units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
116 rows where DES_TP = 19 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, MNG_AG_LEV, COUNTY, YR_EST
MNG_AGENCY >30
- Fremont, City of 6
- Kern, County of 5
- Exeter Cemetery District 3
- Selma Cemetery District 3
- Long Beach, City of 3
- Santa Barbara, County of 2
- Santa Maria Cemetery District 2
- Lindsay-Strathmore Cemetery District 2
- Orange, County of 2
- Riverside, County of 2
- Rio Vista, City of 2
- Mono, County of 2
- Sanger/Del Rey Cemetery District 2
- Merced Cemetery District 2
- Oakdale, City of 1
- San Diego, City of 1
- Los Angeles, County of 1
- Monterey, County of 1
- Los Angeles, City of 1
- San Jose, City of 1
- Monterey, City of 1
- Turlock, City of 1
- Jamestown Cemetery District 1
- Santa Barbara Cemetery Association 1
- Shaws Flat Cemetery District 1
- San Ramon, City of 1
- Oak Grove Cemetery District 1
- Rancho Simi Recreation and Park District 1
- East Bay Regional Park District 1
- San Juan Capistrano, City of 1
- …
MNG_AG_TYP 4
AGNCY_TYP 4 ✖
LAYER 3 ✖
- Special District 57
- City 38
- County 21
ACCESS_TYP 2
- Open Access 113
- Restricted Access 3
DES_TP 1
- Local Historic or Cultural Area · 116 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2909 | 2909 | 2908 | {"type": "Polygon", "coordinates": [[[-120.84105, 37.76305], [-120.84027, 37.76338], [-120.84025, 37.76306], [-120.83825, 37.76356], [-120.83698, 37.76391], [-120.83696, 37.76186], [-120.84023, 37.76187], [-120.84105, 37.76305]]]} | Open Access 1 | 18977 | Oakdale Citizens Cemetery | 23022 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 14.241 | Oakdale Citizens Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
10724 | 10724 | 10723 | {"type": "MultiPolygon", "coordinates": [[[[-117.11649, 32.70594], [-117.11649, 32.7063], [-117.11572, 32.70628], [-117.11532, 32.70631], [-117.11495, 32.70636], [-117.11458, 32.70643], [-117.11421, 32.70653], [-117.11385, 32.70665], [-117.11357, 32.70677], [-117.11306, 32.70703], [-117.11046, 32.70859], [-117.11008, 32.70877], [-117.10962, 32.70894], [-117.10841, 32.70544], [-117.10898, 32.70544], [-117.10905, 32.70531], [-117.10918, 32.70519], [-117.10936, 32.70513], [-117.10958, 32.70512], [-117.10958, 32.70489], [-117.11436, 32.70488], [-117.11437, 32.70556], [-117.11498, 32.70557], [-117.11548, 32.70616], [-117.11575, 32.70615], [-117.11601, 32.70611], [-117.11615, 32.70608], [-117.11649, 32.70594]]], [[[-117.11649, 32.70644], [-117.11649, 32.70802], [-117.11644, 32.70818], [-117.11643, 32.7084], [-117.11641, 32.71134], [-117.11635, 32.71139], [-117.11262, 32.71135], [-117.11043, 32.71131], [-117.10966, 32.70906], [-117.11006, 32.70892], [-117.11054, 32.7087], [-117.11314, 32.70714], [-117.1135, 32.70696], [-117.11387, 32.70679], [-117.1142, 32.70668], [-117.11451, 32.70659], [-117.1151, 32.70648], [-117.11575, 32.70643], [-117.11649, 32.70644]]]]} | Open Access 1 | 19929 | Mt Hope Cemetery | 22573 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 108.763 | Mt Hope Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2224 | 2224 | 2223 | {"type": "MultiPolygon", "coordinates": [[[[-119.78067, 34.4404], [-119.78035, 34.4404], [-119.78034, 34.44016], [-119.78067, 34.44016], [-119.78067, 34.4404]]], [[[-119.78168, 34.43949], [-119.78168, 34.4396], [-119.78068, 34.4396], [-119.78068, 34.43949], [-119.78168, 34.43949]]]]} | Open Access 1 | 16611 | Goleta Cemetery | 19380 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.487 | Goleta Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9587 | 9587 | 9586 | {"type": "Polygon", "coordinates": [[[-120.45155, 34.63055], [-120.45154, 34.63089], [-120.45128, 34.63077], [-120.45087, 34.63037], [-120.45125, 34.63029], [-120.45155, 34.63055]]]} | Open Access 1 | 17395 | Lompoc Cemetery | 21418 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.518 | Lompoc Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
15078 | 15078 | 15077 | {"type": "MultiPolygon", "coordinates": [[[[-118.55697, 34.47401], [-118.55687, 34.47405], [-118.55682, 34.47398], [-118.55671, 34.47402], [-118.55648, 34.47366], [-118.55626, 34.47374], [-118.55607, 34.4736], [-118.55577, 34.47347], [-118.55556, 34.47333], [-118.55558, 34.47306], [-118.55594, 34.4727], [-118.55656, 34.47312], [-118.55676, 34.47328], [-118.55694, 34.47345], [-118.55684, 34.47354], [-118.55681, 34.47366], [-118.55686, 34.47383], [-118.55697, 34.47401]]], [[[-118.55698, 34.47342], [-118.55697, 34.47342], [-118.55694, 34.47339], [-118.55695, 34.47339], [-118.55698, 34.47342]]]]} | Open Access 1 | 45858 | Tesoro Adobe Historic Park | 28905 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Tesoro_Adobe_Historic_Park | Los Angeles 6 | 2.26 | Tesoro Adobe Historic Park | 0 | Local Historic or Cultural Area 19 | 4 |
10247 | 10247 | 10246 | {"type": "MultiPolygon", "coordinates": [[[[-121.62949, 36.69255], [-121.62807, 36.69314], [-121.62759, 36.69261], [-121.62828, 36.69163], [-121.62949, 36.69255]]], [[[-121.63889, 36.69555], [-121.63869, 36.6957], [-121.63826, 36.69613], [-121.63693, 36.69582], [-121.6374, 36.69534], [-121.63679, 36.69491], [-121.63689, 36.69488], [-121.63697, 36.69493], [-121.63754, 36.69473], [-121.63767, 36.69474], [-121.63889, 36.69555]]]]} | Open Access 1 | 17939 | Monterey County Cemetery | 22419 | 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 | 7.401 | Monterey County Cemetery | 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 | |
3577 | 3577 | 3576 | {"type": "Polygon", "coordinates": [[[-121.90718, 37.34301], [-121.90614, 37.34373], [-121.90546, 37.34312], [-121.90653, 37.3424], [-121.90718, 37.34301]]]} | Open Access 1 | 29148 | Historic Orchard | 20007 | 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 | 2.747 | Historic Orchard | 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 | |
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 | |
173 | 173 | 172 | {"type": "Polygon", "coordinates": [[[-120.4259, 37.94699], [-120.42564, 37.9476], [-120.4255, 37.94811], [-120.42551, 37.94822], [-120.42504, 37.94841], [-120.42471, 37.94817], [-120.42435, 37.94782], [-120.42412, 37.94745], [-120.42349, 37.94692], [-120.42464, 37.94646], [-120.42483, 37.94685], [-120.42539, 37.94659], [-120.42558, 37.94679], [-120.4259, 37.94699]]]} | Open Access 1 | 548 | Cemetery | 17011 | 2050 | Jamestown Cemetery District 66 | Special District 4 | Cemetery District 11 | Special District 4 | 2050 | Jamestown Cemetery District 64 | Special District 4 | Cemetery District 11 | Tuolumne 21 | 6.082 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
175 | 175 | 174 | {"type": "Polygon", "coordinates": [[[-119.65914, 34.41998], [-119.65807, 34.4201], [-119.65671, 34.42044], [-119.65662, 34.42048], [-119.65651, 34.42056], [-119.65592, 34.42119], [-119.65575, 34.42131], [-119.65555, 34.42137], [-119.65541, 34.42139], [-119.65297, 34.42138], [-119.65294, 34.42134], [-119.65294, 34.41914], [-119.65261, 34.41913], [-119.65261, 34.41724], [-119.65352, 34.41719], [-119.65403, 34.41712], [-119.65457, 34.41717], [-119.65502, 34.41711], [-119.65526, 34.41712], [-119.65548, 34.41708], [-119.65595, 34.41711], [-119.65614, 34.41706], [-119.65649, 34.41705], [-119.65687, 34.41702], [-119.65729, 34.41703], [-119.65751, 34.41701], [-119.65793, 34.41701], [-119.65827, 34.41698], [-119.6587, 34.41702], [-119.65912, 34.41699], [-119.65914, 34.41998]]]} | Open Access 1 | 481 | Santa Barbara Cemetery | 25039 | 2140 | Santa Barbara Cemetery Association 67 | Special District 4 | Cemetery District 11 | Special District 4 | 2140 | Santa Barbara Cemetery Association 65 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 59.983 | Santa Barbara Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
180 | 180 | 179 | {"type": "Polygon", "coordinates": [[[-120.42711, 34.93148], [-120.42706, 34.93392], [-120.42702, 34.93833], [-120.42498, 34.93831], [-120.42501, 34.93448], [-120.42505, 34.93211], [-120.42507, 34.93195], [-120.42508, 34.93153], [-120.42511, 34.93149], [-120.42515, 34.93147], [-120.42711, 34.93148]]]} | Open Access 1 | 568 | Santa Maria Cemetery | 25103 | 2145 | Santa Maria Cemetery District 68 | Special District 4 | Cemetery District 11 | http://www.countyofsb.org/pwd/pwsurveyor.aspx | Special District 4 | 2145 | Santa Maria Cemetery District 66 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 35.019 | Santa Maria Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2368 | 2368 | 2367 | {"type": "Polygon", "coordinates": [[[-120.41878, 34.85391], [-120.41878, 34.85526], [-120.41827, 34.85526], [-120.41827, 34.85391], [-120.41878, 34.85391]]]} | Open Access 1 | 18541 | Pine Grove Cemetery | 23677 | 2145 | Santa Maria Cemetery District 68 | Special District 4 | Cemetery District 11 | http://www.countyofsb.org/pwd/pwsurveyor.aspx | Special District 4 | 2145 | Santa Maria Cemetery District 66 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 1.717 | Pine Grove Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
182 | 182 | 181 | {"type": "Polygon", "coordinates": [[[-120.40136, 38.00555], [-120.40072, 38.00607], [-120.40064, 38.00615], [-120.40061, 38.00621], [-120.40038, 38.00615], [-120.40036, 38.00603], [-120.39992, 38.00605], [-120.39963, 38.00604], [-120.40009, 38.00557], [-120.40036, 38.00524], [-120.40055, 38.00505], [-120.40073, 38.00515], [-120.40136, 38.00555]]]} | Open Access 1 | 579 | Cemetery | 17015 | 2150 | Shaws Flat Cemetery District 69 | Special District 4 | Cemetery District 11 | Special District 4 | 2150 | Shaws Flat Cemetery District 67 | Special District 4 | Cemetery District 11 | Tuolumne 21 | 2.301 | 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 | |
184 | 184 | 183 | {"type": "Polygon", "coordinates": [[[-120.2455, 37.82767], [-120.24545, 37.82809], [-120.24528, 37.82907], [-120.24525, 37.82917], [-120.24352, 37.82889], [-120.24371, 37.82745], [-120.2455, 37.82767]]]} | Open Access 1 | 561 | Cemetery | 17014 | 2098 | Oak Grove Cemetery District 71 | Special District 4 | Cemetery District 11 | Special District 4 | 2098 | Oak Grove Cemetery District 69 | Special District 4 | Cemetery District 11 | Tuolumne 21 | 6.428 | Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
389 | 389 | 388 | {"type": "Polygon", "coordinates": [[[-118.80196, 34.27578], [-118.801, 34.27578], [-118.80023, 34.27408], [-118.80034, 34.2741], [-118.80041, 34.27419], [-118.80046, 34.27422], [-118.80057, 34.27424], [-118.80064, 34.27422], [-118.80071, 34.27418], [-118.80074, 34.27413], [-118.80076, 34.27408], [-118.80183, 34.27407], [-118.80196, 34.27578]]]} | Open Access 1 | 1158 | Strathearn Historical Park & Museum | 25908 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 5.386 | Strathearn Historical Park & Museum | 0 | 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 |
2454 | 2454 | 2453 | {"type": "Polygon", "coordinates": [[[-117.66179, 33.49999], [-117.66168, 33.50071], [-117.66109, 33.50064], [-117.66106, 33.50059], [-117.66064, 33.50046], [-117.6607, 33.5], [-117.66083, 33.50002], [-117.66099, 33.49984], [-117.66179, 33.49999]]]} | Open Access 1 | 12330 | Historic Town Center (HTC) Park | 20008 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 1.879 | Historic Town Ctr. (HTC) Park | 0 | 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]);