Street_Tree_List

Data source: data.sfgov.org

24 rows where qSiteInfo = 17 and qSpecies = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH

qSiteInfo ✖

  • Side Yard : Yard · 24 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
23489 23489 247849 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 152 Chapman St 1 Side Yard : Yard 17 Tree 1 Private 1     15     6009118.007540001 2098230.0964599997 37.74185503078979 -122.41107154552401 (37.7418550307898, -122.411071545524)
25663 25663 188593 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 20th St 1 Side Yard : Yard 17 Tree 1 Private 1     27     6010961.38996 2104652.9831 37.759594070921004 -122.40514986509899 (37.759594070921, -122.405149865099)
31230 31230 187779 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 230 Middle Point Rd 2 Side Yard : Yard 17 Tree 1 Private 1     5 Width 6ft   6018271.33931 2096490.0449 37.737586251210104 -122.379301134458 (37.7375862512101, -122.379301134458)
44107 44107 188705 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1998 Revere Ave 2 Side Yard : Yard 17 Tree 1 Private 1     3     6013030.362000001 2095929.4873 37.7357566623473 -122.397382506903 (37.7357566623473, -122.397382506903)
49102 49102 248109 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 138 Rutledge St 3 Side Yard : Yard 17 Tree 1 Private 1     24     6010416.26244 2099462.28287 37.7453110660681 -122.406669396477 (37.7453110660681, -122.406669396477)
53119 53119 175069 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 101 Woolsey St 6 Side Yard : Yard 17 Tree 1 Private 1     20     6011573.1556 2092162.2260200002 37.7253313074768 -122.402155892479 (37.7253313074768, -122.402155892479)
56158 56158 247931 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1099 Esmeralda Ave 4 Side Yard : Yard 17 Tree 1 Private 1     6     6010377.81236 2098773.8118 37.7434185228518 -122.406753840137 (37.7434185228518, -122.406753840137)
65626 65626 247850 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 152 Chapman St 2 Side Yard : Yard 17 Tree 1 Private 1     42     6009080.756440001 2098231.91815 37.7418579436943 -122.41120047681801 (37.7418579436943, -122.411200476818)
66596 66596 248070 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 20 Rutledge St 4 Side Yard : Yard 17 Tree 1 Private 1     13     6010599.59932 2099402.0661 37.745155979779504 -122.406031203374 (37.7451559797795, -122.406031203374)
69221 69221 247529 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101 Waller St 10 Side Yard : Yard 17 Tree 1 Private 1     2     6000073.75314 2108487.72588 37.7695086378454 -122.44308003233499 (37.7695086378454, -122.443080032335)
130643 130643 247527 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101 Waller St 8 Side Yard : Yard 17 Tree 1 Private 1     2     6000059.53834 2108484.86365 37.769499968379705 -122.443128995021 (37.7694999683797, -122.443128995021)
132984 132984 175066 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 800 Thornton Ave 1 Side Yard : Yard 17 Tree 1 Private 1     8     6010981.076169999 2094029.55145 37.73042552801979 -122.40433403878599 (37.7304255280198, -122.404334038786)
133560 133560 247858 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 82 Bradford St 1 Side Yard : Yard 17 Tree 1 Private 1     12     6009570.7437 2098077.6511 37.7414618274161 -122.40949536852501 (37.7414618274161, -122.409495368525)
156377 156377 247522 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101 Waller St 3 Side Yard : Yard 17 Tree 1 Private 1     10     6000010.6242 2108472.60358 37.7694635161602 -122.443297305835 (37.7694635161602, -122.443297305835)
159551 159551 247520 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101 Waller St 1 Side Yard : Yard 17 Tree 1 Private 1     14     6000003.99995 2108482.26842 37.7694896756401 -122.443320913055 (37.7694896756401, -122.443320913055)
165964 165964 175067 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 800 Thornton Ave 2 Side Yard : Yard 17 Tree 1 Private 1     26     6010979.40226 2094033.66945 37.730436741644894 -122.404340115499 (37.7304367416449, -122.404340115499)
172072 172072 187778 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 230 Middle Point Rd 1 Side Yard : Yard 17 Tree 1 Private 1     2 Width 6ft   6018276.18855 2096495.79876 37.7376023175876 -122.37928476769899 (37.7376023175876, -122.379284767699)
172088 172088 125288 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 943 Green St 11 Side Yard : Yard 17 Tree 1 Private 1     1     6008674.79926 2118995.08989 37.7988459853112 -122.41407270821101 (37.7988459853112, -122.414072708211)
176347 176347 125277 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1285 Greenwich St 2 Side Yard : Yard 17 Tree 1 Private 1     10     6006721.71386 2119753.35883 37.800818109519206 -122.420884898228 (37.8008181095192, -122.420884898228)
179049 179049 175068 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 101 Woolsey St 5 Side Yard : Yard 17 Tree 1 Private 1     5     6011564.90281 2092154.99462 37.7253109908919 -122.402183913575 (37.7253109908919, -122.402183913575)
181186 181186 175070 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 104 Woolsey St 2 Side Yard : Yard 17 Tree 1 Private 1     14     6011561.993480001 2092186.33195 37.725396874350096 -122.40219617312599 (37.7253968743501, -122.402196173126)
181546 181546 125276 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1285 Greenwich St 1 Side Yard : Yard 17 Tree 1 Private 1     15     6006714.64641 2119759.73621 37.800835221824 -122.420909807645 (37.800835221824, -122.420909807645)
182693 182693 187780 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 230 Middle Point Rd 3 Side Yard : Yard 17 Tree 1 Private 1     4 Width 6ft   6018250.04699 2096453.9006400001 37.7374858320104 -122.379372242948 (37.7374858320104, -122.379372242948)
185208 185208 247934 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1099 Esmeralda Ave 7 Side Yard : Yard 17 Tree 1 Private 1     14     6010311.02519 2098743.98721 37.7433328939103 -122.406982672633 (37.7433328939103, -122.406982672633)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 217.193ms · Data source: data.sfgov.org