units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where COUNTY = 6, DES_TP = 49 and MNG_AGENCY = 59
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, PARK_URL, LABEL_NAME
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- United States National Park Service · 12 ✖
DES_TP 1
- Recreation Management Area · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
939 | 939 | 938 | {"type": "Polygon", "coordinates": [[[-118.69354, 34.09988], [-118.69132, 34.09987], [-118.6913, 34.09626], [-118.69353, 34.09626], [-118.69354, 34.09988]]]} | Unknown Access 4 | 6492 | Triffon Open Space | 29659 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 20.369 | Triffon OS | 0 | Recreation Management Area 49 | 4 | |
1128 | 1128 | 1127 | {"type": "MultiPolygon", "coordinates": [[[[-118.65001, 34.07927], [-118.64902, 34.07928], [-118.6491, 34.07916], [-118.64914, 34.07903], [-118.64913, 34.07888], [-118.64909, 34.07874], [-118.64901, 34.07862], [-118.64888, 34.07851], [-118.64873, 34.07843], [-118.64854, 34.07839], [-118.64834, 34.07839], [-118.64815, 34.07844], [-118.64681, 34.07901], [-118.64666, 34.07901], [-118.64638, 34.07905], [-118.64564, 34.07927], [-118.64543, 34.07928], [-118.64496, 34.07925], [-118.64461, 34.07919], [-118.64334, 34.07882], [-118.64322, 34.07877], [-118.64307, 34.07863], [-118.64299, 34.07846], [-118.64299, 34.07832], [-118.64303, 34.0782], [-118.64313, 34.07807], [-118.64333, 34.0779], [-118.64352, 34.07783], [-118.64373, 34.07769], [-118.64454, 34.07796], [-118.6449, 34.0779], [-118.64493, 34.0781], [-118.6456, 34.07833], [-118.65, 34.07832], [-118.65001, 34.07927]]], [[[-118.64879, 34.07893], [-118.64876, 34.079], [-118.64867, 34.07908], [-118.64557, 34.08106], [-118.64541, 34.08113], [-118.64518, 34.08114], [-118.64488, 34.08105], [-118.64479, 34.08105], [-118.64464, 34.08108], [-118.64452, 34.08114], [-118.64397, 34.08117], [-118.64382, 34.08117], [-118.64366, 34.08083], [-118.64334, 34.08006], [-118.64335, 34.08001], [-118.64344, 34.08002], [-118.64352, 34.08], [-118.64361, 34.07994], [-118.64367, 34.07987], [-118.6438, 34.0792], [-118.64493, 34.07943], [-118.6452, 34.07946], [-118.64544, 34.07946], [-118.64594, 34.07942], [-118.64631, 34.07935], [-118.64668, 34.07924], [-118.64684, 34.07918], [-118.64743, 34.07918], [-118.64762, 34.07915], [-118.64778, 34.07909], [-118.64793, 34.07901], [-118.64809, 34.07888], [-118.64829, 34.07866], [-118.6484, 34.07862], [-118.64858, 34.07862], [-118.64871, 34.07869], [-118.64877, 34.07878], [-118.64879, 34.07893]]], [[[-118.64799, 34.07869], [-118.64782, 34.07887], [-118.64765, 34.07896], [-118.64747, 34.07901], [-118.64723, 34.07901], [-118.64799, 34.07869]]], [[[-118.64889, 34.07913], [-118.64884, 34.07921], [-118.64877, 34.07927], [-118.64851, 34.0794], [-118.64883, 34.0792], [-118.64889, 34.07913]]]]} | Open Access 1 | 7215 | Hepatic Gulch Open Space | 14226 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 29.855 | Hepatic Gulch OS | 0 | Recreation Management Area 49 | 4 | |
1279 | 1279 | 1278 | {"type": "Polygon", "coordinates": [[[-118.62382, 34.08177], [-118.62381, 34.08535], [-118.61508, 34.08531], [-118.61509, 34.08234], [-118.61513, 34.07806], [-118.62377, 34.0781], [-118.62382, 34.08177]]]} | Open Access 1 | 7224 | Hondo Canyon Open Space | 14227 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 159.718 | Hondo Canyon OS | 0 | Recreation Management Area 49 | 4 | |
1667 | 1667 | 1666 | {"type": "Polygon", "coordinates": [[[-118.80701, 34.07087], [-118.80686, 34.07462], [-118.80435, 34.07459], [-118.80451, 34.07274], [-118.8025, 34.07272], [-118.80266, 34.07087], [-118.80701, 34.07087]]]} | Open Access 1 | 12586 | SMMNRA - Backbone Trail | 14272 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/backbonetrail.htm | Los Angeles 6 | 32.43 | SMMNRA - Backbone Trail | 0 | Recreation Management Area 49 | 4 |
5410 | 5410 | 5409 | {"type": "MultiPolygon", "coordinates": [[[[-118.75087, 34.11885], [-118.75058, 34.11902], [-118.75051, 34.11908], [-118.75064, 34.11891], [-118.75074, 34.11886], [-118.75087, 34.11885]]], [[[-118.75359, 34.11659], [-118.75356, 34.11674], [-118.75349, 34.11691], [-118.75315, 34.11733], [-118.75306, 34.11741], [-118.75104, 34.11872], [-118.75072, 34.11875], [-118.75057, 34.11882], [-118.75049, 34.11889], [-118.75042, 34.11899], [-118.75027, 34.11924], [-118.75018, 34.11951], [-118.75035, 34.11811], [-118.74568, 34.11811], [-118.74573, 34.11065], [-118.74682, 34.11178], [-118.74705, 34.11195], [-118.7472, 34.1121], [-118.74751, 34.11234], [-118.74786, 34.11255], [-118.74806, 34.11265], [-118.74807, 34.11269], [-118.74931, 34.1132], [-118.74967, 34.1133], [-118.74997, 34.11334], [-118.75015, 34.11335], [-118.75044, 34.11334], [-118.751, 34.11325], [-118.75107, 34.11329], [-118.75119, 34.11388], [-118.75132, 34.11416], [-118.75141, 34.1143], [-118.75153, 34.11444], [-118.75174, 34.11462], [-118.75194, 34.11474], [-118.75272, 34.11516], [-118.75287, 34.11526], [-118.75301, 34.1154], [-118.75311, 34.11554], [-118.75319, 34.1157], [-118.75341, 34.11594], [-118.7535, 34.11609], [-118.75357, 34.11628], [-118.75359, 34.11659]]], [[[-118.77607, 34.11785], [-118.76678, 34.11932], [-118.76728, 34.12191], [-118.76876, 34.12926], [-118.76476, 34.12769], [-118.76177, 34.12647], [-118.7553, 34.1239], [-118.7547, 34.12542], [-118.75361, 34.12614], [-118.75344, 34.1262], [-118.75226, 34.12623], [-118.75129, 34.12637], [-118.75123, 34.1264], [-118.75109, 34.12625], [-118.75073, 34.12605], [-118.75065, 34.12435], [-118.75064, 34.12412], [-118.75066, 34.12391], [-118.75072, 34.1236], [-118.75078, 34.1234], [-118.7509, 34.12311], [-118.75116, 34.12269], [-118.75163, 34.12209], [-118.75163, 34.12207], [-118.75109, 34.12236], [-118.75089, 34.12262], [-118.75074, 34.12287], [-118.75063, 34.12308], [-118.75049, 34.12346], [-118.75039, 34.12397], [-118.75038, 34.12425], [-118.75045, 34.1259], [-118.7503, 34.12579], [-118.75011, 34.12558], [-118.75003, 34.12553], [-118.74997, 34.12547], [-118.74964, 34.12502], [-118.74958, 34.12489], [-118.74954, 34.12475], [-118.74954, 34.12464], [-118.74958, 34.1244], [-118.74962, 34.12424], [-118.74979, 34.12383], [-118.74986, 34.12354], [-118.75005, 34.12158], [-118.7503, 34.11964], [-118.75038, 34.11942], [-118.75053, 34.11922], [-118.75064, 34.11913], [-118.75205, 34.11825], [-118.75268, 34.11781], [-118.75281, 34.11776], [-118.7531, 34.11757], [-118.7533, 34.1174], [-118.75343, 34.11725], [-118.75362, 34.11696], [-118.75391, 34.11659], [-118.75394, 34.11651], [-118.75394, 34.11637], [-118.75391, 34.1163], [-118.75329, 34.11563], [-118.75303, 34.11515], [-118.75295, 34.11505], [-118.7528, 34.11493], [-118.75204, 34.11453], [-118.75192, 34.11445], [-118.75174, 34.1143], [-118.75162, 34.11416], [-118.7515, 34.11395], [-118.75145, 34.11383], [-118.75133, 34.11326], [-118.75134, 34.11321], [-118.75138, 34.11318], [-118.75272, 34.11295], [-118.75294, 34.11289], [-118.7532, 34.11277], [-118.75325, 34.11274], [-118.75324, 34.11272], [-118.75356, 34.11251], [-118.75449, 34.11172], [-118.75494, 34.11145], [-118.75563, 34.11112], [-118.76413, 34.11097], [-118.76663, 34.11356], [-118.77607, 34.11785]]]]} | Open Access 1 | 12705 | Paramount Ranch | 14261 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/paramountranch.htm | Los Angeles 6 | 753.198 | Paramount Ranch | 0 | Recreation Management Area 49 | 4 |
7009 | 7009 | 7008 | {"type": "MultiPolygon", "coordinates": [[[[-118.69717, 34.09626], [-118.69708, 34.09636], [-118.69685, 34.09655], [-118.69422, 34.09857], [-118.69401, 34.09877], [-118.69383, 34.09898], [-118.69368, 34.09919], [-118.69353, 34.09945], [-118.69353, 34.09626], [-118.69717, 34.09626]]], [[[-118.70229, 34.09625], [-118.7001, 34.09625], [-118.7001, 34.0973], [-118.69892, 34.09625], [-118.69902, 34.09624], [-118.69892, 34.09614], [-118.69887, 34.09599], [-118.69889, 34.0958], [-118.69888, 34.09569], [-118.69891, 34.09558], [-118.69792, 34.09557], [-118.69791, 34.09987], [-118.69364, 34.09988], [-118.69378, 34.09954], [-118.69393, 34.09928], [-118.69405, 34.09911], [-118.69432, 34.09881], [-118.69463, 34.09856], [-118.69719, 34.09659], [-118.69738, 34.0964], [-118.6975, 34.09623], [-118.69761, 34.09596], [-118.69765, 34.09574], [-118.69765, 34.09559], [-118.69762, 34.09544], [-118.69755, 34.09522], [-118.69791, 34.09509], [-118.69791, 34.09264], [-118.70227, 34.09264], [-118.70229, 34.09625]]]]} | Open Access 1 | 6490 | King Gillette Ranch | 14239 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/kinggilletteranch.htm | Los Angeles 6 | 77.512 | King Gillette Ranch | 0 | Recreation Management Area 49 | 4 |
7269 | 7269 | 7268 | {"type": "Polygon", "coordinates": [[[-118.70012, 34.09988], [-118.69791, 34.09987], [-118.69791, 34.09626], [-118.69892, 34.09625], [-118.7001, 34.0973], [-118.70012, 34.09988]]]} | Restricted Access 2 | 6493 | Diamond X Ranch | 29655 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 18.578 | Diamond X Ranch | 0 | Recreation Management Area 49 | 4 | |
7422 | 7422 | 7421 | {"type": "Polygon", "coordinates": [[[-118.38785, 34.12636], [-118.38735, 34.12646], [-118.3872, 34.12645], [-118.38703, 34.12639], [-118.38696, 34.12634], [-118.38625, 34.12553], [-118.38623, 34.12548], [-118.38621, 34.12538], [-118.38608, 34.12528], [-118.38595, 34.12532], [-118.38595, 34.12535], [-118.38592, 34.1254], [-118.38578, 34.12542], [-118.38565, 34.12549], [-118.3851, 34.12621], [-118.38496, 34.12631], [-118.38478, 34.12638], [-118.38434, 34.12643], [-118.38426, 34.12643], [-118.38419, 34.12642], [-118.38413, 34.12638], [-118.38408, 34.12634], [-118.384, 34.12619], [-118.3839, 34.12609], [-118.38377, 34.12603], [-118.38359, 34.12603], [-118.38349, 34.12605], [-118.38337, 34.12613], [-118.38332, 34.12618], [-118.38308, 34.12651], [-118.38298, 34.12659], [-118.38285, 34.12665], [-118.38266, 34.12667], [-118.38149, 34.12656], [-118.38129, 34.12653], [-118.38131, 34.12649], [-118.38131, 34.12642], [-118.38128, 34.12634], [-118.3812, 34.12626], [-118.38096, 34.12612], [-118.38089, 34.12604], [-118.38087, 34.12598], [-118.38119, 34.12546], [-118.38102, 34.125], [-118.38138, 34.12466], [-118.38142, 34.12465], [-118.38142, 34.12462], [-118.38136, 34.12456], [-118.38126, 34.12452], [-118.38043, 34.1245], [-118.38034, 34.12447], [-118.37998, 34.12422], [-118.3798, 34.12415], [-118.37959, 34.12415], [-118.3794, 34.12424], [-118.37936, 34.12422], [-118.3792, 34.12375], [-118.37929, 34.12375], [-118.37942, 34.12372], [-118.37959, 34.12372], [-118.37969, 34.12367], [-118.37984, 34.12367], [-118.37997, 34.1237], [-118.38059, 34.1239], [-118.38067, 34.12389], [-118.38074, 34.12385], [-118.38075, 34.12382], [-118.38075, 34.12376], [-118.38069, 34.1237], [-118.38062, 34.12368], [-118.3805, 34.12373], [-118.3804, 34.12374], [-118.38016, 34.12366], [-118.38007, 34.1231], [-118.38026, 34.12322], [-118.38049, 34.12332], [-118.38071, 34.12335], [-118.38091, 34.12334], [-118.38106, 34.1233], [-118.38119, 34.12325], [-118.38139, 34.1231], [-118.3815, 34.12296], [-118.38154, 34.12286], [-118.38158, 34.1227], [-118.38165, 34.12265], [-118.38179, 34.12264], [-118.38202, 34.12279], [-118.38226, 34.12287], [-118.38248, 34.12289], [-118.38268, 34.12287], [-118.38287, 34.12281], [-118.38309, 34.12269], [-118.38322, 34.12258], [-118.38332, 34.12241], [-118.38339, 34.12238], [-118.38346, 34.12237], [-118.38472, 34.12246], [-118.38491, 34.12246], [-118.38504, 34.12244], [-118.38529, 34.12236], [-118.38552, 34.12221], [-118.38568, 34.12204], [-118.38574, 34.12192], [-118.38579, 34.12178], [-118.38586, 34.12172], [-118.38598, 34.12171], [-118.38629, 34.1218], [-118.38642, 34.12188], [-118.38646, 34.12195], [-118.38679, 34.12306], [-118.38691, 34.12326], [-118.38705, 34.1234], [-118.38729, 34.12354], [-118.38757, 34.12362], [-118.38784, 34.12363], [-118.38785, 34.12597], [-118.38775, 34.12605], [-118.38785, 34.12636]]]} | Open Access 1 | 6860 | Fryman Canyon Park | 14218 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 64.912 | Fryman Canyon Park | 0 | Recreation Management Area 49 | 4 | |
8231 | 8231 | 8230 | {"type": "Polygon", "coordinates": [[[-118.77876, 34.11244], [-118.77774, 34.11333], [-118.77749, 34.11315], [-118.77722, 34.11301], [-118.77658, 34.11278], [-118.77649, 34.11274], [-118.77632, 34.1126], [-118.77602, 34.11226], [-118.77585, 34.11215], [-118.77572, 34.11211], [-118.7755, 34.1121], [-118.77301, 34.1124], [-118.7749, 34.11069], [-118.77876, 34.11244]]]} | Open Access 1 | 12558 | Peter Strauss Ranch | 14262 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/straussranch.htm | Los Angeles 6 | 14.272 | Peter Strauss Ranch | 0 | Recreation Management Area 49 | 4 |
8883 | 8883 | 8882 | {"type": "Polygon", "coordinates": [[[-118.78111, 34.11396], [-118.78093, 34.11395], [-118.78079, 34.11396], [-118.77889, 34.11435], [-118.77869, 34.11434], [-118.7785, 34.11428], [-118.77842, 34.11422], [-118.77833, 34.11414], [-118.778, 34.11361], [-118.77788, 34.11347], [-118.77774, 34.11333], [-118.77875, 34.11245], [-118.77875, 34.11243], [-118.7761, 34.11124], [-118.77607, 34.1074], [-118.78036, 34.10736], [-118.78039, 34.11317], [-118.78104, 34.11347], [-118.78111, 34.11396]]]} | Open Access 1 | 14517 | Peter Strauss Ranch | 14262 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/straussranch.htm | Los Angeles 6 | 61.91 | Peter Strauss Ranch | 0 | Recreation Management Area 49 | 4 |
14320 | 14320 | 14319 | {"type": "Polygon", "coordinates": [[[-118.71107, 34.10391], [-118.71093, 34.10397], [-118.71061, 34.10414], [-118.71032, 34.10426], [-118.70981, 34.10444], [-118.70927, 34.1046], [-118.70646, 34.10285], [-118.707, 34.10227], [-118.70735, 34.10227], [-118.70735, 34.10256], [-118.70733, 34.10264], [-118.7075, 34.10269], [-118.70754, 34.10261], [-118.70867, 34.10291], [-118.71101, 34.10229], [-118.71099, 34.10357], [-118.71107, 34.10363], [-118.71107, 34.10391]]]} | Open Access 1 | 44376 | King Gillette Ranch | 14239 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/kinggilletteranch.htm | Los Angeles 6 | 15.376 | King Gillette Ranch | 0 | Recreation Management Area 49 | 4 |
16090 | 16090 | 16089 | {"type": "Polygon", "coordinates": [[[-118.75338, 34.07449], [-118.74918, 34.07468], [-118.74905, 34.06713], [-118.74903, 34.06346], [-118.74927, 34.06345], [-118.74935, 34.06348], [-118.74943, 34.06353], [-118.74951, 34.06364], [-118.74963, 34.06373], [-118.75017, 34.06398], [-118.75031, 34.06401], [-118.75074, 34.06406], [-118.75082, 34.0641], [-118.75083, 34.06419], [-118.75066, 34.06433], [-118.75064, 34.06438], [-118.75064, 34.06447], [-118.75066, 34.06452], [-118.75065, 34.06456], [-118.7505, 34.06477], [-118.75045, 34.06487], [-118.75046, 34.065], [-118.75048, 34.06506], [-118.75051, 34.06511], [-118.75062, 34.0652], [-118.75078, 34.06526], [-118.7509, 34.06526], [-118.75097, 34.06524], [-118.75153, 34.06497], [-118.7516, 34.06497], [-118.75165, 34.065], [-118.7519, 34.06549], [-118.75197, 34.06556], [-118.75207, 34.0656], [-118.75251, 34.06555], [-118.75257, 34.0656], [-118.75272, 34.06593], [-118.75277, 34.06598], [-118.75285, 34.06602], [-118.75296, 34.06602], [-118.75316, 34.06595], [-118.75321, 34.06595], [-118.75324, 34.06794], [-118.75319, 34.06799], [-118.75317, 34.06807], [-118.75319, 34.06813], [-118.75325, 34.06821], [-118.75334, 34.07273], [-118.75328, 34.07283], [-118.75327, 34.07292], [-118.75329, 34.073], [-118.75335, 34.07314], [-118.75338, 34.07449]]]} | Open Access 1 | 12313 | Gage Open Space | 14219 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 103.318 | Gage OS | 0 | Recreation Management Area 49 | 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]);