units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 57 and DES_TP = 15
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12248 | 12248 | 12247 | {"type": "MultiPolygon", "coordinates": [[[[-120.6906, 39.76307], [-120.69053, 39.77025], [-120.6883, 39.7703], [-120.68828, 39.77751], [-120.68362, 39.77756], [-120.68364, 39.78474], [-120.67927, 39.78469], [-120.67917, 39.77024], [-120.68355, 39.77028], [-120.68353, 39.76334], [-120.68356, 39.76333], [-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 | 25822 | Plumas-Eureka State Park | 28287 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=507 | Plumas 57 | 496.947 | Plumas-Eureka SP | 1959 | State Park 15 | 4 |
| 16551 | 16551 | 16550 | {"type": "MultiPolygon", "coordinates": [[[[-120.68355, 39.77029], [-120.67917, 39.77025], [-120.67927, 39.78469], [-120.66502, 39.78452], [-120.66498, 39.77743], [-120.66969, 39.77745], [-120.66971, 39.76937], [-120.67434, 39.76948], [-120.67442, 39.76625], [-120.67893, 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.77367], [-120.72205, 39.77717], [-120.71646, 39.77722], [-120.71645, 39.77394], [-120.69774, 39.77395], [-120.69771, 39.7774], [-120.68828, 39.77751], [-120.6883, 39.7703], [-120.69053, 39.77024], [-120.6906, 39.76307], [-120.68356, 39.76302], [-120.68346, 39.75564], [-120.68869, 39.75566], [-120.68857, 39.74841], [-120.68797, 39.7484], [-120.68829, 39.74435], [-120.69291, 39.74419], [-120.69296, 39.73721], [-120.69295, 39.7372], [-120.68798, 39.73728], [-120.68798, 39.73349], [-120.6929, 39.73349], [-120.6929, 39.73347], [-120.69171, 39.7328], [-120.69334, 39.73152], [-120.69404, 39.73213], [-120.69487, 39.7303], [-120.69892, 39.7335], [-120.69969, 39.7335], [-120.70072, 39.73071], [-120.70209, 39.73264], [-120.70256, 39.73217], [-120.70433, 39.7326], [-120.70807, 39.73175], [-120.70762, 39.7277], [-120.70985, 39.72745], [-120.711, 39.73312], [-120.7213, 39.73318], [-120.72186, 39.7457], [-120.72593, 39.74567]], [[-120.6967, 39.7614], [-120.69694, 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.69665, 39.759], [-120.69667, 39.75888], [-120.69719, 39.75887], [-120.69721, 39.75796], [-120.69599, 39.758], [-120.69603, 39.75888], [-120.69572, 39.75888], [-120.69573, 39.75911], [-120.69542, 39.75911], [-120.69542, 39.75933], [-120.69512, 39.75933], [-120.69512, 39.75955], [-120.69482, 39.75955], [-120.69482, 39.75977], [-120.69422, 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.69794, 39.7958], [-120.70271, 39.79587], [-120.7028, 39.79224], [-120.70261, 39.78116], [-120.70676, 39.78097], [-120.70691, 39.78479], [-120.71175, 39.78475], [-120.71172, 39.79216], [-120.7119, 39.79944]], [[-120.70581, 39.7922], [-120.7072, 39.7922], [-120.70727, 39.78819], [-120.70577, 39.78818], [-120.70581, 39.7922]]]]} | Open Access 1 | 10718 | Plumas-Eureka State Park | 1836 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=507 | Plumas 57 | 4503.798 | Plumas-Eureka SP | 1959 | State Park 15 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps(
id INT,
map,
ACCESS_TYP INT,
UNIT_ID INT,
UNIT_NAME TEXT,
SUID_NMA INT,
AGNCY_ID INT,
AGNCY_NAME INT,
AGNCY_LEV INT,
AGNCY_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
PARK_URL TEXT,
COUNTY INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
DES_TP INT,
GAP_STS TEXT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
ON [units_with_maps] ([ACCESS_TYP]);