trees
502 rows where Supervisor Districts = 7 and qSpecies_id = 50 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194227 | 228537 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009258.78622 | 2107356.53697 | 37.7669220806253 | -122.411229322595 | (37.7669220806253, -122.411229322595) | 8 | 4 | 7 | 28853 | 19 | |||
193991 | 52376 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 25 Fair Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48505 | 6006761.98937592 | 2099585.56782641 | 37.7454444472056 | -122.419314037874 | (37.7454444472056, -122.419314037874) | 2 | 7 | 7 | 28859 | 2 | ||
193942 | 36713 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 34 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39499 | 6006412.25485032 | 2105738.01834436 | 37.7623179565756 | -122.420960109842 | (37.7623179565756, -122.420960109842) | 8 | 4 | 7 | 28859 | 19 | ||
193547 | 37696 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 590 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40081 | 6007854.26822666 | 2104498.62498081 | 37.7589960467021 | -122.41588494267 | (37.7589960467021, -122.41588494267) | 2 | 4 | 7 | 28859 | 19 | ||
192973 | 226428 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006671.33563 | 2102940.18758 | 37.7546503627401 | -122.419865503217 | (37.7546503627401, -122.419865503217) | 2 | 4 | 7 | 28859 | 19 | |||
192647 | 36594 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
192552 | 229802 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 232 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006479.51273 | 2104709.99124 | 37.7594990251845 | -122.420654508118 | (37.7594990251845, -122.420654508118) | 2 | 4 | 7 | 28859 | 19 | |||
192061 | 228549 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009550.58062 | 2101412.53302 | 37.7506175499731 | -122.409800431165 | (37.7506175499731, -122.409800431165) | 2 | 4 | 7 | 28859 | 19 | |||
192044 | 35542 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
191365 | 226435 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006660.81941 | 2103136.07502 | 37.7551876321062 | -122.419915770819 | (37.7551876321062, -122.419915770819) | 2 | 4 | 7 | 28859 | 19 | |||
191118 | 44013 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
190578 | 37674 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3318 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 8 | Permit Number 40071 | 6008076 | 2104474 | 37.758940895326 | -122.415116344354 | (37.758940895326, -122.415116344354) | 2 | 4 | 7 | 28859 | 19 | |
189452 | 37743 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
189225 | 36609 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1457 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39460 | 6009593.56099734 | 2100772.83589567 | 37.7488634920028 | -122.409606655966 | (37.7488634920028, -122.409606655966) | 2 | 4 | 7 | 28859 | 19 | ||
188939 | 104962 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 74 Aztec St. | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
188542 | 37751 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1425 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1998 12:00:00 AM | Permit Number 40098 | 6009586.08390989 | 2100908.24074194 | 37.7492348647629 | -122.409642067631 | (37.7492348647629, -122.409642067631) | 2 | 4 | 7 | 28859 | 19 | |||
188143 | 88302 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1306 York St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367022 | (37.7511299031436, -122.40816367022) | 2 | 4 | 7 | 28859 | 19 | |||
187560 | 117555 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1314 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6007674.4763735 | 2101992.27281083 | 37.7521040666078 | -122.416329227522 | (37.7521040666078, -122.416329227522) | 2 | 4 | 7 | 28859 | 19 | |||
186401 | 226422 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3354 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007858.2602 | 2104522.84344 | 37.7590627694542 | -122.415872851461 | (37.7590627694542, -122.415872851461) | 2 | 4 | 7 | 28859 | 19 | |||
186236 | 226328 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007822.68734 | 2105830.62056 | 37.7626516238081 | -122.416088496301 | (37.7626516238081, -122.416088496301) | 8 | 4 | 7 | 28859 | 19 | |||
186089 | 229821 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 862 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009901.39603 | 2104182.38613 | 37.7582426021438 | -122.40878266838 | (37.7582426021438, -122.40878266838) | 2 | 4 | 7 | 28859 | 19 | |||
185552 | 26498 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2710 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/1999 12:00:00 AM | 6 | 3x3 | 6008903.18819 | 2102577.27107 | 37.7537793576317 | -122.412121481544 | (37.7537793576317, -122.412121481544) | 2 | 4 | 7 | 28859 | 19 | ||
185014 | 67355 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 815 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777973 | 6009933.6561998 | 2104468.00986769 | 37.759028667481 | -122.408691247698 | (37.759028667481, -122.408691247698) | 2 | 4 | 7 | 28859 | 19 | |
184588 | 38249 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40360 | 6007553.94098134 | 2107334.22981902 | 37.7667650702265 | -122.417124544174 | (37.7667650702265, -122.417124544174) | 8 | 4 | 7 | 28853 | 19 | ||
183689 | 34745 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2531 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38393 | 6008900.83649709 | 2103723.81151617 | 37.756927366913 | -122.4122106421 | (37.756927366913, -122.4122106421) | 2 | 4 | 7 | 28859 | 19 | ||
182567 | 34728 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3171 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38382 | 6008528.73936526 | 2101523.94206267 | 37.7508661360797 | -122.413341931038 | (37.7508661360797, -122.413341931038) | 2 | 4 | 7 | 28859 | 19 | ||
181833 | 226412 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 282 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1987 12:00:00 AM | 14 | Width 3ft | Permit Number 24387 | 6008267.80034 | 2100190.98708 | 37.7471914863912 | -122.41414999144 | (37.7471914863912, -122.41414999144) | 2 | 7 | 7 | 28859 | 2 | |
181781 | 49967 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3228@ PRECITA Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/02/2003 12:00:00 AM | Permit Number 46719 | 6008983.82935555 | 2099882.83427264 | 37.7463855595114 | -122.411652240395 | (37.7463855595114, -122.411652240395) | 2 | 7 | 7 | 28859 | 2 | ||
181741 | 226453 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008553.18177 | 2102742.64498 | 37.754213792241 | -122.41334358196 | (37.754213792241, -122.41334358196) | 2 | 4 | 7 | 28859 | 19 | |||
181150 | 226323 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1139 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008076.0678 | 2101289.03077 | 37.7501956968847 | -122.414890691951 | (37.7501956968847, -122.414890691951) | 2 | 4 | 7 | 28859 | 19 | |||
180711 | 68479 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1216 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32349 | 6010272.81628211 | 2102122.83184257 | 37.7526083219498 | -122.407352938123 | (37.7526083219498, -122.407352938123) | 2 | 4 | 7 | 28859 | 19 | ||
180344 | 36600 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1426 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39453 | 6009534.63032836 | 2100896.9108508 | 37.7492008719769 | -122.409819196077 | (37.7492008719769, -122.409819196077) | 2 | 4 | 7 | 28859 | 19 | ||
179723 | 226405 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1405 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008013.30182 | 2099943.8587 | 37.746498628925 | -122.415012541103 | (37.746498628925, -122.415012541103) | 2 | 7 | 7 | 28859 | 2 | |||
179365 | 99928 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3331 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54787 | 6007298 | 2105556 | 37.7618680647923 | -122.417883738243 | (37.7618680647923, -122.417883738243) | 2 | 4 | 7 | 28859 | 19 |
178778 | 226424 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 576 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007852.84367 | 2104586.25311 | 37.7592365733232 | -122.415896074661 | (37.7592365733232, -122.415896074661) | 2 | 4 | 7 | 28859 | 19 | |||
178334 | 37742 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
178217 | 226324 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1055 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008046.21468 | 2101786.36501 | 37.7515595871229 | -122.415029123693 | (37.7515595871229, -122.415029123693) | 2 | 4 | 7 | 28859 | 19 | |||
177993 | 228536 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009279.45147 | 2107357.51638 | 37.7669259288053 | -122.411157913712 | (37.7669259288053, -122.411157913712) | 8 | 4 | 7 | 28853 | 19 | |||
177741 | 226317 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1332 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007672.14775 | 2101889.27632 | 37.7518211306439 | -122.416329985835 | (37.7518211306439, -122.416329985835) | 2 | 4 | 7 | 28859 | 19 | |||
177064 | 44004 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
177009 | 226349 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3169 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008560.82259 | 2101530.27945 | 37.7508853383864 | -122.413231431983 | (37.7508853383864, -122.413231431983) | 2 | 4 | 7 | 28859 | 19 | |||
176666 | 96068 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1055 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767693 | 6008044 | 2101787 | 37.7515612062089 | -122.415036827298 | (37.7515612062089, -122.415036827298) | 2 | 4 | 7 | 28859 | 19 | |
176140 | 44012 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 405X Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
175900 | 229803 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006754.85376 | 2105853.73018 | 37.7626549800545 | -122.419783396906 | (37.7626549800545, -122.419783396906) | 8 | 4 | 7 | 28859 | 19 | |||
175750 | 226331 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 155 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6006477.52748 | 2105222.5882 | 37.7609063850338 | -122.420697763712 | (37.7609063850338, -122.420697763712) | 2 | 4 | 7 | 28859 | 19 | |||
175061 | 228532 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009375.26414 | 2107362.10106 | 37.7669438900682 | -122.410826835502 | (37.7669438900682, -122.410826835502) | 8 | 4 | 7 | 28853 | 19 | |||
174953 | 226307 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 303 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007092.99842 | 2096727.14909 | 37.7376145033994 | -122.417966864376 | (37.7376145033994, -122.417966864376) | 2 | 7 | 7 | 28859 | 2 | |||
173888 | 51288 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1143 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/2004 12:00:00 AM | Permit Number 47660 | 6009497.00762937 | 2102519.03673443 | 37.7536527600356 | -122.410063798952 | (37.7536527600356, -122.410063798952) | 2 | 4 | 7 | 28859 | 19 | ||
172836 | 37451 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39924 | 6009949.70212209 | 2098546.33795552 | 37.7427699663381 | -122.408218103257 | (37.7427699663381, -122.408218103257) | 10 | 7 | 7 | 28859 | 2 | ||
171578 | 226306 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 92 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006186.62899 | 2097537.37358 | 37.7397881459032 | -122.421158135656 | (37.7397881459032, -122.421158135656) | 2 | 7 | 7 | 28859 | 2 | |||
170353 | 68103 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 8 | 3x3 | Permit Number 31849 | 6008260.07157656 | 2099634.80152159 | 37.7456638906333 | -122.414137374358 | (37.7456638906333, -122.414137374358) | 2 | 7 | 7 | 28859 | 2 |
170166 | 226315 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007642.72664 | 2103585.2825 | 37.756476322828 | -122.416551856705 | (37.756476322828, -122.416551856705) | 2 | 4 | 7 | 28859 | 19 | |||
170113 | 35796 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 230 Lexington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39044 | 6006467.16362039 | 2104758.98191383 | 37.7596328461688 | -122.42070069541 | (37.7596328461688, -122.42070069541) | 2 | 4 | 7 | 28859 | 19 | ||
169650 | 42663 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42694 | 6006739.09438078 | 2102580.17039633 | 37.7536656552896 | -122.419605633092 | (37.7536656552896, -122.419605633092) | 2 | 4 | 7 | 28859 | 19 | ||
168892 | 226441 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 507 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006831.87915 | 2100767.2588 | 37.7486930394633 | -122.419156175534 | (37.7486930394633, -122.419156175534) | 2 | 4 | 7 | 28859 | 19 | |||
168405 | 37760 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1349 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2001 12:00:00 AM | Permit Number 43826 | 6010106.85455823 | 2101350.26433307 | 37.7504777324538 | -122.407872391397 | (37.7504777324538, -122.407872391397) | 2 | 4 | 7 | 28859 | 19 | ||
168394 | 34557 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Nebraska St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38265 | 6009291.02762051 | 2098031.45158376 | 37.7413192965243 | -122.410459272722 | (37.7413192965243, -122.410459272722) | 10 | 7 | 7 | 28859 | 2 | ||
167891 | 226319 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1363 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009300.51192 | 2101248.84299 | 37.7501540762619 | -122.410653634171 | (37.7501540762619, -122.410653634171) | 2 | 4 | 7 | 28859 | 19 | |||
166927 | 226338 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 41 Bartlett St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006684.19647 | 2103512.2186 | 37.7562217526516 | -122.41986161543 | (37.7562217526516, -122.41986161543) | 2 | 4 | 7 | 28859 | 19 | |||
166899 | 229893 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 57 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008237.21282 | 2099854.86207 | 37.7462668439462 | -122.414231983545 | (37.7462668439462, -122.414231983545) | 2 | 7 | 7 | 28859 | 2 | |||
166588 | 37015 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3027 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39628 | 6009057.00887193 | 2100861.48300975 | 37.7490768167034 | -122.411468322066 | (37.7490768167034, -122.411468322066) | 2 | 4 | 7 | 28859 | 19 | ||
166585 | 226406 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008014.49827 | 2099882.17848 | 37.7463293360461 | -122.415004038921 | (37.7463293360461, -122.415004038921) | 2 | 7 | 7 | 28859 | 2 | |||
166181 | 37741 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
164840 | 229738 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1498 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009552.90198 | 2100679.56843 | 37.748605121741 | -122.409740673009 | (37.748605121741, -122.409740673009) | 2 | 4 | 7 | 28859 | 19 | |||
164689 | 229863 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1511 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010172.47865 | 2100425.75688 | 37.7479429122343 | -122.407580282 | (37.7479429122343, -122.407580282) | 2 | 7 | 7 | 28859 | 2 | |||
164441 | 226451 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008441.9337 | 2102736.37343 | 37.7541903253234 | -122.413727863145 | (37.7541903253234, -122.413727863145) | 2 | 4 | 7 | 28859 | 19 | |||
164001 | 229816 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 990 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008580.21051 | 2102912.84819 | 37.7546826492875 | -122.413262144753 | (37.7546826492875, -122.413262144753) | 2 | 4 | 7 | 28859 | 19 | |||
163566 | 37677 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 8 | 0x0 | Permit Number 40072 | 6008031 | 2104525 | 37.7590784006599 | -122.415275586184 | (37.7590784006599, -122.415275586184) | 2 | 4 | 7 | 28859 | 19 |
163174 | 63722 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 282 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24387 | 6008301.23026628 | 2100182.88719283 | 37.7471711235701 | -122.414033820067 | (37.7471711235701, -122.414033820067) | 2 | 7 | 7 | 28859 | 2 | ||
162863 | 226421 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3354 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007857.16487 | 2104491.21664 | 37.7589758679475 | -122.415874400085 | (37.7589758679475, -122.415874400085) | 2 | 4 | 7 | 28859 | 19 | |||
162205 | 36596 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
161840 | 148099 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 509 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2018 12:00:00 AM | 3 | 4x4 | Permit Number 782106 | 6009909.13224 | 2092063.05855 | 37.7249659929773 | -122.40790129952 | (37.7249659929773, -122.40790129952) | 10 | 3 | 7 | 309 | 28 | |
160150 | 52222 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | 8 | 4 | 7 | 28859 | 19 | |||
158779 | 226356 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2793 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008207.55 | 2106773.70397 | 37.7652627442076 | -122.414824138541 | (37.7652627442076, -122.414824138541) | 8 | 4 | 7 | 28859 | 19 | |||
158659 | 229827 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1450 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6010090.15715 | 2100798.67472 | 37.7489622542237 | -122.407891240603 | (37.7489622542237, -122.407891240603) | 2 | 4 | 7 | 28859 | 19 | |||
158524 | 229801 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 232 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006479.77522 | 2104722.77918 | 37.7595341526843 | -122.4206545081 | (37.7595341526843, -122.4206545081) | 2 | 4 | 7 | 28859 | 19 | |||
158498 | 35323 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 209 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2002 12:00:00 AM | Permit Number 45862 | 6006709.88986016 | 2104895.8779561 | 37.76002240815 | -122.419870939027 | (37.76002240815, -122.419870939027) | 2 | 4 | 7 | 28859 | 19 | ||
158000 | 35547 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
157820 | 226386 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 354 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006131.45892 | 2098074.37938 | 37.7412595329921 | -122.421387016722 | (37.7412595329921, -122.421387016722) | 2 | 7 | 7 | 28859 | 2 | |||
157743 | 38250 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40360 | 6007553.94098134 | 2107334.22981902 | 37.7667650702265 | -122.417124544174 | (37.7667650702265, -122.417124544174) | 8 | 4 | 7 | 28853 | 19 | ||
157538 | 37735 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | |||
156928 | 34731 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | 2 | 4 | 7 | 28859 | 19 | |||
156536 | 68108 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 83 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1993 12:00:00 AM | Permit Number 31854 | 6008265.27071667 | 2099541.297285 | 37.7454074408153 | -122.414112782506 | (37.7454074408153, -122.414112782506) | 2 | 7 | 7 | 28859 | 2 | ||
156084 | 226351 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3273 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006624.34034 | 2103173.55504 | 37.7552884883831 | -122.420044586082 | (37.7552884883831, -122.420044586082) | 2 | 4 | 7 | 28859 | 19 | |||
156039 | 226426 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3323 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006880.3188 | 2102604.06002 | 37.7537392047139 | -122.419118940914 | (37.7537392047139, -122.419118940914) | 2 | 4 | 7 | 28859 | 19 | |||
155445 | 28065 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2576 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/2001 12:00:00 AM | 12 | 3X3 | 6009719.04611 | 2102350.04498 | 37.7532011888856 | -122.409284012572 | (37.7532011888856, -122.409284012572) | 2 | 4 | 7 | 28859 | 19 | ||
155304 | 33026 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3428 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.9310023 | 2100900.56738488 | 37.7490622873512 | -122.418968344047 | (37.7490622873512, -122.418968344047) | 2 | 4 | 7 | 28859 | 19 | ||
154980 | 29076 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2299X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009690.9471404 | 2103965.2718708 | 37.7576346655719 | -122.409495172566 | (37.7576346655719, -122.409495172566) | 2 | 4 | 7 | 28859 | 19 | ||
154249 | 228539 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009212.74652 | 2107353.73928 | 37.7669118166657 | -122.411388369502 | (37.7669118166657, -122.411388369502) | 8 | 4 | 7 | 28853 | 19 | |||
154193 | 117396 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 330X Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776356 | 6007069.63693 | 2096670.72705 | 37.7374582661153 | -122.418043637637 | (37.7374582661153, -122.418043637637) | 2 | 7 | 7 | 28859 | 2 | ||
153942 | 34730 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | 2 | 4 | 7 | 28859 | 19 | |||
152400 | 37698 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 590 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40081 | 6007854.26822666 | 2104498.62498081 | 37.7589960467021 | -122.41588494267 | (37.7589960467021, -122.41588494267) | 2 | 4 | 7 | 28859 | 19 | ||
152160 | 229736 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1446 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009548.10461 | 2100752.4115 | 37.7488048638556 | -122.409762403312 | (37.7488048638556, -122.409762403312) | 2 | 4 | 7 | 28859 | 19 | |||
150448 | 46555 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2169 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44694 | 6008148.92674441 | 2105809.63139765 | 37.7626123299985 | -122.414958662117 | (37.7626123299985, -122.414958662117) | 8 | 4 | 7 | 28859 | 19 | |||
150230 | 37662 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3236 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40069 | 6007902.47556564 | 2105636.26552701 | 37.7621224556474 | -122.415798773861 | (37.7621224556474, -122.415798773861) | 8 | 4 | 7 | 28859 | 19 | ||
149748 | 226387 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006154.51065 | 2098290.0214 | 37.7418529371529 | -122.421322621667 | (37.7418529371529, -122.421322621667) | 2 | 7 | 7 | 28859 | 2 | |||
148309 | 226304 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1425 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008016.14912 | 2099877.20359 | 37.7463157688762 | -122.414997978399 | (37.7463157688762, -122.414997978399) | 2 | 7 | 7 | 28859 | 2 | |||
147417 | 229791 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007593.88535 | 2107340.09456 | 37.7667834204575 | -122.416986798497 | (37.7667834204575, -122.416986798497) | 8 | 4 | 7 | 28853 | 19 | |||
146523 | 226382 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 58 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009331.97291 | 2097098.94639 | 37.7387611354248 | -122.410251874634 | (37.7387611354248, -122.410251874634) | 10 | 7 | 7 | 28859 | 2 | |||
146505 | 68109 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 87 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1993 12:00:00 AM | Permit Number 31855 | 6008266.5705023 | 2099517.92121492 | 37.7453433283283 | -122.414106634567 | (37.7453433283283, -122.414106634567) | 2 | 7 | 7 | 28859 | 2 |
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) );