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

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/Allensworth-ER"

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
410	410	409	{"type": "MultiPolygon", "coordinates": [[[[-119.34883, 35.86269], [-119.32201, 35.86295], [-119.32208, 35.87008], [-119.32658, 35.8701], [-119.32659, 35.87192], [-119.32209, 35.87194], [-119.32214, 35.87735], [-119.32205, 35.87736], [-119.32203, 35.8846], [-119.30377, 35.88459], [-119.30388, 35.87733], [-119.29484, 35.87732], [-119.29479, 35.87003], [-119.30381, 35.87004], [-119.30365, 35.85561], [-119.3125, 35.85566], [-119.3126, 35.85564], [-119.31248, 35.84838], [-119.30356, 35.84832], [-119.30361, 35.84108], [-119.32177, 35.84116], [-119.32172, 35.84843], [-119.33063, 35.84835], [-119.33082, 35.85745], [-119.3398, 35.85736], [-119.33983, 35.86098], [-119.34881, 35.86089], [-119.34883, 35.86269]]], [[[-119.3144, 35.89541], [-119.31439, 35.89813], [-119.31383, 35.89814], [-119.31382, 35.89902], [-119.31269, 35.89902], [-119.31271, 35.89632], [-119.31327, 35.89631], [-119.31328, 35.89541], [-119.3144, 35.89541]], [[-119.31381, 35.89813], [-119.31383, 35.89723], [-119.31327, 35.89723], [-119.31326, 35.89812], [-119.31381, 35.89813]]], [[[-119.31553, 35.8945], [-119.31553, 35.89541], [-119.31496, 35.89541], [-119.31497, 35.8945], [-119.31553, 35.8945]]], [[[-119.31607, 35.89813], [-119.31607, 35.89902], [-119.31551, 35.89902], [-119.31551, 35.89813], [-119.31607, 35.89813]]], [[[-119.3189, 35.89722], [-119.31889, 35.89812], [-119.31832, 35.89812], [-119.31833, 35.89722], [-119.3189, 35.89722]]], [[[-119.32002, 35.89631], [-119.3189, 35.89631], [-119.3189, 35.89452], [-119.31833, 35.8945], [-119.31833, 35.89359], [-119.31891, 35.89359], [-119.3189, 35.89449], [-119.31946, 35.8945], [-119.31946, 35.8954], [-119.32001, 35.8954], [-119.32002, 35.89631]]], [[[-119.32058, 35.89192], [-119.32058, 35.89269], [-119.32003, 35.89269], [-119.32003, 35.89192], [-119.32058, 35.89192]]], [[[-119.32208, 35.8954], [-119.32208, 35.89586], [-119.32116, 35.89586], [-119.32114, 35.89631], [-119.32058, 35.89631], [-119.32058, 35.8954], [-119.32208, 35.8954]]], [[[-119.32208, 35.89722], [-119.32208, 35.89767], [-119.32114, 35.89767], [-119.32114, 35.89722], [-119.32208, 35.89722]]], [[[-119.33066, 35.8444], [-119.33065, 35.84551], [-119.32992, 35.84552], [-119.32991, 35.84603], [-119.32992, 35.84604], [-119.33065, 35.84604], [-119.33064, 35.84716], [-119.32991, 35.84715], [-119.3299, 35.8466], [-119.32844, 35.84663], [-119.32844, 35.84714], [-119.32917, 35.84715], [-119.32918, 35.8477], [-119.3299, 35.8477], [-119.3299, 35.84827], [-119.32917, 35.84829], [-119.32916, 35.8477], [-119.32845, 35.8477], [-119.32843, 35.84797], [-119.32771, 35.84801], [-119.32769, 35.84831], [-119.3255, 35.84833], [-119.32548, 35.84834], [-119.3218, 35.84837], [-119.32181, 35.84667], [-119.32253, 35.84666], [-119.32255, 35.84611], [-119.32254, 35.84557], [-119.32183, 35.84555], [-119.32182, 35.84502], [-119.32256, 35.84502], [-119.32255, 35.84556], [-119.32329, 35.84557], [-119.3233, 35.8461], [-119.32475, 35.84609], [-119.32476, 35.84444], [-119.32405, 35.84445], [-119.32403, 35.845], [-119.32329, 35.84501], [-119.3233, 35.84389], [-119.32476, 35.84389], [-119.32478, 35.84337], [-119.32404, 35.84335], [-119.32403, 35.8428], [-119.32184, 35.84281], [-119.32184, 35.84228], [-119.32626, 35.84225], [-119.32626, 35.84278], [-119.32739, 35.84278], [-119.3274, 35.84333], [-119.32846, 35.84332], [-119.32845, 35.84388], [-119.32773, 35.84389], [-119.32773, 35.84442], [-119.33066, 35.8444]], [[-119.32624, 35.84443], [-119.32697, 35.84442], [-119.32698, 35.84389], [-119.32478, 35.8439], [-119.32478, 35.84444], [-119.32624, 35.84443]], [[-119.32621, 35.84608], [-119.32624, 35.845], [-119.32551, 35.845], [-119.3255, 35.84608], [-119.32621, 35.84608]], [[-119.32845, 35.84606], [-119.32698, 35.84607], [-119.32697, 35.84661], [-119.32842, 35.84661], [-119.32844, 35.84635], [-119.32917, 35.84633], [-119.32916, 35.84605], [-119.32845, 35.84606]]], [[[-119.3307, 35.83603], [-119.33069, 35.83748], [-119.32849, 35.83751], [-119.3285, 35.83786], [-119.32959, 35.83785], [-119.32961, 35.83821], [-119.33069, 35.83821], [-119.33069, 35.83857], [-119.32959, 35.83858], [-119.32959, 35.83821], [-119.3274, 35.83823], [-119.32739, 35.83859], [-119.32848, 35.83858], [-119.32848, 35.83894], [-119.32627, 35.83896], [-119.32626, 35.83751], [-119.32188, 35.83753], [-119.32189, 35.83717], [-119.32402, 35.83716], [-119.32404, 35.83681], [-119.32403, 35.83679], [-119.32189, 35.83681], [-119.3219, 35.83573], [-119.32181, 35.83572], [-119.32183, 35.8339], [-119.32406, 35.83389], [-119.32408, 35.83396], [-119.32851, 35.83394], [-119.3285, 35.83532], [-119.32741, 35.83533], [-119.3274, 35.83568], [-119.3285, 35.83568], [-119.32851, 35.83604], [-119.3307, 35.83603]], [[-119.32403, 35.83607], [-119.32404, 35.83571], [-119.32292, 35.83572], [-119.32293, 35.83607], [-119.32403, 35.83607]], [[-119.32404, 35.83678], [-119.32406, 35.83679], [-119.32627, 35.83678], [-119.32628, 35.83644], [-119.32406, 35.83643], [-119.32404, 35.83678]], [[-119.32514, 35.83516], [-119.32514, 35.83497], [-119.32406, 35.835], [-119.32407, 35.83516], [-119.32514, 35.83516]], [[-119.32958, 35.83713], [-119.32958, 35.83676], [-119.32739, 35.83679], [-119.3274, 35.83714], [-119.32958, 35.83713]]], [[[-119.32537, 35.7903], [-119.32425, 35.7903], [-119.32424, 35.78982], [-119.32536, 35.78982], [-119.32537, 35.7903]]], [[[-119.33068, 35.83966], [-119.33067, 35.84166], [-119.32993, 35.84167], [-119.32992, 35.84111], [-119.32626, 35.84113], [-119.32626, 35.84041], [-119.32736, 35.84039], [-119.32737, 35.84004], [-119.32739, 35.83968], [-119.32738, 35.83932], [-119.32848, 35.8393], [-119.3285, 35.83967], [-119.33068, 35.83966]], [[-119.32847, 35.84041], [-119.32846, 35.8404], [-119.32738, 35.8404], [-119.32737, 35.84075], [-119.32846, 35.84075], [-119.32847, 35.84041]]], [[[-119.32766, 35.89362], [-119.32766, 35.89451], [-119.32654, 35.89451], [-119.32654, 35.89362], [-119.32766, 35.89362]]], [[[-119.33067, 35.84275], [-119.32993, 35.84276], [-119.32993, 35.84331], [-119.32919, 35.84332], [-119.3292, 35.84223], [-119.33066, 35.84222], [-119.33067, 35.84275]]], [[[-119.33069, 35.8393], [-119.32959, 35.8393], [-119.32959, 35.83894], [-119.33069, 35.83893], [-119.33069, 35.8393]]], [[[-119.3365, 35.78881], [-119.33649, 35.78926], [-119.33429, 35.78929], [-119.33426, 35.79029], [-119.32982, 35.7903], [-119.32983, 35.78934], [-119.33205, 35.78931], [-119.33207, 35.78843], [-119.33429, 35.7884], [-119.33431, 35.78883], [-119.3365, 35.78881]]], [[[-119.35312, 35.85183], [-119.34419, 35.85187], [-119.34416, 35.85006], [-119.34638, 35.85005], [-119.34635, 35.84827], [-119.33974, 35.84826], [-119.33972, 35.84104], [-119.33892, 35.84107], [-119.33893, 35.8416], [-119.33965, 35.8416], [-119.33965, 35.84491], [-119.33892, 35.84491], [-119.33891, 35.84433], [-119.33818, 35.84436], [-119.33818, 35.84491], [-119.3382, 35.84545], [-119.33965, 35.84544], [-119.33965, 35.84708], [-119.33746, 35.8471], [-119.33745, 35.84766], [-119.33597, 35.84767], [-119.33596, 35.84711], [-119.3367, 35.8471], [-119.33671, 35.84655], [-119.33597, 35.84655], [-119.33596, 35.84629], [-119.33525, 35.84629], [-119.33523, 35.84656], [-119.3323, 35.84659], [-119.33229, 35.84714], [-119.33083, 35.84715], [-119.33081, 35.8466], [-119.33082, 35.84604], [-119.33228, 35.84602], [-119.3323, 35.84551], [-119.33228, 35.84549], [-119.33082, 35.8455], [-119.33083, 35.84328], [-119.33155, 35.84329], [-119.33157, 35.84328], [-119.33157, 35.84222], [-119.33084, 35.84222], [-119.33084, 35.84166], [-119.33157, 35.84166], [-119.33158, 35.84221], [-119.33231, 35.84221], [-119.33231, 35.84273], [-119.33303, 35.84273], [-119.33305, 35.84382], [-119.33377, 35.84383], [-119.33378, 35.84273], [-119.33451, 35.84272], [-119.33452, 35.84328], [-119.33524, 35.84327], [-119.33526, 35.84436], [-119.33597, 35.84435], [-119.33598, 35.84272], [-119.33596, 35.84271], [-119.33525, 35.84271], [-119.33523, 35.84219], [-119.33304, 35.8422], [-119.33303, 35.84109], [-119.33076, 35.84111], [-119.3308, 35.83386], [-119.33975, 35.83382], [-119.33975, 35.84104], [-119.35187, 35.84098], [-119.35186, 35.84822], [-119.34862, 35.84824], [-119.34864, 35.85004], [-119.35309, 35.85002], [-119.35312, 35.85183]], [[-119.3323, 35.8444], [-119.33228, 35.84439], [-119.33157, 35.84439], [-119.33158, 35.84494], [-119.33228, 35.84493], [-119.3323, 35.8444]], [[-119.3345, 35.84493], [-119.33449, 35.84492], [-119.33377, 35.84493], [-119.33377, 35.84547], [-119.33449, 35.84547], [-119.3345, 35.84493]], [[-119.33745, 35.8427], [-119.33745, 35.84106], [-119.336, 35.84107], [-119.33598, 35.84162], [-119.33525, 35.84164], [-119.33525, 35.84218], [-119.33598, 35.84218], [-119.33599, 35.84271], [-119.33671, 35.8427], [-119.33672, 35.84325], [-119.33818, 35.84324], [-119.33817, 35.8427], [-119.33745, 35.8427]], [[-119.33742, 35.84434], [-119.33744, 35.84379], [-119.33671, 35.84383], [-119.33672, 35.84435], [-119.33742, 35.84434]], [[-119.33745, 35.84493], [-119.33672, 35.84491], [-119.33672, 35.84545], [-119.33743, 35.84545], [-119.33745, 35.84493]]], [[[-119.33155, 35.8477], [-119.33155, 35.84826], [-119.33081, 35.84826], [-119.33081, 35.84771], [-119.33155, 35.8477]]], [[[-119.34766, 35.78297], [-119.34765, 35.78654], [-119.34098, 35.78655], [-119.34093, 35.79027], [-119.33872, 35.79028], [-119.3387, 35.78747], [-119.3365, 35.78749], [-119.33648, 35.78706], [-119.33431, 35.78708], [-119.33431, 35.78615], [-119.3365, 35.78614], [-119.33652, 35.78659], [-119.33871, 35.78657], [-119.33872, 35.78654], [-119.33871, 35.78568], [-119.33873, 35.783], [-119.33542, 35.783], [-119.33542, 35.78117], [-119.33764, 35.78115], [-119.33766, 35.78029], [-119.33875, 35.78028], [-119.33874, 35.78208], [-119.33765, 35.7821], [-119.33766, 35.78253], [-119.33873, 35.78254], [-119.33875, 35.78299], [-119.34766, 35.78297]]], [[[-119.33557, 35.84798], [-119.33557, 35.84824], [-119.33449, 35.84824], [-119.33449, 35.84768], [-119.33523, 35.84767], [-119.33524, 35.84796], [-119.33557, 35.84798]]], [[[-119.35871, 35.80113], [-119.3574, 35.80114], [-119.35744, 35.80472], [-119.33954, 35.80475], [-119.3394, 35.79039], [-119.35501, 35.79035], [-119.35736, 35.79719], [-119.35737, 35.79752], [-119.35748, 35.79753], [-119.35871, 35.80113]]], [[[-119.35099, 35.85726], [-119.34875, 35.85728], [-119.3487, 35.85366], [-119.35093, 35.85365], [-119.35099, 35.85726]]], [[[-119.37987, 35.8624], [-119.35778, 35.86261], [-119.35771, 35.85902], [-119.35549, 35.85904], [-119.35548, 35.85813], [-119.35548, 35.85768], [-119.35533, 35.85181], [-119.35757, 35.85181], [-119.3576, 35.85306], [-119.37526, 35.85281], [-119.37519, 35.84938], [-119.37548, 35.85015], [-119.37556, 35.85043], [-119.37593, 35.85125], [-119.37633, 35.85205], [-119.37679, 35.85283], [-119.37712, 35.85334], [-119.37748, 35.85384], [-119.37978, 35.85681], [-119.37987, 35.8624]]], [[[-119.38413, 35.8048], [-119.3753, 35.80482], [-119.36412, 35.80476], [-119.36408, 35.80114], [-119.35934, 35.80113], [-119.35733, 35.79533], [-119.35563, 35.79034], [-119.36397, 35.79031], [-119.364, 35.79391], [-119.36624, 35.79391], [-119.36626, 35.79698], [-119.36404, 35.79698], [-119.36407, 35.79933], [-119.36629, 35.79934], [-119.36631, 35.79933], [-119.36628, 35.79753], [-119.36927, 35.79753], [-119.36919, 35.79029], [-119.37513, 35.79028], [-119.384, 35.79021], [-119.38401, 35.79205], [-119.38405, 35.79385], [-119.38405, 35.79567], [-119.38409, 35.8011], [-119.38413, 35.8048]], [[-119.36179, 35.79842], [-119.36179, 35.79753], [-119.35957, 35.79755], [-119.3596, 35.79842], [-119.36179, 35.79842]]], [[[-119.36766, 35.78835], [-119.36543, 35.78831], [-119.36544, 35.78656], [-119.36766, 35.78656], [-119.36766, 35.78835]]], [[[-119.37782, 35.78571], [-119.37779, 35.7902], [-119.37428, 35.7902], [-119.37433, 35.7857], [-119.37782, 35.78571]]], [[[-119.41006, 35.76746], [-119.41006, 35.76836], [-119.40562, 35.76837], [-119.40562, 35.76747], [-119.41006, 35.76746]]], [[[-119.41891, 35.78081], [-119.41886, 35.7901], [-119.41436, 35.79011], [-119.41434, 35.79005], [-119.41038, 35.79004], [-119.40996, 35.79005], [-119.40994, 35.78854], [-119.41451, 35.78081], [-119.41891, 35.78081]]], [[[-119.41414, 35.7808], [-119.41414, 35.7808], [-119.40995, 35.78788], [-119.41001, 35.78078], [-119.41414, 35.7808]]], [[[-119.42051, 35.77469], [-119.42029, 35.77506], [-119.41896, 35.77507], [-119.41896, 35.7747], [-119.42051, 35.77469]]], [[[-119.42123, 35.77071], [-119.42123, 35.77108], [-119.41898, 35.77108], [-119.41898, 35.77071], [-119.42123, 35.77071]]], [[[-119.42124, 35.76907], [-119.41899, 35.76908], [-119.41899, 35.76898], [-119.42124, 35.76898], [-119.42124, 35.76907]]], [[[-119.42122, 35.77469], [-119.42121, 35.77506], [-119.42068, 35.77506], [-119.42089, 35.77469], [-119.42122, 35.77469]]], [[[-119.4235, 35.77414], [-119.42122, 35.77415], [-119.42122, 35.77413], [-119.42136, 35.77388], [-119.4235, 35.77387], [-119.4235, 35.77414]]], [[[-119.42348, 35.76942], [-119.42348, 35.76955], [-119.42344, 35.76962], [-119.42124, 35.76962], [-119.42124, 35.76944], [-119.42348, 35.76942]]], [[[-119.42789, 35.76942], [-119.42788, 35.77031], [-119.42348, 35.77031], [-119.42348, 35.7702], [-119.42352, 35.77013], [-119.42568, 35.77014], [-119.42569, 35.76941], [-119.42789, 35.76942]]], [[[-119.42567, 35.77468], [-119.42567, 35.77485], [-119.4235, 35.77486], [-119.4235, 35.77468], [-119.42567, 35.77468]]], [[[-119.42573, 35.76115], [-119.42572, 35.76466], [-119.42352, 35.76466], [-119.42356, 35.76116], [-119.42573, 35.76115]]], [[[-119.43457, 35.77249], [-119.43457, 35.77267], [-119.43235, 35.77267], [-119.43233, 35.77252], [-119.43013, 35.77252], [-119.43011, 35.77288], [-119.42787, 35.77289], [-119.42787, 35.77216], [-119.43011, 35.77215], [-119.43013, 35.77233], [-119.43235, 35.77233], [-119.43237, 35.77251], [-119.43457, 35.77249]]], [[[-119.43459, 35.77086], [-119.43459, 35.77104], [-119.43236, 35.77104], [-119.43234, 35.77096], [-119.43011, 35.77096], [-119.43011, 35.77088], [-119.43459, 35.77086]]], [[[-119.43236, 35.77041], [-119.43012, 35.77042], [-119.43012, 35.77033], [-119.43236, 35.77032], [-119.43236, 35.77041]]], [[[-119.43237, 35.76869], [-119.43237, 35.76914], [-119.43012, 35.76915], [-119.43012, 35.7687], [-119.43237, 35.76869]]], [[[-119.43454, 35.77503], [-119.43453, 35.77555], [-119.43234, 35.77555], [-119.43234, 35.77504], [-119.43454, 35.77503]]], [[[-119.43456, 35.77303], [-119.43455, 35.7743], [-119.43235, 35.77431], [-119.43235, 35.77304], [-119.43456, 35.77303]]], [[[-119.43675, 35.77447], [-119.43675, 35.77466], [-119.43454, 35.77467], [-119.43455, 35.77448], [-119.43675, 35.77447]]], [[[-119.4723, 35.76451], [-119.47218, 35.78273], [-119.46002, 35.78265], [-119.45999, 35.78618], [-119.45671, 35.7862], [-119.45673, 35.79002], [-119.45445, 35.79002], [-119.45451, 35.77911], [-119.45896, 35.77914], [-119.45899, 35.77188], [-119.46792, 35.77182], [-119.46799, 35.76451], [-119.4723, 35.76451]], [[-119.46642, 35.77549], [-119.46642, 35.77547], [-119.46554, 35.77547], [-119.46338, 35.77749], [-119.46331, 35.77767], [-119.46354, 35.77993], [-119.46379, 35.78266], [-119.46419, 35.78265], [-119.46444, 35.78217], [-119.46404, 35.77794], [-119.46411, 35.77776], [-119.46642, 35.77549]]], [[[-119.51241, 35.76811], [-119.51238, 35.7716], [-119.5124, 35.77527], [-119.50795, 35.77533], [-119.49909, 35.77528], [-119.49906, 35.77366], [-119.49908, 35.76844], [-119.49911, 35.76821], [-119.50848, 35.76812], [-119.50849, 35.76936], [-119.51014, 35.76936], [-119.5102, 35.7681], [-119.51241, 35.76811]]]]}	Open Access 1	Allensworth Ecological Reserve	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Allensworth-ER	32015	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	6406.291	Allensworth ER	1983

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