calands: units_with_maps: 13 rows where ACCESS_TYP = 2, COUNTY = 10 and MNG_AG

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

13 rows where ACCESS_TYP = 2, COUNTY = 10 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
4350	4350	4349	{"type": "MultiPolygon", "coordinates": [[[[-116.4033, 33.63437], [-116.40313, 33.6346], [-116.40304, 33.63478], [-116.40298, 33.63498], [-116.40295, 33.63518], [-116.40295, 33.63581], [-116.40292, 33.63608], [-116.40286, 33.63631], [-116.40277, 33.63657], [-116.40256, 33.63694], [-116.40226, 33.6373], [-116.40178, 33.63777], [-116.4014, 33.63824], [-116.40107, 33.63875], [-116.40058, 33.63974], [-116.40027, 33.64025], [-116.39983, 33.64081], [-116.39904, 33.64162], [-116.39092, 33.64162], [-116.39091, 33.67062], [-116.3821, 33.67067], [-116.37575, 33.67069], [-116.37657, 33.67462], [-116.37352, 33.67895], [-116.37352, 33.6778], [-116.36487, 33.67777], [-116.36488, 33.67069], [-116.35623, 33.67066], [-116.35622, 33.65615], [-116.33884, 33.65617], [-116.33884, 33.64166], [-116.35622, 33.64164], [-116.3562, 33.62714], [-116.33883, 33.62715], [-116.33882, 33.61264], [-116.3562, 33.61263], [-116.35621, 33.62714], [-116.37349, 33.62716], [-116.39092, 33.62711], [-116.40321, 33.62712], [-116.40314, 33.62853], [-116.40306, 33.62853], [-116.40304, 33.6288], [-116.40311, 33.62883], [-116.40304, 33.62909], [-116.40295, 33.62935], [-116.40284, 33.62959], [-116.40239, 33.63034], [-116.40232, 33.63049], [-116.40224, 33.63081], [-116.40222, 33.63098], [-116.40225, 33.63131], [-116.40236, 33.63163], [-116.4025, 33.63189], [-116.40269, 33.63213], [-116.40291, 33.63232], [-116.40327, 33.63257], [-116.40339, 33.63269], [-116.40349, 33.63281], [-116.40361, 33.63301], [-116.40368, 33.63323], [-116.40371, 33.63346], [-116.40369, 33.63369], [-116.40363, 33.63388], [-116.40355, 33.63406], [-116.40345, 33.6342], [-116.4033, 33.63437]]], [[[-116.46016, 33.61247], [-116.44282, 33.61252], [-116.44282, 33.61006], [-116.44269, 33.61005], [-116.44269, 33.60952], [-116.44294, 33.60951], [-116.44294, 33.60891], [-116.44282, 33.6089], [-116.44283, 33.6044], [-116.44501, 33.6044], [-116.44504, 33.60344], [-116.45248, 33.60347], [-116.45249, 33.59796], [-116.46006, 33.59793], [-116.46016, 33.61247]]]]}	Restricted Access 2	48461	Boyd Deep Canyon Desert Research Center	33174	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	https://ucnrs.org/reserves/boyd-deep-canyon-desert-research-center/	Riverside 10	6239.662	Boyd Deep Canyon Desert Research Ctr.		None 384
5847	5847	5846	{"type": "MultiPolygon", "coordinates": [[[[-117.16733, 33.46176], [-117.16524, 33.46316], [-117.16477, 33.46349], [-117.16432, 33.46385], [-117.1639, 33.46423], [-117.16319, 33.46492], [-117.16317, 33.46482], [-117.16297, 33.46465], [-117.16293, 33.46136], [-117.1584, 33.46141], [-117.1583, 33.458], [-117.16286, 33.458], [-117.16294, 33.46135], [-117.16732, 33.46153], [-117.16733, 33.46176]]], [[[-117.17572, 33.43595], [-117.17572, 33.43673], [-117.17535, 33.43751], [-117.17514, 33.43806], [-117.17463, 33.43969], [-117.17358, 33.44319], [-117.1625, 33.4434], [-117.16239, 33.43974], [-117.17142, 33.43963], [-117.17137, 33.43602], [-117.17572, 33.43595]]], [[[-117.17577, 33.44315], [-117.17438, 33.44318], [-117.17551, 33.43984], [-117.17574, 33.43904], [-117.17577, 33.44315]]], [[[-117.1801, 33.45033], [-117.17584, 33.45044], [-117.1758, 33.44675], [-117.18006, 33.44666], [-117.1801, 33.45033]]], [[[-117.20651, 33.43216], [-117.20649, 33.43578], [-117.19766, 33.43577], [-117.1976, 33.43937], [-117.19315, 33.43935], [-117.1932, 33.43576], [-117.18876, 33.43575], [-117.18441, 33.43581], [-117.18444, 33.43223], [-117.18882, 33.43217], [-117.20651, 33.43216]]]]}	Restricted Access 2	21992	Santa Margarita Ecological Reserve	33342	3065	San Diego State University Foundation 524	Non Profit 6	Non Profit - Other 22	http://www.foundation.sdsu.edu/index.html	Non Governmental Organization 10	221	San Diego State University 378	State 5	State Agency 5	https://fsp.sdsu.edu/about-us/	Riverside 10	493.628	Santa Margarita ER	1962	State Conservation Area 8	2
6872	6872	6871	{"type": "MultiPolygon", "coordinates": [[[[-117.24826, 33.80281], [-117.24825, 33.80455], [-117.24606, 33.80457], [-117.24603, 33.8029], [-117.24629, 33.80289], [-117.24664, 33.80296], [-117.2467, 33.80295], [-117.24675, 33.80291], [-117.24679, 33.80281], [-117.24826, 33.80281]]], [[[-117.26806, 33.81916], [-117.26585, 33.81919], [-117.26585, 33.81556], [-117.26579, 33.81188], [-117.26141, 33.81189], [-117.26146, 33.81559], [-117.25705, 33.81565], [-117.25704, 33.81374], [-117.25263, 33.81378], [-117.25261, 33.81197], [-117.24922, 33.81201], [-117.24922, 33.81118], [-117.24944, 33.81116], [-117.24944, 33.81101], [-117.24934, 33.811], [-117.24936, 33.80968], [-117.24914, 33.80927], [-117.24891, 33.80927], [-117.24891, 33.80833], [-117.24841, 33.80795], [-117.24847, 33.80788], [-117.24838, 33.80781], [-117.24813, 33.80745], [-117.24906, 33.8073], [-117.24907, 33.80729], [-117.2488, 33.80702], [-117.24874, 33.80676], [-117.24778, 33.80691], [-117.2474, 33.80529], [-117.24836, 33.80515], [-117.24825, 33.80463], [-117.24993, 33.80461], [-117.25255, 33.80464], [-117.25252, 33.80114], [-117.25412, 33.8011], [-117.25412, 33.79918], [-117.25422, 33.79917], [-117.25422, 33.79849], [-117.25412, 33.79848], [-117.25411, 33.79593], [-117.25253, 33.79592], [-117.25253, 33.79622], [-117.2504, 33.79625], [-117.25039, 33.79599], [-117.25053, 33.79578], [-117.25039, 33.79575], [-117.25038, 33.79556], [-117.24996, 33.79556], [-117.24931, 33.79527], [-117.24881, 33.79534], [-117.24862, 33.79556], [-117.24821, 33.79556], [-117.24808, 33.78924], [-117.25025, 33.78924], [-117.25029, 33.79101], [-117.25252, 33.79101], [-117.25253, 33.79438], [-117.26128, 33.79438], [-117.26134, 33.80817], [-117.26358, 33.80819], [-117.2636, 33.81004], [-117.26579, 33.81005], [-117.2658, 33.81188], [-117.26689, 33.81188], [-117.26694, 33.81554], [-117.26801, 33.81554], [-117.26806, 33.81916]], [[-117.25355, 33.79496], [-117.25355, 33.79482], [-117.25339, 33.79482], [-117.25339, 33.79496], [-117.25355, 33.79496]]]]}	Restricted Access 2	5523	Motte Rimrock Reserve	22519	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	https://ucnrs.org/reserves/motte-rimrock-reserve/	Riverside 10	639.088	Motte Rimrock Reserve	0	State Conservation Area 8	2
7756	7756	7755	{"type": "Polygon", "coordinates": [[[-117.04819, 33.46996], [-117.04601, 33.46999], [-117.04383, 33.47], [-117.04258, 33.47004], [-117.03519, 33.47001], [-117.03512, 33.46655], [-117.03512, 33.46296], [-117.04814, 33.46288], [-117.04819, 33.46996]], [[-117.04266, 33.46696], [-117.04265, 33.46697], [-117.04274, 33.46733], [-117.04314, 33.46728], [-117.04307, 33.46691], [-117.04266, 33.46696]]]}	Restricted Access 2	48472	Emerson Oaks Reserve	33183	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	https://ucnrs.org/reserves/emerson-oaks-reserve/	Riverside 10	234.781	Emerson Oaks Reserve	0	State Conservation Area 8	2
8349	8349	8348	{"type": "Polygon", "coordinates": [[[-116.77797, 33.80726], [-116.77791, 33.81103], [-116.77358, 33.81102], [-116.77357, 33.80908], [-116.77583, 33.80892], [-116.77583, 33.80728], [-116.77797, 33.80726]]]}	Restricted Access 2	48473	James San Jacinto Mountains Reserve	33184	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	https://ucnrs.org/reserves/james-san-jacinto-mountains-reserve/	Riverside 10	31.718	James San Jacinto Mtns. Reserve	0	State Conservation Area 8	2
8999	8999	8998	{"type": "Polygon", "coordinates": [[[-116.70159, 33.88765], [-116.70159, 33.88807], [-116.69746, 33.88804], [-116.69744, 33.89518], [-116.68886, 33.89519], [-116.68875, 33.888], [-116.68638, 33.88798], [-116.68652, 33.88782], [-116.68635, 33.88771], [-116.68882, 33.8877], [-116.68884, 33.888], [-116.69731, 33.88804], [-116.69732, 33.88767], [-116.70159, 33.88765]]]}	Restricted Access 2	14873	UC Oasis de Los Osos	26638	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		Riverside 10	163.171	UC Oasis de Los Osos		None 748
15027	15027	15026	{"type": "Polygon", "coordinates": [[[-116.40802, 33.61982], [-116.40796, 33.62211], [-116.40752, 33.62235], [-116.40705, 33.62276], [-116.40655, 33.62317], [-116.4061, 33.62346], [-116.40545, 33.62377], [-116.40505, 33.62391], [-116.40395, 33.62425], [-116.4037, 33.62436], [-116.40343, 33.62452], [-116.40321, 33.62472], [-116.40298, 33.62502], [-116.40283, 33.62536], [-116.40277, 33.62581], [-116.40272, 33.62712], [-116.39962, 33.62712], [-116.3996, 33.61983], [-116.40802, 33.61982]]]}	Restricted Access 2	48465	Boyd Deep Canyon Desert Research Center	33174	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	217	University of California 51	State 5	State Agency 5	https://ucnrs.org/reserves/boyd-deep-canyon-desert-research-center/	Riverside 10	109.558	Boyd Deep Canyon Desert Research Ctr.		None 1298
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
15550	15550	15549	{"type": "Polygon", "coordinates": [[[-117.20642, 33.44665], [-117.20637, 33.45054], [-117.16741, 33.4645], [-117.16732, 33.46153], [-117.16295, 33.46136], [-117.16297, 33.46465], [-117.15938, 33.4648], [-117.15931, 33.46482], [-117.15856, 33.46486], [-117.15839, 33.46141], [-117.15396, 33.46161], [-117.15344, 33.4472], [-117.15378, 33.43266], [-117.15812, 33.43261], [-117.15812, 33.43978], [-117.16239, 33.43974], [-117.16251, 33.4434], [-117.17577, 33.44314], [-117.17574, 33.43904], [-117.17588, 33.43855], [-117.17623, 33.43757], [-117.17573, 33.43756], [-117.17571, 33.43595], [-117.17137, 33.43602], [-117.17143, 33.43963], [-117.16663, 33.43969], [-117.16672, 33.43254], [-117.17132, 33.43242], [-117.18444, 33.43223], [-117.18442, 33.43581], [-117.18876, 33.43575], [-117.18865, 33.4429], [-117.1931, 33.44294], [-117.19305, 33.44652], [-117.20642, 33.44665]], [[-117.16286, 33.45801], [-117.1583, 33.458], [-117.1584, 33.46141], [-117.16293, 33.46135], [-117.16286, 33.45801]], [[-117.18006, 33.44667], [-117.18005, 33.44666], [-117.1758, 33.44675], [-117.17585, 33.45044], [-117.18009, 33.45033], [-117.18006, 33.44667]]]}	Restricted Access 2	48639	Santa Margarita Ecological Reserve	33342	221	San Diego State University 1047	State 5	State Agency 5	http://www.sdsu.edu/	Other State 5	221	San Diego State University 378	State 5	State Agency 5	https://fsp.sdsu.edu/about-us/	Riverside 10	2513.083	Santa Margarita ER	1962	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
15620	15620	15619	{"type": "MultiPolygon", "coordinates": [[[[-117.29691, 33.50922], [-117.29443, 33.50925], [-117.29366, 33.50656], [-117.29686, 33.50664], [-117.29691, 33.50922]]], [[[-117.30422, 33.51102], [-117.30312, 33.51228], [-117.30368, 33.51239], [-117.303, 33.51312], [-117.30271, 33.51322], [-117.30252, 33.51335], [-117.30249, 33.5134], [-117.30241, 33.51367], [-117.30233, 33.51377], [-117.30222, 33.51386], [-117.30211, 33.51393], [-117.30192, 33.51401], [-117.30179, 33.5141], [-117.30168, 33.51422], [-117.30163, 33.51432], [-117.30151, 33.51438], [-117.3001, 33.51427], [-117.3002, 33.51413], [-117.30163, 33.51258], [-117.30174, 33.51242], [-117.30178, 33.51231], [-117.3018, 33.51212], [-117.30169, 33.51097], [-117.30171, 33.51072], [-117.30173, 33.51061], [-117.30179, 33.51047], [-117.30185, 33.51044], [-117.30196, 33.51045], [-117.30211, 33.51043], [-117.30222, 33.5104], [-117.30241, 33.51031], [-117.3026, 33.51027], [-117.30273, 33.51026], [-117.30292, 33.51029], [-117.30304, 33.51033], [-117.30396, 33.51075], [-117.30411, 33.51086], [-117.30422, 33.51102]]], [[[-117.30682, 33.48342], [-117.30671, 33.48384], [-117.30668, 33.4842], [-117.3067, 33.48445], [-117.30681, 33.48526], [-117.30682, 33.48547], [-117.30678, 33.48578], [-117.30672, 33.48598], [-117.30664, 33.48618], [-117.30653, 33.48637], [-117.3064, 33.48655], [-117.30459, 33.48881], [-117.30434, 33.48908], [-117.30405, 33.48934], [-117.30282, 33.48822], [-117.30539, 33.48498], [-117.30585, 33.48446], [-117.30682, 33.48342]]], [[[-117.31602, 33.50967], [-117.31583, 33.51591], [-117.31468, 33.51586], [-117.3134, 33.51573], [-117.31277, 33.51564], [-117.30935, 33.51506], [-117.3095, 33.51398], [-117.31151, 33.51178], [-117.31074, 33.51132], [-117.30996, 33.51076], [-117.30875, 33.51199], [-117.30459, 33.5112], [-117.30457, 33.51113], [-117.30441, 33.51095], [-117.30433, 33.51084], [-117.30415, 33.51066], [-117.30657, 33.51076], [-117.30871, 33.50862], [-117.3119, 33.50877], [-117.31204, 33.50873], [-117.31335, 33.50519], [-117.31602, 33.50967]]], [[[-117.32402, 33.49267], [-117.32243, 33.49476], [-117.31894, 33.49287], [-117.31878, 33.49351], [-117.31866, 33.49348], [-117.31854, 33.4935], [-117.31846, 33.49356], [-117.31848, 33.49368], [-117.31856, 33.49373], [-117.31596, 33.49402], [-117.3132, 33.49064], [-117.3083, 33.49327], [-117.3042, 33.48946], [-117.30492, 33.4887], [-117.30523, 33.48833], [-117.30608, 33.48721], [-117.30659, 33.48659], [-117.30682, 33.48629], [-117.30689, 33.4861], [-117.30698, 33.4859], [-117.30934, 33.48625], [-117.30964, 33.48626], [-117.30978, 33.48625], [-117.30998, 33.4863], [-117.3101, 33.48625], [-117.31019, 33.48617], [-117.31013, 33.48608], [-117.31001, 33.48605], [-117.3099, 33.48608], [-117.30963, 33.48613], [-117.30929, 33.48608], [-117.30709, 33.48574], [-117.30703, 33.48566], [-117.30705, 33.48544], [-117.30698, 33.48461], [-117.30697, 33.48376], [-117.30721, 33.48315], [-117.30742, 33.48289], [-117.30759, 33.48275], [-117.31294, 33.48675], [-117.31524, 33.48853], [-117.31715, 33.4866], [-117.31719, 33.48657], [-117.32346, 33.49117], [-117.32288, 33.4918], [-117.32402, 33.49267]]], [[[-117.33472, 33.4949], [-117.33416, 33.49536], [-117.33374, 33.49581], [-117.33365, 33.49597], [-117.33356, 33.49623], [-117.33351, 33.49662], [-117.32591, 33.49765], [-117.32575, 33.49765], [-117.32222, 33.49646], [-117.32227, 33.49633], [-117.32248, 33.49528], [-117.32262, 33.49499], [-117.32333, 33.49408], [-117.32339, 33.49407], [-117.32407, 33.4944], [-117.32433, 33.49449], [-117.32521, 33.49472], [-117.32551, 33.49484], [-117.32559, 33.49484], [-117.32566, 33.49478], [-117.32569, 33.4947], [-117.32567, 33.49465], [-117.3256, 33.49459], [-117.32553, 33.49457], [-117.32528, 33.49456], [-117.32427, 33.4943], [-117.32404, 33.49421], [-117.32356, 33.49396], [-117.32348, 33.49387], [-117.32452, 33.49255], [-117.32476, 33.49229], [-117.32496, 33.49214], [-117.32529, 33.49197], [-117.32566, 33.49186], [-117.32592, 33.49182], [-117.32632, 33.49183], [-117.33029, 33.49216], [-117.33068, 33.49221], [-117.33101, 33.49229], [-117.33155, 33.49246], [-117.3319, 33.49263], [-117.33222, 33.49282], [-117.33304, 33.49347], [-117.33472, 33.4949]]], [[[-117.33364, 33.50621], [-117.333, 33.507], [-117.33283, 33.50726], [-117.33255, 33.50758], [-117.32478, 33.50323], [-117.32545, 33.50184], [-117.3255, 33.50169], [-117.33364, 33.50621]]], [[[-117.33772, 33.50251], [-117.33705, 33.50292], [-117.33622, 33.50346], [-117.33563, 33.50294], [-117.33546, 33.50276], [-117.33527, 33.50254], [-117.33508, 33.50225], [-117.33488, 33.50192], [-117.33455, 33.50105], [-117.33423, 33.49964], [-117.33642, 33.49965], [-117.33636, 33.5007], [-117.33772, 33.50251]]], [[[-117.34065, 33.50668], [-117.33987, 33.50717], [-117.33667, 33.50408], [-117.33722, 33.50368], [-117.33762, 33.50343], [-117.33864, 33.50448], [-117.33868, 33.50464], [-117.33873, 33.50472], [-117.33897, 33.50474], [-117.33904, 33.50461], [-117.339, 33.50449], [-117.33886, 33.50441], [-117.33876, 33.50431], [-117.33784, 33.5033], [-117.33866, 33.50282], [-117.33894, 33.50274], [-117.3393, 33.50256], [-117.33949, 33.50245], [-117.33994, 33.50227], [-117.34, 33.50231], [-117.34064, 33.50368], [-117.34055, 33.50372], [-117.33997, 33.50393], [-117.33957, 33.50403], [-117.33949, 33.50414], [-117.33953, 33.50427], [-117.34065, 33.50668]]], [[[-117.34556, 33.50156], [-117.34541, 33.50193], [-117.34536, 33.50228], [-117.34543, 33.50264], [-117.34549, 33.50274], [-117.34158, 33.50425], [-117.34161, 33.50612], [-117.34156, 33.50612], [-117.34147, 33.50618], [-117.34137, 33.50627], [-117.34097, 33.50656], [-117.34081, 33.50656], [-117.34065, 33.50616], [-117.34054, 33.50594], [-117.33978, 33.50417], [-117.33992, 33.50413], [-117.34053, 33.50391], [-117.3408, 33.50389], [-117.34089, 33.50378], [-117.34091, 33.50366], [-117.34086, 33.50358], [-117.34078, 33.5035], [-117.34028, 33.50237], [-117.34027, 33.50217], [-117.34045, 33.50212], [-117.34072, 33.502], [-117.3412, 33.50186], [-117.34155, 33.50179], [-117.34317, 33.50141], [-117.3437, 33.50133], [-117.34452, 33.50133], [-117.34498, 33.5014], [-117.34541, 33.50151], [-117.34556, 33.50156]]], [[[-117.35154, 33.50447], [-117.35082, 33.5055], [-117.35061, 33.50561], [-117.35037, 33.50566], [-117.35013, 33.50565], [-117.34987, 33.50557], [-117.34969, 33.50541], [-117.34955, 33.50519], [-117.34907, 33.50416], [-117.34886, 33.50397], [-117.3487, 33.50387], [-117.34843, 33.50384], [-117.34765, 33.50384], [-117.34745, 33.5038], [-117.3473, 33.50371], [-117.34719, 33.50359], [-117.34705, 33.50346], [-117.34683, 33.50335], [-117.34629, 33.50317], [-117.34601, 33.50304], [-117.34582, 33.50292], [-117.34566, 33.50272], [-117.34556, 33.50248], [-117.34554, 33.50222], [-117.34562, 33.50191], [-117.34577, 33.50162], [-117.34619, 33.50181], [-117.34652, 33.50192], [-117.3472, 33.50231], [-117.34796, 33.50266], [-117.34952, 33.50347], [-117.35029, 33.50381], [-117.35154, 33.50447]]], [[[-117.35429, 33.50591], [-117.35306, 33.50668], [-117.35206, 33.5065], [-117.35204, 33.50638], [-117.35195, 33.5063], [-117.35178, 33.50624], [-117.35106, 33.50551], [-117.35172, 33.50458], [-117.35251, 33.50497], [-117.35429, 33.50591]]], [[[-117.36579, 33.50162], [-117.36439, 33.50466], [-117.3635, 33.50465], [-117.3628, 33.50619], [-117.36176, 33.5088], [-117.35747, 33.5067], [-117.35318, 33.50452], [-117.35375, 33.50444], [-117.35434, 33.50422], [-117.35495, 33.50386], [-117.35539, 33.50351], [-117.35578, 33.50295], [-117.35602, 33.50239], [-117.35604, 33.50175], [-117.35596, 33.50113], [-117.35591, 33.5005], [-117.35585, 33.49994], [-117.35989, 33.49968], [-117.36579, 33.50162]]]]}	Restricted Access 2	47975	Santa Rosa Plateau Ecological Reserve	25137	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	905.397	Santa Rosa Plateau ER	1994	State Conservation Area 8	2
16881	16881	16880	{"type": "MultiPolygon", "coordinates": [[[[-115.79985, 33.6134], [-115.78249, 33.61336], [-115.7825, 33.59883], [-115.79899, 33.59889], [-115.79984, 33.59912], [-115.79985, 33.6134]]], [[[-115.83435, 33.4331], [-115.83435, 33.43422], [-115.83008, 33.43422], [-115.82992, 33.42706], [-115.83034, 33.42706], [-115.83435, 33.4331]]]]}	Restricted Access 2	44324	California State Lands Commission	16725	209	California State Lands Commission 75	State 5	State Agency 5	http://www.slc.ca.gov/	Other State 5	209	California State Lands Commission 73	State 5	State Agency 5		Riverside 10	688.953	SLC	0	State Resource Management Area 55	3
17022	17022	17021	{"type": "MultiPolygon", "coordinates": [[[[-116.40803, 33.64523], [-116.40752, 33.64498], [-116.40687, 33.64489], [-116.40588, 33.64508], [-116.4053, 33.64525], [-116.40449, 33.64555], [-116.40394, 33.6458], [-116.4029, 33.64641], [-116.40229, 33.64686], [-116.40157, 33.64752], [-116.4009, 33.6483], [-116.40084, 33.64835], [-116.40076, 33.64839], [-116.40066, 33.6484], [-116.40056, 33.6484], [-116.40048, 33.64837], [-116.40035, 33.64827], [-116.40031, 33.64818], [-116.40025, 33.64798], [-116.40024, 33.6478], [-116.40025, 33.64766], [-116.40054, 33.64699], [-116.40065, 33.64665], [-116.40069, 33.64634], [-116.40065, 33.64598], [-116.40049, 33.6456], [-116.40027, 33.64528], [-116.40017, 33.64506], [-116.40012, 33.6448], [-116.40015, 33.6442], [-116.40009, 33.64385], [-116.39958, 33.64264], [-116.39953, 33.64231], [-116.39959, 33.64215], [-116.40001, 33.64162], [-116.40802, 33.64163], [-116.40803, 33.64523]]], [[[-116.40803, 33.65617], [-116.40416, 33.65614], [-116.40417, 33.65585], [-116.40408, 33.65555], [-116.40397, 33.65536], [-116.40356, 33.65498], [-116.403, 33.65478], [-116.40261, 33.65473], [-116.40228, 33.65461], [-116.40206, 33.65437], [-116.40192, 33.65398], [-116.40166, 33.65355], [-116.40141, 33.65332], [-116.40112, 33.65316], [-116.39953, 33.65236], [-116.39873, 33.65193], [-116.39908, 33.65194], [-116.3994, 33.65192], [-116.39966, 33.65198], [-116.40008, 33.65225], [-116.40059, 33.65242], [-116.40116, 33.65244], [-116.4017, 33.6523], [-116.40211, 33.65204], [-116.4024, 33.65172], [-116.40261, 33.65142], [-116.4029, 33.65108], [-116.40327, 33.65081], [-116.40387, 33.65054], [-116.40486, 33.65031], [-116.40539, 33.65005], [-116.40557, 33.64991], [-116.40585, 33.64964], [-116.40803, 33.64731], [-116.40803, 33.65617]]], [[[-116.4011, 33.65615], [-116.3989, 33.65614], [-116.39873, 33.65597], [-116.3985, 33.65578], [-116.39806, 33.65556], [-116.39771, 33.65546], [-116.39743, 33.65542], [-116.39702, 33.65544], [-116.3964, 33.65556], [-116.39624, 33.65554], [-116.39612, 33.6555], [-116.39603, 33.65542], [-116.39599, 33.65536], [-116.39595, 33.65526], [-116.39595, 33.65517], [-116.39598, 33.65507], [-116.39602, 33.655], [-116.39617, 33.6549], [-116.39758, 33.65464], [-116.39777, 33.65465], [-116.39792, 33.6547], [-116.39802, 33.65477], [-116.39846, 33.65519], [-116.39873, 33.65538], [-116.39901, 33.65553], [-116.39926, 33.65563], [-116.39952, 33.65571], [-116.40064, 33.65588], [-116.40079, 33.65593], [-116.40095, 33.65602], [-116.4011, 33.65615]]], [[[-116.40726, 33.64624], [-116.40716, 33.64645], [-116.40467, 33.64911], [-116.4046, 33.64917], [-116.40449, 33.64924], [-116.40436, 33.64929], [-116.40376, 33.64942], [-116.40322, 33.64957], [-116.40291, 33.6497], [-116.40257, 33.64988], [-116.40202, 33.65027], [-116.40175, 33.65052], [-116.40122, 33.65122], [-116.40112, 33.65131], [-116.40089, 33.65135], [-116.40055, 33.65116], [-116.40016, 33.65092], [-116.39978, 33.65081], [-116.39951, 33.65079], [-116.39897, 33.65084], [-116.3987, 33.65076], [-116.39844, 33.65051], [-116.398, 33.65023], [-116.39748, 33.65009], [-116.39702, 33.64999], [-116.39662, 33.6497], [-116.39613, 33.64926], [-116.39579, 33.64908], [-116.39549, 33.64899], [-116.39517, 33.64897], [-116.39476, 33.64902], [-116.39418, 33.6493], [-116.39383, 33.64972], [-116.39372, 33.65028], [-116.3939, 33.65079], [-116.39427, 33.65115], [-116.39486, 33.65139], [-116.39579, 33.65136], [-116.39594, 33.6514], [-116.39786, 33.6527], [-116.3986, 33.65317], [-116.39906, 33.65342], [-116.40051, 33.65413], [-116.40059, 33.65419], [-116.40064, 33.65425], [-116.40084, 33.65479], [-116.39996, 33.65467], [-116.39978, 33.65462], [-116.39953, 33.65451], [-116.39935, 33.65437], [-116.39894, 33.65398], [-116.39864, 33.65378], [-116.3983, 33.65363], [-116.39805, 33.65357], [-116.39776, 33.65354], [-116.39741, 33.65355], [-116.39581, 33.65384], [-116.39552, 33.65394], [-116.3952, 33.65414], [-116.39487, 33.65447], [-116.39469, 33.65483], [-116.39463, 33.65525], [-116.39471, 33.65565], [-116.39502, 33.65613], [-116.39091, 33.65612], [-116.39092, 33.64161], [-116.39843, 33.64162], [-116.39827, 33.64197], [-116.39821, 33.64242], [-116.39826, 33.64279], [-116.39882, 33.64412], [-116.39881, 33.64486], [-116.39888, 33.64529], [-116.39901, 33.64562], [-116.39913, 33.64583], [-116.39935, 33.64617], [-116.39934, 33.64654], [-116.39912, 33.647], [-116.39893, 33.64764], [-116.399, 33.64834], [-116.39926, 33.64887], [-116.39944, 33.64907], [-116.39965, 33.64922], [-116.40005, 33.64941], [-116.40036, 33.64948], [-116.40091, 33.64949], [-116.4014, 33.64935], [-116.40168, 33.6492], [-116.40188, 33.64903], [-116.40255, 33.64826], [-116.40295, 33.64787], [-116.40322, 33.64764], [-116.40355, 33.64739], [-116.40393, 33.64713], [-116.40438, 33.64687], [-116.40511, 33.64652], [-116.40614, 33.64616], [-116.40697, 33.64599], [-116.40723, 33.64614], [-116.40726, 33.64624]]], [[[-116.44282, 33.61252], [-116.4428, 33.62707], [-116.42542, 33.62707], [-116.42545, 33.61257], [-116.4141, 33.61259], [-116.4137, 33.61297], [-116.41358, 33.61368], [-116.41385, 33.61464], [-116.41414, 33.61494], [-116.41447, 33.61553], [-116.41419, 33.61644], [-116.41333, 33.61764], [-116.41293, 33.6179], [-116.41255, 33.61823], [-116.41224, 33.61859], [-116.41198, 33.619], [-116.41189, 33.61918], [-116.41178, 33.61947], [-116.40803, 33.61947], [-116.40802, 33.61982], [-116.3996, 33.61983], [-116.39962, 33.62712], [-116.39092, 33.62711], [-116.39092, 33.61261], [-116.37352, 33.61264], [-116.37349, 33.62716], [-116.35621, 33.62715], [-116.35622, 33.64165], [-116.33884, 33.64167], [-116.33885, 33.65616], [-116.35622, 33.65615], [-116.35623, 33.67065], [-116.3649, 33.67069], [-116.36487, 33.67777], [-116.36491, 33.68484], [-116.35629, 33.68488], [-116.35624, 33.67773], [-116.35623, 33.67067], [-116.35622, 33.67066], [-116.33891, 33.67071], [-116.33891, 33.68484], [-116.32154, 33.68488], [-116.32147, 33.67068], [-116.3389, 33.6707], [-116.33884, 33.65617], [-116.32146, 33.65617], [-116.32147, 33.64164], [-116.33883, 33.64166], [-116.33883, 33.62716], [-116.32146, 33.62714], [-116.32145, 33.61265], [-116.30367, 33.61267], [-116.3039, 33.60748], [-116.304, 33.60178], [-116.30381, 33.59829], [-116.31957, 33.59817], [-116.31959, 33.58374], [-116.33687, 33.58365], [-116.3369, 33.59809], [-116.32146, 33.59818], [-116.32147, 33.61264], [-116.33882, 33.61264], [-116.33888, 33.5981], [-116.35413, 33.59812], [-116.35409, 33.58354], [-116.37145, 33.58348], [-116.37146, 33.59803], [-116.35619, 33.59813], [-116.3562, 33.61262], [-116.37351, 33.61264], [-116.37354, 33.5981], [-116.38867, 33.5981], [-116.38887, 33.58345], [-116.41488, 33.58375], [-116.41486, 33.59806], [-116.41487, 33.59807], [-116.41669, 33.59806], [-116.41664, 33.6053], [-116.42543, 33.60531], [-116.42546, 33.61257], [-116.44282, 33.61252]], [[-116.3562, 33.61264], [-116.33882, 33.61265], [-116.33883, 33.62715], [-116.3562, 33.62714], [-116.3562, 33.61264]], [[-116.40823, 33.5981], [-116.40822, 33.59808], [-116.39093, 33.5981], [-116.39092, 33.6126], [-116.40813, 33.6126], [-116.40823, 33.5981]], [[-116.41663, 33.60531], [-116.41662, 33.6053], [-116.41229, 33.60529], [-116.41232, 33.60895], [-116.41533, 33.60898], [-116.41579, 33.6086], [-116.41617, 33.60841], [-116.41657, 33.60829], [-116.41662, 33.60716], [-116.41663, 33.60531]]]]}	Restricted Access 2	48464	Boyd Deep Canyon Desert Research Center	33174	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/boyd-deep-canyon-desert-research-center/	Riverside 10	10434.306	Boyd Deep Canyon Desert Research Ctr.	0	None 1424

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