trees
979 rows where qSpecies_id = 13 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76532 | 88382 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 355 17th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51360 | 5990561.77007 | 2113010.94096 | 37.7813812065074 | -122.476311706446 | (37.7813812065074, -122.476311706446) | 11 | 6 | 2 | 55 | 26 | ||
| 186900 | 208835 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1673 18th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990563.36006 | 2104017.9082 | 37.7566888695243 | -122.475649328274 | (37.7566888695243, -122.475649328274) | 1 | 8 | 4 | 56 | 12 | |||
| 102332 | 208836 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1677 18th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990563.73281 | 2104000.71919 | 37.7566416946684 | -122.475646784065 | (37.7566416946684, -122.475646784065) | 1 | 8 | 4 | 56 | 12 | |||
| 160765 | 108524 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1669 18th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773675 | 5990564.49357 | 2104037.4684 | 37.7567426423615 | -122.475646836483 | (37.7567426423615, -122.475646836483) | 1 | 8 | 4 | 56 | 12 |
| 121503 | 108525 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1673 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773676 | 5990565.37747 | 2104011.47717 | 37.7566713285758 | -122.475641881825 | (37.7566713285758, -122.475641881825) | 1 | 8 | 4 | 56 | 12 |
| 172192 | 12725 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1544 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2003 12:00:00 AM | 3 | 3X3 | 5990592.79668 | 2114771.31925 | 37.7862165141869 | -122.476332998319 | (37.7862165141869, -122.476332998319) | 11 | 6 | 1 | 54 | 33 | ||
| 84397 | 121908 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 320 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990601.2313 | 2113229.42539 | 37.7819833924997 | -122.476191154353 | (37.7819833924997, -122.476191154353) | 11 | 6 | 2 | 54 | 26 | |||
| 19166 | 144984 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 718 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 5990699.49046 | 2110468.54979 | 37.7744084860936 | -122.475649562098 | (37.7744084860936, -122.475649562098) | 11 | 6 | 2 | 54 | 26 | |||
| 133012 | 101128 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 295X 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769229 | 5990852.62725 | 2113482.24479 | 37.7826921394002 | -122.475339912567 | (37.7826921394002, -122.475339912567) | 11 | 6 | 2 | 54 | 26 | |
| 129178 | 208837 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5990984.78596 | 2102065.3313 | 37.7513520289909 | -122.474049439736 | (37.7513520289909, -122.474049439736) | 1 | 8 | 4 | 29491 | 12 | |||
| 11428 | 122390 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x2 | 5991007 | 2102078 | 37.7513881006776 | -122.473973545995 | (37.7513881006776, -122.473973545995) | 1 | 8 | 4 | 29491 | 12 | |||
| 38155 | 43751 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 255 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/2015 12:00:00 AM | 3 | Permit Number 773834 | 5991170.79793 | 2113718.28394 | 37.7833586747671 | -122.474256417664 | (37.7833586747671, -122.474256417664) | 11 | 6 | 2 | 54 | 26 | |
| 162122 | 122152 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 263 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5991173.60125 | 2113665.47649 | 37.7832138425408 | -122.474242864812 | (37.7832138425408, -122.474242864812) | 11 | 6 | 2 | 54 | 26 | |||
| 155325 | 208838 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1450 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 5ft | 5991176.37038 | 2105519.18149 | 37.7608464875004 | -122.473638846178 | (37.7608464875004, -122.473638846178) | 1 | 8 | 4 | 56 | 12 | |||
| 161402 | 217796 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 21 Sloat Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5991264.94517 | 2095927.55542 | 37.7345154980788 | -122.472633170284 | (37.7345154980788, -122.472633170284) | 1 | 8 | 4 | 64 | 40 | |||
| 48795 | 145061 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 618 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2018 12:00:00 AM | 3 | 5x5 | 5991308.93205 | 2111174.50243 | 37.7763821517422 | -122.47359291598 | (37.7763821517422, -122.47359291598) | 11 | 6 | 2 | 54 | 26 | ||
| 170508 | 72366 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 706 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772932 | 5991332.62885 | 2110561.58816 | 37.7747006286591 | -122.473466226319 | (37.7747006286591, -122.473466226319) | 11 | 6 | 2 | 54 | 26 | |
| 92704 | 88376 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 563 14th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51354 | 5991545.8 | 2111599.6 | 37.7775630683787 | -122.472804534873 | (37.7775630683787, -122.472804534873) | 11 | 6 | 2 | 54 | 26 | |||
| 89563 | 102081 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 525 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52509 | 5991566.61031 | 2111852.8346 | 37.7782595860122 | -122.472751014651 | (37.7782595860122, -122.472751014651) | 11 | 6 | 2 | 54 | 26 |
| 63488 | 81662 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 563 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5991577.12734 | 2111607.04314 | 37.7775853186785 | -122.472696706975 | (37.7775853186785, -122.472696706975) | 11 | 6 | 2 | 54 | 26 | |||
| 95963 | 123057 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 514 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5991919.13974 | 2111920.98536 | 37.7784671102548 | -122.47153646454 | (37.7784671102548, -122.47153646454) | 11 | 6 | 2 | 54 | 11 | |||
| 172950 | 87071 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 395 Byxbee St | 2 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 188216 | 87070 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 395 Byxbee St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 166546 | 68687 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 133 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2014 12:00:00 AM | 1 | 6x6 | Permit Number 771044 | 5992088.87095 | 2114507.13587 | 37.7855777876584 | -122.471137767056 | (37.7855777876584, -122.471137767056) | 11 | 6 | 2 | 54 | 11 |
| 113259 | 108495 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 133 12th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773787 | 5992089.92921 | 2114572.19418 | 37.7857564810121 | -122.47113884729 | (37.7857564810121, -122.47113884729) | 11 | 6 | 2 | 54 | 11 | ||
| 163039 | 122918 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 336 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992182.56375 | 2113171.96239 | 37.7819171874048 | -122.470716333226 | (37.7819171874048, -122.470716333226) | 11 | 6 | 2 | 54 | 11 | |||
| 43601 | 94709 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 739 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53847 | 5992236.9095 | 2110392.30167 | 37.7742881380791 | -122.470325834679 | (37.7742881380791, -122.470325834679) | 11 | 6 | 2 | 54 | 11 |
| 92756 | 52460 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 682@ CABRILLO 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 1 | Permit Number 48571 | 5992268.12798 | 2110826.06835 | 37.7754809489734 | -122.470249439229 | (37.7754809489734, -122.470249439229) | 11 | 6 | 2 | 54 | 11 | |
| 192796 | 94708 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 696 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53846 | 5992270.38847 | 2110735.82166 | 37.7752332866791 | -122.470235046427 | (37.7752332866791, -122.470235046427) | 11 | 6 | 2 | 54 | 11 |
| 63821 | 94705 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 682 12th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53845 | 5992291.3 | 2110837.3 | 37.7755131276945 | -122.470170100471 | (37.7755131276945, -122.470170100471) | 11 | 6 | 2 | 54 | 11 | ||
| 179999 | 94820 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1227 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53900 | 5992334 | 2107055.2 | 37.7651309632558 | -122.469746983482 | (37.7651309632558, -122.469746983482) | 11 | 8 | 11 | 56 | 12 | |
| 144146 | 81067 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1283 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50902 | 5992359.24137134 | 2106729.49777919 | 37.7642381302347 | -122.469635967848 | (37.7642381302347, -122.469635967848) | 11 | 8 | 11 | 56 | 12 | ||
| 1059 | 262280 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 3880 | 262281 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 11800 | 262282 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 26576 | 173651 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 80 Entrada Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.45657 | 2092194.59394 | 37.7243327619491 | -122.468352901223 | (37.7243327619491, -122.468352901223) | 9 | 8 | 4 | 59 | 40 | ||
| 821 | 261708 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 1 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
| 12273 | 261709 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 2 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
| 101820 | 69097 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1652 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53733 | 5992497.75001654 | 2104207.48539143 | 37.7573213517081 | -122.468973359701 | (37.7573213517081, -122.468973359701) | 1 | 8 | 4 | 56 | 12 | |
| 179923 | 122379 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 466 Vernon St | 1 | Front Yard : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 5992521 | 2090937 | 37.7208852925782 | -122.467927737968 | (37.7208852925782, -122.467927737968) | 9 | 8 | 6 | 64 | 24 | ||
| 175719 | 123126 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 771 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992555.29457 | 2110202.54859 | 37.7737855300786 | -122.469210678659 | (37.7737855300786, -122.469210678659) | 11 | 6 | 2 | 54 | 11 | |||
| 65512 | 108459 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 771 11th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773786 | 5992558.08669 | 2110211.94426 | 37.7738114893979 | -122.469201704334 | (37.7738114893979, -122.469201704334) | 11 | 6 | 2 | 54 | 11 | |||
| 49638 | 123123 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 780 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992600.03768 | 2110148.99607 | 37.7736410746067 | -122.469052008303 | (37.7736410746067, -122.469052008303) | 11 | 6 | 2 | 54 | 11 | |||
| 12150 | 31352 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2359 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2020 11:52:00 AM | 3 | Permit Number 34962 | 5992611.19724 | 2099415.50216 | 37.7441703551938 | -122.468232424195 | (37.7441703551938, -122.468232424195) | 1 | 8 | 4 | 29491 | 40 | |
| 6755 | 264922 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 4x6 | Permit Number 781481 | 5992625.08037 | 2092677.96132 | 37.7256715559054 | -122.467694516591 | (37.7256715559054, -122.467694516591) | 9 | 8 | 4 | 59 | 40 | |
| 15881 | 264923 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Urbano Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 4x6 | Permit Number 781481 | 5992625.08037 | 2092677.96132 | 37.7256715559054 | -122.467694516591 | (37.7256715559054, -122.467694516591) | 9 | 8 | 4 | 59 | 40 | |
| 17123 | 254549 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 170 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2020 12:00:00 AM | 3 | 3x3 | 5992784 | 2114350 | 37.7851865177567 | -122.46872140612 | (37.7851865177567, -122.46872140612) | 11 | 6 | 2 | 54 | 11 | ||
| 99358 | 83188 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1664 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53557 | 5992810.26262937 | 2104140.01708709 | 37.7571541524742 | -122.467887670443 | (37.7571541524742, -122.467887670443) | 1 | 8 | 4 | 56 | 12 | ||
| 32930 | 83189 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1670 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53556 | 5992811.58181355 | 2104100.90541778 | 37.7570468381941 | -122.467880263564 | (37.7570468381941, -122.467880263564) | 1 | 8 | 4 | 56 | 12 | ||
| 158850 | 94144 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1670 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53556 | 5992831.3 | 2104104.9 | 37.7570589448864 | -122.467812361688 | (37.7570589448864, -122.467812361688) | 1 | 8 | 4 | 56 | 12 | ||
| 192174 | 84410 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 745 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51564 | 5992859.62349 | 2110370.66867 | 37.7742647232802 | -122.468170197773 | (37.7742647232802, -122.468170197773) | 11 | 6 | 2 | 54 | 11 | |
| 180821 | 208839 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 131 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992959.48741 | 2098205.81206 | 37.74086896193 | -122.466940197353 | (37.74086896193, -122.466940197353) | 1 | 8 | 4 | 59 | 40 | |||
| 57445 | 94819 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1551 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53898 | 5993027.2 | 2104915.2 | 37.7592951275131 | -122.467193784759 | (37.7592951275131, -122.467193784759) | 1 | 8 | 4 | 56 | 12 | |
| 37880 | 53932 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 140 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 1 | Permit Number 9646 | 5993064.17697 | 2114524.47346 | 37.7856817557629 | -122.467764782699 | (37.7856817557629, -122.467764782699) | 11 | 6 | 2 | 54 | 11 | ||
| 6056 | 147742 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 175 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2019 12:00:00 AM | 3 | Width 4ft | 5993335.44452 | 2114350.58879 | 37.7852199756724 | -122.466813637549 | (37.7852199756724, -122.466813637549) | 11 | 6 | 2 | 54 | 11 | ||
| 107998 | 108994 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1819 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773341 | 5993399.9 | 2103085.8 | 37.7542935760975 | -122.465771900659 | (37.7542935760975, -122.465771900659) | 1 | 8 | 4 | 56 | 12 |
| 157008 | 215064 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1446 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993686.72935 | 2105638.95065 | 37.7613204077437 | -122.464965394043 | (37.7613204077437, -122.464965394043) | 1 | 8 | 11 | 56 | 12 | |||
| 70704 | 208841 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2134 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993696.59277 | 2101147.80807 | 37.7489894559968 | -122.46460515623 | (37.7489894559968, -122.46460515623) | 1 | 8 | 4 | 29491 | 40 | |||
| 96765 | 208842 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 168 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993717.6087 | 2099811.01881 | 37.7453201833801 | -122.46443543704 | (37.7453201833801, -122.46443543704) | 1 | 8 | 4 | 29491 | 40 | |||
| 163303 | 208849 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 15 Santa Rita Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 3ft | 5993729.602 | 2100694.18749 | 37.7477458321253 | -122.464458079273 | (37.7477458321253, -122.464458079273) | 1 | 8 | 4 | 29491 | 40 | |||
| 43419 | 108518 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600-602 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773792 | 5993757.57798 | 2110759.58067 | 37.7753843907715 | -122.465092287532 | (37.7753843907715, -122.465092287532) | 11 | 6 | 2 | 54 | 11 |
| 114639 | 218385 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 50 San Marcos Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5993842.10795 | 2100214.10934 | 37.7464341439306 | -122.46403419822 | (37.7464341439306, -122.46403419822) | 1 | 8 | 4 | 29491 | 40 | |||
| 33124 | 218387 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 50 San Marcos Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5993857.52408 | 2100226.90247 | 37.7464701590844 | -122.463981819901 | (37.7464701590844, -122.463981819901) | 1 | 8 | 4 | 29491 | 40 | |||
| 32475 | 255482 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1559 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2018 12:00:00 AM | 3 | 3x5 | 5993958 | 2104895 | 37.7592933500003 | -122.463973185629 | (37.7592933500003, -122.463973185629) | 1 | 8 | 4 | 56 | 12 | ||
| 1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
| 139506 | 254366 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
| 158442 | 254367 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
| 32076 | 208848 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 281 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994210.24416 | 2088699.7294 | 37.7148396860693 | -122.461926423875 | (37.7148396860693, -122.461926423875) | 9 | 8 | 6 | 28861 | 24 | |||
| 45409 | 114908 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 281 LOBOS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994225 | 2088676 | 37.714775380269 | -122.461873702271 | (37.714775380269, -122.461873702271) | 9 | 8 | 6 | 28861 | 24 | ||||
| 70004 | 123549 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 65 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5994237.46417 | 2115165.09446 | 37.7875084040974 | -122.463752090061 | (37.7875084040974, -122.463752090061) | 11 | 6 | 1 | 54 | 11 | |||
| 8586 | 50836 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 202 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2004 12:00:00 AM | Permit Number 47354 | 5994277.69303186 | 2105335.48637483 | 37.7605212305047 | -122.462899497742 | (37.7605212305047, -122.462899497742) | 1 | 5 | 11 | 56 | 12 | |||
| 27335 | 50837 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 202 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2004 12:00:00 AM | Permit Number 47354 | 5994277.69303186 | 2105335.48637483 | 37.7605212305047 | -122.462899497742 | (37.7605212305047, -122.462899497742) | 1 | 5 | 11 | 56 | 12 | |||
| 93223 | 41941 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 646 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 10 | Permit Number 42299 | 5994427.44449 | 2111105.89465 | 37.7763738805691 | -122.46280020914 | (37.7763738805691, -122.46280020914) | 11 | 6 | 2 | 54 | 11 | |
| 46494 | 48393 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1325 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 4 | Permit Number 45775 | 5994526.88441 | 2112095.32134 | 37.7790963088496 | -122.462528007047 | (37.7790963088496, -122.462528007047) | 11 | 6 | 2 | 54 | 11 | |
| 111497 | 87238 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 313 04th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/2008 12:00:00 AM | 3x3 | Permit Number 50268 | 5994594.9 | 2113356.1 | 37.7825619851863 | -122.462384185128 | (37.7825619851863, -122.462384185128) | 11 | 6 | 2 | 54 | 11 | |||
| 172708 | 107438 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 777 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773131 | 5994721.10495 | 2110354.7884 | 37.7743284514501 | -122.461729889857 | (37.7743284514501, -122.461729889857) | 11 | 6 | 2 | 54 | 11 | |
| 10378 | 163649 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 226 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 07/01/2020 12:00:00 AM | 3 | 3x4 | Permit Number 784460 | 5994737.04022 | 2087470.63166 | 37.71149518743 | -122.460016622663 | (37.71149518743, -122.460016622663) | 9 | 8 | 6 | 28861 | 24 |
| 68596 | 123366 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 780 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994765.69029 | 2110380.32738 | 37.7744011411578 | -122.461577514019 | (37.7744011411578, -122.461577514019) | 11 | 6 | 2 | 54 | 11 | |||
| 147619 | 123367 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 780 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994765.80276 | 2110367.1849 | 37.7743650618625 | -122.461576171928 | (37.7743650618625, -122.461576171928) | 11 | 6 | 2 | 54 | 11 | |||
| 139250 | 208851 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 185 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994827.47674 | 2099365.31036 | 37.7441602944536 | -122.460565432153 | (37.7441602944536, -122.460565432153) | 1 | 8 | 4 | 59 | 40 | |||
| 86762 | 208850 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 185 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994846.41703 | 2099381.92654 | 37.7442070079607 | -122.46050114503 | (37.7442070079607, -122.46050114503) | 1 | 8 | 4 | 59 | 40 | |||
| 17 | 164866 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 719 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 4x6 | Permit Number 782492 | 5994853.78052 | 2092811.30491 | 37.7261661184654 | -122.459999785581 | (37.7261661184654, -122.459999785581) | 9 | 7 | 4 | 28861 | 40 | |
| 139488 | 88514 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 640 Faxon Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51446 | 5994921.4 | 2092497.3 | 37.7253078255283 | -122.459743296133 | (37.7253078255283, -122.459743296133) | 9 | 7 | 4 | 28861 | 40 | |||
| 81645 | 47396 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 492 03rd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45308 | 5995005.9977 | 2112260.59137 | 37.7795776757203 | -122.46088255216 | (37.7795776757203, -122.46088255216) | 11 | 6 | 2 | 54 | 11 | |
| 104295 | 47397 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 492 03rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/14/2002 12:00:00 AM | 2 | Permit Number 45308 | 5995007.08219 | 2112241.09178 | 37.7795241974528 | -122.460877386845 | (37.7795241974528, -122.460877386845) | 11 | 6 | 2 | 54 | 11 | |
| 66307 | 47394 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 492 03rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/14/2002 12:00:00 AM | 2 | Permit Number 45308 | 5995008.66399 | 2112223.96074 | 37.7794772512056 | -122.460870672851 | (37.7794772512056, -122.460870672851) | 11 | 6 | 2 | 54 | 11 | |
| 149921 | 123425 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 642 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5995046.06242 | 2111151.48991 | 37.7765346834922 | -122.460663556381 | (37.7765346834922, -122.460663556381) | 11 | 6 | 2 | 54 | 11 | |||
| 121719 | 12532 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 120 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 6x7.4 | 5995061.51034 | 2114935.24706 | 37.7869247555074 | -122.460884411661 | (37.7869247555074, -122.460884411661) | 11 | 6 | 1 | 54 | 11 | |||
| 73885 | 123609 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 121 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782700 | 5995062.26821 | 2114886.47744 | 37.786790890934 | -122.460878253711 | (37.786790890934, -122.460878253711) | 11 | 6 | 1 | 54 | 11 |
| 98197 | 123608 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 121 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2018 12:00:00 AM | 19 | Width 5ft | 5995078.16732 | 2114887.75716 | 37.7867953195114 | -122.46082333969 | (37.7867953195114, -122.46082333969) | 11 | 6 | 1 | 54 | 11 | ||
| 59490 | 12529 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 105 Lake St | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 07/12/2004 12:00:00 AM | 6 | 3x3 | Permit Number 773769 | 5995136.95364 | 2114887.49287 | 37.7867979761022 | -122.460619935074 | (37.7867979761022, -122.460619935074) | 11 | 6 | 1 | 54 | 11 |
| 180340 | 208846 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 36 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995163.31564 | 2091909.32906 | 37.7237073072365 | -122.45886447242 | (37.7237073072365, -122.45886447242) | 9 | 8 | 4 | 28861 | 24 | |||
| 170390 | 203239 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 115 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781591 | 5995169.40317 | 2099688.3978 | 37.7450670773024 | -122.459406527086 | (37.7450670773024, -122.459406527086) | 1 | 8 | 4 | 59 | 40 | |
| 21538 | 123622 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 111 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995179.48554 | 2114830.2995 | 37.7866433854107 | -122.460468639914 | (37.7866433854107, -122.460468639914) | 11 | 6 | 1 | 54 | 11 | |||
| 171901 | 82180 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 105 Lake St | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773769 | 5995179.68463591 | 2114884.08050195 | 37.7867910649613 | -122.460471849521 | (37.7867910649613, -122.460471849521) | 11 | 6 | 1 | 54 | 11 | ||
| 98204 | 112522 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 195 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776238 | 5995198.14893 | 2114301.99699 | 37.7851938828924 | -122.460365776533 | (37.7851938828924, -122.460365776533) | 11 | 6 | 2 | 54 | 11 | |
| 29086 | 112523 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 195 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776238 | 5995199.36548 | 2114291.31706 | 37.7851646286632 | -122.460360793578 | (37.7851646286632, -122.460360793578) | 11 | 6 | 2 | 54 | 11 | |
| 116678 | 31977 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 134 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 7 | Permit Number 35376 | 5995230.64434 | 2114664.73917 | 37.7861917443429 | -122.460279644251 | (37.7861917443429, -122.460279644251) | 11 | 6 | 1 | 54 | 11 | |
| 73688 | 32337 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2626 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | 3 | Permit Number 36899 | 5995236.94633 | 2110306.39824 | 37.7742252654946 | -122.459942005265 | (37.7742252654946, -122.459942005265) | 11 | 6 | 2 | 54 | 11 | ||
| 148085 | 38814 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 286 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51147 | 5995268.26088 | 2113665.38834 | 37.7834499595789 | -122.460077076847 | (37.7834499595789, -122.460077076847) | 11 | 6 | 2 | 54 | 11 |
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) );