units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
39 rows where MNG_AGENCY = 639 sorted by AGNCY_TYP
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Sunrise Recreation and Park District · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13692 | 13692 | 13691 | {"type": "Polygon", "coordinates": [[[-121.2693, 38.71205], [-121.26927, 38.71499], [-121.2671, 38.71497], [-121.2671, 38.71204], [-121.2693, 38.71205]]]} | Open Access 1 | 36076 | Madera Park | 21654 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 15.326 | Madera Park | 0 | Local Park 2 | 4 | |
13713 | 13713 | 13712 | {"type": "Polygon", "coordinates": [[[-121.25298, 38.69746], [-121.25298, 38.69861], [-121.25254, 38.69848], [-121.25252, 38.69849], [-121.25248, 38.69848], [-121.25142, 38.69879], [-121.2513, 38.6986], [-121.25118, 38.69846], [-121.25171, 38.69808], [-121.25203, 38.69778], [-121.25199, 38.69751], [-121.25245, 38.69746], [-121.25298, 38.69746]]]} | Open Access 1 | 36220 | Northwoods Park | 22902 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.516 | Northwoods Park | 0 | Local Park 2 | 4 | |
13728 | 13728 | 13727 | {"type": "Polygon", "coordinates": [[[-121.33198, 38.7005], [-121.33109, 38.70131], [-121.33107, 38.70125], [-121.33084, 38.70109], [-121.33084, 38.70106], [-121.33088, 38.70097], [-121.32959, 38.70009], [-121.32886, 38.6999], [-121.3287, 38.69943], [-121.3286, 38.6994], [-121.32859, 38.69931], [-121.32852, 38.69925], [-121.32859, 38.69913], [-121.32835, 38.69835], [-121.32869, 38.69818], [-121.32875, 38.69818], [-121.32901, 38.69846], [-121.32923, 38.69865], [-121.33145, 38.70014], [-121.33151, 38.70021], [-121.33163, 38.70026], [-121.33198, 38.7005]], [[-121.33134, 38.70057], [-121.33134, 38.70056], [-121.33108, 38.70039], [-121.33097, 38.70048], [-121.33123, 38.70067], [-121.33134, 38.70057]]]} | Open Access 1 | 36211 | Sunrise Recreation and Park District 8 | 26037 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.356 | Sunrise Rec. and Park District 8 | 0 | Local Recreation Area 3 | 4 | |
13730 | 13730 | 13729 | {"type": "Polygon", "coordinates": [[[-121.31655, 38.67259], [-121.31615, 38.67248], [-121.31541, 38.67249], [-121.31541, 38.67194], [-121.31568, 38.67194], [-121.31611, 38.67179], [-121.31649, 38.67247], [-121.31655, 38.67259]]]} | Open Access 1 | 36216 | Park Oaks Park | 23430 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.367 | Park Oaks Park | 0 | Local Park 2 | 4 | |
13731 | 13731 | 13730 | {"type": "Polygon", "coordinates": [[[-121.30473, 38.71495], [-121.30471, 38.71498], [-121.30415, 38.71518], [-121.30403, 38.71521], [-121.30394, 38.71529], [-121.30394, 38.71535], [-121.30359, 38.71547], [-121.30346, 38.71549], [-121.30209, 38.71555], [-121.30196, 38.71558], [-121.3018, 38.71563], [-121.30158, 38.71577], [-121.30262, 38.71457], [-121.3039, 38.7134], [-121.30404, 38.71349], [-121.30425, 38.7135], [-121.30426, 38.71358], [-121.30442, 38.71359], [-121.30442, 38.71386], [-121.30448, 38.71433], [-121.30462, 38.71472], [-121.30473, 38.71495]]]} | Open Access 1 | 36217 | Westwood Park | 27443 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 8.004 | Westwood Park | 0 | Local Park 2 | 4 | |
13732 | 13732 | 13731 | {"type": "Polygon", "coordinates": [[[-121.30691, 38.67268], [-121.3051, 38.67271], [-121.30415, 38.67288], [-121.30393, 38.67288], [-121.30394, 38.67079], [-121.3069, 38.67079], [-121.30691, 38.67268]]]} | Open Access 1 | 36218 | Brooktree Park | 16435 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 13.839 | Brooktree Park | 0 | Local Park 2 | 4 | |
13733 | 13733 | 13732 | {"type": "Polygon", "coordinates": [[[-121.28845, 38.66639], [-121.28467, 38.66642], [-121.28465, 38.6648], [-121.28843, 38.66477], [-121.28845, 38.66639]]]} | Open Access 1 | 36219 | San Juan Park | 24920 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 14.651 | San Juan Park | 0 | Local Park 2 | 4 | |
13734 | 13734 | 13733 | {"type": "Polygon", "coordinates": [[[-121.31984, 38.6729], [-121.31981, 38.67403], [-121.31889, 38.67397], [-121.31903, 38.67441], [-121.31896, 38.67443], [-121.31884, 38.67402], [-121.31879, 38.674], [-121.31813, 38.6743], [-121.31755, 38.67431], [-121.31708, 38.6746], [-121.31694, 38.67505], [-121.31683, 38.6751], [-121.31647, 38.6751], [-121.31632, 38.67497], [-121.31602, 38.675], [-121.31607, 38.67479], [-121.31643, 38.67489], [-121.31661, 38.67481], [-121.31707, 38.67386], [-121.31767, 38.67391], [-121.31805, 38.67385], [-121.31831, 38.67374], [-121.31891, 38.67342], [-121.31937, 38.6729], [-121.31984, 38.6729]]]} | Open Access 1 | 36222 | Shadowcreek Park | 25342 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 5.38 | Shadowcreek Park | 0 | Local Park 2 | 4 | |
14124 | 14124 | 14123 | {"type": "Polygon", "coordinates": [[[-121.25641, 38.7041], [-121.25359, 38.70412], [-121.25365, 38.70058], [-121.25519, 38.70056], [-121.25522, 38.70103], [-121.25635, 38.70102], [-121.25641, 38.7041]]]} | Open Access 1 | 43016 | C-Bar-C Park | 16623 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 22.055 | C-Bar-C Park | 0 | Local Park 2 | 4 | |
14125 | 14125 | 14124 | {"type": "Polygon", "coordinates": [[[-121.29954, 38.71017], [-121.29705, 38.71019], [-121.29704, 38.70937], [-121.29055, 38.70941], [-121.29054, 38.7073], [-121.29165, 38.70731], [-121.29228, 38.70735], [-121.29265, 38.70743], [-121.29439, 38.70744], [-121.29441, 38.70742], [-121.29476, 38.70752], [-121.29497, 38.70754], [-121.29951, 38.7075], [-121.29954, 38.71017]]]} | Open Access 1 | 43018 | Rusch Park | 24733 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 46.067 | Rusch Park | 0 | Local Park 2 | 4 | |
14188 | 14188 | 14187 | {"type": "Polygon", "coordinates": [[[-121.34316, 38.67726], [-121.34314, 38.67731], [-121.34317, 38.67742], [-121.34317, 38.67773], [-121.34315, 38.67776], [-121.34285, 38.67782], [-121.34266, 38.67788], [-121.34246, 38.67798], [-121.34233, 38.67808], [-121.34293, 38.67748], [-121.34304, 38.67739], [-121.34316, 38.67726]]]} | Open Access 1 | 44008 | Rushmore Jeanine Park | 24735 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 0.434 | Rushmore Jeanine Park | 0 | Local Park 2 | 4 | |
14243 | 14243 | 14242 | {"type": "Polygon", "coordinates": [[[-121.2692, 38.70536], [-121.2692, 38.70651], [-121.2682, 38.70653], [-121.2682, 38.70579], [-121.26831, 38.70574], [-121.2692, 38.70536]]]} | Open Access 1 | 44136 | McDonald Field Park | 22021 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.271 | McDonald Field Park | 0 | Local Recreation Area 3 | 4 | |
16206 | 16206 | 16205 | {"type": "MultiPolygon", "coordinates": [[[[-121.25745, 38.71827], [-121.25706, 38.71836], [-121.25661, 38.71824], [-121.25604, 38.71835], [-121.25531, 38.7183], [-121.25481, 38.7183], [-121.25458, 38.71785], [-121.25377, 38.71788], [-121.25328, 38.7182], [-121.25312, 38.71819], [-121.25286, 38.71813], [-121.25264, 38.71812], [-121.25257, 38.71784], [-121.25237, 38.71788], [-121.25149, 38.71703], [-121.25155, 38.717], [-121.25163, 38.71644], [-121.25132, 38.71635], [-121.25131, 38.71616], [-121.2509, 38.71615], [-121.25093, 38.71604], [-121.25088, 38.71596], [-121.25078, 38.71592], [-121.25061, 38.71591], [-121.25062, 38.71554], [-121.25014, 38.71543], [-121.25015, 38.71537], [-121.24976, 38.71477], [-121.24969, 38.71478], [-121.24951, 38.71459], [-121.24941, 38.71442], [-121.24946, 38.71417], [-121.24989, 38.714], [-121.24981, 38.71437], [-121.25022, 38.71465], [-121.25022, 38.71501], [-121.25049, 38.71539], [-121.25132, 38.71542], [-121.25177, 38.71557], [-121.25215, 38.71577], [-121.2526, 38.71618], [-121.25276, 38.71637], [-121.25277, 38.71658], [-121.25261, 38.71688], [-121.25297, 38.71734], [-121.25333, 38.71738], [-121.25374, 38.71722], [-121.25376, 38.71752], [-121.25438, 38.71751], [-121.25463, 38.71726], [-121.2548, 38.71733], [-121.25492, 38.71737], [-121.25509, 38.7178], [-121.25531, 38.7178], [-121.2561, 38.71779], [-121.25611, 38.71739], [-121.25646, 38.71738], [-121.25695, 38.7173], [-121.25696, 38.71737], [-121.25722, 38.71769], [-121.2574, 38.71774], [-121.25738, 38.71787], [-121.25739, 38.71803], [-121.25745, 38.71827]]], [[[-121.26254, 38.71962], [-121.26116, 38.71952], [-121.26128, 38.71921], [-121.26101, 38.71881], [-121.26072, 38.71861], [-121.26024, 38.71858], [-121.26019, 38.71897], [-121.25863, 38.71886], [-121.25863, 38.71854], [-121.25823, 38.71839], [-121.25818, 38.71824], [-121.2577, 38.7182], [-121.25763, 38.71822], [-121.25758, 38.71806], [-121.25757, 38.71792], [-121.25758, 38.71779], [-121.25762, 38.71768], [-121.25763, 38.71764], [-121.25811, 38.71778], [-121.25821, 38.71765], [-121.25843, 38.7178], [-121.25868, 38.71794], [-121.25896, 38.71806], [-121.25924, 38.71814], [-121.25971, 38.71822], [-121.26008, 38.71788], [-121.2606, 38.71806], [-121.26089, 38.71821], [-121.26131, 38.71847], [-121.26162, 38.71861], [-121.26184, 38.71867], [-121.26209, 38.71872], [-121.26253, 38.71873], [-121.26254, 38.71962]]]]} | Open Access 1 | 44064 | Edgecliff/Cripple Creek Open Space | 18434 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 24.487 | Edgecliff/Cripple Creek OS | 0 | Local Recreation Area 3 | 4 | |
16216 | 16216 | 16215 | {"type": "MultiPolygon", "coordinates": [[[[-121.32436, 38.68423], [-121.32407, 38.68432], [-121.32368, 38.6844], [-121.32312, 38.68449], [-121.32291, 38.68451], [-121.32292, 38.68418], [-121.32377, 38.68406], [-121.32405, 38.68399], [-121.32436, 38.68423]]], [[[-121.32508, 38.68324], [-121.32478, 38.68325], [-121.32473, 38.68326], [-121.32467, 38.6833], [-121.32465, 38.68337], [-121.32468, 38.68362], [-121.32468, 38.68382], [-121.32466, 38.68391], [-121.32462, 38.68401], [-121.32454, 38.6841], [-121.32446, 38.68416], [-121.32442, 38.68413], [-121.32416, 38.68394], [-121.32422, 38.68386], [-121.32423, 38.68378], [-121.32417, 38.68325], [-121.32412, 38.68308], [-121.324, 38.68282], [-121.32378, 38.68248], [-121.32363, 38.68218], [-121.32358, 38.68216], [-121.32354, 38.68218], [-121.32339, 38.6824], [-121.32327, 38.68266], [-121.32317, 38.68301], [-121.32303, 38.68321], [-121.32294, 38.68327], [-121.32298, 38.68193], [-121.32316, 38.6819], [-121.32321, 38.6818], [-121.32365, 38.68166], [-121.32378, 38.68166], [-121.32397, 38.68175], [-121.32409, 38.68185], [-121.32434, 38.6819], [-121.32437, 38.68215], [-121.32447, 38.68239], [-121.32458, 38.68254], [-121.3249, 38.68291], [-121.32499, 38.68305], [-121.32508, 38.68324]]], [[[-121.32685, 38.68121], [-121.32683, 38.68171], [-121.32655, 38.68189], [-121.32646, 38.68223], [-121.32636, 38.68246], [-121.32629, 38.68257], [-121.32613, 38.68273], [-121.32551, 38.68316], [-121.3254, 38.68322], [-121.32526, 38.68326], [-121.32516, 38.68302], [-121.32503, 38.6828], [-121.32517, 38.68278], [-121.32535, 38.68268], [-121.3254, 38.68256], [-121.3256, 38.68232], [-121.32558, 38.68229], [-121.32565, 38.68223], [-121.32567, 38.68218], [-121.32565, 38.68212], [-121.32572, 38.6819], [-121.32573, 38.6817], [-121.32577, 38.68162], [-121.32575, 38.68155], [-121.32585, 38.68149], [-121.32576, 38.6812], [-121.32685, 38.68121]]]]} | Open Access 1 | 44675 | Indian River Drive Open Space | 20205 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 10.226 | Indian River Drive OS | 0 | Local Recreation Area 3 | 4 | |
16428 | 16428 | 16427 | {"type": "Polygon", "coordinates": [[[-121.3691, 38.71888], [-121.36732, 38.71887], [-121.36729, 38.71676], [-121.36908, 38.71677], [-121.3691, 38.71888]]]} | Open Access 1 | 36214 | Sunrise Recreation and Park District 6 | 26035 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 8.994 | Sunrise Rec. and Park District 6 | 0 | Local Recreation Area 3 | 4 | |
16742 | 16742 | 16741 | {"type": "Polygon", "coordinates": [[[-121.32665, 38.68958], [-121.32655, 38.69096], [-121.32515, 38.69004], [-121.32568, 38.68963], [-121.32578, 38.68948], [-121.32589, 38.68912], [-121.32664, 38.68924], [-121.32663, 38.68957], [-121.32665, 38.68958]]]} | Open Access 1 | 36221 | Sunrise Recreation and Park District 11 | 26030 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.71 | Sunrise Rec. and Park District 11 | 0 | Local Recreation Area 3 | 4 | |
16826 | 16826 | 16825 | {"type": "Polygon", "coordinates": [[[-121.36676, 38.71031], [-121.36676, 38.71063], [-121.36455, 38.7106], [-121.36455, 38.70886], [-121.36557, 38.70887], [-121.36582, 38.70884], [-121.36607, 38.7088], [-121.36675, 38.7088], [-121.36676, 38.71031]]]} | Open Access 1 | 35621 | Sunrise Recreation and Park District 3 | 26032 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.37 | Sunrise Rec. and Park District 3 | 0 | Local Recreation Area 3 | 4 | |
16827 | 16827 | 16826 | {"type": "Polygon", "coordinates": [[[-121.32934, 38.71856], [-121.32928, 38.71858], [-121.32923, 38.71861], [-121.32919, 38.71868], [-121.3292, 38.71984], [-121.32918, 38.71987], [-121.32914, 38.71989], [-121.3281, 38.7199], [-121.32809, 38.71908], [-121.32763, 38.71908], [-121.32762, 38.71844], [-121.32934, 38.71841], [-121.32934, 38.71856]]]} | Open Access 1 | 35622 | Sunrise Recreation and Park District 1 | 26029 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 4.642 | Sunrise Rec. and Park District 1 | 0 | Local Recreation Area 3 | 4 | |
16828 | 16828 | 16827 | {"type": "Polygon", "coordinates": [[[-121.33686, 38.70649], [-121.33669, 38.7071], [-121.33335, 38.70713], [-121.33368, 38.70691], [-121.33402, 38.70678], [-121.33444, 38.70665], [-121.33575, 38.7064], [-121.33619, 38.70626], [-121.33645, 38.70616], [-121.33652, 38.70619], [-121.33664, 38.70634], [-121.33667, 38.70642], [-121.3367, 38.70645], [-121.33679, 38.70649], [-121.33686, 38.70649]]]} | Open Access 1 | 35625 | Sunrise Recreation and Park District 5 | 26034 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 4.566 | Sunrise Rec. and Park District 5 | 0 | Local Recreation Area 3 | 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]);