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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96836 | 96836 | 85833 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 875 Howard St | 6 | 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) | ||
| 96859 | 96859 | 85826 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1399X Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008422.422874 | 2109956.642426 | 37.774014420128495 | -122.414306166437 | (37.7740144201285, -122.414306166437) | ||
| 97539 | 97539 | 93284 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1347 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004523.0 | 2101050.0 | 37.7493390847523 | -122.427160399995 | (37.7493390847523, -122.427160399995) | ||
| 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) | ||
| 98869 | 98869 | 93275 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1607 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004606.0 | 2099539.0 | 37.7451949208192 | -122.42676579302 | (37.7451949208192, -122.42676579302) | ||
| 99080 | 99080 | 103792 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1214 Polk St | 2 | 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) | ||
| 99170 | 99170 | 100432 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 200X Stonecrest Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | |||||
| 99235 | 99235 | 86637 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2679 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009805.5318559995 | 2101750.09748 | 37.751558711569096 | -122.40894259967101 | (37.7515587115691, -122.408942599671) | ||
| 99600 | 99600 | 103846 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1540 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006747.0 | 2116248.1 | 37.7911949727431 | -122.42054843762399 | (37.7911949727431, -122.420548437624) | ||
| 99675 | 99675 | 103845 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1540 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006747.0 | 2116248.1 | 37.7911949727431 | -122.42054843762399 | (37.7911949727431, -122.420548437624) | ||
| 100161 | 100161 | 85559 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 980 Palou Ave | 1 | 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) | ||
| 100415 | 100415 | 6784 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1360 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 4 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.739876324716896 | -122.384492742853 | (37.7398763247169, -122.384492742853) | ||
| 100513 | 100513 | 93282 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1383 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004535.0 | 2100841.0 | 37.748765897796204 | -122.42710401922199 | (37.7487658977962, -122.427104019222) | ||
| 100706 | 100706 | 85720 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1133 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009666.355548 | 2111144.506481 | 37.777345813652 | -122.41008705150699 | (37.777345813652, -122.410087051507) | ||
| 100755 | 100755 | 93259 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1234 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004459.0 | 2101704.0 | 37.7511311972424 | -122.42742829765899 | (37.7511311972424, -122.427428297659) | ||
| 101720 | 101720 | 93272 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1689 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004632.0 | 2099057.0 | 37.7438729293821 | -122.42664157265 | (37.7438729293821, -122.42664157265) | ||
| 102183 | 102183 | 93254 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1070 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004394.0 | 2102659.0 | 37.753749727529396 | -122.427721110855 | (37.7537497275294, -122.427721110855) | ||
| 102730 | 102730 | 93257 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1180X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004390.8 | 2101994.4 | 37.7519247103798 | -122.42768482883699 | (37.7519247103798, -122.427684828837) | ||
| 102892 | 102892 | 13103 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1516 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2008 12:00:00 AM | 3 | 3x3 | 6005111.0 | 2119918.0 | 37.801179250916796 | -122.426470375667 | (37.8011792509168, -122.426470375667) | ||
| 103470 | 103470 | 103793 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1214 Polk St | 3 | 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) | ||
| 103768 | 103768 | 93261 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1252 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004465.0 | 2101602.0 | 37.750851468343896 | -122.427400283526 | (37.7508514683439, -122.427400283526) | ||
| 104089 | 104089 | 108760 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1350 Church St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6004491.73804 | 2101024.57628 | 37.749267509186204 | -122.427266693799 | (37.7492675091862, -122.427266693799) | ||||
| 104380 | 104380 | 103834 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 900X O'Farrell St | 1 | 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) | ||
| 105434 | 105434 | 85569 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1260 Palou Ave | 1 | 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) | ||
| 105958 | 105958 | 85583 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1500 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015418.292964 | 2094875.9215880001 | 37.7329964475839 | -122.389052889382 | (37.7329964475839, -122.389052889382) | ||
| 106121 | 106121 | 9308 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 240X Mansell St | 3 | 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) | ||
| 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) | ||
| 107651 | 107651 | 103837 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 900X O'Farrell St | 4 | 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) | ||
| 108745 | 108745 | 93276 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1603 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004604.0 | 2099562.0 | 37.7452579604553 | -122.426774346316 | (37.7452579604553, -122.426774346316) | ||
| 109604 | 109604 | 93274 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1613 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004607.0 | 2099503.0 | 37.7450961296299 | -122.426759771954 | (37.7450961296299, -122.426759771954) | ||
| 109929 | 109929 | 85721 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1049 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010189.0 | 2111652.0 | 37.778768551926795 | -122.408314849736 | (37.7787685519268, -122.408314849736) | ||
| 110080 | 110080 | 93283 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1377 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004533.0 | 2100877.0 | 37.7488646323576 | -122.427113499044 | (37.7488646323576, -122.427113499044) | ||
| 110192 | 110192 | 85696 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 640 Howard St | 2 | 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) | ||
| 110344 | 110344 | 85820 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1501 Howard St | 1 | 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) | ||
| 110579 | 110579 | 93290 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1071 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004519.0 | 2102665.5 | 37.7537746450798 | -122.427289295317 | (37.7537746450798, -122.427289295317) | ||
| 110941 | 110941 | 85708 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 964 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010738.0 | 2112218.0 | 37.780353382723604 | -122.40645552748501 | (37.7803533827236, -122.406455527485) | ||
| 112715 | 112715 | 85568 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1264 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016691.22613 | 2093926.645569 | 37.730460403847204 | -122.384585884949 | (37.7304604038472, -122.384585884949) | ||
| 113436 | 113436 | 93287 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1279 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004501.0 | 2101449.0 | 37.750433401942104 | -122.427264894728 | (37.7504334019421, -122.427264894728) | ||
| 113657 | 113657 | 93285 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1289 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004504.0 | 2101389.0 | 37.7502688255514 | -122.427250247058 | (37.7502688255514, -122.427250247058) | ||
| 113842 | 113842 | 6746 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1300X Fairfax Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 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) | ||
| 114055 | 114055 | 103794 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1214 Polk St | 4 | 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) | ||
| 114083 | 114083 | 100431 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 200X Stonecrest Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | |||||
| 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) | ||
| 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) | |||
| 114281 | 114281 | 26918 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2000X Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2010 12:00:00 AM | 3 | 3X3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
| 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) | |||
| 114770 | 114770 | 93280 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1485 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004568.0 | 2100246.0 | 37.7471340314151 | -122.42694753458099 | (37.7471340314151, -122.426947534581) | ||
| 114784 | 114784 | 93255 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1070 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004394.0 | 2102659.0 | 37.753749727529396 | -122.427721110855 | (37.7537497275294, -122.427721110855) | ||
| 115233 | 115233 | 85817 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1581 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007957.739489 | 2109502.485486 | 37.7727412989479 | -122.415881423672 | (37.7727412989479, -122.415881423672) | ||
| 115779 | 115779 | 5577 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1041 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2010 12:00:00 AM | 3 | 3x3 | 6005148.8764838 | 2102292.2742932 | 37.752785456150605 | -122.42508448290899 | (37.7527854561506, -122.425084482909) | ||
| 116886 | 116886 | 85824 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1399X Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008422.422874 | 2109956.642426 | 37.774014420128495 | -122.414306166437 | (37.7740144201285, -122.414306166437) | ||
| 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) | ||
| 117554 | 117554 | 85822 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1499X Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008077.269337 | 2109627.004998 | 37.7730899192917 | -122.415476772701 | (37.7730899192917, -122.415476772701) | ||
| 118293 | 118293 | 85562 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 990 Palou Ave | 2 | 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) | ||
| 118353 | 118353 | 85607 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1397 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015969.720597 | 2094414.6007130002 | 37.7317603044799 | -122.387114277117 | (37.7317603044799, -122.387114277117) | ||
| 118449 | 118449 | 85818 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1525 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2007 12:00:00 AM | 3 | 3x3 | 6007957.0 | 2109502.0 | 37.7727399243445 | -122.415883947269 | (37.7727399243445, -122.415883947269) | ||
| 118815 | 118815 | 11953 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1436 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 3X4 | 6015854.7568499 | 2096315.1604746997 | 37.7369724919298 | -122.38764428476802 | (37.7369724919298, -122.387644284768) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
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");