units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 40
- East Bay Regional Park District 40
- San Diego, City of 39
- Long Beach, City of 33
- El Dorado, County of 31
- Los Angeles, County of 20
- Valley-Wide Recreation and Park District 20
- San Jose, City of 19
- Murrieta, City of 19
- Mountains Recreation and Conservation Authority 18
- San Jacinto, City of 16
- San Diego, County of 14
- Sunrise Recreation and Park District 14
- Azusa, City of 13
- Los Angeles - Department of Parks and Recreation, County of 13
- Whittier, City of 12
- Stockton, City of 12
- Orange, County of 11
- Temecula, City of 11
- Manteca, City of 11
- Sonoma County Regional Parks Dept., County of 10
- Beverly Hills, City of 10
- Fresno Metropolitan Flood Control District 10
- San Ramon, City of 9
- Palmdale, City of 9
- Bakersfield, City of 9
- Napa, City of 9
- Consumnes Community Services District 9
- Perris, City of 8
- Beaumont, City of 8
- …
MNG_AG_TYP 13
ACCESS_TYP 4
- Open Access 1,007
- Restricted Access 83
- No Public Access 19
- Unknown Access 4
DES_TP 1
- Local Park · 1,113 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13194 | 13194 | 13193 | {"type": "Polygon", "coordinates": [[[-121.53929, 36.84003], [-121.53858, 36.84054], [-121.5378, 36.8404], [-121.5373, 36.84034], [-121.53695, 36.84032], [-121.53817, 36.83949], [-121.53929, 36.84003]]]} | Open Access 1 | 35257 | Lang Street Park | 28553 | 1304 | San Juan Bautista, City of 856 | City 2 | City Agency 2 | http://www.san-juan-bautista.ca.us/ | City 2 | 1304 | San Juan Bautista, City of 834 | City 2 | City Agency 2 | San Benito 38 | 3.062 | Lang Street Park | 0 | Local Park 2 | 4 | |
13211 | 13211 | 13210 | {"type": "Polygon", "coordinates": [[[-120.65903, 35.28087], [-120.65874, 35.28105], [-120.65843, 35.2807], [-120.65888, 35.2807], [-120.65903, 35.28087]]]} | Open Access 1 | 35247 | Cheng Park | 28552 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.288 | Cheng Park | 0 | Local Park 2 | 4 | |
13224 | 13224 | 13223 | {"type": "MultiPolygon", "coordinates": [[[[-117.09269, 32.55829], [-117.09263, 32.56415], [-117.09055, 32.56414], [-117.09051, 32.56369], [-117.08947, 32.56369], [-117.08949, 32.56007], [-117.09055, 32.56006], [-117.09056, 32.55828], [-117.09269, 32.55829]]], [[[-117.10137, 32.56011], [-117.10133, 32.56544], [-117.09793, 32.56548], [-117.0971, 32.56548], [-117.09709, 32.56469], [-117.09388, 32.56469], [-117.09387, 32.56424], [-117.09282, 32.56424], [-117.09285, 32.55829], [-117.09377, 32.55829], [-117.09567, 32.559], [-117.09568, 32.55829], [-117.09604, 32.55829], [-117.09604, 32.55914], [-117.09819, 32.55915], [-117.09819, 32.55956], [-117.09926, 32.55957], [-117.09926, 32.56009], [-117.10137, 32.56011]]]]} | Open Access 1 | 45246 | Tijuana River Valley Regional Park | 13879 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 169.576 | Tijuana River Valley RP | 0 | Local Park 2 | 4 |
13285 | 13285 | 13284 | {"type": "Polygon", "coordinates": [[[-118.3602, 33.86163], [-118.35988, 33.86163], [-118.35987, 33.86189], [-118.359, 33.86189], [-118.359, 33.8606], [-118.3602, 33.8606], [-118.3602, 33.86163]]]} | Open Access 1 | 44082 | Franklin Park | 19065 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 3.734 | Franklin Park | 0 | Local Park 2 | 4 | |
13313 | 13313 | 13312 | {"type": "Polygon", "coordinates": [[[-120.87486, 37.05002], [-120.87486, 37.05031], [-120.87472, 37.05043], [-120.87464, 37.0504], [-120.87454, 37.05043], [-120.8745, 37.05038], [-120.87432, 37.05028], [-120.87433, 37.04996], [-120.87486, 37.05002]]]} | Open Access 1 | 35378 | Village Park | 33696 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.507 | Village Park | 0 | Local Park 2 | 4 | |
13411 | 13411 | 13410 | {"type": "Polygon", "coordinates": [[[-117.32935, 33.66648], [-117.32846, 33.66623], [-117.32853, 33.66509], [-117.32905, 33.66522], [-117.32919, 33.66557], [-117.32929, 33.66596], [-117.32935, 33.66648]]]} | Open Access 1 | 35521 | City Park | 17342 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 2.243 | City Park | 0 | Local Park 2 | 4 | |
13452 | 13452 | 13451 | {"type": "Polygon", "coordinates": [[[-121.05734, 38.6586], [-121.05697, 38.65922], [-121.05661, 38.65869], [-121.05709, 38.65863], [-121.05734, 38.6586]]]} | Open Access 1 | 35646 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.505 | RP | 0 | Local Park 2 | 4 | |
13454 | 13454 | 13453 | {"type": "Polygon", "coordinates": [[[-116.39879, 33.82366], [-116.39697, 33.82366], [-116.39696, 33.82193], [-116.39701, 33.82189], [-116.39701, 33.82177], [-116.39697, 33.82173], [-116.39696, 33.8216], [-116.39701, 33.82156], [-116.39701, 33.82145], [-116.39697, 33.82139], [-116.39697, 33.82105], [-116.39702, 33.821], [-116.39702, 33.82089], [-116.39697, 33.82084], [-116.39697, 33.8205], [-116.39702, 33.82045], [-116.39701, 33.82032], [-116.39697, 33.82028], [-116.39698, 33.82013], [-116.39701, 33.8201], [-116.39879, 33.8201], [-116.39879, 33.82366]]]} | Restricted Access 2 | 35667 | Thousand Palms Community Park | 31650 | 2318 | Palm Springs Unified School District 1058 | Special District 4 | School District 14 | http://www.psusd.us/ | Special District 4 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 16.4 | Thousand Palms Community Park | 0 | Local Park 2 | 4 | |
13498 | 13498 | 13497 | {"type": "Polygon", "coordinates": [[[-117.99482, 34.0355], [-117.99427, 34.03605], [-117.99393, 34.03583], [-117.99375, 34.036], [-117.99242, 34.03508], [-117.99314, 34.03435], [-117.99482, 34.0355]]]} | Open Access 1 | 45698 | Avenue Park | 28597 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Avenue_Park | Los Angeles 6 | 4.957 | Avenue Park | 0 | Local Park 2 | 4 |
13531 | 13531 | 13530 | {"type": "Polygon", "coordinates": [[[-117.79047, 34.00735], [-117.79026, 34.0077], [-117.78999, 34.0084], [-117.78987, 34.00849], [-117.78946, 34.00861], [-117.78881, 34.00738], [-117.78917, 34.00745], [-117.78965, 34.00748], [-117.79008, 34.00744], [-117.79047, 34.00735]]]} | Open Access 1 | 35832 | Silver Tip Park | 28565 | 1085 | Diamond Bar, City of 315 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | Los Angeles 6 | 2.875 | Silver Tip Park | 0 | Local Park 2 | 4 | |
13592 | 13592 | 13591 | {"type": "Polygon", "coordinates": [[[-122.67605, 39.02326], [-122.67603, 39.0234], [-122.67559, 39.02335], [-122.67556, 39.02348], [-122.67511, 39.02344], [-122.67522, 39.02283], [-122.67546, 39.02268], [-122.67605, 39.02326]]]} | Open Access 1 | 35927 | Nylander County Park | 31180 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 1.079 | Nylander County Park | 0 | Local Park 2 | 4 | |
13600 | 13600 | 13599 | {"type": "Polygon", "coordinates": [[[-122.63516, 38.74947], [-122.63921, 38.75517], [-122.63967, 38.75585], [-122.63994, 38.75632], [-122.64033, 38.75706], [-122.6411, 38.75872], [-122.64111, 38.75882], [-122.64108, 38.75887], [-122.64102, 38.75892], [-122.64095, 38.75895], [-122.64084, 38.75895], [-122.64033, 38.75884], [-122.63064, 38.75622], [-122.63516, 38.74947]]]} | Open Access 1 | 35941 | Middleton Trailside Park | 31182 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 106.712 | Middleton Trailside Park | 0 | Local Park 2 | 4 | |
13630 | 13630 | 13629 | {"type": "Polygon", "coordinates": [[[-122.86885, 39.12496], [-122.86874, 39.1253], [-122.86734, 39.12488], [-122.86722, 39.12495], [-122.867, 39.12504], [-122.86675, 39.12513], [-122.86661, 39.1252], [-122.86634, 39.12572], [-122.86476, 39.12547], [-122.8655, 39.12316], [-122.86581, 39.12261], [-122.86586, 39.12261], [-122.86608, 39.12222], [-122.86677, 39.12251], [-122.86602, 39.12361], [-122.86717, 39.12424], [-122.86885, 39.12496]]]} | Open Access 1 | 35982 | Hammond Avenue Park | 31181 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 12.675 | Hammond Avenue Park | 0 | Local Park 2 | 4 | |
13638 | 13638 | 13637 | {"type": "Polygon", "coordinates": [[[-121.27817, 38.54514], [-121.2783, 38.54573], [-121.27833, 38.54582], [-121.27831, 38.54586], [-121.27759, 38.54614], [-121.27745, 38.54616], [-121.27732, 38.54615], [-121.27721, 38.54611], [-121.27634, 38.54566], [-121.27661, 38.54531], [-121.27509, 38.54452], [-121.27566, 38.54384], [-121.27608, 38.5443], [-121.27697, 38.54493], [-121.27817, 38.54514]]]} | Open Access 1 | 36001 | Independence Park | 20195 | 2193 | Cordova Recreation and Park District 307 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 6.633 | Independence Park | 0 | Local Park 2 | 4 | |
13639 | 13639 | 13638 | {"type": "Polygon", "coordinates": [[[-121.26874, 38.53018], [-121.2687, 38.53502], [-121.26111, 38.53501], [-121.26109, 38.54475], [-121.26089, 38.54464], [-121.26088, 38.54413], [-121.25886, 38.54414], [-121.25633, 38.54454], [-121.25597, 38.54464], [-121.25564, 38.54479], [-121.25542, 38.54493], [-121.25426, 38.54579], [-121.2541, 38.54594], [-121.25402, 38.54608], [-121.25397, 38.54623], [-121.25397, 38.54664], [-121.25227, 38.54904], [-121.2513, 38.55025], [-121.25199, 38.55103], [-121.25238, 38.55116], [-121.25363, 38.55257], [-121.25416, 38.55259], [-121.25423, 38.55434], [-121.25474, 38.55457], [-121.25778, 38.55443], [-121.25843, 38.55461], [-121.25845, 38.55481], [-121.25864, 38.55486], [-121.25868, 38.55468], [-121.25898, 38.55476], [-121.25975, 38.55439], [-121.26094, 38.5544], [-121.26093, 38.55672], [-121.26216, 38.55957], [-121.26093, 38.55956], [-121.26092, 38.55945], [-121.25463, 38.5594], [-121.25465, 38.55926], [-121.25464, 38.55909], [-121.2546, 38.55895], [-121.25454, 38.55879], [-121.25444, 38.55864], [-121.25434, 38.55852], [-121.2542, 38.55839], [-121.25404, 38.55828], [-121.25374, 38.55814], [-121.25337, 38.55805], [-121.2528, 38.55794], [-121.251, 38.55763], [-121.25056, 38.5575], [-121.25019, 38.55734], [-121.24995, 38.55721], [-121.24972, 38.55706], [-121.24562, 38.55413], [-121.24536, 38.5539], [-121.24523, 38.55376], [-121.24482, 38.55281], [-121.24492, 38.55137], [-121.24467, 38.54633], [-121.24474, 38.5401], [-121.2446, 38.53844], [-121.24457, 38.52893], [-121.24472, 38.52761], [-121.24488, 38.52634], [-121.24503, 38.52572], [-121.25171, 38.52563], [-121.25181, 38.52564], [-121.26099, 38.52833], [-121.26874, 38.53018]]]} | Open Access 1 | 36000 | Mather Regional Park | 9992 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.regionalparks.saccounty.net/Parks/RegionalParksDetails/Pages/MatherRegionalPark.aspx | Sacramento 41 | 1144.635 | Mather RP | 0 | Local Park 2 | 4 |
13641 | 13641 | 13640 | {"type": "Polygon", "coordinates": [[[-121.17868, 38.65142], [-121.17808, 38.65232], [-121.17797, 38.6525], [-121.17783, 38.65284], [-121.17776, 38.65318], [-121.17699, 38.65315], [-121.17613, 38.65317], [-121.17609, 38.65268], [-121.17577, 38.6522], [-121.1761, 38.65206], [-121.17637, 38.65187], [-121.17678, 38.65132], [-121.17709, 38.65108], [-121.17728, 38.65089], [-121.17868, 38.65142]]]} | Open Access 1 | 36008 | Ernie Sheldon Park | 18698 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 9.41 | Ernie Sheldon Park | 0 | Local Park 2 | 4 | |
13643 | 13643 | 13642 | {"type": "Polygon", "coordinates": [[[-121.35818, 38.70102], [-121.35718, 38.70101], [-121.35719, 38.70042], [-121.35676, 38.69988], [-121.35614, 38.69967], [-121.35646, 38.69952], [-121.35742, 38.69916], [-121.35768, 38.69907], [-121.35798, 38.69901], [-121.35812, 38.69949], [-121.35818, 38.69954], [-121.35812, 38.6996], [-121.35811, 38.69966], [-121.35815, 38.69976], [-121.35825, 38.70096], [-121.35823, 38.701], [-121.35818, 38.70102]]]} | Open Access 1 | 36020 | Ridgepoint Park | 24355 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 5.636 | Ridgepoint Park | 0 | Local Park 2 | 4 | |
13644 | 13644 | 13643 | {"type": "MultiPolygon", "coordinates": [[[[-121.44956, 38.5861], [-121.44954, 38.5864], [-121.44955, 38.58802], [-121.44936, 38.58792], [-121.4492, 38.58787], [-121.44913, 38.58782], [-121.44894, 38.58773], [-121.44885, 38.58766], [-121.4487, 38.58762], [-121.44846, 38.58746], [-121.4483, 38.5874], [-121.44784, 38.58717], [-121.4482, 38.58685], [-121.44865, 38.58653], [-121.44913, 38.58628], [-121.44956, 38.5861]]], [[[-121.46355, 38.58344], [-121.46215, 38.58683], [-121.46184, 38.58692], [-121.46141, 38.58712], [-121.46114, 38.58726], [-121.46079, 38.58738], [-121.46041, 38.58758], [-121.46024, 38.58765], [-121.45999, 38.58773], [-121.45976, 38.58783], [-121.45965, 38.5879], [-121.45951, 38.58792], [-121.45935, 38.58799], [-121.45887, 38.58812], [-121.45856, 38.58826], [-121.45831, 38.58832], [-121.45816, 38.58841], [-121.45787, 38.58852], [-121.45762, 38.58859], [-121.45712, 38.58871], [-121.45676, 38.58886], [-121.45656, 38.58889], [-121.45634, 38.58902], [-121.45611, 38.58907], [-121.4558, 38.58918], [-121.45557, 38.58921], [-121.45536, 38.58927], [-121.45514, 38.58926], [-121.45503, 38.58927], [-121.45478, 38.58938], [-121.45421, 38.5894], [-121.45392, 38.58948], [-121.45354, 38.58946], [-121.45327, 38.58955], [-121.45241, 38.58956], [-121.45215, 38.58947], [-121.45183, 38.58944], [-121.45163, 38.58929], [-121.45135, 38.5898], [-121.45077, 38.58953], [-121.45073, 38.58877], [-121.45066, 38.58876], [-121.45063, 38.58827], [-121.45067, 38.5878], [-121.45113, 38.58571], [-121.45191, 38.58557], [-121.45271, 38.58546], [-121.45391, 38.58533], [-121.45575, 38.58518], [-121.45829, 38.58509], [-121.45864, 38.58506], [-121.45907, 38.58501], [-121.45958, 38.5849], [-121.45999, 38.58477], [-121.46046, 38.58459], [-121.46091, 38.58437], [-121.46132, 38.58411], [-121.4617, 38.58382], [-121.46203, 38.5835], [-121.46236, 38.58311], [-121.46355, 38.58344]]]]} | Open Access 1 | 36002 | Sutters Landing Regional Park | 26087 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 108.631 | Sutters Landing RP | 0 | Local Park 2 | 4 | |
13645 | 13645 | 13644 | {"type": "Polygon", "coordinates": [[[-120.98031, 38.61693], [-120.98021, 38.62778], [-120.97558, 38.62784], [-120.97572, 38.61698], [-120.98031, 38.61693]]]} | Open Access 1 | 36004 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 119.729 | RP | 0 | Local Park 2 | 4 | |
13646 | 13646 | 13645 | {"type": "Polygon", "coordinates": [[[-116.97354, 32.83713], [-116.97353, 32.83828], [-116.97352, 32.83831], [-116.97349, 32.83833], [-116.96945, 32.83826], [-116.96948, 32.83738], [-116.97011, 32.83739], [-116.97013, 32.83657], [-116.97133, 32.8366], [-116.97132, 32.83709], [-116.97354, 32.83713]]]} | Open Access 1 | 45974 | Santee Mini Park | 29124 | 2384 | Port of Los Angeles 289 | Special District 4 | Port/Harbor District 15 | http://www.portoflosangeles.org/ | Special District 4 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=67 | San Diego 4 | 13.58 | Santee MP | 0 | Local Park 2 | 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]);