units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where COUNTY = 48 and MNG_AGENCY = 142
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, PARK_URL, LABEL_NAME, GAP_STS
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3129 | 3129 | 3128 | {"type": "MultiPolygon", "coordinates": [[[[-120.20207, 37.13415], [-120.20207, 37.13449], [-120.20152, 37.13451], [-120.20131, 37.13451], [-120.20105, 37.13446], [-120.20079, 37.13437], [-120.19586, 37.13211], [-120.19264, 37.1301], [-120.19236, 37.12991], [-120.19219, 37.12982], [-120.19198, 37.12974], [-120.1916, 37.12964], [-120.19133, 37.12962], [-120.19109, 37.12962], [-120.18887, 37.12995], [-120.18886, 37.12996], [-120.18902, 37.13022], [-120.18406, 37.13106], [-120.18407, 37.12916], [-120.18436, 37.12914], [-120.18504, 37.12897], [-120.18623, 37.12879], [-120.18751, 37.12855], [-120.18812, 37.1284], [-120.1887, 37.12966], [-120.19099, 37.12929], [-120.19127, 37.12928], [-120.19151, 37.1293], [-120.19175, 37.12933], [-120.19202, 37.12939], [-120.19235, 37.12951], [-120.19259, 37.12963], [-120.19617, 37.13183], [-120.201, 37.13407], [-120.20111, 37.13414], [-120.20121, 37.13417], [-120.20134, 37.13418], [-120.20207, 37.13415]]], [[[-120.18786, 37.12782], [-120.18688, 37.1281], [-120.18514, 37.12848], [-120.18407, 37.12864], [-120.18407, 37.12724], [-120.18761, 37.12726], [-120.18786, 37.12782]]], [[[-120.19316, 37.12631], [-120.19316, 37.12665], [-120.1915, 37.12715], [-120.18701, 37.12712], [-120.18727, 37.12685], [-120.191, 37.1269], [-120.19192, 37.12674], [-120.19316, 37.12631]]]]} | Open Access 1 | 25780 | Berenda Reservoir | 16018 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Madera 48 | 47.282 | Berenda Reservoir | 0 | Resource Management Area 82 | 3 | |
| 5061 | 5061 | 5060 | {"type": "Polygon", "coordinates": [[[-119.90021, 37.11763], [-119.90013, 37.11853], [-119.89929, 37.12169], [-119.8965, 37.12602], [-119.8965, 37.12649], [-119.89663, 37.12771], [-119.89646, 37.12939], [-119.89638, 37.12966], [-119.89632, 37.13001], [-119.89335, 37.12997], [-119.89344, 37.13376], [-119.88444, 37.13374], [-119.88446, 37.14093], [-119.87634, 37.14095], [-119.87626, 37.14452], [-119.87522, 37.14453], [-119.87524, 37.14639], [-119.873, 37.14639], [-119.87298, 37.14719], [-119.87184, 37.1472], [-119.87183, 37.14821], [-119.86873, 37.14822], [-119.8687, 37.14646], [-119.86427, 37.14646], [-119.86426, 37.1506], [-119.85549, 37.15058], [-119.85537, 37.14817], [-119.85746, 37.14813], [-119.85749, 37.14631], [-119.85639, 37.1463], [-119.85636, 37.14369], [-119.8574, 37.14363], [-119.85735, 37.14088], [-119.86191, 37.14089], [-119.8619, 37.13812], [-119.86085, 37.13809], [-119.86075, 37.13008], [-119.86179, 37.13008], [-119.86169, 37.12646], [-119.86248, 37.12646], [-119.86344, 37.12503], [-119.86336, 37.12278], [-119.86643, 37.12281], [-119.8664, 37.12177], [-119.86558, 37.12175], [-119.86559, 37.12106], [-119.86645, 37.12083], [-119.86663, 37.12029], [-119.86623, 37.11897], [-119.86551, 37.11783], [-119.86552, 37.11587], [-119.8657, 37.11537], [-119.86679, 37.11419], [-119.86686, 37.11342], [-119.86761, 37.11168], [-119.86756, 37.10989], [-119.86647, 37.10798], [-119.86646, 37.10779], [-119.86776, 37.1058], [-119.86768, 37.10457], [-119.86808, 37.10374], [-119.86836, 37.10404], [-119.86828, 37.10521], [-119.86816, 37.10571], [-119.86808, 37.10576], [-119.86808, 37.1059], [-119.86745, 37.10695], [-119.86739, 37.10745], [-119.86696, 37.10784], [-119.86694, 37.1082], [-119.86745, 37.10871], [-119.86757, 37.10903], [-119.86794, 37.10951], [-119.86805, 37.10999], [-119.86819, 37.11013], [-119.86805, 37.11148], [-119.86791, 37.11187], [-119.86725, 37.11274], [-119.86726, 37.11349], [-119.86739, 37.11369], [-119.86741, 37.11368], [-119.8676, 37.11335], [-119.86777, 37.11258], [-119.86845, 37.11228], [-119.86877, 37.11207], [-119.86931, 37.11134], [-119.86945, 37.11132], [-119.86971, 37.1115], [-119.86991, 37.11143], [-119.87056, 37.11081], [-119.87059, 37.11061], [-119.87048, 37.11045], [-119.87045, 37.11006], [-119.87077, 37.10985], [-119.87082, 37.10963], [-119.87068, 37.10949], [-119.87065, 37.1091], [-119.87085, 37.10882], [-119.87125, 37.10862], [-119.87165, 37.10809], [-119.8723, 37.10786], [-119.87253, 37.1077], [-119.87256, 37.10745], [-119.87296, 37.10727], [-119.87382, 37.10731], [-119.87416, 37.1074], [-119.87491, 37.10807], [-119.87499, 37.10836], [-119.87553, 37.10864], [-119.87556, 37.10905], [-119.87545, 37.10921], [-119.87545, 37.10996], [-119.87528, 37.1104], [-119.87357, 37.11141], [-119.87357, 37.11152], [-119.87382, 37.11175], [-119.87382, 37.11202], [-119.87348, 37.11212], [-119.87311, 37.11236], [-119.87305, 37.11257], [-119.87285, 37.1128], [-119.87257, 37.11292], [-119.8716, 37.11367], [-119.87157, 37.11379], [-119.87111, 37.11404], [-119.87066, 37.11408], [-119.87028, 37.11399], [-119.87028, 37.11381], [-119.87043, 37.1136], [-119.87043, 37.11336], [-119.87008, 37.11308], [-119.87008, 37.11264], [-119.86994, 37.11239], [-119.86968, 37.11237], [-119.86954, 37.11246], [-119.86957, 37.11322], [-119.86914, 37.11381], [-119.86908, 37.11418], [-119.86866, 37.11452], [-119.86863, 37.11479], [-119.86903, 37.11503], [-119.86903, 37.11514], [-119.86931, 37.11544], [-119.86928, 37.11566], [-119.86866, 37.11637], [-119.86846, 37.11678], [-119.86837, 37.11763], [-119.86823, 37.11786], [-119.86817, 37.11823], [-119.86826, 37.1183], [-119.8694, 37.11804], [-119.86966, 37.1182], [-119.86966, 37.11857], [-119.86994, 37.11896], [-119.87003, 37.1193], [-119.87026, 37.11955], [-119.87068, 37.11946], [-119.87075, 37.11896], [-119.87086, 37.11882], [-119.87123, 37.11884], [-119.87143, 37.11861], [-119.87143, 37.11823], [-119.87066, 37.1177], [-119.87069, 37.11747], [-119.87089, 37.11729], [-119.87109, 37.11683], [-119.87154, 37.11642], [-119.87171, 37.11637], [-119.87183, 37.11649], [-119.87169, 37.11681], [-119.87169, 37.11763], [-119.87214, 37.11775], [-119.87237, 37.11795], [-119.87271, 37.11792], [-119.87277, 37.11729], [-119.87286, 37.11699], [-119.87314, 37.11671], [-119.87323, 37.11633], [-119.8736, 37.11614], [-119.8738, 37.1163], [-119.87381, 37.11695], [-119.87406, 37.11701], [-119.87466, 37.11674], [-119.87477, 37.11772], [-119.87503, 37.11806], [-119.87577, 37.11806], [-119.87594, 37.11825], [-119.87597, 37.11857], [-119.87517, 37.11889], [-119.87497, 37.11907], [-119.87489, 37.11934], [-119.87452, 37.1198], [-119.87452, 37.12024], [-119.87432, 37.12054], [-119.87366, 37.12085], [-119.87369, 37.12101], [-119.87406, 37.12125], [-119.87429, 37.12154], [-119.87449, 37.12151], [-119.87458, 37.12115], [-119.8748, 37.1209], [-119.87557, 37.12106], [-119.87701, 37.12212], [-119.87701, 37.12235], [-119.8769, 37.12249], [-119.87687, 37.12344], [-119.8767, 37.12365], [-119.87595, 37.1241], [-119.87546, 37.12454], [-119.87506, 37.12481], [-119.87357, 37.12513], [-119.87303, 37.12545], [-119.87272, 37.12531], [-119.87261, 37.12495], [-119.87261, 37.12479], [-119.87195, 37.12417], [-119.87143, 37.12402], [-119.87101, 37.12427], [-119.87092, 37.12445], [-119.871, 37.12515], [-119.87066, 37.12533], [-119.87014, 37.12545], [-119.86977, 37.12541], [-119.86977, 37.12616], [-119.86969, 37.12625], [-119.86926, 37.12629], [-119.86846, 37.12604], [-119.8674, 37.12531], [-119.86663, 37.12511], [-119.86614, 37.12529], [-119.86526, 37.12529], [-119.86532, 37.12566], [-119.86549, 37.12593], [-119.86555, 37.12664], [-119.8662, 37.12721], [-119.8662, 37.12744], [-119.86597, 37.12751], [-119.86552, 37.12747], [-119.86532, 37.12769], [-119.86503, 37.12779], [-119.86438, 37.12785], [-119.86437, 37.12808], [-119.8646, 37.12831], [-119.86532, 37.12884], [-119.86538, 37.12913], [-119.8668, 37.12973], [-119.867, 37.12998], [-119.86709, 37.1303], [-119.86692, 37.13087], [-119.86709, 37.13098], [-119.86743, 37.13087], [-119.86798, 37.13023], [-119.86818, 37.13014], [-119.86852, 37.13016], [-119.8688, 37.13048], [-119.86869, 37.13076], [-119.86829, 37.13126], [-119.86829, 37.13142], [-119.86872, 37.13172], [-119.86881, 37.13194], [-119.86935, 37.13181], [-119.86941, 37.13279], [-119.86949, 37.13282], [-119.86949, 37.13297], [-119.87038, 37.13352], [-119.87035, 37.13393], [-119.87015, 37.13414], [-119.86955, 37.13405], [-119.86932, 37.13398], [-119.86812, 37.13403], [-119.86787, 37.13415], [-119.86789, 37.13439], [-119.86846, 37.13478], [-119.86858, 37.13499], [-119.86898, 37.13522], [-119.86955, 37.13533], [-119.86984, 37.13554], [-119.86993, 37.13579], [-119.87072, 37.13604], [-119.87081, 37.13611], [-119.87078, 37.13643], [-119.87004, 37.13673], [-119.86978, 37.13702], [-119.86967, 37.1373], [-119.8693, 37.13723], [-119.86904, 37.137], [-119.86904, 37.13609], [-119.86881, 37.13586], [-119.86835, 37.13579], [-119.86775, 37.13593], [-119.86729, 37.13593], [-119.86644, 37.13549], [-119.86587, 37.1354], [-119.86558, 37.13529], [-119.86532, 37.13533], [-119.86513, 37.13547], [-119.86518, 37.13574], [-119.86538, 37.13588], [-119.86538, 37.13623], [-119.86569, 37.1365], [-119.86561, 37.13703], [-119.86621, 37.13741], [-119.86621, 37.1376], [-119.86555, 37.13803], [-119.86492, 37.13778], [-119.86378, 37.13705], [-119.86338, 37.13701], [-119.86318, 37.13714], [-119.86318, 37.13762], [-119.86327, 37.13769], [-119.86327, 37.13815], [-119.86315, 37.13863], [-119.8633, 37.13874], [-119.86367, 37.13883], [-119.86392, 37.13897], [-119.86395, 37.13966], [-119.86413, 37.13996], [-119.86432, 37.14014], [-119.8643, 37.14044], [-119.86404, 37.14062], [-119.86324, 37.14071], [-119.86261, 37.14112], [-119.86264, 37.14126], [-119.86347, 37.14154], [-119.86347, 37.14188], [-119.86304, 37.14236], [-119.86213, 37.14289], [-119.86167, 37.143], [-119.86004, 37.14314], [-119.85973, 37.14334], [-119.85876, 37.1444], [-119.85833, 37.14533], [-119.85818, 37.14542], [-119.85753, 37.14545], [-119.85753, 37.14586], [-119.85801, 37.14639], [-119.8589, 37.1471], [-119.85916, 37.14849], [-119.85887, 37.14927], [-119.85862, 37.14945], [-119.85747, 37.14918], [-119.85685, 37.14922], [-119.8565, 37.14934], [-119.85628, 37.14975], [-119.85679, 37.14977], [-119.8575, 37.14964], [-119.85859, 37.15016], [-119.85927, 37.15007], [-119.8597, 37.14989], [-119.8603, 37.14877], [-119.86062, 37.14778], [-119.86101, 37.14748], [-119.86096, 37.14721], [-119.8607, 37.14689], [-119.8607, 37.14593], [-119.86053, 37.14577], [-119.86059, 37.14543], [-119.86107, 37.14513], [-119.86176, 37.14487], [-119.86244, 37.14417], [-119.86281, 37.14408], [-119.86344, 37.14421], [-119.86464, 37.14423], [-119.86547, 37.14506], [-119.86662, 37.14515], [-119.86704, 37.14509], [-119.86696, 37.14487], [-119.8667, 37.14457], [-119.86673, 37.14428], [-119.86693, 37.14412], [-119.86721, 37.14414], [-119.86753, 37.14432], [-119.86753, 37.14476], [-119.86767, 37.14494], [-119.86818, 37.14492], [-119.86841, 37.1446], [-119.86847, 37.14394], [-119.86862, 37.1438], [-119.86956, 37.14387], [-119.86981, 37.144], [-119.86988, 37.14471], [-119.87127, 37.1456], [-119.87145, 37.14583], [-119.87145, 37.14647], [-119.8713, 37.14672], [-119.87131, 37.14702], [-119.87165, 37.14704], [-119.8723, 37.14682], [-119.87253, 37.14663], [-119.8727, 37.14633], [-119.87256, 37.14608], [-119.8725, 37.1453], [-119.87227, 37.14478], [-119.87256, 37.14469], [-119.87367, 37.14498], [-119.87387, 37.14493], [-119.87382, 37.14473], [-119.87359, 37.14455], [-119.87307, 37.14368], [-119.87242, 37.14315], [-119.87242, 37.1429], [-119.87262, 37.14288], [-119.87373, 37.14327], [-119.87459, 37.14395], [-119.87496, 37.14413], [-119.87507, 37.14406], [-119.87513, 37.14359], [-119.87462, 37.1427], [-119.87459, 37.14233], [-119.87479, 37.14215], [-119.87553, 37.14203], [-119.87576, 37.1419], [-119.87576, 37.1416], [-119.87564, 37.14139], [-119.87581, 37.1405], [-119.87521, 37.13986], [-119.8751, 37.13881], [-119.87521, 37.1383], [-119.8764, 37.13728], [-119.87662, 37.13735], [-119.87685, 37.13755], [-119.87699, 37.13815], [-119.87725, 37.13861], [-119.8774, 37.13872], [-119.87796, 37.13861], [-119.87831, 37.13833], [-119.8782, 37.1379], [-119.87845, 37.13762], [-119.87917, 37.13728], [-119.87922, 37.13714], [-119.87908, 37.13691], [-119.87834, 37.13652], [-119.87834, 37.13616], [-119.87848, 37.13595], [-119.87826, 37.13565], [-119.87865, 37.1351], [-119.87865, 37.13481], [-119.87854, 37.13451], [-119.87866, 37.1344], [-119.87903, 37.1344], [-119.8794, 37.13465], [-119.88017, 37.13485], [-119.88106, 37.13529], [-119.88217, 37.13563], [-119.88285, 37.13575], [-119.88323, 37.136], [-119.88328, 37.13676], [-119.88343, 37.13689], [-119.88376, 37.13683], [-119.88388, 37.13614], [-119.88405, 37.13598], [-119.88405, 37.13575], [-119.88277, 37.13518], [-119.8826, 37.13492], [-119.88194, 37.1344], [-119.88183, 37.13396], [-119.88143, 37.13346], [-119.88146, 37.13259], [-119.88166, 37.13261], [-119.88194, 37.13282], [-119.88246, 37.133], [-119.88303, 37.13339], [-119.88337, 37.13335], [-119.88363, 37.13313], [-119.8836, 37.13273], [-119.88332, 37.13204], [-119.8834, 37.13195], [-119.88417, 37.13188], [-119.8846, 37.13156], [-119.8846, 37.13117], [-119.88474, 37.13113], [-119.88543, 37.1314], [-119.88586, 37.13177], [-119.88603, 37.13209], [-119.88643, 37.13232], [-119.88688, 37.13229], [-119.88683, 37.13209], [-119.88649, 37.13165], [-119.88654, 37.13147], [-119.88777, 37.13152], [-119.88846, 37.13149], [-119.88846, 37.1314], [-119.88777, 37.1309], [-119.88766, 37.13067], [-119.88706, 37.13012], [-119.88592, 37.13008], [-119.88589, 37.12991], [-119.88677, 37.12939], [-119.88672, 37.12898], [-119.8862, 37.12843], [-119.88618, 37.12809], [-119.88638, 37.12802], [-119.887, 37.128], [-119.88712, 37.12809], [-119.88715, 37.12848], [-119.88746, 37.12891], [-119.88763, 37.12939], [-119.88792, 37.1295], [-119.88823, 37.12948], [-119.88829, 37.12912], [-119.88852, 37.12898], [-119.88849, 37.12841], [-119.88866, 37.12813], [-119.88866, 37.12783], [-119.8882, 37.12738], [-119.88832, 37.12717], [-119.88849, 37.1272], [-119.8888, 37.12742], [-119.88903, 37.12772], [-119.88903, 37.12831], [-119.88929, 37.12907], [-119.88949, 37.12918], [-119.8896, 37.12909], [-119.88966, 37.12889], [-119.88989, 37.12873], [-119.89006, 37.12875], [-119.89026, 37.12891], [-119.89069, 37.12983], [-119.89072, 37.13026], [-119.891, 37.13049], [-119.89126, 37.13046], [-119.89129, 37.12983], [-119.89183, 37.13006], [-119.89269, 37.13016], [-119.89263, 37.1298], [-119.89232, 37.12951], [-119.89158, 37.12912], [-119.89158, 37.12889], [-119.89183, 37.12864], [-119.89183, 37.1285], [-119.89166, 37.12836], [-119.891, 37.12806], [-119.89089, 37.12738], [-119.89066, 37.12699], [-119.89078, 37.12681], [-119.89212, 37.12708], [-119.89292, 37.12738], [-119.89323, 37.12729], [-119.8932, 37.12699], [-119.89183, 37.12559], [-119.89183, 37.12518], [-119.89155, 37.12498], [-119.89096, 37.12448], [-119.89098, 37.12439], [-119.89073, 37.12416], [-119.88987, 37.12386], [-119.8899, 37.12361], [-119.8905, 37.12345], [-119.89079, 37.12311], [-119.89098, 37.12304], [-119.89164, 37.12327], [-119.89193, 37.12324], [-119.89198, 37.12304], [-119.89176, 37.12265], [-119.89113, 37.12212], [-119.89113, 37.12196], [-119.89144, 37.12196], [-119.89213, 37.12253], [-119.89264, 37.1226], [-119.89327, 37.12281], [-119.89352, 37.12274], [-119.89358, 37.1224], [-119.89299, 37.1221], [-119.89264, 37.1218], [-119.89256, 37.12141], [-119.89267, 37.12119], [-119.89296, 37.121], [-119.89324, 37.12098], [-119.89376, 37.12171], [-119.89401, 37.12183], [-119.89418, 37.12178], [-119.8941, 37.12132], [-119.89416, 37.12109], [-119.89444, 37.12084], [-119.89522, 37.12059], [-119.89547, 37.12041], [-119.89547, 37.12021], [-119.89424, 37.12011], [-119.89402, 37.12002], [-119.89381, 37.11963], [-119.89284, 37.1194], [-119.89264, 37.11926], [-119.89261, 37.11899], [-119.89196, 37.11897], [-119.89136, 37.11851], [-119.89127, 37.11782], [-119.89022, 37.11759], [-119.88999, 37.11732], [-119.88993, 37.11693], [-119.89007, 37.11677], [-119.89056, 37.11684], [-119.89076, 37.11698], [-119.89085, 37.11716], [-119.89113, 37.11734], [-119.89135, 37.11736], [-119.89165, 37.11691], [-119.89182, 37.11691], [-119.89222, 37.11741], [-119.89293, 37.11764], [-119.89342, 37.11766], [-119.8937, 37.11812], [-119.8943, 37.11851], [-119.8947, 37.11844], [-119.89476, 37.11757], [-119.89422, 37.11711], [-119.89419, 37.11668], [-119.89373, 37.11633], [-119.89347, 37.11533], [-119.89264, 37.11466], [-119.88999, 37.11356], [-119.88671, 37.11174], [-119.88428, 37.11013], [-119.88379, 37.10965], [-119.88302, 37.1091], [-119.88065, 37.10695], [-119.87914, 37.10519], [-119.87786, 37.10503], [-119.87746, 37.10487], [-119.87683, 37.10503], [-119.87648, 37.10491], [-119.87596, 37.10432], [-119.87556, 37.10406], [-119.87544, 37.10383], [-119.87533, 37.10287], [-119.87519, 37.1026], [-119.87439, 37.1021], [-119.8741, 37.10207], [-119.8739, 37.10217], [-119.8739, 37.10255], [-119.8741, 37.10276], [-119.8741, 37.10306], [-119.8739, 37.10326], [-119.87384, 37.10363], [-119.87359, 37.10383], [-119.87325, 37.10381], [-119.87282, 37.10335], [-119.87276, 37.10315], [-119.87242, 37.10283], [-119.8721, 37.10283], [-119.87199, 37.10335], [-119.87216, 37.10381], [-119.87216, 37.10409], [-119.8721, 37.10413], [-119.8711, 37.10416], [-119.8707, 37.10399], [-119.87065, 37.1037], [-119.87079, 37.10351], [-119.87084, 37.10274], [-119.87039, 37.10247], [-119.86922, 37.10255], [-119.86962, 37.10228], [-119.87169, 37.10221], [-119.87288, 37.10119], [-119.87293, 37.10112], [-119.873, 37.10111], [-119.873, 37.10099], [-119.87326, 37.10052], [-119.87325, 37.10016], [-119.87451, 37.09919], [-119.87504, 37.09943], [-119.87542, 37.09977], [-119.87658, 37.10117], [-119.87773, 37.10118], [-119.88044, 37.10032], [-119.88124, 37.10016], [-119.88187, 37.10024], [-119.88288, 37.10072], [-119.8839, 37.1013], [-119.88893, 37.10135], [-119.88896, 37.1036], [-119.88905, 37.10519], [-119.88887, 37.10618], [-119.88828, 37.107], [-119.88818, 37.10803], [-119.88889, 37.11069], [-119.88954, 37.11161], [-119.89055, 37.11222], [-119.8931, 37.11336], [-119.89462, 37.11423], [-119.8971, 37.11596], [-119.89935, 37.11697], [-119.90021, 37.11763]]]} | Open Access 1 | 44415 | Hensley Lake Recreation Area | 13560 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/HensleyLake.aspx | Madera 48 | 1385.168 | Hensley Lake Rec. Area | 0 | Recreation Management Area 49 | 4 |
| 9821 | 9821 | 9820 | {"type": "Polygon", "coordinates": [[[-119.89547, 37.1202], [-119.89547, 37.12041], [-119.89522, 37.12059], [-119.89444, 37.12084], [-119.89416, 37.12109], [-119.8941, 37.12132], [-119.89419, 37.12178], [-119.89401, 37.12183], [-119.89376, 37.12171], [-119.89324, 37.12098], [-119.89296, 37.121], [-119.89267, 37.12119], [-119.89256, 37.12142], [-119.89264, 37.1218], [-119.89299, 37.1221], [-119.89358, 37.1224], [-119.89353, 37.12274], [-119.89327, 37.12281], [-119.89264, 37.1226], [-119.89213, 37.12253], [-119.89144, 37.12196], [-119.89114, 37.12196], [-119.89113, 37.12212], [-119.89176, 37.12265], [-119.89198, 37.12304], [-119.89193, 37.12324], [-119.89164, 37.12327], [-119.89098, 37.12304], [-119.89078, 37.12311], [-119.8905, 37.12345], [-119.8899, 37.12361], [-119.88987, 37.12386], [-119.89073, 37.12416], [-119.89098, 37.12439], [-119.89096, 37.12448], [-119.89155, 37.12498], [-119.89183, 37.12518], [-119.89184, 37.1256], [-119.8932, 37.12699], [-119.89323, 37.12729], [-119.89292, 37.12738], [-119.89212, 37.12708], [-119.89078, 37.12681], [-119.89066, 37.12699], [-119.89089, 37.12738], [-119.89101, 37.12806], [-119.89166, 37.12836], [-119.89183, 37.1285], [-119.89183, 37.12864], [-119.89158, 37.12889], [-119.89158, 37.12912], [-119.89232, 37.12951], [-119.89263, 37.1298], [-119.89269, 37.13017], [-119.89183, 37.13006], [-119.8913, 37.12983], [-119.89126, 37.13047], [-119.891, 37.13049], [-119.89072, 37.13026], [-119.89069, 37.12983], [-119.89026, 37.12891], [-119.89006, 37.12875], [-119.88989, 37.12873], [-119.88966, 37.12889], [-119.8896, 37.12909], [-119.88949, 37.12918], [-119.88929, 37.12907], [-119.88903, 37.12831], [-119.88903, 37.12772], [-119.8888, 37.12742], [-119.88849, 37.1272], [-119.88832, 37.12717], [-119.88821, 37.12738], [-119.88866, 37.12784], [-119.88866, 37.12813], [-119.88849, 37.12841], [-119.88852, 37.12898], [-119.88829, 37.12912], [-119.88823, 37.12948], [-119.88792, 37.1295], [-119.88763, 37.12939], [-119.88746, 37.12891], [-119.88715, 37.12848], [-119.88712, 37.12809], [-119.88701, 37.128], [-119.88638, 37.12802], [-119.88618, 37.12808], [-119.8862, 37.12843], [-119.88672, 37.12898], [-119.88677, 37.12939], [-119.88589, 37.12991], [-119.88592, 37.13007], [-119.88706, 37.13012], [-119.88766, 37.13067], [-119.88777, 37.1309], [-119.88846, 37.1314], [-119.88846, 37.13149], [-119.88777, 37.13152], [-119.88655, 37.13147], [-119.88649, 37.13166], [-119.88683, 37.13209], [-119.88689, 37.1323], [-119.88643, 37.13232], [-119.88603, 37.13209], [-119.88586, 37.13177], [-119.88543, 37.1314], [-119.88475, 37.13113], [-119.88461, 37.13117], [-119.8846, 37.13156], [-119.88417, 37.13188], [-119.8834, 37.13195], [-119.88332, 37.13204], [-119.8836, 37.13273], [-119.88363, 37.13314], [-119.88337, 37.13335], [-119.88303, 37.13339], [-119.88246, 37.133], [-119.88194, 37.13282], [-119.88166, 37.13261], [-119.88146, 37.1326], [-119.88143, 37.13346], [-119.88183, 37.13396], [-119.88194, 37.1344], [-119.8826, 37.13492], [-119.88277, 37.13518], [-119.88406, 37.13575], [-119.88405, 37.13598], [-119.88388, 37.13614], [-119.88377, 37.13682], [-119.88343, 37.13689], [-119.88328, 37.13675], [-119.88323, 37.136], [-119.88285, 37.13575], [-119.88217, 37.13563], [-119.88106, 37.13529], [-119.88017, 37.13485], [-119.8794, 37.13465], [-119.87903, 37.1344], [-119.87865, 37.1344], [-119.87854, 37.13451], [-119.87865, 37.13481], [-119.87865, 37.1351], [-119.87826, 37.13565], [-119.87848, 37.13595], [-119.87834, 37.13616], [-119.87834, 37.13652], [-119.87908, 37.13691], [-119.87922, 37.13714], [-119.87917, 37.13728], [-119.87845, 37.13762], [-119.8782, 37.13789], [-119.87831, 37.13833], [-119.87797, 37.13861], [-119.8774, 37.13872], [-119.87725, 37.1386], [-119.87699, 37.13815], [-119.87685, 37.13755], [-119.87662, 37.13735], [-119.8764, 37.13728], [-119.87521, 37.1383], [-119.8751, 37.13881], [-119.87521, 37.13986], [-119.87581, 37.1405], [-119.87564, 37.14139], [-119.87576, 37.1416], [-119.87576, 37.1419], [-119.87553, 37.14203], [-119.87479, 37.14215], [-119.87459, 37.14233], [-119.87462, 37.1427], [-119.87513, 37.14359], [-119.87507, 37.14407], [-119.87496, 37.14414], [-119.87459, 37.14395], [-119.87373, 37.14327], [-119.87262, 37.14288], [-119.87242, 37.1429], [-119.87242, 37.14316], [-119.87307, 37.14368], [-119.87359, 37.14455], [-119.87382, 37.14473], [-119.87387, 37.14494], [-119.87367, 37.14498], [-119.87256, 37.14469], [-119.87228, 37.14478], [-119.8725, 37.1453], [-119.87256, 37.14608], [-119.8727, 37.14633], [-119.87253, 37.14663], [-119.8723, 37.14682], [-119.87165, 37.14704], [-119.8713, 37.14702], [-119.8713, 37.14672], [-119.87145, 37.14647], [-119.87145, 37.14583], [-119.87127, 37.1456], [-119.86987, 37.14471], [-119.86982, 37.14401], [-119.86956, 37.14387], [-119.86861, 37.1438], [-119.86847, 37.14394], [-119.86841, 37.1446], [-119.86819, 37.14492], [-119.86767, 37.14494], [-119.86753, 37.14476], [-119.86753, 37.14432], [-119.86721, 37.14414], [-119.86693, 37.14412], [-119.86673, 37.14428], [-119.8667, 37.14457], [-119.86696, 37.14487], [-119.86704, 37.1451], [-119.86662, 37.14515], [-119.86547, 37.14506], [-119.86464, 37.14423], [-119.86344, 37.14421], [-119.86281, 37.14408], [-119.86244, 37.14417], [-119.86176, 37.14487], [-119.86107, 37.14513], [-119.86059, 37.14543], [-119.86053, 37.14576], [-119.8607, 37.14593], [-119.8607, 37.14689], [-119.86096, 37.14721], [-119.86101, 37.14748], [-119.86061, 37.14778], [-119.8603, 37.14877], [-119.8597, 37.14989], [-119.85927, 37.15007], [-119.85859, 37.15016], [-119.8575, 37.14964], [-119.85679, 37.14977], [-119.85627, 37.14975], [-119.8565, 37.14934], [-119.85684, 37.14922], [-119.85747, 37.14918], [-119.85862, 37.14945], [-119.85887, 37.14927], [-119.85916, 37.14849], [-119.8589, 37.1471], [-119.85801, 37.14639], [-119.85753, 37.14586], [-119.85753, 37.14545], [-119.85818, 37.14542], [-119.85833, 37.14533], [-119.85876, 37.1444], [-119.85973, 37.14334], [-119.86004, 37.14314], [-119.86167, 37.143], [-119.86213, 37.14289], [-119.86304, 37.14236], [-119.86347, 37.14188], [-119.86347, 37.14154], [-119.86264, 37.14126], [-119.86261, 37.14112], [-119.86324, 37.14071], [-119.86404, 37.14062], [-119.8643, 37.14044], [-119.86432, 37.14014], [-119.86413, 37.13996], [-119.86395, 37.13966], [-119.86392, 37.13897], [-119.86367, 37.13883], [-119.8633, 37.13874], [-119.86315, 37.13863], [-119.86327, 37.13815], [-119.86327, 37.13769], [-119.86318, 37.13762], [-119.86318, 37.13714], [-119.86338, 37.13701], [-119.86378, 37.13705], [-119.86492, 37.13778], [-119.86555, 37.13803], [-119.86621, 37.1376], [-119.86621, 37.13741], [-119.86561, 37.13703], [-119.86569, 37.1365], [-119.86538, 37.13623], [-119.86538, 37.13588], [-119.86518, 37.13574], [-119.86512, 37.13547], [-119.86532, 37.13533], [-119.86558, 37.13529], [-119.86587, 37.1354], [-119.86644, 37.13549], [-119.86729, 37.13593], [-119.86775, 37.13593], [-119.86835, 37.13579], [-119.86881, 37.13586], [-119.86904, 37.13609], [-119.86904, 37.137], [-119.8693, 37.13723], [-119.86967, 37.1373], [-119.86978, 37.13702], [-119.87004, 37.13673], [-119.87078, 37.13642], [-119.87081, 37.13611], [-119.87073, 37.13604], [-119.86992, 37.13579], [-119.86984, 37.13554], [-119.86955, 37.13533], [-119.86898, 37.13522], [-119.86858, 37.13499], [-119.86846, 37.13478], [-119.86789, 37.13439], [-119.86787, 37.13414], [-119.86812, 37.13403], [-119.86932, 37.13398], [-119.86955, 37.13405], [-119.87015, 37.13414], [-119.87035, 37.13393], [-119.87038, 37.13352], [-119.86949, 37.13298], [-119.86949, 37.13282], [-119.86941, 37.13279], [-119.86935, 37.13181], [-119.86881, 37.13195], [-119.86872, 37.13172], [-119.86829, 37.13142], [-119.86829, 37.13126], [-119.86869, 37.13076], [-119.8688, 37.13048], [-119.86852, 37.13016], [-119.86818, 37.13014], [-119.86797, 37.13023], [-119.86743, 37.13087], [-119.86709, 37.13099], [-119.86692, 37.13087], [-119.86709, 37.1303], [-119.867, 37.12998], [-119.86681, 37.12973], [-119.86538, 37.12913], [-119.86532, 37.12884], [-119.8646, 37.12831], [-119.86437, 37.12808], [-119.86437, 37.12785], [-119.86503, 37.12779], [-119.86531, 37.12769], [-119.86552, 37.12747], [-119.86597, 37.12751], [-119.8662, 37.12744], [-119.8662, 37.12721], [-119.86555, 37.12664], [-119.86549, 37.12593], [-119.86532, 37.12566], [-119.86526, 37.12529], [-119.86614, 37.12529], [-119.86663, 37.12511], [-119.8674, 37.12531], [-119.86846, 37.12604], [-119.86926, 37.12629], [-119.86968, 37.12625], [-119.86977, 37.12616], [-119.86977, 37.1254], [-119.87015, 37.12545], [-119.87066, 37.12533], [-119.871, 37.12515], [-119.87092, 37.12445], [-119.87101, 37.12427], [-119.87144, 37.12401], [-119.87195, 37.12417], [-119.87261, 37.12479], [-119.87261, 37.12495], [-119.87272, 37.12531], [-119.87303, 37.12545], [-119.87357, 37.12513], [-119.87506, 37.12481], [-119.87546, 37.12454], [-119.87595, 37.1241], [-119.8767, 37.12365], [-119.87687, 37.12344], [-119.8769, 37.12248], [-119.87701, 37.12235], [-119.87701, 37.12211], [-119.87557, 37.12106], [-119.8748, 37.1209], [-119.87457, 37.12115], [-119.87449, 37.12152], [-119.87429, 37.12154], [-119.87406, 37.12125], [-119.87369, 37.12101], [-119.87366, 37.12086], [-119.87432, 37.12054], [-119.87452, 37.12024], [-119.87452, 37.1198], [-119.87489, 37.11934], [-119.87497, 37.11907], [-119.87517, 37.11889], [-119.87597, 37.11856], [-119.87594, 37.11825], [-119.87577, 37.11806], [-119.87503, 37.11806], [-119.87477, 37.11772], [-119.87465, 37.11674], [-119.87406, 37.11701], [-119.8738, 37.11694], [-119.8738, 37.1163], [-119.8736, 37.11614], [-119.87323, 37.11632], [-119.87314, 37.11671], [-119.87286, 37.11699], [-119.87277, 37.11729], [-119.87271, 37.11793], [-119.87237, 37.11795], [-119.87214, 37.11774], [-119.87169, 37.11763], [-119.87169, 37.11681], [-119.87183, 37.11649], [-119.87171, 37.11637], [-119.87154, 37.11642], [-119.87109, 37.11683], [-119.87089, 37.11729], [-119.87069, 37.11747], [-119.87066, 37.1177], [-119.87143, 37.11823], [-119.87143, 37.11861], [-119.87123, 37.11884], [-119.87086, 37.11882], [-119.87075, 37.11896], [-119.87069, 37.11946], [-119.87026, 37.11955], [-119.87003, 37.1193], [-119.86994, 37.11896], [-119.86966, 37.11857], [-119.86966, 37.11821], [-119.8694, 37.11805], [-119.86826, 37.1183], [-119.86817, 37.11823], [-119.86823, 37.11786], [-119.86837, 37.11763], [-119.86846, 37.11678], [-119.86866, 37.11637], [-119.86928, 37.11566], [-119.86931, 37.11543], [-119.86903, 37.11514], [-119.86903, 37.11502], [-119.86863, 37.1148], [-119.86866, 37.11452], [-119.86908, 37.11418], [-119.86914, 37.11381], [-119.86957, 37.11322], [-119.86954, 37.11246], [-119.86968, 37.11237], [-119.86994, 37.11239], [-119.87008, 37.11264], [-119.87008, 37.11308], [-119.87043, 37.11335], [-119.87043, 37.11361], [-119.87028, 37.11381], [-119.87029, 37.11399], [-119.87066, 37.11408], [-119.87111, 37.11404], [-119.87157, 37.11379], [-119.8716, 37.11367], [-119.87257, 37.11292], [-119.87286, 37.1128], [-119.87305, 37.11257], [-119.87311, 37.11237], [-119.87348, 37.11212], [-119.87382, 37.11202], [-119.87382, 37.11175], [-119.87357, 37.11152], [-119.87357, 37.11141], [-119.87528, 37.1104], [-119.87545, 37.10996], [-119.87545, 37.10921], [-119.87556, 37.10905], [-119.87554, 37.10864], [-119.87499, 37.10836], [-119.87491, 37.10807], [-119.87416, 37.1074], [-119.87382, 37.10731], [-119.87297, 37.10727], [-119.87257, 37.10745], [-119.87253, 37.1077], [-119.87231, 37.10786], [-119.87165, 37.10809], [-119.87125, 37.10862], [-119.87085, 37.10882], [-119.87065, 37.1091], [-119.87068, 37.10948], [-119.87082, 37.10962], [-119.87077, 37.10985], [-119.87045, 37.11006], [-119.87048, 37.11045], [-119.87059, 37.11061], [-119.87057, 37.11081], [-119.86991, 37.11143], [-119.86971, 37.1115], [-119.86945, 37.11132], [-119.86931, 37.11134], [-119.86877, 37.11207], [-119.86845, 37.11228], [-119.86777, 37.11258], [-119.8676, 37.11335], [-119.8674, 37.1137], [-119.86726, 37.11349], [-119.86725, 37.11274], [-119.86791, 37.11187], [-119.86805, 37.11148], [-119.86819, 37.11013], [-119.86805, 37.10999], [-119.86794, 37.10951], [-119.86757, 37.10903], [-119.86745, 37.10871], [-119.86694, 37.10821], [-119.86696, 37.10784], [-119.86739, 37.10745], [-119.86745, 37.10695], [-119.86808, 37.1059], [-119.86808, 37.10576], [-119.86816, 37.10571], [-119.86828, 37.10521], [-119.86836, 37.10405], [-119.86762, 37.10324], [-119.8673, 37.10315], [-119.8665, 37.10304], [-119.86639, 37.10292], [-119.8665, 37.1026], [-119.86647, 37.10169], [-119.86667, 37.10169], [-119.86722, 37.10219], [-119.8685, 37.1026], [-119.87039, 37.10246], [-119.87084, 37.10274], [-119.87079, 37.10352], [-119.87065, 37.1037], [-119.8707, 37.10399], [-119.8711, 37.10416], [-119.8721, 37.10413], [-119.87216, 37.10409], [-119.87216, 37.10381], [-119.87199, 37.10335], [-119.8721, 37.10283], [-119.87242, 37.10283], [-119.87276, 37.10315], [-119.87282, 37.10335], [-119.87324, 37.10381], [-119.87359, 37.10383], [-119.87384, 37.10363], [-119.8739, 37.10326], [-119.8741, 37.10305], [-119.8741, 37.10276], [-119.8739, 37.10255], [-119.8739, 37.10216], [-119.8741, 37.10207], [-119.87439, 37.1021], [-119.87519, 37.1026], [-119.87533, 37.10287], [-119.87544, 37.10383], [-119.87556, 37.10406], [-119.87596, 37.10431], [-119.87648, 37.10491], [-119.87683, 37.10503], [-119.87745, 37.10487], [-119.87786, 37.10503], [-119.87914, 37.10519], [-119.88065, 37.10695], [-119.88302, 37.1091], [-119.88379, 37.10965], [-119.88428, 37.11013], [-119.88671, 37.11174], [-119.88999, 37.11356], [-119.89265, 37.11466], [-119.89347, 37.11533], [-119.89373, 37.11633], [-119.89419, 37.11668], [-119.89422, 37.11712], [-119.89476, 37.11757], [-119.8947, 37.11844], [-119.8943, 37.11851], [-119.8937, 37.11812], [-119.89341, 37.11766], [-119.89293, 37.11764], [-119.89222, 37.11741], [-119.89181, 37.11691], [-119.89164, 37.11691], [-119.89136, 37.11736], [-119.89113, 37.11734], [-119.89085, 37.11716], [-119.89076, 37.11697], [-119.89056, 37.11684], [-119.89008, 37.11677], [-119.88993, 37.11693], [-119.88999, 37.11732], [-119.89022, 37.11759], [-119.89127, 37.11782], [-119.89136, 37.11851], [-119.89196, 37.11897], [-119.89262, 37.11899], [-119.89265, 37.11927], [-119.89285, 37.1194], [-119.89381, 37.11963], [-119.89401, 37.12002], [-119.89424, 37.12011], [-119.89547, 37.1202]]]} | Open Access 1 | 16773 | Hensley Lake Recreation Area | 13560 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/HensleyLake.aspx | Madera 48 | 1669.293 | Hensley Lake Rec. Area | 0 | Recreation Management Area 49 | 4 |
| 16830 | 16830 | 16829 | {"type": "MultiPolygon", "coordinates": [[[[-119.94779, 37.25909], [-119.94775, 37.26382], [-119.94675, 37.26382], [-119.94674, 37.26483], [-119.94503, 37.26985], [-119.94097, 37.27313], [-119.94097, 37.27204], [-119.94087, 37.27203], [-119.94306, 37.26793], [-119.94208, 37.26436], [-119.94209, 37.26357], [-119.94315, 37.26357], [-119.94317, 37.2608], [-119.94466, 37.26018], [-119.94779, 37.25909]]], [[[-119.99489, 37.21396], [-119.99318, 37.2153], [-119.9937, 37.21564], [-119.99236, 37.21649], [-119.99222, 37.21684], [-119.99187, 37.21731], [-119.9913, 37.2177], [-119.99099, 37.21789], [-119.9909, 37.21838], [-119.99253, 37.22083], [-119.9918, 37.22084], [-119.99257, 37.22295], [-119.99243, 37.22356], [-119.99144, 37.22427], [-119.99121, 37.22454], [-119.99103, 37.2248], [-119.9907, 37.22633], [-119.9887, 37.22794], [-119.98861, 37.22798], [-119.9886, 37.23384], [-119.98853, 37.23386], [-119.98854, 37.23482], [-119.98821, 37.23507], [-119.97283, 37.24749], [-119.97278, 37.24744], [-119.97177, 37.24826], [-119.96593, 37.2482], [-119.96589, 37.24454], [-119.96377, 37.24454], [-119.96375, 37.2453], [-119.96138, 37.24534], [-119.96132, 37.24559], [-119.96135, 37.24559], [-119.96128, 37.24649], [-119.95538, 37.24648], [-119.95529, 37.24817], [-119.95206, 37.24814], [-119.95204, 37.24899], [-119.95, 37.24901], [-119.94997, 37.25445], [-119.95105, 37.25449], [-119.95106, 37.25626], [-119.94781, 37.25634], [-119.94779, 37.25891], [-119.94457, 37.26003], [-119.94317, 37.26061], [-119.94319, 37.25893], [-119.94266, 37.25893], [-119.94269, 37.25704], [-119.9432, 37.25704], [-119.94328, 37.24635], [-119.94775, 37.24641], [-119.94769, 37.24539], [-119.95098, 37.24542], [-119.951, 37.24457], [-119.95211, 37.24453], [-119.95216, 37.24259], [-119.95324, 37.24259], [-119.96301, 37.23349], [-119.96293, 37.22461], [-119.96158, 37.22456], [-119.96156, 37.21384], [-119.96165, 37.21383], [-119.96164, 37.20629], [-119.97387, 37.20627], [-119.97391, 37.2043], [-119.97962, 37.20427], [-119.97962, 37.20464], [-119.9803, 37.20465], [-119.98033, 37.20694], [-119.97963, 37.20695], [-119.97963, 37.20901], [-119.97984, 37.20938], [-119.98042, 37.20981], [-119.98113, 37.21004], [-119.98154, 37.21039], [-119.98192, 37.21082], [-119.98235, 37.21166], [-119.98252, 37.21206], [-119.98306, 37.21247], [-119.98353, 37.21254], [-119.98392, 37.21254], [-119.98448, 37.21241], [-119.986, 37.21198], [-119.9863, 37.21232], [-119.9857, 37.21268], [-119.9857, 37.21269], [-119.98621, 37.21304], [-119.98642, 37.21306], [-119.98711, 37.2134], [-119.98813, 37.21293], [-119.98936, 37.21197], [-119.98967, 37.21182], [-119.98995, 37.21178], [-119.99029, 37.21194], [-119.99038, 37.21207], [-119.9904, 37.21208], [-119.99081, 37.21297], [-119.99085, 37.21324], [-119.99118, 37.2137], [-119.99101, 37.21462], [-119.99168, 37.21469], [-119.99219, 37.2148], [-119.99306, 37.21425], [-119.99361, 37.21388], [-119.99396, 37.21354], [-119.99404, 37.21342], [-119.9943, 37.21342], [-119.99484, 37.21368], [-119.99489, 37.21396]], [[-119.95362, 37.24704], [-119.95362, 37.24702], [-119.95303, 37.247], [-119.95301, 37.24705], [-119.95362, 37.24704]]]]} | Open Access 1 | 44416 | Eastman Lake Recreation Area | 13556 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/EastmanLake.aspx | Madera 48 | 2968.721 | Eastman Lake Rec. Area | 0 | Recreation Management Area 49 | 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]);