units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where AGNCY_LEV = 5, DES_TP = 39 and YR_EST = 1978
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7570 | 7570 | 7569 | {"type": "Polygon", "coordinates": [[[-118.81157, 34.71019], [-118.81153, 34.71396], [-118.80713, 34.71394], [-118.80718, 34.71023], [-118.81154, 34.71023], [-118.81155, 34.71019], [-118.81157, 34.71019]]]} | Open Access 1 | 7262 | Hungry Valley State Vehicular Recreation Area | 1574 | 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=405 | Los Angeles 6 | 41.061 | Hungry Valley SVRA | 1978 | State Recreation Area 39 | 4 |
7912 | 7912 | 7911 | {"type": "MultiPolygon", "coordinates": [[[[-117.32954, 34.27677], [-117.32519, 34.2768], [-117.32505, 34.27809], [-117.32505, 34.28], [-117.32508, 34.28054], [-117.31871, 34.28048], [-117.31866, 34.27943], [-117.31867, 34.27874], [-117.31864, 34.27873], [-117.31863, 34.2787], [-117.31209, 34.27871], [-117.31213, 34.2768], [-117.30341, 34.27672], [-117.30337, 34.27501], [-117.29264, 34.27499], [-117.29264, 34.27304], [-117.2905, 34.27304], [-117.29055, 34.26962], [-117.29478, 34.26965], [-117.29472, 34.27035], [-117.29492, 34.27036], [-117.29492, 34.27049], [-117.29694, 34.27058], [-117.29698, 34.27149], [-117.31208, 34.2715], [-117.31207, 34.27237], [-117.31209, 34.27238], [-117.3121, 34.27241], [-117.31463, 34.27244], [-117.31641, 34.27244], [-117.3164, 34.27316], [-117.31643, 34.27317], [-117.31644, 34.27342], [-117.3185, 34.27341], [-117.31848, 34.2741], [-117.3276, 34.27427], [-117.32761, 34.27516], [-117.32953, 34.2752], [-117.32954, 34.27593], [-117.32954, 34.27677]]], [[[-117.3698, 34.28046], [-117.36975, 34.28951], [-117.3621, 34.28957], [-117.35116, 34.28962], [-117.35004, 34.28961], [-117.35001, 34.29052], [-117.34905, 34.2905], [-117.34899, 34.29146], [-117.34275, 34.29146], [-117.34278, 34.2939], [-117.34278, 34.29659], [-117.33719, 34.29659], [-117.33727, 34.30381], [-117.3373, 34.30383], [-117.33957, 34.30387], [-117.3396, 34.30571], [-117.33962, 34.30574], [-117.32543, 34.30576], [-117.32542, 34.30356], [-117.3254, 34.30355], [-117.32516, 34.30373], [-117.32497, 34.30363], [-117.32522, 34.30354], [-117.32542, 34.30353], [-117.3255, 34.30229], [-117.32008, 34.30226], [-117.32007, 34.3005], [-117.31571, 34.30046], [-117.31567, 34.30237], [-117.31129, 34.30234], [-117.31128, 34.30249], [-117.31145, 34.30292], [-117.31191, 34.30343], [-117.31197, 34.30361], [-117.31368, 34.30398], [-117.31445, 34.30434], [-117.31509, 34.30455], [-117.31575, 34.30505], [-117.31611, 34.30512], [-117.31658, 34.30505], [-117.31813, 34.30418], [-117.31854, 34.30366], [-117.31917, 34.30343], [-117.31959, 34.30347], [-117.3197, 34.30356], [-117.3197, 34.30394], [-117.31936, 34.30428], [-117.3191, 34.30422], [-117.31873, 34.30439], [-117.31818, 34.3044], [-117.31753, 34.30473], [-117.31673, 34.30519], [-117.31608, 34.30526], [-117.31563, 34.30498], [-117.31508, 34.30475], [-117.31433, 34.30452], [-117.31356, 34.30417], [-117.31204, 34.30384], [-117.3112, 34.30415], [-117.31119, 34.30513], [-117.31126, 34.30765], [-117.30681, 34.30772], [-117.30678, 34.30409], [-117.29814, 34.30412], [-117.29807, 34.29663], [-117.30346, 34.29678], [-117.30351, 34.29407], [-117.3165, 34.2941], [-117.31647, 34.29615], [-117.31657, 34.29689], [-117.32969, 34.29706], [-117.32959, 34.29612], [-117.32904, 34.29605], [-117.32884, 34.29585], [-117.3286, 34.29585], [-117.32846, 34.29598], [-117.32749, 34.29612], [-117.32719, 34.29589], [-117.32719, 34.2958], [-117.32694, 34.29557], [-117.32672, 34.2955], [-117.32586, 34.29564], [-117.32567, 34.29546], [-117.32581, 34.29472], [-117.32572, 34.29463], [-117.32515, 34.29461], [-117.32496, 34.29445], [-117.32495, 34.29427], [-117.32526, 34.29392], [-117.32537, 34.29362], [-117.32562, 34.2934], [-117.32586, 34.29347], [-117.32595, 34.29372], [-117.32639, 34.29383], [-117.32645, 34.29376], [-117.32675, 34.29374], [-117.32678, 34.29383], [-117.32694, 34.29383], [-117.32722, 34.29365], [-117.32725, 34.29347], [-117.32714, 34.29337], [-117.32714, 34.29317], [-117.3275, 34.29278], [-117.32794, 34.29278], [-117.32827, 34.29294], [-117.32896, 34.2926], [-117.32909, 34.29242], [-117.32898, 34.292], [-117.32923, 34.29179], [-117.32929, 34.29143], [-117.32959, 34.29092], [-117.32959, 34.2899], [-117.32926, 34.28982], [-117.32877, 34.28998], [-117.32857, 34.28989], [-117.32832, 34.2895], [-117.32802, 34.28932], [-117.32808, 34.28893], [-117.3286, 34.28852], [-117.32957, 34.28832], [-117.32957, 34.28773], [-117.33216, 34.28767], [-117.35453, 34.28781], [-117.35537, 34.28686], [-117.3556, 34.28417], [-117.35562, 34.2805], [-117.36437, 34.28041], [-117.36867, 34.28043], [-117.3698, 34.28046]]], [[[-117.32471, 34.30363], [-117.32421, 34.30402], [-117.3237, 34.30376], [-117.32319, 34.30325], [-117.32354, 34.30329], [-117.3239, 34.30354], [-117.32471, 34.30363]]], [[[-117.33224, 34.28109], [-117.33219, 34.28191], [-117.33154, 34.28186], [-117.33159, 34.28109], [-117.33224, 34.28109]]], [[[-117.34852, 34.28107], [-117.34799, 34.28056], [-117.34689, 34.28061], [-117.34696, 34.2795], [-117.34701, 34.27954], [-117.34819, 34.27964], [-117.34815, 34.28066], [-117.34852, 34.28107]]]]} | Open Access 1 | 12680 | Silverwood Lake State Recreation Area | 1838 | 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=650 | San Bernardino 22 | 2057.665 | Silverwood Lake SRA | 1978 | State Recreation Area 39 | 4 |
8105 | 8105 | 8104 | {"type": "Polygon", "coordinates": [[[-118.90767, 34.78905], [-118.90757, 34.79947], [-118.89858, 34.79949], [-118.89846, 34.79591], [-118.89136, 34.7959], [-118.88534, 34.79582], [-118.88555, 34.79909], [-118.88494, 34.79799], [-118.88038, 34.7886], [-118.89876, 34.7886], [-118.89887, 34.78849], [-118.89887, 34.78888], [-118.90767, 34.78905]]]} | Open Access 1 | 12197 | Hungry Valley State Vehicular Recreation Area | 1574 | 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=405 | Kern 36 | 545.61 | Hungry Valley SVRA | 1978 | State Recreation Area 39 | 4 |
12762 | 12762 | 12761 | {"type": "MultiPolygon", "coordinates": [[[[-117.3255, 34.30229], [-117.32542, 34.30354], [-117.32522, 34.30354], [-117.32497, 34.30363], [-117.32481, 34.30356], [-117.32471, 34.30363], [-117.3239, 34.30354], [-117.32354, 34.30329], [-117.32319, 34.30325], [-117.32311, 34.30317], [-117.32217, 34.30299], [-117.32185, 34.30308], [-117.32146, 34.30304], [-117.32105, 34.30317], [-117.31996, 34.30369], [-117.3197, 34.30394], [-117.3197, 34.30356], [-117.31959, 34.30347], [-117.31918, 34.30343], [-117.31854, 34.30365], [-117.31813, 34.30418], [-117.31658, 34.30505], [-117.31611, 34.30512], [-117.31575, 34.30505], [-117.31509, 34.30455], [-117.31445, 34.30434], [-117.31368, 34.30398], [-117.31197, 34.30361], [-117.31191, 34.30342], [-117.31145, 34.30292], [-117.31128, 34.30249], [-117.31129, 34.30234], [-117.31567, 34.30237], [-117.31571, 34.30046], [-117.32007, 34.3005], [-117.32008, 34.30226], [-117.3255, 34.30229]]], [[[-117.35559, 34.28418], [-117.35537, 34.28686], [-117.35453, 34.28781], [-117.33216, 34.28767], [-117.32957, 34.28773], [-117.32958, 34.28832], [-117.3286, 34.28852], [-117.32808, 34.28893], [-117.32802, 34.28931], [-117.32832, 34.2895], [-117.32857, 34.28989], [-117.32876, 34.28998], [-117.32926, 34.28982], [-117.32959, 34.28989], [-117.32959, 34.29092], [-117.32929, 34.29143], [-117.32923, 34.29179], [-117.32899, 34.292], [-117.32909, 34.29241], [-117.32896, 34.2926], [-117.32827, 34.29294], [-117.32794, 34.29278], [-117.32749, 34.29278], [-117.32714, 34.29317], [-117.32714, 34.29337], [-117.32725, 34.29346], [-117.32722, 34.29365], [-117.32694, 34.29383], [-117.32678, 34.29383], [-117.32674, 34.29374], [-117.32645, 34.29376], [-117.32639, 34.29383], [-117.32595, 34.29371], [-117.32586, 34.29347], [-117.32562, 34.2934], [-117.32537, 34.29362], [-117.32526, 34.29392], [-117.32496, 34.29426], [-117.32496, 34.29444], [-117.32515, 34.29461], [-117.32573, 34.29463], [-117.32581, 34.29472], [-117.32567, 34.29545], [-117.32586, 34.29564], [-117.32672, 34.2955], [-117.32694, 34.29557], [-117.32719, 34.2958], [-117.32719, 34.29589], [-117.32749, 34.29612], [-117.32846, 34.29598], [-117.3286, 34.29585], [-117.32884, 34.29585], [-117.32904, 34.29605], [-117.32959, 34.29612], [-117.3297, 34.29706], [-117.31656, 34.29689], [-117.31647, 34.29615], [-117.3165, 34.2941], [-117.31647, 34.28782], [-117.3208, 34.28788], [-117.32081, 34.28049], [-117.32507, 34.28054], [-117.32505, 34.28], [-117.32505, 34.27809], [-117.32519, 34.2768], [-117.32829, 34.27678], [-117.32828, 34.27858], [-117.32829, 34.27961], [-117.32838, 34.27974], [-117.32911, 34.28019], [-117.33125, 34.28039], [-117.33125, 34.28038], [-117.33118, 34.28022], [-117.33119, 34.2799], [-117.33128, 34.27972], [-117.33156, 34.27937], [-117.33161, 34.27924], [-117.33151, 34.2792], [-117.33127, 34.27926], [-117.33108, 34.27927], [-117.33101, 34.27918], [-117.33086, 34.27883], [-117.33386, 34.27888], [-117.33387, 34.27857], [-117.33486, 34.27858], [-117.33493, 34.2761], [-117.33531, 34.27611], [-117.33588, 34.2762], [-117.33718, 34.2765], [-117.33755, 34.27661], [-117.33835, 34.2768], [-117.33934, 34.27708], [-117.3424, 34.27781], [-117.34271, 34.27791], [-117.34466, 34.27843], [-117.34515, 34.27859], [-117.3456, 34.27878], [-117.34664, 34.2793], [-117.34696, 34.2795], [-117.3469, 34.28061], [-117.34799, 34.28056], [-117.34852, 34.28107], [-117.34919, 34.28176], [-117.34962, 34.28214], [-117.34985, 34.28226], [-117.35047, 34.2825], [-117.35114, 34.28271], [-117.35209, 34.28298], [-117.35239, 34.28308], [-117.35364, 34.2834], [-117.35393, 34.28345], [-117.35452, 34.28363], [-117.35493, 34.28381], [-117.35527, 34.28402], [-117.35547, 34.28411], [-117.35559, 34.28418]], [[-117.3316, 34.28109], [-117.33154, 34.28186], [-117.33218, 34.28191], [-117.33224, 34.28109], [-117.3316, 34.28109]]]]} | Open Access 1 | 44432 | Silverwood Lake State Recreation Area | 1838 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=650 | San Bernardino 22 | 1071.542 | Silverwood Lake SRA | 1978 | State Recreation Area 39 | 4 |
16683 | 16683 | 16682 | {"type": "Polygon", "coordinates": [[[-118.87213, 34.78866], [-118.87244, 34.78119], [-118.86355, 34.78121], [-118.86329, 34.7886], [-118.86323, 34.79271], [-118.85998, 34.79324], [-118.85989, 34.79501], [-118.85947, 34.79518], [-118.85717, 34.79492], [-118.85667, 34.79483], [-118.85623, 34.79471], [-118.85583, 34.79454], [-118.85532, 34.7943], [-118.85543, 34.79425], [-118.85516, 34.79412], [-118.85501, 34.79416], [-118.85459, 34.79396], [-118.85474, 34.79397], [-118.85475, 34.79395], [-118.85457, 34.79358], [-118.85504, 34.79357], [-118.85506, 34.79296], [-118.85586, 34.79297], [-118.8559, 34.79155], [-118.85589, 34.79153], [-118.85444, 34.79151], [-118.85442, 34.79202], [-118.85356, 34.79202], [-118.85354, 34.79293], [-118.85245, 34.79291], [-118.85236, 34.79292], [-118.85228, 34.79296], [-118.85222, 34.79301], [-118.85196, 34.79342], [-118.85094, 34.7934], [-118.84837, 34.79383], [-118.84804, 34.79386], [-118.84767, 34.79386], [-118.84763, 34.79408], [-118.84572, 34.79384], [-118.84319, 34.79342], [-118.84295, 34.79349], [-118.84019, 34.79315], [-118.83696, 34.79258], [-118.83608, 34.79225], [-118.83554, 34.79197], [-118.83551, 34.792], [-118.83503, 34.79172], [-118.83379, 34.79093], [-118.83277, 34.79007], [-118.83161, 34.78913], [-118.83015, 34.788], [-118.82933, 34.78739], [-118.82803, 34.78648], [-118.82678, 34.7857], [-118.82679, 34.78567], [-118.82564, 34.78498], [-118.82562, 34.78501], [-118.82007, 34.78169], [-118.8103, 34.77584], [-118.80916, 34.77513], [-118.80775, 34.77416], [-118.80766, 34.77382], [-118.8072, 34.77335], [-118.8065, 34.77308], [-118.80575, 34.77254], [-118.8052, 34.77205], [-118.80507, 34.77178], [-118.80466, 34.77155], [-118.80412, 34.77096], [-118.80341, 34.7701], [-118.80273, 34.76912], [-118.80266, 34.76885], [-118.80238, 34.76864], [-118.80213, 34.76829], [-118.80218, 34.75975], [-118.80213, 34.75645], [-118.79681, 34.75363], [-118.79682, 34.75349], [-118.79673, 34.75331], [-118.79658, 34.75318], [-118.79656, 34.75293], [-118.79671, 34.75273], [-118.79658, 34.75251], [-118.80209, 34.75252], [-118.802, 34.74531], [-118.80253, 34.72968], [-118.80254, 34.72858], [-118.80265, 34.72858], [-118.80265, 34.72808], [-118.80276, 34.72807], [-118.80262, 34.7266], [-118.80267, 34.72657], [-118.8027, 34.72122], [-118.81144, 34.72129], [-118.81147, 34.71947], [-118.81146, 34.71946], [-118.80268, 34.71939], [-118.80264, 34.71921], [-118.80271, 34.71479], [-118.80491, 34.71481], [-118.80489, 34.71573], [-118.8071, 34.71575], [-118.80713, 34.71394], [-118.81152, 34.71396], [-118.81157, 34.71019], [-118.81157, 34.70831], [-118.81603, 34.70842], [-118.81824, 34.70845], [-118.81826, 34.70664], [-118.82107, 34.7067], [-118.82108, 34.70525], [-118.8242, 34.70448], [-118.82492, 34.70448], [-118.8249, 34.69952], [-118.82479, 34.69951], [-118.82479, 34.69946], [-118.83724, 34.69958], [-118.83819, 34.70155], [-118.83816, 34.70683], [-118.84077, 34.70687], [-118.85548, 34.73726], [-118.85548, 34.73732], [-118.85552, 34.73733], [-118.86964, 34.76646], [-118.87586, 34.77947], [-118.87679, 34.78133], [-118.87686, 34.78133], [-118.88033, 34.78858], [-118.87951, 34.78858], [-118.87951, 34.78859], [-118.88164, 34.7922], [-118.8837, 34.79579], [-118.88535, 34.79873], [-118.88535, 34.79884], [-118.88907, 34.80651], [-118.88806, 34.80606], [-118.88781, 34.80598], [-118.88752, 34.80593], [-118.88714, 34.80592], [-118.88677, 34.80596], [-118.88644, 34.80604], [-118.88607, 34.80619], [-118.8858, 34.80636], [-118.88556, 34.80656], [-118.88536, 34.80678], [-118.88523, 34.80701], [-118.88516, 34.80715], [-118.8851, 34.80736], [-118.88481, 34.8087], [-118.88477, 34.8087], [-118.88447, 34.80799], [-118.88312, 34.80661], [-118.88249, 34.80636], [-118.88219, 34.80606], [-118.88186, 34.80577], [-118.8815, 34.80552], [-118.88116, 34.80531], [-118.87955, 34.8038], [-118.87847, 34.80199], [-118.87738, 34.80123], [-118.87604, 34.80114], [-118.87571, 34.80076], [-118.8758, 34.80033], [-118.87559, 34.80012], [-118.87541, 34.79989], [-118.87528, 34.79968], [-118.87524, 34.79808], [-118.87444, 34.79677], [-118.87419, 34.79655], [-118.87419, 34.79627], [-118.87362, 34.79611], [-118.87297, 34.79558], [-118.87222, 34.7953], [-118.87207, 34.79542], [-118.87213, 34.78866]]]} | Open Access 1 | 7261 | Hungry Valley State Vehicular Recreation Area | 1574 | 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=405 | Los Angeles 6 | 11950.165 | Hungry Valley SVRA | 1978 | State Recreation Area 39 | 4 |
16687 | 16687 | 16686 | {"type": "MultiPolygon", "coordinates": [[[[-118.92173, 34.72385], [-118.90654, 34.7237], [-118.90653, 34.72198], [-118.90425, 34.72195], [-118.90423, 34.72011], [-118.89984, 34.72009], [-118.89982, 34.71827], [-118.89104, 34.71824], [-118.89105, 34.72181], [-118.87775, 34.7215], [-118.87775, 34.71786], [-118.87331, 34.71774], [-118.87333, 34.7105], [-118.87775, 34.71062], [-118.87775, 34.71424], [-118.88217, 34.71437], [-118.88218, 34.71798], [-118.8866, 34.71811], [-118.8866, 34.71449], [-118.89103, 34.71461], [-118.8998, 34.71465], [-118.89982, 34.71646], [-118.90421, 34.71648], [-118.90422, 34.71829], [-118.90641, 34.7183], [-118.90643, 34.72011], [-118.90864, 34.72013], [-118.90867, 34.722], [-118.91079, 34.72201], [-118.91079, 34.72021], [-118.92171, 34.7202], [-118.92173, 34.72385]]], [[[-118.90833, 34.75578], [-118.9083, 34.75937], [-118.90814, 34.76695], [-118.89053, 34.76679], [-118.89034, 34.77425], [-118.89925, 34.77435], [-118.89887, 34.78849], [-118.89876, 34.7886], [-118.88039, 34.7886], [-118.88494, 34.79799], [-118.8837, 34.79579], [-118.88164, 34.7922], [-118.8795, 34.78858], [-118.88031, 34.78858], [-118.88032, 34.78857], [-118.87686, 34.78134], [-118.87679, 34.78133], [-118.87586, 34.77947], [-118.87005, 34.7673], [-118.85552, 34.73733], [-118.85548, 34.73733], [-118.85548, 34.73725], [-118.8443, 34.71416], [-118.84817, 34.72174], [-118.84818, 34.72173], [-118.84447, 34.71406], [-118.86467, 34.7141], [-118.86465, 34.72136], [-118.87331, 34.7214], [-118.87329, 34.72327], [-118.87771, 34.72333], [-118.87771, 34.72691], [-118.88217, 34.72697], [-118.88218, 34.72876], [-118.88663, 34.72882], [-118.88664, 34.72524], [-118.89106, 34.72531], [-118.89106, 34.72709], [-118.88888, 34.72706], [-118.88887, 34.72707], [-118.88888, 34.72885], [-118.89107, 34.72888], [-118.89108, 34.73026], [-118.89094, 34.74111], [-118.89533, 34.74115], [-118.89532, 34.74296], [-118.89969, 34.743], [-118.89955, 34.75571], [-118.90833, 34.75578]]]]} | Open Access 1 | 16957 | Hungry Valley State Vehicular Recreation Area | 1574 | 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=405 | Ventura 8 | 6280.692 | Hungry Valley SVRA | 1978 | State Recreation Area 39 | 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]);