units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where AGNCY_TYP = 1 and COUNTY = 41
This data as json, copyable, CSV (advanced)
Suggested facets: LABEL_NAME
MNG_AGENCY 6
DES_TP 6
ACCESS_TYP 3
MNG_AG_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3154 | 3154 | 3153 | {"type": "Polygon", "coordinates": [[[-121.66267, 38.17881], [-121.66233, 38.1796], [-121.66183, 38.18015], [-121.66057, 38.18049], [-121.6572, 38.18162], [-121.65543, 38.18198], [-121.65393, 38.18244], [-121.65201, 38.1828], [-121.64803, 38.18428], [-121.64712, 38.17403], [-121.65009, 38.17464], [-121.65383, 38.17571], [-121.65488, 38.1762], [-121.6556, 38.17642], [-121.65777, 38.17653], [-121.6602, 38.17778], [-121.6615, 38.17807], [-121.66216, 38.1784], [-121.66267, 38.17881]]]} | Open Access 1 | 21759 | Delta Protection | 18074 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Sacramento 41 | 214.905 | Delta Protection | 0 | Federal Other or Unknown 87 | 4 | ||
3589 | 3589 | 3588 | {"type": "Polygon", "coordinates": [[[-121.4409, 38.26568], [-121.4405, 38.26654], [-121.43893, 38.26623], [-121.43872, 38.26566], [-121.43905, 38.26515], [-121.43899, 38.26457], [-121.44061, 38.26555], [-121.4409, 38.26568]]]} | Restricted Access 2 | 29176 | Cosumnes River Ecological Reserve | 17675 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cosumnes-River-ER | Sacramento 41 | 5.742 | Cosumnes River ER | 2003 | State Conservation Area 8 | 2 |
3683 | 3683 | 3682 | {"type": "Polygon", "coordinates": [[[-121.5054, 38.33521], [-121.50491, 38.33521], [-121.50369, 38.32789], [-121.50242, 38.32788], [-121.5012, 38.32057], [-121.50296, 38.32058], [-121.5054, 38.33521]]]} | Open Access 1 | 44405 | Sun River Project | 25977 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Sacramento 41 | 39.49 | Sun River Project | None 308 | |||
11190 | 11190 | 11189 | {"type": "MultiPolygon", "coordinates": [[[[-121.40216, 38.2541], [-121.40126, 38.25502], [-121.40116, 38.25575], [-121.40069, 38.25609], [-121.3998, 38.25771], [-121.39915, 38.25819], [-121.39865, 38.25957], [-121.39866, 38.26069], [-121.39827, 38.26167], [-121.39776, 38.2621], [-121.38884, 38.26208], [-121.38883, 38.26162], [-121.38448, 38.26161], [-121.38449, 38.25917], [-121.38527, 38.25893], [-121.38612, 38.25886], [-121.38745, 38.25829], [-121.38815, 38.25765], [-121.38989, 38.25736], [-121.39053, 38.25736], [-121.3912, 38.25765], [-121.39282, 38.25793], [-121.39308, 38.25788], [-121.39308, 38.25765], [-121.39282, 38.25733], [-121.3905, 38.25651], [-121.38971, 38.25633], [-121.3894, 38.25639], [-121.3889, 38.25681], [-121.38841, 38.25699], [-121.38765, 38.25708], [-121.38738, 38.25722], [-121.38739, 38.25646], [-121.38958, 38.25602], [-121.38959, 38.25578], [-121.38863, 38.2534], [-121.38868, 38.2534], [-121.38887, 38.25353], [-121.38971, 38.25353], [-121.39006, 38.2536], [-121.3905, 38.25363], [-121.39077, 38.25374], [-121.39143, 38.25395], [-121.39239, 38.25411], [-121.39325, 38.25386], [-121.39395, 38.25371], [-121.39523, 38.25349], [-121.39524, 38.25348], [-121.39464, 38.2514], [-121.39716, 38.25142], [-121.40076, 38.25368], [-121.40216, 38.2541]]], [[[-121.43885, 38.2758], [-121.42582, 38.27583], [-121.42579, 38.26864], [-121.42183, 38.26861], [-121.4211, 38.26875], [-121.42111, 38.26869], [-121.4208, 38.26844], [-121.42068, 38.26794], [-121.42065, 38.26748], [-121.42074, 38.26732], [-121.42117, 38.26716], [-121.42123, 38.267], [-121.41981, 38.2667], [-121.4197, 38.26661], [-121.41978, 38.26629], [-121.4199, 38.26618], [-121.42053, 38.26606], [-121.42059, 38.26595], [-121.42039, 38.26572], [-121.41993, 38.2656], [-121.41975, 38.26549], [-121.41973, 38.26515], [-121.41984, 38.26491], [-121.41981, 38.26391], [-121.42016, 38.2632], [-121.42022, 38.26286], [-121.42002, 38.2626], [-121.42004, 38.26219], [-121.42199, 38.26167], [-121.4221, 38.26176], [-121.42217, 38.26217], [-121.42237, 38.26226], [-121.42263, 38.2622], [-121.42286, 38.26178], [-121.42286, 38.26155], [-121.42228, 38.26121], [-121.42245, 38.26103], [-121.42356, 38.2608], [-121.4242, 38.26048], [-121.4244, 38.26068], [-121.42446, 38.26133], [-121.42491, 38.26134], [-121.42481, 38.26014], [-121.42471, 38.26004], [-121.42541, 38.26004], [-121.42533, 38.26134], [-121.42415, 38.26368], [-121.42502, 38.26479], [-121.42578, 38.2663], [-121.42579, 38.26863], [-121.42926, 38.26865], [-121.42942, 38.27299], [-121.43357, 38.27302], [-121.43363, 38.26943], [-121.43453, 38.26943], [-121.43437, 38.26969], [-121.43427, 38.27002], [-121.43427, 38.27018], [-121.43428, 38.27024], [-121.43435, 38.27034], [-121.4344, 38.27039], [-121.43453, 38.27047], [-121.43466, 38.27052], [-121.4349, 38.27054], [-121.43511, 38.27053], [-121.43528, 38.27049], [-121.43552, 38.27038], [-121.43581, 38.27022], [-121.43605, 38.27006], [-121.43619, 38.26994], [-121.43667, 38.26944], [-121.43707, 38.26944], [-121.4382, 38.27258], [-121.4384, 38.27321], [-121.43856, 38.27385], [-121.43865, 38.27427], [-121.43874, 38.27489], [-121.43885, 38.2758]]], [[[-121.43942, 38.28138], [-121.43684, 38.28205], [-121.43527, 38.28275], [-121.43333, 38.28271], [-121.43176, 38.28299], [-121.42897, 38.2828], [-121.41985, 38.28275], [-121.4198, 38.27601], [-121.43887, 38.27596], [-121.43905, 38.27755], [-121.43898, 38.27757], [-121.43917, 38.27919], [-121.43925, 38.27919], [-121.4394, 38.28055], [-121.43933, 38.28057], [-121.43942, 38.28138]]], [[[-121.45645, 38.2843], [-121.44742, 38.28424], [-121.4474, 38.28046], [-121.4453, 38.27972], [-121.44396, 38.28036], [-121.44049, 38.28156], [-121.44005, 38.28144], [-121.43987, 38.27976], [-121.43927, 38.27464], [-121.43916, 38.27399], [-121.43906, 38.27355], [-121.43894, 38.27309], [-121.43867, 38.27217], [-121.43862, 38.2719], [-121.43861, 38.27152], [-121.43867, 38.27108], [-121.43873, 38.27087], [-121.43883, 38.2706], [-121.44011, 38.26786], [-121.44049, 38.26766], [-121.44058, 38.26759], [-121.44081, 38.26731], [-121.44106, 38.26695], [-121.44118, 38.26672], [-121.4413, 38.26638], [-121.4416, 38.2654], [-121.44165, 38.2651], [-121.44166, 38.26494], [-121.44163, 38.26463], [-121.44155, 38.26425], [-121.44145, 38.26394], [-121.44129, 38.26355], [-121.44349, 38.26372], [-121.44468, 38.26306], [-121.44976, 38.2654], [-121.45098, 38.26503], [-121.45122, 38.26501], [-121.45539, 38.27586], [-121.45569, 38.27669], [-121.45589, 38.27735], [-121.45613, 38.27834], [-121.457, 38.28251], [-121.457, 38.2827], [-121.45699, 38.28298], [-121.45694, 38.28325], [-121.45688, 38.28347], [-121.45671, 38.28389], [-121.45659, 38.28409], [-121.45645, 38.2843]], [[-121.45258, 38.27746], [-121.45242, 38.27745], [-121.45201, 38.27789], [-121.45167, 38.27799], [-121.45129, 38.27815], [-121.45102, 38.27824], [-121.45068, 38.27824], [-121.45022, 38.2782], [-121.45007, 38.27822], [-121.45009, 38.27839], [-121.45002, 38.27852], [-121.44972, 38.27859], [-121.44958, 38.27858], [-121.44936, 38.27865], [-121.44874, 38.27878], [-121.44845, 38.27896], [-121.4483, 38.27916], [-121.44812, 38.27937], [-121.44786, 38.27945], [-121.44776, 38.27968], [-121.44763, 38.27985], [-121.44746, 38.27994], [-121.4474, 38.27996], [-121.44741, 38.28045], [-121.44747, 38.28046], [-121.44785, 38.28038], [-121.44812, 38.28022], [-121.44822, 38.28005], [-121.44839, 38.27991], [-121.44898, 38.27929], [-121.44935, 38.27898], [-121.44969, 38.27885], [-121.45014, 38.27879], [-121.4508, 38.27876], [-121.45162, 38.27865], [-121.45234, 38.27846], [-121.45327, 38.27806], [-121.45351, 38.27786], [-121.45371, 38.27763], [-121.45381, 38.27725], [-121.4539, 38.27703], [-121.45316, 38.27701], [-121.45307, 38.27714], [-121.45273, 38.27734], [-121.45258, 38.27746]]]]} | No Public Access 3 | 21461 | BLM | 16161 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Sacramento 41 | 1450.517 | BLM | 0 | National Public Lands 1 | 3 | |
11273 | 11273 | 11272 | {"type": "Polygon", "coordinates": [[[-121.47577, 38.46692], [-121.47575, 38.47575], [-121.47456, 38.47572], [-121.47455, 38.47575], [-121.47313, 38.47576], [-121.47314, 38.48009], [-121.47415, 38.48009], [-121.47416, 38.48135], [-121.47101, 38.48135], [-121.47101, 38.47516], [-121.46887, 38.47515], [-121.46888, 38.47237], [-121.46923, 38.47236], [-121.46925, 38.47036], [-121.4692, 38.47035], [-121.46888, 38.47039], [-121.46888, 38.46696], [-121.46891, 38.46695], [-121.46888, 38.46693], [-121.47577, 38.46692]]]} | Open Access 1 | 21779 | United States Of America | 26669 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Sacramento 41 | 172.155 | United States Of America | 0 | Federal Other or Unknown 87 | 4 | ||
11423 | 11423 | 11422 | {"type": "MultiPolygon", "coordinates": [[[[-121.30305, 38.54735], [-121.30211, 38.5479], [-121.30127, 38.54837], [-121.2953, 38.55181], [-121.29482, 38.55207], [-121.29427, 38.55231], [-121.2937, 38.5525], [-121.29335, 38.5526], [-121.29265, 38.55275], [-121.29246, 38.55278], [-121.29003, 38.5528], [-121.28957, 38.55274], [-121.28897, 38.55261], [-121.28836, 38.55242], [-121.28791, 38.55226], [-121.28551, 38.5512], [-121.28518, 38.55109], [-121.28486, 38.55102], [-121.28379, 38.55086], [-121.28308, 38.55082], [-121.28265, 38.55083], [-121.28259, 38.54964], [-121.28298, 38.54965], [-121.28397, 38.54949], [-121.28537, 38.54886], [-121.28599, 38.54831], [-121.28692, 38.54751], [-121.28713, 38.54683], [-121.28788, 38.54565], [-121.28812, 38.54522], [-121.28839, 38.54526], [-121.28848, 38.54518], [-121.29005, 38.54547], [-121.29024, 38.54486], [-121.29018, 38.54435], [-121.28998, 38.54383], [-121.28964, 38.54334], [-121.28791, 38.54363], [-121.28759, 38.54403], [-121.28589, 38.54301], [-121.28583, 38.54294], [-121.28639, 38.54202], [-121.28574, 38.54162], [-121.28514, 38.54238], [-121.28501, 38.54227], [-121.28488, 38.54207], [-121.28543, 38.54142], [-121.28547, 38.54098], [-121.28481, 38.54044], [-121.28397, 38.54], [-121.28293, 38.54004], [-121.28244, 38.54027], [-121.28118, 38.53964], [-121.28064, 38.53961], [-121.27946, 38.54002], [-121.27897, 38.54049], [-121.27866, 38.54086], [-121.2783, 38.54113], [-121.27786, 38.54135], [-121.27631, 38.54189], [-121.2764, 38.54203], [-121.27556, 38.54252], [-121.27453, 38.54244], [-121.27376, 38.54246], [-121.27307, 38.54332], [-121.27282, 38.54358], [-121.27375, 38.54468], [-121.27278, 38.54507], [-121.27227, 38.54435], [-121.27224, 38.54368], [-121.27233, 38.54302], [-121.27252, 38.54256], [-121.27246, 38.54215], [-121.27209, 38.54127], [-121.27177, 38.54079], [-121.27132, 38.5405], [-121.27142, 38.5403], [-121.27227, 38.54066], [-121.27301, 38.5409], [-121.27377, 38.54112], [-121.27493, 38.54155], [-121.27598, 38.54132], [-121.27663, 38.54074], [-121.2757, 38.53913], [-121.27535, 38.53918], [-121.27453, 38.53879], [-121.2726, 38.53884], [-121.27114, 38.53948], [-121.27019, 38.54032], [-121.26992, 38.54086], [-121.26982, 38.54135], [-121.26894, 38.54175], [-121.26856, 38.54449], [-121.2689, 38.54555], [-121.26937, 38.54647], [-121.26788, 38.54711], [-121.26917, 38.54757], [-121.26919, 38.54759], [-121.26923, 38.54765], [-121.2689, 38.54865], [-121.2688, 38.54869], [-121.26872, 38.54877], [-121.26856, 38.54887], [-121.26839, 38.54894], [-121.26831, 38.549], [-121.26706, 38.54949], [-121.26703, 38.54956], [-121.2661, 38.54997], [-121.26584, 38.54992], [-121.26464, 38.54933], [-121.26446, 38.54912], [-121.2637, 38.54838], [-121.26341, 38.54821], [-121.26297, 38.54721], [-121.26298, 38.54713], [-121.26297, 38.54709], [-121.26302, 38.54687], [-121.26313, 38.54672], [-121.26313, 38.5467], [-121.26121, 38.54672], [-121.2612, 38.54482], [-121.26109, 38.54475], [-121.26111, 38.53501], [-121.26859, 38.53502], [-121.26859, 38.53527], [-121.28764, 38.5349], [-121.29213, 38.53601], [-121.2884, 38.53879], [-121.28755, 38.53809], [-121.28787, 38.53781], [-121.28787, 38.53779], [-121.28664, 38.53694], [-121.2863, 38.53673], [-121.28504, 38.53627], [-121.28387, 38.53604], [-121.28242, 38.53602], [-121.28172, 38.5361], [-121.28183, 38.53748], [-121.28205, 38.5376], [-121.28355, 38.53763], [-121.28389, 38.53766], [-121.28467, 38.53784], [-121.28628, 38.5387], [-121.28665, 38.5387], [-121.28746, 38.53816], [-121.28831, 38.53886], [-121.28745, 38.53963], [-121.28745, 38.53965], [-121.30255, 38.53981], [-121.30254, 38.54027], [-121.29962, 38.54163], [-121.30305, 38.54735]]], [[[-121.27303, 38.54697], [-121.27298, 38.54745], [-121.27276, 38.5477], [-121.27231, 38.54795], [-121.27189, 38.54805], [-121.27153, 38.54807], [-121.27114, 38.54797], [-121.27069, 38.5477], [-121.27032, 38.54743], [-121.27016, 38.54712], [-121.27014, 38.54691], [-121.27016, 38.54678], [-121.27086, 38.54634], [-121.27185, 38.54597], [-121.27209, 38.54611], [-121.27236, 38.54639], [-121.27303, 38.54697]]]]} | Restricted Access 2 | 22251 | Mather | 21950 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Sacramento 41 | 927.044 | Mather | 0 | Federal Other or Unknown 87 | 4 | ||
11425 | 11425 | 11424 | {"type": "MultiPolygon", "coordinates": [[[[-121.3675, 38.67299], [-121.36388, 38.67606], [-121.36391, 38.67519], [-121.36103, 38.6752], [-121.36093, 38.67293], [-121.3675, 38.67299]]], [[[-121.38686, 38.71035], [-121.38621, 38.71061], [-121.38139, 38.71218], [-121.3813, 38.71244], [-121.38071, 38.71244], [-121.38078, 38.71216], [-121.38077, 38.71215], [-121.37652, 38.71218], [-121.37402, 38.71051], [-121.37491, 38.70982], [-121.37505, 38.70977], [-121.37599, 38.70985], [-121.37658, 38.71005], [-121.37976, 38.71], [-121.38052, 38.71011], [-121.38227, 38.71018], [-121.38356, 38.71001], [-121.38466, 38.70975], [-121.38501, 38.70956], [-121.38548, 38.70963], [-121.38581, 38.70997], [-121.38634, 38.71026], [-121.38686, 38.71035]]]]} | No Public Access 3 | 22268 | Other Federal | 23247 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Sacramento 41 | 79.009 | Other Federal | 0 | Federal Other or Unknown 87 | 4 | ||
13966 | 13966 | 13965 | {"type": "Polygon", "coordinates": [[[-121.48188, 38.33873], [-121.47585, 38.33896], [-121.47579, 38.33592], [-121.48187, 38.33587], [-121.48188, 38.33873]]]} | No Public Access 3 | 37013 | BLM | 16161 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Sacramento 41 | 42.907 | BLM | 0 | National Public Lands 1 | 3 | |
13996 | 13996 | 13995 | {"type": "Polygon", "coordinates": [[[-121.25323, 38.55936], [-121.2475, 38.55947], [-121.24737, 38.55661], [-121.24799, 38.55691], [-121.24868, 38.55735], [-121.24949, 38.55796], [-121.24999, 38.55811], [-121.25026, 38.55828], [-121.2505, 38.5584], [-121.25086, 38.55851], [-121.25148, 38.55861], [-121.2527, 38.55892], [-121.25299, 38.55896], [-121.25311, 38.559], [-121.25319, 38.55919], [-121.25323, 38.55936]]]} | Open Access 1 | 37011 | BLM | 16162 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Sacramento 41 | 18.301 | BLM | 1899 | National Public Lands 1 | 3 | |
14010 | 14010 | 14009 | {"type": "MultiPolygon", "coordinates": [[[[-121.16971, 38.68968], [-121.16956, 38.68978], [-121.16947, 38.69003], [-121.16953, 38.69019], [-121.16953, 38.69051], [-121.16963, 38.69076], [-121.16946, 38.69103], [-121.16939, 38.69126], [-121.16939, 38.69191], [-121.16934, 38.69192], [-121.16934, 38.69204], [-121.16816, 38.692], [-121.16732, 38.69206], [-121.16968, 38.68799], [-121.16971, 38.68968]]], [[[-121.17481, 38.68485], [-121.17481, 38.68485], [-121.17297, 38.68484], [-121.17407, 38.68395], [-121.17479, 38.68369], [-121.17481, 38.68485]]]]} | Open Access 1 | 37012 | BLM | 16162 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Sacramento 41 | 13.162 | BLM | 1899 | National Public Lands 1 | 3 | |
14011 | 14011 | 14010 | {"type": "MultiPolygon", "coordinates": [[[[-121.39308, 38.25788], [-121.39282, 38.25793], [-121.3912, 38.25765], [-121.39053, 38.25736], [-121.38989, 38.25736], [-121.38815, 38.25765], [-121.38745, 38.25829], [-121.38611, 38.25886], [-121.38527, 38.25893], [-121.38449, 38.25916], [-121.38449, 38.25883], [-121.38479, 38.25866], [-121.38562, 38.25835], [-121.38586, 38.25835], [-121.38673, 38.25793], [-121.38738, 38.25729], [-121.38738, 38.25722], [-121.38765, 38.25708], [-121.38841, 38.25699], [-121.3889, 38.25681], [-121.3894, 38.25639], [-121.38971, 38.25633], [-121.3905, 38.25651], [-121.39282, 38.25733], [-121.39308, 38.25765], [-121.39308, 38.25788]]], [[[-121.42286, 38.26178], [-121.42263, 38.26219], [-121.42237, 38.26226], [-121.42216, 38.26217], [-121.42211, 38.26176], [-121.42199, 38.26167], [-121.42004, 38.2622], [-121.42002, 38.2626], [-121.42022, 38.26286], [-121.42016, 38.2632], [-121.41981, 38.26391], [-121.41984, 38.26491], [-121.41973, 38.26515], [-121.41975, 38.26549], [-121.41993, 38.2656], [-121.42039, 38.26572], [-121.42059, 38.26595], [-121.42054, 38.26606], [-121.4199, 38.26618], [-121.41978, 38.26629], [-121.4197, 38.26661], [-121.41981, 38.2667], [-121.42123, 38.267], [-121.42117, 38.26716], [-121.42074, 38.26732], [-121.42065, 38.26748], [-121.42068, 38.26794], [-121.4208, 38.26844], [-121.42112, 38.26869], [-121.4211, 38.26875], [-121.42063, 38.26884], [-121.4222, 38.27507], [-121.42168, 38.27584], [-121.41959, 38.27586], [-121.41964, 38.28201], [-121.41166, 38.28198], [-121.4117, 38.27587], [-121.41178, 38.27586], [-121.41179, 38.2744], [-121.41042, 38.27372], [-121.40891, 38.27284], [-121.40773, 38.27283], [-121.40611, 38.27164], [-121.40584, 38.27084], [-121.40484, 38.26957], [-121.41045, 38.2696], [-121.41053, 38.26001], [-121.41761, 38.26002], [-121.41768, 38.26083], [-121.41767, 38.26132], [-121.42249, 38.26133], [-121.42286, 38.26155], [-121.42286, 38.26178]]]]} | Open Access 1 | 37014 | BLM | 16162 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Sacramento 41 | 549.812 | BLM | 1899 | National Public Lands 1 | 3 | |
15825 | 15825 | 15824 | {"type": "MultiPolygon", "coordinates": [[[[-121.47105, 38.35012], [-121.46407, 38.35017], [-121.46402, 38.34546], [-121.46413, 38.34545], [-121.46394, 38.33939], [-121.46876, 38.33911], [-121.47105, 38.35012]]], [[[-121.50976, 38.36471], [-121.50932, 38.36497], [-121.50925, 38.36406], [-121.50915, 38.36315], [-121.50902, 38.36224], [-121.50827, 38.35776], [-121.50809, 38.35774], [-121.50777, 38.35581], [-121.50794, 38.35579], [-121.50791, 38.35561], [-121.50801, 38.35559], [-121.50705, 38.34985], [-121.50695, 38.34984], [-121.50694, 38.34981], [-121.50132, 38.34978], [-121.50101, 38.34974], [-121.50054, 38.34973], [-121.50024, 38.34969], [-121.49774, 38.34967], [-121.49781, 38.34858], [-121.49885, 38.34766], [-121.49929, 38.34611], [-121.49096, 38.34607], [-121.49092, 38.34239], [-121.4909, 38.34231], [-121.49076, 38.32093], [-121.49636, 38.32096], [-121.49638, 38.32055], [-121.5012, 38.32057], [-121.50242, 38.32787], [-121.50369, 38.32788], [-121.50491, 38.3352], [-121.50497, 38.33521], [-121.50872, 38.3577], [-121.50867, 38.35771], [-121.50944, 38.36211], [-121.50967, 38.36368], [-121.50976, 38.36471]]], [[[-121.50109, 38.35764], [-121.50084, 38.36476], [-121.49622, 38.36469], [-121.49609, 38.37119], [-121.49574, 38.37128], [-121.49544, 38.37129], [-121.48983, 38.37282], [-121.48916, 38.37298], [-121.48893, 38.36986], [-121.48853, 38.36862], [-121.48864, 38.36598], [-121.48843, 38.36472], [-121.4885, 38.36472], [-121.48871, 38.36596], [-121.48899, 38.36595], [-121.4888, 38.36472], [-121.48899, 38.36186], [-121.49096, 38.35817], [-121.49308, 38.35702], [-121.50107, 38.35702], [-121.50106, 38.35763], [-121.50109, 38.35764]]], [[[-121.50184, 38.41602], [-121.50166, 38.41632], [-121.50152, 38.41663], [-121.50144, 38.41695], [-121.5014, 38.41728], [-121.50142, 38.42955], [-121.50134, 38.42957], [-121.50133, 38.43045], [-121.50142, 38.43046], [-121.50142, 38.43053], [-121.48891, 38.43054], [-121.48947, 38.429], [-121.48964, 38.42828], [-121.48955, 38.42756], [-121.48888, 38.42657], [-121.48787, 38.4259], [-121.48769, 38.42587], [-121.48733, 38.42418], [-121.4871, 38.42222], [-121.48676, 38.42107], [-121.4859, 38.41689], [-121.4858, 38.41654], [-121.48563, 38.41606], [-121.48585, 38.41604], [-121.50086, 38.41604], [-121.50184, 38.41602]]]]} | Open Access 1 | 21636 | Stone Lakes National Wildlife Refuge | 1758 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/refuge/stone_lakes/ | Sacramento 41 | 1878.711 | Stone Lakes NWR | 1994 | National Wildlife Refuge 105 | 2 |
15844 | 15844 | 15843 | {"type": "MultiPolygon", "coordinates": [[[[-121.50142, 38.43053], [-121.50116, 38.4307], [-121.50116, 38.43311], [-121.49772, 38.43419], [-121.49635, 38.43742], [-121.49086, 38.43957], [-121.48897, 38.43056], [-121.48891, 38.43054], [-121.50142, 38.43053]]], [[[-121.50288, 38.31759], [-121.50237, 38.31765], [-121.50282, 38.32038], [-121.50191, 38.32038], [-121.50147, 38.31774], [-121.50137, 38.31774], [-121.49836, 38.29949], [-121.49887, 38.29944], [-121.49888, 38.29943], [-121.49573, 38.28032], [-121.49674, 38.28031], [-121.50288, 38.31759]]]]} | No Public Access 3 | 44499 | Stone Lakes National Wildlife Refuge | 31515 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/refuge/stone_lakes/ | Sacramento 41 | 288.103 | Stone Lakes NWR | 1994 | National Wildlife Refuge 105 | 2 |
16666 | 16666 | 16665 | {"type": "Polygon", "coordinates": [[[-121.1734, 38.71128], [-121.17147, 38.71156], [-121.17175, 38.71225], [-121.17159, 38.71241], [-121.17186, 38.7131], [-121.1518, 38.71156], [-121.14759, 38.71122], [-121.1471, 38.71121], [-121.14666, 38.71128], [-121.14621, 38.71138], [-121.14592, 38.7115], [-121.14567, 38.71167], [-121.14508, 38.71187], [-121.14469, 38.71193], [-121.14417, 38.71198], [-121.14396, 38.71198], [-121.14345, 38.71204], [-121.143, 38.71211], [-121.14278, 38.71222], [-121.14245, 38.71226], [-121.1422, 38.71225], [-121.142, 38.71223], [-121.14161, 38.71215], [-121.14126, 38.71211], [-121.14071, 38.71193], [-121.14049, 38.71184], [-121.14028, 38.71173], [-121.14007, 38.71159], [-121.13996, 38.71155], [-121.13981, 38.71144], [-121.1396, 38.71118], [-121.13922, 38.71099], [-121.13903, 38.71094], [-121.13884, 38.71081], [-121.13873, 38.71064], [-121.13868, 38.7105], [-121.13863, 38.71019], [-121.13847, 38.70988], [-121.13843, 38.70976], [-121.13843, 38.70961], [-121.13847, 38.70942], [-121.13847, 38.70905], [-121.13838, 38.70886], [-121.13829, 38.70874], [-121.13817, 38.70864], [-121.138, 38.70854], [-121.13769, 38.7083], [-121.13743, 38.70821], [-121.13639, 38.70801], [-121.13592, 38.70798], [-121.13572, 38.70794], [-121.13527, 38.70777], [-121.13486, 38.70756], [-121.13474, 38.70742], [-121.13462, 38.70724], [-121.13455, 38.70709], [-121.13451, 38.70689], [-121.13432, 38.70666], [-121.13404, 38.70644], [-121.13391, 38.70628], [-121.13361, 38.70571], [-121.13342, 38.70557], [-121.1333, 38.70551], [-121.133, 38.70551], [-121.13276, 38.70554], [-121.13253, 38.70559], [-121.13231, 38.70567], [-121.13201, 38.70586], [-121.13159, 38.706], [-121.1312, 38.70622], [-121.13083, 38.70634], [-121.13062, 38.70639], [-121.13033, 38.70653], [-121.13021, 38.70666], [-121.13005, 38.70686], [-121.12974, 38.7075], [-121.12937, 38.70801], [-121.12927, 38.7082], [-121.12906, 38.70841], [-121.12883, 38.70855], [-121.12851, 38.70872], [-121.12807, 38.7089], [-121.12786, 38.70897], [-121.12765, 38.70899], [-121.1272, 38.70899], [-121.12679, 38.70909], [-121.12668, 38.70914], [-121.12632, 38.70957], [-121.12585, 38.7099], [-121.12566, 38.71001], [-121.125, 38.71019], [-121.12453, 38.71023], [-121.12437, 38.71021], [-121.1242, 38.71022], [-121.12387, 38.71034], [-121.1234, 38.71062], [-121.12319, 38.71083], [-121.12265, 38.71151], [-121.12224, 38.71229], [-121.12166, 38.71303], [-121.12139, 38.71344], [-121.12123, 38.71363], [-121.12109, 38.71397], [-121.12088, 38.71424], [-121.1208, 38.71431], [-121.12064, 38.71436], [-121.12049, 38.71437], [-121.12007, 38.71437], [-121.1197, 38.71445], [-121.11934, 38.71463], [-121.11897, 38.71492], [-121.11876, 38.71503], [-121.11866, 38.71517], [-121.11861, 38.71536], [-121.11859, 38.71566], [-121.11852, 38.71582], [-121.11852, 38.71596], [-121.11868, 38.71644], [-121.11871, 38.71663], [-121.11868, 38.71694], [-121.11859, 38.71713], [-121.11849, 38.71726], [-121.11838, 38.71736], [-121.11446, 38.70874], [-121.11054, 38.70026], [-121.10972, 38.70044], [-121.10971, 38.70048], [-121.10994, 38.69624], [-121.11206, 38.69622], [-121.11484, 38.69401], [-121.11485, 38.69384], [-121.11605, 38.69339], [-121.11633, 38.69321], [-121.11691, 38.69264], [-121.12161, 38.69259], [-121.12197, 38.69258], [-121.12203, 38.69253], [-121.13252, 38.6925], [-121.13253, 38.69253], [-121.13336, 38.69253], [-121.13337, 38.6925], [-121.13535, 38.69249], [-121.13534, 38.69337], [-121.1355, 38.6934], [-121.1355, 38.69342], [-121.13615, 38.69353], [-121.13616, 38.69504], [-121.13764, 38.69531], [-121.13766, 38.6953], [-121.13885, 38.6955], [-121.13886, 38.69552], [-121.13985, 38.6957], [-121.13986, 38.69511], [-121.13984, 38.6951], [-121.13987, 38.69313], [-121.14284, 38.69413], [-121.14321, 38.69452], [-121.14385, 38.6939], [-121.14393, 38.69395], [-121.14377, 38.69409], [-121.14368, 38.69419], [-121.14353, 38.69449], [-121.14342, 38.69482], [-121.14338, 38.69478], [-121.14337, 38.69478], [-121.14334, 38.69502], [-121.14335, 38.69527], [-121.14341, 38.69548], [-121.14352, 38.69571], [-121.14375, 38.69605], [-121.14387, 38.69629], [-121.14396, 38.69653], [-121.14401, 38.69686], [-121.14401, 38.69716], [-121.14392, 38.69752], [-121.14384, 38.69773], [-121.14367, 38.69803], [-121.14359, 38.69828], [-121.14357, 38.69851], [-121.14358, 38.6987], [-121.14362, 38.69883], [-121.14367, 38.69895], [-121.14376, 38.69912], [-121.14398, 38.69937], [-121.14419, 38.69953], [-121.14455, 38.69971], [-121.14462, 38.70001], [-121.14526, 38.70027], [-121.14569, 38.70054], [-121.14592, 38.70082], [-121.14616, 38.70148], [-121.14628, 38.7016], [-121.14703, 38.70446], [-121.14718, 38.70457], [-121.14852, 38.70428], [-121.15401, 38.70677], [-121.15453, 38.70705], [-121.15487, 38.70711], [-121.15501, 38.70777], [-121.15523, 38.70802], [-121.15561, 38.70836], [-121.15576, 38.70862], [-121.15637, 38.70861], [-121.1568, 38.7087], [-121.15719, 38.70888], [-121.15732, 38.70884], [-121.15823, 38.70871], [-121.15858, 38.70876], [-121.15878, 38.70885], [-121.15883, 38.70875], [-121.15994, 38.70918], [-121.16039, 38.70934], [-121.16074, 38.70941], [-121.16466, 38.70962], [-121.1662, 38.70913], [-121.16699, 38.70826], [-121.16749, 38.70782], [-121.16807, 38.70745], [-121.16858, 38.70707], [-121.16899, 38.70682], [-121.16885, 38.7067], [-121.16871, 38.7067], [-121.16837, 38.70691], [-121.16814, 38.7071], [-121.16799, 38.70717], [-121.16775, 38.70702], [-121.16764, 38.70693], [-121.16766, 38.70688], [-121.16796, 38.70665], [-121.16871, 38.70614], [-121.16882, 38.70612], [-121.16894, 38.70614], [-121.16901, 38.70619], [-121.16921, 38.70603], [-121.16919, 38.70592], [-121.16935, 38.70576], [-121.16938, 38.70557], [-121.16935, 38.70548], [-121.16922, 38.7054], [-121.16753, 38.70512], [-121.1697, 38.70514], [-121.16955, 38.70588], [-121.16953, 38.70608], [-121.16953, 38.70638], [-121.16958, 38.70669], [-121.16965, 38.70694], [-121.16976, 38.70723], [-121.16987, 38.70742], [-121.17001, 38.70765], [-121.17025, 38.70793], [-121.1734, 38.71128]]]} | Open Access 1 | 28062 | Folsom Lake State Recreation Area | 13811 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=500 | Sacramento 41 | 1642.218 | Folsom Lake SRA | 1956 | State Recreation Area 39 | 4 |
16669 | 16669 | 16668 | {"type": "MultiPolygon", "coordinates": [[[[-121.22702, 38.63621], [-121.22565, 38.63663], [-121.22587, 38.63706], [-121.22599, 38.63794], [-121.22582, 38.63898], [-121.22561, 38.63898], [-121.22565, 38.63808], [-121.22565, 38.63775], [-121.22558, 38.63726], [-121.22545, 38.63678], [-121.2255, 38.63672], [-121.22547, 38.63665], [-121.2254, 38.63664], [-121.2252, 38.63619], [-121.22495, 38.6363], [-121.22513, 38.63669], [-121.22523, 38.63699], [-121.22532, 38.63737], [-121.22536, 38.63769], [-121.22537, 38.63808], [-121.22532, 38.63931], [-121.22531, 38.63934], [-121.22526, 38.63937], [-121.22517, 38.63936], [-121.22319, 38.63815], [-121.223, 38.63806], [-121.22267, 38.63798], [-121.22227, 38.63794], [-121.2222, 38.6379], [-121.22214, 38.63782], [-121.22081, 38.63788], [-121.22082, 38.63808], [-121.22208, 38.63816], [-121.22214, 38.63808], [-121.2222, 38.63804], [-121.22234, 38.63801], [-121.22266, 38.63804], [-121.22303, 38.63813], [-121.22315, 38.63819], [-121.22523, 38.63946], [-121.2253, 38.63956], [-121.22529, 38.63979], [-121.22284, 38.63985], [-121.21706, 38.64192], [-121.21419, 38.64351], [-121.20315, 38.64362], [-121.19881, 38.64738], [-121.19852, 38.64792], [-121.19852, 38.64793], [-121.20721, 38.64636], [-121.20699, 38.65496], [-121.20366, 38.65496], [-121.19644, 38.65771], [-121.19552, 38.65864], [-121.1956, 38.65893], [-121.19504, 38.65937], [-121.19376, 38.6616], [-121.19329, 38.66275], [-121.19337, 38.66334], [-121.19307, 38.66349], [-121.19304, 38.6642], [-121.19178, 38.66432], [-121.19137, 38.66554], [-121.19138, 38.66609], [-121.19167, 38.66617], [-121.19168, 38.66697], [-121.19166, 38.66698], [-121.19181, 38.67051], [-121.19331, 38.67619], [-121.19345, 38.67769], [-121.19542, 38.67773], [-121.19489, 38.67791], [-121.19451, 38.6779], [-121.19467, 38.67785], [-121.19466, 38.67783], [-121.19305, 38.67782], [-121.19281, 38.67624], [-121.1928, 38.67623], [-121.1785, 38.68313], [-121.17642, 38.68318], [-121.17642, 38.6832], [-121.17662, 38.68337], [-121.17648, 38.68355], [-121.17632, 38.68362], [-121.17594, 38.68366], [-121.17564, 38.68366], [-121.17535, 38.68362], [-121.17501, 38.68351], [-121.17495, 38.68344], [-121.17498, 38.68332], [-121.17509, 38.68318], [-121.17541, 38.68292], [-121.17576, 38.68277], [-121.17604, 38.6827], [-121.17556, 38.68196], [-121.17561, 38.68202], [-121.17569, 38.68202], [-121.1759, 38.68188], [-121.17603, 38.68185], [-121.1761, 38.68178], [-121.17623, 38.6817], [-121.1763, 38.68162], [-121.1763, 38.68141], [-121.17653, 38.68112], [-121.17708, 38.68077], [-121.17752, 38.6806], [-121.17755, 38.68051], [-121.17753, 38.6804], [-121.17749, 38.6803], [-121.17754, 38.68025], [-121.17762, 38.68026], [-121.17774, 38.68033], [-121.17781, 38.6803], [-121.17784, 38.68024], [-121.17785, 38.68016], [-121.17781, 38.68009], [-121.17791, 38.68004], [-121.17802, 38.6801], [-121.17809, 38.6801], [-121.17832, 38.68005], [-121.17845, 38.67996], [-121.17856, 38.67985], [-121.17858, 38.6798], [-121.17854, 38.67972], [-121.17842, 38.67961], [-121.17826, 38.67951], [-121.1785, 38.67917], [-121.18842, 38.67343], [-121.18842, 38.67342], [-121.18829, 38.67329], [-121.18717, 38.67394], [-121.18692, 38.67367], [-121.18803, 38.67303], [-121.18804, 38.67301], [-121.188, 38.67298], [-121.18688, 38.67363], [-121.18659, 38.67332], [-121.1877, 38.67267], [-121.18753, 38.67248], [-121.18645, 38.6731], [-121.18666, 38.6725], [-121.18724, 38.67216], [-121.18719, 38.67213], [-121.18669, 38.67241], [-121.18691, 38.6718], [-121.18665, 38.67181], [-121.18685, 38.67169], [-121.18647, 38.67125], [-121.18675, 38.67099], [-121.18633, 38.6687], [-121.18698, 38.66733], [-121.18752, 38.66387], [-121.18859, 38.6598], [-121.18921, 38.65821], [-121.18953, 38.65732], [-121.18985, 38.6563], [-121.19016, 38.65231], [-121.18837, 38.65035], [-121.18548, 38.65012], [-121.18503, 38.64889], [-121.18535, 38.64864], [-121.18609, 38.64927], [-121.18879, 38.64865], [-121.18897, 38.64868], [-121.18915, 38.64879], [-121.18932, 38.64877], [-121.19022, 38.64905], [-121.19125, 38.64953], [-121.19148, 38.64952], [-121.19197, 38.64886], [-121.19226, 38.64783], [-121.19259, 38.6471], [-121.19261, 38.64662], [-121.1925, 38.6465], [-121.19189, 38.64626], [-121.19189, 38.64605], [-121.19267, 38.64575], [-121.19329, 38.64536], [-121.19422, 38.64429], [-121.19498, 38.64378], [-121.19716, 38.64279], [-121.19717, 38.64279], [-121.19792, 38.64243], [-121.19828, 38.64215], [-121.19858, 38.64201], [-121.19887, 38.64189], [-121.19887, 38.64187], [-121.1997, 38.64147], [-121.20408, 38.6395], [-121.20496, 38.63902], [-121.20595, 38.63815], [-121.20665, 38.63801], [-121.20691, 38.63786], [-121.20691, 38.63669], [-121.20796, 38.6363], [-121.20817, 38.63657], [-121.20805, 38.63687], [-121.20744, 38.63765], [-121.20732, 38.6381], [-121.20729, 38.63855], [-121.20762, 38.63851], [-121.2082, 38.6384], [-121.21376, 38.63718], [-121.21303, 38.6361], [-121.21411, 38.6355], [-121.21273, 38.63402], [-121.21272, 38.63399], [-121.21245, 38.63372], [-121.21389, 38.63314], [-121.21411, 38.63302], [-121.21483, 38.63256], [-121.21539, 38.63252], [-121.21585, 38.63254], [-121.21603, 38.6326], [-121.21626, 38.63271], [-121.21645, 38.6329], [-121.21698, 38.63317], [-121.21732, 38.63339], [-121.21748, 38.63346], [-121.21786, 38.63345], [-121.21814, 38.63337], [-121.21823, 38.63331], [-121.21836, 38.63326], [-121.21844, 38.63349], [-121.21858, 38.63352], [-121.21867, 38.63359], [-121.21889, 38.63396], [-121.21908, 38.63397], [-121.22033, 38.63358], [-121.22141, 38.63392], [-121.22194, 38.63405], [-121.22203, 38.63405], [-121.2231, 38.6328], [-121.22351, 38.63288], [-121.22379, 38.63307], [-121.22379, 38.63333], [-121.22357, 38.63347], [-121.2241, 38.63453], [-121.22515, 38.63528], [-121.22702, 38.63621]], [[-121.22079, 38.63713], [-121.22078, 38.63712], [-121.22071, 38.63714], [-121.22045, 38.63651], [-121.22036, 38.63648], [-121.22042, 38.63632], [-121.21995, 38.6354], [-121.21997, 38.63514], [-121.21988, 38.63491], [-121.21991, 38.63455], [-121.21929, 38.63466], [-121.2193, 38.63474], [-121.21892, 38.63483], [-121.21893, 38.63486], [-121.21907, 38.63485], [-121.21918, 38.63515], [-121.21946, 38.63513], [-121.2201, 38.63695], [-121.22019, 38.637], [-121.22024, 38.63735], [-121.22013, 38.63746], [-121.21965, 38.63768], [-121.21946, 38.63804], [-121.21979, 38.63847], [-121.22006, 38.63841], [-121.21991, 38.63801], [-121.22012, 38.63793], [-121.22042, 38.63762], [-121.22094, 38.63748], [-121.22079, 38.63713]]], [[[-121.20682, 38.63594], [-121.2024, 38.63828], [-121.20204, 38.63844], [-121.20143, 38.63865], [-121.20141, 38.63776], [-121.20205, 38.63741], [-121.20216, 38.63713], [-121.20246, 38.63648], [-121.20281, 38.63629], [-121.20399, 38.63619], [-121.20529, 38.63541], [-121.20682, 38.63594]]]]} | Open Access 1 | 25868 | Folsom Lake State Recreation Area | 13811 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=500 | Sacramento 41 | 1231.579 | Folsom Lake SRA | 1956 | State Recreation Area 39 | 4 |
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]);