trees
142,615 rows where qLegalStatus_id = 1 sorted by Neighborhoods (old) descending
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) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
122 | 17067 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1355 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000506.9486 | 2109572.2346 | 37.7725111167076 | -122.441659471159 | (37.7725111167076, -122.441659471159) | 15 | 5 | 11 | 29492 | 9 | |||
167 | 99668 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
183 | 253381 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 899 Waller St | 3 | Side Yard : Yard | Tree | Private 2 | 6001282 | 2108613 | 37.7699214264211 | -122.438909742148 | (37.7699214264211, -122.438909742148) | 15 | 5 | 5 | 29492 | 9 | |||||
191 | 244985 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000147.9035 | 2108881.2284 | 37.7705933244615 | -122.442851810939 | (37.7705933244615, -122.442851810939) | 15 | 5 | 11 | 29492 | 9 | |||
213 | 3891 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 23 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002162.16871 | 2108402.44463 | 37.7693933312702 | -122.435850193556 | (37.7693933312702, -122.435850193556) | 15 | 5 | 5 | 29492 | 9 | |||
250 | 248390 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 34 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998825.2199 | 2108039.7272 | 37.7682072798204 | -122.447366392326 | (37.7682072798204, -122.447366392326) | 15 | 5 | 11 | 29492 | 9 | |||
268 | 247892 | DPW Maintained 1 | :: 45 | 1283 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000447.0072 | 2109223.9761 | 37.7715514711219 | -122.441841814274 | (37.7715514711219, -122.441841814274) | 15 | 5 | 11 | 29492 | 9 | |||
272 | 232035 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 39 Scott St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6002379.25876 | 2108512.04182 | 37.769706587622 | -122.435107129612 | (37.769706587622, -122.435107129612) | 15 | 5 | 5 | 29492 | 9 | |||
278 | 247719 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 12 Broderick St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6001402.47389 | 2108783.95066 | 37.770397668046 | -122.438505276404 | (37.770397668046, -122.438505276404) | 15 | 5 | 11 | 29492 | 9 | |||
325 | 248307 | DPW Maintained 1 | :: 45 | 1323 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999369.7066 | 2108379.5015 | 37.7691713129844 | -122.445507509409 | (37.7691713129844, -122.445507509409) | 15 | 5 | 11 | 29492 | 9 | |||
368 | 234039 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 93 Scott St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6002347.86623 | 2108745.44445 | 37.7703456710482 | -122.435232412346 | (37.7703456710482, -122.435232412346) | 15 | 5 | 5 | 29492 | 9 | |||
474 | 231615 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 123 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997901.04644 | 2106790.55861 | 37.7647245269317 | -122.450472936196 | (37.7647245269317, -122.450472936196) | 15 | 5 | 11 | 29492 | 9 | |||
489 | 225574 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Carmelita St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002579.4442 | 2108765.68107 | 37.7704143837497 | -122.434432832327 | (37.7704143837497, -122.434432832327) | 15 | 5 | 5 | 29492 | 9 | |||
491 | 246210 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 725 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2019 12:00:00 AM | 3 | Width 0ft | 5999854.0817 | 2107930.8602 | 37.7679670970626 | -122.443799851593 | (37.7679670970626, -122.443799851593) | 15 | 5 | 11 | 29492 | 9 | ||
581 | 248465 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 772 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997147.6982 | 2107925.2578 | 37.7677969745346 | -122.453160476336 | (37.7677969745346, -122.453160476336) | 15 | 5 | 11 | 29492 | 9 | |||
664 | 262379 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 925 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2020 12:00:00 AM | 3 | 3x3 | 5998032 | 2106999 | 37.7653043483693 | -122.450035028723 | (37.7653043483693, -122.450035028723) | 15 | 5 | 11 | 29492 | 9 | |
766 | 17084 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1575 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999487.0395 | 2109431.3054 | 37.7720659980909 | -122.445177292475 | (37.7720659980909, -122.445177292475) | 15 | 5 | 11 | 29492 | 9 | |||
879 | 229569 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 129 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997890.05734 | 2106786.37745 | 37.7647124175658 | -122.450510642978 | (37.7647124175658, -122.450510642978) | 15 | 5 | 11 | 29492 | 9 | |||
888 | 246022 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 625 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998964.2184 | 2108548.4801 | 37.769612128289 | -122.446922226392 | (37.769612128289, -122.446922226392) | 15 | 5 | 11 | 29492 | 9 | |||
1030 | 260915 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Waller St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5999454.48308 | 2108393.47297 | 37.7692145145226 | -122.445215277932 | (37.7692145145226, -122.445215277932) | 15 | 5 | 11 | 29492 | 9 | |||
1098 | 31784 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 7 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35255 | 6001631.05677 | 2108636.54376 | 37.7700059251571 | -122.437704050605 | (37.7700059251571, -122.437704050605) | 15 | 5 | 5 | 29492 | 9 | |
1133 | 219665 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4924 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997710.35779 | 2105651.11077 | 37.76158497568 | -122.45105030094 | (37.76158497568, -122.45105030094) | 15 | 5 | 11 | 29492 | 9 | |||
1181 | 238014 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 77 Ashbury Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5999606.96605 | 2106732.73135 | 37.7646632372481 | -122.444568471453 | (37.7646632372481, -122.444568471453) | 15 | 5 | 5 | 29492 | 9 | |||
1454 | 247689 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2 Central Ave | 4 | : | Tree | Private 2 | 24 | Width 4ft | 5999999.2126 | 2108392.11953 | 37.7692418764422 | -122.443330996248 | (37.7692418764422, -122.443330996248) | 15 | 5 | 11 | 29492 | 9 | |||
1482 | 29956 | DPW Maintained 1 | :: 45 | 600 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 6003212.3178 | 2109308.4177 | 37.7719405092432 | -122.432282489737 | (37.7719405092432, -122.432282489737) | 15 | 5 | 11 | 29492 | 9 | ||
1620 | 16991 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 899 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002773.5007 | 2109890.2869 | 37.7735132873347 | -122.433841985714 | (37.7735132873347, -122.433841985714) | 15 | 5 | 11 | 29492 | 9 | |||
1860 | 248578 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 798 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5998643.5224 | 2107650.8947 | 37.7671292598137 | -122.447966864543 | (37.7671292598137, -122.447966864543) | 15 | 5 | 11 | 29492 | 9 | |||
1958 | 244068 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 414 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5998440.5999 | 2109109.2833 | 37.7711220225463 | -122.448773795857 | (37.7711220225463, -122.448773795857) | 15 | 5 | 11 | 29492 | 9 | |||
2120 | 262362 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 160 Central Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 0ft | 5999920 | 2109126 | 37.7712524099727 | -122.443657715912 | (37.7712524099727, -122.443657715912) | 15 | 5 | 11 | 29492 | 9 | ||||
2138 | 228020 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1112 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5998182.13932 | 2106442.54702 | 37.7637850591596 | -122.449475636595 | (37.7637850591596, -122.449475636595) | 15 | 5 | 11 | 29492 | 9 | |||
2221 | 238015 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 77 Ashbury Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5999599.38464 | 2106733.87641 | 37.7646659486903 | -122.444594775755 | (37.7646659486903, -122.444594775755) | 15 | 5 | 5 | 29492 | 9 | |||
2298 | 248463 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 130 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997448.7103 | 2107810.4856 | 37.7674990867904 | -122.452111034778 | (37.7674990867904, -122.452111034778) | 15 | 5 | 11 | 29492 | 9 | |||
2314 | 227584 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 660 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002549.44678 | 2108867.98451 | 37.7706935809695 | -122.434543909369 | (37.7706935809695, -122.434543909369) | 15 | 5 | 11 | 29492 | 9 | |||
2329 | 248481 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 771 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999055.2186 | 2107891.4924 | 37.7678134046704 | -122.446560186722 | (37.7678134046704, -122.446560186722) | 15 | 5 | 11 | 29492 | 9 | |||
2378 | 239239 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Scott St | 1 | : | Tree | Private 2 | 20 | Width 6ft | 6002329.06188 | 2108869.34471 | 37.7706848027038 | -122.435306320439 | (37.7706848027038, -122.435306320439) | 15 | 5 | 11 | 29492 | 9 | |||
2437 | 221745 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 200 Grattan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5997627.57278 | 2106480.28137 | 37.7638569284848 | -122.451396424803 | (37.7638569284848, -122.451396424803) | 15 | 5 | 11 | 29492 | 9 | |||
2449 | 220048 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 201 Rivoli St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 5997609 | 2105896 | 37.7622515762528 | -122.451418517771 | (37.7622515762528, -122.451418517771) | 15 | 5 | 11 | 29492 | 9 | |||
2537 | 245955 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 450 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997557.5774 | 2107478.8878 | 37.7665948394439 | -122.45171055689 | (37.7665948394439, -122.45171055689) | 15 | 5 | 11 | 29492 | 9 | |||
2617 | 247759 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Alpine Ter | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6001668.74952 | 2108376.80716 | 37.7692948959648 | -122.437555068929 | (37.7692948959648, -122.437555068929) | 15 | 5 | 5 | 29492 | 9 | |||
2669 | 248462 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | Permit Number 779787 | 5997458.098 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | 15 | 5 | 11 | 29492 | 9 | ||
2766 | 247224 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 135 Divisadero St | 1 | : | Tree | Private 2 | 08/07/2019 12:00:00 AM | 3 | Width 3ft | 6001887.60725 | 2108459.11842 | 37.7695333431173 | -122.436803945272 | (37.7695333431173, -122.436803945272) | 15 | 5 | 5 | 29492 | 9 | ||
2864 | 227812 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 79 Piedmont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x15 | 5999345.2069 | 2106945.6167 | 37.765232827359 | -122.445489132637 | (37.765232827359, -122.445489132637) | 15 | 5 | 5 | 29492 | 9 | |||
2935 | 246401 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1599 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998515.5772 | 2108578.3087 | 37.7696683888949 | -122.448476202514 | (37.7696683888949, -122.448476202514) | 15 | 5 | 11 | 29492 | 9 | |||
3152 | 10368 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000449.8535 | 2108924.1608 | 37.7707284158065 | -122.441810447284 | (37.7707284158065, -122.441810447284) | 15 | 5 | 11 | 29492 | 9 | |||
3225 | 248333 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1329 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999495.3806 | 2108202.9521 | 37.7686937265955 | -122.445060117561 | (37.7686937265955, -122.445060117561) | 15 | 5 | 11 | 29492 | 9 | |||
3233 | 245150 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6000845.3118 | 2109360.3422 | 37.7719485860085 | -122.440473841976 | (37.7719485860085, -122.440473841976) | 15 | 5 | 11 | 29492 | 9 | |||
3235 | 225279 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 125 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998048.35384 | 2106192.09719 | 37.7630897330321 | -122.449920306376 | (37.7630897330321, -122.449920306376) | 15 | 5 | 11 | 29492 | 9 | |||
3237 | 225589 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 574 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002963.17537 | 2108925.95481 | 37.7708762305838 | -122.433116959576 | (37.7708762305838, -122.433116959576) | 15 | 5 | 11 | 29492 | 9 | |||
3279 | 262361 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 160 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5999920 | 2109126 | 37.7712524099727 | -122.443657715912 | (37.7712524099727, -122.443657715912) | 15 | 5 | 11 | 29492 | 9 | ||||
3307 | 235079 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 109 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5999446.97548 | 2107694.45371 | 37.7672947551641 | -122.44519098308 | (37.7672947551641, -122.44519098308) | 15 | 5 | 5 | 29492 | 9 | |||
3320 | 245104 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999855.4831 | 2109410.1992 | 37.7720290692692 | -122.443901304248 | (37.7720290692692, -122.443901304248) | 15 | 5 | 11 | 29492 | 9 | |||
3328 | 235080 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1199X Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5997665 | 2106510 | 37.7639406713752 | -122.451269119462 | (37.7639406713752, -122.451269119462) | 15 | 5 | 11 | 29492 | 9 | |||
3358 | 233971 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 175 Clifford Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999325.70012 | 2106527.04149 | 37.7640824109973 | -122.44552650036 | (37.7640824109973, -122.44552650036) | 15 | 5 | 5 | 29492 | 9 | |||
3561 | 246211 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 725 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2019 12:00:00 AM | 3 | Width 0ft | 5999847.7223 | 2107912.6904 | 37.7679168446173 | -122.443820542416 | (37.7679168446173, -122.443820542416) | 15 | 5 | 11 | 29492 | 9 | ||
3584 | 3879 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 5 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001986.3803 | 2108685.97385 | 37.7701618451199 | -122.436478532758 | (37.7701618451199, -122.436478532758) | 15 | 5 | 5 | 29492 | 9 | |||
3585 | 14577 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1135 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 3X3 | 5999374.0888 | 2108906.7208 | 37.7706191740488 | -122.445530268097 | (37.7706191740488, -122.445530268097) | 15 | 5 | 11 | 29492 | 9 | |||
3603 | 247549 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 815 Buena Vista Ave West | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 2ft | 6000106.41756 | 2108406.30035 | 37.7692869261681 | -122.442961199511 | (37.7692869261681, -122.442961199511) | 15 | 5 | 11 | 29492 | 9 | |||
3613 | 227144 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997515.89511 | 2105898.72706 | 37.7622537322474 | -122.451740727559 | (37.7622537322474, -122.451740727559) | 15 | 5 | 11 | 29492 | 9 | |||
3759 | 107474 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1500 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2014 12:00:00 AM | 3 | 3x3 | 5999274.15837 | 2109122.8221 | 37.7712068279612 | -122.445891472086 | (37.7712068279612, -122.445891472086) | 15 | 5 | 11 | 29492 | 9 | ||
4284 | 244079 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998854.6041 | 2109046.905 | 37.7709744135065 | -122.447337256007 | (37.7709744135065, -122.447337256007) | 15 | 5 | 11 | 29492 | 9 | |||
4310 | 247395 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 250 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6001848.3229 | 2109217.0966 | 37.7716123305054 | -122.436994101291 | (37.7716123305054, -122.436994101291) | 15 | 5 | 11 | 29492 | 9 | |||
4534 | 17065 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1345 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/1991 12:00:00 AM | 6 | 3X3 | 6000565.7799 | 2109579.8794 | 37.7725354591824 | -122.441456517022 | (37.7725354591824, -122.441456517022) | 15 | 5 | 11 | 29492 | 9 | ||
4749 | 227685 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5997626.03081 | 2107071.20572 | 37.765479368391 | -122.451444382046 | (37.765479368391, -122.451444382046) | 15 | 5 | 11 | 29492 | 9 | |||
4831 | 238452 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 74 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002631.46535 | 2108682.38304 | 37.7701886206411 | -122.434246935272 | (37.7701886206411, -122.434246935272) | 15 | 5 | 5 | 29492 | 9 | |||
4923 | 31224 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1386 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | 0 | Permit Number 42098 | 5999592.83400965 | 2107841.48506455 | 37.76770679076 | -122.444697050343 | (37.76770679076, -122.444697050343) | 15 | 5 | 11 | 29492 | 9 | ||
4943 | 260913 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 482 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997348.59542 | 2107447.85511 | 37.7664976608583 | -122.452431145559 | (37.7664976608583, -122.452431145559) | 15 | 5 | 11 | 29492 | 9 | |||
5003 | 246147 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1504 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5998476.2094 | 2108299.706 | 37.7689011658077 | -122.448592305739 | (37.7689011658077, -122.448592305739) | 15 | 5 | 11 | 29492 | 9 | |||
5079 | 244070 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997422 | 2109143 | 37.7711562992209 | -122.452299584321 | (37.7711562992209, -122.452299584321) | 15 | 5 | 11 | 29492 | 9 | |||
5176 | 260916 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1726 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998303.71415 | 2108967.89528 | 37.7707259785013 | -122.449237098474 | (37.7707259785013, -122.449237098474) | 15 | 5 | 11 | 29492 | 9 | |||
5183 | 262363 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1395 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5999904 | 2109150 | 37.7713173953524 | -122.443714784863 | (37.7713173953524, -122.443714784863) | 15 | 5 | 11 | 29492 | 9 | ||||
5222 | 240527 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 201 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 5997609 | 2105896 | 37.7622515762528 | -122.451418517771 | (37.7622515762528, -122.451418517771) | 15 | 5 | 11 | 29492 | 9 | |||
5247 | 17055 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1285 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1991 12:00:00 AM | 12 | 3X3 | 6000835.008 | 2109621.9255 | 37.772666241387 | -122.440528248313 | (37.772666241387, -122.440528248313) | 15 | 5 | 11 | 29492 | 9 | ||
5342 | 260946 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 351X Upper Ter | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5999155 | 2106055 | 37.7627765565078 | -122.446082944502 | (37.7627765565078, -122.446082944502) | 15 | 5 | 5 | 29492 | 9 | ||||
5434 | 244069 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997423.6428 | 2109118.4396 | 37.7710889568013 | -122.45229212933 | (37.7710889568013, -122.45229212933) | 15 | 5 | 11 | 29492 | 9 | |||
5449 | 245103 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999859.4717 | 2109392.5831 | 37.7719809274281 | -122.443886241527 | (37.7719809274281, -122.443886241527) | 15 | 5 | 11 | 29492 | 9 | |||
5451 | 227724 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 937 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 18 | Width 4ft | Permit Number 17591 | 5999190.54097 | 2106890.47379 | 37.7650725879622 | -122.446020116632 | (37.7650725879622, -122.446020116632) | 15 | 5 | 11 | 29492 | 9 | |
5525 | 3887 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 19 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002118.7656433 | 2108506.4769773 | 37.7696765127931 | -122.436007767762 | (37.7696765127931, -122.436007767762) | 15 | 5 | 5 | 29492 | 9 | |||
5690 | 3889 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 23 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002186.05284 | 2108346.48625 | 37.7692410400757 | -122.435763575333 | (37.7692410400757, -122.435763575333) | 15 | 5 | 5 | 29492 | 9 | |||
5700 | 247227 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 754 Duboce Ave | 3 | : | Tree | Private 2 | 13 | Width 4ft | 6002088.83354 | 2108298.92928 | 37.7691049375705 | -122.436096447702 | (37.7691049375705, -122.436096447702) | 15 | 5 | 5 | 29492 | 9 | |||
5777 | 236886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 19 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999794.84017 | 2107740.78747 | 37.7674418258017 | -122.443991102207 | (37.7674418258017, -122.443991102207) | 15 | 5 | 5 | 29492 | 9 | |||
5821 | 232036 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 50 Scott St | 6 | : | Tree | Private 2 | 7 | Width 3ft | 6002425.62423 | 2108559.69988 | 37.7698400775965 | -122.434950161914 | (37.7698400775965, -122.434950161914) | 15 | 5 | 5 | 29492 | 9 | |||
5966 | 229069 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 134 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5997862.26563 | 2106825.97053 | 37.7648195394167 | -122.450609621445 | (37.7648195394167, -122.450609621445) | 15 | 5 | 11 | 29492 | 9 | |||
5985 | 247277 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 404 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2015 12:00:00 AM | 9 | Width 0ft | 5998904.2718 | 2109290.33 | 37.7716456345938 | -122.447182976567 | (37.7716456345938, -122.447182976567) | 15 | 5 | 11 | 29492 | 9 | ||
6068 | 244550 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1544 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5999032 | 2109089 | 37.7711001308876 | -122.446726670211 | (37.7711001308876, -122.446726670211) | 15 | 5 | 11 | 29492 | 9 | |||
6122 | 221395 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 704 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:44:00 AM | 3 | Width 3ft | 6002236.87075 | 2108821.32754 | 37.7705477235228 | -122.435621774727 | (37.7705477235228, -122.435621774727) | 15 | 5 | 11 | 29492 | 9 | ||
6155 | 247321 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 212 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002821 | 2109296 | 37.7718842175888 | -122.433635197846 | (37.7718842175888, -122.433635197846) | 15 | 5 | 11 | 29492 | 9 | |||
6189 | 260917 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1740 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998239.87383 | 2108958.8784 | 37.7706975687071 | -122.44945727244 | (37.7706975687071, -122.44945727244) | 15 | 5 | 11 | 29492 | 9 | |||
6191 | 244986 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1443 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999693.832 | 2109119.8472 | 37.7712226140057 | -122.44443959552 | (37.7712226140057, -122.44443959552) | 15 | 5 | 11 | 29492 | 9 | |||
6199 | 244531 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1504 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998919.2255 | 2108717.3892 | 37.7700733392593 | -122.44709001202 | (37.7700733392593, -122.44709001202) | 15 | 5 | 11 | 29492 | 9 | |||
6578 | 245102 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5999861.4659 | 2109378.2907 | 37.7719417978626 | -122.443878316418 | (37.7719417978626, -122.443878316418) | 15 | 5 | 11 | 29492 | 9 | |||
6647 | 233181 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1088 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998975.05646 | 2106207.82472 | 37.7631858975236 | -122.446716299819 | (37.7631858975236, -122.446716299819) | 15 | 5 | 5 | 29492 | 9 | |||
6712 | 247499 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 348 Scott St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 0ft | 6002255.8916 | 2109762.6323 | 37.7731333935223 | -122.43562333462 | (37.7731333935223, -122.43562333462) | 15 | 5 | 11 | 29492 | 9 | |||
6806 | 105051 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1244 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2017 12:00:00 AM | 3 | Permit Number 779926 | 5999515.4 | 2108544.9 | 37.7696337718916 | -122.445015457708 | (37.7696337718916, -122.445015457708) | 15 | 5 | 11 | 29492 | 9 | ||
6859 | 246229 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5999439.8115 | 2107740.3807 | 37.7674204502126 | -122.44521906453 | (37.7674204502126, -122.44521906453) | 15 | 5 | 11 | 29492 | 9 | |||
7057 | 246148 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1504 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5998461.6736 | 2108298.4947 | 37.7688970087309 | -122.448642496615 | (37.7688970087309, -122.448642496615) | 15 | 5 | 11 | 29492 | 9 | |||
7150 | 260618 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 637 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/2019 12:00:00 AM | 3 | 6003090.98743 | 2109246.85163 | 37.7717645837124 | -122.432697781433 | (37.7717645837124, -122.432697781433) | 15 | 5 | 11 | 29492 | 9 | |||
7238 | 17116 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1899 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997981.6278 | 2109222.6111 | 37.7714069348749 | -122.450369559944 | (37.7714069348749, -122.450369559944) | 15 | 5 | 11 | 29492 | 9 | |||
7394 | 236442 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1098 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998931 | 2106271 | 37.7633568442315 | -122.446873221995 | (37.7633568442315, -122.446873221995) | 15 | 5 | 11 | 29492 | 9 | |||
7467 | 238440 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 701 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2020 04:27:00 PM | 2 | Width 3ft | 6002273.48193 | 2108783.68455 | 37.7704464445658 | -122.435492443229 | (37.7704464445658, -122.435492443229) | 15 | 5 | 5 | 29492 | 9 | ||
7468 | 244539 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 410 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998914.5258 | 2109210.0073 | 37.7714256747979 | -122.447141725905 | (37.7714256747979, -122.447141725905) | 15 | 5 | 11 | 29492 | 9 |
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) );