trees
619 rows where Fire Prevention Districts = 2 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
193864 | 256057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 238 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39638 | 6004331 | 2099600 | 37.7453468607112 | -122.427721041632 | (37.7453468607112, -122.427721041632) | 2 | 7 | 5 | 63 | 22 | ||
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 | |||
191205 | 226361 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005760.58737 | 2103420.35055 | 37.7559174283599 | -122.423049246236 | (37.7559174283599, -122.423049246236) | 2 | 4 | 5 | 28859 | 19 | |||
190748 | 229846 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6005141.9373 | 2103725.25099 | 37.7567196838778 | -122.425210437638 | (37.7567196838778, -122.425210437638) | 2 | 4 | 5 | 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 | ||
189425 | 37050 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 278 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39655 | 6004138.71288838 | 2098700.07455731 | 37.7428649936747 | -122.428321811345 | (37.7428649936747, -122.428321811345) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||
188574 | 226773 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4030 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002932.26121 | 2102431.29378 | 37.7530417058104 | -122.432759865801 | (37.7530417058104, -122.432759865801) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
186551 | 226785 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3894 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003780.43348 | 2104817.05272 | 37.7596405020293 | -122.429996893968 | (37.7596405020293, -122.429996893968) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
186292 | 226801 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 545 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002785.55177 | 2103842.18407 | 37.7569073526207 | -122.433368026935 | (37.7569073526207, -122.433368026935) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
185908 | 226777 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 323 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004194.76383 | 2103338.46367 | 37.7556041027521 | -122.428458541531 | (37.7556041027521, -122.428458541531) | 2 | 4 | 5 | 28862 | 22 | |||
185655 | 74908 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4201 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52615 | 6002013.46643782 | 2105257.92812677 | 37.7607508108309 | -122.436139491461 | (37.7607508108309, -122.436139491461) | 2 | 4 | 5 | 28862 | 3 | |
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 | |
184733 | 33040 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 318 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37317 | 6005440.04608192 | 2101847.29088497 | 37.751580078433 | -122.42404592247 | (37.751580078433, -122.42404592247) | 2 | 4 | 5 | 28859 | 19 | ||
184418 | 226786 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3894 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003740.86919 | 2104813.89584 | 37.7596295932412 | -122.430133501864 | (37.7596295932412, -122.430133501864) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
181529 | 229746 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 170 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 8ft | 6005420.74895 | 2100228.937 | 37.7471353615169 | -122.423997581329 | (37.7471353615169, -122.423997581329) | 2 | 7 | 5 | 28859 | 22 | |||
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 | |||
181125 | 229820 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 709 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009884.4018 | 2104852.89904 | 37.7600827274654 | -122.408888748842 | (37.7600827274654, -122.408888748842) | 2 | 4 | 8 | 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 |
178845 | 34366 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38122 | 6004628.22720814 | 2097641.9206333 | 37.7399872310586 | -122.426553875593 | (37.7399872310586, -122.426553875593) | 2 | 7 | 5 | 63 | 7 | ||
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 | |||
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 | |||
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 | |||
176921 | 35574 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38942 | 6005781.80020082 | 2103418.56410023 | 37.7559137201977 | -122.422975758251 | (37.7559137201977, -122.422975758251) | 2 | 4 | 5 | 28859 | 19 | ||
176868 | 40243 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 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 | |
176654 | 226367 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 706 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6001215.62025 | 2102209.80088 | 37.7523360311927 | -122.438680460736 | (37.7523360311927, -122.438680460736) | 2 | 4 | 5 | 28862 | 22 | |||
176006 | 33047 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.7495787038819 | -122.423850524117 | (37.7495787038819, -122.423850524117) | 2 | 4 | 5 | 28859 | 19 | ||
175959 | 37023 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39634 | 6003883.04118176 | 2100148.50226599 | 37.7468275709653 | -122.429309115245 | (37.7468275709653, -122.429309115245) | 2 | 7 | 5 | 63 | 22 | ||
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 | |||
175338 | 226824 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003840.68463 | 2095954.97206 | 37.7353107011233 | -122.429156618694 | (37.7353107011233, -122.429156618694) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||
172051 | 35555 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 121 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38929 | 6005429.10148231 | 2103004.04163022 | 37.7547556297845 | -122.424166028327 | (37.7547556297845, -122.424166028327) | 2 | 4 | 5 | 28859 | 19 | ||
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 |
170230 | 229874 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3570 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004568.82488 | 2103108.44768 | 37.7549936933086 | -122.42714853777 | (37.7549936933086, -122.42714853777) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
169196 | 226795 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002427.79388 | 2104301.04841 | 37.7581469808114 | -122.434638096272 | (37.7581469808114, -122.434638096272) | 2 | 4 | 5 | 28862 | 3 | |||
168980 | 226358 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 603 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006078.34429 | 2099888.6136 | 37.7462380152724 | -122.421699497839 | (37.7462380152724, -122.421699497839) | 2 | 7 | 5 | 28859 | 2 | |||
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 | ||
168291 | 229850 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005369.98342 | 2103227.02308 | 37.7553645467641 | -122.424386333963 | (37.7553645467641, -122.424386333963) | 2 | 4 | 5 | 28859 | 19 | |||
167928 | 226763 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 162 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005498.11754 | 2099940.99775 | 37.7463491139326 | -122.423709577049 | (37.7463491139326, -122.423709577049) | 2 | 7 | 5 | 28859 | 22 | |||
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 | |||
166424 | 229855 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 354 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005458.16704 | 2101659.72097 | 37.7510660778443 | -122.42396992087 | (37.7510660778443, -122.42396992087) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
165980 | 35552 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38926 | 6005365.24269409 | 2103216.6337934 | 37.7553357524994 | -122.424401989918 | (37.7553357524994, -122.424401989918) | 2 | 4 | 5 | 28859 | 19 | ||
165178 | 226466 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 7 28th St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6005836.7555 | 2099627.17961 | 37.7455065507954 | -122.422516309799 | (37.7455065507954, -122.422516309799) | 2 | 7 | 5 | 28859 | 22 | |||
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 | |||
163736 | 226783 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003034.17518 | 2104887.2525 | 37.7597909621971 | -122.432582841439 | (37.7597909621971, -122.432582841439) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
162653 | 251225 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1 Yukon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x2.5 | 6000238 | 2104757 | 37.7592743544717 | -122.442244057145 | (37.7592743544717, -122.442244057145) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | ||
162120 | 58905 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 655 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | Permit Number 769760 | 6002418.15212939 | 2104399.4018004 | 37.7584164881822 | -122.434678474426 | (37.7584164881822, -122.434678474426) | 2 | 4 | 5 | 28862 | 3 | ||
159303 | 45811 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 71 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2001 12:00:00 AM | Permit Number 44439 | 6000723.05882095 | 2104884.41992047 | 37.7596518513768 | -122.440575632448 | (37.7596518513768, -122.440575632448) | 2 | 4 | 5 | 28862 | 3 | |||
159162 | 87811 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3631 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50591 | 6005544 | 2102537 | 37.7534797286848 | -122.423735471432 | (37.7534797286848, -122.423735471432) | 2 | 4 | 5 | 28859 | 19 | ||
158762 | 229744 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006129.97006 | 2100227.10081 | 37.7471703352582 | -122.421545017711 | (37.7471703352582, -122.421545017711) | 2 | 7 | 5 | 28859 | 22 | |||
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 | |||
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 |
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) );