Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCareAssistant, DBH, PlotSize
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) |
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) |
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) | |||
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) |
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) | |
86924 | 86924 | 108507 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 796 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773790 | 5990094.5666 | 2109953.25495 | 37.772958540137 | -122.477704410848 | (37.772958540137, -122.477704410848) |
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) | |
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) | |||||
97987 | 97987 | 117395 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 544 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778554 | 5991215.4 | 2097083.4 | 37.737686285904296 | -122.47288871789 | (37.7376862859043, -122.47288871789) | ||
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) | ||||
85638 | 85638 | 92584 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 7 | 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) | ||
88751 | 88751 | 92582 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 5 | 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) | ||
90783 | 90783 | 92589 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 12 | 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) | ||
105427 | 105427 | 86795 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 2 | 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) | ||
106942 | 106942 | 92587 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 10 | 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) | ||
110607 | 110607 | 92586 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 9 | 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) | ||
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) | ||
93529 | 93529 | 2 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 850X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 5992872.52482 | 2114854.21479 | 37.78657606668221 | -122.468451837381 | (37.7865760666822, -122.468451837381) | ||
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) | ||
144520 | 144520 | 52671 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1234@ LINCOLN 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53911 | 5993637.83557736 | 2107090.14039952 | 37.7653021756316 | -122.46523990796699 | (37.7653021756316, -122.465239907967) | |
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) | ||
117526 | 117526 | 117298 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1590 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778522 | 5993741.6 | 2104678.7 | 37.7586869726954 | -122.46470588880699 | (37.7586869726954, -122.464705888807) | ||
125075 | 125075 | 53133 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 925 Holloway Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774158 | 5994000.81776041 | 2091173.40830125 | 37.7216197566197 | -122.46282963525199 | (37.7216197566197, -122.462829635252) | ||
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) | |||
78106 | 78106 | 102590 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1205 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47971 | 5995820.0 | 2092088.8 | 37.724237816628 | -122.4566074133 | (37.724237816628, -122.4566074133) | ||||
18622 | 18622 | 51694 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1205 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | Permit Number 47971 | 5995825.9822194 | 2092036.11859211 | 37.7240935095077 | -122.456582925823 | (37.7240935095077, -122.456582925823) | |||
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) | ||||
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) | |
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) | |
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) | |
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) | |
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) | ||
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) | |||
142452 | 142452 | 72994 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 590 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2011 12:00:00 AM | 3x3 | Permit Number 768023 | 6001377.74978743 | 2100887.76679336 | 37.748715263692006 | -122.438025102274 | (37.748715263692, -122.438025102274) | ||
79321 | 79321 | 10342 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 935 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2011 12:00:00 AM | 3 | 4x4 | 6001663.937059999 | 2109024.15924 | 37.7710720905099 | -122.437618081823 | (37.7710720905099, -122.437618081823) | ||
98839 | 98839 | 115435 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 563 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777504 | 6001919.8 | 2090201.1 | 37.7194029477524 | -122.43538635551901 | (37.7194029477524, -122.435386355519) | ||
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) | |||
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) | |
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) | |
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) | ||
21383 | 21383 | 3929 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 100X Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/18/2014 12:00:00 AM | 3 | 2x2 | 6002188.32938 | 2107609.3026900003 | 37.7672170447484 | -122.43570295204799 | (37.7672170447484, -122.435702952048) | ||
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) | |||
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) | |
116290 | 116290 | 88687 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 135 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2008 12:00:00 AM | Permit Number 51638 | 6003417.0 | 2105051.0 | 37.7602622759886 | -122.43127052793899 | (37.7602622759886, -122.431270527939) | |||
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) | |||
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) | |
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) | |
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) | ||
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) | |
98990 | 98990 | 96158 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767791 | 6003728.0 | 2095595.0 | 37.7343159198258 | -122.429520547314 | (37.7343159198258, -122.429520547314) | |
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) | |
24021 | 24021 | 177451 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 836 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004096.8384300005 | 2090858.43848 | 37.7213312534072 | -122.427907954105 | (37.7213312534072, -122.427907954105) | |||
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) | ||
127668 | 127668 | 87026 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 863 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 3x3 | Permit Number 49970 | 6004379.0 | 2103877.0 | 37.757093220538394 | -122.427859766577 | (37.7570932205384, -122.427859766577) | ||
18377 | 18377 | 93250 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1050 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004388.0 | 2102776.0 | 37.754070642695496 | -122.42775019598 | (37.7540706426955, -122.42775019598) | ||
92614 | 92614 | 93258 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1180X Church St | 2 | 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) | ||
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) | ||
83075 | 83075 | 93252 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1070 Church St | 1 | 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) | ||
94013 | 94013 | 93253 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1070 Church St | 2 | 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) | ||
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) | ||
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) | ||
91448 | 91448 | 93260 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1250X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004401.7 | 2101569.1 | 37.750757552311704 | -122.427616837084 | (37.7507575523117, -122.427616837084) | ||
106002 | 106002 | 93256 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1120 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | Owner Michael Freethy signed agreement on 12/26/09 to maintain curb cut added within 4' of tree after tree was planted | 6004410.0 | 2102371.0 | 37.7529598520175 | -122.427645261537 | (37.7529598520175, -122.427645261537) | |
145306 | 145306 | 93295 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1019 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004430.0 | 2102966.0 | 37.7545947138847 | -122.427618485613 | (37.7545947138847, -122.427618485613) | ||
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) | ||
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) | ||
113846 | 113846 | 93294 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1037 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004436.0 | 2102861.0 | 37.7543067479004 | -122.427590255736 | (37.7543067479004, -122.427590255736) | ||
87716 | 87716 | 93293 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1049 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004440.0 | 2102791.0 | 37.7541147705659 | -122.42757143594 | (37.7541147705659, -122.42757143594) | ||
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) | ||
84828 | 84828 | 93291 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1065 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004445.0 | 2102697.0 | 37.753856951407705 | -122.42754744828301 | (37.7538569514077, -122.427547448283) | ||
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) | |
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) | ||
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) | ||
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) | ||
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) | ||
110651 | 110651 | 4421 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1133 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2012 12:00:00 AM | 3 | 4X4 | Permit Number 769145 | 6004474.71062 | 2102295.4201 | 37.7527559874039 | -122.42741609607201 | (37.7527559874039, -122.427416096072) | |
144320 | 144320 | 93289 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1159 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004476.0 | 2102138.0 | 37.752323821507396 | -122.427400423827 | (37.7523238215074, -122.427400423827) | ||
85944 | 85944 | 93266 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1440 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004482.7 | 2100527.8 | 37.747902965476 | -122.42726256538602 | (37.747902965476, -122.427262565386) | ||
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) | ||
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) | ||
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) |
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) | ||||
90042 | 90042 | 93288 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1259 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004494.0 | 2101568.0 | 37.7507597523824 | -122.42729757712601 | (37.7507597523824, -122.427297577126) | ||
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) | ||
81232 | 81232 | 93286 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1283 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004502.0 | 2101425.0 | 37.7503675600759 | -122.427259727267 | (37.7503675600759, -122.427259727267) | ||
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) |
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");