trees
399 rows where qSpecies_id = 2 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 262167 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 420 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/16/2020 12:00:00 AM | 3 | ||||||||||||
| 6 | 262166 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 420 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/16/2020 12:00:00 AM | 3 | ||||||||||||
| 19 | 262168 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 420 Alpha St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/16/2020 12:00:00 AM | 3 | ||||||||||||
| 4376 | 259271 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1721x Taylor St | 5 | Side Yard : Yard | Tree | DPW 1 | Private | 05/25/2019 12:00:00 AM | 3 | ||||||||||||
| 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 | ||||||||||||
| 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 | |||||||||||
| 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 | ||||||||||||
| 13136 | 255218 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 101 Goettingen St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 15650 | 261311 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3368 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2019 12:00:00 AM | 3 | 3x3 | 5998140.71226 | 2116180.16914 | 37.7905196763565 | -122.450320900484 | (37.7905196763565, -122.450320900484) | 13 | 6 | 1 | 54 | 31 | ||
| 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 | ||
| 56547 | 124911 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3234 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 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) | 11 | 6 | 1 | 54 | 30 | |
| 60588 | 125087 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2498X Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 779691 | 6001734 | 2116823 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | 13 | 6 | 1 | 29490 | 27 | |
| 63660 | 124910 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3234 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780160 | 5998760.11738 | 2116596.00833 | 37.7916968894517 | -122.4482077616 | (37.7916968894517, -122.4482077616) | 11 | 6 | 1 | 54 | 30 | |
| 78957 | 51994 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3858 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1977 12:00:00 AM | Permit Number 769135 | 5995734.40748516 | 2115851.40858603 | 37.78947898308 | -122.458622703992 | (37.78947898308, -122.458622703992) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | ||
| 102280 | 131010 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3099 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001935.38679 | 2118702.33437 | 37.7976613236686 | -122.437372261923 | (37.7976613236686, -122.437372261923) | 13 | 9 | 1 | 57 | 17 | |||
| 103060 | 13103 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1516 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2008 12:00:00 AM | 3 | 3x3 | 6005111 | 2119918 | 37.8011792509168 | -122.426470375667 | (37.8011792509168, -122.426470375667) | 13 | 9 | 1 | 57 | 17 | ||
| 111986 | 131011 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1771 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002300.20603 | 2120865.81933 | 37.8036224187107 | -122.436264801676 | (37.8036224187107, -122.436264801676) | 13 | 9 | 1 | 57 | 17 | |||
| 128897 | 87882 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1771 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50853 | 6002283.00879 | 2120864.77597 | 37.8036185768076 | -122.436324238766 | (37.8036185768076, -122.436324238766) | 13 | 9 | 1 | 57 | 17 | |
| 164641 | 125088 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2498X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 779691 | 6001734 | 2116823 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | 13 | 6 | 1 | 29490 | 27 | |
| 185594 | 135722 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2498X Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 779691 | 6001734 | 2116823 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | 13 | 6 | 1 | 29490 | 27 | |
| 3024 | 103847 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1529 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006640.1 | 2116184.7 | 37.7910148670423 | -122.420913805894 | (37.7910148670423, -122.420913805894) | 13 | 9 | 10 | 28858 | 21 | ||
| 17740 | 96032 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1314 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767671 | 6007241 | 2115796 | 37.7899814452739 | -122.418807131377 | (37.7899814452739, -122.418807131377) | 13 | 9 | 10 | 28858 | 21 | |
| 20501 | 103817 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1100 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006925.9 | 2114751.5 | 37.7870957589339 | -122.41982320605 | (37.7870957589339, -122.41982320605) | 13 | 9 | 10 | 28858 | 21 | ||
| 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 | ||
| 44915 | 103874 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1331 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006716.3 | 2115545.2 | 37.7892632533111 | -122.42060474069 | (37.7892632533111, -122.42060474069) | 13 | 9 | 10 | 28858 | 21 | ||
| 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 | |
| 57632 | 103843 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1541 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006635.7 | 2116216.3 | 37.7911013847793 | -122.420931274285 | (37.7911013847793, -122.420931274285) | 13 | 9 | 10 | 28858 | 21 | ||
| 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 | |||
| 82825 | 103844 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1541 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006635.7 | 2116216.3 | 37.7911013847793 | -122.420931274285 | (37.7911013847793, -122.420931274285) | 13 | 9 | 10 | 28858 | 21 | ||
| 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 | |||
| 89928 | 103848 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1524 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006765.8 | 2116184.9 | 37.7910225007002 | -122.420478902042 | (37.7910225007002, -122.420478902042) | 13 | 9 | 10 | 28858 | 21 | ||
| 93248 | 103851 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1524 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006765.8 | 2116184.9 | 37.7910225007002 | -122.420478902042 | (37.7910225007002, -122.420478902042) | 13 | 9 | 10 | 28858 | 21 | ||
| 97816 | 103845 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1540 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006747 | 2116248.1 | 37.7911949727431 | -122.420548437624 | (37.7911949727431, -122.420548437624) | 13 | 9 | 10 | 28858 | 21 | ||
| 100917 | 103792 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1214 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006878.4 | 2115091.6 | 37.7880269138329 | -122.420011690177 | (37.7880269138329, -122.420011690177) | 13 | 9 | 10 | 28858 | 21 | ||
| 105898 | 103793 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1214 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006878.4 | 2115091.6 | 37.7880269138329 | -122.420011690177 | (37.7880269138329, -122.420011690177) | 13 | 9 | 10 | 28858 | 21 | ||
| 113636 | 103846 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1540 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006747 | 2116248.1 | 37.7911949727431 | -122.420548437624 | (37.7911949727431, -122.420548437624) | 13 | 9 | 10 | 28858 | 21 | ||
| 138526 | 103794 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1214 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006878.4 | 2115091.6 | 37.7880269138329 | -122.420011690177 | (37.7880269138329, -122.420011690177) | 13 | 9 | 10 | 28858 | 21 | ||
| 146908 | 103849 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1524 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006765.8 | 2116184.9 | 37.7910225007002 | -122.420478902042 | (37.7910225007002, -122.420478902042) | 13 | 9 | 10 | 28858 | 21 | ||
| 153966 | 98720 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1500 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2012 12:00:00 AM | 4x4 | Permit Number 768751 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | ||
| 158563 | 103862 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1436 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006766.2 | 2115894.4 | 37.7902248822442 | -122.420456889097 | (37.7902248822442, -122.420456889097) | 13 | 9 | 10 | 28858 | 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 | |
| 167714 | 98719 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1500 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2012 12:00:00 AM | Permit Number 768751 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||
| 172825 | 103850 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1524 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006765.8 | 2116184.9 | 37.7910225007002 | -122.420478902042 | (37.7910225007002, -122.420478902042) | 13 | 9 | 10 | 28858 | 21 | ||
| 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 | |||
| 188352 | 103791 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1214 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006878.4 | 2115091.6 | 37.7880269138329 | -122.420011690177 | (37.7880269138329, -122.420011690177) | 13 | 9 | 10 | 28858 | 21 | ||
| 21886 | 12447 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1989X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2004 12:00:00 AM | 4 | 3x3 | 6004432.6263962 | 2115327.1853144 | 37.7885356724235 | -122.428490433403 | (37.7885356724235, -122.428490433403) | 13 | 9 | 11 | 28858 | 27 | ||
| 30278 | 10232 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 11 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/30/2002 12:00:00 AM | 8 | 6005984.55063 | 2109644.68395 | 37.7730206127534 | -122.422717019597 | (37.7730206127534, -122.422717019597) | 7 | 9 | 11 | 28852 | 10 | |||
| 37211 | 87647 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1989X PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2008 12:00:00 AM | 3 | 3x3 | 6004432 | 2115332 | 37.7885488568913 | -122.428492943957 | (37.7885488568913, -122.428492943957) | 13 | 9 | 11 | 28858 | 27 | ||
| 41844 | 108873 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 137 Cole St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773403 | 5997771.92218 | 2110131.23662 | 37.7738897825389 | -122.451160475717 | (37.7738897825389, -122.451160475717) | 15 | 5 | 11 | 29492 | 16 | |
| 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 | ||
| 70138 | 88771 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 461 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775199 | 6000624 | 2110522 | 37.7751256013752 | -122.441322740074 | (37.7751256013752, -122.441322740074) | 15 | 5 | 11 | 29492 | 16 | |
| 144860 | 10236 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 33 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/30/2002 12:00:00 AM | 8 | 4X4 | 6005944.57875 | 2109639.18298 | 37.7730032531225 | -122.422854896447 | (37.7730032531225, -122.422854896447) | 7 | 9 | 11 | 28852 | 10 | ||
| 159858 | 17177 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1601 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2007 12:00:00 AM | 3 | 4X4 | 6004921.1693652 | 2114736.5058392 | 37.7869414485048 | -122.426758067349 | (37.7869414485048, -122.426758067349) | 13 | 9 | 11 | 28858 | 27 | ||
| 175044 | 230378 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 11 Haight St | 3 | : | Tree | Private 2 | 5 | Width 4ft | 6006027.69558 | 2109650.1201 | 37.7730379732539 | -122.422568162015 | (37.7730379732539, -122.422568162015) | 7 | 9 | 11 | 28852 | 10 | |||
| 180205 | 230377 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 11 Haight St | 2 | : | Tree | Private 2 | 6 | Width 4ft | 6006012.13878 | 2109648.33208 | 37.7730321861234 | -122.422621847921 | (37.7730321861234, -122.422621847921) | 7 | 9 | 11 | 28852 | 10 | |||
| 189245 | 52671 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1234@ LINCOLN 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53911 | 5993637.83557736 | 2107090.14039952 | 37.7653021756316 | -122.465239907967 | (37.7653021756316, -122.465239907967) | 11 | 8 | 11 | 56 | 12 | |
| 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 | ||
| 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 | ||
| 12272 | 117721 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 471 40th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/25/2020 11:12:00 AM | 3 | Width 3ft | 5983437.41308 | 2112653.95912 | 37.779985305245 | -122.500931708584 | (37.779985305245, -122.500931708584) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | ||
| 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 | ||
| 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 |
| 163472 | 109142 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 342 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773572 | 5986886.5 | 2113633.7 | 37.7828773022088 | -122.489071978745 | (37.7828773022088, -122.489071978745) | 11 | 6 | 2 | 55 | 26 |
| 190320 | 72375 | Private 9 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 4299X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1996 12:00:00 AM | 3x3 | Permit Number 773790 | 5990099.63678033 | 2109979.56687008 | 37.773031079694 | -122.477688796337 | (37.773031079694, -122.477688796337) | 11 | 6 | 2 | 55 | 26 | |
| 4497 | 264869 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1655 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | 4x6 | 5986201 | 2103975 | 37.7563171904504 | -122.490732590523 | (37.7563171904504, -122.490732590523) | 1 | 8 | 3 | 56 | 35 | ||
| 4809 | 181872 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2330 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/24/2020 12:00:00 AM | 3 | 4x6 | 5985803.3054 | 2099347.2154 | 37.7435873132981 | -122.491767267489 | (37.7435873132981, -122.491767267489) | 1 | 8 | 3 | 29491 | 35 | ||
| 9751 | 261814 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1622 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x4 | 5985349 | 2104146 | 37.7567369022815 | -122.493691659097 | (37.7567369022815, -122.493691659097) | 1 | 8 | 3 | 56 | 35 | ||
| 16126 | 264873 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2330 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/24/2020 12:00:00 AM | 3 | 4x6 | 5985803.3054 | 2099347.2154 | 37.7435873132981 | -122.491767267489 | (37.7435873132981, -122.491767267489) | 1 | 8 | 3 | 29491 | 35 | ||
| 16185 | 182600 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1959 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 4x4 | 5985980.7032 | 2101896.5884 | 37.7505975691069 | -122.4913414752 | (37.7505975691069, -122.4913414752) | 1 | 8 | 3 | 29491 | 35 | ||
| 22249 | 109286 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1438 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771727 | 5982826.9 | 2105321.3 | 37.75981607235 | -122.502500845014 | (37.75981607235, -122.502500845014) | 1 | 8 | 3 | 56 | 35 |
| 83634 | 109258 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1290 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773444 | 5982171 | 2106334.4 | 37.7625591927486 | -122.504844313965 | (37.7625591927486, -122.504844313965) | 1 | 8 | 3 | 56 | 35 |
| 128665 | 95423 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2187 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767291 | 5989736.1 | 2100494 | 37.7469651560486 | -122.478252612879 | (37.7469651560486, -122.478252612879) | 1 | 8 | 3 | 29491 | 35 | |
| 186849 | 88363 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2294 31st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52532 | 5986746.4 | 2099664.8 | 37.7445143908471 | -122.48852965845 | (37.7445143908471, -122.48852965845) | 1 | 8 | 3 | 29491 | 35 | |||
| 847 | 92588 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 1822 | 51694 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1205 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | Permit Number 47971 | 5995825.9822194 | 2092036.11859211 | 37.7240935095077 | -122.456582925823 | (37.7240935095077, -122.456582925823) | 9 | 8 | 4 | 28861 | 40 | |||
| 21135 | 102590 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1205 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47971 | 5995820 | 2092088.8 | 37.724237816628 | -122.4566074133 | (37.724237816628, -122.4566074133) | 9 | 7 | 4 | 28861 | 40 | ||||
| 59794 | 92589 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 69525 | 92582 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 72989 | 92584 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 101899 | 100432 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 200X Stonecrest Dr | 2 | Front Yard : Yard | Tree | Private 2 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | |||||
| 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 | ||
| 115835 | 92587 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 122719 | 86795 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 129134 | 92585 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 132976 | 92580 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 137187 | 92586 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 147278 | 100431 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 200X Stonecrest Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | |||||
| 156287 | 117298 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1590 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778522 | 5993741.6 | 2104678.7 | 37.7586869726954 | -122.464705888807 | (37.7586869726954, -122.464705888807) | 1 | 8 | 4 | 56 | 12 | ||
| 163939 | 92583 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 174018 | 114091 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1717 15th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2015 12:00:00 AM | Permit Number 775992 | 5991423.2 | 2103752.9 | 37.7560110367904 | -122.472656396727 | (37.7560110367904, -122.472656396727) | 1 | 8 | 4 | 56 | 12 | ||||
| 174678 | 86796 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 192324 | 92581 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Wawona St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625 | 2097033 | 37.7375716044552 | -122.471468876287 | (37.7375716044552, -122.471468876287) | 1 | 8 | 4 | 29491 | 40 | ||
| 1519 | 154406 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1270 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782729 | 6004450.91353 | 2101490.17776 | 37.7505436337949 | -122.427441030576 | (37.7505436337949, -122.427441030576) | 2 | 4 | 5 | 28862 | 22 | |
| 7379 | 93250 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1050 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004388 | 2102776 | 37.7540706426955 | -122.42775019598 | (37.7540706426955, -122.42775019598) | 2 | 4 | 5 | 28862 | 22 | ||
| 8200 | 3929 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 100X Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/18/2014 12:00:00 AM | 3 | 4x4 | 6002188.32938 | 2107609.30269 | 37.7672170447484 | -122.435702952048 | (37.7672170447484, -122.435702952048) | 15 | 5 | 5 | 28862 | 3 | ||
| 9447 | 91424 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2112 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2008 12:00:00 AM | 3x3 | Permit Number 52102 | 6003571 | 2107157 | 37.7660535712373 | -122.430888215554 | (37.7660535712373, -122.430888215554) | 7 | 4 | 5 | 28862 | 3 | ||
| 13904 | 50261 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 31 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2002 12:00:00 AM | Permit Number 46967 | 6005053.32023027 | 2096760.11488265 | 37.737590014135 | -122.425021354004 | (37.737590014135, -122.425021354004) | 2 | 7 | 5 | 28859 | 2 |
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) );