units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where COUNTY = 8, MNG_AGENCY = 168 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
DES_TP 3
MNG_AG_TYP 1
- City Agency · 19 ✖
MNG_AGENCY 1
- Moorpark, City of · 19 ✖
ACCESS_TYP 1
- Open Access 19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
441 | 441 | 440 | {"type": "Polygon", "coordinates": [[[-118.85799, 34.28692], [-118.85787, 34.28768], [-118.8578, 34.28774], [-118.85765, 34.28776], [-118.85737, 34.28709], [-118.85799, 34.28692]]]} | Open Access 1 | 1773 | Virginia Colony Park | 27157 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 0.801 | Virginia Colony Park | 0 | Local Park 2 | 4 | |
2558 | 2558 | 2557 | {"type": "Polygon", "coordinates": [[[-118.86313, 34.27395], [-118.86268, 34.27401], [-118.86263, 34.27389], [-118.86243, 34.27377], [-118.86231, 34.27367], [-118.86222, 34.27365], [-118.86173, 34.27375], [-118.86155, 34.27385], [-118.86157, 34.2739], [-118.86154, 34.27398], [-118.86121, 34.27422], [-118.86114, 34.27423], [-118.86108, 34.27409], [-118.86095, 34.27399], [-118.86078, 34.27394], [-118.86064, 34.27388], [-118.86054, 34.27388], [-118.86042, 34.27393], [-118.86037, 34.27389], [-118.8603, 34.2734], [-118.86042, 34.27334], [-118.8605, 34.27327], [-118.86052, 34.27313], [-118.86076, 34.27301], [-118.86124, 34.27284], [-118.86133, 34.27278], [-118.86149, 34.27265], [-118.86165, 34.27243], [-118.86173, 34.27237], [-118.86189, 34.27233], [-118.86219, 34.27234], [-118.8629, 34.27227], [-118.86283, 34.27276], [-118.86285, 34.27315], [-118.86289, 34.27336], [-118.86295, 34.27356], [-118.86303, 34.27377], [-118.86313, 34.27395]]]} | Open Access 1 | 17831 | Miller Park | 22244 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 8.208 | Miller Park | 0 | Local Park 2 | 4 | |
4799 | 4799 | 4798 | {"type": "Polygon", "coordinates": [[[-118.86173, 34.28582], [-118.86002, 34.28619], [-118.85448, 34.28618], [-118.85629, 34.28478], [-118.85712, 34.28437], [-118.85736, 34.28427], [-118.85765, 34.28419], [-118.85807, 34.28414], [-118.85838, 34.28414], [-118.85869, 34.28418], [-118.85895, 34.28424], [-118.85926, 34.28436], [-118.85956, 34.28452], [-118.85984, 34.28474], [-118.85998, 34.28489], [-118.86011, 34.28504], [-118.86013, 34.28504], [-118.86021, 34.28521], [-118.86035, 34.28538], [-118.86048, 34.2855], [-118.86063, 34.28561], [-118.86086, 34.28572], [-118.86114, 34.2858], [-118.86143, 34.28584], [-118.86173, 34.28582]]]} | Open Access 1 | 48610 | Unnamed site - Moorpark, City of | 33324 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 21.958 | 0 | Local Other or Unknown 14 | 4 | ||
5507 | 5507 | 5506 | {"type": "Polygon", "coordinates": [[[-118.88869, 34.28168], [-118.88869, 34.28172], [-118.88863, 34.28179], [-118.88858, 34.28198], [-118.88857, 34.28252], [-118.88847, 34.28297], [-118.88847, 34.28453], [-118.88844, 34.28456], [-118.8884, 34.28457], [-118.88725, 34.28458], [-118.88725, 34.2817], [-118.88869, 34.28168]]]} | Open Access 1 | 18681 | Poindexter Park | 23841 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 9.194 | Poindexter Park | 0 | Local Park 2 | 4 | |
5731 | 5731 | 5730 | {"type": "Polygon", "coordinates": [[[-118.8436, 34.30171], [-118.84342, 34.30169], [-118.84321, 34.30161], [-118.84301, 34.30155], [-118.84303, 34.30144], [-118.84297, 34.30129], [-118.84281, 34.3012], [-118.8426, 34.30114], [-118.84239, 34.3012], [-118.84148, 34.30226], [-118.84084, 34.30188], [-118.841, 34.30171], [-118.84174, 34.3008], [-118.84187, 34.3007], [-118.84199, 34.30055], [-118.84205, 34.30044], [-118.84222, 34.30018], [-118.84229, 34.30012], [-118.84236, 34.30013], [-118.84247, 34.30017], [-118.84271, 34.30028], [-118.84293, 34.30045], [-118.8431, 34.30063], [-118.84345, 34.30114], [-118.84353, 34.30129], [-118.8436, 34.30149], [-118.8436, 34.30171]]]} | Open Access 1 | 2259 | Campus Canyon Park | 16785 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 5.991 | Campus Canyon Park | 0 | Local Park 2 | 4 | |
6284 | 6284 | 6283 | {"type": "Polygon", "coordinates": [[[-118.89815, 34.26673], [-118.89812, 34.26676], [-118.89781, 34.26689], [-118.89761, 34.267], [-118.89743, 34.26714], [-118.89728, 34.26726], [-118.89716, 34.26741], [-118.89705, 34.26756], [-118.89697, 34.26772], [-118.89684, 34.26803], [-118.89678, 34.26807], [-118.89623, 34.26799], [-118.89413, 34.26778], [-118.89352, 34.26766], [-118.89321, 34.26756], [-118.89317, 34.26753], [-118.89348, 34.26695], [-118.89411, 34.26714], [-118.89442, 34.26722], [-118.8947, 34.26725], [-118.89511, 34.26726], [-118.89533, 34.26724], [-118.89612, 34.26713], [-118.89633, 34.26714], [-118.89673, 34.26717], [-118.8971, 34.26682], [-118.89711, 34.26678], [-118.89758, 34.26658], [-118.89804, 34.26647], [-118.89815, 34.26673]]]} | Open Access 1 | 1376 | Tierra Rejada Park | 26355 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 7.999 | Tierra Rejada Park | 0 | Local Park 2 | 4 | |
6368 | 6368 | 6367 | {"type": "Polygon", "coordinates": [[[-118.88842, 34.27655], [-118.88799, 34.27643], [-118.88629, 34.27589], [-118.88656, 34.27593], [-118.88697, 34.27595], [-118.88732, 34.27593], [-118.88746, 34.27595], [-118.88814, 34.27618], [-118.88841, 34.27624], [-118.88842, 34.27655]]]} | Open Access 1 | 1751 | Villa Campesina Park | 27099 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 1.157 | Villa Campesina Park | 0 | Local Park 2 | 4 | |
6505 | 6505 | 6504 | {"type": "Polygon", "coordinates": [[[-118.85253, 34.29375], [-118.85243, 34.29378], [-118.85235, 34.29385], [-118.85231, 34.29393], [-118.85231, 34.29404], [-118.85153, 34.29404], [-118.85145, 34.29395], [-118.85134, 34.29389], [-118.85123, 34.29388], [-118.85112, 34.29391], [-118.85088, 34.29391], [-118.85073, 34.29388], [-118.85064, 34.2939], [-118.85057, 34.29393], [-118.8505, 34.29399], [-118.85047, 34.29405], [-118.85014, 34.29405], [-118.85013, 34.29364], [-118.85012, 34.29362], [-118.85117, 34.29347], [-118.85247, 34.29348], [-118.85253, 34.29375]]]} | Open Access 1 | 2420 | Campus Park | 16787 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 2.75 | Campus Park | 0 | Local Park 2 | 4 | |
7737 | 7737 | 7736 | {"type": "Polygon", "coordinates": [[[-118.84198, 34.29485], [-118.84175, 34.29545], [-118.84186, 34.29549], [-118.84166, 34.29591], [-118.84047, 34.29591], [-118.8404, 34.29587], [-118.84039, 34.29576], [-118.84044, 34.29557], [-118.84094, 34.29433], [-118.84168, 34.29469], [-118.84194, 34.29475], [-118.84198, 34.29485]]]} | Open Access 1 | 8251 | College View Park | 17516 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 4.317 | College View Park | 0 | Local Park 2 | 4 | |
7945 | 7945 | 7944 | {"type": "Polygon", "coordinates": [[[-118.90752, 34.26316], [-118.90751, 34.26337], [-118.90747, 34.26346], [-118.90739, 34.26351], [-118.90715, 34.26357], [-118.90693, 34.2636], [-118.90676, 34.26357], [-118.90668, 34.26352], [-118.90661, 34.26335], [-118.90752, 34.26316]]]} | Open Access 1 | 10792 | Country Trail Park | 17705 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 0.649 | Country Trail Park | 0 | Local Park 2 | 4 | |
9389 | 9389 | 9388 | {"type": "Polygon", "coordinates": [[[-118.83657, 34.29536], [-118.83657, 34.29613], [-118.8359, 34.29629], [-118.83565, 34.29638], [-118.83538, 34.29651], [-118.83513, 34.29664], [-118.83522, 34.29677], [-118.83504, 34.29686], [-118.83492, 34.29671], [-118.83413, 34.29688], [-118.8339, 34.2969], [-118.83353, 34.2969], [-118.83327, 34.29693], [-118.83302, 34.297], [-118.83262, 34.29715], [-118.83211, 34.29728], [-118.83196, 34.29734], [-118.83183, 34.29745], [-118.83165, 34.29778], [-118.83188, 34.29808], [-118.83255, 34.298], [-118.83327, 34.29778], [-118.83446, 34.29787], [-118.83274, 34.29841], [-118.83204, 34.29848], [-118.83186, 34.29882], [-118.83129, 34.29939], [-118.83094, 34.29989], [-118.83057, 34.29987], [-118.83049, 34.29994], [-118.83047, 34.30022], [-118.83058, 34.30062], [-118.83067, 34.30074], [-118.82259, 34.30074], [-118.82259, 34.30255], [-118.82044, 34.30255], [-118.82087, 34.30152], [-118.82109, 34.30001], [-118.82101, 34.29947], [-118.8199, 34.29764], [-118.81979, 34.29703], [-118.82033, 34.29642], [-118.82099, 34.29625], [-118.82168, 34.29571], [-118.8224, 34.295], [-118.82239, 34.2945], [-118.82176, 34.29316], [-118.82145, 34.29225], [-118.82257, 34.29252], [-118.82372, 34.29312], [-118.82398, 34.29306], [-118.82412, 34.29333], [-118.82471, 34.29332], [-118.82458, 34.29376], [-118.82506, 34.29392], [-118.82574, 34.29357], [-118.82549, 34.29323], [-118.82667, 34.29253], [-118.82714, 34.29282], [-118.82887, 34.29263], [-118.82958, 34.29264], [-118.83004, 34.29268], [-118.83041, 34.29261], [-118.83076, 34.2928], [-118.8321, 34.29285], [-118.83367, 34.29329], [-118.83395, 34.29385], [-118.83449, 34.29436], [-118.8355, 34.29416], [-118.8361, 34.29363], [-118.83645, 34.29381], [-118.83655, 34.29426], [-118.83646, 34.29535], [-118.83657, 34.29536]], [[-118.8311, 34.29578], [-118.8312, 34.29585], [-118.83136, 34.29587], [-118.83178, 34.29553], [-118.8313, 34.2952], [-118.83078, 34.29555], [-118.8311, 34.29578]]]} | Open Access 1 | 49013 | City of Moorpark Open Space | 33711 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 255.937 | City of Moorpark OS | 0 | Local Recreation Area 3 | 4 | |
9737 | 9737 | 9736 | {"type": "Polygon", "coordinates": [[[-118.9006, 34.27489], [-118.9006, 34.27544], [-118.90058, 34.27548], [-118.90054, 34.27551], [-118.8986, 34.27552], [-118.89844, 34.2755], [-118.89837, 34.27551], [-118.89829, 34.27555], [-118.89821, 34.27565], [-118.89788, 34.27565], [-118.89788, 34.27489], [-118.9006, 34.27489]]]} | Open Access 1 | 16528 | Glenwood Park | 19341 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 4.394 | Glenwood Park | 0 | Local Park 2 | 4 | |
9744 | 9744 | 9743 | {"type": "Polygon", "coordinates": [[[-118.86949, 34.2671], [-118.86848, 34.26821], [-118.8684, 34.26834], [-118.86833, 34.26833], [-118.86824, 34.26818], [-118.86815, 34.26796], [-118.86802, 34.26774], [-118.8677, 34.26782], [-118.86769, 34.26833], [-118.86775, 34.26835], [-118.86775, 34.26906], [-118.86697, 34.26705], [-118.86777, 34.26688], [-118.86817, 34.2664], [-118.86949, 34.2671]]]} | Open Access 1 | 17904 | Monte Vista Nature Park | 22399 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 6.787 | Monte Vista Nature Park | 0 | Local Park 2 | 4 | |
9750 | 9750 | 9749 | {"type": "Polygon", "coordinates": [[[-118.90059, 34.27228], [-118.89959, 34.27278], [-118.89971, 34.27296], [-118.89908, 34.27328], [-118.89938, 34.27334], [-118.89789, 34.27409], [-118.89788, 34.27387], [-118.89773, 34.27392], [-118.89772, 34.27379], [-118.89771, 34.27378], [-118.89599, 34.27447], [-118.89474, 34.27447], [-118.89231, 34.27501], [-118.88994, 34.27501], [-118.88755, 34.27476], [-118.8843, 34.27296], [-118.8843, 34.27268], [-118.88589, 34.27236], [-118.88636, 34.27234], [-118.88663, 34.27247], [-118.88737, 34.27242], [-118.88834, 34.27218], [-118.88932, 34.27213], [-118.88986, 34.27216], [-118.89039, 34.27229], [-118.89144, 34.27238], [-118.89246, 34.27242], [-118.89355, 34.27236], [-118.89539, 34.27188], [-118.89673, 34.27339], [-118.8978, 34.27285], [-118.89876, 34.27266], [-118.8989, 34.27261], [-118.90019, 34.27194], [-118.90024, 34.27188], [-118.90026, 34.27181], [-118.90026, 34.27169], [-118.9002, 34.27161], [-118.90042, 34.27155], [-118.9005, 34.27193], [-118.90047, 34.27208], [-118.90051, 34.27212], [-118.90058, 34.27214], [-118.90059, 34.27228]]]} | Open Access 1 | 16540 | Arroyo Vista Community Park | 15636 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 77.018 | Arroyo Vista Community Park | 0 | Local Park 2 | 4 | |
10282 | 10282 | 10281 | {"type": "Polygon", "coordinates": [[[-118.89187, 34.26885], [-118.89173, 34.26904], [-118.89098, 34.27039], [-118.89097, 34.2704], [-118.89088, 34.27039], [-118.89013, 34.27004], [-118.88988, 34.26997], [-118.88977, 34.26966], [-118.88951, 34.2696], [-118.88931, 34.26951], [-118.89057, 34.26807], [-118.89187, 34.26885]]]} | Open Access 1 | 18045 | Mountain Meadows Park | 22544 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 7.988 | Mtn. Meadows Park | 0 | Local Park 2 | 4 | |
10430 | 10430 | 10429 | {"type": "Polygon", "coordinates": [[[-118.87856, 34.26877], [-118.87688, 34.26877], [-118.87688, 34.2669], [-118.87714, 34.26681], [-118.8775, 34.26659], [-118.87775, 34.2665], [-118.87794, 34.26648], [-118.87847, 34.26648], [-118.87855, 34.2665], [-118.87856, 34.26653], [-118.87856, 34.26877]]]} | Open Access 1 | 18464 | Peach Hill Park | 23540 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 9.259 | Peach Hill Park | 0 | Local Park 2 | 4 | |
13425 | 13425 | 13424 | {"type": "Polygon", "coordinates": [[[-118.88255, 34.28664], [-118.88239, 34.2867], [-118.88234, 34.28667], [-118.88234, 34.2866], [-118.88237, 34.28657], [-118.88253, 34.28657], [-118.88255, 34.28664]]]} | Open Access 1 | 35567 | Moorpark holding 1 | 22463 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 0.054 | Moorpark holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13576 | 13576 | 13575 | {"type": "Polygon", "coordinates": [[[-118.88253, 34.28657], [-118.88237, 34.28657], [-118.88234, 34.28652], [-118.88242, 34.28649], [-118.88245, 34.28654], [-118.88247, 34.28653], [-118.88253, 34.28657]]]} | Open Access 1 | 35905 | Moorpark holding 2 | 22464 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 0.02 | Moorpark holding 2 | 0 | Local Other or Unknown 14 | 4 | |
14669 | 14669 | 14668 | {"type": "Polygon", "coordinates": [[[-118.86936, 34.29973], [-118.86731, 34.30066], [-118.86665, 34.30096], [-118.86666, 34.29964], [-118.86826, 34.29891], [-118.86844, 34.2991], [-118.86857, 34.29921], [-118.86936, 34.29973]]]} | Open Access 1 | 44947 | Mammoth Highlands Park | 21717 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 7.068 | Mammoth Highlands Park | 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]);