trees
305 rows where qSpecies_id = 49 sorted by Longitude descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7799 | 112881 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 634 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2015 12:00:00 AM | Permit Number 773545 | 5985072.5 | 2111537.7 | 37.7770162467569 | -122.495192953952 | (37.7770162467569, -122.495192953952) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
73843 | 93629 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 251 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2010 12:00:00 AM | 3x3 | Permit Number 53264 | 5985797 | 2114222 | 37.7844289534299 | -122.492884487425 | (37.7844289534299, -122.492884487425) | 11 | 6 | 1 | 55 | 33 | ||
104688 | 117301 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2238 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778520 | 5985801.3 | 2099978.9 | 37.7453216318219 | -122.491820695636 | (37.7453216318219, -122.491820695636) | 1 | 8 | 3 | 29491 | 35 | ||
151715 | 117300 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2238 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778520 | 5985801.3 | 2099978.9 | 37.7453216318219 | -122.491820695636 | (37.7453216318219, -122.491820695636) | 1 | 8 | 3 | 29491 | 35 | ||
140390 | 90247 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 3026 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5986141.47877 | 2111169.78384 | 37.7760685803771 | -122.49146798939 | (37.7760685803771, -122.49146798939) | 11 | 6 | 2 | 55 | 26 | ||
79191 | 55909 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 3020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Permit Number 11967 | 5986171.45599 | 2111171.12387 | 37.7760740114518 | -122.491364390312 | (37.7760740114518, -122.491364390312) | 11 | 6 | 2 | 55 | 26 | ||
187803 | 90240 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2900X Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5986413.6553 | 2111178.90405 | 37.7761095233068 | -122.490527142485 | (37.7761095233068, -122.490527142485) | 11 | 6 | 2 | 55 | 26 | ||
104540 | 143848 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2900 Balboa St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5986608 | 2111175 | 37.7761101535306 | -122.489854574072 | (37.7761101535306, -122.489854574072) | 11 | 6 | 2 | 55 | 26 | ||
54675 | 87806 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 291 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3 | 3x12 | Permit Number 50584 | 5987096.8 | 2114028.5 | 37.7839735823988 | -122.48837346173 | (37.7839735823988, -122.48837346173) | 11 | 6 | 1 | 55 | 33 | |
60679 | 87807 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 291 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50584 | 5987096.8 | 2114028.5 | 37.7839735823988 | -122.48837346173 | (37.7839735823988, -122.48837346173) | 11 | 6 | 1 | 55 | 33 | |
185606 | 43588 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2014 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/2015 12:00:00 AM | 0 | Permit Number 774769 | 5986972.77982158 | 2101544.10082167 | 37.7496876538817 | -122.48788494443 | (37.7496876538817, -122.48788494443) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
146964 | 52821 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2850@ ANZA Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:32:00 PM | 3 | Permit Number 775537 | 5989762.54787 | 2111977.16007 | 37.7784963508186 | -122.479000957003 | (37.7784963508186, -122.479000957003) | 11 | 6 | 2 | 55 | 26 | ||
102625 | 52820 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2850@ ANZA Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:00:00 PM | 3 | Permit Number 775537 | 5989777.02787 | 2111978.29339 | 37.778500303461 | -122.478950948669 | (37.778500303461, -122.478950948669) | 11 | 6 | 2 | 55 | 26 | ||
191716 | 56557 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 27 Ardenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2010 12:00:00 AM | Permit Number 53358 | 5991301.89931547 | 2096270.47961182 | 37.7354592201324 | -122.472530401662 | (37.7354592201324, -122.472530401662) | 1 | 8 | 4 | 29491 | 40 | |||
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 |
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
103176 | 54058 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2011 12:00:00 AM | Permit Number 767754 | 5994238.69785688 | 2106641.55496777 | 37.7641051091536 | -122.463129131181 | (37.7641051091536, -122.463129131181) | 1 | 5 | 11 | 56 | 12 | |||
31727 | 45656 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2011 12:00:00 AM | Permit Number 767754 | 5994244 | 2106639 | 37.7640983993107 | -122.463110607355 | (37.7640983993107, -122.463110607355) | 1 | 5 | 11 | 56 | 12 | |||
167902 | 45655 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2011 12:00:00 AM | Permit Number 767754 | 5994244 | 2106639 | 37.7640983993107 | -122.463110607355 | (37.7640983993107, -122.463110607355) | 1 | 5 | 11 | 56 | 12 | |||
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 | |||
75265 | 216653 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 307 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 08:20:00 AM | 3 | Width 1ft | 5994722.80826 | 2090636.95151 | 37.7201883328984 | -122.46029507616 | (37.7201883328984, -122.46029507616) | 9 | 8 | 6 | 28861 | 24 | ||
2698 | 216704 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 251 Faxon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 08:35:00 AM | 3 | Width 2ft | 5994715.27121 | 2090263.18688 | 37.7191616308917 | -122.460294062627 | (37.7191616308917, -122.460294062627) | 9 | 8 | 6 | 28861 | 24 | ||
12735 | 216702 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 251 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 08:30:00 AM | 3 | Width 2ft | 5994715.94794 | 2090284.84641 | 37.7192211417229 | -122.460293291913 | (37.7192211417229, -122.460293291913) | 9 | 8 | 6 | 28861 | 24 | ||
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 | ||
113466 | 208858 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 438 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995058.10493 | 2088636.31029 | 37.7147143277695 | -122.458991293911 | (37.7147143277695, -122.458991293911) | 9 | 8 | 6 | 28861 | 24 | |||
175364 | 115252 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 438 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 772344 | 5995084 | 2088641.7 | 37.7147306151804 | -122.458902180491 | (37.7147306151804, -122.458902180491) | 9 | 8 | 6 | 28861 | 24 | |||
104437 | 106758 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 445 Grafton Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | Permit Number 772911 | 5995409.1 | 2090523.2 | 37.7199154518997 | -122.457914582927 | (37.7199154518997, -122.457914582927) | 9 | 8 | 6 | 28861 | 24 | ||||
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 | |||
63056 | 216749 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 26 Granada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/06/2017 08:25:00 AM | 3 | Width 3ft | 5995639.97816 | 2090086.85434 | 37.7187306119189 | -122.457084975807 | (37.7187306119189, -122.457084975807) | 9 | 8 | 6 | 28861 | 24 | ||
47271 | 106182 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 26 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2014 12:00:00 AM | 9 | Permit Number 772520 | 5996564.2 | 2114395.4 | 37.7855288291914 | -122.455646443632 | (37.7855288291914, -122.455646443632) | 11 | 6 | 1 | 54 | 31 | ||
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 | ||
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 | ||
192201 | 84013 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 207 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 771913 | 5997093.91103174 | 2089409.10522836 | 37.7169530610701 | -122.452010468882 | (37.7169530610701, -122.452010468882) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |
169178 | 78830 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 35 Laura St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/2017 04:01:00 PM | 3 | 5997431.0713 | 2086896.39523 | 37.7100730444948 | -122.450664016958 | (37.7100730444948, -122.450664016958) | 9 | 7 | 6 | 28861 | 25 | ||
5303 | 254848 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 914 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x5 | 5999583 | 2111627 | 37.7781002923949 | -122.445003231417 | (37.7781002923949, -122.445003231417) | 15 | 5 | 11 | 29490 | 16 | |||
174012 | 101369 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2007 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769245 | 5999888.5 | 2111553 | 37.7779145386147 | -122.443941082049 | (37.7779145386147, -122.443941082049) | 15 | 5 | 11 | 29490 | 16 | |
174483 | 108870 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 636 Lyon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773421 | 6000111.40758 | 2111064.83155 | 37.7765868652264 | -122.443134899814 | (37.7765868652264, -122.443134899814) | 15 | 5 | 11 | 29492 | 16 | |
153082 | 18993 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2965 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1999 12:00:00 AM | 3 | 3X3 | 6000621.16815 | 2115478.56365 | 37.7887348935356 | -122.441688325582 | (37.7887348935356, -122.441688325582) | 13 | 6 | 1 | 29490 | 27 | ||
94211 | 117589 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2698 VALLEJO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000707 | 2117582 | 37.7945152706116 | -122.441542364689 | (37.7945152706116, -122.441542364689) | 13 | 9 | 1 | 57 | 27 | ||||
155215 | 109566 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 56 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775012 | 6000375.8 | 2089821 | 37.7182714712375 | -122.440696127295 | (37.7182714712375, -122.440696127295) | 9 | 7 | 6 | 28861 | 25 |
132572 | 54713 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2701 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2018 12:00:00 AM | 3 | Permit Number 781936 | 6001165.76206 | 2116883.2589 | 37.7926228359235 | -122.43990487064 | (37.7926228359235, -122.43990487064) | 13 | 6 | 1 | 29490 | 27 | ||
84177 | 230425 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 70 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001023.25881 | 2106016.57579 | 37.7627775639463 | -122.439618557053 | (37.7627775639463, -122.439618557053) | 15 | 5 | 5 | 28862 | 3 | |||
96348 | 115319 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 86 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | Permit Number 777439 | 6000946.9 | 2101238.5 | 37.7496537815844 | -122.439540113547 | (37.7496537815844, -122.439540113547) | 2 | 4 | 5 | 28862 | 22 | ||
143429 | 108627 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 223 Douglass St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772318 | 6001122.48631 | 2104986.51759 | 37.7599549235553 | -122.439201532761 | (37.7599549235553, -122.439201532761) | 2 | 4 | 5 | 28862 | 3 | |
58698 | 254582 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 3239 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | 3x3 | 6001867 | 2119344 | 37.799419281227 | -122.437654876352 | (37.799419281227, -122.437654876352) | 13 | 9 | 1 | 57 | 17 | ||
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 | |||
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 | |||
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 | |||
14386 | 160654 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 527 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2017 12:00:00 AM | 3 | 3x3 | 6001557.28645 | 2090682.81807 | 37.7207050428777 | -122.436673891586 | (37.7207050428777, -122.436673891586) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
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 | ||
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 | ||
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 | |||
125437 | 251758 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 241 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 10:31:00 AM | 3 | 3x3 | 6001856 | 2086522 | 37.7092973294849 | -122.435343856961 | (37.7092973294849, -122.435343856961) | 9 | 7 | 6 | 28861 | 5 | ||
36606 | 160510 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 706 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:18:00 PM | 3 | Width 0ft | 6001927.69711 | 2089831.31409 | 37.7183880466434 | -122.435332621096 | (37.7183880466434, -122.435332621096) | 9 | 7 | 6 | 28861 | 5 | |
60445 | 251757 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 233 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001887 | 2086528 | 37.7093155646434 | -122.43523714505 | (37.7093155646434, -122.43523714505) | 9 | 7 | 6 | 28861 | 5 | ||||
107920 | 251756 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 233 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001887 | 2086528 | 37.7093155646434 | -122.43523714505 | (37.7093155646434, -122.43523714505) | 9 | 7 | 6 | 28861 | 5 | ||||
55856 | 160433 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 401 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2017 12:12:00 PM | 3 | Width 0ft | 6002070.28716 | 2089835.8834 | 37.7184086896908 | -122.43484007413 | (37.7184086896908, -122.43484007413) | 9 | 7 | 6 | 28861 | 5 | |
127114 | 251755 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 201X Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 11:50:00 AM | 3 | 3x3 | 6002020 | 2086565 | 37.7094247104414 | -122.434780120464 | (37.7094247104414, -122.434780120464) | 9 | 7 | 6 | 28861 | 5 | ||
136360 | 251754 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 201X Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 12:00:00 AM | 3 | 3x3 | 6002020 | 2086565 | 37.7094247104414 | -122.434780120464 | (37.7094247104414, -122.434780120464) | 9 | 7 | 6 | 28861 | 5 | ||
24902 | 180669 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 171 Winding Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 6ft | 6002170.18422 | 2086635.71157 | 37.7096273944518 | -122.434266111507 | (37.7096273944518, -122.434266111507) | 9 | 7 | 6 | 28861 | 5 | |||
40245 | 180646 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 451 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 6ft | 6002230.18825 | 2087673.61332 | 37.7124806510226 | -122.434132874236 | (37.7124806510226, -122.434132874236) | 9 | 7 | 6 | 28861 | 5 | |||
46204 | 251736 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 8 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 11:28:00 AM | 3 | 3x3 | 6002228 | 2087184 | 37.7111361560163 | -122.434105459048 | (37.7111361560163, -122.434105459048) | 9 | 7 | 6 | 28861 | 5 | ||
95414 | 160423 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 525 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 03:43:00 PM | 3 | Width 0ft | 6002340.52441 | 2089668.33181 | 37.7179639695305 | -122.433894007997 | (37.7179639695305, -122.433894007997) | 9 | 7 | 6 | 28861 | 5 | |
71239 | 160422 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 591 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:59:00 PM | 3 | Width 0ft | 6002364.11048 | 2089653.56999 | 37.7179247752893 | -122.43381142685 | (37.7179247752893, -122.43381142685) | 9 | 7 | 6 | 28861 | 5 | |
121854 | 160421 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 591 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 04:04:00 PM | 3 | Width 0ft | 6002387.35536 | 2089638.81491 | 37.7178855801363 | -122.433730025613 | (37.7178855801363, -122.433730025613) | 9 | 7 | 6 | 28861 | 5 | |
155192 | 50070 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 178 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53758 | 6003140.05481803 | 2105079.35140699 | 37.7603244234929 | -122.432230375273 | (37.7603244234929, -122.432230375273) | 2 | 4 | 5 | 28862 | 3 | |
156269 | 8129 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 899 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2013 12:00:00 AM | 12 | 3X3 | Permit Number 770378 | 6003470.39544 | 2111382.10126 | 37.7776489625125 | -122.431537848369 | (37.7776489625125, -122.431537848369) | 7 | 9 | 11 | 29492 | 10 | |
56180 | 255527 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 730 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782016 | 6003494.63141 | 2110038.24994 | 37.7739604525435 | -122.431358054188 | (37.7739604525435, -122.431358054188) | 15 | 9 | 11 | 29492 | 10 |
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 |
189972 | 17872 | Section 143 10 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2148 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/21/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53638 | 6003654.7045158 | 2115269.5781823 | 37.7883334451781 | -122.431177809024 | (37.7883334451781, -122.431177809024) | 13 | 9 | 1 | 29490 | 27 |
11491 | 160766 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 695 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6003187.32082 | 2089217.65008 | 37.7167745145126 | -122.430934858059 | (37.7167745145126, -122.430934858059) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
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 | |||
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 |
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 | |||
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 | |||
194394 | 160700 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 932 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 0ft | 6003612.41439 | 2089600.12112 | 37.7178487735724 | -122.429492779881 | (37.7178487735724, -122.429492779881) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
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 | ||
42544 | 37824 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 450X Moscow St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003906.75378 | 2090460.71651 | 37.7202284408775 | -122.428536688136 | (37.7202284408775, -122.428536688136) | 9 | 7 | 6 | 28861 | 5 |
34741 | 93240 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Church St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004217.7 | 2105335.5 | 37.761088789181 | -122.428521561971 | (37.761088789181, -122.428521561971) | 2 | 4 | 5 | 28862 | 3 | ||
113355 | 93239 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004217.7 | 2105335.5 | 37.761088789181 | -122.428521561971 | (37.761088789181, -122.428521561971) | 2 | 4 | 5 | 28862 | 3 | ||
153352 | 93238 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004217.7 | 2105335.5 | 37.761088789181 | -122.428521561971 | (37.761088789181, -122.428521561971) | 2 | 4 | 5 | 28862 | 3 | ||
63510 | 16928 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 518 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2007 12:00:00 AM | 3 | 2.5 X3 | 6004333.80114 | 2110174.91218 | 37.7743832165186 | -122.42846496782 | (37.7743832165186, -122.42846496782) | 7 | 9 | 11 | 28852 | 10 |
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) );