units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where COUNTY = 29 and MNG_AGENCY = 25
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, YR_EST
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 402 | 402 | 401 | {"type": "Polygon", "coordinates": [[[-118.76991, 36.21538], [-118.76991, 36.21538], [-118.76726, 36.21538], [-118.76735, 36.21517], [-118.76842, 36.21452], [-118.76948, 36.21436], [-118.76989, 36.21437], [-118.76991, 36.21538]]]} | Restricted Access 2 | 1556 | Springville Ecological Reserve | 25751 | 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 | Tulare 29 | 4.947 | Springville ER | 0 | 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 | |
| 6188 | 6188 | 6187 | {"type": "Polygon", "coordinates": [[[-118.81911, 36.36224], [-118.81837, 36.36643], [-118.81325, 36.3665], [-118.81331, 36.3666], [-118.81367, 36.3667], [-118.8139, 36.36703], [-118.80688, 36.3671], [-118.80404, 36.36685], [-118.80466, 36.36608], [-118.80756, 36.36631], [-118.81069, 36.36259], [-118.8113, 36.36337], [-118.81146, 36.36387], [-118.81161, 36.36413], [-118.81196, 36.36425], [-118.81237, 36.36429], [-118.81278, 36.36423], [-118.81313, 36.36425], [-118.81339, 36.3643], [-118.8143, 36.36459], [-118.81486, 36.36464], [-118.81543, 36.36452], [-118.81601, 36.36424], [-118.81643, 36.3637], [-118.81693, 36.36319], [-118.81792, 36.36255], [-118.81911, 36.36224]]]} | Restricted Access 2 | 1503 | Kaweah Ecological Reserve | 20561 | 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 | Tulare 29 | 83.672 | Kaweah ER | 0 | State Conservation Area 8 | 2 | |
| 6316 | 6316 | 6315 | {"type": "MultiPolygon", "coordinates": [[[[-118.8669, 36.28058], [-118.85857, 36.28042], [-118.85009, 36.28028], [-118.85005, 36.26722], [-118.86682, 36.26716], [-118.8669, 36.28058]]], [[[-118.87852, 36.33542], [-118.8742, 36.3354], [-118.87424, 36.34262], [-118.86989, 36.34266], [-118.85062, 36.34313], [-118.85055, 36.32735], [-118.86987, 36.32809], [-118.87846, 36.32824], [-118.87852, 36.33542]]]]} | Restricted Access 2 | 1493 | Blue Ridge Ecological Reserve | 16186 | 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 | Tulare 29 | 1499.176 | Blue Ridge ER | 0 | State Conservation Area 8 | 2 | |
| 6319 | 6319 | 6318 | {"type": "Polygon", "coordinates": [[[-118.18296, 36.22846], [-118.16483, 36.22841], [-118.16479, 36.22463], [-118.16933, 36.22468], [-118.16929, 36.22093], [-118.17821, 36.22119], [-118.17834, 36.22475], [-118.18287, 36.22484], [-118.18296, 36.22846]]]} | Open Access 1 | 1516 | Monache Meadows Wildlife Area | 30474 | 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/Monache-Meadows-WA | Tulare 29 | 246.531 | Monache Meadows Wildlife Area | 1994 | State Conservation Area 8 | 2 |
| 7219 | 7219 | 7218 | {"type": "MultiPolygon", "coordinates": [[[[-119.24372, 36.49341], [-119.2362, 36.49332], [-119.23261, 36.49006], [-119.23258, 36.48608], [-119.24154, 36.48618], [-119.24157, 36.48972], [-119.2437, 36.48975], [-119.24372, 36.49341]]], [[[-119.25039, 36.47193], [-119.25018, 36.47903], [-119.24135, 36.47895], [-119.24123, 36.48602], [-119.23668, 36.48598], [-119.23684, 36.47896], [-119.24135, 36.47895], [-119.24148, 36.47188], [-119.25039, 36.47193]]], [[[-119.25525, 36.46979], [-119.2552, 36.47183], [-119.25223, 36.47177], [-119.2523, 36.46976], [-119.25525, 36.46979]]], [[[-119.26888, 36.44301], [-119.26887, 36.45019], [-119.26439, 36.45013], [-119.26443, 36.44306], [-119.26888, 36.44301]]], [[[-119.31376, 36.42893], [-119.31339, 36.45065], [-119.30455, 36.45046], [-119.30468, 36.44713], [-119.29574, 36.44702], [-119.29572, 36.44658], [-119.2989, 36.44658], [-119.29894, 36.44502], [-119.29632, 36.44418], [-119.29568, 36.44342], [-119.29573, 36.44314], [-119.30463, 36.44328], [-119.30492, 36.42878], [-119.30523, 36.42879], [-119.30522, 36.43119], [-119.30946, 36.43125], [-119.31358, 36.43136], [-119.31359, 36.43135], [-119.31355, 36.42887], [-119.31376, 36.42893]]]]} | Open Access 1 | 1565 | Stone Corral Ecological Reserve | 32320 | 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/Stone-Corral-ER | Tulare 29 | 980.195 | Stone Corral ER | 1995 | State Conservation Area 8 | 2 |
| 15561 | 15561 | 15560 | {"type": "MultiPolygon", "coordinates": [[[[-119.38413, 35.8048], [-119.3753, 35.80482], [-119.36412, 35.80476], [-119.36409, 35.80114], [-119.35934, 35.80113], [-119.35733, 35.79533], [-119.35563, 35.79034], [-119.36397, 35.79031], [-119.364, 35.79391], [-119.36624, 35.79391], [-119.36626, 35.79698], [-119.36404, 35.79698], [-119.36407, 35.79934], [-119.3663, 35.79934], [-119.36631, 35.79933], [-119.36628, 35.79753], [-119.36927, 35.79753], [-119.36919, 35.79029], [-119.37513, 35.79028], [-119.384, 35.79021], [-119.38401, 35.79205], [-119.38405, 35.79385], [-119.38405, 35.79567], [-119.38409, 35.8011], [-119.38413, 35.8048]], [[-119.3618, 35.79842], [-119.3618, 35.79753], [-119.35957, 35.79755], [-119.35959, 35.79842], [-119.3618, 35.79842]]], [[[-119.35871, 35.80113], [-119.3574, 35.80113], [-119.35744, 35.80472], [-119.33954, 35.80475], [-119.3394, 35.79039], [-119.35501, 35.79035], [-119.35736, 35.79719], [-119.35737, 35.79752], [-119.35748, 35.79753], [-119.35871, 35.80113]]], [[[-119.3307, 35.83603], [-119.33069, 35.83748], [-119.32849, 35.8375], [-119.32849, 35.83786], [-119.32959, 35.83785], [-119.3296, 35.83821], [-119.33069, 35.83821], [-119.33069, 35.83857], [-119.32959, 35.83858], [-119.32959, 35.83821], [-119.32739, 35.83823], [-119.32738, 35.83859], [-119.32848, 35.83858], [-119.32848, 35.83894], [-119.32627, 35.83896], [-119.32627, 35.83751], [-119.32188, 35.83753], [-119.32188, 35.83717], [-119.32403, 35.83716], [-119.32404, 35.8368], [-119.32403, 35.83679], [-119.32189, 35.83681], [-119.3219, 35.83573], [-119.32181, 35.83572], [-119.32183, 35.8339], [-119.32406, 35.83389], [-119.32407, 35.83396], [-119.32851, 35.83394], [-119.3285, 35.83532], [-119.3274, 35.83533], [-119.3274, 35.83568], [-119.3285, 35.83568], [-119.32851, 35.83604], [-119.3307, 35.83603]], [[-119.32959, 35.83713], [-119.32959, 35.83676], [-119.32739, 35.83678], [-119.32739, 35.83714], [-119.32959, 35.83713]], [[-119.32404, 35.83678], [-119.32405, 35.83679], [-119.32627, 35.83678], [-119.32628, 35.83643], [-119.32405, 35.83643], [-119.32404, 35.83678]], [[-119.32404, 35.83607], [-119.32404, 35.83571], [-119.32292, 35.83572], [-119.32292, 35.83607], [-119.32404, 35.83607]], [[-119.32515, 35.83515], [-119.32515, 35.83497], [-119.32406, 35.83499], [-119.32406, 35.83516], [-119.32515, 35.83515]]], [[[-119.33069, 35.8393], [-119.32959, 35.8393], [-119.32959, 35.83894], [-119.33069, 35.83893], [-119.33069, 35.8393]]], [[[-119.33068, 35.83966], [-119.33067, 35.84166], [-119.32993, 35.84167], [-119.32993, 35.84111], [-119.32626, 35.84113], [-119.32626, 35.84041], [-119.32737, 35.84039], [-119.32737, 35.84004], [-119.32739, 35.83968], [-119.32738, 35.83932], [-119.32848, 35.8393], [-119.32849, 35.83967], [-119.33068, 35.83966]], [[-119.32847, 35.8404], [-119.32737, 35.8404], [-119.32737, 35.84076], [-119.32847, 35.84075], [-119.32847, 35.8404]]], [[[-119.33067, 35.84275], [-119.32993, 35.84276], [-119.32993, 35.84331], [-119.32919, 35.84332], [-119.3292, 35.84223], [-119.33066, 35.84222], [-119.33067, 35.84275]]], [[[-119.33557, 35.84798], [-119.33557, 35.84824], [-119.33449, 35.84824], [-119.33449, 35.84768], [-119.33523, 35.84767], [-119.33523, 35.84796], [-119.33557, 35.84798]]], [[[-119.33155, 35.8477], [-119.33155, 35.84826], [-119.33081, 35.84826], [-119.33081, 35.84771], [-119.33155, 35.8477]]], [[[-119.33066, 35.8444], [-119.33065, 35.84551], [-119.32992, 35.84551], [-119.32991, 35.84603], [-119.32992, 35.84604], [-119.33065, 35.84604], [-119.33064, 35.84716], [-119.32991, 35.84715], [-119.32991, 35.8466], [-119.32844, 35.84662], [-119.32844, 35.84714], [-119.32917, 35.84715], [-119.32918, 35.8477], [-119.3299, 35.8477], [-119.3299, 35.84827], [-119.32917, 35.84829], [-119.32917, 35.8477], [-119.32844, 35.8477], [-119.32843, 35.84797], [-119.3277, 35.848], [-119.32769, 35.84831], [-119.32549, 35.84833], [-119.32548, 35.84834], [-119.3218, 35.84837], [-119.32181, 35.84667], [-119.32254, 35.84666], [-119.32255, 35.84611], [-119.32254, 35.84557], [-119.32183, 35.84555], [-119.32182, 35.84502], [-119.32256, 35.84502], [-119.32255, 35.84556], [-119.32329, 35.84557], [-119.3233, 35.8461], [-119.32476, 35.84609], [-119.32477, 35.84444], [-119.32404, 35.84445], [-119.32403, 35.845], [-119.32329, 35.84501], [-119.3233, 35.84389], [-119.32477, 35.84389], [-119.32478, 35.84336], [-119.32404, 35.84335], [-119.32404, 35.8428], [-119.32184, 35.84281], [-119.32184, 35.84228], [-119.32626, 35.84225], [-119.32626, 35.84278], [-119.32739, 35.84278], [-119.32739, 35.84333], [-119.32846, 35.84332], [-119.32845, 35.84388], [-119.32772, 35.84388], [-119.32772, 35.84442], [-119.33066, 35.8444]], [[-119.32845, 35.84606], [-119.32697, 35.84607], [-119.32697, 35.84662], [-119.32843, 35.84661], [-119.32844, 35.84635], [-119.32918, 35.84634], [-119.32916, 35.84605], [-119.32845, 35.84606]], [[-119.32622, 35.84608], [-119.32624, 35.84499], [-119.32551, 35.845], [-119.3255, 35.84608], [-119.32622, 35.84608]], [[-119.32624, 35.84443], [-119.32697, 35.84442], [-119.32698, 35.84389], [-119.32478, 35.8439], [-119.32478, 35.84444], [-119.32624, 35.84443]]], [[[-119.35312, 35.85183], [-119.34419, 35.85187], [-119.34416, 35.85006], [-119.34638, 35.85005], [-119.34635, 35.84826], [-119.34412, 35.84827], [-119.33974, 35.84826], [-119.33973, 35.84104], [-119.33892, 35.84106], [-119.33893, 35.8416], [-119.33965, 35.8416], [-119.33965, 35.84491], [-119.33892, 35.84491], [-119.33891, 35.84433], [-119.33818, 35.84435], [-119.33818, 35.84491], [-119.3382, 35.84545], [-119.33965, 35.84544], [-119.33965, 35.84708], [-119.33746, 35.8471], [-119.33745, 35.84766], [-119.33597, 35.84767], [-119.33596, 35.84711], [-119.3367, 35.8471], [-119.33671, 35.84654], [-119.33597, 35.84655], [-119.33597, 35.84629], [-119.33524, 35.84629], [-119.33523, 35.84656], [-119.33229, 35.84659], [-119.33229, 35.84714], [-119.33083, 35.84715], [-119.33081, 35.8466], [-119.33082, 35.84604], [-119.33228, 35.84603], [-119.3323, 35.8455], [-119.33229, 35.84549], [-119.33082, 35.8455], [-119.33083, 35.84328], [-119.33156, 35.84329], [-119.33157, 35.84328], [-119.33157, 35.84222], [-119.33084, 35.84222], [-119.33084, 35.84166], [-119.33157, 35.84166], [-119.33157, 35.84221], [-119.33231, 35.84221], [-119.3323, 35.84274], [-119.33303, 35.84273], [-119.33304, 35.84382], [-119.33377, 35.84383], [-119.33378, 35.84273], [-119.33451, 35.84272], [-119.33452, 35.84328], [-119.33524, 35.84327], [-119.33525, 35.84436], [-119.33597, 35.84435], [-119.33598, 35.84272], [-119.33597, 35.84271], [-119.33525, 35.84271], [-119.33524, 35.84219], [-119.33304, 35.8422], [-119.33304, 35.84109], [-119.33076, 35.84111], [-119.3308, 35.83386], [-119.33975, 35.83382], [-119.33974, 35.84104], [-119.35187, 35.84098], [-119.35186, 35.84822], [-119.34862, 35.84824], [-119.34864, 35.85004], [-119.35309, 35.85002], [-119.35312, 35.85183]], [[-119.33745, 35.8427], [-119.33745, 35.84106], [-119.33599, 35.84107], [-119.33598, 35.84162], [-119.33525, 35.84164], [-119.33525, 35.84218], [-119.33598, 35.84218], [-119.33598, 35.84271], [-119.33671, 35.8427], [-119.33672, 35.84325], [-119.33818, 35.84325], [-119.33818, 35.8427], [-119.33745, 35.8427]], [[-119.33743, 35.84434], [-119.33744, 35.84379], [-119.33671, 35.84383], [-119.33672, 35.84435], [-119.33743, 35.84434]], [[-119.3323, 35.8444], [-119.33229, 35.84439], [-119.33157, 35.84439], [-119.33157, 35.84494], [-119.33229, 35.84493], [-119.3323, 35.8444]], [[-119.33745, 35.84492], [-119.33671, 35.84491], [-119.33671, 35.84546], [-119.33744, 35.84546], [-119.33745, 35.84492]], [[-119.3345, 35.84493], [-119.33449, 35.84492], [-119.33377, 35.84493], [-119.33377, 35.84548], [-119.33449, 35.84548], [-119.3345, 35.84493]]], [[[-119.35099, 35.85726], [-119.34875, 35.85728], [-119.3487, 35.85366], [-119.35093, 35.85365], [-119.35099, 35.85726]]], [[[-119.37987, 35.8624], [-119.35778, 35.86261], [-119.35772, 35.85902], [-119.35549, 35.85904], [-119.35548, 35.85813], [-119.35548, 35.85768], [-119.35533, 35.85181], [-119.35757, 35.85181], [-119.3576, 35.85306], [-119.37527, 35.85281], [-119.37519, 35.84938], [-119.37548, 35.85015], [-119.37556, 35.85042], [-119.37593, 35.85125], [-119.37633, 35.85205], [-119.37679, 35.85283], [-119.37712, 35.85334], [-119.37748, 35.85384], [-119.37978, 35.85681], [-119.37987, 35.8624]]], [[[-119.34883, 35.86269], [-119.322, 35.86295], [-119.32208, 35.87009], [-119.32658, 35.8701], [-119.32659, 35.87192], [-119.32209, 35.87194], [-119.32214, 35.87735], [-119.32205, 35.87735], [-119.32203, 35.8846], [-119.30377, 35.88459], [-119.30389, 35.87733], [-119.29484, 35.87732], [-119.29479, 35.87003], [-119.30381, 35.87004], [-119.30365, 35.85561], [-119.3125, 35.85566], [-119.3126, 35.85565], [-119.31248, 35.84838], [-119.30356, 35.84832], [-119.30361, 35.84108], [-119.32177, 35.84116], [-119.32171, 35.84843], [-119.33063, 35.84835], [-119.33081, 35.85745], [-119.3398, 35.85736], [-119.33983, 35.86099], [-119.34881, 35.86089], [-119.34883, 35.86269]]], [[[-119.32058, 35.89192], [-119.32058, 35.89269], [-119.32003, 35.89269], [-119.32003, 35.89192], [-119.32058, 35.89192]]], [[[-119.32766, 35.89362], [-119.32766, 35.89451], [-119.32654, 35.89451], [-119.32654, 35.89362], [-119.32766, 35.89362]]], [[[-119.31553, 35.8945], [-119.31553, 35.89541], [-119.31496, 35.89541], [-119.31497, 35.8945], [-119.31553, 35.8945]]], [[[-119.32208, 35.8954], [-119.32208, 35.89586], [-119.32115, 35.89586], [-119.32114, 35.89631], [-119.32058, 35.89631], [-119.32058, 35.8954], [-119.32208, 35.8954]]], [[[-119.32002, 35.89631], [-119.3189, 35.89631], [-119.3189, 35.89451], [-119.31833, 35.8945], [-119.31833, 35.89359], [-119.31891, 35.89359], [-119.3189, 35.89449], [-119.31946, 35.8945], [-119.31946, 35.8954], [-119.32001, 35.8954], [-119.32002, 35.89631]]], [[[-119.32208, 35.89722], [-119.32208, 35.89767], [-119.32114, 35.89767], [-119.32114, 35.89722], [-119.32208, 35.89722]]], [[[-119.3189, 35.89722], [-119.31889, 35.89812], [-119.31832, 35.89812], [-119.31833, 35.89722], [-119.3189, 35.89722]]], [[[-119.31607, 35.89813], [-119.31607, 35.89902], [-119.31551, 35.89902], [-119.31551, 35.89813], [-119.31607, 35.89813]]], [[[-119.3144, 35.89541], [-119.31439, 35.89813], [-119.31383, 35.89813], [-119.31382, 35.89902], [-119.31269, 35.89902], [-119.31271, 35.89632], [-119.31327, 35.89631], [-119.31328, 35.89541], [-119.3144, 35.89541]], [[-119.31382, 35.89813], [-119.31383, 35.89723], [-119.31327, 35.89722], [-119.31326, 35.89812], [-119.31382, 35.89813]]]]} | Open Access 1 | 1488 | Allensworth Ecological Reserve | 32015 | 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/Allensworth-ER | Tulare 29 | 5187.226 | Allensworth ER | 1983 | 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]);