calands: units_with_maps: 1 row where ACCESS_TYP = 1, LABEL_NAME = "Lake Sonoma Rec. Area" and MNG

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

1 row where ACCESS_TYP = 1, LABEL_NAME = "Lake Sonoma Rec. Area" and MNG_AGENCY = 142

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
2418	2418	2417	{"type": "Polygon", "coordinates": [[[-123.14758, 38.78351], [-123.14572, 38.78313], [-123.14494, 38.78278], [-123.14423, 38.78267], [-123.1434, 38.78252], [-123.14296, 38.7821], [-123.14227, 38.78202], [-123.14157, 38.78212], [-123.14068, 38.78192], [-123.13977, 38.78189], [-123.13914, 38.78227], [-123.13831, 38.78164], [-123.13762, 38.78149], [-123.13726, 38.78066], [-123.13657, 38.78011], [-123.13557, 38.7799], [-123.13489, 38.77997], [-123.13405, 38.77969], [-123.13298, 38.77995], [-123.13213, 38.78042], [-123.13122, 38.78068], [-123.12988, 38.78045], [-123.12905, 38.7805], [-123.12837, 38.78075], [-123.12809, 38.78158], [-123.12736, 38.78174], [-123.12644, 38.78137], [-123.12612, 38.78145], [-123.12587, 38.78154], [-123.12533, 38.78145], [-123.12472, 38.78126], [-123.12412, 38.78125], [-123.1236, 38.78112], [-123.12317, 38.7812], [-123.12263, 38.78113], [-123.1215, 38.78145], [-123.12087, 38.78121], [-123.12014, 38.78114], [-123.11972, 38.78119], [-123.11937, 38.78137], [-123.11741, 38.78139], [-123.1172, 38.7815], [-123.11713, 38.78147], [-123.11672, 38.78116], [-123.11633, 38.78109], [-123.11606, 38.78109], [-123.11594, 38.78119], [-123.11554, 38.78121], [-123.11527, 38.78132], [-123.1151, 38.78155], [-123.11511, 38.78196], [-123.11504, 38.78222], [-123.11488, 38.78229], [-123.11455, 38.78222], [-123.11469, 38.78208], [-123.11468, 38.7819], [-123.11463, 38.78153], [-123.11456, 38.78125], [-123.11406, 38.7808], [-123.1136, 38.78049], [-123.11322, 38.78], [-123.11319, 38.77967], [-123.11271, 38.77919], [-123.1124, 38.77895], [-123.11206, 38.77833], [-123.11165, 38.77825], [-123.11101, 38.77772], [-123.11023, 38.77734], [-123.10987, 38.77686], [-123.10961, 38.77679], [-123.10914, 38.77621], [-123.1087, 38.77596], [-123.10806, 38.77593], [-123.10763, 38.77601], [-123.10755, 38.77588], [-123.10754, 38.77552], [-123.10663, 38.77474], [-123.10598, 38.77457], [-123.10529, 38.77454], [-123.10447, 38.77416], [-123.10393, 38.77393], [-123.10357, 38.77396], [-123.10344, 38.77392], [-123.10346, 38.77373], [-123.10321, 38.77345], [-123.10275, 38.77312], [-123.10265, 38.77269], [-123.10226, 38.77237], [-123.10163, 38.77218], [-123.10133, 38.77215], [-123.1012, 38.77198], [-123.10102, 38.77186], [-123.10063, 38.77136], [-123.10026, 38.77121], [-123.09994, 38.7712], [-123.09976, 38.77139], [-123.0996, 38.77135], [-123.09889, 38.77138], [-123.09891, 38.77124], [-123.09874, 38.77114], [-123.09808, 38.77122], [-123.09745, 38.77084], [-123.09696, 38.77027], [-123.0965, 38.76969], [-123.09561, 38.76898], [-123.09494, 38.76873], [-123.09455, 38.76872], [-123.09442, 38.76883], [-123.09434, 38.76915], [-123.09411, 38.7697], [-123.09427, 38.77008], [-123.09466, 38.77044], [-123.09494, 38.77056], [-123.09486, 38.77085], [-123.09511, 38.77101], [-123.09535, 38.7712], [-123.09588, 38.77141], [-123.0964, 38.772], [-123.0965, 38.77232], [-123.09624, 38.77286], [-123.09614, 38.77313], [-123.09588, 38.77342], [-123.09583, 38.77372], [-123.09616, 38.77404], [-123.09653, 38.77407], [-123.09708, 38.77434], [-123.09699, 38.77445], [-123.09593, 38.7743], [-123.09569, 38.77434], [-123.09546, 38.77463], [-123.09548, 38.77519], [-123.09558, 38.77527], [-123.09553, 38.77533], [-123.09523, 38.77538], [-123.09501, 38.77558], [-123.09488, 38.77574], [-123.09472, 38.77612], [-123.09412, 38.7769], [-123.09409, 38.77704], [-123.0941, 38.77705], [-123.09478, 38.77693], [-123.09547, 38.7769], [-123.09564, 38.77694], [-123.09522, 38.77709], [-123.09453, 38.77737], [-123.09425, 38.77764], [-123.09427, 38.77805], [-123.0946, 38.77838], [-123.09533, 38.77891], [-123.09538, 38.77975], [-123.09568, 38.7801], [-123.09612, 38.78048], [-123.09616, 38.78075], [-123.09663, 38.78136], [-123.097, 38.78163], [-123.09719, 38.78169], [-123.09722, 38.78212], [-123.09764, 38.78257], [-123.09792, 38.78292], [-123.09863, 38.78304], [-123.09889, 38.78295], [-123.09911, 38.78301], [-123.0993, 38.78333], [-123.09936, 38.78374], [-123.09961, 38.78395], [-123.09982, 38.7842], [-123.09979, 38.78434], [-123.09947, 38.78432], [-123.09878, 38.7836], [-123.09854, 38.78356], [-123.09825, 38.78364], [-123.09794, 38.78345], [-123.09737, 38.7834], [-123.09733, 38.78327], [-123.09739, 38.78318], [-123.09711, 38.78288], [-123.09708, 38.78266], [-123.09644, 38.78235], [-123.09651, 38.78209], [-123.09636, 38.78196], [-123.09587, 38.7817], [-123.09579, 38.78132], [-123.09531, 38.78069], [-123.09504, 38.78044], [-123.09503, 38.78022], [-123.09436, 38.77939], [-123.09421, 38.77931], [-123.09397, 38.77936], [-123.09366, 38.77923], [-123.09357, 38.77895], [-123.09292, 38.77825], [-123.09241, 38.77812], [-123.09204, 38.77819], [-123.09196, 38.77828], [-123.09172, 38.77825], [-123.09125, 38.77834], [-123.09103, 38.77849], [-123.09051, 38.77863], [-123.09028, 38.77906], [-123.09041, 38.77928], [-123.09033, 38.77946], [-123.09015, 38.77976], [-123.08988, 38.7809], [-123.08986, 38.78104], [-123.08966, 38.78098], [-123.08957, 38.78052], [-123.08956, 38.77997], [-123.0897, 38.77943], [-123.0897, 38.77909], [-123.09025, 38.77831], [-123.09033, 38.77797], [-123.09016, 38.7774], [-123.08999, 38.77694], [-123.08943, 38.77673], [-123.08905, 38.77665], [-123.08878, 38.77668], [-123.08851, 38.77653], [-123.08812, 38.7767], [-123.08732, 38.77732], [-123.08737, 38.7774], [-123.08739, 38.7777], [-123.08669, 38.77913], [-123.08626, 38.77989], [-123.08626, 38.78031], [-123.0856, 38.78094], [-123.08542, 38.78146], [-123.08605, 38.78276], [-123.08589, 38.78334], [-123.0859, 38.78414], [-123.08604, 38.78441], [-123.08619, 38.78451], [-123.08613, 38.78483], [-123.08609, 38.78522], [-123.08617, 38.78537], [-123.08592, 38.78564], [-123.08583, 38.78616], [-123.08583, 38.78647], [-123.0855, 38.7871], [-123.08497, 38.78762], [-123.08471, 38.78795], [-123.08491, 38.78838], [-123.08519, 38.78864], [-123.08541, 38.78901], [-123.08544, 38.78979], [-123.08567, 38.79001], [-123.08572, 38.79015], [-123.08559, 38.79053], [-123.08534, 38.79097], [-123.08509, 38.79115], [-123.08481, 38.79141], [-123.08467, 38.79159], [-123.08465, 38.79159], [-123.0847, 38.79128], [-123.08455, 38.79092], [-123.08506, 38.79035], [-123.085, 38.78964], [-123.0844, 38.78899], [-123.08422, 38.78861], [-123.084, 38.78824], [-123.08399, 38.78795], [-123.08401, 38.78776], [-123.08414, 38.78752], [-123.0841, 38.78735], [-123.08438, 38.78695], [-123.08465, 38.78635], [-123.08462, 38.78565], [-123.08482, 38.78538], [-123.08498, 38.78532], [-123.08514, 38.7853], [-123.08513, 38.7849], [-123.08469, 38.7839], [-123.08428, 38.7836], [-123.08406, 38.78356], [-123.08334, 38.7841], [-123.08311, 38.78419], [-123.08287, 38.78422], [-123.08287, 38.78412], [-123.0831, 38.78392], [-123.08323, 38.78377], [-123.08321, 38.78354], [-123.08414, 38.78225], [-123.08446, 38.78189], [-123.08434, 38.78173], [-123.0837, 38.781], [-123.08297, 38.78083], [-123.08265, 38.78087], [-123.08239, 38.78076], [-123.08317, 38.78059], [-123.08375, 38.78008], [-123.08375, 38.78006], [-123.08365, 38.77998], [-123.08302, 38.77985], [-123.08306, 38.77974], [-123.0839, 38.77956], [-123.08427, 38.77941], [-123.08472, 38.77873], [-123.08471, 38.77855], [-123.08455, 38.7784], [-123.08349, 38.77828], [-123.08217, 38.77818], [-123.08212, 38.77807], [-123.08233, 38.77795], [-123.08265, 38.77792], [-123.08272, 38.77784], [-123.0827, 38.77775], [-123.08285, 38.77764], [-123.08292, 38.77767], [-123.08318, 38.77787], [-123.08443, 38.77797], [-123.08484, 38.77783], [-123.085, 38.77757], [-123.08508, 38.77737], [-123.08557, 38.77687], [-123.08553, 38.77667], [-123.08546, 38.77649], [-123.08554, 38.77636], [-123.08586, 38.77625], [-123.08647, 38.77599], [-123.0868, 38.77569], [-123.08743, 38.77545], [-123.08791, 38.77523], [-123.0888, 38.77554], [-123.08907, 38.77561], [-123.08941, 38.77543], [-123.09002, 38.77561], [-123.09104, 38.77576], [-123.09108, 38.77609], [-123.09152, 38.77647], [-123.09184, 38.77649], [-123.09206, 38.77649], [-123.09243, 38.77636], [-123.09303, 38.77628], [-123.0935, 38.77598], [-123.09425, 38.77537], [-123.09433, 38.77507], [-123.09427, 38.77487], [-123.09459, 38.77449], [-123.09454, 38.77434], [-123.09448, 38.77403], [-123.0947, 38.77376], [-123.09454, 38.77265], [-123.09356, 38.77231], [-123.09305, 38.77207], [-123.09257, 38.7721], [-123.092, 38.77258], [-123.09184, 38.77264], [-123.09168, 38.77256], [-123.09117, 38.77257], [-123.091, 38.77249], [-123.09112, 38.77239], [-123.09168, 38.77216], [-123.09204, 38.77183], [-123.09206, 38.77147], [-123.09222, 38.77127], [-123.09222, 38.77094], [-123.09178, 38.77039], [-123.09188, 38.77031], [-123.09232, 38.77009], [-123.09232, 38.76998], [-123.09218, 38.76956], [-123.09276, 38.76906], [-123.09278, 38.76884], [-123.09263, 38.76847], [-123.09227, 38.76801], [-123.09308, 38.7675], [-123.09321, 38.76705], [-123.09313, 38.76676], [-123.09286, 38.76632], [-123.09366, 38.76593], [-123.09371, 38.76568], [-123.09367, 38.7653], [-123.09314, 38.76476], [-123.09296, 38.76411], [-123.09275, 38.76377], [-123.09249, 38.76362], [-123.09218, 38.76316], [-123.0912, 38.76307], [-123.09085, 38.76253], [-123.09063, 38.76244], [-123.08988, 38.7623], [-123.0891, 38.76191], [-123.08876, 38.76195], [-123.08809, 38.76245], [-123.08789, 38.76291], [-123.08774, 38.76295], [-123.08732, 38.76285], [-123.08695, 38.76286], [-123.08639, 38.76321], [-123.08589, 38.76363], [-123.08554, 38.76381], [-123.08554, 38.76403], [-123.08571, 38.76423], [-123.08565, 38.7644], [-123.08536, 38.76453], [-123.08517, 38.76474], [-123.08527, 38.7649], [-123.0854, 38.76502], [-123.08519, 38.7652], [-123.0849, 38.7653], [-123.08482, 38.76557], [-123.08516, 38.76576], [-123.08523, 38.76598], [-123.08564, 38.76622], [-123.08564, 38.76632], [-123.08541, 38.76637], [-123.0851, 38.76646], [-123.08476, 38.76636], [-123.08453, 38.76636], [-123.08438, 38.76653], [-123.0844, 38.76677], [-123.08476, 38.76702], [-123.08433, 38.76763], [-123.08443, 38.76787], [-123.0842, 38.7679], [-123.08375, 38.76751], [-123.08339, 38.76737], [-123.08309, 38.76741], [-123.08296, 38.76753], [-123.08297, 38.76764], [-123.08308, 38.76777], [-123.08308, 38.76819], [-123.0833, 38.76835], [-123.08359, 38.76838], [-123.0839, 38.76821], [-123.08427, 38.76835], [-123.08469, 38.76847], [-123.08482, 38.76855], [-123.08482, 38.76865], [-123.08426, 38.76882], [-123.08406, 38.76907], [-123.08352, 38.76923], [-123.08288, 38.76921], [-123.08252, 38.76931], [-123.082, 38.76952], [-123.08187, 38.76979], [-123.08186, 38.7702], [-123.08249, 38.77069], [-123.08299, 38.771], [-123.08329, 38.77101], [-123.0834, 38.77105], [-123.08318, 38.77134], [-123.0831, 38.77167], [-123.08249, 38.77142], [-123.08247, 38.77112], [-123.08243, 38.77099], [-123.08224, 38.77088], [-123.08184, 38.77077], [-123.08137, 38.77048], [-123.08103, 38.76993], [-123.081, 38.76971], [-123.08087, 38.76964], [-123.0806, 38.76965], [-123.08016, 38.76976], [-123.07945, 38.77003], [-123.07925, 38.77016], [-123.07853, 38.7703], [-123.07801, 38.77058], [-123.07764, 38.77097], [-123.0772, 38.77107], [-123.07644, 38.77181], [-123.0765, 38.77191], [-123.07608, 38.77197], [-123.07566, 38.77215], [-123.07522, 38.7725], [-123.07452, 38.77299], [-123.07408, 38.77326], [-123.07351, 38.77326], [-123.07324, 38.77318], [-123.07244, 38.7732], [-123.07258, 38.7731], [-123.07295, 38.77304], [-123.07328, 38.77285], [-123.07313, 38.77251], [-123.073, 38.77233], [-123.07327, 38.77195], [-123.07384, 38.77165], [-123.07462, 38.77141], [-123.07543, 38.77123], [-123.07566, 38.77108], [-123.07567, 38.77071], [-123.07659, 38.77013], [-123.07765, 38.7694], [-123.07781, 38.76911], [-123.07856, 38.76928], [-123.07922, 38.76904], [-123.07962, 38.76885], [-123.07974, 38.76867], [-123.07973, 38.76847], [-123.07953, 38.76842], [-123.07894, 38.76837], [-123.07846, 38.7681], [-123.07861, 38.76791], [-123.07878, 38.7679], [-123.07962, 38.76792], [-123.08031, 38.76771], [-123.0805, 38.76735], [-123.08066, 38.76715], [-123.08083, 38.76714], [-123.08109, 38.76721], [-123.08151, 38.76705], [-123.08189, 38.76665], [-123.08255, 38.76648], [-123.08328, 38.76572], [-123.08312, 38.76503], [-123.08286, 38.76476], [-123.08348, 38.76449], [-123.08376, 38.764], [-123.08376, 38.76368], [-123.08363, 38.7633], [-123.08414, 38.76305], [-123.08465, 38.76248], [-123.08482, 38.76211], [-123.08471, 38.76195], [-123.08402, 38.76188], [-123.08383, 38.76159], [-123.08337, 38.76138], [-123.08296, 38.76146], [-123.08273, 38.76157], [-123.08203, 38.76133], [-123.08136, 38.76129], [-123.08097, 38.76156], [-123.08028, 38.76214], [-123.08018, 38.76214], [-123.08086, 38.76118], [-123.08085, 38.7605], [-123.08027, 38.7601], [-123.07965, 38.75989], [-123.07885, 38.75942], [-123.07864, 38.75912], [-123.07783, 38.75885], [-123.077, 38.75895], [-123.0759, 38.75914], [-123.0749, 38.75903], [-123.07487, 38.75897], [-123.07564, 38.75873], [-123.07656, 38.7588], [-123.07705, 38.75859], [-123.07843, 38.75852], [-123.07904, 38.75858], [-123.07922, 38.75905], [-123.07993, 38.75918], [-123.08051, 38.75925], [-123.0816, 38.7598], [-123.08196, 38.75984], [-123.08205, 38.76001], [-123.08249, 38.76019], [-123.08296, 38.76031], [-123.0834, 38.76021], [-123.08354, 38.76016], [-123.08391, 38.76041], [-123.08447, 38.76045], [-123.08475, 38.76066], [-123.08548, 38.76092], [-123.08644, 38.76091], [-123.08735, 38.76035], [-123.08832, 38.75956], [-123.08853, 38.75921], [-123.09015, 38.75741], [-123.09164, 38.75469], [-123.09216, 38.75405], [-123.09244, 38.75358], [-123.09269, 38.75211], [-123.09273, 38.75149], [-123.09331, 38.75082], [-123.0931, 38.75067], [-123.09228, 38.75052], [-123.09157, 38.75061], [-123.09093, 38.75029], [-123.0906, 38.75028], [-123.08974, 38.75077], [-123.08831, 38.75224], [-123.08796, 38.75282], [-123.08774, 38.75294], [-123.08742, 38.75303], [-123.08739, 38.75297], [-123.08777, 38.75237], [-123.08849, 38.75103], [-123.08821, 38.7506], [-123.08871, 38.75013], [-123.08903, 38.74992], [-123.08915, 38.74962], [-123.08944, 38.74905], [-123.08978, 38.7485], [-123.08924, 38.74811], [-123.08903, 38.74761], [-123.08827, 38.74776], [-123.08765, 38.74753], [-123.08737, 38.74696], [-123.08725, 38.74621], [-123.08731, 38.74548], [-123.08665, 38.74504], [-123.08615, 38.74456], [-123.0855, 38.74484], [-123.08473, 38.74478], [-123.08411, 38.74503], [-123.08331, 38.74492], [-123.08246, 38.74469], [-123.08168, 38.74418], [-123.08041, 38.74407], [-123.07926, 38.74417], [-123.07848, 38.74376], [-123.07706, 38.74377], [-123.07621, 38.74369], [-123.0754, 38.74352], [-123.0747, 38.74301], [-123.07373, 38.74239], [-123.07284, 38.74152], [-123.07237, 38.74111], [-123.07175, 38.74087], [-123.07102, 38.74109], [-123.07037, 38.74142], [-123.06953, 38.74143], [-123.06853, 38.74138], [-123.06768, 38.74124], [-123.06679, 38.7408], [-123.06621, 38.74047], [-123.06513, 38.74051], [-123.06432, 38.74037], [-123.06355, 38.74037], [-123.06286, 38.74008], [-123.06208, 38.7396], [-123.06085, 38.73931], [-123.05996, 38.73917], [-123.05927, 38.73933], [-123.05869, 38.73894], [-123.05784, 38.73862], [-123.05699, 38.73826], [-123.05648, 38.73782], [-123.05548, 38.73804], [-123.05524, 38.73735], [-123.05466, 38.73705], [-123.05362, 38.73676], [-123.05289, 38.73662], [-123.05219, 38.73656], [-123.05118, 38.73597], [-123.04987, 38.73565], [-123.04868, 38.73566], [-123.04806, 38.73534], [-123.04676, 38.73544], [-123.04602, 38.73514], [-123.04559, 38.73467], [-123.04501, 38.73437], [-123.04446, 38.73365], [-123.04384, 38.7333], [-123.04254, 38.73334], [-123.04193, 38.73373], [-123.04108, 38.73368], [-123.03985, 38.73372], [-123.03889, 38.73361], [-123.03838, 38.73317], [-123.03777, 38.73359], [-123.03749, 38.73308], [-123.03657, 38.7327], [-123.03564, 38.73249], [-123.03502, 38.73217], [-123.03417, 38.73203], [-123.03337, 38.73197], [-123.0329, 38.73156], [-123.03182, 38.73166], [-123.03106, 38.73199], [-123.03109, 38.73139], [-123.03073, 38.73064], [-123.03034, 38.73013], [-123.02972, 38.72969], [-123.02903, 38.72951], [-123.02886, 38.7287], [-123.0285, 38.72795], [-123.02765, 38.72772], [-123.02703, 38.72718], [-123.02614, 38.72659], [-123.02521, 38.72647], [-123.02413, 38.72603], [-123.02329, 38.7261], [-123.02264, 38.72632], [-123.02234, 38.7268], [-123.02162, 38.72723], [-123.02162, 38.7278], [-123.02093, 38.72778], [-123.02038, 38.72736], [-123.01984, 38.72701], [-123.01915, 38.72698], [-123.01834, 38.72666], [-123.01765, 38.72675], [-123.01676, 38.7267], [-123.01596, 38.72671], [-123.01474, 38.72759], [-123.0145, 38.72702], [-123.01414, 38.72633], [-123.01424, 38.7257], [-123.01359, 38.72555], [-123.0129, 38.72529], [-123.01217, 38.72518], [-123.01179, 38.72572], [-123.01094, 38.72549], [-123.01001, 38.72525], [-123.01051, 38.7248], [-123.01096, 38.7241], [-123.01176, 38.72397], [-123.01199, 38.72343], [-123.01205, 38.72285], [-123.01132, 38.72244], [-123.01044, 38.72254], [-123.00943, 38.72228], [-123.0087, 38.72222], [-123.0079, 38.72274], [-123.00784, 38.72344], [-123.00721, 38.72233], [-123.00666, 38.72176], [-123.00711, 38.71583], [-123.0033, 38.71601], [-123.0019, 38.71685], [-123.00161, 38.71748], [-123.00134, 38.7189], [-122.99955, 38.71963], [-122.9981, 38.72042], [-122.99785, 38.72039], [-123.00111, 38.71868], [-123.00111, 38.71845], [-122.99799, 38.7201], [-122.99749, 38.72024], [-122.99618, 38.72027], [-122.99334, 38.72023], [-122.99343, 38.71897], [-122.99095, 38.71645], [-122.99329, 38.71486], [-122.9932, 38.71094], [-122.99778, 38.71084], [-122.9978, 38.7108], [-122.99775, 38.70735], [-123.00232, 38.70728], [-123.00671, 38.70699], [-123.00788, 38.70612], [-123.00886, 38.70568], [-123.01069, 38.70541], [-123.01113, 38.70547], [-123.01195, 38.70536], [-123.01276, 38.70499], [-123.01301, 38.70424], [-123.01292, 38.70398], [-123.01278, 38.70379], [-123.01261, 38.70276], [-123.01279, 38.70227], [-123.0128, 38.70201], [-123.0129, 38.70159], [-123.01296, 38.70096], [-123.01301, 38.70067], [-123.01311, 38.70043], [-123.01313, 38.70032], [-123.01304, 38.70009], [-123.01299, 38.69978], [-123.01302, 38.69957], [-123.01307, 38.69942], [-123.01301, 38.69906], [-123.0128, 38.69853], [-123.01278, 38.69824], [-123.01281, 38.69781], [-123.01277, 38.69748], [-123.0126, 38.69683], [-123.01253, 38.69629], [-123.01252, 38.69533], [-123.01261, 38.69499], [-123.01282, 38.69435], [-123.01272, 38.69413], [-123.0122, 38.69353], [-123.01135, 38.69339], [-123.00984, 38.69274], [-123.00958, 38.69181], [-123.00963, 38.69079], [-123.0092, 38.68997], [-123.00707, 38.68907], [-123.00688, 38.68898], [-123.00672, 38.68886], [-123.00643, 38.68848], [-123.00636, 38.68805], [-123.00641, 38.68616], [-123.00783, 38.68533], [-123.00974, 38.68541], [-123.0108, 38.68654], [-123.01201, 38.68661], [-123.01399, 38.68629], [-123.0141, 38.68626], [-123.0142, 38.68621], [-123.01428, 38.68614], [-123.01434, 38.68607], [-123.01439, 38.68595], [-123.01439, 38.68586], [-123.01431, 38.68559], [-123.01429, 38.68542], [-123.01411, 38.68475], [-123.01459, 38.68425], [-123.01475, 38.68335], [-123.01522, 38.68258], [-123.0151, 38.68207], [-123.0152, 38.68156], [-123.0156, 38.68115], [-123.0162, 38.68095], [-123.01708, 38.6797], [-123.01814, 38.67892], [-123.01957, 38.67915], [-123.01997, 38.67912], [-123.02109, 38.67908], [-123.02099, 38.6792], [-123.021, 38.67922], [-123.0282, 38.67911], [-123.02824, 38.6824], [-123.02846, 38.68585], [-123.02854, 38.68907], [-123.04203, 38.68909], [-123.04201, 38.68572], [-123.05096, 38.68563], [-123.05113, 38.69252], [-123.05103, 38.69589], [-123.05559, 38.69593], [-123.05531, 38.69782], [-123.06215, 38.69778], [-123.06224, 38.70273], [-123.06457, 38.70281], [-123.06465, 38.70446], [-123.07394, 38.70449], [-123.07396, 38.7052], [-123.07841, 38.70516], [-123.07837, 38.7029], [-123.08055, 38.70288], [-123.08052, 38.7005], [-123.08276, 38.70048], [-123.08275, 38.69938], [-123.09134, 38.69956], [-123.09333, 38.69957], [-123.09325, 38.69998], [-123.09315, 38.70028], [-123.09336, 38.70076], [-123.09363, 38.70084], [-123.09379, 38.70091], [-123.09388, 38.70098], [-123.09403, 38.70115], [-123.09426, 38.70131], [-123.09446, 38.7015], [-123.09493, 38.70175], [-123.09506, 38.7018], [-123.0953, 38.70185], [-123.09554, 38.702], [-123.09583, 38.7022], [-123.09583, 38.70475], [-123.09139, 38.70472], [-123.08484, 38.7063], [-123.08486, 38.7118], [-123.08708, 38.71354], [-123.09142, 38.71433], [-123.09649, 38.7153], [-123.09736, 38.71731], [-123.08267, 38.71717], [-123.08266, 38.72075], [-123.08241, 38.72075], [-123.0824, 38.72082], [-123.07823, 38.72077], [-123.07831, 38.71344], [-123.08097, 38.7134], [-123.08094, 38.70984], [-123.07857, 38.70986], [-123.0786, 38.71101], [-123.07393, 38.71106], [-123.07391, 38.71158], [-123.06921, 38.71156], [-123.06921, 38.71339], [-123.06462, 38.7134], [-123.06462, 38.71916], [-123.06436, 38.7192], [-123.06362, 38.71943], [-123.06361, 38.71951], [-123.06362, 38.71952], [-123.06374, 38.7195], [-123.06439, 38.71929], [-123.06455, 38.71927], [-123.06465, 38.71928], [-123.06467, 38.72069], [-123.05549, 38.72067], [-123.05551, 38.7242], [-123.05108, 38.72422], [-123.05109, 38.72771], [-123.05113, 38.72955], [-123.05552, 38.72953], [-123.05557, 38.73129], [-123.0601, 38.73135], [-123.06458, 38.7332], [-123.06462, 38.73499], [-123.07345, 38.73504], [-123.07346, 38.73508], [-123.07568, 38.73509], [-123.07564, 38.73691], [-123.07788, 38.73691], [-123.07788, 38.73872], [-123.08225, 38.73871], [-123.09134, 38.73875], [-123.09127, 38.74246], [-123.09587, 38.74242], [-123.09574, 38.74621], [-123.10029, 38.74612], [-123.10024, 38.74803], [-123.10482, 38.74802], [-123.10473, 38.74983], [-123.10592, 38.74984], [-123.10581, 38.75125], [-123.10771, 38.75125], [-123.10771, 38.75379], [-123.10773, 38.75389], [-123.10739, 38.75387], [-123.10695, 38.75359], [-123.10663, 38.75318], [-123.10582, 38.75254], [-123.10439, 38.75187], [-123.10319, 38.75133], [-123.10271, 38.75143], [-123.09968, 38.7523], [-123.09952, 38.75829], [-123.09954, 38.7583], [-123.09773, 38.76147], [-123.09791, 38.76157], [-123.09811, 38.76202], [-123.09841, 38.76234], [-123.09852, 38.76247], [-123.09852, 38.76268], [-123.09841, 38.76313], [-123.09858, 38.76349], [-123.09913, 38.76385], [-123.09925, 38.764], [-123.09928, 38.76438], [-123.09955, 38.76462], [-123.09955, 38.76487], [-123.09971, 38.76508], [-123.10002, 38.76542], [-123.09987, 38.76566], [-123.09998, 38.76599], [-123.10032, 38.76625], [-123.10069, 38.76634], [-123.10104, 38.76674], [-123.10098, 38.7671], [-123.10108, 38.76725], [-123.10124, 38.76744], [-123.10141, 38.76749], [-123.10132, 38.76754], [-123.10102, 38.7678], [-123.10099, 38.76819], [-123.10136, 38.76888], [-123.10198, 38.76942], [-123.10233, 38.76948], [-123.10252, 38.76948], [-123.10271, 38.76978], [-123.10335, 38.77024], [-123.10379, 38.77039], [-123.10406, 38.7704], [-123.10461, 38.77023], [-123.10475, 38.77023], [-123.10475, 38.77033], [-123.10456, 38.77093], [-123.1049, 38.77151], [-123.10517, 38.7721], [-123.10531, 38.77233], [-123.10562, 38.77244], [-123.10617, 38.77231], [-123.10646, 38.77236], [-123.10678, 38.77222], [-123.10698, 38.77223], [-123.10665, 38.77283], [-123.10652, 38.77315], [-123.10675, 38.77348], [-123.10717, 38.7737], [-123.10754, 38.77405], [-123.10781, 38.77405], [-123.10833, 38.77381], [-123.10879, 38.77394], [-123.10945, 38.77392], [-123.11031, 38.77379], [-123.11059, 38.7738], [-123.11096, 38.77355], [-123.11125, 38.77328], [-123.11145, 38.77333], [-123.11167, 38.77343], [-123.112, 38.77351], [-123.11198, 38.77356], [-123.11183, 38.77363], [-123.11166, 38.77383], [-123.11164, 38.77424], [-123.11176, 38.77482], [-123.11192, 38.77534], [-123.11226, 38.77601], [-123.11304, 38.77653], [-123.1137, 38.77747], [-123.11416, 38.7777], [-123.11442, 38.77771], [-123.11447, 38.77795], [-123.11476, 38.77813], [-123.11491, 38.77818], [-123.11507, 38.77846], [-123.11531, 38.77858], [-123.11551, 38.77864], [-123.11577, 38.77888], [-123.11628, 38.77886], [-123.11701, 38.77868], [-123.1177, 38.77873], [-123.11831, 38.77875], [-123.1185, 38.77885], [-123.11886, 38.77927], [-123.11945, 38.77936], [-123.12032, 38.77935], [-123.12105, 38.77973], [-123.12185, 38.77993], [-123.12224, 38.77994], [-123.12266, 38.77986], [-123.12304, 38.78008], [-123.12367, 38.78064], [-123.12392, 38.78065], [-123.12394, 38.7805], [-123.12401, 38.78038], [-123.1245, 38.78037], [-123.12487, 38.78031], [-123.12517, 38.78005], [-123.12587, 38.78004], [-123.12611, 38.77981], [-123.1261, 38.77966], [-123.12646, 38.77903], [-123.12799, 38.77826], [-123.1289, 38.77827], [-123.12961, 38.77788], [-123.13026, 38.77814], [-123.13048, 38.77877], [-123.13116, 38.77887], [-123.13178, 38.77855], [-123.13253, 38.77868], [-123.13324, 38.77843], [-123.13443, 38.77817], [-123.13514, 38.77821], [-123.13594, 38.77836], [-123.13669, 38.77879], [-123.13738, 38.77879], [-123.13779, 38.77952], [-123.13834, 38.77996], [-123.13872, 38.78063], [-123.13879, 38.78121], [-123.1395, 38.78116], [-123.14024, 38.78115], [-123.14104, 38.78132], [-123.14201, 38.7814], [-123.14272, 38.78139], [-123.14369, 38.78154], [-123.14433, 38.782], [-123.14521, 38.78204], [-123.14622, 38.78254], [-123.14706, 38.78309], [-123.14758, 38.78351]]]}	Open Access 1	17263	Lake Sonoma Recreation Area	13568	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://corpslakes.usace.army.mil/visitors/projects.cfm?Id=L304990	Sonoma 16	8085.244	Lake Sonoma Rec. Area	0	Recreation Management Area 49	4

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
   FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
   FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
   FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
   FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);