calands: units_with_maps: 3 rows where COUNTY = 35, DES_TP = 49 and MNG_AG

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

3 rows where COUNTY = 35, DES_TP = 49 and MNG_AG_TYP = 1

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
3264	3264	3263	{"type": "MultiPolygon", "coordinates": [[[[-120.13722, 39.30839], [-120.13608, 39.3084], [-120.13428, 39.30937], [-120.13187, 39.30826], [-120.13015, 39.30797], [-120.12753, 39.30817], [-120.12579, 39.30885], [-120.12528, 39.31032], [-120.12629, 39.31563], [-120.12641, 39.31634], [-120.12368, 39.31634], [-120.12367, 39.31637], [-120.12356, 39.31637], [-120.10961, 39.31629], [-120.10961, 39.31389], [-120.11192, 39.31385], [-120.11204, 39.30943], [-120.11186, 39.30942], [-120.11185, 39.30922], [-120.11095, 39.30922], [-120.11095, 39.30757], [-120.11431, 39.30759], [-120.1143, 39.30237], [-120.12362, 39.30317], [-120.13021, 39.30383], [-120.13091, 39.30393], [-120.13148, 39.30406], [-120.13215, 39.30426], [-120.13257, 39.30442], [-120.13288, 39.30456], [-120.13347, 39.30487], [-120.1341, 39.30528], [-120.13435, 39.30548], [-120.13617, 39.30735], [-120.13722, 39.30839]]], [[[-120.14227, 39.28641], [-120.14222, 39.28995], [-120.14215, 39.29354], [-120.142, 39.29907], [-120.14199, 39.30079], [-120.13337, 39.30099], [-120.12359, 39.30112], [-120.12361, 39.303], [-120.1143, 39.3022], [-120.1143, 39.30215], [-120.11425, 39.30215], [-120.11425, 39.30112], [-120.11658, 39.30112], [-120.11658, 39.29738], [-120.11791, 39.29736], [-120.11795, 39.29646], [-120.12369, 39.29655], [-120.12367, 39.29728], [-120.12368, 39.29729], [-120.12849, 39.29724], [-120.12841, 39.2938], [-120.12843, 39.29195], [-120.12842, 39.2899], [-120.13331, 39.28995], [-120.1333, 39.28652], [-120.14227, 39.28641]]]]}	Open Access 1	23086	Martis Creek Lake Recreation Area	13574	100	United States Army Corps of Engineers 146	Federal 1	Federal Agency 1	http://www.usace.army.mil/	Other Federal 13	100	United States Army Corps of Engineers 142	Federal 1	Federal Agency 1	http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/MartisCreekLake.aspx	Placer 35	1112.337	Martis Creek Lake Rec. Area	0	Recreation Management Area 49	4
10057	10057	10056	{"type": "MultiPolygon", "coordinates": [[[[-120.15944, 39.11112], [-120.15898, 39.11163], [-120.15858, 39.11216], [-120.15822, 39.11273], [-120.15808, 39.113], [-120.158, 39.11325], [-120.15795, 39.11346], [-120.15792, 39.11367], [-120.15792, 39.11389], [-120.15794, 39.1141], [-120.15798, 39.11431], [-120.15813, 39.11475], [-120.1579, 39.11475], [-120.15779, 39.11452], [-120.1577, 39.11413], [-120.15768, 39.11388], [-120.15768, 39.11367], [-120.15773, 39.11321], [-120.15776, 39.1131], [-120.1578, 39.113], [-120.15783, 39.11279], [-120.15793, 39.11248], [-120.15795, 39.11229], [-120.15806, 39.11206], [-120.1583, 39.11158], [-120.1586, 39.11111], [-120.15944, 39.11112]]], [[[-120.16538, 39.11475], [-120.16269, 39.11475], [-120.15978, 39.11469], [-120.1595, 39.11469], [-120.15843, 39.11474], [-120.15829, 39.11437], [-120.15822, 39.11406], [-120.1582, 39.11379], [-120.15823, 39.11348], [-120.1583, 39.11322], [-120.1584, 39.11296], [-120.15873, 39.1124], [-120.15878, 39.11236], [-120.15908, 39.11237], [-120.15926, 39.11234], [-120.15943, 39.11227], [-120.15957, 39.11215], [-120.15957, 39.11245], [-120.16153, 39.1125], [-120.16154, 39.11117], [-120.16208, 39.1112], [-120.16538, 39.11475]]]]}	Open Access 1	49029	Kaspian Recreation Area	33730	107	United States Forest Service 38	Federal 1	Federal Agency 1	http://www.fs.fed.us/	US Forest Service 7	107	United States Forest Service 37	Federal 1	Federal Agency 1	https://www.fs.usda.gov/Internet/FSE_DOCUMENTS/fseprd632577.pdf	Placer 35	39.38	Kaspian Rec. Area	0	Recreation Management Area 49	4
14548	14548	14547	{"type": "Polygon", "coordinates": [[[-121.02582, 38.9373], [-121.02254, 38.93856], [-121.02232, 38.93981], [-121.02046, 38.94222], [-121.01715, 38.94306], [-121.01682, 38.93948], [-121.01802, 38.9396], [-121.01942, 38.93915], [-121.02, 38.93743], [-121.02141, 38.93616], [-121.02233, 38.93553], [-121.02281, 38.93501], [-121.0258, 38.93502], [-121.02575, 38.93638], [-121.02582, 38.9373]]]}	Open Access 1	47511	Auburn State Recreation Area	15701	100	United States Army Corps of Engineers 146	Federal 1	Federal Agency 1	http://www.usace.army.mil/	Other Federal 13	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.parks.ca.gov/?page_id=502	Placer 35	76.191	Auburn SRA	1966	Recreation Management Area 49	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]);