calands: superunits_with_maps: 1 row where MNG_AG_TYP = 5 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Los-Banos-WA"

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

1 row where MNG_AG_TYP = 5 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Los-Banos-WA"

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
15352	15352	15351	{"type": "MultiPolygon", "coordinates": [[[[-120.76213, 37.05843], [-120.76213, 37.06157], [-120.76181, 37.0614], [-120.7615, 37.0611], [-120.76115, 37.06117], [-120.76094, 37.06135], [-120.76073, 37.06186], [-120.7605, 37.06199], [-120.76001, 37.06196], [-120.75985, 37.0623], [-120.75413, 37.06194], [-120.75381, 37.06185], [-120.75349, 37.06164], [-120.7529, 37.06101], [-120.75199, 37.06028], [-120.75067, 37.05967], [-120.75029, 37.05942], [-120.75, 37.05914], [-120.74934, 37.05804], [-120.74926, 37.05782], [-120.75107, 37.05557], [-120.75127, 37.05548], [-120.75338, 37.05551], [-120.75737, 37.0556], [-120.75781, 37.05566], [-120.75836, 37.0558], [-120.75879, 37.05596], [-120.75912, 37.05614], [-120.75984, 37.05661], [-120.75985, 37.05839], [-120.76213, 37.05843]]], [[[-120.82277, 37.14788], [-120.82087, 37.15006], [-120.82029, 37.15064], [-120.81905, 37.1518], [-120.81515, 37.15554], [-120.81486, 37.15593], [-120.81469, 37.15611], [-120.81457, 37.15638], [-120.81404, 37.15795], [-120.81373, 37.15817], [-120.81345, 37.1591], [-120.81212, 37.159], [-120.81187, 37.15911], [-120.8117, 37.15945], [-120.81159, 37.15959], [-120.81146, 37.15966], [-120.80964, 37.16025], [-120.80764, 37.15988], [-120.80733, 37.15978], [-120.80623, 37.15967], [-120.80538, 37.15947], [-120.80539, 37.15922], [-120.80482, 37.15927], [-120.80459, 37.15973], [-120.8049, 37.16016], [-120.80495, 37.16035], [-120.80445, 37.16121], [-120.80411, 37.16131], [-120.80357, 37.1613], [-120.80288, 37.16131], [-120.80237, 37.16137], [-120.80058, 37.16132], [-120.80018, 37.16141], [-120.79946, 37.16126], [-120.79925, 37.16148], [-120.79967, 37.16204], [-120.79964, 37.16214], [-120.79917, 37.16252], [-120.79866, 37.16225], [-120.79762, 37.16194], [-120.79673, 37.16206], [-120.79591, 37.16251], [-120.79574, 37.16251], [-120.79451, 37.16176], [-120.79401, 37.16132], [-120.79309, 37.161], [-120.79234, 37.16105], [-120.79211, 37.16076], [-120.79233, 37.16049], [-120.79346, 37.16005], [-120.7937, 37.15956], [-120.79364, 37.15917], [-120.79398, 37.15823], [-120.79384, 37.15749], [-120.79294, 37.15621], [-120.79303, 37.15607], [-120.79356, 37.15553], [-120.79462, 37.15501], [-120.79477, 37.15456], [-120.79397, 37.15433], [-120.79346, 37.15467], [-120.79295, 37.15463], [-120.7927, 37.15457], [-120.7926, 37.15442], [-120.7925, 37.15347], [-120.79271, 37.15204], [-120.79208, 37.15105], [-120.79129, 37.1503], [-120.79042, 37.14962], [-120.78956, 37.14945], [-120.78919, 37.14922], [-120.78843, 37.1489], [-120.78646, 37.14842], [-120.78509, 37.14886], [-120.78472, 37.14871], [-120.78425, 37.1483], [-120.78327, 37.14789], [-120.78279, 37.14852], [-120.78261, 37.14862], [-120.78202, 37.14856], [-120.78174, 37.14832], [-120.78125, 37.14759], [-120.78096, 37.14695], [-120.7807, 37.14539], [-120.78007, 37.14438], [-120.7798, 37.14435], [-120.77948, 37.14461], [-120.77886, 37.1448], [-120.77821, 37.14478], [-120.7776, 37.14482], [-120.77587, 37.14514], [-120.77568, 37.14569], [-120.77498, 37.14636], [-120.77495, 37.14701], [-120.77509, 37.14749], [-120.7751, 37.14773], [-120.77505, 37.14829], [-120.77505, 37.14853], [-120.77487, 37.14886], [-120.77451, 37.14897], [-120.7738, 37.14874], [-120.77338, 37.14824], [-120.77268, 37.1476], [-120.77291, 37.14668], [-120.77337, 37.14589], [-120.7734, 37.14511], [-120.77285, 37.14386], [-120.77275, 37.14278], [-120.77197, 37.14247], [-120.77174, 37.14228], [-120.77147, 37.14185], [-120.77093, 37.14171], [-120.77036, 37.1414], [-120.76925, 37.14066], [-120.76924, 37.14051], [-120.76928, 37.14042], [-120.77015, 37.14003], [-120.77037, 37.13944], [-120.77004, 37.13899], [-120.76811, 37.13868], [-120.76691, 37.13759], [-120.76638, 37.13745], [-120.76553, 37.1375], [-120.76394, 37.137], [-120.76293, 37.13685], [-120.76223, 37.13644], [-120.76172, 37.13642], [-120.76056, 37.13695], [-120.76015, 37.12779], [-120.76137, 37.12781], [-120.76134, 37.12896], [-120.76127, 37.12915], [-120.76127, 37.12935], [-120.76176, 37.12998], [-120.76181, 37.13012], [-120.7618, 37.13033], [-120.76167, 37.13053], [-120.76095, 37.13096], [-120.76082, 37.13114], [-120.7608, 37.13155], [-120.76082, 37.13166], [-120.76097, 37.13184], [-120.76163, 37.13223], [-120.7617, 37.13237], [-120.76168, 37.13263], [-120.76097, 37.13322], [-120.76087, 37.13333], [-120.76082, 37.13347], [-120.7608, 37.13369], [-120.76083, 37.1338], [-120.76098, 37.13406], [-120.7625, 37.13499], [-120.76264, 37.13523], [-120.76266, 37.13544], [-120.76264, 37.13568], [-120.76246, 37.13612], [-120.76276, 37.13622], [-120.76298, 37.13574], [-120.76301, 37.13544], [-120.76298, 37.13516], [-120.76277, 37.13481], [-120.76125, 37.13388], [-120.76116, 37.13369], [-120.76116, 37.13352], [-120.76123, 37.13339], [-120.76181, 37.13293], [-120.76201, 37.13273], [-120.76205, 37.13232], [-120.7619, 37.13205], [-120.76122, 37.13165], [-120.76114, 37.13154], [-120.76115, 37.13123], [-120.76121, 37.13116], [-120.76195, 37.13071], [-120.76213, 37.1304], [-120.76216, 37.13009], [-120.76208, 37.12987], [-120.76162, 37.12928], [-120.76161, 37.1292], [-120.76169, 37.129], [-120.76172, 37.12782], [-120.77549, 37.1281], [-120.77541, 37.13175], [-120.77991, 37.13182], [-120.78009, 37.12492], [-120.78011, 37.11347], [-120.79823, 37.11367], [-120.7983, 37.10659], [-120.79736, 37.10656], [-120.79746, 37.09926], [-120.7976, 37.09926], [-120.79991, 37.10027], [-120.8006, 37.10027], [-120.80178, 37.09934], [-120.82137, 37.0996], [-120.82, 37.10589], [-120.81884, 37.1128], [-120.81818, 37.11586], [-120.81794, 37.11718], [-120.81773, 37.12124], [-120.81762, 37.12862], [-120.81786, 37.13244], [-120.82277, 37.14788]]], [[[-120.7802, 37.05601], [-120.78018, 37.05821], [-120.78019, 37.06265], [-120.78013, 37.07043], [-120.77119, 37.07025], [-120.76971, 37.07024], [-120.76806, 37.06819], [-120.76772, 37.06801], [-120.76616, 37.06784], [-120.76532, 37.06745], [-120.76402, 37.06703], [-120.76377, 37.06494], [-120.76354, 37.06456], [-120.76281, 37.06407], [-120.76235, 37.06384], [-120.76235, 37.05797], [-120.7624, 37.05787], [-120.76275, 37.05778], [-120.76312, 37.05765], [-120.76334, 37.05753], [-120.76355, 37.05738], [-120.76373, 37.05722], [-120.76458, 37.05655], [-120.76497, 37.0563], [-120.76526, 37.05617], [-120.76556, 37.05606], [-120.76603, 37.05593], [-120.76636, 37.05589], [-120.76669, 37.05586], [-120.76872, 37.05583], [-120.7802, 37.05601]]], [[[-120.83293, 37.1362], [-120.82866, 37.14109], [-120.8282, 37.14165], [-120.82774, 37.14215], [-120.82599, 37.14416], [-120.82521, 37.14517], [-120.82505, 37.14548], [-120.82474, 37.14557], [-120.82335, 37.14721], [-120.81981, 37.1361], [-120.83293, 37.1362]]]]}	Open Access 1	Los Banos Wildlife Area	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Los-Banos-WA	30467	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	6275.183	Los Banos Wildlife Area	1954

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]);