Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlotSize
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185933 | 185933 | 47492 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 657 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45386 | 6001676.19021 | 2093232.03842 | 37.7277113821718 | -122.43644523806499 | (37.7277113821718, -122.436445238065) | |
184245 | 184245 | 50918 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2477 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | 3 | Permit Number 47420 | 5989820.2795 | 2098517.5722 | 37.7415432867093 | -122.477817075256 | (37.7415432867093, -122.477817075256) | |
180708 | 180708 | 65972 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2090 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 2 | Permit Number 28996 | 5989155.2561 | 2101119.0911 | 37.74864775647529 | -122.480306841406 | (37.7486477564753, -122.480306841406) | |
179097 | 179097 | 30759 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1563 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 5 | Permit Number 48354 | 6014932.9973 | 2093776.0212 | 37.7299494300904 | -122.39065386327499 | (37.7299494300904, -122.390653863275) | |
176558 | 176558 | 38592 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1618 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 2 | Permit Number 40547 | 6015152.7308 | 2094735.8699 | 37.7325971695789 | -122.389961235194 | (37.7325971695789, -122.389961235194) | |
174016 | 174016 | 65967 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2562 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | 7 | Permit Number 28991 | 5989886.449 | 2097917.9756 | 37.7399007896882 | -122.477544471364 | (37.7399007896882, -122.477544471364) | |
173694 | 173694 | 95910 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1863 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767611 | 5986268.2408 | 2102571.6706 | 37.75246795898221 | -122.49039681822201 | (37.7524679589822, -122.490396818222) |
168083 | 168083 | 32398 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 244 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | 8 | Permit Number 36939 | 6005971.23324 | 2096091.5920900002 | 37.7358062077876 | -122.42180021560199 | (37.7358062077876, -122.421800215602) | |
164832 | 164832 | 71420 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 637 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 5 | 6009832.0273 | 2120182.0847 | 37.8021701092209 | -122.410152151595 | (37.8021701092209, -122.410152151595) | ||
163888 | 163888 | 38590 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1614 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 2 | Permit Number 40545 | 6015168.4288 | 2094722.1342 | 37.732560324707705 | -122.38990600380698 | (37.7325603247077, -122.389906003807) | |
160564 | 160564 | 31753 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2642 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35239 | 5989905.4007 | 2097364.9943 | 37.738383545459 | -122.477438539611 | (37.738383545459, -122.477438539611) | |
151022 | 151022 | 95110 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 649 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 54039 | 6001693.52474 | 2093271.82828 | 37.7278216210543 | -122.436388158988 | (37.7278216210543, -122.436388158988) |
146174 | 146174 | 40167 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 216 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1999 12:00:00 AM | Permit Number 41360 | 5994849.72626239 | 2095987.73496493 | 37.7348875889443 | -122.46024383672199 | (37.7348875889443, -122.460243836722) | ||
145220 | 145220 | 64244 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 554 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33284 | 6005149.627474099 | 2111313.35504132 | 37.7775552357395 | -122.425723916077 | (37.7775552357395, -122.425723916077) | ||
143418 | 143418 | 68621 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1945 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32526 | 5990932.87525798 | 2102165.34703457 | 37.7516236388925 | -122.47423624838899 | (37.7516236388925, -122.474236248389) | ||
141700 | 141700 | 37459 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 30 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39931 | 6010620.6907028 | 2100238.51379536 | 37.7474538625831 | -122.40601718747 | (37.7474538625831, -122.40601718747) | ||
141520 | 141520 | 35070 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1624 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38624 | 5992801.46807232 | 2104400.76142731 | 37.7578695806114 | -122.46793705016 | (37.7578695806114, -122.46793705016) | ||
140639 | 140639 | 68598 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1926 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32501 | 5991291.13136145 | 2102295.45546455 | 37.7520016305294 | -122.47300685208599 | (37.7520016305294, -122.473006852086) | ||
139837 | 139837 | 65683 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 234 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28607 | 5994926.44798675 | 2095898.35261594 | 37.7346465797712 | -122.459972111851 | (37.7346465797712, -122.459972111851) | ||
139629 | 139629 | 68592 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1612 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32493 | 5991166.83201474 | 2104447.27401218 | 37.7579027613113 | -122.473593642621 | (37.7579027613113, -122.473593642621) | ||
139248 | 139248 | 35403 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 550 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38858 | 6003059.40190018 | 2098358.03858994 | 37.7418647106265 | -122.432029345324 | (37.7418647106265, -122.432029345324) | ||
138305 | 138305 | 39661 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 316 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41052 | 5995871.10695115 | 2090582.25350935 | 37.7201041317861 | -122.456321862645 | (37.7201041317861, -122.456321862645) | ||
128961 | 128961 | 54717 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 3609 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 24726 | 6004298.03079874 | 2103629.31683929 | 37.756408560199 | -122.428122138519 | (37.756408560199, -122.428122138519) | ||
128328 | 128328 | 67340 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2520 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1992 12:00:00 AM | Permit Number 30824 | 6011380.01787368 | 2101864.42331106 | 37.75196069589111 | -122.403505842523 | (37.7519606958911, -122.403505842523) | ||
127990 | 127990 | 62939 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 338 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23320 | 6006780.36050357 | 2097125.37030396 | 37.7386903299864 | -122.41907604266899 | (37.7386903299864, -122.419076042669) | ||
127085 | 127085 | 58683 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 26 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23324 | 6006866.27520727 | 2097031.18211361 | 37.7384365478954 | -122.418772311755 | (37.7384365478954, -122.418772311755) | ||
127030 | 127030 | 69506 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 401 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | Permit Number 33632 | 6008948.22977241 | 2096437.66011224 | 37.7369238689745 | -122.41153197478901 | (37.7369238689745, -122.411531974789) | ||
126800 | 126800 | 65799 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28767 | 5991045.46087918 | 2100388.25805195 | 37.746750736934295 | -122.473717291816 | (37.7467507369343, -122.473717291816) | ||
125632 | 125632 | 65811 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28799 | 5991740.53584922 | 2099906.37764585 | 37.7454678491967 | -122.471278710139 | (37.7454678491967, -122.471278710139) | ||
125044 | 125044 | 46345 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 382 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2002 12:00:00 AM | Permit Number 44591 | 6005460.79581087 | 2101487.62598308 | 37.7505936931274 | -122.423948593876 | (37.7505936931274, -122.423948593876) | ||
124193 | 124193 | 43803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 762 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | Permit Number 43433 | 5988853.6653409 | 2110130.11231626 | 37.7733720498685 | -122.48200974609699 | (37.7733720498685, -122.482009746097) | ||
123867 | 123867 | 32734 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 808 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37117 | 5995081.95862964 | 2089664.82981262 | 37.71753977051271 | -122.45898327191601 | (37.7175397705127, -122.458983271916) | ||
123110 | 123110 | 62941 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 357 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23322 | 6006800.83841041 | 2097053.62300346 | 37.738494480992706 | -122.419000152151 | (37.7384944809927, -122.419000152151) | ||
121976 | 121976 | 62909 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 414 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23286 | 6007271.29358338 | 2097254.92250183 | 37.739073685552896 | -122.41738780295601 | (37.7390736855529, -122.417387802956) | ||
121951 | 121951 | 41707 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 203 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42156 | 6002096.90165519 | 2096076.31860804 | 37.7355450223799 | -122.43519418820401 | (37.7355450223799, -122.435194188204) | ||
121588 | 121588 | 34344 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1325 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38101 | 6010099.44079349 | 2101484.52277039 | 37.7508459613928 | -122.40790749535499 | (37.7508459613928, -122.407907495355) | ||
121441 | 121441 | 65810 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2290 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28778 | 5991729.56779327 | 2099841.10556299 | 37.7452879943861 | -122.471311880679 | (37.7452879943861, -122.471311880679) | ||
121238 | 121238 | 62920 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23300 | 6007655.13385737 | 2096670.74814693 | 37.7374912602593 | -122.41601929597999 | (37.7374912602593, -122.41601929598) | ||
120898 | 120898 | 62937 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 324 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23318 | 6006824.33458428 | 2097207.20889429 | 37.7389175168089 | -122.418929803603 | (37.7389175168089, -122.418929803603) | ||
120499 | 120499 | 41696 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1 Mizpah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | ||
119631 | 119631 | 46178 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 36 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44505 | 5998475.49358611 | 2106915.81544951 | 37.7651013119743 | -122.448495104116 | (37.7651013119743, -122.448495104116) | ||
119254 | 119254 | 65260 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1153 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 28059 | 6009500.12226017 | 2102463.02471256 | 37.7534991381214 | -122.410049073844 | (37.7534991381214, -122.410049073844) | ||
118978 | 118978 | 60133 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 214 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2012 12:00:00 AM | Permit Number 768747 | 6003532.52706643 | 2096003.65082334 | 37.7354269125656 | -122.43022550454201 | (37.7354269125656, -122.430225504542) | ||
117825 | 117825 | 41697 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1 Mizpah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | ||
117382 | 117382 | 82954 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
116961 | 116961 | 68613 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1921 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32518 | 5990927.53246028 | 2102322.02893789 | 37.75205353684021 | -122.474266156198 | (37.7520535368402, -122.474266156198) | ||
115800 | 115800 | 68553 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 724 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | Permit Number 32442 | 5982311.44586787 | 2110822.57803578 | 37.7748906946614 | -122.50469113477 | (37.7748906946614, -122.50469113477) | ||
115026 | 115026 | 34301 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1257 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38089 | 6010337.06875453 | 2101902.38195398 | 37.7520066112995 | -122.407115203053 | (37.7520066112995, -122.407115203053) | ||
114985 | 114985 | 69148 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2478 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33183 | 5983358.82084368 | 2098279.8149921 | 37.7405133500226 | -122.500140666527 | (37.7405133500226, -122.500140666527) | ||
114879 | 114879 | 31913 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2281 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42222 | 5991689.25479737 | 2099914.99470572 | 37.7454885429424 | -122.471456657987 | (37.7454885429424, -122.471456657987) | ||
114576 | 114576 | 61288 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 402 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23284 | 6007176.62571904 | 2097268.48245659 | 37.739105591348704 | -122.417716082945 | (37.7391055913487, -122.417716082945) | ||
114488 | 114488 | 62940 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 355 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23321 | 6006807.32064873 | 2097065.68374167 | 37.7385279621224 | -122.41897859484399 | (37.7385279621224, -122.418978594844) | ||
113954 | 113954 | 65803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2245 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28771 | 5991002.61160286 | 2100125.98772668 | 37.7460281288142 | -122.4738463283 | (37.7460281288142, -122.4738463283) | ||
113070 | 113070 | 51536 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4138 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.43338376260901 | (37.7578376687282, -122.433383762609) | ||
111195 | 111195 | 43490 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 731 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43170 | 6008504.61569086 | 2095547.09041526 | 37.734453664768296 | -122.413002801242 | (37.7344536647683, -122.413002801242) | ||
107937 | 107937 | 39659 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 311 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41051 | 5995887.27205834 | 2090529.96858098 | 37.7199614976995 | -122.45626220721901 | (37.7199614976995, -122.456262207219) | ||
107745 | 107745 | 49836 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 572 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/2005 12:00:00 AM | Permit Number 46619 | 6011764.04798466 | 2105724.17808831 | 37.76258017347929 | -122.402449179614 | (37.7625801734793, -122.402449179614) | ||
107739 | 107739 | 61351 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2435 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33180 | 5983606.72733818 | 2098575.39773775 | 37.741339486665396 | -122.499305352528 | (37.7413394866654, -122.499305352528) | ||
107733 | 107733 | 84504 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 650X Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.775575580460206 | -122.410668559049 | (37.7755755804602, -122.410668559049) | |
107468 | 107468 | 84505 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 650 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.775575580460206 | -122.410668559049 | (37.7755755804602, -122.410668559049) | |
107049 | 107049 | 121560 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 400X Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 6003675.0 | 2102779.0 | 37.754038521377794 | -122.430216135756 | (37.7540385213778, -122.430216135756) | |||
106375 | 106375 | 63593 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1999 12:00:00 AM | Permit Number 24225 | 6005185.44614551 | 2109584.80310454 | 37.7728110766439 | -122.425476960922 | (37.7728110766439, -122.425476960922) | ||
106193 | 106193 | 47123 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1818 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45108 | 5991595.47197715 | 2102975.75176021 | 37.753887161855104 | -122.47200398758899 | (37.7538871618551, -122.472003987589) | ||
105369 | 105369 | 62916 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23296 | 6007721.5198304 | 2096821.74854603 | 37.737909606417496 | -122.415800456905 | (37.7379096064175, -122.415800456905) | ||
105285 | 105285 | 65685 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 265 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28609 | 5995018.52111157 | 2095862.6409490001 | 37.734553819285296 | -122.45965120036101 | (37.7345538192853, -122.459651200361) | ||
104764 | 104764 | 50527 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/2003 12:00:00 AM | Permit Number 47168 | 6001454.91140265 | 2108251.59060829 | 37.7689389222278 | -122.438285751105 | (37.7689389222278, -122.438285751105) | ||
104124 | 104124 | 61289 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 424 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | Permit Number 21181 | 6007345.32477323 | 2097244.32339637 | 37.7390487477576 | -122.417131085359 | (37.7390487477576, -122.417131085359) | ||
104121 | 104121 | 67138 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 453 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1994 12:00:00 AM | Permit Number 30567 | 6007391.81828007 | 2097290.23033564 | 37.739177413508 | -122.416973583395 | (37.739177413508, -122.416973583395) | ||
103775 | 103775 | 62943 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 32 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23325 | 6006886.21663048 | 2097028.33083041 | 37.738429841676 | -122.418703161695 | (37.738429841676, -122.418703161695) | ||
103091 | 103091 | 62944 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 33 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23326 | 6006898.05353177 | 2097079.16721331 | 37.738570093545796 | -122.41866583942 | (37.7385700935458, -122.41866583942) | ||
102257 | 102257 | 62913 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 503 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23293 | 6007737.75654809 | 2096994.92041001 | 37.7383860110425 | -122.41575657686 | (37.7383860110425, -122.41575657686) | ||
101331 | 101331 | 54097 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 121 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1995 12:00:00 AM | Permit Number 9824 | 6000463.76381209 | 2104868.98714017 | 37.759594708041796 | -122.441471294748 | (37.7595947080418, -122.441471294748) | ||
101018 | 101018 | 33392 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 161 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37511 | 5993609.77804843 | 2093900.82209008 | 37.729086039701 | -122.464379267011 | (37.729086039701, -122.464379267011) | ||
100905 | 100905 | 82953 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
99952 | 99952 | 34302 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1261 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38090 | 6010338.30191232 | 2101880.05024725 | 37.7519453623814 | -122.407109364623 | (37.7519453623814, -122.407109364623) | ||
99678 | 99678 | 35101 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 774 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38642 | 6001926.16682464 | 2089330.25640032 | 37.71701216685 | -122.435302089615 | (37.71701216685, -122.435302089615) | ||
99443 | 99443 | 60142 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1600 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/1997 12:00:00 AM | Permit Number 19672 | 5990905.68098297 | 2104491.51831194 | 37.7580091169986 | -122.474500032297 | (37.7580091169986, -122.474500032297) | ||
98472 | 98472 | 68122 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31870 | 6006226.82006776 | 2099469.59440232 | 37.7450958550009 | -122.42115633768 | (37.7450958550009, -122.42115633768) | ||
97694 | 97694 | 63806 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 8 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24493 | 6009169.73778237 | 2097426.78712757 | 37.7396522194543 | -122.41083595729299 | (37.7396522194543, -122.410835957293) | ||
97328 | 97328 | 62145 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 75 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/06/1985 12:00:00 AM | Permit Number 22258 | 6005427.84181989 | 2099597.4165714 | 37.7454017512266 | -122.42392815474899 | (37.7454017512266, -122.423928154749) | ||
97268 | 97268 | 45125 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 215 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2001 12:00:00 AM | Permit Number 43982 | 6001423.51922816 | 2108204.04749997 | 37.7688065951097 | -122.438390927701 | (37.7688065951097, -122.438390927701) | ||
97044 | 97044 | 68702 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 178 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32614 | 5991836.89762768 | 2114262.80781602 | 37.7848923529415 | -122.471991698628 | (37.7848923529415, -122.471991698628) | ||
96993 | 96993 | 63825 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 271 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1987 12:00:00 AM | Permit Number 24513 | 6009008.49456519 | 2097079.12708776 | 37.738688578203295 | -122.41136891509899 | (37.7386885782033, -122.411368915099) | ||
96973 | 96973 | 43489 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 731 Banks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43170 | 6008504.61569086 | 2095547.09041526 | 37.734453664768296 | -122.413002801242 | (37.7344536647683, -122.413002801242) | ||
96862 | 96862 | 121558 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 400X Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 6003675.0 | 2102779.0 | 37.754038521377794 | -122.430216135756 | (37.7540385213778, -122.430216135756) | |||
96209 | 96209 | 82955 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
96011 | 96011 | 53145 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1498@ KEITH Underwood Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | ||
96002 | 96002 | 82952 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
94076 | 94076 | 48468 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1409 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/2002 12:00:00 AM | Permit Number 45831 | 6003303.13281599 | 2100036.19716336 | 37.746486359598705 | -122.431306366847 | (37.7464863595987, -122.431306366847) | ||
93350 | 93350 | 51537 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4138 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.43338376260901 | (37.7578376687282, -122.433383762609) | ||
91943 | 91943 | 60436 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 474 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/2004 12:00:00 AM | Permit Number 20020 | 6003505.36219814 | 2098957.85837164 | 37.743536950172206 | -122.43053014999599 | (37.7435369501722, -122.430530149996) | ||
91932 | 91932 | 62709 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1171 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | Permit Number 23049 | 6007422.95308964 | 2118804.22805474 | 37.798251535762205 | -122.418390975112 | (37.7982515357622, -122.418390975112) | ||
90333 | 90333 | 53193 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 44COLERIDGE Powers Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/28/2006 12:00:00 AM | Permit Number 49130 | 6006839.19551401 | 2099757.71286836 | 37.745921466667205 | -122.419059278748 | (37.7459214666672, -122.419059278748) | ||
89767 | 89767 | 51538 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4138 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.43338376260901 | (37.7578376687282, -122.433383762609) | ||
89728 | 89728 | 82956 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 660X Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636.0 | 2110586.0 | 37.7758105844997 | -122.41015262108601 | (37.7758105844997, -122.410152621086) | |
88498 | 88498 | 35377 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 767 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | Permit Number 38834 | 6011637.61839103 | 2091581.433538 | 37.7237401685956 | -122.401892240977 | (37.7237401685956, -122.401892240977) | ||
86251 | 86251 | 39660 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 316 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41052 | 5995871.10695115 | 2090582.25350935 | 37.7201041317861 | -122.456321862645 | (37.7201041317861, -122.456321862645) | ||
84739 | 84739 | 40751 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 54 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.726553703659995 | -122.46791340088001 | (37.72655370366, -122.46791340088) | ||
84074 | 84074 | 66157 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1765 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | Permit Number 29228 | 6013882.21689766 | 2094959.68148484 | 37.733141166757896 | -122.39436940843201 | (37.7331411667579, -122.394369408432) | ||
84031 | 84031 | 40752 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 54 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.726553703659995 | -122.46791340088001 | (37.72655370366, -122.46791340088) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");