trees
835 rows where qSpecies_id = 122 sorted by YCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
41332 | 249768 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 266 Lombard St | 4 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6010977.12206 | 2120702.10235 | 37.8036620671076 | -122.406226211476 | (37.8036620671076, -122.406226211476) | 3 | 1 | 10 | 308 | 23 | |||
166730 | 71427 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1852 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2017 12:00:00 AM | 3 | 4x4 | 6009993.7542 | 2120480.0499 | 37.8029973115711 | -122.409613538987 | (37.8029973115711, -122.409613538987) | 3 | 1 | 10 | 308 | 23 | |
2461 | 73754 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1815 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009969.6946 | 2120303.1237 | 37.8025101678048 | -122.409684302662 | (37.8025101678048, -122.409684302662) | 3 | 1 | 10 | 308 | 23 | |||
144059 | 66784 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 20 Culebra Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/1992 12:00:00 AM | Permit Number 30056 | 6006381.97640479 | 2120210.98917161 | 37.8020554906142 | -122.422093063103 | (37.8020554906142, -122.422093063103) | 5 | 9 | 1 | 28858 | 32 | ||
103175 | 35258 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1304 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 11 | Permit Number 38744 | 6006066.5782 | 2120048.78389 | 37.8015923223752 | -122.423172956092 | (37.8015923223752, -122.423172956092) | 5 | 9 | 1 | 28858 | 32 | |
43532 | 250193 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Alta St | 3 | Back Yard : Yard | Tree | Private 2 | 35 | Width 0ft | 6011782.39923 | 2119949.71509 | 37.8016412059365 | -122.403386530161 | (37.8016412059365, -122.403386530161) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
94924 | 250191 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Alta St | 1 | Back Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6011795.08799 | 2119945.2148 | 37.8016295579248 | -122.403342304231 | (37.8016295579248, -122.403342304231) | 3 | 1 | 10 | 308 | 23 | |||
142595 | 124762 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1055 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007906.12641 | 2119914.20021 | 37.8013264288216 | -122.416797725058 | (37.8013264288216, -122.416797725058) | 5 | 1 | 1 | 308 | 32 | |||
155399 | 124761 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1055 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007856.93229 | 2119906.6476 | 37.8013029241584 | -122.416967423511 | (37.8013029241584, -122.416967423511) | 5 | 1 | 1 | 308 | 32 | |||
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 | |||
35015 | 50381 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1330 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2003 12:00:00 AM | 6 | 3x3 | Permit Number 47040 | 6006481.85746 | 2119759.67415 | 37.8008219271496 | -122.421715351995 | (37.8008219271496, -122.421715351995) | 13 | 9 | 1 | 28858 | 32 | |
91842 | 50382 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1330 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2003 12:00:00 AM | 4 | Permit Number 47040 | 6006491.715 | 2119759.4717 | 37.8008219271374 | -122.421681226333 | (37.8008219271374, -122.421681226333) | 13 | 9 | 1 | 28858 | 32 | ||
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 | |
34736 | 35252 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1385 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 7 | Permit Number 38738 | 6006246.10083 | 2119680.0646 | 37.8005900423666 | -122.422525509838 | (37.8005900423666, -122.422525509838) | 13 | 9 | 1 | 28858 | 32 | |
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 |
189089 | 124759 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2534 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006240.40404 | 2119512.60207 | 37.8001299114167 | -122.422533316862 | (37.8001299114167, -122.422533316862) | 13 | 9 | 1 | 28858 | 32 | |||
191158 | 102771 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1438 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006063.66154 | 2119354.00796 | 37.7996844799161 | -122.423133635925 | (37.7996844799161, -122.423133635925) | 13 | 9 | 1 | 28858 | 32 | |||
175021 | 42685 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2335 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 8 | Permit Number 42709 | 6006717.2254 | 2119230.45195 | 37.7993820864644 | -122.420863284838 | (37.7993820864644, -122.420863284838) | 5 | 9 | 1 | 28858 | 32 | |
16743 | 50472 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | |
147231 | 50471 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | |
169107 | 50470 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | ||
174508 | 50469 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | |
76223 | 33122 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2363 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37356 | 6001608.80596075 | 2119029.55221322 | 37.7985412065447 | -122.438525775033 | (37.7985412065447, -122.438525775033) | 13 | 9 | 1 | 57 | 17 | ||
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 |
64202 | 253615 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006221 | 2118816 | 37.7982161239914 | -122.422550935399 | (37.7982161239914, -122.422550935399) | 13 | 9 | 10 | 28858 | 32 | ||
137852 | 35265 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006296.38753209 | 2118756.6266107 | 37.7980573523528 | -122.422285851072 | (37.7980573523528, -122.422285851072) | 13 | 9 | 10 | 28858 | 32 | |
99336 | 33133 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3016 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37363 | 6001491.05795368 | 2118756.44455004 | 37.7977846260596 | -122.438913636839 | (37.7977846260596, -122.438913636839) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||
177563 | 38525 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3031 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/1998 12:00:00 AM | 11 | Permit Number 40508 | 6001946.95136 | 2118602.51648 | 37.7973879072825 | -122.437325094293 | (37.7973879072825, -122.437325094293) | 13 | 9 | 1 | 57 | 17 | ||
112476 | 38501 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2133 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1998 12:00:00 AM | Permit Number 40492 | 6006816.69957876 | 2118509.8967936 | 37.7974092298161 | -122.420467894474 | (37.7974092298161, -122.420467894474) | 13 | 9 | 10 | 28858 | 32 | ||
33613 | 49479 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 560@ Pacific Davis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145 | (37.7976666140298, -122.39835845145) | 3 | 1 | 10 | 28860 | 6 | |||
60595 | 49477 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 560@ Pacific Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145 | (37.7976666140298, -122.39835845145) | 3 | 1 | 10 | 28860 | 6 | |||
161776 | 49478 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 560@ Pacific Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145 | (37.7976666140298, -122.39835845145) | 3 | 1 | 10 | 28860 | 6 | |||
68255 | 42696 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1751 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 7 | Permit Number 42713 | 6007796.58473 | 2118447.48214 | 37.7972930261196 | -122.417072803384 | (37.7972930261196, -122.417072803384) | 5 | 1 | 10 | 28858 | 32 | |
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 | ||
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 | |
109176 | 45035 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2306 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43925 | 6002524.20413383 | 2117822.12502906 | 37.7952779539251 | -122.435271803602 | (37.7952779539251, -122.435271803602) | 13 | 9 | 1 | 57 | 17 | |||
138647 | 44744 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1520 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2001 12:00:00 AM | 6 | Permit Number 43862 | 6006848.33301 | 2117722.6808 | 37.7952495146165 | -122.420302532344 | (37.7952495146165, -122.420302532344) | 13 | 9 | 10 | 28858 | 32 | ||
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 | ||
15280 | 124754 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2077 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 784537 | 6003727.74275 | 2117577.18944 | 37.7946736966861 | -122.431089877801 | (37.7946736966861, -122.431089877801) | 13 | 9 | 1 | 29490 | 27 | |
69468 | 124758 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1513 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006956.23003 | 2117363.82528 | 37.7942702662113 | -122.419903713582 | (37.7942702662113, -122.419903713582) | 13 | 9 | 10 | 28858 | 32 | |||
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 | ||||
76011 | 124753 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2109 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999833.99614 | 2116225.74938 | 37.7907415881946 | -122.444465538654 | (37.7907415881946, -122.444465538654) | 13 | 6 | 1 | 29490 | 27 | |||
79064 | 50672 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3305 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47252 | 5998970.56266258 | 2115921.05690667 | 37.7898556796393 | -122.447431022041 | (37.7898556796393, -122.447431022041) | 13 | 6 | 1 | 54 | 31 | ||||
135042 | 50673 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3305 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47252 | 5998970.56266258 | 2115921.05690667 | 37.7898556796393 | -122.447431022041 | (37.7898556796393, -122.447431022041) | 13 | 6 | 1 | 54 | 31 | ||||
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 | ||
29891 | 138357 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001830.9567 | 2114618.7351 | 37.7864428800724 | -122.437441043234 | (37.7864428800724, -122.437441043234) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||
138145 | 138352 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001715.4366 | 2114603.3734 | 37.7863941325812 | -122.437839612353 | (37.7863941325812, -122.437839612353) | 13 | 6 | 1 | 29490 | 27 | |||
118283 | 138351 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001690.7359 | 2114600.4656 | 37.7863847439093 | -122.437924862001 | (37.7863847439093, -122.437924862001) | 13 | 6 | 1 | 29490 | 27 | |||
75851 | 138350 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001659.5245 | 2114595.4043 | 37.7863690719611 | -122.438032482637 | (37.7863690719611, -122.438032482637) | 13 | 6 | 1 | 29490 | 27 | |||
110471 | 138348 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001613.9728 | 2114589.4995 | 37.786350268304 | -122.43818965646 | (37.786350268304, -122.43818965646) | 13 | 6 | 1 | 29490 | 27 | |||
185557 | 138347 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 SCOTT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001586.1357 | 2114554.9139 | 37.7862537218777 | -122.438283486898 | (37.7862537218777, -122.438283486898) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||
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 | ||
177732 | 38051 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 0 | Permit Number 40248 | 6000571.40891222 | 2114495.1875697 | 37.7860319624569 | -122.441789880059 | (37.7860319624569, -122.441789880059) | 13 | 6 | 1 | 29490 | 27 | |
4729 | 38050 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2005 12:00:00 AM | 3 | Permit Number 47797 | 6000529.6397 | 2114492.1859 | 37.7860213405762 | -122.441934174319 | (37.7860213405762, -122.441934174319) | 13 | 6 | 1 | 29490 | 27 | |
11039 | 19285 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1998 12:00:00 AM | 11 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | ||
59125 | 19282 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | |||
102025 | 19281 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||
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 | ||
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 | |
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 | ||
4696 | 117040 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
25580 | 117035 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
32201 | 117042 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
59827 | 117033 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
86594 | 117034 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
178228 | 117038 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
50427 | 40817 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1999 12:00:00 AM | 10 | Permit Number 41760 | 6001600.476 | 2114446.9395 | 37.7859580674702 | -122.438226135379 | (37.7859580674702, -122.438226135379) | 13 | 6 | 1 | 29490 | 27 | |
18343 | 38054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2779 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 7 | Permit Number 40250 | 6000242.4339 | 2114393.9483 | 37.7857352353713 | -122.442920768491 | (37.7857352353713, -122.442920768491) | 15 | 6 | 1 | 29490 | 27 | |
10486 | 38055 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2779 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 5 | Permit Number 40250 | 6000228.6146 | 2114392.8852 | 37.7857315284908 | -122.442968502827 | (37.7857315284908, -122.442968502827) | 15 | 6 | 1 | 29490 | 27 | |
111975 | 102846 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 29 Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 1x1 | 6014262.35987 | 2114356.78408 | 37.7864225266356 | -122.394412832193 | (37.7864225266356, -122.394412832193) | 6 | 2 | 9 | 28855 | 6 | |||
11891 | 38044 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1523 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 11 | Permit Number 40245 | 6000092.6356 | 2114341.0582 | 37.7855814713487 | -122.443435225951 | (37.7855814713487, -122.443435225951) | 15 | 6 | 1 | 29490 | 31 | |
141281 | 138337 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001955.803 | 2114338.6797 | 37.7856810164636 | -122.436989049911 | (37.7856810164636, -122.436989049911) | 13 | 6 | 1 | 29490 | 27 | |||
149936 | 138338 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001931.2408 | 2114335.4048 | 37.7856706283151 | -122.437073793387 | (37.7856706283151, -122.437073793387) | 13 | 6 | 1 | 29490 | 27 | |||
67493 | 138339 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001909.1348 | 2114331.7204 | 37.7856592553419 | -122.437150009777 | (37.7856592553419, -122.437150009777) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||
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 | |
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 | |||
137380 | 138778 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001713.8653 | 2114306.3395 | 37.785578464198 | -122.437823766308 | (37.785578464198, -122.437823766308) | 13 | 6 | 1 | 29490 | 27 | |||
164166 | 102849 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 31 Guy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1x1 | 6014185 | 2114270 | 37.7861799368485 | -122.394674400267 | (37.7861799368485, -122.394674400267) | 6 | 2 | 9 | 28855 | 6 | |||
110436 | 117044 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2297 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6001629.48989293 | 2114242.74964382 | 37.7853990645293 | -122.438111123258 | (37.7853990645293, -122.438111123258) | 13 | 6 | 11 | 29490 | 13 | |||
37768 | 43179 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2299 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42985 | 6001635.1083 | 2114240.3384 | 37.7853927633961 | -122.438091512505 | (37.7853927633961, -122.438091512505) | 13 | 6 | 11 | 29490 | 13 |
184532 | 138533 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2299 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001645.5525 | 2114240.3384 | 37.7853933573613 | -122.438055378776 | (37.7853933573613, -122.438055378776) | 13 | 6 | 11 | 29490 | 13 | |||
112973 | 38068 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2299 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1998 12:00:00 AM | Permit Number 40258 | 6001654 | 2114215 | 37.7853242650019 | -122.438024337369 | (37.7853242650019, -122.438024337369) | 13 | 6 | 11 | 29490 | 13 | |||
48530 | 38069 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1654X SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1998 12:00:00 AM | Permit Number 40258 | 6001625 | 2114095 | 37.7849931264589 | -122.438116069267 | (37.7849931264589, -122.438116069267) | 15 | 6 | 11 | 29490 | 13 | |||
20553 | 68132 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1526 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 0 | Permit Number 31884 | 6000696.86081651 | 2113890.04393367 | 37.7843775414062 | -122.44131241544 | (37.7843775414062, -122.44131241544) | 15 | 6 | 11 | 29490 | 13 | |
119519 | 57975 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2602 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1983 12:00:00 AM | Permit Number 20908 | 5999705.92548521 | 2113681.4260983 | 37.7837482320799 | -122.444725695659 | (37.7837482320799, -122.444725695659) | 15 | 6 | 11 | 29490 | 31 | ||
147281 | 109502 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2604 POST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999699 | 2113674 | 37.7837274467295 | -122.444749121189 | (37.7837274467295, -122.444749121189) | 15 | 6 | 11 | 29490 | 31 | ||||
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 | ||
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 | |||
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 | |
129086 | 43661 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 370 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43304 | 5992506.56767844 | 2112958.60482073 | 37.781350097045 | -122.46957990283 | (37.781350097045, -122.46957990283) | 11 | 6 | 2 | 54 | 11 | ||
16325 | 38333 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 684 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40387 | 6006701.38591008 | 2112874.96361955 | 37.7819305989802 | -122.420466726707 | (37.7819305989802, -122.420466726707) | 7 | 9 | 9 | 28852 | 36 | |||
71243 | 50520 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 85 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 5 | Permit Number 47158 | 5996681.6204 | 2112482.6347 | 37.7802836203489 | -122.455101936973 | (37.7802836203489, -122.455101936973) | 11 | 6 | 2 | 54 | 16 |
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) );