trees
835 rows where qSpecies_id = 122 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1329 | 124750 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 566 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004650.035 | 2110687.35997 | 37.7758081630602 | -122.42740756863 | (37.7758081630602, -122.42740756863) | 7 | 9 | 11 | 28852 | 10 | |||
2364 | 38049 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2005 12:00:00 AM | 9 | Permit Number 47797 | 6000509.1373 | 2114490.0048 | 37.7860141835177 | -122.442004950262 | (37.7860141835177, -122.442004950262) | 13 | 6 | 1 | 29490 | 27 | |
8295 | 70299 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 237 Theresa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001826.35316 | 2094025.88285 | 37.7298996296434 | -122.435982902906 | (37.7298996296434, -122.435982902906) | 9 | 7 | 6 | 28861 | 25 | |||
9936 | 203633 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 458 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997727.84983 | 2094119.15999 | 37.7299220605503 | -122.450158563772 | (37.7299220605503, -122.450158563772) | 9 | 7 | 4 | 28861 | 40 | |||
24732 | 219998 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 60 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005981.24616 | 2097649.70039 | 37.7400849896219 | -122.421876240696 | (37.7400849896219, -122.421876240696) | 2 | 7 | 7 | 28859 | 2 | |||
27735 | 38526 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3031 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/1998 12:00:00 AM | 9 | Permit Number 40508 | 6001945.50794 | 2118614.30712 | 37.797420199241 | -122.437330933595 | (37.797420199241, -122.437330933595) | 13 | 9 | 1 | 57 | 17 | ||
36597 | 138344 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001758.896 | 2114311.2519 | 37.7855945128702 | -122.437668325433 | (37.7855945128702, -122.437668325433) | 13 | 6 | 1 | 29490 | 27 | |||
44328 | 203663 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 271 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998288.80546 | 2093783.09686 | 37.7290313953773 | -122.448195092827 | (37.7290313953773, -122.448195092827) | 9 | 7 | 4 | 28861 | 40 | |||
50536 | 203666 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 123 Detroit St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999405.93855 | 2093561.74161 | 37.7284874062446 | -122.4443171901 | (37.7284874062446, -122.4443171901) | 9 | 7 | 4 | 28861 | 40 | |||
52115 | 220667 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1337 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007176.02734 | 2107716.44116 | 37.7677932655629 | -122.418458791748 | (37.7677932655629, -122.418458791748) | 8 | 4 | 7 | 28853 | 19 | |||
57640 | 103887 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5999387.5565 | 2110861.3404 | 37.7759868308232 | -122.445624264682 | (37.7759868308232, -122.445624264682) | 15 | 5 | 11 | 29492 | 16 | |||
62285 | 203225 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1575 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993973.71625 | 2104850.02282 | 37.759170760037 | -122.463915566851 | (37.759170760037, -122.463915566851) | 1 | 5 | 4 | 56 | 12 | |||
64954 | 220029 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4107 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6002428.99773 | 2102359.29201 | 37.7528154507744 | -122.434495098689 | (37.7528154507744, -122.434495098689) | 2 | 4 | 5 | 28862 | 22 | |||
65997 | 203662 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 337 Detroit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5999398.70847 | 2094267.55477 | 37.7304249920009 | -122.444392887823 | (37.7304249920009, -122.444392887823) | 9 | 7 | 4 | 28861 | 40 | |||
67998 | 67547 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1125 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 9 | Permit Number 31093 | 6011962.71401 | 2103154.98207 | 37.7555368181877 | -122.401581480218 | (37.7555368181877, -122.401581480218) | 10 | 3 | 8 | 28856 | 29 | |
68143 | 31468 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 523 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 9 | Permit Number 35034 | 6002955.92893 | 2102097.86396 | 37.7521275287632 | -122.432654202633 | (37.7521275287632, -122.432654202633) | 2 | 4 | 5 | 28862 | 22 | |
68294 | 66858 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 103 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1991 12:00:00 AM | 9 | Permit Number 30164 | 5998644.577 | 2110362.2819 | 37.7745740983013 | -122.448158471707 | (37.7745740983013, -122.448158471707) | 15 | 5 | 11 | 29492 | 16 | ||
74183 | 40818 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | 9 | Permit Number 41760 | 6001596.2583 | 2114468.8718 | 37.786018048063 | -122.438242299207 | (37.786018048063, -122.438242299207) | 13 | 6 | 1 | 29490 | 27 | ||
75113 | 140103 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1720 FULTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999438.9967 | 2110868.4473 | 37.776009281241 | -122.44544683133 | (37.776009281241, -122.44544683133) | 15 | 5 | 11 | 29492 | 16 | |||
90686 | 188520 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013272.40757 | 2104812.59187 | 37.7601612472551 | -122.397168349564 | (37.7601612472551, -122.397168349564) | 10 | 3 | 8 | 28856 | 29 | |||
93860 | 203660 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998582.52704 | 2094910.55882 | 37.7321439273893 | -122.447260791654 | (37.7321439273893, -122.447260791654) | 9 | 7 | 4 | 59 | 40 | |||
95811 | 182146 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1690 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5989681.6149 | 2103872.2722 | 37.756237834999 | -122.478688039412 | (37.756237834999, -122.478688039412) | 1 | 8 | 3 | 56 | 35 | |||
102390 | 124752 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2478 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | 9 | Width 5ft | 6002956.6534 | 2115870.86114 | 37.7899448329366 | -122.433635939447 | (37.7899448329366, -122.433635939447) | 13 | 9 | 1 | 29490 | 27 | ||
106618 | 203641 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 608 Garfield St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5992400.09934 | 2090515.70507 | 37.7197215370907 | -122.468315017932 | (37.7197215370907, -122.468315017932) | 9 | 8 | 6 | 64 | 24 | |||
112319 | 138353 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001742.4732 | 2114607.6747 | 37.7864074802067 | -122.437746380915 | (37.7864074802067, -122.437746380915) | 13 | 6 | 1 | 29490 | 27 | |||
117088 | 42651 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1924 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 9 | Permit Number 42691 | 6004339.89147 | 2118073.88126 | 37.7960721541703 | -122.429007191848 | (37.7960721541703, -122.429007191848) | 13 | 9 | 1 | 57 | 17 | |
121599 | 32348 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 9 | Permit Number 37068 | 5985188.5725 | 2106987.4184 | 37.764529258945 | -122.494455919418 | (37.764529258945, -122.494455919418) | 1 | 8 | 3 | 56 | 35 | |
124853 | 220670 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 948 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009928.95694 | 2103687.06035 | 37.7568840925314 | -122.408652407882 | (37.7568840925314, -122.408652407882) | 2 | 4 | 7 | 28859 | 19 | |||
135943 | 124760 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1055 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007817.3795 | 2119902.39919 | 37.8012890341312 | -122.417103992782 | (37.8012890341312, -122.417103992782) | 5 | 1 | 1 | 308 | 32 | |||
158321 | 220696 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 407 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998482.20862 | 2106820.01065 | 37.7648386401035 | -122.448464978478 | (37.7648386401035, -122.448464978478) | 15 | 5 | 11 | 29492 | 9 | |||
162974 | 250192 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Alta St | 2 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011786.88966 | 2119947.0785 | 37.8016342173021 | -122.403370805543 | (37.8016342173021, -122.403370805543) | 3 | 1 | 10 | 308 | 23 | |||
162982 | 19284 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1998 12:00:00 AM | 9 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | ||
163483 | 34234 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/1997 12:00:00 AM | 9 | Permit Number 38047 | 6009059.1086 | 2121116.8197 | 37.8046933049163 | -122.412892958068 | (37.8046933049163, -122.412892958068) | 3 | 1 | 10 | 308 | 23 | ||
166110 | 50534 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1853 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | 9 | Permit Number 47173 | 6004174.32371 | 2118346.10209 | 37.7968102295769 | -122.429599513219 | (37.7968102295769, -122.429599513219) | 13 | 9 | 1 | 57 | 17 | ||
172635 | 44033 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 230 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/2000 12:00:00 AM | 9 | Permit Number 43569 | 5998819.8857 | 2109894.1205 | 37.7732986671632 | -122.447518341015 | (37.7732986671632, -122.447518341015) | 15 | 5 | 11 | 29492 | 16 | |
172691 | 203632 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1400 Monterey Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5993831.29855 | 2094857.6984 | 37.7317261536347 | -122.463682879865 | (37.7317261536347, -122.463682879865) | 9 | 8 | 4 | 59 | 40 | |||
173566 | 203636 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 418 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997970.50252 | 2094115.71728 | 37.7299264906074 | -122.449319440552 | (37.7299264906074, -122.449319440552) | 9 | 7 | 4 | 28861 | 40 | |||
178676 | 220017 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 78 Berkeley Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001185.23014 | 2097348.08527 | 37.7389851844145 | -122.438437264296 | (37.7389851844145, -122.438437264296) | 2 | 7 | 5 | 63 | 7 | |||
184117 | 141691 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996753.535 | 2112367.4021 | 37.7799713474759 | -122.45484482437 | (37.7799713474759, -122.45484482437) | 15 | 6 | 2 | 54 | 16 | |||
185050 | 39226 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 770 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 9 | Permit Number 40869 | 5984798.64138 | 2110605.07298 | 37.774439483359 | -122.49607147975 | (37.774439483359, -122.49607147975) | 11 | 6 | 2 | 55 | 26 | ||
186545 | 103891 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5999322.5796 | 2110851.5262 | 37.7759561736689 | -122.445848329979 | (37.7759561736689, -122.445848329979) | 15 | 5 | 11 | 29492 | 16 | |||
3321 | 220066 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002537.11463 | 2102291.14962 | 37.7526344847082 | -122.434116340213 | (37.7526344847082, -122.434116340213) | 2 | 4 | 5 | 28862 | 22 | |||
5047 | 37814 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003977.37565 | 2090552.2455 | 37.720483755714 | -122.428299091747 | (37.720483755714, -122.428299091747) | 9 | 7 | 6 | 28861 | 5 |
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 | |
11831 | 66789 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1405 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30063 | 6006130.65101914 | 2119658.78326709 | 37.8005250955758 | -122.42292350049 | (37.8005250955758, -122.42292350049) | 13 | 9 | 1 | 28858 | 32 |
13458 | 37949 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40189 | 6013245.07108 | 2104267.20859 | 37.7586622221997 | -122.397224649796 | (37.7586622221997, -122.397224649796) | 10 | 3 | 8 | 28856 | 29 | |
13642 | 78061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 107 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6006671.07774 | 2094291.78297 | 37.7309037694737 | -122.419252940787 | (37.7309037694737, -122.419252940787) | 9 | 3 | 7 | 309 | 28 | |||
14412 | 71308 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1949 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6000243.5 | 2111616.6716 | 37.7781096083019 | -122.442717588877 | (37.7781096083019, -122.442717588877) | 15 | 5 | 11 | 29490 | 16 | |||
15666 | 44745 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1520 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2001 12:00:00 AM | 8 | Permit Number 43862 | 6006829.6851 | 2117719.85237 | 37.7952406976494 | -122.420366856354 | (37.7952406976494, -122.420366856354) | 13 | 9 | 10 | 28858 | 32 | ||
22960 | 54500 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31133 | 6013270.33865 | 2104862.70543 | 37.760298732933 | -122.397179019096 | (37.760298732933, -122.397179019096) | 10 | 3 | 8 | 28856 | 29 | |
25803 | 35250 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1385 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | Permit Number 38738 | 6006287.30636 | 2119683.41372 | 37.8006015626823 | -122.42238315977 | (37.8006015626823, -122.42238315977) | 13 | 9 | 1 | 28858 | 32 | |
26523 | 40816 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | 8 | Permit Number 41760 | 6001593.7276 | 2114497.5525 | 37.7860966539785 | -122.438253110129 | (37.7860966539785, -122.438253110129) | 13 | 6 | 1 | 29490 | 27 | ||
28674 | 220021 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1334 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001964.61353 | 2100084.23013 | 37.7465422991033 | -122.435938247064 | (37.7465422991033, -122.435938247064) | 2 | 7 | 5 | 63 | 22 | |||
28963 | 203665 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 123 Detroit St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999403.44951 | 2093584.38933 | 37.7285494495997 | -122.444327421686 | (37.7285494495997, -122.444327421686) | 9 | 7 | 4 | 28861 | 40 | |||
34409 | 188513 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 55 Mississippi St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6013999.87449 | 2106891.97216 | 37.7659112417232 | -122.394797995654 | (37.7659112417232, -122.394797995654) | 14 | 3 | 8 | 28856 | 20 | |||
37421 | 37816 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003955.66683 | 2090537.19552 | 37.720441203374 | -122.428373060073 | (37.720441203374, -122.428373060073) | 9 | 7 | 6 | 28861 | 5 |
41632 | 220030 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4136 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002251.88877 | 2102392.9278 | 37.7528977513337 | -122.435109978657 | (37.7528977513337, -122.435109978657) | 2 | 4 | 5 | 28862 | 22 | |||
43377 | 23032 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 937 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2003 12:00:00 AM | 8 | 3X3 | 6006338.92475 | 2104110.62405 | 37.7578453778742 | -122.421098173366 | (37.7578453778742, -122.421098173366) | 2 | 4 | 7 | 28859 | 19 | ||
44119 | 220040 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 816 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6001002.40026 | 2102614.77247 | 37.7534358534934 | -122.439446835117 | (37.7534358534934, -122.439446835117) | 2 | 4 | 5 | 28862 | 22 | |||
49903 | 37828 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2006 12:00:00 AM | 8 | 3x3 | Permit Number 48867 | 6003752 | 2090699 | 37.720873955994 | -122.429088601305 | (37.720873955994, -122.429088601305) | 9 | 7 | 6 | 28861 | 5 |
51715 | 220032 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4496 24th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6000063.08667 | 2101692.20447 | 37.7508492036437 | -122.442628935085 | (37.7508492036437, -122.442628935085) | 2 | 4 | 5 | 28862 | 22 | |||
55154 | 220686 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004903.16789 | 2110400.70337 | 37.7750353872943 | -122.426511501216 | (37.7750353872943, -122.426511501216) | 7 | 9 | 11 | 28852 | 10 | |||
55913 | 203667 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999360.3584 | 2093511.22392 | 37.7283460957947 | -122.444471133337 | (37.7283460957947, -122.444471133337) | 9 | 7 | 4 | 28861 | 40 | |||
59237 | 138342 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001808.8392 | 2114319.4393 | 37.7856198329437 | -122.437496123305 | (37.7856198329437, -122.437496123305) | 13 | 6 | 1 | 29490 | 27 | |||
60350 | 103893 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5999294.1521 | 2110847.1267 | 37.7759424705585 | -122.445946351246 | (37.7759424705585, -122.445946351246) | 15 | 5 | 11 | 29492 | 16 | |||
64077 | 40191 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 600 Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008969.32072 | 2093798.8519 | 37.7296794522306 | -122.411272698701 | (37.7296794522306, -122.411272698701) | 9 | 3 | 7 | 309 | 28 | ||
72507 | 35266 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2323 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | 3x3 | Permit Number 38750 | 6006292.04033 | 2118835.34945 | 37.798273260158 | -122.422306489847 | (37.798273260158, -122.422306489847) | 13 | 9 | 10 | 28858 | 32 |
75953 | 40189 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 600 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008978.52665 | 2093804.69628 | 37.7296960159571 | -122.411241285381 | (37.7296960159571, -122.411241285381) | 9 | 3 | 7 | 309 | 28 | ||
76610 | 138346 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 SCOTT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001590.3534 | 2114514.4235 | 37.7861427855089 | -122.438265993007 | (37.7861427855089, -122.438265993007) | 13 | 6 | 1 | 29490 | 27 | |||
77172 | 220000 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 62 Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006013.90538 | 2097631.08265 | 37.7400357112669 | -122.421761996217 | (37.7400357112669, -122.421761996217) | 2 | 7 | 7 | 28859 | 2 | |||
78215 | 182147 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1690 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5989680.1915 | 2103890.3009 | 37.756287254354 | -122.478694280415 | (37.756287254354, -122.478694280415) | 1 | 8 | 3 | 56 | 35 | |||
80555 | 37837 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 23 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752 | 2090699 | 37.720873955994 | -122.429088601305 | (37.720873955994, -122.429088601305) | 9 | 7 | 6 | 28861 | 5 |
80692 | 248081 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1624 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010444.64523 | 2100169.33268 | 37.7472540585408 | -122.406621069628 | (37.7472540585408, -122.406621069628) | 2 | 7 | 7 | 28859 | 2 | |||
81981 | 220076 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4512 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6001006.90228 | 2104666.03653 | 37.7590683830131 | -122.43957830609 | (37.7590683830131, -122.43957830609) | 2 | 4 | 5 | 28862 | 3 | |||
86180 | 139098 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2600 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999639.9141 | 2113670.3506 | 37.7837140544374 | -122.444953272956 | (37.7837140544374, -122.444953272956) | 15 | 6 | 11 | 29490 | 31 | |||
90348 | 220027 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 685 Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001922.66093 | 2102622.77824 | 37.7535101653675 | -122.436264956357 | (37.7535101653675, -122.436264956357) | 2 | 4 | 5 | 28862 | 22 | |||
91942 | 30799 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 131 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 8 | Permit Number 34665 | 6002107.11402 | 2095231.84638 | 37.7332268757153 | -122.43509850062 | (37.7332268757153, -122.43509850062) | 9 | 7 | 5 | 63 | 40 | |
94484 | 49584 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 400REVISED Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2003 12:00:00 AM | 8 | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | 2 | 7 | 7 | 28859 | 2 | ||
95221 | 40190 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 600 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008992.69015 | 2093809.01989 | 37.729708681998 | -122.411192625738 | (37.729708681998, -122.411192625738) | 9 | 3 | 7 | 309 | 28 | ||
104223 | 44327 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1586 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2001 12:00:00 AM | 8 | 2x3 | Permit Number 43713 | 5997934.27114243 | 2105194.99069947 | 37.7603454014574 | -122.45024300053 | (37.7603454014574, -122.45024300053) | 15 | 5 | 11 | 29492 | 12 | |
104471 | 34233 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1690 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1997 12:00:00 AM | 8 | Permit Number 38046 | 5989683.0382 | 2103856.1412 | 37.7561936262155 | -122.478681937543 | (37.7561936262155, -122.478681937543) | 1 | 8 | 3 | 56 | 35 | ||
104939 | 203661 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 582 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5997537.55728 | 2095290.58786 | 37.7331276310309 | -122.450900858796 | (37.7331276310309, -122.450900858796) | 9 | 7 | 4 | 59 | 40 | |||
104988 | 44248 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1960 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2001 12:00:00 AM | 8 | Permit Number 43683 | 5999863.26477 | 2121264.87303 | 37.8045793513217 | -122.444726628942 | (37.8045793513217, -122.444726628942) | 13 | 9 | 1 | 57 | 17 | ||
107495 | 203637 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 270 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998290.1238 | 2093810.02027 | 37.7291053960882 | -122.448192473116 | (37.7291053960882, -122.448192473116) | 9 | 7 | 4 | 28861 | 40 | |||
108665 | 19283 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | |||
109457 | 34758 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 8 | Permit Number 38402 | 6007966.74070994 | 2102458.08144685 | 37.7533995021275 | -122.415351503246 | (37.7533995021275, -122.415351503246) | 2 | 4 | 7 | 28859 | 19 | |
120961 | 219995 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1426 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007991.10477 | 2099694.15634 | 37.7458117546099 | -122.415071624753 | (37.7458117546099, -122.415071624753) | 2 | 7 | 7 | 28859 | 2 | |||
127772 | 220012 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 30 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006012.22422 | 2102309.19405 | 37.7528806462302 | -122.422100066676 | (37.7528806462302, -122.422100066676) | 2 | 4 | 5 | 28859 | 19 | |||
132811 | 140104 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999428.844 | 2110866.7552 | 37.7760040555772 | -122.445481830363 | (37.7760040555772, -122.445481830363) | 15 | 5 | 11 | 29492 | 16 | |||
133075 | 220697 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 897 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998695.14565 | 2106960.91022 | 37.7652376872994 | -122.447738631145 | (37.7652376872994, -122.447738631145) | 15 | 5 | 11 | 29492 | 9 | |||
133217 | 220022 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1334 Diamond St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001965.37109 | 2100066.86744 | 37.746494668289 | -122.435934385359 | (37.746494668289, -122.435934385359) | 2 | 7 | 5 | 63 | 22 | |||
139911 | 38043 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1523 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 8 | Permit Number 40245 | 6000097.0958 | 2114311.3232 | 37.7855000811005 | -122.443417658382 | (37.7855000811005, -122.443417658382) | 15 | 6 | 1 | 29490 | 31 | |
142155 | 249709 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2901 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | 8 | 5999701.30683 | 2117014.48804 | 37.7928996850292 | -122.444981360099 | (37.7928996850292, -122.444981360099) | 13 | 9 | 1 | 29490 | 27 | ||||
146171 | 220087 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 69 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001718.50654 | 2105457.8427 | 37.7612829653482 | -122.437173938027 | (37.7612829653482, -122.437173938027) | 15 | 4 | 5 | 28862 | 3 | |||
147017 | 48447 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2600 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2002 12:00:00 AM | 8 | Permit Number 45819 | 5999656.5928 | 2113671.6674 | 37.7837186219049 | -122.44489566585 | (37.7837186219049, -122.44489566585) | 15 | 6 | 11 | 29490 | 31 | ||
153263 | 220666 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1 Dorland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005487.19676 | 2105743.72088 | 37.7622814268651 | -122.424159948522 | (37.7622814268651, -122.424159948522) | 8 | 4 | 5 | 28859 | 19 | |||
160558 | 219997 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 80 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007927.7529 | 2099409.54394 | 37.7450267121064 | -122.41527054312 | (37.7450267121064, -122.41527054312) | 2 | 7 | 7 | 28859 | 2 | |||
161026 | 174958 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 60 Onondaga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000890.31977 | 2091107.65045 | 37.7218336102096 | -122.439009814053 | (37.7218336102096, -122.439009814053) | 9 | 7 | 6 | 28861 | 25 | |||
167480 | 220034 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 622 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002480.9934 | 2100067.16006 | 37.7465247497217 | -122.434151443447 | (37.7465247497217, -122.434151443447) | 2 | 7 | 5 | 63 | 22 | |||
169839 | 36186 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 133 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 8 | Permit Number 39255 | 5995881.41756 | 2113499.8369 | 37.783030646722 | -122.45794382331 | (37.783030646722, -122.45794382331) | 11 | 6 | 1 | 54 | 31 |
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) );