units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where AGNCY_NAME = 1, DES_TP = 8 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, MNG_AG_ID, PARK_URL, COUNTY, LABEL_NAME, YR_EST
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3461 | 3461 | 3460 | {"type": "MultiPolygon", "coordinates": [[[[-116.11262, 33.44058], [-116.09529, 33.44063], [-116.09545, 33.42628], [-116.10209, 33.42627], [-116.11262, 33.42628], [-116.11262, 33.44058]]], [[[-116.43218, 33.49987], [-116.41536, 33.49987], [-116.41533, 33.4853], [-116.43215, 33.48542], [-116.43218, 33.49987]]], [[[-116.44949, 33.5144], [-116.43221, 33.51441], [-116.43219, 33.49989], [-116.4494, 33.49989], [-116.44949, 33.5144]]], [[[-116.18212, 33.52531], [-116.16486, 33.52549], [-116.16478, 33.51086], [-116.18208, 33.51074], [-116.18212, 33.52531]]], [[[-116.21578, 33.55117], [-116.21568, 33.55483], [-116.19841, 33.55491], [-116.1984, 33.54041], [-116.18224, 33.5399], [-116.18221, 33.52601], [-116.19835, 33.52595], [-116.19825, 33.49137], [-116.18219, 33.49145], [-116.18218, 33.48416], [-116.18141, 33.48415], [-116.18197, 33.48414], [-116.18176, 33.46973], [-116.19791, 33.46969], [-116.19783, 33.45523], [-116.18177, 33.45522], [-116.18181, 33.4407], [-116.16461, 33.44069], [-116.1646, 33.44055], [-116.16447, 33.44055], [-116.16436, 33.42758], [-116.18171, 33.42828], [-116.18182, 33.4407], [-116.19773, 33.44074], [-116.19774, 33.44073], [-116.19766, 33.42891], [-116.20516, 33.42886], [-116.21367, 33.42876], [-116.23452, 33.42845], [-116.25352, 33.4282], [-116.26375, 33.42815], [-116.27331, 33.42792], [-116.28435, 33.42775], [-116.28442, 33.44217], [-116.30216, 33.44248], [-116.30217, 33.44247], [-116.3021, 33.42745], [-116.31943, 33.42743], [-116.31949, 33.44148], [-116.3195, 33.44198], [-116.33674, 33.44188], [-116.33674, 33.44151], [-116.33683, 33.4415], [-116.33689, 33.4274], [-116.35397, 33.42738], [-116.35394, 33.44159], [-116.34509, 33.44145], [-116.33683, 33.44151], [-116.33682, 33.44188], [-116.33674, 33.44189], [-116.33671, 33.44654], [-116.33667, 33.44834], [-116.33655, 33.45617], [-116.33665, 33.45618], [-116.33666, 33.4563], [-116.35383, 33.45619], [-116.35392, 33.44452], [-116.35402, 33.4419], [-116.3712, 33.44187], [-116.37126, 33.42744], [-116.37442, 33.42745], [-116.37441, 33.42744], [-116.37431, 33.42735], [-116.38494, 33.42749], [-116.38863, 33.4275], [-116.38859, 33.44138], [-116.38829, 33.44181], [-116.3712, 33.44188], [-116.37113, 33.45588], [-116.37129, 33.45589], [-116.3713, 33.45606], [-116.37113, 33.45606], [-116.37113, 33.45619], [-116.38829, 33.45616], [-116.38835, 33.44181], [-116.39755, 33.44177], [-116.41518, 33.44193], [-116.41515, 33.45641], [-116.38837, 33.45616], [-116.38836, 33.45622], [-116.38829, 33.45623], [-116.3883, 33.47038], [-116.37138, 33.47043], [-116.37146, 33.48495], [-116.38873, 33.48487], [-116.38868, 33.47038], [-116.4153, 33.47039], [-116.41533, 33.48491], [-116.38873, 33.48488], [-116.38877, 33.49937], [-116.37154, 33.49942], [-116.37154, 33.51116], [-116.35428, 33.51113], [-116.35426, 33.49947], [-116.37154, 33.49942], [-116.37146, 33.48497], [-116.37145, 33.48496], [-116.35396, 33.48508], [-116.35391, 33.47064], [-116.33668, 33.47075], [-116.3367, 33.48513], [-116.35393, 33.48511], [-116.35394, 33.49953], [-116.33698, 33.49951], [-116.33669, 33.48514], [-116.31948, 33.4852], [-116.31971, 33.49955], [-116.30243, 33.49959], [-116.30223, 33.48589], [-116.28479, 33.48574], [-116.28483, 33.50024], [-116.30243, 33.50022], [-116.30246, 33.51136], [-116.31973, 33.51123], [-116.31972, 33.50341], [-116.337, 33.50337], [-116.33703, 33.51109], [-116.31974, 33.51123], [-116.31947, 33.51135], [-116.3192, 33.51831], [-116.31905, 33.52528], [-116.30229, 33.52587], [-116.30236, 33.53996], [-116.30238, 33.54005], [-116.31954, 33.53995], [-116.31959, 33.55438], [-116.33276, 33.55531], [-116.33704, 33.5553], [-116.33682, 33.5692], [-116.31958, 33.56921], [-116.31964, 33.58366], [-116.30279, 33.58371], [-116.30277, 33.58395], [-116.30217, 33.58396], [-116.30257, 33.59267], [-116.30245, 33.59809], [-116.28546, 33.59814], [-116.28536, 33.61266], [-116.30395, 33.61267], [-116.30382, 33.62715], [-116.32146, 33.62714], [-116.32147, 33.64164], [-116.31273, 33.64167], [-116.31279, 33.6308], [-116.30412, 33.6308], [-116.30381, 33.62716], [-116.29397, 33.62747], [-116.29396, 33.62754], [-116.29358, 33.62755], [-116.29352, 33.62747], [-116.28531, 33.62754], [-116.28539, 33.63048], [-116.28536, 33.63489], [-116.28545, 33.6349], [-116.28542, 33.64205], [-116.30368, 33.64192], [-116.30367, 33.64895], [-116.30371, 33.64899], [-116.30371, 33.65642], [-116.28547, 33.65648], [-116.28542, 33.64206], [-116.28107, 33.64208], [-116.28101, 33.63121], [-116.28097, 33.62756], [-116.2853, 33.62753], [-116.28536, 33.61267], [-116.26819, 33.61274], [-116.26791, 33.62036], [-116.26796, 33.62763], [-116.26362, 33.62765], [-116.26377, 33.61658], [-116.2595, 33.61659], [-116.25957, 33.61282], [-116.26819, 33.61274], [-116.26813, 33.59822], [-116.25027, 33.59823], [-116.25033, 33.58382], [-116.23312, 33.58385], [-116.23312, 33.56937], [-116.21587, 33.56939], [-116.21599, 33.55495], [-116.23307, 33.55487], [-116.23302, 33.54022], [-116.21585, 33.54029], [-116.21586, 33.54104], [-116.21567, 33.54397], [-116.21568, 33.54398], [-116.21578, 33.54396], [-116.21578, 33.55117]], [[-116.26813, 33.59821], [-116.28502, 33.59813], [-116.28494, 33.58373], [-116.26762, 33.58376], [-116.26813, 33.59821]], [[-116.25041, 33.58368], [-116.25032, 33.58368], [-116.25032, 33.58372], [-116.25597, 33.58373], [-116.25781, 33.58371], [-116.26761, 33.58372], [-116.26768, 33.56927], [-116.25036, 33.56932], [-116.25041, 33.58368]], [[-116.2503, 33.55656], [-116.25029, 33.55479], [-116.23308, 33.55487], [-116.23312, 33.56936], [-116.25035, 33.56931], [-116.2503, 33.55656]], [[-116.30239, 33.54718], [-116.30236, 33.54011], [-116.29782, 33.54004], [-116.29779, 33.54005], [-116.29357, 33.54005], [-116.29353, 33.54002], [-116.28481, 33.54004], [-116.28469, 33.55452], [-116.26758, 33.55456], [-116.26756, 33.53998], [-116.25024, 33.54017], [-116.2503, 33.55478], [-116.26757, 33.55462], [-116.26769, 33.56927], [-116.28472, 33.56925], [-116.28471, 33.56556], [-116.28444, 33.55457], [-116.3018, 33.55446], [-116.30181, 33.55443], [-116.30254, 33.55442], [-116.30239, 33.54718]], [[-116.21584, 33.5403], [-116.21585, 33.54028], [-116.21572, 33.52588], [-116.19836, 33.52596], [-116.19836, 33.52684], [-116.20695, 33.52675], [-116.20696, 33.52678], [-116.20705, 33.52678], [-116.20705, 33.52771], [-116.19836, 33.52777], [-116.19841, 33.54041], [-116.21584, 33.5403]], [[-116.25021, 33.53595], [-116.25016, 33.52568], [-116.23297, 33.52579], [-116.23298, 33.53128], [-116.23299, 33.53148], [-116.233, 33.53149], [-116.23301, 33.53775], [-116.23306, 33.53922], [-116.23302, 33.54022], [-116.24165, 33.54017], [-116.25022, 33.54017], [-116.25021, 33.53595]], [[-116.22426, 33.51138], [-116.21562, 33.5114], [-116.21563, 33.51421], [-116.21557, 33.52541], [-116.21558, 33.52585], [-116.21572, 33.52585], [-116.21573, 33.52587], [-116.23296, 33.52578], [-116.23291, 33.51137], [-116.22426, 33.51138]], [[-116.26772, 33.51142], [-116.26771, 33.51141], [-116.26312, 33.51138], [-116.25015, 33.51138], [-116.25017, 33.52568], [-116.26748, 33.52562], [-116.26746, 33.52559], [-116.26772, 33.51142]], [[-116.30228, 33.52586], [-116.30229, 33.52585], [-116.30224, 33.51138], [-116.28508, 33.51139], [-116.2847, 33.52275], [-116.2847, 33.52549], [-116.30228, 33.52586]], [[-116.28483, 33.50026], [-116.26752, 33.50027], [-116.26772, 33.5114], [-116.28507, 33.51138], [-116.28483, 33.50026]], [[-116.26747, 33.48578], [-116.26746, 33.48577], [-116.25483, 33.48591], [-116.25072, 33.48581], [-116.25016, 33.48581], [-116.25011, 33.49213], [-116.25013, 33.50026], [-116.26751, 33.50026], [-116.26747, 33.48578]], [[-116.28471, 33.53283], [-116.28471, 33.52919], [-116.28472, 33.52918], [-116.28469, 33.52555], [-116.2675, 33.52563], [-116.26753, 33.53278], [-116.26795, 33.53279], [-116.26753, 33.53318], [-116.26757, 33.53997], [-116.27717, 33.54002], [-116.27718, 33.54001], [-116.28479, 33.54004], [-116.28475, 33.53285], [-116.28471, 33.53283]], [[-116.31956, 33.56921], [-116.31957, 33.5692], [-116.31958, 33.55439], [-116.30255, 33.55445], [-116.30254, 33.56891], [-116.31956, 33.56921]], [[-116.30273, 33.57997], [-116.30274, 33.57996], [-116.30254, 33.56918], [-116.29363, 33.56922], [-116.29362, 33.56917], [-116.28933, 33.56919], [-116.28932, 33.56924], [-116.28473, 33.56926], [-116.28487, 33.58002], [-116.30273, 33.57997]], [[-116.28478, 33.48574], [-116.28479, 33.48573], [-116.28468, 33.47148], [-116.26737, 33.47154], [-116.26738, 33.48032], [-116.26747, 33.48577], [-116.28478, 33.48574]], [[-116.31947, 33.4852], [-116.31947, 33.47078], [-116.30224, 33.47083], [-116.30225, 33.48525], [-116.31947, 33.4852]], [[-116.33665, 33.45631], [-116.33664, 33.4563], [-116.31947, 33.45635], [-116.31947, 33.47061], [-116.31955, 33.47062], [-116.31954, 33.47077], [-116.33668, 33.4707], [-116.33665, 33.45631]], [[-116.28442, 33.44218], [-116.26712, 33.44225], [-116.26728, 33.4495], [-116.26717, 33.45313], [-116.2672, 33.45676], [-116.28451, 33.45668], [-116.28442, 33.44218]], [[-116.31945, 33.45635], [-116.31947, 33.45634], [-116.31949, 33.44199], [-116.30222, 33.44202], [-116.30225, 33.45642], [-116.31945, 33.45635]], [[-116.37136, 33.47042], [-116.37137, 33.47041], [-116.37116, 33.46339], [-116.36269, 33.4634], [-116.36269, 33.46317], [-116.37116, 33.46316], [-116.37112, 33.45619], [-116.35402, 33.45619], [-116.35411, 33.47044], [-116.37136, 33.47042]]], [[[-116.2861, 33.66009], [-116.2861, 33.6637], [-116.28393, 33.6637], [-116.28393, 33.66009], [-116.2861, 33.66009]]], [[[-116.40806, 33.67067], [-116.40804, 33.67427], [-116.40497, 33.67429], [-116.40499, 33.67609], [-116.40616, 33.67609], [-116.40616, 33.6779], [-116.39595, 33.67788], [-116.39091, 33.6779], [-116.39091, 33.67062], [-116.40806, 33.67067]]], [[[-116.42099, 33.69501], [-116.41959, 33.69501], [-116.41958, 33.69477], [-116.41976, 33.6946], [-116.41975, 33.69418], [-116.42094, 33.69418], [-116.42098, 33.69422], [-116.42099, 33.69501]]], [[[-116.42544, 33.6941], [-116.42544, 33.69502], [-116.42328, 33.69502], [-116.42327, 33.69593], [-116.42217, 33.69593], [-116.42216, 33.69501], [-116.42109, 33.69501], [-116.42107, 33.69319], [-116.42226, 33.69319], [-116.42227, 33.69245], [-116.42236, 33.69238], [-116.42325, 33.69238], [-116.42326, 33.69231], [-116.42107, 33.6923], [-116.42108, 33.69238], [-116.42199, 33.69238], [-116.42207, 33.69246], [-116.42207, 33.69303], [-116.42197, 33.69311], [-116.42098, 33.69311], [-116.42098, 33.69397], [-116.42093, 33.69402], [-116.41998, 33.69401], [-116.41997, 33.69231], [-116.41887, 33.6923], [-116.41891, 33.6914], [-116.42326, 33.69139], [-116.42327, 33.69152], [-116.42419, 33.69152], [-116.42425, 33.69174], [-116.42424, 33.69215], [-116.42417, 33.69222], [-116.42327, 33.69222], [-116.42326, 33.69223], [-116.42327, 33.6923], [-116.42444, 33.6923], [-116.42448, 33.69221], [-116.42444, 33.69204], [-116.42444, 33.69175], [-116.4245, 33.69152], [-116.4248, 33.69148], [-116.42481, 33.69143], [-116.42544, 33.69142], [-116.42544, 33.6941]]], [[[-116.41241, 33.69957], [-116.40802, 33.69957], [-116.40802, 33.69594], [-116.41239, 33.69594], [-116.41241, 33.69957]]], [[[-116.36035, 33.70523], [-116.35593, 33.70525], [-116.35593, 33.69939], [-116.33859, 33.69939], [-116.33851, 33.68485], [-116.35629, 33.68488], [-116.35594, 33.69938], [-116.36027, 33.6994], [-116.36035, 33.70523]]], [[[-116.40817, 33.70603], [-116.40807, 33.70604], [-116.40807, 33.70686], [-116.40425, 33.70685], [-116.40422, 33.70321], [-116.40414, 33.69957], [-116.40633, 33.69957], [-116.40643, 33.70596], [-116.40653, 33.70595], [-116.40646, 33.69964], [-116.40814, 33.69965], [-116.40817, 33.70603]]], [[[-116.30382, 33.70717], [-116.29929, 33.7072], [-116.29926, 33.70356], [-116.30381, 33.70354], [-116.30382, 33.70717]]], [[[-116.32988, 33.71076], [-116.32118, 33.71078], [-116.32114, 33.6994], [-116.32986, 33.6994], [-116.32988, 33.71076]]], [[[-116.40812, 33.71417], [-116.40006, 33.71415], [-116.40007, 33.71411], [-116.39993, 33.7139], [-116.39984, 33.70776], [-116.40426, 33.70778], [-116.40433, 33.7134], [-116.40438, 33.70694], [-116.4081, 33.70695], [-116.40812, 33.71417]]], [[[-116.40827, 33.72153], [-116.40465, 33.72151], [-116.40443, 33.72029], [-116.40504, 33.72005], [-116.40435, 33.71968], [-116.40363, 33.71859], [-116.40387, 33.7183], [-116.40386, 33.71818], [-116.40387, 33.71809], [-116.40391, 33.71801], [-116.40398, 33.71792], [-116.40405, 33.71789], [-116.40416, 33.71802], [-116.40439, 33.71794], [-116.4044, 33.71792], [-116.40409, 33.71744], [-116.40386, 33.71721], [-116.40375, 33.71715], [-116.40359, 33.7171], [-116.40324, 33.71704], [-116.4032, 33.71701], [-116.40318, 33.71696], [-116.40306, 33.71693], [-116.40302, 33.71674], [-116.40297, 33.71668], [-116.40284, 33.71642], [-116.40281, 33.71616], [-116.40277, 33.7161], [-116.402, 33.71581], [-116.40159, 33.71552], [-116.40815, 33.71547], [-116.40827, 33.72153]]], [[[-116.53041, 33.6995], [-116.51282, 33.69953], [-116.51288, 33.71406], [-116.4951, 33.71409], [-116.49509, 33.69954], [-116.48601, 33.69954], [-116.486, 33.69952], [-116.47769, 33.69953], [-116.47767, 33.68502], [-116.46027, 33.68507], [-116.46032, 33.69964], [-116.47767, 33.69956], [-116.47765, 33.70302], [-116.4777, 33.70303], [-116.47773, 33.71412], [-116.49075, 33.7141], [-116.4908, 33.72863], [-116.47777, 33.72865], [-116.47774, 33.74322], [-116.49512, 33.74317], [-116.49512, 33.72863], [-116.51288, 33.72861], [-116.51288, 33.7432], [-116.49513, 33.74317], [-116.49512, 33.75769], [-116.51289, 33.75764], [-116.51292, 33.77233], [-116.52324, 33.77228], [-116.52325, 33.77412], [-116.52828, 33.77406], [-116.52826, 33.7786], [-116.52574, 33.77855], [-116.52557, 33.77946], [-116.52345, 33.77949], [-116.52349, 33.7832], [-116.51912, 33.78324], [-116.51917, 33.78686], [-116.51062, 33.78706], [-116.51061, 33.77234], [-116.49503, 33.77242], [-116.49512, 33.7577], [-116.48639, 33.75768], [-116.48641, 33.75045], [-116.47771, 33.75045], [-116.47773, 33.74322], [-116.46033, 33.74322], [-116.46034, 33.75769], [-116.44287, 33.75769], [-116.44289, 33.74863], [-116.44398, 33.74863], [-116.44398, 33.74683], [-116.4429, 33.74683], [-116.44291, 33.74321], [-116.46033, 33.74321], [-116.46034, 33.7287], [-116.44295, 33.72867], [-116.44293, 33.71408], [-116.42557, 33.71407], [-116.42555, 33.69961], [-116.44293, 33.69956], [-116.4429, 33.68508], [-116.42548, 33.68505], [-116.42549, 33.6707], [-116.40903, 33.67068], [-116.40903, 33.6707], [-116.40898, 33.67068], [-116.40822, 33.67068], [-116.40821, 33.67074], [-116.40815, 33.67068], [-116.40799, 33.67039], [-116.40815, 33.67041], [-116.40812, 33.66823], [-116.4081, 33.66326], [-116.40815, 33.65614], [-116.42554, 33.65612], [-116.42551, 33.6416], [-116.44281, 33.6416], [-116.44283, 33.64527], [-116.44301, 33.64884], [-116.44303, 33.64885], [-116.44301, 33.64888], [-116.44304, 33.65613], [-116.4603, 33.65606], [-116.4603, 33.6488], [-116.469, 33.64879], [-116.46901, 33.64155], [-116.47768, 33.64152], [-116.47771, 33.65606], [-116.49512, 33.65609], [-116.4951, 33.67039], [-116.47775, 33.67057], [-116.47768, 33.68501], [-116.49507, 33.68501], [-116.49515, 33.67058], [-116.51228, 33.67063], [-116.51225, 33.68501], [-116.53024, 33.68507], [-116.53041, 33.6995]], [[-116.47776, 33.72865], [-116.47772, 33.71412], [-116.46031, 33.7141], [-116.46034, 33.7287], [-116.47776, 33.72865]], [[-116.4603, 33.7141], [-116.46031, 33.71409], [-116.46031, 33.69965], [-116.44293, 33.69956], [-116.44294, 33.71408], [-116.4603, 33.7141]], [[-116.46035, 33.6706], [-116.46034, 33.67059], [-116.44296, 33.67068], [-116.44291, 33.68506], [-116.46027, 33.68505], [-116.46035, 33.6706]], [[-116.44303, 33.65614], [-116.44302, 33.65613], [-116.42555, 33.65613], [-116.4255, 33.67064], [-116.44294, 33.67058], [-116.44303, 33.65614]], [[-116.47774, 33.67057], [-116.47775, 33.67056], [-116.47771, 33.65607], [-116.46031, 33.65606], [-116.46035, 33.67059], [-116.47774, 33.67057]], [[-116.51281, 33.69953], [-116.51282, 33.69952], [-116.51224, 33.68502], [-116.49508, 33.68502], [-116.4951, 33.69953], [-116.51281, 33.69953]]]]} | Open Access 1 | 25331 | Santa Rosa Wildlife Area | 30502 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Santa-Rosa-WA | Riverside 10 | 65533.31 | Santa Rosa Wildlife Area | 1983 | State Conservation Area 8 | 2 |
| 3589 | 3589 | 3588 | {"type": "Polygon", "coordinates": [[[-121.4409, 38.26568], [-121.4405, 38.26654], [-121.43893, 38.26623], [-121.43872, 38.26566], [-121.43905, 38.26515], [-121.43899, 38.26457], [-121.44061, 38.26555], [-121.4409, 38.26568]]]} | Restricted Access 2 | 29176 | Cosumnes River Ecological Reserve | 17675 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cosumnes-River-ER | Sacramento 41 | 5.742 | Cosumnes River ER | 2003 | State Conservation Area 8 | 2 |
| 3591 | 3591 | 3590 | {"type": "Polygon", "coordinates": [[[-124.14742, 40.69347], [-124.14559, 40.69346], [-124.14538, 40.69323], [-124.14529, 40.69315], [-124.1453, 40.6929], [-124.14528, 40.69266], [-124.14516, 40.69246], [-124.14439, 40.69244], [-124.14425, 40.69237], [-124.14377, 40.69258], [-124.14337, 40.6929], [-124.14227, 40.69323], [-124.14201, 40.69328], [-124.14184, 40.69325], [-124.14175, 40.69317], [-124.14175, 40.69315], [-124.1408, 40.6924], [-124.14079, 40.6925], [-124.14074, 40.69274], [-124.14083, 40.69303], [-124.14104, 40.69323], [-124.14057, 40.69342], [-124.14053, 40.69198], [-124.13941, 40.69246], [-124.1312, 40.69009], [-124.13037, 40.68982], [-124.1215, 40.68448], [-124.12146, 40.68269], [-124.11355, 40.68077], [-124.10809, 40.6787], [-124.10786, 40.6787], [-124.10721, 40.67735], [-124.0988, 40.67462], [-124.09604, 40.67387], [-124.09406, 40.67463], [-124.09347, 40.67584], [-124.08834, 40.67698], [-124.08359, 40.67528], [-124.08359, 40.67524], [-124.07786, 40.67485], [-124.07651, 40.67401], [-124.07441, 40.67364], [-124.07124, 40.6721], [-124.06831, 40.6679], [-124.06471, 40.66617], [-124.0647, 40.66617], [-124.0647, 40.6662], [-124.06468, 40.66621], [-124.06319, 40.6653], [-124.05956, 40.66442], [-124.05778, 40.66229], [-124.05384, 40.65824], [-124.05365, 40.65509], [-124.05002, 40.6541], [-124.04946, 40.65278], [-124.04812, 40.65258], [-124.0477, 40.65187], [-124.04497, 40.65101], [-124.04491, 40.6495], [-124.04189, 40.64952], [-124.04106, 40.64851], [-124.04073, 40.64823], [-124.03978, 40.648], [-124.03632, 40.64835], [-124.02927, 40.64745], [-124.03058, 40.63728], [-124.02908, 40.63553], [-124.02749, 40.63464], [-124.02498, 40.63367], [-124.02012, 40.63067], [-124.02289, 40.62734], [-124.02636, 40.62391], [-124.02952, 40.6237], [-124.03035, 40.62414], [-124.0314, 40.62386], [-124.03149, 40.62163], [-124.03431, 40.62178], [-124.0349, 40.62231], [-124.03653, 40.62122], [-124.03747, 40.6213], [-124.03813, 40.6188], [-124.04011, 40.61761], [-124.04263, 40.61339], [-124.04458, 40.61226], [-124.04459, 40.6127], [-124.0446, 40.61271], [-124.05363, 40.61225], [-124.05809, 40.6085], [-124.05947, 40.60912], [-124.06172, 40.60889], [-124.06364, 40.60903], [-124.06361, 40.60599], [-124.06804, 40.60592], [-124.06818, 40.60858], [-124.06892, 40.60908], [-124.06935, 40.61206], [-124.07123, 40.61266], [-124.07203, 40.6147], [-124.07427, 40.6156], [-124.07464, 40.61645], [-124.07765, 40.61879], [-124.08288, 40.61806], [-124.08893, 40.61992], [-124.09223, 40.62186], [-124.09333, 40.62235], [-124.09552, 40.62446], [-124.09889, 40.62474], [-124.10109, 40.62456], [-124.10608, 40.62589], [-124.11182, 40.62545], [-124.11188, 40.6276], [-124.11191, 40.62761], [-124.11131, 40.64262], [-124.10174, 40.64225], [-124.10166, 40.64898], [-124.10191, 40.65658], [-124.10231, 40.66392], [-124.10343, 40.67117], [-124.10615, 40.6712], [-124.10602, 40.67272], [-124.1088, 40.67387], [-124.11149, 40.67583], [-124.11218, 40.67742], [-124.11561, 40.67875], [-124.11596, 40.67875], [-124.11815, 40.67964], [-124.1214, 40.68025], [-124.12141, 40.68024], [-124.12138, 40.67879], [-124.13117, 40.68583], [-124.13949, 40.68965], [-124.14155, 40.68971], [-124.14739, 40.69182], [-124.14742, 40.69347]], [[-124.09275, 40.67312], [-124.09494, 40.67244], [-124.09639, 40.67249], [-124.0964, 40.67248], [-124.08994, 40.66756], [-124.08528, 40.66692], [-124.08296, 40.66327], [-124.08295, 40.66294], [-124.08063, 40.65854], [-124.07603, 40.65701], [-124.06997, 40.65189], [-124.06773, 40.64819], [-124.06452, 40.64798], [-124.06454, 40.64939], [-124.064, 40.64939], [-124.05629, 40.64394], [-124.04659, 40.64056], [-124.04485, 40.63975], [-124.04491, 40.64863], [-124.05539, 40.65476], [-124.05584, 40.65772], [-124.06019, 40.66206], [-124.06478, 40.66376], [-124.06478, 40.66394], [-124.06676, 40.66461], [-124.07068, 40.66745], [-124.07235, 40.67098], [-124.07617, 40.67265], [-124.07829, 40.67329], [-124.0835, 40.67367], [-124.08351, 40.67365], [-124.08626, 40.67453], [-124.08786, 40.67522], [-124.09141, 40.67419], [-124.09275, 40.67312]]]} | Restricted Access 2 | 29210 | Headwaters Forest Reserve | 29960 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | http://www.blm.gov/ca/st/en/prog/nlcs/Headwaters_ForestReserve.html | Humboldt 45 | 7609.194 | Headwaters Forest Reserve | 0 | State Conservation Area 8 | 2 |
| 6676 | 6676 | 6675 | {"type": "Polygon", "coordinates": [[[-117.1779, 33.42839], [-117.1779, 33.43232], [-117.17339, 33.43239], [-117.17327, 33.42847], [-117.1779, 33.42839]]]} | Restricted Access 2 | 5517 | Santa Margarita Ecological Reserve | 33342 | 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 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 45.762 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
| 8388 | 8388 | 8387 | {"type": "MultiPolygon", "coordinates": [[[[-122.15612, 38.5114], [-122.15602, 38.51461], [-122.13849, 38.5146], [-122.13848, 38.51219], [-122.13854, 38.50977], [-122.13865, 38.50359], [-122.15197, 38.50368], [-122.15222, 38.50001], [-122.15555, 38.49999], [-122.1556, 38.50362], [-122.15219, 38.50368], [-122.15195, 38.5111], [-122.15604, 38.51137], [-122.15612, 38.5114]]], [[[-122.14395, 38.48911], [-122.13942, 38.48915], [-122.13932, 38.48613], [-122.13918, 38.48221], [-122.14358, 38.48228], [-122.14395, 38.48911]]], [[[-122.15728, 38.48585], [-122.15276, 38.48591], [-122.15247, 38.48241], [-122.15699, 38.48233], [-122.15728, 38.48585]]]]} | Restricted Access 2 | 48483 | Quail Ridge Reserve | 33192 | 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 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/quail-ridge-reserve/ | Napa 11 | 529.199 | Quail Ridge Reserve | 0 | State Conservation Area 8 | 2 |
| 15052 | 15052 | 15051 | {"type": "MultiPolygon", "coordinates": [[[[-117.25255, 33.80464], [-117.24993, 33.80461], [-117.24825, 33.80463], [-117.24827, 33.80108], [-117.25252, 33.80114], [-117.25255, 33.80464]]], [[[-117.26585, 33.81556], [-117.26585, 33.81919], [-117.26149, 33.81923], [-117.26146, 33.81559], [-117.26585, 33.81556]]]]} | Restricted Access 2 | 48493 | Motte Rimrock Reserve | 22519 | 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 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/motte-rimrock-reserve/ | Riverside 10 | 78.529 | Motte Rimrock Reserve | 0 | State Conservation Area 8 | 2 |
| 15568 | 15568 | 15567 | {"type": "MultiPolygon", "coordinates": [[[[-117.15855, 33.46486], [-117.15421, 33.46507], [-117.14524, 33.46588], [-117.14538, 33.46928], [-117.14494, 33.46886], [-117.14213, 33.46585], [-117.13783, 33.46151], [-117.1408, 33.46153], [-117.14069, 33.45434], [-117.13656, 33.45432], [-117.13646, 33.45406], [-117.13637, 33.45348], [-117.1363, 33.45254], [-117.13632, 33.44932], [-117.13637, 33.4487], [-117.13646, 33.448], [-117.13653, 33.44776], [-117.13676, 33.44716], [-117.15344, 33.4472], [-117.15396, 33.4616], [-117.1584, 33.46141], [-117.15855, 33.46486]]], [[[-117.20649, 33.43578], [-117.20644, 33.44303], [-117.19756, 33.44297], [-117.1975, 33.44657], [-117.19305, 33.44653], [-117.19309, 33.44294], [-117.18865, 33.44291], [-117.18876, 33.43575], [-117.19321, 33.43576], [-117.19316, 33.43934], [-117.19759, 33.43937], [-117.19765, 33.43577], [-117.20649, 33.43578]]]]} | Restricted Access 2 | 5509 | Santa Margarita Ecological Reserve | 33342 | 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 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | Riverside 10 | 1078.683 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
| 16783 | 16783 | 16782 | {"type": "MultiPolygon", "coordinates": [[[[-120.39365, 40.28935], [-120.39365, 40.2929], [-120.38889, 40.29292], [-120.38889, 40.28943], [-120.39365, 40.28935]]], [[[-120.40789, 40.2928], [-120.40788, 40.29639], [-120.40316, 40.29643], [-120.40318, 40.30006], [-120.39846, 40.30008], [-120.39839, 40.29287], [-120.40789, 40.2928]]], [[[-120.38413, 40.28701], [-120.38412, 40.28953], [-120.36995, 40.28987], [-120.37007, 40.29317], [-120.37015, 40.30042], [-120.36069, 40.30062], [-120.36057, 40.29343], [-120.35116, 40.29341], [-120.35096, 40.30073], [-120.34179, 40.30076], [-120.34177, 40.29732], [-120.34169, 40.29354], [-120.34648, 40.29347], [-120.35177, 40.29286], [-120.36512, 40.29112], [-120.36917, 40.29015], [-120.37056, 40.2892], [-120.3746, 40.28835], [-120.37935, 40.28756], [-120.37998, 40.2873], [-120.38387, 40.28701], [-120.38413, 40.28701]]], [[[-120.33755, 40.30386], [-120.33553, 40.30225], [-120.33367, 40.30414], [-120.33031, 40.30184], [-120.33717, 40.2974], [-120.33755, 40.30386]]], [[[-120.40334, 40.31103], [-120.39861, 40.31109], [-120.39877, 40.32185], [-120.38986, 40.32196], [-120.38937, 40.30745], [-120.39855, 40.30742], [-120.40327, 40.30735], [-120.40334, 40.31103]]]]} | Open Access 1 | 29209 | Honey Lake Wildlife Area | 30454 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Honey-Lake-WA | Lassen 54 | 1014.534 | Honey Lake Wildlife Area | 1953 | State Conservation Area 8 | 2 |
| 16994 | 16994 | 16993 | {"type": "Polygon", "coordinates": [[[-115.66703, 34.62486], [-115.66657, 34.6463], [-115.6658, 34.64635], [-115.66576, 34.66042], [-115.66559, 34.66042], [-115.66559, 34.66059], [-115.6656, 34.6606], [-115.66576, 34.66059], [-115.66577, 34.66074], [-115.66626, 34.6607], [-115.66533, 34.70415], [-115.65997, 34.70529], [-115.65749, 34.70532], [-115.64685, 34.70309], [-115.63455, 34.70275], [-115.6319, 34.7025], [-115.63217, 34.68946], [-115.61509, 34.6895], [-115.61478, 34.70057], [-115.56321, 34.69101], [-115.56468, 34.6604], [-115.58174, 34.66045], [-115.58217, 34.64588], [-115.56456, 34.64577], [-115.56455, 34.64589], [-115.56436, 34.64589], [-115.56436, 34.64575], [-115.47846, 34.64556], [-115.47848, 34.64511], [-115.47847, 34.6451], [-115.46103, 34.64563], [-115.46152, 34.58392], [-115.4617, 34.58405], [-115.47747, 34.5728], [-115.47922, 34.57281], [-115.47923, 34.5727], [-115.48788, 34.57261], [-115.48798, 34.56926], [-115.48806, 34.56561], [-115.49701, 34.55839], [-115.51456, 34.55844], [-115.51454, 34.56278], [-115.51448, 34.56938], [-115.51438, 34.5731], [-115.53183, 34.57324], [-115.53192, 34.56946], [-115.55022, 34.56967], [-115.5504, 34.57333], [-115.55902, 34.57335], [-115.55876, 34.56599], [-115.56316, 34.56599], [-115.56317, 34.56598], [-115.56301, 34.56235], [-115.55863, 34.56233], [-115.5585, 34.55884], [-115.56723, 34.55891], [-115.56679, 34.57338], [-115.5664, 34.58767], [-115.56641, 34.58768], [-115.58388, 34.58772], [-115.58447, 34.5697], [-115.58478, 34.55905], [-115.61871, 34.5593], [-115.61832, 34.57341], [-115.61833, 34.57342], [-115.63534, 34.57348], [-115.63576, 34.55923], [-115.64155, 34.55926], [-115.64159, 34.55947], [-115.64347, 34.57353], [-115.63535, 34.57349], [-115.63493, 34.58782], [-115.64661, 34.5879], [-115.66703, 34.62486]], [[-115.54964, 34.604], [-115.55447, 34.604], [-115.55451, 34.6007], [-115.55446, 34.59904], [-115.54928, 34.59906], [-115.54452, 34.59902], [-115.54452, 34.60216], [-115.53138, 34.60212], [-115.53159, 34.59497], [-115.52273, 34.59494], [-115.52243, 34.60207], [-115.51389, 34.60205], [-115.51352, 34.61654], [-115.54934, 34.61664], [-115.54964, 34.604]], [[-115.52025, 34.60039], [-115.5204, 34.59678], [-115.51593, 34.59673], [-115.51579, 34.60036], [-115.52025, 34.60039]], [[-115.55039, 34.57334], [-115.55038, 34.57333], [-115.53185, 34.57324], [-115.53159, 34.58403], [-115.53152, 34.5875], [-115.53154, 34.58752], [-115.54997, 34.5876], [-115.55039, 34.57334]], [[-115.63406, 34.61698], [-115.63448, 34.60252], [-115.6175, 34.60247], [-115.61711, 34.61699], [-115.63406, 34.61698]], [[-115.65133, 34.61716], [-115.65132, 34.61715], [-115.63407, 34.61698], [-115.63365, 34.63134], [-115.65093, 34.63166], [-115.65095, 34.63138], [-115.65133, 34.61716]]]} | Open Access 1 | 25323 | Marble Mountains Wildlife Area | 30470 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 46326.696 | Marble Mtns. Wildlife Area | 1989 | State Conservation Area 8 | 2 |
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]);