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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25976 | 25976 | 190714 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 375 Texas St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 5ft | 6013800.48111 | 2105372.99908 | 37.761729387017496 | -122.39538124017099 | (37.7617293870175, -122.395381240171) | |||
33217 | 33217 | 247662 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 108 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6001959.68947 | 2108344.83823 | 37.769223654362605 | -122.436546435187 | (37.7692236543626, -122.436546435187) | |||
39045 | 39045 | 190719 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 642 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6014091.4532699995 | 2104130.33792 | 37.75833348851889 | -122.39428786959 | (37.7583334885189, -122.39428786959) | |||
45365 | 45365 | 201527 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 740 Earl St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 5ft | 6020341.20189 | 2093704.82943 | 37.730052512603294 | -122.371951898056 | (37.7300525126033, -122.371951898056) | |||
49682 | 49682 | 190742 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1617 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6015073.9615 | 2096817.26033 | 37.738307875303796 | -122.390378936647 | (37.7383078753038, -122.390378936647) | |||
57800 | 57800 | 190715 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 350 Texas St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6013737.51284 | 2105460.97147 | 37.7619674375704 | -122.395605187539 | (37.7619674375704, -122.395605187539) | |||
61921 | 61921 | 228526 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 405 Florida St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009242.70378 | 2106296.2843400002 | 37.7640099687976 | -122.41121004561701 | (37.7640099687976, -122.411210045617) | |||
63247 | 63247 | 190720 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 315 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6014070.97859 | 2105596.2230599998 | 37.762357352140796 | -122.394461321843 | (37.7623573521408, -122.394461321843) | |||
63954 | 63954 | 228524 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 29 Pearl St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005636.60822 | 2108865.67188 | 37.7708619961085 | -122.42386519303999 | (37.7708619961085, -122.42386519304) | |||
71295 | 71295 | 228531 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1744 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6009451.253190001 | 2106552.40785 | 37.7647249190387 | -122.41050681893199 | (37.7647249190387, -122.410506818932) | |||
72428 | 72428 | 190718 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 446 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013483.0407 | 2105010.44498 | 37.7607162323997 | -122.39645373295299 | (37.7607162323997, -122.396453732953) | |||
133554 | 133554 | 190713 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 529 Texas St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013844.9587900005 | 2104593.96331 | 37.759592798384105 | -122.395172837551 | (37.7595927983841, -122.395172837551) | |||
152926 | 152926 | 190743 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 39 Latona St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 6ft | 6014419.07803 | 2094437.81167 | 37.731738047151296 | -122.392476830144 | (37.7317380471513, -122.392476830144) | |||
156159 | 156159 | 190710 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 715 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012743.458769999 | 2104190.05175 | 37.7584224278606 | -122.39895404970699 | (37.7584224278606, -122.398954049707) | |||
156839 | 156839 | 190711 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 299 Texas St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 3ft | 6013779.84023 | 2105755.3163 | 37.7627779983326 | -122.39547941466299 | (37.7627779983326, -122.395479414663) | |||
159724 | 159724 | 190709 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 715 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012742.49696 | 2104176.10053 | 37.7583840672751 | -122.398956396912 | (37.7583840672751, -122.398956396912) | |||
160847 | 160847 | 129100 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004473.20652 | 2110925.86056 | 37.7764530246232 | -122.42803626308701 | (37.7764530246232, -122.428036263087) | |||
161405 | 161405 | 190708 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2033 22nd St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011986.6004 | 2103715.0173 | 37.7570758846471 | -122.40153823182399 | (37.7570758846471, -122.401538231824) | |||
163454 | 163454 | 129101 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 6ft | 6004471.22614 | 2110943.39026 | 37.7765010448349 | -122.428044363274 | (37.7765010448349, -122.428044363274) | |||
163722 | 163722 | 190741 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1786 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014282.6032300005 | 2095390.34812 | 37.7343459381091 | -122.39301527674601 | (37.7343459381091, -122.393015276746) | |||
173875 | 173875 | 228528 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1718 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6009443.5955 | 2106700.35684 | 37.7651307237316 | -122.410543753197 | (37.7651307237316, -122.410543753197) | |||
174234 | 174234 | 228525 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 405 Florida St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009242.66431 | 2106282.23281 | 37.763971384304206 | -122.411209189472 | (37.7639713843042, -122.411209189472) | |||
174788 | 174788 | 190745 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1617 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6015075.48119 | 2096817.4615200001 | 37.7383085120296 | -122.39037369631501 | (37.7383085120296, -122.390373696315) | |||
176056 | 176056 | 228529 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1718 Bryant St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6009444.29412 | 2106686.02886 | 37.7650914215521 | -122.41054032498 | (37.7650914215521, -122.41054032498) | |||
179213 | 179213 | 228527 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 405 Florida St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009241.97976 | 2106321.44557 | 37.7640790151609 | -122.4112143273 | (37.7640790151609, -122.4112143273) | |||
181284 | 181284 | 228530 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1736 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 6ft | 6009448.1788099995 | 2106596.433 | 37.7648456296528 | -122.410520561485 | (37.7648456296528, -122.410520561485) | |||
183146 | 183146 | 129102 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6004465.70248 | 2110959.4385 | 37.7765447968535 | -122.428064615105 | (37.7765447968535, -122.428064615105) |
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");