units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where AGNCY_NAME = 369, MNG_AGENCY = 25 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, YR_EST
MNG_AG_TYP 1
- State Agency · 5 ✖
MNG_AGENCY 1
- California Department of Fish and Wildlife · 5 ✖
DES_TP 1
ACCESS_TYP 1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11157 | 11157 | 11156 | {"type": "MultiPolygon", "coordinates": [[[[-122.18969, 38.55608], [-122.1896, 38.55707], [-122.18876, 38.55739], [-122.18861, 38.55762], [-122.188, 38.55801], [-122.18723, 38.55821], [-122.18857, 38.557], [-122.18848, 38.55679], [-122.18724, 38.55711], [-122.18612, 38.55567], [-122.18534, 38.55541], [-122.18131, 38.55543], [-122.18095, 38.55556], [-122.18095, 38.55544], [-122.17903, 38.55538], [-122.17351, 38.55414], [-122.17131, 38.55684], [-122.16983, 38.55641], [-122.16986, 38.5518], [-122.16297, 38.55159], [-122.16256, 38.55156], [-122.16091, 38.55046], [-122.16134, 38.54949], [-122.16278, 38.54602], [-122.16, 38.54578], [-122.15902, 38.54444], [-122.1575, 38.54245], [-122.15859, 38.5404], [-122.15812, 38.53634], [-122.15739, 38.53213], [-122.15127, 38.53355], [-122.14376, 38.53488], [-122.14519, 38.53838], [-122.1456, 38.53946], [-122.14571, 38.54606], [-122.14417, 38.54679], [-122.13998, 38.54297], [-122.13933, 38.54236], [-122.13962, 38.53936], [-122.13837, 38.539], [-122.13647, 38.53837], [-122.13561, 38.53332], [-122.13391, 38.5343], [-122.13224, 38.53816], [-122.12988, 38.53817], [-122.12996, 38.53614], [-122.13007, 38.53218], [-122.13103, 38.53216], [-122.13194, 38.52876], [-122.12917, 38.52873], [-122.12908, 38.52724], [-122.13169, 38.52647], [-122.13222, 38.52531], [-122.1257, 38.52528], [-122.12568, 38.52495], [-122.12426, 38.52479], [-122.12365, 38.52588], [-122.12236, 38.5259], [-122.12121, 38.52452], [-122.12162, 38.52176], [-122.11727, 38.52173], [-122.11727, 38.51822], [-122.11722, 38.51778], [-122.10757, 38.51574], [-122.10759, 38.51438], [-122.10782, 38.51444], [-122.10904, 38.51487], [-122.10939, 38.51465], [-122.1107, 38.51467], [-122.11161, 38.51483], [-122.11271, 38.51492], [-122.11394, 38.51538], [-122.11449, 38.51511], [-122.11484, 38.51513], [-122.11554, 38.51534], [-122.11592, 38.51573], [-122.11691, 38.51566], [-122.11764, 38.51596], [-122.11793, 38.51632], [-122.11785, 38.51714], [-122.11819, 38.51714], [-122.11857, 38.51699], [-122.11927, 38.51714], [-122.11979, 38.51767], [-122.11976, 38.51792], [-122.11953, 38.51817], [-122.1188, 38.51866], [-122.11872, 38.51895], [-122.11921, 38.51936], [-122.11971, 38.51939], [-122.12134, 38.5193], [-122.12157, 38.51993], [-122.12183, 38.52012], [-122.12239, 38.52039], [-122.12326, 38.52078], [-122.1239, 38.52112], [-122.12492, 38.5212], [-122.12504, 38.52152], [-122.12373, 38.52248], [-122.123, 38.52277], [-122.12317, 38.52319], [-122.12277, 38.5238], [-122.12242, 38.52415], [-122.12259, 38.52445], [-122.12285, 38.52478], [-122.12381, 38.52385], [-122.1246, 38.52341], [-122.12556, 38.52309], [-122.12609, 38.52289], [-122.12658, 38.52325], [-122.12734, 38.52317], [-122.12792, 38.52351], [-122.12795, 38.52387], [-122.12821, 38.52405], [-122.12912, 38.5239], [-122.12958, 38.52389], [-122.13008, 38.52412], [-122.13113, 38.52424], [-122.13171, 38.5246], [-122.13223, 38.52456], [-122.13267, 38.52397], [-122.13337, 38.5236], [-122.1341, 38.52355], [-122.13439, 38.52325], [-122.13483, 38.52303], [-122.13497, 38.52275], [-122.13547, 38.52246], [-122.13605, 38.52238], [-122.13608, 38.52197], [-122.13631, 38.52175], [-122.13669, 38.52165], [-122.13756, 38.52167], [-122.13762, 38.52126], [-122.13786, 38.52099], [-122.13824, 38.52099], [-122.13859, 38.52113], [-122.13902, 38.52165], [-122.13911, 38.52222], [-122.13966, 38.52307], [-122.13966, 38.52445], [-122.13926, 38.52483], [-122.13882, 38.52472], [-122.13829, 38.52463], [-122.13806, 38.52486], [-122.1376, 38.52522], [-122.13733, 38.52568], [-122.13698, 38.52573], [-122.13678, 38.52623], [-122.13628, 38.52614], [-122.13573, 38.52618], [-122.13564, 38.5268], [-122.13602, 38.52726], [-122.13582, 38.52774], [-122.13547, 38.52785], [-122.13465, 38.52783], [-122.13279, 38.52751], [-122.13186, 38.52763], [-122.13154, 38.52807], [-122.13155, 38.52809], [-122.13261, 38.52825], [-122.13433, 38.52884], [-122.13454, 38.52909], [-122.13422, 38.52978], [-122.13384, 38.53044], [-122.13311, 38.53166], [-122.13241, 38.53221], [-122.13206, 38.5328], [-122.13168, 38.5331], [-122.13148, 38.53376], [-122.13116, 38.5344], [-122.13122, 38.53652], [-122.13123, 38.53653], [-122.13159, 38.53639], [-122.13174, 38.53467], [-122.13238, 38.53388], [-122.13314, 38.53305], [-122.13363, 38.5328], [-122.13399, 38.53271], [-122.13474, 38.5323], [-122.13489, 38.53172], [-122.13521, 38.53124], [-122.13567, 38.53081], [-122.13591, 38.53019], [-122.13637, 38.53], [-122.13643, 38.52964], [-122.13664, 38.52939], [-122.13725, 38.52927], [-122.13751, 38.52891], [-122.13771, 38.52841], [-122.13792, 38.52813], [-122.13853, 38.52795], [-122.13888, 38.52795], [-122.13897, 38.52868], [-122.13899, 38.5293], [-122.13876, 38.52994], [-122.13838, 38.53039], [-122.13832, 38.53083], [-122.13781, 38.53127], [-122.13809, 38.53149], [-122.13914, 38.53149], [-122.13969, 38.53161], [-122.13975, 38.53202], [-122.14004, 38.53234], [-122.14004, 38.53264], [-122.13946, 38.53326], [-122.13958, 38.53369], [-122.13943, 38.53504], [-122.13894, 38.53525], [-122.13743, 38.53552], [-122.13737, 38.53584], [-122.13937, 38.536], [-122.13984, 38.53621], [-122.13996, 38.53699], [-122.1397, 38.53738], [-122.13841, 38.53745], [-122.1379, 38.53806], [-122.13897, 38.53804], [-122.13935, 38.53834], [-122.13975, 38.53822], [-122.14048, 38.53827], [-122.14124, 38.53935], [-122.14127, 38.53983], [-122.14159, 38.54029], [-122.14147, 38.54072], [-122.14069, 38.54102], [-122.14077, 38.54147], [-122.14075, 38.54186], [-122.1415, 38.54159], [-122.14194, 38.54184], [-122.14238, 38.54216], [-122.1425, 38.54296], [-122.14299, 38.54328], [-122.14349, 38.54385], [-122.14334, 38.54451], [-122.14357, 38.5449], [-122.14401, 38.54483], [-122.14418, 38.54404], [-122.14398, 38.54365], [-122.14395, 38.54283], [-122.14375, 38.54257], [-122.1436, 38.54216], [-122.14314, 38.54181], [-122.1429, 38.54136], [-122.14279, 38.54095], [-122.14281, 38.54031], [-122.14311, 38.5401], [-122.14359, 38.53987], [-122.14258, 38.53923], [-122.14258, 38.53893], [-122.14295, 38.53843], [-122.14214, 38.53802], [-122.14185, 38.53774], [-122.14211, 38.53705], [-122.14232, 38.53671], [-122.14174, 38.53625], [-122.14156, 38.53586], [-122.14165, 38.53433], [-122.14188, 38.53415], [-122.14194, 38.53374], [-122.14229, 38.53346], [-122.14398, 38.53348], [-122.14447, 38.53355], [-122.14511, 38.53387], [-122.14549, 38.53348], [-122.14587, 38.53328], [-122.14681, 38.53325], [-122.14739, 38.53337], [-122.14803, 38.53325], [-122.14949, 38.53319], [-122.15036, 38.533], [-122.15112, 38.5331], [-122.15173, 38.53275], [-122.15292, 38.5325], [-122.15307, 38.53218], [-122.15342, 38.53197], [-122.15415, 38.53195], [-122.15479, 38.53213], [-122.15563, 38.53193], [-122.15563, 38.53099], [-122.15601, 38.53049], [-122.15663, 38.53053], [-122.15706, 38.5303], [-122.15747, 38.53], [-122.15843, 38.53], [-122.15893, 38.53017], [-122.15905, 38.53044], [-122.16018, 38.53083], [-122.16079, 38.53119], [-122.16073, 38.53151], [-122.16041, 38.53204], [-122.16041, 38.53206], [-122.16184, 38.5319], [-122.16202, 38.53215], [-122.16167, 38.53236], [-122.16003, 38.53271], [-122.1598, 38.53302], [-122.15937, 38.5333], [-122.15957, 38.53367], [-122.15943, 38.53435], [-122.15978, 38.53458], [-122.16001, 38.53438], [-122.16024, 38.53382], [-122.16071, 38.5335], [-122.16149, 38.53323], [-122.16196, 38.53335], [-122.16181, 38.53383], [-122.16181, 38.53435], [-122.16196, 38.53485], [-122.16158, 38.53524], [-122.16167, 38.5357], [-122.16141, 38.536], [-122.16047, 38.53614], [-122.16025, 38.53645], [-122.16056, 38.53667], [-122.16202, 38.53689], [-122.16254, 38.53714], [-122.16254, 38.53744], [-122.16211, 38.53762], [-122.16164, 38.53767], [-122.16129, 38.53792], [-122.16077, 38.5381], [-122.16031, 38.53815], [-122.1603, 38.53897], [-122.16152, 38.53879], [-122.16205, 38.53882], [-122.16231, 38.53898], [-122.16231, 38.53939], [-122.16193, 38.53975], [-122.16083, 38.54017], [-122.16089, 38.54042], [-122.16219, 38.54042], [-122.1626, 38.54053], [-122.16289, 38.54092], [-122.16278, 38.54181], [-122.16295, 38.54204], [-122.16298, 38.54252], [-122.16304, 38.54307], [-122.16319, 38.5433], [-122.16307, 38.54369], [-122.16231, 38.54396], [-122.16129, 38.5438], [-122.16062, 38.54321], [-122.1594, 38.54275], [-122.15899, 38.54275], [-122.15888, 38.54303], [-122.16027, 38.54378], [-122.16068, 38.5441], [-122.1608, 38.54472], [-122.16081, 38.54501], [-122.16164, 38.54483], [-122.16246, 38.54492], [-122.16336, 38.54483], [-122.16392, 38.5454], [-122.16415, 38.54593], [-122.16438, 38.5463], [-122.16436, 38.54667], [-122.16505, 38.5473], [-122.16476, 38.54751], [-122.16396, 38.54783], [-122.16396, 38.54784], [-122.16421, 38.54801], [-122.16584, 38.54799], [-122.16605, 38.54836], [-122.1657, 38.54875], [-122.165, 38.54906], [-122.16476, 38.54943], [-122.16441, 38.54966], [-122.16288, 38.55012], [-122.16299, 38.55042], [-122.16441, 38.55031], [-122.16531, 38.5504], [-122.16538, 38.55005], [-122.16631, 38.54943], [-122.16698, 38.54911], [-122.1673, 38.54905], [-122.16762, 38.54923], [-122.16783, 38.54982], [-122.16844, 38.54962], [-122.16954, 38.5498], [-122.16969, 38.55017], [-122.16992, 38.55046], [-122.17033, 38.5501], [-122.1708, 38.55007], [-122.17124, 38.55035], [-122.17258, 38.55149], [-122.17255, 38.55186], [-122.17197, 38.5525], [-122.17153, 38.55341], [-122.17115, 38.55401], [-122.17133, 38.55447], [-122.17165, 38.55439], [-122.17185, 38.55392], [-122.17226, 38.55348], [-122.17246, 38.55307], [-122.1729, 38.55273], [-122.17328, 38.55259], [-122.17418, 38.55261], [-122.17575, 38.55302], [-122.17625, 38.55305], [-122.1766, 38.55336], [-122.17686, 38.55368], [-122.17718, 38.55357], [-122.17736, 38.55325], [-122.17768, 38.5533], [-122.1796, 38.55419], [-122.1801, 38.55401], [-122.18051, 38.55419], [-122.18083, 38.55417], [-122.1813, 38.5541], [-122.18193, 38.5541], [-122.18232, 38.55378], [-122.18342, 38.55387], [-122.18403, 38.55364], [-122.18444, 38.55364], [-122.18522, 38.55377], [-122.18537, 38.55272], [-122.18607, 38.5525], [-122.18686, 38.55268], [-122.18683, 38.55297], [-122.18637, 38.55348], [-122.18672, 38.55396], [-122.18663, 38.55441], [-122.18721, 38.55476], [-122.18739, 38.55501], [-122.18754, 38.55551], [-122.18785, 38.5554], [-122.18809, 38.5551], [-122.18823, 38.5541], [-122.18803, 38.55386], [-122.18806, 38.55323], [-122.18832, 38.55302], [-122.18896, 38.55318], [-122.18951, 38.55375], [-122.18951, 38.55444], [-122.18934, 38.55542], [-122.18969, 38.55608]]], [[[-122.19277, 38.56265], [-122.19244, 38.56234], [-122.18938, 38.56216], [-122.18937, 38.56217], [-122.19031, 38.56398], [-122.18978, 38.56547], [-122.18757, 38.56603], [-122.18294, 38.56622], [-122.18267, 38.56437], [-122.18322, 38.56378], [-122.18309, 38.56399], [-122.18309, 38.56401], [-122.18346, 38.56396], [-122.18384, 38.56378], [-122.1841, 38.56353], [-122.18433, 38.56254], [-122.18605, 38.56234], [-122.1864, 38.56259], [-122.18672, 38.5632], [-122.18727, 38.56329], [-122.18725, 38.56293], [-122.1871, 38.5627], [-122.18725, 38.56234], [-122.18739, 38.56206], [-122.18722, 38.56178], [-122.18719, 38.5613], [-122.18774, 38.56073], [-122.18853, 38.56007], [-122.18879, 38.55991], [-122.18926, 38.56], [-122.18949, 38.56023], [-122.18953, 38.56112], [-122.19045, 38.56096], [-122.19086, 38.56098], [-122.19182, 38.56176], [-122.19223, 38.56219], [-122.19276, 38.56247], [-122.19277, 38.56265]]], [[[-122.20486, 38.59141], [-122.20463, 38.59169], [-122.20377, 38.59188], [-122.20379, 38.59084], [-122.19974, 38.5881], [-122.19873, 38.58713], [-122.19285, 38.58165], [-122.19416, 38.58049], [-122.19001, 38.57598], [-122.19071, 38.57163], [-122.19052, 38.57108], [-122.19117, 38.56904], [-122.19184, 38.56919], [-122.19183, 38.56945], [-122.19203, 38.56966], [-122.19166, 38.57002], [-122.19151, 38.57028], [-122.1909, 38.5708], [-122.1909, 38.57107], [-122.19128, 38.57103], [-122.19207, 38.57046], [-122.19259, 38.57025], [-122.19306, 38.57027], [-122.19317, 38.57057], [-122.19315, 38.57132], [-122.19338, 38.57165], [-122.19382, 38.5721], [-122.19379, 38.57245], [-122.19333, 38.57295], [-122.19411, 38.57313], [-122.1944, 38.57334], [-122.19464, 38.57389], [-122.1949, 38.57416], [-122.19513, 38.57485], [-122.19615, 38.57583], [-122.1963, 38.57632], [-122.19691, 38.57661], [-122.19717, 38.577], [-122.19729, 38.57762], [-122.1968, 38.5781], [-122.19607, 38.57835], [-122.19497, 38.57847], [-122.19511, 38.57874], [-122.19557, 38.57904], [-122.19514, 38.58018], [-122.19549, 38.58016], [-122.19601, 38.57975], [-122.19633, 38.57984], [-122.1968, 38.57941], [-122.19741, 38.57901], [-122.19779, 38.57897], [-122.19825, 38.57908], [-122.19855, 38.57936], [-122.19866, 38.57961], [-122.19875, 38.58], [-122.19896, 38.58032], [-122.19896, 38.58071], [-122.19858, 38.58105], [-122.19855, 38.58155], [-122.19916, 38.58181], [-122.19916, 38.58206], [-122.19902, 38.58229], [-122.19937, 38.58288], [-122.1994, 38.58405], [-122.19911, 38.58435], [-122.19928, 38.58485], [-122.19951, 38.58537], [-122.20086, 38.5857], [-122.20141, 38.58627], [-122.20144, 38.58664], [-122.20255, 38.58741], [-122.20261, 38.58773], [-122.20287, 38.58803], [-122.20287, 38.58862], [-122.20334, 38.58869], [-122.20381, 38.58892], [-122.20404, 38.58924], [-122.20398, 38.58958], [-122.20384, 38.59009], [-122.20457, 38.59094], [-122.20486, 38.59141]]], [[[-122.26964, 38.67788], [-122.26865, 38.67853], [-122.2678, 38.679], [-122.26613, 38.67962], [-122.26461, 38.68014], [-122.26405, 38.68049], [-122.26391, 38.68068], [-122.26384, 38.68081], [-122.26379, 38.68097], [-122.26377, 38.68155], [-122.26353, 38.68159], [-122.26338, 38.68164], [-122.26309, 38.68168], [-122.26294, 38.68133], [-122.26283, 38.68096], [-122.26259, 38.68058], [-122.26061, 38.67827], [-122.2605, 38.67807], [-122.25949, 38.67428], [-122.25947, 38.6741], [-122.26005, 38.67279], [-122.26078, 38.673], [-122.26091, 38.67261], [-122.2599, 38.67245], [-122.25911, 38.67317], [-122.25896, 38.67327], [-122.25878, 38.67329], [-122.25724, 38.67322], [-122.25596, 38.67315], [-122.25579, 38.67313], [-122.25563, 38.67308], [-122.25552, 38.67301], [-122.25542, 38.6729], [-122.25537, 38.67277], [-122.25527, 38.67226], [-122.255, 38.67165], [-122.25427, 38.6691], [-122.25199, 38.66725], [-122.24951, 38.66523], [-122.2494, 38.66509], [-122.24917, 38.66466], [-122.24908, 38.66443], [-122.24908, 38.66422], [-122.24915, 38.66403], [-122.2499, 38.66311], [-122.25002, 38.66293], [-122.25006, 38.66283], [-122.25005, 38.66263], [-122.24948, 38.66125], [-122.24926, 38.66097], [-122.24719, 38.65891], [-122.24698, 38.6586], [-122.24692, 38.65843], [-122.24691, 38.65829], [-122.24694, 38.65816], [-122.24734, 38.65733], [-122.24733, 38.65716], [-122.24708, 38.65617], [-122.2466, 38.65461], [-122.24659, 38.65445], [-122.24663, 38.65407], [-122.24663, 38.65386], [-122.24661, 38.65373], [-122.24646, 38.65343], [-122.24647, 38.65318], [-122.24628, 38.65285], [-122.24603, 38.65259], [-122.24586, 38.65254], [-122.24556, 38.6525], [-122.24522, 38.65244], [-122.24468, 38.65242], [-122.24444, 38.65236], [-122.24424, 38.65227], [-122.24413, 38.65214], [-122.24402, 38.65199], [-122.24352, 38.65078], [-122.24312, 38.64985], [-122.24278, 38.64893], [-122.24272, 38.64869], [-122.24276, 38.64844], [-122.24282, 38.64833], [-122.24286, 38.64815], [-122.24006, 38.64607], [-122.23995, 38.64598], [-122.23986, 38.64585], [-122.23982, 38.64576], [-122.23962, 38.64506], [-122.23954, 38.64488], [-122.2395, 38.64482], [-122.23938, 38.64474], [-122.23901, 38.64454], [-122.23858, 38.64434], [-122.23851, 38.64427], [-122.23847, 38.64419], [-122.23845, 38.64406], [-122.2385, 38.64386], [-122.23858, 38.64364], [-122.23855, 38.64352], [-122.23847, 38.64345], [-122.23738, 38.64281], [-122.23676, 38.64242], [-122.23665, 38.64234], [-122.23653, 38.64218], [-122.23649, 38.6421], [-122.23648, 38.64201], [-122.23649, 38.64188], [-122.23675, 38.64065], [-122.2368, 38.64053], [-122.23686, 38.64044], [-122.23717, 38.64009], [-122.23733, 38.63984], [-122.23738, 38.63972], [-122.23736, 38.63953], [-122.23729, 38.63941], [-122.23721, 38.63933], [-122.2366, 38.63884], [-122.2363, 38.63863], [-122.23617, 38.63851], [-122.23608, 38.63835], [-122.23441, 38.63471], [-122.23424, 38.63444], [-122.23405, 38.63406], [-122.23386, 38.63359], [-122.23382, 38.63336], [-122.23384, 38.63324], [-122.23389, 38.6331], [-122.23399, 38.63296], [-122.23399, 38.63292], [-122.23403, 38.63273], [-122.23401, 38.63259], [-122.23367, 38.63174], [-122.2331, 38.6302], [-122.2324, 38.62849], [-122.23221, 38.62802], [-122.232, 38.62741], [-122.23194, 38.62731], [-122.23181, 38.62719], [-122.23167, 38.62711], [-122.2297, 38.62634], [-122.22951, 38.62625], [-122.22944, 38.6262], [-122.22936, 38.62604], [-122.22935, 38.62599], [-122.22938, 38.62583], [-122.2295, 38.62558], [-122.22951, 38.62542], [-122.22949, 38.62532], [-122.22944, 38.62524], [-122.22936, 38.62514], [-122.22899, 38.62484], [-122.22845, 38.62445], [-122.22827, 38.62427], [-122.22765, 38.62311], [-122.22722, 38.62249], [-122.22712, 38.62238], [-122.22698, 38.62229], [-122.22683, 38.62223], [-122.22659, 38.6222], [-122.2244, 38.62212], [-122.22404, 38.6221], [-122.22395, 38.62208], [-122.22379, 38.62194], [-122.2237, 38.62177], [-122.2237, 38.62168], [-122.22379, 38.62153], [-122.22447, 38.62107], [-122.22462, 38.62094], [-122.22472, 38.62082], [-122.22475, 38.62075], [-122.22477, 38.62056], [-122.2244, 38.61988], [-122.22406, 38.6192], [-122.2236, 38.61932], [-122.22363, 38.61882], [-122.22313, 38.61845], [-122.22228, 38.61776], [-122.22149, 38.61707], [-122.22074, 38.61638], [-122.21779, 38.61393], [-122.21752, 38.61091], [-122.2162, 38.60664], [-122.20991, 38.6035], [-122.21067, 38.59918], [-122.21081, 38.59815], [-122.20372, 38.59412], [-122.20377, 38.59201], [-122.20448, 38.5924], [-122.20435, 38.59297], [-122.20472, 38.59299], [-122.20544, 38.59238], [-122.20605, 38.59245], [-122.20608, 38.59286], [-122.20493, 38.59361], [-122.20577, 38.59391], [-122.20668, 38.59453], [-122.2067, 38.59452], [-122.20658, 38.59393], [-122.20687, 38.59368], [-122.20781, 38.59409], [-122.20822, 38.59446], [-122.20857, 38.59437], [-122.20903, 38.59464], [-122.20953, 38.5948], [-122.20953, 38.59533], [-122.21061, 38.59615], [-122.21081, 38.59684], [-122.21081, 38.59725], [-122.21062, 38.59771], [-122.2116, 38.59814], [-122.21184, 38.59871], [-122.21187, 38.59963], [-122.21195, 38.60011], [-122.2112, 38.60057], [-122.21131, 38.601], [-122.21187, 38.60098], [-122.21225, 38.60107], [-122.21292, 38.6015], [-122.21336, 38.60192], [-122.21348, 38.60217], [-122.21493, 38.60287], [-122.21593, 38.60377], [-122.21712, 38.60457], [-122.21782, 38.60487], [-122.21826, 38.6053], [-122.21861, 38.60539], [-122.21925, 38.60601], [-122.21949, 38.60656], [-122.21949, 38.60684], [-122.22025, 38.60752], [-122.22063, 38.60898], [-122.22063, 38.60983], [-122.22049, 38.6102], [-122.2192, 38.61176], [-122.21923, 38.61203], [-122.21958, 38.6129], [-122.21979, 38.6137], [-122.22008, 38.61395], [-122.2211, 38.61391], [-122.22215, 38.61407], [-122.22332, 38.6147], [-122.22399, 38.61509], [-122.22481, 38.615], [-122.22525, 38.61516], [-122.22569, 38.61566], [-122.22566, 38.61612], [-122.22479, 38.61651], [-122.22476, 38.61678], [-122.22548, 38.61681], [-122.22618, 38.61708], [-122.22671, 38.61752], [-122.22759, 38.61859], [-122.22744, 38.61916], [-122.22669, 38.61908], [-122.22657, 38.61939], [-122.22709, 38.61997], [-122.22709, 38.62056], [-122.22735, 38.62076], [-122.22736, 38.62108], [-122.22718, 38.62134], [-122.22683, 38.62152], [-122.22579, 38.62159], [-122.22576, 38.62186], [-122.22794, 38.62189], [-122.22908, 38.62205], [-122.22966, 38.62228], [-122.23083, 38.62308], [-122.23179, 38.6239], [-122.23232, 38.62477], [-122.23264, 38.6249], [-122.23302, 38.62536], [-122.23276, 38.62584], [-122.23212, 38.62578], [-122.23107, 38.62527], [-122.2308, 38.62491], [-122.23012, 38.62491], [-122.23011, 38.62492], [-122.23031, 38.62529], [-122.23031, 38.62589], [-122.23174, 38.62637], [-122.23256, 38.62676], [-122.23367, 38.62674], [-122.23437, 38.6271], [-122.23419, 38.6276], [-122.23356, 38.62827], [-122.23434, 38.62884], [-122.23429, 38.62925], [-122.23519, 38.6293], [-122.23539, 38.62951], [-122.23531, 38.63046], [-122.2356, 38.63085], [-122.23554, 38.63126], [-122.2347, 38.63159], [-122.23551, 38.63225], [-122.23534, 38.63326], [-122.2352, 38.63369], [-122.23587, 38.63417], [-122.23601, 38.6344], [-122.23598, 38.63472], [-122.23584, 38.63506], [-122.23665, 38.63527], [-122.23742, 38.63602], [-122.23756, 38.63666], [-122.23797, 38.63701], [-122.2385, 38.63783], [-122.2379, 38.63829], [-122.23864, 38.63857], [-122.23897, 38.63898], [-122.23888, 38.63989], [-122.23807, 38.64037], [-122.23815, 38.64078], [-122.23774, 38.64129], [-122.2378, 38.64209], [-122.23772, 38.64254], [-122.23856, 38.6423], [-122.23883, 38.6425], [-122.23918, 38.64343], [-122.23959, 38.64314], [-122.24008, 38.64307], [-122.24046, 38.64337], [-122.24058, 38.64364], [-122.2407, 38.64451], [-122.24073, 38.64519], [-122.24137, 38.64525], [-122.24184, 38.64557], [-122.24266, 38.64621], [-122.24391, 38.64662], [-122.24388, 38.64687], [-122.24362, 38.64723], [-122.24382, 38.64746], [-122.24415, 38.64739], [-122.24447, 38.64687], [-122.24502, 38.64666], [-122.24531, 38.64685], [-122.24563, 38.64744], [-122.24561, 38.64796], [-122.24485, 38.6498], [-122.2448, 38.65028], [-122.24506, 38.65045], [-122.24538, 38.65003], [-122.24578, 38.64936], [-122.24628, 38.64906], [-122.24713, 38.64943], [-122.2473, 38.64991], [-122.2473, 38.65052], [-122.24719, 38.65098], [-122.24742, 38.65128], [-122.24812, 38.65114], [-122.24865, 38.65117], [-122.24981, 38.65171], [-122.25008, 38.65199], [-122.25011, 38.65267], [-122.24976, 38.65279], [-122.24912, 38.65286], [-122.24906, 38.6531], [-122.25023, 38.65346], [-122.2504, 38.65402], [-122.25061, 38.65441], [-122.25108, 38.65483], [-122.25108, 38.65535], [-122.25047, 38.6562], [-122.25108, 38.65648], [-122.25044, 38.65732], [-122.2496, 38.65773], [-122.24971, 38.65802], [-122.25047, 38.65796], [-122.25073, 38.65817], [-122.25108, 38.65869], [-122.25176, 38.65816], [-122.25246, 38.65805], [-122.25275, 38.65821], [-122.25278, 38.65872], [-122.25337, 38.65908], [-122.25336, 38.6594], [-122.2531, 38.65968], [-122.25299, 38.65997], [-122.25304, 38.66031], [-122.25386, 38.66055], [-122.25383, 38.66084], [-122.25349, 38.66121], [-122.25456, 38.66183], [-122.25511, 38.6619], [-122.25543, 38.66208], [-122.2554, 38.66242], [-122.25508, 38.66279], [-122.25511, 38.66309], [-122.25575, 38.66355], [-122.25622, 38.66378], [-122.25619, 38.66405], [-122.25566, 38.66448], [-122.25482, 38.66487], [-122.25411, 38.66476], [-122.25377, 38.66489], [-122.25385, 38.66515], [-122.25446, 38.66538], [-122.25464, 38.6656], [-122.25598, 38.66531], [-122.25642, 38.66535], [-122.25671, 38.66554], [-122.25683, 38.66602], [-122.25773, 38.66657], [-122.2577, 38.66684], [-122.25724, 38.66721], [-122.2577, 38.6679], [-122.25808, 38.66815], [-122.25822, 38.66843], [-122.25817, 38.66874], [-122.25787, 38.66907], [-122.25799, 38.66939], [-122.25881, 38.66936], [-122.25939, 38.66886], [-122.25974, 38.6687], [-122.26024, 38.66879], [-122.25989, 38.66918], [-122.26003, 38.66991], [-122.25997, 38.67042], [-122.25957, 38.67035], [-122.25892, 38.66996], [-122.25796, 38.67014], [-122.25738, 38.67019], [-122.25723, 38.67058], [-122.2568, 38.6711], [-122.25746, 38.67142], [-122.25761, 38.67183], [-122.25837, 38.67158], [-122.25886, 38.67156], [-122.25924, 38.67181], [-122.26102, 38.67191], [-122.2614, 38.67186], [-122.26234, 38.6714], [-122.26304, 38.6715], [-122.26339, 38.67175], [-122.26339, 38.67204], [-122.26295, 38.67246], [-122.2635, 38.67328], [-122.2635, 38.67374], [-122.26295, 38.67376], [-122.26222, 38.6736], [-122.26133, 38.67338], [-122.26132, 38.67339], [-122.26143, 38.67367], [-122.26195, 38.67438], [-122.26259, 38.67484], [-122.26283, 38.67518], [-122.26272, 38.67566], [-122.2637, 38.67592], [-122.26458, 38.67603], [-122.26458, 38.67656], [-122.26396, 38.6769], [-122.26376, 38.67713], [-122.26358, 38.678], [-122.26335, 38.67834], [-122.26314, 38.67937], [-122.26311, 38.68056], [-122.26352, 38.68051], [-122.26396, 38.67864], [-122.26408, 38.67829], [-122.26466, 38.67788], [-122.26533, 38.67791], [-122.26577, 38.6774], [-122.26633, 38.67729], [-122.26659, 38.67745], [-122.26703, 38.67718], [-122.26726, 38.67697], [-122.26758, 38.6769], [-122.26814, 38.67711], [-122.26893, 38.67727], [-122.26938, 38.67802], [-122.26964, 38.67788]]]]} | Open Access 1 | 25319 | Lake Berryessa Wildlife Area | 30463 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Napa 11 | 1792.223 | Lake Berryessa Wildlife Area | 0 | State Conservation Area 8 | 2 | |
| 11472 | 11472 | 11471 | {"type": "Polygon", "coordinates": [[[-121.0343, 37.08628], [-121.03425, 37.08903], [-121.02759, 37.08656], [-121.02759, 37.08625], [-121.0343, 37.08628]]]} | Open Access 1 | 29207 | O'Neill Forebay Wildlife Area | 30483 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Merced 37 | 25.025 | O'Neill Forebay Wildlife Area | 1974 | State Conservation Area 8 | 2 | |
| 16554 | 16554 | 16553 | {"type": "Polygon", "coordinates": [[[-120.82603, 36.77763], [-120.82308, 36.77759], [-120.81894, 36.77774], [-120.81895, 36.78132], [-120.81219, 36.7815], [-120.80999, 36.78344], [-120.81, 36.78518], [-120.81227, 36.78511], [-120.81452, 36.78872], [-120.80996, 36.78696], [-120.80555, 36.78534], [-120.80551, 36.78535], [-120.8055, 36.78533], [-120.80322, 36.78605], [-120.80101, 36.78668], [-120.79853, 36.78658], [-120.79774, 36.78693], [-120.79423, 36.78744], [-120.78738, 36.78753], [-120.78295, 36.78844], [-120.78296, 36.7853], [-120.78743, 36.78359], [-120.79187, 36.7818], [-120.79418, 36.78183], [-120.79414, 36.77818], [-120.79658, 36.77818], [-120.79658, 36.77614], [-120.80104, 36.77616], [-120.80544, 36.77625], [-120.80544, 36.77534], [-120.8055, 36.77441], [-120.80857, 36.77443], [-120.81001, 36.77343], [-120.81451, 36.77276], [-120.81896, 36.77272], [-120.82292, 36.77271], [-120.82306, 36.77201], [-120.82519, 36.77203], [-120.82517, 36.77356], [-120.8254, 36.77356], [-120.82541, 36.77362], [-120.82589, 36.77366], [-120.82603, 36.77763]]]} | Open Access 1 | 7474 | Little Ponoche Reservoir Wildlife Area | 30466 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Fresno 9 | 828.561 | Little Ponoche Reservoir Wildlife Area | 0 | State Conservation Area 8 | 2 | |
| 16727 | 16727 | 16726 | {"type": "Polygon", "coordinates": [[[-120.94301, 37.12928], [-120.94293, 37.13488], [-120.9429, 37.1384], [-120.94007, 37.13838], [-120.93723, 37.13839], [-120.91627, 37.14373], [-120.90571, 37.14369], [-120.90635, 37.13006], [-120.9064, 37.12916], [-120.90653, 37.12916], [-120.90672, 37.12493], [-120.90689, 37.12342], [-120.90689, 37.1213], [-120.90715, 37.11711], [-120.90715, 37.11549], [-120.9072, 37.11452], [-120.90707, 37.11451], [-120.90728, 37.10736], [-120.93218, 37.1073], [-120.93427, 37.10566], [-120.93428, 37.10552], [-120.93599, 37.10488], [-120.93659, 37.10542], [-120.93624, 37.10627], [-120.93416, 37.10801], [-120.93406, 37.11461], [-120.94296, 37.11466], [-120.94318, 37.11526], [-120.9431, 37.11962], [-120.94307, 37.12234], [-120.94301, 37.12458], [-120.94301, 37.12928]]]} | Open Access 1 | 17311 | Volta Wildlife Area | 30513 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Volta-WA | Merced 37 | 2873.422 | Volta Wildlife Area | 1973 | State Conservation Area 8 | 2 |
| 16737 | 16737 | 16736 | {"type": "Polygon", "coordinates": [[[-121.21406, 37.06776], [-121.21298, 37.06812], [-121.21212, 37.06859], [-121.21188, 37.06961], [-121.2101, 37.07152], [-121.20869, 37.07416], [-121.20739, 37.07552], [-121.20099, 37.07677], [-121.19885, 37.07706], [-121.19884, 37.07707], [-121.19633, 37.07741], [-121.19525, 37.07718], [-121.19463, 37.07753], [-121.19516, 37.07966], [-121.19407, 37.08005], [-121.19383, 37.08125], [-121.1924, 37.08246], [-121.19156, 37.08301], [-121.19054, 37.08296], [-121.19005, 37.08424], [-121.18797, 37.08395], [-121.1871, 37.08434], [-121.18607, 37.08428], [-121.18542, 37.08347], [-121.18368, 37.0841], [-121.18212, 37.08385], [-121.17922, 37.08431], [-121.17713, 37.08548], [-121.17606, 37.08487], [-121.17821, 37.08307], [-121.17796, 37.07874], [-121.18424, 37.07983], [-121.18605, 37.07761], [-121.18322, 37.07575], [-121.18084, 37.07492], [-121.1802, 37.06942], [-121.18417, 37.07149], [-121.19435, 37.07428], [-121.19578, 37.0731], [-121.18894, 37.06847], [-121.18034, 37.06541], [-121.18358, 37.06544], [-121.18861, 37.06533], [-121.19068, 37.06551], [-121.1916, 37.06583], [-121.19232, 37.06645], [-121.19305, 37.06654], [-121.19453, 37.06725], [-121.195, 37.0677], [-121.1973, 37.06844], [-121.19909, 37.06839], [-121.201, 37.06716], [-121.2009, 37.06662], [-121.20154, 37.0658], [-121.20221, 37.06557], [-121.20246, 37.06481], [-121.20495, 37.06328], [-121.20792, 37.06482], [-121.20995, 37.06498], [-121.21014, 37.06529], [-121.21023, 37.06551], [-121.21019, 37.06568], [-121.21011, 37.06588], [-121.20996, 37.06606], [-121.20975, 37.06625], [-121.20933, 37.06659], [-121.20921, 37.06685], [-121.20914, 37.0671], [-121.2092, 37.06737], [-121.20941, 37.06751], [-121.20965, 37.06762], [-121.20996, 37.0677], [-121.2103, 37.06774], [-121.21065, 37.06784], [-121.21158, 37.06825], [-121.21174, 37.06826], [-121.21318, 37.06774], [-121.21347, 37.06769], [-121.21381, 37.06769], [-121.21406, 37.06776]]]} | Open Access 1 | 17305 | San Luis Reservoir Wildlife Area | 30500 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Merced 37 | 861.266 | San Luis Reservoir Wildlife Area | 1974 | 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]);