units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where ACCESS_TYP = 2 and DES_TP = 3 sorted by MNG_AG_TYP
This data as json, copyable, CSV (advanced)
MNG_AGENCY 123
- Los Angeles, County of 9
- Los Angeles, City of 8
- Los Angeles - Department of Parks and Recreation, County of 7
- Santa Cruz, City of 6
- San Diego, City of 5
- San Jose, City of 5
- Santa Ana, City of 4
- San Bernardino, City of 4
- Long Beach, City of 4
- Carlsbad, City of 3
- Needles, City of 3
- Torrance, City of 3
- Stockton, City of 3
- Modesto, City of 3
- Roseville, City of 3
- Sacramento, County of 3
- San Gabriel, City of 3
- San Luis Obispo, County of 2
- San Francisco, City and County of 2
- San Luis Obispo, City of 2
- Rancho Simi Recreation and Park District 2
- Ventura, City of 2
- Pomona, City of 2
- Orange, County of 2
- Riverside, City of 2
- Ventura, County of 2
- El Monte, City of 2
- Hayward Area Recreation and Park District 2
- El Segundo, City of 2
- South Pasadena, City of 2
- Sunnyvale, City of 2
- Conejo Open Space Conservation Agency 2
- Culver City Unified School District 2
- South Lake Tahoe, City of 2
- Nevada Irrigation District 2
- Lancaster, City of 1
- Conejo Recreation and Park District 1
- Fresno, City of 1
- Moreno Valley, City of 1
- Monterey, County of 1
- Santa Barbara, City of 1
- Santa Rosa, City of 1
- Pleasanton, City of 1
- Santa Maria, City of 1
- Encinitas, City of 1
- Monterey Peninsula Regional Park District 1
- National City, City of 1
- Salinas, City of 1
- Yorba Linda, City of 1
- El Cajon, City of 1
- Oceanside, City of 1
- Huntington Park, City of 1
- Sonoma County Water Agency 1
- San Mateo, City of 1
- Glendale, City of 1
- Coronado, City of 1
- Seaside, City of 1
- Fullerton, City of 1
- Costa Mesa, City of 1
- Chula Vista, City of 1
- Ontario, City of 1
- Monterey Park, City of 1
- Burbank, City of 1
- Porterville, City of 1
- Vacaville, City of 1
- Visalia, City of 1
- Alhambra, City of 1
- Valley-Wide Recreation and Park District 1
- Dublin, City of 1
- Davis, City of 1
- Walnut Creek, City of 1
- Cupertino, City of 1
- Hollister, City of 1
- Fairfield, City of 1
- Indio, City of 1
- Cerritos, City of 1
- Mill Valley, City of 1
- Brea, City of 1
- San Dimas, City of 1
- Montebello, City of 1
- Fresno, County of 1
- Gardena, City of 1
- Pasadena, City of 1
- Arcadia, City of 1
- La Verne, City of 1
- Monrovia, City of 1
- Rohnert Park, City of 1
- Walnut, City of 1
- La Canada Flintridge, City of 1
- Blythe, City of 1
- Antioch, City of 1
- Pico Rivera, City of 1
- Lemoore, City of 1
- Concord, City of 1
- Kern, County of 1
- Gilroy, City of 1
- Milpitas, City of 1
- Brooktrails Community Services District 1
- Thousand Oaks, City of 1
- Delano, City of 1
- Napa, City of 1
- Santa Clara County Parks and Recreation Dept., County of 1
- King City, City of 1
- Lawndale, City of 1
- Manteca, City of 1
- Manhattan Beach, City of 1
- Southgate Recreation and Park District 1
- Ripon, City of 1
- Marysville, City of 1
- Sacramento, City of 1
- Rocklin, City of 1
- South El Monte, City of 1
- Lincoln, City of 1
- La Quinta, City of 1
- Los Angeles Unified School District 1
- Eureka, City of 1
- Calleguas Municipal Water District 1
- Watershed Conservation Authority 1
- Santa Clara Unified School District 1
- San Bernardino County Flood Control District 1
- Malibu, City of 1
- Vista Unified School District 1
- San Dimas-La Verne Recreational Facilities Authority 1
MNG_AG_TYP 11
DES_TP 1
- Local Recreation Area · 200 ✖
ACCESS_TYP 1
- Restricted Access · 200 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4885 | 4885 | 4884 | {"type": "Polygon", "coordinates": [[[-121.14717, 37.72653], [-121.145, 37.72656], [-121.14453, 37.72659], [-121.14304, 37.72659], [-121.1424, 37.7266], [-121.142, 37.72657], [-121.14198, 37.72631], [-121.1419, 37.72282], [-121.14224, 37.7226], [-121.14268, 37.72235], [-121.1428, 37.72219], [-121.14288, 37.72189], [-121.14279, 37.72164], [-121.14261, 37.72157], [-121.14239, 37.72159], [-121.14219, 37.72148], [-121.14206, 37.72129], [-121.14189, 37.72117], [-121.14187, 37.72094], [-121.14187, 37.72084], [-121.14213, 37.72065], [-121.14225, 37.72053], [-121.14321, 37.71995], [-121.14367, 37.71974], [-121.14396, 37.71968], [-121.14447, 37.71965], [-121.1449, 37.71984], [-121.14518, 37.72002], [-121.14541, 37.72005], [-121.14564, 37.71991], [-121.14571, 37.71959], [-121.14583, 37.71926], [-121.14572, 37.7187], [-121.14564, 37.71847], [-121.14564, 37.71823], [-121.14577, 37.71796], [-121.14604, 37.71776], [-121.14635, 37.71762], [-121.14693, 37.71756], [-121.14715, 37.71763], [-121.14713, 37.72287], [-121.14711, 37.72294], [-121.14711, 37.72322], [-121.14717, 37.7262], [-121.14717, 37.72653]]]} | Restricted Access 2 | 17783 | Jack Tone Golf Course | 33060 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 88.453 | Jack Tone GC | 0 | Local Recreation Area 3 | 4 | |
4887 | 4887 | 4886 | {"type": "Polygon", "coordinates": [[[-122.01786, 38.01685], [-122.01615, 38.01606], [-122.01379, 38.01187], [-122.01827, 38.01106], [-122.02232, 38.01073], [-122.02266, 38.01085], [-122.02298, 38.01167], [-122.0232, 38.01212], [-122.02344, 38.01272], [-122.02371, 38.01327], [-122.0239, 38.01321], [-122.02459, 38.01463], [-122.02429, 38.01472], [-122.02586, 38.01793], [-122.02616, 38.01785], [-122.02649, 38.01854], [-122.02529, 38.01892], [-122.02508, 38.01872], [-122.02404, 38.01933], [-122.01786, 38.01685]]]} | Restricted Access 2 | 13617 | Diablo Creek Golf Course | 33034 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 150.576 | Diablo Creek GC | 0 | Local Recreation Area 3 | 4 | |
5091 | 5091 | 5090 | {"type": "Polygon", "coordinates": [[[-118.14026, 33.782], [-118.14026, 33.78244], [-118.13519, 33.78245], [-118.13518, 33.78214], [-118.13189, 33.78191], [-118.1286, 33.77948], [-118.1286, 33.77543], [-118.13159, 33.77543], [-118.13155, 33.77619], [-118.13253, 33.77718], [-118.13431, 33.77757], [-118.13696, 33.77795], [-118.1371, 33.77794], [-118.13729, 33.77819], [-118.13734, 33.77832], [-118.13746, 33.77879], [-118.13743, 33.77907], [-118.13769, 33.77961], [-118.13781, 33.77978], [-118.13825, 33.78024], [-118.1386, 33.78072], [-118.13873, 33.78094], [-118.13906, 33.78131], [-118.13928, 33.78148], [-118.13951, 33.78164], [-118.13984, 33.78183], [-118.14026, 33.782]]]} | Restricted Access 2 | 45923 | Recreation Park 18 Hole Golf Course | 33116 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 119.647 | Rec. Park 18 Hole GC | 0 | Local Recreation Area 3 | 4 | |
5702 | 5702 | 5701 | {"type": "Polygon", "coordinates": [[[-118.21106, 34.03932], [-118.21067, 34.03991], [-118.21062, 34.03994], [-118.21057, 34.03993], [-118.20993, 34.03964], [-118.21034, 34.03899], [-118.21106, 34.03932]]]} | Restricted Access 2 | 45762 | Roosevelt High School Pool | 28767 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/aquatic/facility/rooseveltPool.htm | Los Angeles 6 | 1.493 | Roosevelt High School Pool | 0 | Local Recreation Area 3 | 4 |
5710 | 5710 | 5709 | {"type": "Polygon", "coordinates": [[[-118.2722, 34.12839], [-118.27164, 34.12791], [-118.2691, 34.12331], [-118.26956, 34.12305], [-118.26994, 34.12261], [-118.27156, 34.12603], [-118.2722, 34.12839]]]} | Restricted Access 2 | 45780 | Los Feliz Golf Course | 28786 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://golf.lacity.org/cdp_los_feliz.htm | Los Angeles 6 | 11.795 | Los Feliz GC | 0 | Local Recreation Area 3 | 4 |
5739 | 5739 | 5738 | {"type": "Polygon", "coordinates": [[[-117.86368, 33.71492], [-117.86366, 33.71591], [-117.86257, 33.71591], [-117.86257, 33.715], [-117.86248, 33.71499], [-117.86248, 33.71487], [-117.86359, 33.71488], [-117.86359, 33.71492], [-117.86368, 33.71492]]]} | Restricted Access 2 | 47437 | Monroe Elementary School Field | 31153 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 2.918 | Monroe Elementary School Field | 0 | Local Recreation Area 3 | 4 | |
5740 | 5740 | 5739 | {"type": "Polygon", "coordinates": [[[-117.90815, 33.749], [-117.90761, 33.74987], [-117.90711, 33.75063], [-117.9066, 33.75137], [-117.9061, 33.75206], [-117.90563, 33.75177], [-117.9056, 33.75179], [-117.90382, 33.75069], [-117.90435, 33.74984], [-117.90502, 33.75014], [-117.90503, 33.75021], [-117.90483, 33.75055], [-117.90576, 33.75095], [-117.90624, 33.75015], [-117.90651, 33.75028], [-117.90653, 33.75028], [-117.90651, 33.74904], [-117.90667, 33.74904], [-117.90668, 33.74906], [-117.90714, 33.74906], [-117.90715, 33.74901], [-117.90815, 33.749]]]} | Restricted Access 2 | 47438 | Spurgeon Intermediate School Field | 31154 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 12.376 | Spurgeon Intermediate School Field | 0 | Local Recreation Area 3 | 4 | |
6170 | 6170 | 6169 | {"type": "MultiPolygon", "coordinates": [[[[-119.00412, 36.06444], [-119.00205, 36.06442], [-119.00204, 36.06457], [-119.00206, 36.06564], [-119.00082, 36.06562], [-119.00081, 36.06569], [-118.99981, 36.06569], [-118.99979, 36.0629], [-119.00339, 36.06294], [-119.00388, 36.06365], [-119.00412, 36.06444]]], [[[-119.00453, 36.06712], [-119.00453, 36.06755], [-119.00411, 36.06755], [-119.0041, 36.06711], [-119.00453, 36.06712]]], [[[-119.0045, 36.06776], [-119.0045, 36.06847], [-119.00412, 36.06847], [-119.00412, 36.06776], [-119.0045, 36.06776]]]]} | Restricted Access 2 | 1184 | Murry Park and Porterville Municipal Golf Course | 32995 | 1260 | Porterville, City of 139 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | Tulare 29 | 22.939 | Murry Park and Porterville Municipal GC | 0 | Local Recreation Area 3 | 4 | |
6254 | 6254 | 6253 | {"type": "MultiPolygon", "coordinates": [[[[-116.72083, 32.70426], [-116.71907, 32.7045], [-116.71873, 32.70456], [-116.7182, 32.70471], [-116.71793, 32.70482], [-116.71767, 32.70496], [-116.71735, 32.70515], [-116.71708, 32.70537], [-116.71398, 32.70808], [-116.71371, 32.70826], [-116.71349, 32.70839], [-116.71319, 32.70853], [-116.71283, 32.70866], [-116.70883, 32.70798], [-116.70426, 32.70803], [-116.70439, 32.71165], [-116.70677, 32.71163], [-116.70672, 32.71196], [-116.70667, 32.7121], [-116.70658, 32.71228], [-116.70649, 32.71241], [-116.70538, 32.71375], [-116.70517, 32.71411], [-116.70506, 32.71444], [-116.70502, 32.71464], [-116.705, 32.71489], [-116.70499, 32.71695], [-116.70495, 32.71993], [-116.7049, 32.72027], [-116.70478, 32.72064], [-116.70461, 32.72097], [-116.70444, 32.72123], [-116.70424, 32.72147], [-116.70405, 32.72166], [-116.69956, 32.72557], [-116.69966, 32.7224], [-116.69545, 32.72241], [-116.6953, 32.72599], [-116.6909, 32.726], [-116.69148, 32.71532], [-116.69577, 32.71527], [-116.69593, 32.71173], [-116.7001, 32.71169], [-116.69997, 32.7081], [-116.70112, 32.70807], [-116.70099, 32.7045], [-116.69554, 32.70453], [-116.69514, 32.69711], [-116.6819, 32.69715], [-116.68214, 32.70068], [-116.67793, 32.70075], [-116.67876, 32.71169], [-116.6786, 32.71546], [-116.68281, 32.71546], [-116.68266, 32.71901], [-116.68694, 32.71903], [-116.68659, 32.7261], [-116.67808, 32.72613], [-116.67826, 32.7226], [-116.66961, 32.72265], [-116.66984, 32.71904], [-116.67418, 32.71895], [-116.67435, 32.71542], [-116.6661, 32.71554], [-116.66639, 32.71171], [-116.66252, 32.71174], [-116.66225, 32.70812], [-116.66611, 32.70808], [-116.66584, 32.7045], [-116.66983, 32.70446], [-116.66933, 32.69723], [-116.66139, 32.69733], [-116.66126, 32.69371], [-116.65721, 32.69375], [-116.65703, 32.69021], [-116.65041, 32.68985], [-116.64504, 32.6896], [-116.64512, 32.68579], [-116.64145, 32.68553], [-116.62402, 32.686], [-116.62403, 32.68245], [-116.61982, 32.68242], [-116.61983, 32.67894], [-116.62406, 32.67895], [-116.62828, 32.67883], [-116.62843, 32.68226], [-116.64162, 32.6817], [-116.65303, 32.68272], [-116.65312, 32.68635], [-116.65685, 32.68666], [-116.66102, 32.68661], [-116.66116, 32.69017], [-116.66941, 32.69001], [-116.66943, 32.68647], [-116.66522, 32.68654], [-116.66518, 32.67936], [-116.66938, 32.67923], [-116.66936, 32.66864], [-116.67387, 32.66853], [-116.67418, 32.66477], [-116.67836, 32.6647], [-116.67912, 32.65372], [-116.68316, 32.65371], [-116.68281, 32.65012], [-116.69142, 32.65005], [-116.69107, 32.6537], [-116.68713, 32.65371], [-116.68691, 32.66092], [-116.68275, 32.66096], [-116.68232, 32.66832], [-116.67809, 32.66843], [-116.67805, 32.67191], [-116.67386, 32.67198], [-116.67382, 32.68271], [-116.68213, 32.68268], [-116.68206, 32.68638], [-116.68642, 32.68631], [-116.68641, 32.68978], [-116.69093, 32.68974], [-116.69093, 32.69145], [-116.69097, 32.69352], [-116.7085, 32.69348], [-116.70862, 32.69707], [-116.71266, 32.69772], [-116.71271, 32.7015], [-116.7208, 32.70275], [-116.72083, 32.70426]]], [[[-116.70877, 32.71161], [-116.70809, 32.72584], [-116.69953, 32.72595], [-116.69953, 32.72583], [-116.70419, 32.72176], [-116.70447, 32.72148], [-116.7047, 32.72118], [-116.70487, 32.72089], [-116.70501, 32.72058], [-116.70509, 32.7203], [-116.70515, 32.71995], [-116.70519, 32.71695], [-116.7052, 32.71484], [-116.70523, 32.71452], [-116.70534, 32.71421], [-116.70544, 32.714], [-116.70558, 32.71379], [-116.70662, 32.71254], [-116.70673, 32.71239], [-116.70683, 32.71221], [-116.7069, 32.71203], [-116.70695, 32.71184], [-116.70697, 32.71163], [-116.70877, 32.71161]]], [[[-116.71691, 32.70935], [-116.71691, 32.70935], [-116.71317, 32.70872], [-116.71348, 32.70858], [-116.71373, 32.70845], [-116.71395, 32.70831], [-116.71419, 32.70814], [-116.71683, 32.70582], [-116.71691, 32.70935]]], [[[-116.72086, 32.70635], [-116.72086, 32.70635], [-116.71693, 32.70573], [-116.71727, 32.70544], [-116.71758, 32.70521], [-116.71797, 32.705], [-116.71838, 32.70483], [-116.7187, 32.70474], [-116.719, 32.70467], [-116.72083, 32.70443], [-116.72086, 32.70635]]]]} | Restricted Access 2 | 1327 | Barrett Reservoir | 15833 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/water/recreation/reservoirs/barrett | San Diego 4 | 4177.221 | Barrett Reservoir | 0 | Local Recreation Area 3 | 4 |
6317 | 6317 | 6316 | {"type": "Polygon", "coordinates": [[[-117.28211, 34.15967], [-117.28207, 34.15968], [-117.28207, 34.16048], [-117.28042, 34.16048], [-117.28041, 34.16006], [-117.28015, 34.16006], [-117.28015, 34.15949], [-117.28008, 34.15948], [-117.28007, 34.15884], [-117.2821, 34.15884], [-117.28211, 34.15967]]]} | Restricted Access 2 | 47434 | Golden Valley School Field | 31151 | 2314 | San Bernardino City Unified School District 832 | Special District 4 | School District 14 | http://www.sbcusd.k12.ca.us/ | Special District 4 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 7.872 | Golden Valley School Field | 0 | Local Recreation Area 3 | 4 | |
6327 | 6327 | 6326 | {"type": "Polygon", "coordinates": [[[-117.30749, 34.09498], [-117.30538, 34.09499], [-117.30538, 34.09434], [-117.30548, 34.09433], [-117.30548, 34.09403], [-117.30749, 34.09403], [-117.30749, 34.09498]]]} | Restricted Access 2 | 47431 | Richardson School Field | 31149 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 5.028 | Richardson School Field | 0 | Local Recreation Area 3 | 4 | |
6328 | 6328 | 6327 | {"type": "Polygon", "coordinates": [[[-117.89836, 33.72183], [-117.8983, 33.72317], [-117.89797, 33.72315], [-117.89796, 33.72316], [-117.89797, 33.72355], [-117.89832, 33.72355], [-117.89835, 33.72428], [-117.8943, 33.72425], [-117.8943, 33.72338], [-117.89435, 33.72295], [-117.89452, 33.72237], [-117.89471, 33.72195], [-117.89481, 33.72179], [-117.89488, 33.72177], [-117.89525, 33.72176], [-117.89683, 33.72176], [-117.897, 33.72177], [-117.89752, 33.72184], [-117.89836, 33.72183]]]} | Restricted Access 2 | 47436 | Valley High School Field | 31152 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 24.28 | Valley High School Field | 0 | Local Recreation Area 3 | 4 | |
6335 | 6335 | 6334 | {"type": "Polygon", "coordinates": [[[-117.91058, 33.72179], [-117.91047, 33.72176], [-117.91041, 33.72186], [-117.91048, 33.72189], [-117.91044, 33.72198], [-117.91045, 33.722], [-117.91032, 33.72232], [-117.91024, 33.72234], [-117.91017, 33.72238], [-117.91007, 33.72251], [-117.90997, 33.7225], [-117.90995, 33.72254], [-117.90986, 33.72251], [-117.90986, 33.72247], [-117.90977, 33.72248], [-117.9096, 33.72254], [-117.90953, 33.72264], [-117.90952, 33.72269], [-117.9094, 33.72266], [-117.90937, 33.72271], [-117.90927, 33.7227], [-117.90916, 33.72291], [-117.90914, 33.72327], [-117.90867, 33.72327], [-117.90855, 33.72329], [-117.90838, 33.72335], [-117.90792, 33.72336], [-117.90848, 33.72176], [-117.90871, 33.72179], [-117.90924, 33.72182], [-117.90951, 33.72176], [-117.90978, 33.72154], [-117.90996, 33.72132], [-117.91058, 33.72179]]]} | Restricted Access 2 | 47439 | Hector G. Godinez High School Field | 31155 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.664 | Hector G. Godinez High School Field | 0 | Local Recreation Area 3 | 4 | |
6341 | 6341 | 6340 | {"type": "Polygon", "coordinates": [[[-117.84173, 33.89423], [-117.83972, 33.89424], [-117.83966, 33.89199], [-117.8408, 33.89197], [-117.84079, 33.89285], [-117.84024, 33.89286], [-117.84024, 33.89331], [-117.84092, 33.89332], [-117.84092, 33.89378], [-117.84123, 33.89378], [-117.84122, 33.89348], [-117.84171, 33.89348], [-117.84173, 33.89423]]]} | Restricted Access 2 | 47441 | Rose Drive Elementary School Recreational Facilities | 31157 | 2410 | Placentia-Yorba Linda Unified School District 833 | Special District 4 | School District 14 | http://www.pylusd.org/ | Special District 4 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 7.295 | Rose Drive Elementary School Recreational Facilities | 0 | Local Recreation Area 3 | 4 | |
6410 | 6410 | 6409 | {"type": "MultiPolygon", "coordinates": [[[[-120.85781, 35.47038], [-120.8576, 35.47052], [-120.85741, 35.47067], [-120.85723, 35.47086], [-120.8571, 35.47104], [-120.85699, 35.47122], [-120.85691, 35.47142], [-120.85681, 35.47178], [-120.85678, 35.47199], [-120.85565, 35.47199], [-120.85497, 35.47201], [-120.85379, 35.47197], [-120.8534, 35.47197], [-120.85344, 35.47036], [-120.85781, 35.47038]]], [[[-120.86826, 35.4694], [-120.86824, 35.47331], [-120.85682, 35.47326], [-120.85741, 35.47321], [-120.85761, 35.47316], [-120.85778, 35.47306], [-120.85828, 35.47261], [-120.85842, 35.47254], [-120.85857, 35.4725], [-120.85953, 35.47248], [-120.86111, 35.47272], [-120.86124, 35.47273], [-120.86386, 35.47235], [-120.86401, 35.47228], [-120.86412, 35.4722], [-120.86534, 35.47097], [-120.86548, 35.47086], [-120.86571, 35.47079], [-120.86695, 35.4706], [-120.8672, 35.47052], [-120.86744, 35.47039], [-120.86758, 35.47029], [-120.86772, 35.47015], [-120.86816, 35.46951], [-120.86826, 35.4694]]], [[[-120.88945, 35.45158], [-120.88818, 35.45144], [-120.88838, 35.45703], [-120.88624, 35.45705], [-120.88624, 35.4588], [-120.88128, 35.45883], [-120.87823, 35.46], [-120.87683, 35.45728], [-120.87511, 35.45676], [-120.87526, 35.46117], [-120.8775, 35.46112], [-120.87771, 35.46723], [-120.87532, 35.46729], [-120.87531, 35.4673], [-120.87557, 35.47469], [-120.87588, 35.47622], [-120.87722, 35.47508], [-120.87721, 35.47908], [-120.8759, 35.47975], [-120.87565, 35.47989], [-120.87539, 35.47989], [-120.87537, 35.47973], [-120.87514, 35.47898], [-120.87509, 35.47819], [-120.87504, 35.47807], [-120.87487, 35.47783], [-120.87482, 35.47768], [-120.87482, 35.47754], [-120.87491, 35.47734], [-120.87494, 35.47718], [-120.87493, 35.47704], [-120.87487, 35.47688], [-120.87474, 35.47671], [-120.87457, 35.47659], [-120.87438, 35.47654], [-120.87411, 35.47653], [-120.87405, 35.47651], [-120.874, 35.47647], [-120.87384, 35.47606], [-120.87366, 35.47572], [-120.87348, 35.47545], [-120.8729, 35.47469], [-120.87233, 35.47337], [-120.87221, 35.47316], [-120.87208, 35.47299], [-120.87195, 35.47286], [-120.87108, 35.47216], [-120.87052, 35.47141], [-120.87047, 35.47132], [-120.87046, 35.47124], [-120.87035, 35.46989], [-120.8703, 35.46968], [-120.87019, 35.46948], [-120.87003, 35.46929], [-120.86978, 35.46912], [-120.86953, 35.46901], [-120.86934, 35.46897], [-120.86918, 35.46895], [-120.86892, 35.46896], [-120.86862, 35.46902], [-120.86835, 35.46914], [-120.86819, 35.46926], [-120.86805, 35.4694], [-120.86762, 35.47002], [-120.86752, 35.47013], [-120.86733, 35.47029], [-120.8671, 35.47041], [-120.86682, 35.47049], [-120.86564, 35.47066], [-120.86539, 35.47075], [-120.86521, 35.47088], [-120.86402, 35.47209], [-120.86392, 35.47217], [-120.86379, 35.47222], [-120.86123, 35.47259], [-120.86113, 35.47259], [-120.85956, 35.47235], [-120.85857, 35.47236], [-120.85837, 35.47241], [-120.85818, 35.4725], [-120.85766, 35.47296], [-120.85755, 35.47303], [-120.85738, 35.47308], [-120.85686, 35.47312], [-120.85691, 35.47285], [-120.85694, 35.47257], [-120.85694, 35.47207], [-120.85696, 35.4719], [-120.85707, 35.47146], [-120.85718, 35.47122], [-120.85734, 35.47097], [-120.85759, 35.47071], [-120.85783, 35.47054], [-120.85806, 35.47042], [-120.85832, 35.47032], [-120.85864, 35.47026], [-120.8589, 35.47024], [-120.85915, 35.47025], [-120.86032, 35.47052], [-120.86065, 35.47058], [-120.86112, 35.4706], [-120.86141, 35.47058], [-120.86171, 35.47054], [-120.86194, 35.47047], [-120.86212, 35.47039], [-120.86231, 35.47027], [-120.86245, 35.47014], [-120.86254, 35.47002], [-120.86269, 35.46954], [-120.86271, 35.46939], [-120.86271, 35.46928], [-120.86268, 35.46913], [-120.86264, 35.469], [-120.86251, 35.46881], [-120.86227, 35.46857], [-120.86216, 35.46842], [-120.86209, 35.46828], [-120.86204, 35.46809], [-120.86203, 35.46792], [-120.86206, 35.46778], [-120.86233, 35.46702], [-120.86237, 35.46683], [-120.86238, 35.4667], [-120.86236, 35.46654], [-120.86228, 35.46627], [-120.86219, 35.46612], [-120.8621, 35.466], [-120.85959, 35.46311], [-120.85948, 35.46296], [-120.85933, 35.46265], [-120.85926, 35.46246], [-120.85924, 35.46231], [-120.85923, 35.46197], [-120.85927, 35.46173], [-120.86041, 35.45914], [-120.86057, 35.45894], [-120.8615, 35.45803], [-120.86159, 35.4579], [-120.86191, 35.45736], [-120.86203, 35.45721], [-120.86221, 35.45707], [-120.86294, 35.45662], [-120.86308, 35.45652], [-120.86421, 35.45532], [-120.86577, 35.45403], [-120.86593, 35.45386], [-120.86605, 35.4537], [-120.86614, 35.4535], [-120.86668, 35.45126], [-120.86676, 35.45107], [-120.86688, 35.45089], [-120.86819, 35.44942], [-120.86849, 35.44915], [-120.8689, 35.4489], [-120.86862, 35.44885], [-120.86915, 35.44846], [-120.86948, 35.44897], [-120.86973, 35.449], [-120.87005, 35.44868], [-120.87066, 35.44904], [-120.8713, 35.44837], [-120.87072, 35.448], [-120.87483, 35.44385], [-120.87733, 35.44296], [-120.87844, 35.44296], [-120.88138, 35.44564], [-120.88726, 35.44384], [-120.88744, 35.44401], [-120.88666, 35.44476], [-120.88671, 35.44593], [-120.88675, 35.44609], [-120.88685, 35.44609], [-120.88701, 35.44604], [-120.88715, 35.44596], [-120.88727, 35.44585], [-120.88734, 35.4457], [-120.88738, 35.44549], [-120.88738, 35.44535], [-120.88743, 35.44522], [-120.88749, 35.44511], [-120.88773, 35.44489], [-120.8882, 35.44523], [-120.88945, 35.45158]], [[-120.88637, 35.45027], [-120.88661, 35.44856], [-120.88343, 35.44796], [-120.8827, 35.44819], [-120.88192, 35.44819], [-120.88021, 35.44775], [-120.87965, 35.44771], [-120.87918, 35.44787], [-120.8787, 35.44789], [-120.87803, 35.44766], [-120.87683, 35.44766], [-120.87599, 35.44713], [-120.87562, 35.44682], [-120.87486, 35.44663], [-120.87374, 35.44675], [-120.87324, 35.44691], [-120.87251, 35.44739], [-120.87237, 35.44762], [-120.87226, 35.4489], [-120.87114, 35.45041], [-120.87061, 35.45085], [-120.86997, 35.45099], [-120.86941, 35.45215], [-120.86924, 35.45339], [-120.86905, 35.45373], [-120.86905, 35.4541], [-120.86924, 35.4543], [-120.86924, 35.4549], [-120.86899, 35.45561], [-120.86874, 35.45584], [-120.86809, 35.45584], [-120.86785, 35.45618], [-120.86776, 35.45671], [-120.86748, 35.45714], [-120.86698, 35.45737], [-120.86687, 35.45751], [-120.86684, 35.4577], [-120.86685, 35.45772], [-120.86703, 35.45772], [-120.86734, 35.45756], [-120.86782, 35.45758], [-120.86804, 35.45776], [-120.86849, 35.45829], [-120.86894, 35.45849], [-120.86905, 35.459], [-120.87003, 35.45989], [-120.87, 35.46051], [-120.86955, 35.46099], [-120.8695, 35.46245], [-120.86969, 35.46261], [-120.86953, 35.46305], [-120.86975, 35.4636], [-120.87006, 35.46374], [-120.87003, 35.46392], [-120.86987, 35.46408], [-120.86965, 35.46413], [-120.86979, 35.46441], [-120.87003, 35.46447], [-120.87039, 35.46435], [-120.87124, 35.46378], [-120.87137, 35.4638], [-120.8718, 35.46419], [-120.87247, 35.46431], [-120.87263, 35.46421], [-120.87263, 35.46371], [-120.87255, 35.46362], [-120.87213, 35.46353], [-120.87213, 35.46328], [-120.87275, 35.46245], [-120.8728, 35.46193], [-120.87249, 35.46145], [-120.87199, 35.46101], [-120.87196, 35.4608], [-120.8721, 35.46064], [-120.87221, 35.46014], [-120.87235, 35.45989], [-120.87246, 35.45911], [-120.87235, 35.45902], [-120.8721, 35.45787], [-120.87232, 35.45737], [-120.87224, 35.45712], [-120.87196, 35.45687], [-120.87193, 35.45584], [-120.87207, 35.45554], [-120.8728, 35.45449], [-120.87299, 35.45394], [-120.87347, 35.4538], [-120.87372, 35.45389], [-120.87433, 35.45364], [-120.87445, 35.45309], [-120.87456, 35.45298], [-120.87517, 35.45288], [-120.87548, 35.45263], [-120.87599, 35.4526], [-120.87649, 35.45251], [-120.87671, 35.45221], [-120.87688, 35.45141], [-120.87705, 35.45132], [-120.87887, 35.45137], [-120.87923, 35.45155], [-120.8792, 35.45201], [-120.87901, 35.45229], [-120.87878, 35.45309], [-120.87895, 35.45419], [-120.87906, 35.45428], [-120.87989, 35.45436], [-120.87968, 35.45347], [-120.88038, 35.45242], [-120.88105, 35.4519], [-120.88152, 35.45174], [-120.88186, 35.45206], [-120.88195, 35.45233], [-120.88275, 35.45295], [-120.88275, 35.45334], [-120.88301, 35.45368], [-120.88303, 35.45467], [-120.88331, 35.45503], [-120.8834, 35.45535], [-120.88362, 35.45533], [-120.88376, 35.45517], [-120.88421, 35.45503], [-120.88423, 35.45492], [-120.88401, 35.45467], [-120.8839, 35.4544], [-120.88415, 35.45371], [-120.88418, 35.45304], [-120.88454, 35.45256], [-120.88399, 35.45208], [-120.88393, 35.45085], [-120.88407, 35.45064], [-120.88432, 35.45064], [-120.88525, 35.45142], [-120.88585, 35.45146], [-120.88586, 35.45105], [-120.88642, 35.4505], [-120.88645, 35.45032], [-120.88637, 35.45027]]], [[[-120.86618, 35.45263], [-120.86596, 35.4535], [-120.8659, 35.45364], [-120.86578, 35.4538], [-120.86565, 35.45393], [-120.8641, 35.45522], [-120.86296, 35.45642], [-120.86284, 35.45652], [-120.86209, 35.45697], [-120.86188, 35.45714], [-120.86175, 35.45731], [-120.86143, 35.45786], [-120.86135, 35.45797], [-120.86044, 35.45885], [-120.86029, 35.45902], [-120.8602, 35.45918], [-120.85971, 35.4603], [-120.85972, 35.45707], [-120.86166, 35.45708], [-120.86208, 35.45655], [-120.86321, 35.45569], [-120.86444, 35.45449], [-120.86519, 35.45416], [-120.86614, 35.45262], [-120.86618, 35.45263]]], [[[-120.87522, 35.47989], [-120.87432, 35.4799], [-120.87421, 35.47782], [-120.87294, 35.47949], [-120.87296, 35.47504], [-120.87333, 35.47552], [-120.87351, 35.47578], [-120.87365, 35.47605], [-120.87383, 35.47648], [-120.87387, 35.47656], [-120.87396, 35.47663], [-120.87406, 35.47666], [-120.87436, 35.47667], [-120.87447, 35.4767], [-120.8746, 35.47679], [-120.87472, 35.47695], [-120.87476, 35.47707], [-120.87477, 35.47718], [-120.87474, 35.47731], [-120.87466, 35.47752], [-120.87465, 35.47772], [-120.87471, 35.47786], [-120.8749, 35.47815], [-120.87493, 35.47823], [-120.87497, 35.47898], [-120.8752, 35.47976], [-120.87522, 35.47989]]], [[[-120.88888, 35.44363], [-120.8874, 35.44494], [-120.8872, 35.44475], [-120.88722, 35.44433], [-120.88762, 35.44398], [-120.88832, 35.4437], [-120.8887, 35.44344], [-120.88888, 35.44363]]]]} | Restricted Access 2 | 1848 | Whale Rock Reservoir | 27446 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1098.807 | Whale Rock Reservoir | 0 | Local Recreation Area 3 | 4 | |
6636 | 6636 | 6635 | {"type": "Polygon", "coordinates": [[[-117.58444, 34.02028], [-117.58363, 34.02028], [-117.58362, 34.01981], [-117.58128, 34.0198], [-117.58127, 34.02195], [-117.58018, 34.02194], [-117.58018, 34.01914], [-117.58444, 34.01915], [-117.58444, 34.02028]]]} | Restricted Access 2 | 4398 | Creekside Park and Golf Course | 33000 | 1232 | Ontario, City of 126 | City 2 | City Agency 2 | http://www.ci.ontario.ca.us/index.aspx?page=456 | City 2 | 1232 | Ontario, City of 123 | City 2 | City Agency 2 | San Bernardino 22 | 14.022 | Creekside Park and GC | 0 | Local Recreation Area 3 | 4 | |
7233 | 7233 | 7232 | {"type": "Polygon", "coordinates": [[[-118.17442, 34.11313], [-118.17382, 34.11314], [-118.17249, 34.1138], [-118.1717, 34.11481], [-118.17141, 34.1152], [-118.17123, 34.11541], [-118.17064, 34.11525], [-118.17023, 34.11568], [-118.1699, 34.11588], [-118.16957, 34.11604], [-118.1687, 34.11633], [-118.1684, 34.11659], [-118.16778, 34.11722], [-118.16752, 34.1172], [-118.16721, 34.11715], [-118.16702, 34.11722], [-118.16668, 34.1172], [-118.16617, 34.11698], [-118.16631, 34.1167], [-118.16644, 34.11652], [-118.16714, 34.1158], [-118.16736, 34.11565], [-118.16786, 34.11535], [-118.16903, 34.11436], [-118.17094, 34.11312], [-118.17138, 34.11306], [-118.1719, 34.11287], [-118.17256, 34.11271], [-118.17296, 34.1125], [-118.17362, 34.11232], [-118.17402, 34.11239], [-118.17442, 34.11313]]]} | Restricted Access 2 | 6930 | Arroyo Seco Golf Course | 29411 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.arroyosecogolf.com/Home.html | Los Angeles 6 | 31.16 | Arroyo Seco GC | 0 | Local Recreation Area 3 | 4 |
7252 | 7252 | 7251 | {"type": "Polygon", "coordinates": [[[-118.10792, 33.88199], [-118.10716, 33.882], [-118.10715, 33.88191], [-118.10454, 33.88194], [-118.10453, 33.88189], [-118.10437, 33.88189], [-118.10433, 33.88166], [-118.10432, 33.88045], [-118.10422, 33.88025], [-118.10504, 33.88024], [-118.1051, 33.87876], [-118.10616, 33.87877], [-118.10629, 33.88012], [-118.10716, 33.88009], [-118.10714, 33.87968], [-118.10709, 33.87933], [-118.10649, 33.87707], [-118.10742, 33.87714], [-118.10767, 33.87811], [-118.10775, 33.87855], [-118.10785, 33.87922], [-118.10789, 33.87966], [-118.10791, 33.88021], [-118.10771, 33.88022], [-118.10771, 33.88026], [-118.10791, 33.88027], [-118.10792, 33.88199]]]} | Restricted Access 2 | 20050 | Cerritos Iron Wood Nine Golf Course | 33069 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.cerritos.us/RESIDENTS/recreation/facilities/iron_wood_nine_golf_course.php | Los Angeles 6 | 26.76 | Cerritos Iron Wood Nine GC | 0 | Local Recreation Area 3 | 4 |
7283 | 7283 | 7282 | {"type": "MultiPolygon", "coordinates": [[[[-118.14175, 33.82338], [-118.13512, 33.82334], [-118.13509, 33.82283], [-118.13466, 33.82244], [-118.13408, 33.82244], [-118.13409, 33.81902], [-118.13416, 33.81896], [-118.13886, 33.81895], [-118.139, 33.81906], [-118.1391, 33.81948], [-118.13924, 33.81986], [-118.13935, 33.82009], [-118.13975, 33.82078], [-118.13995, 33.82107], [-118.14019, 33.82136], [-118.14125, 33.82253], [-118.14146, 33.82291], [-118.14163, 33.82315], [-118.14164, 33.82326], [-118.14169, 33.82326], [-118.14175, 33.82338]]], [[[-118.13891, 33.81857], [-118.13879, 33.81867], [-118.13416, 33.81868], [-118.1341, 33.81863], [-118.13413, 33.81186], [-118.13414, 33.81143], [-118.13419, 33.81124], [-118.1342, 33.81077], [-118.13422, 33.81074], [-118.13428, 33.81072], [-118.13441, 33.81072], [-118.13496, 33.81078], [-118.13539, 33.81088], [-118.13582, 33.81105], [-118.13625, 33.81129], [-118.13757, 33.81228], [-118.13794, 33.81248], [-118.13814, 33.81256], [-118.13848, 33.81267], [-118.1388, 33.81275], [-118.1389, 33.81284], [-118.1389, 33.81374], [-118.13894, 33.81402], [-118.13894, 33.81428], [-118.13895, 33.81713], [-118.13889, 33.81799], [-118.13889, 33.81832], [-118.13891, 33.81857]]]]} | Restricted Access 2 | 6575 | Skylinks Golf Course | 33018 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 152.018 | Skylinks GC | 0 | Local Recreation Area 3 | 4 | |
7408 | 7408 | 7407 | {"type": "Polygon", "coordinates": [[[-117.04334, 32.65988], [-117.04285, 32.66126], [-117.0421, 32.66117], [-117.0413, 32.66018], [-117.0412, 32.66015], [-117.04094, 32.66055], [-117.04015, 32.66116], [-117.03857, 32.66186], [-117.03858, 32.66188], [-117.04059, 32.66212], [-117.0408, 32.66229], [-117.04084, 32.66253], [-117.04076, 32.6627], [-117.04062, 32.66285], [-117.04042, 32.66298], [-117.0394, 32.6633], [-117.03913, 32.66334], [-117.03859, 32.66336], [-117.03512, 32.66317], [-117.03443, 32.66331], [-117.03443, 32.66338], [-117.03373, 32.66363], [-117.03301, 32.66462], [-117.03291, 32.6647], [-117.03277, 32.66475], [-117.03263, 32.66475], [-117.0325, 32.66471], [-117.03167, 32.6642], [-117.03148, 32.66413], [-117.03126, 32.66409], [-117.03101, 32.6641], [-117.03087, 32.66414], [-117.03072, 32.66419], [-117.02943, 32.66491], [-117.02923, 32.66453], [-117.02836, 32.66501], [-117.02643, 32.66623], [-117.02661, 32.66667], [-117.02554, 32.66792], [-117.02303, 32.66863], [-117.02316, 32.66727], [-117.02417, 32.66612], [-117.02392, 32.66566], [-117.02415, 32.66546], [-117.02459, 32.66513], [-117.02715, 32.66335], [-117.0274, 32.66315], [-117.02752, 32.66308], [-117.02757, 32.66312], [-117.02804, 32.66286], [-117.0291, 32.66239], [-117.03265, 32.66094], [-117.03297, 32.66083], [-117.0334, 32.66074], [-117.03377, 32.66071], [-117.03417, 32.66071], [-117.03416, 32.66077], [-117.03466, 32.66116], [-117.03456, 32.6616], [-117.03457, 32.66161], [-117.03539, 32.66154], [-117.03567, 32.66154], [-117.03594, 32.66152], [-117.03618, 32.66147], [-117.03638, 32.66141], [-117.03682, 32.66123], [-117.03705, 32.66111], [-117.03713, 32.66119], [-117.04058, 32.65915], [-117.04032, 32.65881], [-117.04048, 32.65871], [-117.04051, 32.65874], [-117.0416, 32.65884], [-117.04165, 32.65879], [-117.04334, 32.65988]]]} | Restricted Access 2 | 7602 | Chula Vista Municipal Golf Course | 33025 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistagc.com/ | San Diego 4 | 128.631 | Chula Vista Municipal GC | 0 | Local Recreation Area 3 | 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]);