Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
qLegalStatus ✖
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 172742 | 172742 | 177452 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 404 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003440.2849 | 2091219.73942 | 37.7222861409715 | -122.430203237092 | (37.7222861409715, -122.430203237092) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 146333 | 146333 | 9298 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 135X Mansell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1992 12:00:00 AM | 3 | 3X3 | 6011497.3933157995 | 2090592.5284866001 | 37.7210170109869 | -122.40230748066001 | (37.7210170109869, -122.40230748066) | ||
| 146253 | 146253 | 85830 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 875 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824523999 | 2112775.117387 | 37.7819184786136 | -122.40430550469401 | (37.7819184786136, -122.404305504694) | ||
| 146109 | 146109 | 85695 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 640 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6012881.28755 | 2114275.485576 | 37.786122430176896 | -122.39918531693199 | (37.7861224301769, -122.399185316932) | ||
| 146040 | 146040 | 85697 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 640 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6012881.28755 | 2114275.485576 | 37.786122430176896 | -122.39918531693199 | (37.7861224301769, -122.399185316932) | ||
| 146017 | 146017 | 92581 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 145952 | 145952 | 85814 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1607 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007663.0 | 2109095.0 | 37.7716058657462 | -122.41687208779301 | (37.7716058657462, -122.416872087793) | ||
| 145750 | 145750 | 93279 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1557 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004591.0 | 2099830.0 | 37.745993091787795 | -122.426838380811 | (37.7459930917878, -122.426838380811) | ||
| 145512 | 145512 | 72375 | Private 5 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 4299X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 3x3 | Permit Number 773790 | 5990099.63678033 | 2109979.56687008 | 37.773031079694 | -122.47768879633699 | (37.773031079694, -122.477688796337) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 144410 | 144410 | 85707 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 960 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010763.0 | 2112242.0 | 37.7804206796364 | -122.406370731962 | (37.7804206796364, -122.406370731962) | ||
| 144320 | 144320 | 93289 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1159 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004476.0 | 2102138.0 | 37.752323821507396 | -122.427400423827 | (37.7523238215074, -122.427400423827) | ||
| 144302 | 144302 | 30135 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 220X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2007 12:00:00 AM | 3 | 3X30 | 6011221.783783999 | 2090644.291322 | 37.721143752318895 | -122.403263826082 | (37.7211437523189, -122.403263826082) | ||
| 144143 | 144143 | 85565 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1276 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016630.35305 | 2093972.0233900002 | 37.7305816357941 | -122.384799493903 | (37.7305816357941, -122.384799493903) | ||
| 143702 | 143702 | 85577 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1370 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016127.199744 | 2094347.0989189998 | 37.731583677290004 | -122.38656512948499 | (37.73158367729, -122.386565129485) | ||
| 143637 | 143637 | 85570 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1260 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016711.517151 | 2093911.5196330003 | 37.7304199931233 | -122.384514682139 | (37.7304199931233, -122.384514682139) | ||
| 143631 | 143631 | 88363 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2294 31st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52532 | 5986746.4 | 2099664.8 | 37.7445143908471 | -122.48852965844999 | (37.7445143908471, -122.48852965845) | |||
| 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) | |||
| 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) | |
| 143516 | 143516 | 93278 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1559 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004592.0 | 2099818.0 | 37.74596019909129 | -122.426834068489 | (37.7459601990913, -122.426834068489) | ||
| 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) | ||||
| 142798 | 142798 | 103791 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1214 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006878.4 | 2115091.6 | 37.7880269138329 | -122.420011690177 | (37.7880269138329, -122.420011690177) | ||
| 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) | ||
| 142452 | 142452 | 72994 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 590 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2011 12:00:00 AM | 3x3 | Permit Number 768023 | 6001377.74978743 | 2100887.76679336 | 37.748715263692006 | -122.438025102274 | (37.748715263692, -122.438025102274) | ||
| 142267 | 142267 | 85832 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 875 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824523999 | 2112775.117387 | 37.7819184786136 | -122.40430550469401 | (37.7819184786136, -122.404305504694) | ||
| 142121 | 142121 | 86796 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 142073 | 142073 | 108791 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 323 Edinburgh St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774649 | 6003546.88289 | 2091819.58764 | 37.7239392283561 | -122.429877518865 | (37.7239392283561, -122.429877518865) | |
| 142002 | 142002 | 85561 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 990 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018144.213614 | 2092843.516343 | 37.7275665867834 | -122.379487431767 | (37.7275665867834, -122.379487431767) | ||
| 141931 | 141931 | 83827 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 755-757 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | Permit Number 52235 | 6009406.96888923 | 2119078.72581504 | 37.7991167247732 | -122.41154506438299 | (37.7991167247732, -122.411545064383) | |||
| 141895 | 141895 | 84852 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1266 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2007 12:00:00 AM | Permit No. 49294 | 6005132.0 | 2100972.0 | 37.7491593351889 | -122.42504891393499 | (37.7491593351889, -122.425048913935) | |||
| 141707 | 141707 | 85728 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1025 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2007 12:00:00 AM | 3 | 3x3 | 6010365.0 | 2111820.0 | 37.7792396944918 | -122.40771784288 | (37.7792396944918, -122.40771784288) | ||
| 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) | |
| 141455 | 141455 | 103836 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 900X O'Farrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006751.076230001 | 2113939.67696 | 37.78485684194221 | -122.420370415446 | (37.7848568419422, -122.420370415446) | ||
| 140765 | 140765 | 85831 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 875 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824523999 | 2112775.117387 | 37.7819184786136 | -122.40430550469401 | (37.7819184786136, -122.404305504694) | ||
| 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) | ||
| 139951 | 139951 | 85719 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1175 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009405.0 | 2110901.0 | 37.7766625499179 | -122.410973965657 | (37.7766625499179, -122.410973965657) | ||
| 139844 | 139844 | 93265 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1400X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004448.1 | 2100692.1 | 37.748352138422796 | -122.42739391326401 | (37.7483521384228, -122.427393913264) | ||
| 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) | |
| 139282 | 139282 | 87673 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2610 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2006 12:00:00 AM | 3 | 3x3 | 6010582.741346 | 2086196.4709060001 | 37.708895230886 | -122.40515978386101 | (37.708895230886, -122.405159783861) | ||
| 139100 | 139100 | 2389 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2642X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6009749.5258463 | 2101948.1671123 | 37.752099429361294 | -122.409150251369 | (37.7520994293613, -122.409150251369) | ||
| 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) | |
| 138637 | 138637 | 94896 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1375 Keith St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53955 | 6016208.4 | 2094705.0 | 37.7325708970962 | -122.386309345138 | (37.7325708970962, -122.386309345138) | ||
| 138443 | 138443 | 15056 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1441 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 3 | 4x4 | 6015002.0 | 2095363.0 | 37.7343107811298 | -122.390526157796 | (37.7343107811298, -122.390526157796) | ||
| 138373 | 138373 | 9306 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 240X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2007 12:00:00 AM | 3 | 3X100 | 6011154.1519898 | 2090628.8663314 | 37.7210976210121 | -122.403496526224 | (37.7210976210121, -122.403496526224) | ||
| 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) | |||
| 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) | |||
| 132375 | 132375 | 230378 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 11 Haight St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6006027.69558 | 2109650.1201 | 37.7730379732539 | -122.422568162015 | (37.7730379732539, -122.422568162015) | |||
| 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) | |||
| 128409 | 128409 | 88751 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 990 Polk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284.0 | 37.785814090273796 | -122.41966893082501 | (37.7858140902738, -122.419668930825) | ||
| 128139 | 128139 | 12447 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1989X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2004 12:00:00 AM | 4 | 3x3 | 6004432.626396201 | 2115327.1853143997 | 37.7885356724235 | -122.428490433403 | (37.7885356724235, -122.428490433403) | ||
| 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) | ||
| 127595 | 127595 | 85589 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1566 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015069.619532 | 2095135.4181869999 | 37.7336896386511 | -122.390276478357 | (37.7336896386511, -122.390276478357) | ||
| 127564 | 127564 | 16583 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 810X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2008 12:00:00 AM | 2 | 3X3 | 5992991.92524 | 2114858.80829 | 37.7865955752076 | -122.46803907898199 | (37.7865955752076, -122.468039078982) | ||
| 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) | ||
| 127408 | 127408 | 85825 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1399X Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008422.422874 | 2109956.642426 | 37.774014420128495 | -122.414306166437 | (37.7740144201285, -122.414306166437) | ||
| 127402 | 127402 | 13061 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 583 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/01/2013 12:00:00 AM | 12 | 2X2 | 6009566.8887098 | 2120490.1657189 | 37.8030011583731 | -122.411091436508 | (37.8030011583731, -122.411091436508) | ||
| 127346 | 127346 | 94638 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2000X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2010 12:00:00 AM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.715357222040005 | -122.399324379639 | (37.71535722204, -122.399324379639) | ||
| 126091 | 126091 | 93264 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1326 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004490.0 | 2101167.0 | 37.749658473374204 | -122.42728284799401 | (37.7496584733742, -122.427282847994) | ||
| 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) | |
| 125597 | 125597 | 93271 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1699X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004711.0 | 2099043.6 | 37.7438406020251 | -122.426367454995 | (37.7438406020251, -122.426367454995) | ||
| 125341 | 125341 | 103817 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1100 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006925.9 | 2114751.5 | 37.787095758933894 | -122.41982320605 | (37.7870957589339, -122.41982320605) | ||
| 125075 | 125075 | 53133 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 925 Holloway Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774158 | 5994000.81776041 | 2091173.40830125 | 37.7216197566197 | -122.46282963525199 | (37.7216197566197, -122.462829635252) | ||
| 124508 | 124508 | 85821 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1501 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6008072.0 | 2109608.0 | 37.7730374398788 | -122.415493654294 | (37.7730374398788, -122.415493654294) | ||
| 124501 | 124501 | 93263 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1326 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004490.0 | 2101167.0 | 37.749658473374204 | -122.42728284799401 | (37.7496584733742, -122.427282847994) | ||
| 124409 | 124409 | 85712 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1144 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009550.0 | 2111081.0 | 37.777164917460105 | -122.410485079371 | (37.7771649174601, -122.410485079371) | ||
| 124404 | 124404 | 87647 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1989X PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2008 12:00:00 AM | 3 | 3x3 | 6004432.0 | 2115332.0 | 37.788548856891296 | -122.42849294395701 | (37.7885488568913, -122.428492943957) | ||
| 124075 | 124075 | 50261 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 31 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2002 12:00:00 AM | Permit Number 46967 | 6005053.32023027 | 2096760.11488265 | 37.737590014135 | -122.425021354004 | (37.737590014135, -122.425021354004) | ||
| 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) | |
| 123660 | 123660 | 85829 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 875 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824523999 | 2112775.117387 | 37.7819184786136 | -122.40430550469401 | (37.7819184786136, -122.404305504694) | ||
| 123606 | 123606 | 92588 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 120899 | 120899 | 85560 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 980 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018187.977748999 | 2092810.8923689998 | 37.727479421244 | -122.37933387198099 | (37.727479421244, -122.379333871981) | ||
| 120705 | 120705 | 92583 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 120644 | 120644 | 103862 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1436 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006766.2 | 2115894.4 | 37.7902248822442 | -122.42045688909701 | (37.7902248822442, -122.420456889097) | ||
| 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) | ||
| 120504 | 120504 | 17177 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1601 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2007 12:00:00 AM | 3 | 4X4 | 6004921.1693652 | 2114736.5058391998 | 37.7869414485048 | -122.426758067349 | (37.7869414485048, -122.426758067349) | ||
| 120459 | 120459 | 85597 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1101 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 6 | 3x3 | 6017523.881587001 | 2093256.0516779998 | 37.728665096277204 | -122.381660625783 | (37.7286650962772, -122.381660625783) | ||
| 120237 | 120237 | 98720 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1500 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2012 12:00:00 AM | 4x4 | Permit Number 768751 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | ||
| 120118 | 120118 | 85737 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 843 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6011572.165806 | 2112967.7341830004 | 37.782458608165896 | -122.40362250946998 | (37.7824586081659, -122.40362250947) | ||
| 120019 | 120019 | 85580 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1458 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015655.098902999 | 2094699.254039 | 37.7325244779387 | -122.38822185678002 | (37.7325244779387, -122.38822185678) | ||
| 119953 | 119953 | 63015 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 75 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/16/2014 12:00:00 AM | Permit Number 772837 | 6007421.64921795 | 2097871.12423845 | 37.7407740975251 | -122.41691158671499 | (37.7407740975251, -122.416911586715) | ||
| 119478 | 119478 | 96015 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 999 California St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767660 | 6009569.0 | 2116409.0 | 37.791795397820394 | -122.410795730189 | (37.7917953978204, -122.410795730189) | |
| 119023 | 119023 | 34756 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 930 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | Permit Number 767406 | 6007964.37275398 | 2102502.67346206 | 37.7535218086 | -122.415362848727 | (37.7535218086, -122.415362848727) | ||
| 118880 | 118880 | 93268 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1574 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/2015 05:47:00 AM | 3 | 3x3 | 6004569.0 | 2099722.0 | 37.7456953047191 | -122.42690676352 | (37.7456953047191, -122.42690676352) |
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");