units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 8,672
- State Agency 1,065
- Recreation/Parks District 1,049
- County Agency 1,043
- Non Profit - Land Trust 544
- Federal Agency 467
- Open Space District 396
- Water District 225
- County Agency - Parks 216
- Community Services District 191
- Home Owners Association 187
- Non Profit - Conservation 142
- Flood District 99
- Non Profit - Other 44
- Irrigation District 41
- School District 37
- Cemetery District 34
- County Agency - Other 28
- Port/Harbor District 28
- Special District - Other 15
- Commercial 14
- Joint Powers Authority 9
- Sanitation District 7
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 457
- California Department of Fish and Wildlife 411
- Los Angeles, City of 393
- California Department of Parks and Recreation 362
- Mountains Recreation and Conservation Authority 322
- Sacramento, City of 220
- San Jose, City of 199
- San Francisco, City and County of 166
- East Bay Regional Park District 162
- Los Angeles, County of 139
- Ventura, City of 138
- Roseville, City of 130
- Long Beach, City of 126
- United States Bureau of Land Management 114
- Oakland, City of 103
- Santa Barbara, County of 102
- San Diego, County of 102
- United States Forest Service 99
- Consumnes Community Services District 94
- California State Lands Commission 81
- Orange, County of 81
- Napa, City of 80
- United States Fish and Wildlife Service 79
- Stockton, City of 78
- United States National Park Service 74
- Irvine, City of 74
- Modesto, City of 74
- Tracy, City of 70
- Hayward Area Recreation and Park District 69
- Valley-Wide Recreation and Park District 64
- …
DES_TP >30
- Local Park 7,572
- Local Recreation Area 1,803
- Local Other or Unknown 1,157
- Private Conservation 570
- Local Conservation Area 435
- State Conservation Area 359
- Private Recreation or Education 249
- State Park 198
- State Resource Management Area 147
- State Recreation Area 135
- National Forest 86
- Local Historic or Cultural Area 74
- National Wildlife Refuge 72
- National Public Lands 70
- State Other or Unknown 67
- State Historic or Cultural Area 61
- Recreation Management Area 52
- Private Other or Unknown 51
- National Monument or Landmark 38
- National Recreation Area 35
- Resource Management Area 23
- Federal Other or Unknown 23
- National Park 22
- Local Resource Management Area 21
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 12,218
- Restricted Access 1,108
- No Public Access 890
- Unknown Access 370
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2483 | 2483 | 2482 | {"type": "Polygon", "coordinates": [[[-121.26919, 38.1353], [-121.26912, 38.13629], [-121.26801, 38.13624], [-121.26808, 38.13525], [-121.26919, 38.1353]]]} | Open Access 1 | 17508 | Hale Park | 19602 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 2.645 | Hale Park | 0 | Local Park 2 | 4 | |
2484 | 2484 | 2483 | {"type": "Polygon", "coordinates": [[[-118.24559, 33.90428], [-118.24551, 33.9063], [-118.24405, 33.90632], [-118.24403, 33.90632], [-118.24326, 33.9054], [-118.24324, 33.90536], [-118.24233, 33.90429], [-118.24479, 33.90362], [-118.24486, 33.90425], [-118.24559, 33.90428]]]} | Open Access 1 | 6276 | Gonzales Park | 19398 | 1065 | Compton, City of 276 | City 2 | City Agency 2 | http://www.comptoncity.org/index.php/Parks-and-Recreation/parks-and-recreation-overview.htm | City 2 | 1065 | Compton, City of 271 | City 2 | City Agency 2 | Los Angeles 6 | 14.318 | Gonzales Park | 0 | Local Park 2 | 4 | |
2485 | 2485 | 2484 | {"type": "Polygon", "coordinates": [[[-118.25232, 33.88901], [-118.2523, 33.88903], [-118.25047, 33.88932], [-118.25045, 33.8893], [-118.25034, 33.88886], [-118.2508, 33.88871], [-118.25071, 33.88831], [-118.25164, 33.8879], [-118.2517, 33.8879], [-118.25173, 33.88792], [-118.25222, 33.8887], [-118.25231, 33.88892], [-118.25232, 33.88901]]]} | Open Access 1 | 6278 | Tragniew Park | 26507 | 1065 | Compton, City of 276 | City 2 | City Agency 2 | http://www.comptoncity.org/index.php/Parks-and-Recreation/parks-and-recreation-overview.htm | City 2 | 1065 | Compton, City of 271 | City 2 | City Agency 2 | Los Angeles 6 | 4.261 | Tragniew Park | 0 | Local Park 2 | 4 | |
2486 | 2486 | 2485 | {"type": "MultiPolygon", "coordinates": [[[[-118.35476, 33.96038], [-118.35458, 33.96037], [-118.35456, 33.95959], [-118.35472, 33.95959], [-118.35476, 33.96038]]], [[[-118.35495, 33.96159], [-118.35464, 33.96161], [-118.35461, 33.96062], [-118.35489, 33.96062], [-118.35495, 33.96159]]]]} | Open Access 1 | 6279 | Grevillea Park | 19503 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 1.073 | Grevillea Park | 0 | Local Park 2 | 4 | |
2487 | 2487 | 2486 | {"type": "Polygon", "coordinates": [[[-118.32256, 33.96368], [-118.32254, 33.96376], [-118.3225, 33.96384], [-118.32239, 33.96394], [-118.32231, 33.96399], [-118.32221, 33.96402], [-118.32203, 33.96402], [-118.32191, 33.96399], [-118.32176, 33.96388], [-118.32168, 33.96374], [-118.32166, 33.96364], [-118.32171, 33.96349], [-118.32181, 33.96337], [-118.32189, 33.96333], [-118.322, 33.96329], [-118.32216, 33.96328], [-118.32225, 33.9633], [-118.32234, 33.96333], [-118.32248, 33.96344], [-118.32255, 33.96356], [-118.32256, 33.96368]]]} | Open Access 1 | 6280 | Circle Park | 17264 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 1.316 | Circle Park | 0 | Local Park 2 | 4 | |
2488 | 2488 | 2487 | {"type": "Polygon", "coordinates": [[[-118.33084, 33.9561], [-118.32917, 33.95611], [-118.32915, 33.95528], [-118.32933, 33.95527], [-118.32933, 33.95245], [-118.32973, 33.95246], [-118.32978, 33.95248], [-118.33084, 33.95274], [-118.33084, 33.9561]]]} | Open Access 1 | 6281 | Darby Park | 17925 | 1147 | Inglewood, City of 277 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | Los Angeles 6 | 13.903 | Darby Park | 0 | Local Park 2 | 4 | |
2489 | 2489 | 2488 | {"type": "Polygon", "coordinates": [[[-122.44958, 37.76633], [-122.44898, 37.76641], [-122.44881, 37.76647], [-122.44849, 37.76654], [-122.44848, 37.76657], [-122.44806, 37.76662], [-122.44802, 37.76642], [-122.44844, 37.76637], [-122.44846, 37.7664], [-122.44872, 37.76635], [-122.44892, 37.76627], [-122.44902, 37.7662], [-122.44899, 37.76602], [-122.4495, 37.76595], [-122.44958, 37.76633]]]} | Open Access 1 | 48909 | Richard Gamble Memorial Park | 33627 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/gamble-memorial-park | San Francisco 13 | 0.912 | Richard Gamble Memorial Park | None 205 | ||
2490 | 2490 | 2489 | {"type": "Polygon", "coordinates": [[[-121.28039, 38.13556], [-121.2793, 38.13556], [-121.27928, 38.13486], [-121.28038, 38.13486], [-121.28039, 38.13556]]]} | Open Access 1 | 17500 | Emerson Park | 18622 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 1.842 | Emerson Park | 0 | Local Park 2 | 4 | |
2491 | 2491 | 2490 | {"type": "Polygon", "coordinates": [[[-122.02042, 37.05058], [-122.01927, 37.05073], [-122.01725, 37.04949], [-122.01756, 37.04915], [-122.01918, 37.0484], [-122.01941, 37.04831], [-122.01986, 37.0491], [-122.0197, 37.04917], [-122.02024, 37.05013], [-122.02042, 37.05058]]]} | Open Access 1 | 17503 | MacDorsa Park | 21626 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 10.057 | MacDorsa Park | 0 | Local Park 2 | 4 | |
2492 | 2492 | 2491 | {"type": "Polygon", "coordinates": [[[-121.30458, 38.13408], [-121.30187, 38.13407], [-121.3016, 38.13404], [-121.30137, 38.13393], [-121.30127, 38.13385], [-121.3012, 38.13377], [-121.30114, 38.13367], [-121.30111, 38.13357], [-121.3011, 38.13346], [-121.30111, 38.13336], [-121.30114, 38.13325], [-121.3012, 38.13315], [-121.30128, 38.13307], [-121.30137, 38.13299], [-121.30148, 38.13293], [-121.30176, 38.13284], [-121.30188, 38.13278], [-121.30198, 38.1327], [-121.30206, 38.13262], [-121.30213, 38.13252], [-121.30217, 38.13242], [-121.30219, 38.13229], [-121.30456, 38.13229], [-121.30458, 38.13408]]]} | Open Access 1 | 17511 | Henry Glaves Jr Park | 19824 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 13.141 | Henry Glaves Jr Park | 0 | Local Park 2 | 4 | |
2493 | 2493 | 2492 | {"type": "MultiPolygon", "coordinates": [[[[-122.55812, 38.0849], [-122.55687, 38.08592], [-122.55674, 38.08612], [-122.5571, 38.08641], [-122.55704, 38.08644], [-122.55698, 38.08645], [-122.55692, 38.08644], [-122.55686, 38.08641], [-122.55663, 38.08617], [-122.55652, 38.08622], [-122.55498, 38.08474], [-122.55505, 38.08468], [-122.55722, 38.08325], [-122.55733, 38.08336], [-122.55792, 38.08372], [-122.55785, 38.08372], [-122.55754, 38.0847], [-122.558, 38.08489], [-122.55812, 38.0849]]], [[[-122.5575, 38.08673], [-122.5574, 38.0868], [-122.5571, 38.08656], [-122.5572, 38.08649], [-122.5575, 38.08673]]]]} | Open Access 1 | 17513 | Lynnwood Hill Park | 21611 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 11.591 | Lynnwood Hill Park | 0 | Local Park 2 | 4 | |
2494 | 2494 | 2493 | {"type": "Polygon", "coordinates": [[[-119.68921, 36.83919], [-119.68885, 36.83919], [-119.6885, 36.83919], [-119.68853, 36.83903], [-119.68919, 36.83902], [-119.68921, 36.83919]]]} | Open Access 1 | 17523 | Monte Vista 26 Park | 22397 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.279 | Monte Vista 26 Park | 0 | Local Park 2 | 4 | |
2495 | 2495 | 2494 | {"type": "Polygon", "coordinates": [[[-121.29088, 38.11928], [-121.29088, 38.11966], [-121.28831, 38.11967], [-121.28831, 38.1172], [-121.28934, 38.11719], [-121.28945, 38.1182], [-121.29071, 38.11819], [-121.29071, 38.11927], [-121.29088, 38.11928]]]} | Open Access 1 | 17526 | Kofu Park | 20713 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 11.242 | Kofu Park | 0 | Local Park 2 | 4 | |
2496 | 2496 | 2495 | {"type": "Polygon", "coordinates": [[[-121.26754, 38.1385], [-121.26695, 38.13848], [-121.26691, 38.13898], [-121.26692, 38.13899], [-121.2675, 38.13902], [-121.2674, 38.14026], [-121.26555, 38.14022], [-121.26562, 38.14012], [-121.26566, 38.14002], [-121.26569, 38.13985], [-121.26564, 38.13829], [-121.26566, 38.13825], [-121.2657, 38.13823], [-121.2675, 38.13817], [-121.26754, 38.13818], [-121.26756, 38.13822], [-121.26754, 38.1385]]]} | Open Access 1 | 17530 | Lawrence Park | 21116 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 8.188 | Lawrence Park | 0 | Local Park 2 | 4 | |
2497 | 2497 | 2496 | {"type": "Polygon", "coordinates": [[[-121.78361, 37.67491], [-121.7835, 37.67498], [-121.78311, 37.67502], [-121.78209, 37.67494], [-121.78073, 37.67462], [-121.78006, 37.67423], [-121.77944, 37.67395], [-121.77806, 37.67357], [-121.77751, 37.67545], [-121.77661, 37.67525], [-121.77663, 37.67487], [-121.776, 37.67457], [-121.77489, 37.67428], [-121.77458, 37.67395], [-121.77465, 37.67363], [-121.77378, 37.67351], [-121.77373, 37.67258], [-121.76847, 37.67254], [-121.76781, 37.67242], [-121.76786, 37.67183], [-121.76847, 37.67197], [-121.76995, 37.67158], [-121.77045, 37.67153], [-121.77105, 37.67156], [-121.77122, 37.6718], [-121.77298, 37.67169], [-121.77451, 37.67172], [-121.77516, 37.67167], [-121.77605, 37.67168], [-121.7769, 37.67172], [-121.77753, 37.67182], [-121.77823, 37.67197], [-121.77888, 37.67224], [-121.77907, 37.6725], [-121.77917, 37.67281], [-121.7792, 37.67316], [-121.77983, 37.67342], [-121.78022, 37.67342], [-121.78012, 37.67384], [-121.78189, 37.67423], [-121.78196, 37.67411], [-121.78283, 37.67445], [-121.78361, 37.67491]]]} | Open Access 1 | 17532 | Madeiros Parkway | 21649 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 51.175 | Madeiros Parkway | 0 | Local Recreation Area 3 | 4 | |
2498 | 2498 | 2497 | {"type": "MultiPolygon", "coordinates": [[[[-119.63205, 34.43527], [-119.631, 34.43526], [-119.63141, 34.43312], [-119.63141, 34.43311], [-119.63134, 34.4331], [-119.63134, 34.43283], [-119.63179, 34.43283], [-119.6318, 34.43303], [-119.63183, 34.43323], [-119.63201, 34.43386], [-119.63205, 34.43527]]], [[[-119.63427, 34.43281], [-119.63426, 34.43526], [-119.63224, 34.43526], [-119.63225, 34.43427], [-119.63336, 34.43427], [-119.63339, 34.43368], [-119.63328, 34.43339], [-119.63369, 34.43334], [-119.63417, 34.43334], [-119.63418, 34.43281], [-119.63427, 34.43281]]]]} | Open Access 1 | 17533 | Manning Park | 21754 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 11.812 | Manning Park | 0 | Local Park 2 | 4 | |
2499 | 2499 | 2498 | {"type": "Polygon", "coordinates": [[[-121.28061, 38.1243], [-121.27916, 38.1243], [-121.27915, 38.1226], [-121.27923, 38.12255], [-121.27943, 38.12259], [-121.27986, 38.12273], [-121.28013, 38.12277], [-121.2806, 38.12278], [-121.28061, 38.1243]]]} | Open Access 1 | 17534 | Legion Park | 21141 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 5.584 | Legion Park | 0 | Local Park 2 | 4 | |
2500 | 2500 | 2499 | {"type": "Polygon", "coordinates": [[[-121.25153, 38.03604], [-121.24923, 38.03607], [-121.24921, 38.03448], [-121.2512, 38.03445], [-121.25123, 38.03443], [-121.25152, 38.03443], [-121.25153, 38.03604]]]} | Open Access 1 | 17538 | Morada Park | 22467 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 8.881 | Morada Park | 0 | Local Park 2 | 4 | |
2501 | 2501 | 2500 | {"type": "Polygon", "coordinates": [[[-121.82723, 36.6137], [-121.82691, 36.61382], [-121.8271, 36.61401], [-121.82685, 36.61443], [-121.82657, 36.6143], [-121.82631, 36.61413], [-121.82655, 36.61396], [-121.8269, 36.61383], [-121.8269, 36.61379], [-121.82722, 36.61367], [-121.82723, 36.6137]]]} | Open Access 1 | 17551 | Manzanita Stuart Park | 21770 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.669 | Manzanita Stuart Park | 0 | Local Park 2 | 4 | |
2502 | 2502 | 2501 | {"type": "Polygon", "coordinates": [[[-121.31533, 38.1379], [-121.31453, 38.1379], [-121.31265, 38.13818], [-121.3118, 38.13818], [-121.3118, 38.13751], [-121.31172, 38.13691], [-121.31177, 38.13599], [-121.31174, 38.13545], [-121.31457, 38.13547], [-121.3149, 38.1357], [-121.3149, 38.13648], [-121.31532, 38.13649], [-121.31533, 38.1379]]]} | Open Access 1 | 17552 | Peterson Park | 23634 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 20.991 | Peterson 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]);