trees
305 rows where qSpecies_id = 49 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161364 | 193420 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015798.54633 | 2105794.6845 | 37.7629981703438 | -122.38850010901 | (37.7629981703438, -122.38850010901) | 14 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 164163 | 193418 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 610 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015955.04058 | 2106161.79394 | 37.7640148449206 | -122.387984462917 | (37.7640148449206, -122.387984462917) | 14 | 3 | 8 | 28856 | 29 | |||
| 166488 | 193413 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2200 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011171.17043 | 2105584.01117 | 37.7621621911485 | -122.404489872412 | (37.7621621911485, -122.404489872412) | 8 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |
| 174645 | 230412 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 310 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2016 08:29:00 AM | 1 | Width 6ft | 6004822.22232 | 2106544.83878 | 37.7644435373721 | -122.426516892666 | (37.7644435373721, -122.426516892666) | 8 | 4 | 5 | 28862 | 3 | ||
| 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 | ||
| 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 | |||
| 175595 | 117160 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014455.03317 | 2103837.45298 | 37.7575494928317 | -122.393009948265 | (37.7575494928317, -122.393009948265) | 10 | 3 | 8 | 28856 | 29 | |||
| 176400 | 193410 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 551 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010705.60274 | 2105553.43771 | 37.7620522139578 | -122.406097947485 | (37.7620522139578, -122.406097947485) | 8 | 4 | 8 | 28859 | 19 | |||
| 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 | |||
| 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 | |||
| 180617 | 101611 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 681 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 6011008.34199 | 2105144.37638 | 37.7609459516243 | -122.40502208042 | (37.7609459516243, -122.40502208042) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 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 | ||
| 181396 | 172046 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 255 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 2ft | 6009960.33149 | 2094057.74194 | 37.730445840099 | -122.407864901243 | (37.730445840099, -122.407864901243) | 10 | 3 | 7 | 309 | 28 | |||
| 182962 | 230399 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 635 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6010446.03903 | 2105294.43136 | 37.761326519519 | -122.406977425991 | (37.761326519519, -122.406977425991) | 10 | 4 | 8 | 28859 | 19 | |||
| 183623 | 230421 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2851 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009338.5093 | 2104971.08738 | 37.7603766528768 | -122.41078508446 | (37.7603766528768, -122.41078508446) | 2 | 4 | 7 | 28859 | 19 | |||
| 184363 | 117158 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014455.94065 | 2103803.29799 | 37.7574557609929 | -122.393004420141 | (37.7574557609929, -122.393004420141) | 10 | 3 | 8 | 28856 | 29 | |||
| 184892 | 93299 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 801X Church St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004394.3 | 2104124.7 | 37.7577742117678 | -122.427824502367 | (37.7577742117678, -122.427824502367) | 2 | 4 | 5 | 28862 | 3 | ||
| 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 | |
| 186140 | 193437 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 420 Bay Shore Blvd | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6010286.5563 | 2097785.62722 | 37.7407000755616 | -122.406999745365 | (37.7407000755616, -122.406999745365) | 10 | 3 | 7 | 58 | 2 | |||
| 186428 | 193423 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015877.90137 | 2105798.99134 | 37.7630143932264 | -122.388225945268 | (37.7630143932264, -122.388225945268) | 14 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | ||
| 188069 | 95808 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 974 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767552 | 6011863.56882 | 2103875.82821 | 37.7575105701687 | -122.401975028944 | (37.7575105701687, -122.401975028944) | 10 | 3 | 8 | 28856 | 29 |
| 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 | |||
| 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 | ||
| 190715 | 18367 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 625 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/17/2015 09:59:00 AM | 3 | 4X3 | 6010438.66394 | 2105366.85434 | 37.7615249639888 | -122.407008038291 | (37.7615249639888, -122.407008038291) | 10 | 4 | 8 | 28859 | 19 | ||
| 192615 | 37946 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 255 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 6 | Permit Number 40187 | 6013211.43951 | 2105863.92108 | 37.7630445717758 | -122.397452942701 | (37.7630445717758, -122.397452942701) | 14 | 3 | 8 | 28856 | 29 | |
| 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 | |
| 194232 | 18350 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 459 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/2015 06:59:00 AM | 3 | 3x3 | 6010395.85662 | 2106161.99214 | 37.7637058369709 | -122.407212144541 | (37.7637058369709, -122.407212144541) | 8 | 4 | 8 | 28859 | 19 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 27287 | 255049 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 925 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779631 | 6009075.60356 | 2091383.60862 | 37.7230536656288 | -122.410734764023 | (37.7230536656288, -122.410734764023) | 9 | 3 | 7 | 309 | 28 | |
| 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 | |||
| 32707 | 100007 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501X Mission St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.7897060631976 | -122.397547983339 | (37.7897060631976, -122.397547983339) | 12 | 2 | 9 | 28855 | 6 | |||
| 35004 | 100003 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501X Mission St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.7897060631976 | -122.397547983339 | (37.7897060631976, -122.397547983339) | 12 | 2 | 9 | 28855 | 6 | |||
| 35901 | 94252 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2125 BRYANT ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |||
| 39923 | 94251 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2125 BRYANT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |||
| 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 | |||
| 45351 | 94249 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2125 BRYANT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |||
| 52174 | 99998 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501X Mission St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013420 | 2115433 | 37.7893307029327 | -122.397402707509 | (37.7893307029327, -122.397402707509) | 12 | 2 | 9 | 28855 | 6 | |||
| 54991 | 94248 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2125 BRYANT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |||
| 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 | ||
| 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 | ||||
| 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 | |||
| 88404 | 100008 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501X Mission St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.7897060631976 | -122.397547983339 | (37.7897060631976, -122.397547983339) | 12 | 2 | 9 | 28855 | 6 | |||
| 93417 | 94253 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2125 BRYANT ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 141793 | 94257 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2777X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.409573390285 | (37.7597963985886, -122.409573390285) | 2 | 4 | 8 | 28859 | 19 | |||
| 143815 | 94250 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2125 BRYANT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 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 | ||
| 155778 | 94256 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2777X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.409573390285 | (37.7597963985886, -122.409573390285) | 2 | 4 | 8 | 28859 | 19 | |||
| 3337 | 261748 | Section 806 (d) 5 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 540 De Haro St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 11461 | 261747 | Section 806 (d) 5 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 540 De Haro St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 15024 | 261746 | Section 806 (d) 5 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 540 De Haro St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 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 |
| 10331 | 128078 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 245 North Point St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:25:00 PM | 3 | Width 4ft | 6009589.18536 | 2121879.68336 | 37.8068176775527 | -122.411112486276 | (37.8068176775527, -122.411112486276) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | ||
| 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 | |||
| 38581 | 29817 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1695X Evans Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |
| 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 | |
| 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 |
| 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 | |
| 69262 | 58794 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2125 BRYANT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/1979 12:00:00 AM | Permit Number 18041 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |||
| 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 |
| 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 | ||
| 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 | |
| 77890 | 115285 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 32 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775365 | 6004721.1 | 2096171.8 | 37.7359558621574 | -122.426128127271 | (37.7359558621574, -122.426128127271) | 2 | 7 | 5 | 28861 | 2 | |||
| 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 |
| 89203 | 108393 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 321 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772685 | 6006734.79675 | 2104244.32387 | 37.7582347949878 | -122.419738566409 | (37.7582347949878, -122.419738566409) | 2 | 4 | 7 | 28859 | 19 |
| 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 | ||
| 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 | |||
| 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 |
| 121448 | 115375 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 230 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776301 | 6007067.3 | 2096865.5 | 37.7379929380378 | -122.418065521541 | (37.7379929380378, -122.418065521541) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | ||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | ||
| 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 | |
| 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 |
| 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 | |
| 160733 | 108628 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 741 Ellis St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774600 | 6007319.99858 | 2113650.90643 | 37.7840959912819 | -122.418381641984 | (37.7840959912819, -122.418381641984) | 7 | 9 | 9 | 28858 | 36 | |
| 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 | ||
| 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 | |||
| 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 | |||
| 185674 | 82560 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 832 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52208 | 6009084.37207289 | 2104307.27777207 | 37.7585397298832 | -122.411617128308 | (37.7585397298832, -122.411617128308) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );