Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68988 | 68988 | 190930 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 9ft | 6015277.62058 | 2102029.1535 | 37.752629945825795 | -122.39003876447799 | (37.7526299458258, -122.390038764478) | |||
69219 | 69219 | 193379 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 500 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 9ft | 6012632.72668 | 2105144.08354 | 37.7610358181789 | -122.39940398859699 | (37.7610358181789, -122.399403988597) | |||
69302 | 69302 | 222965 | Undocumented 2 | Corymbia maculata :: Spotted Gum 165 | 1201 San Jose Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 9ft | 6004149.63466 | 2095858.37478 | 37.7350629514011 | -122.428081582617 | (37.7350629514011, -122.428081582617) | |||
69873 | 69873 | 202066 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1 Hwy 101 S On Ramp | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 9ft | 6012981.8772 | 2090193.58175 | 37.7200043379011 | -122.39714806353001 | (37.7200043379011, -122.39714806353) | |||
70006 | 70006 | 175852 | Undocumented 2 | Citrus aurantifolia 'Bearss' :: Seedless Lime 268 | 981 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 5998486.05845 | 2089261.9262299999 | 37.7166285851125 | -122.447187923197 | (37.7166285851125, -122.447187923197) | |||
70440 | 70440 | 194604 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 500 Wisconsin St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 9ft | 6012630.87805 | 2105129.76973 | 37.760996412581704 | -122.39940937733999 | (37.7609964125817, -122.39940937734) | |||
71415 | 71415 | 226675 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 127 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 9ft | 6005684.59904 | 2100199.28079 | 37.7470688251863 | -122.423083100303 | (37.7470688251863, -122.423083100303) | |||
71992 | 71992 | 192382 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 9ft | 6015926.910759999 | 2106504.64628 | 37.7649546850211 | -122.38810568434499 | (37.7649546850211, -122.388105684345) | |||
72093 | 72093 | 198060 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6016003.71174 | 2105110.97053 | 37.761132205694295 | -122.387742798886 | (37.7611322056943, -122.387742798886) | |||
73184 | 73184 | 132229 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3599 Jackson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 9ft | 5997088.40366 | 2115983.62327 | 37.7899197346433 | -122.45394760361602 | (37.7899197346433, -122.453947603616) | |||
73631 | 73631 | 211163 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 5995808.0564 | 2099301.9235400003 | 37.744042614569295 | -122.45717023961001 | (37.7440426145693, -122.45717023961) | |||
74510 | 74510 | 131861 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3640 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 5998876.901959999 | 2121298.6839099997 | 37.8046158502946 | -122.448142451919 | (37.8046158502946, -122.448142451919) | |||
74523 | 74523 | 194587 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 37 Maddux Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 9ft | 6012781.54528 | 2095521.68187 | 37.7346230570026 | -122.398214166653 | (37.7346230570026, -122.398214166653) | |||
74607 | 74607 | 189822 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 9ft | 6010499.44736 | 2107381.21521 | 37.767059343243105 | -122.40693979295901 | (37.7670593432431, -122.406939792959) | |||
74642 | 74642 | 119410 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 375 32nd Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 5985887.68292 | 2113265.4589 | 37.78180786995821 | -122.49250029292101 | (37.7818078699582, -122.492500292921) | |||
74696 | 74696 | 192973 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012869.52448 | 2105946.64842 | 37.7632526794011 | -122.39864132394301 | (37.7632526794011, -122.398641323943) | |||
74742 | 74742 | 193451 | Undocumented 2 | Malus :: Crab Apple 235 | 760 De Haro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 9ft | 6012093.60455 | 2104911.13829 | 37.7603661389049 | -122.401252219518 | (37.7603661389049, -122.401252219518) | |||
75383 | 75383 | 125524 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6011207.6846199995 | 2120726.9389400003 | 37.8037431562814 | -122.40543008395201 | (37.8037431562814, -122.405430083952) | |||
76465 | 76465 | 126074 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 280 Euclid Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 9ft | 5997931.91034 | 2113961.1395099997 | 37.7844148567016 | -122.450883266276 | (37.7844148567016, -122.450883266276) | |||
76839 | 76839 | 210860 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 458 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 5998392.85645 | 2095276.6341799998 | 37.7331382439186 | -122.447942868994 | (37.7331382439186, -122.447942868994) | |||
77277 | 77277 | 118638 | Undocumented 2 | Ilex spp :: Holly Species 163 | 489 45th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 9ft | 5981883.80409 | 2112496.71277 | 37.779462211155 | -122.506294581666 | (37.779462211155, -122.506294581666) | |||
93610 | 93610 | 192378 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 9ft | 6015920.68395 | 2106620.6403200002 | 37.765272834597894 | -122.388135317012 | (37.7652728345979, -122.388135317012) | |||
115432 | 115432 | 210682 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100x Idora Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 9ft | 5995339.29404 | 2099412.4410200003 | 37.7443191354124 | -122.4587991034 | (37.7443191354124, -122.4587991034) | |||
129709 | 129709 | 131323 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 9ft | 5996254.50366 | 2114867.62545 | 37.7868076567964 | -122.456752060266 | (37.7868076567964, -122.456752060266) | |||
131686 | 131686 | 190788 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1701 19th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 6012435.911169999 | 2105136.5588700003 | 37.7610041854195 | -122.400084163877 | (37.7610041854195, -122.400084163877) | |||
132787 | 132787 | 202063 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1 Hwy 101 S On Ramp | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 9ft | 6012938.96015 | 2090178.7208200002 | 37.7199611434755 | -122.3972953725 | (37.7199611434755, -122.3972953725) | |||
132813 | 132813 | 201611 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 98 Jerrold Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 9ft | 6020793.34161 | 2092957.5019 | 37.7280253184122 | -122.37033713297501 | (37.7280253184122, -122.370337132975) | |||
133930 | 133930 | 198057 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6015999.46733 | 2105182.54146 | 37.7613284890375 | -122.38776247247499 | (37.7613284890375, -122.387762472475) | |||
134543 | 134543 | 189984 | Undocumented 2 | Cercis occidentalis :: Western Redbud 246 | 2001 Revere Ave | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6012475.97844 | 2096310.0717099998 | 37.73677078553071 | -122.39932594815599 | (37.7367707855307, -122.399325948156) | |||
134715 | 134715 | 211077 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 100x Idora Ave | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 9ft | 5995433.6180300005 | 2099390.76131 | 37.7442650295015 | -122.45847138416799 | (37.7442650295015, -122.458471384168) | |||
134932 | 134932 | 202258 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 9ft | 6013221.11687 | 2093370.23706 | 37.7287401067524 | -122.396543647186 | (37.7287401067524, -122.396543647186) | |||
135950 | 135950 | 192385 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 9ft | 6015934.883119999 | 2106386.4235799997 | 37.7646305127095 | -122.388069858948 | (37.7646305127095, -122.388069858948) | |||
136941 | 136941 | 211477 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100x Idora Ave | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | Width 9ft | 5995466.33774 | 2099382.46662 | 37.7442441346666 | -122.45835764690001 | (37.7442441346666, -122.4583576469) | |||
137327 | 137327 | 214332 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 100x Idora Ave | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 9ft | 5995718.21124 | 2099321.8453599997 | 37.7440921546362 | -122.457482343055 | (37.7440921546362, -122.457482343055) | |||
137366 | 137366 | 225845 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 38 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 9ft | 6006048.77626 | 2104063.35692 | 37.7576992326564 | -122.42209827161301 | (37.7576992326564, -122.422098271613) | |||
138133 | 138133 | 202067 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 1 Hwy 101 S On Ramp | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6013024.681059999 | 2090205.86512 | 37.720040448378704 | -122.397000965021 | (37.7200404483787, -122.397000965021) | |||
146356 | 146356 | 199366 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300x Division St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 9ft | 6009946.07759 | 2108167.65587 | 37.769187748042704 | -122.40890931543801 | (37.7691877480427, -122.408909315438) | |||
146780 | 146780 | 214408 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Idora Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 9ft | 5995751.653580001 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | |||
146834 | 146834 | 190932 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 9ft | 6015229.59957 | 2102026.97334 | 37.7526212961411 | -122.390204678629 | (37.7526212961411, -122.390204678629) | |||
146878 | 146878 | 201557 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 9ft | 6019843.77362 | 2093685.4029299999 | 37.7299718344327 | -122.373670245296 | (37.7299718344327, -122.373670245296) | |||
147053 | 147053 | 226002 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 169 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6005477.49545 | 2100188.99105 | 37.7470288826965 | -122.42379851640499 | (37.7470288826965, -122.423798516405) | |||
147435 | 147435 | 194484 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2208 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 9ft | 6012170.679769999 | 2101904.59247 | 37.7521151235314 | -122.40077442501699 | (37.7521151235314, -122.400774425017) | |||
147673 | 147673 | 194031 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1101 25th St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 9ft | 6015324.74216 | 2102030.33526 | 37.7526358040022 | -122.38987589096901 | (37.7526358040022, -122.389875890969) | |||
147873 | 147873 | 189982 | Undocumented 2 | Cercis occidentalis :: Western Redbud 246 | 2001 Revere Ave | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6012448.34075 | 2096330.25882 | 37.7368246747079 | -122.39942292113301 | (37.7368246747079, -122.399422921133) | |||
148329 | 148329 | 192967 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012878.79115 | 2105782.39393 | 37.7628021891935 | -122.398597746415 | (37.7628021891935, -122.398597746415) | |||
148511 | 148511 | 212576 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100x Idora Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995353.74805 | 2099410.49817 | 37.74431463161879 | -122.458748984199 | (37.7443146316188, -122.458748984199) | |||
148740 | 148740 | 194781 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 37 Maddux Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 9ft | 6012782.01516 | 2095526.39332 | 37.734636019838 | -122.398212872552 | (37.734636019838, -122.398212872552) | |||
149322 | 149322 | 123178 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 755 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 9ft | 5992851.1981 | 2110319.1636799998 | 37.77412281782561 | -122.46819559495 | (37.7741228178256, -122.46819559495) | |||
150923 | 150923 | 204192 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 442 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 5998503.82131 | 2095275.63385 | 37.7331418394226 | -122.44755916334199 | (37.7331418394226, -122.447559163342) | |||
151463 | 151463 | 224192 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1200 San Jose Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | Width 9ft | 6004059.13086 | 2095959.7871599998 | 37.7353362859469 | -122.42840171247101 | (37.7353362859469, -122.428401712471) | |||
151482 | 151482 | 189815 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 9ft | 6010361.40821 | 2107373.60835 | 37.7670307313104 | -122.407416715103 | (37.7670307313104, -122.407416715103) | |||
152760 | 152760 | 232869 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 301 Putnam St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 9ft | 6009077.71064 | 2095875.53633 | 37.7353876606063 | -122.411044607225 | (37.7353876606063, -122.411044607225) | |||
152930 | 152930 | 132679 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 16 Heather Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 5997380.732580001 | 2114357.4428 | 37.78547143241121 | -122.452818754791 | (37.7854714324112, -122.452818754791) | |||
154396 | 154396 | 124182 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 18 Almaden Ct | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 9ft | 5995869.666259999 | 2112609.07722 | 37.780584182666395 | -122.45791999637699 | (37.7805841826664, -122.457919996377) | |||
155889 | 155889 | 187486 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 9ft | 6006768.10436 | 2086582.6135 | 37.7097415013489 | -122.41837109707 | (37.7097415013489, -122.41837109707) | |||
155898 | 155898 | 192971 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012871.7630900005 | 2105891.87126 | 37.7631023981666 | -122.398629737092 | (37.7631023981666, -122.398629737092) | |||
156731 | 156731 | 198053 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6015994.50717 | 2105252.5943299998 | 37.761520564453896 | -122.387784515751 | (37.7615205644539, -122.387784515751) | |||
156796 | 156796 | 191266 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1721 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 9ft | 6014437.69224 | 2094855.17275 | 37.7328850694924 | -122.39244165855499 | (37.7328850694924, -122.392441658555) | |||
157169 | 157169 | 187487 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 9ft | 6006739.4924099995 | 2086592.2880099998 | 37.709766454838096 | -122.418470670891 | (37.7097664548381, -122.418470670891) | |||
157332 | 157332 | 192376 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 6015917.31296 | 2106690.54623 | 37.7654645943419 | -122.388151855539 | (37.7654645943419, -122.388151855539) | |||
157488 | 157488 | 192968 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012876.85912 | 2105807.00697 | 37.762869663519 | -122.39860615594999 | (37.762869663519, -122.39860615595) | |||
157593 | 157593 | 124179 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 8X Almaden Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 9ft | 5995876.0 | 2112606.0 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | |||
157732 | 157732 | 189820 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 9ft | 6010468.25457 | 2107379.34073 | 37.7670524508424 | -122.40704755241 | (37.7670524508424, -122.40704755241) | |||
158033 | 158033 | 225852 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 58 Liberty St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 9ft | 6005926.4648400005 | 2104057.0106 | 37.7576749077845 | -122.422520824396 | (37.7576749077845, -122.422520824396) | |||
158785 | 158785 | 189988 | Undocumented 2 | Cercis occidentalis :: Western Redbud 246 | 2001 Revere Ave | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6012609.72443 | 2096214.3207900003 | 37.736515326817 | -122.39885680871201 | (37.736515326817, -122.398856808712) | |||
159160 | 159160 | 124582 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3969 Washington St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 9ft | 5995697.73054 | 2115463.76534 | 37.7884125114933 | -122.458721526276 | (37.7884125114933, -122.458721526276) | |||
159189 | 159189 | 234375 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 9ft | 6004995.06327 | 2105009.72546 | 37.760238249920604 | -122.425809806971 | (37.7602382499206, -122.425809806971) | |||
159281 | 159281 | 126073 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 280 Euclid Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 9ft | 5997937.77739 | 2113961.77772 | 37.784416944922704 | -122.450863014442 | (37.7844169449227, -122.450863014442) | |||
159393 | 159393 | 198054 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6015996.1825 | 2105236.6253 | 37.7614768097219 | -122.387777607167 | (37.7614768097219, -122.387777607167) | |||
159564 | 159564 | 242778 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 9ft | 6006595.78841 | 2109152.55753 | 37.7717038182152 | -122.420567728011 | (37.7717038182152, -122.420567728011) | |||
160138 | 160138 | 125525 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6011203.66326 | 2120729.63027 | 37.8037503211682 | -122.405444189817 | (37.8037503211682, -122.405444189817) | |||
160221 | 160221 | 130561 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 49 Heather Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 9ft | 5997335.31934 | 2114155.38722 | 37.784914038893206 | -122.452961280243 | (37.7849140388932, -122.452961280243) | |||
160429 | 160429 | 192377 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 9ft | 6015920.48189 | 2106647.80141 | 37.7653474018847 | -122.38813791154499 | (37.7653474018847, -122.388137911545) | |||
160560 | 160560 | 234507 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1100 San Jose Ave | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 9ft | 6004787.92016 | 2096687.497 | 37.7373756263678 | -122.425933801003 | (37.7373756263678, -122.425933801003) | |||
160876 | 160876 | 131042 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 3001 Divisadero St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 9ft | 6000473.91869 | 2118638.90202 | 37.797403962867996 | -122.442424767404 | (37.797403962868, -122.442424767404) | |||
160927 | 160927 | 242373 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 6006573.34583 | 2109150.3275 | 37.771696430266 | -122.420645200112 | (37.771696430266, -122.420645200112) | |||
161434 | 161434 | 119408 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 375 32nd Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 5985886.47906 | 2113308.3563599996 | 37.781925583655294 | -122.49250761776301 | (37.7819255836553, -122.492507617763) | |||
161733 | 161733 | 196296 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 383 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 9ft | 6012973.423830001 | 2105290.2988400003 | 37.7614562764103 | -122.398235915848 | (37.7614562764103, -122.398235915848) | |||
161939 | 161939 | 198055 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6015997.74921 | 2105213.0549 | 37.7614121772375 | -122.387770543876 | (37.7614121772375, -122.387770543876) | |||
162022 | 162022 | 131041 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 3001 Divisadero St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 9ft | 6000469.3004 | 2118677.0449099997 | 37.7975084299175 | -122.44244348768 | (37.7975084299175, -122.44244348768) | |||
162455 | 162455 | 195979 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 900 Phelps St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 30 | Width 9ft | 6014704.25324 | 2097268.53042 | 37.739526454869704 | -122.39168875963999 | (37.7395264548697, -122.39168875964) | |||
162650 | 162650 | 192374 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 6015916.946 | 2106720.28142 | 37.765546220411295 | -122.38815520010901 | (37.7655462204113, -122.388155200109) | |||
163006 | 163006 | 228912 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 6002507.65455 | 2108261.418 | 37.769025726184395 | -122.43464508941999 | (37.7690257261844, -122.43464508942) | |||
163978 | 163978 | 232291 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1100 San Jose Ave | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 9ft | 6004778.102000001 | 2096680.6709599998 | 37.737356328728104 | -122.42596726120001 | (37.7373563287281, -122.4259672612) | |||
164075 | 164075 | 241289 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1201 Vermont St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 9ft | 6011466.52977 | 2102070.65758 | 37.7525318019104 | -122.403221176312 | (37.7525318019104, -122.403221176312) | |||
164086 | 164086 | 189216 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1660 La Salle Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 9ft | 6015290.992769999 | 2096384.2824799998 | 37.737131043164794 | -122.38959831162501 | (37.7371310431648, -122.389598311625) | |||
165512 | 165512 | 131040 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 3001 Divisadero St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 9ft | 6000467.64422 | 2118686.84374 | 37.797535240511706 | -122.442449922347 | (37.7975352405117, -122.442449922347) | |||
165743 | 165743 | 225851 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 58 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 9ft | 6005940.80903 | 2104056.71589 | 37.7576749077866 | -122.4224711953 | (37.7576749077866, -122.4224711953) | |||
165827 | 165827 | 201926 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 118 Elmira St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 9ft | 6011142.54954 | 2096046.89892 | 37.7359737613804 | -122.403917705737 | (37.7359737613804, -122.403917705737) | |||
166369 | 166369 | 194603 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 500 Wisconsin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 6012631.4012 | 2105136.35292 | 37.761014517726295 | -122.399408030156 | (37.7610145177263, -122.399408030156) | |||
166371 | 166371 | 246687 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 9ft | 6004944.1218 | 2097602.36636 | 37.7398964773322 | -122.42545882766301 | (37.7398964773322, -122.425458827663) | |||
166774 | 166774 | 242781 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 95x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006152.38517 | 2109124.27435 | 37.771601160584 | -122.42209948031099 | (37.771601160584, -122.422099480311) | |||
167388 | 167388 | 194082 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 495 Barneveld Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 6011088.380890001 | 2097569.3881900003 | 37.7401511662306 | -122.404212110497 | (37.7401511662306, -122.404212110497) | |||
167492 | 167492 | 228917 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 9ft | 6002641.22231 | 2108269.24913 | 37.7690548102697 | -122.434183647259 | (37.7690548102697, -122.434183647259) | |||
167759 | 167759 | 196407 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 301 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6014364.2295 | 2105674.4780599996 | 37.7625885210619 | -122.393452545091 | (37.7625885210619, -122.393452545091) | |||
167931 | 167931 | 124291 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4401x Cornwall St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 9ft | 5993813.763719999 | 2114194.95027 | 37.7848202285685 | -122.465147505193 | (37.7848202285685, -122.465147505193) | |||
168179 | 168179 | 119407 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 375 32nd Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 9ft | 5985884.85714 | 2113320.57304 | 37.78195903231371 | -122.49251412874399 | (37.7819590323137, -122.492514128744) | |||
169278 | 169278 | 124176 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 11 Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 5995826.0985199995 | 2112588.51087 | 37.7805252097548 | -122.45806922812099 | (37.7805252097548, -122.458069228121) | |||
169555 | 169555 | 125268 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2960 Van Ness Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 9ft | 6005626.14224 | 2120703.55494 | 37.8033652908254 | -122.42474367328 | (37.8033652908254, -122.42474367328) | |||
169841 | 169841 | 190933 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 9ft | 6015201.2247 | 2102025.49065 | 37.7526156511008 | -122.390302701123 | (37.7526156511008, -122.390302701123) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");