units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where COUNTY = 14 and MNG_AG_TYP = 4 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, MNG_AG_ID, GAP_STS
DES_TP 12
- Local Park 13
- Local Recreation Area 6
- Local Conservation Area 4
- Local Other or Unknown 4
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 6
ACCESS_TYP 4
MNG_AG_TYP 1
- Recreation/Parks District · 35 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3783 | 3783 | 3782 | {"type": "Polygon", "coordinates": [[[-121.75364, 36.487], [-121.75279, 36.48783], [-121.7518, 36.48836], [-121.75076, 36.4881], [-121.75052, 36.48825], [-121.75067, 36.48844], [-121.7499, 36.48882], [-121.74643, 36.48407], [-121.74641, 36.484], [-121.74643, 36.48389], [-121.74641, 36.48383], [-121.74632, 36.48377], [-121.74621, 36.48377], [-121.74493, 36.48202], [-121.74586, 36.48073], [-121.75297, 36.48553], [-121.75243, 36.48657], [-121.75263, 36.48678], [-121.75293, 36.48659], [-121.75364, 36.487]]]} | Unknown Access 4 | 8686 | Condon | 17579 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 70.591 | Condon | None 317 | |||
3817 | 3817 | 3816 | {"type": "Polygon", "coordinates": [[[-121.80256, 36.69071], [-121.80064, 36.68954], [-121.8013, 36.68878], [-121.8017, 36.68905], [-121.80185, 36.68917], [-121.80204, 36.68937], [-121.80221, 36.68959], [-121.80238, 36.6899], [-121.80249, 36.69019], [-121.80254, 36.69043], [-121.80256, 36.69071]]]} | Open Access 1 | 35194 | Monterey Peninsula Regional Park District 4 | 22427 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.919 | Monterey Peninsula RP District 4 | None 320 | |||
9783 | 9783 | 9782 | {"type": "Polygon", "coordinates": [[[-121.80988, 36.70244], [-121.80939, 36.70557], [-121.80456, 36.70389], [-121.80313, 36.70304], [-121.80425, 36.70156], [-121.80449, 36.7013], [-121.80495, 36.70084], [-121.80501, 36.70057], [-121.80505, 36.70049], [-121.80988, 36.70244]]]} | Open Access 1 | 16656 | Granite Rock Dunes | 19432 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 47.054 | Granite Rock Dunes | None 846 | |||
10524 | 10524 | 10523 | {"type": "Polygon", "coordinates": [[[-121.93787, 36.63113], [-121.93781, 36.6314], [-121.93762, 36.63138], [-121.93738, 36.63147], [-121.93734, 36.63155], [-121.93718, 36.63165], [-121.9368, 36.63156], [-121.93686, 36.63115], [-121.93738, 36.6312], [-121.9375, 36.63109], [-121.93787, 36.63113]]]} | Open Access 1 | 18717 | Point Pinos | 23857 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 0.9 | Point Pinos | None 920 | |||
13203 | 13203 | 13202 | {"type": "Polygon", "coordinates": [[[-121.80186, 36.69126], [-121.8018, 36.69183], [-121.80169, 36.69184], [-121.80121, 36.69177], [-121.80105, 36.69183], [-121.80105, 36.69187], [-121.8004, 36.69199], [-121.79878, 36.69216], [-121.7988, 36.69187], [-121.7988, 36.69171], [-121.79991, 36.69038], [-121.80005, 36.69047], [-121.79996, 36.69061], [-121.79989, 36.6908], [-121.79987, 36.691], [-121.79991, 36.69115], [-121.79995, 36.69126], [-121.80003, 36.69139], [-121.80012, 36.69149], [-121.80029, 36.6916], [-121.80043, 36.69166], [-121.80171, 36.69145], [-121.80186, 36.69126]]]} | Open Access 1 | 35197 | Monterey Peninsula Regional Park District 1 | 22424 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 4.709 | Monterey Peninsula RP District 1 | None 1150 | |||
16133 | 16133 | 16132 | {"type": "Polygon", "coordinates": [[[-121.80227, 36.69054], [-121.80211, 36.69072], [-121.80203, 36.69079], [-121.80191, 36.69085], [-121.80192, 36.69099], [-121.80186, 36.69184], [-121.8018, 36.69183], [-121.80185, 36.69128], [-121.80171, 36.69145], [-121.80043, 36.69166], [-121.80029, 36.6916], [-121.80012, 36.69148], [-121.79999, 36.69134], [-121.79995, 36.69126], [-121.79989, 36.69107], [-121.79987, 36.69092], [-121.79989, 36.6908], [-121.79996, 36.69061], [-121.80005, 36.69048], [-121.79991, 36.69038], [-121.80064, 36.68954], [-121.80227, 36.69054]]]} | Open Access 1 | 35174 | Monterey Peninsula Regional Park District 2 | 22425 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 8.039 | Monterey Peninsula RP District 2 | None 1387 | |||
16147 | 16147 | 16146 | {"type": "Polygon", "coordinates": [[[-121.80932, 36.70606], [-121.80931, 36.70614], [-121.80262, 36.70368], [-121.80266, 36.70362], [-121.80932, 36.70606]]]} | Open Access 1 | 35195 | Monterey Peninsula Regional Park District 3 | 22426 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 1.319 | Monterey Peninsula RP District 3 | None 1388 | |||
16195 | 16195 | 16194 | {"type": "Polygon", "coordinates": [[[-121.80939, 36.70557], [-121.80932, 36.70606], [-121.80266, 36.70362], [-121.80313, 36.70304], [-121.80456, 36.70389], [-121.80939, 36.70557]]]} | Open Access 1 | 35196 | Monterey Peninsula Regional Park District 5 | 22428 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 8.017 | Monterey Peninsula RP District 5 | None 1393 | |||
112 | 112 | 111 | {"type": "MultiPolygon", "coordinates": [[[[-121.89676, 36.61064], [-121.89648, 36.61079], [-121.89639, 36.61069], [-121.8964, 36.61049], [-121.89638, 36.61044], [-121.89628, 36.61029], [-121.89611, 36.6101], [-121.89602, 36.61002], [-121.89595, 36.61], [-121.8958, 36.61], [-121.89572, 36.60995], [-121.8956, 36.60978], [-121.89551, 36.6097], [-121.89543, 36.60948], [-121.89573, 36.60943], [-121.89676, 36.61064]]], [[[-121.89709, 36.61029], [-121.89683, 36.61043], [-121.89595, 36.60939], [-121.89629, 36.60934], [-121.89709, 36.61029]]]]} | Open Access 1 | 327 | San Carlos Beach Park | 24846 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 1.92 | San Carlos Beach Park | 0 | Local Park 2 | 4 | |
2068 | 2068 | 2067 | {"type": "Polygon", "coordinates": [[[-121.93333, 36.50126], [-121.93326, 36.50153], [-121.93266, 36.50142], [-121.93222, 36.50144], [-121.93206, 36.50171], [-121.93202, 36.50193], [-121.93202, 36.50211], [-121.93237, 36.50231], [-121.93186, 36.50242], [-121.93146, 36.50254], [-121.93119, 36.50253], [-121.93114, 36.50254], [-121.93127, 36.50272], [-121.93136, 36.50297], [-121.93161, 36.5032], [-121.93153, 36.50331], [-121.93128, 36.50335], [-121.93096, 36.50323], [-121.93074, 36.50311], [-121.93058, 36.50294], [-121.93043, 36.50283], [-121.93107, 36.50243], [-121.93107, 36.50242], [-121.93099, 36.50237], [-121.93084, 36.50218], [-121.93118, 36.50214], [-121.9312, 36.50217], [-121.9315, 36.50207], [-121.93171, 36.50176], [-121.93173, 36.50144], [-121.93207, 36.50111], [-121.9323, 36.50095], [-121.93268, 36.50063], [-121.93302, 36.50082], [-121.93284, 36.50113], [-121.93333, 36.50126]]]} | Restricted Access 2 | 17207 | Laidlaw-Apte Pine Forest Reserve | 20872 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 4.771 | Laidlaw-Apte Pine Forest Reserve | 0 | Local Conservation Area 4 | 2 | |
2591 | 2591 | 2590 | {"type": "MultiPolygon", "coordinates": [[[[-121.89718, 36.61024], [-121.89709, 36.61029], [-121.89629, 36.60934], [-121.8964, 36.60932], [-121.89718, 36.61024]]], [[[-121.89804, 36.61126], [-121.89796, 36.61131], [-121.89719, 36.6104], [-121.89727, 36.61035], [-121.89804, 36.61126]]], [[[-121.89857, 36.61213], [-121.89845, 36.6122], [-121.89841, 36.61202], [-121.89831, 36.61179], [-121.89821, 36.61162], [-121.89805, 36.61143], [-121.89816, 36.61137], [-121.89831, 36.61155], [-121.89846, 36.6118], [-121.89852, 36.61194], [-121.89857, 36.61213]]], [[[-121.89976, 36.61454], [-121.8996, 36.61463], [-121.89874, 36.61359], [-121.89862, 36.61339], [-121.89853, 36.61314], [-121.8985, 36.61297], [-121.89847, 36.61266], [-121.89862, 36.61283], [-121.89864, 36.61302], [-121.89868, 36.61318], [-121.89875, 36.61336], [-121.89886, 36.61355], [-121.89942, 36.61422], [-121.89947, 36.6142], [-121.89976, 36.61454]]], [[[-121.90075, 36.61569], [-121.90057, 36.61579], [-121.89971, 36.61477], [-121.89987, 36.61468], [-121.90006, 36.61489], [-121.90008, 36.61489], [-121.90075, 36.61569]]], [[[-121.90167, 36.61684], [-121.90153, 36.61692], [-121.90067, 36.6159], [-121.9008, 36.61582], [-121.90167, 36.61684]]], [[[-121.90242, 36.6177], [-121.90225, 36.61776], [-121.90163, 36.61703], [-121.90177, 36.61695], [-121.90242, 36.6177]]], [[[-121.90324, 36.61833], [-121.90322, 36.61834], [-121.90314, 36.61831], [-121.903, 36.61821], [-121.90291, 36.61811], [-121.90302, 36.61806], [-121.90324, 36.61833]]]]} | Open Access 1 | 17932 | Monterey Bay Coastal Trail | 22417 | 2084 | Monterey Peninsula Recreational Trail Joint Powers 537 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2084 | Monterey Peninsula Recreational Trail Joint Powers 530 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.184 | Monterey Bay Coastal Trail | 0 | Local Recreation Area 3 | 4 | ||
2666 | 2666 | 2665 | {"type": "Polygon", "coordinates": [[[-121.21401, 36.33581], [-121.21125, 36.33739], [-121.2107, 36.33678], [-121.2099, 36.33723], [-121.2097, 36.3372], [-121.20858, 36.33591], [-121.21228, 36.33384], [-121.21401, 36.33581]]]} | Open Access 1 | 18207 | Oak Park | 30778 | 2042 | Greenfield Public Recreation District 542 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2042 | Greenfield Public Recreation District 535 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 24.875 | Oak Park | 0 | Local Park 2 | 4 | ||
3741 | 3741 | 3740 | {"type": "Polygon", "coordinates": [[[-121.909, 36.51865], [-121.90875, 36.51885], [-121.90885, 36.51911], [-121.90865, 36.51936], [-121.90826, 36.5196], [-121.90811, 36.51967], [-121.90807, 36.51973], [-121.90716, 36.52011], [-121.90656, 36.52042], [-121.90615, 36.52045], [-121.90555, 36.52056], [-121.90501, 36.52079], [-121.9046, 36.52107], [-121.90365, 36.52139], [-121.9025, 36.52232], [-121.90225, 36.5224], [-121.90144, 36.52252], [-121.90107, 36.52238], [-121.90084, 36.52241], [-121.90066, 36.52256], [-121.90048, 36.52259], [-121.89827, 36.52246], [-121.89696, 36.52232], [-121.89571, 36.51565], [-121.8964, 36.51259], [-121.89768, 36.51305], [-121.89768, 36.5118], [-121.90218, 36.51185], [-121.90218, 36.50821], [-121.90668, 36.50827], [-121.90669, 36.51191], [-121.90662, 36.51654], [-121.909, 36.51865]]]} | Restricted Access 2 | 44849 | Whisler-Wilson Ranch | 28252 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 306.464 | Whisler-Wilson Ranch | 0 | Local Other or Unknown 14 | 4 | |
4221 | 4221 | 4220 | {"type": "Polygon", "coordinates": [[[-121.75105, 36.77086], [-121.75056, 36.77128], [-121.75044, 36.77119], [-121.75059, 36.77105], [-121.75051, 36.7709], [-121.75078, 36.77066], [-121.75105, 36.77086]]]} | Open Access 1 | 45005 | Crane Street Park | 17759 | 2094 | North County Recreation and Park District 733 | Special District 4 | Recreation/Parks District 4 | http://www.ncrpd.org | Special District 4 | 2094 | North County Recreation and Park District 717 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 0.405 | Crane Street Park | 0 | Local Park 2 | 4 | |
4687 | 4687 | 4686 | {"type": "Polygon", "coordinates": [[[-121.32025, 36.42989], [-121.32025, 36.43031], [-121.31912, 36.4303], [-121.31914, 36.42962], [-121.31995, 36.42962], [-121.31996, 36.42988], [-121.32025, 36.42989]]]} | Open Access 1 | 43092 | Unknown park - Soledad-Mission Recreation District | 28668 | 2154 | Soledad-Mission Recreation District 775 | Special District 4 | Recreation/Parks District 4 | http://www.soledad-mission-recreation-district.org/ | Special District 4 | 2154 | Soledad-Mission Recreation District 756 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 1.687 | 0 | Local Other or Unknown 14 | 4 | ||
5811 | 5811 | 5810 | {"type": "Polygon", "coordinates": [[[-121.86002, 36.60779], [-121.85928, 36.6088], [-121.85829, 36.60932], [-121.85798, 36.6093], [-121.85783, 36.60901], [-121.86002, 36.60779]]]} | Open Access 1 | 114 | Roberts Lake Open Space | 24493 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 2.374 | Roberts Lake OS | 0 | Local Recreation Area 3 | 4 | |
6096 | 6096 | 6095 | {"type": "MultiPolygon", "coordinates": [[[[-121.8696, 36.60282], [-121.86947, 36.60286], [-121.86935, 36.60264], [-121.86947, 36.60259], [-121.8696, 36.60282]]], [[[-121.8699, 36.60337], [-121.86965, 36.60346], [-121.86953, 36.60324], [-121.86977, 36.60314], [-121.86965, 36.60292], [-121.86978, 36.60288], [-121.8699, 36.6031], [-121.86978, 36.60315], [-121.8699, 36.60337]]], [[[-121.8704, 36.60292], [-121.87028, 36.60297], [-121.87015, 36.60274], [-121.87027, 36.6027], [-121.8704, 36.60292]]], [[[-121.87059, 36.60246], [-121.87047, 36.6025], [-121.87034, 36.60228], [-121.87047, 36.60224], [-121.87059, 36.60246]]], [[[-121.87065, 36.60283], [-121.87052, 36.60288], [-121.8704, 36.60265], [-121.87052, 36.60261], [-121.87065, 36.60283]]]]} | Open Access 1 | 980 | South Monterey Dunes Beach | 25666 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 0.582 | South Monterey Dunes Beach | 0 | Local Park 2 | 4 | |
6193 | 6193 | 6192 | {"type": "Polygon", "coordinates": [[[-121.56192, 36.44252], [-121.55756, 36.4424], [-121.55754, 36.43877], [-121.54888, 36.43855], [-121.54884, 36.44575], [-121.53978, 36.4455], [-121.53984, 36.4346], [-121.53079, 36.43424], [-121.53081, 36.43057], [-121.53085, 36.42693], [-121.53987, 36.42728], [-121.53986, 36.43096], [-121.5489, 36.43134], [-121.54889, 36.43494], [-121.56186, 36.43525], [-121.56192, 36.44252]]]} | Restricted Access 2 | 18578 | Bloomquist Open Space | 16170 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 639.336 | Bloomquist OS | 0 | Local Recreation Area 3 | 4 | |
6224 | 6224 | 6223 | {"type": "Polygon", "coordinates": [[[-121.66224, 36.3959], [-121.66236, 36.39661], [-121.66237, 36.39721], [-121.66237, 36.39773], [-121.66229, 36.39814], [-121.66186, 36.3987], [-121.66126, 36.39891], [-121.66119, 36.39901], [-121.65937, 36.39814], [-121.66011, 36.39708], [-121.66037, 36.397], [-121.6606, 36.39685], [-121.66077, 36.39667], [-121.66087, 36.39648], [-121.66136, 36.39636], [-121.66186, 36.39615], [-121.66198, 36.39616], [-121.66224, 36.3959]]]} | Open Access 1 | 1288 | Cachagua Community Park | 16647 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 13.535 | Cachagua Community Park | 0 | Local Park 2 | 4 | |
6263 | 6263 | 6262 | {"type": "Polygon", "coordinates": [[[-121.79058, 36.52123], [-121.79045, 36.52142], [-121.79048, 36.52155], [-121.79052, 36.52163], [-121.79026, 36.52171], [-121.7886, 36.52066], [-121.78871, 36.52058], [-121.78783, 36.5197], [-121.78919, 36.51943], [-121.7892, 36.51992], [-121.78948, 36.52042], [-121.78993, 36.52087], [-121.79025, 36.52083], [-121.79058, 36.52123]]]} | No Public Access 3 | 1348 | Thomas Open Space | 26308 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 5.313 | Thomas OS | 0 | Local Recreation Area 3 | 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]);