calands: superunits_with_maps: 1 row where ACCESS_TYP = 1, MNG_AGENCY = 25 and PARK

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where ACCESS_TYP = 1, MNG_AGENCY = 25 and PARK_NAME = "Eel River Wildlife Area"

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME	YR_EST
11831	11831	11830	{"type": "MultiPolygon", "coordinates": [[[[-124.23591, 40.62486], [-124.2359, 40.62813], [-124.22611, 40.6281], [-124.22611, 40.62394], [-124.22609, 40.62237], [-124.23162, 40.6224], [-124.23226, 40.62486], [-124.23591, 40.62486]]], [[[-124.31116, 40.64446], [-124.31115, 40.64461], [-124.31054, 40.64573], [-124.31025, 40.64607], [-124.30989, 40.64659], [-124.30964, 40.64708], [-124.30933, 40.64763], [-124.30914, 40.64789], [-124.3087, 40.64864], [-124.30827, 40.64901], [-124.30808, 40.64923], [-124.30799, 40.64945], [-124.30774, 40.64984], [-124.30671, 40.65123], [-124.30664, 40.65147], [-124.30659, 40.6518], [-124.30642, 40.6521], [-124.30575, 40.65306], [-124.30537, 40.65385], [-124.30525, 40.65405], [-124.30506, 40.65423], [-124.30489, 40.65448], [-124.3047, 40.65469], [-124.30447, 40.65505], [-124.30424, 40.6553], [-124.30383, 40.65592], [-124.30348, 40.65658], [-124.3033, 40.65683], [-124.30301, 40.65745], [-124.30282, 40.6577], [-124.30249, 40.65834], [-124.30221, 40.65877], [-124.30207, 40.65894], [-124.30183, 40.65912], [-124.30146, 40.65959], [-124.30117, 40.66003], [-124.30091, 40.66054], [-124.30043, 40.66138], [-124.30029, 40.66157], [-124.30012, 40.66171], [-124.29998, 40.66192], [-124.29981, 40.6621], [-124.29964, 40.66237], [-124.29954, 40.66261], [-124.2994, 40.66278], [-124.29899, 40.66337], [-124.29882, 40.66399], [-124.29783, 40.66571], [-124.29775, 40.66583], [-124.29761, 40.66597], [-124.29744, 40.66627], [-124.29721, 40.66653], [-124.29667, 40.66755], [-124.29586, 40.66884], [-124.2956, 40.66943], [-124.29493, 40.67043], [-124.29447, 40.671], [-124.29409, 40.67156], [-124.2939, 40.67187], [-124.29377, 40.67214], [-124.29323, 40.673], [-124.29303, 40.67322], [-124.29265, 40.67381], [-124.29237, 40.67411], [-124.29209, 40.67449], [-124.29204, 40.67459], [-124.29169, 40.6751], [-124.29081, 40.67643], [-124.29065, 40.67649], [-124.29047, 40.67688], [-124.28973, 40.67789], [-124.28959, 40.67814], [-124.2894, 40.67861], [-124.28933, 40.67894], [-124.28904, 40.67942], [-124.28903, 40.67947], [-124.28891, 40.67972], [-124.28857, 40.6802], [-124.28836, 40.68046], [-124.28815, 40.68068], [-124.28772, 40.68144], [-124.28721, 40.68211], [-124.28711, 40.68234], [-124.28692, 40.68264], [-124.28643, 40.68319], [-124.28603, 40.68377], [-124.28574, 40.68428], [-124.28521, 40.68497], [-124.28487, 40.68554], [-124.28448, 40.68601], [-124.28431, 40.68634], [-124.28383, 40.68714], [-124.28368, 40.68741], [-124.28315, 40.68817], [-124.28267, 40.68843], [-124.28247, 40.68897], [-124.28215, 40.68932], [-124.28206, 40.68953], [-124.28182, 40.68988], [-124.28076, 40.6909], [-124.28075, 40.69125], [-124.28064, 40.69139], [-124.28039, 40.6919], [-124.28009, 40.69265], [-124.27971, 40.69303], [-124.27956, 40.69313], [-124.27935, 40.69336], [-124.27916, 40.69351], [-124.279, 40.69371], [-124.27885, 40.69384], [-124.27875, 40.69396], [-124.27854, 40.69405], [-124.27856, 40.69416], [-124.2785, 40.69422], [-124.27805, 40.69487], [-124.27789, 40.69501], [-124.27774, 40.69522], [-124.27744, 40.69574], [-124.27693, 40.69642], [-124.27482, 40.69643], [-124.27481, 40.69602], [-124.2755, 40.696], [-124.27553, 40.69554], [-124.27565, 40.69528], [-124.27545, 40.69514], [-124.27569, 40.69493], [-124.27574, 40.69469], [-124.27555, 40.69402], [-124.27424, 40.69403], [-124.27363, 40.69412], [-124.27268, 40.69351], [-124.27307, 40.69196], [-124.27134, 40.69119], [-124.27049, 40.69025], [-124.26536, 40.6877], [-124.26503, 40.68727], [-124.26498, 40.68723], [-124.26428, 40.68722], [-124.26433, 40.68269], [-124.26476, 40.68237], [-124.26467, 40.68223], [-124.26477, 40.68218], [-124.26489, 40.68228], [-124.2662, 40.68287], [-124.27046, 40.68488], [-124.27231, 40.68449], [-124.27274, 40.68322], [-124.27275, 40.68195], [-124.27034, 40.6806], [-124.27461, 40.67996], [-124.276, 40.67934], [-124.27773, 40.67904], [-124.27883, 40.67833], [-124.27958, 40.67726], [-124.27987, 40.67652], [-124.28027, 40.67621], [-124.28156, 40.67629], [-124.28225, 40.67616], [-124.28319, 40.67503], [-124.28351, 40.67407], [-124.2835, 40.67358], [-124.28363, 40.67284], [-124.28372, 40.67247], [-124.28381, 40.67229], [-124.28424, 40.67107], [-124.28513, 40.67], [-124.28615, 40.66846], [-124.28714, 40.6671], [-124.28781, 40.66626], [-124.28799, 40.66618], [-124.2882, 40.66605], [-124.28917, 40.66567], [-124.28971, 40.66534], [-124.28974, 40.66534], [-124.28994, 40.66517], [-124.29035, 40.6646], [-124.29258, 40.66438], [-124.29319, 40.66417], [-124.29375, 40.66404], [-124.29458, 40.66374], [-124.29521, 40.66342], [-124.29594, 40.66292], [-124.29649, 40.66243], [-124.2974, 40.66178], [-124.29787, 40.66154], [-124.29792, 40.66141], [-124.29803, 40.66127], [-124.29856, 40.66069], [-124.29878, 40.66051], [-124.29893, 40.66035], [-124.29914, 40.6602], [-124.29937, 40.65999], [-124.2996, 40.65985], [-124.29973, 40.65971], [-124.30005, 40.65921], [-124.30014, 40.65901], [-124.30029, 40.65862], [-124.30039, 40.65844], [-124.30053, 40.65831], [-124.30088, 40.65808], [-124.30101, 40.6578], [-124.30124, 40.65743], [-124.30181, 40.65658], [-124.30225, 40.65598], [-124.30256, 40.65548], [-124.30269, 40.65513], [-124.30282, 40.6549], [-124.30301, 40.65469], [-124.30348, 40.65379], [-124.30371, 40.65344], [-124.30398, 40.65318], [-124.30416, 40.65293], [-124.30468, 40.65192], [-124.30522, 40.651], [-124.30572, 40.64956], [-124.30609, 40.6488], [-124.30642, 40.64819], [-124.30654, 40.648], [-124.30667, 40.64788], [-124.30681, 40.64778], [-124.3077, 40.64663], [-124.3078, 40.64619], [-124.30787, 40.64606], [-124.30813, 40.64527], [-124.30838, 40.64475], [-124.30846, 40.64461], [-124.30848, 40.64451], [-124.30843, 40.64437], [-124.30833, 40.64426], [-124.3085, 40.64381], [-124.30863, 40.64309], [-124.31114, 40.6431], [-124.31115, 40.64314], [-124.31103, 40.6433], [-124.31108, 40.64343], [-124.31089, 40.64377], [-124.31088, 40.64399], [-124.31116, 40.64446]]], [[[-124.29993, 40.65464], [-124.29944, 40.65464], [-124.29923, 40.65488], [-124.29899, 40.65506], [-124.29897, 40.65523], [-124.29733, 40.65758], [-124.29701, 40.65817], [-124.29695, 40.65818], [-124.29667, 40.65834], [-124.29641, 40.65843], [-124.29619, 40.65844], [-124.29608, 40.65843], [-124.29598, 40.65856], [-124.29598, 40.65866], [-124.29602, 40.6588], [-124.29602, 40.65896], [-124.29595, 40.6592], [-124.2957, 40.65947], [-124.29539, 40.65974], [-124.29502, 40.66001], [-124.29422, 40.66039], [-124.29377, 40.66057], [-124.29339, 40.6607], [-124.29264, 40.66079], [-124.29228, 40.6608], [-124.29202, 40.66075], [-124.29169, 40.6607], [-124.29138, 40.66068], [-124.29, 40.66036], [-124.28947, 40.66025], [-124.28831, 40.65989], [-124.28716, 40.65948], [-124.28652, 40.65919], [-124.28598, 40.6589], [-124.28542, 40.65875], [-124.28433, 40.6586], [-124.28372, 40.65864], [-124.28293, 40.65881], [-124.28225, 40.65888], [-124.2816, 40.65899], [-124.28106, 40.65914], [-124.28028, 40.65925], [-124.27972, 40.65936], [-124.27875, 40.65947], [-124.27824, 40.6595], [-124.27761, 40.65956], [-124.2766, 40.65953], [-124.27574, 40.65941], [-124.27502, 40.65913], [-124.27412, 40.65866], [-124.27368, 40.65841], [-124.27317, 40.65804], [-124.27235, 40.65748], [-124.27184, 40.65706], [-124.27185, 40.65704], [-124.27168, 40.65689], [-124.27163, 40.65649], [-124.27176, 40.65618], [-124.27206, 40.65578], [-124.27237, 40.6555], [-124.27274, 40.65521], [-124.27375, 40.65451], [-124.29306, 40.6546], [-124.29324, 40.64313], [-124.29582, 40.64311], [-124.29628, 40.64378], [-124.29629, 40.64401], [-124.29642, 40.64428], [-124.29714, 40.64519], [-124.29752, 40.64587], [-124.29779, 40.64628], [-124.29791, 40.64675], [-124.29795, 40.64711], [-124.2981, 40.6475], [-124.29818, 40.64802], [-124.29822, 40.64866], [-124.29812, 40.64929], [-124.29797, 40.65003], [-124.29791, 40.65081], [-124.29814, 40.65152], [-124.29858, 40.65236], [-124.29892, 40.65281], [-124.29936, 40.65322], [-124.29972, 40.65365], [-124.29982, 40.65427], [-124.29979, 40.6544], [-124.29982, 40.65449], [-124.29993, 40.65461], [-124.29993, 40.65464]]], [[[-124.29296, 40.63205], [-124.29294, 40.63217], [-124.29068, 40.63292], [-124.28977, 40.63307], [-124.28902, 40.63311], [-124.28871, 40.63316], [-124.2881, 40.63339], [-124.28685, 40.63403], [-124.28617, 40.63435], [-124.28592, 40.63445], [-124.28592, 40.63448], [-124.2861, 40.63448], [-124.28591, 40.6346], [-124.28543, 40.63476], [-124.28504, 40.63493], [-124.28461, 40.63507], [-124.28397, 40.63521], [-124.28363, 40.63526], [-124.28332, 40.63534], [-124.28265, 40.63558], [-124.28231, 40.63576], [-124.28193, 40.63588], [-124.28166, 40.63592], [-124.28136, 40.63603], [-124.28102, 40.6361], [-124.2807, 40.63609], [-124.28048, 40.63612], [-124.28011, 40.63607], [-124.27978, 40.63597], [-124.27957, 40.63577], [-124.27914, 40.63553], [-124.27874, 40.63523], [-124.2786, 40.63499], [-124.27846, 40.63481], [-124.27806, 40.63416], [-124.27733, 40.63334], [-124.27626, 40.6316], [-124.27607, 40.63138], [-124.27594, 40.63136], [-124.2757, 40.63157], [-124.27565, 40.63172], [-124.27558, 40.63219], [-124.27558, 40.63239], [-124.27563, 40.63274], [-124.27572, 40.63301], [-124.27605, 40.63343], [-124.27624, 40.63363], [-124.27646, 40.63396], [-124.2768, 40.63455], [-124.27675, 40.63452], [-124.27611, 40.63351], [-124.27558, 40.6329], [-124.27551, 40.63228], [-124.27552, 40.63197], [-124.27494, 40.63087], [-124.27424, 40.63006], [-124.27407, 40.62994], [-124.27398, 40.62991], [-124.27399, 40.6279], [-124.27401, 40.62792], [-124.2742, 40.62838], [-124.27878, 40.62839], [-124.27866, 40.62488], [-124.2786, 40.62486], [-124.27849, 40.62246], [-124.27864, 40.62245], [-124.27988, 40.62261], [-124.28304, 40.62352], [-124.28307, 40.62366], [-124.28348, 40.62366], [-124.2839, 40.62378], [-124.28611, 40.62494], [-124.28781, 40.62633], [-124.28838, 40.62734], [-124.28872, 40.62842], [-124.29289, 40.63188], [-124.29281, 40.63189], [-124.2928, 40.6319], [-124.29296, 40.63205]]], [[[-124.31593, 40.62053], [-124.31553, 40.62104], [-124.31468, 40.62164], [-124.31377, 40.6219], [-124.31329, 40.62201], [-124.31314, 40.62145], [-124.31306, 40.62104], [-124.31272, 40.62061], [-124.31255, 40.61986], [-124.31221, 40.61961], [-124.31183, 40.61962], [-124.31159, 40.61969], [-124.31112, 40.61963], [-124.31008, 40.61965], [-124.30899, 40.61993], [-124.30856, 40.61979], [-124.30827, 40.61947], [-124.30821, 40.61915], [-124.30819, 40.61887], [-124.30773, 40.61901], [-124.30702, 40.61907], [-124.30622, 40.61915], [-124.30603, 40.61919], [-124.30588, 40.61901], [-124.30588, 40.61887], [-124.3061, 40.61851], [-124.30618, 40.61821], [-124.30603, 40.61778], [-124.30573, 40.61747], [-124.3053, 40.61755], [-124.30489, 40.61784], [-124.30448, 40.61821], [-124.30391, 40.61822], [-124.30315, 40.61809], [-124.30261, 40.61771], [-124.30246, 40.61746], [-124.30264, 40.61706], [-124.30283, 40.61702], [-124.30283, 40.61386], [-124.29813, 40.61384], [-124.29814, 40.61022], [-124.29422, 40.61017], [-124.29423, 40.60651], [-124.29437, 40.59613], [-124.29339, 40.5962], [-124.29148, 40.59686], [-124.29059, 40.59704], [-124.28988, 40.59728], [-124.28905, 40.59761], [-124.28873, 40.59768], [-124.28755, 40.59739], [-124.28689, 40.59702], [-124.28633, 40.5968], [-124.2858, 40.59669], [-124.28562, 40.59688], [-124.28463, 40.5969], [-124.28404, 40.59707], [-124.28281, 40.59758], [-124.28142, 40.59785], [-124.28037, 40.59793], [-124.27906, 40.5978], [-124.27849, 40.59769], [-124.2779, 40.59755], [-124.27738, 40.59734], [-124.27653, 40.59692], [-124.27611, 40.59665], [-124.2754, 40.59613], [-124.27499, 40.59579], [-124.27469, 40.59552], [-124.27441, 40.59522], [-124.27465, 40.59498], [-124.27596, 40.59544], [-124.27633, 40.59585], [-124.27656, 40.59606], [-124.27722, 40.59659], [-124.27753, 40.59677], [-124.27868, 40.59726], [-124.27912, 40.59738], [-124.2794, 40.59742], [-124.28087, 40.59753], [-124.28138, 40.59748], [-124.28288, 40.59711], [-124.28308, 40.59703], [-124.28404, 40.5965], [-124.28407, 40.59663], [-124.28498, 40.59629], [-124.28574, 40.59611], [-124.28613, 40.59621], [-124.28662, 40.59637], [-124.28731, 40.59665], [-124.28862, 40.59683], [-124.28897, 40.59675], [-124.28921, 40.59664], [-124.29006, 40.5964], [-124.29101, 40.59618], [-124.29153, 40.59604], [-124.2922, 40.59582], [-124.29294, 40.59542], [-124.29328, 40.59532], [-124.29364, 40.59529], [-124.29356, 40.59567], [-124.29438, 40.59575], [-124.29438, 40.59612], [-124.29475, 40.59614], [-124.29572, 40.5969], [-124.29929, 40.59989], [-124.30012, 40.60171], [-124.30028, 40.60309], [-124.3002, 40.60375], [-124.30105, 40.60764], [-124.30168, 40.60931], [-124.30245, 40.61027], [-124.30352, 40.61109], [-124.30439, 40.61142], [-124.30544, 40.61129], [-124.30654, 40.61073], [-124.30796, 40.61006], [-124.30903, 40.60987], [-124.30992, 40.61009], [-124.3105, 40.61119], [-124.31117, 40.61315], [-124.31174, 40.61425], [-124.31185, 40.6164], [-124.31219, 40.61722], [-124.31545, 40.61905], [-124.31583, 40.61969], [-124.31593, 40.62053]]], [[[-124.29499, 40.62785], [-124.29305, 40.62718], [-124.29171, 40.627], [-124.28854, 40.6261], [-124.28704, 40.62361], [-124.293, 40.62555], [-124.29496, 40.62606], [-124.29499, 40.62785]]], [[[-124.30413, 40.6482], [-124.3029, 40.65144], [-124.30278, 40.65166], [-124.30273, 40.65195], [-124.30213, 40.65243], [-124.30124, 40.65309], [-124.30089, 40.65322], [-124.30034, 40.65312], [-124.29988, 40.6529], [-124.29969, 40.65276], [-124.29921, 40.65236], [-124.2989, 40.65207], [-124.2986, 40.65159], [-124.2984, 40.65087], [-124.29832, 40.65039], [-124.29837, 40.64934], [-124.29856, 40.64854], [-124.29854, 40.64802], [-124.29834, 40.64717], [-124.29802, 40.64598], [-124.29689, 40.64341], [-124.29681, 40.64303], [-124.30313, 40.64306], [-124.3032, 40.64349], [-124.30317, 40.64353], [-124.30322, 40.64357], [-124.30339, 40.64465], [-124.30406, 40.64467], [-124.30402, 40.64475], [-124.30386, 40.64495], [-124.30371, 40.64508], [-124.3036, 40.64526], [-124.30342, 40.64546], [-124.3032, 40.64579], [-124.30303, 40.64636], [-124.30266, 40.64679], [-124.30237, 40.64693], [-124.30232, 40.64706], [-124.30227, 40.64729], [-124.30225, 40.64748], [-124.30226, 40.6482], [-124.30232, 40.64859], [-124.30244, 40.64894], [-124.30253, 40.64899], [-124.30297, 40.64867], [-124.30317, 40.64849], [-124.30351, 40.64822], [-124.30357, 40.64801], [-124.30367, 40.64791], [-124.30391, 40.64784], [-124.30395, 40.64786], [-124.30413, 40.6482]]]]}	Open Access 1	Eel River Wildlife Area	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Eel-River-WA	30436	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	2384.802	Eel River Wildlife Area	1968

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);