Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
124888 | 124888 | 48984 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 4215 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2002 12:00:00 AM | Permit Number 46171 | 6002499.14803074 | 2100605.29142344 | 37.7480033622388 | -122.43412712945299 | (37.7480033622388, -122.434127129453) | ||
125182 | 125182 | 34411 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 191 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38159 | 6004342.16299585 | 2097508.24193041 | 37.739604003626795 | -122.427533446458 | (37.7396040036268, -122.427533446458) | ||
125305 | 125305 | 222705 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 77 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007841.33022 | 2100005.82897 | 37.74665912012979 | -122.41561158852899 | (37.7466591201298, -122.415611588529) | |||
125410 | 125410 | 45536 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 79 Melba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | Permit Number 44293 | 5989585.76469698 | 2094846.08328142 | 37.7314487101847 | -122.478359538262 | (37.7314487101847, -122.478359538262) | |||
125714 | 125714 | 102089 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 27 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769734 | 5992609.4 | 2096703.2 | 37.7367229555432 | -122.468041385671 | (37.7367229555432, -122.468041385671) | |
126538 | 126538 | 43593 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2014 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43254 | 5986663.03161814 | 2101533.45903453 | 37.7496403612652 | -122.488955268867 | (37.7496403612652, -122.488955268867) | ||
127137 | 127137 | 122679 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 598x Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008469.0 | 2098078.0 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | ||||
128258 | 128258 | 204719 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 110 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993903.71897 | 2099982.29966 | 37.7458012037543 | -122.46380433331001 | (37.7458012037543, -122.46380433331) | |||
128301 | 128301 | 45396 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 135 Corona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | Permit Number 44206 | 5992967.23882057 | 2092102.4527906997 | 37.72411110068 | -122.466469901656 | (37.72411110068, -122.466469901656) | ||
129111 | 129111 | 51597 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1478 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | 3x3 | Permit Number 47890 | 5999641.13876025 | 2107457.97579425 | 37.766656526924294 | -122.444502404738 | (37.7666565269243, -122.444502404738) | ||
129702 | 129702 | 204734 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 80 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994953.56479 | 2099867.13318 | 37.7455454275919 | -122.460165799529 | (37.7455454275919, -122.460165799529) | |||
131430 | 131430 | 204721 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 460 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5997139.03164 | 2093838.66053 | 37.729118162849495 | -122.452173936375 | (37.7291181628495, -122.452173936375) | |||
135290 | 135290 | 222704 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 69 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007772.24851 | 2100018.26139 | 37.746689373329296 | -122.415851346858 | (37.7466893733293, -122.415851346858) | |||
136522 | 136522 | 204722 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 422 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5993793.315830001 | 2090006.70292 | 37.7184043108851 | -122.46346228245501 | (37.7184043108851, -122.463462282455) | ||||
137834 | 137834 | 175805 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 35 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6009673.12409 | 2089221.0725599998 | 37.7171492746007 | -122.408516774841 | (37.7171492746007, -122.408516774841) | |||
140864 | 140864 | 53611 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2266 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 50102 | 5991755.89113084 | 2099997.75858136 | 37.7457196459604 | -122.47123227110201 | (37.7457196459604, -122.471232271102) | ||
144682 | 144682 | 106923 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 196 States St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | Permit Number 772939 | 6001039.87531 | 2106387.50014 | 37.7637969766711 | -122.43958767886002 | (37.7637969766711, -122.43958767886) | |||
146575 | 146575 | 222710 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 201 Randall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6004263.21249 | 2097476.0489 | 37.7395111430209 | -122.427804130079 | (37.7395111430209, -122.427804130079) | |||
147518 | 147518 | 188397 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 501 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6010696.0277 | 2105850.49204 | 37.7628673226003 | -122.406151993137 | (37.7628673226003, -122.406151993137) | |||
148165 | 148165 | 222701 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 340 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004099.43344 | 2096524.74955 | 37.7368898251991 | -122.42830262426399 | (37.7368898251991, -122.428302624264) | |||
149036 | 149036 | 32269 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2033 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 4 | Permit Number 36855 | 6011970.48286 | 2103707.9911700003 | 37.7570556930908 | -122.40159347895 | (37.7570556930908, -122.40159347895) | |
149164 | 149164 | 175811 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 15 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6005336.45581 | 2093162.3032099998 | 37.727727212929004 | -122.423786672331 | (37.727727212929, -122.423786672331) | ||||
149330 | 149330 | 222691 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2981 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009598.49349 | 2101000.57831 | 37.7494890986626 | -122.40960567126801 | (37.7494890986626, -122.409605671268) | |||
153957 | 153957 | 218236 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 353 Wawona St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5991977.13565 | 2097137.64691 | 37.7378793033766 | -122.47025900595101 | (37.7378793033766, -122.470259005951) | |||
155099 | 155099 | 222702 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 123 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008311.654 | 2097864.96994 | 37.7408072216699 | -122.413833840154 | (37.7408072216699, -122.413833840154) | |||
156342 | 156342 | 222693 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 440 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003701.6023699995 | 2098966.92625 | 37.74357296341329 | -122.42985224701 | (37.7435729634133, -122.42985224701) | |||
159639 | 159639 | 188416 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1790 McKinnon Ave | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 8ft | 6014390.68688 | 2096696.7168 | 37.7379389617097 | -122.392732952571 | (37.7379389617097, -122.392732952571) | |||
165838 | 165838 | 59091 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 3524 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 1 | Permit Number 18392 | 5992426.174880001 | 2110042.4468799997 | 37.77333847202161 | -122.46964566266001 | (37.7733384720216, -122.46964566266) | ||
167143 | 167143 | 188401 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 909 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015267.441000001 | 2104396.98208 | 37.7591309344718 | -122.39023938074101 | (37.7591309344718, -122.390239380741) | |||
167905 | 167905 | 94813 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2948 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53896 | 6002515.07841 | 2118365.04564 | 37.7967681547718 | -122.43534223486799 | (37.7967681547718, -122.435342234868) | |
170167 | 170167 | 222677 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1498 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010454.79524 | 2100826.85949 | 37.749060050992604 | -122.40663230034201 | (37.7490600509926, -122.406632300342) | |||
175877 | 175877 | 222699 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2102 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6002635.97774 | 2099387.5471900003 | 37.744667486907204 | -122.43356696417 | (37.7446674869072, -122.43356696417) | |||
175957 | 175957 | 204740 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 317 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 5999296.31857 | 2095221.44608 | 37.7330383112512 | -122.44481540373 | (37.7330383112512, -122.44481540373) | |||
176601 | 176601 | 188418 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1790 McKinnon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6014392.11707 | 2096695.01257 | 37.737934361678796 | -122.39272788847401 | (37.7379343616788, -122.392727888474) | |||
183898 | 183898 | 188402 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 654 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012373.88939 | 2104883.09648 | 37.7603047754705 | -122.40028086897 | (37.7603047754705, -122.40028086897) | |||
184518 | 184518 | 39934 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 186 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41205 | 6010249.35801 | 2088014.8431799999 | 37.7138694695674 | -122.40644005139299 | (37.7138694695674, -122.406440051393) |
187407 | 187407 | 175800 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 701 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001959.2202699995 | 2089802.6495400001 | 37.71831113034379 | -122.43522160969401 | (37.7183111303438, -122.435221609694) | |||
440 | 440 | 157410 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 125 Highland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | 2x5 | 6005546.67522 | 2096690.9332 | 37.7374279129674 | -122.423310672857 | (37.7374279129674, -122.423310672857) | ||
5660 | 5660 | 39923 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 0 Arleta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41198 | ||||||||
6711 | 6711 | 31341 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 430 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772811 | 6005729.4209 | 2111051.1148 | 37.7768679337671 | -122.423699563703 | (37.7768679337671, -122.423699563703) | |
10397 | 10397 | 108837 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 699 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774665 | 6001210.74249 | 2089636.42248 | 37.7178121756617 | -122.437796877731 | (37.7178121756617, -122.437796877731) |
12527 | 12527 | 108378 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 358 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773808 | 6003377.41913 | 2091635.77484 | 37.7234249209965 | -122.43045021882 | (37.7234249209965, -122.43045021882) |
13070 | 13070 | 93869 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400-422X Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773818 | 6012466.99875 | 2086683.8296 | 37.7103385819422 | -122.398681660343 | (37.7103385819422, -122.398681660343) |
13992 | 13992 | 108725 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 877 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773104 | 6011895.30838 | 2104315.65478 | 37.758720008153 | -122.401896177292 | (37.758720008153, -122.401896177292) |
14920 | 14920 | 37328 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39838 | |||||||||
24848 | 24848 | 188408 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2033 22nd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6011976.80987 | 2103707.86259 | 37.7570556930855 | -122.40157158857299 | (37.7570556930855, -122.401571588573) | |||
26902 | 26902 | 175812 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 15 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6005342.42292 | 2093158.1624099999 | 37.727716180055204 | -122.42376574960899 | (37.7277161800552, -122.423765749609) | ||||
29820 | 29820 | 187571 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 73 Bishop St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6010860.52073 | 2089475.11103 | 37.7179132396708 | -122.40443035886899 | (37.7179132396708, -122.404430358869) | ||||
36978 | 36978 | 187575 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 Bishop St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6010832.96557 | 2089490.7918200002 | 37.7179547559905 | -122.40452670863998 | (37.7179547559905, -122.40452670864) | ||||
38985 | 38985 | 123068 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 678 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992266.69336 | 2110864.34538 | 37.7755859643914 | -122.47025718989201 | (37.7755859643914, -122.470257189892) | |||
39135 | 39135 | 247897 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 351 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6010077.88258 | 2098386.8429099997 | 37.7423392041858 | -122.407763645688 | (37.7423392041858, -122.407763645688) | ||||
40968 | 40968 | 91228 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 250 Texas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53161 | 6013714.91861 | 2105876.83519 | 37.7631080513185 | -122.39571247215 | (37.7631080513185, -122.39571247215) | |
49133 | 49133 | 247976 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 503 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009801.95016 | 2099270.17301 | 37.7447491849331 | -122.408780045086 | (37.7447491849331, -122.408780045086) | ||||
51309 | 51309 | 222685 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 145 Coso Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6007512.1231 | 2099620.66206 | 37.74558302735271 | -122.41672267392201 | (37.7455830273527, -122.416722673922) | ||||
77059 | 77059 | 188411 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 398 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014024.24871 | 2105357.36092 | 37.7616988910081 | -122.394606216998 | (37.7616988910081, -122.394606216998) | |||
78290 | 78290 | 37278 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 700 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39817 | 6003661.86134005 | 2104206.66341524 | 37.7579578025996 | -122.430363425655 | (37.7579578025996, -122.430363425655) | |||
78986 | 78986 | 105989 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 651X Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002337.0 | 2099724.0 | 37.745574339333 | -122.434624822764 | (37.745574339333, -122.434624822764) | |||||
81516 | 81516 | 50910 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2450 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | 2 | 3x9 | Permit Number 772737 | 5991103.05311172 | 2098729.45888754 | 37.742199437798 | -122.47339717645399 | (37.742199437798, -122.473397176454) |
82156 | 82156 | 36956 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 16 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39587 | 5994274.56771258 | 2115474.49567321 | 37.7883600733979 | -122.463646184404 | (37.7883600733979, -122.463646184404) | ||
83450 | 83450 | 68449 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 4054 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 04/24/1999 12:00:00 AM | Permit Number 32307 | 6003251.17179249 | 2104206.64930012 | 37.757934492021604 | -122.431783761852 | (37.7579344920216, -122.431783761852) | ||
91092 | 91092 | 51953 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 82 Mary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2005 12:00:00 AM | Permit Number 48176 | 6010868.83737248 | 2112458.01845687 | 37.781019735711006 | -122.40601981145599 | (37.781019735711, -122.406019811456) | |||
94464 | 94464 | 36069 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1504 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44775 | 6009387.99483758 | 2107777.56202059 | 37.7680853638298 | -122.410812146882 | (37.7680853638298, -122.410812146882) | ||
96969 | 96969 | 109399 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
97803 | 97803 | 45537 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 79 Melba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | Permit Number 44293 | 5989585.76469698 | 2094846.08328142 | 37.7314487101847 | -122.478359538262 | (37.7314487101847, -122.478359538262) | |||
107545 | 107545 | 37854 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 50 Ina Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.42496422599702 | (37.7235254489092, -122.424964225997) | |||
113561 | 113561 | 115771 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1204 Egbert Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775363 | 6015358.9 | 2090410.1 | 37.7207308974409 | -122.38894654781099 | (37.7207308974409, -122.388946547811) | ||
114122 | 114122 | 102090 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 27 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769734 | 5992609.4 | 2096703.2 | 37.7367229555432 | -122.468041385671 | (37.7367229555432, -122.468041385671) | |
116006 | 116006 | 106924 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 196 States St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | Permit Number 772939 | 6001039.87531 | 2106387.50014 | 37.7637969766711 | -122.43958767886002 | (37.7637969766711, -122.43958767886) | |||
116475 | 116475 | 109575 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774875 | 6002004.0 | 2089808.9 | 37.7183308355338 | -122.43506727205299 | (37.7183308355338, -122.435067272053) |
116919 | 116919 | 175809 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 La Grande Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6005230.95207 | 2091785.5880000002 | 37.7239410985769 | -122.424053538037 | (37.7239410985769, -122.424053538037) | ||||
125292 | 125292 | 40738 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 20 Alviso St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1999 12:00:00 AM | Permit Number 41717 | 5992072.81756498 | 2091384.27409538 | 37.7220875062624 | -122.469509497536 | (37.7220875062624, -122.469509497536) | |||
127386 | 127386 | 42819 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
129209 | 129209 | 37309 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
130324 | 130324 | 123045 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 568 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991929.81513 | 2111594.03006 | 37.777569997766705 | -122.47147570428301 | (37.7775699977667, -122.471475704283) | |||
140417 | 140417 | 108905 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Cordova St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772783 | 6001785.8 | 2087307.2 | 37.7114493293027 | -122.43564261659901 | (37.7114493293027, -122.435642616599) |
144281 | 144281 | 122680 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 598x Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008469.0 | 2098078.0 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | ||||
144836 | 144836 | 51903 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 168 Caselli Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48111 | 6000192.99372442 | 2104905.40226883 | 37.7596792654558 | -122.44241036439301 | (37.7596792654558, -122.442410364393) | |||
145019 | 145019 | 96748 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 399X Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 1.5x2 | 6003700.0 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | |||
155156 | 155156 | 125935 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1132 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6007463.08276 | 2119890.85277 | 37.8012373932575 | -122.418329199431 | (37.8012373932575, -122.418329199431) | ||||
155781 | 155781 | 222708 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 290 States St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6000342.850880001 | 2106861.9429200003 | 37.76505998306129 | -122.442032523579 | (37.7650599830613, -122.442032523579) | |||
156475 | 156475 | 175816 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 616 Dwight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009781.28405 | 2091163.7033900002 | 37.7224893931511 | -122.40827985473699 | (37.7224893931511, -122.408279854737) | |||
166040 | 166040 | 175807 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 156 San Juan Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6001266.11551 | 2092303.88748 | 37.725139581023605 | -122.437796421768 | (37.7251395810236, -122.437796421768) | |||
169588 | 169588 | 204739 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 463 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998365.55897 | 2095230.78545 | 37.7330107938072 | -122.44803394331899 | (37.7330107938072, -122.448033943319) | |||
171201 | 171201 | 175802 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 421 Wheeler Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011992.04716 | 2086775.8851599998 | 37.7105648747395 | -122.400329663484 | (37.7105648747395, -122.400329663484) | |||
171203 | 171203 | 204735 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 40 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995650.24765 | 2100035.09823 | 37.746046665624 | -122.457768945275 | (37.746046665624, -122.457768945275) | |||
174132 | 174132 | 188415 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2 Jennings St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6019090.329030001 | 2097590.47628 | 37.7406529492792 | -122.37654576818998 | (37.7406529492792, -122.37654576819) | |||
176434 | 176434 | 124049 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 651 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5992517.64773 | 2111006.08275 | 37.775989642541795 | -122.469399404795 | (37.7759896425418, -122.469399404795) | |||
178316 | 178316 | 202043 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 52 Exeter St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012522.16713 | 2090984.69593 | 37.722150974681604 | -122.398792625891 | (37.7221509746816, -122.398792625891) | |||
178842 | 178842 | 204733 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 80 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994927.12974 | 2099849.55804 | 37.745495650106605 | -122.460255934077 | (37.7454956501066, -122.460255934077) | |||
179565 | 179565 | 222694 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 427 Valley St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6003122.71421 | 2099186.4838799997 | 37.7441430185014 | -122.431869572034 | (37.7441430185014, -122.431869572034) | ||||
185050 | 185050 | 204744 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 545 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5996927.5801099995 | 2095415.2897 | 37.733435093958896 | -122.453018700168 | (37.7334350939589, -122.453018700168) | |||
3005 | 3005 | 208852 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 42 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | 6001113.97001 | 2095223.0116299998 | 37.733146173254205 | -122.43853142959101 | (37.7331461732542, -122.438531429591) | ||
3511 | 3511 | 247940 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 5 | Permit Number 775404 | 6010280.31746 | 2098909.2881400003 | 37.7437850559498 | -122.407100501782 | (37.7437850559498, -122.407100501782) | |||
8008 | 8008 | 39924 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 0 Arleta Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41198 | ||||||||
12503 | 12503 | 93870 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400-422X Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773818 | 6012462.01959 | 2086667.4072599998 | 37.7102932120209 | -122.398697717749 | (37.7102932120209, -122.398697717749) |
18455 | 18455 | 51904 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 168 Caselli Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48111 | 6000192.99372442 | 2104905.40226883 | 37.7596792654558 | -122.44241036439301 | (37.7596792654558, -122.442410364393) | |||
18868 | 18868 | 15071 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1X Minerva St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5995959.8595900005 | 2089005.6685900001 | 37.7157802951115 | -122.45590116312201 | (37.7157802951115, -122.455901163122) | |||
35603 | 35603 | 204716 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 155 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992699.213880001 | 2098207.72713 | 37.7408591943976 | -122.467840257748 | (37.7408591943976, -122.467840257748) | |||
39239 | 39239 | 175813 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 15 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6005348.05368 | 2093155.48995 | 37.727709159929105 | -122.42374609402201 | (37.7277091599291, -122.423746094022) | ||||
45007 | 45007 | 248046 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 38 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6010555.404680001 | 2099417.48898 | 37.745195855721995 | -122.406185107956 | (37.745195855722, -122.406185107956) |
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");