calands: units_with_maps: 45 rows where ACCESS_TYP = 2, DES

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

45 rows where ACCESS_TYP = 2, DES_TP = 8 and LAYER = 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
655	655	654	{"type": "Polygon", "coordinates": [[[-122.60188, 38.34223], [-122.60099, 38.34219], [-122.59824, 38.34219], [-122.59784, 38.34221], [-122.59674, 38.34238], [-122.59579, 38.34284], [-122.59514, 38.34423], [-122.59427, 38.34493], [-122.59333, 38.34522], [-122.59334, 38.34582], [-122.59113, 38.34633], [-122.5913, 38.34768], [-122.59135, 38.34828], [-122.5912, 38.3487], [-122.59122, 38.34925], [-122.59128, 38.34926], [-122.5913, 38.34965], [-122.59261, 38.35027], [-122.59275, 38.35752], [-122.58592, 38.35768], [-122.58582, 38.35554], [-122.5836, 38.35559], [-122.58354, 38.34758], [-122.58768, 38.34758], [-122.58754, 38.34322], [-122.5927, 38.34315], [-122.59271, 38.33808], [-122.59176, 38.33786], [-122.59079, 38.33744], [-122.58972, 38.33705], [-122.58885, 38.33685], [-122.588, 38.3368], [-122.58729, 38.33644], [-122.5869, 38.33609], [-122.58626, 38.33575], [-122.58571, 38.33561], [-122.58518, 38.33551], [-122.58545, 38.33521], [-122.58614, 38.33528], [-122.58697, 38.33561], [-122.58767, 38.33622], [-122.58824, 38.33643], [-122.58911, 38.33648], [-122.58974, 38.33662], [-122.5905, 38.33687], [-122.59169, 38.33743], [-122.5927, 38.33768], [-122.59271, 38.33767], [-122.59272, 38.33589], [-122.60179, 38.33588], [-122.60186, 38.34013], [-122.60188, 38.34223]], [[-122.5906, 38.3493], [-122.59059, 38.34928], [-122.59046, 38.34931], [-122.59053, 38.34931], [-122.5906, 38.3493]]]}	Restricted Access 2	3269	Fairfield Osborn Preserve	18798	211	California State University Sonoma 232	State 5	State Agency 5	http://www.sonoma.edu/	Other State 5	211	California State University Sonoma 228	State 5	State Agency 5		Sonoma 16	414.364	Fairfield Osborn Preserve	2004	State Conservation Area 8	2
1947	1947	1946	{"type": "MultiPolygon", "coordinates": [[[[-118.98159, 36.05067], [-118.98137, 36.05079], [-118.9727, 36.05085], [-118.9718, 36.05081], [-118.97127, 36.05076], [-118.9708, 36.0507], [-118.97091, 36.0439], [-118.98041, 36.04394], [-118.98036, 36.04846], [-118.98039, 36.04883], [-118.98043, 36.04901], [-118.98052, 36.04928], [-118.98064, 36.04953], [-118.98074, 36.0497], [-118.98091, 36.04994], [-118.98105, 36.05009], [-118.98123, 36.05026], [-118.98148, 36.05046], [-118.98159, 36.05067]]], [[[-118.98205, 36.04396], [-118.98203, 36.04531], [-118.98196, 36.05048], [-118.98172, 36.05031], [-118.98148, 36.05012], [-118.98129, 36.04993], [-118.9811, 36.0497], [-118.98094, 36.04945], [-118.98084, 36.04924], [-118.98075, 36.04901], [-118.98068, 36.04874], [-118.98065, 36.04846], [-118.9807, 36.04394], [-118.98205, 36.04396]]]]}	Restricted Access 2	29177	Yaudanchi Ecological Reserve	27765	220	California Department of Health Services 459	State 5	State Agency 5	http://www.dhcs.ca.gov/Pages/default.aspx	Other State 5	201	California Department of Fish and Wildlife 25	State 5	State Agency 5		Tulare 29	184.306	Yaudanchi ER	0	State Conservation Area 8	2
3108	3108	3107	{"type": "MultiPolygon", "coordinates": [[[[-121.46234, 38.2686], [-121.46231, 38.26876], [-121.46161, 38.26911], [-121.46002, 38.26922], [-121.45923, 38.26938], [-121.45839, 38.2697], [-121.45775, 38.26965], [-121.45753, 38.26953], [-121.45774, 38.2673], [-121.45781, 38.26714], [-121.4579, 38.2664], [-121.45801, 38.26606], [-121.4583, 38.26581], [-121.45862, 38.26576], [-121.45932, 38.26588], [-121.46083, 38.2659], [-121.46118, 38.26624], [-121.46112, 38.26713], [-121.46132, 38.26782], [-121.46167, 38.26823], [-121.46211, 38.2684], [-121.46234, 38.2686]]], [[[-121.68459, 38.14478], [-121.68456, 38.14487], [-121.68445, 38.14505], [-121.68418, 38.14541], [-121.68404, 38.14611], [-121.68393, 38.14638], [-121.68387, 38.14656], [-121.68386, 38.14674], [-121.68389, 38.14684], [-121.6838, 38.14733], [-121.68366, 38.14777], [-121.68363, 38.148], [-121.68355, 38.14839], [-121.68327, 38.14912], [-121.68318, 38.14929], [-121.68312, 38.1493], [-121.68345, 38.14644], [-121.68406, 38.14476], [-121.68459, 38.14478]]]]}	Restricted Access 2	25288	Cosumnes River Preserve	17678	299	Other State 131	State 5	State Agency 5		Other State 5	299	Other State 128	State 5	State Agency 5		Sacramento 41	35.364	Cosumnes River Preserve	0	State Conservation Area 8	2
3672	3672	3671	{"type": "MultiPolygon", "coordinates": [[[[-120.44871, 34.6888], [-120.44792, 34.69026], [-120.4478, 34.69035], [-120.44763, 34.69033], [-120.44725, 34.69018], [-120.44662, 34.68998], [-120.44669, 34.6899], [-120.44679, 34.6897], [-120.44724, 34.68935], [-120.44815, 34.68888], [-120.44871, 34.6888]]], [[[-120.4499, 34.69128], [-120.44987, 34.69127], [-120.44986, 34.69126], [-120.44856, 34.69068], [-120.44826, 34.69059], [-120.44812, 34.69043], [-120.44817, 34.69018], [-120.44916, 34.6887], [-120.44971, 34.68869], [-120.44982, 34.68905], [-120.45004, 34.69], [-120.45006, 34.69067], [-120.4499, 34.69128]]]]}	Restricted Access 2	29691	Burton Mesa Ecological Reserve	16533	209	California State Lands Commission 75	State 5	State Agency 5	http://www.slc.ca.gov/	Other State 5	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Burton-Mesa-ER	Santa Barbara 7	11.989	Burton Mesa ER	2004	State Conservation Area 8	2
3803	3803	3802	{"type": "MultiPolygon", "coordinates": [[[[-122.10658, 38.5004], [-122.09761, 38.50035], [-122.09774, 38.50434], [-122.09775, 38.50723], [-122.09305, 38.50723], [-122.093, 38.50397], [-122.09232, 38.49092], [-122.09697, 38.4909], [-122.09687, 38.4893], [-122.09688, 38.48804], [-122.0969, 38.48794], [-122.09688, 38.4865], [-122.09693, 38.48236], [-122.10164, 38.48238], [-122.10165, 38.48207], [-122.10631, 38.48211], [-122.10633, 38.48923], [-122.1065, 38.49317], [-122.10655, 38.49628], [-122.10658, 38.5004]]], [[[-122.1064, 38.50769], [-122.10633, 38.50813], [-122.10619, 38.50846], [-122.1061, 38.5086], [-122.10598, 38.5087], [-122.10582, 38.50877], [-122.10572, 38.50879], [-122.10561, 38.50879], [-122.10518, 38.50894], [-122.10504, 38.50897], [-122.10464, 38.50918], [-122.10452, 38.50932], [-122.10427, 38.5095], [-122.1042, 38.50947], [-122.10212, 38.50969], [-122.10231, 38.50753], [-122.10582, 38.50758], [-122.1064, 38.50769]]]]}	Restricted Access 2	35111	Stebbins Cold Canyon Reserve	25816	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		Solano 26	606.446	Stebbins Cold Canyon Reserve	0	State Conservation Area 8	2
5503	5503	5502	{"type": "MultiPolygon", "coordinates": [[[[-117.24645, 33.15192], [-117.24325, 33.15203], [-117.24295, 33.1512], [-117.24431, 33.15105], [-117.24644, 33.15036], [-117.24645, 33.15192]]], [[[-117.26182, 33.14925], [-117.26138, 33.14958], [-117.25936, 33.14941], [-117.25864, 33.14971], [-117.2584, 33.14977], [-117.25816, 33.14977], [-117.25744, 33.14967], [-117.25731, 33.14967], [-117.25716, 33.14971], [-117.25701, 33.14979], [-117.25667, 33.15004], [-117.25655, 33.15019], [-117.25648, 33.15037], [-117.25635, 33.1512], [-117.25631, 33.1513], [-117.25622, 33.15142], [-117.25586, 33.15176], [-117.25562, 33.15211], [-117.25053, 33.15267], [-117.25006, 33.1537], [-117.24851, 33.15389], [-117.24842, 33.1523], [-117.24819, 33.15211], [-117.24806, 33.15211], [-117.24804, 33.15188], [-117.24906, 33.14891], [-117.24789, 33.14895], [-117.24624, 33.14851], [-117.24658, 33.14758], [-117.24459, 33.14705], [-117.24455, 33.14478], [-117.24659, 33.1439], [-117.24672, 33.1458], [-117.26179, 33.1458], [-117.26182, 33.14925]]]]}	Restricted Access 2	12865	Dawson Los Monos Canyon Reserve	17958	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		San Diego 4	231.903	Dawson Los Monos Canyon Reserve	0	State Conservation Area 8	2
5757	5757	5756	{"type": "Polygon", "coordinates": [[[-118.06308, 33.71148], [-118.0591, 33.71135], [-118.05909, 33.71137], [-118.05916, 33.71145], [-118.0591, 33.71145], [-118.0529, 33.70379], [-118.05255, 33.70376], [-118.05209, 33.70383], [-118.05126, 33.7045], [-118.05053, 33.70499], [-118.04992, 33.70528], [-118.04939, 33.70559], [-118.04839, 33.70627], [-118.04758, 33.70679], [-118.04721, 33.70696], [-118.0473, 33.70706], [-118.04645, 33.70713], [-118.0451, 33.7068], [-118.04429, 33.70664], [-118.04277, 33.7066], [-118.04262, 33.70639], [-118.03926, 33.70783], [-118.03874, 33.70808], [-118.03248, 33.7108], [-118.03236, 33.71026], [-118.0385, 33.70771], [-118.03856, 33.70759], [-118.04008, 33.70696], [-118.04008, 33.70694], [-118.03929, 33.70619], [-118.0362, 33.70457], [-118.0348, 33.70349], [-118.0343, 33.70285], [-118.03222, 33.70268], [-118.03233, 33.70084], [-118.03007, 33.70098], [-118.02774, 33.69924], [-118.02442, 33.69685], [-118.02392, 33.69652], [-118.02288, 33.69605], [-118.02167, 33.69532], [-118.02083, 33.69486], [-118.02092, 33.69004], [-118.0209, 33.68917], [-118.02053, 33.68916], [-118.02115, 33.68814], [-118.02114, 33.68806], [-118.02204, 33.68651], [-118.02221, 33.68641], [-118.02252, 33.68592], [-118.02297, 33.68566], [-118.02347, 33.68548], [-118.02404, 33.68539], [-118.02475, 33.68495], [-118.02488, 33.68482], [-118.02499, 33.68461], [-118.02516, 33.68437], [-118.02565, 33.68424], [-118.02733, 33.68355], [-118.02777, 33.68348], [-118.02863, 33.68372], [-118.03085, 33.6841], [-118.03152, 33.68436], [-118.03221, 33.68471], [-118.03276, 33.68458], [-118.03308, 33.68442], [-118.03319, 33.6839], [-118.0338, 33.68341], [-118.03355, 33.68309], [-118.03361, 33.68286], [-118.03424, 33.68245], [-118.03919, 33.68737], [-118.04395, 33.69223], [-118.04773, 33.69635], [-118.05291, 33.70154], [-118.05401, 33.7027], [-118.05549, 33.70404], [-118.05874, 33.70712], [-118.06037, 33.70878], [-118.06086, 33.70921], [-118.06308, 33.71148]]]}	Restricted Access 2	6996	Bolsa Chica Ecological Reserve	16245	209	California State Lands Commission 75	State 5	State Agency 5	http://www.slc.ca.gov/	Other State 5	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bolsa-Chica-ER	Orange 3	1223.82	Bolsa Chica ER	1993	State Conservation Area 8	2
6257	6257	6256	{"type": "Polygon", "coordinates": [[[-123.07837, 38.32311], [-123.07836, 38.32325], [-123.07834, 38.32329], [-123.07828, 38.32333], [-123.07823, 38.32327], [-123.07821, 38.32328], [-123.07823, 38.32335], [-123.07809, 38.32338], [-123.07798, 38.32331], [-123.07797, 38.32332], [-123.07798, 38.32336], [-123.07795, 38.32337], [-123.07786, 38.32333], [-123.07781, 38.32336], [-123.07771, 38.32325], [-123.07769, 38.32332], [-123.07764, 38.32332], [-123.0776, 38.32328], [-123.07758, 38.32319], [-123.07751, 38.32318], [-123.0774, 38.32309], [-123.07735, 38.32312], [-123.07735, 38.32317], [-123.07729, 38.32319], [-123.07714, 38.32316], [-123.07706, 38.32319], [-123.07702, 38.32309], [-123.07695, 38.32312], [-123.07686, 38.3231], [-123.07668, 38.32291], [-123.07659, 38.32292], [-123.07642, 38.32283], [-123.07633, 38.32289], [-123.07621, 38.3228], [-123.07614, 38.32268], [-123.07607, 38.32252], [-123.07597, 38.32247], [-123.0759, 38.32241], [-123.07577, 38.32232], [-123.07571, 38.32225], [-123.07485, 38.32245], [-123.07388, 38.323], [-123.06521, 38.31876], [-123.0652, 38.31877], [-123.06519, 38.3231], [-123.06515, 38.32332], [-123.06285, 38.3217], [-123.05888, 38.31954], [-123.05732, 38.31876], [-123.05637, 38.31841], [-123.05631, 38.31831], [-123.0564, 38.31813], [-123.05663, 38.31789], [-123.05696, 38.31739], [-123.05732, 38.31658], [-123.05751, 38.31584], [-123.05778, 38.31536], [-123.05812, 38.31492], [-123.05837, 38.31469], [-123.05885, 38.31437], [-123.05961, 38.31402], [-123.06022, 38.31377], [-123.06103, 38.31335], [-123.06125, 38.31317], [-123.0615, 38.31293], [-123.06169, 38.31255], [-123.06539, 38.31252], [-123.0679, 38.31144], [-123.06859, 38.31127], [-123.06891, 38.31163], [-123.06927, 38.31224], [-123.06952, 38.31261], [-123.0696, 38.31291], [-123.06962, 38.31312], [-123.06976, 38.31336], [-123.06971, 38.31355], [-123.06977, 38.31387], [-123.06988, 38.3141], [-123.07005, 38.3142], [-123.07024, 38.31428], [-123.07041, 38.31424], [-123.07046, 38.31434], [-123.07046, 38.31446], [-123.07043, 38.31452], [-123.07032, 38.31452], [-123.0701, 38.31447], [-123.06998, 38.31454], [-123.06998, 38.3147], [-123.0699, 38.31491], [-123.06943, 38.31527], [-123.06895, 38.31571], [-123.06866, 38.31582], [-123.06863, 38.31599], [-123.06877, 38.31623], [-123.06891, 38.3165], [-123.06949, 38.317], [-123.0697, 38.31714], [-123.07019, 38.31729], [-123.07047, 38.31734], [-123.07082, 38.31725], [-123.07114, 38.31689], [-123.07128, 38.31669], [-123.0715, 38.31657], [-123.07181, 38.31648], [-123.07206, 38.31656], [-123.07239, 38.31694], [-123.07239, 38.31706], [-123.0725, 38.31721], [-123.0725, 38.31733], [-123.07265, 38.31758], [-123.07283, 38.3177], [-123.07321, 38.31802], [-123.07329, 38.31821], [-123.07344, 38.31838], [-123.07359, 38.31866], [-123.07381, 38.3189], [-123.07395, 38.31895], [-123.07408, 38.3192], [-123.07457, 38.31972], [-123.07479, 38.31989], [-123.07489, 38.32], [-123.07521, 38.32017], [-123.07543, 38.32032], [-123.07647, 38.32069], [-123.07679, 38.32083], [-123.07732, 38.32109], [-123.07735, 38.32117], [-123.07731, 38.32124], [-123.07737, 38.32131], [-123.07745, 38.32155], [-123.07732, 38.32161], [-123.07741, 38.32168], [-123.07741, 38.32173], [-123.07749, 38.32171], [-123.07751, 38.32181], [-123.0775, 38.32187], [-123.0774, 38.32191], [-123.07736, 38.32193], [-123.07736, 38.32195], [-123.07739, 38.32197], [-123.07756, 38.322], [-123.07759, 38.32208], [-123.07755, 38.32223], [-123.07761, 38.32236], [-123.07777, 38.32242], [-123.07777, 38.32251], [-123.0777, 38.32259], [-123.07773, 38.32267], [-123.07787, 38.3227], [-123.07801, 38.32275], [-123.07808, 38.32284], [-123.07804, 38.32284], [-123.07803, 38.32286], [-123.07809, 38.32291], [-123.07817, 38.32291], [-123.07822, 38.32299], [-123.0782, 38.32304], [-123.07825, 38.3231], [-123.07832, 38.32307], [-123.07837, 38.32311]]]}	Restricted Access 2	1339	Bodega Marine Reserve	16219	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		Sonoma 16	295.278	Bodega Marine Reserve	0	State Conservation Area 8	2
6470	6470	6469	{"type": "Polygon", "coordinates": [[[-122.06987, 36.9535], [-122.06981, 36.95358], [-122.06949, 36.9538], [-122.06941, 36.95398], [-122.06942, 36.95419], [-122.06937, 36.95429], [-122.06901, 36.95456], [-122.06885, 36.95465], [-122.06873, 36.95472], [-122.06864, 36.95469], [-122.06863, 36.95464], [-122.06886, 36.95406], [-122.06891, 36.95388], [-122.06883, 36.95375], [-122.06855, 36.95346], [-122.06841, 36.95338], [-122.06811, 36.95332], [-122.06804, 36.9533], [-122.06796, 36.95323], [-122.06787, 36.95299], [-122.06775, 36.95281], [-122.06759, 36.95271], [-122.06748, 36.95283], [-122.0673, 36.9535], [-122.06718, 36.95371], [-122.06691, 36.95396], [-122.06662, 36.95409], [-122.06652, 36.95425], [-122.06651, 36.95458], [-122.06646, 36.95465], [-122.06596, 36.95498], [-122.06572, 36.95531], [-122.06541, 36.95567], [-122.06527, 36.9558], [-122.06529, 36.95758], [-122.06435, 36.95765], [-122.06252, 36.95783], [-122.06252, 36.95702], [-122.06409, 36.95687], [-122.06393, 36.95661], [-122.06374, 36.95665], [-122.06365, 36.95663], [-122.06346, 36.95664], [-122.06323, 36.9566], [-122.06311, 36.95649], [-122.063, 36.95647], [-122.06279, 36.95648], [-122.06252, 36.9564], [-122.06252, 36.95528], [-122.06283, 36.95494], [-122.06305, 36.95465], [-122.06253, 36.95452], [-122.06255, 36.94931], [-122.06258, 36.9493], [-122.06257, 36.94913], [-122.06265, 36.94914], [-122.06284, 36.9491], [-122.06294, 36.94905], [-122.06297, 36.94899], [-122.06304, 36.94897], [-122.06311, 36.94898], [-122.06313, 36.94902], [-122.06319, 36.9491], [-122.06346, 36.94912], [-122.06352, 36.94905], [-122.06363, 36.94907], [-122.06369, 36.94913], [-122.06379, 36.94913], [-122.06386, 36.94901], [-122.06397, 36.94895], [-122.06405, 36.94886], [-122.06413, 36.94885], [-122.06417, 36.94886], [-122.06427, 36.94894], [-122.06438, 36.94918], [-122.06449, 36.94936], [-122.06451, 36.94945], [-122.06458, 36.94958], [-122.06463, 36.94959], [-122.06467, 36.94957], [-122.06473, 36.94967], [-122.06484, 36.9498], [-122.06485, 36.94984], [-122.06494, 36.9499], [-122.06502, 36.94993], [-122.06509, 36.94994], [-122.06527, 36.94991], [-122.06535, 36.94993], [-122.06539, 36.94995], [-122.0654, 36.94999], [-122.06542, 36.95011], [-122.06543, 36.95141], [-122.0643, 36.95145], [-122.06423, 36.95149], [-122.06419, 36.95157], [-122.06396, 36.95157], [-122.06383, 36.95151], [-122.06371, 36.9515], [-122.0636, 36.95158], [-122.06358, 36.95203], [-122.06371, 36.9521], [-122.06386, 36.95212], [-122.06403, 36.95223], [-122.06409, 36.95232], [-122.06414, 36.95248], [-122.0641, 36.95272], [-122.06406, 36.95279], [-122.06397, 36.95289], [-122.06379, 36.95299], [-122.06356, 36.95303], [-122.06343, 36.95316], [-122.06344, 36.95323], [-122.06341, 36.9534], [-122.06328, 36.95465], [-122.06329, 36.95469], [-122.06335, 36.95477], [-122.06348, 36.95486], [-122.06387, 36.95499], [-122.06439, 36.9552], [-122.06458, 36.95526], [-122.0647, 36.95528], [-122.06483, 36.95523], [-122.06483, 36.95522], [-122.06471, 36.95513], [-122.06466, 36.95499], [-122.0647, 36.95483], [-122.06476, 36.95477], [-122.06499, 36.9547], [-122.06515, 36.95472], [-122.06516, 36.95456], [-122.06519, 36.9545], [-122.06528, 36.95442], [-122.06534, 36.95441], [-122.06539, 36.95463], [-122.06548, 36.95464], [-122.06553, 36.95459], [-122.06564, 36.95458], [-122.06576, 36.9546], [-122.06599, 36.95469], [-122.06607, 36.95464], [-122.06612, 36.95458], [-122.06611, 36.95448], [-122.06589, 36.95435], [-122.06581, 36.95426], [-122.06579, 36.95411], [-122.06583, 36.954], [-122.0661, 36.95379], [-122.06624, 36.95376], [-122.06639, 36.95369], [-122.0665, 36.9536], [-122.06661, 36.95347], [-122.06663, 36.95328], [-122.0666, 36.95316], [-122.06665, 36.95305], [-122.06671, 36.95299], [-122.06669, 36.95278], [-122.06659, 36.95269], [-122.06619, 36.95268], [-122.06601, 36.95256], [-122.06587, 36.95234], [-122.06581, 36.95213], [-122.06577, 36.95205], [-122.0656, 36.95205], [-122.06559, 36.95199], [-122.06559, 36.95186], [-122.06556, 36.95181], [-122.0655, 36.95178], [-122.0655, 36.95052], [-122.06563, 36.95049], [-122.06624, 36.94994], [-122.06635, 36.94985], [-122.06654, 36.94976], [-122.06661, 36.94967], [-122.06662, 36.94961], [-122.06661, 36.94952], [-122.06649, 36.94938], [-122.0663, 36.94924], [-122.06616, 36.94904], [-122.06604, 36.94882], [-122.06589, 36.94877], [-122.06593, 36.94865], [-122.06599, 36.94859], [-122.06601, 36.94849], [-122.06584, 36.94835], [-122.0657, 36.94827], [-122.06557, 36.9483], [-122.06538, 36.94829], [-122.06547, 36.94823], [-122.06588, 36.94807], [-122.06593, 36.94806], [-122.066, 36.94808], [-122.06611, 36.94822], [-122.06617, 36.9484], [-122.06628, 36.94853], [-122.0663, 36.9486], [-122.06635, 36.9486], [-122.0664, 36.94864], [-122.0664, 36.94868], [-122.06645, 36.94873], [-122.06657, 36.94869], [-122.06662, 36.94873], [-122.0667, 36.94871], [-122.06683, 36.94873], [-122.06703, 36.94882], [-122.06728, 36.9489], [-122.06744, 36.94888], [-122.06746, 36.94882], [-122.06749, 36.94881], [-122.06748, 36.94873], [-122.0676, 36.94904], [-122.06791, 36.94952], [-122.06793, 36.9497], [-122.06792, 36.95008], [-122.06804, 36.95042], [-122.06804, 36.95054], [-122.06795, 36.95066], [-122.06777, 36.9507], [-122.0677, 36.95086], [-122.06779, 36.95095], [-122.06811, 36.95111], [-122.0681, 36.95118], [-122.06805, 36.95125], [-122.06788, 36.95128], [-122.06777, 36.95138], [-122.06771, 36.95153], [-122.06771, 36.95165], [-122.06803, 36.95196], [-122.06811, 36.95216], [-122.06816, 36.95233], [-122.0683, 36.95252], [-122.06871, 36.95279], [-122.06896, 36.953], [-122.06919, 36.95329], [-122.06937, 36.95338], [-122.06947, 36.95339], [-122.06979, 36.95341], [-122.06987, 36.9535]]]}	Restricted Access 2	2005	Younger Lagoon Reserve	27791	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		Santa Cruz 5	69.92	Younger Lagoon Reserve	0	State Conservation Area 8	2
6642	6642	6641	{"type": "MultiPolygon", "coordinates": [[[[-119.52824, 34.39721], [-119.52817, 34.39735], [-119.52732, 34.39804], [-119.52713, 34.39789], [-119.52812, 34.3971], [-119.52824, 34.39721]]], [[[-119.53867, 34.39858], [-119.53863, 34.40505], [-119.53816, 34.40492], [-119.53775, 34.40478], [-119.53696, 34.40448], [-119.5299, 34.40115], [-119.53026, 34.40061], [-119.52943, 34.40021], [-119.53009, 34.39857], [-119.53025, 34.3983], [-119.53107, 34.39724], [-119.53128, 34.39727], [-119.53248, 34.3973], [-119.53281, 34.39735], [-119.53323, 34.39755], [-119.5335, 34.39773], [-119.53403, 34.39803], [-119.53427, 34.39808], [-119.53464, 34.39818], [-119.53497, 34.39818], [-119.53521, 34.39816], [-119.53545, 34.39819], [-119.53573, 34.39815], [-119.5363, 34.39809], [-119.53663, 34.39814], [-119.53683, 34.39811], [-119.53691, 34.39788], [-119.53704, 34.39764], [-119.53709, 34.39747], [-119.53714, 34.39719], [-119.53711, 34.39711], [-119.53711, 34.39706], [-119.53666, 34.39621], [-119.53655, 34.39595], [-119.53674, 34.396], [-119.53724, 34.39633], [-119.53758, 34.39698], [-119.53758, 34.39805], [-119.53867, 34.39858]]]]}	Restricted Access 2	4645	Carpinteria Salt Marsh Reserve - UC Natural Reserve	16902	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		Santa Barbara 7	120.56	Carpinteria Salt Marsh Reserve - UC Natural Reserve	0	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
7602	7602	7601	{"type": "Polygon", "coordinates": [[[-117.09082, 32.89483], [-117.08881, 32.89783], [-117.0865, 32.89848], [-117.08509, 32.89881], [-117.08278, 32.89949], [-117.08164, 32.89815], [-117.07952, 32.89829], [-117.07915, 32.89934], [-117.08029, 32.90022], [-117.07721, 32.90112], [-117.07883, 32.90284], [-117.07721, 32.90339], [-117.07527, 32.90178], [-117.07426, 32.90045], [-117.07239, 32.89842], [-117.07523, 32.89837], [-117.07522, 32.89663], [-117.08409, 32.89651], [-117.08416, 32.89467], [-117.08629, 32.8947], [-117.08637, 32.89287], [-117.08828, 32.89286], [-117.0883, 32.89111], [-117.09079, 32.89112], [-117.09082, 32.89483]]]}	Restricted Access 2	48471	Elliott Chaparral Reserve	33182	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/elliott-chaparral-reserve/	San Diego 4	183.016	Elliott Chaparral Reserve	0	State Conservation Area 8	2
7672	7672	7671	{"type": "Polygon", "coordinates": [[[-119.88447, 34.41537], [-119.88109, 34.41543], [-119.8811, 34.41769], [-119.87698, 34.41751], [-119.87697, 34.41748], [-119.87253, 34.41749], [-119.87264, 34.41654], [-119.87287, 34.41634], [-119.87326, 34.41582], [-119.87337, 34.41572], [-119.87354, 34.41562], [-119.87402, 34.41543], [-119.87405, 34.41541], [-119.87415, 34.41528], [-119.87415, 34.4152], [-119.87413, 34.41511], [-119.87398, 34.41487], [-119.8737, 34.41453], [-119.8736, 34.41438], [-119.87358, 34.41429], [-119.87366, 34.41409], [-119.87406, 34.41367], [-119.87424, 34.41353], [-119.87484, 34.41345], [-119.87492, 34.41343], [-119.87511, 34.4133], [-119.87521, 34.41316], [-119.87535, 34.41284], [-119.87544, 34.41272], [-119.87573, 34.41241], [-119.87588, 34.41226], [-119.87597, 34.4122], [-119.8761, 34.41214], [-119.87647, 34.41204], [-119.87677, 34.41186], [-119.87692, 34.41168], [-119.87702, 34.41149], [-119.87731, 34.41112], [-119.87748, 34.41083], [-119.87809, 34.41023], [-119.87832, 34.40993], [-119.87843, 34.40976], [-119.8785, 34.40956], [-119.87848, 34.4095], [-119.87828, 34.40933], [-119.87753, 34.40893], [-119.87745, 34.40884], [-119.87746, 34.40873], [-119.87745, 34.40867], [-119.87755, 34.40847], [-119.8776, 34.40821], [-119.87773, 34.40793], [-119.87778, 34.40784], [-119.87783, 34.4078], [-119.87802, 34.40771], [-119.87823, 34.40767], [-119.87837, 34.40768], [-119.87892, 34.40783], [-119.87898, 34.40775], [-119.87895, 34.40755], [-119.87836, 34.40717], [-119.87818, 34.4072], [-119.87779, 34.40751], [-119.87745, 34.40752], [-119.87739, 34.40733], [-119.87753, 34.40714], [-119.87764, 34.40705], [-119.8778, 34.40697], [-119.87796, 34.40689], [-119.87807, 34.40685], [-119.87821, 34.40684], [-119.87839, 34.40687], [-119.87864, 34.40696], [-119.87905, 34.40717], [-119.88006, 34.40796], [-119.88044, 34.40829], [-119.88136, 34.40918], [-119.88176, 34.40962], [-119.88228, 34.41026], [-119.88332, 34.41179], [-119.88351, 34.41198], [-119.8837, 34.41226], [-119.88443, 34.41319], [-119.88447, 34.41537]]]}	Restricted Access 2	7582	Coal Oil Point Natural Reserve	33181	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://coaloilpoint.ucnrs.org/	Santa Barbara 7	174.185	Coal Oil Point Natural 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
7999	7999	7998	{"type": "Polygon", "coordinates": [[[-117.85797, 33.6566], [-117.85687, 33.66016], [-117.85439, 33.66093], [-117.85304, 33.66254], [-117.85132, 33.66388], [-117.85077, 33.6635], [-117.85031, 33.66313], [-117.85005, 33.66289], [-117.84982, 33.66264], [-117.84939, 33.6621], [-117.84905, 33.66153], [-117.84883, 33.66102], [-117.84833, 33.65945], [-117.85104, 33.6568], [-117.84759, 33.65285], [-117.8483, 33.65243], [-117.84904, 33.65207], [-117.8495, 33.65186], [-117.85028, 33.65158], [-117.85094, 33.65138], [-117.85193, 33.65114], [-117.85261, 33.65103], [-117.85295, 33.65099], [-117.85572, 33.65361], [-117.85656, 33.65519], [-117.85797, 33.6566]]]}	Restricted Access 2	11237	San Joaquin Marsh Reserve	33193	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/san-joaquin-marsh-reserve/	Orange 3	198.279	San Joaquin Marsh Reserve	0	State Conservation Area 8	2
8345	8345	8344	{"type": "Polygon", "coordinates": [[[-123.76615, 39.28535], [-123.76613, 39.28619], [-123.76623, 39.28837], [-123.76622, 39.29088], [-123.76353, 39.28996], [-123.76354, 39.28536], [-123.76125, 39.28534], [-123.76132, 39.28339], [-123.76129, 39.28146], [-123.7637, 39.2815], [-123.76605, 39.28153], [-123.76615, 39.28535]]]}	Restricted Access 2	48474	Hans Jenny Pygmy Forest Reserve	33185	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/hans-jenny-pygmy-forest-reserve/	Mendocino 24	75.697	Hans Jenny Pygmy Forest Reserve	0	State Conservation Area 8	2
8346	8346	8345	{"type": "Polygon", "coordinates": [[[-117.23111, 32.79319], [-117.23107, 32.79326], [-117.23079, 32.7932], [-117.23029, 32.79353], [-117.2303, 32.79356], [-117.23015, 32.79366], [-117.23009, 32.79379], [-117.23005, 32.79383], [-117.23004, 32.79417], [-117.23009, 32.79439], [-117.2301, 32.79484], [-117.23047, 32.79495], [-117.23076, 32.79592], [-117.23007, 32.79609], [-117.2299, 32.79556], [-117.22808, 32.79595], [-117.22756, 32.79426], [-117.22918, 32.79378], [-117.2293, 32.79327], [-117.23017, 32.79269], [-117.23073, 32.79196], [-117.23111, 32.79319]]]}	Restricted Access 2	48475	Kendall Frost Mission Bay Marsh Reserve	33187	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/kendall-frost-mission-bay-marsh-reserve/	San Diego 4	16.556	Kendall Frost Mission Bay Marsh Reserve	0	State Conservation Area 8	2
8348	8348	8347	{"type": "MultiPolygon", "coordinates": [[[[-122.41094, 38.85388], [-122.4109, 38.86064], [-122.41064, 38.86043], [-122.41045, 38.86031], [-122.40971, 38.85998], [-122.40952, 38.85988], [-122.40712, 38.85804], [-122.40687, 38.85789], [-122.40358, 38.85648], [-122.40329, 38.85638], [-122.40383, 38.85581], [-122.40383, 38.8558], [-122.40339, 38.85564], [-122.40303, 38.85564], [-122.40277, 38.85567], [-122.40247, 38.85568], [-122.402, 38.85586], [-122.40174, 38.85591], [-122.4014, 38.85577], [-122.40121, 38.85547], [-122.40099, 38.85506], [-122.40086, 38.85472], [-122.40053, 38.85448], [-122.40009, 38.85431], [-122.39986, 38.85425], [-122.39967, 38.85404], [-122.39955, 38.85379], [-122.41094, 38.85388]]], [[[-122.41361, 38.86493], [-122.4059, 38.8649], [-122.40599, 38.86091], [-122.40127, 38.86083], [-122.40125, 38.86271], [-122.39731, 38.86263], [-122.4032, 38.85648], [-122.40351, 38.85657], [-122.40679, 38.85797], [-122.40702, 38.85812], [-122.40943, 38.85996], [-122.40964, 38.86008], [-122.41038, 38.86041], [-122.41067, 38.8606], [-122.4109, 38.86083], [-122.4109, 38.86098], [-122.411, 38.86098], [-122.41104, 38.86105], [-122.41215, 38.86347], [-122.41234, 38.86382], [-122.4126, 38.86414], [-122.4128, 38.86433], [-122.41303, 38.86451], [-122.41361, 38.86493]]], [[[-122.42422, 38.87573], [-122.42408, 38.87585], [-122.41522, 38.87548], [-122.41522, 38.87045], [-122.4174, 38.87051], [-122.41776, 38.87075], [-122.41802, 38.87089], [-122.42, 38.87169], [-122.42023, 38.87181], [-122.42044, 38.87195], [-122.42062, 38.87211], [-122.42078, 38.87229], [-122.42091, 38.87248], [-122.421, 38.87268], [-122.4216, 38.87421], [-122.42178, 38.87453], [-122.42203, 38.87482], [-122.42235, 38.87507], [-122.42259, 38.87521], [-122.42284, 38.87532], [-122.42311, 38.87541], [-122.42422, 38.87573]]], [[[-122.44673, 38.8798], [-122.44346, 38.87981], [-122.44345, 38.87995], [-122.44277, 38.87981], [-122.43966, 38.8804], [-122.43894, 38.88033], [-122.43696, 38.87922], [-122.43486, 38.87902], [-122.43409, 38.87868], [-122.43283, 38.8773], [-122.43267, 38.87716], [-122.43248, 38.87704], [-122.43216, 38.8769], [-122.43193, 38.87684], [-122.4317, 38.8768], [-122.43146, 38.87678], [-122.43125, 38.87679], [-122.43105, 38.87682], [-122.42927, 38.87726], [-122.42901, 38.87732], [-122.4288, 38.87734], [-122.42857, 38.87735], [-122.42823, 38.87731], [-122.42801, 38.87725], [-122.42771, 38.87711], [-122.4265, 38.87633], [-122.42616, 38.87617], [-122.42316, 38.87531], [-122.42289, 38.87522], [-122.42264, 38.8751], [-122.42241, 38.87497], [-122.42222, 38.87482], [-122.42204, 38.87465], [-122.42183, 38.87437], [-122.42173, 38.87417], [-122.42109, 38.87254], [-122.42092, 38.87226], [-122.42069, 38.872], [-122.4204, 38.87177], [-122.42007, 38.87159], [-122.41823, 38.87085], [-122.41796, 38.87073], [-122.41771, 38.87058], [-122.41748, 38.87042], [-122.41727, 38.87024], [-122.4171, 38.87004], [-122.41688, 38.86972], [-122.41623, 38.86846], [-122.41606, 38.86816], [-122.41431, 38.86544], [-122.4141, 38.86519], [-122.41381, 38.86493], [-122.41291, 38.86426], [-122.41262, 38.86397], [-122.41247, 38.86376], [-122.41228, 38.86343], [-122.41116, 38.86099], [-122.41549, 38.86112], [-122.41551, 38.85757], [-122.42008, 38.85771], [-122.42945, 38.85792], [-122.42944, 38.87069], [-122.43174, 38.87069], [-122.4321, 38.87105], [-122.43243, 38.87134], [-122.43274, 38.87195], [-122.43308, 38.87236], [-122.4334, 38.87257], [-122.43375, 38.87276], [-122.43413, 38.87264], [-122.43498, 38.87277], [-122.4339, 38.87337], [-122.4331, 38.87389], [-122.4331, 38.87391], [-122.43337, 38.87416], [-122.43348, 38.87422], [-122.4335, 38.8744], [-122.43748, 38.87427], [-122.43935, 38.87519], [-122.44673, 38.8798]]]]}	Restricted Access 2	48476	McLaughlin Natural Reserve	33195	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/mclaughlin-natural-reserve/	Lake 40	1035.449	McLaughlin Natural 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
8370	8370	8369	{"type": "MultiPolygon", "coordinates": [[[[-120.42002, 37.37524], [-120.41992, 37.3795], [-120.41983, 37.38494], [-120.41625, 37.385], [-120.41623, 37.39018], [-120.41373, 37.39018], [-120.39562, 37.39007], [-120.39556, 37.40447], [-120.39315, 37.40448], [-120.39556, 37.40457], [-120.39543, 37.41772], [-120.38974, 37.41904], [-120.38701, 37.41965], [-120.3837, 37.42025], [-120.38097, 37.42078], [-120.37846, 37.42131], [-120.37718, 37.42142], [-120.37044, 37.42207], [-120.36706, 37.4239], [-120.35097, 37.40445], [-120.35124, 37.38997], [-120.35761, 37.38306], [-120.36048, 37.38003], [-120.36471, 37.3754], [-120.3782, 37.36093], [-120.39595, 37.36105], [-120.39596, 37.35653], [-120.39623, 37.35667], [-120.3965, 37.35679], [-120.39673, 37.35684], [-120.39759, 37.35683], [-120.39798, 37.35671], [-120.39825, 37.35659], [-120.39857, 37.35628], [-120.39895, 37.35596], [-120.39937, 37.35573], [-120.39985, 37.35569], [-120.40136, 37.35636], [-120.40201, 37.3567], [-120.40275, 37.35696], [-120.40408, 37.35734], [-120.40476, 37.35756], [-120.40478, 37.35755], [-120.40478, 37.36102], [-120.40743, 37.36363], [-120.40741, 37.37544], [-120.40743, 37.37618], [-120.41232, 37.37618], [-120.41482, 37.37475], [-120.42002, 37.37524]], [[-120.37764, 37.3754], [-120.37763, 37.37539], [-120.37636, 37.3754], [-120.37763, 37.37541], [-120.37764, 37.3754]]], [[[-120.39543, 37.41789], [-120.39542, 37.41908], [-120.39049, 37.41904], [-120.39228, 37.41862], [-120.39543, 37.41789]]]]}	Restricted Access 2	48477	Merced Vernal Pools and Grassland Reserve	33191	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/merced-vernal-pools-and-grassland-reserve/	Merced 37	6559.831	Merced Vernal Pools and Grassland Reserve	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]);