units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
397 rows where COUNTY = 14
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Monterey, County of 44
- Salinas, City of 41
- Seaside, City of 34
- Monterey, City of 29
- Monterey Peninsula Regional Park District 24
- California Department of Parks and Recreation 23
- Big Sur Land Trust 19
- Greenfield, City of 18
- Pacific Grove, City of 16
- Soledad, City of 11
- Marina, City of 10
- Del Monte Forest Foundation 10
- Gonzales, City of 9
- Elkhorn Slough Foundation 9
- California Department of Fish and Wildlife 8
- Other State 8
- King City, City of 8
- Carmel-by-the-Sea, City of 6
- North County Recreation and Park District 6
- United States Department of Defense 4
- United States Bureau of Land Management 3
- United States Forest Service 3
- University of California 3
- California State Lands Commission 2
- United States Coast Guard 2
- Sand City, City of 2
- Del Rey Oaks, City of 2
- Moss Landing Harbor District 2
- Monterey County Water Resources Agency 2
- Pajaro Community Services District 2
- …
DES_TP >30
- Local Park 151
- Local Other or Unknown 51
- Private Conservation 36
- Local Recreation Area 33
- State Park 17
- State Conservation Area 14
- Local Conservation Area 10
- Local Historic or Cultural Area 7
- State Other or Unknown 7
- National Monument or Landmark 5
- Private Other or Unknown 5
- State Historic or Cultural Area 3
- Recreation Management Area 2
- Private Recreation or Education 2
- National Public Lands 1
- National Forest 1
- National Park 1
- State Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Private Agricultural 1
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 311
- Restricted Access 36
- No Public Access 22
- Unknown Access 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
651 | 651 | 650 | {"type": "Polygon", "coordinates": [[[-121.83147, 36.60522], [-121.83145, 36.60586], [-121.83095, 36.60585], [-121.83097, 36.60522], [-121.83147, 36.60522]]]} | Open Access 1 | 3181 | Capra Park | 16842 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.791 | Capra Park | 0 | Local Park 2 | 4 | |
679 | 679 | 678 | {"type": "Polygon", "coordinates": [[[-121.92514, 36.53043], [-121.92439, 36.53053], [-121.92438, 36.5305], [-121.92514, 36.53041], [-121.92514, 36.53043]]]} | Open Access 1 | 3434 | Carmel River Lagoon & Wetlands Natural Preserve | 16874 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 0.044 | Carmel River Lagoon & Wetlands Natural Preserve | 0 | Local Conservation Area 4 | 2 | |
762 | 762 | 761 | {"type": "Polygon", "coordinates": [[[-121.85224, 36.59449], [-121.85177, 36.59488], [-121.85075, 36.59406], [-121.85181, 36.59419], [-121.85195, 36.59425], [-121.85224, 36.59449]]]} | Open Access 1 | 4961 | Casanova Oak Knoll Park | 16933 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 1.296 | Casanova Oak Knoll Park | 0 | Local Park 2 | 4 | |
775 | 775 | 774 | {"type": "Polygon", "coordinates": [[[-121.91806, 36.62456], [-121.91784, 36.6251], [-121.91745, 36.6249], [-121.91761, 36.62454], [-121.91788, 36.62453], [-121.91806, 36.62456]]]} | Open Access 1 | 5711 | Chase Park | 17157 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 0.521 | Chase Park | 0 | Local Park 2 | 4 | |
832 | 832 | 831 | {"type": "Polygon", "coordinates": [[[-121.63752, 36.67956], [-121.63746, 36.67966], [-121.63621, 36.68089], [-121.63611, 36.68096], [-121.63597, 36.68103], [-121.6358, 36.68108], [-121.63508, 36.6812], [-121.63494, 36.68121], [-121.63422, 36.68115], [-121.63433, 36.68028], [-121.63237, 36.67947], [-121.63175, 36.67992], [-121.62945, 36.68037], [-121.62906, 36.68053], [-121.6288, 36.68027], [-121.6285, 36.68005], [-121.62853, 36.68001], [-121.62833, 36.67989], [-121.62875, 36.67962], [-121.62899, 36.67954], [-121.62933, 36.6792], [-121.6294, 36.67897], [-121.62938, 36.67876], [-121.62926, 36.67865], [-121.62909, 36.67845], [-121.62997, 36.67864], [-121.62997, 36.67868], [-121.63031, 36.67883], [-121.63081, 36.67887], [-121.6314, 36.67873], [-121.63142, 36.6787], [-121.63148, 36.67869], [-121.63156, 36.67813], [-121.63279, 36.6784], [-121.63486, 36.67951], [-121.63503, 36.67953], [-121.63501, 36.67958], [-121.63502, 36.67959], [-121.6353, 36.67964], [-121.63635, 36.67962], [-121.63752, 36.67956]]]} | Open Access 1 | 5409 | Cesar Chavez Community Park | 17092 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 27.823 | Cesar Chavez Community Park | 0 | Local Park 2 | 4 | |
1133 | 1133 | 1132 | {"type": "Polygon", "coordinates": [[[-121.6595, 36.67057], [-121.65909, 36.67063], [-121.659, 36.67022], [-121.65942, 36.67016], [-121.6595, 36.67057]]]} | Open Access 1 | 7220 | Clay Park | 17397 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.426 | Clay Park | 0 | Local Park 2 | 4 | |
1183 | 1183 | 1182 | {"type": "Polygon", "coordinates": [[[-121.91238, 36.53285], [-121.91178, 36.53344], [-121.91174, 36.5336], [-121.90785, 36.53358], [-121.90718, 36.53361], [-121.90652, 36.53368], [-121.90586, 36.53377], [-121.90514, 36.53391], [-121.90169, 36.53471], [-121.90144, 36.53402], [-121.90197, 36.53366], [-121.90319, 36.53217], [-121.9039, 36.53149], [-121.90504, 36.53109], [-121.90542, 36.53107], [-121.90577, 36.5311], [-121.90609, 36.53133], [-121.90641, 36.53152], [-121.90692, 36.53164], [-121.9072, 36.53167], [-121.90743, 36.53162], [-121.90823, 36.53118], [-121.90861, 36.53115], [-121.91058, 36.5322], [-121.91194, 36.53282], [-121.91238, 36.53285]]]} | Restricted Access 2 | 7782 | Coast Ranch | 17463 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 51.109 | Coast Ranch | 0 | Private Conservation 16 | 2 | |
1426 | 1426 | 1425 | {"type": "Polygon", "coordinates": [[[-121.64639, 36.6877], [-121.64408, 36.6912], [-121.64363, 36.69113], [-121.64368, 36.69104], [-121.64367, 36.69103], [-121.64273, 36.69088], [-121.64213, 36.69135], [-121.64196, 36.69156], [-121.64198, 36.69158], [-121.64139, 36.69215], [-121.63962, 36.69351], [-121.63892, 36.69423], [-121.63884, 36.69428], [-121.63864, 36.69411], [-121.63991, 36.69024], [-121.6399, 36.69023], [-121.63797, 36.69073], [-121.63845, 36.68718], [-121.64106, 36.6865], [-121.64063, 36.68798], [-121.64637, 36.68758], [-121.6464, 36.68763], [-121.64639, 36.6877]]]} | No Public Access 3 | 48978 | Carr Lake | 33675 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | https://bigsurlandtrust.org/wp-content/uploads/2018/10/CarrLake_PublicMap-2.pdf | Monterey 14 | 72.339 | Carr Lake | 2017 | Private Conservation 16 | 2 |
1479 | 1479 | 1478 | {"type": "Polygon", "coordinates": [[[-121.62993, 36.69624], [-121.62762, 36.69442], [-121.62979, 36.69262], [-121.63183, 36.6944], [-121.63188, 36.69446], [-121.63189, 36.69452], [-121.63188, 36.69459], [-121.63186, 36.69463], [-121.62993, 36.69624]]]} | Open Access 1 | 10118 | Constitution Soccer Complex | 17603 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 19.339 | Constitution Soccer Complex | 0 | Local Recreation Area 3 | 4 | |
1516 | 1516 | 1515 | {"type": "Polygon", "coordinates": [[[-121.91031, 36.62062], [-121.91016, 36.62096], [-121.90987, 36.6208], [-121.90954, 36.62069], [-121.9097, 36.62033], [-121.90994, 36.6204], [-121.90991, 36.62051], [-121.91031, 36.62062]]]} | Open Access 1 | 10994 | Andy Jacobson Park | 15489 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 0.587 | Andy Jacobson Park | 0 | Local Park 2 | 4 | |
1537 | 1537 | 1536 | {"type": "Polygon", "coordinates": [[[-121.61028, 36.70424], [-121.61018, 36.70453], [-121.60947, 36.70555], [-121.60894, 36.70532], [-121.60905, 36.70516], [-121.60966, 36.7045], [-121.6099, 36.70418], [-121.60995, 36.70416], [-121.61001, 36.70415], [-121.61028, 36.70424]]]} | Open Access 1 | 11239 | Creekbridge Neighborhood Park | 17766 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 1.816 | Creekbridge Neighborhood Park | 0 | Local Park 2 | 4 | |
1553 | 1553 | 1552 | {"type": "Polygon", "coordinates": [[[-121.90672, 36.50825], [-121.90222, 36.5082], [-121.90221, 36.50639], [-121.90672, 36.50645], [-121.90672, 36.50825]]]} | Restricted Access 2 | 11595 | Curtis | 17864 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 19.995 | Curtis | 0 | Private Conservation 16 | 2 | |
1756 | 1756 | 1755 | {"type": "Polygon", "coordinates": [[[-121.86248, 36.57835], [-121.86239, 36.57909], [-121.8616, 36.57872], [-121.86205, 36.57832], [-121.86248, 36.57835]]]} | Open Access 1 | 13079 | Deer Flats Park | 17996 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 1.0 | Deer Flats Park | 0 | Local Park 2 | 4 | |
1797 | 1797 | 1796 | {"type": "MultiPolygon", "coordinates": [[[[-121.89329, 36.59281], [-121.89328, 36.59282], [-121.89237, 36.59259], [-121.89257, 36.59233], [-121.89262, 36.59231], [-121.89266, 36.59231], [-121.89285, 36.59244], [-121.89327, 36.59271], [-121.89327, 36.59276], [-121.89329, 36.59281]]], [[[-121.90145, 36.58357], [-121.89962, 36.58668], [-121.89925, 36.58719], [-121.89888, 36.5876], [-121.89356, 36.59253], [-121.89347, 36.59253], [-121.89338, 36.59256], [-121.89298, 36.59232], [-121.8928, 36.59217], [-121.89265, 36.59197], [-121.89256, 36.59178], [-121.89252, 36.59155], [-121.89253, 36.59132], [-121.89257, 36.59117], [-121.89299, 36.59016], [-121.89308, 36.58998], [-121.89325, 36.58976], [-121.89372, 36.58997], [-121.89484, 36.58998], [-121.8955, 36.58927], [-121.89593, 36.58842], [-121.8971, 36.58754], [-121.89751, 36.58704], [-121.8985, 36.58658], [-121.89882, 36.5863], [-121.90108, 36.58319], [-121.90131, 36.58334], [-121.90145, 36.58357]]]]} | Open Access 1 | 13544 | Don Dahvee Greenbelt | 18201 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 35.707 | Don Dahvee Greenbelt | 0 | Local Recreation Area 3 | 4 | |
1814 | 1814 | 1813 | {"type": "Polygon", "coordinates": [[[-121.83212, 36.60337], [-121.83211, 36.60358], [-121.8316, 36.60358], [-121.83161, 36.60337], [-121.83212, 36.60337]]]} | Open Access 1 | 15623 | Encanto Park | 18638 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.261 | Encanto Park | 0 | Local Park 2 | 4 | |
1855 | 1855 | 1854 | {"type": "Polygon", "coordinates": [[[-121.85534, 36.57982], [-121.85529, 36.57987], [-121.85525, 36.57992], [-121.85519, 36.57986], [-121.85475, 36.58], [-121.85446, 36.57938], [-121.85489, 36.57925], [-121.85494, 36.57919], [-121.85503, 36.57922], [-121.85515, 36.57922], [-121.85534, 36.57982]]]} | Open Access 1 | 15857 | Fishermans Flats Park | 18924 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 1.106 | Fishermans Flats Park | 0 | Local Park 2 | 4 | |
1904 | 1904 | 1903 | {"type": "MultiPolygon", "coordinates": [[[[-121.61887, 36.71254], [-121.61886, 36.71261], [-121.6185, 36.71307], [-121.61816, 36.71343], [-121.6178, 36.71378], [-121.61758, 36.71404], [-121.61734, 36.71441], [-121.61711, 36.71491], [-121.61681, 36.71483], [-121.61679, 36.71478], [-121.61695, 36.71444], [-121.61718, 36.71404], [-121.61734, 36.71384], [-121.61755, 36.7136], [-121.61799, 36.71318], [-121.61822, 36.71293], [-121.61843, 36.71266], [-121.61858, 36.71244], [-121.61862, 36.71242], [-121.61865, 36.71242], [-121.61885, 36.71251], [-121.61887, 36.71254]]], [[[-121.62192, 36.70546], [-121.62192, 36.70572], [-121.6218, 36.70605], [-121.6214, 36.70663], [-121.62144, 36.70691], [-121.62137, 36.70731], [-121.62114, 36.70767], [-121.62112, 36.7092], [-121.62102, 36.70934], [-121.62123, 36.70991], [-121.621, 36.71038], [-121.62096, 36.71057], [-121.62093, 36.71062], [-121.62055, 36.71077], [-121.6202, 36.71094], [-121.61998, 36.71109], [-121.61976, 36.71126], [-121.61957, 36.71144], [-121.6194, 36.71167], [-121.61902, 36.71234], [-121.61894, 36.71236], [-121.61876, 36.71228], [-121.61872, 36.71224], [-121.61872, 36.7122], [-121.61887, 36.71195], [-121.61898, 36.7117], [-121.61906, 36.71143], [-121.61911, 36.71115], [-121.61925, 36.71117], [-121.61939, 36.71099], [-121.61951, 36.71087], [-121.61966, 36.71077], [-121.61984, 36.71069], [-121.61975, 36.71012], [-121.61996, 36.70925], [-121.62083, 36.70759], [-121.62127, 36.70536], [-121.62192, 36.70546]]]]} | Open Access 1 | 16324 | Gabilan Creek Wilderness Sanctuary | 19165 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 14.845 | Gabilan Creek Wilderness Sanctuary | 0 | Local Conservation Area 4 | 2 | |
1942 | 1942 | 1941 | {"type": "Polygon", "coordinates": [[[-121.43074, 36.49462], [-121.42983, 36.49537], [-121.42837, 36.49418], [-121.4298, 36.49384], [-121.43074, 36.49462]]]} | Open Access 1 | 16639 | Gonzales Cemetery | 19393 | 2038 | Gonzales Cemetery District 457 | Special District 4 | Cemetery District 11 | Special District 4 | 2038 | Gonzales Cemetery District 451 | Special District 4 | Cemetery District 11 | Monterey 14 | 4.437 | Gonzales Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
1943 | 1943 | 1942 | {"type": "Polygon", "coordinates": [[[-121.44452, 36.50964], [-121.44379, 36.51021], [-121.44308, 36.50961], [-121.44381, 36.50905], [-121.44452, 36.50964]]]} | Open Access 1 | 16643 | Gonzales Central Park | 19394 | 1122 | Gonzales, City of 458 | City 2 | City Agency 2 | http://www.ci.gonzales.ca.us/parks-and-facilities.php | City 2 | 1122 | Gonzales, City of 452 | City 2 | City Agency 2 | Monterey 14 | 2.05 | Gonzales Central Park | 0 | Local Park 2 | 4 | |
1979 | 1979 | 1978 | {"type": "Polygon", "coordinates": [[[-121.70451, 36.82285], [-121.70093, 36.8239], [-121.69807, 36.82554], [-121.69697, 36.82531], [-121.69577, 36.82573], [-121.69365, 36.82737], [-121.69189, 36.82775], [-121.68673, 36.82948], [-121.6852, 36.83049], [-121.68253, 36.83133], [-121.68196, 36.83058], [-121.68169, 36.82951], [-121.68138, 36.82887], [-121.68016, 36.82835], [-121.67991, 36.82691], [-121.67861, 36.8239], [-121.67901, 36.82359], [-121.67927, 36.82261], [-121.68059, 36.82235], [-121.67966, 36.82096], [-121.6798, 36.82083], [-121.68079, 36.82232], [-121.69006, 36.82054], [-121.70297, 36.81805], [-121.70451, 36.82285]]]} | No Public Access 3 | 15151 | Elkhorn Slough / Long Valley - ESF | 18577 | 3019 | Elkhorn Slough Foundation 464 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.elkhornslough.org | Non Governmental Organization 10 | 3019 | Elkhorn Slough Foundation 457 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 428.023 | Elkhorn Slough / Long Valley - ESF | 0 | Private Conservation 16 | 2 |
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]);