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) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | |||
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 | |||||
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 | |||||
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 | |||
5908 | 105725 | Undocumented 4 | Ficus laurel :: 247 | 895 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002505 | 2109533 | 37.7725170259656 | -122.434745213579 | (37.7725170259656, -122.434745213579) | 15 | 5 | 11 | 29492 | 9 | |||
6391 | 246158 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1652 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5997620.7172 | 2108179.7857 | 37.7685229419277 | -122.451542729467 | (37.7685229419277, -122.451542729467) | 15 | 5 | 11 | 29492 | 9 | |||
6425 | 102410 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
8565 | 105233 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1508 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5998474.1 | 2108297 | 37.7688936152058 | -122.448599407064 | (37.7688936152058, -122.448599407064) | 15 | 5 | 11 | 29492 | 9 | |||
9370 | 110531 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 1201X PAGE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000585 | 2109266 | 37.7716747202038 | -122.441367506705 | (37.7716747202038, -122.441367506705) | 15 | 5 | 11 | 29492 | 9 | ||||
9461 | 98346 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1943 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997281 | 2108783 | 37.7701597533774 | -122.452761318704 | (37.7701597533774, -122.452761318704) | 15 | 5 | 11 | 29492 | 9 | ||||
9802 | 245988 | Undocumented 4 | :: 45 | 1250 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999884.6674 | 2108495.9392 | 37.7695204065663 | -122.443734660449 | (37.7695204065663, -122.443734660449) | 15 | 5 | 11 | 29492 | 9 | |||
14479 | 260995 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
15470 | 105248 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1301 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x5 | 5998246 | 2105821 | 37.7620821004846 | -122.44920998149 | (37.7620821004846, -122.44920998149) | 15 | 5 | 11 | 29492 | 9 | |||
16109 | 110528 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 1201X PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000585 | 2109266 | 37.7716747202038 | -122.441367506705 | (37.7716747202038, -122.441367506705) | 15 | 5 | 11 | 29492 | 9 | ||||
16169 | 105247 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1301X COLE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x 5 | 5998246 | 2105821 | 37.7620821004846 | -122.44920998149 | (37.7620821004846, -122.44920998149) | 15 | 5 | 11 | 29492 | 9 | ||||
17233 | 246018 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 603 Clayton St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 0ft | 5998473.1811 | 2108575.8861 | 37.7696593129339 | -122.448622674121 | (37.7696593129339, -122.448622674121) | 15 | 5 | 11 | 29492 | 9 | |||
17358 | 93737 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 201 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999812.1 | 2109210.9 | 37.7714793693282 | -122.44403704657 | (37.7714793693282, -122.44403704657) | 15 | 5 | 11 | 29492 | 9 | |||||
17803 | 117536 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 601 WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002803 | 2108833 | 37.7706119122875 | -122.433664364997 | (37.7706119122875, -122.433664364997) | 15 | 5 | 5 | 29492 | 9 | ||||
17837 | 260996 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
17899 | 110754 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 COLE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x4 | 5998015 | 2108858 | 37.770407716093 | -122.450227838314 | (37.770407716093, -122.450227838314) | 15 | 5 | 11 | 29492 | 9 | ||||
18486 | 260997 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
18556 | 105475 | Undocumented 4 | Tree(s) :: 17 | 671 Waller St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2014 12:00:00 AM | 3x3 | 6002476.36422 | 2108834.33955 | 37.7705970512656 | -122.434794296397 | (37.7705970512656, -122.434794296397) | 15 | 5 | 11 | 29492 | 9 | ||||
19071 | 260994 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
20084 | 115908 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 5 | 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 | ||
20310 | 112288 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 895x PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002361 | 2109458 | 37.7723029182135 | -122.435237957834 | (37.7723029182135, -122.435237957834) | 15 | 5 | 11 | 29492 | 9 | ||||
20756 | 96094 | Undocumented 4 | Acacia longifolia :: Golden Wattle 150 | 1524 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999743.8 | 2107236.2 | 37.7660534433338 | -122.444131380779 | (37.7660534433338, -122.444131380779) | 15 | 5 | 5 | 29492 | 9 | ||||
23402 | 105461 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
24623 | 115781 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1401X MASONIC AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2016 12:00:00 AM | 3 | 3x3 | 5999527 | 2107685 | 37.7672733650738 | -122.444913510993 | (37.7672733650738, -122.444913510993) | 15 | 5 | 5 | 29492 | 9 | ||
24992 | 121225 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 217 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2016 12:00:00 AM | 3 | 2.5x2.5 | 5998931 | 2106888 | 37.7650509713906 | -122.446917623402 | (37.7650509713906, -122.446917623402) | 15 | 5 | 11 | 29492 | 9 | ||
25095 | 244549 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1500 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999267.0062 | 2109103.195 | 37.7711525285338 | -122.445914799778 | (37.7711525285338, -122.445914799778) | 15 | 5 | 11 | 29492 | 9 | |||
25601 | 104243 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 42 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998257.6 | 2108324 | 37.7689553686247 | -122.449350208019 | (37.7689553686247, -122.449350208019) | 15 | 5 | 11 | 29492 | 9 | ||||
27089 | 106627 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 98X PARNASSUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5998297 | 2106864 | 37.7649488326227 | -122.449108733904 | (37.7649488326227, -122.449108733904) | 15 | 5 | 11 | 29492 | 9 | |||
28710 | 102826 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2001X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
29522 | 102830 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 101 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x12 | 6000750.2 | 2109361.5 | 37.7719463488262 | -122.440802922949 | (37.7719463488262, -122.440802922949) | 15 | 5 | 11 | 29492 | 9 | ||||
29538 | 104011 | Undocumented 4 | Tree(s) :: 17 | 1154 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5997378 | 2106254 | 37.7632213232397 | -122.452243288452 | (37.7632213232397, -122.452243288452) | 15 | 5 | 11 | 29492 | 9 | |||
32205 | 117522 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999017 | 2108636 | 37.7698554510238 | -122.446745955589 | (37.7698554510238, -122.446745955589) | 15 | 5 | 11 | 29492 | 9 | ||||
32406 | 113978 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1180 STANYAN 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 | ||||
32686 | 114513 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 418 BELVEDERE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 6x7 | 5998550 | 2106753 | 37.7646585215155 | -122.448225680862 | (37.7646585215155, -122.448225680862) | 15 | 5 | 11 | 29492 | 9 | |||
32800 | 117172 | Undocumented 4 | Tree(s) :: 17 | 299x ALMA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
33403 | 121563 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 102 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x15 | 6000873 | 2109380 | 37.7720041379507 | -122.440379476736 | (37.7720041379507, -122.440379476736) | 15 | 5 | 11 | 29492 | 9 | ||||
34177 | 109402 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1588 WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997977.9 | 2108248 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | 15 | 5 | 11 | 29492 | 9 | ||||
35050 | 115907 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 4 | 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 | ||
35740 | 103007 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 41X Beulah St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5997709.4 | 2107777.7 | 37.7674239953752 | -122.451206983541 | (37.7674239953752, -122.451206983541) | 15 | 5 | 11 | 29492 | 9 | |||
37105 | 98497 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1X Miley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000842 | 2108958 | 37.7708436665375 | -122.44045643654 | (37.7708436665375, -122.44045643654) | 15 | 5 | 11 | 29492 | 9 | ||||
38081 | 108922 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 857 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x12 | 5999156 | 2107174 | 37.7658491072629 | -122.446159980933 | (37.7658491072629, -122.446159980933) | 15 | 5 | 11 | 29492 | 9 | ||||
38273 | 111768 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 4966 17th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5997580.2349427 | 2105651.04183436 | 37.7615773358373 | -122.45150033551 | (37.7615773358373, -122.45150033551) | 15 | 5 | 11 | 29492 | 9 | |||||
38742 | 113004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
41727 | 109884 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 756 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002947.3 | 2109633.8 | 37.7728188985867 | -122.433222458601 | (37.7728188985867, -122.433222458601) | 15 | 5 | 11 | 29492 | 9 | ||||
42327 | 105285 | Undocumented 4 | Persea americana :: Avocado 34 | 1055 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998993.5 | 2106394.4 | 37.7636992400688 | -122.446665934844 | (37.7636992400688, -122.446665934844) | 15 | 5 | 11 | 29492 | 9 | ||||
42636 | 93199 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 748 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x9 | 5998625.2 | 2107963.2 | 37.7679857237315 | -122.448052727493 | (37.7679857237315, -122.448052727493) | 15 | 5 | 11 | 29492 | 9 | ||||
43223 | 117532 | Undocumented 4 | Cinnamomum camphora :: Camphor Tree 90 | 257 Central Ave | 6 | 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 | ||||
43330 | 113005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
43654 | 114877 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 226 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001315 | 2109584 | 37.7725894276985 | -122.438865189694 | (37.7725894276985, -122.438865189694) | 15 | 5 | 11 | 29492 | 9 | ||||
43947 | 102413 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1301 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x6 | 6000345 | 2109213 | 37.7715155205087 | -122.442193873774 | (37.7715155205087, -122.442193873774) | 15 | 5 | 11 | 29492 | 9 | ||||
45808 | 113977 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1180 STANYAN 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 | ||||
46883 | 106970 | Undocumented 4 | Tree(s) :: 17 | 30 Piedmont St | Front Yard : Yard | Tree | Private 2 | 07/11/2014 12:00:00 AM | Permit Number 772781 | 5999571.08265 | 2107127.27884 | 37.7657445183673 | -122.444720943629 | (37.7657445183673, -122.444720943629) | 15 | 5 | 5 | 29492 | 9 | ||||
47216 | 112606 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 100X Monument Way | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5999003 | 2105766 | 37.7619743535119 | -122.446587863076 | (37.7619743535119, -122.446587863076) | 15 | 5 | 5 | 29492 | 9 | ||||
47523 | 75088 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 574 WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1985 12:00:00 AM | 18 | 5x5 | 6002936 | 2108949 | 37.7709379654477 | -122.433212606655 | (37.7709379654477, -122.433212606655) | 15 | 5 | 11 | 29492 | 9 | ||
48938 | 102827 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2001X Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
49558 | 113001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700x STANYAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997124 | 2108268 | 37.768736698354 | -122.453267191941 | (37.768736698354, -122.453267191941) | 15 | 5 | 11 | 29492 | 9 | ||||
50629 | 225859 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5998015.01543 | 2107655.1459 | 37.7671049865286 | -122.450141071966 | (37.7671049865286, -122.450141071966) | 15 | 5 | 11 | 29492 | 9 | |||
51409 | 109401 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 1588 WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997977.9 | 2108248 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | 15 | 5 | 11 | 29492 | 9 | ||||
52073 | 119620 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 96 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999423 | 2107768 | 37.7674953262458 | -122.445279199015 | (37.7674953262458, -122.445279199015) | 15 | 5 | 11 | 29492 | 9 | ||||
52254 | 117170 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
52952 | 79881 | Undocumented 4 | Tree(s) :: 17 | 1607-1609 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2014 12:00:00 AM | 3 | Permit Number 773600 | 5997890.57004251 | 2108169.19987562 | 37.768509325571 | -122.450608572711 | (37.768509325571, -122.450608572711) | 15 | 5 | 11 | 29492 | 9 | ||
53009 | 113762 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 130 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x15 | 6001382 | 2109326 | 37.7718848357935 | -122.438614940538 | (37.7718848357935, -122.438614940538) | 15 | 5 | 11 | 29492 | 9 | ||||
54330 | 117521 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1601 PAGE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998904 | 2109014 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | 15 | 5 | 11 | 29492 | 9 | ||||
55032 | 105463 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 1 | 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 | |||
55106 | 102412 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 55X Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
55800 | 108629 | Undocumented 4 | :: 45 | 82-98X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6002862.02202 | 2108710.63631 | 37.7702792804688 | -122.433451461668 | (37.7702792804688, -122.433451461668) | 15 | 5 | 5 | 29492 | 9 | |||
56441 | 110584 | Undocumented 4 | Acer saccharinum :: Silver Maple 271 | 1850 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x13 | 5997708 | 2108904 | 37.7705164467869 | -122.45129306486 | (37.7705164467869, -122.45129306486) | 15 | 5 | 11 | 29492 | 9 | ||||
56765 | 111767 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 4966 17th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5997580.2349427 | 2105651.04183436 | 37.7615773358373 | -122.45150033551 | (37.7615773358373, -122.45150033551) | 15 | 5 | 11 | 29492 | 9 | |||||
58177 | 117520 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1601 PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998904 | 2109014 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | 15 | 5 | 11 | 29492 | 9 | ||||
58767 | 98349 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 225 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002759 | 2109307 | 37.7719109027838 | -122.4338504464 | (37.7719109027838, -122.4338504464) | 15 | 5 | 11 | 29492 | 9 | ||||
58858 | 101856 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1650 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997742 | 2108194 | 37.7685689153589 | -122.451124249867 | (37.7685689153589, -122.451124249867) | 15 | 5 | 11 | 29492 | 9 | ||||
59195 | 93735 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 201@ Page Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on Page St. | 5999812.1 | 2109210.9 | 37.7714793693282 | -122.44403704657 | (37.7714793693282, -122.44403704657) | 15 | 5 | 11 | 29492 | 9 | ||||
59389 | 102825 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2001X Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997438 | 2109144 | 37.7711599615563 | -122.452244312179 | (37.7711599615563, -122.452244312179) | 15 | 5 | 11 | 29492 | 9 | ||||
59927 | 121221 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1639 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5998709 | 2108958 | 37.7707219817969 | -122.4478345011 | (37.7707219817969, -122.4478345011) | 15 | 5 | 11 | 29492 | 9 | ||||
60833 | 102647 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 221 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x9 | 6002283 | 2109227 | 37.7716642197307 | -122.435491238531 | (37.7716642197307, -122.435491238531) | 15 | 5 | 11 | 29492 | 9 | ||||
61627 | 117524 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 ASHBURY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999017 | 2108636 | 37.7698554510238 | -122.446745955589 | (37.7698554510238, -122.446745955589) | 15 | 5 | 11 | 29492 | 9 | ||||
61871 | 117228 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 66 POTOMAC ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003144 | 2108708 | 37.7702880357607 | -122.432475913278 | (37.7702880357607, -122.432475913278) | 15 | 5 | 5 | 29492 | 9 | |||
63264 | 117174 | Undocumented 4 | Tree(s) :: 17 | 299x ALMA ST | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
63335 | 102588 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 222 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002344.3 | 2109244.2 | 37.7717149279992 | -122.435280428905 | (37.7717149279992, -122.435280428905) | 15 | 5 | 11 | 29492 | 9 | |||
65458 | 247322 | Undocumented 4 | :: 45 | 218 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002795.6845 | 2109344.9924 | 37.7720173021936 | -122.433726268045 | (37.7720173021936, -122.433726268045) | 15 | 5 | 11 | 29492 | 9 | ||||
65918 | 117173 | Undocumented 4 | Tree(s) :: 17 | 299x ALMA ST | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
67747 | 255499 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1837 Oak St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998183 | 2109231 | 37.771441491369 | -122.449673611464 | (37.771441491369, -122.449673611464) | 15 | 5 | 11 | 29492 | 9 | ||||
69177 | 116506 | Undocumented 4 | Tree(s) :: 17 | 100X FREDERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999550 | 2107755 | 37.7674668800993 | -122.444838989899 | (37.7674668800993, -122.444838989899) | 15 | 5 | 11 | 29492 | 9 | ||||
69228 | 102411 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
70751 | 110203 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 82 POTOMAC ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003128.3 | 2108821.4 | 37.7705985140517 | -122.432538320625 | (37.7705985140517, -122.432538320625) | 15 | 5 | 5 | 29492 | 9 | ||||
71813 | 108240 | Undocumented 4 | Prunus serrula :: Birchbark Cherry 510 | 163 DELMAR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5999383.5 | 2107248.1 | 37.7660655566694 | -122.445378437485 | (37.7660655566694, -122.445378437485) | 15 | 5 | 5 | 29492 | 9 | |||
71877 | 98351 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 225 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002759 | 2109307 | 37.7719109027838 | -122.4338504464 | (37.7719109027838, -122.4338504464) | 15 | 5 | 11 | 29492 | 9 | ||||
72086 | 108923 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1335 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5999481.5 | 2108169.7 | 37.7686016324565 | -122.445105738432 | (37.7686016324565, -122.445105738432) | 15 | 5 | 11 | 29492 | 9 | ||||
72298 | 108074 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 BUENA VISTA AVE EAST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001336 | 2108482 | 37.7695648051764 | -122.438713569331 | (37.7695648051764, -122.438713569331) | 15 | 5 | 5 | 29492 | 9 | ||||
72569 | 104648 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 833 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5997625 | 2107698 | 37.767200326764 | -122.451493160886 | (37.767200326764, -122.451493160886) | 15 | 5 | 11 | 29492 | 9 | ||||
74559 | 115904 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500x WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003255 | 2109006 | 37.7711125644946 | -122.432113248928 | (37.7711125644946, -122.432113248928) | 15 | 5 | 11 | 29492 | 9 | ||||
75916 | 107960 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 117 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2016 12:00:00 AM | 3 | 5998866 | 2107526 | 37.7667990449831 | -122.447188361508 | (37.7667990449831, -122.447188361508) | 15 | 5 | 11 | 29492 | 9 | |||
75944 | 122778 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1524 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999743 | 2107236 | 37.7660528485452 | -122.444134133437 | (37.7660528485452, -122.444134133437) | 15 | 5 | 5 | 29492 | 9 | |||
77067 | 246157 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1644 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997644.9436 | 2108182.5111 | 37.7685318124906 | -122.451459129436 | (37.7685318124906, -122.451459129436) | 15 | 5 | 11 | 29492 | 9 | |||
77521 | 106628 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 875 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x12 | 5998657.7 | 2107117.8 | 37.7656663268312 | -122.447879442364 | (37.7656663268312, -122.447879442364) | 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) );