trees
305 rows where qSpecies_id = 49 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19244 | 128105 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 102 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:20:00 PM | 3 | Width 3ft | 6009886.88129 | 2121974.64206 | 37.8070951004301 | -122.410088954368 | (37.8070951004301, -122.410088954368) | 3 | 1 | 10 | 308 | 23 | ||
| 78395 | 132020 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1028 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782077 | 6007946.58222 | 2119968.79133 | 37.8014785977268 | -122.416661599167 | (37.8014785977268, -122.416661599167) | 5 | 1 | 10 | 308 | 32 | |
| 15725 | 128091 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 103 North Point St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:22:00 PM | 3 | Width 3ft | 6009972.30221 | 2121930.59441 | 37.8069789439766 | -122.409790224757 | (37.8069789439766, -122.409790224757) | 3 | 1 | 10 | 308 | 23 | ||
| 74860 | 39178 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1050 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | 2 | 4 | 7 | 28859 | 19 | |
| 133579 | 39177 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1050 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | 2 | 4 | 7 | 28859 | 19 | |
| 58149 | 216756 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 106 Harold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 01:41:00 PM | 3 | Width 3ft | 5996820.43291 | 2090638.75117 | 37.7203137127762 | -122.45304445763 | (37.7203137127762, -122.45304445763) | 9 | 8 | 6 | 28861 | 24 | ||
| 144366 | 123782 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1100 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992174.17281 | 2110703.76964 | 37.7751397174253 | -122.470565540203 | (37.7751397174253, -122.470565540203) | 11 | 6 | 2 | 54 | 11 | |||
| 154077 | 123781 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1100 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992148.27248 | 2110704.3151 | 37.7751397174227 | -122.47065517412 | (37.7751397174227, -122.47065517412) | 11 | 6 | 2 | 54 | 11 | |||
| 11787 | 149766 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1100 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015500.66268 | 2101160.05686 | 37.7502559568697 | -122.389206758507 | (37.7502559568697, -122.389206758507) | 10 | 3 | 8 | 28856 | 1 | |||
| 21662 | 81651 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1100@ 12th Ave Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | Permit Number 767881 | 5992197.33713 | 2110704.35062 | 37.7751426520596 | -122.470485452724 | (37.7751426520596, -122.470485452724) | 11 | 6 | 2 | 54 | 11 | ||
| 189520 | 18455 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1115 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/17/2015 12:46:00 PM | 3 | 3X3 | 6010591.72601 | 2102631.12863 | 37.7540218364648 | -122.406285897673 | (37.7540218364648, -122.406285897673) | 10 | 4 | 8 | 28859 | 19 | ||
| 129187 | 94327 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1132 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2010 12:00:00 AM | 3x3 | Permit Number 53627 | 5995101.4 | 2091446 | 37.7224315574184 | -122.459044970295 | (37.7224315574184, -122.459044970295) | 9 | 8 | 4 | 28861 | 24 | ||
| 55581 | 18458 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1136 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2006 12:00:00 AM | 3 | 4X4 | 6010508.18213 | 2102591.02821 | 37.7539070559711 | -122.406571988228 | (37.7539070559711, -122.406571988228) | 10 | 4 | 7 | 28859 | 19 | ||
| 16233 | 258379 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1139 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007502.57934 | 2093306.87278 | 37.728246213244 | -122.416308562579 | (37.728246213244, -122.416308562579) | 9 | 3 | 7 | 309 | 5 | |||
| 61010 | 230401 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1140 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010508.63913 | 2102581.4092 | 37.7538806698698 | -122.406569730021 | (37.7538806698698, -122.406569730021) | 10 | 4 | 7 | 28859 | 19 | |||
| 70355 | 27621 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1143 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010597.97715 | 2102516.55151 | 37.7537075827479 | -122.406256207463 | (37.7537075827479, -122.406256207463) | 10 | 4 | 8 | 28859 | 19 | ||
| 181160 | 18460 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1146 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2006 12:00:00 AM | 5 | 3X3 | 6010512.14548 | 2102543.99159 | 37.753778125574 | -122.406554967641 | (37.753778125574, -122.406554967641) | 10 | 4 | 7 | 28859 | 19 | ||
| 124156 | 216755 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 115 Harold Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/04/2017 01:38:00 PM | 3 | Width 3ft | 5996789.87728 | 2090654.02957 | 37.720353912481 | -122.453151180205 | (37.720353912481, -122.453151180205) | 9 | 8 | 6 | 28861 | 24 | ||
| 2615 | 193428 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1151 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014491.22334 | 2103857.32403 | 37.7576060646987 | -122.392886177259 | (37.7576060646987, -122.392886177259) | 10 | 3 | 8 | 28856 | 29 | |||
| 94176 | 193427 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1151 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014474.19771 | 2103855.91322 | 37.7576012452178 | -122.392944960565 | (37.7576012452178, -122.392944960565) | 10 | 3 | 8 | 28856 | 29 | |||
| 103794 | 193429 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1151 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014506.85634 | 2103858.18885 | 37.7576093076281 | -122.392832172067 | (37.7576093076281, -122.392832172067) | 10 | 3 | 8 | 28856 | 29 | |||
| 3712 | 171727 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1151 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6007391.28997 | 2093272.37114 | 37.7281452205055 | -122.416690852302 | (37.7281452205055, -122.416690852302) | 9 | 3 | 7 | 309 | 5 | ||
| 14623 | 171726 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1151 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6007369.69842 | 2093265.62582 | 37.7281254849051 | -122.416765017588 | (37.7281254849051, -122.416765017588) | 9 | 3 | 7 | 309 | 5 | ||
| 193859 | 84342 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1153 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50832 | 6005241.68146 | 2120923.06914 | 37.8039462987346 | -122.426089751557 | (37.8039462987346, -122.426089751557) | 13 | 9 | 1 | 28858 | 17 | |
| 194397 | 160660 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 118 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 0ft | 6001728.7088 | 2090784.69907 | 37.7209945256629 | -122.436088625395 | (37.7209945256629, -122.436088625395) | 9 | 7 | 6 | 28861 | 5 | ||
| 49718 | 93670 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 12 Robblee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 54071 | 6012650.87025 | 2095997.96753 | 37.7359235585191 | -122.398699370703 | (37.7359235585191, -122.398699370703) | 10 | 3 | 8 | 58 | 1 | |
| 21726 | 251776 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 120 Seville St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/13/2017 12:12:00 PM | 3 | Width 6ft | 6001722.65495 | 2087355.78866 | 37.7115791562393 | -122.435864336264 | (37.7115791562393, -122.435864336264) | 9 | 7 | 6 | 28861 | 5 | ||
| 32699 | 251774 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 120 Seville St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 10:14:00 AM | 3 | Width 6ft | 6001722.65495 | 2087355.78866 | 37.7115791562393 | -122.435864336264 | (37.7115791562393, -122.435864336264) | 9 | 7 | 6 | 28861 | 5 | ||
| 73067 | 180648 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 120 Seville St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 6ft | 6001751.26715 | 2087361.8508 | 37.7115974268507 | -122.435765878508 | (37.7115974268507, -122.435765878508) | 9 | 7 | 6 | 28861 | 5 | |||
| 148422 | 251775 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 120 Seville St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 10:17:00 AM | 3 | Width 6ft | 6001722.65495 | 2087355.78866 | 37.7115791562393 | -122.435864336264 | (37.7115791562393, -122.435864336264) | 9 | 7 | 6 | 28861 | 5 | ||
| 34144 | 252994 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 64671 | 253000 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 66243 | 252996 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 74568 | 252992 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 76061 | 252998 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 106536 | 252993 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 120857 | 252995 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 145867 | 252999 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 146871 | 253002 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 160987 | 253001 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 168745 | 252997 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 179340 | 253003 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 187255 | 54682 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1212 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2011 12:00:00 AM | Permit Number 767886 | 5993014.13432891 | 2107214.38358529 | 37.7656073275163 | -122.467406160634 | (37.7656073275163, -122.467406160634) | 11 | 8 | 11 | 56 | 12 | |||
| 192982 | 96632 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1212 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2011 12:00:00 AM | Permit Number 767886 | 5993035.2 | 2107183.3 | 37.7655231963247 | -122.467331039359 | (37.7655231963247, -122.467331039359) | 11 | 8 | 11 | 56 | 12 | |||
| 120990 | 18472 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1245 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/2015 07:25:00 AM | 3 | 3X3 | 6010625.30786 | 2102050.90235 | 37.7524305418599 | -122.406128887762 | (37.7524305418599, -122.406128887762) | 10 | 4 | 8 | 28859 | 19 | ||
| 29129 | 34304 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1248 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2016 12:00:00 AM | Permit Number 777415 | 6010821.325282 | 2102511.88817286 | 37.7537072691799 | -122.405483487001 | (37.7537072691799, -122.405483487001) | 10 | 4 | 8 | 28859 | 19 | ||
| 180822 | 18473 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1255 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/15/2013 12:00:00 AM | 3 | 3x3 | 6010628.31505 | 2101997.99365 | 37.7522854344497 | -122.406114761193 | (37.7522854344497, -122.406114761193) | 10 | 4 | 8 | 28859 | 19 | ||
| 149431 | 18474 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1260 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | 0 | Permit Number 773798 | 6010545.83787 | 2101980.95756 | 37.7522340435672 | -122.406398781502 | (37.7522340435672, -122.406398781502) | 10 | 4 | 7 | 28859 | 19 |
| 160673 | 18475 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1260 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2013 12:00:00 AM | 3 | 3x3 | 6010550.21333 | 2101942.07688 | 37.7521275305728 | -122.406380911075 | (37.7521275305728, -122.406380911075) | 10 | 4 | 7 | 28859 | 19 | ||
| 59736 | 18476 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1263 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/1997 12:00:00 AM | 18 | 3X3 | 6010629.32405 | 2101956.3743 | 37.7521712133345 | -122.406108340032 | (37.7521712133345, -122.406108340032) | 10 | 4 | 8 | 28859 | 19 | ||
| 187792 | 230414 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1295 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003749.35106 | 2095592.34196 | 37.7343098303216 | -122.429446540326 | (37.7343098303216, -122.429446540326) | 2 | 7 | 5 | 28861 | 25 | |||
| 164144 | 6738 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1300X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2016 12:00:00 AM | 1 | 3x3 | 6016982.91603 | 2097217.69187 | 37.7395130873532 | -122.383806518479 | (37.7395130873532, -122.383806518479) | 10 | 3 | 8 | 58 | 1 | ||
| 86035 | 230419 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003538.97469 | 2095464.77113 | 37.7339476364774 | -122.430164781185 | (37.7339476364774, -122.430164781185) | 2 | 7 | 5 | 28861 | 25 | |||
| 120530 | 230415 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003663.13723 | 2095538.7313 | 37.7341577459882 | -122.429740786804 | (37.7341577459882, -122.429740786804) | 2 | 7 | 5 | 28861 | 25 | |||
| 134923 | 230418 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003572.46167 | 2095485.43499 | 37.7340062713591 | -122.430050480067 | (37.7340062713591, -122.430050480067) | 2 | 7 | 5 | 28861 | 25 | |||
| 172302 | 230416 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003629.87373 | 2095518.06271 | 37.7340991110765 | -122.429854315422 | (37.7340991110765, -122.429854315422) | 2 | 7 | 5 | 28861 | 25 | |||
| 188741 | 230417 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003609.08364 | 2095506.47935 | 37.7340661284367 | -122.429925367268 | (37.7340661284367, -122.429925367268) | 2 | 7 | 5 | 28861 | 25 | |||
| 73814 | 99874 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 770597 | 6003616.3 | 2095455.7 | 37.7339271085192 | -122.429896797189 | (37.7339271085192, -122.429896797189) | 2 | 7 | 5 | 28861 | 25 |
| 6816 | 46977 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1310 Minnesota St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44998 | 6015323.66021 | 2102361.18474 | 37.7535441867291 | -122.389902741142 | (37.7535441867291, -122.389902741142) | 10 | 3 | 8 | 28856 | 29 | ||
| 126697 | 46981 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1310 Minnesota St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 1 | Permit Number 44998 | 6015319.9852 | 2102418.03165 | 37.7537000725041 | -122.389919420856 | (37.7537000725041, -122.389919420856) | 10 | 3 | 8 | 28856 | 29 | ||
| 175179 | 46980 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1310 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44998 | 6015320.43653 | 2102435.84562 | 37.7537490109239 | -122.389919104308 | (37.7537490109239, -122.389919104308) | 10 | 3 | 8 | 28856 | 29 | ||
| 139324 | 115273 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1314 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775588 | 5985278.7 | 2106245.9 | 37.7624985311794 | -122.49408954164 | (37.7624985311794, -122.49408954164) | 1 | 8 | 3 | 56 | 35 | |||
| 144083 | 88518 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 133 Kenwood Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51449 | 5994469.5 | 2093573.6 | 37.7282370866894 | -122.46138344933 | (37.7282370866894, -122.46138344933) | 9 | 8 | 4 | 59 | 40 | |||
| 19242 | 202025 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 7 | : | Tree | Private 2 | 3 | Width 3ft | 6013662.90177 | 2091312.27446 | 37.7231139336312 | -122.394872285044 | (37.7231139336312, -122.394872285044) | 10 | 3 | 8 | 58 | 1 | |||
| 22368 | 202024 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6013681.0358 | 2091298.8599 | 37.7230781082384 | -122.394808659817 | (37.7230781082384, -122.394808659817) | 10 | 3 | 8 | 58 | 1 | |||
| 39558 | 202027 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 9 | : | Tree | Private 2 | 3 | Width 3ft | 6013629.18756 | 2091337.20695 | 37.72318051856 | -122.39499057468 | (37.72318051856, -122.39499057468) | 10 | 3 | 8 | 58 | 1 | |||
| 61398 | 202023 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6013701.15269 | 2091283.23076 | 37.7230363122648 | -122.394738025239 | (37.7230363122648, -122.394738025239) | 10 | 3 | 8 | 58 | 1 | |||
| 70881 | 202020 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6013858.20959 | 2091166.1399 | 37.7227235352339 | -122.394186913506 | (37.7227235352339, -122.394186913506) | 10 | 3 | 8 | 58 | 1 | |||
| 102453 | 202021 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6013834.37055 | 2091185.24466 | 37.722774667999 | -122.394270657471 | (37.722774667999, -122.394270657471) | 10 | 3 | 8 | 58 | 1 | |||
| 139187 | 202028 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 10 | : | Tree | Private 2 | 3 | Width 3ft | 6013610.79633 | 2091351.15014 | 37.7232177810632 | -122.395055126189 | (37.7232177810632, -122.395055126189) | 10 | 3 | 8 | 58 | 1 | |||
| 145383 | 202026 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6013645.7458 | 2091325.32173 | 37.7231488048702 | -122.394932503635 | (37.7231488048702, -122.394932503635) | 10 | 3 | 8 | 58 | 1 | |||
| 179385 | 202022 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6013717.54523 | 2091271.83204 | 37.7230059250686 | -122.394680561262 | (37.7230059250686, -122.394680561262) | 10 | 3 | 8 | 58 | 1 | |||
| 7720 | 109781 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1335 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775057 | 5991737.5 | 2106325 | 37.7630915327801 | -122.471756892939 | (37.7630915327801, -122.471756892939) | 1 | 8 | 11 | 56 | 12 |
| 194377 | 171274 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 134 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2017 12:00:00 AM | 3 | Width 3ft | 6004391.75762 | 2092740.75057 | 37.726516347746 | -122.427022498699 | (37.726516347746, -122.427022498699) | 9 | 7 | 6 | 28861 | 5 | ||
| 146568 | 202019 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1350 Fitzgerald Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013890.08621 | 2091145.17982 | 37.7226677548035 | -122.394075255469 | (37.7226677548035, -122.394075255469) | 10 | 3 | 8 | 58 | 1 | |||
| 109946 | 64806 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1375 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2012 12:00:00 AM | 22 | 5x5 | Permit Number 768180 | 6003293.30156995 | 2100236.74825313 | 37.747036468941 | -122.43135467592 | (37.747036468941, -122.43135467592) | 2 | 7 | 5 | 63 | 22 |
| 47719 | 108874 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 138 Cole St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781829 | 5997812.45112 | 2110130.24113 | 37.773889369558 | -122.451020208331 | (37.773889369558, -122.451020208331) | 15 | 5 | 11 | 29492 | 16 | |
| 83854 | 193416 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1425 Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6015128.54714 | 2101843.94886 | 37.7521131441083 | -122.390541350608 | (37.7521131441083, -122.390541350608) | 10 | 3 | 8 | 28856 | 1 | |||
| 167252 | 193415 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1425 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6015129.4675 | 2101818.79874 | 37.7520441382513 | -122.390536410622 | (37.7520441382513, -122.390536410622) | 10 | 3 | 8 | 28856 | 1 | |||
| 175505 | 193417 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1425 Indiana St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6015126.28801 | 2101884.04231 | 37.7522231069197 | -122.390551964402 | (37.7522231069197, -122.390551964402) | 10 | 3 | 8 | 28856 | 1 | |||
| 38708 | 230420 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 143 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005428.86473 | 2102882.34915 | 37.7544214771723 | -122.424158193041 | (37.7544214771723, -122.424158193041) | 2 | 4 | 5 | 28859 | 19 | |||
| 81653 | 109448 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 143 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770854 | 6005451.2 | 2102876.8 | 37.7544075015735 | -122.424080557223 | (37.7544075015735, -122.424080557223) | 2 | 4 | 5 | 28859 | 19 |
| 148083 | 104967 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 143-147 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | Permit Number 770854 | 6005451.2 | 2102876.8 | 37.7544075015735 | -122.424080557223 | (37.7544075015735, -122.424080557223) | 2 | 4 | 5 | 28859 | 19 | ||
| 42298 | 108621 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 150-198X Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 774592 | 6005405 | 2109611 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | 7 | 9 | 11 | 28852 | 10 | |
| 94441 | 89392 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1532 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 11:13:00 AM | 3 | 3x3 | 5993876.23543 | 2112127.34483 | 37.779146745751 | -122.464781174904 | (37.779146745751, -122.464781174904) | 11 | 6 | 2 | 54 | 11 | ||
| 51035 | 89723 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1535 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 11:16:00 AM | 3 | 3x3 | 5993886.8268 | 2112071.32228 | 37.7789935335335 | -122.464740465973 | (37.7789935335335, -122.464740465973) | 11 | 6 | 2 | 54 | 11 | ||
| 37230 | 208859 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 157 Thrift St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995398.10832 | 2089609.60714 | 37.7174063107347 | -122.457886500157 | (37.7174063107347, -122.457886500157) | 9 | 8 | 6 | 28861 | 24 | |||
| 139355 | 114987 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 157 Thrift St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | Permit Number 775985 | 5995400.7 | 2089591.3 | 37.7173561925503 | -122.457876217939 | (37.7173561925503, -122.457876217939) | 9 | 8 | 6 | 28861 | 24 | |||
| 666 | 49628 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1591 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2003 12:00:00 AM | 3 | Permit Number 46483 | 6007746.40275 | 2109230.16933 | 37.7719816997133 | -122.416593168865 | (37.7719816997133, -122.416593168865) | 8 | 2 | 9 | 28853 | 19 | |
| 7352 | 49629 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1591 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2003 12:00:00 AM | 3 | Permit Number 46483 | 6007726.58715 | 2109200.55407 | 37.7718992687552 | -122.416659614369 | (37.7718992687552, -122.416659614369) | 8 | 2 | 9 | 28853 | 19 | |
| 162230 | 17176 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1601 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/1999 12:00:00 AM | 3 | 4X4 | 6004921.1693652 | 2114736.5058392 | 37.7869414485048 | -122.426758067349 | (37.7869414485048, -122.426758067349) | 13 | 9 | 11 | 28858 | 27 | ||
| 90449 | 115264 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1634 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775141 | 5989384.4 | 2104210.4 | 37.7571489820097 | -122.479740639367 | (37.7571489820097, -122.479740639367) | 1 | 8 | 3 | 56 | 35 | |||
| 115784 | 115265 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1634 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775141 | 5989384.4 | 2104210.4 | 37.7571489820097 | -122.479740639367 | (37.7571489820097, -122.479740639367) | 1 | 8 | 3 | 56 | 35 | |||
| 134063 | 62821 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 165 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2010 12:00:00 AM | 3x3 | Permit Number 53769 | 6004060.48554268 | 2101568.78877881 | 37.7507373914484 | -122.42879676445 | (37.7507373914484, -122.42879676445) | 2 | 4 | 5 | 28862 | 22 | ||
| 6939 | 177453 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1651 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001481.52618 | 2094146.78927 | 37.7302120154671 | -122.437183661494 | (37.7302120154671, -122.437183661494) | 9 | 7 | 6 | 28861 | 25 | |||
| 61091 | 177455 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1651 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001518.96973 | 2094154.72477 | 37.7302359329302 | -122.437054782357 | (37.7302359329302, -122.437054782357) | 9 | 7 | 6 | 28861 | 25 | |||
| 89910 | 177456 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1651 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001539.4565 | 2094159.89194 | 37.7302512852618 | -122.436984326781 | (37.7302512852618, -122.436984326781) | 9 | 7 | 6 | 28861 | 25 | |||
| 120121 | 177457 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1651 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001558.28444 | 2094165.30046 | 37.7302672059603 | -122.436919623235 | (37.7302672059603, -122.436919623235) | 9 | 7 | 6 | 28861 | 25 | |||
| 124024 | 177454 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1651 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001501.63972 | 2094151.35591 | 37.7302256977428 | -122.43711445329 | (37.7302256977428, -122.43711445329) | 9 | 7 | 6 | 28861 | 25 | |||
| 52022 | 131012 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1661 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006845.95984 | 2116366.0433 | 37.7915243922801 | -122.420214413174 | (37.7915243922801, -122.420214413174) | 13 | 9 | 10 | 28858 | 21 |
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) );