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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
111694 | 111694 | 92580 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 3 | 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) | ||
117359 | 117359 | 92585 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 8 | 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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
99829 | 99829 | 95738 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Edinburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767484 | 6003120.3 | 2091142.7 | 37.7220564786865 | -122.431303852024 | (37.7220564786865, -122.431303852024) | |
14973 | 14973 | 18344 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 440 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/2015 07:27:00 AM | 3 | 3X3 | 6010309.570730001 | 2106285.64769 | 37.7640405376657 | -122.40751930078001 | (37.7640405376657, -122.40751930078) | ||
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) | |
82178 | 82178 | 5416 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 430X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2011 12:00:00 AM | 3 | 6x150 | 6004853.970832599 | 2105864.857711 | 37.7625782660478 | -122.42635866544599 | (37.7625782660478, -122.426358665446) | ||
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) | |
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) | |
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) | |||
9788 | 9788 | 115347 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 398X HARRISON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 773314 | 6014854.0 | 2114630.0 | 37.7872055860551 | -122.392385006805 | (37.7872055860551, -122.392385006805) | |
9806 | 9806 | 115346 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 398X HARRISON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 773314 | 6014854.0 | 2114630.0 | 37.7872055860551 | -122.392385006805 | (37.7872055860551, -122.392385006805) | |
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) | ||
97369 | 97369 | 51994 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3858 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1977 12:00:00 AM | Permit Number 769135 | 5995734.40748516 | 2115851.40858603 | 37.78947898308 | -122.458622703992 | (37.78947898308, -122.458622703992) | |||
18110 | 18110 | 5394 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 347 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2014 12:00:00 AM | 2 | 7x5 | 6004926.5455599995 | 2106285.12827 | 37.7637363311974 | -122.426137576609 | (37.7637363311974, -122.426137576609) | ||
117348 | 117348 | 95786 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3431 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767530 | 6005503.0 | 2103116.0 | 37.7550672136514 | -122.42391842755801 | (37.7550672136514, -122.423918427558) | |
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) | |||
53871 | 53871 | 230391 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3425 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005521.318 | 2103117.66656 | 37.755072823769204 | -122.423855197061 | (37.7550728237692, -122.423855197061) | |||
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) | |||
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) |
87986 | 87986 | 91094 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
114805 | 114805 | 91093 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
123957 | 123957 | 91091 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
126063 | 126063 | 91095 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
139405 | 139405 | 91090 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
143561 | 143561 | 91089 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
145490 | 145490 | 91092 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) | |
45445 | 45445 | 230392 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3416 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005586.33797 | 2103162.25218 | 37.7551989159029 | -122.423633508794 | (37.7551989159029, -122.423633508794) | |||
20720 | 20720 | 10236 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 33 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/30/2002 12:00:00 AM | 8 | 4X4 | 6005944.57875 | 2109639.18298 | 37.7730032531225 | -122.42285489644699 | (37.7730032531225, -122.422854896447) | ||
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) | |||
2562 | 2562 | 124910 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3234 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780160 | 5998760.117380001 | 2116596.00833 | 37.79169688945171 | -122.4482077616 | (37.7916968894517, -122.4482077616) | |
2563 | 2563 | 124911 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3234 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780160 | 5998736.95045 | 2116593.12953 | 37.7916876606053 | -122.448287711302 | (37.7916876606053, -122.448287711302) | |
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) | |
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) | ||
49354 | 49354 | 131010 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3099 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001935.38679 | 2118702.3343700003 | 37.797661323668606 | -122.437372261923 | (37.7976613236686, -122.437372261923) | |||
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) | |||
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) |
83591 | 83591 | 94262 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2850X 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009745.2 | 2104556.4 | 37.759260809864294 | -122.409349258874 | (37.7592608098643, -122.409349258874) | |
85874 | 85874 | 94260 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2850X 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009745.2 | 2104556.4 | 37.759260809864294 | -122.409349258874 | (37.7592608098643, -122.409349258874) | |
101173 | 101173 | 94263 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2850X 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009745.2 | 2104556.4 | 37.759260809864294 | -122.409349258874 | (37.7592608098643, -122.409349258874) | |
114755 | 114755 | 94258 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2850X 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009745.2 | 2104556.4 | 37.759260809864294 | -122.409349258874 | (37.7592608098643, -122.409349258874) | |
141665 | 141665 | 94261 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2850X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009745.2 | 2104556.4 | 37.759260809864294 | -122.409349258874 | (37.7592608098643, -122.409349258874) | |
44789 | 44789 | 230394 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 280 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005433.48505 | 2102088.4512099996 | 37.752241878473896 | -122.42408575987 | (37.7522418784739, -122.42408575987) | |||
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) | |
113204 | 113204 | 114762 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 27X Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | Permit Number 46967 | 6005096.96871 | 2096699.6024099998 | 37.7374263260205 | -122.424866136467 | (37.7374263260205, -122.424866136467) | |||
109624 | 109624 | 94259 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2777X 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.40957339028499 | (37.7597963985886, -122.409573390285) | |
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) | ||
91447 | 91447 | 5370 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 265 DOLORES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2015 03:03:00 PM | 3 | 3X3 | 6005008.2 | 2106862.7 | 37.765326820302 | -122.42589627439101 | (37.765326820302, -122.425896274391) | ||
85160 | 85160 | 2390 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2642X Bryant St | 2 | 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) | ||
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) | ||
92111 | 92111 | 29047 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 244 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/31/2012 12:00:00 AM | 3 | 3x3 | 6008230.7231960995 | 2109406.8924959 | 37.7724941663121 | -122.414930372766 | (37.7724941663121, -122.414930372766) | ||
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) | ||
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) | ||
94068 | 94068 | 112744 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 235 Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2015 12:00:00 AM | Permit Number 774127 | 5993719.1 | 2088769.4 | 37.7150026970857 | -122.463629063261 | (37.7150026970857, -122.463629063261) | ||
90907 | 90907 | 13340 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 230 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2007 12:00:00 AM | 3 | 3X24 | 6011187.2509688 | 2090638.9738565 | 37.721127222942 | -122.40338282278499 | (37.721127222942, -122.403382822785) | ||
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) | |||
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) | ||
21175 | 21175 | 5356 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 220 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2015 03:17:00 PM | 3 | 6x6 | posted for removal 3/27/14 DPW | 6004796.958190001 | 2107043.90776 | 37.765812433218706 | -122.426639815582 | (37.7658124332187, -122.426639815582) | |
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) | |
91750 | 91750 | 94689 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 218 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53815 | 6003547.0 | 2096007.0 | 37.73543692838779 | -122.43017570506201 | (37.7354369283878, -122.430175705062) | |
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) | ||
20240 | 20240 | 5355 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 214 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/03/2009 12:00:00 AM | 3 | 6 | 6004795.29962 | 2107076.64131 | 37.765902217941296 | -122.42664788340099 | (37.7659022179413, -122.426647883401) | ||
81332 | 81332 | 94246 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2125 BRYANT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |
91334 | 91334 | 94243 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2125 BRYANT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |
96403 | 96403 | 94244 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2125 BRYANT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |
111220 | 111220 | 94245 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2125 BRYANT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |
138820 | 138820 | 94247 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2125 BRYANT ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |
44178 | 44178 | 91424 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2112 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102 | 6003571.0 | 2107157.0 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | ||
91361 | 91361 | 91421 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2112 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102; tree 1 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012 | 6003571.0 | 2107157.0 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | ||
120630 | 120630 | 91426 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2112 15th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102 | 6003571.0 | 2107157.0 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | ||
121595 | 121595 | 91423 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2112 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102 | 6003571.0 | 2107157.0 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | ||
127472 | 127472 | 91422 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2112 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102; Tree 2 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012 | 6003571.0 | 2107157.0 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | ||
142736 | 142736 | 91425 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2112 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102 | 6003571.0 | 2107157.0 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | ||
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) | |||||
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) | |||||
21837 | 21837 | 5348 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 200X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004789.9063099995 | 2107160.01438 | 37.7661308355062 | -122.426672475382 | (37.7661308355062, -122.426672475382) | |
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) | ||
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) | ||
79853 | 79853 | 96159 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767792 | 6003680.0 | 2095311.9 | 37.7335358734479 | -122.429666314328 | (37.7335358734479, -122.429666314328) | |
105916 | 105916 | 96160 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2 Milton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767792 | 6003680.0 | 2095311.9 | 37.7335358734479 | -122.429666314328 | (37.7335358734479, -122.429666314328) | |
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) | ||
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) | ||
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) | ||
14910 | 14910 | 17426 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1869 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2015 01:06:00 PM | 3 | 3X3 | 6013447.639169999 | 2096284.8118900002 | 37.736755533926 | -122.39596469871401 | (37.736755533926, -122.395964698714) | ||
79518 | 79518 | 29856 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1800X Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/2011 12:00:00 AM | 3 | 4x4 | 6014606.392164 | 2099329.1692391 | 37.745179108267 | -122.392171198439 | (37.745179108267, -122.392171198439) | ||
1590 | 1590 | 5343 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 180 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2014 02:20:00 PM | 3 | 3X3 | 6004776.7961099995 | 2107352.0132 | 37.7666572770255 | -122.426731495165 | (37.7666572770255, -122.426731495165) | ||
59156 | 59156 | 87882 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1771 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50853 | 6002283.00879 | 2120864.7759700003 | 37.8036185768076 | -122.436324238766 | (37.8036185768076, -122.436324238766) | |
60367 | 60367 | 131011 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1771 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002300.20603 | 2120865.81933 | 37.8036224187107 | -122.436264801676 | (37.8036224187107, -122.436264801676) | |||
77688 | 77688 | 93269 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1730 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004618.0 | 2098811.0 | 37.743196678206296 | -122.42667246707799 | (37.7431966782063, -122.426672467078) | ||
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) | ||||
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) | ||
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) | ||
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) | |
85134 | 85134 | 93273 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1679 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004706.9 | 2099119.3 | 37.7440482251279 | -122.42638702061701 | (37.7440482251279, -122.426387020617) | ||
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) |
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");