trees
1,013 rows where qSpecies_id = 42 sorted by qLegalStatus_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22075 | 187658 | Property Tree 8 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 600X Clarendon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995637 | 2102382 | 37.7524899085688 | -122.457984564932 | (37.7524899085688, -122.457984564932) | 1 | 5 | 4 | 63 | 12 | ||||
183366 | 251343 | Property Tree 8 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 934 Brannan St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010724 | 2108745 | 37.7708165471861 | -122.406259194073 | (37.7708165471861, -122.406259194073) | 14 | 2 | 9 | 28853 | 34 | ||||
7145 | 206261 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 57 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 13 | Width 3ft | Permit Number 42423 | 5999614.39843 | 2093757.95077 | 37.729038042256 | -122.443610625157 | (37.729038042256, -122.443610625157) | 9 | 7 | 4 | 63 | 40 | |
8794 | 42966 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 160 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2000 12:00:00 AM | Permit Number 42854 | 5997814.60948514 | 2104925.35351079 | 37.7595981967984 | -122.45063741216 | (37.7595981967984, -122.45063741216) | 15 | 5 | 11 | 29492 | 12 | |||
14476 | 105974 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1336 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 771235 | 6006462.9 | 2119771 | 37.8008519560253 | -122.421781757787 | (37.8008519560253, -122.421781757787) | 13 | 9 | 1 | 28858 | 32 | ||||
15101 | 38685 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1785 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1998 12:00:00 AM | Permit Number 40599 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | 15 | 5 | 11 | 29492 | 16 | |||
15434 | 209153 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2055 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/26/2004 12:00:00 AM | 10 | Width 3ft | Permit Number 47392 | 5991594.69528 | 2101440.30789 | 37.7496711879902 | -122.471894774741 | (37.7496711879902, -122.471894774741) | 1 | 8 | 4 | 29491 | 12 | |
28440 | 46586 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 498 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/2002 12:00:00 AM | Permit Number 44715 | 6005498.22104123 | 2100816.59479858 | 37.7487533087047 | -122.423771466824 | (37.7487533087047, -122.423771466824) | 2 | 4 | 5 | 28859 | 19 | ||
29400 | 57737 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 373 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1976 12:00:00 AM | 16 | 3x3 | Permit Number 16655 | 6005509.467345 | 2101546.81860372 | 37.75075897011 | -122.423784491996 | (37.75075897011, -122.423784491996) | 2 | 4 | 5 | 28859 | 19 | |
31358 | 42182 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 715 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42466 | 6012416.63723338 | 2111137.79713862 | 37.7774811588558 | -122.400572401541 | (37.7774811588558, -122.400572401541) | 14 | 2 | 9 | 28856 | 34 | ||
32534 | 41716 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 543 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44133 | 6008753.21337376 | 2096281.65864333 | 37.7364845820076 | -122.412195213265 | (37.7364845820076, -122.412195213265) | 10 | 7 | 7 | 28859 | 2 | ||
35522 | 36702 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3698x 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005001.97582164 | 2104885.80884876 | 37.7598983948026 | -122.425777079422 | (37.7598983948026, -122.425777079422) | 2 | 4 | 5 | 28859 | 19 | ||
36449 | 11208 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1001X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | 10 | 3 | 8 | 58 | 1 | |||
39446 | 42223 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 661 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | 6 | 2 | 9 | 28853 | 6 | ||
40573 | 12056 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
45639 | 36705 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3690x 19TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005025.9 | 2104880.3 | 37.7598846207262 | -122.425693945182 | (37.7598846207262, -122.425693945182) | 2 | 4 | 5 | 28859 | 19 | ||
45983 | 12055 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1300X La Salle Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | |||
48497 | 68817 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 125 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2007 12:00:00 AM | Permit Number 49379 | 6000058.92001633 | 2094143.32486819 | 37.7301215326631 | -122.442101535638 | (37.7301215326631, -122.442101535638) | 9 | 7 | 4 | 63 | 40 | ||
50519 | 55370 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 177 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2011 12:00:00 AM | 2x3 | Permit Number 767959 | 5993373.59500695 | 2094436.22943113 | 37.7305425193622 | -122.465234638195 | (37.7305425193622, -122.465234638195) | 9 | 8 | 4 | 59 | 40 | ||
52868 | 49746 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 40@ LELAND Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46545 | 6008551.24165341 | 2087877.47374564 | 37.7133971377495 | -122.412299691068 | (37.7133971377495, -122.412299691068) | 9 | 7 | 8 | 309 | 39 | ||
53612 | 42222 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 661 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | 6 | 2 | 9 | 28853 | 6 | ||
54000 | 50882 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2055 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47392 | 5991593.93786831 | 2101441.81632133 | 37.7496752859252 | -122.471897503797 | (37.7496752859252, -122.471897503797) | 1 | 8 | 4 | 29491 | 12 | ||
54164 | 39617 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 143 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1998 12:00:00 AM | Permit Number 41017 | 5997752.15145133 | 2106762.51515119 | 37.7646390036764 | -122.45098590005 | (37.7646390036764, -122.45098590005) | 15 | 5 | 11 | 29492 | 9 | |||
55158 | 46916 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 161 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2013 12:00:00 AM | Permit Number 769519 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.417122358052 | (37.7377931534639, -122.417122358052) | 2 | 7 | 7 | 28859 | 2 | ||
59638 | 111303 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3690x 19TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005025.9 | 2104880.3 | 37.7598846207262 | -122.425693945182 | (37.7598846207262, -122.425693945182) | 2 | 4 | 5 | 28859 | 19 | ||||
62194 | 73475 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 340 Ritch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2008 12:00:00 AM | 3x3 | Permit Number 50288 | 6014252.15043428 | 2111690.62627274 | 37.7791012985319 | -122.394261419296 | (37.7791012985319, -122.394261419296) | 6 | 2 | 9 | 28856 | 34 | ||
62920 | 84960 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2616 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2007 12:00:00 AM | Permit Number 49352 | 5988993.8 | 2097500 | 37.7387012975774 | -122.480600253763 | (37.7387012975774, -122.480600253763) | 1 | 8 | 3 | 29491 | 35 | |||
63432 | 87256 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2 Garrison Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50279 | 6008242.3 | 2086782.6 | 37.7103734997874 | -122.413290127101 | (37.7103734997874, -122.413290127101) | 9 | 7 | 8 | 309 | 39 | |||
65822 | 42484 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 50 Phelan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997088.18001 | 2092254.31401 | 37.7247650096883 | -122.452235460018 | (37.7247650096883, -122.452235460018) | 9 | 7 | 4 | 28861 | 40 | ||
65919 | 52895 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1642 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2006 12:00:00 AM | 3x3 | Permit Number 48894 | 5992495.5632863 | 2104272.70590883 | 37.757500303864 | -122.468985668503 | (37.757500303864, -122.468985668503) | 1 | 8 | 4 | 56 | 12 | ||
69195 | 41668 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 500 Corbett Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.444658701666 | (37.7577735947767, -122.444658701666) | 2 | 5 | 5 | 28862 | 3 | ||
71084 | 1360 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1 Amethyst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5999260.3642815 | 2099960.847629 | 37.7460495263909 | -122.445280344305 | (37.7460495263909, -122.445280344305) | 2 | 7 | 5 | 63 | 22 | |||
72672 | 36703 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3690x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005025.9 | 2104880.3 | 37.7598846207262 | -122.425693945182 | (37.7598846207262, -122.425693945182) | 2 | 4 | 5 | 28859 | 19 | ||
73058 | 43515 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 165 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806364 | (37.7377879152119, -122.41706806364) | 2 | 7 | 7 | 28859 | 2 | ||
77586 | 43523 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1442 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43199 | 6000900.07851404 | 2110723.16086375 | 37.7756936614931 | -122.44038215551 | (37.7756936614931, -122.44038215551) | 15 | 5 | 11 | 29492 | 10 | ||
78971 | 42224 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 661 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | 6 | 2 | 9 | 28853 | 6 | ||
79176 | 42218 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 661 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | 6 | 2 | 9 | 28853 | 6 | ||
80572 | 38688 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1763 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1998 12:00:00 AM | Permit Number 40601 | 6001154.46973963 | 2111747.51694807 | 37.7785207657155 | -122.439575605477 | (37.7785207657155, -122.439575605477) | 15 | 5 | 11 | 29490 | 41 | ||
81905 | 37521 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1112 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 3x3 | Permit Number 39974 | 6007343.4495166 | 2115114.77721986 | 37.7881167428842 | -122.418404341482 | (37.7881167428842, -122.418404341482) | 13 | 9 | 10 | 28858 | 21 | |
83000 | 12058 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
85177 | 42477 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 50 Phelan Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997094.69001 | 2092414.90401 | 37.7252063248445 | -122.452224537935 | (37.7252063248445, -122.452224537935) | 9 | 7 | 4 | 28861 | 40 | ||
85574 | 56997 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 469 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | 14 | 4x4 | Permit Number 14254 | 6003301.68334873 | 2103280.29729908 | 37.7553938131292 | -122.431542939454 | (37.7553938131292, -122.431542939454) | 2 | 4 | 5 | 28862 | 22 | |
85901 | 38684 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1785 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1998 12:00:00 AM | Permit Number 40599 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | 15 | 5 | 11 | 29492 | 16 | |||
86577 | 69756 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50279 | 6008252.26832326 | 2086801.73422247 | 37.7104265980746 | -122.413257026566 | (37.7104265980746, -122.413257026566) | 9 | 7 | 8 | 309 | 39 | ||
87000 | 39732 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3698 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41104 | 6004245.08369654 | 2106017.71232833 | 37.7629635309961 | -122.428475481414 | (37.7629635309961, -122.428475481414) | 8 | 4 | 5 | 28862 | 3 | ||
87558 | 38683 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1785 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1998 12:00:00 AM | Permit Number 40599 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | 15 | 5 | 11 | 29492 | 16 | |||
90309 | 44205 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 341 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1986 12:00:00 AM | Permit Number 43653 | 6007751.99799899 | 2097517.30165944 | 37.739821155436 | -122.415744314793 | (37.739821155436, -122.415744314793) | 2 | 7 | 7 | 28859 | 2 | ||
90646 | 39662 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 340 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41053 | 5995802.87923545 | 2090583.42381532 | 37.7201034282275 | -122.456557785922 | (37.7201034282275, -122.456557785922) | 9 | 8 | 6 | 28861 | 24 | ||
93483 | 12059 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
94012 | 42220 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 661 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | 6 | 2 | 9 | 28853 | 6 | ||
94351 | 38022 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 180 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1998 12:00:00 AM | Permit Number 40233 | 5992584.62016279 | 2098022.80205393 | 37.7403448191448 | -122.468223027257 | (37.7403448191448, -122.468223027257) | 1 | 8 | 4 | 59 | 40 | |||
94786 | 106502 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 420X Shrader St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997462.73555 | 2109001.92463 | 37.7707712761397 | -122.452148498658 | (37.7707712761397, -122.452148498658) | 15 | 5 | 11 | 29492 | 9 | |||||
95512 | 38682 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1785 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 41971 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | 15 | 5 | 11 | 29492 | 16 | ||
98270 | 113325 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1234 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5993019.12807809 | 2107069.22790191 | 37.76520905664 | -122.467378332531 | (37.76520905664, -122.467378332531) | 11 | 8 | 11 | 56 | 12 | |||
98305 | 46613 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 394 Fair Oaks St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44735. Tree 4 on 25th St. | 6005464.68638444 | 2101420.18882448 | 37.750408745884 | -122.423930345056 | (37.750408745884, -122.423930345056) | 2 | 4 | 5 | 28859 | 19 | ||
98836 | 43022 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 71 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42883 | 6005491.3790618 | 2109225.31619528 | 37.7718412930396 | -122.424393129042 | (37.7718412930396, -122.424393129042) | 7 | 9 | 5 | 28852 | 10 | ||
99381 | 39097 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3014 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | 12 | 5x9 | Permit Number 40786 | 6008165.45158313 | 2103310.33864273 | 37.7557507733516 | -122.414724626281 | (37.7557507733516, -122.414724626281) | 2 | 4 | 7 | 28859 | 19 |
99995 | 32507 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 100x OGDEN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37009 | 6007659 | 2096105 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | 2 | 7 | 7 | 28859 | 2 | ||
102291 | 38023 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 180 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40233 | 5992584.62016279 | 2098022.80205393 | 37.7403448191448 | -122.468223027257 | (37.7403448191448, -122.468223027257) | 1 | 8 | 4 | 59 | 40 | ||
102662 | 35831 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 800 Edinburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | Permit Number 39062 | 6001828.61140297 | 2089175.38471651 | 37.7165813830219 | -122.435628217621 | (37.7165813830219, -122.435628217621) | 9 | 7 | 6 | 28861 | 5 | ||
103984 | 43507 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 161 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2013 12:00:00 AM | Permit Number 769519 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.417122358052 | (37.7377931534639, -122.417122358052) | 2 | 7 | 7 | 28859 | 2 | |||
105632 | 48625 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1548 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45922 | 5992473.51988967 | 2104913.75628044 | 37.7592591867123 | -122.469108556949 | (37.7592591867123, -122.469108556949) | 1 | 8 | 4 | 56 | 12 | ||
114981 | 42221 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 661 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | 6 | 2 | 9 | 28853 | 6 | ||
115243 | 43516 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 165 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806364 | (37.7377879152119, -122.41706806364) | 2 | 7 | 7 | 28859 | 2 | ||
116958 | 97405 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2@Melrose Stanford Heights Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5997807 | 2095590.8 | 37.7339673631019 | -122.449990957178 | (37.7339673631019, -122.449990957178) | 9 | 7 | 4 | 59 | 40 | |||||
117156 | 54684 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1234 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | 14 | 3x3 | Permit Number 30565 | 5993019.12807809 | 2107069.22790191 | 37.76520905664 | -122.467378332531 | (37.76520905664, -122.467378332531) | 11 | 8 | 11 | 56 | 12 |
119195 | 39733 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3698 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41104 | 6004245.08369654 | 2106017.71232833 | 37.7629635309961 | -122.428475481414 | (37.7629635309961, -122.428475481414) | 8 | 4 | 5 | 28862 | 3 | ||
124318 | 42219 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 661 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | 6 | 2 | 9 | 28853 | 6 | ||
124356 | 12062 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
128251 | 92101 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1076 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2009 12:00:00 AM | 3x3 | Permit Number 52984 | 6005698 | 2102695 | 37.7539222521842 | -122.423214136058 | (37.7539222521842, -122.423214136058) | 2 | 4 | 5 | 28859 | 19 | ||
132051 | 87255 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2 Garrison Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50279 | 6008242.3 | 2086782.6 | 37.7103734997874 | -122.413290127101 | (37.7103734997874, -122.413290127101) | 9 | 7 | 8 | 309 | 39 | ||
132420 | 105973 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1336 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 771235 | 6006462.9 | 2119771 | 37.8008519560253 | -122.421781757787 | (37.8008519560253, -122.421781757787) | 13 | 9 | 1 | 28858 | 32 | ||||
135081 | 42127 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 57 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42423 | 5999631.06894657 | 2093753.11151717 | 37.7290257055547 | -122.443552646594 | (37.7290257055547, -122.443552646594) | 9 | 7 | 4 | 63 | 40 | ||
135903 | 36704 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3690x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005025.9 | 2104880.3 | 37.7598846207262 | -122.425693945182 | (37.7598846207262, -122.425693945182) | 2 | 4 | 5 | 28859 | 19 | ||
136213 | 39757 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 513 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41124 | 6002972.50040311 | 2103846.50934997 | 37.7569298331089 | -122.432721798166 | (37.7569298331089, -122.432721798166) | 2 | 4 | 5 | 28862 | 3 | ||
144957 | 41136 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1890 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41875 | 5997533.67783563 | 2108867.16274176 | 37.7704053182028 | -122.451893385496 | (37.7704053182028, -122.451893385496) | 15 | 5 | 11 | 29492 | 9 | ||
146563 | 35830 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 800 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | Permit Number 39062 | 6001828.61140297 | 2089175.38471651 | 37.7165813830219 | -122.435628217621 | (37.7165813830219, -122.435628217621) | 9 | 7 | 6 | 28861 | 5 | ||
146945 | 52587 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 690@ CABRILLO 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2006 12:00:00 AM | Permit Number 48680 | 5989145.55322023 | 2110639.08863484 | 37.7747865297245 | -122.481037351164 | (37.7747865297245, -122.481037351164) | 11 | 6 | 2 | 55 | 26 | |||
149333 | 46585 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 496 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/2002 12:00:00 AM | Permit Number 44714 | 6005497.60346294 | 2100827.74105942 | 37.7487838789143 | -122.423774394842 | (37.7487838789143, -122.423774394842) | 2 | 4 | 5 | 28859 | 19 | ||
150033 | 39734 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3698 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41104 | 6004245.08369654 | 2106017.71232833 | 37.7629635309961 | -122.428475481414 | (37.7629635309961, -122.428475481414) | 8 | 4 | 5 | 28862 | 3 | ||
151846 | 12057 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
156590 | 4253 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 4078 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003401.3861068 | 2100414.7966431 | 37.7475314732241 | -122.430993634389 | (37.7475314732241, -122.430993634389) | 2 | 4 | 5 | 63 | 22 | |||
157441 | 35825 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 618 Edinburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | Permit Number 39058 | 6002465.48488427 | 2090189.48175621 | 37.7194020221485 | -122.433499297304 | (37.7194020221485, -122.433499297304) | 9 | 7 | 6 | 28861 | 5 | ||
157687 | 12054 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1300X La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | |||
161810 | 42476 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 50 Phelan Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997093.60501 | 2092371.50101 | 37.7250870883021 | -122.452225158319 | (37.7250870883021, -122.452225158319) | 9 | 7 | 4 | 28861 | 40 | ||
162250 | 42217 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 661 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | 6 | 2 | 9 | 28853 | 6 | ||
167704 | 43517 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 165 Newman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806364 | (37.7377879152119, -122.41706806364) | 2 | 7 | 7 | 28859 | 2 | ||
168152 | 12065 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
168172 | 12060 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
170051 | 46612 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 394 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44735. Tree 1 on 25th St | 6005464.68638444 | 2101420.18882448 | 37.750408745884 | -122.423930345056 | (37.750408745884, -122.423930345056) | 2 | 4 | 5 | 28859 | 19 | ||
170110 | 45473 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1301 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | Permit Number 44252 | 5993960.36650023 | 2094413.72258595 | 37.730514541433 | -122.463204465727 | (37.730514541433, -122.463204465727) | 9 | 8 | 4 | 59 | 40 | ||
170473 | 12053 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1300X La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/29/1993 12:00:00 AM | 6 | 3X3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | ||
172390 | 40278 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 327 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41430 | 6006777.24179017 | 2101874.53362521 | 37.751730286944 | -122.41942365409 | (37.751730286944, -122.41942365409) | 2 | 4 | 7 | 28859 | 19 | ||
173319 | 39210 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 101 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/1999 12:00:00 AM | Permit Number 41852 | 5998202.98711321 | 2108218.1904746 | 37.7686617185434 | -122.449531484363 | (37.7686617185434, -122.449531484363) | 15 | 5 | 11 | 29492 | 9 | ||
176639 | 42670 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1575 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42698 | 6006081.0251203 | 2117910.0746574 | 37.7957207841663 | -122.422970868865 | (37.7957207841663, -122.422970868865) | 13 | 9 | 10 | 28858 | 32 | ||
180155 | 122595 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 524 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010413.68618597 | 2119615.98935706 | 37.8006483359763 | -122.408099375454 | (37.8006483359763, -122.408099375454) | 3 | 1 | 10 | 308 | 23 | |||
181753 | 36701 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3698x 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005001.97582164 | 2104885.80884876 | 37.7598983948026 | -122.425777079422 | (37.7598983948026, -122.425777079422) | 2 | 4 | 5 | 28859 | 19 | ||
186579 | 114967 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 469 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6003301.68334873 | 2103280.29729908 | 37.7553938131292 | -122.431542939454 | (37.7553938131292, -122.431542939454) | 2 | 4 | 5 | 28862 | 22 | ||||
187583 | 87251 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50275 | 6008259 | 2086838.7 | 37.7105284764145 | -122.413236372693 | (37.7105284764145, -122.413236372693) | 9 | 7 | 8 | 309 | 39 | |||
190584 | 42121 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 110 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42418 | 5999349.45513333 | 2095526.80253467 | 37.7338797805201 | -122.44465363726 | (37.7338797805201, -122.44465363726) | 9 | 7 | 4 | 59 | 40 |
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) );