trees
251 rows where DBH = 3 and qCaretaker_id = 4 sorted by Supervisor Districts
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▼ | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
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 |
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 |
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 |
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 |
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 |
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 |
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 | |
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 | |
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 |
165305 | 93105 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53160 | 5995888.42271 | 2113224.45495 | 37.7822749237882 | -122.457899654053 | (37.7822749237882, -122.457899654053) | 11 | 6 | 1 | 54 | 31 |
3324 | 100985 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 03/23/2016 02:34:00 PM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |
3937 | 98576 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301X Francisco St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:52:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
11581 | 98091 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007129.63323 | 2115568.12393 | 37.7893494826426 | -122.419176280756 | (37.7893494826426, -122.419176280756) | 13 | 9 | 10 | 28858 | 21 | ||
11856 | 107887 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
14472 | 100972 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 450X Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 03/24/2016 07:43:00 AM | 3 | Permit Number 37341 | 6009614 | 2121059.9 | 37.8045681487804 | -122.410968670823 | (37.8045681487804, -122.410968670823) | 3 | 1 | 10 | 308 | 23 | |
17603 | 75990 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 350 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6011912.57037 | 2118781.03793 | 37.7984395708796 | -122.402853834756 | (37.7984395708796, -122.402853834756) | 3 | 1 | 10 | 308 | 23 | ||
20224 | 98090 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007144.43128 | 2115568.9527 | 37.7893525915946 | -122.419125139911 | (37.7893525915946, -122.419125139911) | 13 | 9 | 10 | 28858 | 21 | ||
34474 | 95271 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2245 Jones St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:36:00 PM | 3 | 6x6 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |
36927 | 95272 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2245 Jones St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/08/2011 12:00:00 AM | 3 | 3x3 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |
38733 | 98088 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007178.15894 | 2115574.08384 | 37.7893685797349 | -122.419008809929 | (37.7893685797349, -122.419008809929) | 13 | 9 | 10 | 28858 | 21 | ||
66219 | 100977 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 450X Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | Permit Number 37341 | 6009542.7178 | 2120879.1139 | 37.8040677578058 | -122.411202572075 | (37.8040677578058, -122.411202572075) | 3 | 1 | 10 | 308 | 23 | ||
102454 | 131001 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6007906.15602 | 2120261.72441 | 37.8022806446072 | -122.416822257668 | (37.8022806446072, -122.416822257668) | 5 | 1 | 10 | 308 | 32 | |||
150198 | 98089 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007160.90241 | 2115572.1732 | 37.7893623618415 | -122.419068380099 | (37.7893623618415, -122.419068380099) | 13 | 9 | 10 | 28858 | 21 | ||
152258 | 98578 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/26/2016 09:53:00 AM | 3 | 6x7 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
152503 | 98570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/26/2016 09:47:00 AM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
156452 | 98568 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:55:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
171481 | 107886 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
188027 | 100980 | DPW Maintained 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 05/03/2013 12:00:00 AM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |
192694 | 95270 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2245 Jones St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:41:00 PM | 3 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | ||
40750 | 30740 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004184.33514 | 2109844.20882 | 37.7734667268354 | -122.428958416203 | (37.7734667268354, -122.428958416203) | 7 | 9 | 11 | 28852 | 10 |
41872 | 41128 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2049 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) | 15 | 5 | 11 | 29492 | 16 |
72831 | 30743 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
97737 | 30738 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004189.67673 | 2109821.80854 | 37.773405523492 | -122.428938341537 | (37.773405523492, -122.428938341537) | 7 | 9 | 11 | 28852 | 10 |
106593 | 41127 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2049 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) | 15 | 5 | 11 | 29492 | 16 |
117961 | 99675 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
132145 | 41129 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2049 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) | 15 | 5 | 11 | 29492 | 16 |
150789 | 99672 | DPW Maintained 1 | Shrub :: Shrub 66 | 1250X Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
175889 | 99669 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x6 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
180042 | 99682 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 165 Grattan St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
4799 | 95481 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | 11 | 6 | 2 | 55 | 26 | |
11601 | 95514 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | 11 | 6 | 2 | 55 | 26 | ||
18124 | 95460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986585.7747 | 2111417.7398 | 37.7767753504668 | -122.489949313769 | (37.7767753504668, -122.489949313769) | 11 | 6 | 2 | 55 | 26 | |
19099 | 113032 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 251 06th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5993973.41927 | 2113841.38508 | 37.7838586397785 | -122.464569471656 | (37.7838586397785, -122.464569471656) | 11 | 6 | 2 | 54 | 11 | |||
33781 | 95450 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986571.54012 | 2111769.53516 | 37.7777404494553 | -122.49002443627 | (37.7777404494553, -122.49002443627) | 11 | 6 | 2 | 55 | 26 | ||
44906 | 95475 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986561.73612 | 2112070.55828 | 37.7785664008394 | -122.490080498329 | (37.7785664008394, -122.490080498329) | 11 | 6 | 2 | 55 | 26 | ||
51466 | 95482 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986568.36529 | 2111879.34223 | 37.7780417630679 | -122.490043497613 | (37.7780417630679, -122.490043497613) | 11 | 6 | 2 | 55 | 26 | ||
53024 | 99347 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986832.70752 | 2113173.16715 | 37.7816096708126 | -122.489224205331 | (37.7816096708126, -122.489224205331) | 11 | 6 | 2 | 55 | 26 | ||
64192 | 99336 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986577.60051 | 2112919.49158 | 37.7808982560395 | -122.490088077428 | (37.7808982560395, -122.490088077428) | 11 | 6 | 2 | 55 | 26 | ||
66912 | 95490 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986007.65609 | 2111463.21002 | 37.7768664240251 | -122.491952519112 | (37.7768664240251, -122.491952519112) | 11 | 6 | 2 | 55 | 26 | |||
85468 | 95510 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500X 32nd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:35:00 PM | 3 | 3x3 | 5985969.9 | 2112493.2 | 37.7796922752829 | -122.492158984519 | (37.7796922752829, -122.492158984519) | 11 | 6 | 2 | 55 | 26 | ||
93459 | 95462 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986590.67553 | 2111282.39545 | 37.7764040194223 | -122.489922403821 | (37.7764040194223, -122.489922403821) | 11 | 6 | 2 | 55 | 26 | ||
103512 | 95456 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986576.02446 | 2111660.34524 | 37.7774409068096 | -122.490000890521 | (37.7774409068096, -122.490000890521) | 11 | 6 | 2 | 55 | 26 | ||
104893 | 95486 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986007.39345 | 2111549.75354 | 37.7771040325177 | -122.491959800837 | (37.7771040325177, -122.491959800837) | 11 | 6 | 2 | 55 | 26 | |||
105937 | 95458 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986582.44659 | 2111474.61787 | 37.7769313271764 | -122.489965010922 | (37.7769313271764, -122.489965010922) | 11 | 6 | 2 | 55 | 26 | |
113363 | 95502 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500X 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985980.32699 | 2112340.5385 | 37.7792737200362 | -122.492111670045 | (37.7792737200362, -122.492111670045) | 11 | 6 | 2 | 55 | 26 | |||
113585 | 95463 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986592.12306 | 2111264.12941 | 37.7763539505765 | -122.489916052727 | (37.7763539505765, -122.489916052727) | 11 | 6 | 2 | 55 | 26 | |
115615 | 95468 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 535X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 53267 | 5986556.7 | 2112284.6 | 37.7791538043677 | -122.490113668043 | (37.7791538043677, -122.490113668043) | 11 | 6 | 2 | 55 | 26 |
118940 | 95491 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986009.30138 | 2111441.61533 | 37.7768072273274 | -122.491945237383 | (37.7768072273274, -122.491945237383) | 11 | 6 | 2 | 55 | 26 | |||
123758 | 95505 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985982.87909 | 2112248.55872 | 37.7790213190615 | -122.492096067193 | (37.7790213190615, -122.492096067193) | 11 | 6 | 2 | 55 | 26 | |||
125188 | 95464 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986592.75422 | 2111242.97331 | 37.7762958987751 | -122.489912313045 | (37.7762958987751, -122.489912313045) | 11 | 6 | 2 | 55 | 26 | |
152325 | 95504 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500X 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985982.4173 | 2112269.22924 | 37.7790780474023 | -122.492099187045 | (37.7790780474023, -122.492099187045) | 11 | 6 | 2 | 55 | 26 | |||
160497 | 95509 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:37:00 PM | 3 | 3x3 | 5985988.58257 | 2112092.73248 | 37.7785937981587 | -122.492064860632 | (37.7785937981587, -122.492064860632) | 11 | 6 | 2 | 55 | 26 | ||
164971 | 95474 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986559.68186 | 2112141.60911 | 37.7787613662348 | -122.490092832202 | (37.7787613662348, -122.490092832202) | 11 | 6 | 2 | 55 | 26 | ||
166601 | 95494 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986000.13497 | 2111717.29406 | 37.7775636267397 | -122.491997248036 | (37.7775636267397, -122.491997248036) | 11 | 6 | 2 | 55 | 26 | |||
174849 | 47197 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2899X Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 3 | 3x3 | 5986581.22601267 | 2112881.07204474 | 37.7807929786872 | -122.490072708464 | (37.7807929786872, -122.490072708464) | 11 | 6 | 2 | 55 | 26 | |
177073 | 95511 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:32:00 PM | 3 | 3x3 | 5985988.37339 | 2112068.78219 | 37.7785280252799 | -122.492063820389 | (37.7785280252799, -122.492063820389) | 11 | 6 | 2 | 55 | 26 | ||
181422 | 99357 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986839.06552 | 2112970.96623 | 37.7810548559101 | -122.489187339385 | (37.7810548559101, -122.489187339385) | 11 | 6 | 2 | 55 | 26 | ||
191041 | 95487 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986008.46306 | 2111529.36899 | 37.7770481248733 | -122.491954599624 | (37.7770481248733, -122.491954599624) | 11 | 6 | 2 | 55 | 26 | |||
3628 | 76755 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x12 | 5983093.5463 | 2104662.8676 | 37.758023867602 | -122.501529951702 | (37.758023867602, -122.501529951702) | 1 | 8 | 3 | 56 | 35 | ||
59100 | 46948 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 3 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
15793 | 42348 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
37102 | 77218 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499X Hearst Ave | 22 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 3 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
37151 | 77198 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 3 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
160859 | 42357 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 3 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
2474 | 256556 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 5 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:18:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
19907 | 102028 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
20806 | 102022 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
34431 | 256554 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 3 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:10:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
34835 | 71106 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 4235 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2015 07:32:00 AM | 3 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | 2 | 4 | 5 | 28862 | 3 | |
35858 | 102033 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
38321 | 102024 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
44657 | 99552 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12/28/2016 06:02:00 AM | 3 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | |
48405 | 102030 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
67077 | 113468 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 06/21/2016 02:14:00 PM | 3 | 6x7 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
67735 | 99550 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 200X Henry St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/19/2016 04:45:00 AM | 3 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | |
76443 | 102025 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
78271 | 73518 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2015 07:36:00 AM | 3 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | 2 | 4 | 5 | 28862 | 3 | |
81910 | 225512 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 01/08/2019 12:00:00 AM | 3 | 6x6 | 6004203.25115 | 2106055.40872 | 37.7630646689183 | -122.428622853063 | (37.7630646689183, -122.428622853063) | 8 | 4 | 5 | 28862 | 3 | ||
84100 | 77325 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/18/1988 12:00:00 AM | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | |
90011 | 256555 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 4 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:48:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
112801 | 96209 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 201X Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/28/2012 12:00:00 AM | 3 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.436964804087 | (37.759113460692, -122.436964804087) | 2 | 4 | 5 | 28862 | 3 |
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) );