calands: units_with_maps: 2 rows where AGNCY_LEV = 4, COUNTY = 2 and MNG

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

2 rows where AGNCY_LEV = 4, COUNTY = 2 and MNG_AGENCY = 977

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
12247	12247	12246	{"type": "MultiPolygon", "coordinates": [[[[-120.45234, 37.66491], [-120.45126, 37.66492], [-120.4513, 37.66851], [-120.44674, 37.6685], [-120.44673, 37.66851], [-120.44674, 37.67122], [-120.45132, 37.67124], [-120.45137, 37.67588], [-120.44916, 37.67588], [-120.44916, 37.674], [-120.44573, 37.674], [-120.44575, 37.67587], [-120.44458, 37.67586], [-120.44457, 37.67654], [-120.44205, 37.67462], [-120.44382, 37.67412], [-120.44455, 37.67299], [-120.44461, 37.67256], [-120.44475, 37.67257], [-120.4449, 37.67256], [-120.44505, 37.67252], [-120.44514, 37.67246], [-120.44483, 37.67199], [-120.44468, 37.67196], [-120.44507, 37.6707], [-120.44499, 37.67024], [-120.44449, 37.66942], [-120.44291, 37.66834], [-120.44239, 37.66704], [-120.44248, 37.66673], [-120.44261, 37.66672], [-120.44265, 37.66654], [-120.4428, 37.6663], [-120.44314, 37.66621], [-120.4433, 37.66615], [-120.4436, 37.66606], [-120.4438, 37.66594], [-120.44446, 37.66575], [-120.4451, 37.6655], [-120.44525, 37.66542], [-120.4455, 37.66526], [-120.44561, 37.66517], [-120.44655, 37.66479], [-120.44745, 37.66461], [-120.44802, 37.66442], [-120.4486, 37.66415], [-120.4489, 37.66403], [-120.44896, 37.66403], [-120.44897, 37.66546], [-120.44841, 37.66516], [-120.446, 37.66557], [-120.4447, 37.6664], [-120.44362, 37.66685], [-120.4434, 37.66746], [-120.44475, 37.66857], [-120.44489, 37.6691], [-120.44555, 37.66955], [-120.44602, 37.67113], [-120.44528, 37.67163], [-120.44515, 37.67243], [-120.44517, 37.67244], [-120.4453, 37.67229], [-120.44557, 37.6718], [-120.4461, 37.67146], [-120.44637, 37.67123], [-120.44639, 37.67116], [-120.44594, 37.66953], [-120.44588, 37.66942], [-120.4452, 37.66891], [-120.44506, 37.66845], [-120.44381, 37.66745], [-120.44378, 37.66737], [-120.44391, 37.66706], [-120.44474, 37.66674], [-120.44475, 37.66672], [-120.44619, 37.66585], [-120.44834, 37.66548], [-120.44899, 37.66585], [-120.44902, 37.66671], [-120.44904, 37.66672], [-120.44902, 37.66585], [-120.44936, 37.66604], [-120.45033, 37.66568], [-120.45153, 37.66468], [-120.45209, 37.66468], [-120.45234, 37.66491]]], [[[-120.45863, 37.66709], [-120.45837, 37.66745], [-120.45807, 37.66728], [-120.45701, 37.66699], [-120.45657, 37.66648], [-120.45591, 37.66655], [-120.45586, 37.66493], [-120.45287, 37.66491], [-120.4523, 37.66438], [-120.45142, 37.66437], [-120.45017, 37.66539], [-120.44941, 37.66567], [-120.449, 37.66546], [-120.44899, 37.66389], [-120.45094, 37.66331], [-120.45214, 37.6633], [-120.45292, 37.66353], [-120.45469, 37.6645], [-120.45597, 37.66483], [-120.45707, 37.66528], [-120.45808, 37.66542], [-120.45807, 37.66685], [-120.45863, 37.66709]]], [[[-120.4581, 37.66852], [-120.45593, 37.66852], [-120.45592, 37.66685], [-120.45642, 37.6668], [-120.45679, 37.66726], [-120.45787, 37.66754], [-120.45809, 37.66767], [-120.4581, 37.66852]]], [[[-120.46353, 37.67073], [-120.46336, 37.67081], [-120.46178, 37.67083], [-120.46161, 37.67074], [-120.46152, 37.67035], [-120.46215, 37.67035], [-120.46214, 37.67076], [-120.46273, 37.67071], [-120.46274, 37.67073], [-120.46353, 37.67073]]], [[[-120.46732, 37.67226], [-120.46714, 37.6722], [-120.46709, 37.67244], [-120.4668, 37.67265], [-120.46662, 37.67282], [-120.46272, 37.67278], [-120.46272, 37.67151], [-120.46155, 37.67149], [-120.46156, 37.67114], [-120.46174, 37.67122], [-120.46355, 37.67119], [-120.46422, 37.67085], [-120.4647, 37.67087], [-120.46593, 37.67124], [-120.46653, 37.67153], [-120.46679, 37.67169], [-120.46732, 37.67226]]], [[[-120.47223, 37.67317], [-120.4708, 37.6731], [-120.47028, 37.6729], [-120.47027, 37.67258], [-120.47085, 37.67281], [-120.47222, 37.6729], [-120.47223, 37.67317]]], [[[-120.47225, 37.67253], [-120.47103, 37.67244], [-120.4703, 37.67214], [-120.47223, 37.67225], [-120.47225, 37.67253]]], [[[-120.48912, 37.6657], [-120.4889, 37.66599], [-120.48853, 37.66657], [-120.48791, 37.6663], [-120.48855, 37.6654], [-120.48912, 37.6657]]], [[[-120.48983, 37.66609], [-120.48929, 37.66695], [-120.48896, 37.66679], [-120.48931, 37.66621], [-120.48953, 37.66592], [-120.48983, 37.66609]]]]}	Open Access 1	25750	Modesto Irrigation District	22339	2081	Modesto Irrigation District 1015	Special District 4	Irrigation District 17	http://www.mid.org/	Special District 4	2081	Modesto Irrigation District 977	Special District 4	Irrigation District 16		Stanislaus 2	199.046	Modesto Irrigation District	0	Local Other or Unknown 14	4
16373	16373	16372	{"type": "MultiPolygon", "coordinates": [[[[-120.61168, 37.65074], [-120.61119, 37.6508], [-120.6107, 37.65012], [-120.6096, 37.64943], [-120.60929, 37.64908], [-120.60895, 37.64912], [-120.60862, 37.64956], [-120.6086, 37.64996], [-120.60801, 37.65017], [-120.6077, 37.65055], [-120.60704, 37.65153], [-120.60665, 37.65203], [-120.60629, 37.65264], [-120.60628, 37.65275], [-120.6059, 37.65326], [-120.60575, 37.65389], [-120.60622, 37.65453], [-120.60604, 37.65484], [-120.60602, 37.65518], [-120.60606, 37.65547], [-120.60575, 37.6558], [-120.60564, 37.65648], [-120.60569, 37.65688], [-120.60474, 37.65732], [-120.60465, 37.65722], [-120.6046, 37.6563], [-120.60477, 37.65586], [-120.60476, 37.65579], [-120.60408, 37.65493], [-120.6042, 37.65423], [-120.60368, 37.65372], [-120.60324, 37.6539], [-120.60294, 37.65362], [-120.60343, 37.65322], [-120.60334, 37.65282], [-120.60269, 37.65267], [-120.60234, 37.65284], [-120.60251, 37.65359], [-120.6023, 37.65387], [-120.60181, 37.65423], [-120.60154, 37.65397], [-120.60188, 37.65338], [-120.60183, 37.65277], [-120.6018, 37.65266], [-120.60148, 37.65218], [-120.60099, 37.65184], [-120.60043, 37.65164], [-120.59976, 37.65155], [-120.59972, 37.65124], [-120.60279, 37.6524], [-120.60404, 37.65252], [-120.60566, 37.6518], [-120.6087, 37.64915], [-120.61047, 37.64804], [-120.61067, 37.64782], [-120.61066, 37.64824], [-120.61134, 37.64884], [-120.61129, 37.64988], [-120.61168, 37.65074]]], [[[-120.60572, 37.657], [-120.60529, 37.65791], [-120.60529, 37.65791], [-120.60482, 37.65741], [-120.60572, 37.657]]], [[[-120.61382, 37.64373], [-120.61373, 37.644], [-120.61306, 37.64444], [-120.61109, 37.64514], [-120.61086, 37.64519], [-120.60991, 37.64551], [-120.60933, 37.64563], [-120.60838, 37.64566], [-120.60744, 37.6455], [-120.60696, 37.64524], [-120.60617, 37.64478], [-120.60696, 37.6447], [-120.60916, 37.64471], [-120.61382, 37.64373]]], [[[-120.61428, 37.64851], [-120.61318, 37.64784], [-120.61261, 37.64739], [-120.61218, 37.64685], [-120.61329, 37.64634], [-120.61332, 37.64684], [-120.61382, 37.64735], [-120.61428, 37.64851]]], [[[-120.61487, 37.64591], [-120.61471, 37.64614], [-120.61426, 37.64599], [-120.61487, 37.64591], [-120.61487, 37.64591]]], [[[-120.62931, 37.64723], [-120.62794, 37.64723], [-120.62789, 37.64698], [-120.6276, 37.64638], [-120.62746, 37.64621], [-120.62725, 37.64602], [-120.62694, 37.64584], [-120.62674, 37.64577], [-120.62644, 37.64578], [-120.62565, 37.64609], [-120.62521, 37.64616], [-120.62477, 37.6463], [-120.62443, 37.64636], [-120.62399, 37.64631], [-120.62373, 37.64621], [-120.62354, 37.64617], [-120.62287, 37.64624], [-120.62256, 37.64624], [-120.62074, 37.64615], [-120.62046, 37.64607], [-120.61959, 37.64563], [-120.61933, 37.64553], [-120.62927, 37.64553], [-120.62931, 37.64723]]], [[[-120.62536, 37.65895], [-120.6252, 37.65899], [-120.62484, 37.65895], [-120.62484, 37.65817], [-120.62533, 37.65817], [-120.62536, 37.65895]]], [[[-120.6272, 37.66097], [-120.62719, 37.66184], [-120.62489, 37.66183], [-120.62487, 37.66056], [-120.62557, 37.66062], [-120.62579, 37.66066], [-120.62611, 37.66077], [-120.6266, 37.6609], [-120.62695, 37.6609], [-120.6272, 37.66097]]], [[[-120.63625, 37.64972], [-120.63585, 37.6494], [-120.63538, 37.64896], [-120.63529, 37.64885], [-120.63524, 37.64872], [-120.63507, 37.64851], [-120.63503, 37.64726], [-120.63621, 37.64725], [-120.63625, 37.64972]]], [[[-120.64994, 37.65494], [-120.64928, 37.65562], [-120.64766, 37.65477], [-120.64765, 37.65468], [-120.64803, 37.65443], [-120.64809, 37.65432], [-120.64804, 37.65425], [-120.64793, 37.65421], [-120.64784, 37.65421], [-120.64722, 37.65436], [-120.64708, 37.65437], [-120.64689, 37.65429], [-120.64677, 37.65414], [-120.64679, 37.65381], [-120.64691, 37.65341], [-120.64689, 37.65321], [-120.64691, 37.65304], [-120.64688, 37.6529], [-120.64673, 37.65269], [-120.64624, 37.65235], [-120.64611, 37.65228], [-120.64603, 37.65207], [-120.64585, 37.65201], [-120.64542, 37.65213], [-120.64478, 37.65219], [-120.64457, 37.65219], [-120.6444, 37.65212], [-120.64422, 37.65199], [-120.64394, 37.65172], [-120.64329, 37.65082], [-120.64288, 37.65047], [-120.6427, 37.65034], [-120.64244, 37.65021], [-120.64176, 37.64992], [-120.64068, 37.64968], [-120.64045, 37.64965], [-120.63993, 37.64965], [-120.63992, 37.64885], [-120.64094, 37.64922], [-120.64569, 37.65068], [-120.64825, 37.65269], [-120.64875, 37.6532], [-120.6499, 37.65413], [-120.64994, 37.65494]]], [[[-120.64986, 37.66297], [-120.64988, 37.66305], [-120.64977, 37.66334], [-120.64965, 37.66348], [-120.6493, 37.6637], [-120.64926, 37.66292], [-120.64943, 37.6629], [-120.64967, 37.66284], [-120.64986, 37.66297]]], [[[-120.65144, 37.66129], [-120.65136, 37.66139], [-120.65126, 37.66142], [-120.65059, 37.66148], [-120.65045, 37.66152], [-120.65037, 37.66163], [-120.65036, 37.66177], [-120.65032, 37.66185], [-120.65023, 37.66193], [-120.6501, 37.66198], [-120.64994, 37.66202], [-120.64992, 37.65997], [-120.65088, 37.65998], [-120.65105, 37.66018], [-120.65109, 37.66028], [-120.6511, 37.66069], [-120.65105, 37.66091], [-120.65134, 37.66099], [-120.65141, 37.66104], [-120.65145, 37.66116], [-120.65144, 37.66129]]], [[[-120.67478, 37.65643], [-120.67379, 37.65631], [-120.67277, 37.65654], [-120.67247, 37.65658], [-120.67118, 37.65636], [-120.67052, 37.65609], [-120.67039, 37.65607], [-120.6701, 37.65607], [-120.67009, 37.65624], [-120.67013, 37.65631], [-120.67046, 37.65661], [-120.67045, 37.6567], [-120.67033, 37.65681], [-120.67009, 37.65692], [-120.66998, 37.65695], [-120.66989, 37.65694], [-120.66959, 37.65662], [-120.66944, 37.65654], [-120.66925, 37.65657], [-120.66787, 37.65747], [-120.6678, 37.65755], [-120.66782, 37.65767], [-120.6679, 37.6578], [-120.66817, 37.65804], [-120.66827, 37.65824], [-120.66819, 37.65837], [-120.66792, 37.65837], [-120.66719, 37.65807], [-120.66683, 37.65802], [-120.66668, 37.65806], [-120.66613, 37.65827], [-120.66574, 37.6585], [-120.66564, 37.65865], [-120.66564, 37.65883], [-120.66551, 37.659], [-120.66533, 37.65903], [-120.66525, 37.6589], [-120.6652, 37.65876], [-120.66503, 37.65867], [-120.66477, 37.65878], [-120.66457, 37.65893], [-120.66416, 37.65913], [-120.66388, 37.6592], [-120.6634, 37.65926], [-120.66318, 37.65927], [-120.663, 37.65925], [-120.6628, 37.65921], [-120.66244, 37.65908], [-120.662, 37.65903], [-120.66183, 37.65903], [-120.66123, 37.65908], [-120.66107, 37.65904], [-120.66094, 37.65891], [-120.66091, 37.65883], [-120.66096, 37.65868], [-120.66103, 37.65862], [-120.6611, 37.65845], [-120.66107, 37.65836], [-120.66099, 37.65832], [-120.66044, 37.65834], [-120.66026, 37.65821], [-120.66025, 37.65792], [-120.66021, 37.65787], [-120.66009, 37.65784], [-120.66, 37.65789], [-120.65981, 37.65808], [-120.65967, 37.65815], [-120.65943, 37.65818], [-120.65934, 37.65814], [-120.65918, 37.65796], [-120.65901, 37.65789], [-120.65903, 37.6576], [-120.6672, 37.65759], [-120.66986, 37.65551], [-120.67132, 37.65502], [-120.67223, 37.65479], [-120.67301, 37.6547], [-120.67366, 37.65465], [-120.67408, 37.65481], [-120.67455, 37.65547], [-120.67475, 37.65549], [-120.67478, 37.65643]]], [[[-120.67644, 37.68455], [-120.67416, 37.68453], [-120.67415, 37.68549], [-120.67304, 37.6855], [-120.67315, 37.69279], [-120.66739, 37.69278], [-120.66739, 37.69174], [-120.66808, 37.69174], [-120.66927, 37.69167], [-120.67001, 37.69099], [-120.67008, 37.69083], [-120.67004, 37.69055], [-120.66994, 37.6903], [-120.66956, 37.6897], [-120.66958, 37.68918], [-120.66972, 37.6889], [-120.67004, 37.68846], [-120.67035, 37.68814], [-120.67084, 37.68774], [-120.67099, 37.68754], [-120.67114, 37.6872], [-120.6712, 37.68672], [-120.67116, 37.68596], [-120.67122, 37.68569], [-120.67146, 37.68535], [-120.6718, 37.6847], [-120.67203, 37.68433], [-120.67298, 37.68325], [-120.67323, 37.68311], [-120.67352, 37.68299], [-120.6739, 37.68288], [-120.6744, 37.68258], [-120.67451, 37.68242], [-120.6745, 37.68229], [-120.67442, 37.68218], [-120.67395, 37.68188], [-120.67641, 37.68188], [-120.67644, 37.68455]]], [[[-120.67471, 37.65419], [-120.67294, 37.65434], [-120.67193, 37.65445], [-120.67136, 37.65413], [-120.67065, 37.65403], [-120.66966, 37.6532], [-120.66833, 37.65251], [-120.66757, 37.65182], [-120.67469, 37.65197], [-120.67469, 37.65355], [-120.67471, 37.65419]]], [[[-120.67472, 37.65441], [-120.67472, 37.65453], [-120.67369, 37.65449], [-120.67472, 37.65441], [-120.67472, 37.65441]]], [[[-120.67475, 37.65533], [-120.67467, 37.65534], [-120.67421, 37.6547], [-120.6741, 37.65466], [-120.67473, 37.65468], [-120.67475, 37.65533]]], [[[-120.67769, 37.65477], [-120.67742, 37.65478], [-120.67637, 37.65487], [-120.67533, 37.65536], [-120.67527, 37.65519], [-120.67527, 37.65495], [-120.67561, 37.65503], [-120.6762, 37.65474], [-120.67741, 37.65478], [-120.67744, 37.65469], [-120.67769, 37.65477]]], [[[-120.68197, 37.66549], [-120.67692, 37.66551], [-120.67681, 37.66535], [-120.67669, 37.66513], [-120.67668, 37.66487], [-120.67675, 37.66467], [-120.6769, 37.66448], [-120.677, 37.66443], [-120.67731, 37.6644], [-120.67771, 37.66439], [-120.67796, 37.66432], [-120.67857, 37.66408], [-120.67944, 37.66389], [-120.67954, 37.66369], [-120.67944, 37.66361], [-120.67913, 37.66357], [-120.67887, 37.66357], [-120.67763, 37.66393], [-120.67683, 37.66394], [-120.67663, 37.66386], [-120.67649, 37.66369], [-120.67646, 37.6636], [-120.67646, 37.66325], [-120.67641, 37.66314], [-120.67642, 37.66303], [-120.67656, 37.66268], [-120.67667, 37.66256], [-120.67684, 37.66247], [-120.67693, 37.66245], [-120.67742, 37.66246], [-120.67759, 37.66252], [-120.67783, 37.66251], [-120.67798, 37.66244], [-120.67842, 37.66218], [-120.67871, 37.66209], [-120.67901, 37.6621], [-120.67939, 37.66228], [-120.67972, 37.66251], [-120.67999, 37.66251], [-120.68023, 37.66232], [-120.68032, 37.66215], [-120.68023, 37.66164], [-120.68022, 37.66103], [-120.68028, 37.66064], [-120.68008, 37.65991], [-120.68006, 37.65964], [-120.6799, 37.6591], [-120.67962, 37.65854], [-120.67899, 37.65777], [-120.67855, 37.65737], [-120.67817, 37.6569], [-120.67778, 37.65662], [-120.67766, 37.65656], [-120.67746, 37.65655], [-120.67736, 37.65659], [-120.67709, 37.65685], [-120.6769, 37.65696], [-120.67669, 37.65696], [-120.67585, 37.65658], [-120.67543, 37.6565], [-120.6753, 37.6565], [-120.67529, 37.65551], [-120.67539, 37.65551], [-120.67642, 37.65501], [-120.67768, 37.65493], [-120.67853, 37.655], [-120.68007, 37.65537], [-120.68013, 37.65525], [-120.68029, 37.65534], [-120.68068, 37.65577], [-120.68106, 37.65605], [-120.68161, 37.65612], [-120.68187, 37.65611], [-120.68197, 37.66549]]], [[[-120.68005, 37.65485], [-120.68003, 37.65492], [-120.67861, 37.65458], [-120.67785, 37.65453], [-120.67977, 37.65419], [-120.68005, 37.65485]]], [[[-120.68187, 37.65585], [-120.68171, 37.65586], [-120.68123, 37.6558], [-120.68095, 37.6556], [-120.68053, 37.65514], [-120.68025, 37.65498], [-120.6803, 37.65486], [-120.68008, 37.65431], [-120.68042, 37.6546], [-120.68186, 37.6551], [-120.68187, 37.65585]]]]}	Open Access 1	18251	Modesto Reservoir Regional Park	29283	2081	Modesto Irrigation District 1015	Special District 4	Irrigation District 17	http://www.mid.org/	Special District 4	2081	Modesto Irrigation District 977	Special District 4	Irrigation District 16	http://www.stancounty.com/ER/PARKS/reservoir.shtm	Stanislaus 2	380.478	Modesto Reservoir RP	0	Local Park 2	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]);