trees
399 rows where qSpecies_id = 2 sorted by qAddress descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50443 | 96012 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 999 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767660 | 6009569 | 2116409 | 37.7917953978204 | -122.410795730189 | (37.7917953978204, -122.410795730189) | 5 | 1 | 10 | 28857 | 21 | |
53527 | 96014 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 999 California St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767660 | 6009569 | 2116409 | 37.7917953978204 | -122.410795730189 | (37.7917953978204, -122.410795730189) | 5 | 1 | 10 | 28857 | 21 | |
53962 | 96013 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 999 California St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767660 | 6009569 | 2116409 | 37.7917953978204 | -122.410795730189 | (37.7917953978204, -122.410795730189) | 5 | 1 | 10 | 28857 | 21 | |
161466 | 96015 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 999 California St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767660 | 6009569 | 2116409 | 37.7917953978204 | -122.410795730189 | (37.7917953978204, -122.410795730189) | 5 | 1 | 10 | 28857 | 21 | |
33153 | 88751 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
41333 | 88753 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Polk St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
87848 | 88749 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
98572 | 88750 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
159193 | 88752 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
163406 | 85562 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018144.213614 | 2092843.516343 | 37.7275665867834 | -122.379487431767 | (37.7275665867834, -122.379487431767) | 10 | 3 | 8 | 58 | 1 | ||
188775 | 85561 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018144.213614 | 2092843.516343 | 37.7275665867834 | -122.379487431767 | (37.7275665867834, -122.379487431767) | 10 | 3 | 8 | 58 | 1 | ||
102956 | 85559 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 980 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018187.977749 | 2092810.892369 | 37.727479421244 | -122.379333871981 | (37.727479421244, -122.379333871981) | 10 | 3 | 8 | 58 | 1 | ||
160107 | 85560 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 980 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018187.977749 | 2092810.892369 | 37.727479421244 | -122.379333871981 | (37.727479421244, -122.379333871981) | 10 | 3 | 8 | 58 | 1 | ||
5865 | 262160 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 98 Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
9316 | 262159 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 98 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
144650 | 85708 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 964 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010738 | 2112218 | 37.7803533827236 | -122.406455527485 | (37.7803533827236, -122.406455527485) | 14 | 2 | 9 | 28853 | 34 | ||
188346 | 85707 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 960 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010763 | 2112242 | 37.7804206796364 | -122.406370731962 | (37.7804206796364, -122.406370731962) | 14 | 2 | 9 | 28853 | 34 | ||
181972 | 18423 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 952 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2013 12:00:00 AM | 3 | 3x3 | 6010455.30853 | 2103703.28348 | 37.7569581031602 | -122.406833222372 | (37.7569581031602, -122.406833222372) | 10 | 4 | 7 | 28859 | 19 | ||
114396 | 95387 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 949 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767255 | 6001944 | 2101334 | 37.7499727001327 | -122.436098944037 | (37.7499727001327, -122.436098944037) | 2 | 4 | 5 | 28862 | 22 | |
39903 | 18422 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 940 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 06:57:00 AM | 3 | 3x3 | 6010451.25485 | 2103753.05423 | 37.7570945357026 | -122.406850749261 | (37.7570945357026, -122.406850749261) | 10 | 4 | 7 | 28859 | 19 | ||
42966 | 10342 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 935 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/2011 12:00:00 AM | 3 | 4x4 | 6001663.93706 | 2109024.15924 | 37.7710720905099 | -122.437618081823 | (37.7710720905099, -122.437618081823) | 15 | 5 | 11 | 29492 | 9 | ||
10603 | 18421 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 934 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2013 12:00:00 AM | 3 | 3x3 | 6010449.27067 | 2103789.58404 | 37.7571947273755 | -122.40686018586 | (37.7571947273755, -122.40686018586) | 10 | 4 | 7 | 28859 | 19 | ||
162176 | 34756 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 930 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | Permit Number 767406 | 6007964.37275398 | 2102502.67346206 | 37.7535218086 | -122.415362848727 | (37.7535218086, -122.415362848727) | 2 | 4 | 7 | 28859 | 19 | ||
29972 | 53133 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 925 Holloway Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774158 | 5994000.81776041 | 2091173.40830125 | 37.7216197566197 | -122.462829635252 | (37.7216197566197, -122.462829635252) | 9 | 8 | 6 | 64 | 24 | ||
41743 | 18420 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 924 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010442.48956 | 2103839.41038 | 37.7573311599314 | -122.406887149344 | (37.7573311599314, -122.406887149344) | 10 | 4 | 7 | 28859 | 19 | ||
22322 | 85732 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 901 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6011193.193535 | 2112605.183477 | 37.7814419523203 | -122.404908060988 | (37.7814419523203, -122.404908060988) | 14 | 2 | 9 | 28853 | 34 | ||
173913 | 85733 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 901 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 4 | 3x3 | 6011193.193535 | 2112605.183477 | 37.7814419523203 | -122.404908060988 | (37.7814419523203, -122.404908060988) | 14 | 2 | 9 | 28853 | 34 | ||
34950 | 103838 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006751.07623 | 2113939.67696 | 37.7848568419422 | -122.420370415446 | (37.7848568419422, -122.420370415446) | 13 | 9 | 9 | 28858 | 36 | ||
40281 | 103835 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006751.07623 | 2113939.67696 | 37.7848568419422 | -122.420370415446 | (37.7848568419422, -122.420370415446) | 13 | 9 | 9 | 28858 | 36 | ||
114647 | 103837 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006751.07623 | 2113939.67696 | 37.7848568419422 | -122.420370415446 | (37.7848568419422, -122.420370415446) | 13 | 9 | 9 | 28858 | 36 | ||
129205 | 103834 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006751.07623 | 2113939.67696 | 37.7848568419422 | -122.420370415446 | (37.7848568419422, -122.420370415446) | 13 | 9 | 9 | 28858 | 36 | ||
184033 | 103836 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 900X O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006751.07623 | 2113939.67696 | 37.7848568419422 | -122.420370415446 | (37.7848568419422, -122.420370415446) | 13 | 9 | 9 | 28858 | 36 | ||
98913 | 434 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 890X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010425.4291782 | 2104052.7086425 | 37.7579158746071 | -122.406961184613 | (37.7579158746071, -122.406961184613) | 10 | 4 | 7 | 28859 | 19 | ||
85532 | 110043 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 890 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011841.59848 | 2104237.14125 | 37.7585014297196 | -122.402076412192 | (37.7585014297196, -122.402076412192) | 10 | 3 | 8 | 28856 | 29 | |||
88499 | 67550 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 890 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31097 | 6011842.05192 | 2104248.01189 | 37.7585313034009 | -122.402075608207 | (37.7585313034009, -122.402075608207) | 10 | 3 | 8 | 28856 | 29 | |
7382 | 85829 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
56473 | 93743 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2010 12:00:00 AM | 3x3 | Permit Number 53322 | 6011367.4 | 2112778.7 | 37.7819281242694 | -122.40431760427 | (37.7819281242694, -122.40431760427) | 6 | 2 | 9 | 28853 | 34 | |||
60072 | 85828 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
84916 | 85833 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
170951 | 85832 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
179694 | 85831 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
193248 | 85830 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
66728 | 18391 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 874 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 4x4 | 6010420.6643105 | 2104143.6455038 | 37.7581653002339 | -122.406984073056 | (37.7581653002339, -122.406984073056) | 10 | 4 | 7 | 28859 | 19 | ||
20524 | 87026 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 863 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2007 12:00:00 AM | 3x3 | Permit Number 49970 | 6004379 | 2103877 | 37.7570932205384 | -122.427859766577 | (37.7570932205384, -122.427859766577) | 2 | 4 | 5 | 28862 | 3 | ||
5494 | 261029 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 863 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | 4x6 | 5986308 | 2110038 | 37.7729707519219 | -122.490808659035 | (37.7729707519219, -122.490808659035) | 11 | 6 | 2 | 55 | 26 | ||
79656 | 2 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 850X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 5992872.52482 | 2114854.21479 | 37.7865760666822 | -122.468451837381 | (37.7865760666822, -122.468451837381) | 11 | 6 | 1 | 54 | 11 | ||
165962 | 85737 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 843 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6011572.165806 | 2112967.734183 | 37.7824586081659 | -122.40362250947 | (37.7824586081659, -122.40362250947) | 6 | 2 | 9 | 28853 | 34 | ||
168460 | 3904 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 84 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2014 11:00:00 AM | 3 | 2X2 | 6002180.9408165 | 2107753.3024618 | 37.7676120130603 | -122.435738811724 | (37.7676120130603, -122.435738811724) | 15 | 5 | 5 | 29492 | 3 | ||
185957 | 177451 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 836 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004096.83843 | 2090858.43848 | 37.7213312534072 | -122.427907954105 | (37.7213312534072, -122.427907954105) | 9 | 7 | 6 | 28861 | 5 | |||
25318 | 16583 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 810X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2008 12:00:00 AM | 2 | 3X3 | 5992991.92524 | 2114858.80829 | 37.7865955752076 | -122.468039078982 | (37.7865955752076, -122.468039078982) | 11 | 6 | 1 | 54 | 11 | ||
62023 | 108507 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 796 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773790 | 5990094.5666 | 2109953.25495 | 37.772958540137 | -122.477704410848 | (37.772958540137, -122.477704410848) | 11 | 6 | 2 | 55 | 26 |
18500 | 144214 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 786 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 12:25:00 PM | 0 | Width 4ft | 5982943.75928 | 2110448.71022 | 37.7739013377013 | -122.502476188525 | (37.7739013377013, -122.502476188525) | 11 | 6 | 2 | 55 | 26 | ||
60125 | 109530 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 76 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775000 | 6005863.7 | 2102913.1 | 37.7545304541232 | -122.422656603423 | (37.7545304541232, -122.422656603423) | 2 | 4 | 5 | 28859 | 19 |
59261 | 83828 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 755-757 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | Permit Number 52235 | 6009406.96888923 | 2119078.72581504 | 37.7991167247732 | -122.411545064383 | (37.7991167247732, -122.411545064383) | 3 | 1 | 10 | 308 | 4 | |||
85121 | 83826 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 755-757 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | Permit Number 52235 | 6009406.96888923 | 2119078.72581504 | 37.7991167247732 | -122.411545064383 | (37.7991167247732, -122.411545064383) | 3 | 1 | 10 | 308 | 4 | |||
183348 | 83827 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 755-757 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | Permit Number 52235 | 6009406.96888923 | 2119078.72581504 | 37.7991167247732 | -122.411545064383 | (37.7991167247732, -122.411545064383) | 3 | 1 | 10 | 308 | 4 | |||
151915 | 63015 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 75 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/16/2014 12:00:00 AM | Permit Number 772837 | 6007421.64921795 | 2097871.12423845 | 37.7407740975251 | -122.416911586715 | (37.7407740975251, -122.416911586715) | 2 | 7 | 7 | 28859 | 2 | ||
179157 | 193406 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 746 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011525.03424 | 2104899.87784 | 37.7603034831294 | -122.403217858726 | (37.7603034831294, -122.403217858726) | 10 | 3 | 8 | 28856 | 29 | |||
93856 | 4894 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 745X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2007 12:00:00 AM | 3 | 3X3 | 6009751.8988059 | 2090059.5024837 | 37.7194558413593 | -122.408303589874 | (37.7194558413593, -122.408303589874) | 9 | 3 | 8 | 309 | 18 | ||
37463 | 252931 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 71 Edgar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997064 | 2091155 | 37.7217451669512 | -122.452239761545 | (37.7217451669512, -122.452239761545) | 9 | 8 | 6 | 28861 | 24 | ||||
7622 | 253826 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 701 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 02/22/2018 12:20:00 PM | 3 | 3x3 | |||||||||||
84741 | 230375 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 70 Pearl St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6005616.00843 | 2108643.76201 | 37.770251521926 | -122.423920665902 | (37.770251521926, -122.423920665902) | 8 | 2 | 5 | 28853 | 19 | |||
120075 | 230383 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 655 Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6005020.28561 | 2104519.96917 | 37.7588949199761 | -122.425687715924 | (37.7588949199761, -122.425687715924) | 2 | 4 | 5 | 28859 | 19 | |||
136291 | 5477 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 655 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005026.79294 | 2104432.16218 | 37.7586541903676 | -122.425658960999 | (37.7586541903676, -122.425658960999) | 2 | 4 | 5 | 28859 | 19 | |||
149323 | 230381 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 655 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6005021.94421 | 2104476.35643 | 37.7587752633866 | -122.425678875606 | (37.7587752633866, -122.425678875606) | 2 | 4 | 5 | 28859 | 19 | |||
186916 | 230382 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 655 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6005021.64655 | 2104500.02665 | 37.7588402394163 | -122.42568158976 | (37.7588402394163, -122.42568158976) | 2 | 4 | 5 | 28859 | 19 | |||
64305 | 18418 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 645X POTRERO AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/02/2016 12:00:00 AM | 3 | 3X3 | 6010440 | 2105310 | 37.7613689295586 | -122.406999409931 | (37.7613689295586, -122.406999409931) | 10 | 4 | 8 | 28859 | 19 | ||
126676 | 25487 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 645X POTRERO AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2013 12:00:00 AM | 3 | 3X3 | 6010440 | 2105310 | 37.7613689295586 | -122.406999409931 | (37.7613689295586, -122.406999409931) | 10 | 4 | 8 | 28859 | 19 | ||
43002 | 32722 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 644 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768334 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | 13 | 1 | 9 | 28858 | 36 | |
138301 | 32721 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 644 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37113 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | 13 | 1 | 9 | 28858 | 36 | |
143563 | 32720 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 644 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37113 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | 13 | 1 | 9 | 28858 | 36 | |
73027 | 85698 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6012881.28755 | 2114275.485576 | 37.7861224301769 | -122.399185316932 | (37.7861224301769, -122.399185316932) | 12 | 2 | 9 | 28855 | 6 | ||
138694 | 85696 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6012881.28755 | 2114275.485576 | 37.7861224301769 | -122.399185316932 | (37.7861224301769, -122.399185316932) | 12 | 2 | 9 | 28855 | 6 | ||
192345 | 85697 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6012881.28755 | 2114275.485576 | 37.7861224301769 | -122.399185316932 | (37.7861224301769, -122.399185316932) | 12 | 2 | 9 | 28855 | 6 | ||
193910 | 85695 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6012881.28755 | 2114275.485576 | 37.7861224301769 | -122.399185316932 | (37.7861224301769, -122.399185316932) | 12 | 2 | 9 | 28855 | 6 | ||
10779 | 49299 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Permit Number 46308 | 5981979.10455 | 2111331.16831 | 37.7762675789736 | -122.505878467652 | (37.7762675789736, -122.505878467652) | 11 | 6 | 2 | 55 | 26 | ||
92580 | 18371 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 636 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2016 12:00:00 AM | 4 | 2X2 | 6010355.57301 | 2105342.69627 | 37.7614539813358 | -122.40729371394 | (37.7614539813358, -122.40729371394) | 10 | 4 | 8 | 28859 | 19 | ||
193387 | 230379 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 636 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6010352.94216 | 2105328.73163 | 37.7614154903439 | -122.407301828531 | (37.7614154903439, -122.407301828531) | 10 | 4 | 8 | 28859 | 19 | |||
73597 | 226527 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 635 Potrero Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780912 | 6010443.26884 | 2105321.1926 | 37.7613998448343 | -122.406988893247 | (37.7613998448343, -122.406988893247) | 10 | 4 | 8 | 28859 | 19 | |
13828 | 144979 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 626 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | Width 3ft | 5990674.57486 | 2111094.54046 | 37.7761258404607 | -122.47578147193 | (37.7761258404607, -122.47578147193) | 11 | 6 | 2 | 54 | 26 | ||
75023 | 5475 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 601 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2008 12:00:00 AM | 3 | 4X4 | 6005004.3744 | 2104794.07494 | 37.759646650683 | -122.425762254445 | (37.759646650683, -122.425762254445) | 2 | 4 | 5 | 28859 | 19 | ||
80541 | 87452 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 601 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 4 | 3x3 | 6004976 | 2104871 | 37.7598562652774 | -122.425865863079 | (37.7598562652774, -122.425865863079) | 2 | 4 | 5 | 28862 | 19 | ||
164462 | 230384 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 601 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005003.81478 | 2104818.83763 | 37.7597146115626 | -122.425765952455 | (37.7597146115626, -122.425765952455) | 2 | 4 | 5 | 28859 | 19 | |||
103120 | 87853 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 599 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50764 | 6007684 | 2096571 | 37.7372189966792 | -122.415912430403 | (37.7372189966792, -122.415912430403) | 2 | 7 | 7 | 28859 | 2 | ||
26492 | 149925 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 595 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 778997 | 6015496.37916 | 2106243.76048 | 37.7642144863464 | -122.389576575905 | (37.7642144863464, -122.389576575905) | 14 | 3 | 8 | 28856 | 29 | |
117680 | 149924 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 595 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 778997 | 6015473.11557 | 2106243.07147 | 37.764211304535 | -122.389656990574 | (37.764211304535, -122.389656990574) | 14 | 3 | 8 | 28856 | 29 | |
137115 | 149926 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 595 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 778997 | 6015520.39678 | 2106244.91247 | 37.7642189811532 | -122.389493585568 | (37.7642189811532, -122.389493585568) | 14 | 3 | 8 | 28856 | 29 | |
19079 | 229898 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 590 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2020 12:00:00 AM | 3 | Width 2ft | Permit Number 787828 | 6001392.90328 | 2100882.89168 | 37.7487027395486 | -122.437972352563 | (37.7487027395486, -122.437972352563) | 2 | 4 | 5 | 28862 | 22 | |
179751 | 72994 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 590 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2011 12:00:00 AM | 3x3 | Permit Number 768023 | 6001377.74978743 | 2100887.76679336 | 37.748715263692 | -122.438025102274 | (37.748715263692, -122.438025102274) | 2 | 4 | 5 | 28862 | 22 | ||
50013 | 93300 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 589X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004575.9 | 2105667 | 37.7620192734995 | -122.427306317148 | (37.7620192734995, -122.427306317148) | 8 | 4 | 5 | 28862 | 3 | ||
161160 | 5458 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 589 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2009 12:00:00 AM | 90 | 3x3 | 6004996.57492 | 2104960.58209 | 37.7601033992601 | -122.425801080858 | (37.7601033992601, -122.425801080858) | 2 | 4 | 5 | 28859 | 19 | ||
24900 | 13061 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 583 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/01/2013 12:00:00 AM | 12 | 2X2 | 6009566.8887098 | 2120490.1657189 | 37.8030011583731 | -122.411091436508 | (37.8030011583731, -122.411091436508) | 3 | 1 | 10 | 308 | 23 | ||
150628 | 230385 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 581 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 9ft | 6004995.95318 | 2104998.86424 | 37.760208477866 | -122.425805956086 | (37.760208477866, -122.425805956086) | 2 | 4 | 5 | 28859 | 19 | |||
115105 | 81753 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 565 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52385 | 6013577.35874 | 2104447.02049 | 37.7591744400611 | -122.396088040728 | (37.7591744400611, -122.396088040728) | 10 | 3 | 8 | 28856 | 29 | |
106272 | 115435 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 563 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777504 | 6001919.8 | 2090201.1 | 37.7194029477524 | -122.435386355519 | (37.7194029477524, -122.435386355519) | 9 | 7 | 6 | 28861 | 5 | ||
110634 | 117395 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 544 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778554 | 5991215.4 | 2097083.4 | 37.7376862859043 | -122.47288871789 | (37.7376862859043, -122.47288871789) | 1 | 8 | 4 | 29491 | 40 | ||
123120 | 193407 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 541 Missouri St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6013570.69062 | 2104547.33874 | 37.7594495210946 | -122.396118132954 | (37.7594495210946, -122.396118132954) | 10 | 3 | 8 | 28856 | 29 | |||
153331 | 18361 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 530 Potrero Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/02/2015 11:39:00 AM | 3 | 3x3 | 6010330.8079075 | 2105828.5872592 | 37.7627867420622 | -122.407413622665 | (37.7627867420622, -122.407413622665) | 8 | 4 | 8 | 28859 | 19 | ||
37543 | 230386 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6008087.40778 | 2108285.62264 | 37.769407368778 | -122.415346724678 | (37.769407368778, -122.415346724678) | 8 | 4 | 7 | 28853 | 19 | |||
88872 | 230387 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 2 | : | Tree | Private 2 | 7 | Width 4ft | 6008108.07186 | 2108284.25114 | 37.7694047643365 | -122.415275151222 | (37.7694047643365, -122.415275151222) | 8 | 4 | 7 | 28853 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );