calands: units_with_maps: 3 rows where COUNTY = 21 and DES

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

3 rows where COUNTY = 21 and DES_TP = 82

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	DES_TP	GAP_STS
5598	5598	5597	{"type": "MultiPolygon", "coordinates": [[[[-120.53915, 37.97939], [-120.539, 37.97943], [-120.53854, 37.9796], [-120.53811, 37.9797], [-120.53744, 37.97989], [-120.53634, 37.98014], [-120.53582, 37.98024], [-120.53522, 37.98032], [-120.53406, 37.98042], [-120.53228, 37.98072], [-120.53172, 37.98072], [-120.53124, 37.98081], [-120.53081, 37.98092], [-120.52994, 37.98127], [-120.52913, 37.98164], [-120.52871, 37.98191], [-120.52793, 37.98247], [-120.52768, 37.98267], [-120.52758, 37.98325], [-120.52762, 37.98344], [-120.52779, 37.98388], [-120.52818, 37.9843], [-120.52838, 37.98454], [-120.52865, 37.98481], [-120.52906, 37.98526], [-120.52975, 37.98592], [-120.53002, 37.98615], [-120.53047, 37.98678], [-120.53076, 37.98703], [-120.53141, 37.98768], [-120.53184, 37.98799], [-120.53211, 37.9881], [-120.53393, 37.98911], [-120.53433, 37.98939], [-120.53455, 37.98961], [-120.53494, 37.99016], [-120.53501, 37.99031], [-120.53504, 37.99058], [-120.535, 37.99084], [-120.53493, 37.991], [-120.5347, 37.99128], [-120.53428, 37.99163], [-120.53387, 37.99186], [-120.53356, 37.99197], [-120.53292, 37.99215], [-120.53264, 37.99221], [-120.53211, 37.99225], [-120.5316, 37.99223], [-120.53095, 37.99229], [-120.5306, 37.99234], [-120.53006, 37.99254], [-120.52927, 37.99274], [-120.52857, 37.99289], [-120.52824, 37.99293], [-120.52767, 37.99305], [-120.52692, 37.99327], [-120.52623, 37.99339], [-120.5257, 37.99355], [-120.52499, 37.99373], [-120.52449, 37.99387], [-120.52384, 37.9941], [-120.52289, 37.9945], [-120.52207, 37.99491], [-120.52148, 37.99528], [-120.52137, 37.99526], [-120.51888, 37.99503], [-120.5195, 37.99784], [-120.51645, 37.99784], [-120.51627, 37.99416], [-120.5147, 37.9942], [-120.50923, 37.99049], [-120.50669, 37.99054], [-120.50668, 37.99095], [-120.50584, 37.9909], [-120.50541, 37.99097], [-120.50509, 37.99101], [-120.50458, 37.99118], [-120.50421, 37.99143], [-120.50356, 37.99195], [-120.50315, 37.99245], [-120.50203, 37.99352], [-120.50207, 37.99054], [-120.48824, 37.99054], [-120.48806, 37.98426], [-120.48806, 37.98332], [-120.48804, 37.98332], [-120.48767, 37.98381], [-120.48587, 37.98303], [-120.48721, 37.98467], [-120.48541, 37.98546], [-120.48533, 37.98531], [-120.48388, 37.98286], [-120.48434, 37.98267], [-120.48467, 37.9828], [-120.48474, 37.98272], [-120.48512, 37.98272], [-120.48512, 37.98271], [-120.48485, 37.98257], [-120.48572, 37.98145], [-120.48807, 37.9825], [-120.48811, 37.97861], [-120.48811, 37.97595], [-120.50551, 37.97576], [-120.51601, 37.97581], [-120.51571, 37.97173], [-120.5229, 37.9717], [-120.52244, 37.97349], [-120.52308, 37.97487], [-120.52273, 37.97559], [-120.5231, 37.97559], [-120.52354, 37.97507], [-120.5242, 37.97436], [-120.52412, 37.97163], [-120.52497, 37.97161], [-120.52512, 37.97021], [-120.52512, 37.96842], [-120.52525, 37.96849], [-120.52546, 37.96863], [-120.52577, 37.96888], [-120.52608, 37.96911], [-120.52657, 37.96956], [-120.52685, 37.96979], [-120.52752, 37.97062], [-120.52774, 37.97098], [-120.52787, 37.97145], [-120.52796, 37.97184], [-120.52798, 37.97266], [-120.52787, 37.97336], [-120.52773, 37.97378], [-120.52757, 37.97436], [-120.52756, 37.97467], [-120.52762, 37.97509], [-120.52782, 37.97548], [-120.528, 37.97566], [-120.52822, 37.97581], [-120.52881, 37.97612], [-120.52904, 37.97618], [-120.52984, 37.97631], [-120.53067, 37.97631], [-120.53104, 37.97626], [-120.53173, 37.9761], [-120.53208, 37.97598], [-120.53252, 37.97587], [-120.53299, 37.97578], [-120.53367, 37.97556], [-120.53473, 37.97533], [-120.53536, 37.97517], [-120.53567, 37.97517], [-120.536, 37.9751], [-120.53628, 37.97499], [-120.53831, 37.97448], [-120.53899, 37.9744], [-120.53967, 37.97441], [-120.54061, 37.97434], [-120.54121, 37.97433], [-120.54145, 37.97435], [-120.54204, 37.97447], [-120.5424, 37.97465], [-120.54274, 37.97479], [-120.54303, 37.97507], [-120.54313, 37.97522], [-120.54317, 37.97533], [-120.54325, 37.9755], [-120.54332, 37.97576], [-120.54333, 37.97592], [-120.54314, 37.97657], [-120.54303, 37.97685], [-120.54288, 37.9771], [-120.54268, 37.97738], [-120.5423, 37.97779], [-120.54173, 37.97815], [-120.54133, 37.97838], [-120.54072, 37.97877], [-120.53994, 37.97914], [-120.53942, 37.97932], [-120.53915, 37.97939]]], [[[-120.51539, 37.99939], [-120.5139, 38.00053], [-120.51222, 37.99854], [-120.51202, 37.99723], [-120.51236, 37.99712], [-120.51254, 37.99709], [-120.51271, 37.99709], [-120.51292, 37.99711], [-120.51308, 37.9971], [-120.51319, 37.99711], [-120.51343, 37.99708], [-120.51371, 37.99698], [-120.51384, 37.99753], [-120.51539, 37.99939]]], [[[-120.48737, 38.00077], [-120.48609, 37.99921], [-120.48519, 37.99813], [-120.48622, 37.99833], [-120.48652, 37.99836], [-120.48659, 37.99844], [-120.48668, 37.99882], [-120.48647, 37.99898], [-120.4861, 37.99922], [-120.48736, 38.00046], [-120.48738, 38.00058], [-120.48737, 38.00077]]], [[[-120.51162, 37.99736], [-120.51166, 37.99805], [-120.51144, 38.00126], [-120.51067, 38.0015], [-120.51008, 38.00107], [-120.50979, 38.00078], [-120.50961, 38.00062], [-120.50931, 37.99962], [-120.50934, 37.99912], [-120.50942, 37.99891], [-120.50978, 37.99826], [-120.50986, 37.99809], [-120.51001, 37.99796], [-120.51049, 37.99774], [-120.5112, 37.99748], [-120.51162, 37.99736]]], [[[-120.49998, 38.00165], [-120.50004, 38.00235], [-120.50009, 38.00264], [-120.50013, 38.00339], [-120.50026, 38.00419], [-120.50032, 38.00493], [-120.50042, 38.00567], [-120.50053, 38.00669], [-120.50048, 38.007], [-120.50037, 38.00733], [-120.49988, 38.00787], [-120.49971, 38.00799], [-120.49956, 38.00806], [-120.49935, 38.00812], [-120.49913, 38.00822], [-120.49895, 38.00822], [-120.49874, 38.00818], [-120.49831, 38.00808], [-120.49804, 38.00804], [-120.49781, 38.00797], [-120.49758, 38.00794], [-120.49728, 38.00798], [-120.49693, 38.00807], [-120.49655, 38.0082], [-120.49478, 38.00941], [-120.49446, 38.00976], [-120.4939, 38.01032], [-120.49365, 38.01065], [-120.49339, 38.0109], [-120.49315, 38.01109], [-120.49294, 38.01113], [-120.49256, 38.01117], [-120.4923, 38.01118], [-120.49178, 38.01105], [-120.49148, 38.01095], [-120.49092, 38.01058], [-120.49062, 38.01031], [-120.4904, 38.01007], [-120.49019, 38.00977], [-120.48995, 38.00953], [-120.48954, 38.00921], [-120.48911, 38.00908], [-120.48898, 38.00909], [-120.48869, 38.00908], [-120.4882, 38.00901], [-120.48779, 38.00911], [-120.48781, 38.0087], [-120.4878, 38.00832], [-120.48791, 38.00752], [-120.48772, 38.00754], [-120.48636, 38.00776], [-120.4862, 38.00729], [-120.48592, 38.00635], [-120.48555, 38.00525], [-120.48437, 38.00535], [-120.48437, 38.00537], [-120.48457, 38.00552], [-120.48318, 38.00676], [-120.48207, 38.00586], [-120.48132, 38.0052], [-120.48299, 38.00437], [-120.48362, 38.00383], [-120.48361, 38.00354], [-120.48641, 38.00342], [-120.48642, 38.0034], [-120.48635, 38.00327], [-120.48686, 38.00325], [-120.48721, 38.00317], [-120.48743, 38.00308], [-120.48759, 38.00297], [-120.48769, 38.00286], [-120.48774, 38.00276], [-120.48778, 38.00262], [-120.48775, 38.00222], [-120.48782, 38.0022], [-120.48779, 38.00155], [-120.48773, 38.00089], [-120.4877, 38.0007], [-120.48769, 38.00041], [-120.48764, 38.00018], [-120.48745, 38.00007], [-120.48743, 37.99997], [-120.48736, 37.99986], [-120.48698, 37.99946], [-120.48689, 37.99926], [-120.48688, 37.99899], [-120.48691, 37.99891], [-120.48697, 37.99901], [-120.48709, 37.99912], [-120.48717, 37.99916], [-120.48728, 37.99925], [-120.48758, 37.99938], [-120.48779, 37.99945], [-120.4881, 37.99948], [-120.48812, 37.99939], [-120.48764, 37.99927], [-120.48747, 37.99921], [-120.48731, 37.99912], [-120.48712, 37.99898], [-120.48697, 37.99866], [-120.48703, 37.99859], [-120.48694, 37.99845], [-120.48731, 37.99844], [-120.48788, 37.99806], [-120.48815, 37.99832], [-120.4882, 37.99788], [-120.49738, 37.9979], [-120.49735, 38.00167], [-120.49987, 38.00166], [-120.49998, 38.00165]], [[-120.49257, 38.00877], [-120.49274, 38.00533], [-120.49154, 38.00529], [-120.49035, 38.00531], [-120.48998, 38.0053], [-120.48817, 38.00534], [-120.48766, 38.00537], [-120.48809, 38.00647], [-120.48796, 38.00727], [-120.49007, 38.00713], [-120.48999, 38.00926], [-120.49159, 38.00907], [-120.49242, 38.00905], [-120.49257, 38.00877]], [[-120.48365, 38.00415], [-120.48367, 38.00415], [-120.48386, 38.00399], [-120.48381, 38.00392], [-120.48363, 38.00397], [-120.48365, 38.00415]], [[-120.48822, 38.00248], [-120.4882, 38.00247], [-120.48808, 38.00249], [-120.48787, 38.00254], [-120.48821, 38.00284], [-120.48822, 38.00248]]], [[[-120.46016, 38.00582], [-120.46135, 38.00585], [-120.46251, 38.00585], [-120.46486, 38.00575], [-120.46985, 38.00561], [-120.47839, 38.00544], [-120.47844, 38.00881], [-120.47345, 38.00917], [-120.47359, 38.01114], [-120.47574, 38.01114], [-120.48075, 38.01097], [-120.4832, 38.01081], [-120.48329, 38.01222], [-120.48324, 38.01227], [-120.4828, 38.01241], [-120.48242, 38.01248], [-120.48179, 38.01241], [-120.47986, 38.012], [-120.4794, 38.01195], [-120.47901, 38.01182], [-120.47857, 38.01178], [-120.47813, 38.01172], [-120.47742, 38.01178], [-120.4767, 38.01198], [-120.47643, 38.01208], [-120.47605, 38.01213], [-120.47568, 38.01224], [-120.47541, 38.01228], [-120.47508, 38.01237], [-120.47443, 38.01242], [-120.47416, 38.01242], [-120.47348, 38.01231], [-120.47322, 38.01212], [-120.47299, 38.01202], [-120.47247, 38.01161], [-120.47223, 38.01139], [-120.47178, 38.01116], [-120.47139, 38.01092], [-120.47068, 38.01054], [-120.47003, 38.01024], [-120.46985, 38.0102], [-120.46982, 38.00931], [-120.46666, 38.00938], [-120.46666, 38.0094], [-120.46668, 38.00941], [-120.46651, 38.00942], [-120.46596, 38.00942], [-120.46529, 38.00957], [-120.46403, 38.00942], [-120.46026, 38.00946], [-120.46071, 38.01481], [-120.46874, 38.01479], [-120.46884, 38.01478], [-120.46907, 38.01507], [-120.46921, 38.01531], [-120.4695, 38.01611], [-120.46964, 38.01643], [-120.46967, 38.01656], [-120.46816, 38.01655], [-120.46844, 38.01823], [-120.46074, 38.01821], [-120.46012, 38.01996], [-120.46013, 38.02026], [-120.46731, 38.02036], [-120.46629, 38.02083], [-120.46603, 38.02093], [-120.4656, 38.02099], [-120.46534, 38.02106], [-120.46506, 38.02104], [-120.46476, 38.02116], [-120.46444, 38.02126], [-120.46411, 38.0213], [-120.46382, 38.02137], [-120.46325, 38.02155], [-120.46272, 38.02186], [-120.46254, 38.022], [-120.46232, 38.02224], [-120.46197, 38.02269], [-120.46171, 38.02328], [-120.46166, 38.02357], [-120.46165, 38.02371], [-120.46185, 38.02473], [-120.46183, 38.02602], [-120.46177, 38.02652], [-120.4615, 38.02726], [-120.46133, 38.02759], [-120.46099, 38.02809], [-120.46073, 38.02837], [-120.46034, 38.02887], [-120.46018, 38.02906], [-120.45933, 38.02995], [-120.45901, 38.03024], [-120.45846, 38.03079], [-120.45824, 38.03104], [-120.45806, 38.03127], [-120.45783, 38.03149], [-120.45761, 38.03181], [-120.45744, 38.0321], [-120.45716, 38.03265], [-120.45695, 38.03317], [-120.4567, 38.03389], [-120.45657, 38.03446], [-120.45632, 38.03525], [-120.45619, 38.03557], [-120.45603, 38.03585], [-120.45582, 38.0361], [-120.45553, 38.03663], [-120.45531, 38.03706], [-120.45499, 38.03755], [-120.45478, 38.03777], [-120.45454, 38.03795], [-120.45419, 38.03813], [-120.45374, 38.03854], [-120.45362, 38.0388], [-120.4536, 38.0391], [-120.45379, 38.03969], [-120.45395, 38.04029], [-120.45398, 38.04054], [-120.45398, 38.0408], [-120.45395, 38.04107], [-120.45395, 38.04135], [-120.45378, 38.04179], [-120.45365, 38.04195], [-120.45346, 38.04208], [-120.45323, 38.04222], [-120.45301, 38.04239], [-120.45271, 38.04255], [-120.45242, 38.04276], [-120.45204, 38.04312], [-120.45176, 38.04342], [-120.45141, 38.04393], [-120.45079, 38.04435], [-120.45073, 38.04325], [-120.45073, 38.04198], [-120.44149, 38.042], [-120.44151, 38.03473], [-120.45076, 38.03472], [-120.45065, 38.02738], [-120.45774, 38.02752], [-120.46017, 38.02753], [-120.46012, 38.02026], [-120.45536, 38.02024], [-120.45541, 38.01839], [-120.45422, 38.01835], [-120.45421, 38.01555], [-120.45547, 38.01554], [-120.45556, 38.01189], [-120.45439, 38.01186], [-120.45421, 38.00922], [-120.45096, 38.00926], [-120.45096, 38.00836], [-120.44756, 38.00822], [-120.44716, 38.00564], [-120.44824, 38.00555], [-120.4487, 38.00556], [-120.44964, 38.00554], [-120.45569, 38.00578], [-120.45817, 38.00583], [-120.46016, 38.00582]]], [[[-120.44323, 38.05285], [-120.44324, 38.05308], [-120.4433, 38.05388], [-120.44339, 38.05434], [-120.44351, 38.05471], [-120.44362, 38.0551], [-120.44369, 38.05543], [-120.4437, 38.05566], [-120.44365, 38.05601], [-120.44346, 38.05666], [-120.44336, 38.05693], [-120.44321, 38.05748], [-120.44304, 38.05804], [-120.44294, 38.05826], [-120.44277, 38.05848], [-120.4397, 38.05762], [-120.43851, 38.05585], [-120.43791, 38.05539], [-120.43707, 38.05471], [-120.43799, 38.05323], [-120.43899, 38.05402], [-120.44109, 38.05386], [-120.44094, 38.05443], [-120.4408, 38.05506], [-120.44081, 38.05507], [-120.44229, 38.05366], [-120.44323, 38.05285]]], [[[-120.39137, 38.07072], [-120.38909, 38.07071], [-120.38905, 38.06891], [-120.39131, 38.06884], [-120.39137, 38.07072]]], [[[-120.43203, 38.05658], [-120.4319, 38.06001], [-120.43173, 38.06007], [-120.43153, 38.06022], [-120.43134, 38.06044], [-120.43124, 38.06073], [-120.43115, 38.0612], [-120.43119, 38.06227], [-120.43117, 38.06264], [-120.43119, 38.0629], [-120.43119, 38.06319], [-120.43131, 38.0632], [-120.43137, 38.06476], [-120.43117, 38.06696], [-120.43085, 38.07019], [-120.43066, 38.07157], [-120.43087, 38.07175], [-120.43103, 38.07187], [-120.4312, 38.0721], [-120.43139, 38.07264], [-120.43138, 38.07282], [-120.43132, 38.07301], [-120.43114, 38.07323], [-120.43091, 38.07341], [-120.43063, 38.0735], [-120.43027, 38.07359], [-120.42973, 38.07361], [-120.42881, 38.07351], [-120.42813, 38.07334], [-120.42763, 38.07314], [-120.42683, 38.07277], [-120.42654, 38.07268], [-120.42637, 38.07265], [-120.42598, 38.07265], [-120.42548, 38.07273], [-120.42481, 38.07287], [-120.42442, 38.07313], [-120.42411, 38.07358], [-120.42403, 38.07373], [-120.42401, 38.07404], [-120.42411, 38.07434], [-120.42431, 38.07477], [-120.42442, 38.07505], [-120.42444, 38.07525], [-120.42443, 38.07551], [-120.42433, 38.07575], [-120.42405, 38.07616], [-120.42378, 38.07651], [-120.42349, 38.07679], [-120.42282, 38.07757], [-120.42258, 38.07777], [-120.41898, 38.07792], [-120.41922, 38.07608], [-120.42114, 38.07602], [-120.42158, 38.07423], [-120.41756, 38.07433], [-120.41725, 38.07612], [-120.41522, 38.07615], [-120.41438, 38.0762], [-120.41432, 38.07798], [-120.40994, 38.07814], [-120.40557, 38.07828], [-120.40555, 38.077], [-120.40849, 38.07621], [-120.40821, 38.07439], [-120.40537, 38.07526], [-120.40529, 38.07448], [-120.40221, 38.07449], [-120.40071, 38.07452], [-120.40049, 38.07072], [-120.40045, 38.06972], [-120.40397, 38.06968], [-120.40411, 38.07069], [-120.40503, 38.07068], [-120.40518, 38.07249], [-120.40964, 38.07255], [-120.40965, 38.0724], [-120.41404, 38.07256], [-120.41779, 38.07255], [-120.41795, 38.07148], [-120.41985, 38.07142], [-120.41994, 38.07049], [-120.4229, 38.07036], [-120.42433, 38.07034], [-120.42438, 38.07132], [-120.42503, 38.0712], [-120.42521, 38.07133], [-120.42584, 38.07144], [-120.42616, 38.07043], [-120.42823, 38.07039], [-120.42996, 38.06673], [-120.43011, 38.06621], [-120.42963, 38.06575], [-120.4289, 38.06568], [-120.42829, 38.06535], [-120.4281, 38.06516], [-120.42789, 38.06505], [-120.42729, 38.0649], [-120.42715, 38.06483], [-120.42792, 38.06481], [-120.42792, 38.06479], [-120.42787, 38.06475], [-120.42857, 38.06475], [-120.42934, 38.06466], [-120.42934, 38.06464], [-120.42872, 38.06418], [-120.42821, 38.06403], [-120.42796, 38.06381], [-120.42797, 38.06357], [-120.42816, 38.06334], [-120.42841, 38.06315], [-120.42843, 38.06312], [-120.42731, 38.06313], [-120.42697, 38.06316], [-120.42625, 38.06318], [-120.42623, 38.06241], [-120.4272, 38.06229], [-120.42732, 38.06038], [-120.42751, 38.05663], [-120.43203, 38.05658]]], [[[-120.39907, 38.0749], [-120.39636, 38.07827], [-120.39618, 38.07862], [-120.39389, 38.07865], [-120.3941, 38.07827], [-120.3941, 38.07826], [-120.39172, 38.0782], [-120.39154, 38.07447], [-120.39611, 38.07452], [-120.3957, 38.07636], [-120.39571, 38.07638], [-120.397, 38.07498], [-120.39697, 38.07393], [-120.39358, 38.07153], [-120.39613, 38.07142], [-120.39901, 38.07382], [-120.39907, 38.0749]]], [[[-120.41354, 38.08171], [-120.41282, 38.0848], [-120.41265, 38.08544], [-120.41245, 38.08559], [-120.41196, 38.0861], [-120.41115, 38.08689], [-120.41092, 38.08717], [-120.41068, 38.08776], [-120.41061, 38.08803], [-120.41051, 38.0854], [-120.41163, 38.08173], [-120.41354, 38.08171]]], [[[-120.37862, 38.13326], [-120.3784, 38.13421], [-120.3769, 38.13389], [-120.37238, 38.1335], [-120.37355, 38.13213], [-120.37677, 38.13217], [-120.37713, 38.1322], [-120.37838, 38.13259], [-120.37847, 38.133], [-120.37855, 38.13317], [-120.37862, 38.13326]]], [[[-120.37492, 38.14239], [-120.37144, 38.14222], [-120.37144, 38.1407], [-120.37162, 38.14088], [-120.37187, 38.14107], [-120.37244, 38.14132], [-120.37294, 38.14144], [-120.37323, 38.14155], [-120.37346, 38.14159], [-120.37381, 38.14162], [-120.37426, 38.14171], [-120.37478, 38.14214], [-120.37492, 38.14239]]]]}	Open Access 1	632	New Melones	13833	103	United States Bureau of Reclamation 369	Federal 1	Federal Agency 1	http://www.usbr.gov/	Other Federal 13	103	United States Bureau of Reclamation 364	Federal 1	Federal Agency 1	http://www.usbr.gov/mp/ccao/newmelones/index.html	Tuolumne 21	3895.472	New Melones	Resource Management Area 82	3
5603	5603	5602	{"type": "MultiPolygon", "coordinates": [[[[-120.48987, 37.96247], [-120.4882, 37.96438], [-120.48662, 37.96662], [-120.48362, 37.96486], [-120.48361, 37.96414], [-120.48418, 37.96339], [-120.48529, 37.96423], [-120.48419, 37.96219], [-120.48465, 37.96159], [-120.48542, 37.96072], [-120.48713, 37.95959], [-120.48807, 37.96078], [-120.48821, 37.96098], [-120.48822, 37.96133], [-120.4886, 37.96164], [-120.48981, 37.96242], [-120.48987, 37.96247]]], [[[-120.49255, 37.95779], [-120.48809, 37.95791], [-120.48368, 37.95791], [-120.48362, 37.9616], [-120.48349, 37.96162], [-120.48164, 37.96164], [-120.48136, 37.96166], [-120.48143, 37.95806], [-120.47448, 37.95815], [-120.47445, 37.95684], [-120.47112, 37.95527], [-120.47164, 37.95461], [-120.47335, 37.95455], [-120.47331, 37.95437], [-120.47331, 37.95302], [-120.4733, 37.95271], [-120.4745, 37.9527], [-120.47446, 37.94978], [-120.47441, 37.94801], [-120.47423, 37.9478], [-120.47422, 37.94759], [-120.47406, 37.94732], [-120.47384, 37.94732], [-120.47278, 37.94735], [-120.4711, 37.94741], [-120.46995, 37.9474], [-120.46988, 37.94819], [-120.46915, 37.94818], [-120.46789, 37.94825], [-120.46784, 37.94738], [-120.46723, 37.9473], [-120.46561, 37.9474], [-120.46557, 37.94731], [-120.46549, 37.94377], [-120.46261, 37.94388], [-120.46308, 37.94005], [-120.46306, 37.93682], [-120.46297, 37.93352], [-120.463, 37.93294], [-120.45609, 37.93292], [-120.45508, 37.93295], [-120.455, 37.93268], [-120.4548, 37.93117], [-120.45493, 37.92933], [-120.455, 37.92867], [-120.45608, 37.92863], [-120.45603, 37.92769], [-120.45709, 37.92763], [-120.46077, 37.92765], [-120.46106, 37.92763], [-120.46508, 37.92763], [-120.46519, 37.92937], [-120.47428, 37.92933], [-120.47438, 37.93289], [-120.47462, 37.93995], [-120.47619, 37.93995], [-120.47916, 37.93991], [-120.48363, 37.9399], [-120.48361, 37.93823], [-120.48033, 37.9364], [-120.48157, 37.9351], [-120.48359, 37.93618], [-120.48352, 37.93265], [-120.479, 37.9329], [-120.47875, 37.92929], [-120.47867, 37.92575], [-120.47862, 37.91788], [-120.48786, 37.91762], [-120.49252, 37.91737], [-120.49718, 37.91722], [-120.49719, 37.92089], [-120.50623, 37.92082], [-120.50624, 37.92081], [-120.5062, 37.91716], [-120.5108, 37.91715], [-120.5109, 37.92442], [-120.51309, 37.92441], [-120.51316, 37.9266], [-120.51325, 37.92804], [-120.51554, 37.92804], [-120.51558, 37.93168], [-120.52018, 37.93163], [-120.52016, 37.92667], [-120.52012, 37.925], [-120.5247, 37.92494], [-120.52635, 37.9249], [-120.52653, 37.92436], [-120.53385, 37.92431], [-120.53386, 37.92609], [-120.5382, 37.92613], [-120.53745, 37.92722], [-120.53726, 37.92759], [-120.53711, 37.92806], [-120.53706, 37.92854], [-120.53718, 37.92951], [-120.53728, 37.93001], [-120.53747, 37.93046], [-120.53759, 37.93066], [-120.53793, 37.93111], [-120.53843, 37.93184], [-120.53876, 37.93219], [-120.539, 37.93248], [-120.53951, 37.93317], [-120.53961, 37.93342], [-120.53966, 37.93374], [-120.53977, 37.93415], [-120.53987, 37.93491], [-120.53999, 37.93535], [-120.54001, 37.93598], [-120.53991, 37.93638], [-120.53968, 37.93695], [-120.53954, 37.93722], [-120.5386, 37.93824], [-120.53809, 37.93872], [-120.53782, 37.93901], [-120.53702, 37.93972], [-120.53674, 37.94006], [-120.53665, 37.94025], [-120.53666, 37.94039], [-120.53659, 37.94082], [-120.53661, 37.94098], [-120.53659, 37.94202], [-120.53643, 37.94259], [-120.53619, 37.9431], [-120.53539, 37.94427], [-120.53525, 37.94443], [-120.535, 37.94461], [-120.53479, 37.94473], [-120.53464, 37.9448], [-120.53372, 37.94511], [-120.53131, 37.94542], [-120.53092, 37.94553], [-120.53022, 37.94583], [-120.5299, 37.94601], [-120.5294, 37.94601], [-120.52974, 37.94577], [-120.52934, 37.94541], [-120.52931, 37.94496], [-120.52685, 37.945], [-120.52685, 37.94603], [-120.52724, 37.94604], [-120.5272, 37.94686], [-120.5258, 37.94744], [-120.5251, 37.94771], [-120.52506, 37.94849], [-120.52456, 37.94879], [-120.52419, 37.94903], [-120.52388, 37.94919], [-120.52326, 37.94942], [-120.52303, 37.94955], [-120.52254, 37.94975], [-120.52195, 37.95007], [-120.51987, 37.95073], [-120.51947, 37.95081], [-120.51862, 37.95115], [-120.51815, 37.95131], [-120.51777, 37.9515], [-120.51693, 37.95186], [-120.51659, 37.95205], [-120.51581, 37.95261], [-120.51551, 37.95287], [-120.51527, 37.95314], [-120.51459, 37.95414], [-120.51421, 37.95479], [-120.51405, 37.95507], [-120.51395, 37.95532], [-120.51386, 37.95564], [-120.51372, 37.9559], [-120.51345, 37.95671], [-120.51342, 37.95719], [-120.51346, 37.95738], [-120.51356, 37.95773], [-120.51372, 37.95846], [-120.514, 37.95907], [-120.51422, 37.95971], [-120.51433, 37.96011], [-120.51457, 37.96071], [-120.51483, 37.96164], [-120.51496, 37.96193], [-120.51539, 37.96274], [-120.51565, 37.96309], [-120.51583, 37.96342], [-120.51619, 37.96386], [-120.51639, 37.96408], [-120.51672, 37.96449], [-120.51714, 37.96485], [-120.51739, 37.96514], [-120.51765, 37.96534], [-120.5178, 37.96544], [-120.51831, 37.96563], [-120.51875, 37.96584], [-120.5201, 37.9664], [-120.5206, 37.96665], [-120.52161, 37.96701], [-120.52214, 37.96723], [-120.52263, 37.96737], [-120.52264, 37.96804], [-120.51106, 37.96816], [-120.5111, 37.97178], [-120.50188, 37.97196], [-120.5018, 37.96105], [-120.50182, 37.95752], [-120.50181, 37.9574], [-120.49737, 37.95745], [-120.49255, 37.95779]], [[-120.47448, 37.95454], [-120.47447, 37.95453], [-120.47381, 37.95456], [-120.47447, 37.95488], [-120.47448, 37.95487], [-120.47448, 37.95454]], [[-120.50187, 37.95011], [-120.50186, 37.9501], [-120.49838, 37.95019], [-120.49796, 37.95018], [-120.49728, 37.95022], [-120.49726, 37.95389], [-120.49768, 37.9539], [-120.50183, 37.95375], [-120.50187, 37.95011]], [[-120.52509, 37.94772], [-120.52518, 37.94606], [-120.52057, 37.94614], [-120.52057, 37.94786], [-120.52502, 37.94774], [-120.52509, 37.94772]]], [[[-120.48837, 37.9688], [-120.48819, 37.97237], [-120.48364, 37.97244], [-120.48363, 37.96971], [-120.48359, 37.96883], [-120.4814, 37.96892], [-120.48143, 37.96788], [-120.48146, 37.96749], [-120.48148, 37.96638], [-120.48144, 37.96541], [-120.48147, 37.96524], [-120.48361, 37.96526], [-120.4836, 37.96883], [-120.48837, 37.9688]]]]}	Open Access 1	635	New Melones	13833	103	United States Bureau of Reclamation 369	Federal 1	Federal Agency 1	http://www.usbr.gov/	Other Federal 13	103	United States Bureau of Reclamation 364	Federal 1	Federal Agency 1	http://www.usbr.gov/mp/ccao/newmelones/index.html	Tuolumne 21	5784.633	New Melones	Resource Management Area 82	3
6009	6009	6008	{"type": "MultiPolygon", "coordinates": [[[[-119.97265, 38.19975], [-119.97151, 38.20038], [-119.97128, 38.20049], [-119.97101, 38.20033], [-119.96999, 38.19966], [-119.97195, 38.19831], [-119.97261, 38.19962], [-119.97265, 38.19975]]], [[[-119.97067, 38.1968], [-119.97053, 38.19699], [-119.97043, 38.19716], [-119.97008, 38.19715], [-119.9701, 38.19687], [-119.97033, 38.19666], [-119.97067, 38.1968]]], [[[-119.97859, 38.19362], [-119.97835, 38.19384], [-119.97793, 38.19336], [-119.97819, 38.19316], [-119.97848, 38.19347], [-119.97859, 38.19362]]], [[[-119.98219, 38.19251], [-119.98193, 38.19258], [-119.98177, 38.19232], [-119.98208, 38.19229], [-119.98219, 38.19251]]], [[[-119.99129, 38.18838], [-119.99118, 38.18838], [-119.99077, 38.18833], [-119.99109, 38.18814], [-119.99129, 38.18838]]], [[[-119.99305, 38.19376], [-119.99224, 38.19413], [-119.99183, 38.1943], [-119.9908, 38.19375], [-119.99119, 38.19336], [-119.99142, 38.1935], [-119.99205, 38.19384], [-119.99252, 38.1938], [-119.99298, 38.19368], [-119.99305, 38.19376]]], [[[-119.99211, 38.19559], [-119.99185, 38.196], [-119.99146, 38.19556], [-119.99154, 38.19545], [-119.99182, 38.19528], [-119.99211, 38.19559]]], [[[-119.99377, 38.19211], [-119.99371, 38.19246], [-119.99368, 38.19301], [-119.9932, 38.19329], [-119.99291, 38.19273], [-119.99262, 38.19233], [-119.99212, 38.19191], [-119.99339, 38.19164], [-119.99377, 38.19211]]], [[[-119.99296, 38.18735], [-119.99283, 38.18746], [-119.99258, 38.18737], [-119.99278, 38.18716], [-119.99296, 38.18735]]], [[[-119.99449, 38.19314], [-119.99442, 38.19328], [-119.99354, 38.1936], [-119.9935, 38.19353], [-119.99372, 38.19343], [-119.99382, 38.19217], [-119.99438, 38.19239], [-119.99443, 38.19248], [-119.99443, 38.19256], [-119.99437, 38.19266], [-119.99435, 38.19282], [-119.99439, 38.19297], [-119.99449, 38.19314]]], [[[-119.99432, 38.19396], [-119.99399, 38.1941], [-119.99383, 38.19414], [-119.99354, 38.19368], [-119.99404, 38.19351], [-119.99432, 38.19396]]], [[[-120.00369, 38.19183], [-119.99976, 38.19184], [-120.00003, 38.19149], [-120.0002, 38.19133], [-120.00044, 38.1911], [-120.00063, 38.19096], [-120.00038, 38.19067], [-119.9998, 38.19113], [-119.99923, 38.19184], [-119.99908, 38.19184], [-119.9987, 38.19211], [-119.99844, 38.19238], [-119.99812, 38.19265], [-119.99795, 38.19277], [-119.99785, 38.19284], [-119.99676, 38.19329], [-119.99651, 38.19329], [-119.99546, 38.19316], [-119.99498, 38.19317], [-119.99478, 38.19315], [-119.99462, 38.19305], [-119.99453, 38.19293], [-119.99451, 38.19287], [-119.9945, 38.19272], [-119.99458, 38.19259], [-119.99471, 38.19249], [-119.99488, 38.19243], [-119.99504, 38.19242], [-119.99524, 38.1926], [-119.99561, 38.19247], [-119.9959, 38.19226], [-119.9959, 38.19225], [-119.99568, 38.19201], [-119.99594, 38.19186], [-119.99594, 38.19184], [-119.99428, 38.19189], [-119.99431, 38.19175], [-119.9943, 38.19174], [-119.99384, 38.19184], [-119.99358, 38.19148], [-119.99354, 38.19133], [-119.99401, 38.19118], [-119.9942, 38.19133], [-119.99422, 38.19133], [-119.99444, 38.18822], [-119.99489, 38.18829], [-119.99461, 38.18789], [-119.99489, 38.18779], [-119.995, 38.18803], [-119.99506, 38.18828], [-119.9952, 38.18821], [-119.99906, 38.1882], [-119.99905, 38.18989], [-119.99951, 38.18988], [-119.99928, 38.18999], [-119.99947, 38.19019], [-119.99966, 38.19022], [-119.9999, 38.19015], [-120.00023, 38.19016], [-120.00072, 38.18995], [-120.00207, 38.18999], [-120.00137, 38.19032], [-120.00066, 38.19053], [-120.00044, 38.19061], [-120.00064, 38.19095], [-120.00089, 38.19086], [-120.00155, 38.19065], [-120.00231, 38.19032], [-120.00276, 38.1901], [-120.0032, 38.18995], [-120.00368, 38.18991], [-120.00369, 38.19183]]], [[[-119.99405, 38.18735], [-119.99405, 38.18735], [-119.99362, 38.18721], [-119.99394, 38.18718], [-119.99401, 38.18725], [-119.99405, 38.18735]]], [[[-119.99908, 38.19356], [-119.99851, 38.19358], [-119.99798, 38.19356], [-119.99787, 38.19321], [-119.99795, 38.19287], [-119.99821, 38.19277], [-119.99831, 38.19301], [-119.99868, 38.1929], [-119.99886, 38.19276], [-119.99859, 38.19249], [-119.99874, 38.19233], [-119.999, 38.19262], [-119.99907, 38.19256], [-119.99908, 38.19356]]], [[[-120.00473, 38.18395], [-120.00422, 38.18422], [-120.00298, 38.18412], [-120.00185, 38.18419], [-120.00096, 38.1843], [-120.00044, 38.18406], [-120.00065, 38.18372], [-120.00166, 38.18357], [-120.00282, 38.18328], [-120.00372, 38.18327], [-120.00473, 38.18395]]], [[[-120.00292, 38.18727], [-120.0027, 38.1875], [-120.00201, 38.18725], [-120.00217, 38.18704], [-120.00292, 38.18727]]], [[[-120.00551, 38.19068], [-120.00404, 38.191], [-120.00404, 38.191], [-120.00406, 38.19069], [-120.0049, 38.19028], [-120.00537, 38.19015], [-120.00551, 38.19068]]], [[[-120.0071, 38.18991], [-120.00691, 38.19008], [-120.00657, 38.19032], [-120.0062, 38.18988], [-120.00559, 38.18985], [-120.00588, 38.18942], [-120.00618, 38.18942], [-120.00679, 38.18923], [-120.00709, 38.18929], [-120.0071, 38.18991]]]]}	Open Access 1	651	Lower Strawberry Lake	21567	107	United States Forest Service 38	Federal 1	Federal Agency 1	http://www.fs.fed.us/	US Forest Service 7	107	United States Forest Service 37	Federal 1	Federal Agency 1		Tuolumne 21	99.748	Lower Strawberry Lake	Resource Management Area 82	3

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