calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES_TP = 277 and MNG_AG

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

1 row where ACCESS_TYP = 1, DES_TP = 277 and MNG_AG_TYP = 16

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
3371	3371	3370	{"type": "MultiPolygon", "coordinates": [[[[-120.22268, 37.57899], [-120.21963, 37.58186], [-120.21703, 37.58094], [-120.21897, 37.58056], [-120.21977, 37.57897], [-120.2202, 37.57859], [-120.22022, 37.57897], [-120.22268, 37.57899]]], [[[-120.08693, 37.59674], [-120.08677, 37.60151], [-120.08661, 37.60425], [-120.07683, 37.60409], [-120.0772, 37.59643], [-120.08693, 37.59674]]], [[[-120.14144, 37.6112], [-120.14143, 37.61261], [-120.14039, 37.61255], [-120.13977, 37.6116], [-120.13824, 37.61118], [-120.1377, 37.61113], [-120.13722, 37.61096], [-120.13721, 37.61398], [-120.13501, 37.61392], [-120.13498, 37.6145], [-120.13132, 37.61436], [-120.13079, 37.61436], [-120.1308, 37.61321], [-120.13012, 37.6134], [-120.1301, 37.61253], [-120.13009, 37.61252], [-120.12634, 37.61432], [-120.12486, 37.61369], [-120.12498, 37.61108], [-120.12298, 37.60693], [-120.11921, 37.60526], [-120.11552, 37.60482], [-120.11355, 37.60534], [-120.11048, 37.60554], [-120.10575, 37.60347], [-120.10566, 37.60478], [-120.10877, 37.60647], [-120.10872, 37.60846], [-120.09903, 37.60808], [-120.09903, 37.60489], [-120.09461, 37.60477], [-120.09422, 37.60161], [-120.09205, 37.60191], [-120.09175, 37.60035], [-120.09217, 37.60021], [-120.09363, 37.60008], [-120.09513, 37.60065], [-120.0956, 37.60118], [-120.09589, 37.6023], [-120.09647, 37.60294], [-120.09698, 37.6032], [-120.09802, 37.60282], [-120.09683, 37.60124], [-120.09508, 37.60019], [-120.09292, 37.59965], [-120.09165, 37.59993], [-120.09163, 37.5995], [-120.09525, 37.59979], [-120.09889, 37.60243], [-120.0989, 37.60242], [-120.09875, 37.60115], [-120.10083, 37.60087], [-120.10131, 37.60171], [-120.1058, 37.60179], [-120.10575, 37.60347], [-120.10937, 37.60401], [-120.11174, 37.60461], [-120.11844, 37.60436], [-120.11975, 37.60478], [-120.1236, 37.60605], [-120.12572, 37.60833], [-120.12652, 37.61157], [-120.12781, 37.6126], [-120.13129, 37.61096], [-120.1336, 37.61088], [-120.13361, 37.61087], [-120.133, 37.60967], [-120.13508, 37.60986], [-120.13463, 37.60871], [-120.13466, 37.60803], [-120.13447, 37.60729], [-120.13485, 37.60694], [-120.13428, 37.60655], [-120.13359, 37.60556], [-120.13421, 37.60473], [-120.13692, 37.60815], [-120.13721, 37.60982], [-120.14144, 37.6112]]], [[[-120.16277, 37.6313], [-120.16265, 37.63137], [-120.16144, 37.63034], [-120.15525, 37.62738], [-120.15569, 37.62686], [-120.15509, 37.62627], [-120.15414, 37.62598], [-120.15264, 37.62505], [-120.15184, 37.62511], [-120.151, 37.62466], [-120.15143, 37.62425], [-120.15143, 37.62423], [-120.15126, 37.62425], [-120.15047, 37.62425], [-120.15031, 37.62429], [-120.14753, 37.62193], [-120.1462, 37.62049], [-120.1493, 37.62046], [-120.15132, 37.62212], [-120.15144, 37.62212], [-120.15147, 37.62161], [-120.15456, 37.62347], [-120.15759, 37.62358], [-120.15809, 37.62623], [-120.16008, 37.62628], [-120.16033, 37.62802], [-120.16239, 37.6281], [-120.16277, 37.6313]]], [[[-120.16731, 37.63235], [-120.16602, 37.63368], [-120.16432, 37.63244], [-120.1656, 37.63111], [-120.16731, 37.63235]]], [[[-120.16636, 37.63625], [-120.16613, 37.63746], [-120.16425, 37.6355], [-120.16449, 37.63523], [-120.16385, 37.63478], [-120.16434, 37.63453], [-120.16517, 37.6351], [-120.16636, 37.63625]]], [[[-120.27003, 37.6382], [-120.27003, 37.6382], [-120.26991, 37.64025], [-120.26866, 37.63814], [-120.27003, 37.6382]]], [[[-120.19148, 37.65012], [-120.17785, 37.65098], [-120.17785, 37.64562], [-120.17784, 37.64561], [-120.17712, 37.64586], [-120.17638, 37.64407], [-120.17718, 37.64381], [-120.17786, 37.6453], [-120.17785, 37.64318], [-120.18234, 37.64296], [-120.18234, 37.64313], [-120.18003, 37.64526], [-120.18292, 37.64982], [-120.1842, 37.65022], [-120.18597, 37.64887], [-120.18559, 37.64762], [-120.18637, 37.64801], [-120.19147, 37.64977], [-120.19148, 37.65012]]], [[[-120.23154, 37.66014], [-120.2241, 37.66008], [-120.21413, 37.65998], [-120.21415, 37.65222], [-120.22216, 37.65252], [-120.23151, 37.65263], [-120.23154, 37.66014]]], [[[-120.20562, 37.65411], [-120.20544, 37.66051], [-120.20353, 37.66042], [-120.20366, 37.65936], [-120.20105, 37.65741], [-120.19968, 37.65839], [-120.19552, 37.65678], [-120.19395, 37.65547], [-120.19224, 37.65491], [-120.19093, 37.65316], [-120.20431, 37.65325], [-120.20562, 37.65411]]], [[[-120.29773, 37.62284], [-120.30872, 37.62304], [-120.3087, 37.62347], [-120.30872, 37.62357], [-120.30871, 37.62367], [-120.30868, 37.6238], [-120.30858, 37.62403], [-120.30852, 37.62427], [-120.3096, 37.62437], [-120.31033, 37.6239], [-120.31097, 37.62385], [-120.31093, 37.62311], [-120.31639, 37.62331], [-120.31631, 37.62593], [-120.31524, 37.62525], [-120.31346, 37.62514], [-120.31088, 37.62602], [-120.3083, 37.62598], [-120.30835, 37.62866], [-120.3083, 37.62912], [-120.30831, 37.62917], [-120.30814, 37.62916], [-120.30801, 37.6292], [-120.3078, 37.62951], [-120.30672, 37.63175], [-120.30649, 37.63269], [-120.3064, 37.63367], [-120.30639, 37.63399], [-120.29745, 37.63393], [-120.29747, 37.63721], [-120.29738, 37.64088], [-120.29735, 37.64437], [-120.29713, 37.65062], [-120.29374, 37.65055], [-120.29379, 37.65092], [-120.29438, 37.65111], [-120.29437, 37.65151], [-120.295, 37.6541], [-120.29456, 37.65455], [-120.2955, 37.655], [-120.29629, 37.65611], [-120.29682, 37.65734], [-120.29672, 37.65947], [-120.28732, 37.65918], [-120.28739, 37.66138], [-120.2874, 37.66278], [-120.27879, 37.66246], [-120.27868, 37.66359], [-120.27791, 37.66351], [-120.27878, 37.66246], [-120.27885, 37.66059], [-120.27902, 37.65908], [-120.27882, 37.65562], [-120.27433, 37.65595], [-120.27434, 37.65323], [-120.27636, 37.65409], [-120.2779, 37.65361], [-120.28212, 37.65583], [-120.28359, 37.65567], [-120.28344, 37.6542], [-120.28216, 37.65241], [-120.28054, 37.65108], [-120.2827, 37.65115], [-120.28256, 37.65053], [-120.28336, 37.64989], [-120.28331, 37.65117], [-120.28802, 37.65131], [-120.28804, 37.64771], [-120.28348, 37.64757], [-120.28341, 37.64881], [-120.28214, 37.64876], [-120.28046, 37.64679], [-120.28177, 37.64647], [-120.28033, 37.64422], [-120.27908, 37.64391], [-120.27908, 37.64337], [-120.2777, 37.64384], [-120.27698, 37.64351], [-120.27722, 37.64229], [-120.27789, 37.64086], [-120.27747, 37.64002], [-120.2764, 37.6404], [-120.27456, 37.63999], [-120.27469, 37.63689], [-120.27197, 37.63689], [-120.27011, 37.63697], [-120.2704, 37.63567], [-120.26906, 37.63316], [-120.26647, 37.63216], [-120.26535, 37.62848], [-120.26331, 37.62567], [-120.2654, 37.6242], [-120.26322, 37.6241], [-120.26268, 37.62304], [-120.26085, 37.62311], [-120.26062, 37.62293], [-120.26061, 37.6238], [-120.26001, 37.62386], [-120.26002, 37.6227], [-120.26037, 37.62271], [-120.26106, 37.62062], [-120.26352, 37.61986], [-120.26141, 37.6194], [-120.26203, 37.61815], [-120.2612, 37.61794], [-120.26141, 37.61509], [-120.25645, 37.61508], [-120.25611, 37.61366], [-120.25436, 37.61428], [-120.254, 37.61163], [-120.2526, 37.61063], [-120.25359, 37.61004], [-120.2536, 37.61003], [-120.25191, 37.60937], [-120.25194, 37.60854], [-120.25075, 37.60841], [-120.25085, 37.60788], [-120.24847, 37.60673], [-120.24912, 37.60463], [-120.24833, 37.60425], [-120.24708, 37.60426], [-120.24701, 37.60599], [-120.2454, 37.6063], [-120.2435, 37.60779], [-120.24374, 37.60858], [-120.24294, 37.60881], [-120.24208, 37.60785], [-120.24055, 37.60725], [-120.23999, 37.6078], [-120.23845, 37.60776], [-120.2385, 37.6066], [-120.24092, 37.60623], [-120.24215, 37.60552], [-120.24218, 37.60394], [-120.24059, 37.60369], [-120.24043, 37.60283], [-120.24455, 37.60228], [-120.24536, 37.6018], [-120.24511, 37.60122], [-120.24546, 37.60068], [-120.24415, 37.60024], [-120.24361, 37.59977], [-120.24434, 37.59952], [-120.24424, 37.59794], [-120.24504, 37.59757], [-120.24332, 37.59684], [-120.24395, 37.5959], [-120.24232, 37.59354], [-120.23809, 37.59013], [-120.23809, 37.58736], [-120.2374, 37.58747], [-120.23649, 37.58581], [-120.23572, 37.58335], [-120.23419, 37.58523], [-120.2336, 37.58523], [-120.23359, 37.58652], [-120.23074, 37.58297], [-120.22493, 37.58274], [-120.22503, 37.58113], [-120.22337, 37.579], [-120.22499, 37.579], [-120.22503, 37.57551], [-120.22425, 37.57549], [-120.22375, 37.57369], [-120.22603, 37.57437], [-120.22668, 37.57349], [-120.22774, 37.5751], [-120.22882, 37.57564], [-120.23288, 37.5765], [-120.23289, 37.57648], [-120.23168, 37.57278], [-120.23217, 37.57243], [-120.23524, 37.57502], [-120.2367, 37.57793], [-120.23817, 37.57944], [-120.23935, 37.57948], [-120.23967, 37.57796], [-120.24072, 37.57821], [-120.24143, 37.5769], [-120.24142, 37.57689], [-120.24011, 37.57654], [-120.2414, 37.57599], [-120.24134, 37.57422], [-120.24238, 37.57371], [-120.2407, 37.57267], [-120.24144, 37.57191], [-120.24144, 37.56874], [-120.24215, 37.56902], [-120.25044, 37.56908], [-120.25068, 37.57231], [-120.25328, 37.57662], [-120.25423, 37.57691], [-120.25534, 37.57764], [-120.25528, 37.57847], [-120.25688, 37.57912], [-120.26332, 37.57901], [-120.26335, 37.58292], [-120.26292, 37.59371], [-120.27038, 37.59315], [-120.27042, 37.59216], [-120.26833, 37.59129], [-120.26572, 37.58692], [-120.26589, 37.5869], [-120.26686, 37.58326], [-120.26857, 37.58369], [-120.26758, 37.58727], [-120.2684, 37.58746], [-120.27046, 37.59074], [-120.27047, 37.59075], [-120.27045, 37.58865], [-120.27074, 37.58067], [-120.27089, 37.57523], [-120.27216, 37.57541], [-120.27332, 37.57624], [-120.27385, 37.57803], [-120.27759, 37.57808], [-120.27799, 37.57607], [-120.27978, 37.57532], [-120.27987, 37.57068], [-120.28005, 37.56325], [-120.27959, 37.56101], [-120.28002, 37.55983], [-120.27992, 37.55948], [-120.27899, 37.55909], [-120.27909, 37.5584], [-120.27965, 37.55853], [-120.27966, 37.55852], [-120.27936, 37.55727], [-120.27973, 37.55648], [-120.28002, 37.55568], [-120.28031, 37.55524], [-120.28033, 37.55312], [-120.28139, 37.55312], [-120.28223, 37.55149], [-120.28223, 37.55078], [-120.28201, 37.55032], [-120.28047, 37.54891], [-120.27956, 37.54803], [-120.27758, 37.54375], [-120.27806, 37.54379], [-120.27838, 37.54415], [-120.27839, 37.54414], [-120.27954, 37.54124], [-120.2797, 37.53999], [-120.28009, 37.53854], [-120.28028, 37.53836], [-120.28, 37.53667], [-120.28275, 37.53658], [-120.28271, 37.5382], [-120.28252, 37.53827], [-120.28208, 37.54012], [-120.28229, 37.54022], [-120.28216, 37.54112], [-120.2821, 37.5427], [-120.28205, 37.54281], [-120.28202, 37.54319], [-120.28191, 37.54351], [-120.28162, 37.54404], [-120.28163, 37.54616], [-120.28173, 37.54644], [-120.28197, 37.54691], [-120.2822, 37.54709], [-120.28266, 37.54767], [-120.28312, 37.54848], [-120.28355, 37.54889], [-120.2843, 37.54967], [-120.28519, 37.55045], [-120.2852, 37.55044], [-120.28524, 37.55002], [-120.28536, 37.55], [-120.28534, 37.5507], [-120.28548, 37.55086], [-120.28547, 37.55118], [-120.28536, 37.55144], [-120.28531, 37.55248], [-120.28552, 37.55277], [-120.28576, 37.5534], [-120.28529, 37.55403], [-120.28466, 37.55417], [-120.28441, 37.55428], [-120.28407, 37.55449], [-120.28382, 37.55466], [-120.28359, 37.55484], [-120.28345, 37.55493], [-120.28335, 37.55514], [-120.28321, 37.55558], [-120.28332, 37.55561], [-120.28326, 37.55608], [-120.28313, 37.55609], [-120.28285, 37.55745], [-120.28284, 37.5577], [-120.2829, 37.55799], [-120.28309, 37.55838], [-120.28325, 37.55896], [-120.28325, 37.55933], [-120.28318, 37.55966], [-120.28351, 37.55983], [-120.28328, 37.56022], [-120.28314, 37.56052], [-120.2831, 37.56078], [-120.2831, 37.56092], [-120.28313, 37.56115], [-120.2828, 37.56124], [-120.28292, 37.56174], [-120.28284, 37.56253], [-120.28261, 37.56331], [-120.28345, 37.56473], [-120.28396, 37.56596], [-120.2838, 37.5661], [-120.28415, 37.56712], [-120.28452, 37.56714], [-120.28445, 37.56928], [-120.28467, 37.57011], [-120.28492, 37.57071], [-120.2851, 37.57091], [-120.28899, 37.57099], [-120.28893, 37.57477], [-120.28712, 37.57473], [-120.28722, 37.57549], [-120.2873, 37.57589], [-120.28748, 37.57619], [-120.28774, 37.57726], [-120.28787, 37.57836], [-120.28794, 37.58016], [-120.28809, 37.58017], [-120.28817, 37.58122], [-120.28826, 37.5816], [-120.28845, 37.58201], [-120.28858, 37.58217], [-120.28869, 37.58236], [-120.28877, 37.58245], [-120.28874, 37.58509], [-120.28829, 37.58532], [-120.28793, 37.58559], [-120.28757, 37.58598], [-120.28766, 37.58609], [-120.28725, 37.58645], [-120.28711, 37.58644], [-120.28674, 37.58663], [-120.28617, 37.58682], [-120.28501, 37.58697], [-120.28464, 37.58711], [-120.2841, 37.58736], [-120.28404, 37.58961], [-120.28397, 37.59331], [-120.28398, 37.59537], [-120.28424, 37.59569], [-120.28447, 37.59676], [-120.28413, 37.59899], [-120.284, 37.59911], [-120.28397, 37.60753], [-120.28389, 37.6129], [-120.28251, 37.61287], [-120.2825, 37.61288], [-120.28278, 37.61348], [-120.28151, 37.61359], [-120.28189, 37.61408], [-120.28186, 37.61737], [-120.28119, 37.61746], [-120.28005, 37.61586], [-120.28003, 37.61586], [-120.28004, 37.61661], [-120.27973, 37.61685], [-120.27998, 37.61746], [-120.28054, 37.61747], [-120.28092, 37.61791], [-120.28066, 37.61844], [-120.28155, 37.61852], [-120.28199, 37.61958], [-120.28071, 37.61978], [-120.28094, 37.62138], [-120.28132, 37.62168], [-120.28099, 37.62221], [-120.28192, 37.62296], [-120.28842, 37.62294], [-120.29773, 37.62284]], [[-120.28023, 37.62294], [-120.28024, 37.62293], [-120.27917, 37.62051], [-120.27916, 37.62052], [-120.27915, 37.62117], [-120.27853, 37.62125], [-120.27434, 37.61558], [-120.27353, 37.61573], [-120.27701, 37.62227], [-120.27765, 37.62292], [-120.28023, 37.62294]], [[-120.27468, 37.62288], [-120.27469, 37.62287], [-120.27469, 37.61905], [-120.27017, 37.619], [-120.27008, 37.62283], [-120.27468, 37.62288]], [[-120.27016, 37.619], [-120.27025, 37.61519], [-120.26577, 37.61514], [-120.26566, 37.61894], [-120.27016, 37.619]], [[-120.26629, 37.60763], [-120.26636, 37.60387], [-120.26222, 37.60397], [-120.26219, 37.60437], [-120.25693, 37.60439], [-120.2567, 37.61141], [-120.26166, 37.61157], [-120.26168, 37.61141], [-120.27046, 37.61134], [-120.27059, 37.60757], [-120.26629, 37.60763]], [[-120.24146, 37.58477], [-120.24027, 37.58454], [-120.23915, 37.58313], [-120.23814, 37.58302], [-120.23858, 37.58522], [-120.23809, 37.58661], [-120.24128, 37.58659], [-120.24272, 37.58549], [-120.24268, 37.58439], [-120.24146, 37.58477]]], [[[-120.25451, 37.66574], [-120.25337, 37.66659], [-120.25341, 37.66433], [-120.24947, 37.66418], [-120.24951, 37.66038], [-120.24354, 37.66028], [-120.24001, 37.66018], [-120.24053, 37.65968], [-120.24098, 37.65785], [-120.24266, 37.65692], [-120.24633, 37.65711], [-120.24749, 37.65687], [-120.24852, 37.65765], [-120.25032, 37.65853], [-120.25033, 37.65851], [-120.24907, 37.65667], [-120.25079, 37.6567], [-120.2535, 37.65857], [-120.25341, 37.66432], [-120.25407, 37.66436], [-120.25451, 37.66574]]], [[[-120.3066, 37.67532], [-120.30623, 37.67846], [-120.3062, 37.67843], [-120.30613, 37.67843], [-120.3057, 37.67848], [-120.30533, 37.67858], [-120.30526, 37.67862], [-120.30517, 37.67872], [-120.30503, 37.67875], [-120.30502, 37.67873], [-120.30509, 37.67844], [-120.30518, 37.67817], [-120.30554, 37.6777], [-120.30558, 37.6776], [-120.30558, 37.67754], [-120.3055, 37.67741], [-120.30518, 37.67716], [-120.30505, 37.67711], [-120.30482, 37.67709], [-120.3048, 37.67707], [-120.30479, 37.67689], [-120.30469, 37.6766], [-120.3043, 37.67623], [-120.30383, 37.67551], [-120.3034, 37.67502], [-120.30324, 37.67492], [-120.30317, 37.6749], [-120.30307, 37.6749], [-120.30301, 37.67491], [-120.30293, 37.67498], [-120.30281, 37.67501], [-120.30272, 37.67507], [-120.30259, 37.67519], [-120.30234, 37.67533], [-120.30234, 37.67537], [-120.30239, 37.67552], [-120.30236, 37.67562], [-120.30232, 37.67567], [-120.3023, 37.67568], [-120.30224, 37.67558], [-120.30219, 37.67553], [-120.30185, 37.67533], [-120.30177, 37.67525], [-120.30155, 37.67506], [-120.30154, 37.67507], [-120.3015, 37.67548], [-120.30065, 37.67467], [-120.30161, 37.67409], [-120.30161, 37.67407], [-120.29602, 37.67399], [-120.29623, 37.66974], [-120.30152, 37.66996], [-120.30164, 37.67406], [-120.30499, 37.67412], [-120.30515, 37.6743], [-120.30541, 37.67472], [-120.3057, 37.67512], [-120.30602, 37.67538], [-120.30612, 37.67544], [-120.30627, 37.67548], [-120.30641, 37.67545], [-120.30653, 37.67539], [-120.3066, 37.67532]]], [[[-120.3178, 37.68845], [-120.3178, 37.6886], [-120.31776, 37.68889], [-120.31671, 37.68889], [-120.31624, 37.68822], [-120.31534, 37.68722], [-120.31394, 37.68717], [-120.31338, 37.68678], [-120.3138, 37.68605], [-120.3125, 37.68471], [-120.31067, 37.68275], [-120.3095, 37.68155], [-120.31068, 37.68154], [-120.31086, 37.6802], [-120.3111, 37.68059], [-120.31133, 37.6807], [-120.31135, 37.68082], [-120.31139, 37.6809], [-120.31169, 37.68126], [-120.31183, 37.68139], [-120.31201, 37.68153], [-120.31221, 37.6816], [-120.31227, 37.68165], [-120.3124, 37.68183], [-120.31246, 37.68195], [-120.31251, 37.6821], [-120.31257, 37.68218], [-120.31264, 37.68225], [-120.31282, 37.68233], [-120.313, 37.68249], [-120.31304, 37.68255], [-120.31303, 37.68272], [-120.31318, 37.68285], [-120.31326, 37.68315], [-120.31337, 37.68333], [-120.31354, 37.68353], [-120.31361, 37.68358], [-120.31395, 37.6837], [-120.31399, 37.68373], [-120.31412, 37.68399], [-120.31429, 37.68415], [-120.31435, 37.68422], [-120.31439, 37.68431], [-120.31441, 37.68448], [-120.31443, 37.68458], [-120.3145, 37.68466], [-120.31462, 37.68472], [-120.31481, 37.68485], [-120.31498, 37.68502], [-120.31504, 37.68506], [-120.31523, 37.68515], [-120.31534, 37.68524], [-120.31535, 37.68536], [-120.31599, 37.6861], [-120.31616, 37.68626], [-120.31655, 37.68676], [-120.31691, 37.68708], [-120.31709, 37.6873], [-120.31753, 37.68768], [-120.31753, 37.68788], [-120.31767, 37.68824], [-120.3178, 37.68845]]], [[[-120.31992, 37.68888], [-120.31987, 37.69035], [-120.31822, 37.68889], [-120.31992, 37.68888], [-120.31992, 37.68888]]], [[[-120.32256, 37.69339], [-120.32252, 37.69342], [-120.32125, 37.69304], [-120.32086, 37.69241], [-120.32017, 37.69243], [-120.32058, 37.69309], [-120.32097, 37.69434], [-120.32151, 37.6952], [-120.32143, 37.69645], [-120.3212, 37.69643], [-120.32118, 37.696], [-120.32105, 37.69563], [-120.32084, 37.69527], [-120.32056, 37.69487], [-120.32028, 37.69444], [-120.32027, 37.69383], [-120.32026, 37.69369], [-120.32023, 37.69355], [-120.32016, 37.69342], [-120.32007, 37.69329], [-120.31982, 37.69306], [-120.31951, 37.69265], [-120.31943, 37.69248], [-120.31901, 37.6919], [-120.31887, 37.69159], [-120.31884, 37.69143], [-120.31885, 37.69133], [-120.31889, 37.69119], [-120.31896, 37.69114], [-120.31902, 37.69113], [-120.31938, 37.69116], [-120.31971, 37.69128], [-120.31978, 37.69132], [-120.31982, 37.69093], [-120.32006, 37.69112], [-120.32015, 37.69118], [-120.32062, 37.69136], [-120.32092, 37.69156], [-120.32113, 37.69178], [-120.32126, 37.69198], [-120.32143, 37.69239], [-120.32161, 37.69263], [-120.32176, 37.69274], [-120.32211, 37.69286], [-120.32227, 37.69294], [-120.32235, 37.69302], [-120.32256, 37.69339]]], [[[-120.23633, 37.68273], [-120.23624, 37.68642], [-120.23427, 37.68749], [-120.2362, 37.68773], [-120.23614, 37.69035], [-120.24063, 37.69036], [-120.24058, 37.69398], [-120.24995, 37.6939], [-120.24992, 37.69762], [-120.25316, 37.6977], [-120.25348, 37.70014], [-120.25314, 37.69961], [-120.25175, 37.69943], [-120.25039, 37.69902], [-120.2503, 37.69915], [-120.25131, 37.70023], [-120.2509, 37.70022], [-120.24934, 37.69936], [-120.24917, 37.69939], [-120.24917, 37.6994], [-120.24947, 37.70048], [-120.24956, 37.70111], [-120.24846, 37.70108], [-120.24798, 37.70026], [-120.24617, 37.69875], [-120.24553, 37.69872], [-120.24546, 37.6975], [-120.23492, 37.69791], [-120.23115, 37.69798], [-120.23111, 37.70159], [-120.2304, 37.70163], [-120.22772, 37.70005], [-120.22816, 37.698], [-120.22259, 37.69791], [-120.22286, 37.69067], [-120.23135, 37.69064], [-120.23151, 37.68639], [-120.22678, 37.68643], [-120.22681, 37.68526], [-120.2278, 37.68434], [-120.22685, 37.68423], [-120.2269, 37.68258], [-120.22715, 37.68257], [-120.22716, 37.67877], [-120.22435, 37.67874], [-120.22428, 37.67719], [-120.22179, 37.67748], [-120.22099, 37.67527], [-120.21944, 37.6757], [-120.21823, 37.67111], [-120.21663, 37.67098], [-120.21452, 37.66927], [-120.2151, 37.66805], [-120.21678, 37.66747], [-120.21867, 37.66748], [-120.21857, 37.66373], [-120.22242, 37.66373], [-120.22339, 37.66507], [-120.22675, 37.66655], [-120.22714, 37.66674], [-120.22715, 37.66752], [-120.2317, 37.66762], [-120.23171, 37.66761], [-120.23163, 37.66386], [-120.23608, 37.66387], [-120.2361, 37.66762], [-120.23776, 37.66767], [-120.2372, 37.66813], [-120.2372, 37.66815], [-120.24046, 37.66835], [-120.2405, 37.67142], [-120.24494, 37.67161], [-120.24488, 37.67535], [-120.24056, 37.67513], [-120.24058, 37.67893], [-120.23625, 37.67886], [-120.23633, 37.68273]]]]}	Open Access 1	24458	Lake McClure (Exchequer Reservoir)	6445	2240	Merced Irrigation District 631	Special District 4	Irrigation District 17	http://www.lakemcclure.com/	Special District 4	2240	Merced Irrigation District 620	Special District 4	Irrigation District 16	http://www.lakemcclure.com/	Mariposa 31	9725.152	Lake McClure (Exchequer Reservoir)	0	None 277

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