units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2,383 rows where AGNCY_LEV = 4
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 273
- East Bay Regional Park District 129
- Consumnes Community Services District 92
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 58
- Rancho Simi Recreation and Park District 52
- Yuba County Water Agency 50
- Conejo Recreation and Park District 49
- Midpeninsula Regional Open Space District 49
- Conejo Open Space Conservation Agency 43
- Southgate Recreation and Park District 41
- Marin County Open Space District 39
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 38
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 30
- Fresno Metropolitan Flood Control District 29
- Las Virgenes Municipal Water District 28
- North of the River Recreation and Park District 27
- El Dorado Hills Community Service District 25
- Monterey Peninsula Regional Park District 24
- Los Angeles County Flood Control District 23
- Olivehurst Public Utility District 23
- Santa Clara Valley Open Space Authority 22
- Natomas Basin Conservancy 22
- Sonoma County Agricultural Preservation and Open Space District 21
- Santa Barbara Flood Control and Water Conserv. District 18
- Isla Vista Recreation and Park District 18
- Whittier, City of 18
- Jurupa Area Recreation and Park District 18
- …
DES_TP >30
- Local Park 1,130
- Local Recreation Area 400
- Local Other or Unknown 285
- Local Conservation Area 209
- Local Historic or Cultural Area 51
- Local Resource Management Area 10
- National Monument or Landmark 2
- State Conservation Area 1
- State Park 1
- National Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 23
- Recreation/Parks District 1,093
- Open Space District 339
- Water District 232
- Community Services District 195
- City Agency 160
- Flood District 104
- Cemetery District 56
- Irrigation District 49
- School District 37
- Port/Harbor District 30
- Special District - Other 15
- County Agency - Parks 12
- Sanitation District 9
- County Agency 7
- Non Profit - Land Trust 5
- Conservation District 5
- Transportation Agency 5
- State Agency 2
- Non Profit - Conservation 2
- Joint Powers Authority 2
- Metropolitan Planning Organization 2
- Airport District 1
- Fire District 1
ACCESS_TYP 4
- Open Access 1,642
- No Public Access 261
- Restricted Access 251
- Unknown Access 209
LAYER 1 ✖
- Special District 2,363
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
286 | 286 | 285 | {"type": "Polygon", "coordinates": [[[-119.13521, 36.30947], [-119.1351, 36.31147], [-119.13075, 36.31143], [-119.13077, 36.31043], [-119.1323, 36.31043], [-119.13238, 36.30936], [-119.13521, 36.30947]]]} | Open Access 1 | 778 | Exeter Cemetery | 18773 | 2033 | Exeter Cemetery District 99 | Special District 4 | Cemetery District 11 | Special District 4 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Tulare 29 | 18.069 | Exeter Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
290 | 290 | 289 | {"type": "Polygon", "coordinates": [[[-119.10764, 36.34977], [-119.10762, 36.35107], [-119.1054, 36.35107], [-119.10542, 36.34976], [-119.10764, 36.34977]]]} | Open Access 1 | 782 | Hamilton Cemetery | 19616 | 2033 | Exeter Cemetery District 99 | Special District 4 | Cemetery District 11 | Special District 4 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Tulare 29 | 7.139 | Hamilton Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
298 | 298 | 297 | {"type": "Polygon", "coordinates": [[[-118.95592, 36.14627], [-118.95521, 36.14626], [-118.9552, 36.14479], [-118.95589, 36.1448], [-118.95592, 36.14627]]]} | Open Access 1 | 802 | Frazier Valley Cemetery | 19071 | 2060 | Lindsay-Strathmore Cemetery District 122 | Special District 4 | Cemetery District 11 | Special District 4 | 2060 | Lindsay-Strathmore Cemetery District 119 | Special District 4 | Cemetery District 11 | Tulare 29 | 2.538 | Frazier Valley Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
303 | 303 | 302 | {"type": "Polygon", "coordinates": [[[-118.87425, 34.22586], [-118.87258, 34.2261], [-118.87258, 34.22433], [-118.87408, 34.22434], [-118.87409, 34.22539], [-118.87418, 34.22551], [-118.87425, 34.22586]]]} | Open Access 1 | 1040 | Spring Meadow Park | 25741 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 6.467 | Spring Meadow Park | 0 | Local Park 2 | 4 | |
304 | 304 | 303 | {"type": "Polygon", "coordinates": [[[-119.10787, 36.41389], [-119.10786, 36.41561], [-119.10573, 36.41561], [-119.10572, 36.4146], [-119.10643, 36.4146], [-119.10644, 36.41385], [-119.10787, 36.41389]]]} | Open Access 1 | 1041 | Antelope Cemetery | 15507 | 2184 | Woodlake Public Cemetery District 124 | Special District 4 | Cemetery District 11 | Special District 4 | 2184 | Woodlake Public Cemetery District 121 | Special District 4 | Cemetery District 11 | Tulare 29 | 7.877 | Antelope Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
332 | 332 | 331 | {"type": "Polygon", "coordinates": [[[-121.31293, 36.42631], [-121.31293, 36.42822], [-121.31184, 36.42912], [-121.3115, 36.42912], [-121.3115, 36.42606], [-121.31293, 36.42631]]]} | Open Access 1 | 911 | Soledad Cemetery | 25597 | 2153 | Soledad Cemetery District 135 | Special District 4 | Cemetery District 11 | Special District 4 | 2153 | Soledad Cemetery District 132 | Special District 4 | Cemetery District 11 | Monterey 14 | 9.116 | Soledad Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
347 | 347 | 346 | {"type": "Polygon", "coordinates": [[[-117.85051, 34.14864], [-117.85051, 34.14999], [-117.84989, 34.15], [-117.84989, 34.15052], [-117.84633, 34.15052], [-117.84629, 34.15049], [-117.84629, 34.14964], [-117.84651, 34.14929], [-117.84697, 34.14876], [-117.84774, 34.14876], [-117.84775, 34.14814], [-117.84839, 34.14815], [-117.84839, 34.14865], [-117.85051, 34.14864]]]} | Restricted Access 2 | 953 | George Manooshian Park | 29754 | 2312 | Glendora Unified School District 141 | Special District 4 | School District 14 | http://www.glendora.k12.ca.us/ | Special District 4 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 18.865 | George Manooshian Park | 0 | Local Park 2 | 4 | |
351 | 351 | 350 | {"type": "Polygon", "coordinates": [[[-119.32193, 36.20761], [-119.32189, 36.20923], [-119.32081, 36.20925], [-119.32078, 36.20934], [-119.31981, 36.20934], [-119.31987, 36.20762], [-119.32193, 36.20761]]]} | Open Access 1 | 969 | Tulare Veterans Memorial Park | 26570 | 2168 | Tulare Veterans Memorial District 144 | Special District 4 | Cemetery District 11 | Special District 4 | 2168 | Tulare Veterans Memorial District 140 | Special District 4 | Cemetery District 11 | Tulare 29 | 8.555 | Tulare Veterans Memorial Park | 0 | Local Park 2 | 4 | ||
358 | 358 | 357 | {"type": "Polygon", "coordinates": [[[-118.84164, 34.14351], [-118.84162, 34.14361], [-118.84153, 34.1437], [-118.84153, 34.14379], [-118.84163, 34.14385], [-118.84147, 34.14417], [-118.84155, 34.14456], [-118.8412, 34.14464], [-118.84027, 34.14465], [-118.83984, 34.1442], [-118.83987, 34.14412], [-118.84004, 34.14402], [-118.84058, 34.14361], [-118.84113, 34.14306], [-118.84128, 34.14315], [-118.84155, 34.14336], [-118.84164, 34.14351]]]} | Open Access 1 | 1009 | Southshore Hills Park | 25696 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.475 | Southshore Hills Park | 0 | Local Park 2 | 4 | |
365 | 365 | 364 | {"type": "MultiPolygon", "coordinates": [[[[-119.08732, 34.22541], [-119.08716, 34.2256], [-119.08697, 34.22573], [-119.08674, 34.22581], [-119.08637, 34.22589], [-119.08621, 34.22533], [-119.08622, 34.22508], [-119.08664, 34.22498], [-119.08731, 34.22537], [-119.08732, 34.22541]]], [[[-119.08846, 34.22607], [-119.08817, 34.22634], [-119.0866, 34.22666], [-119.08642, 34.22605], [-119.08683, 34.22596], [-119.08707, 34.22587], [-119.08725, 34.22575], [-119.08748, 34.22552], [-119.08752, 34.22551], [-119.08846, 34.22607]]]]} | Open Access 1 | 1045 | Springville Park | 25752 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.87 | Springville Park | 0 | Local Park 2 | 4 | |
366 | 366 | 365 | {"type": "Polygon", "coordinates": [[[-119.18856, 36.09471], [-119.18594, 36.09472], [-119.18594, 36.09315], [-119.18855, 36.09314], [-119.18856, 36.09471]]]} | Open Access 1 | 1046 | Woodville Cemetery | 27750 | 2185 | Woodville Public Cemetery District 150 | Special District 4 | Cemetery District 11 | Special District 4 | 2185 | Woodville Public Cemetery District 146 | Special District 4 | Cemetery District 11 | Tulare 29 | 10.155 | Woodville Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
368 | 368 | 367 | {"type": "Polygon", "coordinates": [[[-118.91305, 34.18088], [-118.91256, 34.18067], [-118.912, 34.18037], [-118.91123, 34.18041], [-118.91136, 34.17666], [-118.91295, 34.17687], [-118.91305, 34.18088]]]} | Open Access 1 | 1056 | Stagecoach Inn Park | 25777 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 16.214 | Stagecoach Inn Park | 0 | Local Park 2 | 4 | |
385 | 385 | 384 | {"type": "Polygon", "coordinates": [[[-117.15388, 33.67064], [-117.15386, 33.67362], [-117.15375, 33.67366], [-117.15354, 33.67338], [-117.15342, 33.6733], [-117.15342, 33.67327], [-117.15317, 33.67312], [-117.15276, 33.67299], [-117.15275, 33.67297], [-117.15218, 33.67273], [-117.1521, 33.67268], [-117.15205, 33.67268], [-117.15209, 33.67232], [-117.15206, 33.67228], [-117.15172, 33.67207], [-117.15166, 33.67209], [-117.15161, 33.67209], [-117.15158, 33.67206], [-117.15137, 33.67206], [-117.15114, 33.67216], [-117.15096, 33.67243], [-117.15097, 33.67245], [-117.15093, 33.67262], [-117.15094, 33.67265], [-117.15089, 33.67283], [-117.15091, 33.67286], [-117.15091, 33.67306], [-117.15088, 33.67306], [-117.15083, 33.67326], [-117.15041, 33.67303], [-117.15016, 33.67299], [-117.14999, 33.67287], [-117.14973, 33.67259], [-117.14955, 33.67245], [-117.14936, 33.67232], [-117.14933, 33.67232], [-117.14914, 33.6722], [-117.14911, 33.6722], [-117.14903, 33.67215], [-117.14888, 33.67217], [-117.14849, 33.67226], [-117.1482, 33.67272], [-117.14817, 33.6727], [-117.14817, 33.67261], [-117.14814, 33.67256], [-117.1481, 33.67252], [-117.14802, 33.67247], [-117.14821, 33.67255], [-117.14865, 33.67182], [-117.14797, 33.67065], [-117.14945, 33.67065], [-117.14949, 33.67069], [-117.14974, 33.67069], [-117.14978, 33.67065], [-117.15154, 33.67065], [-117.15159, 33.67069], [-117.15184, 33.67069], [-117.15188, 33.67065], [-117.15388, 33.67064]]]} | Open Access 1 | 48338 | Lago Vista Sports Park | 32901 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/lago-vista-sports-park | Riverside 10 | 28.451 | Lago Vista Sports Park | 0 | Local Recreation Area 3 | 4 |
389 | 389 | 388 | {"type": "Polygon", "coordinates": [[[-118.80196, 34.27578], [-118.801, 34.27578], [-118.80023, 34.27408], [-118.80034, 34.2741], [-118.80041, 34.27419], [-118.80046, 34.27422], [-118.80057, 34.27424], [-118.80064, 34.27422], [-118.80071, 34.27418], [-118.80074, 34.27413], [-118.80076, 34.27408], [-118.80183, 34.27407], [-118.80196, 34.27578]]]} | Open Access 1 | 1158 | Strathearn Historical Park & Museum | 25908 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 5.386 | Strathearn Historical Park & Museum | 0 | Local Historic or Cultural Area 19 | 4 | |
403 | 403 | 402 | {"type": "Polygon", "coordinates": [[[-122.51336, 37.9088], [-122.51314, 37.90905], [-122.51286, 37.9095], [-122.51262, 37.91045], [-122.51268, 37.91098], [-122.51245, 37.91139], [-122.51184, 37.91121], [-122.51148, 37.91148], [-122.51096, 37.91151], [-122.51099, 37.91097], [-122.51073, 37.90717], [-122.51103, 37.90745], [-122.51151, 37.90854], [-122.51207, 37.90839], [-122.51279, 37.90839], [-122.51308, 37.90879], [-122.51336, 37.9088]]]} | Open Access 1 | 1554 | Tiburon Ridge Open Space Preserve | 26341 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | Marin 23 | 14.684 | Tiburon Ridge OSP | 0 | Local Conservation Area 4 | 2 | |
413 | 413 | 412 | {"type": "Polygon", "coordinates": [[[-118.60477, 34.27717], [-118.60418, 34.27703], [-118.60318, 34.2767], [-118.60222, 34.27647], [-118.60128, 34.2759], [-118.59886, 34.27528], [-118.59773, 34.27477], [-118.5968, 34.27437], [-118.59644, 34.27429], [-118.59687, 34.27384], [-118.59763, 34.27384], [-118.59817, 34.27352], [-118.59822, 34.27339], [-118.59913, 34.27345], [-118.59979, 34.27347], [-118.60035, 34.2736], [-118.60064, 34.27325], [-118.60057, 34.27261], [-118.60272, 34.2726], [-118.60273, 34.27228], [-118.60457, 34.27224], [-118.60449, 34.27236], [-118.60431, 34.27294], [-118.60432, 34.27441], [-118.60439, 34.27467], [-118.60448, 34.27485], [-118.60448, 34.27491], [-118.60457, 34.27492], [-118.60477, 34.27613], [-118.60481, 34.27645], [-118.60482, 34.27667], [-118.6048, 34.27695], [-118.60477, 34.27717]]]} | Open Access 1 | 831 | Stoney Point Park | 30273 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 55.047 | Stoney Point Park | 0 | Local Park 2 | 4 | |
415 | 415 | 414 | {"type": "Polygon", "coordinates": [[[-118.21396, 34.10912], [-118.21373, 34.10945], [-118.21319, 34.10986], [-118.21289, 34.11018], [-118.21235, 34.11095], [-118.21288, 34.11156], [-118.21273, 34.11194], [-118.21216, 34.11203], [-118.21173, 34.11207], [-118.21061, 34.11072], [-118.21136, 34.11055], [-118.21098, 34.11009], [-118.21022, 34.11025], [-118.21011, 34.11013], [-118.21088, 34.10996], [-118.21117, 34.10978], [-118.2106, 34.10917], [-118.21198, 34.10827], [-118.21371, 34.10856], [-118.2137, 34.10865], [-118.21396, 34.10912]]]} | Open Access 1 | 1647 | Heidelberg Park | 19791 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 18.734 | Heidelberg Park | 0 | Local Park 2 | 4 | |
447 | 447 | 446 | {"type": "Polygon", "coordinates": [[[-119.86022, 34.41121], [-119.86022, 34.41162], [-119.85989, 34.41162], [-119.85989, 34.41121], [-119.86022, 34.41121]]]} | Open Access 1 | 1418 | Trigo Pasado Park | 26535 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.344 | Trigo Pasado Park | 0 | Local Park 2 | 4 | |
450 | 450 | 449 | {"type": "Polygon", "coordinates": [[[-118.84969, 34.15691], [-118.84861, 34.15729], [-118.8484, 34.15705], [-118.84823, 34.15692], [-118.8481, 34.15686], [-118.84745, 34.15669], [-118.8474, 34.15675], [-118.84724, 34.15671], [-118.84701, 34.15669], [-118.84647, 34.15673], [-118.84613, 34.15674], [-118.84609, 34.15669], [-118.84529, 34.15636], [-118.84513, 34.15634], [-118.84475, 34.15615], [-118.84455, 34.15601], [-118.84392, 34.15522], [-118.84377, 34.15509], [-118.84351, 34.15491], [-118.84278, 34.1546], [-118.84282, 34.15435], [-118.84282, 34.15411], [-118.84286, 34.15404], [-118.84303, 34.154], [-118.84331, 34.15383], [-118.84351, 34.15362], [-118.84361, 34.1534], [-118.8436, 34.15311], [-118.84357, 34.15296], [-118.84413, 34.15317], [-118.84731, 34.15444], [-118.84968, 34.15512], [-118.84969, 34.15691]]]} | Open Access 1 | 1427 | Triunfo Park | 7237 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.lamountains.com/parks.asp?parkid=62 | Ventura 8 | 38.958 | Triunfo Park | 0 | Local Park 2 | 4 |
484 | 484 | 483 | {"type": "Polygon", "coordinates": [[[-119.86222, 34.40916], [-119.86222, 34.40971], [-119.86197, 34.40971], [-119.86197, 34.40918], [-119.86222, 34.40916]]]} | Open Access 1 | 1943 | Window to the Sea Park | 27630 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.344 | Window to the Sea 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]);