units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, MNG_AG_TYP = 5 and YR_EST = 1971
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11255 | 11255 | 11254 | {"type": "Polygon", "coordinates": [[[-117.57335, 33.45319], [-117.5733, 33.45446], [-117.56712, 33.45446], [-117.56788, 33.45287], [-117.56793, 33.45246], [-117.57306, 33.45311], [-117.57317, 33.45312], [-117.57335, 33.45319]]]} | Open Access 1 | 25874 | San Onofre State Beach | 13878 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=647 | Orange 3 | 24.569 | San Onofre SB | 1971 | State Park 15 | 4 |
16492 | 16492 | 16491 | {"type": "MultiPolygon", "coordinates": [[[[-117.54775, 33.36682], [-117.54765, 33.36691], [-117.54715, 33.36659], [-117.52944, 33.3545], [-117.52868, 33.354], [-117.52813, 33.35358], [-117.52765, 33.35319], [-117.52745, 33.35299], [-117.52679, 33.35245], [-117.52421, 33.35012], [-117.5235, 33.34954], [-117.5231, 33.34925], [-117.52304, 33.34919], [-117.52225, 33.34865], [-117.52154, 33.34821], [-117.51759, 33.34608], [-117.51724, 33.3459], [-117.51653, 33.34549], [-117.51589, 33.34508], [-117.50239, 33.33524], [-117.50246, 33.33517], [-117.50775, 33.33902], [-117.50784, 33.33907], [-117.50791, 33.33913], [-117.508, 33.33925], [-117.50808, 33.33933], [-117.50954, 33.34038], [-117.50964, 33.34043], [-117.50981, 33.34047], [-117.50991, 33.34056], [-117.50995, 33.34066], [-117.51004, 33.34076], [-117.51121, 33.34162], [-117.51158, 33.34177], [-117.51199, 33.34205], [-117.51207, 33.34213], [-117.51218, 33.3423], [-117.51228, 33.34239], [-117.51344, 33.34324], [-117.51369, 33.34332], [-117.51377, 33.34336], [-117.51391, 33.34349], [-117.51403, 33.34366], [-117.51411, 33.34373], [-117.51527, 33.34457], [-117.51541, 33.34465], [-117.5157, 33.34474], [-117.51603, 33.34497], [-117.51611, 33.34504], [-117.51621, 33.34519], [-117.5163, 33.34527], [-117.51697, 33.34568], [-117.51782, 33.34617], [-117.52126, 33.34799], [-117.52253, 33.34877], [-117.5232, 33.34925], [-117.52332, 33.34931], [-117.52352, 33.34938], [-117.52358, 33.34942], [-117.52405, 33.3498], [-117.52422, 33.35007], [-117.52522, 33.35096], [-117.52532, 33.35102], [-117.52564, 33.35113], [-117.52588, 33.35135], [-117.52597, 33.35156], [-117.52606, 33.3517], [-117.52736, 33.35286], [-117.52805, 33.35343], [-117.5282, 33.35352], [-117.52841, 33.35358], [-117.5285, 33.35364], [-117.52859, 33.35372], [-117.52867, 33.35385], [-117.52873, 33.35392], [-117.53038, 33.35504], [-117.53051, 33.35511], [-117.53074, 33.35517], [-117.53131, 33.35557], [-117.53135, 33.35562], [-117.53142, 33.35574], [-117.53146, 33.35577], [-117.53374, 33.35735], [-117.5339, 33.35743], [-117.53423, 33.35753], [-117.53449, 33.35773], [-117.5346, 33.35791], [-117.53471, 33.35801], [-117.53537, 33.35847], [-117.54198, 33.36299], [-117.54219, 33.36308], [-117.54235, 33.36314], [-117.54251, 33.36326], [-117.54264, 33.36341], [-117.54662, 33.3661], [-117.5467, 33.36614], [-117.54696, 33.36633], [-117.54698, 33.36633], [-117.54773, 33.36682], [-117.54775, 33.36682]]], [[[-117.54934, 33.36477], [-117.54781, 33.36673], [-117.54762, 33.36661], [-117.54697, 33.36619], [-117.54672, 33.36602], [-117.54669, 33.36601], [-117.54424, 33.36434], [-117.54273, 33.36334], [-117.54261, 33.36318], [-117.54248, 33.36308], [-117.54232, 33.363], [-117.5422, 33.36297], [-117.54201, 33.36286], [-117.53758, 33.35982], [-117.53545, 33.35839], [-117.53477, 33.35791], [-117.53471, 33.35785], [-117.53459, 33.35764], [-117.53433, 33.35746], [-117.53428, 33.35742], [-117.53395, 33.35733], [-117.53384, 33.35728], [-117.53156, 33.35569], [-117.5315, 33.35564], [-117.53146, 33.35555], [-117.53138, 33.35547], [-117.53135, 33.35546], [-117.53078, 33.35506], [-117.53047, 33.35496], [-117.52883, 33.35383], [-117.52876, 33.35377], [-117.5287, 33.35365], [-117.52859, 33.35356], [-117.5285, 33.3535], [-117.52827, 33.35342], [-117.52816, 33.35336], [-117.52746, 33.35278], [-117.52616, 33.35163], [-117.52608, 33.35152], [-117.52603, 33.35137], [-117.52597, 33.35128], [-117.52574, 33.35106], [-117.52567, 33.35102], [-117.52534, 33.3509], [-117.52527, 33.35085], [-117.52437, 33.35006], [-117.52432, 33.35001], [-117.5242, 33.34979], [-117.52414, 33.3497], [-117.52372, 33.34937], [-117.52361, 33.3493], [-117.52337, 33.34921], [-117.5233, 33.34917], [-117.52261, 33.34869], [-117.52198, 33.34829], [-117.52133, 33.3479], [-117.51796, 33.34611], [-117.51723, 33.3457], [-117.51641, 33.3452], [-117.51631, 33.34511], [-117.5162, 33.34496], [-117.51611, 33.34489], [-117.51577, 33.34465], [-117.5154, 33.34452], [-117.51419, 33.34365], [-117.51415, 33.34361], [-117.51401, 33.34341], [-117.51391, 33.34332], [-117.51376, 33.34323], [-117.51351, 33.34315], [-117.51347, 33.34312], [-117.51237, 33.34231], [-117.51229, 33.34224], [-117.51211, 33.34199], [-117.51167, 33.34167], [-117.51127, 33.34151], [-117.51009, 33.34065], [-117.51001, 33.34049], [-117.50992, 33.3404], [-117.50982, 33.34035], [-117.50962, 33.34029], [-117.50816, 33.33924], [-117.50809, 33.33916], [-117.50803, 33.33908], [-117.50792, 33.33898], [-117.50787, 33.33896], [-117.50255, 33.33509], [-117.50537, 33.33236], [-117.50715, 33.33406], [-117.51033, 33.33691], [-117.5108, 33.3373], [-117.51129, 33.3377], [-117.51259, 33.33869], [-117.51641, 33.34171], [-117.51955, 33.34416], [-117.51998, 33.34452], [-117.52116, 33.34533], [-117.5218, 33.34587], [-117.52202, 33.34602], [-117.52251, 33.34632], [-117.5246, 33.34775], [-117.52503, 33.34808], [-117.52547, 33.34838], [-117.52688, 33.34924], [-117.5277, 33.34979], [-117.52827, 33.3502], [-117.52829, 33.3502], [-117.52856, 33.35042], [-117.52882, 33.35066], [-117.52901, 33.3508], [-117.52946, 33.35107], [-117.5309, 33.3521], [-117.53539, 33.35525], [-117.53607, 33.35578], [-117.53641, 33.35607], [-117.53714, 33.3566], [-117.53889, 33.35781], [-117.54499, 33.36222], [-117.54607, 33.36294], [-117.54711, 33.36359], [-117.54818, 33.36418], [-117.54934, 33.36477]]], [[[-117.57053, 33.37696], [-117.56991, 33.37733], [-117.56978, 33.37735], [-117.56951, 33.37746], [-117.56937, 33.3775], [-117.56883, 33.37754], [-117.56862, 33.3776], [-117.56851, 33.37767], [-117.56841, 33.37776], [-117.56815, 33.37811], [-117.55996, 33.37365], [-117.56045, 33.37298], [-117.56065, 33.37306], [-117.56093, 33.3732], [-117.56125, 33.37339], [-117.56175, 33.37373], [-117.56194, 33.37388], [-117.56217, 33.37408], [-117.56223, 33.37405], [-117.56223, 33.37396], [-117.56195, 33.37373], [-117.56162, 33.37349], [-117.56114, 33.37319], [-117.56083, 33.37302], [-117.56052, 33.37288], [-117.56073, 33.37259], [-117.56087, 33.37244], [-117.56206, 33.37081], [-117.56285, 33.37114], [-117.56404, 33.37152], [-117.56428, 33.37162], [-117.56453, 33.37175], [-117.56469, 33.37188], [-117.5656, 33.3725], [-117.56667, 33.37339], [-117.56725, 33.37383], [-117.56778, 33.37418], [-117.56816, 33.37441], [-117.56837, 33.37451], [-117.56862, 33.37467], [-117.5689, 33.37492], [-117.56911, 33.37514], [-117.56959, 33.37582], [-117.56991, 33.37622], [-117.57, 33.3763], [-117.57029, 33.37671], [-117.57053, 33.37696]]], [[[-117.59347, 33.39734], [-117.59314, 33.39871], [-117.59226, 33.40197], [-117.59224, 33.40209], [-117.59118, 33.4061], [-117.59107, 33.40652], [-117.591, 33.40663], [-117.59029, 33.40933], [-117.59028, 33.40934], [-117.58959, 33.41175], [-117.58965, 33.41177], [-117.57853, 33.45381], [-117.57335, 33.45305], [-117.57334, 33.45306], [-117.57335, 33.45319], [-117.57317, 33.45312], [-117.57306, 33.45311], [-117.56793, 33.45246], [-117.56811, 33.4511], [-117.56863, 33.44909], [-117.56866, 33.44474], [-117.56864, 33.44342], [-117.57021, 33.4409], [-117.57224, 33.436], [-117.57238, 33.4295], [-117.57242, 33.42813], [-117.57133, 33.42565], [-117.57419, 33.42353], [-117.57879, 33.41984], [-117.58222, 33.4135], [-117.58369, 33.41133], [-117.58475, 33.41178], [-117.58494, 33.41169], [-117.58594, 33.41049], [-117.5854, 33.40984], [-117.5852, 33.40937], [-117.58269, 33.40734], [-117.58274, 33.40661], [-117.58282, 33.40611], [-117.58355, 33.40494], [-117.58367, 33.40457], [-117.5839, 33.40431], [-117.5839, 33.404], [-117.58417, 33.40325], [-117.5853, 33.40227], [-117.58621, 33.40295], [-117.5875, 33.40317], [-117.58813, 33.40148], [-117.58763, 33.40133], [-117.59027, 33.39795], [-117.59025, 33.39567], [-117.5913, 33.39381], [-117.59139, 33.39394], [-117.59194, 33.39509], [-117.59208, 33.39556], [-117.59202, 33.39573], [-117.59173, 33.39599], [-117.59155, 33.3962], [-117.59151, 33.39629], [-117.59173, 33.39639], [-117.5918, 33.39637], [-117.59326, 33.39719], [-117.59347, 33.39734]]], [[[-117.59539, 33.3879], [-117.59529, 33.38798], [-117.59522, 33.38793], [-117.59356, 33.38905], [-117.59103, 33.39191], [-117.58947, 33.38984], [-117.5888, 33.38883], [-117.58771, 33.38765], [-117.58683, 33.38698], [-117.58494, 33.38534], [-117.58396, 33.38466], [-117.58341, 33.38456], [-117.58318, 33.38465], [-117.58238, 33.3845], [-117.58136, 33.3842], [-117.5783, 33.38323], [-117.57803, 33.38303], [-117.5778, 33.38296], [-117.57849, 33.38206], [-117.57861, 33.38152], [-117.57927, 33.38153], [-117.57998, 33.38159], [-117.58062, 33.38169], [-117.58148, 33.38188], [-117.58184, 33.38199], [-117.58244, 33.38221], [-117.59285, 33.38626], [-117.5935, 33.38657], [-117.59422, 33.38698], [-117.59481, 33.3874], [-117.59518, 33.38769], [-117.59539, 33.3879]]], [[[-117.59617, 33.38711], [-117.59594, 33.38795], [-117.59565, 33.38767], [-117.59519, 33.38729], [-117.59443, 33.38676], [-117.59373, 33.38635], [-117.59292, 33.38598], [-117.58258, 33.38195], [-117.5822, 33.38182], [-117.58142, 33.38159], [-117.58064, 33.38142], [-117.57977, 33.3813], [-117.57922, 33.38126], [-117.57864, 33.38124], [-117.57869, 33.38077], [-117.57889, 33.3808], [-117.5795, 33.38078], [-117.57996, 33.38082], [-117.58028, 33.38087], [-117.58049, 33.38092], [-117.58078, 33.38102], [-117.58095, 33.3811], [-117.58178, 33.38155], [-117.58218, 33.3817], [-117.58253, 33.38179], [-117.58531, 33.38216], [-117.58561, 33.38218], [-117.586, 33.38223], [-117.58637, 33.3823], [-117.58681, 33.38242], [-117.58753, 33.38255], [-117.58802, 33.3826], [-117.58885, 33.38262], [-117.58903, 33.38257], [-117.58925, 33.38243], [-117.58945, 33.38237], [-117.58958, 33.38237], [-117.58968, 33.3824], [-117.58982, 33.38251], [-117.58988, 33.38261], [-117.59007, 33.38288], [-117.59041, 33.38322], [-117.59103, 33.38378], [-117.59167, 33.38427], [-117.59205, 33.3845], [-117.5928, 33.3849], [-117.59311, 33.38503], [-117.5934, 33.3851], [-117.59361, 33.38517], [-117.59407, 33.3854], [-117.59523, 33.38616], [-117.59549, 33.38635], [-117.59589, 33.38672], [-117.59617, 33.38711]]]]} | Open Access 1 | 25875 | San Onofre State Beach | 13878 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=647 | San Diego 4 | 2018.265 | San Onofre SB | 1971 | State Park 15 | 4 |
16563 | 16563 | 16562 | {"type": "Polygon", "coordinates": [[[-122.65157, 38.44273], [-122.65083, 38.44301], [-122.65083, 38.44305], [-122.65007, 38.44418], [-122.64989, 38.44433], [-122.6497, 38.4444], [-122.6494, 38.44444], [-122.64868, 38.44435], [-122.64837, 38.44417], [-122.6481, 38.44392], [-122.64786, 38.44383], [-122.64766, 38.44361], [-122.64764, 38.44361], [-122.64765, 38.44392], [-122.64761, 38.44458], [-122.64766, 38.44494], [-122.6476, 38.44518], [-122.64757, 38.44542], [-122.6476, 38.44565], [-122.64767, 38.44585], [-122.64782, 38.44613], [-122.6482, 38.44901], [-122.64456, 38.45144], [-122.6435, 38.45135], [-122.64267, 38.45431], [-122.64222, 38.45571], [-122.64164, 38.45583], [-122.64182, 38.45656], [-122.64227, 38.45645], [-122.6421, 38.45683], [-122.64214, 38.45704], [-122.64062, 38.45687], [-122.63923, 38.45679], [-122.63922, 38.45677], [-122.63899, 38.45675], [-122.63869, 38.45669], [-122.6384, 38.4566], [-122.63813, 38.45649], [-122.63792, 38.45637], [-122.63772, 38.45623], [-122.63754, 38.45607], [-122.6374, 38.45591], [-122.63731, 38.45567], [-122.63644, 38.45445], [-122.63605, 38.45394], [-122.63581, 38.45369], [-122.63504, 38.45312], [-122.63458, 38.45282], [-122.63304, 38.45184], [-122.63252, 38.45154], [-122.63128, 38.45102], [-122.63046, 38.45064], [-122.62987, 38.45029], [-122.62879, 38.44975], [-122.62695, 38.44876], [-122.62645, 38.44854], [-122.62448, 38.4478], [-122.62426, 38.44809], [-122.62419, 38.4479], [-122.62404, 38.44774], [-122.62378, 38.44765], [-122.62304, 38.44735], [-122.62231, 38.44673], [-122.62199, 38.44656], [-122.62164, 38.44671], [-122.62138, 38.44658], [-122.62105, 38.44658], [-122.62079, 38.44654], [-122.62043, 38.44606], [-122.62014, 38.44561], [-122.62001, 38.44546], [-122.61972, 38.44538], [-122.61917, 38.44554], [-122.61876, 38.44585], [-122.61866, 38.44588], [-122.61801, 38.4459], [-122.61785, 38.44603], [-122.61757, 38.44611], [-122.61748, 38.44622], [-122.61711, 38.44595], [-122.61634, 38.44557], [-122.61618, 38.44556], [-122.61591, 38.44546], [-122.61594, 38.44528], [-122.61543, 38.4451], [-122.61488, 38.44482], [-122.61463, 38.44467], [-122.61339, 38.44381], [-122.61482, 38.44222], [-122.61253, 38.4371], [-122.60911, 38.43416], [-122.60581, 38.43213], [-122.60185, 38.4305], [-122.60021, 38.4262], [-122.60054, 38.42356], [-122.6002, 38.42148], [-122.59868, 38.42095], [-122.59068, 38.42116], [-122.59068, 38.42118], [-122.59268, 38.42372], [-122.59192, 38.42408], [-122.59108, 38.42566], [-122.59211, 38.42627], [-122.59191, 38.42827], [-122.59123, 38.42841], [-122.59086, 38.42843], [-122.59061, 38.42847], [-122.59023, 38.42848], [-122.59003, 38.42712], [-122.58901, 38.42717], [-122.58883, 38.42672], [-122.58805, 38.42606], [-122.58724, 38.42548], [-122.58693, 38.42497], [-122.58688, 38.42469], [-122.58738, 38.42433], [-122.58718, 38.42395], [-122.58705, 38.42383], [-122.58789, 38.42403], [-122.58824, 38.4242], [-122.58875, 38.42424], [-122.58921, 38.42432], [-122.58965, 38.42448], [-122.59105, 38.4246], [-122.59151, 38.42412], [-122.59097, 38.42361], [-122.58983, 38.42364], [-122.58928, 38.42417], [-122.58879, 38.42407], [-122.5883, 38.42403], [-122.58797, 38.42387], [-122.58751, 38.42377], [-122.58725, 38.42351], [-122.58767, 38.42323], [-122.58777, 38.42187], [-122.58688, 38.42143], [-122.58559, 38.42256], [-122.58401, 38.42122], [-122.58543, 38.42012], [-122.58543, 38.4201], [-122.58408, 38.41939], [-122.58265, 38.41965], [-122.58018, 38.41832], [-122.57871, 38.42042], [-122.57753, 38.41666], [-122.57686, 38.41691], [-122.57672, 38.41732], [-122.57507, 38.41753], [-122.57509, 38.41696], [-122.57537, 38.41614], [-122.57574, 38.41522], [-122.57574, 38.4149], [-122.57537, 38.41405], [-122.57533, 38.4137], [-122.57888, 38.41214], [-122.57696, 38.40906], [-122.57594, 38.40949], [-122.5749, 38.40804], [-122.575, 38.40799], [-122.57547, 38.40816], [-122.57583, 38.40811], [-122.57629, 38.40761], [-122.57702, 38.40748], [-122.57751, 38.4076], [-122.57838, 38.40736], [-122.57913, 38.40755], [-122.58092, 38.40563], [-122.57968, 38.40355], [-122.57928, 38.40312], [-122.57849, 38.40233], [-122.5786, 38.4022], [-122.57855, 38.40211], [-122.57894, 38.40227], [-122.57925, 38.40225], [-122.57933, 38.4022], [-122.57985, 38.40196], [-122.5801, 38.40208], [-122.58047, 38.40244], [-122.58172, 38.40133], [-122.58087, 38.39986], [-122.58137, 38.39922], [-122.58433, 38.39517], [-122.58907, 38.39731], [-122.60729, 38.40567], [-122.62403, 38.41295], [-122.62587, 38.41496], [-122.63921, 38.41581], [-122.64534, 38.41623], [-122.64751, 38.4163], [-122.6483, 38.41628], [-122.64839, 38.42719], [-122.64837, 38.43081], [-122.64843, 38.43685], [-122.6485, 38.43696], [-122.64847, 38.43697], [-122.64847, 38.43755], [-122.6487, 38.43806], [-122.64804, 38.43806], [-122.64803, 38.43807], [-122.64818, 38.43858], [-122.64828, 38.43907], [-122.64838, 38.43974], [-122.64884, 38.44022], [-122.64859, 38.44073], [-122.64858, 38.44083], [-122.6486, 38.44093], [-122.64868, 38.4411], [-122.64908, 38.44157], [-122.64922, 38.44168], [-122.64944, 38.44177], [-122.65053, 38.44195], [-122.65087, 38.44206], [-122.65109, 38.44218], [-122.65132, 38.44236], [-122.65146, 38.44253], [-122.65157, 38.44273]], [[-122.63768, 38.45493], [-122.63621, 38.45283], [-122.63619, 38.45282], [-122.6362, 38.45385], [-122.63632, 38.45399], [-122.63681, 38.45466], [-122.63757, 38.45576], [-122.63766, 38.45568], [-122.63757, 38.45527], [-122.63768, 38.45493]], [[-122.63961, 38.456], [-122.6396, 38.45598], [-122.63888, 38.45588], [-122.63878, 38.45638], [-122.63906, 38.45647], [-122.63926, 38.45649], [-122.63946, 38.45649], [-122.63961, 38.456]]]} | Open Access 1 | 16679 | Annadel State Park | 1395 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=480 | Sonoma 16 | 5112.105 | Annadel SP | 1971 | State Park 15 | 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]);