calands: units_with_maps: 2 rows where ACCESS_TYP = 1, COUNTY = 57 and DES

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

2 rows where ACCESS_TYP = 1, COUNTY = 57 and DES_TP = 15

Search:

descending

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]);