trees
439 rows where qSpecies_id = 148 sorted by PermitNotes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
159637 | 123676 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4620 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782655 | 5993209.68387 | 2114188.73207 | 37.7847683024995 | -122.467236954218 | (37.7847683024995, -122.467236954218) | 11 | 6 | 2 | 54 | 11 | |
14247 | 256666 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1406 California St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782597 | |||||||||||
126905 | 243200 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 220 Valencia St | 1 | : | Tree | Private 2 | 05/08/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781817 | 6006037.36793 | 2108352.33176 | 37.7694751030168 | -122.422442472745 | (37.7694751030168, -122.422442472745) | 8 | 4 | 5 | 28853 | 19 | |
51452 | 2624 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1822 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781445 | 6004615.6699 | 2115060.0567 | 37.7878125608959 | -122.427838089219 | (37.7878125608959, -122.427838089219) | 13 | 9 | 11 | 28858 | 27 | |
66342 | 14084 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1411 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2015 12:00:00 AM | 3 | 4X4 | Permit Number 775519 | 6007340.8551319 | 2110667.3761307 | 37.7759051108463 | -122.418097899429 | (37.7759051108463, -122.418097899429) | 8 | 2 | 9 | 28853 | 34 | |
25067 | 91795 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 500x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | Permit Number 775014 | 6014662.1325 | 2114223.547757 | 37.7860789052247 | -122.39302038306 | (37.7860789052247, -122.39302038306) | 6 | 2 | 9 | 28855 | 6 | |
156677 | 91796 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 500x Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | Permit Number 775014 | 6014662.1325 | 2114223.547757 | 37.7860789052247 | -122.39302038306 | (37.7860789052247, -122.39302038306) | 6 | 2 | 9 | 28855 | 6 | |
121259 | 78666 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 600X Bowdoin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008870.67132607 | 2093251.69361296 | 37.7281715390597 | -122.411575098353 | (37.7281715390597, -122.411575098353) | 9 | 3 | 7 | 309 | 28 | |
126438 | 62108 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 295 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773730 | 6006765.73996863 | 2102077.12480026 | 37.7522859081758 | -122.419477800449 | (37.7522859081758, -122.419477800449) | 2 | 4 | 7 | 28859 | 19 |
82500 | 112842 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 604 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2015 12:00:00 AM | Permit Number 773221 | 5992274.9 | 2111288.5 | 37.7767510524606 | -122.470259695975 | (37.7767510524606, -122.470259695975) | 11 | 6 | 2 | 54 | 11 | |||
161659 | 25176 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3066 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2006 12:00:00 AM | 3 | 3X3 | Permit Number 772743 | 6000144.4461106 | 2105441.7794376 | 37.7611492576992 | -122.442616778303 | (37.7611492576992, -122.442616778303) | 15 | 5 | 5 | 28862 | 3 | |
58720 | 109763 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 899 VALENCIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | 2 | 4 | 7 | 28859 | 19 | ||
152875 | 109765 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 899 VALENCIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | 2 | 4 | 7 | 28859 | 19 | ||
159509 | 109761 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 899 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | 2 | 4 | 7 | 28859 | 19 | |
171013 | 109764 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 899 VALENCIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | 2 | 4 | 7 | 28859 | 19 | ||
179065 | 109766 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 899 VALENCIA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | 2 | 4 | 7 | 28859 | 19 | ||
28286 | 26876 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 275 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2014 12:00:00 AM | 20 | 3X3 | Permit Number 771536 | 6006101 | 2108089 | 37.7687556461675 | -122.422203660432 | (37.7687556461675, -122.422203660432) | 8 | 4 | 7 | 28853 | 19 | |
43112 | 26878 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 275 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | Permit Number 771536 | 6006101 | 2108089 | 37.7687556461675 | -122.422203660432 | (37.7687556461675, -122.422203660432) | 8 | 4 | 7 | 28853 | 19 | ||
93711 | 26877 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 275 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 771536 | 6006101 | 2108089 | 37.7687556461675 | -122.422203660432 | (37.7687556461675, -122.422203660432) | 8 | 4 | 7 | 28853 | 19 | ||
128801 | 106964 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 275 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 771536 | 6006216.68747 | 2108092.23656 | 37.7687710576512 | -122.421803735394 | (37.7687710576512, -122.421803735394) | 8 | 4 | 7 | 28853 | 19 | ||||
109025 | 105854 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3440 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2014 12:00:00 AM | 3x3 | Permit Number 771130 | 5998402.1 | 2115236.7 | 37.7879441154945 | -122.449348514051 | (37.7879441154945, -122.449348514051) | 13 | 6 | 1 | 54 | 31 | ||
14266 | 104341 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 953 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2013 12:00:00 AM | 3x3 | Permit Number 770725 | 6015057.1 | 2104275.7 | 37.7587862506702 | -122.390958369803 | (37.7587862506702, -122.390958369803) | 10 | 3 | 8 | 28856 | 29 | ||
32478 | 102160 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4300X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 |
53422 | 84564 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
58214 | 102158 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4300X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 |
79199 | 84561 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1095X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) | 2 | 4 | 5 | 28862 | 22 |
95087 | 84562 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
98801 | 84560 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1095X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) | 2 | 4 | 5 | 28862 | 22 |
111204 | 102122 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1090X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) | 2 | 4 | 5 | 28862 | 22 |
131308 | 102123 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1090X Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) | 2 | 4 | 5 | 28862 | 22 |
135140 | 84557 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1111X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.7515016484692 | -122.429618577466 | (37.7515016484692, -122.429618577466) | 2 | 4 | 5 | 28862 | 22 |
166295 | 102121 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1090X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) | 2 | 4 | 5 | 28862 | 22 |
168283 | 84563 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
180891 | 84558 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1111X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.7515016484692 | -122.429618577466 | (37.7515016484692, -122.429618577466) | 2 | 4 | 5 | 28862 | 22 |
189664 | 59740 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4301 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | Permit Number 769743 | 6001257.45272634 | 2101704.38356178 | 37.7509506561918 | -122.438499588668 | (37.7509506561918, -122.438499588668) | 2 | 4 | 5 | 28862 | 22 | ||
114609 | 101514 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 240X DRUMM ST | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11/30/2012 12:00:00 AM | 3x3 | Permit Number 769442 | 6013870 | 2117910 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | 3 | 1 | 10 | 28860 | 6 | ||
88068 | 27805 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350X The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 11/15/2012 12:00:00 AM | 12 | 4x4 | Permit Number 769363 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | |
134560 | 101923 | Section 143 10 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1401X California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 3x3 | Permit Number 769132 | 6007402.7 | 2116063.9 | 37.7907261358602 | -122.418266664095 | (37.7907261358602, -122.418266664095) | 13 | 1 | 10 | 28858 | 21 | ||
32018 | 14183 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1844 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2012 12:00:00 AM | 12 | 4X4 | Permit Number 769087 | 6005554.6579568 | 2109080.5883488 | 37.7714474783148 | -122.424163948162 | (37.7714474783148, -122.424163948162) | 7 | 2 | 5 | 28852 | 10 | |
100838 | 14187 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1844 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2012 12:00:00 AM | 18 | 4X4 | Permit Number 769087 | 6005518.4692831 | 2109046.2188948 | 37.7713510647017 | -122.424286681889 | (37.7713510647017, -122.424286681889) | 7 | 2 | 5 | 28852 | 10 | |
27805 | 49020 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 507 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013774.69039299 | 2115066.5155164 | 37.7883441634439 | -122.396149816377 | (37.7883441634439, -122.396149816377) | 6 | 2 | 9 | 28855 | 6 | |||
130584 | 49022 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 507 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013774.69039299 | 2115066.5155164 | 37.7883441634439 | -122.396149816377 | (37.7883441634439, -122.396149816377) | 6 | 2 | 9 | 28855 | 6 | |||
145061 | 49021 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 507 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013774.69039299 | 2115066.5155164 | 37.7883441634439 | -122.396149816377 | (37.7883441634439, -122.396149816377) | 6 | 2 | 9 | 28855 | 6 | |||
146745 | 49019 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 507 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013774.69039299 | 2115066.5155164 | 37.7883441634439 | -122.396149816377 | (37.7883441634439, -122.396149816377) | 6 | 2 | 9 | 28855 | 6 | |||
165577 | 100715 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 507 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013735 | 2115044 | 37.7882801326001 | -122.396285560985 | (37.7882801326001, -122.396285560985) | 6 | 2 | 9 | 28855 | 6 | |||
119087 | 101070 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3018 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768630 | 5999883.5 | 2115123.7 | 37.7877184733225 | -122.444215032048 | (37.7877184733225, -122.444215032048) | 13 | 6 | 1 | 29490 | 27 | |
23054 | 104167 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 | ||
146391 | 104166 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 | ||
159490 | 104165 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 | ||
192322 | 104164 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 | ||
61145 | 97531 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
66289 | 97530 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
71851 | 97533 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
98088 | 97532 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
127325 | 97529 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
2426 | 100409 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
32661 | 100407 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
39543 | 70859 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1995 12:00:00 AM | Permit Number 767727 | 6006431.93006457 | 2110802.5343302 | 37.7762250224845 | -122.421251711265 | (37.7762250224845, -122.421251711265) | 7 | 9 | 11 | 28852 | 10 | |||
138619 | 100408 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
125923 | 94527 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1545 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2010 12:00:00 AM | Permit Number 53714 | 6001163 | 2113666 | 37.7837889169409 | -122.439683671841 | (37.7837889169409, -122.439683671841) | 15 | 6 | 11 | 29490 | 13 | |||
39100 | 92566 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 222 Stanyan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | |||
119568 | 92087 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 710 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52197 | 6010351 | 2116200 | 37.7912653498297 | -122.408075252992 | (37.7912653498297, -122.408075252992) | 5 | 1 | 10 | 28857 | 21 | |||
32839 | 91205 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
33990 | 91343 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
51107 | 91344 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
75983 | 91335 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
87123 | 91336 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
105085 | 91204 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
182507 | 53296 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4124 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50423 | 6002335.15488349 | 2102402.29787451 | 37.7529282071332 | -122.434822699235 | (37.7529282071332, -122.434822699235) | 2 | 4 | 5 | 28862 | 22 | ||
81477 | 86693 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1355 Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2007 12:00:00 AM | Permit Number 49693 | 6007704.191622 | 2111021.854521 | 37.7768988673684 | -122.416866141309 | (37.7768988673684, -122.416866141309) | 8 | 2 | 9 | 28853 | 34 | |||
37390 | 41431 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 352-360 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2005 12:00:00 AM | Permit Number 42039 | 6011197 | 2111276 | 37.7777925370097 | -122.404801285962 | (37.7777925370097, -122.404801285962) | 14 | 2 | 9 | 28853 | 34 | |||
20292 | 41297 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 135 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2000 12:00:00 AM | 18 | Permit Number 41974 | 6006066.97178257 | 2108901.70025465 | 37.770985207585 | -122.422379113504 | (37.770985207585, -122.422379113504) | 8 | 2 | 9 | 28853 | 19 | ||
866 | 28332 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3247 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 9 | 3x3 | 6006498.83651 | 2099346.51324 | 37.74477323292 | -122.420207017141 | (37.74477323292, -122.420207017141) | 2 | 7 | 7 | 28859 | 2 | ||
920 | 91853 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 601x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6014039.760938 | 2113573.418065 | 37.7842592071543 | -122.395128082808 | (37.7842592071543, -122.395128082808) | 6 | 2 | 9 | 28856 | 6 | ||
1735 | 28503 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 270 06th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/2013 12:00:00 AM | 3 | 3x3 | 6010824.2979387 | 2111653.7211901 | 37.7788088323978 | -122.406117215604 | (37.7788088323978, -122.406117215604) | 14 | 2 | 9 | 28853 | 34 | ||
1742 | 28048 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
2658 | 91806 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2945 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009025.873084 | 2101313.36822 | 37.7503158463726 | -122.411607913685 | (37.7503158463726, -122.411607913685) | 2 | 4 | 7 | 28859 | 19 | |||
2703 | 2795 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 6530X California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 75 | 5 | 5987349.71414 | 2113973.97564 | 37.783838627391 | -122.487494476151 | (37.783838627391, -122.487494476151) | 11 | 6 | 1 | 55 | 33 | |||
7301 | 172637 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1675 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2013 12:00:00 AM | 3 | Width 3ft | 6006387.36369 | 2115949.63382 | 37.790355184582 | -122.421771561426 | (37.790355184582, -122.421771561426) | 13 | 9 | 10 | 28858 | 21 | ||
7309 | 14032 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1245 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2012 12:00:00 AM | 3 | 4X4 | 6008153.5614441 | 2111445.1787375 | 37.7780864807987 | -122.415341604846 | (37.7780864807987, -122.415341604846) | 8 | 2 | 9 | 28853 | 34 | ||
8152 | 116289 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009504.70132 | 2120333.42493 | 37.8025672995432 | -122.41129555893 | (37.8025672995432, -122.41129555893) | 3 | 1 | 10 | 308 | 23 | |||||
9094 | 91830 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1849 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008677.188747 | 2107760.243317 | 37.7679979296822 | -122.413269533592 | (37.7679979296822, -122.413269533592) | 8 | 4 | 7 | 28853 | 19 | ||
9221 | 28049 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
9581 | 28011 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014191.95801 | 2117739.78401 | 37.795707543335 | -122.394893427962 | (37.795707543335, -122.394893427962) | 4 | 2 | 10 | 28860 | 6 | ||
9814 | 28339 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3125 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6007038.71469 | 2100348.34949 | 37.7475544551381 | -122.418411239379 | (37.7475544551381, -122.418411239379) | 2 | 7 | 7 | 28859 | 2 | ||
9871 | 91779 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1184 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6010158.993686 | 2109919.902048 | 37.7740109351691 | -122.408296453122 | (37.7740109351691, -122.408296453122) | 8 | 2 | 9 | 28853 | 34 | ||
11651 | 28006 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014086.70601 | 2117927.50101 | 37.7962171170916 | -122.395270777766 | (37.7962171170916, -122.395270777766) | 3 | 2 | 10 | 28860 | 6 | ||
15454 | 28326 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3284 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006311.45985 | 2099177.31377 | 37.7442980895932 | -122.420842920924 | (37.7442980895932, -122.420842920924) | 2 | 7 | 7 | 28859 | 2 | ||
16561 | 3199 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3700X California St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/31/2017 11:41:00 AM | 3 | 3X3 | 5996731.2206933 | 2114663.0950297 | 37.7862734316129 | -122.455087955232 | (37.7862734316129, -122.455087955232) | 11 | 6 | 1 | 54 | 31 | ||
16919 | 27303 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4339 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 5994091.63002 | 2114139.77761 | 37.7846847585801 | -122.464182179248 | (37.7846847585801, -122.464182179248) | 11 | 6 | 2 | 54 | 11 | |||
18997 | 146023 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 211 Cornwall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5994760.92974 | 2114191.03867 | 37.7848640608675 | -122.46187036015 | (37.7848640608675, -122.46187036015) | 11 | 6 | 2 | 54 | 11 | |||
19838 | 207 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2919 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/1994 12:00:00 AM | 20 | 2X3 | 5990501.92231 | 2095794.16798 | 37.7341050531518 | -122.47526143143 | (37.7341050531518, -122.47526143143) | 1 | 8 | 4 | 64 | 35 | ||
19974 | 28151 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
20062 | 97792 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 150X Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995458 | 2088095 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | 9 | 8 | 6 | 28861 | 24 | ||||
20337 | 28014 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014226.68001 | 2117656.23301 | 37.7954800625202 | -122.394767428538 | (37.7954800625202, -122.394767428538) | 4 | 2 | 10 | 28860 | 6 | ||
21126 | 27305 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4405 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5993893.05463 | 2114093.73932 | 37.7845469027899 | -122.464865833974 | (37.7845469027899, -122.464865833974) | 11 | 6 | 2 | 54 | 11 | |||
21275 | 13852 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 989 Market St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.409935404775 | (37.7823576258181, -122.409935404775) | 14 | 2 | 9 | 28853 | 34 | |||
21517 | 27259 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 690 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006717.7455722 | 2112795.3484565 | 37.7817129170403 | -122.420404476934 | (37.7817129170403, -122.420404476934) | 7 | 9 | 9 | 28852 | 36 | |||
23271 | 91828 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1941 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008705.970676 | 2107189.131 | 37.7664314036014 | -122.413129591178 | (37.7664314036014, -122.413129591178) | 8 | 4 | 7 | 28853 | 19 | ||
23858 | 85447 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y13 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 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) );