Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2200 | 2200 | 252931 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 71 Edgar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997064.0 | 2091155.0 | 37.7217451669512 | -122.45223976154499 | (37.7217451669512, -122.452239761545) | ||||
89333 | 89333 | 104727 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1079 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | Permit Number 770313 | 6004450.0 | 2102615.0 | 37.7536320814231 | -122.427524315639 | (37.7536320814231, -122.427524315639) | ||
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) | ||||
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) | |||
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) | |||
98395 | 98395 | 108709 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 280 Fair Oaks St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773390 | 6005432.93594 | 2102084.07132 | 37.752229821306706 | -122.42408734733101 | (37.7522298213067, -122.424087347331) | |
9834 | 9834 | 6787 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1360 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/03/2017 06:55:00 AM | 3 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.739876324716896 | -122.384492742853 | (37.7398763247169, -122.384492742853) | ||
102059 | 102059 | 108761 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1350 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774645 | 6004491.73804 | 2101024.57628 | 37.749267509186204 | -122.427266693799 | (37.7492675091862, -122.427266693799) |
90759 | 90759 | 108834 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 163 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774662 | 6004445.49273 | 2094062.1156099997 | 37.73014756094079 | -122.42693080570601 | (37.7301475609408, -122.426930805706) | |
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) | |
89625 | 89625 | 108873 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 137 Cole St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773403 | 5997771.922180001 | 2110131.23662 | 37.7738897825389 | -122.45116047571699 | (37.7738897825389, -122.451160475717) | |
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) |
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) | ||
117889 | 117889 | 109142 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 342 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773572 | 5986886.5 | 2113633.7 | 37.782877302208796 | -122.489071978745 | (37.7828773022088, -122.489071978745) |
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) | ||
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) | ||
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) |
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) |
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) | ||
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) |
88356 | 88356 | 95388 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 4290 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767255 | 6001987.9 | 2101228.0 | 37.7496841432906 | -122.43593955208 | (37.7496841432906, -122.43593955208) | |
106814 | 106814 | 95387 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 949 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767255 | 6001944.0 | 2101334.0 | 37.7499727001327 | -122.436098944037 | (37.7499727001327, -122.436098944037) | |
104974 | 104974 | 95423 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2187 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767291 | 5989736.1 | 2100494.0 | 37.7469651560486 | -122.478252612879 | (37.7469651560486, -122.478252612879) | |
13480 | 13480 | 85599 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1115 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2014 12:00:00 AM | 3 | 3x3 | 6017434.0078 | 2093308.576 | 37.7288043549368 | -122.38197498007798 | (37.7288043549368, -122.381974980078) | ||
105721 | 105721 | 95660 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 431 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767422 | 6010656.7 | 2092697.9 | 37.726750960199794 | -122.40536171554 | (37.7267509601998, -122.40536171554) | |
96738 | 96738 | 85598 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1101 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6017523.881587001 | 2093256.0516779998 | 37.728665096277204 | -122.381660625783 | (37.7286650962772, -122.381660625783) | ||
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) | |
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) | ||
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) | ||
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) | ||
507 | 507 | 251288 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1335 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/18/2017 01:58:00 PM | 3 | 3x3 | 6016828.0 | 2097292.0 | 37.7397085577181 | -122.38434732981199 | (37.7397085577181, -122.384347329812) | |
84159 | 84159 | 85604 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1261 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016687.610646 | 2093879.449725 | 37.7303306134548 | -122.384595098105 | (37.7303306134548, -122.384595098105) | ||
86667 | 86667 | 85584 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1512 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015354.897796 | 2094923.102787 | 37.7331224832721 | -122.389275358402 | (37.7331224832721, -122.389275358402) | ||
91134 | 91134 | 85567 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1274 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016640.49857 | 2093964.460415 | 37.730561430483796 | -122.384763892339 | (37.7305614304838, -122.384763892339) | ||
93558 | 93558 | 85578 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1388 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016034.7263629995 | 2094416.0331849998 | 37.7317678372886 | -122.386889636739 | (37.7317678372886, -122.386889636739) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
82865 | 82865 | 93743 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 875 Howard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2010 12:00:00 AM | 3x3 | Permit Number 53322 | 6011367.4 | 2112778.7 | 37.7819281242694 | -122.40431760427 | (37.7819281242694, -122.40431760427) | |||
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) | ||
89374 | 89374 | 88771 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 461 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775199 | 6000624.0 | 2110522.0 | 37.7751256013752 | -122.441322740074 | (37.7751256013752, -122.441322740074) | |
511 | 511 | 251164 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2017 01:46:00 PM | 3 | 3x3 | 6017471.0 | 2096747.0 | 37.738247630240295 | -122.382086185189 | (37.7382476302403, -122.382086185189) | ||
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) | ||
9121 | 9121 | 85732 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 901 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6011193.193535 | 2112605.183477 | 37.7814419523203 | -122.404908060988 | (37.7814419523203, -122.404908060988) | ||
9463 | 9463 | 85733 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 901 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 4 | 3x3 | 6011193.193535 | 2112605.183477 | 37.7814419523203 | -122.404908060988 | (37.7814419523203, -122.404908060988) | ||
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) | ||
89180 | 89180 | 85698 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 640 Howard St | 4 | 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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
1124 | 1124 | 29774 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1100X Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 12:44:00 PM | 3 | 3x3 | 6018183.3236 | 2096672.8034 | 37.7380832156692 | -122.37961814277901 | (37.7380832156692, -122.379618142779) | ||
9231 | 9231 | 6725 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1200X Fairfax Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2008 12:00:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
95910 | 95910 | 95566 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 168 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2014 12:00:00 AM | 3x3 | Permit Number 772810 | 6004034.0 | 2101610.0 | 37.75084904875379 | -122.4288912915 | (37.7508490487538, -122.4288912915) | |
79013 | 79013 | 85727 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1025 Howard St | 1 | 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) | ||
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) | ||
85241 | 85241 | 85828 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 875 Howard St | 1 | 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) | ||
88557 | 88557 | 85827 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1345 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008580.0 | 2110114.0 | 37.774455337270396 | -122.413772211324 | (37.7744553372704, -122.413772211324) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
80881 | 80881 | 85815 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1607 Howard St | 2 | 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) | ||
86047 | 86047 | 85812 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1675 Howard St | 3 | 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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
102897 | 102897 | 87853 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 599 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50764 | 6007684.0 | 2096571.0 | 37.7372189966792 | -122.415912430403 | (37.7372189966792, -122.415912430403) | ||
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) |
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");