calands: units_with_maps: 77 rows where ACCESS_TYP = 3, AGNCY_NAME = 25 and MNG_AG

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

77 rows where ACCESS_TYP = 3, AGNCY_NAME = 25 and MNG_AG_TYP = 5

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
228	228	227	{"type": "Polygon", "coordinates": [[[-122.33028, 41.31414], [-122.32908, 41.31415], [-122.32909, 41.31022], [-122.32966, 41.31067], [-122.33018, 41.31094], [-122.33021, 41.31196], [-122.33028, 41.31197], [-122.33028, 41.31414]]]}	No Public Access 3	621	Elsa Rupp Natural Area	32160	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		Siskiyou 28	9.475	Elsa Rupp Natural Area		None 26
545	545	544	{"type": "Polygon", "coordinates": [[[-122.31307, 41.2763], [-122.31264, 41.2763], [-122.31266, 41.2752], [-122.31307, 41.2752], [-122.31307, 41.2763]]]}	No Public Access 3	1814	Lower Box Canyon	32208	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		Siskiyou 28	1.061	Lower Box Canyon	0	State Resource Management Area 55	3
1130	1130	1129	{"type": "Polygon", "coordinates": [[[-118.05045, 37.26696], [-118.05032, 37.28884], [-118.04578, 37.2888], [-118.0458, 37.28518], [-118.04122, 37.28514], [-118.04125, 37.28152], [-118.03671, 37.28148], [-118.03674, 37.27786], [-118.03221, 37.27783], [-118.0323, 37.26688], [-118.05045, 37.26696]]]}	No Public Access 3	6619	Deep Springs Lake	32146	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	725.874	Deep Springs Lake	0	State Resource Management Area 55	3
1362	1362	1361	{"type": "MultiPolygon", "coordinates": [[[[-120.54592, 36.6911], [-120.53904, 36.69108], [-120.53903, 36.68751], [-120.53931, 36.68748], [-120.53932, 36.67661], [-120.53965, 36.67662], [-120.54592, 36.6911]]], [[[-120.54644, 36.69054], [-120.54632, 36.69071], [-120.54625, 36.69074], [-120.54003, 36.67662], [-120.54028, 36.67664], [-120.54644, 36.69054]]]]}	No Public Access 3	8074	Pilobos	32263	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	134.36	Pilobos	0	State Resource Management Area 55	3
1551	1551	1550	{"type": "Polygon", "coordinates": [[[-117.15937, 33.4648], [-117.15693, 33.46596], [-117.15546, 33.46627], [-117.1551, 33.46876], [-117.15582, 33.4699], [-117.15547, 33.4701], [-117.15359, 33.47159], [-117.15293, 33.47188], [-117.14835, 33.47303], [-117.14752, 33.4732], [-117.14553, 33.47346], [-117.1454, 33.4735], [-117.1452, 33.47361], [-117.14441, 33.47424], [-117.14428, 33.4744], [-117.14423, 33.47451], [-117.14422, 33.47465], [-117.14428, 33.47512], [-117.14445, 33.47524], [-117.14434, 33.47534], [-117.14243, 33.47398], [-117.14117, 33.47457], [-117.1392, 33.47439], [-117.13887, 33.4735], [-117.14494, 33.46886], [-117.14521, 33.46914], [-117.14523, 33.46914], [-117.14519, 33.46582], [-117.15408, 33.46502], [-117.15937, 33.4648]]]}	No Public Access 3	11546	Santa Margarita Ecological Reserve	33343	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	221	San Diego State University 378	State 5	State Agency 5	https://fsp.sdsu.edu/about-us/	Riverside 10	243.178	Santa Margarita ER	1962	State Conservation Area 8	2
1581	1581	1580	{"type": "Polygon", "coordinates": [[[-115.54599, 33.539], [-115.53693, 33.53898], [-115.53689, 33.53374], [-115.53922, 33.53373], [-115.53931, 33.53565], [-115.54152, 33.53564], [-115.54145, 33.53741], [-115.54597, 33.53769], [-115.54599, 33.539]]]}	No Public Access 3	12128	Chuckwalla Bench	32115	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		Riverside 10	66.962	Chuckwalla Bench	0	State Resource Management Area 55	3
1949	1949	1948	{"type": "Polygon", "coordinates": [[[-119.3411, 35.24915], [-119.33804, 35.25071], [-119.33274, 35.25344], [-119.32347, 35.25337], [-119.32342, 35.24243], [-119.33225, 35.24252], [-119.3322, 35.23881], [-119.34107, 35.23889], [-119.3411, 35.24915]]]}	No Public Access 3	16653	Elk Hills	32158	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		Kern 36	517.552	Elk Hills	0	State Resource Management Area 55	3
1956	1956	1955	{"type": "Polygon", "coordinates": [[[-117.8303, 35.57191], [-117.83026, 35.57926], [-117.82582, 35.57925], [-117.82581, 35.58284], [-117.82577, 35.58649], [-117.82128, 35.58644], [-117.82132, 35.58281], [-117.82141, 35.57924], [-117.82581, 35.57924], [-117.82587, 35.57561], [-117.82586, 35.5756], [-117.82143, 35.57557], [-117.82145, 35.57191], [-117.8303, 35.57191]]]}	No Public Access 3	16665	Indian Wells Valley	32190	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		Kern 36	201.555	Indian Wells Valley	0	State Resource Management Area 55	3
2417	2417	2416	{"type": "Polygon", "coordinates": [[[-120.82613, 36.92597], [-120.81978, 36.92585], [-120.82012, 36.91517], [-120.82491, 36.91943], [-120.82613, 36.92597]]]}	No Public Access 3	17273	Dos Amigos	32151	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		Merced 37	114.925	Dos Amigos	0	State Resource Management Area 55	3
2428	2428	2427	{"type": "MultiPolygon", "coordinates": [[[[-120.39692, 37.50741], [-120.39664, 37.51843], [-120.39339, 37.51813], [-120.39035, 37.51702], [-120.3889, 37.51665], [-120.38848, 37.51633], [-120.3843, 37.51606], [-120.38436, 37.5155], [-120.38449, 37.51059], [-120.38471, 37.51053], [-120.38563, 37.51016], [-120.38827, 37.50854], [-120.3895, 37.50769], [-120.39086, 37.50715], [-120.39629, 37.50707], [-120.39692, 37.50741]]], [[[-120.39693, 37.50636], [-120.39692, 37.50692], [-120.39645, 37.50666], [-120.39073, 37.50674], [-120.38921, 37.50734], [-120.38794, 37.50822], [-120.38536, 37.50981], [-120.3845, 37.51015], [-120.38462, 37.50621], [-120.39333, 37.50635], [-120.39693, 37.50636]]]]}	No Public Access 3	17291	Merced River	32217	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		Merced 37	311.747	Merced River	0	State Resource Management Area 55	3
2481	2481	2480	{"type": "Polygon", "coordinates": [[[-122.19661, 40.26979], [-122.19658, 40.27249], [-122.19162, 40.27297], [-122.18953, 40.27326], [-122.19087, 40.26973], [-122.19661, 40.26979]]]}	No Public Access 3	17478	Bend Ferry Road	32047	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		Tehama 18	45.388	Bend Ferry Road	0	State Resource Management Area 55	3
2631	2631	2630	{"type": "Polygon", "coordinates": [[[-121.49959, 37.6491], [-121.49457, 37.649], [-121.49018, 37.64886], [-121.49073, 37.64768], [-121.49079, 37.6476], [-121.49097, 37.64704], [-121.49108, 37.64648], [-121.49155, 37.63993], [-121.4916, 37.63962], [-121.49221, 37.6393], [-121.4944, 37.63887], [-121.49444, 37.63989], [-121.4952, 37.64234], [-121.49679, 37.64307], [-121.49847, 37.64757], [-121.49959, 37.6491]], [[-121.49355, 37.64011], [-121.49277, 37.64012], [-121.49267, 37.64151], [-121.49369, 37.64277], [-121.49423, 37.64241], [-121.49463, 37.64166], [-121.49429, 37.64112], [-121.49355, 37.64011]]]}	No Public Access 3	18038	Corral Hollow Ecological Reserve	32134	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		San Joaquin 39	125.166	Corral Hollow ER	0	State Conservation Area 8	2
3147	3147	3146	{"type": "MultiPolygon", "coordinates": [[[[-120.81642, 38.5584], [-120.8161, 38.55859], [-120.81609, 38.55862], [-120.81611, 38.55839], [-120.81642, 38.5584]]], [[[-120.82405, 38.55808], [-120.82414, 38.55836], [-120.82417, 38.55862], [-120.82414, 38.55901], [-120.82407, 38.55919], [-120.82377, 38.55954], [-120.82358, 38.55964], [-120.82332, 38.55973], [-120.82311, 38.55974], [-120.82289, 38.55977], [-120.82264, 38.55976], [-120.82233, 38.5597], [-120.82197, 38.55968], [-120.82166, 38.55965], [-120.82129, 38.55955], [-120.82089, 38.55941], [-120.8206, 38.55925], [-120.82011, 38.55885], [-120.81942, 38.55845], [-120.81877, 38.55822], [-120.81842, 38.55813], [-120.81821, 38.55806], [-120.82405, 38.55808]]]]}	No Public Access 3	21619	Upper Cosumnes River	32342	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		Amador 52	15.616	Upper Cosumnes River	0	State Resource Management Area 55	3
3167	3167	3166	{"type": "MultiPolygon", "coordinates": [[[[-116.68524, 34.06247], [-116.6852, 34.07681], [-116.66784, 34.07682], [-116.66779, 34.06235], [-116.65036, 34.06223], [-116.65034, 34.04784], [-116.66779, 34.04785], [-116.6678, 34.06235], [-116.68524, 34.06247]]], [[[-116.6938, 34.10576], [-116.69375, 34.11974], [-116.68527, 34.11965], [-116.6851, 34.10573], [-116.66771, 34.1057], [-116.66798, 34.09129], [-116.68529, 34.09155], [-116.6851, 34.10573], [-116.6938, 34.10576]]]]}	No Public Access 3	21980	Mission Creek	32221	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		San Bernardino 22	2202.531	Mission Creek	0	State Resource Management Area 55	3
3296	3296	3295	{"type": "Polygon", "coordinates": [[[-121.61412, 37.7845], [-121.61412, 37.78579], [-121.61407, 37.78736], [-121.60506, 37.78748], [-121.605, 37.78452], [-121.6051, 37.78452], [-121.60511, 37.78451], [-121.61412, 37.7845]]]}	No Public Access 3	23599	Christensen Road Burrowing Owl Site	32113	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		Alameda 17	63.899	Christensen Road Burrowing Owl Site	0	State Resource Management Area 55	3
3427	3427	3426	{"type": "Polygon", "coordinates": [[[-122.01238, 36.97053], [-122.01187, 36.97081], [-122.01185, 36.97079], [-122.01191, 36.97056], [-122.01223, 36.97036], [-122.01238, 36.97053]]]}	No Public Access 3	25174	South Branciforte	32313	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		Santa Cruz 5	0.251	South Branciforte	0	State Resource Management Area 55	3
3439	3439	3438	{"type": "Polygon", "coordinates": [[[-116.69795, 34.67637], [-116.68049, 34.67634], [-116.68049, 34.67369], [-116.69794, 34.67376], [-116.69795, 34.67637]]]}	No Public Access 3	25252	Ord Rodman	32252	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		San Bernardino 22	115.534	Ord Rodman	0	State Resource Management Area 55	3
3441	3441	3440	{"type": "Polygon", "coordinates": [[[-120.25813, 38.62982], [-120.25788, 38.63346], [-120.25343, 38.63333], [-120.25308, 38.63683], [-120.24397, 38.63654], [-120.2445, 38.63308], [-120.24896, 38.63318], [-120.2494, 38.62968], [-120.25813, 38.62982]]]}	No Public Access 3	25249	Leek Springs Ecological Reserve	32201	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		El Dorado 34	151.078	Leek Springs ER	0	State Conservation Area 8	2
3442	3442	3441	{"type": "Polygon", "coordinates": [[[-123.96676, 41.87177], [-123.95707, 41.87178], [-123.95706, 41.86815], [-123.96193, 41.86808], [-123.96197, 41.86444], [-123.96673, 41.86439], [-123.96667, 41.86953], [-123.96676, 41.87177]]]}	No Public Access 3	25256	Stoney Creek	32321	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		Del Norte 50	120.393	Stoney Creek	0	State Resource Management Area 55	3
3485	3485	3484	{"type": "Polygon", "coordinates": [[[-123.05209, 38.33746], [-123.05198, 38.33754], [-123.05179, 38.33741], [-123.05131, 38.33782], [-123.05136, 38.33837], [-123.04991, 38.33944], [-123.04926, 38.33873], [-123.05025, 38.33836], [-123.05118, 38.33786], [-123.05131, 38.33741], [-123.05145, 38.33698], [-123.05209, 38.33746]]]}	No Public Access 3	25904	Bodega Bay Monarch Butterfly	32057	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		Sonoma 16	4.076	Bodega Bay Monarch Butterfly	0	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]);