8,298 rows where qLegalStatus_id = 4 sorted by Neighborhoods (old) descending

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);