Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23806 | 23806 | 232314 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 99 Elsie St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6007320.806890001 | 2098778.15204 | 37.7432589210582 | -122.417324523624 | (37.7432589210582, -122.417324523624) | ||||
| 25040 | 25040 | 210510 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 13 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 6ft | 5997279.39992 | 2098558.56074 | 37.7420859128371 | -122.452029069086 | (37.7420859128371, -122.452029069086) | |||
| 26581 | 26581 | 194044 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1542 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 3ft | 6013293.95823 | 2104770.11303 | 37.760045809374205 | -122.39709083697201 | (37.7600458093742, -122.397090836972) | |||
| 30452 | 30452 | 131764 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1492 Pacific Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6007026.74159 | 2117749.85493 | 37.7953341794929 | -122.419687137974 | (37.7953341794929, -122.419687137974) | |||
| 42437 | 42437 | 131765 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1492 Pacific Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6007015.710940001 | 2117748.69184 | 37.7953303645668 | -122.41972522333599 | (37.7953303645668, -122.419725223336) | |||
| 74548 | 74548 | 210511 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 16 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 5997410.29084 | 2098566.36293 | 37.742114832343 | -122.451577054547 | (37.742114832343, -122.451577054547) | |||
| 75022 | 75022 | 210512 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 18 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 5997479.74459 | 2098569.7593 | 37.7421281351089 | -122.45133715141199 | (37.7421281351089, -122.451337151412) | |||
| 133073 | 133073 | 210508 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 6ft | 5997156.34573 | 2098551.2278 | 37.7420587290339 | -122.452454020343 | (37.7420587290339, -122.452454020343) | |||
| 155691 | 155691 | 138261 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 29 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 0ft | 5999049.3886 | 2113169.4617 | 37.782305023527606 | -122.44696020353999 | (37.7823050235276, -122.44696020354) | |||
| 167044 | 167044 | 177804 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 670 Brunswick St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | 5998746.52485 | 2086721.86687 | 37.709669038459 | -122.446105024329 | (37.709669038459, -122.446105024329) | ||||
| 168632 | 168632 | 177803 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 670 Brunswick St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | 5998734.37003 | 2086718.8653400003 | 37.70966010280571 | -122.44614681761499 | (37.7096601028057, -122.446146817615) | ||||
| 169301 | 169301 | 138761 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 36 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 5999027.0527 | 2113220.9018 | 37.7824449885745 | -122.44704117852 | (37.7824449885745, -122.44704117852) | |||
| 170140 | 170140 | 210506 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 5997067.619580001 | 2098546.7599 | 37.7420413775124 | -122.452760483218 | (37.7420413775124, -122.452760483218) | |||
| 173399 | 173399 | 232313 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 99 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6007317.39057 | 2098776.5375599996 | 37.743254295847 | -122.417336222008 | (37.743254295847, -122.417336222008) | ||||
| 174795 | 174795 | 210507 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 5997086.47327 | 2098548.0515900003 | 37.7420460045079 | -122.452695386699 | (37.7420460045079, -122.452695386699) | |||
| 182272 | 182272 | 131763 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1457 Jones St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 3ft | 6008417.06699 | 2117517.79175 | 37.794775211263705 | -122.414859937834 | (37.7947752112637, -122.414859937834) | |||
| 184351 | 184351 | 210509 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 6ft | 5997270.91609 | 2098557.47378 | 37.7420824423506 | -122.452058324935 | (37.7420824423506, -122.452058324935) | |||
| 187810 | 187810 | 138265 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 33 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 5999027.3911 | 2113166.4159 | 37.7822954037862 | -122.447036085573 | (37.7822954037862, -122.447036085573) | |||
| 188549 | 188549 | 138262 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 30 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 5999046.0043 | 2113182.6602 | 37.7823410698302 | -122.44697286174801 | (37.7823410698302, -122.446972861748) |
JSON shape: default, array, newline-delimited
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");