calands: units_with_maps: 2 rows where COUNTY = 2 and DES

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

2 rows where COUNTY = 2 and DES_TP = 39

Search:

descending

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
2290	2290	2289	{"type": "Polygon", "coordinates": [[[-120.60218, 37.62572], [-120.60074, 37.62629], [-120.6005, 37.62609], [-120.60065, 37.62603], [-120.60054, 37.62585], [-120.60026, 37.62593], [-120.59987, 37.626], [-120.59961, 37.62598], [-120.59921, 37.62599], [-120.59815, 37.62595], [-120.5974, 37.62598], [-120.5971, 37.6261], [-120.59598, 37.62641], [-120.59296, 37.62765], [-120.58744, 37.62797], [-120.58672, 37.62798], [-120.58598, 37.62819], [-120.58589, 37.6302], [-120.58589, 37.63206], [-120.58408, 37.63198], [-120.58218, 37.63162], [-120.57933, 37.6318], [-120.57893, 37.63155], [-120.57733, 37.63078], [-120.57588, 37.63045], [-120.57448, 37.63027], [-120.5721, 37.63008], [-120.57195, 37.62512], [-120.57199, 37.62364], [-120.57141, 37.6237], [-120.57129, 37.62363], [-120.57057, 37.62348], [-120.57034, 37.62363], [-120.57028, 37.62377], [-120.56948, 37.62393], [-120.56939, 37.62384], [-120.56936, 37.62354], [-120.56916, 37.62347], [-120.56856, 37.6235], [-120.56792, 37.6237], [-120.56712, 37.6234], [-120.56631, 37.62324], [-120.56462, 37.62333], [-120.56416, 37.62313], [-120.56324, 37.62246], [-120.56318, 37.6221], [-120.56341, 37.62205], [-120.56387, 37.62228], [-120.56447, 37.62217], [-120.56491, 37.62246], [-120.56516, 37.62253], [-120.56525, 37.62246], [-120.56525, 37.62226], [-120.56439, 37.62102], [-120.56367, 37.62063], [-120.56367, 37.62043], [-120.5639, 37.6202], [-120.56393, 37.61995], [-120.56373, 37.61965], [-120.56381, 37.61944], [-120.56416, 37.61935], [-120.5645, 37.61956], [-120.56474, 37.62031], [-120.56574, 37.62091], [-120.56611, 37.62105], [-120.56635, 37.62097], [-120.56637, 37.62078], [-120.56629, 37.62061], [-120.56632, 37.62018], [-120.56672, 37.61986], [-120.56706, 37.61974], [-120.56773, 37.62006], [-120.56836, 37.62022], [-120.5685, 37.62011], [-120.56853, 37.61986], [-120.5683, 37.61968], [-120.56767, 37.61949], [-120.56761, 37.61935], [-120.56755, 37.61862], [-120.56623, 37.61759], [-120.56572, 37.61741], [-120.5652, 37.61734], [-120.56471, 37.61764], [-120.56439, 37.61775], [-120.56416, 37.61759], [-120.56407, 37.61739], [-120.56347, 37.61748], [-120.56333, 37.61713], [-120.56344, 37.61661], [-120.56365, 37.61617], [-120.56468, 37.61617], [-120.56482, 37.61571], [-120.56422, 37.61482], [-120.56396, 37.61466], [-120.56336, 37.61459], [-120.56322, 37.61448], [-120.56321, 37.61386], [-120.56279, 37.61299], [-120.56224, 37.61253], [-120.56227, 37.61224], [-120.56238, 37.61205], [-120.56238, 37.6118], [-120.56204, 37.61164], [-120.56164, 37.61157], [-120.56167, 37.61139], [-120.56195, 37.61116], [-120.56198, 37.6109], [-120.56166, 37.61049], [-120.56083, 37.61004], [-120.56052, 37.60999], [-120.55997, 37.61036], [-120.55948, 37.61118], [-120.55945, 37.61164], [-120.55985, 37.61205], [-120.55983, 37.6126], [-120.56031, 37.61283], [-120.56103, 37.6129], [-120.56221, 37.61347], [-120.56241, 37.61363], [-120.56238, 37.61436], [-120.56204, 37.61477], [-120.56201, 37.61508], [-120.56252, 37.61535], [-120.56336, 37.6153], [-120.56356, 37.61549], [-120.56341, 37.61571], [-120.5627, 37.61606], [-120.5625, 37.61628], [-120.56246, 37.61679], [-120.56215, 37.61679], [-120.56157, 37.61624], [-120.56114, 37.61603], [-120.56028, 37.61601], [-120.56014, 37.6161], [-120.56002, 37.61656], [-120.55947, 37.61677], [-120.55947, 37.61704], [-120.55973, 37.61725], [-120.56042, 37.6175], [-120.56042, 37.6177], [-120.55973, 37.61784], [-120.55907, 37.61809], [-120.55884, 37.61809], [-120.55763, 37.61713], [-120.55706, 37.61695], [-120.55628, 37.6169], [-120.55593, 37.61706], [-120.55522, 37.61713], [-120.55384, 37.61646], [-120.55358, 37.61646], [-120.55343, 37.61713], [-120.55317, 37.61731], [-120.5524, 37.61751], [-120.55176, 37.61786], [-120.55101, 37.61811], [-120.55012, 37.61831], [-120.54937, 37.6182], [-120.54851, 37.61818], [-120.54733, 37.61856], [-120.54612, 37.61943], [-120.54575, 37.62005], [-120.54557, 37.6205], [-120.54537, 37.62073], [-120.54497, 37.62082], [-120.54448, 37.62073], [-120.54371, 37.62016], [-120.54322, 37.61991], [-120.54233, 37.6197], [-120.54057, 37.61954], [-120.54026, 37.61942], [-120.54023, 37.61904], [-120.54049, 37.6181], [-120.54, 37.61734], [-120.53873, 37.61629], [-120.53862, 37.61561], [-120.53836, 37.61508], [-120.53831, 37.61464], [-120.53842, 37.61419], [-120.53928, 37.61411], [-120.53931, 37.61393], [-120.53897, 37.6137], [-120.539, 37.6135], [-120.5398, 37.61302], [-120.53983, 37.61282], [-120.5396, 37.61272], [-120.5396, 37.61249], [-120.54124, 37.61115], [-120.54136, 37.61085], [-120.54202, 37.61009], [-120.5421, 37.60987], [-120.54199, 37.60982], [-120.54196, 37.60954], [-120.54217, 37.60932], [-120.54343, 37.60858], [-120.54395, 37.60735], [-120.54418, 37.60582], [-120.5447, 37.60511], [-120.54473, 37.60465], [-120.54456, 37.60403], [-120.54419, 37.60314], [-120.54372, 37.60282], [-120.54307, 37.60259], [-120.54189, 37.60243], [-120.54166, 37.60227], [-120.54157, 37.60195], [-120.54172, 37.60186], [-120.54318, 37.60174], [-120.54384, 37.60186], [-120.54404, 37.6017], [-120.54407, 37.6015], [-120.54396, 37.6014], [-120.54396, 37.60108], [-120.54479, 37.59953], [-120.54517, 37.5985], [-120.54537, 37.59838], [-120.546, 37.59863], [-120.54629, 37.59863], [-120.54644, 37.59847], [-120.54675, 37.59756], [-120.54649, 37.59735], [-120.54612, 37.59724], [-120.54612, 37.59706], [-120.5469, 37.59655], [-120.54724, 37.59614], [-120.54808, 37.59578], [-120.54819, 37.59562], [-120.54819, 37.59523], [-120.54802, 37.59495], [-120.54793, 37.59454], [-120.54776, 37.59424], [-120.54687, 37.59388], [-120.54635, 37.59287], [-120.54633, 37.59248], [-120.5465, 37.59218], [-120.54699, 37.5917], [-120.54716, 37.5912], [-120.54722, 37.59042], [-120.54713, 37.59035], [-120.54711, 37.58983], [-120.54722, 37.58969], [-120.54751, 37.5896], [-120.54785, 37.58912], [-120.54932, 37.58775], [-120.54973, 37.58717], [-120.55027, 37.58571], [-120.5501, 37.58486], [-120.5497, 37.58411], [-120.54979, 37.58404], [-120.55039, 37.58397], [-120.55056, 37.58376], [-120.55122, 37.58381], [-120.55131, 37.58371], [-120.55117, 37.58335], [-120.55186, 37.58321], [-120.55226, 37.58253], [-120.55266, 37.58246], [-120.55269, 37.58324], [-120.55298, 37.58377], [-120.55306, 37.58431], [-120.55361, 37.58459], [-120.55372, 37.58495], [-120.55438, 37.58571], [-120.55461, 37.58612], [-120.55458, 37.58642], [-120.55366, 37.58681], [-120.55323, 37.58733], [-120.55326, 37.58772], [-120.55355, 37.58793], [-120.55389, 37.58802], [-120.55507, 37.58796], [-120.55493, 37.5883], [-120.55441, 37.58898], [-120.5543, 37.58946], [-120.55435, 37.58964], [-120.55467, 37.58997], [-120.55541, 37.59022], [-120.55591, 37.59056], [-120.55614, 37.59065], [-120.55731, 37.59029], [-120.55817, 37.59072], [-120.55846, 37.59082], [-120.55967, 37.59047], [-120.56275, 37.59045], [-120.56424, 37.59034], [-120.56528, 37.59036], [-120.56551, 37.59046], [-120.56643, 37.59121], [-120.56666, 37.59149], [-120.56666, 37.59178], [-120.56597, 37.59258], [-120.56585, 37.5926], [-120.56542, 37.59297], [-120.56502, 37.59373], [-120.56479, 37.59389], [-120.56435, 37.59373], [-120.56392, 37.59384], [-120.56364, 37.59409], [-120.56372, 37.59544], [-120.56355, 37.5956], [-120.56191, 37.59631], [-120.56079, 37.59752], [-120.55995, 37.59892], [-120.55989, 37.59978], [-120.56006, 37.59992], [-120.56118, 37.59986], [-120.56138, 37.59974], [-120.56145, 37.59908], [-120.56165, 37.5989], [-120.56219, 37.5991], [-120.56268, 37.59901], [-120.5628, 37.59869], [-120.56251, 37.59832], [-120.56251, 37.59805], [-120.56447, 37.59716], [-120.56521, 37.59659], [-120.56533, 37.59624], [-120.5653, 37.59567], [-120.56594, 37.59528], [-120.56605, 37.59508], [-120.56605, 37.59453], [-120.56671, 37.59398], [-120.5672, 37.59348], [-120.5674, 37.59352], [-120.56752, 37.59364], [-120.56761, 37.59414], [-120.56806, 37.59435], [-120.56847, 37.59435], [-120.56907, 37.59423], [-120.56988, 37.5938], [-120.57062, 37.59364], [-120.57117, 37.59309], [-120.57157, 37.59286], [-120.57393, 37.59231], [-120.57451, 37.59233], [-120.5756, 37.59266], [-120.57557, 37.59286], [-120.57451, 37.59325], [-120.57448, 37.59378], [-120.57405, 37.5941], [-120.57341, 37.59435], [-120.57232, 37.594], [-120.57172, 37.59407], [-120.57137, 37.59428], [-120.57126, 37.59444], [-120.57126, 37.59487], [-120.57151, 37.59515], [-120.57307, 37.59552], [-120.57304, 37.59572], [-120.57232, 37.596], [-120.57229, 37.59629], [-120.57289, 37.59648], [-120.57278, 37.59673], [-120.572, 37.59709], [-120.57197, 37.59744], [-120.57212, 37.59758], [-120.57206, 37.59776], [-120.57134, 37.59833], [-120.57099, 37.59847], [-120.5699, 37.5986], [-120.56858, 37.5992], [-120.56734, 37.59929], [-120.56582, 37.59986], [-120.56556, 37.60006], [-120.56559, 37.60043], [-120.56584, 37.60059], [-120.56702, 37.60082], [-120.5672, 37.60096], [-120.56719, 37.60162], [-120.56702, 37.6019], [-120.56696, 37.60306], [-120.56722, 37.60375], [-120.56757, 37.60402], [-120.56863, 37.60421], [-120.56877, 37.60435], [-120.56889, 37.60503], [-120.56903, 37.60512], [-120.56944, 37.60499], [-120.5699, 37.60462], [-120.57024, 37.60407], [-120.57073, 37.60238], [-120.5718, 37.6016], [-120.57188, 37.60089], [-120.57217, 37.60094], [-120.57249, 37.60112], [-120.5728, 37.60112], [-120.57321, 37.60098], [-120.57398, 37.60108], [-120.57473, 37.60101], [-120.57496, 37.60105], [-120.57582, 37.60075], [-120.57677, 37.60074], [-120.57778, 37.60089], [-120.57847, 37.6008], [-120.57867, 37.60092], [-120.57936, 37.60087], [-120.57971, 37.6006], [-120.57982, 37.60026], [-120.57965, 37.60002], [-120.57965, 37.59977], [-120.58034, 37.59957], [-120.58054, 37.59934], [-120.58069, 37.59893], [-120.58074, 37.59842], [-120.58135, 37.59797], [-120.58152, 37.59799], [-120.58207, 37.59859], [-120.58241, 37.5987], [-120.58299, 37.59854], [-120.58333, 37.59831], [-120.58342, 37.59774], [-120.58394, 37.59692], [-120.58489, 37.59698], [-120.58661, 37.59646], [-120.5875, 37.59627], [-120.58819, 37.59589], [-120.58883, 37.59568], [-120.58906, 37.59571], [-120.58917, 37.5958], [-120.58914, 37.59618], [-120.58894, 37.59646], [-120.58785, 37.59692], [-120.58739, 37.59767], [-120.58644, 37.59831], [-120.58563, 37.59861], [-120.58538, 37.59888], [-120.58526, 37.5995], [-120.58534, 37.60035], [-120.58598, 37.60083], [-120.58583, 37.60142], [-120.58641, 37.60179], [-120.58667, 37.60229], [-120.5869, 37.60239], [-120.58727, 37.60232], [-120.58782, 37.60177], [-120.58807, 37.60181], [-120.58813, 37.60218], [-120.58856, 37.60255], [-120.58943, 37.60259], [-120.58994, 37.60305], [-120.59029, 37.60314], [-120.59072, 37.60296], [-120.59078, 37.60266], [-120.58992, 37.6017], [-120.58989, 37.60142], [-120.59023, 37.60147], [-120.59112, 37.60181], [-120.59161, 37.60184], [-120.59176, 37.60177], [-120.59187, 37.60147], [-120.59219, 37.60147], [-120.59253, 37.60165], [-120.59282, 37.60166], [-120.59328, 37.60154], [-120.594, 37.60125], [-120.59455, 37.60127], [-120.59472, 37.6014], [-120.59463, 37.60161], [-120.5944, 37.60182], [-120.59342, 37.60241], [-120.59317, 37.60278], [-120.59308, 37.60344], [-120.59317, 37.60374], [-120.59345, 37.60408], [-120.59434, 37.60465], [-120.59434, 37.60484], [-120.59345, 37.60509], [-120.59334, 37.60545], [-120.59334, 37.60603], [-120.59313, 37.60621], [-120.59285, 37.60614], [-120.59256, 37.60589], [-120.59256, 37.60543], [-120.59264, 37.60524], [-120.59242, 37.6045], [-120.59219, 37.6044], [-120.59161, 37.60449], [-120.59115, 37.60465], [-120.59032, 37.60534], [-120.59017, 37.60582], [-120.59055, 37.60626], [-120.59161, 37.60648], [-120.59198, 37.60669], [-120.59198, 37.60687], [-120.59132, 37.60728], [-120.59106, 37.60772], [-120.59106, 37.60822], [-120.59115, 37.60834], [-120.59161, 37.60847], [-120.5921, 37.60843], [-120.59259, 37.60822], [-120.5929, 37.60824], [-120.59356, 37.60861], [-120.59356, 37.60889], [-120.59342, 37.60907], [-120.59302, 37.60927], [-120.5923, 37.60939], [-120.59207, 37.60959], [-120.59199, 37.61015], [-120.59221, 37.61033], [-120.59241, 37.61035], [-120.59305, 37.61024], [-120.59382, 37.61037], [-120.59402, 37.61076], [-120.59451, 37.61129], [-120.59425, 37.61193], [-120.59399, 37.61202], [-120.59359, 37.61252], [-120.59327, 37.61248], [-120.59198, 37.61159], [-120.59172, 37.61149], [-120.59112, 37.61165], [-120.5906, 37.61202], [-120.59043, 37.61227], [-120.59028, 37.61288], [-120.59069, 37.61325], [-120.59112, 37.61332], [-120.59261, 37.61323], [-120.59281, 37.61339], [-120.59287, 37.6136], [-120.5929, 37.61467], [-120.59304, 37.61522], [-120.59287, 37.61529], [-120.59175, 37.61474], [-120.59075, 37.61438], [-120.59037, 37.61444], [-120.59025, 37.61497], [-120.58996, 37.6155], [-120.58905, 37.61607], [-120.5887, 37.61646], [-120.58804, 37.61664], [-120.58712, 37.61751], [-120.58712, 37.61772], [-120.58778, 37.61808], [-120.58792, 37.6184], [-120.58795, 37.61877], [-120.58887, 37.6193], [-120.58904, 37.61957], [-120.5893, 37.61971], [-120.58962, 37.61957], [-120.58976, 37.61939], [-120.58979, 37.61861], [-120.58999, 37.61849], [-120.59086, 37.61879], [-120.59128, 37.61879], [-120.59172, 37.61838], [-120.59169, 37.61827], [-120.59178, 37.61818], [-120.59215, 37.61818], [-120.59284, 37.6184], [-120.59232, 37.61957], [-120.59247, 37.62012], [-120.59267, 37.62028], [-120.59336, 37.62062], [-120.59382, 37.6212], [-120.59425, 37.62115], [-120.59436, 37.62092], [-120.59434, 37.62044], [-120.59419, 37.62024], [-120.59416, 37.61996], [-120.59451, 37.61994], [-120.59503, 37.62024], [-120.59534, 37.6206], [-120.59549, 37.62108], [-120.59594, 37.62145], [-120.5964, 37.62136], [-120.59687, 37.6209], [-120.59756, 37.62042], [-120.5977, 37.62026], [-120.59776, 37.61971], [-120.59799, 37.61976], [-120.59836, 37.62012], [-120.59828, 37.62177], [-120.59865, 37.62204], [-120.59948, 37.62225], [-120.59994, 37.62214], [-120.6004, 37.62175], [-120.60058, 37.62138], [-120.60084, 37.62125], [-120.60109, 37.62129], [-120.6021, 37.62207], [-120.60245, 37.62269], [-120.60247, 37.62324], [-120.60224, 37.62424], [-120.60211, 37.62496], [-120.6021, 37.6252], [-120.60143, 37.62549], [-120.60085, 37.62567], [-120.60103, 37.62583], [-120.60201, 37.6255], [-120.60218, 37.62572]]]}	Open Access 1	18239	Turlock Lake State Recreation Area	1778	204	California Department of Parks and Recreation 48	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://www.parks.ca.gov/?page_id=555	Stanislaus 2	3470.177	Turlock Lake SRA	1950	State Recreation Area 39	4
7996	7996	7995	{"type": "MultiPolygon", "coordinates": [[[[-120.84563, 37.61895], [-120.84545, 37.61903], [-120.84473, 37.62007], [-120.84403, 37.62084], [-120.84261, 37.62181], [-120.84163, 37.62226], [-120.84153, 37.62225], [-120.84196, 37.62189], [-120.84148, 37.62063], [-120.84163, 37.61955], [-120.84195, 37.61932], [-120.84163, 37.61895], [-120.8422, 37.61857], [-120.84301, 37.61756], [-120.84275, 37.61605], [-120.84369, 37.61618], [-120.84406, 37.61629], [-120.84379, 37.61775], [-120.8443, 37.61762], [-120.84492, 37.61786], [-120.84529, 37.61767], [-120.84563, 37.61895]]], [[[-120.85093, 37.61827], [-120.84939, 37.61906], [-120.84879, 37.61899], [-120.84793, 37.6187], [-120.84729, 37.61865], [-120.84609, 37.61872], [-120.84574, 37.61743], [-120.84684, 37.61692], [-120.84745, 37.61661], [-120.84873, 37.61675], [-120.84972, 37.6172], [-120.85027, 37.61796], [-120.85068, 37.6181], [-120.85055, 37.61819], [-120.85055, 37.61821], [-120.85093, 37.61827]]]]}	Open Access 1	468	Fox Grove Fishing Access	32167	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	201	California Department of Fish and Wildlife 25	State 5	State Agency 5		Stanislaus 2	51.641	Fox Grove FA	0	State Recreation Area 39	4

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