units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where AGNCY_LEV = 2 and DES_TP = 19 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, MNG_AG_LEV, COUNTY
MNG_AGENCY 30
- Fremont, City of 6
- Long Beach, City of 3
- Rio Vista, City of 2
- Oakdale, City of 1
- San Diego, City of 1
- Los Angeles, City of 1
- San Jose, City of 1
- Monterey, City of 1
- Turlock, City of 1
- San Ramon, City of 1
- East Bay Regional Park District 1
- San Juan Capistrano, City of 1
- Oxnard, City of 1
- San Mateo, City of 1
- Rialto, City of 1
- Ventura, City of 1
- Carlsbad, City of 1
- Pacific Grove, City of 1
- Santa Monica, City of 1
- South Pasadena, City of 1
- Redwood City, City of 1
- Gilroy, City of 1
- Pismo Beach, City of 1
- Modesto, City of 1
- Firebaugh, City of 1
- Marysville, City of 1
- Eureka, City of 1
- Williams, City of 1
- Los Angeles - Community Redevelopment Agency, City of 1
- Colma, City of 1
MNG_AG_TYP 2
ACCESS_TYP 2
DES_TP 1
- Local Historic or Cultural Area · 38 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7127 | 7127 | 7126 | {"type": "Polygon", "coordinates": [[[-118.24292, 33.94311], [-118.24258, 33.94313], [-118.24261, 33.94276], [-118.24292, 33.94277], [-118.24292, 33.94311]]]} | Restricted Access 2 | 6216 | Watts Historic Train Station | 29326 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1717 | Los Angeles - Community Redevelopment Agency, City of 829 | City 2 | City Agency 2 | Los Angeles 6 | 0.287 | Watts Historic Train Station | 0 | Local Historic or Cultural Area 19 | 4 | |
8354 | 8354 | 8353 | {"type": "MultiPolygon", "coordinates": [[[[-118.23804, 34.05665], [-118.23761, 34.05703], [-118.23757, 34.05704], [-118.23752, 34.05703], [-118.23751, 34.05698], [-118.23761, 34.05653], [-118.23783, 34.05657], [-118.23804, 34.05665]]], [[[-118.23804, 34.05645], [-118.23761, 34.05638], [-118.23763, 34.05623], [-118.23763, 34.05623], [-118.23804, 34.05645]]], [[[-118.23843, 34.05598], [-118.23816, 34.05631], [-118.23813, 34.05632], [-118.23806, 34.05631], [-118.23784, 34.05617], [-118.23768, 34.05611], [-118.23767, 34.05608], [-118.23775, 34.05566], [-118.23786, 34.05564], [-118.23797, 34.05568], [-118.23843, 34.05598]]], [[[-118.23875, 34.05625], [-118.23891, 34.05628], [-118.23901, 34.05635], [-118.23907, 34.05644], [-118.23909, 34.05655], [-118.23906, 34.05667], [-118.23897, 34.05676], [-118.23885, 34.05682], [-118.23872, 34.05683], [-118.23858, 34.0568], [-118.23849, 34.05673], [-118.23842, 34.05664], [-118.2384, 34.05653], [-118.23842, 34.05643], [-118.2385, 34.05634], [-118.23861, 34.05627], [-118.23875, 34.05625]]]]} | Open Access 1 | 12941 | El Pueblo de Los Angeles Historic Monument | 28788 | 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.002 | El Pueblo de Los Angeles Historic Monument | 0 | Local Historic or Cultural Area 19 | 4 | |
10099 | 10099 | 10098 | {"type": "Polygon", "coordinates": [[[-121.89403, 36.60846], [-121.89279, 36.60845], [-121.89238, 36.60732], [-121.89352, 36.60702], [-121.89403, 36.60846]]]} | Open Access 1 | 17491 | Lower Presidio Historic Park | 21563 | 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 | 3.927 | Lower Presidio Historic Park | 0 | Local Historic or Cultural Area 19 | 4 | |
1928 | 1928 | 1927 | {"type": "Polygon", "coordinates": [[[-121.69947, 38.16059], [-121.69822, 38.1616], [-121.69725, 38.16089], [-121.69786, 38.16039], [-121.69803, 38.16032], [-121.69864, 38.15988], [-121.69947, 38.16059]]]} | Open Access 1 | 14905 | St. Joseph Cemetery | 31581 | 1276 | Rio Vista, City of 327 | City 2 | City Agency 2 | http://riovistacity.com/parks-dept/ | City 2 | 1276 | Rio Vista, City of 324 | City 2 | City Agency 2 | Solano 26 | 4.479 | St. Joseph Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9011 | 9011 | 9010 | {"type": "Polygon", "coordinates": [[[-121.70163, 38.16458], [-121.70079, 38.16524], [-121.69973, 38.16441], [-121.69925, 38.16476], [-121.69829, 38.16404], [-121.69956, 38.16294], [-121.70163, 38.16458]]]} | Open Access 1 | 14918 | Cemetery | 17008 | 1276 | Rio Vista, City of 327 | City 2 | City Agency 2 | http://riovistacity.com/parks-dept/ | City 2 | 1276 | Rio Vista, City of 324 | City 2 | City Agency 2 | Solano 26 | 8.295 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
4225 | 4225 | 4224 | {"type": "Polygon", "coordinates": [[[-118.47891, 34.01843], [-118.47761, 34.01948], [-118.47634, 34.0184], [-118.47499, 34.01949], [-118.47298, 34.01777], [-118.47616, 34.01607], [-118.47891, 34.01843]]]} | Open Access 1 | 29311 | Woodlawn Cemetery | 27728 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 26.5 | Woodlawn Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
6431 | 6431 | 6430 | {"type": "Polygon", "coordinates": [[[-117.23992, 33.11868], [-117.23968, 33.12004], [-117.23953, 33.12006], [-117.23882, 33.12], [-117.23835, 33.11991], [-117.23795, 33.12013], [-117.23771, 33.12034], [-117.23735, 33.12062], [-117.23697, 33.12084], [-117.23701, 33.12088], [-117.23698, 33.12091], [-117.23632, 33.12138], [-117.23525, 33.12035], [-117.23528, 33.12033], [-117.23525, 33.12019], [-117.23525, 33.12012], [-117.23532, 33.11989], [-117.2357, 33.11951], [-117.23574, 33.11935], [-117.23573, 33.11929], [-117.23562, 33.11916], [-117.23573, 33.11901], [-117.23569, 33.11894], [-117.23563, 33.11888], [-117.23551, 33.11886], [-117.23545, 33.11884], [-117.23531, 33.11875], [-117.23541, 33.11845], [-117.23546, 33.11814], [-117.23543, 33.11795], [-117.23535, 33.11772], [-117.23527, 33.11758], [-117.2353, 33.11753], [-117.23553, 33.11743], [-117.23577, 33.11762], [-117.23577, 33.11765], [-117.23599, 33.11774], [-117.23602, 33.11778], [-117.23625, 33.11783], [-117.23627, 33.11786], [-117.23636, 33.11788], [-117.23655, 33.11782], [-117.23665, 33.11761], [-117.23783, 33.11779], [-117.23816, 33.11782], [-117.23812, 33.11828], [-117.23831, 33.11843], [-117.23851, 33.11847], [-117.23868, 33.11847], [-117.23992, 33.11868]]]} | Open Access 1 | 1950 | Leo Carillo Ranch Historic Park | 21165 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/south/carrillo.asp | San Diego 4 | 27.397 | Leo Carillo Ranch Historic Park | 0 | Local Historic or Cultural Area 19 | 4 |
14339 | 14339 | 14338 | {"type": "Polygon", "coordinates": [[[-124.15133, 40.79915], [-124.15105, 40.79916], [-124.15088, 40.79986], [-124.15065, 40.8], [-124.15066, 40.80016], [-124.1508, 40.80014], [-124.15074, 40.80036], [-124.15062, 40.80038], [-124.15061, 40.80046], [-124.15071, 40.80045], [-124.15058, 40.80093], [-124.15051, 40.80095], [-124.15012, 40.80067], [-124.14902, 40.79999], [-124.14903, 40.79819], [-124.14961, 40.79821], [-124.15103, 40.7982], [-124.15132, 40.79816], [-124.15133, 40.79915]]]} | Open Access 1 | 47011 | Myrtle Grove Cemetery | 30645 | 1419 | Eureka, City of 715 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | Humboldt 45 | 10.734 | Myrtle Grove Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2394 | 2394 | 2393 | {"type": "Polygon", "coordinates": [[[-120.45327, 36.85931], [-120.45288, 36.85957], [-120.45288, 36.85961], [-120.45117, 36.85982], [-120.45094, 36.85983], [-120.45032, 36.86], [-120.4499, 36.86022], [-120.44966, 36.86037], [-120.44952, 36.86052], [-120.44829, 36.85938], [-120.44841, 36.85912], [-120.44868, 36.85886], [-120.44889, 36.85862], [-120.44897, 36.85833], [-120.4498, 36.8584], [-120.45047, 36.85836], [-120.45209, 36.85818], [-120.45215, 36.85822], [-120.45327, 36.85931]]]} | Open Access 1 | 18627 | Andrew Firebaugh Historical Park | 15484 | 1107 | Firebaugh, City of 523 | City 2 | City Agency 2 | http://www.ci.firebaugh.ca.us/ | City 2 | 1107 | Firebaugh, City of 516 | City 2 | City Agency 2 | Fresno 9 | 16.635 | Andrew Firebaugh Historical Park | 0 | Local Historic or Cultural Area 19 | 4 | |
8862 | 8862 | 8861 | {"type": "Polygon", "coordinates": [[[-121.93261, 36.63166], [-121.93201, 36.63331], [-121.9294, 36.63268], [-121.92997, 36.63113], [-121.93025, 36.63117], [-121.93046, 36.63118], [-121.93084, 36.63115], [-121.93112, 36.6311], [-121.93131, 36.63103], [-121.9315, 36.63096], [-121.93171, 36.63084], [-121.93261, 36.63166]]]} | Open Access 1 | 14488 | El Carmelo Cemetery | 18487 | 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 | 12.698 | El Carmelo Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
13090 | 13090 | 13089 | {"type": "Polygon", "coordinates": [[[-121.9528, 37.73557], [-121.95073, 37.73637], [-121.94946, 37.73461], [-121.9492, 37.73429], [-121.95111, 37.73302], [-121.95184, 37.73419], [-121.952, 37.73427], [-121.95247, 37.73463], [-121.95246, 37.73468], [-121.9528, 37.73557]]]} | Open Access 1 | 35009 | Forest Home Farms Historic Park | 18994 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 15.479 | Forest Home Farms Historic Park | 0 | Local Historic or Cultural Area 19 | 4 | |
11279 | 11279 | 11278 | {"type": "Polygon", "coordinates": [[[-118.15783, 34.11516], [-118.15741, 34.1155], [-118.15725, 34.11565], [-118.15722, 34.11553], [-118.15722, 34.11543], [-118.15741, 34.11524], [-118.15742, 34.11513], [-118.15783, 34.11513], [-118.15783, 34.11516]]]} | Open Access 1 | 48041 | Ironwork Historical Museum and Park | 32534 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | https://www.southpasadenaca.gov/government/departments/community-services/administration/south-pasadena-historical-museum | Los Angeles 6 | 0.327 | Ironwork Historical Museum and Park | 0 | Local Historic or Cultural Area 19 | 4 |
5930 | 5930 | 5929 | {"type": "Polygon", "coordinates": [[[-120.86721, 37.49685], [-120.86724, 37.50022], [-120.86539, 37.50025], [-120.86542, 37.49801], [-120.86237, 37.49803], [-120.86236, 37.4969], [-120.86415, 37.49687], [-120.8642, 37.49471], [-120.8649, 37.4947], [-120.86489, 37.49284], [-120.86718, 37.49284], [-120.86717, 37.49545], [-120.86721, 37.49685]]]} | Open Access 1 | 431 | Turlock Memorial Park Cemetery | 26582 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 49.361 | Turlock Memorial Park Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1685 | 1685 | 1684 | {"type": "Polygon", "coordinates": [[[-121.59246, 37.01144], [-121.59242, 37.01347], [-121.58778, 37.01342], [-121.58781, 37.0113], [-121.58913, 37.01137], [-121.58934, 37.0114], [-121.59246, 37.01144]]]} | Open Access 1 | 14569 | St. Mary's Cemetery | 25770 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | Santa Clara 19 | 23.292 | St. Mary's Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
8683 | 8683 | 8682 | {"type": "Polygon", "coordinates": [[[-122.32986, 37.56138], [-122.32912, 37.5622], [-122.32894, 37.56233], [-122.32844, 37.56238], [-122.32831, 37.56247], [-122.32823, 37.56284], [-122.32781, 37.56315], [-122.32743, 37.56319], [-122.32742, 37.56305], [-122.32757, 37.56302], [-122.32772, 37.56297], [-122.32787, 37.56289], [-122.328, 37.56279], [-122.32812, 37.56262], [-122.32821, 37.56237], [-122.32832, 37.56226], [-122.32847, 37.56218], [-122.32876, 37.56213], [-122.32893, 37.56205], [-122.32912, 37.56187], [-122.32922, 37.56173], [-122.32935, 37.56164], [-122.32946, 37.56162], [-122.32953, 37.56157], [-122.32957, 37.56149], [-122.32952, 37.5614], [-122.3297, 37.56137], [-122.32986, 37.56138]]]} | Open Access 1 | 14040 | DeAnza Historical Area | 17979 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 1.425 | DeAnza Historical Area | 1940 | Local Historic or Cultural Area 19 | 4 | |
4025 | 4025 | 4024 | {"type": "Polygon", "coordinates": [[[-119.2436, 34.24393], [-119.24298, 34.24398], [-119.24187, 34.24402], [-119.24185, 34.24357], [-119.24184, 34.24356], [-119.24183, 34.24303], [-119.2422, 34.24282], [-119.24288, 34.24238], [-119.24343, 34.24302], [-119.24348, 34.24318], [-119.2436, 34.24393]]]} | Open Access 1 | 46896 | Olivas Adobe Historical Park | 30398 | 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 | 5.374 | Olivas Adobe Historical Park | 0 | Local Historic or Cultural Area 19 | 4 | |
4352 | 4352 | 4351 | {"type": "Polygon", "coordinates": [[[-122.15012, 39.15433], [-122.14972, 39.15449], [-122.1496, 39.15431], [-122.15001, 39.15415], [-122.15012, 39.15433]]]} | Open Access 1 | 45673 | Williams Historic Town Square | 28702 | 1381 | Williams, City of 752 | City 2 | City Agency 2 | http://www.cityofwilliams.org/parks-rec/index.htm | City 2 | 1381 | Williams, City of 738 | City 2 | City Agency 2 | Colusa 49 | 0.22 | Williams Historic Town Square | 0 | Local Historic or Cultural Area 19 | 4 | |
12422 | 12422 | 12421 | {"type": "Polygon", "coordinates": [[[-122.45638, 37.68223], [-122.45632, 37.68224], [-122.45604, 37.68209], [-122.4562, 37.68199], [-122.45636, 37.68214], [-122.45638, 37.68223]]]} | Open Access 1 | 27027 | Colma Historical | 17523 | 1456 | Colma, City of 968 | City 2 | City Agency 2 | http://www.colma.ca.gov/ | City 2 | 1456 | Colma, City of 934 | City 2 | City Agency 2 | San Mateo 15 | 0.098 | Colma Historical | 0 | Local Historic or Cultural Area 19 | 4 | |
1713 | 1713 | 1712 | {"type": "MultiPolygon", "coordinates": [[[[-121.97999, 37.5644], [-121.98024, 37.56435], [-121.9804, 37.56434], [-121.98046, 37.56437], [-121.98049, 37.56446], [-121.98046, 37.56449], [-121.98039, 37.56453], [-121.9797, 37.56477], [-121.97952, 37.56481], [-121.97943, 37.56451], [-121.97999, 37.5644]]], [[[-121.98121, 37.5663], [-121.98119, 37.56634], [-121.98115, 37.56638], [-121.98079, 37.56649], [-121.98073, 37.56649], [-121.98067, 37.56646], [-121.98059, 37.56633], [-121.98044, 37.56604], [-121.98016, 37.56567], [-121.98005, 37.56548], [-121.97984, 37.56491], [-121.97984, 37.56487], [-121.97986, 37.56484], [-121.98051, 37.5646], [-121.98057, 37.5646], [-121.98063, 37.56462], [-121.98078, 37.5648], [-121.98102, 37.56501], [-121.98114, 37.56519], [-121.98121, 37.56537], [-121.98121, 37.56555], [-121.98115, 37.56583], [-121.98113, 37.56599], [-121.98115, 37.56614], [-121.98121, 37.5663]]]]} | Open Access 1 | 12857 | Shin Historic Park | 30828 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 4.615 | Shin Historic Park | 1984 | Local Historic or Cultural Area 19 | 4 | |
2090 | 2090 | 2089 | {"type": "Polygon", "coordinates": [[[-122.05671, 37.55736], [-122.0544, 37.55828], [-122.05314, 37.5588], [-122.04939, 37.56032], [-122.04849, 37.56072], [-122.04831, 37.56073], [-122.04627, 37.56161], [-122.04605, 37.56164], [-122.04542, 37.56193], [-122.04503, 37.56213], [-122.0441, 37.56252], [-122.0439, 37.56253], [-122.04307, 37.56293], [-122.04186, 37.56437], [-122.04173, 37.56445], [-122.04168, 37.56459], [-122.04131, 37.56503], [-122.0412, 37.56504], [-122.04107, 37.56502], [-122.04083, 37.56479], [-122.04047, 37.56459], [-122.0404, 37.56449], [-122.04033, 37.56428], [-122.04031, 37.56414], [-122.04031, 37.56402], [-122.04036, 37.56354], [-122.04036, 37.56327], [-122.0403, 37.56299], [-122.04025, 37.56288], [-122.04027, 37.56275], [-122.0403, 37.56263], [-122.04065, 37.56208], [-122.04081, 37.5619], [-122.04066, 37.56181], [-122.04149, 37.56063], [-122.04314, 37.55856], [-122.04394, 37.5578], [-122.04503, 37.55688], [-122.04532, 37.55689], [-122.04642, 37.55805], [-122.04676, 37.55788], [-122.04654, 37.55734], [-122.04642, 37.55712], [-122.04632, 37.55697], [-122.0459, 37.55665], [-122.04582, 37.55652], [-122.0458, 37.55642], [-122.0468, 37.55556], [-122.04925, 37.55413], [-122.05039, 37.55358], [-122.05071, 37.55347], [-122.0528, 37.5525], [-122.05356, 37.55289], [-122.05494, 37.55332], [-122.05588, 37.55343], [-122.05671, 37.55736]]]} | Open Access 1 | 17282 | Ardenwood Historic Farm | 3820 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/ardenwood | Alameda 17 | 202.709 | Ardenwood Historic Farm | 1985 | Local Historic or Cultural Area 19 | 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]);