trees
399 rows where qSpecies_id = 2 sorted by YCoord
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 | ||||||||||||||
179720 | 87673 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2610 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2006 12:00:00 AM | 3 | 3x3 | 6010582.741346 | 2086196.470906 | 37.708895230886 | -122.405159783861 | (37.708895230886, -122.405159783861) | 9 | 7 | 8 | 309 | 39 | ||
11 | 264841 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1601 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007819 | 2087884 | 37.7133739406818 | -122.41483104388 | (37.7133739406818, -122.41483104388) | 9 | 7 | 8 | 309 | 39 | |||
21 | 264839 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1601 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007819 | 2087884 | 37.7133739406818 | -122.41483104388 | (37.7133739406818, -122.41483104388) | 9 | 7 | 8 | 309 | 39 | |||
140650 | 26918 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2000X Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2010 12:00:00 AM | 3 | 3X3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | ||
35474 | 94638 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2000X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2010 12:00:00 AM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.71535722204 | -122.399324379639 | (37.71535722204, -122.399324379639) | 10 | 7 | 8 | 309 | 39 | ||
95100 | 112744 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 235 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2015 12:00:00 AM | Permit Number 774127 | 5993719.1 | 2088769.4 | 37.7150026970857 | -122.463629063261 | (37.7150026970857, -122.463629063261) | 9 | 8 | 6 | 64 | 24 | ||
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 | ||
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 | ||
191699 | 9298 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 135X Mansell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1992 12:00:00 AM | 3 | 3X3 | 6011497.3933158 | 2090592.5284866 | 37.7210170109869 | -122.40230748066 | (37.7210170109869, -122.40230748066) | 10 | 7 | 8 | 309 | 28 | ||
125882 | 9308 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 240X Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2007 12:00:00 AM | 3 | 3X100 | 6011154.1519898 | 2090628.8663314 | 37.7210976210121 | -122.403496526224 | (37.7210976210121, -122.403496526224) | 10 | 3 | 7 | 309 | 28 | ||
173603 | 9306 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 240X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2007 12:00:00 AM | 3 | 3X100 | 6011154.1519898 | 2090628.8663314 | 37.7210976210121 | -122.403496526224 | (37.7210976210121, -122.403496526224) | 10 | 3 | 7 | 309 | 28 | ||
64762 | 13340 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 230 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2007 12:00:00 AM | 3 | 3X24 | 6011187.2509688 | 2090638.9738565 | 37.721127222942 | -122.403382822785 | (37.721127222942, -122.403382822785) | 10 | 3 | 7 | 309 | 28 | ||
171372 | 30135 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 220X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2007 12:00:00 AM | 3 | 3X30 | 6011221.783784 | 2090644.291322 | 37.7211437523189 | -122.403263826082 | (37.7211437523189, -122.403263826082) | 10 | 3 | 7 | 309 | 28 | ||
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 | |||
109636 | 95738 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 445 Edinburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767484 | 6003120.3 | 2091142.7 | 37.7220564786865 | -122.431303852024 | (37.7220564786865, -122.431303852024) | 9 | 7 | 6 | 28861 | 5 | |
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 | ||||
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 | ||
24373 | 177452 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 404 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003440.2849 | 2091219.73942 | 37.7222861409715 | -122.430203237092 | (37.7222861409715, -122.430203237092) | 9 | 7 | 6 | 28861 | 5 | |||
177568 | 108791 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 323 Edinburgh St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774649 | 6003546.88289 | 2091819.58764 | 37.7239392283561 | -122.429877518865 | (37.7239392283561, -122.429877518865) | 9 | 7 | 6 | 28861 | 5 | |
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 | ||||
132768 | 95660 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 431 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767422 | 6010656.7 | 2092697.9 | 37.7267509601998 | -122.40536171554 | (37.7267509601998, -122.40536171554) | 10 | 3 | 7 | 309 | 28 | |
61373 | 88349 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 100 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004690.8 | 2092754.8 | 37.7265718296959 | -122.425989720183 | (37.7265718296959, -122.425989720183) | 9 | 7 | 6 | 28861 | 5 | ||
72199 | 88350 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 100 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004690.8 | 2092754.8 | 37.7265718296959 | -122.425989720183 | (37.7265718296959, -122.425989720183) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
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 | ||
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 | |||||
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 | |||||
88606 | 85598 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1101 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6017523.881587 | 2093256.051678 | 37.7286650962772 | -122.381660625783 | (37.7286650962772, -122.381660625783) | 10 | 3 | 8 | 58 | 1 | ||
168373 | 85597 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1101 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 6 | 3x3 | 6017523.881587 | 2093256.051678 | 37.7286650962772 | -122.381660625783 | (37.7286650962772, -122.381660625783) | 10 | 3 | 8 | 58 | 1 | ||
3150 | 85599 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1115 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2014 12:00:00 AM | 3 | 3x3 | 6017434.0078 | 2093308.576 | 37.7288043549368 | -122.381974980078 | (37.7288043549368, -122.381974980078) | 10 | 3 | 8 | 58 | 1 | ||
14858 | 171814 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 100 Dartmouth St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6008473.26376 | 2093533.30473 | 37.7289224829841 | -122.412968858728 | (37.7289224829841, -122.412968858728) | 9 | 3 | 7 | 309 | 28 | ||
15395 | 262455 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1788 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000684 | 2093777 | 37.7291512919898 | -122.43991430419 | (37.7291512919898, -122.43991430419) | 9 | 7 | 6 | 28861 | 25 | ||
38684 | 85604 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1261 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016687.610646 | 2093879.449725 | 37.7303306134548 | -122.384595098105 | (37.7303306134548, -122.384595098105) | 10 | 3 | 8 | 58 | 1 | ||
129033 | 85569 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1260 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016711.517151 | 2093911.519633 | 37.7304199931233 | -122.384514682139 | (37.7304199931233, -122.384514682139) | 10 | 3 | 8 | 58 | 1 | ||
177837 | 85570 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1260 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016711.517151 | 2093911.519633 | 37.7304199931233 | -122.384514682139 | (37.7304199931233, -122.384514682139) | 10 | 3 | 8 | 58 | 1 | ||
147657 | 85568 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1264 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016691.22613 | 2093926.645569 | 37.7304604038472 | -122.384585884949 | (37.7304604038472, -122.384585884949) | 10 | 3 | 8 | 58 | 1 | ||
89302 | 85567 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1274 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016640.49857 | 2093964.460415 | 37.7305614304838 | -122.384763892339 | (37.7305614304838, -122.384763892339) | 10 | 3 | 8 | 58 | 1 | ||
185603 | 85565 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1276 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016630.35305 | 2093972.02339 | 37.7305816357941 | -122.384799493903 | (37.7305816357941, -122.384799493903) | 10 | 3 | 8 | 58 | 1 | ||
60208 | 108834 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 163 Ney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774662 | 6004445.49273 | 2094062.11561 | 37.7301475609408 | -122.426930805706 | (37.7301475609408, -122.426930805706) | 9 | 7 | 6 | 28861 | 5 | |
3345 | 258176 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 255 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010040.21914 | 2094084.80619 | 37.7305246249549 | -122.4075906244 | (37.7305246249549, -122.4075906244) | 10 | 3 | 7 | 309 | 28 | ||
7155 | 258178 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 255 Silliman St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010040.21914 | 2094084.80619 | 37.7305246249549 | -122.4075906244 | (37.7305246249549, -122.4075906244) | 10 | 3 | 7 | 309 | 28 | ||
19452 | 258177 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 255 Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010040.21914 | 2094084.80619 | 37.7305246249549 | -122.4075906244 | (37.7305246249549, -122.4075906244) | 10 | 3 | 7 | 309 | 28 | ||
176520 | 85577 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1370 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016127.199744 | 2094347.098919 | 37.73158367729 | -122.386565129485 | (37.73158367729, -122.386565129485) | 10 | 3 | 8 | 58 | 1 | ||
160902 | 85607 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1397 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015969.720597 | 2094414.600713 | 37.7317603044799 | -122.387114277117 | (37.7317603044799, -122.387114277117) | 10 | 3 | 8 | 58 | 1 | ||
86673 | 85578 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1388 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016034.726363 | 2094416.033185 | 37.7317678372886 | -122.386889636739 | (37.7317678372886, -122.386889636739) | 10 | 3 | 8 | 58 | 1 | ||
168926 | 85580 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1458 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015655.098903 | 2094699.254039 | 37.7325244779387 | -122.38822185678 | (37.7325244779387, -122.38822185678) | 10 | 3 | 8 | 58 | 1 | ||
177200 | 94896 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1375 Keith St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53955 | 6016208.4 | 2094705 | 37.7325708970962 | -122.386309345138 | (37.7325708970962, -122.386309345138) | 10 | 3 | 8 | 58 | 1 | ||
127073 | 85583 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1500 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015418.292964 | 2094875.921588 | 37.7329964475839 | -122.389052889382 | (37.7329964475839, -122.389052889382) | 10 | 3 | 8 | 58 | 1 | ||
69485 | 85584 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1512 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015354.897796 | 2094923.102787 | 37.7331224832721 | -122.389275358402 | (37.7331224832721, -122.389275358402) | 10 | 3 | 8 | 58 | 1 | ||
25377 | 85589 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1566 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015069.619532 | 2095135.418187 | 37.7336896386511 | -122.390276478357 | (37.7336896386511, -122.390276478357) | 10 | 3 | 8 | 58 | 1 | ||
51058 | 96159 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767792 | 6003680 | 2095311.9 | 37.7335358734479 | -122.429666314328 | (37.7335358734479, -122.429666314328) | 2 | 7 | 5 | 28861 | 25 | |
114564 | 96160 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2 Milton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767792 | 6003680 | 2095311.9 | 37.7335358734479 | -122.429666314328 | (37.7335358734479, -122.429666314328) | 2 | 7 | 5 | 28861 | 25 | |
181472 | 15056 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1441 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2012 12:00:00 AM | 3 | 4x4 | 6015002 | 2095363 | 37.7343107811298 | -122.390526157796 | (37.7343107811298, -122.390526157796) | 10 | 3 | 8 | 58 | 1 | ||
119339 | 96670 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1425 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2012 12:00:00 AM | 4 | 4x4 | 6015007.7446 | 2095379.2401 | 37.7343556918302 | -122.390507431087 | (37.7343556918302, -122.390507431087) | 10 | 3 | 8 | 58 | 1 | ||
12577 | 17385 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1649 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1996 12:00:00 AM | 12 | 6x5 | 6014583.05525 | 2095408.96107 | 37.7344137306531 | -122.391977809509 | (37.7344137306531, -122.391977809509) | 10 | 3 | 8 | 58 | 1 | ||
106231 | 96158 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767791 | 6003728 | 2095595 | 37.7343159198258 | -122.429520547314 | (37.7343159198258, -122.429520547314) | 2 | 7 | 5 | 28861 | 25 | |
88803 | 94689 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 218 Roanoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53815 | 6003547 | 2096007 | 37.7354369283878 | -122.430175705062 | (37.7354369283878, -122.430175705062) | 2 | 7 | 5 | 63 | 7 | |
77343 | 17426 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1869 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/2015 01:06:00 PM | 3 | 3X3 | 6013447.63917 | 2096284.81189 | 37.736755533926 | -122.395964698714 | (37.736755533926, -122.395964698714) | 10 | 3 | 8 | 58 | 1 | ||
154650 | 11953 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1436 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 6 | 3X4 | 6015854.7568499 | 2096315.1604747 | 37.7369724919298 | -122.387644284768 | (37.7369724919298, -122.387644284768) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
88054 | 29774 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1100X Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/03/2017 12:44:00 PM | 3 | 3x3 | 6018183.3236 | 2096672.8034 | 37.7380832156692 | -122.379618142779 | (37.7380832156692, -122.379618142779) | 10 | 3 | 8 | 58 | 1 | ||
139812 | 114762 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 27X Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2015 12:00:00 AM | Permit Number 46967 | 6005096.96871 | 2096699.60241 | 37.7374263260205 | -122.424866136467 | (37.7374263260205, -122.424866136467) | 2 | 7 | 5 | 28859 | 2 | |||
84232 | 6725 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1200X Fairfax Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2008 12:00:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
151153 | 6746 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1300X Fairfax Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
63030 | 251164 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2017 01:46:00 PM | 3 | 3x3 | 6017471 | 2096747 | 37.7382476302403 | -122.382086185189 | (37.7382476302403, -122.382086185189) | 10 | 3 | 8 | 58 | 1 | ||
77180 | 248912 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1215 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017471 | 2096747 | 37.7382476302403 | -122.382086185189 | (37.7382476302403, -122.382086185189) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||
101381 | 188685 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1300 Evans Ave | 14 | : | Tree | DPW 1 | 04/10/2017 01:01:00 PM | 3 | Width 3ft | 6017863.85792 | 2096944.20177 | 37.7388107959886 | -122.380741566863 | (37.7388107959886, -122.380741566863) | 10 | 3 | 8 | 58 | 1 | ||
9624 | 6769 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1275 Fairfax Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2007 12:00:00 AM | 3 | 3x3 | 6017217.4089567 | 2096970.3613046 | 37.7388469269577 | -122.382978527185 | (37.7388469269577, -122.382978527185) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
135674 | 188687 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1300 Evans Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 12:53:00 PM | 3 | Width 4ft | 6017556.40659 | 2097171.27575 | 37.7394173230594 | -122.381820390005 | (37.7394173230594, -122.381820390005) | 10 | 3 | 8 | 58 | 1 | ||
180775 | 197655 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1300 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6016998.37545 | 2097206.43045 | 37.7394830203258 | -122.383752282143 | (37.7394830203258, -122.383752282143) | 10 | 3 | 8 | 58 | 1 | |||
3079 | 203064 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1300 Evans Ave | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 01:07:00 PM | 3 | Width 3ft | 6017493.20317 | 2097219.31473 | 37.7395457381522 | -122.382042262644 | (37.7395457381522, -122.382042262644) | 10 | 3 | 8 | 58 | 1 | ||
77056 | 251288 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1335 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 01:58:00 PM | 3 | 3x3 | 6016828 | 2097292 | 37.7397085577181 | -122.384347329812 | (37.7397085577181, -122.384347329812) | 10 | 3 | 8 | 58 | 1 | |
72148 | 6787 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1360 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/03/2017 06:55:00 AM | 3 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | ||
105367 | 6784 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1360 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 4 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | ||
10875 | 6812 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1400X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 08/13/2020 01:09:00 PM | 3 | 3X3 | 6016477.27072 | 2097595.73141 | 37.7405231429351 | -122.385581175844 | (37.7405231429351, -122.385581175844) | 10 | 3 | 8 | 58 | 1 |
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) );