Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
169978 | 169978 | 189818 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 9ft | 6010426.403390001 | 2107376.26761 | 37.767041670665996 | -122.407192093242 | (37.767041670666, -122.407192093242) | |||
170127 | 170127 | 201932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 190 Boutwell St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 9ft | 6010626.2158 | 2095614.29555 | 37.734757064092605 | -122.405672426066 | (37.7347570640926, -122.405672426066) | |||
171385 | 171385 | 244815 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 451 Florida St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 9ft | 6009251.4171400005 | 2106274.41145 | 37.7639503995181 | -122.411178363391 | (37.7639503995181, -122.411178363391) | |||
171469 | 171469 | 227092 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 9ft | 6009197.49082 | 2095788.0482299998 | 37.7351541534232 | -122.410624304588 | (37.7351541534232, -122.410624304588) | |||
171948 | 171948 | 194193 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1601 Kansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 6011834.442419999 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | |||
172033 | 172033 | 225849 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 58 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 9ft | 6005973.95639 | 2104058.73898 | 37.7576823326016 | -122.422356701726 | (37.7576823326016, -122.422356701726) | |||
172236 | 172236 | 202064 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1 Hwy 101 S On Ramp | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 9ft | 6012962.66083 | 2090186.66523 | 37.7199842767271 | -122.39721400364401 | (37.7199842767271, -122.397214003644) | |||
173100 | 173100 | 197038 | Undocumented 2 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 2401 Mendell St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 9ft | 6013437.73435 | 2093129.7743099998 | 37.728091897903 | -122.395777939219 | (37.728091897903, -122.395777939219) | |||
173341 | 173341 | 194633 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 500 Wisconsin St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 9ft | 6012635.5698 | 2105111.4439 | 37.7609463553975 | -122.399391863957 | (37.7609463553975, -122.399391863957) | |||
173442 | 173442 | 192966 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012878.7192 | 2105754.24297 | 37.7627248888745 | -122.398596019716 | (37.7627248888745, -122.398596019716) | |||
173643 | 173643 | 187485 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 9ft | 6006777.87289 | 2086579.02758 | 37.7097322050565 | -122.41833708111 | (37.7097322050565, -122.41833708111) | |||
173924 | 173924 | 220153 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 9ft | 6004145.42049 | 2095858.4508 | 37.735062921705996 | -122.428096157927 | (37.735062921706, -122.428096157927) | |||
174102 | 174102 | 123200 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1310 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 5993097.33077 | 2112035.35395 | 37.7788492259481 | -122.46746901060699 | (37.7788492259481, -122.467469010607) | |||
174153 | 174153 | 191822 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Connecticut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 9ft | 6013380.185190001 | 2101849.60949 | 37.7520315396334 | -122.396587889337 | (37.7520315396334, -122.396587889337) | |||
174199 | 174199 | 233357 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 100 Beacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 9ft | 6003400.532869999 | 2097174.07927 | 37.7386331645932 | -122.43076535563 | (37.7386331645932, -122.43076535563) | |||
174694 | 174694 | 214258 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 9ft | 5997049.83244 | 2095507.43022 | 37.7336950951374 | -122.452602689063 | (37.7336950951374, -122.452602689063) | |||
175345 | 175345 | 192379 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6015920.8983 | 2106611.50942 | 37.7652477749961 | -122.38813393835 | (37.7652477749961, -122.38813393835) | |||
175528 | 175528 | 189817 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 9ft | 6010416.08165 | 2107377.1962599996 | 37.767043642870796 | -122.407227860188 | (37.7670436428708, -122.407227860188) | |||
175987 | 175987 | 192972 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012871.07375 | 2105918.34501 | 37.7631750508186 | -122.398633979195 | (37.7631750508186, -122.398633979195) | |||
176054 | 176054 | 223701 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 9ft | 6004786.9856 | 2096684.12369 | 37.7373663112035 | -122.425936792158 | (37.7373663112035, -122.425936792158) | |||
176086 | 176086 | 190931 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 9ft | 6015254.41614 | 2102028.26395 | 37.752626216333 | -122.390118948029 | (37.752626216333, -122.390118948029) | |||
176854 | 176854 | 191389 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 43 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 9ft | 6011309.9548 | 2104119.65272 | 37.758149144577104 | -122.403906816767 | (37.7581491445771, -122.403906816767) | |||
176864 | 176864 | 135666 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3001 Divisadero St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | Width 9ft | 6000472.49775 | 2118651.8946700003 | 37.797439556256705 | -122.442430617479 | (37.7974395562567, -122.442430617479) | |||
177965 | 177965 | 125892 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 3001 Divisadero St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 9ft | 6000476.92366 | 2118604.49605 | 37.7973096644524 | -122.442411898085 | (37.7973096644524, -122.442411898085) | |||
178549 | 178549 | 230385 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 581 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 9ft | 6004995.95318 | 2104998.86424 | 37.760208477866 | -122.42580595608601 | (37.760208477866, -122.425805956086) | |||
179074 | 179074 | 201933 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 190 Boutwell St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 9ft | 6010622.819180001 | 2095611.5496200002 | 37.7347493344117 | -122.405683976059 | (37.7347493344117, -122.405683976059) | |||
179975 | 179975 | 234373 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 9ft | 6004999.25531 | 2105001.6441599997 | 37.76021629747461 | -122.42579473344401 | (37.7602162974746, -122.425794733444) | |||
180161 | 180161 | 198056 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6015997.12564 | 2105199.4171 | 37.761374696215704 | -122.38777174897699 | (37.7613746962157, -122.387771748977) | |||
180521 | 180521 | 192375 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 9ft | 6015916.65317 | 2106707.2255 | 37.765510355454204 | -122.38815530173001 | (37.7655103554542, -122.38815530173) | |||
181603 | 181603 | 202065 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 1 Hwy 101 S On Ramp | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 6012968.073469999 | 2090188.26026 | 37.7199889576912 | -122.39719540566601 | (37.7199889576912, -122.397195405666) | |||
181872 | 181872 | 124180 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Almaden Ct | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 9ft | 5995876.0 | 2112606.0 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | |||
181959 | 181959 | 201376 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Fairfax Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 9ft | 6018269.69343 | 2095669.23069 | 37.7353323666994 | -122.379249829039 | (37.7353323666994, -122.379249829039) | |||
182048 | 182048 | 194267 | Undocumented 2 | Persea americana :: Avocado 113 | 91 Charter Oak Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 9ft | 6010928.668190001 | 2096415.01821 | 37.7369725871245 | -122.404683089975 | (37.7369725871245, -122.404683089975) |
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");