units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where DES_TP = 2 and MNG_AGENCY = 9 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 34
MNG_AGENCY 1
- Santa Cruz, City of · 34 ✖
DES_TP 1
- Local Park · 34 ✖
ACCESS_TYP 1
- Open Access 34
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10192 | 10192 | 10191 | {"type": "MultiPolygon", "coordinates": [[[[-122.01868, 36.96877], [-122.01776, 36.96884], [-122.01776, 36.96884], [-122.01777, 36.96872], [-122.01868, 36.96877]]], [[[-122.02196, 36.9699], [-122.02157, 36.9693], [-122.02145, 36.96919], [-122.0213, 36.9691], [-122.02102, 36.96902], [-122.01961, 36.96879], [-122.01961, 36.96875], [-122.01964, 36.96871], [-122.01975, 36.96866], [-122.01999, 36.96861], [-122.02034, 36.96862], [-122.02092, 36.96876], [-122.02124, 36.96888], [-122.02152, 36.96905], [-122.02174, 36.96928], [-122.02185, 36.96951], [-122.02196, 36.9699]]], [[[-122.02199, 36.97037], [-122.02192, 36.97061], [-122.02192, 36.9711], [-122.02181, 36.97136], [-122.02165, 36.97155], [-122.02162, 36.97156], [-122.02157, 36.97153], [-122.0216, 36.97154], [-122.02165, 36.97153], [-122.02178, 36.97134], [-122.02185, 36.97105], [-122.02181, 36.97064], [-122.0219, 36.97038], [-122.02199, 36.97037]]]]} | Open Access 1 | 17823 | Mike Fox Park | 22212 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 1.596 | Mike Fox Park | 0 | Local Park 2 | 4 | |
10295 | 10295 | 10294 | {"type": "MultiPolygon", "coordinates": [[[[-122.03531, 36.96338], [-122.03531, 36.96359], [-122.03313, 36.96215], [-122.03324, 36.962], [-122.03531, 36.96338]]], [[[-122.03528, 36.96378], [-122.03526, 36.96405], [-122.03416, 36.96371], [-122.03415, 36.96372], [-122.03417, 36.96386], [-122.03416, 36.96406], [-122.03419, 36.96417], [-122.03422, 36.96421], [-122.03422, 36.96434], [-122.03426, 36.96446], [-122.03425, 36.96451], [-122.03421, 36.96456], [-122.03428, 36.9646], [-122.03438, 36.96459], [-122.03441, 36.96463], [-122.0344, 36.9647], [-122.03431, 36.96482], [-122.03426, 36.96494], [-122.03425, 36.96502], [-122.03427, 36.96512], [-122.03431, 36.9652], [-122.03437, 36.96529], [-122.03457, 36.96543], [-122.03465, 36.96552], [-122.03477, 36.9657], [-122.0348, 36.9658], [-122.03481, 36.96589], [-122.03478, 36.96601], [-122.03474, 36.96604], [-122.03469, 36.96605], [-122.03463, 36.96602], [-122.03449, 36.96592], [-122.0344, 36.96581], [-122.03433, 36.96577], [-122.0342, 36.96577], [-122.03414, 36.9658], [-122.03409, 36.96584], [-122.03406, 36.96596], [-122.03405, 36.96616], [-122.0341, 36.9662], [-122.03419, 36.96622], [-122.03421, 36.96624], [-122.03418, 36.96634], [-122.03411, 36.9664], [-122.03411, 36.96647], [-122.03413, 36.96653], [-122.03423, 36.96664], [-122.03429, 36.96674], [-122.03434, 36.96686], [-122.03434, 36.96695], [-122.03431, 36.96706], [-122.03423, 36.96716], [-122.03411, 36.96722], [-122.034, 36.96723], [-122.03386, 36.96721], [-122.03385, 36.96717], [-122.03369, 36.96714], [-122.03373, 36.96698], [-122.03367, 36.96648], [-122.03363, 36.96629], [-122.03361, 36.96598], [-122.03355, 36.9659], [-122.03355, 36.96563], [-122.03353, 36.96552], [-122.03358, 36.96539], [-122.03357, 36.96511], [-122.03364, 36.96505], [-122.03362, 36.96471], [-122.03311, 36.96443], [-122.03305, 36.96431], [-122.03251, 36.96408], [-122.0324, 36.96411], [-122.03209, 36.96394], [-122.03195, 36.96405], [-122.03157, 36.96414], [-122.03118, 36.96414], [-122.03073, 36.9655], [-122.03044, 36.96557], [-122.03041, 36.96549], [-122.03047, 36.96536], [-122.03046, 36.96523], [-122.03044, 36.96514], [-122.03034, 36.96505], [-122.03018, 36.96498], [-122.03003, 36.96497], [-122.02984, 36.96489], [-122.02967, 36.9648], [-122.0295, 36.96479], [-122.02935, 36.96475], [-122.02923, 36.96466], [-122.0291, 36.9645], [-122.0289, 36.96431], [-122.02876, 36.96423], [-122.02841, 36.96395], [-122.02805, 36.96355], [-122.02796, 36.96353], [-122.02789, 36.96354], [-122.02784, 36.96358], [-122.0278, 36.96366], [-122.02773, 36.9637], [-122.02767, 36.96347], [-122.0275, 36.96347], [-122.02762, 36.96289], [-122.02767, 36.96274], [-122.02812, 36.96176], [-122.02833, 36.96151], [-122.02862, 36.96125], [-122.02883, 36.96111], [-122.02911, 36.96098], [-122.02918, 36.96105], [-122.02904, 36.96118], [-122.02909, 36.96131], [-122.02909, 36.96137], [-122.02895, 36.96157], [-122.02899, 36.96167], [-122.02918, 36.96176], [-122.02938, 36.96165], [-122.02944, 36.96165], [-122.02947, 36.9617], [-122.02948, 36.9618], [-122.02954, 36.96186], [-122.02967, 36.9619], [-122.02986, 36.96204], [-122.03047, 36.96219], [-122.03077, 36.96231], [-122.03087, 36.96232], [-122.03126, 36.96248], [-122.03143, 36.96249], [-122.03162, 36.96237], [-122.03173, 36.96236], [-122.03183, 36.96238], [-122.03201, 36.96254], [-122.03213, 36.96258], [-122.03229, 36.96255], [-122.03245, 36.96243], [-122.03265, 36.96242], [-122.03279, 36.96252], [-122.03274, 36.96258], [-122.03275, 36.96259], [-122.03309, 36.96272], [-122.03319, 36.9628], [-122.03359, 36.96279], [-122.03375, 36.9628], [-122.03528, 36.96378]]]]} | Open Access 1 | 18088 | Neary Lagoon Park | 22680 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 41.943 | Neary Lagoon Park | 0 | Local Park 2 | 4 | |
2323 | 2323 | 2322 | {"type": "Polygon", "coordinates": [[[-122.00075, 36.98632], [-122.00054, 36.98677], [-122.00016, 36.98666], [-122.00036, 36.9862], [-122.00075, 36.98632]]]} | Open Access 1 | 17039 | John Franks Park | 20441 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.48 | John Franks Park | 0 | Local Park 2 | 4 | |
9558 | 9558 | 9557 | {"type": "Polygon", "coordinates": [[[-122.00255, 36.97243], [-122.00094, 36.97265], [-122.0008, 36.9725], [-122.0007, 36.9721], [-122.00082, 36.9717], [-122.00235, 36.97148], [-122.00255, 36.97243]]]} | Open Access 1 | 16062 | Frederick Street Park | 19080 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 3.966 | Frederick Street Park | 0 | Local Park 2 | 4 | |
8032 | 8032 | 8031 | {"type": "Polygon", "coordinates": [[[-122.00315, 36.99207], [-122.00298, 36.99208], [-122.00296, 36.99196], [-122.00293, 36.99189], [-122.00287, 36.99179], [-122.0028, 36.99172], [-122.00261, 36.9916], [-122.00237, 36.99154], [-122.00238, 36.99124], [-122.00266, 36.99124], [-122.00275, 36.99151], [-122.00287, 36.99159], [-122.00294, 36.99177], [-122.00306, 36.99194], [-122.00312, 36.99194], [-122.00315, 36.99207]]]} | Open Access 1 | 47742 | Pacheco Dog Park | 31551 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.466 | Pacheco Dog Park | 0 | Local Park 2 | 4 | |
5014 | 5014 | 5013 | {"type": "Polygon", "coordinates": [[[-122.00633, 36.97691], [-122.00584, 36.97704], [-122.00573, 36.97677], [-122.00622, 36.97664], [-122.00633, 36.97691]]]} | Open Access 1 | 1067 | Star of the Sea Park | 25799 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.362 | Star of the Sea Park | 0 | Local Park 2 | 4 | |
1520 | 1520 | 1519 | {"type": "Polygon", "coordinates": [[[-122.00809, 36.98128], [-122.00809, 36.98128], [-122.00733, 36.98127], [-122.00796, 36.98109], [-122.00807, 36.98104], [-122.00809, 36.98128]]]} | Open Access 1 | 47747 | El Portal Park | 31556 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.212 | El Portal Park | 0 | Local Park 2 | 4 | |
475 | 475 | 474 | {"type": "Polygon", "coordinates": [[[-122.00999, 36.96529], [-122.00949, 36.96531], [-122.00956, 36.96505], [-122.00915, 36.96464], [-122.00891, 36.96456], [-122.00917, 36.96442], [-122.00936, 36.96436], [-122.00956, 36.96434], [-122.00976, 36.96435], [-122.00999, 36.96529]]]} | Open Access 1 | 1534 | Tyrell Park | 26631 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 1.3 | Tyrell Park | 0 | Local Park 2 | 4 | |
1436 | 1436 | 1435 | {"type": "Polygon", "coordinates": [[[-122.01137, 36.9919], [-122.01132, 36.9921], [-122.0113, 36.99239], [-122.01115, 36.99208], [-122.01115, 36.99183], [-122.01137, 36.9919]]]} | Open Access 1 | 47745 | Branciforte Dog Park | 31554 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.175 | Branciforte Dog Park | 0 | Local Park 2 | 4 | |
2688 | 2688 | 2687 | {"type": "Polygon", "coordinates": [[[-122.01418, 36.96968], [-122.01346, 36.9699], [-122.01357, 36.97013], [-122.01289, 36.97037], [-122.01274, 36.97007], [-122.01262, 36.97002], [-122.01222, 36.9703], [-122.01215, 36.97025], [-122.01214, 36.97016], [-122.01227, 36.96991], [-122.01343, 36.96964], [-122.01338, 36.96879], [-122.01362, 36.96851], [-122.01376, 36.96857], [-122.01418, 36.96968]]]} | Open Access 1 | 18246 | Ocean View Park | 23061 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 3.067 | Ocean View Park | 0 | Local Park 2 | 4 | |
10045 | 10045 | 10044 | {"type": "Polygon", "coordinates": [[[-122.01725, 36.96579], [-122.01685, 36.96565], [-122.0168, 36.9655], [-122.01713, 36.96543], [-122.01725, 36.96579]]]} | Open Access 1 | 17442 | Beach Flats Park | 15906 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.216 | Beach Flats Park | 0 | Local Park 2 | 4 | |
8031 | 8031 | 8030 | {"type": "Polygon", "coordinates": [[[-122.01756, 36.96672], [-122.0173, 36.96663], [-122.01733, 36.96659], [-122.01729, 36.96651], [-122.01744, 36.96629], [-122.01756, 36.96672]]]} | Open Access 1 | 47740 | Poets Park | 31549 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.144 | Poets Park | 0 | Local Park 2 | 4 | |
709 | 709 | 708 | {"type": "Polygon", "coordinates": [[[-122.01909, 36.97734], [-122.01892, 36.97736], [-122.01872, 36.97737], [-122.01879, 36.97715], [-122.01894, 36.97709], [-122.01909, 36.97734]]]} | Open Access 1 | 5334 | Central Park | 17062 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.156 | Central Park | 0 | Local Park 2 | 4 | |
4208 | 4208 | 4207 | {"type": "Polygon", "coordinates": [[[-122.02155, 36.96974], [-122.02111, 36.96979], [-122.02079, 36.96995], [-122.02073, 36.96988], [-122.02065, 36.96982], [-122.02097, 36.96956], [-122.02107, 36.96963], [-122.02141, 36.96939], [-122.02149, 36.96952], [-122.02155, 36.96974]]]} | Open Access 1 | 44946 | Riverside Gardens Park | 24449 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.519 | Riverside Gardens Park | 0 | Local Park 2 | 4 | |
2247 | 2247 | 2246 | {"type": "Polygon", "coordinates": [[[-122.02181, 36.98457], [-122.02176, 36.98553], [-122.02056, 36.9854], [-122.0206, 36.98468], [-122.02121, 36.98477], [-122.02119, 36.98463], [-122.02181, 36.98457]]]} | Open Access 1 | 16660 | Grant Park | 19441 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 2.364 | Grant Park | 0 | Local Park 2 | 4 | |
8033 | 8033 | 8032 | {"type": "Polygon", "coordinates": [[[-122.02249, 36.97118], [-122.02245, 36.97129], [-122.02235, 36.97138], [-122.02232, 36.97139], [-122.02224, 36.97135], [-122.02216, 36.97136], [-122.02212, 36.97139], [-122.0221, 36.97143], [-122.02209, 36.97151], [-122.02204, 36.97153], [-122.02199, 36.97152], [-122.0221, 36.9713], [-122.02215, 36.97116], [-122.02217, 36.97098], [-122.02217, 36.97074], [-122.02221, 36.97055], [-122.02225, 36.97048], [-122.02233, 36.97054], [-122.02248, 36.971], [-122.02249, 36.97118]]]} | Open Access 1 | 47743 | Mimi De Marta Dog Park | 31552 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.582 | Mimi De Marta Dog Park | 0 | Local Park 2 | 4 | |
5903 | 5903 | 5902 | {"type": "Polygon", "coordinates": [[[-122.02272, 36.97699], [-122.02204, 36.97717], [-122.02161, 36.97613], [-122.02147, 36.97605], [-122.02163, 36.97583], [-122.02172, 36.97558], [-122.02173, 36.97533], [-122.02168, 36.9747], [-122.02184, 36.97468], [-122.02205, 36.97473], [-122.0222, 36.97481], [-122.02227, 36.97488], [-122.02232, 36.97495], [-122.02235, 36.97504], [-122.02243, 36.97588], [-122.02248, 36.9762], [-122.02256, 36.97652], [-122.02272, 36.97699]]]} | Open Access 1 | 354 | San Lorenzo Park | 24926 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 4.282 | San Lorenzo Park | 0 | Local Park 2 | 4 | |
7522 | 7522 | 7521 | {"type": "Polygon", "coordinates": [[[-122.02546, 36.95999], [-122.02535, 36.96016], [-122.02541, 36.96029], [-122.02538, 36.96047], [-122.02509, 36.96091], [-122.02489, 36.96096], [-122.0251, 36.96127], [-122.02479, 36.96101], [-122.02537, 36.95992], [-122.02546, 36.95999]]]} | Open Access 1 | 10873 | Cowell's Beach | 17729 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.596 | Cowell's Beach | 0 | Local Park 2 | 4 | |
3717 | 3717 | 3716 | {"type": "Polygon", "coordinates": [[[-122.0257, 36.96018], [-122.02534, 36.95989], [-122.02539, 36.95983], [-122.0254, 36.95974], [-122.02549, 36.95968], [-122.02549, 36.95962], [-122.02565, 36.95962], [-122.02563, 36.95976], [-122.0257, 36.96018]]]} | Open Access 1 | 14027 | Dutra Overlook Park | 18324 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.26 | Dutra Overlook Park | 0 | Local Park 2 | 4 | |
5070 | 5070 | 5069 | {"type": "Polygon", "coordinates": [[[-122.02709, 36.97727], [-122.02707, 36.9773], [-122.02703, 36.97731], [-122.02661, 36.97724], [-122.02658, 36.97721], [-122.0266, 36.97718], [-122.02675, 36.97712], [-122.02696, 36.97707], [-122.02699, 36.97709], [-122.02705, 36.97717], [-122.02709, 36.97727]]]} | Open Access 1 | 1396 | Town Clock Park | 26487 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.187 | Town Clock 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]);