trees
1,098 rows where qCaretaker_id = 4 sorted by Supervisor Districts
This data as json, CSV (advanced)
PlantType ✖
- Tree 1,089
- Landscaping 8
- tree 1
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80 | 260998 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard | Tree | SFUSD 4 | 10x10 | ||||||||||||||
1047 | 42641 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1651 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 12:11:00 PM | 3 | 5x5 | Permit Number 42688 | 6005090.06351 | 2118821.98656 | 37.7981686950973 | -122.426464740961 | (37.7981686950973, -122.426464740961) | 13 | 9 | 1 | 57 | 17 |
3404 | 74737 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 151X Palm Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5995889.08215 | 2113282.06845 | 37.7824331529909 | -122.457901543211 | (37.7824331529909, -122.457901543211) | 11 | 6 | 1 | 54 | 31 | ||
5484 | 71815 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5995888.68435 | 2113315.23973 | 37.7825242096287 | -122.45790532062 | (37.7825242096287, -122.45790532062) | 11 | 6 | 1 | 54 | 31 | ||
6245 | 75019 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 151X Palm Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5995892.05475 | 2113163.21783 | 37.782106991639 | -122.457882656117 | (37.782106991639, -122.457882656117) | 11 | 6 | 1 | 54 | 31 | ||
6745 | 74583 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995884.6031 | 2113341.96396 | 37.7825973527613 | -122.457921374418 | (37.7825973527613, -122.457921374418) | 11 | 6 | 1 | 54 | 31 | |
10649 | 76037 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 4x6 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
10992 | 98625 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002285.2374 | 2120040.843 | 37.8013564005351 | -122.43625752619 | (37.8013564005351, -122.43625752619) | 13 | 9 | 1 | 57 | 17 | ||
11183 | 74883 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995886.83117 | 2113252.75826 | 37.7823525456975 | -122.457907208857 | (37.7823525456975, -122.457907208857) | 11 | 6 | 1 | 54 | 31 | |
11450 | 93122 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995895.24901 | 2113041.91566 | 37.7817741116959 | -122.457862824896 | (37.7817741116959, -122.457862824896) | 11 | 6 | 1 | 54 | 31 | |
12599 | 93632 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 53266 | 5995882.07932 | 2113403.99303 | 37.7827675230466 | -122.457934595796 | (37.7827675230466, -122.457934595796) | 11 | 6 | 1 | 54 | 31 |
12918 | 42635 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:32:00 AM | 3 | 4x5 | Permit Number 42688 | 6005113.34773 | 2118824.42387 | 37.7981767035488 | -122.426384344263 | (37.7981767035488, -122.426384344263) | 13 | 9 | 1 | 57 | 17 |
13407 | 42632 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 12:07:00 PM | 3 | 4x4 | Permit Number 42688 | 6005134.31421 | 2118828.07494 | 37.7981879136105 | -122.426312054082 | (37.7981879136105, -122.426312054082) | 13 | 9 | 1 | 57 | 17 |
15563 | 42636 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:48:00 AM | 3 | 4x5 | Permit Number 42688 | 6005181.30457 | 2118838.80185 | 37.7982200229931 | -122.426150217479 | (37.7982200229931, -122.426150217479) | 13 | 9 | 1 | 57 | 17 |
17940 | 42637 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:43:00 AM | 3 | 4x4 | Permit Number 42688 | 6005203.48268 | 2118840.06651 | 37.7982247489172 | -122.42607356464 | (37.7982247489172, -122.42607356464) | 13 | 9 | 1 | 57 | 17 |
20458 | 42640 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1651 Union St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/25/2015 02:08:00 PM | 3 | 3x3 | Permit Number 42688 | 6005273.82097 | 2118847.7065 | 37.7982497015198 | -122.425830717123 | (37.7982497015198, -122.425830717123) | 13 | 9 | 1 | 57 | 17 |
21058 | 98632 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x4 | 6002258.48202 | 2120196.40471 | 37.801782011886 | -122.436361251288 | (37.801782011886, -122.436361251288) | 13 | 9 | 1 | 57 | 17 | ||
21099 | 76027 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 4x4 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
21542 | 98642 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002233.86885 | 2120387.28696 | 37.8023047257379 | -122.436460093962 | (37.8023047257379, -122.436460093962) | 13 | 9 | 1 | 57 | 17 | ||
25637 | 76093 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 3x3 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
27553 | 97723 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
27818 | 98647 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 12 | 5x5 | 6002751.94545 | 2119240.19821 | 37.7991845449763 | -122.434585229619 | (37.7991845449763, -122.434585229619) | 13 | 9 | 1 | 57 | 17 | ||
30715 | 73286 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
36405 | 98645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | 5x5 | 6002788.88101 | 2119245.38589 | 37.7992008856766 | -122.434457791187 | (37.7992008856766, -122.434457791187) | 13 | 9 | 1 | 57 | 17 | ||
37719 | 81999 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50638 | 6005960.45556 | 2120727.09731 | 37.8034488081703 | -122.423588442877 | (37.8034488081703, -122.423588442877) | 5 | 9 | 1 | 28858 | 32 |
38172 | 34688 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 7 | 3x3 | Permit Number 38352 | 6002815.38185 | 2119347.35443 | 37.7994823689702 | -122.434373383533 | (37.7994823689702, -122.434373383533) | 13 | 9 | 1 | 57 | 17 |
38478 | 98628 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x4 | 6002274.71062 | 2120096.76485 | 37.8015093491298 | -122.43629795789 | (37.8015093491298, -122.43629795789) | 13 | 9 | 1 | 57 | 17 | ||
40234 | 98607 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6002988.21052 | 2116859.68166 | 37.7926616713417 | -122.433597452086 | (37.7926616713417, -122.433597452086) | 13 | 9 | 1 | 29490 | 27 | ||
43511 | 98646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 8 | 5x5 | 6002771.23879 | 2119243.65965 | 37.7991951444108 | -122.434518715761 | (37.7991951444108, -122.434518715761) | 13 | 9 | 1 | 57 | 17 | ||
44945 | 99261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3099X Polk St | 1 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x6 | 6005936.6 | 2121383.7 | 37.8052503240173 | -122.42371770971 | (37.8052503240173, -122.42371770971) | 5 | 1 | 1 | 28858 | 32 | ||
45053 | 98657 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | 5x5 | 6002607.56666 | 2119218.59599 | 37.7991170337862 | -122.435083283187 | (37.7991170337862, -122.435083283187) | 13 | 9 | 1 | 57 | 17 | ||
46233 | 98631 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 4x4 | 6002262.16905 | 2120180.85898 | 37.8017395368973 | -122.436347379249 | (37.8017395368973, -122.436347379249) | 13 | 9 | 1 | 57 | 17 | ||
48885 | 98651 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2110 Greenwich St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 23 | 5x5 | 6002674.17203 | 2119228.66956 | 37.7991484749737 | -122.434853527066 | (37.7991484749737, -122.434853527066) | 13 | 9 | 1 | 57 | 17 | ||
49136 | 42633 | DPW Maintained 1 | Tristania conferta :: 61 | 1651 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2016 02:56:00 PM | 3 | 5x5 | Permit Number 45045 | 6005048.16251 | 2118816.23898 | 37.7981505449739 | -122.426609321383 | (37.7981505449739, -122.426609321383) | 13 | 9 | 1 | 57 | 17 |
49823 | 98650 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | 5x5 | 6002693.158 | 2119231.97091 | 37.7991586175436 | -122.434788065428 | (37.7991586175436, -122.434788065428) | 13 | 9 | 1 | 57 | 17 | ||
52590 | 73289 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 10 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
56368 | 34692 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002825.2019 | 2119271.55666 | 37.7992748054477 | -122.434333980647 | (37.7992748054477, -122.434333980647) | 13 | 9 | 1 | 57 | 17 |
58686 | 98656 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 8 | 5x5 | 6002629.88193 | 2119221.45898 | 37.7991261619004 | -122.435006269744 | (37.7991261619004, -122.435006269744) | 13 | 9 | 1 | 57 | 17 | ||
59247 | 98633 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002258.36283 | 2120214.87059 | 37.8018327075615 | -122.436362986088 | (37.8018327075615, -122.436362986088) | 13 | 9 | 1 | 57 | 17 | ||
60137 | 98622 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3500X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 6x6 | 6002297.34528 | 2119958.59074 | 37.8011312453645 | -122.436209738003 | (37.8011312453645, -122.436209738003) | 13 | 9 | 1 | 57 | 17 | ||
62685 | 98637 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6002243.51572 | 2120296.51697 | 37.8020560434066 | -122.436420210829 | (37.8020560434066, -122.436420210829) | 13 | 9 | 1 | 57 | 17 | ||
63052 | 98617 | DPW Maintained 1 | Vitex lucens :: Puriri tree 492 | 2501X Franklin St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6005326.63971 | 2118722.15466 | 37.7979079528477 | -122.425639007743 | (37.7979079528477, -122.425639007743) | 13 | 9 | 1 | 57 | 17 | ||
63809 | 99258 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5995889.58772 | 2113188.82138 | 37.7821771504315 | -122.45789304424 | (37.7821771504315, -122.45789304424) | 11 | 6 | 1 | 54 | 31 | ||
64478 | 98626 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3500X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 6x6 | 6002283.11168 | 2120054.94147 | 37.8013949904512 | -122.436265891653 | (37.8013949904512, -122.436265891653) | 13 | 9 | 1 | 57 | 17 | ||
65139 | 97730 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | Permit Number 50638 | 6005803.34745 | 2120703.57786 | 37.8033753605476 | -122.424130448959 | (37.8033753605476, -122.424130448959) | 5 | 9 | 1 | 28858 | 32 | |
66536 | 98615 | DPW Maintained 1 | Vitex lucens :: Puriri tree 492 | 2501X Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6005320.03726 | 2118764.37328 | 37.7980235013495 | -122.42566486054 | (37.7980235013495, -122.42566486054) | 13 | 9 | 1 | 57 | 17 | ||
71113 | 42638 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2016 02:49:00 PM | 3 | 5x5 | Permit Number 42688 | 6005231.45083 | 2118842.40752 | 37.7982327574016 | -122.425976953174 | (37.7982327574016, -122.425976953174) | 13 | 9 | 1 | 57 | 17 |
71791 | 76065 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 4x4 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
73331 | 97736 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2017 12:02:00 PM | 3 | 3x3 | Permit Number 50638 | 6005674.32361 | 2120686.81612 | 37.8033220514443 | -122.424575748272 | (37.8033220514443, -122.424575748272) | 5 | 9 | 1 | 28858 | 32 |
74212 | 93121 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151X Palm Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 5995892.67419 | 2113127.59534 | 37.7820092173573 | -122.457877934554 | (37.7820092173573, -122.457877934554) | 11 | 6 | 1 | 54 | 31 | ||
76994 | 82000 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50638 | 6005983.68719 | 2120729.63993 | 37.8034571008393 | -122.423508229633 | (37.8034571008393, -122.423508229633) | 5 | 9 | 1 | 28858 | 32 |
77923 | 256355 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
79131 | 97722 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
82737 | 42644 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 10 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
83123 | 98639 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002240.75278 | 2120332.50299 | 37.8021546945469 | -122.436432348976 | (37.8021546945469, -122.436432348976) | 13 | 9 | 1 | 57 | 17 | ||
83270 | 98613 | DPW Maintained 1 | Vitex lucens :: Puriri tree 492 | 2501X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6005313.74464 | 2118810.30564 | 37.7981492643346 | -122.425689905776 | (37.7981492643346, -122.425689905776) | 13 | 9 | 1 | 57 | 17 | ||
85175 | 93633 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53266 | 5995881.0393 | 2113432.55638 | 37.7828458906338 | -122.457940261495 | (37.7828458906338, -122.457940261495) | 11 | 6 | 1 | 54 | 31 |
90658 | 98640 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6002237.13778 | 2120351.54005 | 37.8022067598879 | -122.43644622191 | (37.8022067598879, -122.43644622191) | 13 | 9 | 1 | 57 | 17 | ||
91578 | 97725 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | |||
92129 | 98641 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002235.03073 | 2120370.79549 | 37.8022595105266 | -122.436454892273 | (37.8022595105266, -122.436454892273) | 13 | 9 | 1 | 57 | 17 | ||
93651 | 98648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | 5x5 | 6002730.0885 | 2119237.75472 | 37.7991765949935 | -122.434660687245 | (37.7991765949935, -122.434660687245) | 13 | 9 | 1 | 57 | 17 | ||
95651 | 73287 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
95696 | 99259 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5995893.7088 | 2113098.76002 | 37.7819301026873 | -122.457872268014 | (37.7819301026873, -122.457872268014) | 11 | 6 | 1 | 54 | 31 | ||
99986 | 42634 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2016 02:52:00 PM | 3 | 5x5 | Permit Number 45045 | 6005069.31611 | 2118819.49736 | 37.7981606875253 | -122.426536355794 | (37.7981606875253, -122.426536355794) | 13 | 9 | 1 | 57 | 17 |
101654 | 42639 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1651 Union St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/2014 12:00:00 AM | 8 | 3x3 | Permit Number 42688 | 6005258.41678 | 2118846.41372 | 37.7982452813572 | -122.425883928195 | (37.7982452813572, -122.425883928195) | 13 | 9 | 1 | 57 | 17 |
101801 | 256358 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6005778.11415 | 2120709.05822 | 37.8033889834786 | -122.424218159845 | (37.8033889834786, -122.424218159845) | 5 | 9 | 1 | 28858 | 32 | |||
102172 | 97726 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 4x4 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | ||
105467 | 98620 | DPW Maintained 1 | Vitex lucens :: Puriri tree 492 | 2501X Franklin St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6005340.01128 | 2118634.45898 | 37.79766791839 | -122.42558649364 | (37.79766791839, -122.42558649364) | 13 | 9 | 1 | 57 | 17 | ||
108543 | 67860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 01/20/1993 12:00:00 AM | 5 | 5x5 | Permit Number 31536 | 6002806.21719 | 2119247.92289 | 37.7992088356751 | -122.434397983605 | (37.7992088356751, -122.434397983605) | 13 | 9 | 1 | 57 | 17 |
110284 | 98635 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002251.83785 | 2120250.68488 | 37.8019306734253 | -122.436388130233 | (37.8019306734253, -122.436388130233) | 13 | 9 | 1 | 57 | 17 | ||
110307 | 42646 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X GREEN ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 10 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
110693 | 98618 | DPW Maintained 1 | Vitex lucens :: Puriri tree 492 | 2501X Franklin St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6005334.04674 | 2118673.64199 | 37.797775167941 | -122.425609922762 | (37.797775167941, -122.425609922762) | 13 | 9 | 1 | 57 | 17 | ||
112087 | 98638 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002513 | 2120207.2 | 37.8018261113234 | -122.435481274987 | (37.8018261113234, -122.435481274987) | 13 | 9 | 1 | 57 | 17 | ||
113652 | 76212 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 3x3 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
114136 | 98612 | DPW Maintained 1 | Vitex lucens :: Puriri tree 492 | 2501X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6005312.4459 | 2118826.60748 | 37.7981939516456 | -122.425695560696 | (37.7981939516456, -122.425695560696) | 13 | 9 | 1 | 57 | 17 | ||
115106 | 98606 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 4.5x4.5 | 6003043.17178 | 2116866.41104 | 37.7926832667819 | -122.433407765274 | (37.7926832667819, -122.433407765274) | 13 | 9 | 1 | 29490 | 27 | ||
123087 | 34690 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38352 | 6002819.05677 | 2119313.26082 | 37.7993889653989 | -122.434358228162 | (37.7993889653989, -122.434358228162) | 13 | 9 | 1 | 57 | 17 |
123904 | 98659 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2110 Greenwich St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 20 | 7x7 | 6002683.8 | 2119245.6 | 37.7991955081761 | -122.434821422435 | (37.7991955081761, -122.434821422435) | 13 | 9 | 1 | 57 | 17 | ||
125279 | 98621 | DPW Maintained 1 | Vitex lucens :: Puriri tree 492 | 2501X Franklin St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6005341.92436 | 2118613.95929 | 37.797611739554 | -122.425578414124 | (37.797611739554, -122.425578414124) | 13 | 9 | 1 | 57 | 17 | ||
128028 | 98619 | DPW Maintained 1 | Vitex lucens :: Puriri tree 492 | 2501X Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6005336.89801 | 2118653.35554 | 37.7977196276222 | -122.425598612003 | (37.7977196276222, -122.425598612003) | 13 | 9 | 1 | 57 | 17 | ||
131177 | 98630 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002266.09398 | 2120152.58331 | 37.8016621223571 | -122.436331772404 | (37.8016621223571, -122.436331772404) | 13 | 9 | 1 | 57 | 17 | ||
132120 | 98636 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3500X Fillmore St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 6x6 | 6002249.05694 | 2120273.69699 | 37.8019937006086 | -122.436399401415 | (37.8019937006086, -122.436399401415) | 13 | 9 | 1 | 57 | 17 | ||
133386 | 98658 | DPW Maintained 1 | Tree(s) :: 17 | 2110 Greenwich St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 06/20/2014 12:00:00 AM | 6x6 | Permit Number 772915 | 6002683.8 | 2119245.6 | 37.7991955081761 | -122.434821422435 | (37.7991955081761, -122.434821422435) | 13 | 9 | 1 | 57 | 17 | |
136269 | 76137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 3x3 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
136350 | 59884 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/20/1981 12:00:00 AM | 24 | 3x3 | Permit Number 19349 | 6004500.5356676 | 2116743.15343908 | 37.7924274060317 | -122.42835643846 | (37.7924274060317, -122.42835643846) | 13 | 9 | 1 | 28858 | 27 |
137518 | 98655 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 6 | 5x5 | 6002650.75991 | 2119226.56813 | 37.7991413757273 | -122.434934390513 | (37.7991413757273, -122.434934390513) | 13 | 9 | 1 | 57 | 17 | ||
139610 | 98609 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6003008.4 | 2116877.5 | 37.7927117414369 | -122.433528869724 | (37.7927117414369, -122.433528869724) | 13 | 9 | 1 | 29490 | 27 | ||
140661 | 98604 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6003077.63265 | 2116870.32542 | 37.792695969686 | -122.433288809234 | (37.792695969686, -122.433288809234) | 13 | 9 | 1 | 29490 | 27 | ||
142043 | 97731 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1150 Francisco St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | Permit Number 50638 | 6005778.11415 | 2120709.05822 | 37.8033889834786 | -122.424218159845 | (37.8033889834786, -122.424218159845) | 5 | 9 | 1 | 28858 | 32 | |
142139 | 34693 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002813.73545 | 2119366.57801 | 37.799535058456 | -122.434380455813 | (37.799535058456, -122.434380455813) | 13 | 9 | 1 | 57 | 17 |
142206 | 99260 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2015 03:10:00 PM | 3 | 3x3 | 5995894.58408 | 2113075.36458 | 37.7818659153243 | -122.457867546462 | (37.7818659153243, -122.457867546462) | 11 | 6 | 1 | 54 | 31 | |
143470 | 98602 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6003137.34298 | 2116882.04608 | 37.7927315387907 | -122.433083047059 | (37.7927315387907, -122.433083047059) | 13 | 9 | 1 | 29490 | 27 | ||
147715 | 81997 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50638 | 6005918.11487 | 2120722.35908 | 37.8034334081868 | -122.42373462766 | (37.8034334081868, -122.42373462766) | 5 | 9 | 1 | 28858 | 32 |
149719 | 98608 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6002968.64851 | 2116857.31006 | 37.7926540495901 | -122.433664967757 | (37.7926540495901, -122.433664967757) | 13 | 9 | 1 | 29490 | 27 | ||
150387 | 98603 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6003120.00759 | 2116875.00163 | 37.7927112131931 | -122.433142524628 | (37.7927112131931, -122.433142524628) | 13 | 9 | 1 | 29490 | 27 | ||
151130 | 97735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Francisco St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2016 02:46:00 PM | 3 | 3x3 | Permit Number 50638 | 6005694.979 | 2120690.49004 | 37.8033333055591 | -122.424504530974 | (37.8033333055591, -122.424504530974) | 5 | 9 | 1 | 28858 | 32 |
151965 | 98629 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 6x6 | 6002271.75666 | 2120123.52327 | 37.8015826528763 | -122.436310096028 | (37.8015826528763, -122.436310096028) | 13 | 9 | 1 | 57 | 17 | ||
152683 | 98649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 16 | 5x5 | 6002707.76445 | 2119233.0203 | 37.7991623281478 | -122.434737597267 | (37.7991623281478, -122.434737597267) | 13 | 9 | 1 | 57 | 17 | ||
153204 | 81998 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50638 | 6005939.39797 | 2120724.94139 | 37.8034416999448 | -122.42366116025 | (37.8034416999448, -122.42366116025) | 5 | 9 | 1 | 28858 | 32 |
154771 | 98634 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002253.74096 | 2120233.67924 | 37.8018840885493 | -122.436380326794 | (37.8018840885493, -122.436380326794) | 13 | 9 | 1 | 57 | 17 |
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) );