units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, AGNCY_TYP = 1 and UNIT_NAME = "Farallon National Wildlife Refuge"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12505 | 12505 | 12504 | {"type": "MultiPolygon", "coordinates": [[[[-123.00864, 37.69832], [-123.00862, 37.69838], [-123.00859, 37.69881], [-123.0085, 37.69885], [-123.00844, 37.6988], [-123.00834, 37.69882], [-123.00825, 37.69877], [-123.00814, 37.69866], [-123.00807, 37.69877], [-123.00814, 37.69884], [-123.00814, 37.69895], [-123.00801, 37.69898], [-123.00793, 37.69898], [-123.00786, 37.69891], [-123.00782, 37.6988], [-123.00775, 37.69878], [-123.00767, 37.69869], [-123.00755, 37.69866], [-123.00727, 37.69856], [-123.00717, 37.69858], [-123.00706, 37.69854], [-123.00685, 37.69842], [-123.00668, 37.69835], [-123.0065, 37.69831], [-123.00649, 37.69834], [-123.00656, 37.69845], [-123.00674, 37.69859], [-123.00687, 37.69876], [-123.00691, 37.69889], [-123.00684, 37.69903], [-123.00685, 37.69913], [-123.00698, 37.69926], [-123.00706, 37.69938], [-123.00707, 37.6995], [-123.00702, 37.6996], [-123.00693, 37.69965], [-123.0068, 37.69964], [-123.00675, 37.69954], [-123.00675, 37.69942], [-123.00671, 37.69934], [-123.00661, 37.69939], [-123.0065, 37.69937], [-123.0063, 37.69938], [-123.00601, 37.69924], [-123.00599, 37.69925], [-123.00605, 37.69933], [-123.00615, 37.69938], [-123.00613, 37.6995], [-123.00598, 37.6994], [-123.00589, 37.69939], [-123.00588, 37.69946], [-123.00595, 37.69958], [-123.0059, 37.69964], [-123.00564, 37.69944], [-123.00535, 37.69914], [-123.00531, 37.69923], [-123.0054, 37.69937], [-123.0057, 37.69968], [-123.00574, 37.69976], [-123.00574, 37.70012], [-123.0057, 37.70024], [-123.00556, 37.70028], [-123.00541, 37.70012], [-123.00531, 37.70009], [-123.00516, 37.69993], [-123.00509, 37.69996], [-123.00498, 37.69994], [-123.00499, 37.70008], [-123.00488, 37.70008], [-123.0048, 37.70007], [-123.00454, 37.7001], [-123.00452, 37.70014], [-123.00462, 37.70019], [-123.00485, 37.70018], [-123.00498, 37.70037], [-123.00499, 37.70047], [-123.00496, 37.70052], [-123.005, 37.70061], [-123.00509, 37.70066], [-123.00511, 37.70075], [-123.0052, 37.7008], [-123.00526, 37.70079], [-123.00528, 37.70062], [-123.00543, 37.70062], [-123.00548, 37.70067], [-123.0055, 37.70079], [-123.00548, 37.70089], [-123.00542, 37.70096], [-123.00554, 37.70102], [-123.00553, 37.70114], [-123.00535, 37.70111], [-123.00536, 37.70118], [-123.00541, 37.70131], [-123.00533, 37.70131], [-123.00518, 37.70122], [-123.00502, 37.70109], [-123.00484, 37.70093], [-123.00467, 37.70092], [-123.00467, 37.70093], [-123.00499, 37.70121], [-123.00493, 37.70131], [-123.00481, 37.7013], [-123.00472, 37.70137], [-123.00472, 37.70145], [-123.00462, 37.70155], [-123.0045, 37.70178], [-123.00452, 37.70194], [-123.0045, 37.70204], [-123.00461, 37.70213], [-123.00451, 37.7022], [-123.00424, 37.70231], [-123.00418, 37.7023], [-123.004, 37.70231], [-123.00382, 37.70224], [-123.00381, 37.70216], [-123.00378, 37.70212], [-123.0038, 37.70189], [-123.00377, 37.7018], [-123.00371, 37.70169], [-123.00378, 37.70159], [-123.0039, 37.70151], [-123.00405, 37.70147], [-123.0041, 37.70141], [-123.00404, 37.7012], [-123.00395, 37.70116], [-123.00391, 37.70109], [-123.00381, 37.70113], [-123.00371, 37.70102], [-123.00365, 37.70098], [-123.00359, 37.7009], [-123.00348, 37.70097], [-123.00343, 37.70105], [-123.00335, 37.70108], [-123.00317, 37.70101], [-123.00301, 37.70102], [-123.00294, 37.70093], [-123.00292, 37.70087], [-123.00297, 37.70073], [-123.00299, 37.70051], [-123.00296, 37.70047], [-123.00288, 37.70056], [-123.0028, 37.70061], [-123.00273, 37.70059], [-123.00266, 37.70056], [-123.00268, 37.70082], [-123.00257, 37.70104], [-123.00248, 37.70098], [-123.00241, 37.70066], [-123.00236, 37.7006], [-123.00232, 37.70063], [-123.00227, 37.70091], [-123.00221, 37.70101], [-123.00216, 37.70105], [-123.00205, 37.70108], [-123.00196, 37.70105], [-123.00187, 37.70097], [-123.00178, 37.70086], [-123.00169, 37.7009], [-123.0017, 37.70099], [-123.00179, 37.70106], [-123.00186, 37.70117], [-123.00182, 37.70122], [-123.00174, 37.70121], [-123.00166, 37.70116], [-123.00148, 37.70118], [-123.00141, 37.70107], [-123.00128, 37.70102], [-123.00127, 37.70095], [-123.00121, 37.70087], [-123.00108, 37.70089], [-123.00101, 37.70082], [-123.00085, 37.70052], [-123.00084, 37.70036], [-123.00069, 37.70016], [-123.0007, 37.70008], [-123.00079, 37.69997], [-123.00069, 37.69991], [-123.00071, 37.69979], [-123.00068, 37.69965], [-123.00065, 37.6996], [-123.00055, 37.69956], [-123.00047, 37.6996], [-123.00044, 37.69971], [-123.00038, 37.69974], [-123.00035, 37.69982], [-123.00036, 37.69993], [-123.00025, 37.7], [-123.00009, 37.7], [-122.99996, 37.69998], [-122.99981, 37.69991], [-122.99971, 37.69976], [-122.99964, 37.69971], [-122.99952, 37.69971], [-122.99931, 37.69954], [-122.99923, 37.69933], [-122.99921, 37.69917], [-122.99924, 37.69908], [-122.99938, 37.69896], [-122.99953, 37.69903], [-122.99964, 37.69891], [-122.99978, 37.69889], [-122.99975, 37.69874], [-122.99976, 37.69863], [-122.99975, 37.69851], [-122.9998, 37.69843], [-122.9998, 37.69836], [-122.99993, 37.69832], [-122.99996, 37.69821], [-122.99989, 37.69791], [-122.99981, 37.6978], [-122.99971, 37.69739], [-122.99959, 37.69737], [-122.99957, 37.69729], [-122.99951, 37.69722], [-122.99958, 37.69718], [-122.99957, 37.69708], [-122.99967, 37.69702], [-122.99974, 37.69706], [-122.99982, 37.69703], [-122.99996, 37.69717], [-123.00004, 37.69734], [-123.00018, 37.69746], [-123.00028, 37.69757], [-123.00039, 37.69752], [-123.00032, 37.6973], [-123.00033, 37.69714], [-123.00029, 37.69711], [-123.00018, 37.69724], [-123.0001, 37.69713], [-122.99998, 37.69697], [-122.99992, 37.69681], [-122.99986, 37.69674], [-122.99984, 37.69662], [-122.9997, 37.6965], [-122.99972, 37.69639], [-122.99985, 37.69622], [-122.99999, 37.69615], [-123.00011, 37.69617], [-123.00015, 37.69608], [-123.00028, 37.69609], [-123.00037, 37.69599], [-123.00056, 37.69629], [-123.00066, 37.6964], [-123.00078, 37.69643], [-123.00071, 37.69623], [-123.00056, 37.696], [-123.00053, 37.6959], [-123.00056, 37.69582], [-123.00062, 37.69573], [-123.00069, 37.69566], [-123.00078, 37.69566], [-123.00089, 37.69551], [-123.00095, 37.69549], [-123.00115, 37.69551], [-123.00122, 37.69559], [-123.00134, 37.69558], [-123.00144, 37.69564], [-123.00152, 37.69561], [-123.00158, 37.69565], [-123.00168, 37.69562], [-123.00178, 37.69571], [-123.00187, 37.6957], [-123.00207, 37.69575], [-123.00216, 37.69569], [-123.0023, 37.69582], [-123.00235, 37.69578], [-123.00253, 37.69589], [-123.00261, 37.696], [-123.00275, 37.69604], [-123.00299, 37.69624], [-123.00303, 37.6963], [-123.00351, 37.69669], [-123.00363, 37.69685], [-123.00377, 37.69696], [-123.0038, 37.69704], [-123.00384, 37.69727], [-123.00379, 37.69762], [-123.00386, 37.69766], [-123.00387, 37.69765], [-123.0039, 37.69756], [-123.00399, 37.69741], [-123.00413, 37.69744], [-123.0042, 37.69751], [-123.00429, 37.69755], [-123.00436, 37.69756], [-123.00444, 37.69761], [-123.00456, 37.69759], [-123.00464, 37.6976], [-123.00475, 37.69759], [-123.00486, 37.69763], [-123.00496, 37.69759], [-123.00504, 37.69762], [-123.0052, 37.69759], [-123.00529, 37.69768], [-123.00544, 37.69772], [-123.00544, 37.69771], [-123.00542, 37.69765], [-123.00532, 37.69754], [-123.00528, 37.69744], [-123.00539, 37.69741], [-123.00541, 37.69737], [-123.00527, 37.69727], [-123.00519, 37.69717], [-123.00535, 37.69716], [-123.00544, 37.69709], [-123.00551, 37.69713], [-123.0056, 37.69708], [-123.00572, 37.69721], [-123.00581, 37.69737], [-123.00577, 37.69747], [-123.00567, 37.69745], [-123.00561, 37.69749], [-123.00573, 37.69759], [-123.00579, 37.69774], [-123.00588, 37.69763], [-123.00593, 37.69747], [-123.00601, 37.69742], [-123.00613, 37.69747], [-123.00615, 37.69753], [-123.00609, 37.69754], [-123.00609, 37.69756], [-123.00614, 37.69761], [-123.00628, 37.6977], [-123.00635, 37.69772], [-123.00648, 37.69764], [-123.00659, 37.69767], [-123.00677, 37.69782], [-123.00684, 37.69779], [-123.00669, 37.69751], [-123.00681, 37.69753], [-123.00699, 37.69778], [-123.00709, 37.6979], [-123.00735, 37.6981], [-123.00736, 37.69809], [-123.00738, 37.69803], [-123.00731, 37.69792], [-123.00751, 37.69791], [-123.00767, 37.69796], [-123.00774, 37.69794], [-123.00772, 37.69787], [-123.00778, 37.69787], [-123.00792, 37.6979], [-123.00798, 37.69794], [-123.00807, 37.69803], [-123.00817, 37.69802], [-123.00826, 37.69794], [-123.00837, 37.69792], [-123.00844, 37.69796], [-123.00855, 37.69797], [-123.00859, 37.69806], [-123.00857, 37.69814], [-123.00861, 37.69822], [-123.00864, 37.69832]]], [[[-123.00345, 37.70331], [-123.00345, 37.70356], [-123.00348, 37.70375], [-123.00345, 37.70388], [-123.00336, 37.70403], [-123.00319, 37.70423], [-123.0031, 37.70429], [-123.00269, 37.70447], [-123.00265, 37.70445], [-123.00243, 37.7043], [-123.0024, 37.70419], [-123.00249, 37.70382], [-123.0025, 37.70373], [-123.00259, 37.70365], [-123.00273, 37.70345], [-123.00303, 37.70318], [-123.00315, 37.70309], [-123.00325, 37.7031], [-123.00338, 37.7032], [-123.00345, 37.70331]]], [[[-123.00439, 37.6934], [-123.00441, 37.69349], [-123.00439, 37.69359], [-123.00428, 37.69371], [-123.00415, 37.69378], [-123.00405, 37.69386], [-123.00383, 37.69398], [-123.0035, 37.69399], [-123.00343, 37.69408], [-123.00321, 37.69415], [-123.00309, 37.69423], [-123.00287, 37.69423], [-123.00274, 37.69426], [-123.00262, 37.69412], [-123.00269, 37.69396], [-123.00274, 37.6939], [-123.00298, 37.6938], [-123.00349, 37.6937], [-123.00365, 37.69357], [-123.00401, 37.69335], [-123.00409, 37.69336], [-123.00418, 37.69341], [-123.00424, 37.69341], [-123.00433, 37.69336], [-123.00439, 37.6934]]], [[[-123.00508, 37.70227], [-123.00507, 37.70239], [-123.00501, 37.70257], [-123.00496, 37.70265], [-123.00487, 37.70274], [-123.00471, 37.70282], [-123.00464, 37.70304], [-123.00458, 37.70317], [-123.0045, 37.70321], [-123.00446, 37.70335], [-123.00437, 37.70342], [-123.00434, 37.7035], [-123.00418, 37.70348], [-123.00411, 37.70336], [-123.00413, 37.70318], [-123.00422, 37.70288], [-123.00418, 37.70282], [-123.00411, 37.70285], [-123.00408, 37.70299], [-123.00403, 37.70309], [-123.00394, 37.70315], [-123.00386, 37.70316], [-123.00379, 37.70308], [-123.00372, 37.70295], [-123.00368, 37.70279], [-123.00378, 37.70273], [-123.00389, 37.70269], [-123.0041, 37.70253], [-123.00418, 37.7025], [-123.00446, 37.70234], [-123.00482, 37.70222], [-123.00502, 37.70218], [-123.00508, 37.70227]]], [[[-123.00538, 37.70322], [-123.00535, 37.70332], [-123.00529, 37.70339], [-123.00522, 37.70345], [-123.0051, 37.70349], [-123.00502, 37.70345], [-123.00495, 37.70345], [-123.00484, 37.7034], [-123.00482, 37.70332], [-123.00483, 37.70312], [-123.00496, 37.70294], [-123.00508, 37.70291], [-123.00528, 37.70299], [-123.00535, 37.70307], [-123.00538, 37.70322]]], [[[-123.01401, 37.70014], [-123.01399, 37.70023], [-123.01401, 37.70035], [-123.01397, 37.70045], [-123.0138, 37.7005], [-123.01373, 37.70037], [-123.01368, 37.70038], [-123.01373, 37.70055], [-123.01378, 37.7006], [-123.01378, 37.70073], [-123.01379, 37.70091], [-123.01374, 37.70099], [-123.01345, 37.70099], [-123.01337, 37.70107], [-123.01328, 37.70108], [-123.01321, 37.70102], [-123.01309, 37.70096], [-123.01305, 37.70086], [-123.01293, 37.70078], [-123.01289, 37.70053], [-123.01276, 37.70045], [-123.01271, 37.70057], [-123.01255, 37.70054], [-123.01254, 37.70045], [-123.01249, 37.70038], [-123.01239, 37.70035], [-123.01226, 37.7005], [-123.01214, 37.70049], [-123.01218, 37.70065], [-123.01228, 37.70073], [-123.01223, 37.70086], [-123.01218, 37.70086], [-123.01209, 37.70083], [-123.01206, 37.70075], [-123.01201, 37.70072], [-123.01198, 37.70067], [-123.01192, 37.70066], [-123.01178, 37.70068], [-123.01174, 37.70062], [-123.01175, 37.70058], [-123.01181, 37.70049], [-123.01184, 37.70035], [-123.01174, 37.70035], [-123.01157, 37.70045], [-123.01148, 37.70036], [-123.01138, 37.70032], [-123.01125, 37.70023], [-123.01122, 37.70016], [-123.01121, 37.69995], [-123.01118, 37.6999], [-123.01116, 37.69991], [-123.0111, 37.70006], [-123.01104, 37.70003], [-123.01102, 37.69993], [-123.01101, 37.69978], [-123.01095, 37.69977], [-123.01082, 37.69956], [-123.01086, 37.69952], [-123.01086, 37.69949], [-123.01079, 37.69945], [-123.01079, 37.69939], [-123.01068, 37.69937], [-123.01061, 37.69928], [-123.01049, 37.69928], [-123.01031, 37.69935], [-123.01018, 37.69935], [-123.01002, 37.69939], [-123.00984, 37.69948], [-123.00964, 37.69949], [-123.0094, 37.6994], [-123.00905, 37.69931], [-123.00895, 37.69925], [-123.00886, 37.69914], [-123.00874, 37.69887], [-123.00874, 37.69865], [-123.00879, 37.6983], [-123.00885, 37.6982], [-123.00903, 37.69803], [-123.00905, 37.69794], [-123.00922, 37.69789], [-123.00936, 37.69794], [-123.00953, 37.69795], [-123.00945, 37.69783], [-123.00944, 37.69776], [-123.00958, 37.69775], [-123.00974, 37.69781], [-123.0098, 37.69789], [-123.00978, 37.69802], [-123.00984, 37.698], [-123.00994, 37.69794], [-123.00996, 37.69785], [-123.0101, 37.69785], [-123.01017, 37.69792], [-123.01028, 37.69796], [-123.01053, 37.69815], [-123.01058, 37.69811], [-123.01049, 37.69799], [-123.01051, 37.69786], [-123.01063, 37.69787], [-123.01077, 37.69793], [-123.01082, 37.69792], [-123.01088, 37.69777], [-123.01101, 37.69771], [-123.01104, 37.69761], [-123.01115, 37.69758], [-123.01115, 37.69765], [-123.0112, 37.69768], [-123.01134, 37.69761], [-123.01142, 37.69749], [-123.01152, 37.69754], [-123.01154, 37.69741], [-123.01152, 37.69736], [-123.01158, 37.69724], [-123.01174, 37.69706], [-123.01183, 37.69706], [-123.01194, 37.69715], [-123.01202, 37.69729], [-123.01216, 37.69728], [-123.0122, 37.69735], [-123.01232, 37.69737], [-123.01233, 37.69743], [-123.01243, 37.69746], [-123.01246, 37.69752], [-123.01259, 37.69757], [-123.0126, 37.69762], [-123.01265, 37.69764], [-123.01259, 37.6977], [-123.01264, 37.69777], [-123.01257, 37.69787], [-123.01258, 37.69797], [-123.01251, 37.69805], [-123.01245, 37.69817], [-123.01232, 37.69822], [-123.01213, 37.6984], [-123.01199, 37.69846], [-123.01196, 37.69857], [-123.01214, 37.69861], [-123.01226, 37.69859], [-123.01252, 37.69864], [-123.01268, 37.6987], [-123.01277, 37.699], [-123.01284, 37.69896], [-123.01286, 37.69892], [-123.01285, 37.69872], [-123.01288, 37.69864], [-123.01286, 37.69854], [-123.01291, 37.69842], [-123.01298, 37.6985], [-123.01306, 37.69853], [-123.01316, 37.69853], [-123.01331, 37.69857], [-123.01333, 37.69868], [-123.01332, 37.69877], [-123.01334, 37.69899], [-123.01331, 37.69905], [-123.01323, 37.6991], [-123.01319, 37.69921], [-123.01314, 37.69923], [-123.01305, 37.69934], [-123.01325, 37.6994], [-123.01329, 37.69948], [-123.01338, 37.69949], [-123.01349, 37.69954], [-123.01361, 37.69953], [-123.01368, 37.69965], [-123.01374, 37.69971], [-123.01382, 37.69976], [-123.01388, 37.69984], [-123.01389, 37.69997], [-123.01397, 37.70004], [-123.01397, 37.7001], [-123.01401, 37.70014]]], [[[-123.03119, 37.72823], [-123.03114, 37.72827], [-123.03103, 37.72829], [-123.03093, 37.72819], [-123.03079, 37.72822], [-123.03057, 37.72803], [-123.0306, 37.72796], [-123.03058, 37.72783], [-123.03063, 37.72779], [-123.03081, 37.72781], [-123.03108, 37.728], [-123.03119, 37.72816], [-123.03119, 37.72823]]], [[[-123.09912, 37.76431], [-123.09908, 37.76436], [-123.09899, 37.76442], [-123.09884, 37.76436], [-123.09873, 37.76436], [-123.0986, 37.76443], [-123.09851, 37.76441], [-123.09837, 37.76444], [-123.09816, 37.76428], [-123.09809, 37.76416], [-123.09803, 37.76415], [-123.09796, 37.76408], [-123.09789, 37.76406], [-123.09788, 37.76398], [-123.09793, 37.76392], [-123.09811, 37.76394], [-123.0983, 37.76401], [-123.09842, 37.764], [-123.0985, 37.76401], [-123.09866, 37.76412], [-123.09912, 37.76431]]], [[[-123.09972, 37.7675], [-123.09971, 37.76766], [-123.09967, 37.76775], [-123.09949, 37.76778], [-123.09937, 37.76788], [-123.09921, 37.76784], [-123.0992, 37.76785], [-123.09925, 37.76794], [-123.09912, 37.76791], [-123.09905, 37.76787], [-123.0988, 37.76768], [-123.09876, 37.76754], [-123.0988, 37.76741], [-123.09886, 37.7673], [-123.09885, 37.76719], [-123.09887, 37.76709], [-123.09913, 37.76697], [-123.09932, 37.76702], [-123.09952, 37.76714], [-123.09972, 37.7675]]], [[[-123.10111, 37.76688], [-123.101, 37.76709], [-123.10084, 37.76722], [-123.10077, 37.76725], [-123.10063, 37.76727], [-123.10046, 37.76736], [-123.10037, 37.76735], [-123.10022, 37.76729], [-123.10012, 37.76723], [-123.09999, 37.7672], [-123.09992, 37.76711], [-123.09983, 37.76707], [-123.0998, 37.76697], [-123.09983, 37.76689], [-123.09988, 37.76684], [-123.10008, 37.76673], [-123.10018, 37.76672], [-123.10037, 37.76665], [-123.10054, 37.76665], [-123.10067, 37.76668], [-123.10077, 37.76672], [-123.10078, 37.76678], [-123.10085, 37.76687], [-123.10094, 37.76685], [-123.10098, 37.76683], [-123.10104, 37.76684], [-123.10111, 37.76688]]], [[[-123.10815, 37.77072], [-123.10814, 37.77083], [-123.10806, 37.7709], [-123.10793, 37.77097], [-123.10788, 37.77101], [-123.10784, 37.77117], [-123.10783, 37.77138], [-123.1078, 37.77154], [-123.10776, 37.77161], [-123.10776, 37.77169], [-123.10781, 37.77174], [-123.10809, 37.77184], [-123.10814, 37.7719], [-123.10799, 37.77204], [-123.10781, 37.77212], [-123.10774, 37.77212], [-123.10764, 37.77209], [-123.1075, 37.772], [-123.10735, 37.77185], [-123.10719, 37.77163], [-123.10714, 37.77148], [-123.10714, 37.77138], [-123.10719, 37.77126], [-123.10725, 37.77103], [-123.10731, 37.77092], [-123.10736, 37.77089], [-123.10755, 37.77089], [-123.10775, 37.77079], [-123.10804, 37.77073], [-123.10815, 37.77072]]]]} | No Public Access 3 | 28318 | Farallon National Wildlife Refuge | 18842 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | San Francisco 13 | 109.074 | Farallon NWR | 1969 | National Wildlife Refuge 105 | 2 |
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]);