units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 10,059
- County Agency 1,168
- Recreation/Parks District 1,138
- State Agency 1,126
- Non Profit - Land Trust 583
- Federal Agency 507
- Open Space District 423
- Water District 237
- County Agency - Parks 233
- Home Owners Association 202
- Community Services District 198
- Non Profit - Conservation 147
- Flood District 105
- Irrigation District 50
- Cemetery District 48
- Non Profit - Other 45
- School District 38
- Port/Harbor District 33
- County Agency - Other 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 486
- Los Angeles, City of 471
- California Department of Fish and Wildlife 436
- California Department of Parks and Recreation 380
- Mountains Recreation and Conservation Authority 347
- San Jose, City of 240
- San Francisco, City and County of 236
- Sacramento, City of 220
- Los Angeles, County of 170
- East Bay Regional Park District 165
- Long Beach, City of 148
- Ventura, City of 145
- Roseville, City of 130
- Oakland, City of 120
- San Diego, County of 120
- United States Bureau of Land Management 117
- United States Forest Service 110
- Santa Barbara, County of 109
- Irvine, City of 101
- Consumnes Community Services District 94
- United States National Park Service 87
- Orange, County of 87
- Modesto, City of 85
- Hayward Area Recreation and Park District 84
- California State Lands Commission 83
- United States Fish and Wildlife Service 82
- Stockton, City of 81
- Napa, City of 81
- Santa Rosa, City of 79
- Huntington Beach, City of 73
- …
DES_TP >30
- Local Park 8,920
- Local Recreation Area 1,946
- Local Other or Unknown 1,177
- Private Conservation 610
- Local Conservation Area 476
- State Conservation Area 377
- Private Recreation or Education 267
- State Park 208
- State Resource Management Area 158
- State Recreation Area 143
- Local Historic or Cultural Area 99
- National Forest 98
- National Wildlife Refuge 75
- National Public Lands 72
- State Other or Unknown 70
- State Historic or Cultural Area 63
- Recreation Management Area 60
- Private Other or Unknown 51
- National Monument or Landmark 39
- National Recreation Area 38
- National Park 26
- Resource Management Area 26
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 14
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 6
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 13,942
- Restricted Access 1,178
- No Public Access 954
- Unknown Access 380
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
731 | 731 | 730 | {"type": "Polygon", "coordinates": [[[-117.67158, 33.93436], [-117.67145, 33.93446], [-117.67128, 33.93452], [-117.67111, 33.93454], [-117.67088, 33.9345], [-117.67099, 33.93433], [-117.66977, 33.93373], [-117.66924, 33.93354], [-117.66901, 33.93344], [-117.6685, 33.9331], [-117.66796, 33.93279], [-117.66758, 33.93247], [-117.66707, 33.93212], [-117.66681, 33.93198], [-117.66665, 33.93192], [-117.66633, 33.93186], [-117.66334, 33.93185], [-117.66334, 33.93144], [-117.66617, 33.93145], [-117.66637, 33.93126], [-117.66814, 33.9325], [-117.66858, 33.93279], [-117.66919, 33.93312], [-117.67155, 33.93429], [-117.67158, 33.93432], [-117.67158, 33.93436]]]} | Open Access 1 | 4742 | Meadows Park | 22096 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 8.121 | Meadows Park | 0 | Local Park 2 | 4 | |
732 | 732 | 731 | {"type": "Polygon", "coordinates": [[[-117.73548, 33.96926], [-117.73534, 33.96932], [-117.73492, 33.96967], [-117.73479, 33.96981], [-117.73471, 33.96993], [-117.73464, 33.97009], [-117.73461, 33.97027], [-117.73461, 33.97041], [-117.73464, 33.97058], [-117.73467, 33.97066], [-117.73473, 33.97071], [-117.73486, 33.97073], [-117.73496, 33.9707], [-117.73497, 33.97073], [-117.73465, 33.97086], [-117.7346, 33.97084], [-117.73376, 33.96937], [-117.7336, 33.96922], [-117.73359, 33.96916], [-117.73368, 33.969], [-117.73372, 33.96887], [-117.73375, 33.96888], [-117.7338, 33.96897], [-117.73412, 33.96907], [-117.73414, 33.96905], [-117.73439, 33.96914], [-117.73501, 33.96925], [-117.73512, 33.96925], [-117.73547, 33.96921], [-117.73548, 33.96926]]]} | Open Access 1 | 4749 | Valle Vista Park | 26772 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 3.295 | Valle Vista Park | 0 | Local Park 2 | 4 | |
733 | 733 | 732 | {"type": "Polygon", "coordinates": [[[-117.71808, 33.97952], [-117.71777, 33.9796], [-117.71778, 33.9808], [-117.71766, 33.98078], [-117.7175, 33.98069], [-117.71737, 33.98058], [-117.71712, 33.98077], [-117.71706, 33.9807], [-117.71731, 33.98053], [-117.71721, 33.98041], [-117.71713, 33.98027], [-117.71707, 33.98012], [-117.71704, 33.97997], [-117.71703, 33.97946], [-117.7167, 33.97946], [-117.7167, 33.97898], [-117.71674, 33.97883], [-117.7168, 33.97872], [-117.71684, 33.9787], [-117.71688, 33.9787], [-117.7172, 33.97887], [-117.71703, 33.97909], [-117.71703, 33.97911], [-117.71767, 33.97946], [-117.7179, 33.97927], [-117.71801, 33.97938], [-117.71808, 33.97952]]]} | Open Access 1 | 4750 | Glenmeade Park | 19332 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 3.203 | Glenmeade Park | 0 | Local Park 2 | 4 | |
734 | 734 | 733 | {"type": "Polygon", "coordinates": [[[-117.21085, 34.04651], [-117.20865, 34.04651], [-117.20865, 34.04481], [-117.21084, 34.04481], [-117.21085, 34.0455], [-117.21085, 34.04651]]]} | Open Access 1 | 5512 | Brookside Park | 16432 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 9.471 | Brookside Park | 0 | Local Park 2 | 4 | |
735 | 735 | 734 | {"type": "Polygon", "coordinates": [[[-122.42952, 37.73851], [-122.42949, 37.73855], [-122.4295, 37.73861], [-122.42928, 37.73867], [-122.42929, 37.73892], [-122.4288, 37.73859], [-122.4288, 37.73837], [-122.42926, 37.73806], [-122.42927, 37.73835], [-122.42952, 37.73851]]]} | Open Access 1 | 5513 | Fairmount Plaza | 18812 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.742 | Fairmount Plaza | 0 | Local Park 2 | 4 | |
736 | 736 | 735 | {"type": "Polygon", "coordinates": [[[-117.96468, 34.0876], [-117.96463, 34.08765], [-117.96323, 34.08766], [-117.96322, 34.08773], [-117.96265, 34.08773], [-117.96265, 34.08752], [-117.96257, 34.08749], [-117.96255, 34.08746], [-117.96249, 34.08747], [-117.9625, 34.08767], [-117.96159, 34.08768], [-117.96158, 34.08705], [-117.9623, 34.08688], [-117.96253, 34.08686], [-117.96261, 34.08682], [-117.96263, 34.0868], [-117.96263, 34.08668], [-117.96254, 34.08639], [-117.96457, 34.08592], [-117.96465, 34.08597], [-117.96468, 34.0876]]]} | Open Access 1 | 5514 | Morgan Park | 22484 | 1020 | Baldwin Park, City of 247 | City 2 | City Agency 2 | http://www.baldwinpark.com/ | City 2 | 1020 | Baldwin Park, City of 243 | City 2 | City Agency 2 | Los Angeles 6 | 9.842 | Morgan Park | 0 | Local Park 2 | 4 | |
737 | 737 | 736 | {"type": "Polygon", "coordinates": [[[-118.50977, 34.20099], [-118.50767, 34.20099], [-118.50767, 34.19973], [-118.50918, 34.19972], [-118.5092, 34.19979], [-118.50938, 34.19979], [-118.50938, 34.19974], [-118.50977, 34.19974], [-118.50977, 34.20099]]]} | Open Access 1 | 4829 | Louise Park | 21550 | 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 | 6.663 | Louise Park | 0 | Local Park 2 | 4 | |
740 | 740 | 739 | {"type": "MultiPolygon", "coordinates": [[[[-122.43261, 37.73842], [-122.43248, 37.73852], [-122.4324, 37.73848], [-122.43211, 37.73825], [-122.432, 37.7382], [-122.43185, 37.73817], [-122.43168, 37.73818], [-122.43124, 37.7383], [-122.43104, 37.73798], [-122.43159, 37.73777], [-122.43195, 37.73779], [-122.43261, 37.73842]]], [[[-122.43549, 37.74395], [-122.43519, 37.74397], [-122.43518, 37.7439], [-122.435, 37.74391], [-122.43495, 37.74329], [-122.43544, 37.74326], [-122.43547, 37.74327], [-122.43549, 37.74395]]]]} | Open Access 1 | 5519 | Diamond Hights Lot3 | 18142 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.023 | Diamond Hights Lot3 | 0 | Local Other or Unknown 14 | 4 | |
741 | 741 | 740 | {"type": "Polygon", "coordinates": [[[-119.09273, 35.41839], [-119.09269, 35.4184], [-119.0927, 35.41955], [-119.0925, 35.41955], [-119.09243, 35.41949], [-119.09241, 35.41509], [-119.09269, 35.41509], [-119.09269, 35.41693], [-119.09273, 35.41694], [-119.09273, 35.41839]]]} | Open Access 1 | 47535 | Coffee Road Dog Park | 31240 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 3.164 | Coffee Road Dog Park | 0 | Local Park 2 | 4 | |
743 | 743 | 742 | {"type": "Polygon", "coordinates": [[[-122.17782, 37.45219], [-122.17654, 37.45387], [-122.1743, 37.4528], [-122.17577, 37.45096], [-122.17782, 37.45219]]]} | Open Access 1 | 4790 | Burgess Park | 16518 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 13.014 | Burgess Park | 1947 | Local Park 2 | 4 | |
744 | 744 | 743 | {"type": "Polygon", "coordinates": [[[-117.47083, 34.12883], [-117.47082, 34.13125], [-117.47075, 34.13131], [-117.46928, 34.13131], [-117.46928, 34.12876], [-117.47075, 34.12876], [-117.47083, 34.12883]]]} | Open Access 1 | 4839 | Koehler Park / The Landings | 20712 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 9.998 | Koehler Park / The Landings | None 68 | |||
745 | 745 | 744 | {"type": "Polygon", "coordinates": [[[-117.18976, 34.13227], [-117.18934, 34.1326], [-117.18918, 34.1325], [-117.18904, 34.13244], [-117.18809, 34.13217], [-117.18805, 34.13209], [-117.1897, 34.1321], [-117.18976, 34.13227]]]} | Open Access 1 | 4841 | Canyon Oaks Park | 16821 | 1136 | Highland, City of 249 | City 2 | City Agency 2 | http://www.ci.highland.ca.us/ | City 2 | 1136 | Highland, City of 245 | City 2 | City Agency 2 | San Bernardino 22 | 1.171 | Canyon Oaks Park | 0 | Local Park 2 | 4 | |
746 | 746 | 745 | {"type": "MultiPolygon", "coordinates": [[[[-117.40095, 33.94777], [-117.40071, 33.94777], [-117.40025, 33.94777], [-117.40041, 33.94751], [-117.40046, 33.94749], [-117.40093, 33.94769], [-117.40095, 33.94772], [-117.40095, 33.94777]]], [[[-117.40082, 33.94629], [-117.40073, 33.94643], [-117.40029, 33.94713], [-117.40029, 33.94672], [-117.40046, 33.94671], [-117.40046, 33.9463], [-117.40082, 33.94629]]], [[[-117.40096, 33.94666], [-117.40096, 33.94755], [-117.40095, 33.94758], [-117.40091, 33.9476], [-117.40053, 33.94743], [-117.4005, 33.94737], [-117.40096, 33.94666]]]]} | Open Access 1 | 4842 | Low Park | 21552 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 1.258 | Low Park | 0 | Local Park 2 | 4 | |
747 | 747 | 746 | {"type": "MultiPolygon", "coordinates": [[[[-119.44573, 36.58961], [-119.44537, 36.58963], [-119.44447, 36.58892], [-119.4438, 36.58849], [-119.44338, 36.58829], [-119.43086, 36.58296], [-119.43083, 36.58271], [-119.44402, 36.58835], [-119.44453, 36.58867], [-119.44573, 36.58961]]], [[[-119.44987, 36.59354], [-119.44964, 36.59365], [-119.44551, 36.58977], [-119.44593, 36.58981], [-119.44987, 36.59354]]], [[[-119.45189, 36.59557], [-119.45174, 36.5957], [-119.45083, 36.59481], [-119.45091, 36.59472], [-119.45079, 36.59461], [-119.45068, 36.59466], [-119.44981, 36.59379], [-119.45002, 36.59366], [-119.45189, 36.59557]]], [[[-119.453, 36.59657], [-119.45277, 36.59669], [-119.45188, 36.59581], [-119.45205, 36.59566], [-119.453, 36.59657]]], [[[-119.45512, 36.59856], [-119.45491, 36.59872], [-119.45297, 36.59683], [-119.45318, 36.59667], [-119.45512, 36.59856]]], [[[-119.45728, 36.60049], [-119.4568, 36.6005], [-119.45508, 36.59886], [-119.45525, 36.59868], [-119.45728, 36.60049]]], [[[-119.45763, 36.60105], [-119.45763, 36.60105], [-119.45699, 36.60059], [-119.45759, 36.60064], [-119.45763, 36.60105]]], [[[-119.46088, 36.60239], [-119.46072, 36.60259], [-119.45776, 36.60116], [-119.45774, 36.60077], [-119.45891, 36.60144], [-119.46088, 36.60239]]]]} | Open Access 1 | 4869 | Reedley Community Parkway | 24261 | 1272 | Reedley, City of 250 | City 2 | City Agency 2 | http://www.reedley.com/ | City 2 | 1272 | Reedley, City of 246 | City 2 | City Agency 2 | Fresno 9 | 20.099 | Reedley Community Parkway | 0 | Local Recreation Area 3 | 4 | |
748 | 748 | 747 | {"type": "Polygon", "coordinates": [[[-122.06423, 38.24698], [-122.06271, 38.24698], [-122.06272, 38.24918], [-122.05835, 38.24917], [-122.0583, 38.24668], [-122.05833, 38.24524], [-122.06423, 38.2453], [-122.06423, 38.24698]]]} | Open Access 1 | 4870 | Alan Witt Park | 15325 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 47.468 | Alan Witt Park | 0 | Local Park 2 | 4 | |
749 | 749 | 748 | {"type": "Polygon", "coordinates": [[[-119.62108, 36.558], [-119.62104, 36.55974], [-119.62088, 36.55974], [-119.62087, 36.55979], [-119.61988, 36.55979], [-119.61991, 36.558], [-119.62036, 36.55799], [-119.62108, 36.558]]]} | Open Access 1 | 4873 | West Selma Cemetery | 27375 | 2148 | Selma Cemetery District 251 | Special District 4 | Cemetery District 11 | Special District 4 | 2148 | Selma Cemetery District 247 | Special District 4 | Cemetery District 11 | Fresno 9 | 5.109 | West Selma Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
750 | 750 | 749 | {"type": "Polygon", "coordinates": [[[-118.11706, 34.02141], [-118.11655, 34.02308], [-118.11557, 34.02288], [-118.11586, 34.02192], [-118.11517, 34.02177], [-118.11511, 34.02168], [-118.11503, 34.02159], [-118.11491, 34.02152], [-118.11479, 34.02148], [-118.11481, 34.02139], [-118.11388, 34.02119], [-118.11386, 34.02117], [-118.11395, 34.02088], [-118.114, 34.02085], [-118.11597, 34.02126], [-118.116, 34.02118], [-118.11706, 34.02141]]]} | Open Access 1 | 4874 | Acuna Park | 15253 | 1211 | Montebello, City of 252 | City 2 | City Agency 2 | http://www.cityofmontebello.com/depts/parks/default.asp | City 2 | 1211 | Montebello, City of 248 | City 2 | City Agency 2 | Los Angeles 6 | 7.143 | Acuna Park | 0 | Local Park 2 | 4 | |
751 | 751 | 750 | {"type": "Polygon", "coordinates": [[[-122.02681, 37.30115], [-122.02645, 37.30262], [-122.02649, 37.30263], [-122.02622, 37.30302], [-122.02611, 37.30314], [-122.02528, 37.30385], [-122.02406, 37.30433], [-122.02399, 37.30413], [-122.02384, 37.30385], [-122.0238, 37.30366], [-122.02375, 37.30168], [-122.0238, 37.30147], [-122.02381, 37.30133], [-122.02383, 37.30129], [-122.02389, 37.30126], [-122.02608, 37.30126], [-122.02635, 37.30123], [-122.02668, 37.30115], [-122.02681, 37.30115]]]} | Open Access 1 | 5576 | Calabazas | 16668 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 16.77 | Calabazas | 1978 | None 69 | ||
752 | 752 | 751 | {"type": "Polygon", "coordinates": [[[-118.28031, 34.05822], [-118.27848, 34.06102], [-118.27504, 34.05949], [-118.27684, 34.05666], [-118.28031, 34.05822]]]} | Open Access 1 | 4928 | MacArthur Park | 21623 | 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 | 31.717 | MacArthur Park | 0 | Local Park 2 | 4 | |
753 | 753 | 752 | {"type": "Polygon", "coordinates": [[[-117.40864, 34.57644], [-117.40864, 34.57651], [-117.40731, 34.57652], [-117.4073, 34.57483], [-117.40807, 34.57484], [-117.40809, 34.57508], [-117.40828, 34.5751], [-117.4083, 34.57568], [-117.4078, 34.57569], [-117.40771, 34.57575], [-117.40767, 34.57584], [-117.40764, 34.57594], [-117.40764, 34.57606], [-117.40824, 34.57606], [-117.40825, 34.5763], [-117.40859, 34.5763], [-117.40864, 34.57631], [-117.40864, 34.57644]]]} | Open Access 1 | 5583 | Adelanto Park | 15265 | 1403 | Adelanto, City of 253 | City 2 | City Agency 2 | http://www.ci.adelanto.ca.us/index.asp?SEC=517BE3C2-87D2-432E-9BC6-84102B2ADDFB&Type=B_BASIC | City 2 | 1403 | Adelanto, City of 249 | City 2 | City Agency 2 | San Bernardino 22 | 3.627 | Adelanto 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]);