calands: units_with_maps: 2 rows where ACCESS_TYP = 1, DES_TP = 82 and PARK_URL = "http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/NewHoganLake.aspx"

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

2 rows where ACCESS_TYP = 1, DES_TP = 82 and PARK_URL = "http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/NewHoganLake.aspx"

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
3127	3127	3126	{"type": "MultiPolygon", "coordinates": [[[[-120.79331, 38.11217], [-120.78797, 38.11218], [-120.78808, 38.10856], [-120.79052, 38.10855], [-120.79059, 38.1086], [-120.79101, 38.10861], [-120.79331, 38.11217]]], [[[-120.81514, 38.17794], [-120.81468, 38.17795], [-120.81467, 38.17612], [-120.81492, 38.17601], [-120.81504, 38.17591], [-120.81511, 38.17577], [-120.81514, 38.17555], [-120.81514, 38.17794]]], [[[-120.82737, 38.14855], [-120.82696, 38.14866], [-120.82704, 38.1488], [-120.82522, 38.14883], [-120.82448, 38.14904], [-120.82445, 38.14935], [-120.82322, 38.15], [-120.82313, 38.14987], [-120.82112, 38.15085], [-120.82113, 38.1508], [-120.82111, 38.15079], [-120.8208, 38.15092], [-120.82027, 38.15106], [-120.8201, 38.15108], [-120.81915, 38.15102], [-120.81762, 38.15111], [-120.81741, 38.1512], [-120.81713, 38.15144], [-120.817, 38.15153], [-120.81688, 38.15156], [-120.8165, 38.1516], [-120.8163, 38.15168], [-120.81577, 38.15205], [-120.81568, 38.15213], [-120.81562, 38.15221], [-120.81557, 38.15235], [-120.81558, 38.15237], [-120.81652, 38.15237], [-120.81645, 38.15428], [-120.81673, 38.15462], [-120.81685, 38.15484], [-120.81694, 38.15509], [-120.81699, 38.15552], [-120.81774, 38.15553], [-120.81774, 38.15608], [-120.81709, 38.15608], [-120.81708, 38.15609], [-120.81716, 38.15621], [-120.81751, 38.15652], [-120.81765, 38.15673], [-120.81795, 38.15758], [-120.81796, 38.15779], [-120.81792, 38.15799], [-120.81782, 38.15819], [-120.8177, 38.15832], [-120.8175, 38.15847], [-120.81732, 38.15855], [-120.81712, 38.15861], [-120.81686, 38.15865], [-120.81665, 38.15864], [-120.81638, 38.15859], [-120.81638, 38.15962], [-120.81455, 38.15965], [-120.81451, 38.1598], [-120.81423, 38.15972], [-120.81395, 38.15999], [-120.81352, 38.15977], [-120.8135, 38.15977], [-120.81347, 38.16202], [-120.81424, 38.162], [-120.81404, 38.16227], [-120.81405, 38.16228], [-120.81445, 38.16197], [-120.81469, 38.16233], [-120.81491, 38.16287], [-120.81543, 38.16296], [-120.81516, 38.16326], [-120.8136, 38.16331], [-120.81382, 38.16365], [-120.81362, 38.16409], [-120.81333, 38.16379], [-120.81295, 38.16375], [-120.81293, 38.16448], [-120.81267, 38.16484], [-120.81357, 38.16483], [-120.81395, 38.16497], [-120.81304, 38.16545], [-120.81314, 38.16594], [-120.8136, 38.16609], [-120.8138, 38.16662], [-120.81316, 38.16671], [-120.81318, 38.16747], [-120.8119, 38.1665], [-120.8121, 38.16628], [-120.81093, 38.16488], [-120.81035, 38.16542], [-120.81094, 38.16569], [-120.81095, 38.16605], [-120.81148, 38.16648], [-120.81147, 38.16717], [-120.81238, 38.16751], [-120.81211, 38.16782], [-120.81243, 38.16839], [-120.81223, 38.16854], [-120.81265, 38.16899], [-120.81147, 38.17011], [-120.81201, 38.17051], [-120.81215, 38.17005], [-120.81278, 38.17043], [-120.81308, 38.1702], [-120.81345, 38.16945], [-120.81365, 38.16987], [-120.81381, 38.17025], [-120.81397, 38.17102], [-120.814, 38.17109], [-120.81477, 38.17219], [-120.815, 38.1725], [-120.81527, 38.17294], [-120.81449, 38.17313], [-120.81422, 38.17328], [-120.8139, 38.17274], [-120.81358, 38.17297], [-120.81401, 38.1742], [-120.81462, 38.1742], [-120.81421, 38.17514], [-120.81382, 38.17516], [-120.81336, 38.1748], [-120.81327, 38.17524], [-120.81242, 38.17538], [-120.812, 38.17504], [-120.81107, 38.17493], [-120.81033, 38.17617], [-120.81062, 38.17638], [-120.8091, 38.17702], [-120.80834, 38.17575], [-120.80816, 38.17542], [-120.80762, 38.17537], [-120.80785, 38.17495], [-120.80741, 38.17397], [-120.80767, 38.17356], [-120.80722, 38.17268], [-120.80731, 38.17217], [-120.80616, 38.17167], [-120.80624, 38.17435], [-120.80151, 38.17442], [-120.80155, 38.17813], [-120.79675, 38.17829], [-120.79446, 38.17832], [-120.79459, 38.1826], [-120.79449, 38.18246], [-120.79452, 38.18371], [-120.79236, 38.18369], [-120.79233, 38.18328], [-120.78986, 38.18331], [-120.78985, 38.18185], [-120.78767, 38.18185], [-120.78764, 38.17925], [-120.78758, 38.17832], [-120.78461, 38.17824], [-120.78127, 38.17813], [-120.77825, 38.17798], [-120.77825, 38.178], [-120.77831, 38.1781], [-120.77842, 38.17818], [-120.77874, 38.1784], [-120.77916, 38.17864], [-120.77919, 38.17873], [-120.77919, 38.17877], [-120.77914, 38.1788], [-120.77896, 38.17881], [-120.77886, 38.17879], [-120.77874, 38.17874], [-120.77854, 38.17871], [-120.77811, 38.17869], [-120.77789, 38.17872], [-120.77769, 38.17879], [-120.7777, 38.18033], [-120.77802, 38.18048], [-120.77818, 38.1806], [-120.7783, 38.18072], [-120.7784, 38.18091], [-120.77851, 38.18103], [-120.77869, 38.18115], [-120.77872, 38.1812], [-120.77871, 38.18122], [-120.77859, 38.18123], [-120.77847, 38.18122], [-120.77807, 38.18107], [-120.77791, 38.18103], [-120.7777, 38.18102], [-120.77766, 38.18259], [-120.77772, 38.18266], [-120.77805, 38.18317], [-120.77829, 38.18347], [-120.77837, 38.18354], [-120.77883, 38.18377], [-120.77887, 38.18381], [-120.77888, 38.18384], [-120.77884, 38.18388], [-120.77873, 38.18388], [-120.77815, 38.18378], [-120.77803, 38.18373], [-120.77771, 38.18355], [-120.77765, 38.18353], [-120.77764, 38.18435], [-120.77766, 38.1853], [-120.77328, 38.18529], [-120.77322, 38.18357], [-120.773, 38.1834], [-120.77161, 38.18321], [-120.77082, 38.18365], [-120.77083, 38.18398], [-120.77089, 38.18408], [-120.77098, 38.18419], [-120.771, 38.18424], [-120.771, 38.1843], [-120.77093, 38.18446], [-120.7709, 38.18459], [-120.77093, 38.18495], [-120.77092, 38.1851], [-120.77085, 38.18529], [-120.77087, 38.18575], [-120.77093, 38.186], [-120.77112, 38.18623], [-120.77116, 38.18631], [-120.77118, 38.18638], [-120.77115, 38.18659], [-120.77116, 38.18669], [-120.77132, 38.1872], [-120.77128, 38.18743], [-120.77127, 38.18763], [-120.77129, 38.18817], [-120.77136, 38.18847], [-120.77136, 38.18861], [-120.77121, 38.18874], [-120.77135, 38.18923], [-120.77154, 38.18941], [-120.77152, 38.18947], [-120.77144, 38.18956], [-120.77148, 38.18972], [-120.7711, 38.19005], [-120.77103, 38.19016], [-120.77092, 38.19027], [-120.77135, 38.19072], [-120.77146, 38.19175], [-120.76931, 38.19176], [-120.76888, 38.18529], [-120.76817, 38.18529], [-120.76811, 38.18493], [-120.76756, 38.18457], [-120.76468, 38.18462], [-120.76481, 38.18367], [-120.76491, 38.18316], [-120.76411, 38.18351], [-120.76323, 38.18314], [-120.76247, 38.18308], [-120.76155, 38.1823], [-120.76114, 38.18194], [-120.76051, 38.18165], [-120.75991, 38.1816], [-120.75988, 38.18132], [-120.75821, 38.1811], [-120.75775, 38.18112], [-120.7573, 38.18121], [-120.75707, 38.18121], [-120.75681, 38.18128], [-120.75638, 38.18144], [-120.75617, 38.18154], [-120.75599, 38.18166], [-120.75583, 38.18178], [-120.75569, 38.18192], [-120.75563, 38.18202], [-120.75559, 38.18218], [-120.75564, 38.18257], [-120.75562, 38.18266], [-120.75552, 38.18289], [-120.75547, 38.18307], [-120.75544, 38.18327], [-120.75542, 38.18354], [-120.75537, 38.18405], [-120.75536, 38.1844], [-120.75537, 38.1845], [-120.75558, 38.18481], [-120.75563, 38.18508], [-120.75568, 38.18519], [-120.75581, 38.18518], [-120.75658, 38.18647], [-120.75833, 38.18819], [-120.75908, 38.18851], [-120.75912, 38.18923], [-120.75919, 38.18935], [-120.75918, 38.18958], [-120.7592, 38.18984], [-120.75918, 38.18993], [-120.75912, 38.19007], [-120.75914, 38.19016], [-120.75921, 38.19021], [-120.75924, 38.19026], [-120.75924, 38.1903], [-120.75922, 38.19034], [-120.75913, 38.19037], [-120.75887, 38.19042], [-120.7586, 38.19055], [-120.75842, 38.19054], [-120.75804, 38.1911], [-120.75812, 38.19146], [-120.75829, 38.19169], [-120.7583, 38.19173], [-120.7583, 38.19178], [-120.75827, 38.1918], [-120.7582, 38.19181], [-120.75826, 38.19208], [-120.75765, 38.19226], [-120.75765, 38.19228], [-120.75787, 38.19259], [-120.75788, 38.19311], [-120.75557, 38.19315], [-120.7555, 38.19522], [-120.75612, 38.19616], [-120.76023, 38.19613], [-120.76004, 38.20025], [-120.7564, 38.20028], [-120.75504, 38.20093], [-120.75297, 38.20196], [-120.75052, 38.20412], [-120.74968, 38.20413], [-120.74966, 38.20221], [-120.75055, 38.2022], [-120.75056, 38.20148], [-120.74965, 38.20148], [-120.74969, 38.20104], [-120.75059, 38.20101], [-120.7507, 38.19621], [-120.74594, 38.19624], [-120.74587, 38.2014], [-120.74588, 38.20141], [-120.74644, 38.20141], [-120.74638, 38.20296], [-120.74552, 38.20297], [-120.74553, 38.20234], [-120.74283, 38.2024], [-120.7428, 38.20182], [-120.74144, 38.20186], [-120.74117, 38.20152], [-120.74113, 38.20019], [-120.74065, 38.20018], [-120.74062, 38.19982], [-120.73963, 38.19981], [-120.739, 38.19937], [-120.73854, 38.19913], [-120.73795, 38.19891], [-120.73749, 38.19878], [-120.73626, 38.19848], [-120.7358, 38.19843], [-120.7353, 38.19844], [-120.73484, 38.19851], [-120.73443, 38.1986], [-120.73355, 38.19894], [-120.7332, 38.19905], [-120.73296, 38.19909], [-120.73271, 38.19907], [-120.73238, 38.19902], [-120.7321, 38.19893], [-120.73186, 38.19876], [-120.73169, 38.19856], [-120.73121, 38.19752], [-120.73097, 38.19726], [-120.73063, 38.19699], [-120.73034, 38.1968], [-120.7299, 38.19667], [-120.72922, 38.19658], [-120.72876, 38.19666], [-120.7285, 38.19672], [-120.72807, 38.19686], [-120.72775, 38.19702], [-120.72726, 38.19738], [-120.72696, 38.19752], [-120.72678, 38.19758], [-120.72651, 38.1976], [-120.72624, 38.19759], [-120.72573, 38.19748], [-120.72534, 38.19734], [-120.7245, 38.19698], [-120.72407, 38.19678], [-120.72372, 38.19668], [-120.72335, 38.19663], [-120.72281, 38.19668], [-120.72281, 38.19588], [-120.72286, 38.19428], [-120.72381, 38.19431], [-120.72747, 38.19438], [-120.72743, 38.19615], [-120.72744, 38.19616], [-120.72761, 38.19616], [-120.73031, 38.19545], [-120.73166, 38.19578], [-120.73233, 38.19619], [-120.73557, 38.19619], [-120.73616, 38.19569], [-120.73642, 38.19481], [-120.73649, 38.19464], [-120.73755, 38.19486], [-120.73829, 38.19451], [-120.73835, 38.19447], [-120.73852, 38.19415], [-120.73941, 38.19378], [-120.73942, 38.19377], [-120.73863, 38.19275], [-120.73867, 38.19248], [-120.7379, 38.19222], [-120.73765, 38.19169], [-120.73711, 38.19173], [-120.73646, 38.19148], [-120.73678, 38.19127], [-120.7369, 38.19088], [-120.73658, 38.19056], [-120.73612, 38.18985], [-120.73624, 38.1889], [-120.73598, 38.18817], [-120.73714, 38.18914], [-120.73776, 38.18953], [-120.73863, 38.19], [-120.73919, 38.18942], [-120.73968, 38.19041], [-120.74072, 38.19073], [-120.74115, 38.19073], [-120.74248, 38.19106], [-120.74302, 38.19117], [-120.74428, 38.19151], [-120.74569, 38.19168], [-120.74678, 38.19112], [-120.7473, 38.19027], [-120.74833, 38.19067], [-120.74833, 38.19027], [-120.74875, 38.18996], [-120.74877, 38.18972], [-120.74874, 38.18961], [-120.74875, 38.18943], [-120.74881, 38.18926], [-120.74886, 38.18866], [-120.74782, 38.18795], [-120.74747, 38.18618], [-120.7465, 38.18539], [-120.74608, 38.18495], [-120.74545, 38.18505], [-120.74558, 38.18463], [-120.74517, 38.18439], [-120.74562, 38.18392], [-120.74542, 38.18358], [-120.74544, 38.18327], [-120.74595, 38.18318], [-120.74596, 38.18317], [-120.74556, 38.18229], [-120.74493, 38.18191], [-120.74552, 38.18142], [-120.74621, 38.18172], [-120.74666, 38.18168], [-120.74806, 38.18291], [-120.74926, 38.18241], [-120.74944, 38.18183], [-120.74821, 38.18017], [-120.74821, 38.17971], [-120.74697, 38.17911], [-120.74612, 38.17917], [-120.74549, 38.17854], [-120.74514, 38.17816], [-120.74449, 38.1783], [-120.74416, 38.17813], [-120.74388, 38.17778], [-120.74345, 38.17784], [-120.74242, 38.17723], [-120.74254, 38.17685], [-120.74198, 38.17621], [-120.74198, 38.17536], [-120.74165, 38.17427], [-120.7421, 38.17402], [-120.74212, 38.17446], [-120.74275, 38.17529], [-120.74318, 38.17661], [-120.74378, 38.17691], [-120.7443, 38.17694], [-120.74619, 38.17661], [-120.7467, 38.17596], [-120.7471, 38.17511], [-120.74754, 38.17514], [-120.74778, 38.17554], [-120.74867, 38.17557], [-120.75077, 38.17669], [-120.75245, 38.17803], [-120.75277, 38.17827], [-120.75403, 38.17936], [-120.75503, 38.17943], [-120.75512, 38.17801], [-120.75899, 38.17798], [-120.75904, 38.17786], [-120.75909, 38.17782], [-120.75916, 38.17781], [-120.7593, 38.17784], [-120.75952, 38.17797], [-120.76527, 38.178], [-120.76542, 38.17782], [-120.7656, 38.17745], [-120.76541, 38.17434], [-120.76616, 38.17433], [-120.76601, 38.17244], [-120.76649, 38.17242], [-120.76635, 38.17061], [-120.76688, 38.1706], [-120.76686, 38.16911], [-120.7686, 38.16905], [-120.76857, 38.17055], [-120.76893, 38.17061], [-120.76906, 38.17235], [-120.7698, 38.173], [-120.77037, 38.17289], [-120.77086, 38.17284], [-120.77128, 38.17275], [-120.77182, 38.17268], [-120.77235, 38.17265], [-120.77281, 38.1727], [-120.77296, 38.17274], [-120.77325, 38.17277], [-120.7734, 38.17279], [-120.7736, 38.17285], [-120.77433, 38.17283], [-120.77428, 38.17225], [-120.77318, 38.17152], [-120.77251, 38.17158], [-120.77235, 38.17108], [-120.77342, 38.17064], [-120.77405, 38.16986], [-120.77402, 38.16865], [-120.77424, 38.16862], [-120.77429, 38.16762], [-120.77714, 38.16746], [-120.77718, 38.16572], [-120.77792, 38.16568], [-120.77792, 38.16609], [-120.77946, 38.1667], [-120.78009, 38.16651], [-120.78186, 38.16629], [-120.78188, 38.16553], [-120.78126, 38.16476], [-120.78146, 38.16412], [-120.78266, 38.16382], [-120.78131, 38.16169], [-120.78103, 38.16146], [-120.77989, 38.16203], [-120.77905, 38.16287], [-120.77798, 38.16292], [-120.77797, 38.16321], [-120.7754, 38.16326], [-120.77539, 38.16195], [-120.77798, 38.16199], [-120.77798, 38.16191], [-120.7787, 38.16102], [-120.77959, 38.15913], [-120.77947, 38.15868], [-120.78063, 38.15736], [-120.78037, 38.15596], [-120.78066, 38.15478], [-120.78032, 38.15438], [-120.78068, 38.15426], [-120.78047, 38.15302], [-120.77998, 38.15256], [-120.78023, 38.15235], [-120.78048, 38.15185], [-120.78004, 38.15106], [-120.78018, 38.15081], [-120.78095, 38.15116], [-120.78151, 38.15237], [-120.78511, 38.1523], [-120.78512, 38.15121], [-120.78484, 38.15082], [-120.78446, 38.1496], [-120.78476, 38.14923], [-120.78436, 38.14882], [-120.78383, 38.14882], [-120.78382, 38.14858], [-120.78293, 38.14858], [-120.78295, 38.14705], [-120.78817, 38.14709], [-120.78818, 38.14708], [-120.78528, 38.14515], [-120.78486, 38.14475], [-120.78451, 38.14431], [-120.78441, 38.14404], [-120.78433, 38.14377], [-120.78144, 38.13545], [-120.78037, 38.13384], [-120.77958, 38.13363], [-120.77956, 38.13206], [-120.78205, 38.13198], [-120.78201, 38.13334], [-120.78332, 38.13354], [-120.78345, 38.13353], [-120.78377, 38.13339], [-120.7842, 38.13316], [-120.78496, 38.13262], [-120.78554, 38.132], [-120.78578, 38.13166], [-120.78588, 38.13149], [-120.78607, 38.13107], [-120.78615, 38.13085], [-120.78626, 38.13013], [-120.78623, 38.1299], [-120.78612, 38.12953], [-120.78311, 38.12306], [-120.78513, 38.12295], [-120.78578, 38.12265], [-120.78535, 38.12109], [-120.78524, 38.12104], [-120.78506, 38.121], [-120.78488, 38.12098], [-120.7846, 38.12104], [-120.78249, 38.12081], [-120.78232, 38.12043], [-120.7831, 38.12059], [-120.78388, 38.12023], [-120.78411, 38.11983], [-120.78374, 38.11941], [-120.7834, 38.11886], [-120.78318, 38.11853], [-120.78278, 38.11837], [-120.7828, 38.11778], [-120.7816, 38.11741], [-120.78032, 38.1173], [-120.78071, 38.1172], [-120.78147, 38.11704], [-120.78212, 38.11655], [-120.7818, 38.11587], [-120.78176, 38.11581], [-120.78157, 38.11516], [-120.78037, 38.11417], [-120.78018, 38.1138], [-120.77875, 38.11401], [-120.7795, 38.11344], [-120.77943, 38.11309], [-120.77931, 38.11294], [-120.77883, 38.11254], [-120.7788, 38.11253], [-120.77779, 38.11237], [-120.7772, 38.11255], [-120.77781, 38.11186], [-120.7778, 38.11159], [-120.7777, 38.11128], [-120.77762, 38.11097], [-120.77664, 38.10992], [-120.77628, 38.10857], [-120.77631, 38.10798], [-120.77669, 38.10852], [-120.77687, 38.1096], [-120.77881, 38.11097], [-120.7792, 38.1114], [-120.78028, 38.11171], [-120.78118, 38.11341], [-120.78165, 38.11351], [-120.78146, 38.11418], [-120.78215, 38.11483], [-120.78252, 38.1146], [-120.783, 38.11523], [-120.78315, 38.11584], [-120.78467, 38.11555], [-120.78497, 38.11567], [-120.78522, 38.11567], [-120.78535, 38.1157], [-120.78544, 38.11575], [-120.78554, 38.11583], [-120.78566, 38.11598], [-120.78585, 38.11631], [-120.78597, 38.11636], [-120.78616, 38.11622], [-120.78636, 38.116], [-120.78647, 38.11651], [-120.78667, 38.11652], [-120.78672, 38.11655], [-120.78672, 38.11689], [-120.7867, 38.11691], [-120.78668, 38.11691], [-120.78655, 38.1169], [-120.78659, 38.11714], [-120.78623, 38.11716], [-120.7853, 38.11823], [-120.78558, 38.11847], [-120.78575, 38.11893], [-120.78577, 38.11893], [-120.78603, 38.1185], [-120.7863, 38.11873], [-120.78697, 38.11867], [-120.78719, 38.11939], [-120.78835, 38.12018], [-120.78848, 38.12075], [-120.78898, 38.12088], [-120.78907, 38.12085], [-120.78917, 38.12083], [-120.78928, 38.12083], [-120.78938, 38.12085], [-120.78942, 38.12081], [-120.78957, 38.11998], [-120.78978, 38.12069], [-120.79012, 38.12116], [-120.79057, 38.12104], [-120.79033, 38.12211], [-120.78979, 38.1219], [-120.78941, 38.12212], [-120.78969, 38.12292], [-120.78998, 38.12306], [-120.79052, 38.12294], [-120.79054, 38.12295], [-120.79051, 38.12304], [-120.79048, 38.12307], [-120.79048, 38.12309], [-120.79097, 38.12299], [-120.79122, 38.12261], [-120.79153, 38.12307], [-120.79102, 38.12357], [-120.79117, 38.12394], [-120.79217, 38.12399], [-120.79168, 38.12454], [-120.79261, 38.12569], [-120.79301, 38.12573], [-120.79337, 38.12549], [-120.79341, 38.12534], [-120.79348, 38.12526], [-120.79362, 38.12523], [-120.79342, 38.12487], [-120.79307, 38.12459], [-120.79303, 38.12454], [-120.79354, 38.12457], [-120.79399, 38.12431], [-120.79374, 38.12383], [-120.79427, 38.12402], [-120.79468, 38.12473], [-120.79413, 38.12506], [-120.79427, 38.12529], [-120.79503, 38.12543], [-120.7962, 38.12547], [-120.79575, 38.12582], [-120.79486, 38.12624], [-120.79486, 38.12626], [-120.7951, 38.1263], [-120.79565, 38.12696], [-120.796, 38.12719], [-120.79608, 38.12782], [-120.79508, 38.12797], [-120.79507, 38.12798], [-120.79517, 38.12835], [-120.7958, 38.12835], [-120.79596, 38.12879], [-120.79697, 38.12881], [-120.797, 38.12838], [-120.79694, 38.12837], [-120.79687, 38.12829], [-120.79688, 38.12822], [-120.79694, 38.12814], [-120.79695, 38.12806], [-120.79692, 38.12799], [-120.79681, 38.12785], [-120.79639, 38.12769], [-120.79639, 38.12765], [-120.79644, 38.12763], [-120.7968, 38.1276], [-120.79684, 38.12735], [-120.7961, 38.12675], [-120.79646, 38.12622], [-120.79698, 38.12675], [-120.79786, 38.12639], [-120.79785, 38.1258], [-120.79851, 38.1251], [-120.79859, 38.12471], [-120.79786, 38.12456], [-120.79741, 38.1241], [-120.79731, 38.12379], [-120.79626, 38.12327], [-120.79527, 38.12329], [-120.79689, 38.12226], [-120.79676, 38.12219], [-120.79636, 38.1221], [-120.79615, 38.12207], [-120.7961, 38.12205], [-120.79609, 38.12202], [-120.79707, 38.12158], [-120.79736, 38.12154], [-120.79732, 38.1213], [-120.79722, 38.12111], [-120.79712, 38.12098], [-120.79575, 38.12076], [-120.79614, 38.12038], [-120.79546, 38.12031], [-120.79543, 38.12029], [-120.79543, 38.12026], [-120.79547, 38.12024], [-120.7958, 38.12015], [-120.79642, 38.12012], [-120.79714, 38.11943], [-120.79713, 38.11942], [-120.79628, 38.11941], [-120.79688, 38.11829], [-120.79541, 38.11739], [-120.79541, 38.11718], [-120.79531, 38.11675], [-120.79482, 38.11629], [-120.79382, 38.11672], [-120.79357, 38.11639], [-120.79474, 38.11593], [-120.79474, 38.1159], [-120.79479, 38.1159], [-120.79572, 38.1152], [-120.79564, 38.11497], [-120.79548, 38.11479], [-120.79541, 38.11466], [-120.7954, 38.11459], [-120.79542, 38.1141], [-120.79547, 38.11386], [-120.7956, 38.11362], [-120.79571, 38.11348], [-120.79576, 38.11343], [-120.79581, 38.11342], [-120.7959, 38.11343], [-120.79601, 38.11349], [-120.79595, 38.1134], [-120.79638, 38.11276], [-120.79555, 38.11233], [-120.79576, 38.11233], [-120.79577, 38.11231], [-120.79573, 38.11225], [-120.79553, 38.11221], [-120.79544, 38.11214], [-120.79532, 38.11209], [-120.79505, 38.112], [-120.79479, 38.11202], [-120.7948, 38.11183], [-120.79473, 38.11176], [-120.79467, 38.11173], [-120.79434, 38.11167], [-120.79423, 38.11162], [-120.7941, 38.11151], [-120.79397, 38.11137], [-120.79385, 38.11094], [-120.79386, 38.11088], [-120.79389, 38.11083], [-120.79402, 38.11074], [-120.79432, 38.11062], [-120.79463, 38.11057], [-120.79339, 38.10865], [-120.79378, 38.10865], [-120.79378, 38.10863], [-120.78988, 38.10589], [-120.78815, 38.10586], [-120.78818, 38.10493], [-120.79784, 38.10489], [-120.79792, 38.11215], [-120.80474, 38.1122], [-120.80472, 38.11948], [-120.8028, 38.11946], [-120.80278, 38.11623], [-120.80277, 38.11622], [-120.80247, 38.11633], [-120.80219, 38.1165], [-120.80213, 38.11673], [-120.80224, 38.11698], [-120.80211, 38.11719], [-120.80178, 38.11735], [-120.8014, 38.11755], [-120.80103, 38.11778], [-120.80091, 38.11808], [-120.8012, 38.11824], [-120.80112, 38.11842], [-120.80174, 38.1186], [-120.80163, 38.11897], [-120.80139, 38.11901], [-120.80121, 38.11916], [-120.8011, 38.11928], [-120.8009, 38.11987], [-120.80091, 38.11988], [-120.80151, 38.1199], [-120.79997, 38.12058], [-120.80017, 38.12082], [-120.80071, 38.12092], [-120.80117, 38.12097], [-120.80162, 38.12083], [-120.80167, 38.12083], [-120.80166, 38.1209], [-120.80161, 38.12095], [-120.80162, 38.12097], [-120.80262, 38.121], [-120.80258, 38.12138], [-120.80335, 38.12139], [-120.80331, 38.12182], [-120.80331, 38.1224], [-120.8014, 38.12236], [-120.80142, 38.12181], [-120.80141, 38.1218], [-120.80095, 38.12194], [-120.7999, 38.1231], [-120.80175, 38.1246], [-120.80181, 38.12515], [-120.80211, 38.12537], [-120.80215, 38.12504], [-120.80402, 38.12509], [-120.80395, 38.12493], [-120.80388, 38.12481], [-120.80377, 38.12459], [-120.80373, 38.12442], [-120.80372, 38.12436], [-120.80375, 38.12425], [-120.8039, 38.12404], [-120.80399, 38.12386], [-120.80403, 38.12375], [-120.80406, 38.12358], [-120.80404, 38.12349], [-120.80394, 38.12327], [-120.80364, 38.12267], [-120.80359, 38.1224], [-120.80365, 38.12212], [-120.80376, 38.12183], [-120.80485, 38.12049], [-120.80517, 38.12063], [-120.80492, 38.12105], [-120.80475, 38.12127], [-120.80441, 38.1216], [-120.80407, 38.12187], [-120.80404, 38.12193], [-120.80391, 38.12232], [-120.80391, 38.1225], [-120.80398, 38.12272], [-120.80415, 38.12304], [-120.80437, 38.1235], [-120.80436, 38.12367], [-120.80434, 38.12372], [-120.80428, 38.12387], [-120.80412, 38.12412], [-120.80406, 38.12424], [-120.80404, 38.12437], [-120.80405, 38.12449], [-120.80411, 38.12461], [-120.80425, 38.1248], [-120.80442, 38.1251], [-120.80682, 38.12508], [-120.80678, 38.12529], [-120.8071, 38.12528], [-120.80698, 38.12683], [-120.8092, 38.12687], [-120.81098, 38.12685], [-120.81127, 38.1249], [-120.81141, 38.12305], [-120.81155, 38.12201], [-120.81162, 38.12119], [-120.81162, 38.12092], [-120.81441, 38.12097], [-120.81394, 38.12682], [-120.81357, 38.12916], [-120.8119, 38.12911], [-120.80735, 38.12912], [-120.80726, 38.13043], [-120.80599, 38.13043], [-120.80567, 38.13362], [-120.8071, 38.13351], [-120.80713, 38.13384], [-120.80847, 38.13346], [-120.8079, 38.13408], [-120.8079, 38.1341], [-120.80806, 38.13404], [-120.80868, 38.13363], [-120.80902, 38.1349], [-120.80862, 38.1351], [-120.80817, 38.13479], [-120.80813, 38.13483], [-120.80862, 38.13774], [-120.81226, 38.13784], [-120.81683, 38.1377], [-120.81673, 38.14125], [-120.82634, 38.14154], [-120.82612, 38.1479], [-120.82668, 38.14836], [-120.82683, 38.14833], [-120.82691, 38.14843], [-120.82727, 38.14836], [-120.82737, 38.14855]], [[-120.80143, 38.12111], [-120.80143, 38.12113], [-120.80161, 38.12115], [-120.80161, 38.12098], [-120.80143, 38.12111]], [[-120.80015, 38.11529], [-120.80014, 38.11521], [-120.80005, 38.11511], [-120.7999, 38.11515], [-120.79988, 38.11541], [-120.80021, 38.11539], [-120.80021, 38.11537], [-120.80015, 38.11529]], [[-120.79537, 38.11173], [-120.79538, 38.11172], [-120.79476, 38.11077], [-120.79458, 38.11081], [-120.79445, 38.11087], [-120.79433, 38.11094], [-120.79424, 38.11104], [-120.79423, 38.11114], [-120.79426, 38.11121], [-120.79432, 38.11128], [-120.79445, 38.11136], [-120.79502, 38.11158], [-120.79537, 38.11173]]]]}	Open Access 1	25778	New Hogan Lake	13827	100	United States Army Corps of Engineers 146	Federal 1	Federal Agency 1	http://www.usace.army.mil/	Other Federal 13	100	United States Army Corps of Engineers 142	Federal 1	Federal Agency 1	http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/NewHoganLake.aspx	Calaveras 53	6225.203	New Hogan Lake	0	Resource Management Area 82	3
4073	4073	4072	{"type": "MultiPolygon", "coordinates": [[[[-120.7228, 38.19705], [-120.72278, 38.19976], [-120.72012, 38.19972], [-120.72078, 38.19943], [-120.72093, 38.19966], [-120.72272, 38.19967], [-120.72171, 38.19821], [-120.72233, 38.19741], [-120.72259, 38.19716], [-120.7228, 38.19705]]], [[[-120.72281, 38.19613], [-120.7228, 38.19668], [-120.72254, 38.19675], [-120.7222, 38.19697], [-120.72174, 38.19745], [-120.72141, 38.19782], [-120.72072, 38.19676], [-120.72023, 38.19607], [-120.72281, 38.19613]]]]}	Open Access 1	44450	New Hogan Lake	13827	103	United States Bureau of Reclamation 369	Federal 1	Federal Agency 1	http://www.usbr.gov/	Other Federal 13	100	United States Army Corps of Engineers 142	Federal 1	Federal Agency 1	http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/NewHoganLake.aspx	Calaveras 53	10.237	New Hogan Lake	0	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]);