calands: units_with_maps: 22 rows where ACCESS_TYP = 3 and DES

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

22 rows where ACCESS_TYP = 3 and DES_TP = 8

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
1331	1331	1330	{"type": "Polygon", "coordinates": [[[-117.30505, 33.972], [-117.30065, 33.97196], [-117.30065, 33.97556], [-117.29645, 33.97552], [-117.2965, 33.96463], [-117.30083, 33.96465], [-117.30087, 33.96815], [-117.30505, 33.96813], [-117.30505, 33.972]]]}	No Public Access 3	47644	Box Springs Reserve	31388	217	University of California 53	State 5	State Agency 5	http://nrs.ucop.edu/	Other State 5	217	University of California 51	State 5	State Agency 5	http://www.ucnrs.org/reserves/box-springs-reserve.html	Riverside 10	159.828	Box Springs Reserve	0	State Conservation Area 8	2
1332	1332	1331	{"type": "Polygon", "coordinates": [[[-116.45768, 34.14968], [-116.45334, 34.1497], [-116.45333, 34.15015], [-116.45115, 34.15016], [-116.45115, 34.14929], [-116.44898, 34.1493], [-116.44892, 34.13524], [-116.45764, 34.13534], [-116.45767, 34.14247], [-116.45768, 34.14968]], [[-116.45762, 34.14811], [-116.45654, 34.14811], [-116.45653, 34.14608], [-116.45332, 34.1461], [-116.45333, 34.14699], [-116.45654, 34.14833], [-116.45761, 34.14833], [-116.45762, 34.14811]]]}	No Public Access 3	47645	Burns Piñon Ridge Reserve	31389	217	University of California 53	State 5	State Agency 5	http://nrs.ucop.edu/	Other State 5	217	University of California 51	State 5	State Agency 5	http://www.ucnrs.org/reserves/burns-pinon-ridge-reserve.html	San Bernardino 22	304.422	Burns Piñon Ridge Reserve	0	State Conservation Area 8	2
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
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
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
4395	4395	4394	{"type": "Polygon", "coordinates": [[[-118.60789, 37.41288], [-118.60787, 37.41414], [-118.60753, 37.41449], [-118.60753, 37.41492], [-118.60774, 37.41516], [-118.60339, 37.41611], [-118.59577, 37.41603], [-118.59579, 37.41253], [-118.59971, 37.41251], [-118.60257, 37.41244], [-118.60451, 37.41246], [-118.60454, 37.41298], [-118.60497, 37.413], [-118.60497, 37.41273], [-118.60737, 37.41274], [-118.60738, 37.41284], [-118.60789, 37.41288]]]}	No Public Access 3	48600	Round Valley Wildlife Area	33312	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	97.218	Round Valley Wildlife Area	1993	State Conservation Area 8	2
6527	6527	6526	{"type": "Polygon", "coordinates": [[[-121.21611, 38.65634], [-121.21517, 38.65635], [-121.2144, 38.65533], [-121.21395, 38.65428], [-121.21608, 38.65427], [-121.21611, 38.65634]]]}	No Public Access 3	2848	Phoenix Field Ecological Reserve	32261	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		Sacramento 41	8.007	Phoenix Field ER	0	State Conservation Area 8	2
7238	7238	7237	{"type": "Polygon", "coordinates": [[[-116.40815, 33.62707], [-116.40367, 33.6271], [-116.40321, 33.62712], [-116.40272, 33.62712], [-116.40277, 33.62581], [-116.40283, 33.62536], [-116.40298, 33.62502], [-116.40321, 33.62472], [-116.40343, 33.62452], [-116.4037, 33.62436], [-116.40395, 33.62425], [-116.40505, 33.62391], [-116.40545, 33.62377], [-116.4061, 33.62346], [-116.40655, 33.62317], [-116.40705, 33.62276], [-116.40753, 33.62235], [-116.40796, 33.62211], [-116.40815, 33.62343], [-116.40815, 33.62707]]]}	No Public Access 3	29180	Hidden Palms Ecological Reserve	32184	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	47.345	Hidden Palms ER	0	State Conservation Area 8	2
8054	8054	8053	{"type": "Polygon", "coordinates": [[[-117.24639, 34.2514], [-117.24262, 34.25146], [-117.2426, 34.25152], [-117.24249, 34.25502], [-117.23823, 34.25519], [-117.23846, 34.24793], [-117.24636, 34.24797], [-117.24639, 34.2514]]]}	No Public Access 3	11821	San Bernardino Mountains Wildlife Corridor	32288	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	109.636	San Bernardino Mtns. Wildlife Corridor	0	State Conservation Area 8	2
9250	9250	9249	{"type": "MultiPolygon", "coordinates": [[[[-116.44947, 33.88499], [-116.44723, 33.88499], [-116.44529, 33.88496], [-116.4457, 33.88489], [-116.44596, 33.88482], [-116.44707, 33.88443], [-116.44732, 33.88435], [-116.44773, 33.88427], [-116.44824, 33.8842], [-116.44946, 33.88418], [-116.44947, 33.88499]]], [[[-116.46255, 33.8886], [-116.46251, 33.89218], [-116.45813, 33.89218], [-116.45819, 33.88861], [-116.46255, 33.8886]]], [[[-116.47988, 33.89224], [-116.47985, 33.89496], [-116.47554, 33.89498], [-116.47555, 33.89223], [-116.47988, 33.89224]]]]}	No Public Access 3	15404	Edom Hill-Willow Hole Preserve	18453	214	Coachella Valley Mountains Conservancy 767	State 5	State Agency 5	http://www.cvmc.ca.gov/	Other State 5	214	Coachella Valley Mountains Conservancy 748	State 5	State Agency 5		Riverside 10	75.092	Edom Hill-Willow Hole Preserve	0	State Conservation Area 8	2
9251	9251	9250	{"type": "Polygon", "coordinates": [[[-116.47394, 33.88857], [-116.47122, 33.88857], [-116.47122, 33.88785], [-116.47129, 33.88596], [-116.47394, 33.88857]]]}	No Public Access 3	15407	Edom Hill-Willow Hole Preserve	18453	214	Coachella Valley Mountains Conservancy 767	State 5	State Agency 5	http://www.cvmc.ca.gov/	Other State 5	214	Coachella Valley Mountains Conservancy 748	State 5	State Agency 5		Riverside 10	9.085	Edom Hill-Willow Hole Preserve	0	State Conservation Area 8	2
10466	10466	10465	{"type": "Polygon", "coordinates": [[[-120.90912, 38.31308], [-120.909, 38.31682], [-120.90552, 38.31687], [-120.90527, 38.31584], [-120.90514, 38.31541], [-120.90507, 38.31524], [-120.90461, 38.31438], [-120.90456, 38.3131], [-120.90912, 38.31308]]]}	No Public Access 3	21588	Apricum Hill Ecological Reserve	32028	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	37.029	Apricum Hill ER	0	State Conservation Area 8	2
11282	11282	11281	{"type": "Polygon", "coordinates": [[[-121.41367, 38.23999], [-121.41393, 38.24073], [-121.41403, 38.24115], [-121.41401, 38.24182], [-121.41387, 38.2422], [-121.41372, 38.24252], [-121.41349, 38.24273], [-121.4134, 38.24305], [-121.41338, 38.24337], [-121.41318, 38.24429], [-121.41301, 38.24479], [-121.41253, 38.2454], [-121.41205, 38.2458], [-121.41183, 38.24594], [-121.41149, 38.2461], [-121.41107, 38.24659], [-121.41077, 38.24686], [-121.41051, 38.24724], [-121.41014, 38.24789], [-121.40986, 38.24824], [-121.4098, 38.24835], [-121.40967, 38.24845], [-121.40943, 38.24856], [-121.40929, 38.24867], [-121.40924, 38.24878], [-121.40917, 38.24913], [-121.40828, 38.25009], [-121.40789, 38.25041], [-121.40766, 38.25056], [-121.40722, 38.25103], [-121.40677, 38.25159], [-121.40616, 38.25214], [-121.40585, 38.25266], [-121.40583, 38.25277], [-121.40585, 38.25291], [-121.40612, 38.25307], [-121.40671, 38.25329], [-121.4067, 38.25337], [-121.4064, 38.25349], [-121.40605, 38.25368], [-121.40588, 38.2538], [-121.4057, 38.25401], [-121.40567, 38.25411], [-121.40595, 38.25412], [-121.40522, 38.25423], [-121.40433, 38.25417], [-121.4041, 38.25411], [-121.40216, 38.2541], [-121.40127, 38.25383], [-121.40146, 38.25112], [-121.40144, 38.25103], [-121.40136, 38.25096], [-121.40126, 38.25093], [-121.39906, 38.25089], [-121.39863, 38.25068], [-121.3983, 38.25048], [-121.39765, 38.24996], [-121.39734, 38.24974], [-121.39617, 38.24779], [-121.39663, 38.24661], [-121.39638, 38.24624], [-121.39618, 38.246], [-121.39563, 38.24543], [-121.39533, 38.24509], [-121.39504, 38.24486], [-121.39474, 38.24467], [-121.39269, 38.24467], [-121.39251, 38.2447], [-121.39178, 38.24494], [-121.39059, 38.24485], [-121.39026, 38.24475], [-121.38955, 38.24426], [-121.38627, 38.24134], [-121.38819, 38.24132], [-121.3925, 38.24131], [-121.39949, 38.24126], [-121.39985, 38.24123], [-121.40024, 38.24113], [-121.40047, 38.24103], [-121.40227, 38.24019], [-121.40258, 38.24009], [-121.40298, 38.24003], [-121.41367, 38.23999]]]}	No Public Access 3	21821	Grizzly Slough	30567	207	California Department of Water Resources 477	State 5	State Agency 5	http://www.water.ca.gov/	Other State 5	207	California Department of Water Resources 470	State 5	State Agency 5		Sacramento 41	487.047	Grizzly Slough	0	State Conservation Area 8	2
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
13158	13158	13157	{"type": "Polygon", "coordinates": [[[-122.52495, 38.06971], [-122.52293, 38.06978], [-122.52096, 38.07133], [-122.51104, 38.06343], [-122.5006, 38.06098], [-122.49657, 38.06008], [-122.49222, 38.05907], [-122.49669, 38.05127], [-122.498, 38.04907], [-122.49841, 38.04941], [-122.49892, 38.04861], [-122.49891, 38.04859], [-122.49831, 38.04855], [-122.49847, 38.04828], [-122.49848, 38.04785], [-122.50668, 38.04784], [-122.50668, 38.04742], [-122.50731, 38.04741], [-122.50732, 38.0474], [-122.50668, 38.04689], [-122.50851, 38.04693], [-122.50972, 38.04814], [-122.51013, 38.04801], [-122.51102, 38.04913], [-122.51148, 38.05001], [-122.51052, 38.05012], [-122.51044, 38.05017], [-122.5105, 38.05049], [-122.50943, 38.05062], [-122.50805, 38.05113], [-122.50669, 38.0522], [-122.50669, 38.05222], [-122.5098, 38.05469], [-122.51448, 38.06081], [-122.51476, 38.06197], [-122.51638, 38.06325], [-122.51678, 38.06343], [-122.51743, 38.06392], [-122.51755, 38.06389], [-122.51761, 38.06395], [-122.5176, 38.06404], [-122.51799, 38.06436], [-122.51829, 38.06465], [-122.51843, 38.0647], [-122.51859, 38.06467], [-122.52495, 38.06971]]]}	No Public Access 3	35102	Hamilton Wetlands	19625	200	California State Coastal Conservancy 859	State 5	State Agency 5	http://www.scc.ca.gov/	Other State 5	200	California State Coastal Conservancy 837	State 5	State Agency 5		Marin 23	632.955	Hamilton Wetlands	0	State Conservation Area 8	2
13162	13162	13161	{"type": "Polygon", "coordinates": [[[-121.69523, 37.99864], [-121.69516, 37.99875], [-121.69492, 37.99898], [-121.69489, 37.99899], [-121.69479, 37.99908], [-121.6946, 37.99933], [-121.69451, 37.99949], [-121.69412, 38.00034], [-121.69357, 38.00137], [-121.69349, 38.00155], [-121.69341, 38.00178], [-121.69332, 38.00199], [-121.69256, 38.00334], [-121.69235, 38.00375], [-121.69214, 38.00408], [-121.69172, 38.00498], [-121.69157, 38.0052], [-121.6915, 38.00533], [-121.69134, 38.00615], [-121.6913, 38.00678], [-121.69131, 38.00698], [-121.69117, 38.00802], [-121.69114, 38.00835], [-121.69102, 38.00912], [-121.691, 38.00933], [-121.69101, 38.01008], [-121.69106, 38.01024], [-121.69104, 38.01035], [-121.69121, 38.01057], [-121.69102, 38.01082], [-121.69092, 38.01111], [-121.6909, 38.01129], [-121.69083, 38.01153], [-121.69057, 38.01169], [-121.69041, 38.01184], [-121.69042, 38.01202], [-121.69037, 38.01241], [-121.68974, 38.01329], [-121.68931, 38.01338], [-121.68885, 38.01329], [-121.68808, 38.0132], [-121.68616, 38.01353], [-121.68476, 38.01351], [-121.68233, 38.012], [-121.6797, 38.01151], [-121.6779, 38.01073], [-121.67466, 38.01191], [-121.67439, 38.01196], [-121.67438, 38.01228], [-121.66372, 38.01239], [-121.66372, 38.01234], [-121.66361, 38.01228], [-121.66332, 38.01219], [-121.66305, 38.01222], [-121.66269, 38.0124], [-121.66098, 38.01241], [-121.66075, 38.01191], [-121.66066, 38.01164], [-121.6605, 38.0114], [-121.65932, 38.0089], [-121.65922, 38.00863], [-121.65914, 38.00835], [-121.65911, 38.00795], [-121.65919, 37.99845], [-121.66012, 37.99845], [-121.66014, 37.99791], [-121.66013, 37.9979], [-121.6592, 37.9979], [-121.65925, 37.99124], [-121.66028, 37.99208], [-121.66047, 37.99221], [-121.66068, 37.99233], [-121.6609, 37.99243], [-121.66357, 37.99352], [-121.66415, 37.99377], [-121.67363, 37.99756], [-121.67366, 37.99754], [-121.67405, 37.99767], [-121.67431, 37.99772], [-121.67459, 37.99775], [-121.6759, 37.99776], [-121.67585, 37.99946], [-121.67687, 38.0005], [-121.67805, 38.00051], [-121.67798, 38.00067], [-121.67805, 38.00087], [-121.67806, 38.00179], [-121.67966, 38.00179], [-121.67966, 38.00051], [-121.68253, 38.00051], [-121.68379, 38.0001], [-121.68381, 37.99788], [-121.68397, 37.99792], [-121.6859, 37.99855], [-121.6862, 37.99862], [-121.68641, 37.99865], [-121.68662, 37.99866], [-121.69523, 37.99864]]]}	No Public Access 3	35110	Dutch Slough	18320	207	California Department of Water Resources 477	State 5	State Agency 5	http://www.water.ca.gov/	Other State 5	207	California Department of Water Resources 470	State 5	State Agency 5		Contra Costa 12	1185.171	Dutch Slough	0	State Conservation Area 8	2
15546	15546	15545	{"type": "MultiPolygon", "coordinates": [[[[-121.83297, 36.97264], [-121.8322, 36.97322], [-121.8311, 36.97307], [-121.83061, 36.97317], [-121.83022, 36.9731], [-121.82993, 36.97303], [-121.82964, 36.97311], [-121.82843, 36.97315], [-121.82817, 36.97312], [-121.82651, 36.97307], [-121.82487, 36.9708], [-121.82586, 36.97066], [-121.82626, 36.97051], [-121.82652, 36.97033], [-121.8269, 36.96993], [-121.82748, 36.97011], [-121.82782, 36.97011], [-121.83012, 36.96958], [-121.83048, 36.96964], [-121.83161, 36.96959], [-121.83198, 36.97029], [-121.83211, 36.97092], [-121.83297, 36.97264]]], [[[-121.84213, 36.92346], [-121.84073, 36.92517], [-121.84049, 36.9254], [-121.84043, 36.92536], [-121.84041, 36.92537], [-121.8404, 36.92538], [-121.84046, 36.92542], [-121.83996, 36.9259], [-121.83785, 36.92388], [-121.83407, 36.92477], [-121.83363, 36.92355], [-121.83425, 36.92341], [-121.83482, 36.92319], [-121.83613, 36.92327], [-121.8365, 36.92336], [-121.83802, 36.92338], [-121.83914, 36.92249], [-121.84213, 36.92346]]], [[[-121.84412, 36.95327], [-121.84289, 36.95384], [-121.8427, 36.95357], [-121.84222, 36.95321], [-121.84201, 36.95308], [-121.84164, 36.95293], [-121.84093, 36.9527], [-121.84083, 36.95176], [-121.84171, 36.95174], [-121.84262, 36.95202], [-121.84357, 36.95271], [-121.84412, 36.95327]]], [[[-121.87791, 36.96634], [-121.87783, 36.96654], [-121.87768, 36.96678], [-121.87736, 36.96695], [-121.87727, 36.96697], [-121.87714, 36.96694], [-121.87708, 36.96688], [-121.87699, 36.96654], [-121.8769, 36.9664], [-121.87674, 36.96628], [-121.87661, 36.96623], [-121.87646, 36.96624], [-121.87636, 36.96629], [-121.87593, 36.96667], [-121.87577, 36.96677], [-121.87564, 36.96681], [-121.87555, 36.96681], [-121.87546, 36.96679], [-121.87511, 36.96652], [-121.87496, 36.96647], [-121.8748, 36.96649], [-121.87448, 36.96665], [-121.87436, 36.96668], [-121.87414, 36.96668], [-121.87398, 36.96664], [-121.87392, 36.96507], [-121.8737, 36.96478], [-121.87322, 36.96463], [-121.87289, 36.9651], [-121.87293, 36.96609], [-121.87276, 36.9661], [-121.87238, 36.96616], [-121.87225, 36.96615], [-121.87215, 36.96609], [-121.87192, 36.96579], [-121.8718, 36.9657], [-121.87169, 36.96566], [-121.87137, 36.96561], [-121.87118, 36.96553], [-121.87154, 36.96463], [-121.87216, 36.96317], [-121.87244, 36.96144], [-121.87549, 36.96011], [-121.87616, 36.96092], [-121.87619, 36.96089], [-121.87692, 36.96083], [-121.87729, 36.9607], [-121.87775, 36.96063], [-121.87787, 36.9607], [-121.87753, 36.96107], [-121.87737, 36.96102], [-121.87653, 36.96109], [-121.87604, 36.9616], [-121.87595, 36.96224], [-121.87611, 36.96335], [-121.87651, 36.96413], [-121.87709, 36.96488], [-121.87762, 36.96591], [-121.87752, 36.96626], [-121.87791, 36.96634]]], [[[-121.88404, 36.97386], [-121.884, 36.97398], [-121.87851, 36.97215], [-121.87538, 36.97081], [-121.87546, 36.9707], [-121.87846, 36.97201], [-121.88051, 36.97272], [-121.88404, 36.97386]]], [[[-121.88106, 36.97198], [-121.88104, 36.97216], [-121.88102, 36.97223], [-121.88094, 36.97237], [-121.88091, 36.9724], [-121.88078, 36.97238], [-121.88043, 36.97228], [-121.88061, 36.97185], [-121.88106, 36.97198]]], [[[-121.88427, 36.97355], [-121.88408, 36.97376], [-121.88046, 36.97251], [-121.88056, 36.97241], [-121.88081, 36.97248], [-121.88101, 36.9725], [-121.88115, 36.9725], [-121.88154, 36.97243], [-121.88172, 36.97242], [-121.8819, 36.97243], [-121.8824, 36.97249], [-121.88254, 36.97254], [-121.88281, 36.9727], [-121.88313, 36.9728], [-121.88386, 36.9732], [-121.88411, 36.97338], [-121.88427, 36.97355]]], [[[-121.8827, 36.97205], [-121.8824, 36.9724], [-121.88176, 36.97234], [-121.8815, 36.97235], [-121.88114, 36.97241], [-121.88109, 36.9724], [-121.88107, 36.97236], [-121.88114, 36.97217], [-121.88116, 36.97193], [-121.88164, 36.97195], [-121.8817, 36.97182], [-121.88209, 36.97191], [-121.88214, 36.97152], [-121.88225, 36.97157], [-121.88234, 36.97156], [-121.88239, 36.97154], [-121.88257, 36.972], [-121.8827, 36.97205]]], [[[-121.88166, 36.97148], [-121.88119, 36.97155], [-121.88118, 36.97147], [-121.88112, 36.9714], [-121.88165, 36.97122], [-121.88166, 36.97148]]], [[[-121.88308, 36.97238], [-121.88289, 36.97264], [-121.88271, 36.97255], [-121.88301, 36.97218], [-121.88308, 36.97238]]], [[[-121.88366, 36.97186], [-121.88359, 36.97207], [-121.883, 36.97213], [-121.88285, 36.97209], [-121.88292, 36.97195], [-121.88366, 36.97186]]], [[[-121.88362, 36.97164], [-121.88302, 36.97174], [-121.88301, 36.97139], [-121.88312, 36.97139], [-121.88325, 36.97134], [-121.8834, 36.97126], [-121.88347, 36.97127], [-121.88352, 36.97131], [-121.88354, 36.97145], [-121.88362, 36.97164]]], [[[-121.88422, 36.97235], [-121.88385, 36.97255], [-121.88348, 36.9725], [-121.88366, 36.97219], [-121.88374, 36.97222], [-121.88414, 36.97223], [-121.8842, 36.97227], [-121.88422, 36.97235]]], [[[-121.88419, 36.97146], [-121.88408, 36.97154], [-121.88367, 36.97152], [-121.88362, 36.97131], [-121.88359, 36.97124], [-121.88372, 36.97111], [-121.88419, 36.97146]]], [[[-121.88461, 36.97228], [-121.88446, 36.9725], [-121.88436, 36.97241], [-121.88429, 36.97223], [-121.88424, 36.97219], [-121.88418, 36.97216], [-121.88452, 36.97196], [-121.88461, 36.97228]]], [[[-121.88563, 36.97398], [-121.88561, 36.97407], [-121.88549, 36.97398], [-121.88542, 36.97396], [-121.88518, 36.97403], [-121.88495, 36.9737], [-121.88523, 36.9735], [-121.88528, 36.97358], [-121.88532, 36.97378], [-121.8854, 36.97389], [-121.88545, 36.97394], [-121.88551, 36.97397], [-121.88563, 36.97398]]]]}	No Public Access 3	650	Santa Cruz Long-Toed Salamander Ecological Reserve	32298	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	164.091	Santa Cruz Long-Toed Salamander ER	0	State Conservation Area 8	2
15552	15552	15551	{"type": "MultiPolygon", "coordinates": [[[[-122.72009, 38.37147], [-122.71926, 38.37177], [-122.71925, 38.37265], [-122.71699, 38.37267], [-122.71616, 38.37133], [-122.71645, 38.37127], [-122.7167, 38.37125], [-122.71693, 38.37125], [-122.72009, 38.37147]]], [[[-122.75284, 38.37969], [-122.75203, 38.38046], [-122.75178, 38.38073], [-122.75159, 38.38099], [-122.7507, 38.3824], [-122.75046, 38.38273], [-122.75017, 38.38308], [-122.74986, 38.3834], [-122.74958, 38.38365], [-122.74834, 38.38466], [-122.74804, 38.38488], [-122.74745, 38.38523], [-122.74682, 38.38552], [-122.74639, 38.38569], [-122.74587, 38.38585], [-122.74528, 38.38599], [-122.74416, 38.38618], [-122.74415, 38.38213], [-122.74624, 38.38209], [-122.74624, 38.37983], [-122.75284, 38.37969]]], [[[-122.75511, 38.38384], [-122.75511, 38.38384], [-122.74981, 38.38391], [-122.75018, 38.3836], [-122.7507, 38.38303], [-122.75099, 38.38264], [-122.75195, 38.38112], [-122.75212, 38.38088], [-122.75228, 38.38071], [-122.75262, 38.38041], [-122.75281, 38.38028], [-122.75306, 38.38016], [-122.75344, 38.38003], [-122.75368, 38.37999], [-122.75398, 38.37997], [-122.75502, 38.37994], [-122.75513, 38.38238], [-122.75511, 38.38384]]], [[[-122.75687, 38.40921], [-122.75684, 38.40955], [-122.75674, 38.41136], [-122.75668, 38.41162], [-122.75661, 38.41296], [-122.75641, 38.41295], [-122.75621, 38.41311], [-122.75615, 38.41401], [-122.75083, 38.41441], [-122.75048, 38.41153], [-122.75072, 38.4115], [-122.75071, 38.40963], [-122.75661, 38.40922], [-122.75664, 38.40878], [-122.75645, 38.40709], [-122.75657, 38.40708], [-122.75674, 38.40877], [-122.75675, 38.40921], [-122.75687, 38.40921]]], [[[-122.76305, 38.39085], [-122.75418, 38.39206], [-122.75418, 38.39561], [-122.75155, 38.39562], [-122.75155, 38.38709], [-122.75184, 38.38711], [-122.75394, 38.387], [-122.75341, 38.38771], [-122.75296, 38.38778], [-122.75275, 38.38798], [-122.75276, 38.38945], [-122.75329, 38.38955], [-122.75343, 38.38954], [-122.75517, 38.38984], [-122.75546, 38.38969], [-122.75586, 38.38943], [-122.75586, 38.3869], [-122.76093, 38.38661], [-122.76096, 38.38738], [-122.76115, 38.38738], [-122.76117, 38.38795], [-122.76199, 38.38795], [-122.762, 38.38784], [-122.76299, 38.38783], [-122.76305, 38.39085]]], [[[-122.7564, 38.40664], [-122.75588, 38.40668], [-122.75572, 38.40677], [-122.75516, 38.40681], [-122.75515, 38.40671], [-122.75479, 38.40667], [-122.75438, 38.40669], [-122.75437, 38.4067], [-122.75179, 38.40668], [-122.75179, 38.4065], [-122.75183, 38.40579], [-122.75607, 38.40552], [-122.75611, 38.40579], [-122.75629, 38.40579], [-122.7564, 38.40664]]], [[[-122.76189, 38.37549], [-122.76121, 38.37551], [-122.76121, 38.37608], [-122.76089, 38.37611], [-122.76074, 38.37614], [-122.76046, 38.37625], [-122.75908, 38.3772], [-122.75876, 38.37721], [-122.75873, 38.376], [-122.75635, 38.37603], [-122.75627, 38.37236], [-122.7542, 38.37239], [-122.75418, 38.37147], [-122.75623, 38.37144], [-122.75619, 38.36922], [-122.75637, 38.36921], [-122.75633, 38.36746], [-122.75408, 38.36747], [-122.75403, 38.36441], [-122.75402, 38.3644], [-122.75391, 38.36448], [-122.7539, 38.36312], [-122.75589, 38.36308], [-122.7561, 38.36294], [-122.75619, 38.36291], [-122.75621, 38.36301], [-122.75804, 38.36296], [-122.75843, 38.36376], [-122.75846, 38.36377], [-122.75853, 38.36632], [-122.75858, 38.36919], [-122.7586, 38.36954], [-122.75864, 38.37126], [-122.75872, 38.37501], [-122.76187, 38.37498], [-122.76189, 38.37549]]], [[[-122.75751, 38.40108], [-122.75671, 38.40118], [-122.75674, 38.4015], [-122.75637, 38.40154], [-122.75508, 38.40156], [-122.75506, 38.39923], [-122.75749, 38.3992], [-122.75751, 38.40108]]], [[[-122.76129, 38.37803], [-122.75889, 38.37806], [-122.75889, 38.37806], [-122.7589, 38.37792], [-122.75894, 38.37781], [-122.75901, 38.37768], [-122.75915, 38.37753], [-122.76066, 38.37647], [-122.76082, 38.37638], [-122.76096, 38.37633], [-122.76122, 38.37629], [-122.76129, 38.37803]]], [[[-122.76589, 38.47792], [-122.76578, 38.47792], [-122.76577, 38.47796], [-122.76491, 38.47796], [-122.7649, 38.47803], [-122.76287, 38.47803], [-122.76286, 38.47715], [-122.76287, 38.47624], [-122.76579, 38.47623], [-122.76579, 38.4778], [-122.76589, 38.47781], [-122.76589, 38.47792]]], [[[-122.76909, 38.39921], [-122.76909, 38.4004], [-122.76849, 38.40049], [-122.76789, 38.40183], [-122.76789, 38.40205], [-122.76738, 38.40205], [-122.76738, 38.4015], [-122.76694, 38.4015], [-122.76693, 38.40178], [-122.76735, 38.40179], [-122.76734, 38.40206], [-122.76672, 38.40206], [-122.76673, 38.39975], [-122.76909, 38.39921]]], [[[-122.77985, 38.38778], [-122.77867, 38.38851], [-122.77242, 38.38856], [-122.76953, 38.38618], [-122.7781, 38.38605], [-122.77985, 38.38778]]], [[[-122.77366, 38.39817], [-122.77366, 38.40077], [-122.77229, 38.40077], [-122.77228, 38.40227], [-122.77143, 38.40228], [-122.77143, 38.40341], [-122.77135, 38.40341], [-122.77135, 38.40123], [-122.77049, 38.40124], [-122.77049, 38.39889], [-122.77366, 38.39817]]], [[[-122.78171, 38.43789], [-122.78119, 38.43789], [-122.78118, 38.43515], [-122.78117, 38.43514], [-122.7811, 38.43515], [-122.78111, 38.43789], [-122.77983, 38.4379], [-122.77982, 38.43755], [-122.77906, 38.43754], [-122.77906, 38.43738], [-122.77884, 38.43738], [-122.77882, 38.4379], [-122.7744, 38.43793], [-122.7744, 38.4362], [-122.77447, 38.43619], [-122.77451, 38.43057], [-122.77141, 38.43056], [-122.77137, 38.42731], [-122.77252, 38.42587], [-122.77359, 38.42481], [-122.77382, 38.42464], [-122.77411, 38.42451], [-122.77447, 38.42443], [-122.77732, 38.42421], [-122.77734, 38.42578], [-122.77679, 38.42579], [-122.7768, 38.42637], [-122.77754, 38.42637], [-122.77754, 38.42599], [-122.77887, 38.42598], [-122.77886, 38.42798], [-122.77888, 38.43065], [-122.78168, 38.43066], [-122.78171, 38.43789]]], [[[-122.77884, 38.51847], [-122.77564, 38.51847], [-122.77563, 38.51795], [-122.77484, 38.51795], [-122.77483, 38.51746], [-122.77563, 38.51745], [-122.77563, 38.51709], [-122.77884, 38.51708], [-122.77884, 38.51847]]], [[[-122.77907, 38.47094], [-122.77901, 38.47094], [-122.77901, 38.47105], [-122.77722, 38.47106], [-122.77723, 38.47045], [-122.77906, 38.47047], [-122.77907, 38.47094]]], [[[-122.78767, 38.38685], [-122.78114, 38.38699], [-122.77999, 38.3877], [-122.77835, 38.38605], [-122.77932, 38.38603], [-122.7796, 38.386], [-122.77973, 38.38595], [-122.78764, 38.38579], [-122.78767, 38.38685]]], [[[-122.78111, 38.44116], [-122.77888, 38.44115], [-122.77886, 38.44013], [-122.77962, 38.44012], [-122.77965, 38.43807], [-122.78103, 38.43806], [-122.7811, 38.4381], [-122.78111, 38.44116]]], [[[-122.78177, 38.47439], [-122.77907, 38.47438], [-122.77903, 38.47268], [-122.77902, 38.47118], [-122.77959, 38.4717], [-122.77955, 38.47175], [-122.77964, 38.47213], [-122.77992, 38.47214], [-122.77991, 38.47219], [-122.77998, 38.47239], [-122.78013, 38.47239], [-122.78013, 38.47243], [-122.78028, 38.47247], [-122.78035, 38.47246], [-122.7806, 38.47221], [-122.78058, 38.47203], [-122.78066, 38.47202], [-122.78071, 38.47198], [-122.7807, 38.47154], [-122.78018, 38.47154], [-122.78018, 38.47162], [-122.77971, 38.47162], [-122.77958, 38.47159], [-122.77916, 38.47119], [-122.77916, 38.47096], [-122.78173, 38.47097], [-122.78177, 38.47439]]]]}	No Public Access 3	1044	Santa Rosa Plain Vernal Pool Ecological Reserve	32301	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	840.334	Santa Rosa Plain Vernal Pool ER	0	State Conservation Area 8	2
15604	15604	15603	{"type": "Polygon", "coordinates": [[[-119.96286, 37.60719], [-119.95818, 37.60735], [-119.95777, 37.61098], [-119.95315, 37.61105], [-119.95347, 37.6075], [-119.95349, 37.60392], [-119.96276, 37.60376], [-119.96286, 37.60719]]]}	No Public Access 3	16863	Limestone Salamander Ecological Reserve	32203	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		Mariposa 31	119.896	Limestone Salamander ER	0	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]);