Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, DBH
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25729 | 25729 | 233231 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 4 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010116.17645 | 2099679.88413 | 37.7458917573937 | -122.407722389299 | (37.7458917573937, -122.407722389299) | |||
31996 | 31996 | 237002 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 11 | : Yard 23 | Tree 1 | Private 1 | 12 | Width 3ft | 6010115.457330001 | 2099644.6115099997 | 37.745794866235 | -122.40772238927 | (37.745794866235, -122.40772238927) | |||
32348 | 32348 | 233229 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 2 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010110.29265 | 2099690.9553400003 | 37.745921827136996 | -122.407743515268 | (37.745921827137, -122.407743515268) | |||
37555 | 37555 | 237003 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 14 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010106.165469999 | 2099668.32603 | 37.7458594609566 | -122.40775619120001 | (37.7458594609566, -122.4077561912) | |||
37605 | 37605 | 237004 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 15 | : Yard 23 | Tree 1 | Private 1 | 8 | Width 3ft | 6010095.49496 | 2099684.36191 | 37.7459028946219 | -122.40779421904101 | (37.7459028946219, -122.407794219041) | |||
40295 | 40295 | 233234 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 7 | : Yard 23 | Tree 1 | Private 1 | 4 | Width 3ft | 6010136.86006 | 2099655.53222 | 37.7458260502241 | -122.40764915121099 | (37.7458260502241, -122.407649151211) | |||
70403 | 70403 | 233232 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 5 | : Yard 23 | Tree 1 | Private 1 | 10 | Width 3ft | 6010129.8045 | 2099669.06085 | 37.7458628019252 | -122.407674502171 | (37.7458628019252, -122.407674502171) | |||
73122 | 73122 | 225894 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 199 Franconia St | 17 | : Yard 23 | Tree 1 | Private 1 | 7 | Width 3ft | 6010105.1921 | 2099680.51389 | 37.7458928716644 | -122.407760416232 | (37.7458928716644, -122.407760416232) | |||
76157 | 76157 | 233604 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 10 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6010160.0797 | 2099615.7154599996 | 37.7457180218657 | -122.40756605383301 | (37.7457180218657, -122.407566053833) | |||
134356 | 134356 | 233602 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 8 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010143.5997 | 2099646.47131 | 37.7458015482156 | -122.40762520763701 | (37.7458015482156, -122.407625207637) | |||
151779 | 151779 | 241988 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 199 Franconia St | 18 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010085.85388 | 2099710.92257 | 37.745975284649 | -122.40782942930299 | (37.745975284649, -122.407829429303) | |||
152462 | 152462 | 233605 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 12 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010122.88511 | 2099649.32748 | 37.745808231063705 | -122.407697037414 | (37.7458082310637, -122.407697037414) | |||
154537 | 154537 | 233603 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 9 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010152.72418 | 2099634.5230799997 | 37.7457692517475 | -122.40759281407101 | (37.7457692517475, -122.407592814071) | |||
154821 | 154821 | 237005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 16 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010090.49979 | 2099699.0653 | 37.7459429872721 | -122.40781252834101 | (37.7459429872721, -122.407812528341) | |||
156957 | 156957 | 233233 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 6 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010125.251569999 | 2099665.5030400003 | 37.745852778088 | -122.407689994823 | (37.745852778088, -122.407689994823) | |||
161704 | 161704 | 225066 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 199 Franconia St | 13 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010116.17854 | 2099660.00965 | 37.745837186534295 | -122.407720980957 | (37.7458371865343, -122.407720980957) | |||
169576 | 169576 | 233228 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 1 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010113.61596 | 2099694.13241 | 37.7459307367175 | -122.407732247644 | (37.7459307367175, -122.407732247644) | |||
173331 | 173331 | 233230 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 3 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010120.38838 | 2099686.6934 | 37.745910689944104 | -122.407708305 | (37.7459106899441, -122.407708305) |
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");