units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 8,023
- Recreation/Parks District 994
- State Agency 986
- County Agency 973
- Non Profit - Land Trust 500
- Federal Agency 417
- Open Space District 391
- County Agency - Parks 207
- Water District 204
- Home Owners Association 183
- Community Services District 176
- Non Profit - Conservation 132
- Flood District 95
- Non Profit - Other 41
- Irrigation District 38
- School District 35
- Cemetery District 33
- County Agency - Other 27
- Port/Harbor District 26
- Special District - Other 15
- Commercial 14
- Joint Powers Authority 7
- Sanitation District 6
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 412
- Los Angeles, City of 377
- California Department of Fish and Wildlife 375
- California Department of Parks and Recreation 332
- Mountains Recreation and Conservation Authority 319
- San Jose, City of 191
- Sacramento, City of 190
- San Francisco, City and County of 161
- East Bay Regional Park District 157
- Los Angeles, County of 137
- Ventura, City of 131
- Long Beach, City of 122
- Roseville, City of 120
- San Diego, County of 101
- United States Bureau of Land Management 95
- Santa Barbara, County of 94
- Oakland, City of 94
- Consumnes Community Services District 93
- United States Forest Service 87
- Napa, City of 80
- Orange, County of 77
- California State Lands Commission 76
- United States Fish and Wildlife Service 75
- United States National Park Service 72
- Irvine, City of 70
- Hayward Area Recreation and Park District 68
- Valley-Wide Recreation and Park District 64
- Tracy, City of 63
- Poway, City of 61
- Davis, City of 61
- …
DES_TP >30
- Local Park 6,943
- Local Recreation Area 1,704
- Local Other or Unknown 1,140
- Private Conservation 523
- Local Conservation Area 418
- State Conservation Area 339
- Private Recreation or Education 237
- State Park 182
- State Resource Management Area 128
- State Recreation Area 124
- National Forest 74
- Local Historic or Cultural Area 70
- National Wildlife Refuge 68
- State Other or Unknown 66
- State Historic or Cultural Area 58
- National Public Lands 53
- Recreation Management Area 51
- Private Other or Unknown 51
- National Monument or Landmark 36
- National Recreation Area 34
- National Park 22
- Local Resource Management Area 20
- Resource Management Area 18
- Federal Other or Unknown 18
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 11,322
- Restricted Access 1,051
- No Public Access 824
- Unknown Access 359
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3513 | 3513 | 3512 | {"type": "Polygon", "coordinates": [[[-117.81397, 33.68873], [-117.81343, 33.68929], [-117.81316, 33.68912], [-117.81251, 33.68866], [-117.81295, 33.68837], [-117.81303, 33.68829], [-117.81307, 33.68822], [-117.81318, 33.68818], [-117.81397, 33.68873]]]} | Restricted Access 2 | 36118 | Santa Clara Park | 32396 | 6018 | Paseo Westpark Maintenance Association 653 | Private 7 | Home Owners Association 16 | Private 14 | 6018 | Paseo Westpark Maintenance Association 642 | Private 7 | Home Owners Association 15 | Orange 3 | 2.033 | Santa Clara Park | 0 | Private Recreation or Education 65 | 4 | ||
3514 | 3514 | 3513 | {"type": "Polygon", "coordinates": [[[-120.61439, 35.11511], [-120.61433, 35.11594], [-120.61209, 35.11583], [-120.61214, 35.115], [-120.61439, 35.11511]]]} | Open Access 1 | 26522 | Mentone Basin Park | 22157 | 1452 | Grover Beach, City of 654 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | San Luis Obispo 1 | 4.654 | Mentone Basin Park | 0 | Local Park 2 | 4 | |
3515 | 3515 | 3514 | {"type": "Polygon", "coordinates": [[[-121.45599, 37.72415], [-121.45592, 37.72421], [-121.45585, 37.7244], [-121.4558, 37.72465], [-121.45552, 37.72465], [-121.45527, 37.72461], [-121.45507, 37.72452], [-121.45491, 37.72438], [-121.45483, 37.72427], [-121.45479, 37.72415], [-121.45513, 37.72411], [-121.45513, 37.72397], [-121.45531, 37.72375], [-121.45558, 37.72365], [-121.45579, 37.72399], [-121.45599, 37.72415]]]} | Open Access 1 | 26546 | Kingsley Chadeayne Park | 20670 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 1.717 | Kingsley Chadeayne Park | 0 | Local Park 2 | 4 | |
3516 | 3516 | 3515 | {"type": "Polygon", "coordinates": [[[-120.57668, 35.12287], [-120.57621, 35.12313], [-120.57614, 35.12305], [-120.57585, 35.1232], [-120.57564, 35.12292], [-120.57639, 35.12251], [-120.57668, 35.12287]]]} | Open Access 1 | 27007 | Rotary Bandstand | 24681 | 1454 | Arroyo Grande, City of 611 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.903 | Rotary Bandstand | None 292 | |||
3517 | 3517 | 3516 | {"type": "Polygon", "coordinates": [[[-122.21848, 37.77884], [-122.21773, 37.77981], [-122.21745, 37.77956], [-122.21813, 37.77872], [-122.21827, 37.77848], [-122.21752, 37.77811], [-122.2176, 37.778], [-122.21846, 37.77842], [-122.21848, 37.77884]]]} | Open Access 1 | 13356 | Cesar Chavez Park | 17097 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.518 | Cesar Chavez Park | 0 | Local Park 2 | 4 | |
3518 | 3518 | 3517 | {"type": "Polygon", "coordinates": [[[-117.13246, 32.57949], [-117.1323, 32.57953], [-117.13216, 32.57961], [-117.13212, 32.57991], [-117.1318, 32.5799], [-117.13181, 32.57892], [-117.13246, 32.57893], [-117.13246, 32.57949]]]} | Open Access 1 | 28044 | Portwood Pier Plaza | 29091 | 1143 | Imperial Beach, City of 630 | City 2 | City Agency 2 | http://www.imperialbeachca.gov/index.asp?Type=B_BASIC&SEC={9F232DF8-5366-4BA2-A4B8-8795196F6D81} | City 2 | 1143 | Imperial Beach, City of 619 | City 2 | City Agency 2 | http://www.imperialbeachca.gov/index.asp?Type=B_BASIC&SEC={B5217DFC-6F0F-43C8-B295-F4B2D4A63F42} | San Diego 4 | 1.353 | Portwood Pier Plaza | 0 | Local Park 2 | 4 |
3519 | 3519 | 3518 | {"type": "Polygon", "coordinates": [[[-119.90601, 36.84991], [-119.90514, 36.85098], [-119.90334, 36.8516], [-119.89998, 36.85175], [-119.8968, 36.85271], [-119.8963, 36.85226], [-119.89313, 36.85186], [-119.89311, 36.85193], [-119.89311, 36.85227], [-119.89279, 36.85211], [-119.8925, 36.852], [-119.89239, 36.85197], [-119.89231, 36.85193], [-119.89166, 36.85179], [-119.89119, 36.85175], [-119.89085, 36.85175], [-119.89017, 36.85181], [-119.88985, 36.85188], [-119.88952, 36.85198], [-119.88916, 36.85211], [-119.88936, 36.85126], [-119.88934, 36.85125], [-119.88939, 36.851], [-119.89048, 36.85117], [-119.89102, 36.85119], [-119.89182, 36.85127], [-119.89197, 36.85126], [-119.89206, 36.8513], [-119.89216, 36.8513], [-119.89237, 36.85134], [-119.8925, 36.85132], [-119.89259, 36.85135], [-119.89281, 36.85138], [-119.893, 36.85138], [-119.8931, 36.85136], [-119.89311, 36.85138], [-119.89352, 36.85142], [-119.8942, 36.85139], [-119.89439, 36.85135], [-119.89457, 36.85124], [-119.89461, 36.85124], [-119.89479, 36.85133], [-119.89495, 36.85136], [-119.89599, 36.85117], [-119.89622, 36.8511], [-119.89647, 36.85107], [-119.89672, 36.851], [-119.8968, 36.85091], [-119.89685, 36.85089], [-119.89709, 36.85087], [-119.89718, 36.85083], [-119.89729, 36.85082], [-119.8974, 36.85077], [-119.89761, 36.85052], [-119.89793, 36.85047], [-119.89817, 36.85016], [-119.89815, 36.85013], [-119.89822, 36.85009], [-119.89888, 36.84987], [-119.89952, 36.84974], [-119.89995, 36.84962], [-119.90022, 36.84965], [-119.90068, 36.84957], [-119.90181, 36.84954], [-119.90254, 36.84948], [-119.90325, 36.84925], [-119.90334, 36.84931], [-119.90346, 36.84927], [-119.90349, 36.84934], [-119.90349, 36.8494], [-119.90346, 36.84947], [-119.90341, 36.84952], [-119.9029, 36.84981], [-119.90261, 36.84989], [-119.90094, 36.85005], [-119.90107, 36.85103], [-119.90151, 36.85099], [-119.90155, 36.85107], [-119.9025, 36.85122], [-119.90255, 36.85131], [-119.90264, 36.85128], [-119.90258, 36.85115], [-119.9016, 36.851], [-119.90159, 36.85098], [-119.90337, 36.85082], [-119.90449, 36.85024], [-119.90397, 36.84955], [-119.90351, 36.84925], [-119.90358, 36.84923], [-119.90444, 36.84977], [-119.90533, 36.84896], [-119.90567, 36.84919], [-119.90538, 36.8495], [-119.90601, 36.84991]]]} | Open Access 1 | 28049 | Riverbottom Park | 24437 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 49.154 | Riverbottom Park | 0 | Local Park 2 | 4 | |
3520 | 3520 | 3519 | {"type": "Polygon", "coordinates": [[[-119.90449, 36.85024], [-119.90337, 36.85082], [-119.90162, 36.85099], [-119.90163, 36.851], [-119.90259, 36.85115], [-119.90265, 36.85128], [-119.90254, 36.85131], [-119.9025, 36.85122], [-119.90154, 36.85107], [-119.9015, 36.85099], [-119.90107, 36.85103], [-119.90094, 36.85005], [-119.90261, 36.84989], [-119.9029, 36.84981], [-119.90342, 36.84952], [-119.90346, 36.84947], [-119.90349, 36.8494], [-119.90349, 36.84934], [-119.90346, 36.84927], [-119.90351, 36.84925], [-119.90397, 36.84955], [-119.90449, 36.85024]]]} | Open Access 1 | 28050 | Riverbottom Park | 24437 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.705 | Riverbottom Park | 0 | Local Park 2 | 4 | |
3521 | 3521 | 3520 | {"type": "Polygon", "coordinates": [[[-118.0817, 33.93339], [-118.08089, 33.93344], [-118.08095, 33.93408], [-118.07831, 33.93411], [-118.07833, 33.93206], [-118.07991, 33.93211], [-118.07994, 33.93174], [-118.08167, 33.93176], [-118.0817, 33.93339]]]} | Open Access 1 | 20591 | Little Lake Park | 21340 | 1321 | Santa Fe Springs, City of 211 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | Los Angeles 6 | 17.276 | Little Lake Park | 0 | Local Park 2 | 4 | |
3522 | 3522 | 3521 | {"type": "Polygon", "coordinates": [[[-118.09829, 33.94428], [-118.09786, 33.94516], [-118.0975, 33.94572], [-118.09717, 33.94613], [-118.09512, 33.94844], [-118.09473, 33.94823], [-118.0948, 33.94767], [-118.09495, 33.94767], [-118.09506, 33.94753], [-118.0952, 33.94704], [-118.0954, 33.9468], [-118.0958, 33.9464], [-118.09599, 33.9463], [-118.09632, 33.94631], [-118.09648, 33.94614], [-118.0977, 33.94373], [-118.09809, 33.94399], [-118.09829, 33.94428]]]} | Open Access 1 | 20592 | Santa Fe Springs Park | 29827 | 1321 | Santa Fe Springs, City of 211 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/city_parks/santa_fe_springs_park.asp | Los Angeles 6 | 9.909 | Santa Fe Springs Park | 0 | Local Park 2 | 4 |
3523 | 3523 | 3522 | {"type": "Polygon", "coordinates": [[[-118.08269, 33.95288], [-118.08201, 33.9526], [-118.08206, 33.95251], [-118.08205, 33.9525], [-118.08129, 33.95222], [-118.08207, 33.95074], [-118.0821, 33.95072], [-118.08351, 33.9512], [-118.08354, 33.95123], [-118.08269, 33.95288]]]} | Open Access 1 | 20593 | Santa Fe Springs Athletic Fields | 25089 | 1321 | Santa Fe Springs, City of 211 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | Los Angeles 6 | 6.926 | Santa Fe Springs Athletic Fields | 0 | Local Recreation Area 3 | 4 | |
3524 | 3524 | 3523 | {"type": "Polygon", "coordinates": [[[-118.06897, 33.81678], [-118.06835, 33.81747], [-118.06758, 33.81747], [-118.06842, 33.81706], [-118.06897, 33.81678]]]} | Open Access 1 | 20594 | Stansbury Park | 25791 | 1185 | Los Alamitos, City of 295 | City 2 | City Agency 2 | http://cityoflosalamitos.org/ | City 2 | 1185 | Los Alamitos, City of 291 | City 2 | City Agency 2 | Orange 3 | 0.677 | Stansbury Park | 0 | Local Park 2 | 4 | |
3525 | 3525 | 3524 | {"type": "Polygon", "coordinates": [[[-118.1436, 33.87107], [-118.14301, 33.87107], [-118.14301, 33.87037], [-118.14299, 33.87036], [-118.14299, 33.86965], [-118.1436, 33.86965], [-118.1436, 33.87107]]]} | Open Access 1 | 20595 | Constitution Park | 17598 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 2.156 | Constitution Park | 0 | Local Park 2 | 4 | |
3526 | 3526 | 3525 | {"type": "Polygon", "coordinates": [[[-118.11099, 33.9097], [-118.1104, 33.90972], [-118.10973, 33.90773], [-118.11031, 33.90763], [-118.11099, 33.9097]]]} | Open Access 1 | 20596 | H. Byrum Zinn Community Park and Trail | 29571 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 3.096 | H. Byrum Zinn Community Park and Trail | 0 | Local Recreation Area 3 | 4 | |
3527 | 3527 | 3526 | {"type": "Polygon", "coordinates": [[[-121.34589, 38.0487], [-121.34578, 38.04902], [-121.3457, 38.04939], [-121.34566, 38.04976], [-121.34565, 38.0503], [-121.34558, 38.05035], [-121.3447, 38.05035], [-121.34443, 38.05038], [-121.34418, 38.05044], [-121.34393, 38.05052], [-121.34367, 38.05063], [-121.3434, 38.0508], [-121.34319, 38.05098], [-121.34309, 38.051], [-121.34245, 38.05072], [-121.34236, 38.0507], [-121.34188, 38.05044], [-121.34185, 38.05006], [-121.34456, 38.05007], [-121.34459, 38.04833], [-121.34587, 38.04866], [-121.34589, 38.0487]]]} | Open Access 1 | 28069 | Baxter Park | 15869 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 9.101 | Baxter Park | 0 | Local Park 2 | 4 | |
3528 | 3528 | 3527 | {"type": "Polygon", "coordinates": [[[-120.73191, 40.62673], [-120.72607, 40.62669], [-120.72666, 40.62644], [-120.72861, 40.62224], [-120.72666, 40.62227], [-120.72674, 40.61939], [-120.72188, 40.61937], [-120.72192, 40.61796], [-120.72202, 40.61567], [-120.72661, 40.61542], [-120.72693, 40.61539], [-120.72841, 40.61537], [-120.73165, 40.6202], [-120.7318, 40.62318], [-120.73191, 40.62673]]]} | Restricted Access 2 | 28071 | Eagle Lake Field Station | 18339 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Lassen 54 | 147.826 | Eagle Lake Field Station | None 293 | |||
3529 | 3529 | 3528 | {"type": "Polygon", "coordinates": [[[-121.29482, 38.10429], [-121.29393, 38.10425], [-121.29392, 38.103], [-121.2948, 38.10303], [-121.29482, 38.10429]]]} | Open Access 1 | 28074 | Century Meadows Park | 17075 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 2.673 | Century Meadows Park | 0 | Local Park 2 | 4 | |
3530 | 3530 | 3529 | {"type": "Polygon", "coordinates": [[[-122.3149, 38.33891], [-122.31472, 38.33897], [-122.31412, 38.33907], [-122.31397, 38.33883], [-122.31467, 38.3386], [-122.3149, 38.33891]]]} | Open Access 1 | 36316 | North Jefferson Park | 28695 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.602 | North Jefferson Park | 0 | Local Park 2 | 4 | |
3531 | 3531 | 3530 | {"type": "Polygon", "coordinates": [[[-121.86672, 37.99639], [-121.86672, 37.99787], [-121.86396, 37.99786], [-121.86392, 37.99781], [-121.86392, 37.99762], [-121.86388, 37.99743], [-121.86358, 37.99675], [-121.86354, 37.99658], [-121.86354, 37.99646], [-121.86356, 37.99643], [-121.8636, 37.99641], [-121.86614, 37.99642], [-121.86672, 37.99639]]]} | Open Access 1 | 28082 | Highlands Ranch Park | 19948 | 1254 | Pittsburg, City of 384 | City 2 | City Agency 2 | http://www.ci.pittsburg.ca.us/index.aspx?page=238 | City 2 | 1254 | Pittsburg, City of 380 | City 2 | City Agency 2 | Contra Costa 12 | 10.405 | Highlands Ranch Park | 0 | Local Park 2 | 4 | |
3532 | 3532 | 3531 | {"type": "Polygon", "coordinates": [[[-121.09561, 38.95939], [-121.0956, 38.96022], [-121.09452, 38.96022], [-121.09452, 38.95938], [-121.09561, 38.95939]]]} | Open Access 1 | 28095 | North Park | 22839 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 2.141 | North 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]);