trees
2,180 rows where qSpecies_id = 57 sorted by qCaretaker_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
110727 | 18030 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2987 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000614.9455864 | 2114797.0276148 | 37.7868632177605 | -122.441660924747 | (37.7868632177605, -122.441660924747) | 13 | 6 | 1 | 29490 | 27 | |||
113499 | 10163 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1013 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2x2 | 6005764.7450429 | 2102960.7456767 | 37.7546556947331 | -122.423002202394 | (37.7546556947331, -122.423002202394) | 2 | 4 | 5 | 28859 | 19 | |||
116328 | 7212 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1225X McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003292.04755 | 2111699.25846 | 37.7785096871687 | -122.432177469136 | (37.7785096871687, -122.432177469136) | 15 | 9 | 11 | 29492 | 41 | |||
116377 | 23386 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006045.46684 | 2115549.55751 | 37.7892373884463 | -122.422926056205 | (37.7892373884463, -122.422926056205) | 13 | 9 | 1 | 28858 | 41 | |||
116611 | 27486 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2113 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.423437499889 | (37.7949042735724, -122.423437499889) | 13 | 9 | 1 | 28858 | 27 | |||
118234 | 19325 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 212 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X4 | 5993418.38204 | 2089852.67557 | 37.717959779598 | -122.464747082736 | (37.717959779598, -122.464747082736) | 9 | 8 | 6 | 64 | 24 | |||
119085 | 14757 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 955X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004579.18989 | 2111878.0493 | 37.7790734963365 | -122.427737496151 | (37.7790734963365, -122.427737496151) | 7 | 9 | 11 | 29490 | 41 | |||
119189 | 12183 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016331.0601118 | 2095306.4617143 | 37.7342291794135 | -122.385927185653 | (37.7342291794135, -122.385927185653) | 10 | 3 | 8 | 58 | 1 | |||
119266 | 12172 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1419X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
119271 | 10004 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 150 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6005403.33839 | 2108127.1988 | 37.7688211546939 | -122.424619539876 | (37.7688211546939, -122.424619539876) | 8 | 4 | 5 | 28853 | 19 | |||
119471 | 12118 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1325X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016848.2078526 | 2094661.9057693 | 37.7324879628386 | -122.38409435335 | (37.7324879628386, -122.38409435335) | 10 | 3 | 8 | 58 | 1 | |||
120021 | 17747 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005995.83513 | 2115543.3505 | 37.7892175449029 | -122.423097334789 | (37.7892175449029, -122.423097334789) | 13 | 9 | 1 | 28858 | 41 | |||
122217 | 10072 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 573 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005609.84736 | 2105668.09746 | 37.7620807071743 | -122.423730368485 | (37.7620807071743, -122.423730368485) | 8 | 4 | 5 | 28859 | 19 | |||
122656 | 12299 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 881 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004832.93645 | 2111868.25149 | 37.7790609444122 | -122.426858985423 | (37.7790609444122, -122.426858985423) | 7 | 9 | 11 | 28852 | 41 | |||
124284 | 26194 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 573 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | Permit Number 772904 | 6002390.549968 | 2104882.2284699 | 37.7597406467411 | -122.434808462305 | (37.7597406467411, -122.434808462305) | 2 | 4 | 5 | 28862 | 3 | ||
125416 | 8121 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 850X Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6003699.00422 | 2111459.33104 | 37.7778739709463 | -122.430752525918 | (37.7778739709463, -122.430752525918) | 15 | 9 | 11 | 29492 | 41 | |||
125806 | 6715 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1200X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
127544 | 191437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300x De Haro St | 31 | Median : Yard | Tree | DPW 1 | 15 | 6012282.34359 | 2102012.29375 | 37.7524170754114 | -122.400395836501 | (37.7524170754114, -122.400395836501) | 10 | 3 | 8 | 28856 | 29 | ||||
127774 | 6762 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1275 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2009 12:00:00 AM | 3 | 3x3 | 6017299.98506 | 2096895.81009 | 37.7386467866108 | -122.38268782839 | (37.7386467866108, -122.38268782839) | 10 | 3 | 8 | 58 | 1 | ||
129071 | 10129 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 892 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6005646.9391641 | 2103763.6492254 | 37.7568536327232 | -122.42346668442 | (37.7568536327232, -122.42346668442) | 2 | 4 | 5 | 28859 | 19 | |||
129797 | 12186 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1455 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016291.5956 | 2095467.9407 | 37.7346703842439 | -122.38607488138 | (37.7346703842439, -122.38607488138) | 10 | 3 | 8 | 58 | 1 | |||
130137 | 17345 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 175X Otis St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | |||
131365 | 5507 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 800 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2x2 | 6004984.13536 | 2103653.10654 | 37.756512676133 | -122.42575103989 | (37.756512676133, -122.42575103989) | 2 | 4 | 5 | 28862 | 22 | |||
131366 | 10202 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1243 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005829.09689 | 2101725.42508 | 37.7512674207747 | -122.422691874526 | (37.7512674207747, -122.422691874526) | 2 | 4 | 5 | 28859 | 19 | |||
132435 | 109819 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 909X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.7793315126419 | -122.426930961581 | (37.7793315126419, -122.426930961581) | 7 | 9 | 11 | 29490 | 41 | ||||
135876 | 17142 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 3 | 3X3 | 6017965.0245 | 2093314.70496 | 37.7288504949441 | -122.380139626367 | (37.7288504949441, -122.380139626367) | 10 | 3 | 8 | 58 | 1 | ||
137415 | 12310 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 949 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004809.18722 | 2111991.67629 | 37.7793984956931 | -122.426949936516 | (37.7793984956931, -122.426949936516) | 7 | 9 | 11 | 29490 | 41 | ||
139391 | 12298 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 869 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004833.39802 | 2111828.5317 | 37.778951909736 | -122.426854559148 | (37.778951909736, -122.426854559148) | 7 | 9 | 11 | 28852 | 41 | |||
141494 | 13031 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 462 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2015 12:00:00 AM | 10 | 3X3 | 6010124.59861 | 2120694.43773 | 37.803593298513 | -122.409175884375 | (37.803593298513, -122.409175884375) | 3 | 1 | 10 | 308 | 23 | ||
141509 | 27487 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2113 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.423437499889 | (37.7949042735724, -122.423437499889) | 13 | 9 | 1 | 28858 | 27 | |||
142101 | 25294 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 150 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000635.34988 | 2091747.89359 | 37.7235770614816 | -122.439937060329 | (37.7235770614816, -122.439937060329) | 9 | 7 | 6 | 28861 | 25 | |||
143348 | 191501 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299x Cashmere St | 2 | Median : Yard | Tree | DPW 1 | 27 | 6016915.88272 | 2095866.14342 | 37.7357983009387 | -122.383944206463 | (37.7357983009387, -122.383944206463) | 10 | 3 | 8 | 58 | 1 | ||||
143660 | 12324 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1005 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004768.4493 | 2112339.49 | 37.7803512028232 | -122.427115646852 | (37.7803512028232, -122.427115646852) | 7 | 9 | 11 | 29490 | 41 | |||
144615 | 17135 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2033 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5997261.7134 | 2109120.9259 | 37.7710865056541 | -122.452852425167 | (37.7710865056541, -122.452852425167) | 15 | 5 | 11 | 29492 | 9 | |||
147150 | 11437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100X Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005576.77796 | 2117294.00706 | 37.7940007519905 | -122.424671810255 | (37.7940007519905, -122.424671810255) | 13 | 9 | 1 | 28858 | 27 | |||
147977 | 14799 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1135 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003745.74789 | 2111758.98852 | 37.7786994042914 | -122.430612211228 | (37.7786994042914, -122.430612211228) | 15 | 9 | 11 | 29492 | 41 | |||
148456 | 7966 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1901 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005614.52229 | 2116667.02972 | 37.7922813615542 | -122.424496592638 | (37.7922813615542, -122.424496592638) | 13 | 9 | 1 | 28858 | 27 | |||
148764 | 12284 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 803X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | 7 | 9 | 11 | 28852 | 41 | |||
150509 | 7960 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1800 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005701.62625 | 2116374.60015 | 37.7914833418188 | -122.42417440425 | (37.7914833418188, -122.42417440425) | 13 | 9 | 1 | 28858 | 27 | |||
151018 | 12177 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1409X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
155782 | 12166 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1439X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
155800 | 12179 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1405X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016402.1103 | 2095116.3031 | 37.733710973633 | -122.385668291381 | (37.733710973633, -122.385668291381) | 10 | 3 | 8 | 58 | 1 | |||
155921 | 247023 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550x Valley St | 1 | Median : Yard | Tree | DPW 1 | 7 | 6002381.07182 | 2099185.81683 | 37.7440991162756 | -122.434433957386 | (37.7440991162756, -122.434433957386) | 2 | 7 | 5 | 63 | 22 | ||||
157235 | 2694 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2111 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003424.2987912 | 2114891.8357248 | 37.787283200782 | -122.431947991092 | (37.787283200782, -122.431947991092) | 13 | 9 | 11 | 29490 | 27 | |||
157319 | 12319 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/1989 12:00:00 AM | 18 | 6004795.7539 | 2112145.0577 | 37.7798188836778 | -122.427007335387 | (37.7798188836778, -122.427007335387) | 7 | 9 | 11 | 29490 | 41 | |||
159052 | 12326 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1025 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 4X4 | 6004464 | 2112418 | 37.7805495508812 | -122.428174475606 | (37.7805495508812, -122.428174475606) | 7 | 9 | 11 | 29490 | 41 | |||
159307 | 15312 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1665 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/27/2001 12:00:00 AM | 4 | 3X3 | 6006906.5597 | 2108955.7422 | 37.771180919322 | -122.419478782903 | (37.771180919322, -122.419478782903) | 8 | 2 | 9 | 28853 | 19 | ||
159405 | 1691 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 23 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017695.7876646 | 2093605.1145142 | 37.7296330451049 | -122.381090589205 | (37.7296330451049, -122.381090589205) | 10 | 3 | 8 | 58 | 1 | |||
159469 | 14756 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 955X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004579.18989 | 2111878.0493 | 37.7790734963365 | -122.427737496151 | (37.7790734963365, -122.427737496151) | 7 | 9 | 11 | 29490 | 41 | |||
159730 | 11438 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100X FRANKLIN ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005630 | 2117242 | 37.7938609593863 | -122.424483955414 | (37.7938609593863, -122.424483955414) | 13 | 9 | 1 | 28858 | 27 | |||
160135 | 191494 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 4ft | 6016613.84098 | 2094824.19976 | 37.7329206295756 | -122.384915925743 | (37.7329206295756, -122.384915925743) | 10 | 3 | 8 | 58 | 1 | |||
160331 | 12321 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1001 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004765.45239 | 2112324.55184 | 37.7803100168497 | -122.427124950246 | (37.7803100168497, -122.427124950246) | 7 | 9 | 11 | 29490 | 41 | |||
161788 | 12180 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1403X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | |||
162330 | 12308 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 949 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004792.64443 | 2112089.73098 | 37.7796667943102 | -122.427014150745 | (37.7796667943102, -122.427014150745) | 7 | 9 | 11 | 29490 | 41 | ||
163286 | 1687 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 15 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017775.00772 | 2093610.25153 | 37.729651522897 | -122.380817071263 | (37.729651522897, -122.380817071263) | 10 | 3 | 8 | 58 | 1 | ||
163691 | 25310 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 197 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000354.04016 | 2091646.91959 | 37.7232837922084 | -122.440902255631 | (37.7232837922084, -122.440902255631) | 9 | 7 | 6 | 28861 | 25 | |||
163827 | 12185 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016337.4341 | 2095323.5181 | 37.7342763655711 | -122.385906337047 | (37.7342763655711, -122.385906337047) | 10 | 3 | 8 | 58 | 1 | |||
165665 | 16954 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 660 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003830.0479 | 2110098.0565 | 37.7741436701635 | -122.430202060124 | (37.7741436701635, -122.430202060124) | 7 | 9 | 11 | 29492 | 10 | |||
166982 | 12187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1455 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016297.2469 | 2095451.6147 | 37.7346258690942 | -122.386054205025 | (37.7346258690942, -122.386054205025) | 10 | 3 | 8 | 58 | 1 | |||
168520 | 25705 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 564 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X2 | 6012100.37031 | 2110300.97089 | 37.7751657827012 | -122.401607649574 | (37.7751657827012, -122.401607649574) | 14 | 2 | 9 | 28853 | 34 | |||
169245 | 20209 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1349 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002745.5181122 | 2112859.7826276 | 37.7816651934241 | -122.434151104411 | (37.7816651934241, -122.434151104411) | 15 | 9 | 11 | 29490 | 41 | |||
170995 | 10162 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1013 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6005758.27618 | 2103002.23491 | 37.7547692495131 | -122.423027522221 | (37.7547692495131, -122.423027522221) | 2 | 4 | 5 | 28859 | 19 | |||
172313 | 12294 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 841X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004846.05575 | 2111737.27176 | 37.7787020480516 | -122.426804270071 | (37.7787020480516, -122.426804270071) | 7 | 9 | 11 | 28852 | 41 | |||
172480 | 12300 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 885 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004826.184 | 2111880.54348 | 37.7790943133977 | -122.426883220553 | (37.7790943133977, -122.426883220553) | 7 | 9 | 11 | 28852 | 41 | |||
172888 | 12327 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1025 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004464 | 2112418 | 37.7805495508812 | -122.428174475606 | (37.7805495508812, -122.428174475606) | 7 | 9 | 11 | 29490 | 41 | |||
173087 | 23385 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006030.41853 | 2115547.69719 | 37.7892314313446 | -122.422977989336 | (37.7892314313446, -122.422977989336) | 13 | 9 | 1 | 28858 | 41 | |||
174459 | 4606 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 300 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010770.74502 | 2118660.66826 | 37.7980452429337 | -122.40679643371 | (37.7980452429337, -122.40679643371) | 3 | 1 | 10 | 308 | 23 | |||
174559 | 18823 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1870 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005861.74139 | 2116275.81208 | 37.7912211336846 | -122.423613381076 | (37.7912211336846, -122.423613381076) | 13 | 9 | 1 | 28858 | 27 | |||
177041 | 10187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1135 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005790.8424 | 2102360.27695 | 37.7530084192058 | -122.422869277503 | (37.7530084192058, -122.422869277503) | 2 | 4 | 5 | 28859 | 19 | |||
177169 | 7210 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1225X McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003292.04755 | 2111699.25846 | 37.7785096871687 | -122.432177469136 | (37.7785096871687, -122.432177469136) | 15 | 9 | 11 | 29492 | 41 | |||
177259 | 14765 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 987 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6004437.97734 | 2111858.52426 | 37.7790118963921 | -122.428224615869 | (37.7790118963921, -122.428224615869) | 7 | 9 | 11 | 29490 | 41 | |||
177429 | 1702 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 47 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017785.2431167 | 2093593.9655411 | 37.7296073696477 | -122.380780554369 | (37.7296073696477, -122.380780554369) | 10 | 3 | 8 | 58 | 1 | |||
177579 | 20203 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1315 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002746.65897 | 2112743.01466 | 37.781344642713 | -122.434138807658 | (37.781344642713, -122.434138807658) | 15 | 5 | 11 | 29490 | 41 | |||
178079 | 25299 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6000418.66631 | 2091706.69164 | 37.7234515931109 | -122.44068314123 | (37.7234515931109, -122.44068314123) | 9 | 7 | 6 | 28861 | 25 | |||
179786 | 6751 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1215 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 7 | 6017537.38126 | 2096718.538 | 37.7381731451641 | -122.381854690145 | (37.7381731451641, -122.381854690145) | 10 | 3 | 8 | 58 | 1 | |||
181938 | 17711 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1214 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6002331.3974 | 2112685.404 | 37.7811628814816 | -122.435571285126 | (37.7811628814816, -122.435571285126) | 15 | 5 | 11 | 29490 | 41 | |||
182293 | 17714 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1230 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6002319.96855 | 2112800.43345 | 37.7814780741875 | -122.435619055061 | (37.7814780741875, -122.435619055061) | 15 | 5 | 11 | 29490 | 41 | |||
182953 | 17111 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1837 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5998183.72781 | 2109230.99806 | 37.7714415276809 | -122.449671093805 | (37.7714415276809, -122.449671093805) | 15 | 5 | 11 | 29492 | 9 | |||
183264 | 12175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1413X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016419.0642 | 2095079.8835 | 37.7336119107928 | -122.385607138859 | (37.7336119107928, -122.385607138859) | 10 | 3 | 8 | 58 | 1 | |||
184036 | 12181 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1401X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016385.1563 | 2095160.2578 | 37.7338307263114 | -122.385729969415 | (37.7338307263114, -122.385729969415) | 10 | 3 | 8 | 58 | 1 | |||
187519 | 10058 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 451 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x5 | 6005573.31758 | 2106314.3851 | 37.763853198087 | -122.4239026696 | (37.763853198087, -122.4239026696) | 8 | 4 | 5 | 28859 | 19 | |||
189896 | 17040 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1200X Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001235.1914802 | 2109729.1714048 | 37.7729834911046 | -122.439151661694 | (37.7729834911046, -122.439151661694) | 15 | 5 | 11 | 29492 | 10 | |||
190071 | 25303 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 286 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x9 | 5999775.2112 | 2091625.73202 | 37.7231926324273 | -122.4429016302 | (37.7231926324273, -122.4429016302) | 9 | 7 | 6 | 28861 | 25 | |||
190969 | 12205 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
192501 | 14791 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1077 McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 12 | 3X3 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.429603641013 | (37.7788514015092, -122.429603641013) | 7 | 9 | 11 | 29490 | 41 | ||
193145 | 5074 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 5593 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1992 12:00:00 AM | 3 | 6001579.88731 | 2097086.51396 | 37.73828941133 | -122.437054001757 | (37.73828941133, -122.437054001757) | 2 | 7 | 5 | 63 | 7 | |||
193189 | 15426 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6006897.56767 | 2106023.27679 | 37.7631285540423 | -122.419301827609 | (37.7631285540423, -122.419301827609) | 8 | 4 | 7 | 28859 | 19 | |||
193426 | 10214 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1335 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X3 | 6005859.10485 | 2101158.22325 | 37.7497117078336 | -122.422547803155 | (37.7497117078336, -122.422547803155) | 2 | 4 | 5 | 28859 | 19 | |||
193717 | 17143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/1999 12:00:00 AM | 3 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
193809 | 109820 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 909X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.7793315126419 | -122.426930961581 | (37.7793315126419, -122.426930961581) | 7 | 9 | 11 | 29490 | 41 | ||||
125 | 92934 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 339 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5992211 | 2096907 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) | 1 | 8 | 4 | 59 | 40 | ||||
250 | 248390 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 34 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998825.2199 | 2108039.7272 | 37.7682072798204 | -122.447366392326 | (37.7682072798204, -122.447366392326) | 15 | 5 | 11 | 29492 | 9 | |||
475 | 102627 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2039 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001422 | 2115424 | 37.7886306717674 | -122.438913657053 | (37.7886306717674, -122.438913657053) | 13 | 6 | 1 | 29490 | 27 | |||
573 | 227463 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 238 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5999836.92244 | 2105557.8617 | 37.7614504560077 | -122.443688706966 | (37.7614504560077, -122.443688706966) | 15 | 5 | 5 | 28862 | 3 | |||
918 | 62597 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 7 | Permit Number 22903 | 5984441.0146 | 2110622.99108 | 37.7744677278845 | -122.497309882833 | (37.7744677278845, -122.497309882833) | 11 | 6 | 2 | 55 | 26 | |
1173 | 227375 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006792.16678 | 2101508.46009 | 37.7507259731465 | -122.419346074576 | (37.7507259731465, -122.419346074576) | 2 | 4 | 7 | 28859 | 19 | |||
1250 | 227382 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3110 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008243.43201 | 2102726.48966 | 37.7541520375997 | -122.414413633986 | (37.7541520375997, -122.414413633986) | 2 | 4 | 7 | 28859 | 19 | |||
1280 | 191487 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 288 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010205.79697 | 2110974.44372 | 37.7769090816273 | -122.408208942312 | (37.7769090816273, -122.408208942312) | 8 | 2 | 9 | 28853 | 34 | |||
1456 | 207879 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1677 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5992449.40881 | 2104058.56598 | 37.7569096647699 | -122.469129702993 | (37.7569096647699, -122.469129702993) | 1 | 8 | 4 | 56 | 12 | |||
1632 | 227241 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 957 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005737.27172 | 2103394.53822 | 37.7558452379797 | -122.423128044836 | (37.7558452379797, -122.423128044836) | 2 | 4 | 5 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );