Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
582 | 582 | 27390 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007140.50399 | 2120032.48345 | 37.8016081117892 | -122.419455519354 | (37.8016081117892, -122.419455519354) | |||
2886 | 2886 | 7974 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1955 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005597.935869999 | 2116784.08675 | 37.7926018340689 | -122.424562312409 | (37.7926018340689, -122.424562312409) | |||
4694 | 4694 | 7986 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005534.41759 | 2117282.00669 | 37.7939654095207 | -122.424817527421 | (37.7939654095207, -122.424817527421) | |||
5334 | 5334 | 17712 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1214 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6002329.348999999 | 2112708.9615 | 37.7812274480895 | -122.435580057373 | (37.7812274480895, -122.435580057373) | |||
6112 | 6112 | 17719 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1250 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6002302.3774 | 2112913.4677 | 37.78178743852221 | -122.43568800125799 | (37.7817874385222, -122.435688001258) | |||
7554 | 7554 | 12324 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1005 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004768.4493 | 2112339.49 | 37.780351202823205 | -122.427115646852 | (37.7803512028232, -122.427115646852) | |||
8115 | 8115 | 12319 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 999 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 18 | 6004795.7539 | 2112145.0577 | 37.7798188836778 | -122.427007335387 | (37.7798188836778, -122.427007335387) | |||
14345 | 14345 | 25704 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 564 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6012091.3603 | 2110309.05533 | 37.7751874779549 | -122.401639385748 | (37.7751874779549, -122.401639385748) | |||
16320 | 16320 | 12187 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1455 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016297.2469 | 2095451.6147 | 37.7346258690942 | -122.386054205025 | (37.7346258690942, -122.386054205025) | |||
16421 | 16421 | 12185 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016337.4341 | 2095323.5181 | 37.734276365571105 | -122.385906337047 | (37.7342763655711, -122.385906337047) | |||
17545 | 17545 | 17038 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001065.34359 | 2109713.09337 | 37.772929678688506 | -122.43973803201 | (37.7729296786885, -122.43973803201) | |||
18911 | 18911 | 12302 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 945X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004623.92182 | 2111884.23425 | 37.7790930089412 | -122.42758319096399 | (37.7790930089412, -122.427583190964) | |||
23288 | 23288 | 15312 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1665 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/27/2001 12:00:00 AM | 4 | 3X3 | 6006906.5597 | 2108955.7422 | 37.771180919322 | -122.419478782903 | (37.771180919322, -122.419478782903) | ||
78058 | 78058 | 20276 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
82904 | 82904 | 12198 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1485 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016165.701365701 | 2095622.0691082 | 37.7350866214264 | -122.38652088789301 | (37.7350866214264, -122.386520887893) | |||
83389 | 83389 | 422 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 685X Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005653.198434 | 2104994.6037312 | 37.7602338989595 | -122.423532549649 | (37.7602338989595, -122.423532549649) | |||
85014 | 85014 | 20210 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1349 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002745.5181122 | 2112859.7826276002 | 37.781665193424104 | -122.43415110441099 | (37.7816651934241, -122.434151104411) | |||
88966 | 88966 | 8120 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 850X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6003699.00422 | 2111459.33104 | 37.777873970946295 | -122.43075252591801 | (37.7778739709463, -122.430752525918) | |||
99786 | 99786 | 10163 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1013 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2x2 | 6005764.7450429 | 2102960.7456767 | 37.7546556947331 | -122.423002202394 | (37.7546556947331, -122.423002202394) | |||
102821 | 102821 | 7209 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
106256 | 106256 | 14757 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 955X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004579.18989 | 2111878.0493 | 37.7790734963365 | -122.42773749615101 | (37.7790734963365, -122.427737496151) | |||
107274 | 107274 | 12183 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016331.060111799 | 2095306.4617143 | 37.7342291794135 | -122.385927185653 | (37.7342291794135, -122.385927185653) | |||
107293 | 107293 | 27486 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2113 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.42343749988899 | (37.7949042735724, -122.423437499889) | |||
112287 | 112287 | 12177 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1409X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
114969 | 114969 | 12284 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 803X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | |||
119439 | 119439 | 12308 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 949 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004792.64443 | 2112089.73098 | 37.7796667943102 | -122.427014150745 | (37.7796667943102, -122.427014150745) | ||
121009 | 121009 | 2694 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003424.2987912 | 2114891.8357248 | 37.787283200782 | -122.431947991092 | (37.787283200782, -122.431947991092) | |||
123069 | 123069 | 1691 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 23 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017695.7876646 | 2093605.1145141998 | 37.7296330451049 | -122.381090589205 | (37.7296330451049, -122.381090589205) | |||
124120 | 124120 | 2170 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2299X FRANKLIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005396.0 | 2117789.0 | 37.7953496659997 | -122.42533256183701 | (37.7953496659997, -122.425332561837) | |||
129338 | 129338 | 12165 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1439X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
138297 | 138297 | 20203 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1315 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002746.658969999 | 2112743.01466 | 37.781344642713 | -122.434138807658 | (37.781344642713, -122.434138807658) | |||
141998 | 141998 | 12327 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1025 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004464.0 | 2112418.0 | 37.780549550881204 | -122.428174475606 | (37.7805495508812, -122.428174475606) | |||
143245 | 143245 | 17111 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1837 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5998183.72781 | 2109230.9980599997 | 37.7714415276809 | -122.44967109380501 | (37.7714415276809, -122.449671093805) | |||
143686 | 143686 | 12294 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 841X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004846.05575 | 2111737.27176 | 37.7787020480516 | -122.42680427007099 | (37.7787020480516, -122.426804270071) | |||
145506 | 145506 | 12205 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
146055 | 146055 | 109820 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 909X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.779331512641896 | -122.42693096158101 | (37.7793315126419, -122.426930961581) | ||||
146083 | 146083 | 17143 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/1999 12:00:00 AM | 3 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.37983116682699 | (37.7286870123052, -122.379831166827) | ||
154902 | 154902 | 191501 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 299x Cashmere St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6016915.88272 | 2095866.14342 | 37.735798300938704 | -122.383944206463 | (37.7357983009387, -122.383944206463) |
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");