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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24867 | 24867 | 128872 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1270 Clay St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6008617.8933 | 2116985.80522 | 37.7933257892186 | -122.414127394165 | (37.7933257892186, -122.414127394165) | |||
31199 | 31199 | 176506 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 178 Brookdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6005608.52394 | 2087094.5334400001 | 37.7110817807597 | -122.42241517113001 | (37.7110817807597, -122.42241517113) | |||
43000 | 43000 | 176515 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6006304.71292 | 2087396.6514 | 37.7119505816242 | -122.420030394781 | (37.7119505816242, -122.420030394781) | |||
43767 | 43767 | 176500 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 162 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005731.33862 | 2087429.69303 | 37.712008985404 | -122.422014487205 | (37.712008985404, -122.422014487205) | |||
43922 | 43922 | 176514 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6006291.2518 | 2087400.97553 | 37.7119616963423 | -122.420077226985 | (37.7119616963423, -122.420077226985) | |||
56399 | 56399 | 219016 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 23 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998493.11217 | 2097521.42795 | 37.7393076426268 | -122.447757806504 | (37.7393076426268, -122.447757806504) | |||
58127 | 58127 | 176510 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Brookdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006143.81597 | 2087479.5619400002 | 37.7121691699409 | -122.420592382928 | (37.7121691699409, -122.420592382928) | |||
59507 | 59507 | 176502 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 170 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005669.88649 | 2087297.20509 | 37.7116417355373 | -122.42221747678002 | (37.7116417355373, -122.42221747678) | |||
69064 | 69064 | 176509 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 127 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006088.90588 | 2087444.93251 | 37.7120709900614 | -122.420779711712 | (37.7120709900614, -122.420779711712) | |||
69724 | 69724 | 176518 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1501 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6007403.12553 | 2087360.3651400001 | 37.7119127723386 | -122.416231391376 | (37.7119127723386, -122.416231391376) | |||
72097 | 72097 | 176499 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 162 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6005745.58119 | 2087451.7768599999 | 37.7120704261874 | -122.421966828522 | (37.7120704261874, -122.421966828522) | |||
73386 | 73386 | 176503 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 170 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005661.68615 | 2087270.92863 | 37.711569123398796 | -122.422243953714 | (37.7115691233988, -122.422243953714) | |||
75133 | 75133 | 128874 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1270 Clay St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6008580.96851 | 2116980.96928 | 37.7933104368651 | -122.41425481461799 | (37.7933104368651, -122.414254814618) | |||
130263 | 130263 | 192406 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 718 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6012081.21103 | 2105020.2958 | 37.7606651697825 | -122.401302754214 | (37.7606651697825, -122.401302754214) | ||||
131668 | 131668 | 176513 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006276.40846 | 2087403.9786200002 | 37.7119691058641 | -122.42012874286199 | (37.7119691058641, -122.420128742862) | |||
151401 | 151401 | 176516 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 49 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6006459.4617 | 2087377.28485 | 37.7119061227438 | -122.419494165041 | (37.7119061227438, -122.419494165041) | |||
152426 | 152426 | 176517 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 49 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6006489.3282699995 | 2087380.0454 | 37.7119153848503 | -122.419391133293 | (37.7119153848503, -122.419391133293) | |||
152999 | 152999 | 176497 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Brookdale Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6005989.52225 | 2087517.96508 | 37.7122659199214 | -122.421128393261 | (37.7122659199214, -122.421128393261) | |||
153095 | 153095 | 219000 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1775 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 3ft | 5992776.7043 | 2103406.16926 | 37.7551372592989 | -122.467950350926 | (37.7551372592989, -122.467950350926) | |||
158771 | 158771 | 176498 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 144 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6005795.48549 | 2087494.48765 | 37.7121905153633 | -122.42179737647498 | (37.7121905153633, -122.421797376475) | |||
161897 | 161897 | 176501 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 170 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6005674.86736 | 2087315.91925 | 37.7116934016018 | -122.42220159024599 | (37.7116934016018, -122.422201590246) | |||
164012 | 164012 | 128873 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1270 Clay St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6008597.37413 | 2116983.75832 | 37.7933190163979 | -122.414198247271 | (37.7933190163979, -122.414198247271) | |||
169474 | 169474 | 176504 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 178 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6005618.83947 | 2087124.32667 | 37.711164168567 | -122.422381633625 | (37.711164168567, -122.422381633625) | |||
171695 | 171695 | 176519 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1501 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6007411.664 | 2087356.69589 | 37.7119031774593 | -122.416201620236 | (37.7119031774593, -122.416201620236) | |||
177304 | 177304 | 176507 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 150 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | Width 6ft | 6005719.71054 | 2087314.8851 | 37.7116930913392 | -122.422046526423 | (37.7116930913392, -122.422046526423) | |||
179065 | 179065 | 176512 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006244.01324 | 2087410.04073 | 37.711983925792 | -122.42024114011801 | (37.711983925792, -122.420241140118) | |||
181038 | 181038 | 176508 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 150 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | Width 6ft | 6005731.293880001 | 2087351.0784200002 | 37.71179312382829 | -122.422009060692 | (37.7117931238283, -122.422009060692) | |||
186907 | 186907 | 176505 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 178 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005616.04698 | 2087112.6870400002 | 37.7111320510829 | -122.42239045867599 | (37.7111320510829, -122.422390458676) | |||
187028 | 187028 | 176511 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 127 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6006104.31545 | 2087436.5206900002 | 37.712048761508605 | -122.42072585491199 | (37.7120487615086, -122.420725854912) |
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");