Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25093 | 25093 | 241010 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 933 Treat Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 6008616.62656 | 2103120.74551 | 37.7552555327391 | -122.413150907606 | (37.7552555327391, -122.413150907606) | |||
| 27143 | 27143 | 197825 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011965.06287 | 2091392.40975 | 37.7232394169387 | -122.40074704065701 | (37.7232394169387, -122.400747040657) | |||
| 30392 | 30392 | 136582 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 22 Casa Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001615.61714 | 2121552.96535 | 37.8054702188359 | -122.43868311735399 | (37.8054702188359, -122.438683117354) | |||
| 32085 | 32085 | 197864 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012060.1959 | 2091081.01697 | 37.7223897015024 | -122.400396320338 | (37.7223897015024, -122.400396320338) | |||
| 34615 | 34615 | 197842 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012001.83454 | 2091273.05649 | 37.7229137481456 | -122.400611547001 | (37.7229137481456, -122.400611547001) | |||
| 50253 | 50253 | 197890 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 980 Kansas St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 4ft | 6011575.63279 | 2103848.50078 | 37.757419460745 | -122.402968911103 | (37.757419460745, -122.402968911103) | |||
| 56679 | 56679 | 197819 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011944.173880001 | 2091457.7319099999 | 37.72341761312129 | -122.400823837369 | (37.7234176131213, -122.400823837369) | |||
| 57257 | 57257 | 197860 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012046.4319 | 2091124.21465 | 37.722507545966 | -122.400446932379 | (37.722507545966, -122.400446932379) | |||
| 62296 | 62296 | 247547 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 815 Buena Vista Ave West | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6000144.16921 | 2108418.92305 | 37.769323737231495 | -122.44283152537201 | (37.7693237372315, -122.442831525372) | |||
| 74193 | 74193 | 249617 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 2398 Golden Gate Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 5998099.1254900005 | 2111386.37003 | 37.7773547829374 | -122.450119115921 | (37.7773547829374, -122.450119115921) | |||
| 130496 | 130496 | 197827 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011971.4942 | 2091374.0034400001 | 37.7231892356806 | -122.40072351619101 | (37.7231892356806, -122.400723516191) | |||
| 158390 | 158390 | 197867 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012066.20658 | 2091062.20785 | 37.7223383906757 | -122.400374222197 | (37.7223383906757, -122.400374222197) | |||
| 159115 | 159115 | 197895 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 2200 Oakdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6011815.867459999 | 2097932.90691 | 37.7411899344586 | -122.40172228707199 | (37.7411899344586, -122.401722287072) | |||
| 176686 | 176686 | 197835 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011986.88775 | 2091319.6841900002 | 37.7230409446734 | -122.400666489273 | (37.7230409446734, -122.400666489273) | |||
| 188159 | 188159 | 197822 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011948.87446 | 2091441.14937 | 37.723372343042996 | -122.40080642377899 | (37.723372343043, -122.400806423779) |
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");