superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LAYER = 13 and PARK_NAME = "Orange Blossom Recreation Area"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
ACCESS_TYP 1
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6525 | 6525 | 6524 | {"type": "Polygon", "coordinates": [[[-120.7739, 37.7927], [-120.77322, 37.79285], [-120.77164, 37.79236], [-120.76957, 37.7921], [-120.76865, 37.79188], [-120.76749, 37.79128], [-120.76754, 37.79123], [-120.76754, 37.79122], [-120.76729, 37.79108], [-120.76722, 37.79113], [-120.767, 37.79101], [-120.76646, 37.79083], [-120.76346, 37.79052], [-120.76278, 37.79031], [-120.76279, 37.79023], [-120.7623, 37.79007], [-120.76196, 37.78989], [-120.76187, 37.78981], [-120.7618, 37.78973], [-120.76168, 37.78963], [-120.76164, 37.78954], [-120.76156, 37.78946], [-120.76149, 37.78928], [-120.76187, 37.78901], [-120.76279, 37.78841], [-120.76306, 37.7888], [-120.76332, 37.78906], [-120.76406, 37.78952], [-120.76436, 37.78978], [-120.76462, 37.79011], [-120.76495, 37.7903], [-120.76532, 37.79038], [-120.76563, 37.79056], [-120.76598, 37.79061], [-120.7663, 37.79063], [-120.76685, 37.79076], [-120.76706, 37.79086], [-120.76727, 37.79091], [-120.76769, 37.79094], [-120.76799, 37.79105], [-120.76824, 37.79119], [-120.76868, 37.79131], [-120.76899, 37.79142], [-120.76932, 37.79152], [-120.76973, 37.79158], [-120.77008, 37.79175], [-120.77082, 37.79188], [-120.77112, 37.79192], [-120.77182, 37.79208], [-120.77211, 37.79209], [-120.77259, 37.7922], [-120.77319, 37.79236], [-120.77374, 37.79233], [-120.7739, 37.7927]]]} | Open Access 1 | Orange Blossom Recreation Area | 23150 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 17.475 | Orange Blossom Rec. Area |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);