calands: units_with_maps: 6 rows where ACCESS_TYP = 2, DES

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

6 rows where ACCESS_TYP = 2, DES_TP = 8 and LAYER = 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
3589	3589	3588	{"type": "Polygon", "coordinates": [[[-121.4409, 38.26568], [-121.4405, 38.26654], [-121.43893, 38.26623], [-121.43872, 38.26566], [-121.43905, 38.26515], [-121.43899, 38.26457], [-121.44061, 38.26555], [-121.4409, 38.26568]]]}	Restricted Access 2	29176	Cosumnes River Ecological Reserve	17675	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.blm.gov/wo/st/en.html	US Bureau of Land Management 1	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cosumnes-River-ER	Sacramento 41	5.742	Cosumnes River ER	2003	State Conservation Area 8	2
3591	3591	3590	{"type": "Polygon", "coordinates": [[[-124.14742, 40.69347], [-124.14559, 40.69346], [-124.14538, 40.69323], [-124.14529, 40.69315], [-124.1453, 40.6929], [-124.14528, 40.69266], [-124.14516, 40.69246], [-124.14439, 40.69244], [-124.14425, 40.69237], [-124.14377, 40.69258], [-124.14337, 40.6929], [-124.14227, 40.69323], [-124.14201, 40.69328], [-124.14184, 40.69325], [-124.14175, 40.69317], [-124.14175, 40.69315], [-124.1408, 40.6924], [-124.14079, 40.6925], [-124.14074, 40.69274], [-124.14083, 40.69303], [-124.14104, 40.69323], [-124.14057, 40.69342], [-124.14053, 40.69198], [-124.13941, 40.69246], [-124.1312, 40.69009], [-124.13037, 40.68982], [-124.1215, 40.68448], [-124.12146, 40.68269], [-124.11355, 40.68077], [-124.10809, 40.6787], [-124.10786, 40.6787], [-124.10721, 40.67735], [-124.0988, 40.67462], [-124.09604, 40.67387], [-124.09406, 40.67463], [-124.09347, 40.67584], [-124.08834, 40.67698], [-124.08359, 40.67528], [-124.08359, 40.67524], [-124.07786, 40.67485], [-124.07651, 40.67401], [-124.07441, 40.67364], [-124.07124, 40.6721], [-124.06831, 40.6679], [-124.06471, 40.66617], [-124.0647, 40.66617], [-124.0647, 40.6662], [-124.06468, 40.66621], [-124.06319, 40.6653], [-124.05956, 40.66442], [-124.05778, 40.66229], [-124.05384, 40.65824], [-124.05365, 40.65509], [-124.05002, 40.6541], [-124.04946, 40.65278], [-124.04812, 40.65258], [-124.0477, 40.65187], [-124.04497, 40.65101], [-124.04491, 40.6495], [-124.04189, 40.64952], [-124.04106, 40.64851], [-124.04073, 40.64823], [-124.03978, 40.648], [-124.03632, 40.64835], [-124.02927, 40.64745], [-124.03058, 40.63728], [-124.02908, 40.63553], [-124.02749, 40.63464], [-124.02498, 40.63367], [-124.02012, 40.63067], [-124.02289, 40.62734], [-124.02636, 40.62391], [-124.02952, 40.6237], [-124.03035, 40.62414], [-124.0314, 40.62386], [-124.03149, 40.62163], [-124.03431, 40.62178], [-124.0349, 40.62231], [-124.03653, 40.62122], [-124.03747, 40.6213], [-124.03813, 40.6188], [-124.04011, 40.61761], [-124.04263, 40.61339], [-124.04458, 40.61226], [-124.04459, 40.6127], [-124.0446, 40.61271], [-124.05363, 40.61225], [-124.05809, 40.6085], [-124.05947, 40.60912], [-124.06172, 40.60889], [-124.06364, 40.60903], [-124.06361, 40.60599], [-124.06804, 40.60592], [-124.06818, 40.60858], [-124.06892, 40.60908], [-124.06935, 40.61206], [-124.07123, 40.61266], [-124.07203, 40.6147], [-124.07427, 40.6156], [-124.07464, 40.61645], [-124.07765, 40.61879], [-124.08288, 40.61806], [-124.08893, 40.61992], [-124.09223, 40.62186], [-124.09333, 40.62235], [-124.09552, 40.62446], [-124.09889, 40.62474], [-124.10109, 40.62456], [-124.10608, 40.62589], [-124.11182, 40.62545], [-124.11188, 40.6276], [-124.11191, 40.62761], [-124.11131, 40.64262], [-124.10174, 40.64225], [-124.10166, 40.64898], [-124.10191, 40.65658], [-124.10231, 40.66392], [-124.10343, 40.67117], [-124.10615, 40.6712], [-124.10602, 40.67272], [-124.1088, 40.67387], [-124.11149, 40.67583], [-124.11218, 40.67742], [-124.11561, 40.67875], [-124.11596, 40.67875], [-124.11815, 40.67964], [-124.1214, 40.68025], [-124.12141, 40.68024], [-124.12138, 40.67879], [-124.13117, 40.68583], [-124.13949, 40.68965], [-124.14155, 40.68971], [-124.14739, 40.69182], [-124.14742, 40.69347]], [[-124.09275, 40.67312], [-124.09494, 40.67244], [-124.09639, 40.67249], [-124.0964, 40.67248], [-124.08994, 40.66756], [-124.08528, 40.66692], [-124.08296, 40.66327], [-124.08295, 40.66294], [-124.08063, 40.65854], [-124.07603, 40.65701], [-124.06997, 40.65189], [-124.06773, 40.64819], [-124.06452, 40.64798], [-124.06454, 40.64939], [-124.064, 40.64939], [-124.05629, 40.64394], [-124.04659, 40.64056], [-124.04485, 40.63975], [-124.04491, 40.64863], [-124.05539, 40.65476], [-124.05584, 40.65772], [-124.06019, 40.66206], [-124.06478, 40.66376], [-124.06478, 40.66394], [-124.06676, 40.66461], [-124.07068, 40.66745], [-124.07235, 40.67098], [-124.07617, 40.67265], [-124.07829, 40.67329], [-124.0835, 40.67367], [-124.08351, 40.67365], [-124.08626, 40.67453], [-124.08786, 40.67522], [-124.09141, 40.67419], [-124.09275, 40.67312]]]}	Restricted Access 2	29210	Headwaters Forest Reserve	29960	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.blm.gov/wo/st/en.html	US Bureau of Land Management 1	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	http://www.blm.gov/ca/st/en/prog/nlcs/Headwaters_ForestReserve.html	Humboldt 45	7609.194	Headwaters Forest Reserve	0	State Conservation Area 8	2
6676	6676	6675	{"type": "Polygon", "coordinates": [[[-117.1779, 33.42839], [-117.1779, 33.43232], [-117.17339, 33.43239], [-117.17327, 33.42847], [-117.1779, 33.42839]]]}	Restricted Access 2	5517	Santa Margarita Ecological Reserve	33342	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.blm.gov/wo/st/en.html	US Bureau of Land Management 1	221	San Diego State University 378	State 5	State Agency 5	https://fsp.sdsu.edu/about-us/	San Diego 4	45.762	Santa Margarita ER	1962	State Conservation Area 8	2
8388	8388	8387	{"type": "MultiPolygon", "coordinates": [[[[-122.15612, 38.5114], [-122.15602, 38.51461], [-122.13849, 38.5146], [-122.13848, 38.51219], [-122.13854, 38.50977], [-122.13865, 38.50359], [-122.15197, 38.50368], [-122.15222, 38.50001], [-122.15555, 38.49999], [-122.1556, 38.50362], [-122.15219, 38.50368], [-122.15195, 38.5111], [-122.15604, 38.51137], [-122.15612, 38.5114]]], [[[-122.14395, 38.48911], [-122.13942, 38.48915], [-122.13932, 38.48613], [-122.13918, 38.48221], [-122.14358, 38.48228], [-122.14395, 38.48911]]], [[[-122.15728, 38.48585], [-122.15276, 38.48591], [-122.15247, 38.48241], [-122.15699, 38.48233], [-122.15728, 38.48585]]]]}	Restricted Access 2	48483	Quail Ridge Reserve	33192	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.blm.gov/wo/st/en.html	US Bureau of Land Management 1	217	University of California 51	State 5	State Agency 5	https://ucnrs.org/reserves/quail-ridge-reserve/	Napa 11	529.199	Quail Ridge Reserve	0	State Conservation Area 8	2
15052	15052	15051	{"type": "MultiPolygon", "coordinates": [[[[-117.25255, 33.80464], [-117.24993, 33.80461], [-117.24825, 33.80463], [-117.24827, 33.80108], [-117.25252, 33.80114], [-117.25255, 33.80464]]], [[[-117.26585, 33.81556], [-117.26585, 33.81919], [-117.26149, 33.81923], [-117.26146, 33.81559], [-117.26585, 33.81556]]]]}	Restricted Access 2	48493	Motte Rimrock Reserve	22519	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.blm.gov/wo/st/en.html	US Bureau of Land Management 1	217	University of California 51	State 5	State Agency 5	https://ucnrs.org/reserves/motte-rimrock-reserve/	Riverside 10	78.529	Motte Rimrock Reserve	0	State Conservation Area 8	2
15568	15568	15567	{"type": "MultiPolygon", "coordinates": [[[[-117.15855, 33.46486], [-117.15421, 33.46507], [-117.14524, 33.46588], [-117.14538, 33.46928], [-117.14494, 33.46886], [-117.14213, 33.46585], [-117.13783, 33.46151], [-117.1408, 33.46153], [-117.14069, 33.45434], [-117.13656, 33.45432], [-117.13646, 33.45406], [-117.13637, 33.45348], [-117.1363, 33.45254], [-117.13632, 33.44932], [-117.13637, 33.4487], [-117.13646, 33.448], [-117.13653, 33.44776], [-117.13676, 33.44716], [-117.15344, 33.4472], [-117.15396, 33.4616], [-117.1584, 33.46141], [-117.15855, 33.46486]]], [[[-117.20649, 33.43578], [-117.20644, 33.44303], [-117.19756, 33.44297], [-117.1975, 33.44657], [-117.19305, 33.44653], [-117.19309, 33.44294], [-117.18865, 33.44291], [-117.18876, 33.43575], [-117.19321, 33.43576], [-117.19316, 33.43934], [-117.19759, 33.43937], [-117.19765, 33.43577], [-117.20649, 33.43578]]]]}	Restricted Access 2	5509	Santa Margarita Ecological Reserve	33342	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.blm.gov/wo/st/en.html	US Bureau of Land Management 1	221	San Diego State University 378	State 5	State Agency 5	https://fsp.sdsu.edu/about-us/	Riverside 10	1078.683	Santa Margarita ER	1962	State Conservation Area 8	2

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