trees
548 rows where qCaretaker_id = 1 and qSpecies_id = 53 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77953 | 4657 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 3x3 | 6009795.85928 | 2119479.51144 | 37.8002389893085 | -122.41022767808 | (37.8002389893085, -122.41022767808) | 3 | 1 | 10 | 308 | 4 | |||
79373 | 29910 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 791x Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6008575.10006 | 2120353.42874 | 37.8025700449008 | -122.414513871045 | (37.8025700449008, -122.414513871045) | 3 | 1 | 10 | 308 | 32 | ||||
83502 | 112109 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
87782 | 21807 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2600X Taylor St | 12 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
88644 | 4629 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6010259.97829 | 2119047.3818 | 37.7990784717377 | -122.408591136664 | (37.7990784717377, -122.408591136664) | 3 | 1 | 10 | 308 | 4 | |||
89782 | 4755 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4X4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | |||
93249 | 9942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601X Green St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | 3 | 1 | 10 | 308 | 4 | |||
94426 | 23139 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 406X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6x3 | 6010454.05392 | 2118948.49862 | 37.798817830036 | -122.407912589535 | (37.798817830036, -122.407912589535) | 3 | 1 | 10 | 308 | 23 | |||
103171 | 4672 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 659 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6009562.16476 | 2119705.53614 | 37.8008464951643 | -122.411052329729 | (37.8008464951643, -122.411052329729) | 3 | 1 | 10 | 308 | 4 | |||
109285 | 11031 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1469 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6007466.43149 | 2117407.25122 | 37.7944182331434 | -122.418141434433 | (37.7944182331434, -122.418141434433) | 5 | 1 | 10 | 28858 | 32 | |||
113684 | 13012 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 400 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 6010380.84909 | 2120676.56867 | 37.8035585868989 | -122.408287852113 | (37.8035585868989, -122.408287852113) | 3 | 1 | 10 | 308 | 23 | |||
119311 | 4652 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6009795.85928 | 2119479.51144 | 37.8002389893085 | -122.41022767808 | (37.8002389893085, -122.41022767808) | 3 | 1 | 10 | 308 | 4 | |||
119461 | 11088 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
122874 | 94039 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 722 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6009288 | 2119899 | 37.801362320674 | -122.412014738208 | (37.801362320674, -122.412014738208) | 3 | 1 | 10 | 308 | 4 | |||
124571 | 98660 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6008942.64461 | 2120384.58796 | 37.8026762417443 | -122.41324418324 | (37.8026762417443, -122.41324418324) | 3 | 1 | 10 | 308 | 23 | |||
126231 | 112107 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
127504 | 4686 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 722 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6009336.3456 | 2120034.69791 | 37.8017376257964 | -122.411857034683 | (37.8017376257964, -122.411857034683) | 3 | 1 | 10 | 308 | 23 | |||
132857 | 11053 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1603 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007388.39144 | 2117874.05515 | 37.795695567741 | -122.418444578472 | (37.795695567741, -122.418444578472) | 5 | 1 | 10 | 28858 | 32 | |||
138724 | 19491 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10X Saroyan Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010944.42859 | 2118456.69114 | 37.7974948878134 | -122.406181056735 | (37.7974948878134, -122.406181056735) | 3 | 1 | 10 | 308 | 4 | |||
138743 | 11090 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1903 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 6x6 | 6007250.95739 | 2118862.55474 | 37.7984020026002 | -122.418990272151 | (37.7984020026002, -122.418990272151) | 5 | 1 | 10 | 28858 | 32 | |||
139551 | 112828 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
140945 | 4683 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 707 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6009355.02929 | 2119856.39151 | 37.8012490888204 | -122.41177977375 | (37.8012490888204, -122.41177977375) | 3 | 1 | 10 | 308 | 4 | |||
141238 | 11085 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1865 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6007279.7286506 | 2118687.2113849 | 37.7979221737821 | -122.418878272086 | (37.7979221737821, -122.418878272086) | 5 | 1 | 10 | 28858 | 32 | |||
142924 | 18508 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
143163 | 4654 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 3x3 | 6009795.85928 | 2119479.51144 | 37.8002389893085 | -122.41022767808 | (37.8002389893085, -122.41022767808) | 3 | 1 | 10 | 308 | 4 | |||
145725 | 112106 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
148636 | 112826 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
151930 | 18509 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
151939 | 257912 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
154973 | 21805 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2600X Taylor St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
155532 | 13054 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 562 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6009643.06131 | 2120540.81886 | 37.80314451067 | -122.41083141813 | (37.80314451067, -122.41083141813) | 3 | 1 | 10 | 308 | 23 | |||
160977 | 4597 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
162852 | 19490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10X Saroyan Pl | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010944.42859 | 2118456.69114 | 37.7974948878134 | -122.406181056735 | (37.7974948878134, -122.406181056735) | 3 | 1 | 10 | 308 | 4 | |||
166051 | 18510 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
166466 | 11087 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4x4 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
170847 | 4631 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 430 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6010350.91598 | 2119042.69079 | 37.799070683936 | -122.408276129064 | (37.799070683936, -122.408276129064) | 3 | 1 | 10 | 308 | 23 | |||
173250 | 11082 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1849 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007286.9943087 | 2118635.1241552 | 37.7977795644032 | -122.418849434729 | (37.7977795644032, -122.418849434729) | 5 | 1 | 10 | 28858 | 32 | |||
175319 | 11028 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1449 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007474.68946 | 2117365.61582 | 37.7943043774737 | -122.418109907661 | (37.7943043774737, -122.418109907661) | 5 | 1 | 10 | 28858 | 32 | |||
175894 | 13036 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 490 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/04/2015 08:35:00 AM | 3 | 3X3 | 6010019.32094 | 2120615.54911 | 37.80337079145 | -122.409534633266 | (37.80337079145, -122.409534633266) | 3 | 1 | 10 | 308 | 23 | ||
177573 | 4627 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 420 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010403.3977 | 2118996.04309 | 37.7989455393885 | -122.408091232197 | (37.7989455393885, -122.408091232197) | 3 | 1 | 10 | 308 | 23 | |||
179087 | 105657 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
182166 | 11086 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
184105 | 112108 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
186524 | 112825 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
193319 | 257913 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
371 | 251215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | ||||
3630 | 258965 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
5064 | 258966 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
6270 | 258961 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
9626 | 258963 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
9664 | 258964 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
10154 | 258967 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
11514 | 258968 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
16987 | 17305 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 51X Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006870.5020453 | 2109341.6908091 | 37.7722386113234 | -122.419630895813 | (37.7722386113234, -122.419630895813) | 8 | 2 | 9 | 28853 | 19 | |||
17682 | 258962 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
18544 | 258969 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
20552 | 15171 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 941 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010472.08374 | 2112774.72891 | 37.7818671496492 | -122.407414720255 | (37.7818671496492, -122.407414720255) | 14 | 2 | 9 | 28853 | 34 | |||
27252 | 17296 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 5X Otis St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007104.29527 | 2109558.64203 | 37.7728474744005 | -122.418837572 | (37.7728474744005, -122.418837572) | 8 | 2 | 9 | 28853 | 19 | |||
28163 | 10573 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 65 | 4x4 | 6011301.87316 | 2111047.97507 | 37.7771722946398 | -122.404422436991 | (37.7771722946398, -122.404422436991) | 14 | 2 | 9 | 28853 | 34 | |||
32017 | 116771 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 590X NATOMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6009883 | 2111689 | 37.7788530052944 | -122.409376039999 | (37.7788530052944, -122.409376039999) | 14 | 2 | 9 | 28853 | 34 | |||
34758 | 15261 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007445.07805 | 2110006.65891 | 37.7740968045009 | -122.417690522857 | (37.7740968045009, -122.417690522857) | 8 | 2 | 9 | 28853 | 19 | |||
40269 | 25702 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6012081.78675 | 2110335.7627 | 37.7752602760543 | -122.401674380603 | (37.7752602760543, -122.401674380603) | 14 | 2 | 9 | 28853 | 34 | |||
40345 | 17320 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
41708 | 251371 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
42234 | 25701 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6012066.85402 | 2110350.08491 | 37.7752987682674 | -122.40172704355 | (37.7752987682674, -122.40172704355) | 14 | 2 | 9 | 28853 | 34 | |||
43589 | 15250 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1450X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007716.15968 | 2110227.06056 | 37.7747172257492 | -122.416768419302 | (37.7747172257492, -122.416768419302) | 8 | 2 | 9 | 28853 | 34 | |||
51241 | 15259 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6007494.54134 | 2110025.11497 | 37.7741502637452 | -122.417520728591 | (37.7741502637452, -122.417520728591) | 8 | 2 | 9 | 28853 | 19 | |||
51739 | 19375 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390X 06th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6011348.29286 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | 14 | 2 | 9 | 28853 | 34 | |||
54802 | 17309 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 70 Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | 8 | 2 | 9 | 28853 | 19 | |||
55801 | 15251 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1450X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007694.41094 | 2110207.30516 | 37.7746617588291 | -122.416842252889 | (37.7746617588291, -122.416842252889) | 8 | 2 | 9 | 28853 | 34 | |||
64749 | 17324 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
66600 | 17310 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 70 Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | 8 | 2 | 9 | 28853 | 19 | |||
72154 | 17321 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
72411 | 15256 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007417.64852 | 2109947.83449 | 37.7739337430824 | -122.417781236147 | (37.7739337430824, -122.417781236147) | 8 | 2 | 9 | 28853 | 19 | |||
91800 | 19370 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390X 06TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
97139 | 15172 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 941 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010497.86985 | 2112769.44604 | 37.7818540873698 | -122.40732513932 | (37.7818540873698, -122.40732513932) | 14 | 2 | 9 | 28853 | 34 | |||
108637 | 27712 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 175X Otis St | 12 | 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 | |||
109251 | 17295 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 5X Otis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007087.86369 | 2109540.24307 | 37.7727960300261 | -122.418893105705 | (37.7727960300261, -122.418893105705) | 8 | 2 | 9 | 28853 | 19 | |||
109824 | 17315 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
113415 | 17294 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 5X Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007138.45925 | 2109591.54151 | 37.7729397321212 | -122.418721728138 | (37.7729397321212, -122.418721728138) | 8 | 2 | 9 | 28853 | 19 | |||
122653 | 17306 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 51X Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006870.5020453 | 2109341.6908091 | 37.7722386113234 | -122.419630895813 | (37.7722386113234, -122.419630895813) | 8 | 2 | 9 | 28853 | 19 | |||
131297 | 17307 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 51X Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006961.49044 | 2109420.44821 | 37.772459985288 | -122.419321746309 | (37.772459985288, -122.419321746309) | 8 | 2 | 9 | 28853 | 19 | |||
140527 | 15263 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51766 | 6007587.5132074 | 2110099.4827033 | 37.7743596907053 | -122.417204392502 | (37.7743596907053, -122.417204392502) | 8 | 2 | 9 | 28853 | 19 | |
141769 | 15252 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1450X Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007671.66057 | 2110183.15551 | 37.7745941699553 | -122.416919239811 | (37.7745941699553, -122.416919239811) | 8 | 2 | 9 | 28853 | 34 | |||
148523 | 15253 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1450X Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007637.14046 | 2110148.71 | 37.7744976489686 | -122.417036210851 | (37.7744976489686, -122.417036210851) | 8 | 2 | 9 | 28853 | 34 | |||
148917 | 19373 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390X 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4X4 | 6011348.29286 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | 14 | 2 | 9 | 28853 | 34 | |||
155474 | 17322 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
156641 | 15249 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1450X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007741.56076 | 2110251.13936 | 37.7747847690696 | -122.416682257719 | (37.7747847690696, -122.416682257719) | 8 | 2 | 9 | 28853 | 34 | |||
157267 | 17313 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
167163 | 17304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 51X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006870.5020453 | 2109341.6908091 | 37.7722386113234 | -122.419630895813 | (37.7722386113234, -122.419630895813) | 8 | 2 | 9 | 28853 | 19 | |||
173445 | 15262 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007448.14843 | 2109975.86864 | 37.774012434525 | -122.417677719037 | (37.774012434525, -122.417677719037) | 8 | 2 | 9 | 28853 | 19 | |||
173835 | 17323 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
175687 | 17314 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
177980 | 27711 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 175X Otis St | 11 | 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 | |||
180877 | 10578 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1005X HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x7 | 6011386 | 2111037 | 37.7771468605476 | -122.404130641378 | (37.7771468605476, -122.404130641378) | 14 | 2 | 9 | 28853 | 34 | |||
181935 | 17311 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 77 Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006769.4589066 | 2109244.8738273 | 37.7719670827617 | -122.419973541884 | (37.7719670827617, -122.419973541884) | 8 | 2 | 9 | 28853 | 19 | |||
185238 | 15310 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1650 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006887.5781181 | 2109042.9003069 | 37.7714191656036 | -122.41955062575 | (37.7714191656036, -122.41955062575) | 8 | 2 | 9 | 28853 | 19 | |||
186181 | 251369 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
187641 | 17308 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 70 Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | 8 | 2 | 9 | 28853 | 19 | |||
189650 | 15279 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1551 MISSION ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007345 | 2109715.7 | 37.7732922684508 | -122.418016080506 | (37.7732922684508, -122.418016080506) | 8 | 2 | 9 | 28853 | 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) );