units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by DES_TP
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 10,026
- County Agency 1,176
- Recreation/Parks District 1,142
- State Agency 1,141
- Non Profit - Land Trust 601
- Federal Agency 442
- Open Space District 423
- Water District 238
- County Agency - Parks 232
- Home Owners Association 203
- Community Services District 198
- Non Profit - Conservation 148
- Flood District 106
- Cemetery District 61
- Irrigation District 50
- Non Profit - Other 45
- School District 38
- County Agency - Other 35
- Port/Harbor District 32
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- 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 491
- Los Angeles, City of 469
- California Department of Fish and Wildlife 443
- California Department of Parks and Recreation 380
- Mountains Recreation and Conservation Authority 347
- San Jose, City of 244
- San Francisco, City and County of 235
- Sacramento, City of 220
- Los Angeles, County of 170
- East Bay Regional Park District 167
- Ventura, City of 148
- Long Beach, City of 148
- Roseville, City of 130
- Oakland, City of 120
- San Diego, County of 116
- Santa Barbara, County of 111
- United States Forest Service 111
- Irvine, City of 101
- Consumnes Community Services District 94
- Orange, County of 92
- United States National Park Service 89
- California State Lands Commission 86
- Modesto, City of 85
- Hayward Area Recreation and Park District 83
- United States Fish and Wildlife Service 82
- Stockton, City of 81
- Napa, City of 81
- Santa Rosa, City of 79
- Torrance, City of 73
- Tracy, City of 73
- …
DES_TP >30
- Local Park 8,802
- Local Recreation Area 1,989
- Local Other or Unknown 1,190
- Private Conservation 629
- Local Conservation Area 485
- State Conservation Area 381
- Private Recreation or Education 268
- State Park 208
- State Resource Management Area 159
- State Recreation Area 145
- Local Historic or Cultural Area 116
- National Forest 99
- National Wildlife Refuge 75
- State Other or Unknown 70
- State Historic or Cultural Area 63
- Recreation Management Area 61
- Private Other or Unknown 51
- National Recreation Area 40
- National Monument or Landmark 39
- National Park 26
- Resource Management Area 26
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 14
- Private Agricultural 12
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- Research or Educational Area 3
- …
AGNCY_LEV 8 ✖
- City 9,899
- Special District 2,352
- County 1,407
- State 1,197
- Non Profit 781
- Federal 509
- Private 266
- Joint 8
ACCESS_TYP 4
- Open Access 13,874
- Restricted Access 1,192
- No Public Access 967
- Unknown Access 386
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
784 | 784 | 783 | {"type": "Polygon", "coordinates": [[[-118.21821, 33.92641], [-118.21814, 33.92658], [-118.21803, 33.9267], [-118.21792, 33.92676], [-118.21782, 33.92679], [-118.21769, 33.9268], [-118.21748, 33.92674], [-118.21735, 33.92666], [-118.21728, 33.92658], [-118.21725, 33.92649], [-118.21723, 33.92634], [-118.21725, 33.92626], [-118.21732, 33.92615], [-118.21742, 33.92606], [-118.2175, 33.92602], [-118.21764, 33.92599], [-118.21779, 33.92598], [-118.21799, 33.92605], [-118.21812, 33.92615], [-118.21819, 33.9263], [-118.21821, 33.92641]]]} | Open Access 1 | 5772 | Rose Park | 24613 | 1191 | Lynwood, City of 258 | City 2 | City Agency 2 | http://www.lynwood.ca.us/ | City 2 | 1191 | Lynwood, City of 254 | City 2 | City Agency 2 | Los Angeles 6 | 1.562 | Rose Park | 0 | Local Park 2 | 4 | |
786 | 786 | 785 | {"type": "Polygon", "coordinates": [[[-122.10174, 37.85993], [-122.10174, 37.86191], [-122.10034, 37.86391], [-122.09999, 37.86392], [-122.09965, 37.86438], [-122.09912, 37.86403], [-122.09873, 37.86468], [-122.09828, 37.8651], [-122.09781, 37.86516], [-122.09794, 37.8657], [-122.09807, 37.86602], [-122.0979, 37.86635], [-122.09797, 37.86662], [-122.09815, 37.8669], [-122.09776, 37.86746], [-122.09806, 37.86777], [-122.09807, 37.86819], [-122.09803, 37.86883], [-122.09759, 37.86962], [-122.09705, 37.86926], [-122.09627, 37.8684], [-122.0955, 37.86773], [-122.09513, 37.86732], [-122.09484, 37.86714], [-122.09459, 37.86673], [-122.0961, 37.86643], [-122.09667, 37.86596], [-122.09734, 37.86507], [-122.09768, 37.86456], [-122.09766, 37.86387], [-122.09799, 37.86358], [-122.09332, 37.86072], [-122.09488, 37.86046], [-122.09586, 37.86008], [-122.09628, 37.86048], [-122.09757, 37.86078], [-122.09879, 37.86062], [-122.10029, 37.86018], [-122.10174, 37.85993]]]} | Open Access 1 | 5101 | Lafayette Community Park | 20830 | 1163 | Lafayette, City of 236 | City 2 | City Agency 2 | http://www.ci.lafayette.ca.us/index.aspx?page=87 | City 2 | 1163 | Lafayette, City of 232 | City 2 | City Agency 2 | Contra Costa 12 | 70.977 | Lafayette Community Park | 1973 | Local Park 2 | 4 | |
787 | 787 | 786 | {"type": "Polygon", "coordinates": [[[-118.03115, 33.70861], [-118.03105, 33.70865], [-118.03101, 33.70868], [-118.03099, 33.70875], [-118.031, 33.7088], [-118.03105, 33.70887], [-118.03106, 33.70892], [-118.03108, 33.71], [-118.03053, 33.71023], [-118.03055, 33.71007], [-118.03063, 33.71005], [-118.03064, 33.70998], [-118.03061, 33.70997], [-118.03061, 33.70937], [-118.02998, 33.70937], [-118.03022, 33.70912], [-118.03041, 33.70888], [-118.03046, 33.70877], [-118.03048, 33.70864], [-118.03046, 33.70855], [-118.0304, 33.70847], [-118.03033, 33.70841], [-118.03032, 33.70837], [-118.03115, 33.70837], [-118.03115, 33.70861]]]} | Open Access 1 | 5126 | Marine View Park | 21850 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.794 | Marine View Park | 0 | Local Park 2 | 4 | |
788 | 788 | 787 | {"type": "Polygon", "coordinates": [[[-118.14681, 34.71504], [-118.14676, 34.71507], [-118.14445, 34.71507], [-118.14442, 34.71506], [-118.14441, 34.71504], [-118.14438, 34.71315], [-118.14442, 34.71313], [-118.14673, 34.71313], [-118.14676, 34.71314], [-118.14678, 34.71316], [-118.14681, 34.71504]]]} | Open Access 1 | 5130 | Mariposa Park | 21867 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | Los Angeles 6 | 11.692 | Mariposa Park | 0 | Local Park 2 | 4 | |
789 | 789 | 788 | {"type": "Polygon", "coordinates": [[[-117.72013, 34.10336], [-117.71855, 34.10336], [-117.71855, 34.10171], [-117.72012, 34.10172], [-117.72013, 34.10336]]]} | Open Access 1 | 5280 | Memorial Park | 22124 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | Los Angeles 6 | 6.563 | Memorial Park | 0 | Local Park 2 | 4 | |
790 | 790 | 789 | {"type": "Polygon", "coordinates": [[[-117.34745, 33.23316], [-117.34696, 33.23302], [-117.34672, 33.23298], [-117.34621, 33.23294], [-117.34596, 33.23294], [-117.34546, 33.23299], [-117.34496, 33.2331], [-117.34461, 33.2331], [-117.34461, 33.23301], [-117.34463, 33.23293], [-117.3447, 33.23278], [-117.34516, 33.23227], [-117.34534, 33.23204], [-117.34538, 33.23202], [-117.34544, 33.23201], [-117.34575, 33.23212], [-117.34589, 33.23215], [-117.34615, 33.23218], [-117.34697, 33.23217], [-117.34712, 33.23219], [-117.34727, 33.23226], [-117.34736, 33.23232], [-117.34747, 33.23243], [-117.34755, 33.23253], [-117.34759, 33.23266], [-117.3476, 33.23276], [-117.34758, 33.2329], [-117.34745, 33.23316]]]} | Open Access 1 | 5134 | Marlado Highlands Park | 21877 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#11 | San Diego 4 | 5.8 | Marlado Highlands Park | 0 | Local Park 2 | 4 |
791 | 791 | 790 | {"type": "Polygon", "coordinates": [[[-118.30835, 34.01371], [-118.30834, 34.014], [-118.30815, 34.014], [-118.30813, 34.0142], [-118.30731, 34.0142], [-118.30731, 34.01294], [-118.30773, 34.01293], [-118.30779, 34.01291], [-118.30789, 34.01283], [-118.3079, 34.01358], [-118.30812, 34.01359], [-118.30813, 34.01373], [-118.30835, 34.01371]]]} | Open Access 1 | 5154 | Martin Luther King Jr Park | 21907 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.407 | Martin Luther King Jr Park | 0 | Local Park 2 | 4 | |
792 | 792 | 791 | {"type": "Polygon", "coordinates": [[[-118.57969, 34.26206], [-118.57967, 34.2621], [-118.57963, 34.26211], [-118.57724, 34.26212], [-118.57721, 34.2621], [-118.5772, 34.26208], [-118.5772, 34.25943], [-118.57721, 34.25941], [-118.57725, 34.25939], [-118.57962, 34.25939], [-118.57967, 34.25942], [-118.57969, 34.26206]]]} | Open Access 1 | 5161 | Mason Park | 21943 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 17.038 | Mason Park | 0 | Local Park 2 | 4 | |
793 | 793 | 792 | {"type": "Polygon", "coordinates": [[[-118.43173, 33.99148], [-118.43157, 33.99155], [-118.43154, 33.99132], [-118.43173, 33.99148], [-118.43173, 33.99148]]]} | Open Access 1 | 5165 | Maxella Parkette | 21967 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 0.051 | Maxella Parkette | 0 | Local Park 2 | 4 | |
794 | 794 | 793 | {"type": "Polygon", "coordinates": [[[-117.98034, 33.82842], [-117.97815, 33.82845], [-117.97813, 33.82675], [-117.9773, 33.82676], [-117.97729, 33.82592], [-117.97784, 33.8259], [-117.97784, 33.82578], [-117.97812, 33.82576], [-117.97812, 33.8256], [-117.97826, 33.82558], [-117.97827, 33.82525], [-117.97837, 33.82523], [-117.97838, 33.825], [-117.97961, 33.82499], [-117.97962, 33.82579], [-117.9803, 33.82579], [-117.98034, 33.82842]]]} | Open Access 1 | 5169 | Maxwell Park | 21970 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 19.293 | Maxwell Park | 0 | Local Park 2 | 4 | |
795 | 795 | 794 | {"type": "Polygon", "coordinates": [[[-117.194, 32.68587], [-117.19286, 32.68822], [-117.19121, 32.68742], [-117.18933, 32.6866], [-117.1878, 32.6859], [-117.18651, 32.68525], [-117.18315, 32.68347], [-117.18134, 32.68242], [-117.18077, 32.68205], [-117.17992, 32.68109], [-117.17994, 32.68096], [-117.17953, 32.68063], [-117.1795, 32.68048], [-117.17852, 32.67943], [-117.17847, 32.67918], [-117.17835, 32.67906], [-117.17705, 32.67807], [-117.17716, 32.67788], [-117.1774, 32.67761], [-117.17915, 32.6786], [-117.17944, 32.67858], [-117.17981, 32.67865], [-117.17996, 32.67876], [-117.17995, 32.67901], [-117.17997, 32.67914], [-117.1801, 32.67932], [-117.18114, 32.68008], [-117.18325, 32.6813], [-117.18576, 32.68281], [-117.18725, 32.68359], [-117.18844, 32.68415], [-117.18948, 32.68459], [-117.19056, 32.68496], [-117.19281, 32.68559], [-117.194, 32.68587]]]} | Open Access 1 | 5171 | Coronado Municipal Beach | 17648 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.sandiego.com/beaches/coronado-beach | San Diego 4 | 84.62 | Coronado Municipal Beach | 0 | Local Park 2 | 4 |
796 | 796 | 795 | {"type": "Polygon", "coordinates": [[[-118.13366, 33.86003], [-118.13175, 33.86004], [-118.13173, 33.85681], [-118.13235, 33.8568], [-118.13234, 33.85625], [-118.13363, 33.85625], [-118.13366, 33.86003]]]} | Open Access 1 | 5174 | Mayfair Park | 21972 | 1168 | Lakewood, City of 259 | City 2 | City Agency 2 | http://www.lakewoodcity.org/ | City 2 | 1168 | Lakewood, City of 255 | City 2 | City Agency 2 | Los Angeles 6 | 17.432 | Mayfair Park | 0 | Local Park 2 | 4 | |
797 | 797 | 796 | {"type": "Polygon", "coordinates": [[[-118.17818, 33.98838], [-118.17816, 33.98843], [-118.17809, 33.98843], [-118.17808, 33.98845], [-118.17767, 33.98873], [-118.17642, 33.98745], [-118.17645, 33.98726], [-118.178, 33.98742], [-118.17797, 33.9877], [-118.17784, 33.98769], [-118.17774, 33.98834], [-118.17792, 33.9885], [-118.17812, 33.98837], [-118.17818, 33.98838]]]} | Open Access 1 | 5176 | Maywood Park | 21982 | 1200 | Maywood, City of 260 | City 2 | City Agency 2 | http://www.cityofmaywood.com/index.php?option=com_content&view=article&id=162&Itemid=69 | City 2 | 1200 | Maywood, City of 256 | City 2 | City Agency 2 | Los Angeles 6 | 3.053 | Maywood Park | 0 | Local Park 2 | 4 | |
798 | 798 | 797 | {"type": "Polygon", "coordinates": [[[-118.05437, 33.82517], [-118.0527, 33.82519], [-118.05268, 33.82431], [-118.05431, 33.82429], [-118.05436, 33.82434], [-118.05437, 33.82517]]]} | Open Access 1 | 5837 | Willow Park | 27583 | 1077 | Cypress, City of 218 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | Orange 3 | 3.722 | Willow Park | 0 | Local Park 2 | 4 | |
800 | 800 | 799 | {"type": "Polygon", "coordinates": [[[-116.73692, 33.70731], [-116.73692, 33.70798], [-116.73675, 33.71539], [-116.73248, 33.71537], [-116.73258, 33.70742], [-116.73272, 33.70733], [-116.73692, 33.70731]]]} | Open Access 1 | 5190 | McCall Memorial Park | 21990 | 2123 | Riverside County Regional Park and Open Space District 262 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 88.363 | McCall Memorial Park | 0 | Local Park 2 | 4 | |
802 | 802 | 801 | {"type": "Polygon", "coordinates": [[[-117.15085, 33.41386], [-117.14988, 33.41386], [-117.14987, 33.41211], [-117.15083, 33.4121], [-117.15085, 33.41386]]]} | Open Access 1 | 5212 | Rainbow Park | 24087 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Rainbow.html | San Diego 4 | 4.328 | Rainbow Park | 0 | Local Park 2 | 4 |
803 | 803 | 802 | {"type": "Polygon", "coordinates": [[[-115.54406, 32.79085], [-115.54196, 32.79085], [-115.54196, 32.78986], [-115.54406, 32.78986], [-115.54406, 32.79085]]]} | Open Access 1 | 5217 | McGee Park | 22034 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 5.333 | McGee Park | 0 | Local Park 2 | 4 | |
804 | 804 | 803 | {"type": "Polygon", "coordinates": [[[-119.61346, 36.56549], [-119.61318, 36.56569], [-119.61257, 36.56512], [-119.61285, 36.56492], [-119.61346, 36.56549]]]} | Open Access 1 | 5221 | Berry Park | 16033 | 1332 | Selma, City of 264 | City 2 | City Agency 2 | http://www.cityofselma.com/recreate/parks.htm | City 2 | 1332 | Selma, City of 260 | City 2 | City Agency 2 | Fresno 9 | 0.702 | Berry Park | 0 | Local Park 2 | 4 | |
805 | 805 | 804 | {"type": "Polygon", "coordinates": [[[-117.32007, 34.15316], [-117.31993, 34.15321], [-117.31979, 34.15329], [-117.31965, 34.15339], [-117.31954, 34.15352], [-117.31942, 34.15373], [-117.31939, 34.15388], [-117.31937, 34.154], [-117.31897, 34.15399], [-117.31873, 34.15401], [-117.3181, 34.1541], [-117.31786, 34.15409], [-117.31762, 34.15403], [-117.31747, 34.15396], [-117.31733, 34.15387], [-117.31717, 34.15371], [-117.31652, 34.15403], [-117.31592, 34.1532], [-117.31556, 34.15241], [-117.31557, 34.15019], [-117.31656, 34.15019], [-117.31656, 34.14974], [-117.31821, 34.14974], [-117.31822, 34.15004], [-117.31825, 34.1503], [-117.31854, 34.15205], [-117.31961, 34.15189], [-117.31972, 34.15233], [-117.31988, 34.15275], [-117.32007, 34.15316]]]} | Open Access 1 | 5222 | Blair Park | 16150 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 34.037 | Blair Park | 0 | Local Park 2 | 4 | |
810 | 810 | 809 | {"type": "Polygon", "coordinates": [[[-117.67105, 34.02566], [-117.67042, 34.02566], [-117.67041, 34.02571], [-117.66987, 34.02571], [-117.66987, 34.02507], [-117.66984, 34.02493], [-117.66978, 34.02474], [-117.66977, 34.02461], [-117.67105, 34.0246], [-117.67105, 34.02566]]]} | Open Access 1 | 5230 | Bob B. McLeod Park | 31074 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/bob-b-mcleod-park | San Bernardino 22 | 3.292 | Bob B. McLeod 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]);