units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14,510 rows where ACCESS_TYP = 1 sorted by MNG_AGENCY descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 14,510 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16983 | 16983 | 16982 | {"type": "MultiPolygon", "coordinates": [[[[-116.68466, 33.85886], [-116.68463, 33.8734], [-116.66704, 33.87328], [-116.66695, 33.85903], [-116.68466, 33.85886]]], [[[-116.7262, 33.84986], [-116.71981, 33.84987], [-116.71982, 33.84259], [-116.72615, 33.84258], [-116.7262, 33.84986]]]]} | Open Access 1 | 4534 | Santa Rosa and San Jacinto Mountains National Monument | 3109 | 2028 | Desert Water Agency 1183 | Special District 4 | Water District 13 | http://www.dwa.org/ | Special District 4 | 2028 | Desert Water Agency 1121 | Special District 4 | Water District 13 | Riverside 10 | 761.78 | Santa Rosa and San Jacinto Mtns. NM | 2000 | National Monument or Landmark 80 | 3 | |
16917 | 16917 | 16916 | {"type": "MultiPolygon", "coordinates": [[[[-116.59408, 33.15137], [-116.5897, 33.15166], [-116.58967, 33.1474], [-116.5906, 33.14589], [-116.59217, 33.14588], [-116.59219, 33.14793], [-116.59401, 33.14784], [-116.59407, 33.15133], [-116.59408, 33.15137]]], [[[-116.60729, 33.13867], [-116.60595, 33.14048], [-116.60542, 33.14383], [-116.60515, 33.14379], [-116.60489, 33.14372], [-116.60467, 33.14363], [-116.60434, 33.14346], [-116.60408, 33.14337], [-116.60384, 33.14332], [-116.60345, 33.14327], [-116.60035, 33.14481], [-116.59837, 33.14496], [-116.59831, 33.14088], [-116.59792, 33.14069], [-116.59776, 33.14065], [-116.59759, 33.14064], [-116.59734, 33.14068], [-116.59708, 33.14078], [-116.59669, 33.1409], [-116.59628, 33.14097], [-116.59573, 33.14101], [-116.59525, 33.14098], [-116.59498, 33.14091], [-116.59491, 33.1408], [-116.5949, 33.14068], [-116.59486, 33.14058], [-116.59479, 33.1405], [-116.59469, 33.14043], [-116.59454, 33.14037], [-116.59404, 33.14029], [-116.59385, 33.1403], [-116.59366, 33.14037], [-116.59355, 33.14044], [-116.59325, 33.1407], [-116.59334, 33.14043], [-116.59342, 33.14027], [-116.59353, 33.14013], [-116.59361, 33.14016], [-116.59395, 33.13963], [-116.59383, 33.13914], [-116.59385, 33.1356], [-116.59825, 33.13536], [-116.59829, 33.13385], [-116.59827, 33.12787], [-116.6003, 33.12794], [-116.60103, 33.12798], [-116.60142, 33.12798], [-116.60155, 33.13262], [-116.60124, 33.1326], [-116.60134, 33.13326], [-116.60152, 33.13326], [-116.60171, 33.13324], [-116.60217, 33.13306], [-116.60256, 33.13297], [-116.6029, 33.13297], [-116.60297, 33.13299], [-116.60304, 33.13305], [-116.60311, 33.1332], [-116.60309, 33.13325], [-116.60306, 33.1333], [-116.60296, 33.13335], [-116.60279, 33.13339], [-116.60263, 33.13346], [-116.60252, 33.13353], [-116.60246, 33.13361], [-116.60244, 33.13368], [-116.60245, 33.13418], [-116.60241, 33.1344], [-116.60344, 33.13434], [-116.60353, 33.1343], [-116.60358, 33.13427], [-116.60367, 33.13401], [-116.60423, 33.13395], [-116.60462, 33.13382], [-116.60492, 33.13354], [-116.60483, 33.13294], [-116.60704, 33.13315], [-116.60729, 33.13867]]]]} | Open Access 1 | 46819 | Volcan Mountain Wilderness Preserve | 30284 | 3333 | Volcan Mountain Preserve Foundation 1182 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.volcanmt.org/acquisition-projects-accomplishments | Non Governmental Organization 10 | 3333 | Volcan Mountain Preserve Foundation 1120 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.volcanmt.org | San Diego 4 | 381.895 | Volcan Mtn. Wilderness Preserve | 0 | Private Conservation 16 | 2 |
16901 | 16901 | 16900 | {"type": "Polygon", "coordinates": [[[-121.99742, 37.3099], [-121.99742, 37.31032], [-121.99733, 37.31095], [-121.99727, 37.311], [-121.99717, 37.311], [-121.99687, 37.31043], [-121.99662, 37.31014], [-121.99673, 37.31007], [-121.99654, 37.30984], [-121.99704, 37.30983], [-121.99736, 37.30986], [-121.9974, 37.3099], [-121.99742, 37.3099]]]} | Open Access 1 | 24310 | Rancho Rinconada Recreation Center | 24167 | 2251 | Rancho Rinconada Recreation and Park District 1180 | Special District 4 | Recreation/Parks District 4 | http://www.ranchoreccenter.com/ | Special District 4 | 2251 | Rancho Rinconada Recreation and Park District 1119 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 1.514 | Rancho Rinconada Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16900 | 16900 | 16899 | {"type": "Polygon", "coordinates": [[[-122.19908, 37.40441], [-122.19859, 37.40468], [-122.19843, 37.40469], [-122.19797, 37.40388], [-122.19864, 37.40363], [-122.19908, 37.40441]]]} | Open Access 1 | 24309 | Ladera Recreation Center | 20823 | 2233 | Ladera Recreation District 1179 | Special District 4 | Recreation/Parks District 4 | http://www.lrdrec.com/ | Special District 4 | 2233 | Ladera Recreation District 1118 | Special District 4 | Recreation/Parks District 4 | San Mateo 15 | 1.613 | Ladera Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16899 | 16899 | 16898 | {"type": "Polygon", "coordinates": [[[-122.34743, 37.51955], [-122.34676, 37.52049], [-122.34572, 37.52008], [-122.34668, 37.51877], [-122.34722, 37.51902], [-122.34701, 37.51936], [-122.34743, 37.51955]]]} | Open Access 1 | 24308 | Highlands Recreation Center | 19949 | 2228 | Highlands Recreation District 1178 | Special District 4 | Recreation/Parks District 4 | http://www.highlandsrec.com/ | Special District 4 | 2228 | Highlands Recreation District 1117 | Special District 4 | Recreation/Parks District 4 | San Mateo 15 | 3.66 | Highlands Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16810 | 16810 | 16809 | {"type": "Polygon", "coordinates": [[[-123.53176, 38.79603], [-123.52979, 38.79762], [-123.52905, 38.79637], [-123.52785, 38.79494], [-123.52811, 38.79484], [-123.52838, 38.79482], [-123.5285, 38.79482], [-123.52897, 38.79489], [-123.52942, 38.79536], [-123.53153, 38.79567], [-123.53176, 38.79603]]]} | Open Access 1 | 48503 | Redwood Coast Recreation Center | 33212 | 3389 | Redwood Coast Recreation Center 1176 | Non Profit 6 | Non Profit - Conservation 12 | http://rcrcpool.org/#about | Non Governmental Organization 10 | 3389 | Redwood Coast Recreation Center 1116 | Non Profit 6 | Non Profit - Conservation 12 | http://rcrcpool.org/ | Mendocino 24 | 11.148 | Redwood Coast Rec. Ctr. | 1999 | Private Conservation 16 | 2 |
16796 | 16796 | 16795 | {"type": "Polygon", "coordinates": [[[-118.86603, 34.26242], [-118.86562, 34.26252], [-118.86522, 34.26265], [-118.86394, 34.26316], [-118.86356, 34.26328], [-118.86317, 34.26338], [-118.86264, 34.26347], [-118.86097, 34.26347], [-118.86089, 34.2628], [-118.8609, 34.26237], [-118.86095, 34.26211], [-118.861, 34.2619], [-118.86109, 34.26165], [-118.86118, 34.26145], [-118.86138, 34.26111], [-118.86163, 34.2608], [-118.86183, 34.2606], [-118.86237, 34.26013], [-118.8626, 34.25991], [-118.86281, 34.25968], [-118.86305, 34.25937], [-118.86326, 34.25903], [-118.86447, 34.25686], [-118.86461, 34.25655], [-118.8647, 34.25629], [-118.86476, 34.25603], [-118.86479, 34.2557], [-118.86478, 34.25538], [-118.86473, 34.25506], [-118.86461, 34.25464], [-118.86413, 34.25349], [-118.86405, 34.25324], [-118.86401, 34.25298], [-118.86399, 34.25267], [-118.86401, 34.25241], [-118.86406, 34.2521], [-118.86415, 34.2518], [-118.86428, 34.25151], [-118.86444, 34.25123], [-118.86461, 34.25101], [-118.86483, 34.25076], [-118.86509, 34.25053], [-118.86537, 34.25033], [-118.86568, 34.25015], [-118.86601, 34.25], [-118.86601, 34.25267], [-118.86509, 34.25268], [-118.86509, 34.25349], [-118.86601, 34.2535], [-118.86603, 34.26242]]]} | Open Access 1 | 49014 | Moorpark Watershed, Parks, Recreation and Conservation Authority Open Space | 33712 | 502 | Moorpark Watershed, Parks, Recreation and Conservation Authority 1175 | Joint 8 | Joint Powers Authority 24 | http://smmc.ca.gov/Moorpark%20Watershed%20Parks%20Recreation%20and%20Conservation%20Authority.html | Special District 4 | 502 | Moorpark Watershed, Parks, Recreation and Conservation Authority 1115 | Joint 8 | Joint Powers Authority 23 | Ventura 8 | 80.677 | Moorpark Watershed, Parks, Rec. and Conservation Authority OS | None 1418 | |||
16777 | 16777 | 16776 | {"type": "MultiPolygon", "coordinates": [[[[-121.32835, 39.32083], [-121.32741, 39.32099], [-121.32743, 39.32082], [-121.32742, 39.32081], [-121.32611, 39.32104], [-121.32606, 39.32077], [-121.32632, 39.32044], [-121.32753, 39.32028], [-121.32834, 39.32058], [-121.32835, 39.32083]]], [[[-121.33188, 39.34191], [-121.33189, 39.34216], [-121.33188, 39.34277], [-121.33121, 39.34476], [-121.32791, 39.34345], [-121.32665, 39.344], [-121.32726, 39.34514], [-121.32708, 39.34564], [-121.32807, 39.34709], [-121.32842, 39.34764], [-121.32772, 39.34845], [-121.3264, 39.34849], [-121.32679, 39.35054], [-121.32645, 39.35135], [-121.32611, 39.35143], [-121.32406, 39.35094], [-121.32355, 39.35201], [-121.32411, 39.3543], [-121.32393, 39.35623], [-121.32202, 39.35605], [-121.32233, 39.35703], [-121.32218, 39.35806], [-121.3208, 39.35861], [-121.32109, 39.3604], [-121.32114, 39.36108], [-121.32034, 39.36122], [-121.32035, 39.362], [-121.31996, 39.36193], [-121.31991, 39.36118], [-121.31898, 39.36126], [-121.31866, 39.36182], [-121.31683, 39.36169], [-121.31191, 39.36163], [-121.31381, 39.36072], [-121.31438, 39.35769], [-121.3151, 39.35558], [-121.3156, 39.35493], [-121.31674, 39.35424], [-121.31864, 39.35203], [-121.31711, 39.35045], [-121.31381, 39.35083], [-121.3124, 39.35023], [-121.31157, 39.34868], [-121.30954, 39.34808], [-121.30783, 39.347], [-121.3062, 39.34438], [-121.30459, 39.34319], [-121.3042, 39.34249], [-121.30412, 39.34039], [-121.30516, 39.33994], [-121.30606, 39.33992], [-121.30807, 39.33935], [-121.30808, 39.33857], [-121.3048, 39.33534], [-121.30563, 39.33302], [-121.30741, 39.33138], [-121.30729, 39.33068], [-121.3033, 39.32901], [-121.30466, 39.32782], [-121.30453, 39.32059], [-121.3106, 39.32065], [-121.31527, 39.32072], [-121.31837, 39.32456], [-121.31915, 39.32509], [-121.3195, 39.32553], [-121.32, 39.32597], [-121.32241, 39.32959], [-121.32248, 39.32994], [-121.32225, 39.3305], [-121.32237, 39.33074], [-121.32276, 39.3312], [-121.32426, 39.33264], [-121.32426, 39.33439], [-121.32584, 39.33452], [-121.32707, 39.33532], [-121.32707, 39.33704], [-121.32858, 39.33861], [-121.32912, 39.34105], [-121.33188, 39.34191]]], [[[-121.31524, 39.36175], [-121.31682, 39.36179], [-121.3186, 39.36191], [-121.31775, 39.36316], [-121.32079, 39.36518], [-121.32123, 39.36596], [-121.32097, 39.36688], [-121.31987, 39.36715], [-121.31905, 39.36651], [-121.31795, 39.36582], [-121.31713, 39.36478], [-121.31529, 39.36402], [-121.31306, 39.36412], [-121.31005, 39.36485], [-121.3087, 39.36396], [-121.30512, 39.36372], [-121.30466, 39.36234], [-121.30758, 39.36172], [-121.31033, 39.36236], [-121.31075, 39.36219], [-121.31169, 39.36174], [-121.31524, 39.36175]]]]} | Open Access 1 | 662 | Collins Lake Recreation Area | 720 | 2010 | Browns Valley Irrigation District 1174 | Special District 4 | Irrigation District 17 | http://www.bvid.org/ | Special District 4 | 2010 | Browns Valley Irrigation District 1114 | Special District 4 | Irrigation District 16 | http://www.collinslake.com/map | Yuba 25 | 1598.822 | Collins Lake Rec. Area | 0 | Local Recreation Area 3 | 4 |
16658 | 16658 | 16657 | {"type": "MultiPolygon", "coordinates": [[[[-123.0767, 38.55966], [-123.07524, 38.56305], [-123.07437, 38.56486], [-123.07367, 38.56642], [-123.06127, 38.56613], [-123.06033, 38.56614], [-123.05927, 38.56941], [-123.05928, 38.56942], [-123.06811, 38.56953], [-123.0656, 38.57548], [-123.0656, 38.57549], [-123.07418, 38.5755], [-123.0737, 38.58223], [-123.07323, 38.58793], [-123.07326, 38.59136], [-123.07328, 38.59164], [-123.06893, 38.59167], [-123.06487, 38.59217], [-123.06484, 38.58862], [-123.06013, 38.5894], [-123.05375, 38.59049], [-123.05371, 38.59053], [-123.04864, 38.5921], [-123.04906, 38.58871], [-123.04896, 38.58724], [-123.04865, 38.58717], [-123.04817, 38.58735], [-123.04811, 38.58705], [-123.048, 38.58702], [-123.04751, 38.58359], [-123.04619, 38.58372], [-123.04608, 38.58326], [-123.04515, 38.57978], [-123.04057, 38.58003], [-123.04009, 38.57801], [-123.03605, 38.57804], [-123.03545, 38.57806], [-123.03599, 38.58033], [-123.02847, 38.5852], [-123.02017, 38.58505], [-123.01617, 38.58502], [-123.01617, 38.58183], [-123.01616, 38.58182], [-123.01404, 38.58186], [-123.01408, 38.58499], [-123.01078, 38.58499], [-123.01081, 38.58112], [-123.00233, 38.58073], [-122.9969, 38.58289], [-122.99333, 38.58121], [-122.99325, 38.57872], [-122.99077, 38.57226], [-122.99085, 38.56825], [-122.99564, 38.56827], [-122.99546, 38.5595], [-122.99521, 38.55207], [-122.99771, 38.55212], [-122.99779, 38.54973], [-122.99803, 38.54973], [-122.99804, 38.54952], [-123.00149, 38.54949], [-123.00119, 38.5451], [-123.00904, 38.54512], [-123.00904, 38.55225], [-123.01367, 38.5522], [-123.01405, 38.5578], [-123.01385, 38.55838], [-123.01394, 38.55945], [-123.01757, 38.55941], [-123.03507, 38.55804], [-123.03549, 38.55803], [-123.03965, 38.55824], [-123.0395, 38.55891], [-123.03949, 38.55907], [-123.03875, 38.56183], [-123.04774, 38.5622], [-123.04865, 38.5587], [-123.04878, 38.5478], [-123.05671, 38.54794], [-123.05731, 38.54793], [-123.07134, 38.54861], [-123.07136, 38.54868], [-123.07204, 38.55945], [-123.0767, 38.55966]], [[-123.01966, 38.57379], [-123.01965, 38.5738], [-123.0202, 38.5778], [-123.02021, 38.58327], [-123.02844, 38.5831], [-123.02804, 38.57314], [-123.01966, 38.57379]]], [[[-123.07594, 38.54551], [-123.07147, 38.54555], [-123.07145, 38.54385], [-123.07153, 38.54362], [-123.07153, 38.54357], [-123.07158, 38.54349], [-123.07171, 38.54336], [-123.07186, 38.54325], [-123.07185, 38.54196], [-123.07588, 38.54192], [-123.07594, 38.54551]]]]} | Open Access 1 | 17520 | Austin Creek State Recreation Area | 30575 | 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 | 3371 | Stewards of the Coast and Redwoods 1112 | Non Profit 6 | Non Profit - Conservation 12 | http://www.parks.ca.gov/?page_id=452 | Sonoma 16 | 5650.514 | Austin Creek SRA | 1964 | State Recreation Area 39 | 4 |
16629 | 16629 | 16628 | {"type": "Polygon", "coordinates": [[[-117.8006, 33.92776], [-117.80026, 33.92786], [-117.8002, 33.92778], [-117.79901, 33.92814], [-117.79903, 33.92826], [-117.79854, 33.92841], [-117.7982, 33.92855], [-117.79788, 33.92877], [-117.79778, 33.92871], [-117.79751, 33.92896], [-117.79677, 33.9299], [-117.79685, 33.92998], [-117.79642, 33.93059], [-117.79628, 33.93096], [-117.79612, 33.93152], [-117.79598, 33.93188], [-117.79581, 33.93221], [-117.79581, 33.93222], [-117.79585, 33.93222], [-117.79567, 33.93244], [-117.79541, 33.93268], [-117.79471, 33.93301], [-117.79448, 33.93309], [-117.79426, 33.93322], [-117.7938, 33.93371], [-117.79355, 33.93392], [-117.79313, 33.93412], [-117.79276, 33.93426], [-117.79247, 33.93447], [-117.79229, 33.93468], [-117.79217, 33.93495], [-117.79212, 33.93524], [-117.7921, 33.93562], [-117.79212, 33.93577], [-117.78316, 33.93569], [-117.783, 33.93214], [-117.78306, 33.92837], [-117.79162, 33.92847], [-117.79167, 33.92489], [-117.80058, 33.92502], [-117.8006, 33.92508], [-117.8006, 33.92776]]]} | Open Access 1 | 45015 | Chino Hills State Park | 28288 | 2340 | Castaic Lake Water Agency 1002 | Special District 4 | Water District 13 | http://clwa.org/ | Special District 4 | 2340 | Castaic Lake Water Agency 1111 | Special District 4 | Water District 13 | http://www.parks.ca.gov/?page_id=648 | Orange 3 | 301.431 | Chino Hills SP | 1981 | None 1415 | |
16299 | 16299 | 16298 | {"type": "MultiPolygon", "coordinates": [[[[-117.00698, 32.8493], [-117.00696, 32.8538], [-117.00784, 32.85577], [-117.00829, 32.85706], [-117.00841, 32.8577], [-117.00898, 32.86045], [-117.00905, 32.86085], [-117.00751, 32.86158], [-117.00743, 32.86121], [-117.00733, 32.8609], [-117.00661, 32.85925], [-117.00645, 32.8588], [-117.00637, 32.85845], [-117.00477, 32.84968], [-117.00476, 32.84959], [-117.00497, 32.84953], [-117.00472, 32.84888], [-117.00453, 32.84889], [-117.00424, 32.84725], [-117.00411, 32.84585], [-117.00392, 32.8452], [-117.00418, 32.84515], [-117.00444, 32.84493], [-117.00432, 32.84443], [-117.00441, 32.84444], [-117.00473, 32.84442], [-117.0048, 32.84446], [-117.00484, 32.84453], [-117.00501, 32.84451], [-117.005, 32.84441], [-117.00506, 32.84436], [-117.00548, 32.84432], [-117.00554, 32.84434], [-117.00558, 32.8444], [-117.00574, 32.84438], [-117.00573, 32.84428], [-117.00587, 32.84425], [-117.00601, 32.84469], [-117.00645, 32.84462], [-117.00691, 32.84606], [-117.00698, 32.8493]]], [[[-117.00923, 32.86438], [-117.00906, 32.86491], [-117.00844, 32.86624], [-117.00817, 32.86642], [-117.0076, 32.86635], [-117.00738, 32.86624], [-117.00703, 32.86596], [-117.00697, 32.86578], [-117.00795, 32.86413], [-117.00825, 32.8639], [-117.00917, 32.8642], [-117.00923, 32.86438]]]]} | Open Access 1 | 193 | Santee Lakes Regional Park | 25150 | 2106 | Padre Dam Municipal Water District 1170 | Special District 4 | Water District 13 | http://www.padredam.org/ | Special District 4 | 2106 | Padre Dam Municipal Water District 1109 | Special District 4 | Water District 13 | http://www.santeelakes.com/ | San Diego 4 | 99.056 | Santee Lakes RP | 0 | Local Park 2 | 4 |
16271 | 16271 | 16270 | {"type": "MultiPolygon", "coordinates": [[[[-118.7196, 34.04372], [-118.71953, 34.04551], [-118.71958, 34.04915], [-118.71638, 34.0492], [-118.71638, 34.04989], [-118.7163, 34.04988], [-118.71595, 34.04962], [-118.71587, 34.04959], [-118.71578, 34.04961], [-118.71562, 34.04972], [-118.71557, 34.04971], [-118.71541, 34.0496], [-118.71532, 34.0496], [-118.71497, 34.0498], [-118.71484, 34.04985], [-118.71471, 34.04987], [-118.71447, 34.04987], [-118.7144, 34.04979], [-118.71416, 34.04981], [-118.71418, 34.04992], [-118.71406, 34.04998], [-118.71424, 34.05015], [-118.71452, 34.05017], [-118.71463, 34.05015], [-118.71433, 34.05032], [-118.71451, 34.05037], [-118.71442, 34.05047], [-118.71442, 34.05074], [-118.71436, 34.05085], [-118.71437, 34.051], [-118.71429, 34.05115], [-118.71428, 34.05131], [-118.71413, 34.05131], [-118.71376, 34.05162], [-118.71351, 34.05157], [-118.71325, 34.05171], [-118.71325, 34.05173], [-118.71341, 34.05174], [-118.71327, 34.05184], [-118.71327, 34.05186], [-118.71343, 34.05188], [-118.71318, 34.0523], [-118.71309, 34.05228], [-118.71296, 34.05242], [-118.71278, 34.05243], [-118.71262, 34.05239], [-118.7126, 34.05226], [-118.71251, 34.0522], [-118.71227, 34.05186], [-118.71225, 34.05221], [-118.71176, 34.05228], [-118.71166, 34.05233], [-118.71163, 34.05237], [-118.71162, 34.05243], [-118.7117, 34.05269], [-118.71146, 34.05282], [-118.71144, 34.05301], [-118.71134, 34.05302], [-118.71116, 34.05283], [-118.71107, 34.05283], [-118.71086, 34.05248], [-118.71061, 34.05232], [-118.71054, 34.05236], [-118.71039, 34.05229], [-118.71021, 34.05203], [-118.70981, 34.05186], [-118.70972, 34.05179], [-118.70965, 34.0517], [-118.70955, 34.05148], [-118.7095, 34.05142], [-118.70943, 34.05139], [-118.70918, 34.05138], [-118.70907, 34.05134], [-118.70893, 34.05125], [-118.7087, 34.05103], [-118.7084, 34.05106], [-118.70791, 34.05021], [-118.70522, 34.04897], [-118.70517, 34.04899], [-118.70481, 34.04888], [-118.70429, 34.04858], [-118.70417, 34.04856], [-118.70385, 34.0486], [-118.70374, 34.04857], [-118.70369, 34.04853], [-118.70361, 34.0484], [-118.70353, 34.04833], [-118.70316, 34.04821], [-118.70305, 34.04816], [-118.70291, 34.04807], [-118.70263, 34.04783], [-118.70231, 34.0477], [-118.70208, 34.04747], [-118.70188, 34.04739], [-118.70167, 34.04699], [-118.70157, 34.04686], [-118.70148, 34.0468], [-118.70111, 34.0466], [-118.70099, 34.04648], [-118.70078, 34.04619], [-118.7011, 34.04639], [-118.70129, 34.04648], [-118.70149, 34.04653], [-118.70181, 34.04656], [-118.70151, 34.04637], [-118.70133, 34.04629], [-118.70125, 34.04623], [-118.701, 34.0459], [-118.70074, 34.04563], [-118.70067, 34.0456], [-118.70034, 34.04557], [-118.70007, 34.04549], [-118.69954, 34.04514], [-118.69939, 34.04499], [-118.6993, 34.04495], [-118.69906, 34.04496], [-118.69879, 34.04507], [-118.69873, 34.0451], [-118.6987, 34.04515], [-118.69869, 34.04521], [-118.6987, 34.04527], [-118.69884, 34.04544], [-118.69889, 34.04555], [-118.6989, 34.04564], [-118.69888, 34.04582], [-118.69895, 34.04602], [-118.69893, 34.04616], [-118.69807, 34.04554], [-118.69849, 34.04479], [-118.69899, 34.04471], [-118.69928, 34.04363], [-118.69905, 34.04238], [-118.70187, 34.04238], [-118.70296, 34.04405], [-118.70363, 34.04411], [-118.70391, 34.04409], [-118.70409, 34.04405], [-118.70426, 34.04399], [-118.70443, 34.04391], [-118.70457, 34.04381], [-118.70532, 34.0444], [-118.70446, 34.04496], [-118.70494, 34.04547], [-118.70561, 34.04503], [-118.70571, 34.0449], [-118.70629, 34.04452], [-118.70648, 34.04451], [-118.70665, 34.04471], [-118.70673, 34.04484], [-118.70675, 34.04494], [-118.70674, 34.04504], [-118.70673, 34.04508], [-118.70667, 34.04508], [-118.70664, 34.04515], [-118.7067, 34.04517], [-118.70667, 34.04522], [-118.70655, 34.04534], [-118.7064, 34.04542], [-118.70622, 34.04546], [-118.70609, 34.04546], [-118.70597, 34.04544], [-118.70599, 34.04539], [-118.7059, 34.04536], [-118.70581, 34.0455], [-118.70611, 34.04616], [-118.7067, 34.04621], [-118.70764, 34.04598], [-118.70778, 34.04637], [-118.70875, 34.04646], [-118.70972, 34.04542], [-118.70988, 34.04546], [-118.70994, 34.0454], [-118.71112, 34.04528], [-118.71112, 34.0462], [-118.7135, 34.04619], [-118.71353, 34.04627], [-118.7141, 34.04713], [-118.71424, 34.04725], [-118.71442, 34.04734], [-118.71446, 34.0474], [-118.71452, 34.04744], [-118.71458, 34.04744], [-118.71468, 34.0474], [-118.71513, 34.0474], [-118.71538, 34.04737], [-118.71562, 34.0473], [-118.71583, 34.04718], [-118.716, 34.04703], [-118.71613, 34.04684], [-118.71618, 34.04671], [-118.71621, 34.04646], [-118.71623, 34.04643], [-118.71638, 34.04639], [-118.71645, 34.0465], [-118.71644, 34.04652], [-118.71653, 34.04659], [-118.71679, 34.04647], [-118.71704, 34.04629], [-118.71708, 34.0462], [-118.71709, 34.04611], [-118.71689, 34.04596], [-118.71698, 34.04581], [-118.71714, 34.04592], [-118.71736, 34.04551], [-118.71739, 34.04527], [-118.71724, 34.04492], [-118.7172, 34.04486], [-118.71713, 34.04482], [-118.71704, 34.04479], [-118.71665, 34.04478], [-118.71618, 34.04479], [-118.71593, 34.04483], [-118.71589, 34.04481], [-118.71558, 34.04463], [-118.7159, 34.04412], [-118.71593, 34.04403], [-118.71594, 34.04394], [-118.71591, 34.0438], [-118.71583, 34.04368], [-118.7157, 34.04358], [-118.71551, 34.04351], [-118.71547, 34.04347], [-118.7156, 34.04283], [-118.71557, 34.04264], [-118.71548, 34.04247], [-118.71538, 34.04237], [-118.71527, 34.04228], [-118.71514, 34.04222], [-118.715, 34.04217], [-118.71485, 34.04215], [-118.71469, 34.04215], [-118.71455, 34.04217], [-118.71442, 34.04221], [-118.71424, 34.04231], [-118.7141, 34.04244], [-118.71348, 34.04342], [-118.71339, 34.04352], [-118.71325, 34.04359], [-118.7131, 34.04361], [-118.71296, 34.04359], [-118.71287, 34.04356], [-118.71283, 34.04352], [-118.71332, 34.04277], [-118.71343, 34.04255], [-118.71335, 34.04251], [-118.71346, 34.04218], [-118.71351, 34.04183], [-118.71344, 34.04162], [-118.71333, 34.04141], [-118.7127, 34.04065], [-118.71262, 34.04053], [-118.71254, 34.04033], [-118.71253, 34.04011], [-118.71259, 34.04023], [-118.7129, 34.04012], [-118.71317, 34.04044], [-118.71395, 34.04065], [-118.71445, 34.04019], [-118.71445, 34.04017], [-118.71435, 34.0401], [-118.7144, 34.04002], [-118.71438, 34.03994], [-118.71455, 34.03986], [-118.7149, 34.03942], [-118.7148, 34.03936], [-118.71442, 34.03922], [-118.71444, 34.03919], [-118.71494, 34.03937], [-118.71526, 34.03895], [-118.71505, 34.03775], [-118.71571, 34.03694], [-118.71512, 34.03605], [-118.71358, 34.03503], [-118.71483, 34.03493], [-118.71809, 34.03679], [-118.7184, 34.03923], [-118.71835, 34.04035], [-118.71933, 34.04219], [-118.7196, 34.04372]]], [[[-118.70509, 34.04902], [-118.70418, 34.04939], [-118.70319, 34.0494], [-118.70134, 34.04835], [-118.70124, 34.04784], [-118.69899, 34.0462], [-118.69901, 34.04602], [-118.69894, 34.04582], [-118.69896, 34.04564], [-118.69895, 34.04555], [-118.6989, 34.04542], [-118.69877, 34.04525], [-118.69876, 34.04519], [-118.69877, 34.04516], [-118.69883, 34.04511], [-118.69911, 34.045], [-118.69918, 34.04499], [-118.69928, 34.045], [-118.69934, 34.04503], [-118.69949, 34.04518], [-118.70005, 34.04554], [-118.7003, 34.04562], [-118.7007, 34.04567], [-118.70094, 34.04593], [-118.7012, 34.04626], [-118.70129, 34.04633], [-118.70144, 34.0464], [-118.7016, 34.04649], [-118.7014, 34.04646], [-118.70113, 34.04635], [-118.70088, 34.04619], [-118.7006, 34.04597], [-118.70059, 34.04597], [-118.70076, 34.04628], [-118.701, 34.04658], [-118.70108, 34.04664], [-118.70144, 34.04684], [-118.70155, 34.04693], [-118.70164, 34.04705], [-118.7018, 34.04738], [-118.70186, 34.04744], [-118.70204, 34.04751], [-118.70222, 34.04769], [-118.70231, 34.04776], [-118.70259, 34.04787], [-118.70297, 34.04818], [-118.70313, 34.04826], [-118.7035, 34.04838], [-118.70356, 34.04844], [-118.70363, 34.04856], [-118.70369, 34.04861], [-118.70377, 34.04864], [-118.70385, 34.04865], [-118.70416, 34.04861], [-118.70423, 34.04862], [-118.70478, 34.04892], [-118.70509, 34.04902]]], [[[-118.7164, 34.05288], [-118.71536, 34.05292], [-118.71535, 34.0565], [-118.71496, 34.05681], [-118.71433, 34.05616], [-118.71375, 34.056], [-118.71369, 34.05587], [-118.7137, 34.05546], [-118.71346, 34.05539], [-118.71325, 34.05559], [-118.71294, 34.05564], [-118.7119, 34.05521], [-118.7114, 34.05467], [-118.71125, 34.05431], [-118.71113, 34.05418], [-118.71111, 34.05419], [-118.71111, 34.0544], [-118.71125, 34.05473], [-118.71179, 34.05532], [-118.71291, 34.05578], [-118.71333, 34.05572], [-118.71351, 34.05555], [-118.71353, 34.05556], [-118.71353, 34.05589], [-118.71362, 34.05611], [-118.71423, 34.05628], [-118.71499, 34.05705], [-118.7152, 34.05749], [-118.71503, 34.05836], [-118.71515, 34.05874], [-118.71533, 34.05896], [-118.71533, 34.0673], [-118.7111, 34.06737], [-118.71111, 34.05477], [-118.7092, 34.05244], [-118.70843, 34.05111], [-118.70867, 34.05109], [-118.70889, 34.05129], [-118.70903, 34.05139], [-118.70917, 34.05143], [-118.70941, 34.05144], [-118.70946, 34.05146], [-118.70948, 34.05149], [-118.70959, 34.05172], [-118.7097, 34.05185], [-118.70982, 34.05192], [-118.71016, 34.05207], [-118.71034, 34.05233], [-118.71055, 34.05242], [-118.71061, 34.05238], [-118.71081, 34.05252], [-118.71103, 34.05288], [-118.71113, 34.05288], [-118.7113, 34.05308], [-118.71149, 34.05306], [-118.71152, 34.05286], [-118.71178, 34.05271], [-118.71169, 34.05243], [-118.7117, 34.05239], [-118.71172, 34.05235], [-118.71231, 34.05225], [-118.71233, 34.05204], [-118.71246, 34.05224], [-118.71254, 34.05229], [-118.71256, 34.05243], [-118.71277, 34.05249], [-118.71299, 34.05247], [-118.71311, 34.05234], [-118.71322, 34.05236], [-118.71353, 34.05185], [-118.71352, 34.05184], [-118.7134, 34.05182], [-118.71356, 34.05169], [-118.71343, 34.05168], [-118.71352, 34.05163], [-118.71378, 34.05168], [-118.71416, 34.05136], [-118.71434, 34.05136], [-118.71435, 34.05116], [-118.71443, 34.05102], [-118.71443, 34.05086], [-118.71448, 34.05075], [-118.71448, 34.05049], [-118.71455, 34.05041], [-118.71493, 34.05025], [-118.71492, 34.05024], [-118.71451, 34.05032], [-118.71447, 34.0503], [-118.71469, 34.05018], [-118.71479, 34.05008], [-118.71451, 34.05011], [-118.71428, 34.0501], [-118.71416, 34.04999], [-118.71425, 34.04995], [-118.71423, 34.04986], [-118.71437, 34.04985], [-118.71443, 34.04992], [-118.71472, 34.04992], [-118.71486, 34.0499], [-118.715, 34.04985], [-118.71534, 34.04965], [-118.71539, 34.04966], [-118.71554, 34.04976], [-118.7156, 34.04978], [-118.71568, 34.04976], [-118.71582, 34.04965], [-118.71587, 34.04964], [-118.71626, 34.04993], [-118.71638, 34.04995], [-118.71638, 34.05005], [-118.71605, 34.04994], [-118.71599, 34.04996], [-118.71596, 34.05001], [-118.716, 34.05007], [-118.71638, 34.05027], [-118.7164, 34.05288]]], [[[-118.71534, 34.05761], [-118.71533, 34.05871], [-118.71533, 34.05872], [-118.7153, 34.05868], [-118.7152, 34.05836], [-118.71534, 34.05761]]], [[[-118.71534, 34.05717], [-118.71534, 34.05717], [-118.71534, 34.05742], [-118.71522, 34.05717], [-118.71534, 34.05717]]], [[[-118.71638, 34.05021], [-118.71603, 34.05002], [-118.71603, 34.05], [-118.71605, 34.05], [-118.71638, 34.05011], [-118.71638, 34.05021]]]]} | Open Access 1 | 48999 | Pepperdine University Open Space | 33698 | 3399 | Pepperdine University 1169 | Non Profit 6 | Non Profit - Education 34 | https://www.pepperdine.edu/ | Non Governmental Organization 10 | 3399 | Pepperdine University 1108 | Non Profit 6 | Non Profit - Education 32 | Los Angeles 6 | 517.886 | Pepperdine University OS | 0 | Private Recreation or Education 65 | 4 | |
15845 | 15845 | 15844 | {"type": "MultiPolygon", "coordinates": [[[[-118.37159, 33.76721], [-118.37139, 33.76744], [-118.37081, 33.76795], [-118.37054, 33.76809], [-118.37028, 33.76819], [-118.36988, 33.76826], [-118.36957, 33.76825], [-118.36931, 33.76821], [-118.36905, 33.76812], [-118.36801, 33.7677], [-118.3677, 33.76761], [-118.36738, 33.76756], [-118.36695, 33.76756], [-118.36722, 33.76751], [-118.36745, 33.76751], [-118.36778, 33.76756], [-118.36792, 33.7676], [-118.3693, 33.76817], [-118.36961, 33.76824], [-118.36984, 33.76825], [-118.37, 33.76823], [-118.37022, 33.76817], [-118.37042, 33.76808], [-118.37055, 33.76799], [-118.37068, 33.76788], [-118.37139, 33.76708], [-118.37138, 33.76701], [-118.37159, 33.76714], [-118.37159, 33.76721]]], [[[-118.3718, 33.76638], [-118.3718, 33.76662], [-118.37176, 33.76685], [-118.3717, 33.7669], [-118.37163, 33.76689], [-118.37158, 33.76686], [-118.37168, 33.7667], [-118.37175, 33.76655], [-118.37178, 33.76638], [-118.37178, 33.76628], [-118.3718, 33.76638]]]]} | Open Access 1 | 5926 | Ridgecrest Ranchos Open Space | 24353 | 2120 | Ridgecrest Ranchos Recreation and Park District 1162 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2120 | Ridgecrest Ranchos Recreation and Park District 1105 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 1.195 | Ridgecrest Ranchos OS | 0 | Local Recreation Area 3 | 4 | ||
15558 | 15558 | 15557 | {"type": "MultiPolygon", "coordinates": [[[[-117.23623, 33.03472], [-117.23609, 33.03514], [-117.23477, 33.03601], [-117.23459, 33.03653], [-117.23385, 33.03634], [-117.23455, 33.03424], [-117.23623, 33.03472]]], [[[-117.23374, 33.03631], [-117.23309, 33.03834], [-117.23296, 33.03831], [-117.23292, 33.03841], [-117.23201, 33.03818], [-117.23209, 33.03792], [-117.23191, 33.03787], [-117.23251, 33.03599], [-117.23374, 33.03631]]]]} | Open Access 1 | 1247 | San Elijo Lagoon Ecological Reserve | 24880 | 3058 | Rancho Santa Fe Community Foundation 1159 | Non Profit 6 | Non Profit - Other 22 | http://www.rsffoundation.org/ | Non Governmental Organization 10 | 3058 | Rancho Santa Fe Community Foundation 1101 | Non Profit 6 | Non Profit - Other 20 | https://www.sanelijo.org/home | San Diego 4 | 14.074 | San Elijo Lagoon ER | 1983 | Private Conservation 16 | 2 |
15426 | 15426 | 15425 | {"type": "MultiPolygon", "coordinates": [[[[-122.28318, 38.30265], [-122.28294, 38.3029], [-122.2829, 38.30296], [-122.28289, 38.30304], [-122.28294, 38.30335], [-122.28277, 38.30344], [-122.28272, 38.30318], [-122.28268, 38.30281], [-122.28265, 38.3027], [-122.28254, 38.30246], [-122.28229, 38.30218], [-122.28217, 38.30212], [-122.28207, 38.3021], [-122.28203, 38.30204], [-122.2821, 38.30199], [-122.28205, 38.30193], [-122.28217, 38.30187], [-122.2822, 38.30189], [-122.28231, 38.30179], [-122.28244, 38.30173], [-122.28318, 38.30265]]], [[[-122.28323, 38.3012], [-122.28254, 38.30155], [-122.28245, 38.30144], [-122.28269, 38.30123], [-122.28274, 38.3012], [-122.28277, 38.30122], [-122.28284, 38.30112], [-122.28297, 38.30103], [-122.28289, 38.30092], [-122.2829, 38.30087], [-122.28274, 38.30068], [-122.28279, 38.30065], [-122.28323, 38.3012]]], [[[-122.28379, 38.30186], [-122.28306, 38.30224], [-122.28265, 38.3017], [-122.28337, 38.30134], [-122.28379, 38.30186]]], [[[-122.2837, 38.30098], [-122.28341, 38.30111], [-122.28296, 38.30057], [-122.28325, 38.30043], [-122.28332, 38.30043], [-122.2837, 38.30098]]]]} | Open Access 1 | 46689 | Oxbow Commons | 30727 | 2405 | Napa County Flood Control and Water Conservation District 1158 | Special District 4 | Water District 13 | http://www.countyofnapa.org/flooddistrict/ | Special District 4 | 2405 | Napa County Flood Control and Water Conservation District 1100 | Special District 4 | Water District 13 | Napa 11 | 3.865 | Oxbow Commons | None 1363 | |||
15309 | 15309 | 15308 | {"type": "Polygon", "coordinates": [[[-118.1787, 33.98749], [-118.1785, 33.98885], [-118.17811, 33.98882], [-118.17817, 33.98838], [-118.17812, 33.98837], [-118.17792, 33.98851], [-118.17774, 33.98834], [-118.17784, 33.98769], [-118.17797, 33.98769], [-118.178, 33.98742], [-118.1787, 33.98749]]]} | Open Access 1 | 46464 | Maywood Activity Center | 29736 | 1200 | Maywood, City of 260 | City 2 | City Agency 2 | http://www.cityofmaywood.com/index.php?option=com_content&view=article&id=162&Itemid=69 | City 2 | 3366 | YMCA of Southeast - Rio Vista 1098 | Non Profit 6 | Non Profit - Other 20 | http://www.cityofmaywood.com/index.php?option=com_content&view=article&id=162&Itemid=69 | Los Angeles 6 | 2.399 | Maywood Activity Ctr. | None 1354 | ||
15299 | 15299 | 15298 | {"type": "Polygon", "coordinates": [[[-117.97481, 34.14373], [-117.9748, 34.14592], [-117.97453, 34.14593], [-117.97453, 34.14687], [-117.9745, 34.14687], [-117.9745, 34.1459], [-117.97473, 34.14589], [-117.97476, 34.14586], [-117.97476, 34.14373], [-117.97481, 34.14373]]]} | Open Access 1 | 46437 | Lemon Trail | 29710 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.341 | Lemon Trail | 0 | Local Recreation Area 3 | 4 | |
15300 | 15300 | 15299 | {"type": "Polygon", "coordinates": [[[-117.96999, 34.14575], [-117.9696, 34.14575], [-117.96915, 34.14556], [-117.96899, 34.14555], [-117.96898, 34.14547], [-117.96986, 34.1455], [-117.96996, 34.14548], [-117.96999, 34.14575]]]} | Open Access 1 | 46439 | Civic Center Park | 32522 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.468 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
15301 | 15301 | 15300 | {"type": "Polygon", "coordinates": [[[-117.97472, 34.14357], [-117.97464, 34.14362], [-117.96441, 34.1437], [-117.96441, 34.14354], [-117.97458, 34.14347], [-117.97472, 34.14357]]]} | Open Access 1 | 46438 | Royal Oaks Trail North | 29711 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 4.034 | Royal Oaks Trail North | None 1352 | |||
15167 | 15167 | 15166 | {"type": "Polygon", "coordinates": [[[-117.27449, 33.09512], [-117.27025, 33.09505], [-117.27019, 33.09492], [-117.27019, 33.09488], [-117.27023, 33.09483], [-117.27016, 33.09464], [-117.27011, 33.09465], [-117.27011, 33.09307], [-117.2703, 33.09301], [-117.27048, 33.09283], [-117.27071, 33.09282], [-117.27099, 33.09295], [-117.27164, 33.09308], [-117.2715, 33.09331], [-117.27151, 33.09332], [-117.27233, 33.09353], [-117.27312, 33.09348], [-117.27325, 33.09329], [-117.27351, 33.09329], [-117.27355, 33.09311], [-117.27415, 33.09307], [-117.27413, 33.09316], [-117.27439, 33.09325], [-117.27448, 33.09326], [-117.27449, 33.09512]]]} | Open Access 1 | 47291 | Cholla Point | 30996 | 3220 | Batiquitos Lagoon Foundation 1138 | Non Profit 6 | Non Profit - Conservation 12 | http://www.batiquitosfoundation.org/about/ | Non Governmental Organization 10 | 3220 | Batiquitos Lagoon Foundation 1093 | Non Profit 6 | Non Profit - Conservation 12 | http://www.batiquitosfoundation.org/category/visit/ | San Diego 4 | 20.824 | Cholla Point | 2011 | Private Conservation 16 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);