units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 2 and DES_TP = 13
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5067 | 5067 | 5066 | {"type": "MultiPolygon", "coordinates": [[[[-121.92364, 39.61375], [-121.91546, 39.61369], [-121.91009, 39.61404], [-121.90974, 39.58565], [-121.91651, 39.58595], [-121.91905, 39.59054], [-121.92027, 39.59046], [-121.92226, 39.60293], [-121.92315, 39.6032], [-121.92361, 39.6051], [-121.92364, 39.61375]]], [[[-121.95697, 39.57561], [-121.95661, 39.58172], [-121.95673, 39.58306], [-121.95538, 39.58764], [-121.9527, 39.59123], [-121.94897, 39.59451], [-121.94637, 39.59764], [-121.9452, 39.59967], [-121.94368, 39.60103], [-121.93282, 39.60012], [-121.93297, 39.5959], [-121.93329, 39.58805], [-121.93354, 39.58402], [-121.93359, 39.57597], [-121.94034, 39.5756], [-121.94131, 39.57612], [-121.95697, 39.57561]]]]} | Restricted Access 2 | 9050 | North Central Valley Wildlife Management Area | 22810 | 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 | Butte 42 | 1915.19 | North Central Valley WMA | 0 | Conservation Area 13 | 2 | |
12172 | 12172 | 12171 | {"type": "MultiPolygon", "coordinates": [[[[-122.0023, 39.55714], [-122.00067, 39.55738], [-122.00004, 39.55733], [-121.99786, 39.55722], [-121.9962, 39.55706], [-121.99474, 39.55668], [-121.99225, 39.55686], [-121.99091, 39.55726], [-121.99068, 39.55729], [-121.99098, 39.55403], [-121.99099, 39.55127], [-121.99048, 39.54485], [-121.98916, 39.54105], [-121.98522, 39.53903], [-121.9855, 39.53688], [-121.9834, 39.53577], [-121.98269, 39.53511], [-121.98042, 39.53448], [-121.9785, 39.53391], [-121.97608, 39.53414], [-121.97452, 39.53396], [-121.9725, 39.53286], [-121.97036, 39.53075], [-121.97013, 39.53024], [-121.97103, 39.53], [-121.97405, 39.52928], [-121.97381, 39.52965], [-121.9734, 39.53036], [-121.97335, 39.53079], [-121.97343, 39.53115], [-121.97367, 39.5314], [-121.9739, 39.53157], [-121.97541, 39.53246], [-121.97657, 39.53298], [-121.97737, 39.53321], [-121.97795, 39.53328], [-121.9787, 39.5333], [-121.97964, 39.53321], [-121.98059, 39.53305], [-121.98156, 39.53294], [-121.98245, 39.53293], [-121.98298, 39.53304], [-121.98325, 39.53318], [-121.9842, 39.5333], [-121.98464, 39.53314], [-121.9849, 39.53293], [-121.98493, 39.53272], [-121.9849, 39.53229], [-121.98511, 39.53188], [-121.98573, 39.53154], [-121.9862, 39.53149], [-121.98676, 39.53169], [-121.98777, 39.53231], [-121.98854, 39.53256], [-121.98931, 39.53279], [-121.99005, 39.53316], [-121.99155, 39.53382], [-121.99238, 39.53423], [-121.99333, 39.53491], [-121.99387, 39.53547], [-121.995, 39.5373], [-121.99688, 39.54166], [-121.99885, 39.54825], [-122.0023, 39.55714]]], [[[-122.00208, 39.55937], [-122.00124, 39.56031], [-121.99906, 39.56057], [-121.99884, 39.5608], [-121.99772, 39.56184], [-121.99751, 39.56216], [-121.99678, 39.56214], [-121.99612, 39.56208], [-121.99553, 39.56205], [-121.99479, 39.56198], [-121.99405, 39.56205], [-121.99334, 39.56225], [-121.99307, 39.56201], [-121.99299, 39.5624], [-121.99267, 39.56255], [-121.99254, 39.56256], [-121.99223, 39.56206], [-121.99223, 39.56278], [-121.99202, 39.5629], [-121.99105, 39.56295], [-121.99048, 39.56269], [-121.99049, 39.56174], [-121.99005, 39.56026], [-121.99016, 39.55991], [-121.99107, 39.55867], [-121.99143, 39.55837], [-121.99224, 39.55796], [-121.99316, 39.55774], [-121.99448, 39.55786], [-121.99569, 39.55781], [-121.99659, 39.55806], [-121.99659, 39.55849], [-121.99763, 39.5587], [-121.99784, 39.55903], [-121.99897, 39.55913], [-121.99977, 39.55929], [-122.00167, 39.5595], [-122.00208, 39.55937]]]]} | Restricted Access 2 | 25275 | Butte Sink Wildlife Management Area | 16605 | 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 | Butte 42 | 655.167 | Butte Sink WMA | 1980 | Conservation Area 13 | 2 | |
16397 | 16397 | 16396 | {"type": "Polygon", "coordinates": [[[-121.84941, 36.95765], [-121.84932, 36.95782], [-121.84903, 36.95804], [-121.84861, 36.95819], [-121.84853, 36.95827], [-121.84855, 36.95846], [-121.84801, 36.95847], [-121.84779, 36.95855], [-121.84752, 36.95899], [-121.84755, 36.9599], [-121.84699, 36.96071], [-121.84698, 36.96089], [-121.84729, 36.9623], [-121.84754, 36.96307], [-121.84617, 36.96314], [-121.84616, 36.96255], [-121.84619, 36.96183], [-121.84626, 36.96086], [-121.84627, 36.96017], [-121.84642, 36.95971], [-121.84642, 36.95919], [-121.84636, 36.95864], [-121.8462, 36.95828], [-121.84591, 36.95775], [-121.84515, 36.95702], [-121.84454, 36.9566], [-121.8446, 36.95623], [-121.8467, 36.95564], [-121.84709, 36.95597], [-121.84741, 36.9562], [-121.84775, 36.95682], [-121.8479, 36.95696], [-121.84802, 36.95701], [-121.84854, 36.95701], [-121.84879, 36.95719], [-121.84941, 36.95751], [-121.84941, 36.95765]]]} | Restricted Access 2 | 1387 | Ellicott Slough National Wildlife Area | 18587 | 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 | Santa Cruz 5 | 31.059 | Ellicott Slough Nat. Wildlife Area | 0 | Conservation Area 13 | 2 | |
16776 | 16776 | 16775 | {"type": "MultiPolygon", "coordinates": [[[[-121.98913, 39.63463], [-121.98831, 39.63516], [-121.98797, 39.6354], [-121.98776, 39.63558], [-121.98765, 39.63558], [-121.98749, 39.6358], [-121.98755, 39.63615], [-121.98734, 39.63669], [-121.98688, 39.63727], [-121.9863, 39.63822], [-121.98608, 39.63885], [-121.98592, 39.63988], [-121.98601, 39.64065], [-121.98631, 39.6418], [-121.98624, 39.64203], [-121.98624, 39.64253], [-121.98601, 39.64333], [-121.98612, 39.64348], [-121.98607, 39.64397], [-121.98652, 39.64403], [-121.98688, 39.6436], [-121.98761, 39.64346], [-121.98865, 39.64425], [-121.98794, 39.64442], [-121.98673, 39.64509], [-121.98542, 39.64584], [-121.98493, 39.64621], [-121.98419, 39.64662], [-121.98339, 39.64702], [-121.9828, 39.64725], [-121.98205, 39.64712], [-121.98178, 39.64703], [-121.98158, 39.64694], [-121.98098, 39.64676], [-121.98063, 39.64671], [-121.98033, 39.64664], [-121.97991, 39.64649], [-121.97959, 39.64641], [-121.97929, 39.64631], [-121.97908, 39.64626], [-121.97838, 39.64628], [-121.9781, 39.64627], [-121.97779, 39.64631], [-121.97737, 39.64639], [-121.97718, 39.64637], [-121.97465, 39.64655], [-121.97397, 39.64654], [-121.9728, 39.64632], [-121.97186, 39.64627], [-121.97155, 39.64611], [-121.97104, 39.64611], [-121.97061, 39.64618], [-121.97054, 39.64621], [-121.9702, 39.64641], [-121.96981, 39.64641], [-121.96931, 39.64637], [-121.95954, 39.63596], [-121.94593, 39.6374], [-121.94593, 39.63729], [-121.96613, 39.63515], [-121.97408, 39.63512], [-121.98913, 39.63463]]], [[[-121.99123, 39.75232], [-121.99, 39.75229], [-121.98999, 39.75234], [-121.98506, 39.75224], [-121.98404, 39.75224], [-121.98309, 39.75228], [-121.97719, 39.75269], [-121.97711, 39.75211], [-121.9764, 39.75237], [-121.97545, 39.7526], [-121.97547, 39.75281], [-121.97116, 39.75311], [-121.971, 39.75288], [-121.97049, 39.7526], [-121.97054, 39.75137], [-121.9704, 39.75094], [-121.96994, 39.7503], [-121.9693, 39.74961], [-121.96879, 39.74862], [-121.96846, 39.7478], [-121.96795, 39.74694], [-121.96753, 39.74646], [-121.9668, 39.74587], [-121.96646, 39.74517], [-121.96496, 39.74394], [-121.96459, 39.74317], [-121.96501, 39.74308], [-121.96556, 39.74391], [-121.96597, 39.74414], [-121.96624, 39.74453], [-121.96704, 39.74499], [-121.9671, 39.74545], [-121.96732, 39.74577], [-121.96763, 39.74605], [-121.96783, 39.74617], [-121.9683, 39.74667], [-121.96866, 39.74703], [-121.96905, 39.74725], [-121.96987, 39.747], [-121.97061, 39.74684], [-121.97208, 39.74673], [-121.97208, 39.74672], [-121.97032, 39.74409], [-121.97098, 39.74429], [-121.97197, 39.74384], [-121.972, 39.74316], [-121.97183, 39.74314], [-121.97049, 39.74113], [-121.97132, 39.74041], [-121.97284, 39.73962], [-121.97339, 39.74061], [-121.97416, 39.74024], [-121.97586, 39.73968], [-121.97714, 39.73933], [-121.97804, 39.73881], [-121.98153, 39.73829], [-121.98383, 39.73861], [-121.98411, 39.73877], [-121.98426, 39.73892], [-121.98435, 39.73919], [-121.98518, 39.74006], [-121.9855, 39.74045], [-121.98572, 39.74075], [-121.98578, 39.7408], [-121.98585, 39.74081], [-121.98589, 39.74085], [-121.98586, 39.74091], [-121.98636, 39.74153], [-121.98678, 39.74197], [-121.98577, 39.7422], [-121.98576, 39.74221], [-121.98689, 39.74383], [-121.98885, 39.74673], [-121.98861, 39.74682], [-121.98861, 39.74683], [-121.99123, 39.75232]]], [[[-121.97773, 39.64853], [-121.97603, 39.64885], [-121.97523, 39.64892], [-121.97472, 39.64892], [-121.97359, 39.64858], [-121.97173, 39.64826], [-121.97128, 39.64822], [-121.97152, 39.64786], [-121.97218, 39.64738], [-121.97261, 39.64717], [-121.97322, 39.64712], [-121.97362, 39.64721], [-121.97413, 39.64739], [-121.97509, 39.6476], [-121.97548, 39.64763], [-121.97617, 39.64778], [-121.97666, 39.64795], [-121.97728, 39.64824], [-121.97773, 39.64853]]], [[[-121.99226, 39.63886], [-121.99217, 39.6388], [-121.99202, 39.63862], [-121.99216, 39.63863], [-121.99226, 39.63886]]], [[[-122.03253, 39.7796], [-122.03181, 39.78056], [-122.03077, 39.78182], [-122.03027, 39.78147], [-122.02994, 39.78126], [-122.02965, 39.78102], [-122.02921, 39.78045], [-122.02898, 39.78008], [-122.02888, 39.77978], [-122.02882, 39.77941], [-122.02881, 39.7791], [-122.02883, 39.77883], [-122.02887, 39.77872], [-122.02892, 39.77865], [-122.02899, 39.77864], [-122.02913, 39.77872], [-122.02917, 39.77871], [-122.02936, 39.77803], [-122.02952, 39.77773], [-122.02973, 39.77756], [-122.0315, 39.77754], [-122.03199, 39.7782], [-122.03253, 39.7796]]]]} | Restricted Access 2 | 8354 | Butte Sink Wildlife Management Area | 16605 | 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 | Butte 42 | 1202.727 | Butte Sink WMA | 1980 | Conservation Area 13 | 2 | |
16789 | 16789 | 16788 | {"type": "MultiPolygon", "coordinates": [[[[-120.74252, 37.27339], [-120.73801, 37.28775], [-120.73803, 37.29353], [-120.72413, 37.29258], [-120.72414, 37.28789], [-120.71512, 37.28784], [-120.71515, 37.2805], [-120.70615, 37.28052], [-120.70625, 37.26775], [-120.70642, 37.25213], [-120.70653, 37.25216], [-120.70654, 37.25215], [-120.70641, 37.2521], [-120.70645, 37.2499], [-120.70639, 37.24428], [-120.70665, 37.24428], [-120.70702, 37.24491], [-120.70732, 37.24525], [-120.71901, 37.2545], [-120.72423, 37.25905], [-120.73083, 37.26454], [-120.73586, 37.26762], [-120.74252, 37.27339]]], [[[-120.85194, 37.24763], [-120.85193, 37.24991], [-120.8519, 37.25195], [-120.85118, 37.25691], [-120.8512, 37.26022], [-120.85118, 37.27587], [-120.85119, 37.29287], [-120.85117, 37.29466], [-120.85051, 37.29446], [-120.84875, 37.29431], [-120.84796, 37.29407], [-120.84712, 37.29378], [-120.84611, 37.29362], [-120.84403, 37.29454], [-120.84249, 37.29477], [-120.84174, 37.29435], [-120.84255, 37.2932], [-120.84234, 37.29211], [-120.84212, 37.29197], [-120.84232, 37.29178], [-120.84266, 37.2917], [-120.84287, 37.29154], [-120.84305, 37.29131], [-120.84329, 37.29097], [-120.84436, 37.29066], [-120.84487, 37.28979], [-120.84492, 37.2888], [-120.84475, 37.28831], [-120.84376, 37.28554], [-120.84296, 37.28441], [-120.84333, 37.28298], [-120.84367, 37.28206], [-120.84364, 37.28158], [-120.84265, 37.28125], [-120.8423, 37.28126], [-120.84202, 37.28155], [-120.84084, 37.28229], [-120.8399, 37.2828], [-120.83792, 37.28341], [-120.83728, 37.28345], [-120.83693, 37.2834], [-120.83652, 37.28314], [-120.8353, 37.28266], [-120.83461, 37.28243], [-120.83346, 37.28186], [-120.83313, 37.28166], [-120.83145, 37.28131], [-120.83075, 37.2804], [-120.82988, 37.28012], [-120.82941, 37.28006], [-120.82891, 37.28012], [-120.82781, 37.28071], [-120.82674, 37.28065], [-120.82668, 37.28014], [-120.82746, 37.27962], [-120.82848, 37.27936], [-120.82902, 37.27931], [-120.82951, 37.27916], [-120.83005, 37.27901], [-120.83074, 37.27865], [-120.83166, 37.27853], [-120.83174, 37.27803], [-120.83153, 37.27737], [-120.83071, 37.27651], [-120.82901, 37.27551], [-120.82839, 37.27501], [-120.828, 37.27449], [-120.82758, 37.27416], [-120.82746, 37.27415], [-120.82721, 37.27384], [-120.82694, 37.2734], [-120.8268, 37.27295], [-120.82683, 37.27157], [-120.82699, 37.27105], [-120.82744, 37.27045], [-120.82822, 37.26968], [-120.82884, 37.26958], [-120.82942, 37.26917], [-120.82932, 37.27003], [-120.82952, 37.27116], [-120.82984, 37.2715], [-120.83055, 37.27171], [-120.83143, 37.27151], [-120.83201, 37.27086], [-120.83243, 37.26846], [-120.83273, 37.26788], [-120.8329, 37.26747], [-120.83266, 37.26632], [-120.83229, 37.26584], [-120.83111, 37.26585], [-120.8306, 37.26615], [-120.82954, 37.26657], [-120.82816, 37.26687], [-120.82773, 37.2667], [-120.82766, 37.26637], [-120.82814, 37.26572], [-120.82941, 37.26468], [-120.83006, 37.26402], [-120.83055, 37.26377], [-120.83075, 37.26342], [-120.83091, 37.26296], [-120.83103, 37.26243], [-120.83123, 37.26215], [-120.83134, 37.26163], [-120.83029, 37.26066], [-120.82984, 37.25999], [-120.82979, 37.25963], [-120.82946, 37.25997], [-120.82945, 37.25983], [-120.81555, 37.25869], [-120.81536, 37.27295], [-120.81281, 37.27297], [-120.81034, 37.27066], [-120.80641, 37.26816], [-120.80429, 37.26568], [-120.80294, 37.26417], [-120.80086, 37.2619], [-120.7972, 37.26047], [-120.79462, 37.26047], [-120.79222, 37.2564], [-120.79063, 37.25607], [-120.7898, 37.25668], [-120.7882, 37.25662], [-120.7863, 37.25551], [-120.78269, 37.25634], [-120.77959, 37.25569], [-120.7768, 37.25676], [-120.76999, 37.2572], [-120.76637, 37.25882], [-120.76432, 37.25878], [-120.76431, 37.25882], [-120.76082, 37.25881], [-120.76082, 37.26605], [-120.75626, 37.26611], [-120.7565, 37.27746], [-120.74319, 37.27327], [-120.74299, 37.2732], [-120.7427, 37.27291], [-120.74264, 37.259], [-120.74261, 37.25898], [-120.74259, 37.25155], [-120.74259, 37.24989], [-120.74269, 37.24434], [-120.74267, 37.24043], [-120.74265, 37.22992], [-120.74917, 37.22993], [-120.751, 37.22997], [-120.75999, 37.22993], [-120.76078, 37.22982], [-120.76081, 37.24439], [-120.77891, 37.24433], [-120.77899, 37.22991], [-120.77942, 37.22992], [-120.77943, 37.22991], [-120.77945, 37.22269], [-120.77944, 37.22268], [-120.77912, 37.22269], [-120.77909, 37.22973], [-120.77898, 37.22973], [-120.77903, 37.22281], [-120.77902, 37.21892], [-120.77904, 37.21359], [-120.77974, 37.21321], [-120.78051, 37.21301], [-120.78131, 37.21298], [-120.78217, 37.21315], [-120.7827, 37.21385], [-120.78281, 37.21451], [-120.78336, 37.21478], [-120.7837, 37.21528], [-120.78312, 37.21704], [-120.78341, 37.21808], [-120.78344, 37.21884], [-120.78296, 37.21992], [-120.7831, 37.22054], [-120.78371, 37.22157], [-120.78507, 37.22288], [-120.7854, 37.2229], [-120.78609, 37.22237], [-120.78768, 37.22177], [-120.78963, 37.22157], [-120.79073, 37.22166], [-120.7915, 37.22221], [-120.79242, 37.22255], [-120.79346, 37.22264], [-120.79384, 37.22172], [-120.79529, 37.22218], [-120.79745, 37.22224], [-120.79819, 37.22262], [-120.79904, 37.22276], [-120.79952, 37.22312], [-120.7999, 37.22391], [-120.79999, 37.22457], [-120.80051, 37.22528], [-120.80091, 37.22561], [-120.80208, 37.22604], [-120.80281, 37.22599], [-120.80388, 37.22556], [-120.8043, 37.22564], [-120.80482, 37.22613], [-120.80484, 37.22691], [-120.80491, 37.22787], [-120.80532, 37.22874], [-120.80597, 37.22945], [-120.80642, 37.22977], [-120.80665, 37.22979], [-120.80793, 37.22805], [-120.80897, 37.22843], [-120.80989, 37.22953], [-120.81019, 37.2304], [-120.80994, 37.23241], [-120.80997, 37.2329], [-120.80995, 37.23294], [-120.80996, 37.23295], [-120.83466, 37.21965], [-120.83507, 37.22048], [-120.83537, 37.22099], [-120.83607, 37.22144], [-120.83635, 37.22194], [-120.83628, 37.22285], [-120.83589, 37.22382], [-120.83618, 37.22416], [-120.83666, 37.22434], [-120.83801, 37.22413], [-120.83924, 37.22397], [-120.8399, 37.22384], [-120.84047, 37.22403], [-120.84204, 37.22424], [-120.84265, 37.22455], [-120.84307, 37.22507], [-120.84316, 37.22596], [-120.8429, 37.22701], [-120.84161, 37.22791], [-120.84124, 37.22828], [-120.84101, 37.2288], [-120.84113, 37.22934], [-120.84163, 37.22975], [-120.84299, 37.22997], [-120.8433, 37.23141], [-120.84375, 37.23193], [-120.84443, 37.23229], [-120.84467, 37.23295], [-120.84448, 37.23427], [-120.84441, 37.23468], [-120.84445, 37.235], [-120.84447, 37.23586], [-120.84527, 37.23647], [-120.84603, 37.23636], [-120.84692, 37.23643], [-120.84749, 37.23689], [-120.84773, 37.23721], [-120.84782, 37.23771], [-120.84776, 37.23829], [-120.84772, 37.2388], [-120.84761, 37.23955], [-120.84745, 37.23979], [-120.84696, 37.24014], [-120.84634, 37.24028], [-120.84501, 37.24012], [-120.8443, 37.24082], [-120.84436, 37.24127], [-120.84425, 37.24161], [-120.84397, 37.24265], [-120.84466, 37.24361], [-120.84533, 37.2439], [-120.84672, 37.24387], [-120.84744, 37.24424], [-120.84785, 37.24463], [-120.84846, 37.24507], [-120.84873, 37.24552], [-120.84868, 37.24578], [-120.84831, 37.24618], [-120.84832, 37.2462], [-120.84907, 37.24651], [-120.84919, 37.24655], [-120.84998, 37.24643], [-120.85036, 37.24607], [-120.85075, 37.24582], [-120.85127, 37.24631], [-120.85123, 37.24707], [-120.85137, 37.24739], [-120.85194, 37.24763]], [[-120.83487, 37.2587], [-120.83483, 37.25799], [-120.83458, 37.25776], [-120.83409, 37.25753], [-120.83398, 37.25719], [-120.83326, 37.257], [-120.833, 37.25675], [-120.83297, 37.25598], [-120.83266, 37.2557], [-120.83177, 37.25559], [-120.83093, 37.25593], [-120.83093, 37.25633], [-120.83094, 37.25634], [-120.83149, 37.25595], [-120.83206, 37.25591], [-120.83237, 37.256], [-120.83257, 37.25668], [-120.83275, 37.2568], [-120.8328, 37.25696], [-120.83312, 37.25717], [-120.83349, 37.25721], [-120.83383, 37.25737], [-120.83378, 37.25767], [-120.83343, 37.25808], [-120.83346, 37.25824], [-120.83426, 37.2587], [-120.83492, 37.2594], [-120.83518, 37.25941], [-120.83521, 37.25922], [-120.83487, 37.2587]], [[-120.83243, 37.25842], [-120.83243, 37.25767], [-120.8312, 37.25698], [-120.83103, 37.25694], [-120.83094, 37.25696], [-120.83094, 37.25742], [-120.83114, 37.25765], [-120.83123, 37.25835], [-120.83277, 37.25929], [-120.83294, 37.25929], [-120.83289, 37.259], [-120.83243, 37.25842]], [[-120.78869, 37.22995], [-120.78863, 37.22968], [-120.78917, 37.22895], [-120.7892, 37.22851], [-120.78869, 37.22792], [-120.78626, 37.22666], [-120.78285, 37.22599], [-120.7826, 37.22597], [-120.78219, 37.22627], [-120.78194, 37.22663], [-120.78194, 37.22712], [-120.78285, 37.22808], [-120.78299, 37.22842], [-120.78302, 37.22902], [-120.78316, 37.22943], [-120.78351, 37.23009], [-120.78382, 37.23029], [-120.78485, 37.23039], [-120.78537, 37.2305], [-120.78643, 37.23162], [-120.78674, 37.23213], [-120.78711, 37.23298], [-120.78746, 37.23345], [-120.78797, 37.23389], [-120.79009, 37.23474], [-120.79055, 37.2348], [-120.79152, 37.23462], [-120.79223, 37.23435], [-120.79324, 37.23353], [-120.79326, 37.23325], [-120.79232, 37.23243], [-120.79052, 37.23119], [-120.78975, 37.23087], [-120.78909, 37.23043], [-120.78869, 37.22995]]]]} | Restricted Access 2 | 31036 | Grasslands Wildlife Management Area | 19449 | 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 | Merced 37 | 12351.617 | Grasslands WMA | 1979 | Conservation Area 13 | 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]);