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

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

6 rows where ACCESS_TYP = 1, DES_TP = 55 and LAYER = 6

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	DES_TP	GAP_STS
2853	2853	2852	{"type": "Polygon", "coordinates": [[[-123.12633, 39.12775], [-123.12199, 39.12765], [-123.12186, 39.12406], [-123.12181, 39.12124], [-123.12251, 39.12168], [-123.12399, 39.12253], [-123.12435, 39.12276], [-123.1246, 39.12316], [-123.12473, 39.12355], [-123.12507, 39.12389], [-123.12597, 39.1242], [-123.12633, 39.12775]]]}	Open Access 1	22154	Mill Creek	32219	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5		Mendocino 24	49.861	Mill Creek	State Resource Management Area 55	3
3142	3142	3141	{"type": "Polygon", "coordinates": [[[-124.10364, 40.82505], [-124.10204, 40.8308], [-124.10044, 40.83153], [-124.0966, 40.82984], [-124.08606, 40.82989], [-124.08663, 40.82862], [-124.08651, 40.82861], [-124.08712, 40.82752], [-124.08784, 40.82592], [-124.08642, 40.82542], [-124.08642, 40.82541], [-124.08628, 40.82535], [-124.08666, 40.82496], [-124.08699, 40.82469], [-124.08887, 40.82328], [-124.08903, 40.82319], [-124.08922, 40.82304], [-124.10364, 40.82505]], [[-124.08767, 40.82431], [-124.08749, 40.82436], [-124.08737, 40.8245], [-124.08721, 40.82478], [-124.08704, 40.82493], [-124.08715, 40.82496], [-124.08717, 40.82494], [-124.09118, 40.82586], [-124.0918, 40.8249], [-124.0918, 40.82489], [-124.08767, 40.82431]]]}	Open Access 1	21590	Bracut Tidelands	32065	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5		Humboldt 45	222.41	Bracut Tidelands	State Resource Management Area 55	3
3437	3437	3436	{"type": "Polygon", "coordinates": [[[-122.4138, 38.46446], [-122.41344, 38.465], [-122.41272, 38.46514], [-122.41239, 38.46481], [-122.41285, 38.46468], [-122.41297, 38.46463], [-122.41332, 38.46455], [-122.41347, 38.4645], [-122.41361, 38.46442], [-122.41379, 38.46439], [-122.4138, 38.46446]]]}	Open Access 1	25245	Rutherford Crossroad	32278	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5		Napa 11	1.213	Rutherford Crossroad	State Resource Management Area 55	3
3677	3677	3676	{"type": "Polygon", "coordinates": [[[-118.24726, 36.83321], [-118.24275, 36.83325], [-118.24273, 36.82962], [-118.24642, 36.8296], [-118.24725, 36.8304], [-118.24726, 36.83321]]]}	Open Access 1	44355	Mount Whitney Facility	32237	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5		Inyo 43	39.204	Mount Whitney Facility	State Resource Management Area 55	3
7132	7132	7131	{"type": "MultiPolygon", "coordinates": [[[[-119.41323, 36.78389], [-119.41298, 36.78429], [-119.41297, 36.78478], [-119.41308, 36.78757], [-119.41299, 36.78847], [-119.41167, 36.78916], [-119.4116, 36.78454], [-119.40887, 36.78451], [-119.40928, 36.78346], [-119.41097, 36.78354], [-119.411, 36.7831], [-119.41, 36.78308], [-119.41079, 36.78223], [-119.41154, 36.78298], [-119.41323, 36.78389]]], [[[-119.41291, 36.78956], [-119.41289, 36.7902], [-119.41169, 36.79021], [-119.41169, 36.79009], [-119.41163, 36.79008], [-119.41163, 36.78953], [-119.41265, 36.78953], [-119.41266, 36.78957], [-119.41291, 36.78956]]]]}	Open Access 1	6750	Avocado Lake	32030	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5		Fresno 9	29.362	Avocado Lake	State Resource Management Area 55	3
14181	14181	14180	{"type": "Polygon", "coordinates": [[[-121.66704, 38.30674], [-121.66711, 38.29215], [-121.66689, 38.29214], [-121.66479, 38.28461], [-121.66567, 38.28461], [-121.66546, 38.28383], [-121.66512, 38.28384], [-121.66506, 38.2834], [-121.66532, 38.28258], [-121.6652, 38.28236], [-121.66582, 38.2792], [-121.66565, 38.27778], [-121.66604, 38.27487], [-121.66586, 38.2745], [-121.6662, 38.27417], [-121.66682, 38.27319], [-121.66798, 38.27229], [-121.66873, 38.27113], [-121.66893, 38.27056], [-121.67055, 38.26728], [-121.67071, 38.26663], [-121.67115, 38.26627], [-121.67166, 38.26594], [-121.67172, 38.26571], [-121.67128, 38.26549], [-121.67108, 38.2653], [-121.67117, 38.26509], [-121.67135, 38.26481], [-121.67137, 38.26456], [-121.6713, 38.26404], [-121.67114, 38.26361], [-121.67086, 38.26332], [-121.671, 38.2631], [-121.67108, 38.26268], [-121.6708, 38.26223], [-121.6711, 38.26175], [-121.67118, 38.26061], [-121.67141, 38.25938], [-121.6719, 38.25794], [-121.67193, 38.25681], [-121.67226, 38.25623], [-121.67221, 38.25603], [-121.67205, 38.25592], [-121.67175, 38.25486], [-121.67171, 38.2545], [-121.6722, 38.25419], [-121.67289, 38.25384], [-121.67332, 38.2534], [-121.67328, 38.25262], [-121.6734, 38.25189], [-121.67488, 38.24991], [-121.67537, 38.2491], [-121.67571, 38.24824], [-121.67615, 38.24774], [-121.67768, 38.24681], [-121.67798, 38.24622], [-121.67884, 38.24467], [-121.6796, 38.24357], [-121.67995, 38.24296], [-121.68045, 38.24277], [-121.68096, 38.24265], [-121.68156, 38.2422], [-121.68197, 38.24163], [-121.6821, 38.24018], [-121.6823, 38.23991], [-121.68291, 38.23965], [-121.6835, 38.23914], [-121.68373, 38.23907], [-121.68396, 38.23915], [-121.68414, 38.23999], [-121.68443, 38.24064], [-121.68682, 38.2428], [-121.68722, 38.24331], [-121.6874, 38.24379], [-121.68732, 38.2444], [-121.68723, 38.2447], [-121.68625, 38.24654], [-121.68615, 38.24708], [-121.68627, 38.2481], [-121.68604, 38.24866], [-121.68596, 38.24898], [-121.68645, 38.24994], [-121.6867, 38.25102], [-121.68674, 38.25173], [-121.68639, 38.25299], [-121.68645, 38.25409], [-121.68668, 38.25514], [-121.68686, 38.25555], [-121.68787, 38.25645], [-121.68873, 38.25706], [-121.6907, 38.25773], [-121.69112, 38.25798], [-121.69112, 38.25842], [-121.69098, 38.25908], [-121.69069, 38.26088], [-121.69048, 38.26148], [-121.69042, 38.26187], [-121.69038, 38.26242], [-121.69017, 38.26295], [-121.69025, 38.26341], [-121.69106, 38.26589], [-121.69161, 38.26645], [-121.69192, 38.26775], [-121.69201, 38.26829], [-121.69176, 38.26862], [-121.6915, 38.26951], [-121.69164, 38.27004], [-121.69274, 38.27049], [-121.69295, 38.27093], [-121.69269, 38.27144], [-121.6924, 38.27197], [-121.69227, 38.27236], [-121.69283, 38.27315], [-121.69344, 38.27387], [-121.69361, 38.27471], [-121.69394, 38.27552], [-121.69417, 38.27629], [-121.69443, 38.27699], [-121.69449, 38.27782], [-121.69429, 38.27817], [-121.69371, 38.27938], [-121.69339, 38.27988], [-121.69231, 38.28247], [-121.69222, 38.28336], [-121.69228, 38.28474], [-121.69337, 38.28475], [-121.6934, 38.28572], [-121.69344, 38.2912], [-121.69345, 38.30007], [-121.69343, 38.30224], [-121.69348, 38.3024], [-121.69346, 38.30395], [-121.69348, 38.3055], [-121.69345, 38.30655], [-121.69172, 38.30635], [-121.69169, 38.30626], [-121.69052, 38.30645], [-121.67593, 38.30641], [-121.67594, 38.30653], [-121.69054, 38.30657], [-121.69123, 38.30649], [-121.69181, 38.30646], [-121.6932, 38.3066], [-121.69345, 38.30671], [-121.69341, 38.31443], [-121.66772, 38.31408], [-121.66723, 38.31409], [-121.66704, 38.30674]]]}	Open Access 1	43100	Liberty Island	32352	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Liberty-Island-ER	Solano 26	3873.908	Liberty Island	State Resource Management Area 55	3

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