units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where ACCESS_TYP = 1 and DES_TP = 104 sorted by rowid descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 32 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15481 | 15481 | 15480 | {"type": "Polygon", "coordinates": [[[-121.90442, 36.37228], [-121.90409, 36.37302], [-121.90285, 36.37256], [-121.9025, 36.37238], [-121.90224, 36.3722], [-121.90207, 36.37203], [-121.90198, 36.37191], [-121.90184, 36.37165], [-121.90175, 36.37141], [-121.90168, 36.37116], [-121.90166, 36.37091], [-121.90167, 36.37059], [-121.90307, 36.3706], [-121.90305, 36.37087], [-121.90312, 36.37125], [-121.90317, 36.3714], [-121.90343, 36.37175], [-121.9036, 36.37192], [-121.90369, 36.37199], [-121.90388, 36.37208], [-121.90399, 36.37216], [-121.90408, 36.3722], [-121.90442, 36.37228]]]} | Open Access 1 | 43080 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 8.36 | 0 | State Other or Unknown 104 | 4 | |||
14627 | 14627 | 14626 | {"type": "Polygon", "coordinates": [[[-117.1923, 32.94906], [-117.191, 32.94919], [-117.19013, 32.94942], [-117.18969, 32.94958], [-117.1895, 32.94982], [-117.19051, 32.94991], [-117.19179, 32.94988], [-117.18881, 32.95146], [-117.18726, 32.95215], [-117.18661, 32.95216], [-117.18604, 32.95168], [-117.1852, 32.95166], [-117.18365, 32.9519], [-117.18288, 32.95212], [-117.18285, 32.94953], [-117.18356, 32.94954], [-117.18489, 32.94924], [-117.18599, 32.94907], [-117.18671, 32.94907], [-117.1883, 32.94888], [-117.18953, 32.94857], [-117.18983, 32.94848], [-117.19089, 32.94847], [-117.1916, 32.9486], [-117.1923, 32.94906]]]} | Open Access 1 | 44879 | Deer Canyon Environmental Mitigation | 17991 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 54.189 | Deer Canyon Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
14336 | 14336 | 14335 | {"type": "Polygon", "coordinates": [[[-122.00031, 40.43185], [-122.00029, 40.43226], [-121.99983, 40.4321], [-121.99906, 40.4325], [-121.99844, 40.43331], [-121.99657, 40.43358], [-121.99441, 40.43303], [-121.99419, 40.433], [-121.9926, 40.43265], [-121.99119, 40.43195], [-121.99124, 40.42927], [-121.99732, 40.42914], [-121.99734, 40.42833], [-122.00029, 40.42825], [-122.00031, 40.43185]]]} | Open Access 1 | 44352 | Darrah Springs Fish Hatchery | 32144 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Shasta 27 | 85.045 | Darrah Springs Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
7674 | 7674 | 7673 | {"type": "Polygon", "coordinates": [[[-119.72154, 36.98342], [-119.72124, 36.98436], [-119.72043, 36.98505], [-119.72041, 36.98576], [-119.72081, 36.98612], [-119.71504, 36.98955], [-119.71421, 36.98877], [-119.71461, 36.98852], [-119.71382, 36.98803], [-119.71385, 36.98732], [-119.71406, 36.98693], [-119.71412, 36.9868], [-119.71485, 36.98589], [-119.7156, 36.98567], [-119.71653, 36.98603], [-119.71687, 36.98603], [-119.71851, 36.98504], [-119.7193, 36.98381], [-119.72074, 36.98281], [-119.72122, 36.98286], [-119.72154, 36.98342]]]} | Open Access 1 | 7583 | San Joaquin Fish Hatchery | 32294 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Fresno 9 | 49.554 | San Joaquin Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
6495 | 6495 | 6494 | {"type": "Polygon", "coordinates": [[[-122.3326, 41.30589], [-122.33249, 41.3062], [-122.33207, 41.30637], [-122.33217, 41.30672], [-122.33166, 41.30715], [-122.33116, 41.30804], [-122.33115, 41.30819], [-122.33034, 41.30844], [-122.33029, 41.30956], [-122.33025, 41.30957], [-122.33012, 41.30987], [-122.32975, 41.31021], [-122.32973, 41.31055], [-122.32915, 41.3101], [-122.32887, 41.30992], [-122.32817, 41.30958], [-122.32679, 41.30908], [-122.32659, 41.30891], [-122.32846, 41.30749], [-122.32846, 41.30626], [-122.33044, 41.30579], [-122.33046, 41.30533], [-122.33252, 41.30536], [-122.33252, 41.30566], [-122.3326, 41.30589]]]} | Open Access 1 | 2367 | Mount Shasta Fish Hatchery | 32233 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 32.759 | Mount Shasta Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
5657 | 5657 | 5656 | {"type": "Polygon", "coordinates": [[[-122.55331, 38.60735], [-122.54863, 38.60741], [-122.54854, 38.60384], [-122.55324, 38.60379], [-122.55331, 38.60735]]]} | Open Access 1 | 43096 | Unnamed site - California Department of General Services | 28627 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 40.016 | 0 | State Other or Unknown 104 | 4 | ||
4832 | 4832 | 4831 | {"type": "Polygon", "coordinates": [[[-120.98197, 36.98324], [-120.98213, 36.97644], [-120.98853, 36.97639], [-120.98853, 36.97728], [-120.98854, 36.97729], [-120.99081, 36.97728], [-120.99083, 36.97637], [-120.99972, 36.9763], [-120.99974, 36.96892], [-121.00106, 36.96895], [-121.00407, 36.96895], [-121.00406, 36.96511], [-121.00864, 36.96512], [-121.00866, 36.96896], [-121.0127, 36.96898], [-121.01274, 36.98375], [-121.0096, 36.98369], [-121.00985, 36.99054], [-120.99991, 36.99067], [-120.99095, 36.99055], [-120.98203, 36.9904], [-120.98197, 36.98324]]]} | Open Access 1 | 49077 | Unnamed Site - California Department of Water Resources | 33776 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Merced 37 | 1286.898 | 0 | State Other or Unknown 104 | 4 | ||
4827 | 4827 | 4826 | {"type": "Polygon", "coordinates": [[[-118.74074, 34.07084], [-118.73649, 34.07068], [-118.73648, 34.06711], [-118.74072, 34.06713], [-118.74074, 34.07084]]]} | Open Access 1 | 48969 | Unnamed site - California Department of Parks and Recreation | 30566 | 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 | Los Angeles 6 | 39.075 | 0 | State Other or Unknown 104 | 4 | ||
4776 | 4776 | 4775 | {"type": "MultiPolygon", "coordinates": [[[[-123.78094, 40.04105], [-123.77631, 40.04038], [-123.77621, 40.03407], [-123.77658, 40.03481], [-123.77778, 40.03667], [-123.77813, 40.03737], [-123.77819, 40.03767], [-123.7784, 40.03788], [-123.77868, 40.0386], [-123.77936, 40.03934], [-123.78039, 40.0401], [-123.78085, 40.0399], [-123.78089, 40.03991], [-123.78086, 40.03993], [-123.78094, 40.04105]]], [[[-124.15793, 40.54867], [-124.15215, 40.54859], [-124.15399, 40.54211], [-124.15466, 40.54314], [-124.15526, 40.54451], [-124.15583, 40.5456], [-124.15629, 40.54623], [-124.157, 40.54706], [-124.15756, 40.54776], [-124.15793, 40.54867]]], [[[-124.15905, 40.56405], [-124.15698, 40.56404], [-124.15638, 40.56307], [-124.15904, 40.5631], [-124.15905, 40.56405]]], [[[-124.17889, 40.59558], [-124.17889, 40.59558], [-124.17622, 40.59879], [-124.17608, 40.59791], [-124.17668, 40.59502], [-124.17645, 40.59463], [-124.17889, 40.59558]]]]} | Open Access 1 | 46941 | Unnamed site - California Department of Parks and Recreation | 30566 | 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 | Humboldt 45 | 91.244 | 0 | State Other or Unknown 104 | 4 | ||
4775 | 4775 | 4774 | {"type": "Polygon", "coordinates": [[[-124.15052, 40.86761], [-124.14962, 40.86842], [-124.14818, 40.86841], [-124.14656, 40.86849], [-124.1365, 40.86849], [-124.1372, 40.86837], [-124.13789, 40.86828], [-124.13851, 40.86817], [-124.14003, 40.86783], [-124.14288, 40.86717], [-124.14878, 40.86571], [-124.14929, 40.8665], [-124.15052, 40.86761]]]} | Open Access 1 | 46938 | Unnamed site - California State University | 30561 | 210 | California State University 778 | State 5 | State Agency 5 | http://www.calstate.edu/ | Other State 5 | 210 | California State University 758 | State 5 | State Agency 5 | Humboldt 45 | 42.634 | 0 | State Other or Unknown 104 | 4 | ||
4773 | 4773 | 4772 | {"type": "MultiPolygon", "coordinates": [[[[-124.24021, 40.69417], [-124.23559, 40.69411], [-124.23559, 40.69168], [-124.23695, 40.69223], [-124.23917, 40.69269], [-124.23992, 40.69296], [-124.24019, 40.69317], [-124.24021, 40.69417]]], [[[-124.24508, 40.7334], [-124.24498, 40.73418], [-124.24133, 40.73757], [-124.24139, 40.73806], [-124.24119, 40.73823], [-124.24034, 40.73821], [-124.24066, 40.73756], [-124.24062, 40.73631], [-124.24108, 40.73545], [-124.24262, 40.73463], [-124.24508, 40.7334]]]]} | Open Access 1 | 46934 | Unnamed site - California State Lands Commission | 30557 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Humboldt 45 | 35.708 | 0 | State Other or Unknown 104 | 4 | ||
4772 | 4772 | 4771 | {"type": "MultiPolygon", "coordinates": [[[[-123.78953, 40.0753], [-123.7895, 40.07556], [-123.78937, 40.07563], [-123.78923, 40.07562], [-123.78895, 40.07539], [-123.78896, 40.07522], [-123.78889, 40.07509], [-123.78898, 40.0749], [-123.78947, 40.07503], [-123.78953, 40.0753]]], [[[-123.80311, 40.92168], [-123.80295, 40.92183], [-123.80259, 40.92175], [-123.80217, 40.92158], [-123.80189, 40.92163], [-123.80154, 40.92173], [-123.80135, 40.92181], [-123.80095, 40.92202], [-123.80048, 40.92219], [-123.79993, 40.92252], [-123.79977, 40.92257], [-123.79706, 40.92221], [-123.79506, 40.92144], [-123.79484, 40.91961], [-123.79532, 40.91907], [-123.79581, 40.91872], [-123.7969, 40.9187], [-123.7967, 40.91955], [-123.79647, 40.91965], [-123.7963, 40.91983], [-123.79616, 40.92023], [-123.79619, 40.92066], [-123.79623, 40.92097], [-123.79652, 40.92115], [-123.79731, 40.92106], [-123.79784, 40.92114], [-123.79858, 40.92122], [-123.80017, 40.92128], [-123.80216, 40.92123], [-123.80242, 40.92129], [-123.80298, 40.92146], [-123.80311, 40.92168]]], [[[-124.15195, 40.80245], [-124.15185, 40.80277], [-124.15156, 40.80277], [-124.15145, 40.80283], [-124.15145, 40.80296], [-124.15115, 40.80296], [-124.15115, 40.80236], [-124.15119, 40.80236], [-124.15157, 40.80212], [-124.15195, 40.80245]]], [[[-124.15907, 40.55577], [-124.15904, 40.5631], [-124.15159, 40.56302], [-124.15233, 40.56174], [-124.15358, 40.55931], [-124.15391, 40.55636], [-124.15462, 40.55636], [-124.15467, 40.55574], [-124.15907, 40.55577]], [[-124.15418, 40.562], [-124.15424, 40.56175], [-124.1541, 40.56175], [-124.15409, 40.56199], [-124.15418, 40.562]]]]} | Open Access 1 | 46933 | Unnamed site - California Department of Transportation | 30558 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | Humboldt 45 | 124.116 | 0 | State Other or Unknown 104 | 4 | ||
4771 | 4771 | 4770 | {"type": "Polygon", "coordinates": [[[-124.09931, 40.49321], [-124.09822, 40.4937], [-124.09816, 40.49283], [-124.09855, 40.49302], [-124.09884, 40.49286], [-124.09931, 40.49321]]]} | Open Access 1 | 46932 | Unnamed site - California Department of Fish and Wildlife | 30559 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Humboldt 45 | 1.271 | 0 | State Other or Unknown 104 | 4 | ||
4768 | 4768 | 4767 | {"type": "MultiPolygon", "coordinates": [[[[-123.79434, 40.47335], [-123.79344, 40.47461], [-123.79172, 40.47464], [-123.7917, 40.47345], [-123.79184, 40.4734], [-123.79189, 40.47397], [-123.7929, 40.47349], [-123.7938, 40.47316], [-123.79434, 40.47335]]], [[[-123.80067, 40.46825], [-123.80044, 40.46859], [-123.80036, 40.4688], [-123.80034, 40.46903], [-123.80011, 40.46906], [-123.80066, 40.46963], [-123.79996, 40.46972], [-123.79992, 40.46966], [-123.79964, 40.46971], [-123.79961, 40.46959], [-123.79997, 40.46954], [-123.8001, 40.46907], [-123.80009, 40.46906], [-123.79735, 40.46919], [-123.79647, 40.46944], [-123.79653, 40.46852], [-123.79661, 40.46843], [-123.79718, 40.46811], [-123.79754, 40.46817], [-123.79789, 40.46815], [-123.7983, 40.46803], [-123.7993, 40.46811], [-123.79937, 40.46813], [-123.79941, 40.46807], [-123.79936, 40.46805], [-123.79938, 40.46802], [-123.80067, 40.46825]]], [[[-124.09997, 41.25922], [-124.0996, 41.26108], [-124.09945, 41.26144], [-124.09924, 41.26217], [-124.09926, 41.26243], [-124.09904, 41.26333], [-124.09904, 41.26429], [-124.09931, 41.26516], [-124.09974, 41.26573], [-124.09975, 41.2659], [-124.0997, 41.2661], [-124.09935, 41.26665], [-124.09928, 41.26672], [-124.09862, 41.26813], [-124.09732, 41.27163], [-124.097, 41.27279], [-124.09665, 41.27363], [-124.09622, 41.27454], [-124.09616, 41.27463], [-124.09565, 41.27589], [-124.09539, 41.27717], [-124.09365, 41.27719], [-124.09391, 41.2761], [-124.09413, 41.27503], [-124.09435, 41.27356], [-124.09491, 41.27158], [-124.09529, 41.27031], [-124.09573, 41.26915], [-124.09606, 41.2682], [-124.09669, 41.26687], [-124.09668, 41.26686], [-124.09536, 41.26684], [-124.09563, 41.26017], [-124.09518, 41.25926], [-124.09688, 41.25931], [-124.09997, 41.25922]]], [[[-124.19517, 40.77569], [-124.19492, 40.77704], [-124.19447, 40.77695], [-124.19466, 40.77632], [-124.19483, 40.77561], [-124.19517, 40.77569]]], [[[-124.26888, 40.62856], [-124.26886, 40.62923], [-124.26704, 40.62852], [-124.26888, 40.62856], [-124.26888, 40.62856]]]]} | Open Access 1 | 46915 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 140.719 | 0 | State Other or Unknown 104 | 4 | |||
4684 | 4684 | 4683 | {"type": "Polygon", "coordinates": [[[-121.44979, 35.87733], [-121.44731, 35.87732], [-121.4472, 35.87724], [-121.44693, 35.87699], [-121.44647, 35.87652], [-121.44576, 35.87561], [-121.44572, 35.87386], [-121.44723, 35.87386], [-121.44745, 35.87417], [-121.44748, 35.87437], [-121.44749, 35.87455], [-121.44772, 35.87489], [-121.44778, 35.87492], [-121.44805, 35.8752], [-121.44825, 35.87555], [-121.44833, 35.87614], [-121.44853, 35.87649], [-121.44887, 35.87663], [-121.44941, 35.87701], [-121.44966, 35.87726], [-121.44979, 35.87733]]]} | Open Access 1 | 43078 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 18.337 | 0 | State Other or Unknown 104 | 4 | |||
4682 | 4682 | 4681 | {"type": "Polygon", "coordinates": [[[-121.68569, 36.44484], [-121.68518, 36.44573], [-121.68502, 36.44565], [-121.68518, 36.44552], [-121.68529, 36.44539], [-121.68537, 36.44527], [-121.68545, 36.44508], [-121.6855, 36.44499], [-121.68558, 36.44491], [-121.68569, 36.44484]]]} | Open Access 1 | 43073 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 0.221 | 0 | State Other or Unknown 104 | 4 | |||
4681 | 4681 | 4680 | {"type": "Polygon", "coordinates": [[[-121.45347, 35.88079], [-121.45045, 35.88079], [-121.45039, 35.87782], [-121.45083, 35.87812], [-121.45128, 35.87836], [-121.45184, 35.87897], [-121.45199, 35.87926], [-121.45214, 35.87963], [-121.45241, 35.88005], [-121.45259, 35.88039], [-121.45312, 35.88067], [-121.45347, 35.88079]]]} | Open Access 1 | 43023 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 11.034 | 0 | State Other or Unknown 104 | 4 | |||
4617 | 4617 | 4616 | {"type": "Polygon", "coordinates": [[[-121.44723, 35.87386], [-121.44572, 35.87386], [-121.44568, 35.87182], [-121.44593, 35.87189], [-121.44619, 35.87189], [-121.44641, 35.87183], [-121.44656, 35.87186], [-121.447, 35.87216], [-121.447, 35.87235], [-121.44694, 35.8725], [-121.44675, 35.87258], [-121.44665, 35.87274], [-121.44665, 35.87297], [-121.44685, 35.87305], [-121.44688, 35.87323], [-121.44688, 35.87356], [-121.44709, 35.87378], [-121.44723, 35.87386]]]} | Open Access 1 | 36110 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 5.733 | 0 | State Other or Unknown 104 | 4 | |||
4615 | 4615 | 4614 | {"type": "Polygon", "coordinates": [[[-120.43434, 35.8989], [-120.4339, 35.89938], [-120.433, 35.89938], [-120.433, 35.89909], [-120.43279, 35.89769], [-120.4328, 35.89746], [-120.43285, 35.89727], [-120.43291, 35.89727], [-120.43341, 35.89756], [-120.43422, 35.89848], [-120.43434, 35.8989]]]} | Open Access 1 | 36133 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 5.226 | 0 | State Other or Unknown 104 | 4 | |||
4604 | 4604 | 4603 | {"type": "Polygon", "coordinates": [[[-122.52162, 38.65813], [-122.51683, 38.65816], [-122.51708, 38.65772], [-122.517, 38.65768], [-122.51701, 38.65454], [-122.51243, 38.65456], [-122.51247, 38.65095], [-122.5216, 38.65086], [-122.52159, 38.65443], [-122.52162, 38.65813]]]} | Open Access 1 | 35702 | Unnamed site - California Department of General Services | 28627 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 119.087 | 0 | State Other or Unknown 104 | 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]);