units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1, COUNTY = 20 and DES_TP = 39
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 6 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1019 | 1019 | 1018 | {"type": "MultiPolygon", "coordinates": [[[[-116.08441, 33.28392], [-116.08407, 33.28397], [-116.08401, 33.28417], [-116.08389, 33.2844], [-116.0834, 33.28491], [-116.08318, 33.28498], [-116.08295, 33.28492], [-116.08274, 33.28483], [-116.08252, 33.28482], [-116.08231, 33.28494], [-116.08211, 33.28508], [-116.08206, 33.28519], [-116.08207, 33.2853], [-116.08193, 33.28546], [-116.08163, 33.28558], [-116.08139, 33.28572], [-116.08118, 33.28587], [-116.08119, 33.28605], [-116.08133, 33.28619], [-116.08143, 33.28638], [-116.08146, 33.2865], [-116.08142, 33.28663], [-116.0812, 33.28664], [-116.0809, 33.28655], [-116.0806, 33.28643], [-116.08032, 33.28626], [-116.08001, 33.28622], [-116.07969, 33.28629], [-116.07929, 33.28654], [-116.07906, 33.28677], [-116.07878, 33.28709], [-116.07864, 33.28715], [-116.07854, 33.28716], [-116.0784, 33.28714], [-116.07829, 33.28707], [-116.07793, 33.28668], [-116.07765, 33.28652], [-116.07735, 33.28642], [-116.07715, 33.28638], [-116.07703, 33.2864], [-116.07656, 33.28644], [-116.07634, 33.28657], [-116.07617, 33.28673], [-116.07592, 33.2868], [-116.07577, 33.2868], [-116.07562, 33.28676], [-116.07536, 33.28666], [-116.07504, 33.28658], [-116.0747, 33.28646], [-116.0746, 33.28648], [-116.07433, 33.28671], [-116.07425, 33.28685], [-116.07423, 33.28692], [-116.07419, 33.2873], [-116.07413, 33.28751], [-116.07399, 33.28766], [-116.07379, 33.28774], [-116.07349, 33.28772], [-116.0731, 33.28764], [-116.07255, 33.28741], [-116.07182, 33.28716], [-116.07152, 33.2871], [-116.07082, 33.28704], [-116.07018, 33.28705], [-116.07, 33.28709], [-116.06983, 33.28719], [-116.06975, 33.28728], [-116.06967, 33.28749], [-116.06955, 33.28762], [-116.06921, 33.28789], [-116.06903, 33.28797], [-116.06878, 33.28799], [-116.06806, 33.28795], [-116.06757, 33.28801], [-116.06691, 33.28802], [-116.06617, 33.28791], [-116.06511, 33.28755], [-116.0645, 33.28746], [-116.06425, 33.28751], [-116.06406, 33.28768], [-116.06393, 33.28814], [-116.0634, 33.28904], [-116.06369, 33.28917], [-116.064, 33.28926], [-116.06438, 33.28943], [-116.06463, 33.28962], [-116.06473, 33.28974], [-116.06485, 33.28994], [-116.06493, 33.29], [-116.06511, 33.29011], [-116.06523, 33.29012], [-116.06536, 33.29009], [-116.06552, 33.2901], [-116.06563, 33.29012], [-116.06571, 33.29015], [-116.06577, 33.29023], [-116.06581, 33.29033], [-116.06583, 33.29073], [-116.06586, 33.29084], [-116.06595, 33.29091], [-116.0661, 33.29094], [-116.0663, 33.29093], [-116.06647, 33.29089], [-116.06674, 33.29075], [-116.0668, 33.29077], [-116.06687, 33.29083], [-116.0669, 33.29094], [-116.0669, 33.29109], [-116.06685, 33.2912], [-116.06672, 33.29137], [-116.06664, 33.29156], [-116.06664, 33.2917], [-116.06666, 33.29178], [-116.06684, 33.29202], [-116.06691, 33.29214], [-116.06699, 33.2922], [-116.06711, 33.29225], [-116.06724, 33.29228], [-116.06734, 33.29226], [-116.06743, 33.2922], [-116.06759, 33.29204], [-116.06767, 33.29192], [-116.06774, 33.29185], [-116.06788, 33.29183], [-116.06799, 33.29187], [-116.06809, 33.29194], [-116.06814, 33.29202], [-116.06812, 33.29219], [-116.06813, 33.29227], [-116.06835, 33.29249], [-116.06846, 33.29253], [-116.06867, 33.29253], [-116.06872, 33.29257], [-116.06871, 33.29263], [-116.06868, 33.29268], [-116.06858, 33.29275], [-116.06816, 33.29289], [-116.0681, 33.29295], [-116.06807, 33.293], [-116.06807, 33.29311], [-116.06809, 33.2932], [-116.06815, 33.29329], [-116.06817, 33.29336], [-116.06813, 33.29345], [-116.06785, 33.29368], [-116.0678, 33.29379], [-116.06781, 33.294], [-116.06785, 33.29416], [-116.06796, 33.2943], [-116.0681, 33.29437], [-116.0682, 33.29436], [-116.06867, 33.29417], [-116.06887, 33.29414], [-116.06911, 33.29415], [-116.06918, 33.2942], [-116.0692, 33.29443], [-116.06923, 33.29455], [-116.06944, 33.29489], [-116.06961, 33.29498], [-116.06983, 33.29504], [-116.07, 33.2951], [-116.03214, 33.29505], [-116.03227, 33.30974], [-116.01474, 33.30969], [-116.01462, 33.29503], [-116.03214, 33.29504], [-116.03202, 33.28036], [-116.03185, 33.2657], [-116.0306, 33.26571], [-116.03061, 33.26989], [-116.02833, 33.26994], [-116.02787, 33.26992], [-116.0274, 33.26985], [-116.02709, 33.26977], [-116.02678, 33.26966], [-116.02585, 33.2693], [-116.0255, 33.26918], [-116.02516, 33.2691], [-116.02182, 33.26839], [-116.02152, 33.2683], [-116.02123, 33.2682], [-116.02095, 33.26807], [-116.02069, 33.26792], [-116.02039, 33.26772], [-116.02017, 33.26753], [-116.01996, 33.26733], [-116.01846, 33.2657], [-116.01426, 33.2657], [-116.01422, 33.26349], [-116.01369, 33.26342], [-116.00928, 33.26345], [-116.00527, 33.26345], [-116.00279, 33.26343], [-116.001, 33.26361], [-116.00013, 33.2638], [-115.99942, 33.26406], [-115.99778, 33.26474], [-115.99693, 33.26534], [-115.99668, 33.26549], [-115.99648, 33.25104], [-115.9789, 33.25103], [-115.97914, 33.23636], [-115.96144, 33.23615], [-115.96123, 33.22192], [-115.94365, 33.22077], [-115.94403, 33.23583], [-115.9324, 33.23588], [-115.923, 33.22625], [-115.92193, 33.22468], [-115.92011, 33.2209], [-115.91389, 33.20665], [-115.9265, 33.2068], [-115.92647, 33.19229], [-115.90917, 33.19208], [-115.90916, 33.19631], [-115.90728, 33.19205], [-115.90916, 33.19207], [-115.90919, 33.17758], [-115.89164, 33.17735], [-115.89163, 33.17736], [-115.89163, 33.17869], [-115.8897, 33.17732], [-115.89163, 33.17734], [-115.89163, 33.16839], [-115.88944, 33.16832], [-115.88944, 33.16653], [-115.89054, 33.16657], [-115.89054, 33.16746], [-115.89163, 33.16748], [-115.89163, 33.16482], [-115.89822, 33.16487], [-115.89824, 33.16307], [-115.90924, 33.16309], [-115.90902, 33.14864], [-115.89162, 33.14856], [-115.89163, 33.16305], [-115.87414, 33.16212], [-115.87415, 33.14761], [-115.86543, 33.1476], [-115.85925, 33.1342], [-115.87473, 33.1343], [-115.87416, 33.1476], [-115.8916, 33.14856], [-115.89161, 33.14855], [-115.892, 33.13427], [-115.90064, 33.13434], [-115.90929, 33.13434], [-115.90902, 33.14863], [-115.9263, 33.14875], [-115.92641, 33.16326], [-115.90925, 33.1631], [-115.90919, 33.17757], [-115.92644, 33.1778], [-115.92648, 33.19228], [-115.94363, 33.19249], [-115.94361, 33.17803], [-115.96085, 33.17826], [-115.96086, 33.17825], [-115.96084, 33.17551], [-115.96412, 33.17553], [-115.96413, 33.17645], [-115.96522, 33.17646], [-115.96523, 33.17829], [-115.96086, 33.17827], [-115.96097, 33.19269], [-115.94364, 33.19249], [-115.94363, 33.1925], [-115.94365, 33.20703], [-115.96112, 33.20733], [-115.96125, 33.22192], [-115.97896, 33.22196], [-115.97896, 33.21822], [-115.98327, 33.21826], [-115.98328, 33.21825], [-115.98325, 33.21459], [-115.97895, 33.21458], [-115.97893, 33.20745], [-115.98323, 33.2074], [-115.98324, 33.20922], [-115.98538, 33.2092], [-115.98538, 33.20829], [-115.98646, 33.20828], [-115.98647, 33.20919], [-115.98753, 33.20918], [-115.98753, 33.20736], [-115.99613, 33.20726], [-115.99588, 33.19266], [-115.97833, 33.19276], [-115.97835, 33.17836], [-115.96961, 33.17831], [-115.96958, 33.17466], [-115.96521, 33.17462], [-115.96518, 33.17279], [-115.96301, 33.17278], [-115.96301, 33.17369], [-115.9641, 33.1737], [-115.96411, 33.17462], [-115.96083, 33.17459], [-115.96077, 33.16542], [-115.96295, 33.16544], [-115.96294, 33.16361], [-115.97605, 33.16373], [-115.97606, 33.16465], [-115.97387, 33.16463], [-115.97389, 33.16737], [-115.96953, 33.16734], [-115.96955, 33.17098], [-115.97828, 33.17105], [-115.97829, 33.17104], [-115.97821, 33.16016], [-115.98255, 33.16015], [-115.98257, 33.16195], [-115.98476, 33.16196], [-115.98476, 33.16377], [-115.99125, 33.16379], [-115.99124, 33.16014], [-115.98693, 33.16014], [-115.98686, 33.15625], [-115.97818, 33.15611], [-115.97819, 33.14877], [-115.99553, 33.14906], [-115.99543, 33.1342], [-115.97822, 33.13409], [-115.97809, 33.12719], [-115.99536, 33.12712], [-115.99544, 33.13419], [-116.01264, 33.13412], [-116.01265, 33.13411], [-116.01257, 33.127], [-116.02991, 33.12635], [-116.04146, 33.12646], [-116.04143, 33.12814], [-116.04251, 33.12817], [-116.04252, 33.12816], [-116.04254, 33.12647], [-116.04361, 33.12648], [-116.04361, 33.12819], [-116.04468, 33.12822], [-116.04469, 33.12821], [-116.04469, 33.12649], [-116.04683, 33.12651], [-116.05529, 33.12637], [-116.05665, 33.12638], [-116.05737, 33.12647], [-116.05804, 33.1266], [-116.06375, 33.12794], [-116.06378, 33.13307], [-116.07241, 33.13297], [-116.07244, 33.13661], [-116.07675, 33.13656], [-116.07676, 33.13746], [-116.08085, 33.13742], [-116.08094, 33.14376], [-116.07892, 33.14379], [-116.07891, 33.14197], [-116.07677, 33.14201], [-116.07678, 33.14745], [-116.06389, 33.14766], [-116.06391, 33.15491], [-116.05562, 33.15526], [-116.05564, 33.1589], [-116.05565, 33.15891], [-116.06392, 33.15856], [-116.06394, 33.16219], [-116.08108, 33.1619], [-116.08107, 33.1764], [-116.08127, 33.19112], [-116.08276, 33.20646], [-116.08354, 33.22149], [-116.08416, 33.23639], [-116.06662, 33.23638], [-116.06683, 33.25103], [-116.08441, 33.25104], [-116.08441, 33.28392]], [[-115.96955, 33.171], [-115.96519, 33.17095], [-115.96519, 33.17278], [-115.96738, 33.17281], [-115.96739, 33.17372], [-115.96957, 33.17374], [-115.96955, 33.171]], [[-115.99631, 33.22187], [-115.97897, 33.22196], [-115.97915, 33.23636], [-115.99645, 33.23642], [-115.99631, 33.22187]], [[-115.99405, 33.21457], [-115.99406, 33.21456], [-115.99404, 33.21276], [-115.99189, 33.21278], [-115.9919, 33.21457], [-115.99405, 33.21457]], [[-116.01283, 33.14907], [-115.99554, 33.14907], [-115.99555, 33.15638], [-115.99558, 33.16013], [-115.99557, 33.16383], [-115.99565, 33.17102], [-116.00647, 33.17094], [-116.00637, 33.16379], [-116.00745, 33.16378], [-116.00756, 33.17093], [-116.01297, 33.17089], [-116.01293, 33.16911], [-116.00861, 33.16914], [-116.0086, 33.16825], [-116.01075, 33.16824], [-116.01076, 33.16822], [-116.01074, 33.16734], [-116.00858, 33.16735], [-116.00853, 33.16378], [-116.01285, 33.16375], [-116.01281, 33.1619], [-116.01283, 33.14907]], [[-115.99588, 33.19265], [-116.0133, 33.19248], [-116.01309, 33.17804], [-115.99572, 33.17822], [-115.99588, 33.19265]], [[-116.01375, 33.22176], [-116.01376, 33.22175], [-116.01353, 33.20711], [-115.99613, 33.20728], [-115.99631, 33.22185], [-116.01375, 33.22176]], [[-115.99648, 33.25102], [-116.01407, 33.25103], [-116.01399, 33.23642], [-115.99646, 33.23643], [-115.99648, 33.25102]], [[-116.03091, 33.20692], [-116.03091, 33.20654], [-116.03067, 33.19222], [-116.01331, 33.19249], [-116.01341, 33.19979], [-116.00906, 33.19984], [-116.00909, 33.20166], [-116.01126, 33.20164], [-116.0113, 33.20347], [-116.01347, 33.20345], [-116.01354, 33.2071], [-116.03091, 33.20692]], [[-116.03035, 33.14894], [-116.03036, 33.14892], [-116.02992, 33.13391], [-116.02099, 33.13388], [-116.01266, 33.13412], [-116.01284, 33.14906], [-116.03035, 33.14894]], [[-116.01399, 33.23641], [-116.03154, 33.2364], [-116.03122, 33.22166], [-116.01376, 33.22176], [-116.01399, 33.23641]], [[-116.01795, 33.21073], [-116.01794, 33.21074], [-116.01807, 33.21806], [-116.02242, 33.21804], [-116.02229, 33.21069], [-116.01795, 33.21073]], [[-116.04723, 33.14834], [-116.04722, 33.14833], [-116.0388, 33.14863], [-116.03859, 33.1449], [-116.03447, 33.14503], [-116.03458, 33.14878], [-116.03036, 33.14894], [-116.03051, 33.15603], [-116.03062, 33.15992], [-116.02838, 33.15995], [-116.02841, 33.16188], [-116.03067, 33.16187], [-116.03074, 33.16383], [-116.04741, 33.16296], [-116.04723, 33.14834]], [[-116.03751, 33.21239], [-116.03752, 33.21238], [-116.03747, 33.21054], [-116.03531, 33.21056], [-116.03522, 33.20687], [-116.03092, 33.20692], [-116.031, 33.2106], [-116.03315, 33.21058], [-116.0332, 33.21243], [-116.03751, 33.21239]], [[-116.03107, 33.2161], [-116.03328, 33.21612], [-116.03543, 33.2161], [-116.0354, 33.21426], [-116.03108, 33.21429], [-116.03107, 33.2161]], [[-116.03122, 33.22165], [-116.0334, 33.22165], [-116.03331, 33.21796], [-116.03115, 33.21798], [-116.03122, 33.22165]], [[-116.03165, 33.25103], [-116.04924, 33.25104], [-116.04907, 33.23638], [-116.03155, 33.2364], [-116.03165, 33.25103]], [[-116.03446, 33.14503], [-116.03442, 33.14316], [-116.03231, 33.14323], [-116.03236, 33.1451], [-116.03446, 33.14503]], [[-116.03694, 33.17053], [-116.03695, 33.16879], [-116.03486, 33.16888], [-116.03485, 33.1706], [-116.03694, 33.17053]], [[-116.03545, 33.2161], [-116.03544, 33.21611], [-116.03549, 33.21794], [-116.03765, 33.21793], [-116.03761, 33.21609], [-116.03545, 33.2161]], [[-116.03761, 33.21607], [-116.03977, 33.21606], [-116.03968, 33.21237], [-116.03752, 33.21239], [-116.03761, 33.21607]], [[-116.0425, 33.1299], [-116.04141, 33.12986], [-116.04139, 33.13084], [-116.04029, 33.13083], [-116.0402, 33.13385], [-116.04243, 33.13374], [-116.0425, 33.1299]], [[-116.0414, 33.12986], [-116.04141, 33.12985], [-116.04143, 33.12815], [-116.04035, 33.12812], [-116.04031, 33.12982], [-116.0414, 33.12986]], [[-116.0436, 33.12821], [-116.04252, 33.12818], [-116.0425, 33.12989], [-116.04468, 33.12995], [-116.04469, 33.12909], [-116.0436, 33.12906], [-116.0436, 33.12821]], [[-116.06387, 33.14766], [-116.06383, 33.14033], [-116.06599, 33.1403], [-116.06598, 33.13851], [-116.06382, 33.13851], [-116.06377, 33.13307], [-116.04692, 33.13353], [-116.04723, 33.14833], [-116.06387, 33.14766]], [[-116.06116, 33.2103], [-116.06117, 33.21029], [-116.061, 33.20657], [-116.05672, 33.20662], [-116.05687, 33.21034], [-116.06116, 33.2103]], [[-116.07395, 33.20648], [-116.07396, 33.20647], [-116.07364, 33.20268], [-116.06936, 33.20271], [-116.06963, 33.2065], [-116.07395, 33.20648]]], [[[-115.94595, 33.13068], [-115.9438, 33.13067], [-115.9438, 33.1343], [-115.93949, 33.13432], [-115.93943, 33.13794], [-115.94158, 33.13794], [-115.94146, 33.1434], [-115.93932, 33.14339], [-115.93928, 33.1452], [-115.94357, 33.14523], [-115.9435, 33.14886], [-115.93922, 33.14884], [-115.93923, 33.14702], [-115.93496, 33.147], [-115.93498, 33.14519], [-115.92638, 33.14515], [-115.92642, 33.14335], [-115.92857, 33.14334], [-115.92858, 33.14245], [-115.92644, 33.14244], [-115.9265, 33.13974], [-115.92757, 33.13974], [-115.92761, 33.13794], [-115.92868, 33.13793], [-115.92876, 33.13433], [-115.93001, 33.13432], [-115.92999, 33.12706], [-115.94379, 33.12703], [-115.94595, 33.12706], [-115.94595, 33.13068]], [[-115.93083, 33.13795], [-115.93082, 33.13794], [-115.92869, 33.13794], [-115.92861, 33.14155], [-115.93075, 33.14155], [-115.93083, 33.13795]], [[-115.93724, 33.13976], [-115.93723, 33.13975], [-115.93509, 33.13975], [-115.93517, 33.13613], [-115.93519, 33.13432], [-115.93091, 33.13433], [-115.93084, 33.13794], [-115.93298, 33.13794], [-115.93291, 33.14156], [-115.93076, 33.14155], [-115.93074, 33.14246], [-115.92967, 33.14246], [-115.92964, 33.14335], [-115.93502, 33.14337], [-115.93499, 33.14518], [-115.93712, 33.14519], [-115.93716, 33.14338], [-115.93931, 33.14338], [-115.93935, 33.14157], [-115.9372, 33.14157], [-115.93724, 33.13976]], [[-115.93943, 33.13795], [-115.93942, 33.13794], [-115.93728, 33.13794], [-115.93724, 33.13975], [-115.93939, 33.13975], [-115.93943, 33.13795]]], [[[-115.92865, 33.13343], [-115.92797, 33.13343], [-115.92794, 33.12706], [-115.92862, 33.12706], [-115.92865, 33.13343]]], [[[-115.93178, 33.17787], [-115.92854, 33.17783], [-115.92855, 33.17601], [-115.93178, 33.17605], [-115.93178, 33.17787]]], [[[-115.93932, 33.17429], [-115.93716, 33.17427], [-115.93714, 33.17336], [-115.93502, 33.17334], [-115.93501, 33.17425], [-115.9307, 33.17422], [-115.9307, 33.1724], [-115.92962, 33.17238], [-115.92962, 33.17148], [-115.92855, 33.17146], [-115.92855, 33.17055], [-115.9307, 33.17058], [-115.9307, 33.17239], [-115.93286, 33.17244], [-115.93285, 33.1706], [-115.935, 33.17062], [-115.93501, 33.16972], [-115.93285, 33.16969], [-115.93285, 33.16696], [-115.935, 33.16698], [-115.93501, 33.1688], [-115.93607, 33.16882], [-115.93608, 33.17063], [-115.93715, 33.17065], [-115.93716, 33.17245], [-115.93931, 33.17248], [-115.93932, 33.17429]]], [[[-115.93931, 33.16523], [-115.93716, 33.16518], [-115.93715, 33.16519], [-115.93715, 33.16609], [-115.93929, 33.16612], [-115.9393, 33.16703], [-115.93715, 33.167], [-115.93714, 33.16609], [-115.935, 33.16607], [-115.935, 33.16516], [-115.93715, 33.16518], [-115.93716, 33.16336], [-115.93931, 33.16338], [-115.93931, 33.16523]]], [[[-115.93565, 33.17703], [-115.93565, 33.17784], [-115.93532, 33.17784], [-115.93533, 33.17703], [-115.93565, 33.17703]]], [[[-115.93619, 33.17704], [-115.93618, 33.17785], [-115.93608, 33.17785], [-115.93608, 33.17704], [-115.93619, 33.17704]]], [[[-115.9364, 33.17704], [-115.9364, 33.17785], [-115.93629, 33.17785], [-115.93629, 33.17704], [-115.9364, 33.17704]]], [[[-115.93673, 33.17704], [-115.93672, 33.17785], [-115.93662, 33.17785], [-115.93662, 33.17704], [-115.93673, 33.17704]]], [[[-115.93856, 33.17707], [-115.93855, 33.17788], [-115.93834, 33.17787], [-115.93834, 33.17707], [-115.93812, 33.17706], [-115.93813, 33.17625], [-115.93845, 33.17626], [-115.93845, 33.17706], [-115.93856, 33.17707]]], [[[-115.94134, 33.17431], [-115.94134, 33.17468], [-115.93945, 33.17466], [-115.93945, 33.17439], [-115.94039, 33.1744], [-115.9404, 33.1743], [-115.94134, 33.17431]]], [[[-115.93974, 33.17708], [-115.93974, 33.17789], [-115.93963, 33.17789], [-115.93963, 33.17708], [-115.93974, 33.17708]]], [[[-115.94359, 33.16889], [-115.94252, 33.16889], [-115.94252, 33.17071], [-115.94145, 33.17069], [-115.94144, 33.16888], [-115.94037, 33.16886], [-115.94037, 33.16704], [-115.94198, 33.16706], [-115.94199, 33.16797], [-115.94252, 33.16797], [-115.94252, 33.16706], [-115.94359, 33.16707], [-115.94359, 33.16889]]], [[[-115.94134, 33.17551], [-115.94134, 33.1756], [-115.9404, 33.17559], [-115.9404, 33.1755], [-115.94134, 33.17551]]], [[[-115.94134, 33.17477], [-115.94134, 33.17496], [-115.9404, 33.17495], [-115.9404, 33.17476], [-115.94134, 33.17477]]], [[[-115.94168, 33.17629], [-115.94167, 33.17792], [-115.94157, 33.17792], [-115.94157, 33.17711], [-115.94146, 33.1771], [-115.94146, 33.17629], [-115.94168, 33.17629]]], [[[-115.94265, 33.17712], [-115.94264, 33.17793], [-115.94232, 33.17793], [-115.94232, 33.17712], [-115.94265, 33.17712]]], [[[-115.94286, 33.17712], [-115.94286, 33.17793], [-115.94275, 33.17793], [-115.94275, 33.17712], [-115.94286, 33.17712]]], [[[-115.94351, 33.17713], [-115.9435, 33.17794], [-115.94329, 33.17794], [-115.94329, 33.17713], [-115.94351, 33.17713]]], [[[-115.94567, 33.15253], [-115.94352, 33.15251], [-115.94351, 33.15069], [-115.94566, 33.15071], [-115.94567, 33.15253]]], [[[-115.95002, 33.16348], [-115.94466, 33.16343], [-115.94465, 33.16161], [-115.94551, 33.16161], [-115.9455, 33.1598], [-115.94571, 33.1598], [-115.94571, 33.1589], [-115.94356, 33.15887], [-115.94354, 33.15615], [-115.94569, 33.15616], [-115.94568, 33.15435], [-115.94783, 33.15437], [-115.94784, 33.15618], [-115.94999, 33.15621], [-115.95002, 33.16348]], [[-115.94891, 33.15802], [-115.94892, 33.15801], [-115.94892, 33.15711], [-115.94785, 33.1571], [-115.94785, 33.158], [-115.94891, 33.15802]]], [[[-115.95857, 33.15447], [-115.95643, 33.15445], [-115.95641, 33.15263], [-115.95213, 33.15259], [-115.95212, 33.1526], [-115.95213, 33.15441], [-115.94998, 33.15439], [-115.94997, 33.15257], [-115.94782, 33.15255], [-115.94781, 33.14891], [-115.94996, 33.14893], [-115.94998, 33.15257], [-115.95212, 33.15258], [-115.95211, 33.14895], [-115.95641, 33.14899], [-115.95642, 33.15263], [-115.95857, 33.15265], [-115.95857, 33.15447]]], [[[-115.95242, 33.1307], [-115.95027, 33.1307], [-115.95026, 33.1298], [-115.94811, 33.12978], [-115.94811, 33.12798], [-115.95026, 33.12799], [-115.95026, 33.12709], [-115.95241, 33.12711], [-115.95242, 33.1307]]], [[[-115.96075, 33.16359], [-115.95217, 33.1635], [-115.95214, 33.15621], [-115.96073, 33.1563], [-115.96075, 33.16359]]], [[[-115.95469, 33.13437], [-115.95242, 33.13429], [-115.95242, 33.1334], [-115.95468, 33.13348], [-115.95469, 33.13437]]], [[[-115.95687, 33.12897], [-115.95576, 33.12896], [-115.95574, 33.12805], [-115.95685, 33.12806], [-115.95687, 33.12897]]], [[[-115.95922, 33.13453], [-115.95696, 33.13445], [-115.95693, 33.13263], [-115.95918, 33.1327], [-115.95922, 33.13453]]], [[[-115.96974, 33.13799], [-115.96969, 33.1398], [-115.96757, 33.13986], [-115.96763, 33.13805], [-115.96552, 33.1381], [-115.96537, 33.14171], [-115.96323, 33.14177], [-115.96289, 33.149], [-115.96071, 33.14903], [-115.9611, 33.14181], [-115.96323, 33.14175], [-115.9634, 33.13816], [-115.96129, 33.13817], [-115.96149, 33.13461], [-115.96357, 33.13454], [-115.96341, 33.13815], [-115.96552, 33.1381], [-115.96566, 33.13448], [-115.96775, 33.13442], [-115.96763, 33.13804], [-115.96974, 33.13799]]], [[[-115.96732, 33.14712], [-115.96726, 33.14894], [-115.96507, 33.14897], [-115.96515, 33.14716], [-115.96732, 33.14712]]], [[[-115.96739, 33.1453], [-115.96735, 33.14621], [-115.96627, 33.14623], [-115.96631, 33.14532], [-115.96739, 33.1453]]], [[[-115.97385, 33.14701], [-115.97382, 33.14884], [-115.97054, 33.14889], [-115.97058, 33.14706], [-115.97385, 33.14701]]], [[[-115.97976, 33.27418], [-115.97931, 33.27418], [-115.97931, 33.27393], [-115.97976, 33.27392], [-115.97976, 33.27418]]], [[[-115.98368, 33.27676], [-115.9836, 33.27703], [-115.98346, 33.27709], [-115.98313, 33.27686], [-115.98316, 33.27681], [-115.98315, 33.27676], [-115.98358, 33.27662], [-115.98368, 33.27676]]], [[[-115.98508, 33.27315], [-115.98491, 33.27334], [-115.98457, 33.27314], [-115.98473, 33.27295], [-115.98508, 33.27315]]], [[[-115.99715, 33.28264], [-115.9972, 33.28264], [-116.00013, 33.2838], [-116.00017, 33.28383], [-116.00017, 33.28386], [-115.99969, 33.28434], [-115.99965, 33.28436], [-115.99713, 33.28409], [-115.9971, 33.28406], [-115.99708, 33.28402], [-115.99706, 33.28271], [-115.99709, 33.28266], [-115.99715, 33.28264]]], [[[-116.00057, 33.29269], [-116.00065, 33.29273], [-116.00225, 33.2948], [-116.00226, 33.29485], [-116.00224, 33.2949], [-116.00216, 33.29493], [-116.00089, 33.29493], [-116.00085, 33.29491], [-115.99951, 33.29344], [-115.99949, 33.29338], [-115.99952, 33.29333], [-116.00051, 33.2927], [-116.00057, 33.29269]]], [[[-116.00099, 33.28335], [-116.00104, 33.28336], [-116.00359, 33.28556], [-116.0036, 33.28562], [-116.00358, 33.28566], [-116.00339, 33.28583], [-116.00308, 33.28616], [-116.00303, 33.28618], [-116.00297, 33.28617], [-115.99989, 33.28445], [-115.99988, 33.28441], [-115.9999, 33.28439], [-116.00095, 33.28336], [-116.00099, 33.28335]]], [[[-116.01002, 33.29163], [-116.01007, 33.29165], [-116.01009, 33.29168], [-116.01028, 33.29484], [-116.01024, 33.2949], [-116.01019, 33.29492], [-116.00941, 33.29491], [-116.00936, 33.29489], [-116.00933, 33.29484], [-116.00928, 33.29181], [-116.00929, 33.29177], [-116.00932, 33.29175], [-116.00955, 33.29173], [-116.01002, 33.29163]]], [[[-116.01037, 33.28343], [-116.01044, 33.28345], [-116.01227, 33.28506], [-116.01229, 33.2851], [-116.01227, 33.28513], [-116.01224, 33.28515], [-116.01025, 33.28567], [-116.01021, 33.28567], [-116.01017, 33.28565], [-116.01008, 33.28528], [-116.01002, 33.28511], [-116.00991, 33.28491], [-116.0094, 33.28407], [-116.00939, 33.28403], [-116.00943, 33.28397], [-116.00966, 33.28386], [-116.01002, 33.28365], [-116.01031, 33.28345], [-116.01037, 33.28343]]], [[[-116.02432, 33.27562], [-116.02408, 33.27578], [-116.02341, 33.27629], [-116.02067, 33.27373], [-116.02165, 33.27299], [-116.02384, 33.27503], [-116.02402, 33.27523], [-116.02432, 33.27562]]], [[[-116.02329, 33.28036], [-116.02149, 33.28036], [-116.02069, 33.27864], [-116.02246, 33.27806], [-116.02322, 33.27973], [-116.02328, 33.28002], [-116.02329, 33.28036]]]]} | Open Access 1 | 6307 | Ocotillo Wells State Vehicular Recreation Area | 13771 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://ohv.parks.ca.gov/?page_id=1217 | Imperial 20 | 38510.826 | Ocotillo Wells SVRA | 1976 | State Recreation Area 39 | 4 |
| 3284 | 3284 | 3283 | {"type": "Polygon", "coordinates": [[[-114.722, 33.08954], [-114.70844, 33.08952], [-114.70802, 33.08874], [-114.70769, 33.08819], [-114.70696, 33.08728], [-114.70612, 33.08661], [-114.70461, 33.08633], [-114.7046, 33.08105], [-114.71315, 33.08099], [-114.71309, 33.075], [-114.72176, 33.07503], [-114.722, 33.08954]]]} | Open Access 1 | 23367 | Colorado River Access | 32132 | 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 | Imperial 20 | 488.822 | Colorado River Access | 0 | State Recreation Area 39 | 4 | |
| 5738 | 5738 | 5737 | {"type": "Polygon", "coordinates": [[[-115.39721, 32.70888], [-115.3965, 32.71603], [-115.39651, 32.72278], [-115.39116, 32.72283], [-115.38802, 32.73027], [-115.38802, 32.73065], [-115.38463, 32.73065], [-115.38568, 32.72835], [-115.38577, 32.72807], [-115.38586, 32.72762], [-115.38709, 32.72343], [-115.38805, 32.72342], [-115.38806, 32.72285], [-115.38725, 32.72285], [-115.38738, 32.72244], [-115.38807, 32.72065], [-115.38808, 32.71976], [-115.38837, 32.71975], [-115.38893, 32.71803], [-115.3902, 32.71249], [-115.39188, 32.70941], [-115.39232, 32.70913], [-115.39232, 32.70888], [-115.39721, 32.70888]]]} | Open Access 1 | 1634 | Heber Dunes State Vehicular Recreation Area | 1560 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=408 | Imperial 20 | 325.49 | Heber Dunes SVRA | 1998 | State Recreation Area 39 | 4 |
| 6935 | 6935 | 6934 | {"type": "MultiPolygon", "coordinates": [[[[-115.77784, 33.37562], [-115.77783, 33.38352], [-115.76941, 33.38359], [-115.76938, 33.38358], [-115.7695, 33.37556], [-115.77784, 33.37562]]], [[[-115.79478, 33.39803], [-115.7868, 33.39803], [-115.78673, 33.39007], [-115.79427, 33.39009], [-115.79478, 33.39803]]], [[[-115.83439, 33.41435], [-115.82239, 33.41444], [-115.82236, 33.41239], [-115.81797, 33.41239], [-115.81311, 33.40829], [-115.82216, 33.40829], [-115.82237, 33.41239], [-115.83432, 33.4122], [-115.83439, 33.41435]]]]} | Open Access 1 | 5844 | Salton Sea State Recreation Area | 13840 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/default.asp?page_id=639 | Imperial 20 | 462.442 | Salton Sea SRA | 1951 | State Recreation Area 39 | 4 |
| 16648 | 16648 | 16647 | {"type": "Polygon", "coordinates": [[[-114.69597, 33.07013], [-114.68771, 33.07016], [-114.68736, 33.07012], [-114.68589, 33.07012], [-114.68438, 33.06864], [-114.68426, 33.06832], [-114.68389, 33.06799], [-114.68248, 33.06652], [-114.67977, 33.06328], [-114.6772, 33.06053], [-114.67638, 33.05983], [-114.67416, 33.05732], [-114.67397, 33.05664], [-114.674, 33.05602], [-114.67398, 33.05576], [-114.67403, 33.05464], [-114.67403, 33.05407], [-114.67454, 33.05221], [-114.67493, 33.0512], [-114.67499, 33.04875], [-114.67519, 33.048], [-114.67498, 33.04628], [-114.67479, 33.04557], [-114.67449, 33.04488], [-114.67266, 33.04188], [-114.67185, 33.04078], [-114.67141, 33.03993], [-114.67104, 33.03939], [-114.66985, 33.03811], [-114.66746, 33.03645], [-114.66535, 33.03521], [-114.66218, 33.03352], [-114.66166, 33.03339], [-114.6603, 33.03326], [-114.65949, 33.03343], [-114.65894, 33.03363], [-114.65847, 33.03386], [-114.65793, 33.03429], [-114.65724, 33.03504], [-114.65578, 33.03633], [-114.65457, 33.03833], [-114.65375, 33.03943], [-114.65307, 33.04009], [-114.65171, 33.04258], [-114.65084, 33.04482], [-114.64917, 33.04731], [-114.64775, 33.04871], [-114.64729, 33.04905], [-114.64642, 33.04907], [-114.64533, 33.04913], [-114.64424, 33.04884], [-114.64313, 33.04828], [-114.64275, 33.04804], [-114.64227, 33.04759], [-114.64074, 33.04669], [-114.64002, 33.04604], [-114.63959, 33.0458], [-114.63888, 33.04528], [-114.63683, 33.04321], [-114.63621, 33.04219], [-114.63559, 33.04147], [-114.6334, 33.03835], [-114.6324, 33.03647], [-114.63108, 33.03458], [-114.62921, 33.03243], [-114.62719, 33.03035], [-114.62662, 33.02994], [-114.62578, 33.02966], [-114.62542, 33.02949], [-114.62466, 33.02906], [-114.62331, 33.02867], [-114.62181, 33.02828], [-114.62002, 33.02788], [-114.61848, 33.02748], [-114.61766, 33.02729], [-114.6163, 33.02712], [-114.61536, 33.02704], [-114.6144, 33.02702], [-114.61424, 33.02703], [-114.61286, 33.02678], [-114.61163, 33.02673], [-114.61127, 33.02668], [-114.60978, 33.02639], [-114.60829, 33.0262], [-114.60479, 33.02582], [-114.60026, 33.02573], [-114.59884, 33.02584], [-114.59769, 33.0258], [-114.59544, 33.02593], [-114.59334, 33.02622], [-114.59255, 33.02614], [-114.59107, 33.02645], [-114.59106, 33.02259], [-114.5907, 33.02257], [-114.59069, 33.00798], [-114.62574, 33.00801], [-114.62575, 33.02256], [-114.62576, 33.02257], [-114.64343, 33.02254], [-114.66088, 33.02259], [-114.66089, 33.00798], [-114.69562, 33.0081], [-114.6956, 33.03705], [-114.69576, 33.05181], [-114.69596, 33.06648], [-114.69597, 33.07013]]]} | Open Access 1 | 5750 | Picacho State Recreation Area | 13835 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=641 | Imperial 20 | 7510.524 | Picacho SRA | 1960 | State Recreation Area 39 | 4 |
| 16691 | 16691 | 16690 | {"type": "MultiPolygon", "coordinates": [[[[-116.08108, 33.1619], [-116.06393, 33.16219], [-116.06388, 33.14767], [-116.06387, 33.14766], [-116.04723, 33.14833], [-116.04741, 33.16296], [-116.03073, 33.16383], [-116.03051, 33.15603], [-116.03035, 33.14894], [-116.01284, 33.14906], [-116.01278, 33.16004], [-116.01285, 33.16376], [-115.99557, 33.16383], [-115.99558, 33.16013], [-115.99555, 33.15639], [-115.99553, 33.14907], [-115.97819, 33.14877], [-115.97818, 33.15611], [-115.97823, 33.16375], [-115.96076, 33.16359], [-115.96086, 33.17826], [-115.97835, 33.17836], [-115.97833, 33.19276], [-115.99588, 33.19266], [-115.99572, 33.17821], [-116.01309, 33.17804], [-116.01331, 33.19248], [-116.03067, 33.19222], [-116.03092, 33.20692], [-116.01353, 33.20711], [-116.01376, 33.22175], [-116.03122, 33.22166], [-116.03154, 33.2364], [-116.04907, 33.23638], [-116.04924, 33.25104], [-116.03165, 33.25104], [-116.03153, 33.2364], [-116.01399, 33.23642], [-116.01407, 33.25103], [-115.99648, 33.25103], [-115.99646, 33.23642], [-116.01399, 33.23642], [-116.01375, 33.22176], [-115.99631, 33.22186], [-115.99638, 33.22914], [-115.97906, 33.22909], [-115.97896, 33.22196], [-115.96124, 33.22192], [-115.96145, 33.23615], [-115.97914, 33.23636], [-115.9789, 33.25103], [-115.96162, 33.25101], [-115.96144, 33.23616], [-115.94403, 33.23583], [-115.94364, 33.22077], [-115.96123, 33.22192], [-115.96112, 33.20734], [-115.94365, 33.20704], [-115.94362, 33.19249], [-115.92648, 33.19229], [-115.9265, 33.2068], [-115.91362, 33.20664], [-115.91318, 33.20568], [-115.91185, 33.20256], [-115.90916, 33.1966], [-115.90916, 33.19208], [-115.90709, 33.19205], [-115.90672, 33.19125], [-115.90609, 33.1902], [-115.90536, 33.1892], [-115.90453, 33.18825], [-115.9036, 33.18737], [-115.90258, 33.18655], [-115.90039, 33.18501], [-115.89163, 33.17875], [-115.89163, 33.17735], [-115.90919, 33.17757], [-115.90924, 33.1631], [-115.89163, 33.16305], [-115.89161, 33.14856], [-115.87415, 33.1476], [-115.87473, 33.13431], [-115.85911, 33.13419], [-115.85667, 33.12863], [-115.85661, 33.11935], [-115.87428, 33.11939], [-115.87474, 33.1343], [-115.892, 33.13427], [-115.89201, 33.11967], [-115.90082, 33.11964], [-115.90952, 33.11991], [-115.90929, 33.12707], [-115.9093, 33.13434], [-115.92662, 33.13434], [-115.9263, 33.14874], [-115.92631, 33.14875], [-115.93061, 33.14878], [-115.93068, 33.14517], [-115.93283, 33.14517], [-115.93278, 33.14879], [-115.94349, 33.14886], [-115.9438, 33.1343], [-115.95242, 33.13429], [-115.96148, 33.13461], [-115.96071, 33.14903], [-115.97818, 33.14877], [-115.97822, 33.1341], [-115.99542, 33.13419], [-115.99537, 33.12712], [-116.01257, 33.127], [-116.01266, 33.13412], [-116.02099, 33.13388], [-116.02992, 33.13391], [-116.03036, 33.14893], [-116.04722, 33.14833], [-116.04692, 33.13353], [-116.06377, 33.13307], [-116.06375, 33.12737], [-116.06433, 33.12774], [-116.06695, 33.12842], [-116.08038, 33.13209], [-116.08106, 33.13235], [-116.08106, 33.13287], [-116.06378, 33.13308], [-116.06388, 33.14766], [-116.08097, 33.14739], [-116.08108, 33.1555], [-116.08108, 33.1619]], [[-115.90901, 33.14864], [-115.90929, 33.13434], [-115.90064, 33.13434], [-115.892, 33.13427], [-115.89162, 33.14856], [-115.90901, 33.14864]], [[-115.9264, 33.16326], [-115.92641, 33.16325], [-115.9263, 33.14875], [-115.90902, 33.14864], [-115.90925, 33.16309], [-115.9264, 33.16326]], [[-115.92644, 33.17781], [-115.9092, 33.17758], [-115.90916, 33.19207], [-115.92647, 33.19228], [-115.92644, 33.17781]], [[-115.9436, 33.17803], [-115.94361, 33.17802], [-115.94358, 33.16342], [-115.92642, 33.16326], [-115.92644, 33.1778], [-115.9436, 33.17803]], [[-115.96071, 33.14904], [-115.9435, 33.14887], [-115.94359, 33.16342], [-115.96075, 33.16358], [-115.96071, 33.14904]], [[-115.96086, 33.17827], [-115.94361, 33.17803], [-115.94364, 33.19249], [-115.96096, 33.19269], [-115.96086, 33.17827]], [[-115.96098, 33.19269], [-115.96097, 33.1927], [-115.96112, 33.20733], [-115.97892, 33.20744], [-115.97832, 33.19277], [-115.96098, 33.19269]], [[-115.9963, 33.22186], [-115.99631, 33.22185], [-115.99613, 33.20728], [-115.97893, 33.20745], [-115.97897, 33.22196], [-115.9963, 33.22186]], [[-116.01265, 33.13413], [-115.99544, 33.1342], [-115.99554, 33.14906], [-116.01283, 33.14906], [-116.01265, 33.13413]], [[-116.0011, 33.19261], [-115.99588, 33.19267], [-115.99613, 33.20727], [-116.01353, 33.2071], [-116.0133, 33.19249], [-116.0011, 33.19261]]], [[[-116.08441, 33.25104], [-116.06683, 33.25104], [-116.06662, 33.23638], [-116.08416, 33.23639], [-116.08441, 33.25104]]]]} | Open Access 1 | 29203 | Ocotillo Wells State Vehicular Recreation Area | 13771 | 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 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://ohv.parks.ca.gov/?page_id=1217 | Imperial 20 | 21169.376 | Ocotillo Wells SVRA | 1976 | 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]);