calands: units_with_maps: 5 rows where ACCESS_TYP = 3 and AGNCY

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

5 rows where ACCESS_TYP = 3 and AGNCY_NAME = 766

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	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
5105	5105	5104	{"type": "Polygon", "coordinates": [[[-123.68414, 40.48042], [-123.67906, 40.48126], [-123.66993, 40.48271], [-123.67004, 40.47815], [-123.6746, 40.47741], [-123.67492, 40.47444], [-123.67959, 40.47359], [-123.67921, 40.47671], [-123.68403, 40.47602], [-123.68414, 40.48042]]]}	No Public Access 3	48240	McClellan Mountain Peatland	32798	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	Humboldt 45	180.409	McClellan Mtn. Peatland	2017	State Resource Management Area 55	3
8625	8625	8624	{"type": "Polygon", "coordinates": [[[-120.1217, 34.50899], [-120.1215, 34.51982], [-120.12123, 34.53056], [-120.11243, 34.53048], [-120.11238, 34.5342], [-120.10805, 34.53417], [-120.108, 34.53779], [-120.10865, 34.5378], [-120.09496, 34.53782], [-120.095, 34.53396], [-120.09499, 34.53395], [-120.09504, 34.53037], [-120.09508, 34.5298], [-120.09469, 34.52938], [-120.0943, 34.529], [-120.09418, 34.52877], [-120.09451, 34.52685], [-120.09508, 34.52678], [-120.09515, 34.52404], [-120.09518, 34.52331], [-120.09512, 34.51591], [-120.11291, 34.516], [-120.11298, 34.50877], [-120.1217, 34.50899]]]}	No Public Access 3	13788	Rancho Dos Vistas	24143	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	212	California Wildlife Conservation Board 747	State 5	State Agency 5	Santa Barbara 7	1402.81	Rancho Dos Vistas		None 721
11524	11524	11523	{"type": "MultiPolygon", "coordinates": [[[[-121.80139, 36.83624], [-121.80041, 36.83633], [-121.80027, 36.83636], [-121.80012, 36.83642], [-121.79995, 36.83655], [-121.79971, 36.83688], [-121.7995, 36.83724], [-121.79925, 36.83777], [-121.79919, 36.83784], [-121.7991, 36.83789], [-121.799, 36.83791], [-121.7982, 36.83791], [-121.79819, 36.83709], [-121.79848, 36.83654], [-121.79868, 36.83586], [-121.79866, 36.83518], [-121.79844, 36.8349], [-121.79817, 36.83491], [-121.79813, 36.83074], [-121.79879, 36.83073], [-121.79899, 36.83093], [-121.79913, 36.83112], [-121.80064, 36.83479], [-121.80093, 36.83538], [-121.80139, 36.83624]]], [[[-121.80217, 36.83804], [-121.80217, 36.83804], [-121.79919, 36.83804], [-121.7993, 36.83798], [-121.7994, 36.83788], [-121.79964, 36.83739], [-121.7998, 36.8371], [-121.80005, 36.83671], [-121.80016, 36.8366], [-121.80029, 36.83654], [-121.80043, 36.8365], [-121.80148, 36.83639], [-121.8017, 36.83677], [-121.80189, 36.83717], [-121.80204, 36.83758], [-121.80217, 36.83804]]]]}	No Public Access 3	48235	McClusky Slough	32792	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	Monterey 14	38.897	McClusky Slough	1996	State Conservation Area 8	2
11529	11529	11528	{"type": "MultiPolygon", "coordinates": [[[[-118.64078, 37.50286], [-118.6391, 37.50286], [-118.63785, 37.50235], [-118.637, 37.50228], [-118.63677, 37.50201], [-118.63603, 37.50216], [-118.63607, 37.49933], [-118.63603, 37.49932], [-118.63601, 37.50215], [-118.63398, 37.50327], [-118.63386, 37.50338], [-118.63381, 37.50347], [-118.6338, 37.50357], [-118.63384, 37.50371], [-118.63394, 37.50383], [-118.63397, 37.50392], [-118.63398, 37.50453], [-118.63395, 37.50469], [-118.63387, 37.50489], [-118.63383, 37.505], [-118.63382, 37.50545], [-118.63376, 37.50545], [-118.63374, 37.49934], [-118.63378, 37.49576], [-118.63149, 37.49576], [-118.6315, 37.49396], [-118.6338, 37.49396], [-118.63383, 37.49216], [-118.64077, 37.49217], [-118.64077, 37.49928], [-118.64076, 37.50283], [-118.64078, 37.50286]]], [[[-118.63498, 37.50563], [-118.63496, 37.50642], [-118.63375, 37.50642], [-118.63375, 37.50562], [-118.63498, 37.50563]]], [[[-118.636, 37.50234], [-118.63598, 37.50626], [-118.63517, 37.50626], [-118.63517, 37.50546], [-118.63403, 37.50545], [-118.63404, 37.50501], [-118.63417, 37.50467], [-118.63419, 37.5045], [-118.63418, 37.50387], [-118.63414, 37.50378], [-118.63403, 37.50364], [-118.63401, 37.50354], [-118.63403, 37.50347], [-118.6341, 37.50341], [-118.636, 37.50234]]]]}	No Public Access 3	48236	Round Valley Wildlife Area	33312	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	Mono 32	203.625	Round Valley Wildlife Area	1993	State Conservation Area 8	2
14856	14856	14855	{"type": "Polygon", "coordinates": [[[-124.18903, 40.79066], [-124.18902, 40.79082], [-124.18514, 40.7908], [-124.1852, 40.79064], [-124.18903, 40.79066]]]}	No Public Access 3	45366	Del Norte Street Pier	18042	212	California Wildlife Conservation Board 766	State 5	State Agency 5	http://www.wcb.ca.gov/	Other State 5	212	California Wildlife Conservation Board 747	State 5	State Agency 5	Humboldt 45	1.467	Del Norte Street Pier		None 1279

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