units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where MNG_AGENCY = 304 and MNG_AG_TYP = 4 sorted by rowid descending
This data as json, copyable, CSV (advanced)
DES_TP 2
- Local Park 37
- None 1
MNG_AG_TYP 1
- Recreation/Parks District · 38 ✖
MNG_AGENCY 1
- Cordova Recreation and Park District · 38 ✖
ACCESS_TYP 1
- Open Access 38
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15273 | 15273 | 15272 | {"type": "Polygon", "coordinates": [[[-121.23495, 38.54351], [-121.23489, 38.54359], [-121.23487, 38.54365], [-121.2349, 38.54373], [-121.23495, 38.54378], [-121.23507, 38.54386], [-121.23521, 38.54392], [-121.23536, 38.54395], [-121.23554, 38.54396], [-121.23559, 38.544], [-121.23559, 38.54448], [-121.23555, 38.54472], [-121.23549, 38.54487], [-121.23539, 38.54502], [-121.23527, 38.54515], [-121.23513, 38.54526], [-121.23487, 38.54539], [-121.23423, 38.54559], [-121.23425, 38.5437], [-121.23444, 38.5437], [-121.2346, 38.54367], [-121.23475, 38.54362], [-121.23495, 38.54351]]]} | Open Access 1 | 48859 | Sandpiper Park | 33579 | 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 | https://crpd.com/parks/sandpiper-park/ | Sacramento 41 | 4.884 | Sandpiper Park | 0 | Local Park 2 | 4 |
14520 | 14520 | 14519 | {"type": "Polygon", "coordinates": [[[-121.23214, 38.53159], [-121.23155, 38.53215], [-121.23094, 38.53244], [-121.23062, 38.53222], [-121.23041, 38.53223], [-121.23036, 38.53215], [-121.22999, 38.53189], [-121.22984, 38.53176], [-121.22982, 38.53173], [-121.22984, 38.53169], [-121.23103, 38.53085], [-121.23107, 38.53084], [-121.23112, 38.53085], [-121.23132, 38.53101], [-121.23173, 38.53129], [-121.23186, 38.53132], [-121.23187, 38.53141], [-121.23214, 38.53159]]]} | Open Access 1 | 48861 | Kavala Ranch Park | 33581 | 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 | https://crpd.com/parks/kavala-ranch/ | Sacramento 41 | 4.825 | Kavala Ranch Park | 0 | Local Park 2 | 4 |
14396 | 14396 | 14395 | {"type": "Polygon", "coordinates": [[[-121.20685, 38.55729], [-121.20612, 38.55679], [-121.2057, 38.55716], [-121.20571, 38.55567], [-121.2061, 38.55554], [-121.20642, 38.55548], [-121.20676, 38.55548], [-121.20712, 38.55553], [-121.20749, 38.55565], [-121.20816, 38.55625], [-121.20817, 38.55629], [-121.20815, 38.55632], [-121.20781, 38.55648], [-121.20757, 38.55664], [-121.20685, 38.55729]]]} | Open Access 1 | 48860 | Sunridge Park | 33580 | 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 | https://crpd.com/parks/sunridge-park/ | Sacramento 41 | 7.145 | Sunridge Park | 0 | Local Park 2 | 4 |
13662 | 13662 | 13661 | {"type": "Polygon", "coordinates": [[[-121.31223, 38.60202], [-121.31034, 38.6035], [-121.31033, 38.60352], [-121.31034, 38.60354], [-121.30748, 38.60507], [-121.30707, 38.60476], [-121.308, 38.60403], [-121.30764, 38.60358], [-121.30773, 38.60336], [-121.30797, 38.60342], [-121.30827, 38.60269], [-121.3078, 38.60256], [-121.30816, 38.60167], [-121.30997, 38.60023], [-121.31223, 38.60202]]]} | Open Access 1 | 36028 | Hagan Community Park | 19592 | 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 | 26.28 | Hagan Community 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 | |
12291 | 12291 | 12290 | {"type": "Polygon", "coordinates": [[[-121.28287, 38.54612], [-121.28277, 38.5463], [-121.28298, 38.54638], [-121.28312, 38.54615], [-121.28249, 38.5459], [-121.28307, 38.54519], [-121.2831, 38.54518], [-121.2834, 38.54533], [-121.28355, 38.54544], [-121.28366, 38.54556], [-121.28375, 38.54569], [-121.28383, 38.54584], [-121.28387, 38.546], [-121.28389, 38.54611], [-121.28388, 38.54625], [-121.28385, 38.54638], [-121.28375, 38.5466], [-121.28357, 38.54682], [-121.28342, 38.54693], [-121.28327, 38.54702], [-121.28311, 38.54709], [-121.28294, 38.54714], [-121.28262, 38.54718], [-121.28229, 38.54716], [-121.28191, 38.54706], [-121.2819, 38.54703], [-121.28221, 38.54635], [-121.28245, 38.54596], [-121.28287, 38.54612]]]} | Open Access 1 | 25944 | Veterans Park | 27056 | 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 | 5.713 | Veterans Park | 0 | Local Park 2 | 4 | |
12290 | 12290 | 12289 | {"type": "Polygon", "coordinates": [[[-121.27262, 38.57888], [-121.27196, 38.5792], [-121.27192, 38.57926], [-121.27187, 38.57926], [-121.27181, 38.57928], [-121.27177, 38.57931], [-121.27175, 38.57936], [-121.27179, 38.57945], [-121.27177, 38.57948], [-121.27141, 38.57948], [-121.27113, 38.57944], [-121.27067, 38.5791], [-121.27083, 38.57873], [-121.27097, 38.5785], [-121.27117, 38.57828], [-121.27147, 38.57807], [-121.27173, 38.57793], [-121.27184, 38.57795], [-121.27254, 38.57879], [-121.27262, 38.57888]]]} | Open Access 1 | 25943 | Tuscany Park | 26602 | 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 | 4.231 | Tuscany Park | 0 | Local Park 2 | 4 | |
12289 | 12289 | 12288 | {"type": "Polygon", "coordinates": [[[-121.27362, 38.62465], [-121.27342, 38.62538], [-121.27319, 38.62557], [-121.27257, 38.6255], [-121.27255, 38.62542], [-121.27248, 38.62539], [-121.27236, 38.62537], [-121.27202, 38.62528], [-121.27142, 38.62517], [-121.27139, 38.62515], [-121.27137, 38.62512], [-121.27158, 38.62477], [-121.27176, 38.62438], [-121.2719, 38.62418], [-121.27225, 38.62432], [-121.27362, 38.62465]]]} | Open Access 1 | 25942 | Sunriver Park | 26040 | 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 | 4.642 | Sunriver Park | 0 | Local Park 2 | 4 | |
12288 | 12288 | 12287 | {"type": "Polygon", "coordinates": [[[-121.27946, 38.56943], [-121.27965, 38.57223], [-121.27964, 38.57254], [-121.2796, 38.5728], [-121.27953, 38.57311], [-121.27937, 38.57356], [-121.27924, 38.57381], [-121.27911, 38.57404], [-121.27879, 38.57446], [-121.27841, 38.57486], [-121.27808, 38.57513], [-121.27759, 38.57548], [-121.27753, 38.57543], [-121.27753, 38.57538], [-121.27811, 38.57495], [-121.27853, 38.57456], [-121.27876, 38.5743], [-121.27887, 38.57416], [-121.27892, 38.57406], [-121.27893, 38.57391], [-121.27884, 38.57376], [-121.27877, 38.5737], [-121.27853, 38.5736], [-121.27834, 38.57347], [-121.2782, 38.57336], [-121.27803, 38.57319], [-121.27777, 38.57299], [-121.27764, 38.57284], [-121.27755, 38.57271], [-121.27748, 38.57253], [-121.27735, 38.57233], [-121.27725, 38.57224], [-121.27684, 38.57206], [-121.2766, 38.57191], [-121.27636, 38.57171], [-121.27627, 38.57158], [-121.27624, 38.57148], [-121.27624, 38.57138], [-121.2764, 38.57113], [-121.27681, 38.57088], [-121.27771, 38.57061], [-121.27837, 38.57058], [-121.27886, 38.57065], [-121.27918, 38.57078], [-121.27922, 38.57078], [-121.27933, 38.57076], [-121.27941, 38.57071], [-121.27945, 38.57062], [-121.27938, 38.56947], [-121.27946, 38.56943]]]} | Open Access 1 | 25940 | Stone Creek Community Park | 25867 | 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 | 18.334 | Stone Creek Community Park | 0 | Local Park 2 | 4 | |
12286 | 12286 | 12285 | {"type": "Polygon", "coordinates": [[[-121.34637, 38.54437], [-121.34635, 38.54442], [-121.34634, 38.54451], [-121.346, 38.54444], [-121.34586, 38.54485], [-121.34561, 38.54522], [-121.34534, 38.54497], [-121.34532, 38.54458], [-121.34599, 38.54421], [-121.34637, 38.54437]]]} | Open Access 1 | 25938 | Rosswood Park | 24680 | 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 | 1.104 | Rosswood Park | 0 | Local Park 2 | 4 | |
11746 | 11746 | 11745 | {"type": "Polygon", "coordinates": [[[-121.40928, 38.45719], [-121.40871, 38.45878], [-121.40829, 38.45876], [-121.40789, 38.45876], [-121.4075, 38.45879], [-121.407, 38.45885], [-121.4065, 38.45895], [-121.40595, 38.45914], [-121.40588, 38.45911], [-121.40581, 38.459], [-121.40565, 38.45865], [-121.40557, 38.45843], [-121.40548, 38.45807], [-121.40542, 38.45769], [-121.4054, 38.45739], [-121.40541, 38.45709], [-121.40544, 38.45703], [-121.40556, 38.45636], [-121.40559, 38.45632], [-121.40565, 38.45631], [-121.40599, 38.45634], [-121.40829, 38.45695], [-121.40928, 38.45719]]]} | Open Access 1 | 24039 | Countryside Community Park | 17708 | 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 | 18.285 | Countryside Community Park | 0 | Local Park 2 | 4 | |
11713 | 11713 | 11712 | {"type": "Polygon", "coordinates": [[[-121.36159, 38.53637], [-121.36153, 38.53648], [-121.3615, 38.53648], [-121.36134, 38.53667], [-121.36134, 38.53695], [-121.36011, 38.53694], [-121.36007, 38.53693], [-121.36005, 38.5369], [-121.36005, 38.53629], [-121.36009, 38.53622], [-121.36017, 38.53615], [-121.36019, 38.5361], [-121.36016, 38.53603], [-121.36008, 38.53599], [-121.36009, 38.53595], [-121.36159, 38.53637]]]} | Open Access 1 | 24009 | Primrose Park | 24003 | 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 | 2.588 | Primrose Park | 0 | Local Park 2 | 4 | |
11712 | 11712 | 11711 | {"type": "Polygon", "coordinates": [[[-121.35089, 38.54512], [-121.35061, 38.54519], [-121.35033, 38.5452], [-121.35033, 38.54473], [-121.3508, 38.54468], [-121.35089, 38.54512]]]} | Open Access 1 | 24008 | Henley Park | 19818 | 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 | 0.591 | Henley Park | 0 | Local Park 2 | 4 | |
11711 | 11711 | 11710 | {"type": "Polygon", "coordinates": [[[-121.28033, 38.54412], [-121.27999, 38.54452], [-121.27967, 38.54497], [-121.27943, 38.54539], [-121.2792, 38.5459], [-121.2791, 38.54587], [-121.27852, 38.54594], [-121.27836, 38.54512], [-121.27937, 38.54391], [-121.27948, 38.54394], [-121.27938, 38.54429], [-121.27984, 38.54438], [-121.28006, 38.5437], [-121.28012, 38.54369], [-121.28015, 38.54378], [-121.28033, 38.54412]]]} | Open Access 1 | 24007 | 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 | 4.608 | Independence Park | 0 | Local Park 2 | 4 | |
11710 | 11710 | 11709 | {"type": "Polygon", "coordinates": [[[-121.35365, 38.55201], [-121.35123, 38.55245], [-121.3507, 38.5526], [-121.34978, 38.55126], [-121.3504, 38.55078], [-121.35068, 38.5506], [-121.35104, 38.55043], [-121.35139, 38.55031], [-121.35171, 38.55024], [-121.35213, 38.55019], [-121.35352, 38.55019], [-121.35352, 38.55152], [-121.35365, 38.55201]]]} | Open Access 1 | 24006 | Rosemont Community Park | 24622 | 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 | 16.027 | Rosemont Community Park | 0 | Local Park 2 | 4 | |
11706 | 11706 | 11705 | {"type": "Polygon", "coordinates": [[[-121.36334, 38.55723], [-121.36257, 38.55762], [-121.36242, 38.55766], [-121.36227, 38.55768], [-121.36223, 38.55742], [-121.36205, 38.55743], [-121.36191, 38.55645], [-121.36279, 38.55637], [-121.36282, 38.55665], [-121.36288, 38.55665], [-121.36334, 38.55723]]]} | Open Access 1 | 24003 | Manlove Park | 21751 | 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 | 2.85 | Manlove Park | 0 | Local Park 2 | 4 | |
11705 | 11705 | 11704 | {"type": "Polygon", "coordinates": [[[-121.35261, 38.55785], [-121.35216, 38.5583], [-121.35181, 38.55855], [-121.35162, 38.55839], [-121.35127, 38.5586], [-121.35118, 38.55847], [-121.35109, 38.55821], [-121.35107, 38.5581], [-121.35103, 38.55805], [-121.35099, 38.55802], [-121.35101, 38.55796], [-121.35093, 38.55773], [-121.3517, 38.55757], [-121.35231, 38.55746], [-121.35235, 38.55769], [-121.35261, 38.55785]]]} | Open Access 1 | 24002 | Rosemont North Park | 24623 | 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 | 2.783 | Rosemont North Park | 0 | Local Park 2 | 4 | |
11704 | 11704 | 11703 | {"type": "MultiPolygon", "coordinates": [[[[-121.37216, 38.55979], [-121.37215, 38.56051], [-121.37168, 38.56054], [-121.3715, 38.55986], [-121.37216, 38.55979]]], [[[-121.37215, 38.56066], [-121.37213, 38.56155], [-121.37195, 38.56158], [-121.37172, 38.56069], [-121.37215, 38.56066]]]]} | Open Access 1 | 24001 | Salmon Falls Park | 24807 | 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 | https://crpd.com/parks/salmon-falls-park/ | Sacramento 41 | 1.628 | Salmon Falls Park | 0 | Local Park 2 | 4 |
11702 | 11702 | 11701 | {"type": "Polygon", "coordinates": [[[-121.32083, 38.56642], [-121.32066, 38.56655], [-121.32071, 38.56678], [-121.32065, 38.56691], [-121.32067, 38.56717], [-121.32081, 38.56787], [-121.31809, 38.56786], [-121.31809, 38.56555], [-121.32057, 38.56556], [-121.3207, 38.56563], [-121.32064, 38.56606], [-121.32083, 38.56642]]]} | Open Access 1 | 23999 | Lincoln Village Park | 21277 | 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 | 14.462 | Lincoln Village Park | 0 | Local Park 2 | 4 | |
11701 | 11701 | 11700 | {"type": "Polygon", "coordinates": [[[-121.36093, 38.5692], [-121.36015, 38.56933], [-121.35965, 38.56944], [-121.35916, 38.56957], [-121.35834, 38.56982], [-121.35794, 38.56992], [-121.35784, 38.56966], [-121.35782, 38.56964], [-121.35786, 38.56961], [-121.35791, 38.56965], [-121.35818, 38.56972], [-121.35829, 38.56947], [-121.35801, 38.56939], [-121.35801, 38.56936], [-121.35839, 38.56926], [-121.35755, 38.56692], [-121.35819, 38.56676], [-121.35839, 38.56669], [-121.35861, 38.56657], [-121.35882, 38.5664], [-121.35902, 38.56654], [-121.35909, 38.56657], [-121.35973, 38.56835], [-121.36055, 38.56815], [-121.36093, 38.5692]]]} | Open Access 1 | 23998 | Larchmont Community Park | 21023 | 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 | 14.052 | Larchmont Community 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]);