Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4219 | 4219 | 244047 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 400 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997955.5586 | 2109119.1735 | 37.771121429752895 | -122.450452276113 | (37.7711214297529, -122.450452276113) | |||
29911 | 29911 | 245456 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007901.4813 | 2106811.8898 | 37.765350391343496 | -122.415885464882 | (37.7653503913435, -122.415885464882) | |||
31018 | 31018 | 244415 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 630 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003443.0612 | 2109684.1199 | 37.7729851758016 | -122.43151115772899 | (37.7729851758016, -122.431511157729) | |||
35324 | 35324 | 245162 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1308 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000247.8581 | 2109240.6853 | 37.7715860006418 | -122.44253187989901 | (37.7715860006418, -122.442531879899) | |||
38420 | 38420 | 244549 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1500 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999267.0062 | 2109103.195 | 37.7711525285338 | -122.44591479977801 | (37.7711525285338, -122.445914799778) | |||
39534 | 39534 | 244202 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003923.0756 | 2109749.7244 | 37.7731925042221 | -122.429855409854 | (37.7731925042221, -122.429855409854) | |||
64117 | 64117 | 245459 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007813.0325 | 2106805.2324 | 37.765327138725 | -122.416190917981 | (37.765327138725, -122.416190917981) | |||
65348 | 65348 | 142345 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1736 HAYES ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5999542.2107 | 2110186.9275 | 37.7741438933316 | -122.445040782661 | (37.7741438933316, -122.445040782661) | |||
66905 | 66905 | 244210 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003934.6479 | 2109752.6175 | 37.7732011032912 | -122.429815586143 | (37.7732011032912, -122.429815586143) | |||
75594 | 75594 | 142692 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2410 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008497.9336 | 2121083.9891 | 37.8045716448485 | -122.414832641069 | (37.8045716448485, -122.414832641069) | |||
123727 | 123727 | 142340 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 520 Central Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999729.6682 | 2110321.6281 | 37.774524444251206 | -122.444402018718 | (37.7745244442512, -122.444402018718) | |||
130809 | 130809 | 142235 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 689 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004665.6696 | 2110849.8982 | 37.7762553374912 | -122.42736506585 | (37.7762553374912, -122.42736506585) | |||
131204 | 131204 | 140348 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1314 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004545.774 | 2113311.1445 | 37.7830065306397 | -122.427955242977 | (37.7830065306397, -122.427955242977) | |||
133659 | 133659 | 142688 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 552 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6008641.5861 | 2121102.2307 | 37.8046298022358 | -122.414336807992 | (37.8046298022358, -122.414336807992) | |||
136428 | 136428 | 245455 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6007994.6854 | 2106818.5473 | 37.7653739107422 | -122.41556356407 | (37.7653739107422, -122.41556356407) | |||
136892 | 136892 | 142690 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 560 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008610.8035 | 2121097.1003 | 37.804613986225704 | -122.41444297124599 | (37.8046139862257, -122.414442971246) | |||
147884 | 147884 | 142233 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004546.0223 | 2110772.1475 | 37.7760350855974 | -122.427773417679 | (37.7760350855974, -122.427773417679) | |||
158116 | 158116 | 142702 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 520 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008814.8812 | 2121126.1728 | 37.8047052743397 | -122.413738796098 | (37.8047052743397, -122.413738796098) | |||
158147 | 158147 | 247455 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003122.801 | 2110193.1484 | 37.7743646855214 | -122.432655343876 | (37.7743646855214, -122.432655343876) | |||
158310 | 158310 | 142337 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 500 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999743.369 | 2110239.8651 | 37.774300725553005 | -122.44434874808998 | (37.774300725553, -122.44434874809) | |||
167039 | 167039 | 140156 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2155 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997581.2766 | 2109865.28 | 37.7731486172497 | -122.451800756951 | (37.7731486172497, -122.451800756951) | |||
167999 | 167999 | 142232 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004552.0651 | 2110734.2793 | 37.775931450627205 | -122.427749815271 | (37.7759314506272, -122.427749815271) | |||
170862 | 170862 | 142691 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2410 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008523.0158 | 2121086.8394 | 37.804580880348794 | -122.414746043331 | (37.8045808803488, -122.414746043331) | |||
173505 | 173505 | 142723 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008387.4711 | 2121064.7168 | 37.8045125206489 | -122.415213542996 | (37.8045125206489, -122.415213542996) | |||
175010 | 175010 | 244548 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1500 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999285.3779 | 2109104.904 | 37.7711582700312 | -122.44585137455499 | (37.7711582700312, -122.445851374555) | |||
176344 | 176344 | 142206 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1693 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999789.089 | 2110173.0386 | 37.7741198453954 | -122.444185791724 | (37.7741198453954, -122.444185791724) | |||
178516 | 178516 | 142724 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008368.8817 | 2121063.6546 | 37.804508559383706 | -122.41527779826299 | (37.8045085593837, -122.415277798263) | |||
181455 | 181455 | 142338 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 510 Central Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5999738.5075 | 2110257.1017 | 37.7743477755014 | -122.444366803816 | (37.7743477755014, -122.444366803816) | |||
184487 | 184487 | 247270 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1520 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999196.9373 | 2109093.7955 | 37.7711227186713 | -122.446156493551 | (37.7711227186713, -122.446156493551) | |||
185659 | 185659 | 245457 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6007865.341 | 2106811.8898 | 37.7653483594859 | -122.41601046611099 | (37.7653483594859, -122.416010466111) | |||
186176 | 186176 | 141447 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 196 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5996894.8261 | 2111600.0306 | 37.7778724506652 | -122.454300593509 | (37.7778724506652, -122.454300593509) | |||
186722 | 186722 | 142687 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 550 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008655.2673 | 2121104.5109 | 37.804636831606494 | -122.414289624157 | (37.8046368316065, -122.414289624157) |
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");