superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and PARK_NAME = "Plumas-Eureka State Park"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
314 | 314 | 313 | {"type": "MultiPolygon", "coordinates": [[[[-120.68355, 39.77029], [-120.67917, 39.77026], [-120.67927, 39.78469], [-120.66502, 39.78452], [-120.66498, 39.77743], [-120.66969, 39.77744], [-120.66971, 39.76937], [-120.67434, 39.76948], [-120.67442, 39.76625], [-120.67892, 39.76639], [-120.67896, 39.76302], [-120.68353, 39.76334], [-120.68355, 39.77029]]], [[[-120.72593, 39.74567], [-120.72591, 39.76311], [-120.72592, 39.77365], [-120.72186, 39.77368], [-120.72205, 39.77717], [-120.71646, 39.77722], [-120.71644, 39.77394], [-120.69775, 39.77395], [-120.69771, 39.7774], [-120.68828, 39.77751], [-120.6883, 39.7703], [-120.69053, 39.77023], [-120.6906, 39.76308], [-120.68356, 39.76302], [-120.68346, 39.75564], [-120.68869, 39.75566], [-120.68857, 39.74842], [-120.68797, 39.7484], [-120.68829, 39.74435], [-120.69291, 39.74419], [-120.69296, 39.73722], [-120.69295, 39.7372], [-120.68798, 39.73728], [-120.68798, 39.73349], [-120.69289, 39.73349], [-120.6929, 39.73347], [-120.69171, 39.7328], [-120.69334, 39.73152], [-120.69404, 39.73212], [-120.69487, 39.7303], [-120.69893, 39.7335], [-120.69969, 39.7335], [-120.70072, 39.73071], [-120.70209, 39.73263], [-120.70256, 39.73217], [-120.70433, 39.7326], [-120.70806, 39.73176], [-120.70762, 39.7277], [-120.70985, 39.72745], [-120.71101, 39.73311], [-120.7213, 39.73318], [-120.72186, 39.7457], [-120.72593, 39.74567]], [[-120.6967, 39.7614], [-120.69691, 39.76133], [-120.69653, 39.76124], [-120.6967, 39.76079], [-120.69667, 39.76016], [-120.69666, 39.75922], [-120.69613, 39.75911], [-120.69627, 39.75892], [-120.69664, 39.759], [-120.69667, 39.75888], [-120.69718, 39.75887], [-120.6972, 39.75796], [-120.69599, 39.758], [-120.69603, 39.75888], [-120.69573, 39.75888], [-120.69573, 39.75911], [-120.69543, 39.75911], [-120.69542, 39.75933], [-120.69513, 39.75933], [-120.69512, 39.75955], [-120.69483, 39.75955], [-120.69482, 39.75977], [-120.69423, 39.75977], [-120.69421, 39.75999], [-120.69249, 39.76003], [-120.69248, 39.76135], [-120.69245, 39.76185], [-120.69195, 39.76185], [-120.69192, 39.763], [-120.69672, 39.763], [-120.6967, 39.7614]]], [[[-120.7119, 39.79944], [-120.6976, 39.79953], [-120.69793, 39.79577], [-120.69795, 39.7958], [-120.70271, 39.79586], [-120.7028, 39.79224], [-120.70261, 39.78116], [-120.70676, 39.78097], [-120.70692, 39.78479], [-120.71175, 39.78475], [-120.71172, 39.79216], [-120.7119, 39.79944]], [[-120.70581, 39.79219], [-120.7072, 39.79219], [-120.70726, 39.7882], [-120.70577, 39.78819], [-120.70581, 39.79219]]]]} | Open Access 1 | Plumas-Eureka State Park | http://www.parks.ca.gov/?page_id=507 | 1836 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 4504.618 | Plumas-Eureka SP | 1959 |
15281 | 15281 | 15280 | {"type": "MultiPolygon", "coordinates": [[[[-120.6906, 39.76307], [-120.69053, 39.77025], [-120.6883, 39.77031], [-120.68828, 39.77751], [-120.68362, 39.77757], [-120.68364, 39.78474], [-120.67927, 39.78469], [-120.67917, 39.77024], [-120.68354, 39.77028], [-120.68353, 39.76334], [-120.68356, 39.76332], [-120.68356, 39.76302], [-120.6906, 39.76307]]], [[[-120.71646, 39.77722], [-120.69771, 39.7774], [-120.69773, 39.77395], [-120.71646, 39.77394], [-120.71646, 39.77722]]]]} | Open Access 1 | Plumas-Eureka State Park | http://www.parks.ca.gov/?page_id=507 | 28287 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 497.034 | Plumas-Eureka SP | 1959 |
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]);