units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where DES_TP = 2, MNG_AGENCY = 397 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 41 ✖
MNG_AGENCY 1
- Redding, City of · 41 ✖
DES_TP 1
- Local Park · 41 ✖
ACCESS_TYP 1
- Open Access 41
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14666 | 14666 | 14665 | {"type": "Polygon", "coordinates": [[[-122.35486, 40.54442], [-122.35483, 40.5452], [-122.35479, 40.5453], [-122.35479, 40.54536], [-122.35367, 40.54535], [-122.35324, 40.54401], [-122.35446, 40.54404], [-122.35437, 40.54437], [-122.35486, 40.54442]]]} | Open Access 1 | 44937 | Rivercrest Park | 24438 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 3.882 | Rivercrest Park | 0 | Local Park 2 | 4 | |
14359 | 14359 | 14358 | {"type": "Polygon", "coordinates": [[[-122.37636, 40.51901], [-122.3763, 40.519], [-122.37618, 40.51891], [-122.37616, 40.51886], [-122.37618, 40.51881], [-122.37682, 40.51827], [-122.3769, 40.51825], [-122.37699, 40.5183], [-122.37707, 40.51839], [-122.37706, 40.51843], [-122.3764, 40.51899], [-122.37636, 40.51901]]]} | Open Access 1 | 44421 | Waverly Park | 27319 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.638 | Waverly Park | 0 | Local Park 2 | 4 | |
13767 | 13767 | 13766 | {"type": "Polygon", "coordinates": [[[-122.38535, 40.56927], [-122.38533, 40.56997], [-122.38492, 40.56996], [-122.38492, 40.5699], [-122.38489, 40.56981], [-122.38488, 40.56971], [-122.3849, 40.56964], [-122.38493, 40.56955], [-122.38506, 40.56942], [-122.38522, 40.56933], [-122.38528, 40.56924], [-122.38535, 40.56927]]]} | Open Access 1 | 36292 | Parkview Green | 32402 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.585 | Parkview Green | 0 | Local Park 2 | 4 | |
12686 | 12686 | 12685 | {"type": "Polygon", "coordinates": [[[-122.35919, 40.60291], [-122.35911, 40.60276], [-122.359, 40.60263], [-122.35877, 40.60241], [-122.35849, 40.60224], [-122.35818, 40.60212], [-122.35815, 40.60208], [-122.35827, 40.60174], [-122.35835, 40.60162], [-122.35849, 40.60148], [-122.35879, 40.6013], [-122.35892, 40.60119], [-122.35902, 40.60125], [-122.35914, 40.6013], [-122.35937, 40.60134], [-122.35964, 40.60142], [-122.35972, 40.60143], [-122.35975, 40.60144], [-122.35977, 40.60148], [-122.35971, 40.60159], [-122.35967, 40.60183], [-122.3596, 40.602], [-122.35959, 40.60208], [-122.35963, 40.60219], [-122.35974, 40.6023], [-122.35979, 40.6024], [-122.35981, 40.6025], [-122.3598, 40.6026], [-122.35973, 40.60273], [-122.35961, 40.60282], [-122.35943, 40.60289], [-122.35919, 40.60291]]]} | Open Access 1 | 48813 | Highland Park Neighborhood Park | 33533 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | https://www.cityofredding.org/Home/Components/FacilityDirectory/FacilityDirectory/150/626?npage=2 | Shasta 27 | 4.103 | Highland Park Neighborhood Park | 0 | Local Park 2 | 4 |
9351 | 9351 | 9350 | {"type": "Polygon", "coordinates": [[[-122.40445, 40.56459], [-122.40409, 40.56485], [-122.40378, 40.565], [-122.40356, 40.5647], [-122.40284, 40.56405], [-122.40413, 40.56436], [-122.40445, 40.56459]]]} | Open Access 1 | 15624 | Indian Hills Park | 20203 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 1.362 | Indian Hills Park | 0 | Local Park 2 | 4 | |
9342 | 9342 | 9341 | {"type": "Polygon", "coordinates": [[[-122.43578, 40.57537], [-122.43495, 40.57555], [-122.43443, 40.57611], [-122.4341, 40.5771], [-122.43043, 40.57569], [-122.43059, 40.57536], [-122.4308, 40.57528], [-122.43097, 40.57518], [-122.43112, 40.57505], [-122.43122, 40.57494], [-122.43187, 40.57365], [-122.43198, 40.57349], [-122.43213, 40.57336], [-122.43229, 40.57325], [-122.43252, 40.57316], [-122.43273, 40.57311], [-122.43306, 40.5731], [-122.43338, 40.57314], [-122.43377, 40.57327], [-122.43397, 40.57337], [-122.43412, 40.57347], [-122.43424, 40.57358], [-122.43439, 40.57376], [-122.43447, 40.57391], [-122.43461, 40.57427], [-122.43473, 40.57446], [-122.43484, 40.57458], [-122.43505, 40.57477], [-122.43554, 40.57511], [-122.43578, 40.57537]]]} | Open Access 1 | 15610 | Mary Lake Park | 21934 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 26.666 | Mary Lake Park | 0 | Local Park 2 | 4 | |
9279 | 9279 | 9278 | {"type": "MultiPolygon", "coordinates": [[[[-122.39912, 40.59395], [-122.39899, 40.59436], [-122.39882, 40.59477], [-122.39859, 40.59517], [-122.39824, 40.59565], [-122.39805, 40.59561], [-122.39782, 40.59558], [-122.39746, 40.59558], [-122.3973, 40.59556], [-122.39627, 40.59528], [-122.39579, 40.59523], [-122.39524, 40.59523], [-122.39488, 40.59529], [-122.39409, 40.59549], [-122.39233, 40.59606], [-122.39216, 40.5961], [-122.39198, 40.59612], [-122.39179, 40.59612], [-122.39155, 40.59607], [-122.39141, 40.59602], [-122.39123, 40.59592], [-122.39113, 40.59583], [-122.39009, 40.59464], [-122.38985, 40.59442], [-122.38982, 40.59432], [-122.38986, 40.59425], [-122.39035, 40.59377], [-122.39062, 40.5936], [-122.39136, 40.59297], [-122.3917, 40.59262], [-122.39236, 40.59284], [-122.39379, 40.59338], [-122.39602, 40.59368], [-122.39696, 40.59382], [-122.39813, 40.59392], [-122.39912, 40.59395]]], [[[-122.39813, 40.59579], [-122.39781, 40.59613], [-122.39744, 40.59645], [-122.39618, 40.59742], [-122.39605, 40.59691], [-122.39603, 40.59675], [-122.39563, 40.59675], [-122.39543, 40.59673], [-122.39503, 40.59665], [-122.39325, 40.59616], [-122.39319, 40.59612], [-122.39317, 40.59606], [-122.39318, 40.59601], [-122.39324, 40.59597], [-122.39416, 40.59567], [-122.39456, 40.59556], [-122.39502, 40.59546], [-122.3951, 40.59547], [-122.39515, 40.59551], [-122.39525, 40.5955], [-122.39529, 40.59545], [-122.39534, 40.59543], [-122.39588, 40.59544], [-122.39626, 40.59548], [-122.39645, 40.59553], [-122.39673, 40.59561], [-122.39678, 40.59565], [-122.39678, 40.59571], [-122.39687, 40.59573], [-122.39697, 40.59568], [-122.39711, 40.59572], [-122.39742, 40.59576], [-122.39813, 40.59579]]]]} | Open Access 1 | 15460 | Caldwell Park | 16675 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 53.31 | Caldwell Park | 0 | Local Park 2 | 4 | |
9242 | 9242 | 9241 | {"type": "Polygon", "coordinates": [[[-122.40749, 40.57803], [-122.40618, 40.57825], [-122.40607, 40.57793], [-122.40606, 40.57777], [-122.40599, 40.57763], [-122.40586, 40.57746], [-122.40578, 40.57728], [-122.40663, 40.57722], [-122.40669, 40.57769], [-122.40737, 40.5776], [-122.40749, 40.57803]]]} | Open Access 1 | 15369 | Benton Dog Park | 32401 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 2.326 | Benton Dog Park | 0 | Local Park 2 | 4 | |
9184 | 9184 | 9183 | {"type": "Polygon", "coordinates": [[[-122.38162, 40.59099], [-122.38032, 40.59104], [-122.3796, 40.59113], [-122.37875, 40.59131], [-122.37863, 40.59074], [-122.3787, 40.59061], [-122.37892, 40.59067], [-122.3791, 40.59069], [-122.37947, 40.59068], [-122.37974, 40.59065], [-122.37984, 40.59073], [-122.38016, 40.59078], [-122.38062, 40.59073], [-122.3811, 40.59081], [-122.38162, 40.59082], [-122.38162, 40.59099]]]} | Open Access 1 | 15248 | Riverfront Park | 24441 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 2.463 | Riverfront Park | 0 | Local Park 2 | 4 | |
9166 | 9166 | 9165 | {"type": "Polygon", "coordinates": [[[-122.42826, 40.56759], [-122.42796, 40.56791], [-122.42804, 40.56814], [-122.42794, 40.56816], [-122.42779, 40.56783], [-122.42747, 40.56764], [-122.42634, 40.56741], [-122.42596, 40.56709], [-122.42536, 40.56709], [-122.42511, 40.56735], [-122.42509, 40.56783], [-122.42553, 40.5688], [-122.42545, 40.56879], [-122.42523, 40.56839], [-122.42492, 40.56848], [-122.42368, 40.56848], [-122.4237, 40.56621], [-122.42486, 40.56621], [-122.42485, 40.56667], [-122.42649, 40.5667], [-122.42676, 40.56621], [-122.42689, 40.56626], [-122.42734, 40.56651], [-122.42751, 40.56672], [-122.4269, 40.56671], [-122.42663, 40.56685], [-122.42641, 40.56688], [-122.4264, 40.56698], [-122.42688, 40.56732], [-122.4277, 40.56758], [-122.42826, 40.56759]]]} | Open Access 1 | 15214 | Ridgeview Park | 24360 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 10.736 | Ridgeview Park | 0 | Local Park 2 | 4 | |
9121 | 9121 | 9120 | {"type": "Polygon", "coordinates": [[[-122.40794, 40.55061], [-122.40759, 40.55096], [-122.40646, 40.55022], [-122.40674, 40.54997], [-122.4066, 40.54987], [-122.40761, 40.549], [-122.40794, 40.55061]]]} | Open Access 1 | 15121 | Country Heights Park | 17697 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 3.58 | Country Heights Park | 0 | Local Park 2 | 4 | |
9065 | 9065 | 9064 | {"type": "Polygon", "coordinates": [[[-122.32063, 40.5651], [-122.32034, 40.5651], [-122.32033, 40.56473], [-122.32062, 40.56473], [-122.32063, 40.5651]]]} | Open Access 1 | 15005 | Hawn Park | 19750 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.249 | Hawn Park | 0 | Local Park 2 | 4 | |
9029 | 9029 | 9028 | {"type": "Polygon", "coordinates": [[[-122.34342, 40.54925], [-122.34026, 40.54929], [-122.33661, 40.5493], [-122.33662, 40.54563], [-122.33654, 40.54199], [-122.3391, 40.54199], [-122.33934, 40.54222], [-122.33967, 40.54281], [-122.33954, 40.54317], [-122.33981, 40.54565], [-122.34334, 40.54567], [-122.34342, 40.54925]]]} | Open Access 1 | 14944 | Enterprise Community Park | 18684 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 82.829 | Enterprise Community Park | 0 | Local Park 2 | 4 | |
8977 | 8977 | 8976 | {"type": "Polygon", "coordinates": [[[-122.42686, 40.573], [-122.42656, 40.57324], [-122.42622, 40.57311], [-122.42616, 40.57293], [-122.42588, 40.57296], [-122.42566, 40.57295], [-122.42567, 40.57281], [-122.42599, 40.57279], [-122.42595, 40.57255], [-122.42633, 40.57236], [-122.42668, 40.5728], [-122.42673, 40.57289], [-122.42686, 40.573]]]} | Open Access 1 | 14817 | Rolling Hills Park | 24579 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 1.148 | Rolling Hills Park | 0 | Local Park 2 | 4 | |
8957 | 8957 | 8956 | {"type": "Polygon", "coordinates": [[[-122.39352, 40.57271], [-122.39244, 40.57282], [-122.39237, 40.57242], [-122.39255, 40.5724], [-122.39246, 40.57188], [-122.39228, 40.57189], [-122.39222, 40.57152], [-122.3933, 40.57141], [-122.39352, 40.57271]]]} | Open Access 1 | 14755 | Martin Luther King Jr. Park | 21913 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 3.107 | Martin Luther King Jr. Park | 0 | Local Park 2 | 4 | |
8886 | 8886 | 8885 | {"type": "MultiPolygon", "coordinates": [[[[-122.40043, 40.59672], [-122.39835, 40.59669], [-122.39835, 40.59669], [-122.39867, 40.5964], [-122.39886, 40.59619], [-122.39893, 40.59622], [-122.39895, 40.59628], [-122.39902, 40.5963], [-122.39905, 40.59628], [-122.3991, 40.59627], [-122.40043, 40.59672]]], [[[-122.40163, 40.59392], [-122.40162, 40.59423], [-122.40122, 40.59516], [-122.40117, 40.59519], [-122.40111, 40.5952], [-122.40106, 40.59531], [-122.40111, 40.59534], [-122.40112, 40.59539], [-122.40067, 40.59642], [-122.40065, 40.59645], [-122.40059, 40.59647], [-122.40052, 40.59647], [-122.39906, 40.59596], [-122.3992, 40.59579], [-122.39947, 40.5954], [-122.39969, 40.595], [-122.39978, 40.59483], [-122.39996, 40.5944], [-122.40008, 40.59396], [-122.40163, 40.59392]]]]} | Open Access 1 | 14530 | Lake Redding Park | 20963 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 9.977 | Lake Redding Park | 0 | Local Park 2 | 4 | |
8863 | 8863 | 8862 | {"type": "Polygon", "coordinates": [[[-122.32243, 40.57834], [-122.32243, 40.57907], [-122.32199, 40.57906], [-122.32197, 40.57834], [-122.32243, 40.57834]]]} | Open Access 1 | 14489 | Ravenwood Park | 24200 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.771 | Ravenwood Park | 0 | Local Park 2 | 4 | |
8812 | 8812 | 8811 | {"type": "MultiPolygon", "coordinates": [[[[-122.36938, 40.60315], [-122.36928, 40.60327], [-122.36919, 40.60346], [-122.36913, 40.60367], [-122.36912, 40.60377], [-122.36597, 40.6033], [-122.36513, 40.60346], [-122.36477, 40.60236], [-122.36435, 40.60213], [-122.36339, 40.60203], [-122.36335, 40.60023], [-122.36479, 40.60021], [-122.3648, 40.60143], [-122.36532, 40.60165], [-122.36574, 40.60123], [-122.36649, 40.6018], [-122.36652, 40.602], [-122.36938, 40.60315]]], [[[-122.37101, 40.60358], [-122.37056, 40.60414], [-122.37044, 40.60417], [-122.37058, 40.60455], [-122.37002, 40.60475], [-122.36978, 40.60389], [-122.36938, 40.60393], [-122.36936, 40.60386], [-122.36935, 40.6037], [-122.36938, 40.60355], [-122.36949, 40.60333], [-122.36974, 40.60301], [-122.36984, 40.60291], [-122.3701, 40.6027], [-122.37025, 40.60261], [-122.37054, 40.6029], [-122.37031, 40.60311], [-122.37101, 40.60358]]]]} | Open Access 1 | 14341 | Peppertree Park | 23599 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 24.154 | Peppertree Park | 0 | Local Park 2 | 4 | |
8788 | 8788 | 8787 | {"type": "Polygon", "coordinates": [[[-122.36896, 40.51309], [-122.36699, 40.51305], [-122.3666, 40.51308], [-122.36632, 40.51312], [-122.36511, 40.51361], [-122.36487, 40.51304], [-122.36543, 40.51252], [-122.36564, 40.5125], [-122.36554, 40.51242], [-122.36559, 40.51219], [-122.36569, 40.51201], [-122.36576, 40.51177], [-122.36586, 40.51154], [-122.36596, 40.51122], [-122.36598, 40.51068], [-122.36607, 40.51041], [-122.36627, 40.51003], [-122.36693, 40.50869], [-122.3669, 40.50884], [-122.36706, 40.50928], [-122.36729, 40.50934], [-122.36774, 40.50967], [-122.36774, 40.50972], [-122.3682, 40.51029], [-122.36853, 40.51047], [-122.3687, 40.5105], [-122.36871, 40.51136], [-122.36891, 40.51214], [-122.36862, 40.51213], [-122.36861, 40.51214], [-122.36895, 40.51291], [-122.36896, 40.51309]]]} | Open Access 1 | 14296 | Cascade Park | 16937 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 24.093 | Cascade Park | 0 | Local Park 2 | 4 | |
8766 | 8766 | 8765 | {"type": "Polygon", "coordinates": [[[-122.35048, 40.59398], [-122.35048, 40.59421], [-122.35045, 40.59425], [-122.34987, 40.59426], [-122.34984, 40.59397], [-122.35048, 40.59398]]]} | Open Access 1 | 14255 | Bobwhite Park | 16216 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.408 | Bobwhite 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]);