units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where MNG_AGENCY = 481 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, ACRES, LABEL_NAME, YR_EST
DES_TP 7
- Local Park 54
- Local Recreation Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 61
MNG_AGENCY 1
- Manteca, City of · 61 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16401 | 16401 | 16400 | {"type": "Polygon", "coordinates": [[[-121.22007, 37.79923], [-121.22006, 37.79965], [-121.21962, 37.79965], [-121.21962, 37.79923], [-121.22007, 37.79923]]]} | Open Access 1 | 24705 | Center St Tennis Courts | 17039 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 0.461 | Ctr. St Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
14821 | 14821 | 14820 | {"type": "Polygon", "coordinates": [[[-121.21025, 37.77704], [-121.21027, 37.77717], [-121.21023, 37.77727], [-121.21013, 37.77738], [-121.20999, 37.77744], [-121.20984, 37.77746], [-121.20966, 37.77742], [-121.20953, 37.77732], [-121.20946, 37.77719], [-121.20946, 37.77709], [-121.20951, 37.77697], [-121.20962, 37.77688], [-121.20976, 37.77682], [-121.2099, 37.77681], [-121.21005, 37.77685], [-121.21019, 37.77694], [-121.21025, 37.77704]]]} | Open Access 1 | 47255 | Paseo Circle Park | 30966 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 0.978 | Paseo Circle Park | 0 | Local Park 2 | 4 | |
14381 | 14381 | 14380 | {"type": "Polygon", "coordinates": [[[-121.23587, 37.83149], [-121.2358, 37.83155], [-121.23512, 37.83155], [-121.2348, 37.83158], [-121.23466, 37.83161], [-121.2344, 37.83169], [-121.23427, 37.83159], [-121.23276, 37.8316], [-121.23141, 37.8321], [-121.23134, 37.83202], [-121.23124, 37.83197], [-121.231, 37.83198], [-121.22943, 37.83185], [-121.22939, 37.83184], [-121.22937, 37.8318], [-121.22942, 37.8314], [-121.22949, 37.83122], [-121.22957, 37.83112], [-121.22968, 37.83103], [-121.22987, 37.83094], [-121.23001, 37.8309], [-121.23016, 37.83089], [-121.23139, 37.83088], [-121.23167, 37.83086], [-121.23213, 37.83079], [-121.23263, 37.83064], [-121.2327, 37.83067], [-121.23283, 37.8309], [-121.2329, 37.8311], [-121.23296, 37.83115], [-121.23304, 37.83117], [-121.23305, 37.83145], [-121.23587, 37.83146], [-121.23587, 37.83149]]]} | Open Access 1 | 44474 | Union Ranch East Park | 32970 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 9.62 | Union Ranch East Park | 0 | Local Park 2 | 4 | |
14378 | 14378 | 14377 | {"type": "Polygon", "coordinates": [[[-121.26138, 37.79009], [-121.25703, 37.79011], [-121.25702, 37.78656], [-121.25703, 37.78652], [-121.25707, 37.78649], [-121.25712, 37.78648], [-121.26036, 37.78647], [-121.26065, 37.7865], [-121.26089, 37.78657], [-121.26113, 37.78666], [-121.26137, 37.78679], [-121.26138, 37.79009]]]} | Open Access 1 | 44470 | Big League Dreams Park | 16080 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 37.84 | Big League Dreams Park | 0 | Local Park 2 | 4 | |
13694 | 13694 | 13693 | {"type": "Polygon", "coordinates": [[[-121.2821, 37.8378], [-121.28209, 37.83823], [-121.28203, 37.8386], [-121.28181, 37.83922], [-121.2817, 37.83927], [-121.28147, 37.83925], [-121.27935, 37.83923], [-121.27926, 37.83916], [-121.27926, 37.83863], [-121.27921, 37.83832], [-121.2791, 37.83806], [-121.27894, 37.83782], [-121.2821, 37.8378]]]} | Open Access 1 | 36065 | Apolinar Sangalang | 15536 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 9.745 | Apolinar Sangalang | None 1178 | |||
13693 | 13693 | 13692 | {"type": "MultiPolygon", "coordinates": [[[[-121.21616, 37.79541], [-121.21614, 37.79551], [-121.21608, 37.79553], [-121.21572, 37.79539], [-121.21485, 37.79488], [-121.21484, 37.79484], [-121.21353, 37.79407], [-121.21372, 37.79384], [-121.21159, 37.79259], [-121.21138, 37.7928], [-121.20766, 37.79062], [-121.20785, 37.79039], [-121.2015, 37.78665], [-121.20149, 37.78648], [-121.21614, 37.79509], [-121.21616, 37.79541]]], [[[-121.21703, 37.79583], [-121.21651, 37.79553], [-121.21651, 37.79547], [-121.21703, 37.79577], [-121.21703, 37.79583]]], [[[-121.21762, 37.79618], [-121.2171, 37.79588], [-121.2171, 37.79581], [-121.21762, 37.79612], [-121.21762, 37.79618]]], [[[-121.21966, 37.79732], [-121.21948, 37.79732], [-121.21908, 37.79703], [-121.21781, 37.79629], [-121.2178, 37.79623], [-121.21966, 37.79732]]], [[[-121.22247, 37.79901], [-121.22206, 37.79901], [-121.22028, 37.79796], [-121.22028, 37.79785], [-121.22008, 37.79774], [-121.22011, 37.7977], [-121.22145, 37.79848], [-121.2215, 37.79844], [-121.22247, 37.79901]]], [[[-121.22609, 37.80464], [-121.22574, 37.80466], [-121.22564, 37.80175], [-121.2256, 37.80152], [-121.22552, 37.8013], [-121.2254, 37.8011], [-121.22533, 37.80109], [-121.22532, 37.80093], [-121.22287, 37.79949], [-121.22287, 37.79923], [-121.22291, 37.79923], [-121.22416, 37.79997], [-121.22446, 37.79997], [-121.22596, 37.80086], [-121.22609, 37.80464]]], [[[-121.22634, 37.81181], [-121.22599, 37.81181], [-121.2259, 37.80905], [-121.22575, 37.80482], [-121.22609, 37.8048], [-121.22634, 37.81181]]], [[[-121.22663, 37.81895], [-121.22628, 37.81895], [-121.226, 37.81204], [-121.22635, 37.81204], [-121.22663, 37.81895]]], [[[-121.22693, 37.82634], [-121.22658, 37.82634], [-121.22629, 37.81918], [-121.22663, 37.81918], [-121.22664, 37.8192], [-121.22655, 37.81921], [-121.22673, 37.82364], [-121.22682, 37.82365], [-121.22693, 37.82634]]]]} | Open Access 1 | 36063 | Tidewater Bikeway | 26349 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 35.162 | Tidewater Bikeway | None 1177 | |||
13690 | 13690 | 13689 | {"type": "Polygon", "coordinates": [[[-121.26434, 37.77727], [-121.2643, 37.7773], [-121.26279, 37.77758], [-121.26273, 37.77757], [-121.2627, 37.77753], [-121.2627, 37.77614], [-121.26277, 37.7761], [-121.26424, 37.77609], [-121.26429, 37.77611], [-121.26431, 37.77614], [-121.26432, 37.77709], [-121.26434, 37.77727]]]} | Open Access 1 | 36062 | Dutra Estates Park | 18321 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 5.252 | Dutra Estates Park | 0 | Local Park 2 | 4 | |
13689 | 13689 | 13688 | {"type": "Polygon", "coordinates": [[[-121.19597, 37.77707], [-121.19556, 37.77889], [-121.19543, 37.7792], [-121.19507, 37.77908], [-121.19475, 37.77889], [-121.19452, 37.7787], [-121.19422, 37.77836], [-121.19399, 37.77815], [-121.19376, 37.77799], [-121.19301, 37.77755], [-121.19287, 37.77743], [-121.19287, 37.7774], [-121.19289, 37.77737], [-121.19301, 37.77732], [-121.19322, 37.77722], [-121.19355, 37.7771], [-121.19373, 37.77709], [-121.19396, 37.77716], [-121.19409, 37.77716], [-121.1942, 37.77711], [-121.19437, 37.77698], [-121.19452, 37.77694], [-121.19483, 37.77693], [-121.19515, 37.77695], [-121.19597, 37.77707]]]} | Open Access 1 | 36061 | Tesoro Park | 26270 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 9.456 | Tesoro Park | 0 | Local Park 2 | 4 | |
13688 | 13688 | 13687 | {"type": "Polygon", "coordinates": [[[-121.23203, 37.77687], [-121.23209, 37.7769], [-121.23222, 37.77703], [-121.23228, 37.77715], [-121.23231, 37.77728], [-121.23232, 37.77858], [-121.23225, 37.77861], [-121.231, 37.77862], [-121.23097, 37.77861], [-121.23094, 37.77856], [-121.23093, 37.7773], [-121.23094, 37.77728], [-121.23098, 37.77725], [-121.23129, 37.77721], [-121.23148, 37.77716], [-121.2317, 37.77706], [-121.23203, 37.77687]]]} | Open Access 1 | 36060 | Antigua Park | 15518 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 5.062 | Antigua Park | 0 | Local Park 2 | 4 | |
13687 | 13687 | 13686 | {"type": "MultiPolygon", "coordinates": [[[[-121.19186, 37.80789], [-121.19129, 37.80837], [-121.18944, 37.80838], [-121.18944, 37.80832], [-121.18948, 37.80828], [-121.18988, 37.80827], [-121.19015, 37.80824], [-121.19041, 37.8082], [-121.19082, 37.8081], [-121.19167, 37.80777], [-121.19173, 37.80778], [-121.19186, 37.80789]]], [[[-121.19492, 37.80707], [-121.19478, 37.8073], [-121.19463, 37.80736], [-121.19459, 37.80745], [-121.19451, 37.80745], [-121.19443, 37.80749], [-121.19435, 37.80743], [-121.1935, 37.80763], [-121.19295, 37.80768], [-121.19295, 37.80796], [-121.19246, 37.80796], [-121.19228, 37.80793], [-121.19206, 37.80785], [-121.19196, 37.80778], [-121.19186, 37.80769], [-121.19374, 37.80724], [-121.19402, 37.80724], [-121.19402, 37.80697], [-121.19421, 37.80697], [-121.19446, 37.807], [-121.19473, 37.80711], [-121.19482, 37.80711], [-121.19492, 37.80707]]]]} | Open Access 1 | 36058 | Sierra Creek Park | 25452 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 3.857 | Sierra Creek Park | 0 | Local Park 2 | 4 | |
13685 | 13685 | 13684 | {"type": "Polygon", "coordinates": [[[-121.19669, 37.80654], [-121.19659, 37.80654], [-121.19656, 37.8066], [-121.19662, 37.80685], [-121.19659, 37.8069], [-121.19511, 37.80739], [-121.19479, 37.8073], [-121.19528, 37.80649], [-121.19539, 37.80634], [-121.19557, 37.80615], [-121.19585, 37.80592], [-121.19593, 37.80593], [-121.19669, 37.80654]]]} | Open Access 1 | 36057 | Button Estates Park | 16612 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 3.552 | Button Estates Park | 0 | Local Park 2 | 4 | |
13684 | 13684 | 13683 | {"type": "Polygon", "coordinates": [[[-121.20077, 37.81086], [-121.20103, 37.81084], [-121.20126, 37.81079], [-121.20143, 37.8107], [-121.20166, 37.81053], [-121.20172, 37.81052], [-121.20258, 37.81121], [-121.20269, 37.81132], [-121.2027, 37.81136], [-121.20267, 37.8114], [-121.20263, 37.8114], [-121.20077, 37.81141], [-121.20073, 37.81139], [-121.20071, 37.81136], [-121.20071, 37.81092], [-121.20072, 37.81088], [-121.20077, 37.81086]]]} | Open Access 1 | 36056 | Rodoni Park | 24552 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 2.74 | Rodoni Park | 0 | Local Park 2 | 4 | |
13683 | 13683 | 13682 | {"type": "Polygon", "coordinates": [[[-121.31182, 37.80165], [-121.3115, 37.80161], [-121.31149, 37.80059], [-121.31153, 37.80017], [-121.31152, 37.79944], [-121.3115, 37.79919], [-121.31146, 37.799], [-121.31134, 37.79861], [-121.31125, 37.79843], [-121.31109, 37.79816], [-121.31093, 37.79795], [-121.31078, 37.79779], [-121.31044, 37.79748], [-121.3102, 37.79731], [-121.30996, 37.79717], [-121.31023, 37.79717], [-121.31046, 37.79732], [-121.3114, 37.79785], [-121.3117, 37.79795], [-121.31179, 37.79803], [-121.31184, 37.79812], [-121.31194, 37.79858], [-121.31196, 37.79879], [-121.31192, 37.79935], [-121.3118, 37.80059], [-121.31179, 37.80135], [-121.31182, 37.80165]]]} | Open Access 1 | 36055 | River Park South | 24423 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 4.562 | River Park South | 0 | Local Park 2 | 4 | |
13682 | 13682 | 13681 | {"type": "Polygon", "coordinates": [[[-121.31182, 37.80165], [-121.31186, 37.80179], [-121.31186, 37.80208], [-121.31182, 37.80237], [-121.31168, 37.80296], [-121.31163, 37.80326], [-121.31163, 37.80356], [-121.31172, 37.80366], [-121.31144, 37.80383], [-121.31175, 37.80509], [-121.31135, 37.80494], [-121.31082, 37.80476], [-121.31027, 37.80462], [-121.30986, 37.80453], [-121.30929, 37.80444], [-121.30887, 37.80439], [-121.30844, 37.80436], [-121.30787, 37.80435], [-121.3078, 37.80429], [-121.30769, 37.80234], [-121.30776, 37.80228], [-121.3081, 37.80228], [-121.30839, 37.8023], [-121.31108, 37.8027], [-121.31119, 37.8027], [-121.31132, 37.80264], [-121.31139, 37.80254], [-121.31149, 37.80208], [-121.31149, 37.80161], [-121.31182, 37.80165]]]} | Open Access 1 | 36054 | Mossdale Landing Community Park | 22515 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 20.398 | Mossdale Landing Community Park | 0 | Local Park 2 | 4 | |
12666 | 12666 | 12665 | {"type": "MultiPolygon", "coordinates": [[[[-121.26306, 37.78131], [-121.26305, 37.78131], [-121.26305, 37.78131], [-121.26305, 37.78131], [-121.26306, 37.78131]]], [[[-121.26389, 37.78023], [-121.26379, 37.7806], [-121.26342, 37.78054], [-121.26353, 37.78016], [-121.26389, 37.78023]]]]} | Open Access 1 | 48799 | Dutra Estates Mini Park | 33521 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 0.343 | Dutra Estates MP | 0 | Local Park 2 | 4 | |
12662 | 12662 | 12661 | {"type": "Polygon", "coordinates": [[[-121.20155, 37.78832], [-121.20155, 37.78832], [-121.19838, 37.78833], [-121.20016, 37.78641], [-121.20028, 37.78642], [-121.20056, 37.78639], [-121.20061, 37.78634], [-121.2015, 37.78686], [-121.20155, 37.78832]]]} | Open Access 1 | 48800 | Spreckels Park BMX | 33522 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | https://www.usabmx.com/tracks/1770/pages/24 | San Joaquin 39 | 9.989 | Spreckels Park BMX | None 1098 | ||
12637 | 12637 | 12636 | {"type": "MultiPolygon", "coordinates": [[[[-121.24019, 37.77305], [-121.24018, 37.7731], [-121.23998, 37.77337], [-121.23992, 37.77352], [-121.23989, 37.7737], [-121.23988, 37.77402], [-121.23987, 37.77407], [-121.23984, 37.77409], [-121.23979, 37.77409], [-121.23941, 37.77402], [-121.23859, 37.77402], [-121.23855, 37.77223], [-121.23874, 37.77223], [-121.23887, 37.77211], [-121.24016, 37.773], [-121.24019, 37.77305]]], [[[-121.24308, 37.77346], [-121.24308, 37.77346], [-121.24308, 37.77346], [-121.24308, 37.77346], [-121.24308, 37.77346]]]]} | Open Access 1 | 48798 | Palmer Memorial | 33520 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 5.463 | Palmer Memorial | None 1095 | |||
12636 | 12636 | 12635 | {"type": "Polygon", "coordinates": [[[-121.23282, 37.80117], [-121.23204, 37.8012], [-121.23203, 37.80089], [-121.23282, 37.80088], [-121.23282, 37.80117]]]} | Open Access 1 | 48797 | Manteca Dog Park | 33519 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 0.572 | Manteca Dog Park | 0 | Local Park 2 | 4 | |
12036 | 12036 | 12035 | {"type": "Polygon", "coordinates": [[[-121.22719, 37.80158], [-121.22687, 37.80192], [-121.22675, 37.80185], [-121.22662, 37.80184], [-121.22655, 37.80187], [-121.2265, 37.80191], [-121.22643, 37.80208], [-121.226, 37.80209], [-121.22596, 37.80086], [-121.22719, 37.80158]]]} | Open Access 1 | 24712 | Walnut Place Park | 27242 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 2.045 | Walnut Place Park | 0 | Local Park 2 | 4 | |
12035 | 12035 | 12034 | {"type": "Polygon", "coordinates": [[[-121.1892, 37.80763], [-121.18922, 37.80862], [-121.1892, 37.80865], [-121.18889, 37.80873], [-121.18867, 37.80881], [-121.18813, 37.80908], [-121.18786, 37.80918], [-121.18757, 37.80925], [-121.18725, 37.80929], [-121.18721, 37.8084], [-121.18685, 37.80839], [-121.18685, 37.80824], [-121.18687, 37.80811], [-121.18686, 37.80803], [-121.18703, 37.80765], [-121.1892, 37.80763]]]} | Open Access 1 | 24711 | Springport Park | 25748 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 7.1 | Springport 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]);