trees
54 rows where qSpecies_id = 24 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15765 | 258114 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 22 Isis St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6008329.87381 | 2108642.20827 | 37.7704000939468 | -122.414533279126 | (37.7704000939468, -122.414533279126) | 8 | 2 | 9 | 28853 | 19 | |||||
8165 | 190352 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 8 Federal St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 10:28:00 AM | 3 | Width 2ft | 6015093.65836 | 2113449.8432 | 37.783978449892 | -122.391473297374 | (37.783978449892, -122.391473297374) | 6 | 2 | 9 | 28856 | 6 | ||
8198 | 190353 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 20 Federal St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 10:24:00 AM | 3 | Width 3ft | 6015020.15445 | 2113379.99675 | 37.7837825874477 | -122.391722710829 | (37.7837825874477, -122.391722710829) | 6 | 2 | 9 | 28856 | 6 | ||
12302 | 190355 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 20 Federal St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 10:16:00 AM | 3 | Width 3ft | 6014990.18738 | 2113351.33782 | 37.7837022330098 | -122.391824381909 | (37.7837022330098, -122.391824381909) | 6 | 2 | 9 | 28856 | 6 | ||
13276 | 190354 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 20 Federal St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 10:20:00 AM | 3 | Width 3ft | 6015003.991 | 2113364.09082 | 37.7837380161259 | -122.391777518225 | (37.7837380161259, -122.391777518225) | 6 | 2 | 9 | 28856 | 6 | ||
14737 | 100258 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 20X Federal St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 10:12:00 AM | 3 | 3x3 | 6015031.62181 | 2113390.73913 | 37.7838127201334 | -122.391683789074 | (37.7838127201334, -122.391683789074) | 6 | 2 | 9 | 28856 | 6 | ||
13548 | 127490 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1000 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 783066 | 6007656.89689 | 2115128.36541 | 37.7881716927058 | -122.417320828287 | (37.7881716927058, -122.417320828287) | 13 | 1 | 10 | 28858 | 21 | |
19414 | 34455 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1711 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 7 | Permit Number 38199 | 6008299.19736 | 2118343.4802 | 37.7970357237711 | -122.415326264207 | (37.7970357237711, -122.415326264207) | 5 | 1 | 10 | 28858 | 21 | |
744 | 152861 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 78 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6005240.53391 | 2104991.58672 | 37.7602023138964 | -122.424959548361 | (37.7602023138964, -122.424959548361) | 2 | 4 | 5 | 28859 | 19 | |||
1421 | 235877 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1208 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:18:00 PM | 3 | 6x5 | 6010019.59972 | 2102103.34196 | 37.7525406314463 | -122.408227234492 | (37.7525406314463, -122.408227234492) | 2 | 4 | 7 | 28859 | 19 | ||
2133 | 27518 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1212 Guerrero St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2000 12:00:00 AM | 4 | 3x3 | 6005759.73558 | 2101716.47325 | 37.7512389275446 | -122.422931097816 | (37.7512389275446, -122.422931097816) | 2 | 4 | 5 | 28859 | 19 | ||
2788 | 235823 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 800 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x5 | 6005620.87436 | 2104260.20784 | 37.7582155954788 | -122.423592129188 | (37.7582155954788, -122.423592129188) | 2 | 4 | 5 | 28859 | 19 | |||
3216 | 27512 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1212 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005753.54797 | 2101830.48031 | 37.75155161552 | -122.422960597352 | (37.75155161552, -122.422960597352) | 2 | 4 | 5 | 28859 | 19 | ||
4472 | 228451 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 2701 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6x6 | 6009297.41402 | 2106368.88017 | 37.7642123684355 | -122.411025946309 | (37.7642123684355, -122.411025946309) | 8 | 4 | 7 | 28859 | 19 | |||
4621 | 152863 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 78 Oakwood St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6005242.20984 | 2104952.34093 | 37.7600946488737 | -122.424950959826 | (37.7600946488737, -122.424950959826) | 2 | 4 | 5 | 28859 | 19 | |||
5763 | 228452 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 2701 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6x6 | 6009318.2366 | 2106370.18067 | 37.7642171069559 | -122.410954018538 | (37.7642171069559, -122.410954018538) | 8 | 4 | 7 | 28859 | 19 | |||
6432 | 10064 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 512 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/1991 12:00:00 AM | 30 | 3X3 | 6005527.25593 | 2105966.68025 | 37.762895882361 | -122.42403725491 | (37.762895882361, -122.42403725491) | 8 | 4 | 5 | 28859 | 19 | ||
7517 | 228449 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 2701 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6x6 | 6009256.91005 | 2106366.76259 | 37.7642042826228 | -122.411165888909 | (37.7642042826228, -122.411165888909) | 8 | 4 | 7 | 28859 | 19 | |||
8288 | 152864 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 78 Oakwood St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6005243.87966 | 2104930.05152 | 37.7600335417272 | -122.424943598861 | (37.7600335417272, -122.424943598861) | 2 | 4 | 5 | 28859 | 19 | |||
9520 | 261605 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 78 Oakwood St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005240.53391 | 2104991.58672 | 37.7602023138964 | -122.424959548361 | (37.7602023138964, -122.424959548361) | 2 | 4 | 5 | 28859 | 19 | ||||
9618 | 228457 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 2701 17th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6x6 | 6009423.8763 | 2106376.92574 | 37.7642415505399 | -122.410589115888 | (37.7642415505399, -122.410589115888) | 8 | 4 | 7 | 28859 | 19 | |||
12029 | 228453 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 2701 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6x6 | 6009339.05918 | 2106371.48119 | 37.7642218454873 | -122.410882090759 | (37.7642218454873, -122.410882090759) | 8 | 4 | 7 | 28859 | 19 | |||
12304 | 27514 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1212 Guerrero St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005755.80226 | 2101784.51034 | 37.7514255197779 | -122.422949534811 | (37.7514255197779, -122.422949534811) | 2 | 4 | 5 | 28859 | 19 | ||
13566 | 228455 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 2701 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6x6 | 6009383.67351 | 2106374.02164 | 37.7642313225287 | -122.410727961341 | (37.7642313225287, -122.410727961341) | 8 | 4 | 7 | 28859 | 19 | |||
14577 | 27519 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1212 Guerrero St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005760.41969 | 2101697.87743 | 37.7511879063069 | -122.42292741057 | (37.7511879063069, -122.42292741057) | 2 | 4 | 5 | 28859 | 19 | ||
15404 | 223295 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 19 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007196.68855 | 2097540.75873 | 37.7398543306231 | -122.417666007897 | (37.7398543306231, -122.417666007897) | 2 | 7 | 7 | 28859 | 2 | |||
15664 | 10200 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1213 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/1993 12:00:00 AM | 12 | 3x3 | 6005821.46028 | 2101837.96868 | 37.7515760087314 | -122.422726279907 | (37.7515760087314, -122.422726279907) | 2 | 4 | 5 | 28859 | 19 | ||
16284 | 228454 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 2701 17th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6x6 | 6009362.10361 | 2106372.48972 | 37.7642259068175 | -122.410802457572 | (37.7642259068175, -122.410802457572) | 8 | 4 | 7 | 28859 | 19 | |||
18695 | 152862 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 78 Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6005240.50344 | 2104972.86471 | 37.7601509059491 | -122.424958321694 | (37.7601509059491, -122.424958321694) | 2 | 4 | 5 | 28859 | 19 | |||
19005 | 228460 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 2625 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010714.68048 | 2102241.99741 | 37.7529602452298 | -122.405833280596 | (37.7529602452298, -122.405833280596) | 10 | 4 | 8 | 28859 | 19 | |||
7045 | 262404 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 100 Lyell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003168.63891 | 2094316.61158 | 37.7307740683503 | -122.431363211466 | (37.7307740683503, -122.431363211466) | 9 | 7 | 5 | 28861 | 25 | ||
13017 | 170386 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 100 Lyell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003168.63891 | 2094316.61158 | 37.7307740683503 | -122.431363211466 | (37.7307740683503, -122.431363211466) | 9 | 7 | 5 | 28861 | 25 | ||
13686 | 170385 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 100 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2020 12:00:00 AM | 3 | Width 3ft | 6003153.84638 | 2094356.3459 | 37.730882331448 | -122.431417186961 | (37.730882331448, -122.431417186961) | 9 | 7 | 5 | 28861 | 25 | ||
15998 | 161276 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 578 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6002845.37486 | 2090276.36856 | 37.7196621404792 | -122.432192361215 | (37.7196621404792, -122.432192361215) | 9 | 7 | 6 | 28861 | 5 | ||
2347 | 228466 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 315 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2015 01:54:00 PM | 1 | Width 3ft | 6004209.32869 | 2107056.55416 | 37.7658139179905 | -122.428673203406 | (37.7658139179905, -122.428673203406) | 8 | 4 | 5 | 28862 | 3 | ||
2383 | 228491 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 544 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x4 | 6004217.2996 | 2105758.44512 | 37.7622500729091 | -122.428553095368 | (37.7622500729091, -122.428553095368) | 8 | 4 | 5 | 28862 | 3 | |||
14641 | 228469 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 251 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004187.68386 | 2107403.80814 | 37.7667661687459 | -122.428772825825 | (37.7667661687459, -122.428772825825) | 8 | 4 | 5 | 28862 | 3 | |||
18636 | 220039 | Permitted Site 7 | Hymenosporum flavum :: Sweetshade 24 | 819 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784849 | 6001009.04844 | 2102577.75334 | 37.7533345862464 | -122.439421190941 | (37.7533345862464, -122.439421190941) | 2 | 4 | 5 | 28862 | 22 | |
19268 | 240769 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 67 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/04/2016 12:00:00 AM | 14 | 3x3 | 6002868.86107 | 2107912.19122 | 37.7680873339916 | -122.433370741063 | (37.7680873339916, -122.433370741063) | 15 | 5 | 5 | 28862 | 3 | ||
58353 | 228497 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 487 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004262.22293 | 2106063.80962 | 37.7630910730105 | -122.428419488484 | (37.7630910730105, -122.428419488484) | 8 | 4 | 5 | 28862 | 3 | |||
81586 | 228498 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 450 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6x6 | 6004181.58169 | 2106402.65123 | 37.7640168872847 | -122.42872255552 | (37.7640168872847, -122.42872255552) | 8 | 4 | 5 | 28862 | 3 | |||
96691 | 228472 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 227 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004182.38579 | 2107503.9785 | 37.7670409125283 | -122.428798292811 | (37.7670409125283, -122.428798292811) | 8 | 4 | 5 | 28862 | 3 | |||
108139 | 232395 | Permitted Site 7 | Hymenosporum flavum :: Sweetshade 24 | 315 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782341 | 6003588.27372 | 2106449.30544 | 37.7641113916603 | -122.43077796144 | (37.7641113916603, -122.43077796144) | 8 | 4 | 5 | 28862 | 3 | |
153096 | 228470 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 245 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004187.12028 | 2107418.48366 | 37.766806432287 | -122.428775821463 | (37.766806432287, -122.428775821463) | 8 | 4 | 5 | 28862 | 3 | |||
40 | 6039 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1822 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001574.3819 | 2112547.6661 | 37.7807416628926 | -122.438180307395 | (37.7807416628926, -122.438180307395) | 15 | 5 | 11 | 29490 | 41 | |||
46 | 6035 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1826 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001552.687 | 2112546.4084 | 37.7807369756783 | -122.438255270265 | (37.7807369756783, -122.438255270265) | 15 | 5 | 11 | 29490 | 41 | |||
3866 | 18880 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 2315 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/13/2014 12:00:00 AM | 3 | 3x3 | 6003622.42952 | 2115918.82336 | 37.7901142787066 | -122.431335838788 | (37.7901142787066, -122.431335838788) | 13 | 9 | 1 | 29490 | 27 | ||
14734 | 86515 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1217 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2016 01:26:00 PM | 3 | 3x3 | 5987669.651538 | 2107004.041134 | 37.7647197926712 | -122.485875869509 | (37.7647197926712, -122.485875869509) | 1 | 8 | 3 | 56 | 35 | ||
1047 | 42641 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1651 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 12:11:00 PM | 3 | 5x5 | Permit Number 42688 | 6005090.06351 | 2118821.98656 | 37.7981686950973 | -122.426464740961 | (37.7981686950973, -122.426464740961) | 13 | 9 | 1 | 57 | 17 |
751 | 261105 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1700X Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6015022 | 2094381 | 37.7316155174388 | -122.390388421118 | (37.7316155174388, -122.390388421118) | 10 | 3 | 8 | 58 | 1 | |
11192 | 6765 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1275 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 01:37:00 PM | 3 | 3x3 | 6017282.82119 | 2096909.09011 | 37.7386823026365 | -122.382748097356 | (37.7386823026365, -122.382748097356) | 10 | 3 | 8 | 58 | 1 | ||
11788 | 6761 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1275 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/2019 12:00:00 AM | 3 | 3x3 | 6017199.30801 | 2096970.01555 | 37.738844977413 | -122.383041088382 | (37.738844977413, -122.383041088382) | 10 | 3 | 8 | 58 | 1 | ||
14710 | 261104 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1700X Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6015022 | 2094381 | 37.7316155174388 | -122.390388421118 | (37.7316155174388, -122.390388421118) | 10 | 3 | 8 | 58 | 1 | |||
17287 | 223277 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 950 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5999782.99991 | 2102046.02662 | 37.751804743197 | -122.443622912589 | (37.751804743197, -122.443622912589) | 2 | 5 | 5 | 63 | 38 |
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) );