trees
8,298 rows where qLegalStatus_id = 4 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) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77966 | 109400 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1588 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997977.9 | 2108248 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | 15 | 5 | 11 | 29492 | 9 | ||||
77968 | 100180 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 100x BELVEDERE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997991 | 2108152 | 37.7684678470263 | -122.450259955793 | (37.7684678470263, -122.450259955793) | 15 | 5 | 11 | 29492 | 9 | ||||
80435 | 112123 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 771 WALLER ST | Back Yard : Yard | Tree | Private 2 | 24 | 3x3 | 6002060 | 2108730 | 37.7702869131062 | -122.436227034456 | (37.7702869131062, -122.436227034456) | 15 | 5 | 5 | 29492 | 9 | ||||
80812 | 102673 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 616 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997561 | 2108438 | 37.7692285123205 | -122.451767914676 | (37.7692285123205, -122.451767914676) | 15 | 5 | 11 | 29492 | 9 | ||||
80875 | 108115 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 786 Clayton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5998636 | 2107697 | 37.7672554233108 | -122.447996203185 | (37.7672554233108, -122.447996203185) | 15 | 5 | 11 | 29492 | 9 | ||||
81248 | 105890 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999444.5 | 2109060.1 | 37.7710443339737 | -122.445297745357 | (37.7710443339737, -122.445297745357) | 15 | 5 | 11 | 29492 | 9 | |||||
81313 | 93225 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 746 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4.5 | 5998618.6 | 2107971.8 | 37.7680089598714 | -122.44807617536 | (37.7680089598714, -122.44807617536) | 15 | 5 | 11 | 29492 | 9 | ||||
81713 | 109645 | Undocumented 4 | Acacia decurrens :: Acacia: Silver Wattle 111 | 999X PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001842 | 2109394 | 37.7720977038705 | -122.437028639855 | (37.7720977038705, -122.437028639855) | 15 | 5 | 11 | 29492 | 9 | ||||
81891 | 110202 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1039 PAGE ST | Front Yard : Cutout | Tree | Private 2 | 4x5 | 6001572.7 | 2109358.5 | 37.771984919077 | -122.437957625293 | (37.771984919077, -122.437957625293) | 15 | 5 | 11 | 29492 | 9 | |||||
82434 | 109881 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1520 PAGE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.446241403234 | (37.7711622584795, -122.446241403234) | 15 | 5 | 11 | 29492 | 9 | ||||
82550 | 108113 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 786 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x7 | 5998636 | 2107697 | 37.7672554233108 | -122.447996203185 | (37.7672554233108, -122.447996203185) | 15 | 5 | 11 | 29492 | 9 | ||||
83547 | 106621 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 158-160 Clifford Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5999377.6 | 2106584.4 | 37.7642428659135 | -122.445351118919 | (37.7642428659135, -122.445351118919) | 15 | 5 | 5 | 29492 | 9 | |||
84055 | 117166 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
84120 | 100226 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1192 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000853 | 2109323 | 37.7718464914602 | -122.440444569342 | (37.7718464914602, -122.440444569342) | 15 | 5 | 11 | 29492 | 9 | ||||
85590 | 108207 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1192 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000914.97169 | 2109351.778 | 37.7719290371123 | -122.440232269589 | (37.7719290371123, -122.440232269589) | 15 | 5 | 11 | 29492 | 9 | |||||
86609 | 122336 | Undocumented 4 | Tree(s) :: 17 | 101x Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998837 | 2107589 | 37.7669703700333 | -122.447293202076 | (37.7669703700333, -122.447293202076) | 15 | 5 | 11 | 29492 | 9 | ||||
86646 | 109112 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 432X FREDERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x7 | 5997770.4 | 2107507.4 | 37.7666853128725 | -122.450976500583 | (37.7666853128725, -122.450976500583) | 15 | 5 | 11 | 29492 | 9 | |||
88497 | 110530 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 1201X PAGE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000585 | 2109266 | 37.7716747202038 | -122.441367506705 | (37.7716747202038, -122.441367506705) | 15 | 5 | 11 | 29492 | 9 | ||||
88721 | 110024 | Undocumented 4 | :: 45 | 432X Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997770.4 | 2107507.4 | 37.7666853128725 | -122.450976500583 | (37.7666853128725, -122.450976500583) | 15 | 5 | 11 | 29492 | 9 | |||||
89681 | 98350 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 225 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002759 | 2109307 | 37.7719109027838 | -122.4338504464 | (37.7719109027838, -122.4338504464) | 15 | 5 | 11 | 29492 | 9 | ||||
89746 | 58598 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 4966 17th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 04/19/1979 12:00:00 AM | Permit Number 17804 | 5997580.2349427 | 2105651.04183436 | 37.7615773358373 | -122.45150033551 | (37.7615773358373, -122.45150033551) | 15 | 5 | 11 | 29492 | 9 | |||
91616 | 109399 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1588 WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997977.9 | 2108248 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | 15 | 5 | 11 | 29492 | 9 | ||||
92362 | 117957 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 229 DOWNEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998953 | 2106815 | 37.7648517885701 | -122.446836277911 | (37.7648517885701, -122.446836277911) | 15 | 5 | 11 | 29492 | 9 | ||||
92694 | 112578 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 660x Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999086 | 2108401 | 37.7692141419233 | -122.446490377962 | (37.7692141419233, -122.446490377962) | 15 | 5 | 11 | 29492 | 9 | ||||
95395 | 117167 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
95413 | 106022 | Undocumented 4 | Photinia fraseri :: Photinia: Chinese photinia 166 | 181 Buena Vista Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 771765 | 6001436.7 | 2108377.5 | 37.7692836023561 | -122.438357764726 | (37.7692836023561, -122.438357764726) | 15 | 5 | 5 | 29492 | 9 | |||||
96954 | 112423 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 48 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000897 | 2109209 | 37.7715359812847 | -122.440284193858 | (37.7715359812847, -122.440284193858) | 15 | 5 | 11 | 29492 | 9 | ||||
98345 | 102484 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1501X Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999365.6 | 2109075.3 | 37.7710815652008 | -122.445571755181 | (37.7710815652008, -122.445571755181) | 15 | 5 | 11 | 29492 | 9 | ||||
98435 | 117530 | Undocumented 4 | Cinnamomum camphora :: Camphor Tree 90 | 257 Central Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999766.4 | 2109434.7 | 37.7720912604321 | -122.444211209505 | (37.7720912604321, -122.444211209505) | 15 | 5 | 11 | 29492 | 9 | ||||
99586 | 117533 | Undocumented 4 | Schinus molle :: California Pepper 91 | 870 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6002404 | 2109622 | 37.7727556633357 | -122.435100948925 | (37.7727556633357, -122.435100948925) | 15 | 5 | 11 | 29492 | 9 | ||||
100064 | 101678 | Undocumented 4 | Tree(s) :: 17 | 257 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999766.4 | 2109434.7 | 37.7720912604321 | -122.444211209505 | (37.7720912604321, -122.444211209505) | 15 | 5 | 11 | 29492 | 9 | ||||
101115 | 107518 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 59 POTOMAC ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x4 | 6003087.6 | 2108634.4 | 37.7700827498113 | -122.432665742309 | (37.7700827498113, -122.432665742309) | 15 | 5 | 5 | 29492 | 9 | |||
102160 | 117527 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1099x WALLER ST | 1 | Front Yard : Yard | Tree | Private 2 | 6000071 | 2108311 | 37.769023235971 | -122.44307686155 | (37.769023235971, -122.44307686155) | 15 | 5 | 5 | 29492 | 9 | |||||
102388 | 113158 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997339 | 2106686 | 37.764405251212 | -122.452409351598 | (37.764405251212, -122.452409351598) | 15 | 5 | 11 | 29492 | 9 | ||||
102540 | 98499 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1X Miley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000842 | 2108958 | 37.7708436665375 | -122.44045643654 | (37.7708436665375, -122.44045643654) | 15 | 5 | 11 | 29492 | 9 | ||||
102782 | 109882 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1520 PAGE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.446241403234 | (37.7711622584795, -122.446241403234) | 15 | 5 | 11 | 29492 | 9 | ||||
102881 | 220639 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1202 Stanyan St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5997451.78012 | 2105807.14899 | 37.7619986098677 | -122.451955868771 | (37.7619986098677, -122.451955868771) | 15 | 5 | 11 | 29492 | 9 | |||
104448 | 110529 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 1201X PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000585 | 2109266 | 37.7716747202038 | -122.441367506705 | (37.7716747202038, -122.441367506705) | 15 | 5 | 11 | 29492 | 9 | ||||
104963 | 96698 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5997732 | 2108845 | 37.7703558220967 | -122.451205793491 | (37.7703558220967, -122.451205793491) | 15 | 5 | 11 | 29492 | 9 | |||
105584 | 113009 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
105994 | 108206 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 1192 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000914.97169 | 2109351.778 | 37.7719290371123 | -122.440232269589 | (37.7719290371123, -122.440232269589) | 15 | 5 | 11 | 29492 | 9 | |||||
106143 | 110752 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x4 | 5998015 | 2108858 | 37.770407716093 | -122.450227838314 | (37.770407716093, -122.450227838314) | 15 | 5 | 11 | 29492 | 9 | ||||
106362 | 115905 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||||
106378 | 101972 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5998294 | 2107899 | 37.7677905087949 | -122.449193680863 | (37.7677905087949, -122.449193680863) | 15 | 5 | 11 | 29492 | 9 | |||
106800 | 100763 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1043 Clayton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998810.4 | 2106255.2 | 37.7633065709297 | -122.447289199162 | (37.7633065709297, -122.447289199162) | 15 | 5 | 11 | 29492 | 9 | ||||
107520 | 113749 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 459 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5998867 | 2109101 | 37.7711236529318 | -122.447298272426 | (37.7711236529318, -122.447298272426) | 15 | 5 | 11 | 29492 | 9 | ||||
107765 | 113980 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1180 STANYAN 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 | ||||
107825 | 113010 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
108004 | 106620 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 158-160 Clifford Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5999377.6 | 2106584.4 | 37.7642428659135 | -122.445351118919 | (37.7642428659135, -122.445351118919) | 15 | 5 | 5 | 29492 | 9 | |||
108863 | 115780 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1401X MASONIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 5999527 | 2107685 | 37.7672733650738 | -122.444913510993 | (37.7672733650738, -122.444913510993) | 15 | 5 | 5 | 29492 | 9 | |||
110296 | 113585 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 536 BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2015 12:00:00 AM | 15x6 | 5998642 | 2106082 | 37.7628213832292 | -122.447859166975 | (37.7628213832292, -122.447859166975) | 15 | 5 | 11 | 29492 | 9 | |||
111821 | 116112 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002265 | 2109203 | 37.7715972993524 | -122.435551784305 | (37.7715972993524, -122.435551784305) | 15 | 5 | 11 | 29492 | 9 | ||||
112699 | 122500 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 722 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6002237 | 2108339 | 37.7692233784846 | -122.435586816367 | (37.7692233784846, -122.435586816367) | 15 | 5 | 5 | 29492 | 9 | |||
113180 | 109880 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1520 PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.446241403234 | (37.7711622584795, -122.446241403234) | 15 | 5 | 11 | 29492 | 9 | ||||
114856 | 93736 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 201 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999812.1 | 2109210.9 | 37.7714793693282 | -122.44403704657 | (37.7714793693282, -122.44403704657) | 15 | 5 | 11 | 29492 | 9 | |||||
116448 | 255498 | Undocumented 4 | Tree(s) :: 17 | 1837 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998183 | 2109231 | 37.771441491369 | -122.449673611464 | (37.771441491369, -122.449673611464) | 15 | 5 | 11 | 29492 | 9 | ||||
118914 | 113002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
120525 | 103005 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 41X Beulah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5997709.4 | 2107777.7 | 37.7674239953752 | -122.451206983541 | (37.7674239953752, -122.451206983541) | 15 | 5 | 11 | 29492 | 9 | |||
120817 | 100762 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1043 Clayton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998810.4 | 2106255.2 | 37.7633065709297 | -122.447289199162 | (37.7633065709297, -122.447289199162) | 15 | 5 | 11 | 29492 | 9 | ||||
122407 | 114512 | Undocumented 4 | Tree(s) :: 17 | 418 BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x7 | 5998550 | 2106753 | 37.7646585215155 | -122.448225680862 | (37.7646585215155, -122.448225680862) | 15 | 5 | 11 | 29492 | 9 | ||||
122602 | 96699 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1849 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5997732 | 2108845 | 37.7703558220967 | -122.451205793491 | (37.7703558220967, -122.451205793491) | 15 | 5 | 11 | 29492 | 9 | |||
124022 | 98345 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998016 | 2107622 | 37.767014032658 | -122.45013527715 | (37.767014032658, -122.45013527715) | 15 | 5 | 11 | 29492 | 9 | ||||
124065 | 116043 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 715 PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003102 | 2109569 | 37.7726497483837 | -122.432682704276 | (37.7726497483837, -122.432682704276) | 15 | 5 | 11 | 29492 | 9 | ||||
124986 | 100419 | Undocumented 4 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 760 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002024.1 | 2108325.5 | 37.7691742163209 | -122.436322258742 | (37.7691742163209, -122.436322258742) | 15 | 5 | 5 | 29492 | 9 | |||||
126581 | 101677 | Undocumented 4 | Tree(s) :: 17 | 257 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999766.4 | 2109434.7 | 37.7720912604321 | -122.444211209505 | (37.7720912604321, -122.444211209505) | 15 | 5 | 11 | 29492 | 9 | ||||
127279 | 98498 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1X Miley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000842 | 2108958 | 37.7708436665375 | -122.44045643654 | (37.7708436665375, -122.44045643654) | 15 | 5 | 11 | 29492 | 9 | ||||
128020 | 115150 | Undocumented 4 | Privet :: 212 | 209 Grattan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2016 12:00:00 AM | 3 | 3x3 | 5997642.1 | 2106419.3 | 37.7636903209387 | -122.451341781368 | (37.7636903209387, -122.451341781368) | 15 | 5 | 11 | 29492 | 9 | ||
128047 | 103004 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 41X Beulah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997709.4 | 2107777.7 | 37.7674239953752 | -122.451206983541 | (37.7674239953752, -122.451206983541) | 15 | 5 | 11 | 29492 | 9 | |||
129159 | 247296 | Undocumented 4 | Tristania conferta :: 61 | 759 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002955.2349 | 2109573.4516 | 37.7726536468991 | -122.433190698089 | (37.7726536468991, -122.433190698089) | 15 | 5 | 11 | 29492 | 9 | |||
129831 | 106940 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 1607 WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5997889 | 2108175 | 37.7685251613651 | -122.450614421545 | (37.7685251613651, -122.450614421545) | 15 | 5 | 11 | 29492 | 9 | ||||
131207 | 108071 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 101 BUENA VISTA AVE EAST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001336 | 2108482 | 37.7695648051764 | -122.438713569331 | (37.7695648051764, -122.438713569331) | 15 | 5 | 5 | 29492 | 9 | |||
131516 | 117176 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 237 DOWNEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5998960 | 2106765 | 37.7647149010203 | -122.44680846876 | (37.7647149010203, -122.44680846876) | 15 | 5 | 11 | 29492 | 9 | ||||
131957 | 103413 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 753 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997587 | 2107969 | 37.7679422474173 | -122.451644147068 | (37.7679422474173, -122.451644147068) | 15 | 5 | 11 | 29492 | 9 | ||||
132679 | 107904 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 102 Frederick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999554 | 2107755 | 37.7674671083746 | -122.444825154486 | (37.7674671083746, -122.444825154486) | 15 | 5 | 11 | 29492 | 9 | ||||
133261 | 121220 | Undocumented 4 | Tree(s) :: 17 | 1639 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5998709 | 2108958 | 37.7707219817969 | -122.4478345011 | (37.7707219817969, -122.4478345011) | 15 | 5 | 11 | 29492 | 9 | ||||
134151 | 108204 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 1192 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000914.97169 | 2109351.778 | 37.7719290371123 | -122.440232269589 | (37.7719290371123, -122.440232269589) | 15 | 5 | 11 | 29492 | 9 | |||||
135880 | 232309 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1012 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5997674.44536 | 2107027.2087 | 37.7653613359944 | -122.451273754591 | (37.7653613359944, -122.451273754591) | 15 | 5 | 11 | 29492 | 9 | |||
135938 | 224479 | Undocumented 4 | Ficus Spp. :: 101 | 252 Alma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5997431.87905 | 2106139.44688 | 37.7629098758031 | -122.452048674332 | (37.7629098758031, -122.452048674332) | 15 | 5 | 11 | 29492 | 9 | |||
136788 | 96700 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1849 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5997732 | 2108845 | 37.7703558220967 | -122.451205793491 | (37.7703558220967, -122.451205793491) | 15 | 5 | 11 | 29492 | 9 | |||
138352 | 114878 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 226 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001315 | 2109584 | 37.7725894276985 | -122.438865189694 | (37.7725894276985, -122.438865189694) | 15 | 5 | 11 | 29492 | 9 | ||||
138590 | 113558 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 544 BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998649 | 2106025 | 37.7626652756279 | -122.447830852725 | (37.7626652756279, -122.447830852725) | 15 | 5 | 11 | 29492 | 9 | ||||
139032 | 114306 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 900 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997219 | 2107398 | 37.7663533458689 | -122.452875791584 | (37.7663533458689, -122.452875791584) | 15 | 5 | 11 | 29492 | 9 | ||||
139253 | 117523 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 ASHBURY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999017 | 2108636 | 37.7698554510238 | -122.446745955589 | (37.7698554510238, -122.446745955589) | 15 | 5 | 11 | 29492 | 9 | ||||
139654 | 111669 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99x CARL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998115 | 2107097 | 37.7655781805803 | -122.449755015442 | (37.7655781805803, -122.449755015442) | 15 | 5 | 11 | 29492 | 9 | ||||
139819 | 117169 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
140272 | 93200 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 756 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x6 | 5998607 | 2107901 | 37.7678138979087 | -122.448111199872 | (37.7678138979087, -122.448111199872) | 15 | 5 | 11 | 29492 | 9 | ||||
141114 | 106626 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 98X PARNASSUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2015 12:00:00 AM | 8 | 3x3 | 5998106 | 2106975 | 37.7652426845591 | -122.449777351607 | (37.7652426845591, -122.449777351607) | 15 | 5 | 11 | 29492 | 9 | ||
141876 | 247384 | Undocumented 4 | :: 45 | 1021 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002057.9469 | 2109793.0538 | 37.7732056784261 | -122.436310227416 | (37.7732056784261, -122.436310227416) | 15 | 5 | 11 | 29492 | 9 | |||
142372 | 109883 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1520 PAGE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.446241403234 | (37.7711622584795, -122.446241403234) | 15 | 5 | 11 | 29492 | 9 | ||||
145614 | 111670 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99x CARL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998115 | 2107097 | 37.7655781805803 | -122.449755015442 | (37.7655781805803, -122.449755015442) | 15 | 5 | 11 | 29492 | 9 | ||||
145981 | 103003 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 41X Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997709.4 | 2107777.7 | 37.7674239953752 | -122.451206983541 | (37.7674239953752, -122.451206983541) | 15 | 5 | 11 | 29492 | 9 | |||
147202 | 105462 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
147741 | 117171 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
148050 | 104242 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 42 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998257.6 | 2108324 | 37.7689553686247 | -122.449350208019 | (37.7689553686247, -122.449350208019) | 15 | 5 | 11 | 29492 | 9 | ||||
148111 | 117165 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 299x ALMA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
148676 | 247379 | Undocumented 4 | :: 45 | 1015 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002146.8166 | 2109803.9081 | 37.7732405306973 | -122.436003592649 | (37.7732405306973, -122.436003592649) | 15 | 5 | 11 | 29492 | 9 | |||
148808 | 102824 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2001X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
150736 | 248526 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 75 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997669.6241 | 2107795.1927 | 37.7674697483814 | -122.451345824031 | (37.7674697483814, -122.451345824031) | 15 | 5 | 11 | 29492 | 9 | |||
151430 | 115906 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||
151600 | 112286 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 895x PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002361 | 2109458 | 37.7723029182135 | -122.435237957834 | (37.7723029182135, -122.435237957834) | 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) );