units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by AGNCY_TYP
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 7,947
- County Agency 1,209
- Recreation/Parks District 1,154
- State Agency 1,095
- Non Profit - Land Trust 599
- Open Space District 421
- Water District 238
- County Agency - Parks 234
- Home Owners Association 203
- Community Services District 198
- Non Profit - Conservation 148
- Flood District 108
- Cemetery District 62
- Irrigation District 49
- Non Profit - Other 41
- School District 38
- County Agency - Other 35
- Port/Harbor District 32
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- Federal Agency 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
- California Department of Fish and Wildlife 429
- San Diego, City of 407
- Los Angeles, City of 376
- California Department of Parks and Recreation 353
- Mountains Recreation and Conservation Authority 347
- Sacramento, City of 190
- San Jose, City of 186
- Los Angeles, County of 172
- East Bay Regional Park District 163
- San Francisco, City and County of 158
- Ventura, City of 130
- Long Beach, City of 123
- San Diego, County of 120
- Santa Barbara, County of 118
- Roseville, City of 110
- Orange, County of 95
- Consumnes Community Services District 94
- Oakland, City of 91
- California State Lands Commission 86
- Hayward Area Recreation and Park District 84
- Napa, City of 78
- Irvine, City of 70
- Valley-Wide Recreation and Park District 67
- Los Angeles - Department of Parks and Recreation, County of 64
- Davis, City of 61
- Tracy, City of 61
- Poway, City of 60
- San Ramon, City of 58
- Santa Cruz, City of 56
- Lake, County of 56
- …
DES_TP >30
- Local Park 7,248
- Local Recreation Area 1,756
- Local Other or Unknown 1,158
- Private Conservation 629
- Local Conservation Area 444
- State Conservation Area 364
- Private Recreation or Education 268
- State Park 202
- State Resource Management Area 159
- State Recreation Area 128
- Local Historic or Cultural Area 106
- State Other or Unknown 70
- State Historic or Cultural Area 62
- Private Other or Unknown 51
- Local Resource Management Area 22
- National Monument or Landmark 16
- Private Agricultural 12
- National Wildlife Refuge 6
- Private Historic or Cultural 4
- National Forest 3
- National Recreation Area 3
- State Wilderness 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 11,552
- Restricted Access 1,075
- No Public Access 899
- Unknown Access 373
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3639 | 3639 | 3638 | {"type": "Polygon", "coordinates": [[[-121.23289, 38.83923], [-121.23166, 38.83923], [-121.23148, 38.83918], [-121.23116, 38.83917], [-121.22968, 38.83909], [-121.22968, 38.83892], [-121.22943, 38.83761], [-121.23048, 38.83762], [-121.2305, 38.83696], [-121.2312, 38.83751], [-121.23166, 38.83783], [-121.23216, 38.83813], [-121.23242, 38.83825], [-121.2327, 38.83836], [-121.23267, 38.83845], [-121.23268, 38.83854], [-121.23288, 38.83891], [-121.23289, 38.83923]]]} | Open Access 1 | 29497 | Boulder Ridge Park | 16297 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 11.15 | Boulder Ridge Park | 0 | Local Park 2 | 4 | |
3640 | 3640 | 3639 | {"type": "Polygon", "coordinates": [[[-121.25516, 38.82911], [-121.25484, 38.82931], [-121.25459, 38.82956], [-121.25447, 38.82976], [-121.25421, 38.8303], [-121.25411, 38.83044], [-121.25317, 38.82964], [-121.25338, 38.82941], [-121.25345, 38.82929], [-121.2535, 38.82917], [-121.25354, 38.82903], [-121.25355, 38.82889], [-121.25354, 38.82875], [-121.25351, 38.8286], [-121.25392, 38.82844], [-121.25515, 38.82835], [-121.25517, 38.82877], [-121.25511, 38.82902], [-121.25516, 38.82911]]]} | No Public Access 3 | 29498 | Mansion Oaks Park | 21761 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 5.751 | Mansion Oaks Park | 0 | Local Park 2 | 4 | |
3641 | 3641 | 3640 | {"type": "Polygon", "coordinates": [[[-117.89406, 34.16397], [-117.89267, 34.16401], [-117.89233, 34.1637], [-117.89222, 34.16349], [-117.89221, 34.16311], [-117.89406, 34.16397]]]} | Open Access 1 | 29516 | River Wilderness Park | 24431 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 1.847 | River Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
3644 | 3644 | 3643 | {"type": "Polygon", "coordinates": [[[-117.15271, 34.12106], [-117.15209, 34.12107], [-117.15215, 34.12455], [-117.15001, 34.12454], [-117.14992, 34.12106], [-117.13918, 34.12108], [-117.13913, 34.11642], [-117.13931, 34.11652], [-117.13941, 34.11655], [-117.13957, 34.1167], [-117.13974, 34.11677], [-117.13979, 34.11682], [-117.13992, 34.11702], [-117.14008, 34.11731], [-117.14011, 34.11735], [-117.1402, 34.11738], [-117.14042, 34.11751], [-117.14052, 34.11753], [-117.14058, 34.11757], [-117.14064, 34.11768], [-117.14074, 34.11781], [-117.14076, 34.11788], [-117.14088, 34.11803], [-117.14107, 34.11822], [-117.14114, 34.11834], [-117.14121, 34.11842], [-117.14128, 34.11839], [-117.14234, 34.11835], [-117.14279, 34.11851], [-117.14331, 34.11848], [-117.14368, 34.1186], [-117.14393, 34.11866], [-117.14428, 34.11879], [-117.14528, 34.11897], [-117.14585, 34.11906], [-117.14588, 34.11899], [-117.14643, 34.11898], [-117.148, 34.11954], [-117.14884, 34.11987], [-117.15053, 34.12041], [-117.15053, 34.12044], [-117.15207, 34.12091], [-117.15271, 34.12106]]]} | Open Access 1 | 29522 | City of Highland Natural Park Land | 17316 | 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 | 85.909 | City of Highland Natural Park Land | None 304 | |||
3647 | 3647 | 3646 | {"type": "Polygon", "coordinates": [[[-118.18416, 33.84964], [-118.18416, 33.84977], [-118.1839, 33.84978], [-118.18368, 33.84995], [-118.18366, 33.85], [-118.18366, 33.85103], [-118.18368, 33.85107], [-118.1839, 33.85124], [-118.18415, 33.85125], [-118.18412, 33.8514], [-118.18406, 33.85154], [-118.18391, 33.85147], [-118.18377, 33.85139], [-118.18366, 33.85128], [-118.18358, 33.85119], [-118.18348, 33.85098], [-118.18344, 33.85061], [-118.18338, 33.85051], [-118.18271, 33.85006], [-118.18216, 33.84996], [-118.18039, 33.85003], [-118.18036, 33.85027], [-118.18017, 33.85029], [-118.18011, 33.85019], [-118.18008, 33.84977], [-118.17983, 33.84976], [-118.17975, 33.84957], [-118.17968, 33.84949], [-118.17974, 33.84942], [-118.17984, 33.84936], [-118.18021, 33.84922], [-118.18033, 33.84962], [-118.18037, 33.84983], [-118.18193, 33.84976], [-118.18192, 33.84935], [-118.18226, 33.84923], [-118.18204, 33.84878], [-118.18212, 33.84873], [-118.18233, 33.84879], [-118.18248, 33.84853], [-118.18292, 33.84865], [-118.18288, 33.84873], [-118.18271, 33.84886], [-118.18251, 33.84906], [-118.18305, 33.84956], [-118.18339, 33.84983], [-118.18349, 33.84986], [-118.18356, 33.84986], [-118.18363, 33.84983], [-118.18379, 33.8497], [-118.18388, 33.84966], [-118.18397, 33.84964], [-118.18416, 33.84964]]]} | Open Access 1 | 29559 | Atlantic Plaza Park | 15675 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 6.585 | Atlantic Plaza Park | 0 | Local Park 2 | 4 | |
3649 | 3649 | 3648 | {"type": "Polygon", "coordinates": [[[-119.16573, 34.21387], [-119.16566, 34.21391], [-119.16562, 34.21398], [-119.16561, 34.21418], [-119.16528, 34.21418], [-119.16528, 34.21381], [-119.16436, 34.2138], [-119.16437, 34.2133], [-119.16439, 34.21328], [-119.16571, 34.21329], [-119.1657, 34.21382], [-119.16573, 34.21387]]]} | Open Access 1 | 48804 | Oxnard Historic Farm Park | 33526 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 2.107 | Oxnard Historic Farm Park | 0 | Local Historic or Cultural Area 19 | 4 | |
3650 | 3650 | 3649 | {"type": "Polygon", "coordinates": [[[-117.22792, 33.78575], [-117.22791, 33.7858], [-117.22716, 33.78583], [-117.22716, 33.78652], [-117.22629, 33.78652], [-117.22625, 33.78652], [-117.22623, 33.78649], [-117.22622, 33.78562], [-117.22627, 33.78556], [-117.22768, 33.78556], [-117.22769, 33.78574], [-117.22792, 33.78575]]]} | Open Access 1 | 48805 | Russel Stewart Park/Cesar Chavez Library | 33527 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://www.cityofperris.org/residents/parks/parklist.html | Riverside 10 | 2.684 | Russel Stewart Park/Cesar Chavez Library | None 305 | ||
3651 | 3651 | 3650 | {"type": "Polygon", "coordinates": [[[-122.12357, 37.47625], [-122.11842, 37.47804], [-122.11828, 37.47759], [-122.12356, 37.47574], [-122.12357, 37.47625]]]} | Open Access 1 | 43106 | Cooley Landing Park | 17619 | 1091 | East Palo Alto, City of 637 | City 2 | City Agency 2 | http://www.ci.east-palo-alto.ca.us | City 2 | 1091 | East Palo Alto, City of 626 | City 2 | City Agency 2 | San Mateo 15 | 6.447 | Cooley Landing Park | 2012 | Local Park 2 | 4 | |
3652 | 3652 | 3651 | {"type": "Polygon", "coordinates": [[[-119.18157, 34.27235], [-119.18155, 34.27234], [-119.1815, 34.2721], [-119.18151, 34.27206], [-119.18156, 34.27204], [-119.18177, 34.27201], [-119.1818, 34.27202], [-119.18187, 34.27209], [-119.18172, 34.27225], [-119.18157, 34.27235]]]} | Open Access 1 | 46897 | Citrus Walk Gold Park | 30399 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.194 | Citrus Walk Gold Park | 0 | Local Park 2 | 4 | |
3653 | 3653 | 3652 | {"type": "Polygon", "coordinates": [[[-121.64347, 37.11265], [-121.64347, 37.11268], [-121.64305, 37.11279], [-121.64285, 37.11264], [-121.64329, 37.11251], [-121.64336, 37.1126], [-121.64341, 37.11259], [-121.64345, 37.11265], [-121.64347, 37.11265]]]} | Open Access 1 | 29875 | 21 Mile Park | 15179 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 0.221 | 21 Mile Park | 0 | Local Park 2 | 4 | |
3655 | 3655 | 3654 | {"type": "Polygon", "coordinates": [[[-118.01025, 33.8141], [-118.00963, 33.8145], [-118.00962, 33.81458], [-118.00903, 33.81457], [-118.00903, 33.81504], [-118.00862, 33.81504], [-118.00641, 33.81368], [-118.00641, 33.81364], [-118.00708, 33.81363], [-118.00708, 33.81327], [-118.00725, 33.81327], [-118.00727, 33.81363], [-118.00876, 33.81362], [-118.00878, 33.81408], [-118.01021, 33.81405], [-118.01025, 33.8141]]]} | Open Access 1 | 29596 | Hansen Park | 19648 | 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 | 6.605 | Hansen Park | 0 | Local Park 2 | 4 | |
3657 | 3657 | 3656 | {"type": "Polygon", "coordinates": [[[-117.31247, 34.11591], [-117.31247, 34.11755], [-117.3102, 34.11754], [-117.3102, 34.1159], [-117.31247, 34.11591]]]} | Open Access 1 | 29601 | Encanto Park | 18637 | 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 | 9.417 | Encanto Park | 0 | Local Park 2 | 4 | |
3658 | 3658 | 3657 | {"type": "Polygon", "coordinates": [[[-119.18436, 34.27411], [-119.18356, 34.27423], [-119.18352, 34.27406], [-119.18352, 34.27397], [-119.18357, 34.27384], [-119.18369, 34.27373], [-119.18384, 34.27368], [-119.18401, 34.27368], [-119.18416, 34.27373], [-119.18428, 34.27382], [-119.18433, 34.27393], [-119.18437, 34.2741], [-119.18436, 34.27411]]]} | Open Access 1 | 46898 | Citrus Walk Sunstone Park | 30400 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.877 | Citrus Walk Sunstone Park | 0 | Local Park 2 | 4 | |
3659 | 3659 | 3658 | {"type": "Polygon", "coordinates": [[[-119.19724, 34.26741], [-119.19685, 34.26747], [-119.19679, 34.26555], [-119.19717, 34.26554], [-119.19724, 34.26741]]]} | Open Access 1 | 46899 | Cornucopia Garden | 30401 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.855 | Cornucopia Garden | 0 | Local Park 2 | 4 | |
3661 | 3661 | 3660 | {"type": "Polygon", "coordinates": [[[-121.24385, 38.81066], [-121.24348, 38.81184], [-121.24341, 38.81205], [-121.2433, 38.81226], [-121.24299, 38.81279], [-121.24256, 38.81348], [-121.24111, 38.81281], [-121.2418, 38.81213], [-121.24265, 38.81212], [-121.24265, 38.81049], [-121.24303, 38.81049], [-121.24385, 38.81066]]]} | Open Access 1 | 29633 | Clarke Dominguez Park | 17390 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 8.027 | Clarke Dominguez Park | 0 | Local Park 2 | 4 | |
3664 | 3664 | 3663 | {"type": "Polygon", "coordinates": [[[-121.3465, 38.79539], [-121.3411, 38.79543], [-121.3411, 38.79542], [-121.34159, 38.79537], [-121.34265, 38.79521], [-121.34315, 38.7951], [-121.34381, 38.79492], [-121.34428, 38.79475], [-121.34485, 38.79451], [-121.34613, 38.79383], [-121.34649, 38.79424], [-121.3465, 38.79539]]]} | Open Access 1 | 29635 | Veterans Memorial Park | 27032 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 7.926 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
3667 | 3667 | 3666 | {"type": "Polygon", "coordinates": [[[-120.63151, 35.14694], [-120.63138, 35.14758], [-120.63074, 35.14764], [-120.63031, 35.14745], [-120.63006, 35.14668], [-120.6304, 35.1465], [-120.63082, 35.14618], [-120.63134, 35.14628], [-120.63127, 35.14651], [-120.63141, 35.14683], [-120.63151, 35.14694]]]} | Open Access 1 | 48812 | Price Historical Park | 33532 | 1253 | Pismo Beach, City of 423 | City 2 | City Agency 2 | http://www.pismobeach.org/69/Parks-Halls | City 2 | 1253 | Pismo Beach, City of 417 | City 2 | City Agency 2 | https://www.pismobeach.org/307/Price-Regional-Park | San Luis Obispo 1 | 3.772 | Price Historical Park | 0 | Local Historic or Cultural Area 19 | 4 |
3668 | 3668 | 3667 | {"type": "Polygon", "coordinates": [[[-121.85409, 37.22428], [-121.85408, 37.22431], [-121.85404, 37.22435], [-121.85328, 37.22419], [-121.85329, 37.224], [-121.85332, 37.22396], [-121.85338, 37.22393], [-121.85355, 37.22387], [-121.85363, 37.22387], [-121.85381, 37.22392], [-121.85397, 37.22392], [-121.854, 37.22395], [-121.85404, 37.22418], [-121.85409, 37.22428]]]} | Open Access 1 | 13730 | Pfeiffer Park | 23637 | 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 | 0.664 | Pfeiffer Park | 2001 | Local Park 2 | 4 | |
3669 | 3669 | 3668 | {"type": "Polygon", "coordinates": [[[-122.24716, 37.82328], [-122.24694, 37.82343], [-122.24704, 37.82379], [-122.24697, 37.82383], [-122.24686, 37.8237], [-122.24665, 37.82319], [-122.24594, 37.82256], [-122.24562, 37.82222], [-122.24612, 37.82207], [-122.24623, 37.82214], [-122.24621, 37.82224], [-122.24623, 37.82235], [-122.24647, 37.82266], [-122.24693, 37.82302], [-122.24716, 37.82328]]]} | Open Access 1 | 44215 | Linda Park | 21281 | 1251 | Piedmont, City of 562 | City 2 | City Agency 2 | http://www.ci.piedmont.ca.us/ | City 2 | 1251 | Piedmont, City of 554 | City 2 | City Agency 2 | Alameda 17 | 1.594 | Linda Park | 0 | Local Park 2 | 4 | |
3670 | 3670 | 3669 | {"type": "Polygon", "coordinates": [[[-120.61242, 35.11026], [-120.61236, 35.11057], [-120.61232, 35.11061], [-120.61228, 35.11061], [-120.61184, 35.11056], [-120.61162, 35.11056], [-120.61162, 35.11015], [-120.61204, 35.11017], [-120.61239, 35.11023], [-120.61242, 35.11026]]]} | Open Access 1 | 44247 | Hero Community Park | 19875 | 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 | 0.771 | Hero Community 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]);