trees
619 rows where Fire Prevention Districts = 2 and qSpecies_id = 50
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30844 | 36599 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1423 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39452 | 6009585.61659215 | 2100916.70354088 | 37.7492580755485 | -122.409644280871 | (37.7492580755485, -122.409644280871) | 2 | 4 | 7 | 28859 | 19 | ||
31239 | 226775 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4065 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003443.87888 | 2101243.2515 | 37.7498086241662 | -122.430905812676 | (37.7498086241662, -122.430905812676) | 2 | 4 | 5 | 28862 | 22 | |||
31293 | 229879 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003795.059 | 2100140.55813 | 37.7468007768344 | -122.429612782729 | (37.7468007768344, -122.429612782729) | 2 | 7 | 5 | 63 | 22 | |||
31344 | 226771 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 822 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003061.62277 | 2103431.29043 | 37.7557947949988 | -122.432383924871 | (37.7557947949988, -122.432383924871) | 2 | 4 | 5 | 28862 | 22 | |||
31441 | 50614 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 474 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | Permit Number 47214 | 6002793.31412073 | 2098675.69251057 | 37.7427218255103 | -122.432972078444 | (37.7427218255103, -122.432972078444) | 2 | 7 | 5 | 63 | 22 | |||
31962 | 33030 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3428 26th St | 2 | 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 | ||
32241 | 59724 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 706 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 19156 | 6001209.48230507 | 2102271.53927268 | 37.7525052007973 | -122.438706110204 | (37.7525052007973, -122.438706110204) | 2 | 4 | 5 | 28862 | 22 | ||
32703 | 226374 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4120 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001383.53668 | 2102929.36368 | 37.7543213286885 | -122.438151321247 | (37.7543213286885, -122.438151321247) | 2 | 4 | 5 | 28862 | 22 | |||
32766 | 226392 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1441 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008026.30666 | 2099772.03767 | 37.7460275775108 | -122.414955412565 | (37.7460275775108, -122.414955412565) | 2 | 7 | 7 | 28859 | 2 | |||
32997 | 40317 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 999 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41459 | 6006351.75417313 | 2103777.48351974 | 37.7569313744996 | -122.421030150349 | (37.7569313744996, -122.421030150349) | 2 | 4 | 7 | 28859 | 19 | ||
33217 | 229842 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3731 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005435.33161 | 2104281.13131 | 37.7582625715808 | -122.424235305437 | (37.7582625715808, -122.424235305437) | 2 | 4 | 5 | 28859 | 19 | |||
33298 | 229847 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6005127.97551 | 2103724.2468 | 37.7567161378508 | -122.42525865119 | (37.7567161378508, -122.42525865119) | 2 | 4 | 5 | 28859 | 19 | |||
33353 | 229895 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1429 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008018.20821 | 2099852.67897 | 37.7462485454514 | -122.414989122751 | (37.7462485454514, -122.414989122751) | 2 | 7 | 7 | 28859 | 2 | |||
33380 | 226305 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006137.34667 | 2097561.46022 | 37.7398515040311 | -122.421330243406 | (37.7398515040311, -122.421330243406) | 2 | 7 | 7 | 28859 | 2 | |||
33974 | 229877 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 376 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004079.13209 | 2100156.42335 | 37.7468604198839 | -122.428631616054 | (37.7468604198839, -122.428631616054) | 2 | 7 | 5 | 63 | 22 | |||
34432 | 229750 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 365 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005497.63156 | 2101589.27142 | 37.7508748675982 | -122.423828439536 | (37.7508748675982, -122.423828439536) | 2 | 4 | 5 | 28859 | 19 | |||
35141 | 32262 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 10 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 3 | Permit Number 35561 | 6005748.8799 | 2099664.71545 | 37.7456046578383 | -122.422822837406 | (37.7456046578383, -122.422822837406) | 2 | 7 | 5 | 28859 | 22 | |
35462 | 50281 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2890 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 46985 | 6009507.79940806 | 2102799.18720578 | 37.7544225953783 | -122.410046254665 | (37.7544225953783, -122.410046254665) | 2 | 4 | 7 | 28859 | 19 | ||
35536 | 34771 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1112 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.415081788574 | (37.7505995211504, -122.415081788574) | 2 | 4 | 7 | 28859 | 19 | |
35623 | 52402 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 92@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/2005 12:00:00 AM | Permit Number 48522 | 6006139.57045617 | 2097557.41563242 | 37.7398405238756 | -122.421322267329 | (37.7398405238756, -122.421322267329) | 2 | 7 | 7 | 28859 | 2 | ||
35946 | 68105 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31851 | 6008211.91573535 | 2099564.22145596 | 37.7454673885178 | -122.414298897694 | (37.7454673885178, -122.414298897694) | 2 | 7 | 7 | 28859 | 2 | ||
36827 | 37740 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 1 | 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 | ||
37084 | 71739 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1467 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1995 12:00:00 AM | 3x3 | Permit Number 56975 | 6008043.26276721 | 2099626.05915094 | 37.7456277058322 | -122.41488645052 | (37.7456277058322, -122.41488645052) | 2 | 7 | 7 | 28859 | 2 | ||
37473 | 37697 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 590 Shotwell St | 3 | 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 | ||
38635 | 226802 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4187 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002513.17222 | 2104117.53721 | 37.7576479497004 | -122.434329701679 | (37.7576479497004, -122.434329701679) | 2 | 4 | 5 | 28862 | 3 | |||
38719 | 226320 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1237 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009255.59412 | 2102037.09938 | 37.7523159340399 | -122.410864628624 | (37.7523159340399, -122.410864628624) | 2 | 4 | 7 | 28859 | 19 | |||
38739 | 229867 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 474 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002892.54695 | 2098627.83365 | 37.7425960442853 | -122.432625542146 | (37.7425960442853, -122.432625542146) | 2 | 7 | 5 | 63 | 22 | |||
39039 | 35325 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 226 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38792 | 6006662.54340548 | 2104792.55869269 | 37.7597360500369 | -122.42002735576 | (37.7597360500369, -122.42002735576) | 2 | 4 | 7 | 28859 | 19 | ||
39052 | 229883 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3784 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008413.69404 | 2097282.59684 | 37.7392138829104 | -122.413439846296 | (37.7392138829104, -122.413439846296) | 2 | 7 | 7 | 28859 | 2 | |||
39438 | 229804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 10 Crescent Ave | 7 | Side Yard : Yard | Tree | Private 2 | 6 | Width 5ft | 6005354.49537 | 2095898.81655 | 37.7352420900484 | -122.423918818711 | (37.7352420900484, -122.423918818711) | 2 | 7 | 7 | 28859 | 2 | |||
39458 | 67919 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 18 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31630 | 6004275.26721169 | 2095614.00906402 | 37.734399085455 | -122.427629821288 | (37.734399085455, -122.427629821288) | 2 | 7 | 5 | 28861 | 25 | ||
39886 | 37737 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 6 | 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 | ||
39925 | 226768 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 508 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001810.12784 | 2102797.39865 | 37.7539832366425 | -122.436666617866 | (37.7539832366425, -122.436666617866) | 2 | 4 | 5 | 28862 | 22 | |||
40005 | 229894 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1435 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008020.95699 | 2099824.31502 | 37.7461708188376 | -122.414977610555 | (37.7461708188376, -122.414977610555) | 2 | 7 | 7 | 28859 | 2 | |||
40026 | 229885 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1420 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007989.39364 | 2099739.34159 | 37.7459357270683 | -122.415080739378 | (37.7459357270683, -122.415080739378) | 2 | 7 | 7 | 28859 | 2 | |||
40085 | 226333 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 383 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006558.03164 | 2103902.48298 | 37.7572862199038 | -122.42032563593 | (37.7572862199038, -122.42032563593) | 2 | 4 | 7 | 28859 | 19 | |||
40136 | 229839 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 70 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005996.27622 | 2105099.28876 | 37.7605406982241 | -122.422353441684 | (37.7605406982241, -122.422353441684) | 2 | 4 | 5 | 28859 | 19 | |||
40238 | 46344 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 365 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44590 | 6005506.87362767 | 2101591.77673747 | 37.7508822683578 | -122.423796657689 | (37.7508822683578, -122.423796657689) | 2 | 4 | 5 | 28859 | 19 | ||
40292 | 82604 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1306 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010041.95956984 | 2101582.34952093 | 37.7511113537145 | -122.408113170097 | (37.7511113537145, -122.408113170097) | 2 | 4 | 7 | 28859 | 19 | ||
40413 | 40242 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 2 | 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 | ||
40544 | 226445 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3176 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008495.22679 | 2101571.86166 | 37.7509958309158 | -122.41346120966 | (37.7509958309158, -122.41346120966) | 2 | 4 | 7 | 28859 | 19 | |||
41208 | 226823 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 192 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004115.91768 | 2097275.83468 | 37.7389530669259 | -122.428299145692 | (37.7389530669259, -122.428299145692) | 2 | 7 | 5 | 63 | 7 | |||
41565 | 81287 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3145 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50544 | 6008016.04178081 | 2102664.62636249 | 37.7539693984201 | -122.415195628809 | (37.7539693984201, -122.415195628809) | 2 | 4 | 7 | 28859 | 19 | ||
41705 | 229798 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006019.29949 | 2105109.06322 | 37.7605688353024 | -122.422274509073 | (37.7605688353024, -122.422274509073) | 2 | 4 | 5 | 28859 | 19 | |||
41706 | 226443 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3190 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008436.7771 | 2101566.08648 | 37.7509766915292 | -122.413662926703 | (37.7509766915292, -122.413662926703) | 2 | 4 | 7 | 28859 | 19 | |||
42122 | 93487 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 643 San Jose Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53236 | 6005997.4 | 2099554.6 | 37.745316324998 | -122.421955670553 | (37.745316324998, -122.421955670553) | 2 | 7 | 5 | 28859 | 2 | |||
42682 | 226444 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3184 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008475.72782 | 2101569.16263 | 37.750987325127 | -122.413528448383 | (37.750987325127, -122.413528448383) | 2 | 4 | 7 | 28859 | 19 | |||
42787 | 39159 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40827 | 6006035.82025068 | 2105107.15671694 | 37.7605645323651 | -122.422217235752 | (37.7605645323651, -122.422217235752) | 2 | 4 | 5 | 28859 | 19 | ||
42902 | 104963 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3z3 | Permit Number 770948 | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
42972 | 226342 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006734.79318 | 2102518.91234 | 37.7534972124365 | -122.419616161673 | (37.7534972124365, -122.419616161673) | 2 | 4 | 7 | 28859 | 19 | |||
44395 | 226394 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1451 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008031.02829 | 2099712.86133 | 37.7458653577975 | -122.414934898137 | (37.7458653577975, -122.414934898137) | 2 | 7 | 7 | 28859 | 2 | |||
44484 | 226429 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006669.22772 | 2102968.64373 | 37.7547283780289 | -122.419874812075 | (37.7547283780289, -122.419874812075) | 2 | 4 | 7 | 28859 | 19 | |||
44643 | 226423 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 582 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007852.94487 | 2104547.46953 | 37.7591300882142 | -122.415892978285 | (37.7591300882142, -122.415892978285) | 2 | 4 | 7 | 28859 | 19 | |||
45979 | 226458 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3318 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008112.40239 | 2104471.67491 | 37.7589365568012 | -122.41499028288 | (37.7589365568012, -122.41499028288) | 2 | 4 | 7 | 28859 | 19 | |||
46390 | 229737 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1456 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009551.6906 | 2100697.19292 | 37.7486534468077 | -122.409746105823 | (37.7486534468077, -122.409746105823) | 2 | 4 | 7 | 28859 | 19 | |||
46491 | 226357 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 645 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005980.00754 | 2099557.6277 | 37.7453236574624 | -122.422016025938 | (37.7453236574624, -122.422016025938) | 2 | 7 | 5 | 28859 | 2 | |||
46513 | 82600 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1380-1382 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52212 | 6010324.92053454 | 2101179.2577549 | 37.7500203919907 | -122.407106246848 | (37.7500203919907, -122.407106246848) | 2 | 4 | 7 | 28859 | 19 | |
46591 | 37747 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 10 | 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 | ||
47184 | 226313 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2479 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008246.47754 | 2104016.96539 | 37.7576955616045 | -122.414494411095 | (37.7576955616045, -122.414494411095) | 2 | 4 | 7 | 28859 | 19 | |||
47921 | 35543 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 6 | 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 | ||
48255 | 50560 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4175 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2003 12:00:00 AM | Permit Number 47183 | 6002030.50619515 | 2102333.72789299 | 37.7527226291178 | -122.435871324431 | (37.7527226291178, -122.435871324431) | 2 | 4 | 5 | 28862 | 22 | |||
48641 | 39193 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 862 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40846 | 6009896.76562705 | 2104189.54699772 | 37.758262004919 | -122.408799187601 | (37.758262004919, -122.408799187601) | 2 | 4 | 7 | 28859 | 19 | ||
48985 | 100215 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 7x6 | 6008249 | 2099678 | 37.7457818821655 | -122.414178714053 | (37.7457818821655, -122.414178714053) | 2 | 7 | 7 | 28859 | 2 | |||
49433 | 66285 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31629 | 6004295.09294916 | 2095637.08175846 | 37.7344635592859 | -122.427562920462 | (37.7344635592859, -122.427562920462) | 2 | 7 | 5 | 28861 | 25 | ||
49516 | 36914 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 508 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 39560 | 6001809.10067712 | 2102876.63029352 | 37.7542007293515 | -122.436675841105 | (37.7542007293515, -122.436675841105) | 2 | 4 | 5 | 28862 | 22 | ||
49552 | 35556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 121 Fair Oaks St | 1 | 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 | ||
50251 | 37675 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3318 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 12 | 3x3 | Permit Number 40071 | 6008076 | 2104474 | 37.758940895326 | -122.415116344354 | (37.758940895326, -122.415116344354) | 2 | 4 | 7 | 28859 | 19 |
50360 | 108394 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 737 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773728 | 6007947.99445 | 2103637.44207 | 37.7566367043842 | -122.41549982216 | (37.7566367043842, -122.41549982216) | 2 | 4 | 7 | 28859 | 19 |
50375 | 52627 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 642@ 18th ST Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2006 12:00:00 AM | Permit Number 48710 | 6010085.91969508 | 2105298.86686021 | 37.7613185401792 | -122.408223245875 | (37.7613185401792, -122.408223245875) | 2 | 4 | 8 | 28859 | 19 | |||
50547 | 55554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 159 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50800 | 6000262.70357659 | 2104857.37596764 | 37.7595513701063 | -122.44216582584 | (37.7595513701063, -122.44216582584) | 2 | 4 | 5 | 28862 | 3 | ||
51240 | 226804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3520 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004856.92636 | 2103707.06921 | 37.7566536556703 | -122.42619481576 | (37.7566536556703, -122.42619481576) | 2 | 4 | 5 | 28862 | 3 | |||
51280 | 229857 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 119 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005419.16743 | 2102997.26245 | 37.7547364548257 | -122.42419990093 | (37.7547364548257, -122.42419990093) | 2 | 4 | 5 | 28859 | 19 | |||
51307 | 226395 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1467 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008034.1838 | 2099620.63234 | 37.7456122948636 | -122.414917460292 | (37.7456122948636, -122.414917460292) | 2 | 7 | 7 | 28859 | 2 | |||
51702 | 97477 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3000 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768380 | 6009497.8 | 2101066.6 | 37.7496647366653 | -122.409958533785 | (37.7496647366653, -122.409958533785) | 2 | 4 | 7 | 28859 | 19 |
51890 | 229889 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008249.88149 | 2099665.88685 | 37.7457486716635 | -122.414174809135 | (37.7457486716635, -122.414174809135) | 2 | 7 | 7 | 28859 | 2 | |||
52017 | 226767 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4257 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001499.39319 | 2102307.79719 | 37.752621244884 | -122.437706147824 | (37.752621244884, -122.437706147824) | 2 | 4 | 5 | 28862 | 22 | |||
52183 | 228548 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6009560.01396 | 2101278.1954 | 37.7502492173426 | -122.409758328497 | (37.7502492173426, -122.409758328497) | 2 | 4 | 7 | 28859 | 19 | |||
52380 | 228547 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6009559.03474 | 2101249.47013 | 37.7501702892497 | -122.409759687354 | (37.7501702892497, -122.409759687354) | 2 | 4 | 7 | 28859 | 19 | |||
52802 | 37414 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 929 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39892 | 6001945.76118783 | 2101390.6122358 | 37.7501282439333 | -122.436096904408 | (37.7501282439333, -122.436096904408) | 2 | 4 | 5 | 28862 | 22 | ||
52818 | 229871 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3737 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004840.3014 | 2102492.95724 | 37.7533190486424 | -122.426165878261 | (37.7533190486424, -122.426165878261) | 2 | 4 | 5 | 28862 | 22 | |||
52832 | 37699 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 590 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | 3x3 | Permit Number 40081 | 6007854.26822666 | 2104498.62498081 | 37.7589960467021 | -122.41588494267 | (37.7589960467021, -122.41588494267) | 2 | 4 | 7 | 28859 | 19 | |
52984 | 226359 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 18 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006091.22485 | 2103483.15861 | 37.7561085369955 | -122.421910253056 | (37.7561085369955, -122.421910253056) | 2 | 4 | 5 | 28859 | 19 | |||
53093 | 226430 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006668.67931 | 2102994.38705 | 37.7547990323663 | -122.419878535269 | (37.7547990323663, -122.419878535269) | 2 | 4 | 7 | 28859 | 19 | |||
53758 | 226353 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3027 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009058.07626 | 2100853.8453 | 37.7490559051208 | -122.41146409149 | (37.7490559051208, -122.41146409149) | 2 | 4 | 7 | 28859 | 19 | |||
54136 | 226376 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 268 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004329.65759 | 2096832.9872 | 37.7377492002742 | -122.427528590399 | (37.7377492002742, -122.427528590399) | 2 | 7 | 5 | 63 | 7 | |||
55105 | 39192 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1081 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1998 12:00:00 AM | Permit Number 40845 | 6008661.50268126 | 2102262.13718449 | 37.7529005072206 | -122.412935008702 | (37.7529005072206, -122.412935008702) | 2 | 4 | 7 | 28859 | 19 | |||
55115 | 229835 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2899 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010132.5344 | 2101618.95509 | 37.7512169355291 | -122.407802532369 | (37.7512169355291, -122.407802532369) | 2 | 4 | 7 | 28859 | 19 | |||
55153 | 229747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005427.81149 | 2099645.37238 | 37.7455334252207 | -122.423931669125 | (37.7455334252207, -122.423931669125) | 2 | 7 | 5 | 28859 | 22 | |||
55486 | 37153 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 170 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39733 | 6005417.81804662 | 2100232.85413732 | 37.7471459516063 | -122.42400799468 | (37.7471459516063, -122.42400799468) | 2 | 7 | 5 | 28859 | 22 | |||
55488 | 220057 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007984.69118 | 2102236.05472 | 37.752790875909 | -122.415273710521 | (37.752790875909, -122.415273710521) | 2 | 4 | 7 | 28859 | 19 | |||
55948 | 50586 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 941 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2003 12:00:00 AM | Permit Number 47201 | 6001947.38784558 | 2101357.03323011 | 37.7500361363805 | -122.436088876747 | (37.7500361363805, -122.436088876747) | 2 | 4 | 5 | 28862 | 22 | |||
56577 | 35969 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 176 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39127 | 6006023.56999156 | 2096341.44627535 | 37.7364952030819 | -122.421637006977 | (37.7364952030819, -122.421637006977) | 2 | 7 | 7 | 28859 | 2 | ||
56787 | 83340 | 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 | |
56791 | 42908 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2728 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51144 | 6009776.67669238 | 2103983.6124683 | 37.7576898279618 | -122.409199977722 | (37.7576898279618, -122.409199977722) | 2 | 4 | 7 | 28859 | 19 | ||
56867 | 229875 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3771 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004599.42844 | 2102480.09049 | 37.7532701021595 | -122.42699795081 | (37.7532701021595, -122.42699795081) | 2 | 4 | 5 | 28862 | 22 | |||
56905 | 34792 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1171 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38428 | 6008691.00817577 | 2101734.24862099 | 37.7514527000041 | -122.412795655117 | (37.7514527000041, -122.412795655117) | 2 | 4 | 7 | 28859 | 19 | ||
56974 | 226417 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1116 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008029.19909 | 2101392.11657 | 37.7504761135956 | -122.415060063068 | (37.7504761135956, -122.415060063068) | 2 | 4 | 7 | 28859 | 19 | |||
56991 | 35544 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 5 | 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 | ||
57678 | 226799 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Sanchez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003733.12478 | 2104096.27114 | 37.7576587280713 | -122.430109091559 | (37.7576587280713, -122.430109091559) | 2 | 4 | 5 | 28862 | 3 | |||
57912 | 229849 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005369.70063 | 2103246.31322 | 37.7554174970228 | -122.424388683912 | (37.7554174970228, -122.424388683912) | 2 | 4 | 5 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );