calands: units_with_maps: 3 rows where MNG_AGENCY = 620 and MNG_AG

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

3 rows where MNG_AGENCY = 620 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
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
7761	7761	7760	{"type": "Polygon", "coordinates": [[[-120.31895, 37.52502], [-120.31852, 37.52527], [-120.31803, 37.52517], [-120.31679, 37.525], [-120.31626, 37.5249], [-120.31569, 37.52483], [-120.31548, 37.52484], [-120.31468, 37.52498], [-120.31412, 37.52505], [-120.31379, 37.52505], [-120.31337, 37.52502], [-120.31309, 37.52495], [-120.31281, 37.52486], [-120.312, 37.52441], [-120.31077, 37.52366], [-120.30206, 37.5239], [-120.29728, 37.52385], [-120.29724, 37.52346], [-120.29606, 37.52324], [-120.2955, 37.52344], [-120.29558, 37.5236], [-120.29312, 37.52441], [-120.29203, 37.52461], [-120.29178, 37.52469], [-120.29147, 37.52483], [-120.29125, 37.52499], [-120.29044, 37.52582], [-120.2902, 37.52596], [-120.29006, 37.52585], [-120.2899, 37.52596], [-120.28979, 37.52594], [-120.28916, 37.52642], [-120.28887, 37.52661], [-120.28841, 37.52716], [-120.28844, 37.52726], [-120.28717, 37.5286], [-120.28707, 37.5286], [-120.28673, 37.52917], [-120.28658, 37.52955], [-120.28637, 37.53062], [-120.28636, 37.53126], [-120.28607, 37.53165], [-120.28549, 37.53229], [-120.28538, 37.53254], [-120.2853, 37.53301], [-120.28518, 37.53352], [-120.28513, 37.53367], [-120.28479, 37.53413], [-120.2846, 37.53431], [-120.28419, 37.53456], [-120.28375, 37.5348], [-120.28334, 37.5352], [-120.28311, 37.5355], [-120.28292, 37.53581], [-120.28275, 37.53658], [-120.28, 37.53667], [-120.28098, 37.53383], [-120.28102, 37.5312], [-120.28117, 37.52988], [-120.28182, 37.53], [-120.28321, 37.52909], [-120.28389, 37.52827], [-120.28464, 37.52741], [-120.28466, 37.5271], [-120.28501, 37.52659], [-120.28531, 37.52646], [-120.28587, 37.52577], [-120.28469, 37.52417], [-120.28479, 37.52371], [-120.28398, 37.52336], [-120.28302, 37.52404], [-120.28336, 37.52307], [-120.28422, 37.52264], [-120.28565, 37.52313], [-120.28597, 37.52384], [-120.28673, 37.52421], [-120.28765, 37.52339], [-120.28696, 37.52268], [-120.28806, 37.5226], [-120.28906, 37.52155], [-120.28839, 37.52087], [-120.2886, 37.52031], [-120.29, 37.52076], [-120.29197, 37.51909], [-120.29196, 37.51836], [-120.29121, 37.51803], [-120.29114, 37.51784], [-120.28969, 37.51818], [-120.28899, 37.51815], [-120.28959, 37.51765], [-120.29126, 37.51697], [-120.2917, 37.51558], [-120.29153, 37.51491], [-120.29221, 37.51322], [-120.29221, 37.51299], [-120.29285, 37.51207], [-120.29369, 37.51202], [-120.29339, 37.513], [-120.29377, 37.51341], [-120.29308, 37.51455], [-120.29252, 37.51477], [-120.29252, 37.51478], [-120.29303, 37.51534], [-120.29384, 37.51508], [-120.29389, 37.51435], [-120.29444, 37.51458], [-120.29468, 37.51399], [-120.29519, 37.51393], [-120.29506, 37.51514], [-120.29598, 37.51471], [-120.29534, 37.51566], [-120.2955, 37.51645], [-120.29641, 37.51672], [-120.29786, 37.51661], [-120.29865, 37.51672], [-120.29904, 37.51678], [-120.29933, 37.51653], [-120.30248, 37.51675], [-120.30326, 37.51675], [-120.30351, 37.51636], [-120.30361, 37.51564], [-120.30444, 37.51585], [-120.30482, 37.51623], [-120.30501, 37.51679], [-120.3066, 37.51626], [-120.30794, 37.51748], [-120.30832, 37.51674], [-120.309, 37.51656], [-120.31143, 37.51626], [-120.31199, 37.51621], [-120.31464, 37.51928], [-120.31649, 37.52163], [-120.31743, 37.52286], [-120.31532, 37.52453], [-120.31532, 37.52454], [-120.31543, 37.52453], [-120.31652, 37.52463], [-120.31895, 37.52502]]]}	Restricted Access 2	48467	Lake McClure	33177	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	626.209	Lake McClure		None 643
15542	15542	15541	{"type": "MultiPolygon", "coordinates": [[[[-120.22503, 37.57551], [-120.22499, 37.57901], [-120.22021, 37.57897], [-120.22011, 37.57541], [-120.22503, 37.57551]]], [[[-120.2707, 37.58198], [-120.27045, 37.58865], [-120.27047, 37.59077], [-120.2684, 37.58746], [-120.26758, 37.58728], [-120.26856, 37.58369], [-120.26686, 37.58326], [-120.26589, 37.58691], [-120.26573, 37.58693], [-120.26833, 37.59129], [-120.27042, 37.59216], [-120.27039, 37.59315], [-120.26292, 37.59371], [-120.26335, 37.58292], [-120.26334, 37.58243], [-120.2707, 37.58198]]], [[[-120.27059, 37.60756], [-120.27047, 37.61134], [-120.26169, 37.61141], [-120.26167, 37.61157], [-120.25669, 37.61142], [-120.25693, 37.60439], [-120.26218, 37.60437], [-120.26222, 37.60397], [-120.26637, 37.60387], [-120.26629, 37.60763], [-120.27059, 37.60756]]], [[[-120.26141, 37.61509], [-120.2612, 37.61794], [-120.26119, 37.61878], [-120.25643, 37.61877], [-120.25656, 37.61554], [-120.25645, 37.61508], [-120.26141, 37.61509]]], [[[-120.27469, 37.61905], [-120.27469, 37.62289], [-120.27008, 37.62283], [-120.27016, 37.619], [-120.26565, 37.61894], [-120.26576, 37.61514], [-120.27026, 37.61519], [-120.27017, 37.619], [-120.27469, 37.61905]]], [[[-120.15147, 37.62161], [-120.15144, 37.62212], [-120.15132, 37.62212], [-120.14929, 37.62046], [-120.14621, 37.6205], [-120.14753, 37.62193], [-120.1503, 37.62429], [-120.15047, 37.62425], [-120.15126, 37.62425], [-120.15145, 37.62423], [-120.151, 37.62466], [-120.15031, 37.62429], [-120.14971, 37.62442], [-120.14602, 37.62187], [-120.14282, 37.61934], [-120.14288, 37.61761], [-120.14137, 37.61643], [-120.14006, 37.61676], [-120.13921, 37.6149], [-120.13847, 37.61432], [-120.13846, 37.61434], [-120.13864, 37.61585], [-120.13812, 37.61617], [-120.13572, 37.61394], [-120.13721, 37.61397], [-120.13722, 37.61096], [-120.1377, 37.61113], [-120.13824, 37.61118], [-120.13977, 37.6116], [-120.14039, 37.61255], [-120.14143, 37.6126], [-120.14144, 37.6112], [-120.14356, 37.61189], [-120.14296, 37.61408], [-120.14399, 37.61608], [-120.15147, 37.62161]]], [[[-120.27469, 37.63688], [-120.27456, 37.63999], [-120.27428, 37.63999], [-120.2739, 37.63785], [-120.27129, 37.64012], [-120.26991, 37.64025], [-120.27011, 37.63697], [-120.27197, 37.63689], [-120.27469, 37.63688]]], [[[-120.28804, 37.64771], [-120.28802, 37.65131], [-120.2833, 37.65117], [-120.28348, 37.64757], [-120.28804, 37.64771]]], [[[-120.16434, 37.63453], [-120.16406, 37.63432], [-120.16535, 37.63319], [-120.16603, 37.63368], [-120.1673, 37.63235], [-120.1656, 37.63111], [-120.16432, 37.63244], [-120.16277, 37.6313], [-120.16239, 37.6281], [-120.16033, 37.62802], [-120.16008, 37.62628], [-120.15808, 37.62623], [-120.15759, 37.62358], [-120.16225, 37.6236], [-120.16234, 37.62766], [-120.1624, 37.62809], [-120.16292, 37.6281], [-120.1677, 37.63159], [-120.16901, 37.6324], [-120.17146, 37.63519], [-120.17345, 37.63571], [-120.17324, 37.63639], [-120.17598, 37.63906], [-120.17923, 37.64257], [-120.18133, 37.64228], [-120.18288, 37.64263], [-120.18234, 37.64313], [-120.18233, 37.64296], [-120.17785, 37.64318], [-120.17787, 37.64534], [-120.17718, 37.64381], [-120.17639, 37.64407], [-120.17712, 37.64586], [-120.17785, 37.64561], [-120.17785, 37.6483], [-120.17676, 37.64667], [-120.17517, 37.64819], [-120.17505, 37.65158], [-120.17274, 37.65274], [-120.17426, 37.64964], [-120.17384, 37.64535], [-120.17611, 37.64493], [-120.17611, 37.64491], [-120.17123, 37.6391], [-120.16886, 37.63914], [-120.16636, 37.63625], [-120.16517, 37.6351], [-120.16434, 37.63453]]], [[[-120.19942, 37.65321], [-120.18545, 37.65312], [-120.18509, 37.65278], [-120.1821, 37.65287], [-120.18004, 37.6516], [-120.17956, 37.65087], [-120.19147, 37.65012], [-120.19147, 37.64977], [-120.19365, 37.65053], [-120.19393, 37.65183], [-120.19747, 37.65306], [-120.19888, 37.65255], [-120.19942, 37.65321]]], [[[-120.32305, 37.6929], [-120.32256, 37.69339], [-120.32235, 37.69302], [-120.32227, 37.69294], [-120.3221, 37.69286], [-120.32176, 37.69274], [-120.32161, 37.69263], [-120.32143, 37.69239], [-120.32126, 37.69198], [-120.32113, 37.69178], [-120.32092, 37.69156], [-120.32062, 37.69136], [-120.32015, 37.69118], [-120.32006, 37.69112], [-120.31983, 37.69094], [-120.31979, 37.69133], [-120.31971, 37.69128], [-120.31938, 37.69116], [-120.31902, 37.69113], [-120.31896, 37.69114], [-120.31889, 37.69119], [-120.31885, 37.69132], [-120.31884, 37.69143], [-120.31887, 37.69159], [-120.31893, 37.69175], [-120.31901, 37.6919], [-120.31943, 37.69248], [-120.31951, 37.69265], [-120.31982, 37.69306], [-120.32007, 37.69329], [-120.32016, 37.69342], [-120.32023, 37.69355], [-120.32026, 37.69369], [-120.32027, 37.69383], [-120.32028, 37.69444], [-120.32056, 37.69487], [-120.32084, 37.69527], [-120.32105, 37.69563], [-120.32118, 37.696], [-120.3212, 37.69643], [-120.32086, 37.69643], [-120.3197, 37.6944], [-120.31824, 37.69241], [-120.31532, 37.69246], [-120.31535, 37.68888], [-120.31775, 37.68889], [-120.3178, 37.6886], [-120.3178, 37.68845], [-120.31767, 37.68824], [-120.31753, 37.68788], [-120.31753, 37.68768], [-120.31709, 37.6873], [-120.31691, 37.68708], [-120.31655, 37.68676], [-120.31617, 37.68626], [-120.31599, 37.6861], [-120.31534, 37.68535], [-120.31534, 37.68524], [-120.31523, 37.68515], [-120.31504, 37.68506], [-120.31498, 37.68502], [-120.31481, 37.68485], [-120.31462, 37.68472], [-120.3145, 37.68466], [-120.31443, 37.68458], [-120.31441, 37.68448], [-120.31439, 37.68431], [-120.31435, 37.68422], [-120.31429, 37.68414], [-120.31412, 37.68399], [-120.31399, 37.68373], [-120.31395, 37.6837], [-120.31361, 37.68358], [-120.31354, 37.68353], [-120.31337, 37.68333], [-120.31326, 37.68315], [-120.31318, 37.68285], [-120.31303, 37.68272], [-120.31304, 37.68255], [-120.313, 37.68249], [-120.31282, 37.68233], [-120.31263, 37.68224], [-120.31257, 37.68218], [-120.31251, 37.6821], [-120.31246, 37.68195], [-120.3124, 37.68183], [-120.31227, 37.68165], [-120.31221, 37.6816], [-120.31201, 37.68153], [-120.31183, 37.68139], [-120.31169, 37.68126], [-120.31139, 37.68091], [-120.31135, 37.68082], [-120.31132, 37.6807], [-120.3111, 37.68059], [-120.31087, 37.68022], [-120.31086, 37.68023], [-120.31069, 37.68154], [-120.30587, 37.68156], [-120.30091, 37.68154], [-120.30127, 37.67781], [-120.29598, 37.67777], [-120.29599, 37.67625], [-120.29264, 37.67623], [-120.29254, 37.67982], [-120.28809, 37.6796], [-120.28798, 37.67589], [-120.27894, 37.67524], [-120.27489, 37.67552], [-120.27428, 37.66634], [-120.2695, 37.66665], [-120.25918, 37.66738], [-120.25934, 37.66452], [-120.25342, 37.66433], [-120.25337, 37.66659], [-120.25346, 37.67204], [-120.259, 37.67216], [-120.25906, 37.67037], [-120.26472, 37.6705], [-120.26468, 37.6737], [-120.25895, 37.67352], [-120.25908, 37.67961], [-120.25912, 37.6831], [-120.25926, 37.6879], [-120.2593, 37.69219], [-120.25901, 37.70076], [-120.25742, 37.70101], [-120.2511, 37.70193], [-120.24991, 37.70291], [-120.24956, 37.70111], [-120.25362, 37.70124], [-120.25316, 37.6977], [-120.24992, 37.69762], [-120.24995, 37.6939], [-120.24057, 37.69398], [-120.24063, 37.69036], [-120.23613, 37.69035], [-120.2362, 37.68773], [-120.23425, 37.6875], [-120.23624, 37.68642], [-120.23633, 37.68273], [-120.23624, 37.67886], [-120.24057, 37.67893], [-120.24056, 37.67513], [-120.24488, 37.67535], [-120.24494, 37.67161], [-120.24049, 37.67142], [-120.24046, 37.66835], [-120.23718, 37.66815], [-120.23774, 37.66769], [-120.23774, 37.66767], [-120.2361, 37.66763], [-120.23608, 37.66387], [-120.23163, 37.66386], [-120.23171, 37.66762], [-120.22714, 37.66752], [-120.22712, 37.66377], [-120.22263, 37.66368], [-120.22261, 37.66399], [-120.22242, 37.66373], [-120.21858, 37.66373], [-120.21868, 37.66748], [-120.21678, 37.66747], [-120.21833, 37.66692], [-120.21707, 37.66522], [-120.21357, 37.6652], [-120.21263, 37.6644], [-120.20855, 37.66382], [-120.20633, 37.66352], [-120.2072, 37.66117], [-120.20544, 37.66051], [-120.20562, 37.65411], [-120.20421, 37.65318], [-120.20069, 37.65268], [-120.20013, 37.6517], [-120.20566, 37.65192], [-120.21415, 37.65222], [-120.21414, 37.65998], [-120.2241, 37.66008], [-120.23154, 37.66014], [-120.23151, 37.65263], [-120.23604, 37.65269], [-120.23604, 37.66016], [-120.23996, 37.66022], [-120.24001, 37.66018], [-120.24354, 37.66028], [-120.24952, 37.66038], [-120.24948, 37.66418], [-120.2534, 37.66433], [-120.25341, 37.66432], [-120.2535, 37.65857], [-120.25354, 37.65678], [-120.25079, 37.6567], [-120.24049, 37.6565], [-120.24041, 37.65274], [-120.2444, 37.65279], [-120.25129, 37.65295], [-120.25924, 37.65308], [-120.26, 37.65316], [-120.26007, 37.65206], [-120.26188, 37.65241], [-120.27418, 37.65138], [-120.27434, 37.65323], [-120.27433, 37.65594], [-120.27882, 37.65561], [-120.27902, 37.65909], [-120.27885, 37.66059], [-120.27878, 37.66246], [-120.28739, 37.66277], [-120.28739, 37.66138], [-120.28731, 37.65918], [-120.29672, 37.65947], [-120.29602, 37.67399], [-120.30164, 37.67407], [-120.30066, 37.67467], [-120.30149, 37.67546], [-120.3015, 37.67546], [-120.30154, 37.67505], [-120.30185, 37.67533], [-120.30218, 37.67553], [-120.30224, 37.67558], [-120.3023, 37.67567], [-120.30232, 37.67567], [-120.30237, 37.67558], [-120.30238, 37.67552], [-120.30234, 37.67536], [-120.30234, 37.67533], [-120.30259, 37.67519], [-120.30272, 37.67507], [-120.30281, 37.67501], [-120.30293, 37.67498], [-120.30301, 37.67491], [-120.30306, 37.6749], [-120.30317, 37.6749], [-120.30324, 37.67492], [-120.3034, 37.67502], [-120.30383, 37.67551], [-120.3043, 37.67623], [-120.30469, 37.6766], [-120.30479, 37.67689], [-120.3048, 37.67707], [-120.30482, 37.67709], [-120.30505, 37.67711], [-120.30518, 37.67716], [-120.3055, 37.67741], [-120.30558, 37.67754], [-120.30558, 37.6776], [-120.30554, 37.6777], [-120.30544, 37.67784], [-120.30518, 37.67817], [-120.30509, 37.67844], [-120.30502, 37.67873], [-120.30504, 37.67875], [-120.30517, 37.67872], [-120.30526, 37.67862], [-120.30533, 37.67858], [-120.3057, 37.67848], [-120.30613, 37.67843], [-120.30623, 37.67845], [-120.30659, 37.67533], [-120.30658, 37.67533], [-120.30653, 37.67538], [-120.30641, 37.67545], [-120.30627, 37.67548], [-120.30612, 37.67544], [-120.3058, 37.67522], [-120.3057, 37.67512], [-120.30556, 37.67494], [-120.30515, 37.6743], [-120.30499, 37.67412], [-120.30549, 37.67412], [-120.30622, 37.67516], [-120.30665, 37.67487], [-120.30673, 37.67414], [-120.31161, 37.67416], [-120.31107, 37.67951], [-120.31123, 37.68028], [-120.31281, 37.6815], [-120.31386, 37.68277], [-120.31429, 37.68337], [-120.31482, 37.6843], [-120.31535, 37.68474], [-120.31586, 37.68497], [-120.31645, 37.68558], [-120.31761, 37.68696], [-120.31802, 37.6875], [-120.31827, 37.68825], [-120.31822, 37.68889], [-120.31988, 37.69035], [-120.32142, 37.69134], [-120.32248, 37.69239], [-120.32305, 37.6929]], [[-120.27867, 37.66359], [-120.27868, 37.66358], [-120.27877, 37.66248], [-120.27792, 37.6635], [-120.27867, 37.66359]]]]}	Open Access 1	48981	Lake McClure (Exchequer Reservoir)	6445	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.blm.gov/wo/st/en.html	US Bureau of Land Management 1	2240	Merced Irrigation District 620	Special District 4	Irrigation District 16	http://www.lakemcclure.com/	Mariposa 31	5305.275	Lake McClure (Exchequer Reservoir)	0	None 1365

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