Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
123533 | 123533 | 85811 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1675 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007516.0 | 2108769.0 | 37.7707024771995 | -122.417357464156 | (37.7707024771995, -122.417357464156) | ||
140189 | 140189 | 85813 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1675 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007516.0 | 2108769.0 | 37.7707024771995 | -122.417357464156 | (37.7707024771995, -122.417357464156) | ||
144998 | 144998 | 85810 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1675 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007516.0 | 2108769.0 | 37.7707024771995 | -122.417357464156 | (37.7707024771995, -122.417357464156) | ||
178042 | 178042 | 230375 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 70 Pearl St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6005616.00843 | 2108643.7620099997 | 37.770251521926 | -122.423920665902 | (37.770251521926, -122.423920665902) | |||
41914 | 41914 | 230386 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 51 13th St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6008087.40778 | 2108285.62264 | 37.769407368778 | -122.415346724678 | (37.769407368778, -122.415346724678) | |||
164713 | 164713 | 230387 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 51 13th St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6008108.07186 | 2108284.2511400003 | 37.7694047643365 | -122.415275151222 | (37.7694047643365, -122.415275151222) | |||
180875 | 180875 | 230388 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 51 13th St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6008125.5999300005 | 2108283.70929 | 37.7694042616334 | -122.41521448386001 | (37.7694042616334, -122.41521448386) | |||
22880 | 22880 | 230389 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 51 13th St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008142.81587 | 2108281.73826 | 37.7693998171644 | -122.41515479496701 | (37.7693998171644, -122.415154794967) | |||
122456 | 122456 | 3904 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 84 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2014 11:00:00 AM | 3 | 2X2 | 6002180.9408165 | 2107753.3024618 | 37.7676120130603 | -122.435738811724 | (37.7676120130603, -122.435738811724) | ||
156278 | 156278 | 230376 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 126 Dolores St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004756.55794 | 2107626.00234 | 37.7674084411732 | -122.426821010098 | (37.7674084411732, -122.426821010098) | |||
21383 | 21383 | 3929 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 100X Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/18/2014 12:00:00 AM | 3 | 2x2 | 6002188.32938 | 2107609.3026900003 | 37.7672170447484 | -122.43570295204799 | (37.7672170447484, -122.435702952048) | ||
1590 | 1590 | 5343 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 180 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2014 02:20:00 PM | 3 | 3X3 | 6004776.7961099995 | 2107352.0132 | 37.7666572770255 | -122.426731495165 | (37.7666572770255, -122.426731495165) | ||
21837 | 21837 | 5348 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 200X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004789.9063099995 | 2107160.01438 | 37.7661308355062 | -122.426672475382 | (37.7661308355062, -122.426672475382) | |
44178 | 44178 | 91424 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2112 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102 | 6003571.0 | 2107157.0 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | ||
91361 | 91361 | 91421 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2112 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102; tree 1 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012 | 6003571.0 | 2107157.0 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | ||
120630 | 120630 | 91426 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2112 15th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102 | 6003571.0 | 2107157.0 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | ||
121595 | 121595 | 91423 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2112 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102 | 6003571.0 | 2107157.0 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | ||
127472 | 127472 | 91422 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2112 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102; Tree 2 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012 | 6003571.0 | 2107157.0 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | ||
142736 | 142736 | 91425 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2112 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102 | 6003571.0 | 2107157.0 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | ||
20240 | 20240 | 5355 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 214 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/03/2009 12:00:00 AM | 3 | 6 | 6004795.29962 | 2107076.64131 | 37.765902217941296 | -122.42664788340099 | (37.7659022179413, -122.426647883401) | ||
21175 | 21175 | 5356 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 220 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2015 03:17:00 PM | 3 | 6x6 | posted for removal 3/27/14 DPW | 6004796.958190001 | 2107043.90776 | 37.765812433218706 | -122.426639815582 | (37.7658124332187, -122.426639815582) | |
91447 | 91447 | 5370 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 265 DOLORES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2015 03:03:00 PM | 3 | 3X3 | 6005008.2 | 2106862.7 | 37.765326820302 | -122.42589627439101 | (37.765326820302, -122.425896274391) | ||
144520 | 144520 | 52671 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1234@ LINCOLN 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53911 | 5993637.83557736 | 2107090.14039952 | 37.7653021756316 | -122.46523990796699 | (37.7653021756316, -122.465239907967) | |
114295 | 114295 | 5385 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 325X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/2013 12:00:00 AM | 4X4 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | |||
14973 | 14973 | 18344 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 440 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/2015 07:27:00 AM | 3 | 3X3 | 6010309.570730001 | 2106285.64769 | 37.7640405376657 | -122.40751930078001 | (37.7640405376657, -122.40751930078) | ||
18110 | 18110 | 5394 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 347 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2014 12:00:00 AM | 2 | 7x5 | 6004926.5455599995 | 2106285.12827 | 37.7637363311974 | -122.426137576609 | (37.7637363311974, -122.426137576609) | ||
16888 | 16888 | 18349 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 480 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6010310.27618 | 2106136.10948 | 37.763629979170496 | -122.40750631726101 | (37.7636299791705, -122.407506317261) | ||
14031 | 14031 | 18353 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 480 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2013 12:00:00 AM | 3 | 3x3 | 6010310.709559999 | 2106111.3358 | 37.76356198052329 | -122.407503071611 | (37.7635619805233, -122.407503071611) | ||
151629 | 151629 | 116966 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 480 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6010311.678719999 | 2106089.82191 | 37.7635029625087 | -122.407498202703 | (37.7635029625087, -122.407498202703) | |||
49153 | 49153 | 193408 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 480 Potrero Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010314.12402 | 2106048.6526900004 | 37.763390058038794 | -122.40748684246401 | (37.7633900580388, -122.407486842464) | |||
9977 | 9977 | 5406 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 392 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2012 12:00:00 AM | 5 | 3x3 | 6004848.6988147 | 2106052.9215434 | 37.7630943465887 | -122.42639029035401 | (37.7630943465887, -122.426390290354) | ||
116965 | 116965 | 18361 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 530 Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/2015 11:39:00 AM | 3 | 3x3 | 6010330.807907499 | 2105828.5872592 | 37.762786742062204 | -122.407413622665 | (37.7627867420622, -122.407413622665) | ||
82178 | 82178 | 5416 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 430X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2011 12:00:00 AM | 3 | 6x150 | 6004853.970832599 | 2105864.857711 | 37.7625782660478 | -122.42635866544599 | (37.7625782660478, -122.426358665446) | ||
55712 | 55712 | 109258 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1290 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773444 | 5982171.0 | 2106334.4 | 37.762559192748604 | -122.504844313965 | (37.7625591927486, -122.504844313965) |
83349 | 83349 | 93300 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 589X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004575.9 | 2105667.0 | 37.7620192734995 | -122.427306317148 | (37.7620192734995, -122.427306317148) | ||
87986 | 87986 | 91094 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
114805 | 114805 | 91093 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
123957 | 123957 | 91091 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
126063 | 126063 | 91095 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
139405 | 139405 | 91090 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
143561 | 143561 | 91089 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
145490 | 145490 | 91092 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
21273 | 21273 | 18371 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 636 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2016 12:00:00 AM | 4 | 2X2 | 6010355.5730099995 | 2105342.69627 | 37.7614539813358 | -122.40729371393999 | (37.7614539813358, -122.40729371394) | ||
182507 | 182507 | 230379 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 636 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010352.94216 | 2105328.73163 | 37.7614154903439 | -122.407301828531 | (37.7614154903439, -122.407301828531) | |||
9325 | 9325 | 25487 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 645X POTRERO AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2013 12:00:00 AM | 3 | 3X3 | 6010440.0 | 2105310.0 | 37.7613689295586 | -122.40699940993099 | (37.7613689295586, -122.406999409931) | ||
85642 | 85642 | 18418 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 645X POTRERO AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2016 12:00:00 AM | 3 | 3X3 | 6010440.0 | 2105310.0 | 37.7613689295586 | -122.40699940993099 | (37.7613689295586, -122.406999409931) | ||
179739 | 179739 | 193406 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 746 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011525.03424 | 2104899.87784 | 37.7603034831294 | -122.40321785872601 | (37.7603034831294, -122.403217858726) | |||
116290 | 116290 | 88687 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 135 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2008 12:00:00 AM | Permit Number 51638 | 6003417.0 | 2105051.0 | 37.7602622759886 | -122.43127052793899 | (37.7602622759886, -122.431270527939) | |||
178549 | 178549 | 230385 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 581 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 9ft | 6004995.95318 | 2104998.86424 | 37.760208477866 | -122.42580595608601 | (37.760208477866, -122.425805956086) | |||
19158 | 19158 | 5458 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 589 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2009 12:00:00 AM | 90 | 3x3 | 6004996.57492 | 2104960.58209 | 37.7601033992601 | -122.42580108085801 | (37.7601033992601, -122.425801080858) | ||
9244 | 9244 | 87452 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 601 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2008 12:00:00 AM | 4 | 3x3 | 6004976.0 | 2104871.0 | 37.7598562652774 | -122.425865863079 | (37.7598562652774, -122.425865863079) | ||
22960 | 22960 | 109286 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1438 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771727 | 5982826.9 | 2105321.3 | 37.75981607235 | -122.502500845014 | (37.75981607235, -122.502500845014) |
109624 | 109624 | 94259 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2777X 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.40957339028499 | (37.7597963985886, -122.409573390285) | |
88428 | 88428 | 86595 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2154 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 6 | 3x3 | 6009566.0 | 2104744.0 | 37.7597658751742 | -122.409982265203 | (37.7597658751742, -122.409982265203) | ||
86147 | 86147 | 55564 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1X CASELLI AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50796 | 6000842.0 | 2104917.0 | 37.7597480805722 | -122.44016661153098 | (37.7597480805722, -122.440166611531) | ||
102655 | 102655 | 87857 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1X CASELLI AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50796 | 6000842.0 | 2104917.0 | 37.7597480805722 | -122.44016661153098 | (37.7597480805722, -122.440166611531) | ||
134507 | 134507 | 230384 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 601 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005003.814780001 | 2104818.83763 | 37.7597146115626 | -122.42576595245501 | (37.7597146115626, -122.425765952455) | |||
81332 | 81332 | 94246 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2125 BRYANT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |
91334 | 91334 | 94243 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2125 BRYANT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |
96403 | 96403 | 94244 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2125 BRYANT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |
111220 | 111220 | 94245 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2125 BRYANT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |
138820 | 138820 | 94247 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2125 BRYANT ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |
17893 | 17893 | 5475 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 601 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2008 12:00:00 AM | 3 | 4X4 | 6005004.3744 | 2104794.07494 | 37.759646650682996 | -122.425762254445 | (37.759646650683, -122.425762254445) | ||
129588 | 129588 | 193407 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 541 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6013570.69062 | 2104547.33874 | 37.7594495210946 | -122.396118132954 | (37.7594495210946, -122.396118132954) | |||
83591 | 83591 | 94262 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2850X 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009745.2 | 2104556.4 | 37.759260809864294 | -122.409349258874 | (37.7592608098643, -122.409349258874) | |
85874 | 85874 | 94260 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2850X 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009745.2 | 2104556.4 | 37.759260809864294 | -122.409349258874 | (37.7592608098643, -122.409349258874) | |
101173 | 101173 | 94263 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2850X 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009745.2 | 2104556.4 | 37.759260809864294 | -122.409349258874 | (37.7592608098643, -122.409349258874) | |
114755 | 114755 | 94258 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2850X 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009745.2 | 2104556.4 | 37.759260809864294 | -122.409349258874 | (37.7592608098643, -122.409349258874) | |
141665 | 141665 | 94261 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2850X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009745.2 | 2104556.4 | 37.759260809864294 | -122.409349258874 | (37.7592608098643, -122.409349258874) | |
176715 | 176715 | 81753 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 565 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52385 | 6013577.35874 | 2104447.02049 | 37.7591744400611 | -122.396088040728 | (37.7591744400611, -122.396088040728) | |
143565 | 143565 | 55516 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 299 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2014 12:00:00 AM | Permit Number 772528 | 6001150.72264648 | 2104659.12373936 | 37.759057586626206 | -122.439080412698 | (37.7590575866262, -122.439080412698) | |||
75813 | 75813 | 230383 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 655 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6005020.28561 | 2104519.96917 | 37.7588949199761 | -122.425687715924 | (37.7588949199761, -122.425687715924) | |||
152400 | 152400 | 230382 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 655 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6005021.64655 | 2104500.02665 | 37.7588402394163 | -122.42568158976002 | (37.7588402394163, -122.42568158976) | |||
59682 | 59682 | 230381 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 655 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6005021.944209999 | 2104476.3564299997 | 37.7587752633866 | -122.425678875606 | (37.7587752633866, -122.425678875606) | |||
117526 | 117526 | 117298 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1590 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778522 | 5993741.6 | 2104678.7 | 37.7586869726954 | -122.46470588880699 | (37.7586869726954, -122.464705888807) | ||
20723 | 20723 | 5477 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 655 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005026.79294 | 2104432.16218 | 37.7586541903676 | -122.42565896099899 | (37.7586541903676, -122.425658960999) | |||
61066 | 61066 | 67550 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 890 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 8 | Permit Number 31097 | 6011842.0519199995 | 2104248.01189 | 37.7585313034009 | -122.402075608207 | (37.7585313034009, -122.402075608207) | |
33883 | 33883 | 110043 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 890 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 9 | 6011841.59848 | 2104237.14125 | 37.7585014297196 | -122.402076412192 | (37.7585014297196, -122.402076412192) | |||
85651 | 85651 | 18391 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 874 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2013 12:00:00 AM | 3 | 4x4 | 6010420.6643105 | 2104143.6455038004 | 37.7581653002339 | -122.406984073056 | (37.7581653002339, -122.406984073056) | ||
98187 | 98187 | 434 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 890X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010425.429178201 | 2104052.7086425 | 37.7579158746071 | -122.406961184613 | (37.7579158746071, -122.406961184613) | ||
112259 | 112259 | 108977 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2970 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773794 | 6008402.2 | 2103930.0 | 37.7574655215329 | -122.413949705223 | (37.7574655215329, -122.413949705223) |
17773 | 17773 | 18420 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 924 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010442.48956 | 2103839.41038 | 37.7573311599314 | -122.406887149344 | (37.7573311599314, -122.406887149344) | ||
17657 | 17657 | 18422 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 940 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2016 06:57:00 AM | 3 | 3x3 | 6010451.25485 | 2103753.05423 | 37.7570945357026 | -122.406850749261 | (37.7570945357026, -122.406850749261) | ||
127668 | 127668 | 87026 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 863 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 3x3 | Permit Number 49970 | 6004379.0 | 2103877.0 | 37.757093220538394 | -122.427859766577 | (37.7570932205384, -122.427859766577) | ||
21685 | 21685 | 18423 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 952 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2013 12:00:00 AM | 3 | 3x3 | 6010455.30853 | 2103703.2834799998 | 37.75695810316021 | -122.406833222372 | (37.7569581031602, -122.406833222372) | ||
143424 | 143424 | 114091 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1717 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2015 12:00:00 AM | Permit Number 775992 | 5991423.2 | 2103752.9 | 37.7560110367904 | -122.472656396727 | (37.7560110367904, -122.472656396727) | ||||
136828 | 136828 | 230393 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3420 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005567.360669999 | 2103163.57677 | 37.7552014816894 | -122.423699232135 | (37.7552014816894, -122.423699232135) | |||
45445 | 45445 | 230392 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3416 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005586.33797 | 2103162.25218 | 37.7551989159029 | -122.423633508794 | (37.7551989159029, -122.423633508794) | |||
53871 | 53871 | 230391 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3425 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005521.318 | 2103117.66656 | 37.755072823769204 | -122.423855197061 | (37.7550728237692, -122.423855197061) | |||
173263 | 173263 | 230390 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3431 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005492.40988 | 2103117.15388 | 37.7550697840629 | -122.423955133335 | (37.7550697840629, -122.423955133335) | |||
117348 | 117348 | 95786 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3431 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767530 | 6005503.0 | 2103116.0 | 37.7550672136514 | -122.42391842755801 | (37.7550672136514, -122.423918427558) | |
145306 | 145306 | 93295 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1019 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004430.0 | 2102966.0 | 37.7545947138847 | -122.427618485613 | (37.7545947138847, -122.427618485613) | ||
85097 | 85097 | 109530 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 76 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775000 | 6005863.7 | 2102913.1 | 37.7545304541232 | -122.42265660342301 | (37.7545304541232, -122.422656603423) |
113846 | 113846 | 93294 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1037 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004436.0 | 2102861.0 | 37.7543067479004 | -122.427590255736 | (37.7543067479004, -122.427590255736) | ||
87716 | 87716 | 93293 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1049 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004440.0 | 2102791.0 | 37.7541147705659 | -122.42757143594 | (37.7541147705659, -122.42757143594) | ||
18377 | 18377 | 93250 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1050 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004388.0 | 2102776.0 | 37.754070642695496 | -122.42775019598 | (37.7540706426955, -122.42775019598) | ||
114160 | 114160 | 93292 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1059 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004443.0 | 2102732.0 | 37.7539529400822 | -122.42755685810499 | (37.7539529400822, -122.427556858105) | ||
106888 | 106888 | 93251 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1060 CHURCH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004371.0 | 2102721.0 | 37.753918663927706 | -122.42780506745899 | (37.7539186639277, -122.427805067459) | ||
84828 | 84828 | 93291 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1065 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004445.0 | 2102697.0 | 37.753856951407705 | -122.42754744828301 | (37.7538569514077, -122.427547448283) | ||
114199 | 114199 | 100465 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1140 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010498.9 | 2102571.5 | 37.75385291653011 | -122.40660271212 | (37.7538529165301, -122.40660271212) |
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");