trees
575 rows where qSpecies_id = 123 sorted by Neighborhoods (old) 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) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68784 | 91130 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 218 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 52020 | 6002821.3 | 2109296.6 | 37.7718858820629 | -122.433634203014 | (37.7718858820629, -122.433634203014) | 15 | 5 | 11 | 29492 | 9 | ||
108145 | 46139 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 206 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51613 | 5998984.25754118 | 2106980.434825 | 37.7653078166494 | -122.446740070916 | (37.7653078166494, -122.446740070916) | 15 | 5 | 11 | 29492 | 9 | ||
110190 | 88738 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 218 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51672 | 6002821.3 | 2109296.6 | 37.7718858820629 | -122.433634203014 | (37.7718858820629, -122.433634203014) | 15 | 5 | 11 | 29492 | 9 | ||
2223 | 241387 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 43 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6004298.90777 | 2098020.68858 | 37.7410086185538 | -122.42771950655 | (37.7410086185538, -122.42771950655) | 2 | 7 | 5 | 63 | 7 | |||
57267 | 241390 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004068.12547 | 2098354.29911 | 37.7419115792635 | -122.428541241382 | (37.7419115792635, -122.428541241382) | 2 | 7 | 5 | 63 | 7 | |||
93244 | 86800 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 71 Miguel St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2007 12:00:00 AM | 3x3 | Permit Number 49752 | 6003860 | 2097292 | 37.7389829690297 | -122.429185143196 | (37.7389829690297, -122.429185143196) | 2 | 7 | 5 | 63 | 7 | |||
98123 | 241389 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 47 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002625.89983 | 2096003.53123 | 37.7353751906151 | -122.43336004273 | (37.7353751906151, -122.43336004273) | 2 | 7 | 5 | 63 | 7 | |||
109816 | 241388 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1769 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003420.97531 | 2097978.60034 | 37.7408433528415 | -122.430752071748 | (37.7408433528415, -122.430752071748) | 2 | 7 | 5 | 63 | 7 | |||
4814 | 72022 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 550 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6010599.26481 | 2116134.30998 | 37.7910988780658 | -122.407211626534 | (37.7910988780658, -122.407211626534) | 5 | 1 | 10 | 28857 | 6 | |||
58857 | 197005 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6015945.83282 | 2113971.21012 | 37.7854572671771 | -122.388561464349 | (37.7854572671771, -122.388561464349) | 6 | 2 | 9 | 28856 | 6 | |||
74677 | 197008 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015819.96471 | 2114109.17282 | 37.7858291053701 | -122.389006570307 | (37.7858291053701, -122.389006570307) | 6 | 2 | 9 | 28856 | 6 | |||
87499 | 197007 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6015822.85417 | 2114091.9182 | 37.7857818882589 | -122.388995368366 | (37.7857818882589, -122.388995368366) | 6 | 2 | 9 | 28856 | 6 | |||
135225 | 197004 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6015943.64363 | 2113959.00175 | 37.7854236244348 | -122.388568185881 | (37.7854236244348, -122.388568185881) | 6 | 2 | 9 | 28856 | 6 | |||
149145 | 197006 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6015876.10983 | 2114035.38454 | 37.7856296114719 | -122.388807169036 | (37.7856296114719, -122.388807169036) | 6 | 2 | 9 | 28856 | 6 | |||
184093 | 197003 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6015964.6605 | 2113962.87673 | 37.7854354289412 | -122.38849574371 | (37.7854354289412, -122.38849574371) | 6 | 2 | 9 | 28856 | 6 | |||
599 | 78256 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 754 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6002680.72455 | 2088998.08405 | 37.7161429170478 | -122.432670234864 | (37.7161429170478, -122.432670234864) | 9 | 7 | 6 | 28861 | 5 | |||
13645 | 70110 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 79 Stoneyford Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6006114.15907 | 2093862.38939 | 37.7296933683514 | -122.421147824905 | (37.7296933683514, -122.421147824905) | 9 | 7 | 7 | 28861 | 5 | |||
16550 | 88330 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 544 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51318 | 6001416.8 | 2090660.3 | 37.7206352284922 | -122.437157897339 | (37.7206352284922, -122.437157897339) | 9 | 7 | 6 | 28861 | 5 | |||
51900 | 40680 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 227 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 11 | Permit Number 41663 | 6004891.01488 | 2093810.36977 | 37.7294815042584 | -122.425372669006 | (37.7294815042584, -122.425372669006) | 9 | 7 | 6 | 28861 | 5 | |
86529 | 179278 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 223 Pioche St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006228.66725 | 2093396.90262 | 37.7284216981869 | -122.420718924746 | (37.7284216981869, -122.420718924746) | 9 | 7 | 7 | 309 | 5 | |||
88850 | 88346 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 351 Vienna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51331 | 6003903 | 2091384 | 37.7227633616233 | -122.428615443614 | (37.7227633616233, -122.428615443614) | 9 | 7 | 6 | 28861 | 5 | |||
91782 | 88337 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 686 Naples St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51324 | 6002465 | 2089669 | 37.7179728672328 | -122.433463798527 | (37.7179728672328, -122.433463798527) | 9 | 7 | 6 | 28861 | 5 | |||
118233 | 179275 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 716 Peru Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005245.16074 | 2092477.21394 | 37.7258409541933 | -122.424053582122 | (37.7258409541933, -122.424053582122) | 9 | 7 | 6 | 309 | 5 | |||
170652 | 179279 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 223 Pioche St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6006275.12702 | 2093408.77207 | 37.7284569075468 | -122.420559152977 | (37.7284569075468, -122.420559152977) | 9 | 7 | 7 | 309 | 5 | |||
171562 | 88315 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 157 Edinburg St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51306 | 6004192.4 | 2092727.9 | 37.7264697879052 | -122.427710754996 | (37.7264697879052, -122.427710754996) | 9 | 7 | 6 | 28861 | 5 | |||
172506 | 88317 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 670 Edinburg St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51308 | 6002238.5 | 2089937.8 | 37.7186980790536 | -122.434265915388 | (37.7186980790536, -122.434265915388) | 9 | 7 | 6 | 28861 | 5 | |||
178993 | 179276 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 716 Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6005258.78381 | 2092467.95462 | 37.7258162992748 | -122.424005829932 | (37.7258162992748, -122.424005829932) | 9 | 7 | 6 | 309 | 5 | |||
193441 | 179277 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 716 Peru Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6005276.23831 | 2092458.42558 | 37.7257911200544 | -122.423944813618 | (37.7257911200544, -122.423944813618) | 9 | 7 | 6 | 309 | 5 | |||
43779 | 89201 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1627 McAllister St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51818 | 6001371 | 2111438 | 37.7776832317385 | -122.438804361006 | (37.7776832317385, -122.438804361006) | 15 | 5 | 11 | 29492 | 41 | |||
27312 | 88136 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 321 Los Palmos Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51162 | 5997690 | 2096237 | 37.7357349780848 | -122.450442028597 | (37.7357349780848, -122.450442028597) | 9 | 7 | 4 | 59 | 40 | |||
39809 | 88509 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
40738 | 100424 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
47581 | 88507 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
60226 | 100425 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
60418 | 88523 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 10 Valdez Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51454 | 5996417 | 2093827.6 | 37.7290464055545 | -122.454669245202 | (37.7290464055545, -122.454669245202) | 9 | 7 | 4 | 28861 | 40 | |||
66880 | 88511 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
71898 | 88508 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
96159 | 88510 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
121788 | 213854 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 494 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5998170.4747 | 2095280.37565 | 37.7331358031646 | -122.448711968308 | (37.7331358031646, -122.448711968308) | 9 | 7 | 4 | 59 | 40 | ||||
140091 | 88138 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 181 Marietta Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51166 | 5998804 | 2097893 | 37.7403456543781 | -122.446709627058 | (37.7403456543781, -122.446709627058) | 9 | 7 | 4 | 59 | 40 | |||
180009 | 88506 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | |||
26140 | 136187 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 840 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010038.55828 | 2116686.60963 | 37.7925839636381 | -122.409190650353 | (37.7925839636381, -122.409190650353) | 3 | 1 | 10 | 28857 | 4 | |||
31987 | 39269 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1998 12:00:00 AM | 5 | Permit Number 40882 | 6010051.67469 | 2116602.92631 | 37.7923549243012 | -122.409139359294 | (37.7923549243012, -122.409139359294) | 3 | 1 | 10 | 28857 | 4 | |
39352 | 136186 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010043.14101 | 2116645.97985 | 37.7924726608324 | -122.40917192557 | (37.7924726608324, -122.40917192557) | 3 | 1 | 10 | 28857 | 4 | |||
45296 | 38903 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1998 12:00:00 AM | 3 | Permit Number 40882 | 6010050.21943 | 2116612.32864 | 37.7923806592989 | -122.409145058308 | (37.7923806592989, -122.409145058308) | 3 | 1 | 10 | 28857 | 4 | |
92775 | 136185 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010045.72464 | 2116634.21167 | 37.7924404929984 | -122.409162155311 | (37.7924404929984, -122.409162155311) | 3 | 1 | 10 | 28857 | 4 | |||
96568 | 88524 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 840 Powell St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51456 | 6010045 | 2116631 | 37.7924316339339 | -122.409164435867 | (37.7924316339339, -122.409164435867) | 3 | 1 | 10 | 28857 | 4 | |||
147702 | 38904 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 6 | Permit Number 40717 | 6010047.86641 | 2116623.85793 | 37.7924121841197 | -122.409154013767 | (37.7924121841197, -122.409154013767) | 3 | 1 | 10 | 28857 | 4 | |
182003 | 39270 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1998 12:00:00 AM | 3 | Permit Number 40882 | 6010056.25648 | 2116573.77784 | 37.7922751463304 | -122.409121448409 | (37.7922751463304, -122.409121448409) | 3 | 1 | 10 | 28857 | 4 | |
47551 | 84204 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
61889 | 84203 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
80433 | 84200 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
125579 | 62067 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 240 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50979 | 6009906.39574025 | 2087592.17070432 | 37.7126897048858 | -122.40759567922 | (37.7126897048858, -122.40759567922) | 9 | 7 | 8 | 309 | 39 | ||
145828 | 84205 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
152881 | 84199 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
161073 | 84202 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
164480 | 84201 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
172942 | 84198 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
22375 | 87991 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 222 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51029 | 6008096 | 2113166 | 37.7828082078679 | -122.41566260373 | (37.7828082078679, -122.41566260373) | 7 | 10 | 9 | 28852 | 36 | ||
31101 | 88015 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 77 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51043 | 6008723.4 | 2112463.6 | 37.780914833514 | -122.413442364822 | (37.780914833514, -122.413442364822) | 7 | 10 | 9 | 28852 | 36 | ||
55308 | 88011 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 144 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51041 | 6008609 | 2112967 | 37.7822906254359 | -122.413873752004 | (37.7822906254359, -122.413873752004) | 7 | 10 | 9 | 28852 | 36 | ||
61643 | 88017 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 601 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51044 | 6008420 | 2114150 | 37.7855282422492 | -122.414611351671 | (37.7855282422492, -122.414611351671) | 7 | 10 | 9 | 28852 | 36 | ||
65987 | 87988 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 233 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51028 | 6009741 | 2113986 | 37.785152065252 | -122.410029478455 | (37.785152065252, -122.410029478455) | 14 | 10 | 9 | 28852 | 36 | ||
66669 | 88027 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 121 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51050 | 6008492.3 | 2112899.8 | 37.7820995557553 | -122.414272727386 | (37.7820995557553, -122.414272727386) | 7 | 10 | 9 | 28852 | 36 | ||
87658 | 87989 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 233 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51028 | 6009741 | 2113986 | 37.785152065252 | -122.410029478455 | (37.785152065252, -122.410029478455) | 14 | 10 | 9 | 28852 | 36 | ||
88344 | 87993 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 248 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51031 | 6008142.6 | 2113255.6 | 37.7830568472778 | -122.415507732402 | (37.7830568472778, -122.415507732402) | 7 | 10 | 9 | 28852 | 36 | ||
92525 | 88014 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 77 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51043 | 6008723.4 | 2112463.6 | 37.780914833514 | -122.413442364822 | (37.780914833514, -122.413442364822) | 7 | 10 | 9 | 28852 | 36 | ||
99310 | 87994 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 248 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51031 | 6008142.6 | 2113255.6 | 37.7830568472778 | -122.415507732402 | (37.7830568472778, -122.415507732402) | 7 | 10 | 9 | 28852 | 36 | ||
110478 | 88010 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 301 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51039 | 6008988 | 2113534 | 37.7838687491965 | -122.412602670053 | (37.7838687491965, -122.412602670053) | 7 | 10 | 9 | 28852 | 36 | ||
119445 | 87990 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 233 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51028 | 6009741 | 2113986 | 37.785152065252 | -122.410029478455 | (37.785152065252, -122.410029478455) | 14 | 10 | 9 | 28852 | 36 | ||
132824 | 88009 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 360 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51038 | 6008030 | 2113635 | 37.7840922583142 | -122.415924158968 | (37.7840922583142, -122.415924158968) | 7 | 10 | 9 | 28858 | 36 | ||
146243 | 88019 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 926 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51046 | 6007429 | 2114473 | 37.7863593952456 | -122.418062835651 | (37.7863593952456, -122.418062835651) | 13 | 9 | 9 | 28858 | 36 | ||
155593 | 87995 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 120 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51032 | 6009094.1 | 2112956.3 | 37.7822884772374 | -122.412194758861 | (37.7822884772374, -122.412194758861) | 14 | 10 | 9 | 28852 | 36 | ||
174823 | 88016 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 77 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51043 | 6008723.4 | 2112463.6 | 37.780914833514 | -122.413442364822 | (37.780914833514, -122.413442364822) | 7 | 10 | 9 | 28852 | 36 | ||
9813 | 201661 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 149 Dore St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6009207.44548 | 2109499.94346 | 37.7728044975557 | -122.411558355748 | (37.7728044975557, -122.411558355748) | 8 | 2 | 9 | 28853 | 34 | |||
49759 | 88162 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 365 Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51185 | 6011732.3 | 2112447.5 | 37.7810391100489 | -122.40303190845 | (37.7810391100489, -122.40303190845) | 6 | 2 | 9 | 28853 | 34 | |||
119219 | 88203 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 436 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51208 | 6011221 | 2112104 | 37.7800673738175 | -122.40477656867 | (37.7800673738175, -122.40477656867) | 14 | 2 | 9 | 28853 | 34 | ||
120740 | 88157 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 353 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51181 | 6011830.6 | 2112533.5 | 37.7812807348582 | -122.402697887639 | (37.7812807348582, -122.402697887639) | 6 | 2 | 9 | 28853 | 34 | ||
150797 | 88158 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 353 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51181 | 6011830.6 | 2112533.5 | 37.7812807348582 | -122.402697887639 | (37.7812807348582, -122.402697887639) | 6 | 2 | 9 | 28853 | 34 | ||
161656 | 88185 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 493 Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51192 | 6010910.3 | 2111721.3 | 37.7789991980081 | -122.405824460674 | (37.7789991980081, -122.405824460674) | 14 | 2 | 9 | 28853 | 34 | |||
176344 | 88191 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 355 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51196 | 6011553 | 2112651 | 37.7815878594503 | -122.403666522452 | (37.7815878594503, -122.403666522452) | 6 | 2 | 9 | 28853 | 34 | |||
39664 | 94083 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1355 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53468 | 6007661.58372 | 2117803.95708 | 37.7955184712527 | -122.41749431113 | (37.7955184712527, -122.41749431113) | 5 | 1 | 10 | 28858 | 32 | |
46530 | 136183 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006523.02231 | 2120459.93681 | 37.8027469916359 | -122.421622667864 | (37.8027469916359, -122.421622667864) | 5 | 9 | 1 | 28858 | 32 | |||
71899 | 136184 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006503.30451 | 2120455.88239 | 37.8027347473741 | -122.421690613452 | (37.8027347473741, -122.421690613452) | 5 | 9 | 1 | 28858 | 32 | |||
110684 | 94081 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1355 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53468 | 6007606.52221 | 2117796.21393 | 37.7954941122185 | -122.417684284801 | (37.7954941122185, -122.417684284801) | 5 | 1 | 10 | 28858 | 32 | |
163999 | 94082 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1355 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53468 | 6007647.44648 | 2117801.56463 | 37.7955111067173 | -122.41754305889 | (37.7955111067173, -122.41754305889) | 5 | 1 | 10 | 28858 | 32 | |
173251 | 86867 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1386 Pacific Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49799 | 6007535 | 2117833.1 | 37.7955913672303 | -122.417934380535 | (37.7955913672303, -122.417934380535) | 5 | 1 | 10 | 28858 | 32 | |||
66671 | 38887 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 316 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998129.65961 | 2115308.75845 | 37.7881263812657 | -122.450296300351 | (37.7881263812657, -122.450296300351) | 13 | 6 | 1 | 54 | 31 | |
144038 | 38888 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 316 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998132.12011 | 2115294.26521 | 37.7880867274765 | -122.45028674235 | (37.7880867274765, -122.45028674235) | 13 | 6 | 1 | 54 | 31 | |
4885 | 71351 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 118 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2008 12:00:00 AM | 3x3 | Permit Number 50915 | 5999898.11886666 | 2105092.21291824 | 37.7601753897516 | -122.44344360556 | (37.7601753897516, -122.44344360556) | 2 | 4 | 5 | 28862 | 3 | ||
133896 | 87939 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4489 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50962 | 5999451 | 2105708 | 37.7618406796867 | -122.445034241655 | (37.7618406796867, -122.445034241655) | 15 | 5 | 5 | 28862 | 3 | ||
145915 | 62429 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4475 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50961 | 5999555.98449793 | 2105708.06247977 | 37.7618468426508 | -122.444671147653 | (37.7618468426508, -122.444671147653) | 15 | 5 | 5 | 28862 | 3 | ||
925 | 34964 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2019 12:00:00 AM | 3 | Permit Number 38553 | 6014444.74274 | 2102850.73033 | 37.7548395926778 | -122.392976501569 | (37.7548395926778, -122.392976501569) | 10 | 3 | 8 | 28856 | 29 | ||
4053 | 196973 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2019 12:00:00 AM | 3 | Width 4ft | 6014457.83967 | 2102608.37301 | 37.7541748588033 | -122.392914253189 | (37.7541748588033, -122.392914253189) | 10 | 3 | 8 | 28856 | 29 | ||
7828 | 196969 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015866.24342 | 2105844.60301 | 37.763138987107 | -122.388269449981 | (37.763138987107, -122.388269449981) | 14 | 3 | 8 | 28856 | 29 | |||
9715 | 196963 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015947.26389 | 2105849.11258 | 37.7631558583726 | -122.387989539601 | (37.7631558583726, -122.387989539601) | 14 | 3 | 8 | 28856 | 29 | |||
14984 | 68126 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1331 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 8 | Permit Number 31876 | 6013566.56944 | 2105672.60835 | 37.7625390358578 | -122.396211251447 | (37.7625390358578, -122.396211251447) | 14 | 3 | 8 | 28856 | 29 | |
17382 | 35346 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1124 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 8 | Permit Number 38809 | 6012181.54645 | 2103168.5427 | 37.7555862611206 | -122.400825637793 | (37.7555862611206, -122.400825637793) | 10 | 3 | 8 | 28856 | 29 | |
20176 | 196977 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 209 Mississippi St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014040.95878 | 2106120.30389 | 37.7637946944947 | -122.394601850808 | (37.7637946944947, -122.394601850808) | 14 | 3 | 8 | 28856 | 29 | |||
39500 | 32941 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1546 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 12 | Permit Number 37260 | 6013066.21805 | 2105223.63069 | 37.7612783887065 | -122.397910300117 | (37.7612783887065, -122.397910300117) | 10 | 3 | 8 | 28856 | 29 |
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) );