trees
194,517 rows 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 | |||
462 | 33949 | Permitted Site 7 | Tree(s) :: 17 | 1238 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1997 12:00:00 AM | Permit Number 37907 | 5999468.65195546 | 2108623.71254321 | 37.7698475030127 | -122.445182824083 | (37.7698475030127, -122.445182824083) | 15 | 5 | 11 | 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 | |||
778 | 61131 | Permitted Site 7 | Tree(s) :: 17 | 76 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/1983 12:00:00 AM | Permit Number 20983 | 5998241.83548559 | 2106883.25514995 | 37.7649985471459 | -122.449300920602 | (37.7649985471459, -122.449300920602) | 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 | |||
1177 | 50666 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 132 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | Permit Number 47245 | 5997808.46990271 | 2107170.46182714 | 37.7657623457378 | -122.450820527035 | (37.7657623457378, -122.450820527035) | 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 | |||
2220 | 117168 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 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 | |||
2238 | 88648 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 74 Carmelita St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51628 | 6002619 | 2108775 | 37.7704422164895 | -122.434296675208 | (37.7704422164895, -122.434296675208) | 15 | 5 | 5 | 29492 | 9 | |||
2269 | 58628 | Permitted Site 7 | Tree(s) :: 17 | 1240 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1979 12:00:00 AM | Permit Number 17846 | 5998229.96040674 | 2106129.9560019 | 37.7629294984974 | -122.449287716214 | (37.7629294984974, -122.449287716214) | 15 | 5 | 11 | 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 | |||
2375 | 58506 | Permitted Site 7 | Tree(s) :: 17 | 1378 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1979 12:00:00 AM | Permit Number 17681 | 5999108.40955672 | 2108391.40839874 | 37.7691890857648 | -122.446412174677 | (37.7691890857648, -122.446412174677) | 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 | |||
2897 | 62561 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 263 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22761 | 6002735.54596737 | 2109434.34982555 | 37.7722592430025 | -122.433940680004 | (37.7722592430025, -122.433940680004) | 15 | 5 | 11 | 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 | |||
3159 | 94569 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100@ Cole Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998051 | 2107197 | 37.7658490933668 | -122.449983584058 | (37.7658490933668, -122.449983584058) | 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 | ||
3566 | 246019 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 609 Clayton St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 0ft | 5998477.1179 | 2108551.0541 | 37.7695913556898 | -122.448607268219 | (37.7695913556898, -122.448607268219) | 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 | |||
3610 | 45141 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1300 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43998 | 6000329.1714268 | 2109256.8846269 | 37.7716351145449 | -122.442251776367 | (37.7716351145449, -122.442251776367) | 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 | |||
3701 | 78185 | Section 806 (d) 5 | Tree(s) :: 17 | 811 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999080 | 2107571 | 37.7669348288429 | -122.446451411547 | (37.7669348288429, -122.446451411547) | 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 | ||
3865 | 105892 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999444.5 | 2109060.1 | 37.7710443339737 | -122.445297745357 | (37.7710443339737, -122.445297745357) | 15 | 5 | 11 | 29492 | 9 | |||||
3977 | 262296 | Section 806 (d) 5 | Acer rubrum :: Red Maple 75 | 45 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782635 | 5998403.0154 | 2106238.4273 | 37.7632372305534 | -122.448696994498 | (37.7632372305534, -122.448696994498) | 15 | 5 | 11 | 29492 | 9 | |
4209 | 62680 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 654 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | Permit Number 23014 | 6002561.35247931 | 2108872.24257196 | 37.7707059484007 | -122.434503031919 | (37.7707059484007, -122.434503031919) | 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 | |||
4498 | 58438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 3x3 | Permit Number 51484 | 5999161.38005537 | 2107089.77623283 | 37.7656181571992 | -122.446135313725 | (37.7656181571992, -122.446135313725) | 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 | ||
4670 | 107425 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1600X Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997832.17799 | 2108247.26578 | 37.7687203321672 | -122.450816174345 | (37.7687203321672, -122.450816174345) | 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 | |||
4752 | 107181 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1520 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x9 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.446241403234 | (37.7711622584795, -122.446241403234) | 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 | |||
4919 | 64744 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1058 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25706 | 6001496.66932698 | 2109419.88262313 | 37.7721491365124 | -122.43822501871 | (37.7721491365124, -122.43822501871) | 15 | 5 | 11 | 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 | ||||
5390 | 244700 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 722 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:50:00 AM | 3 | Width 3ft | Permit Number 32809 | 6002026.57128 | 2108798.52358 | 37.7704731625436 | -122.43634756898 | (37.7704731625436, -122.43634756898) | 15 | 5 | 11 | 29492 | 9 | |
5413 | 54883 | Permitted Site 7 | Tree(s) :: 17 | 130 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | Permit Number 10747 | 5997823.05471268 | 2107172.49422209 | 37.7657687610677 | -122.450770228093 | (37.7657687610677, -122.450770228093) | 15 | 5 | 11 | 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 | |
5516 | 248395 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1655 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | 8 | Width 0ft | Permit Number 41881 | 5997659.0251 | 2108142.2349 | 37.7684220306889 | -122.451407517669 | (37.7684220306889, -122.451407517669) | 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 |
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) );