calands: units_with_maps: 6 rows where ACCESS_TYP = 1, COUNTY = 2 and MNG_AG

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

6 rows where ACCESS_TYP = 1, COUNTY = 2 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
2290	2290	2289	{"type": "Polygon", "coordinates": [[[-120.60218, 37.62572], [-120.60074, 37.62629], [-120.6005, 37.62609], [-120.60065, 37.62603], [-120.60054, 37.62585], [-120.60026, 37.62593], [-120.59987, 37.626], [-120.59961, 37.62598], [-120.59921, 37.62599], [-120.59815, 37.62595], [-120.5974, 37.62598], [-120.5971, 37.6261], [-120.59598, 37.62641], [-120.59296, 37.62765], [-120.58744, 37.62797], [-120.58672, 37.62798], [-120.58598, 37.62819], [-120.58589, 37.6302], [-120.58589, 37.63206], [-120.58408, 37.63198], [-120.58218, 37.63162], [-120.57933, 37.6318], [-120.57893, 37.63155], [-120.57733, 37.63078], [-120.57588, 37.63045], [-120.57448, 37.63027], [-120.5721, 37.63008], [-120.57195, 37.62512], [-120.57199, 37.62364], [-120.57141, 37.6237], [-120.57129, 37.62363], [-120.57057, 37.62348], [-120.57034, 37.62363], [-120.57028, 37.62377], [-120.56948, 37.62393], [-120.56939, 37.62384], [-120.56936, 37.62354], [-120.56916, 37.62347], [-120.56856, 37.6235], [-120.56792, 37.6237], [-120.56712, 37.6234], [-120.56631, 37.62324], [-120.56462, 37.62333], [-120.56416, 37.62313], [-120.56324, 37.62246], [-120.56318, 37.6221], [-120.56341, 37.62205], [-120.56387, 37.62228], [-120.56447, 37.62217], [-120.56491, 37.62246], [-120.56516, 37.62253], [-120.56525, 37.62246], [-120.56525, 37.62226], [-120.56439, 37.62102], [-120.56367, 37.62063], [-120.56367, 37.62043], [-120.5639, 37.6202], [-120.56393, 37.61995], [-120.56373, 37.61965], [-120.56381, 37.61944], [-120.56416, 37.61935], [-120.5645, 37.61956], [-120.56474, 37.62031], [-120.56574, 37.62091], [-120.56611, 37.62105], [-120.56635, 37.62097], [-120.56637, 37.62078], [-120.56629, 37.62061], [-120.56632, 37.62018], [-120.56672, 37.61986], [-120.56706, 37.61974], [-120.56773, 37.62006], [-120.56836, 37.62022], [-120.5685, 37.62011], [-120.56853, 37.61986], [-120.5683, 37.61968], [-120.56767, 37.61949], [-120.56761, 37.61935], [-120.56755, 37.61862], [-120.56623, 37.61759], [-120.56572, 37.61741], [-120.5652, 37.61734], [-120.56471, 37.61764], [-120.56439, 37.61775], [-120.56416, 37.61759], [-120.56407, 37.61739], [-120.56347, 37.61748], [-120.56333, 37.61713], [-120.56344, 37.61661], [-120.56365, 37.61617], [-120.56468, 37.61617], [-120.56482, 37.61571], [-120.56422, 37.61482], [-120.56396, 37.61466], [-120.56336, 37.61459], [-120.56322, 37.61448], [-120.56321, 37.61386], [-120.56279, 37.61299], [-120.56224, 37.61253], [-120.56227, 37.61224], [-120.56238, 37.61205], [-120.56238, 37.6118], [-120.56204, 37.61164], [-120.56164, 37.61157], [-120.56167, 37.61139], [-120.56195, 37.61116], [-120.56198, 37.6109], [-120.56166, 37.61049], [-120.56083, 37.61004], [-120.56052, 37.60999], [-120.55997, 37.61036], [-120.55948, 37.61118], [-120.55945, 37.61164], [-120.55985, 37.61205], [-120.55983, 37.6126], [-120.56031, 37.61283], [-120.56103, 37.6129], [-120.56221, 37.61347], [-120.56241, 37.61363], [-120.56238, 37.61436], [-120.56204, 37.61477], [-120.56201, 37.61508], [-120.56252, 37.61535], [-120.56336, 37.6153], [-120.56356, 37.61549], [-120.56341, 37.61571], [-120.5627, 37.61606], [-120.5625, 37.61628], [-120.56246, 37.61679], [-120.56215, 37.61679], [-120.56157, 37.61624], [-120.56114, 37.61603], [-120.56028, 37.61601], [-120.56014, 37.6161], [-120.56002, 37.61656], [-120.55947, 37.61677], [-120.55947, 37.61704], [-120.55973, 37.61725], [-120.56042, 37.6175], [-120.56042, 37.6177], [-120.55973, 37.61784], [-120.55907, 37.61809], [-120.55884, 37.61809], [-120.55763, 37.61713], [-120.55706, 37.61695], [-120.55628, 37.6169], [-120.55593, 37.61706], [-120.55522, 37.61713], [-120.55384, 37.61646], [-120.55358, 37.61646], [-120.55343, 37.61713], [-120.55317, 37.61731], [-120.5524, 37.61751], [-120.55176, 37.61786], [-120.55101, 37.61811], [-120.55012, 37.61831], [-120.54937, 37.6182], [-120.54851, 37.61818], [-120.54733, 37.61856], [-120.54612, 37.61943], [-120.54575, 37.62005], [-120.54557, 37.6205], [-120.54537, 37.62073], [-120.54497, 37.62082], [-120.54448, 37.62073], [-120.54371, 37.62016], [-120.54322, 37.61991], [-120.54233, 37.6197], [-120.54057, 37.61954], [-120.54026, 37.61942], [-120.54023, 37.61904], [-120.54049, 37.6181], [-120.54, 37.61734], [-120.53873, 37.61629], [-120.53862, 37.61561], [-120.53836, 37.61508], [-120.53831, 37.61464], [-120.53842, 37.61419], [-120.53928, 37.61411], [-120.53931, 37.61393], [-120.53897, 37.6137], [-120.539, 37.6135], [-120.5398, 37.61302], [-120.53983, 37.61282], [-120.5396, 37.61272], [-120.5396, 37.61249], [-120.54124, 37.61115], [-120.54136, 37.61085], [-120.54202, 37.61009], [-120.5421, 37.60987], [-120.54199, 37.60982], [-120.54196, 37.60954], [-120.54217, 37.60932], [-120.54343, 37.60858], [-120.54395, 37.60735], [-120.54418, 37.60582], [-120.5447, 37.60511], [-120.54473, 37.60465], [-120.54456, 37.60403], [-120.54419, 37.60314], [-120.54372, 37.60282], [-120.54307, 37.60259], [-120.54189, 37.60243], [-120.54166, 37.60227], [-120.54157, 37.60195], [-120.54172, 37.60186], [-120.54318, 37.60174], [-120.54384, 37.60186], [-120.54404, 37.6017], [-120.54407, 37.6015], [-120.54396, 37.6014], [-120.54396, 37.60108], [-120.54479, 37.59953], [-120.54517, 37.5985], [-120.54537, 37.59838], [-120.546, 37.59863], [-120.54629, 37.59863], [-120.54644, 37.59847], [-120.54675, 37.59756], [-120.54649, 37.59735], [-120.54612, 37.59724], [-120.54612, 37.59706], [-120.5469, 37.59655], [-120.54724, 37.59614], [-120.54808, 37.59578], [-120.54819, 37.59562], [-120.54819, 37.59523], [-120.54802, 37.59495], [-120.54793, 37.59454], [-120.54776, 37.59424], [-120.54687, 37.59388], [-120.54635, 37.59287], [-120.54633, 37.59248], [-120.5465, 37.59218], [-120.54699, 37.5917], [-120.54716, 37.5912], [-120.54722, 37.59042], [-120.54713, 37.59035], [-120.54711, 37.58983], [-120.54722, 37.58969], [-120.54751, 37.5896], [-120.54785, 37.58912], [-120.54932, 37.58775], [-120.54973, 37.58717], [-120.55027, 37.58571], [-120.5501, 37.58486], [-120.5497, 37.58411], [-120.54979, 37.58404], [-120.55039, 37.58397], [-120.55056, 37.58376], [-120.55122, 37.58381], [-120.55131, 37.58371], [-120.55117, 37.58335], [-120.55186, 37.58321], [-120.55226, 37.58253], [-120.55266, 37.58246], [-120.55269, 37.58324], [-120.55298, 37.58377], [-120.55306, 37.58431], [-120.55361, 37.58459], [-120.55372, 37.58495], [-120.55438, 37.58571], [-120.55461, 37.58612], [-120.55458, 37.58642], [-120.55366, 37.58681], [-120.55323, 37.58733], [-120.55326, 37.58772], [-120.55355, 37.58793], [-120.55389, 37.58802], [-120.55507, 37.58796], [-120.55493, 37.5883], [-120.55441, 37.58898], [-120.5543, 37.58946], [-120.55435, 37.58964], [-120.55467, 37.58997], [-120.55541, 37.59022], [-120.55591, 37.59056], [-120.55614, 37.59065], [-120.55731, 37.59029], [-120.55817, 37.59072], [-120.55846, 37.59082], [-120.55967, 37.59047], [-120.56275, 37.59045], [-120.56424, 37.59034], [-120.56528, 37.59036], [-120.56551, 37.59046], [-120.56643, 37.59121], [-120.56666, 37.59149], [-120.56666, 37.59178], [-120.56597, 37.59258], [-120.56585, 37.5926], [-120.56542, 37.59297], [-120.56502, 37.59373], [-120.56479, 37.59389], [-120.56435, 37.59373], [-120.56392, 37.59384], [-120.56364, 37.59409], [-120.56372, 37.59544], [-120.56355, 37.5956], [-120.56191, 37.59631], [-120.56079, 37.59752], [-120.55995, 37.59892], [-120.55989, 37.59978], [-120.56006, 37.59992], [-120.56118, 37.59986], [-120.56138, 37.59974], [-120.56145, 37.59908], [-120.56165, 37.5989], [-120.56219, 37.5991], [-120.56268, 37.59901], [-120.5628, 37.59869], [-120.56251, 37.59832], [-120.56251, 37.59805], [-120.56447, 37.59716], [-120.56521, 37.59659], [-120.56533, 37.59624], [-120.5653, 37.59567], [-120.56594, 37.59528], [-120.56605, 37.59508], [-120.56605, 37.59453], [-120.56671, 37.59398], [-120.5672, 37.59348], [-120.5674, 37.59352], [-120.56752, 37.59364], [-120.56761, 37.59414], [-120.56806, 37.59435], [-120.56847, 37.59435], [-120.56907, 37.59423], [-120.56988, 37.5938], [-120.57062, 37.59364], [-120.57117, 37.59309], [-120.57157, 37.59286], [-120.57393, 37.59231], [-120.57451, 37.59233], [-120.5756, 37.59266], [-120.57557, 37.59286], [-120.57451, 37.59325], [-120.57448, 37.59378], [-120.57405, 37.5941], [-120.57341, 37.59435], [-120.57232, 37.594], [-120.57172, 37.59407], [-120.57137, 37.59428], [-120.57126, 37.59444], [-120.57126, 37.59487], [-120.57151, 37.59515], [-120.57307, 37.59552], [-120.57304, 37.59572], [-120.57232, 37.596], [-120.57229, 37.59629], [-120.57289, 37.59648], [-120.57278, 37.59673], [-120.572, 37.59709], [-120.57197, 37.59744], [-120.57212, 37.59758], [-120.57206, 37.59776], [-120.57134, 37.59833], [-120.57099, 37.59847], [-120.5699, 37.5986], [-120.56858, 37.5992], [-120.56734, 37.59929], [-120.56582, 37.59986], [-120.56556, 37.60006], [-120.56559, 37.60043], [-120.56584, 37.60059], [-120.56702, 37.60082], [-120.5672, 37.60096], [-120.56719, 37.60162], [-120.56702, 37.6019], [-120.56696, 37.60306], [-120.56722, 37.60375], [-120.56757, 37.60402], [-120.56863, 37.60421], [-120.56877, 37.60435], [-120.56889, 37.60503], [-120.56903, 37.60512], [-120.56944, 37.60499], [-120.5699, 37.60462], [-120.57024, 37.60407], [-120.57073, 37.60238], [-120.5718, 37.6016], [-120.57188, 37.60089], [-120.57217, 37.60094], [-120.57249, 37.60112], [-120.5728, 37.60112], [-120.57321, 37.60098], [-120.57398, 37.60108], [-120.57473, 37.60101], [-120.57496, 37.60105], [-120.57582, 37.60075], [-120.57677, 37.60074], [-120.57778, 37.60089], [-120.57847, 37.6008], [-120.57867, 37.60092], [-120.57936, 37.60087], [-120.57971, 37.6006], [-120.57982, 37.60026], [-120.57965, 37.60002], [-120.57965, 37.59977], [-120.58034, 37.59957], [-120.58054, 37.59934], [-120.58069, 37.59893], [-120.58074, 37.59842], [-120.58135, 37.59797], [-120.58152, 37.59799], [-120.58207, 37.59859], [-120.58241, 37.5987], [-120.58299, 37.59854], [-120.58333, 37.59831], [-120.58342, 37.59774], [-120.58394, 37.59692], [-120.58489, 37.59698], [-120.58661, 37.59646], [-120.5875, 37.59627], [-120.58819, 37.59589], [-120.58883, 37.59568], [-120.58906, 37.59571], [-120.58917, 37.5958], [-120.58914, 37.59618], [-120.58894, 37.59646], [-120.58785, 37.59692], [-120.58739, 37.59767], [-120.58644, 37.59831], [-120.58563, 37.59861], [-120.58538, 37.59888], [-120.58526, 37.5995], [-120.58534, 37.60035], [-120.58598, 37.60083], [-120.58583, 37.60142], [-120.58641, 37.60179], [-120.58667, 37.60229], [-120.5869, 37.60239], [-120.58727, 37.60232], [-120.58782, 37.60177], [-120.58807, 37.60181], [-120.58813, 37.60218], [-120.58856, 37.60255], [-120.58943, 37.60259], [-120.58994, 37.60305], [-120.59029, 37.60314], [-120.59072, 37.60296], [-120.59078, 37.60266], [-120.58992, 37.6017], [-120.58989, 37.60142], [-120.59023, 37.60147], [-120.59112, 37.60181], [-120.59161, 37.60184], [-120.59176, 37.60177], [-120.59187, 37.60147], [-120.59219, 37.60147], [-120.59253, 37.60165], [-120.59282, 37.60166], [-120.59328, 37.60154], [-120.594, 37.60125], [-120.59455, 37.60127], [-120.59472, 37.6014], [-120.59463, 37.60161], [-120.5944, 37.60182], [-120.59342, 37.60241], [-120.59317, 37.60278], [-120.59308, 37.60344], [-120.59317, 37.60374], [-120.59345, 37.60408], [-120.59434, 37.60465], [-120.59434, 37.60484], [-120.59345, 37.60509], [-120.59334, 37.60545], [-120.59334, 37.60603], [-120.59313, 37.60621], [-120.59285, 37.60614], [-120.59256, 37.60589], [-120.59256, 37.60543], [-120.59264, 37.60524], [-120.59242, 37.6045], [-120.59219, 37.6044], [-120.59161, 37.60449], [-120.59115, 37.60465], [-120.59032, 37.60534], [-120.59017, 37.60582], [-120.59055, 37.60626], [-120.59161, 37.60648], [-120.59198, 37.60669], [-120.59198, 37.60687], [-120.59132, 37.60728], [-120.59106, 37.60772], [-120.59106, 37.60822], [-120.59115, 37.60834], [-120.59161, 37.60847], [-120.5921, 37.60843], [-120.59259, 37.60822], [-120.5929, 37.60824], [-120.59356, 37.60861], [-120.59356, 37.60889], [-120.59342, 37.60907], [-120.59302, 37.60927], [-120.5923, 37.60939], [-120.59207, 37.60959], [-120.59199, 37.61015], [-120.59221, 37.61033], [-120.59241, 37.61035], [-120.59305, 37.61024], [-120.59382, 37.61037], [-120.59402, 37.61076], [-120.59451, 37.61129], [-120.59425, 37.61193], [-120.59399, 37.61202], [-120.59359, 37.61252], [-120.59327, 37.61248], [-120.59198, 37.61159], [-120.59172, 37.61149], [-120.59112, 37.61165], [-120.5906, 37.61202], [-120.59043, 37.61227], [-120.59028, 37.61288], [-120.59069, 37.61325], [-120.59112, 37.61332], [-120.59261, 37.61323], [-120.59281, 37.61339], [-120.59287, 37.6136], [-120.5929, 37.61467], [-120.59304, 37.61522], [-120.59287, 37.61529], [-120.59175, 37.61474], [-120.59075, 37.61438], [-120.59037, 37.61444], [-120.59025, 37.61497], [-120.58996, 37.6155], [-120.58905, 37.61607], [-120.5887, 37.61646], [-120.58804, 37.61664], [-120.58712, 37.61751], [-120.58712, 37.61772], [-120.58778, 37.61808], [-120.58792, 37.6184], [-120.58795, 37.61877], [-120.58887, 37.6193], [-120.58904, 37.61957], [-120.5893, 37.61971], [-120.58962, 37.61957], [-120.58976, 37.61939], [-120.58979, 37.61861], [-120.58999, 37.61849], [-120.59086, 37.61879], [-120.59128, 37.61879], [-120.59172, 37.61838], [-120.59169, 37.61827], [-120.59178, 37.61818], [-120.59215, 37.61818], [-120.59284, 37.6184], [-120.59232, 37.61957], [-120.59247, 37.62012], [-120.59267, 37.62028], [-120.59336, 37.62062], [-120.59382, 37.6212], [-120.59425, 37.62115], [-120.59436, 37.62092], [-120.59434, 37.62044], [-120.59419, 37.62024], [-120.59416, 37.61996], [-120.59451, 37.61994], [-120.59503, 37.62024], [-120.59534, 37.6206], [-120.59549, 37.62108], [-120.59594, 37.62145], [-120.5964, 37.62136], [-120.59687, 37.6209], [-120.59756, 37.62042], [-120.5977, 37.62026], [-120.59776, 37.61971], [-120.59799, 37.61976], [-120.59836, 37.62012], [-120.59828, 37.62177], [-120.59865, 37.62204], [-120.59948, 37.62225], [-120.59994, 37.62214], [-120.6004, 37.62175], [-120.60058, 37.62138], [-120.60084, 37.62125], [-120.60109, 37.62129], [-120.6021, 37.62207], [-120.60245, 37.62269], [-120.60247, 37.62324], [-120.60224, 37.62424], [-120.60211, 37.62496], [-120.6021, 37.6252], [-120.60143, 37.62549], [-120.60085, 37.62567], [-120.60103, 37.62583], [-120.60201, 37.6255], [-120.60218, 37.62572]]]}	Open Access 1	18239	Turlock Lake State Recreation Area	1778	204	California Department of Parks and Recreation 48	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://www.parks.ca.gov/?page_id=555	Stanislaus 2	3470.177	Turlock Lake SRA	1950	State Recreation Area 39	4
5955	5955	5954	{"type": "Polygon", "coordinates": [[[-120.98655, 37.40316], [-120.98645, 37.4037], [-120.9858, 37.40327], [-120.98326, 37.4014], [-120.98204, 37.40081], [-120.98154, 37.40063], [-120.98443, 37.39949], [-120.98456, 37.39989], [-120.98467, 37.40012], [-120.98472, 37.40027], [-120.98493, 37.40061], [-120.98501, 37.40078], [-120.98513, 37.40095], [-120.98522, 37.40114], [-120.98557, 37.40154], [-120.98567, 37.40168], [-120.98599, 37.40248], [-120.98621, 37.40281], [-120.98643, 37.40306], [-120.98655, 37.40316]]]}	Open Access 1	518	West Hilmar Wildlife Area	30516	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/West-Hilmar-WA	Stanislaus 2	16.656	West Hilmar Wildlife Area	1994	State Conservation Area 8	2
7996	7996	7995	{"type": "MultiPolygon", "coordinates": [[[[-120.84563, 37.61895], [-120.84545, 37.61903], [-120.84473, 37.62007], [-120.84403, 37.62084], [-120.84261, 37.62181], [-120.84163, 37.62226], [-120.84153, 37.62225], [-120.84196, 37.62189], [-120.84148, 37.62063], [-120.84163, 37.61955], [-120.84195, 37.61932], [-120.84163, 37.61895], [-120.8422, 37.61857], [-120.84301, 37.61756], [-120.84275, 37.61605], [-120.84369, 37.61618], [-120.84406, 37.61629], [-120.84379, 37.61775], [-120.8443, 37.61762], [-120.84492, 37.61786], [-120.84529, 37.61767], [-120.84563, 37.61895]]], [[[-120.85093, 37.61827], [-120.84939, 37.61906], [-120.84879, 37.61899], [-120.84793, 37.6187], [-120.84729, 37.61865], [-120.84609, 37.61872], [-120.84574, 37.61743], [-120.84684, 37.61692], [-120.84745, 37.61661], [-120.84873, 37.61675], [-120.84972, 37.6172], [-120.85027, 37.61796], [-120.85068, 37.6181], [-120.85055, 37.61819], [-120.85055, 37.61821], [-120.85093, 37.61827]]]]}	Open Access 1	468	Fox Grove Fishing Access	32167	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		Stanislaus 2	51.641	Fox Grove FA	0	State Recreation Area 39	4
12197	12197	12196	{"type": "Polygon", "coordinates": [[[-120.46492, 37.66834], [-120.46421, 37.66774], [-120.4619, 37.66728], [-120.4618, 37.66725], [-120.46168, 37.66715], [-120.46163, 37.66704], [-120.46164, 37.66696], [-120.4617, 37.66675], [-120.46266, 37.66675], [-120.4649, 37.66747], [-120.46492, 37.66834]]]}	Open Access 1	35662	Tuolumne River Restoration Center	26580	299	Other State 131	State 5	State Agency 5		Other State 5	299	Other State 128	State 5	State Agency 5		Stanislaus 2	4.72	Tuolumne River Restoration Ctr.		None 1063
16587	16587	16586	{"type": "Polygon", "coordinates": [[[-121.45661, 37.2858], [-121.4563, 37.28663], [-121.45574, 37.28677], [-121.45464, 37.28751], [-121.45462, 37.28793], [-121.45435, 37.28868], [-121.45329, 37.2891], [-121.45088, 37.28938], [-121.45106, 37.29017], [-121.45124, 37.29225], [-121.45111, 37.2929], [-121.45122, 37.29301], [-121.45113, 37.29308], [-121.44667, 37.29314], [-121.4467, 37.29653], [-121.44601, 37.29689], [-121.44559, 37.29675], [-121.43937, 37.29679], [-121.43879, 37.29664], [-121.43722, 37.29596], [-121.43609, 37.29627], [-121.43535, 37.29611], [-121.43471, 37.29645], [-121.43446, 37.29669], [-121.43324, 37.29675], [-121.43218, 37.29695], [-121.4313, 37.29747], [-121.42979, 37.29749], [-121.42813, 37.29846], [-121.4275, 37.2985], [-121.4269, 37.29906], [-121.4263, 37.29916], [-121.42566, 37.29917], [-121.4252, 37.29906], [-121.42439, 37.29902], [-121.42292, 37.29864], [-121.42226, 37.29963], [-121.4227, 37.30064], [-121.42261, 37.30109], [-121.42259, 37.30154], [-121.42209, 37.30187], [-121.42116, 37.30362], [-121.42096, 37.30393], [-121.40899, 37.30391], [-121.40889, 37.30996], [-121.40608, 37.30996], [-121.40605, 37.31113], [-121.38814, 37.31106], [-121.38825, 37.30383], [-121.36993, 37.30379], [-121.37036, 37.28932], [-121.3467, 37.28899], [-121.34704, 37.27482], [-121.32899, 37.27481], [-121.32899, 37.27379], [-121.3289, 37.26018], [-121.31984, 37.26025], [-121.31987, 37.253], [-121.3466, 37.25278], [-121.34659, 37.25386], [-121.3513, 37.25377], [-121.35119, 37.24538], [-121.3516, 37.24536], [-121.3516, 37.23817], [-121.35622, 37.23808], [-121.35636, 37.22366], [-121.33805, 37.22381], [-121.33797, 37.21656], [-121.33811, 37.21655], [-121.35617, 37.18739], [-121.35616, 37.18737], [-121.35605, 37.18737], [-121.35605, 37.18137], [-121.35656, 37.18131], [-121.35676, 37.18131], [-121.35908, 37.18255], [-121.36064, 37.18237], [-121.36193, 37.18301], [-121.36236, 37.18306], [-121.36269, 37.18286], [-121.36486, 37.18202], [-121.36554, 37.18196], [-121.36466, 37.17953], [-121.36513, 37.17965], [-121.36597, 37.1798], [-121.36695, 37.18032], [-121.36748, 37.17962], [-121.36919, 37.17941], [-121.36992, 37.17873], [-121.37048, 37.17851], [-121.37073, 37.17797], [-121.37078, 37.17798], [-121.37091, 37.17725], [-121.37129, 37.17733], [-121.37187, 37.17736], [-121.3732, 37.17635], [-121.37351, 37.17508], [-121.37365, 37.17474], [-121.37373, 37.17468], [-121.37374, 37.17466], [-121.37401, 37.1746], [-121.37402, 37.17572], [-121.37404, 37.17573], [-121.37445, 37.17491], [-121.37529, 37.17447], [-121.37594, 37.17422], [-121.37662, 37.17389], [-121.37711, 37.17304], [-121.37774, 37.17253], [-121.37897, 37.17193], [-121.37936, 37.1716], [-121.37946, 37.17128], [-121.37949, 37.17108], [-121.37973, 37.17096], [-121.38005, 37.17012], [-121.3804, 37.17006], [-121.38142, 37.17032], [-121.3823, 37.1705], [-121.38245, 37.17046], [-121.38288, 37.17054], [-121.38315, 37.17049], [-121.38348, 37.17048], [-121.38374, 37.16999], [-121.38377, 37.16941], [-121.38393, 37.1692], [-121.38424, 37.16916], [-121.38488, 37.16877], [-121.38454, 37.16777], [-121.38401, 37.16711], [-121.38361, 37.16631], [-121.3831, 37.16577], [-121.38395, 37.1652], [-121.38427, 37.16465], [-121.38412, 37.1641], [-121.38415, 37.16327], [-121.38396, 37.16303], [-121.38388, 37.16267], [-121.38338, 37.16209], [-121.38314, 37.16159], [-121.38265, 37.16128], [-121.38229, 37.16091], [-121.38199, 37.16065], [-121.38242, 37.15987], [-121.38317, 37.15969], [-121.38329, 37.15933], [-121.38321, 37.15858], [-121.3832, 37.15824], [-121.38356, 37.15758], [-121.38351, 37.15738], [-121.38339, 37.15715], [-121.38331, 37.15675], [-121.38273, 37.15621], [-121.38244, 37.15548], [-121.38262, 37.15511], [-121.38298, 37.15486], [-121.38362, 37.1549], [-121.38362, 37.1547], [-121.38407, 37.15332], [-121.38443, 37.15298], [-121.38444, 37.15235], [-121.38464, 37.15202], [-121.38499, 37.15179], [-121.38526, 37.15137], [-121.38558, 37.15121], [-121.38574, 37.15007], [-121.38642, 37.14958], [-121.38698, 37.14942], [-121.3875, 37.1497], [-121.38764, 37.15015], [-121.38825, 37.15029], [-121.38875, 37.15067], [-121.38935, 37.15095], [-121.39117, 37.15033], [-121.39146, 37.15054], [-121.39187, 37.15043], [-121.39188, 37.1516], [-121.39372, 37.15159], [-121.394, 37.15081], [-121.39403, 37.15041], [-121.39419, 37.14966], [-121.39431, 37.14924], [-121.39446, 37.14906], [-121.39509, 37.1488], [-121.39524, 37.14897], [-121.39548, 37.14906], [-121.39548, 37.14796], [-121.39499, 37.14795], [-121.39505, 37.14765], [-121.3952, 37.14723], [-121.39541, 37.14704], [-121.39605, 37.14674], [-121.39628, 37.14705], [-121.39663, 37.14721], [-121.39722, 37.14719], [-121.39803, 37.14767], [-121.39803, 37.14816], [-121.39869, 37.14997], [-121.39892, 37.14991], [-121.39991, 37.15003], [-121.40056, 37.14945], [-121.40129, 37.15002], [-121.40187, 37.15051], [-121.40271, 37.15061], [-121.40271, 37.15103], [-121.40291, 37.1517], [-121.40294, 37.1521], [-121.40305, 37.15238], [-121.40326, 37.15255], [-121.40323, 37.1529], [-121.40322, 37.15373], [-121.40357, 37.15425], [-121.40392, 37.15497], [-121.40497, 37.15542], [-121.40561, 37.15533], [-121.40573, 37.15582], [-121.4062, 37.15571], [-121.40765, 37.15644], [-121.4078, 37.15661], [-121.40777, 37.15719], [-121.40817, 37.1577], [-121.40823, 37.15805], [-121.40864, 37.15824], [-121.40895, 37.1588], [-121.40895, 37.1592], [-121.40941, 37.15948], [-121.4097, 37.16018], [-121.40982, 37.17031], [-121.40988, 37.17041], [-121.41016, 37.17075], [-121.41188, 37.172], [-121.41269, 37.17207], [-121.414, 37.17273], [-121.41474, 37.17281], [-121.41492, 37.17362], [-121.41507, 37.17449], [-121.41308, 37.1749], [-121.41175, 37.17577], [-121.41165, 37.17613], [-121.41158, 37.1769], [-121.41158, 37.17748], [-121.41259, 37.17816], [-121.41264, 37.17913], [-121.41286, 37.17956], [-121.41272, 37.17987], [-121.41198, 37.18032], [-121.41152, 37.18085], [-121.41165, 37.18144], [-121.41136, 37.18218], [-121.40997, 37.18265], [-121.40999, 37.18444], [-121.41047, 37.18524], [-121.41119, 37.18539], [-121.41165, 37.18531], [-121.41177, 37.18573], [-121.41243, 37.18574], [-121.41329, 37.18612], [-121.41262, 37.18723], [-121.41263, 37.18724], [-121.4131, 37.18724], [-121.41331, 37.18797], [-121.41279, 37.18862], [-121.41286, 37.18893], [-121.41507, 37.18892], [-121.41497, 37.19007], [-121.41473, 37.1904], [-121.41448, 37.19168], [-121.41406, 37.19202], [-121.41441, 37.19301], [-121.41418, 37.19386], [-121.41479, 37.1941], [-121.41513, 37.19465], [-121.41508, 37.1955], [-121.41603, 37.19621], [-121.41546, 37.19718], [-121.4157, 37.1974], [-121.41595, 37.19795], [-121.41614, 37.19802], [-121.41741, 37.19927], [-121.41748, 37.19956], [-121.41778, 37.2], [-121.41771, 37.20075], [-121.41788, 37.20078], [-121.41804, 37.20115], [-121.41795, 37.20212], [-121.41815, 37.20229], [-121.41817, 37.20252], [-121.41975, 37.2027], [-121.4197, 37.20314], [-121.41947, 37.20411], [-121.41996, 37.20436], [-121.42, 37.20455], [-121.41994, 37.20499], [-121.41999, 37.20532], [-121.42013, 37.20588], [-121.4201, 37.20617], [-121.42019, 37.2072], [-121.42027, 37.20762], [-121.42102, 37.20852], [-121.42147, 37.20883], [-121.42166, 37.20946], [-121.42183, 37.21033], [-121.4211, 37.21033], [-121.42105, 37.21086], [-121.4212, 37.21197], [-121.42107, 37.21263], [-121.42263, 37.21373], [-121.42413, 37.214], [-121.42454, 37.21446], [-121.4248, 37.21499], [-121.42483, 37.21604], [-121.42747, 37.21601], [-121.42736, 37.21831], [-121.42761, 37.22485], [-121.42866, 37.22536], [-121.43041, 37.22541], [-121.43042, 37.22626], [-121.43127, 37.22746], [-121.4323, 37.22799], [-121.43285, 37.22805], [-121.43405, 37.22945], [-121.43531, 37.22914], [-121.43627, 37.22986], [-121.43765, 37.23037], [-121.4377, 37.23037], [-121.43772, 37.23399], [-121.43775, 37.23452], [-121.43771, 37.23934], [-121.4467, 37.23893], [-121.44671, 37.23869], [-121.44688, 37.23894], [-121.44803, 37.2397], [-121.44876, 37.24067], [-121.44921, 37.24093], [-121.44956, 37.24149], [-121.45056, 37.2413], [-121.45091, 37.24131], [-121.45253, 37.24325], [-121.45295, 37.24433], [-121.45325, 37.24459], [-121.45123, 37.24463], [-121.45124, 37.24614], [-121.45181, 37.2472], [-121.45272, 37.24777], [-121.45285, 37.24819], [-121.45518, 37.24816], [-121.45519, 37.25075], [-121.45561, 37.25084], [-121.45562, 37.25094], [-121.45591, 37.25107], [-121.45599, 37.25114], [-121.45606, 37.2513], [-121.45608, 37.25141], [-121.45624, 37.25174], [-121.45639, 37.25209], [-121.45639, 37.2522], [-121.45636, 37.25231], [-121.45627, 37.25243], [-121.45616, 37.25256], [-121.45603, 37.25265], [-121.45557, 37.25285], [-121.4554, 37.25294], [-121.45528, 37.25302], [-121.45512, 37.25326], [-121.45511, 37.25339], [-121.45525, 37.25367], [-121.45524, 37.25373], [-121.45522, 37.2538], [-121.44639, 37.25381], [-121.44613, 37.26109], [-121.43253, 37.26129], [-121.4326, 37.26498], [-121.4371, 37.26493], [-121.4372, 37.27494], [-121.43855, 37.27496], [-121.43853, 37.28306], [-121.45124, 37.28307], [-121.45119, 37.28578], [-121.45661, 37.2858]]]}	Open Access 1	18235	Henry W. Coe State Park	1566	204	California Department of Parks and Recreation 48	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://www.parks.ca.gov/?page_id=561	Stanislaus 2	28259.874	Henry W. Coe SP	1959	State Park 15	4
16685	16685	16684	{"type": "MultiPolygon", "coordinates": [[[[-120.97841, 37.3416], [-120.97836, 37.34177], [-120.97784, 37.34216], [-120.97724, 37.34226], [-120.97631, 37.34346], [-120.97602, 37.34421], [-120.97597, 37.34438], [-120.97593, 37.34444], [-120.97592, 37.34454], [-120.97571, 37.34488], [-120.97566, 37.34507], [-120.97566, 37.34529], [-120.97585, 37.34562], [-120.97595, 37.3457], [-120.9761, 37.34578], [-120.97616, 37.34583], [-120.97623, 37.34593], [-120.97631, 37.34599], [-120.97645, 37.34618], [-120.9765, 37.34622], [-120.97653, 37.3465], [-120.97648, 37.34664], [-120.97638, 37.34675], [-120.97592, 37.34681], [-120.97522, 37.34713], [-120.97439, 37.34803], [-120.97413, 37.34834], [-120.97409, 37.349], [-120.97401, 37.34925], [-120.97384, 37.34926], [-120.9733, 37.34921], [-120.97302, 37.34913], [-120.97249, 37.34892], [-120.97213, 37.34876], [-120.97184, 37.3486], [-120.97152, 37.34829], [-120.97138, 37.34808], [-120.97134, 37.34775], [-120.97134, 37.34749], [-120.97126, 37.34733], [-120.97109, 37.34711], [-120.96997, 37.34605], [-120.96958, 37.34575], [-120.96932, 37.34557], [-120.96885, 37.34538], [-120.9684, 37.34534], [-120.96801, 37.34533], [-120.96768, 37.34541], [-120.96728, 37.34554], [-120.96644, 37.34592], [-120.966, 37.34606], [-120.9657, 37.34614], [-120.96509, 37.34611], [-120.96489, 37.34605], [-120.96472, 37.34591], [-120.96458, 37.34575], [-120.96456, 37.3457], [-120.96414, 37.34562], [-120.96368, 37.34567], [-120.96483, 37.34478], [-120.96516, 37.34488], [-120.96913, 37.34174], [-120.97186, 37.33963], [-120.97223, 37.34008], [-120.9724, 37.34033], [-120.97254, 37.34045], [-120.9729, 37.34067], [-120.97314, 37.34073], [-120.97354, 37.34078], [-120.97394, 37.34076], [-120.97433, 37.34066], [-120.97448, 37.34049], [-120.9746, 37.34029], [-120.97481, 37.34028], [-120.97511, 37.34037], [-120.97545, 37.34056], [-120.97565, 37.34081], [-120.97561, 37.34127], [-120.97572, 37.34147], [-120.97589, 37.34162], [-120.97629, 37.34168], [-120.97656, 37.34166], [-120.97675, 37.34156], [-120.97696, 37.34126], [-120.97724, 37.34099], [-120.97745, 37.34086], [-120.97767, 37.3408], [-120.97841, 37.3416]]], [[[-120.98615, 37.33757], [-120.98331, 37.3402], [-120.98007, 37.33795], [-120.97985, 37.33808], [-120.97922, 37.33829], [-120.97886, 37.33864], [-120.9787, 37.33868], [-120.97846, 37.33862], [-120.97829, 37.33845], [-120.97835, 37.33802], [-120.9782, 37.33758], [-120.97827, 37.33732], [-120.97864, 37.33699], [-120.9787, 37.33671], [-120.97849, 37.33651], [-120.97757, 37.33614], [-120.97721, 37.33617], [-120.97642, 37.33657], [-120.97703, 37.33682], [-120.97706, 37.33694], [-120.97694, 37.33726], [-120.9765, 37.3376], [-120.97605, 37.33773], [-120.97615, 37.33803], [-120.97617, 37.3384], [-120.97616, 37.33881], [-120.97622, 37.33908], [-120.97606, 37.33931], [-120.97641, 37.33963], [-120.97653, 37.33999], [-120.9768, 37.34041], [-120.97736, 37.34051], [-120.97778, 37.34046], [-120.97722, 37.34065], [-120.97696, 37.34083], [-120.97683, 37.34099], [-120.97666, 37.34109], [-120.9765, 37.34136], [-120.97641, 37.3414], [-120.9763, 37.34142], [-120.97606, 37.34137], [-120.97598, 37.34132], [-120.97594, 37.34122], [-120.97599, 37.34099], [-120.97599, 37.34083], [-120.9759, 37.34057], [-120.97565, 37.34034], [-120.97522, 37.34011], [-120.97487, 37.34], [-120.97475, 37.33999], [-120.97453, 37.34002], [-120.97436, 37.34007], [-120.9743, 37.34013], [-120.97421, 37.34031], [-120.97413, 37.3404], [-120.97404, 37.34044], [-120.97388, 37.34049], [-120.97357, 37.3405], [-120.97322, 37.34047], [-120.97311, 37.34045], [-120.97279, 37.34026], [-120.97265, 37.34015], [-120.97252, 37.33994], [-120.97224, 37.3396], [-120.97211, 37.33943], [-120.975, 37.33717], [-120.97945, 37.33371], [-120.98484, 37.33624], [-120.98615, 37.33757]]]]}	Open Access 1	493	North Grasslands Wildlife Area	30482	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/North-Grasslands-WA	Stanislaus 2	253.111	North Grasslands Wildlife Area	1992	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]);