units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where ACCESS_TYP = 1, COUNTY = 9 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 19 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2914 | 2914 | 2913 | {"type": "MultiPolygon", "coordinates": [[[[-119.6911, 36.98505], [-119.69104, 36.9878], [-119.69059, 36.98771], [-119.68995, 36.9875], [-119.68416, 36.98563], [-119.68412, 36.9857], [-119.68305, 36.98542], [-119.68307, 36.98525], [-119.68208, 36.98517], [-119.68205, 36.98528], [-119.67957, 36.98508], [-119.67714, 36.98498], [-119.67605, 36.98505], [-119.67599, 36.98483], [-119.67719, 36.98484], [-119.68171, 36.98493], [-119.6911, 36.98505]]], [[[-119.58334, 37.05371], [-119.58331, 37.0539], [-119.58236, 37.06225], [-119.58237, 37.06226], [-119.58297, 37.06232], [-119.58268, 37.06423], [-119.58263, 37.06429], [-119.58256, 37.0648], [-119.58237, 37.06475], [-119.58226, 37.06487], [-119.58214, 37.06528], [-119.58194, 37.06553], [-119.58072, 37.06562], [-119.58003, 37.06544], [-119.57943, 37.06512], [-119.57866, 37.06429], [-119.57837, 37.0643], [-119.57749, 37.06468], [-119.57604, 37.06475], [-119.57515, 37.06464], [-119.57144, 37.06377], [-119.5703, 37.06343], [-119.56912, 37.06331], [-119.5685, 37.06272], [-119.56827, 37.06267], [-119.56775, 37.06331], [-119.5673, 37.06368], [-119.56681, 37.06384], [-119.56668, 37.06381], [-119.56603, 37.06026], [-119.56503, 37.05287], [-119.58328, 37.05365], [-119.58334, 37.05371]]], [[[-119.70653, 36.99986], [-119.70408, 37.00231], [-119.70226, 37.0043], [-119.70202, 37.00459], [-119.70167, 37.00506], [-119.70137, 37.00556], [-119.70067, 37.00705], [-119.70046, 37.00744], [-119.70029, 37.00769], [-119.70008, 37.00797], [-119.69989, 37.00819], [-119.69967, 37.0084], [-119.69929, 37.00868], [-119.69906, 37.00881], [-119.6988, 37.00894], [-119.69801, 37.00923], [-119.69747, 37.0094], [-119.69689, 37.00955], [-119.6961, 37.00984], [-119.69504, 37.01028], [-119.69397, 37.01082], [-119.67342, 37.0107], [-119.67338, 37.0107], [-119.67304, 37.01053], [-119.6727, 37.01044], [-119.67246, 37.0104], [-119.67223, 37.0104], [-119.67209, 37.0104], [-119.67178, 37.01045], [-119.67087, 37.0102], [-119.67, 37.01027], [-119.66915, 37.01049], [-119.66483, 37.01039], [-119.66396, 37.01073], [-119.66314, 37.01099], [-119.66241, 37.01147], [-119.6609, 37.01159], [-119.66019, 37.01192], [-119.65949, 37.0117], [-119.65901, 37.01262], [-119.65796, 37.01327], [-119.6573, 37.01385], [-119.65684, 37.01465], [-119.65698, 37.01539], [-119.65662, 37.01608], [-119.65677, 37.01798], [-119.65663, 37.01859], [-119.65681, 37.01966], [-119.6567, 37.02021], [-119.65649, 37.02169], [-119.65705, 37.02251], [-119.65712, 37.02396], [-119.65747, 37.02443], [-119.6576, 37.02488], [-119.65545, 37.02492], [-119.65517, 37.0249], [-119.65012, 37.02499], [-119.64938, 37.02502], [-119.64954, 37.02945], [-119.64963, 37.03479], [-119.64962, 37.03615], [-119.64965, 37.03751], [-119.6498, 37.038], [-119.64973, 37.03897], [-119.6506, 37.03968], [-119.65159, 37.03959], [-119.65193, 37.03963], [-119.65217, 37.03947], [-119.65261, 37.03887], [-119.65338, 37.03883], [-119.65427, 37.03909], [-119.65512, 37.03888], [-119.65538, 37.03869], [-119.6552, 37.03819], [-119.65565, 37.03781], [-119.65578, 37.03756], [-119.65568, 37.03728], [-119.65538, 37.0372], [-119.65511, 37.03725], [-119.65501, 37.0375], [-119.6548, 37.03787], [-119.65447, 37.0379], [-119.65383, 37.03772], [-119.65337, 37.03777], [-119.65297, 37.03809], [-119.6526, 37.0386], [-119.65208, 37.03866], [-119.65152, 37.03839], [-119.65121, 37.0383], [-119.65095, 37.03804], [-119.6502, 37.03782], [-119.65, 37.03764], [-119.65074, 37.03706], [-119.65107, 37.03671], [-119.65162, 37.03672], [-119.65224, 37.03688], [-119.65263, 37.03663], [-119.65318, 37.03636], [-119.65323, 37.03611], [-119.65289, 37.03581], [-119.65258, 37.03589], [-119.6519, 37.03643], [-119.65159, 37.03631], [-119.65189, 37.03612], [-119.65198, 37.03587], [-119.65179, 37.03566], [-119.65205, 37.03528], [-119.65249, 37.03523], [-119.65253, 37.03505], [-119.65226, 37.03471], [-119.65254, 37.03459], [-119.6528, 37.03467], [-119.65306, 37.03473], [-119.65333, 37.03476], [-119.6537, 37.03475], [-119.65408, 37.03466], [-119.65438, 37.03443], [-119.65443, 37.03422], [-119.6542, 37.03381], [-119.65388, 37.03338], [-119.654, 37.03328], [-119.65424, 37.03329], [-119.65473, 37.03316], [-119.65487, 37.03297], [-119.65491, 37.03281], [-119.65497, 37.03267], [-119.65523, 37.03249], [-119.65541, 37.0323], [-119.6555, 37.03195], [-119.65547, 37.03167], [-119.65537, 37.03146], [-119.65511, 37.0312], [-119.65488, 37.03102], [-119.65462, 37.03097], [-119.65412, 37.03103], [-119.65383, 37.03111], [-119.65369, 37.03117], [-119.65348, 37.03101], [-119.65343, 37.03095], [-119.65361, 37.03097], [-119.65511, 37.0299], [-119.65523, 37.02968], [-119.65508, 37.02944], [-119.65443, 37.02908], [-119.65442, 37.02892], [-119.65407, 37.02857], [-119.65371, 37.02833], [-119.65333, 37.02833], [-119.6529, 37.02847], [-119.65255, 37.02867], [-119.65238, 37.02862], [-119.65258, 37.02835], [-119.65253, 37.02827], [-119.6524, 37.02814], [-119.65219, 37.02803], [-119.65229, 37.02796], [-119.65224, 37.02781], [-119.65218, 37.02749], [-119.65209, 37.02734], [-119.65231, 37.02742], [-119.65251, 37.02754], [-119.65283, 37.02762], [-119.65385, 37.02729], [-119.6544, 37.02718], [-119.65332, 37.02768], [-119.65318, 37.02789], [-119.65449, 37.02853], [-119.65557, 37.02933], [-119.6556, 37.02963], [-119.65466, 37.03052], [-119.65466, 37.03066], [-119.65511, 37.031], [-119.65551, 37.03148], [-119.65563, 37.03198], [-119.65548, 37.03237], [-119.65523, 37.03278], [-119.65486, 37.03315], [-119.65446, 37.03372], [-119.6546, 37.03429], [-119.65471, 37.03436], [-119.65465, 37.03461], [-119.65426, 37.03494], [-119.65377, 37.03514], [-119.65331, 37.03521], [-119.65317, 37.03544], [-119.65326, 37.03562], [-119.65408, 37.03592], [-119.65408, 37.03626], [-119.6536, 37.03661], [-119.65171, 37.03755], [-119.65172, 37.03771], [-119.65197, 37.03793], [-119.65217, 37.03793], [-119.65323, 37.03729], [-119.65388, 37.03741], [-119.65428, 37.03736], [-119.65483, 37.03697], [-119.65531, 37.03679], [-119.65565, 37.03681], [-119.65602, 37.03718], [-119.65602, 37.0378], [-119.65571, 37.03842], [-119.65565, 37.03892], [-119.65537, 37.03908], [-119.65437, 37.0394], [-119.65348, 37.03917], [-119.65282, 37.03919], [-119.65248, 37.03931], [-119.65166, 37.03986], [-119.65049, 37.04022], [-119.65006, 37.04018], [-119.64986, 37.04004], [-119.64971, 37.03967], [-119.64855, 37.03864], [-119.64838, 37.03864], [-119.64795, 37.03914], [-119.64723, 37.03906], [-119.64692, 37.03955], [-119.64675, 37.03969], [-119.64638, 37.03965], [-119.64609, 37.03944], [-119.64586, 37.03949], [-119.64518, 37.03978], [-119.64463, 37.0402], [-119.64421, 37.04038], [-119.64372, 37.04079], [-119.64295, 37.04097], [-119.64229, 37.04127], [-119.64095, 37.04161], [-119.64067, 37.04164], [-119.64024, 37.04193], [-119.63981, 37.04207], [-119.63904, 37.04191], [-119.63876, 37.04175], [-119.6379, 37.04093], [-119.63704, 37.04042], [-119.63659, 37.04001], [-119.63638, 37.03973], [-119.6363, 37.03968], [-119.63607, 37.03969], [-119.63606, 37.03952], [-119.63493, 37.03875], [-119.63376, 37.03782], [-119.6329, 37.03701], [-119.63182, 37.03615], [-119.63169, 37.03607], [-119.6315, 37.03607], [-119.6315, 37.03596], [-119.63099, 37.03566], [-119.63059, 37.0353], [-119.63033, 37.03489], [-119.63033, 37.03475], [-119.63045, 37.03392], [-119.63099, 37.03269], [-119.63106, 37.03242], [-119.62923, 37.03243], [-119.62973, 37.03153], [-119.63056, 37.03076], [-119.63092, 37.03049], [-119.63252, 37.03004], [-119.63387, 37.02881], [-119.63436, 37.02801], [-119.63473, 37.02708], [-119.63502, 37.02631], [-119.63506, 37.02531], [-119.63576, 37.02529], [-119.63571, 37.0288], [-119.63589, 37.0288], [-119.63624, 37.0285], [-119.63703, 37.02798], [-119.6369, 37.02756], [-119.63693, 37.02708], [-119.63707, 37.0269], [-119.63786, 37.02635], [-119.63775, 37.02603], [-119.63778, 37.02535], [-119.63752, 37.02516], [-119.63741, 37.025], [-119.63744, 37.02466], [-119.63792, 37.02422], [-119.63792, 37.024], [-119.63721, 37.02271], [-119.63727, 37.02214], [-119.63738, 37.02198], [-119.63747, 37.02173], [-119.63744, 37.02144], [-119.63735, 37.02138], [-119.63729, 37.0208], [-119.63635, 37.02063], [-119.63538, 37.01976], [-119.63455, 37.01951], [-119.63427, 37.01928], [-119.63424, 37.01846], [-119.6337, 37.01864], [-119.63273, 37.01935], [-119.63207, 37.01935], [-119.63116, 37.01919], [-119.6305, 37.01978], [-119.62971, 37.01981], [-119.62962, 37.02033], [-119.62942, 37.02063], [-119.62919, 37.02116], [-119.62885, 37.02141], [-119.62814, 37.02161], [-119.62802, 37.02205], [-119.62753, 37.02246], [-119.62708, 37.02255], [-119.62705, 37.02315], [-119.62682, 37.02349], [-119.62597, 37.02381], [-119.62495, 37.02432], [-119.62442, 37.02445], [-119.6238, 37.02431], [-119.62362, 37.02413], [-119.62331, 37.02411], [-119.62257, 37.02468], [-119.62197, 37.02491], [-119.62129, 37.025], [-119.62091, 37.02511], [-119.62056, 37.02516], [-119.62056, 37.02518], [-119.62471, 37.02522], [-119.62313, 37.02584], [-119.62135, 37.02631], [-119.62095, 37.02655], [-119.62013, 37.02751], [-119.61987, 37.02798], [-119.61947, 37.02902], [-119.61919, 37.02953], [-119.61832, 37.03213], [-119.618, 37.03245], [-119.61732, 37.03282], [-119.61612, 37.03372], [-119.61553, 37.035], [-119.61524, 37.03607], [-119.61499, 37.03798], [-119.6141, 37.03917], [-119.61375, 37.0401], [-119.6138, 37.04059], [-119.61358, 37.04114], [-119.61164, 37.04311], [-119.61061, 37.04474], [-119.61081, 37.04572], [-119.61127, 37.04696], [-119.61006, 37.04696], [-119.61006, 37.04335], [-119.60941, 37.04334], [-119.60909, 37.04365], [-119.60889, 37.0441], [-119.60894, 37.04442], [-119.60944, 37.04479], [-119.60954, 37.04497], [-119.60957, 37.04552], [-119.60901, 37.04601], [-119.60942, 37.04695], [-119.61018, 37.04715], [-119.61018, 37.04716], [-119.6102, 37.04717], [-119.61017, 37.04735], [-119.60983, 37.04763], [-119.60983, 37.04774], [-119.61009, 37.04793], [-119.61009, 37.04822], [-119.60969, 37.04875], [-119.60982, 37.04892], [-119.61015, 37.049], [-119.61017, 37.04902], [-119.61034, 37.0494], [-119.61057, 37.04957], [-119.61055, 37.0498], [-119.60995, 37.05028], [-119.60978, 37.05097], [-119.61009, 37.05127], [-119.61009, 37.05166], [-119.60998, 37.05191], [-119.61021, 37.05225], [-119.61015, 37.05261], [-119.60992, 37.05282], [-119.60924, 37.05285], [-119.60923, 37.05376], [-119.60915, 37.05385], [-119.60861, 37.05399], [-119.60864, 37.05415], [-119.60867, 37.05419], [-119.60866, 37.05421], [-119.60941, 37.05502], [-119.61009, 37.05543], [-119.61009, 37.05589], [-119.60984, 37.0563], [-119.60912, 37.05685], [-119.60912, 37.05742], [-119.60838, 37.05802], [-119.60855, 37.05829], [-119.60898, 37.05879], [-119.60907, 37.05907], [-119.60907, 37.05964], [-119.60896, 37.0599], [-119.60941, 37.06051], [-119.61012, 37.06134], [-119.6099, 37.0623], [-119.6093, 37.06328], [-119.60881, 37.06392], [-119.60813, 37.06449], [-119.60736, 37.06495], [-119.60679, 37.0652], [-119.60653, 37.06552], [-119.60619, 37.06575], [-119.6061, 37.06616], [-119.60587, 37.06632], [-119.60545, 37.06642], [-119.60491, 37.06699], [-119.60491, 37.06715], [-119.60516, 37.0674], [-119.60516, 37.06795], [-119.60473, 37.06836], [-119.60476, 37.06888], [-119.60522, 37.06914], [-119.60522, 37.0695], [-119.60502, 37.06976], [-119.60496, 37.07001], [-119.60468, 37.07028], [-119.60391, 37.07042], [-119.60265, 37.07042], [-119.60239, 37.07051], [-119.60054, 37.07063], [-119.59965, 37.07099], [-119.59905, 37.07111], [-119.59817, 37.07104], [-119.59737, 37.07086], [-119.59537, 37.06987], [-119.59485, 37.06919], [-119.59482, 37.06839], [-119.59448, 37.06781], [-119.5944, 37.06743], [-119.59411, 37.06727], [-119.59371, 37.06717], [-119.59303, 37.06644], [-119.59285, 37.06649], [-119.59271, 37.06665], [-119.5924, 37.06747], [-119.59205, 37.06772], [-119.59168, 37.06765], [-119.59166, 37.06708], [-119.5918, 37.06685], [-119.59165, 37.06612], [-119.59145, 37.06587], [-119.59145, 37.06584], [-119.59192, 37.06517], [-119.59196, 37.06114], [-119.601, 37.06136], [-119.60101, 37.05784], [-119.6015, 37.05775], [-119.60262, 37.05784], [-119.60256, 37.05796], [-119.60256, 37.05797], [-119.60408, 37.05863], [-119.60614, 37.05498], [-119.60553, 37.05469], [-119.60538, 37.05426], [-119.60536, 37.05069], [-119.60149, 37.05057], [-119.60149, 37.04675], [-119.59663, 37.04673], [-119.59636, 37.03951], [-119.60085, 37.03959], [-119.60095, 37.04317], [-119.60535, 37.04333], [-119.60547, 37.036], [-119.60983, 37.03608], [-119.6099, 37.03021], [-119.6099, 37.02875], [-119.60551, 37.02867], [-119.60553, 37.02509], [-119.61234, 37.02519], [-119.61244, 37.0217], [-119.61691, 37.02164], [-119.61704, 37.01804], [-119.62274, 37.01798], [-119.62287, 37.02174], [-119.62622, 37.02171], [-119.62623, 37.0217], [-119.62607, 37.01809], [-119.63971, 37.01813], [-119.63988, 37.01795], [-119.63973, 37.01435], [-119.64291, 37.01438], [-119.64325, 37.01517], [-119.64409, 37.01628], [-119.64435, 37.01674], [-119.64444, 37.01627], [-119.64367, 37.0155], [-119.64429, 37.01513], [-119.64432, 37.01472], [-119.64464, 37.01413], [-119.64436, 37.01384], [-119.64443, 37.01312], [-119.64424, 37.01287], [-119.64415, 37.01208], [-119.64499, 37.01154], [-119.64501, 37.01117], [-119.64445, 37.01079], [-119.64954, 37.01081], [-119.6521, 37.01079], [-119.65215, 37.01076], [-119.65215, 37.01074], [-119.64954, 37.01075], [-119.64955, 37.0062], [-119.65415, 37.00618], [-119.65413, 37.00778], [-119.65425, 37.00782], [-119.65435, 37.00784], [-119.65447, 37.00783], [-119.65458, 37.0078], [-119.65465, 37.00776], [-119.65475, 37.00767], [-119.65495, 37.00759], [-119.65503, 37.00752], [-119.65507, 37.00741], [-119.65508, 37.00715], [-119.65513, 37.00692], [-119.65515, 37.00681], [-119.65514, 37.00672], [-119.6551, 37.00662], [-119.65504, 37.00652], [-119.65494, 37.00642], [-119.65489, 37.00627], [-119.65486, 37.00616], [-119.65487, 37.00591], [-119.65496, 37.00568], [-119.65494, 37.00546], [-119.65497, 37.00538], [-119.65498, 37.00529], [-119.65494, 37.00515], [-119.6548, 37.00499], [-119.65475, 37.00487], [-119.65475, 37.00477], [-119.65481, 37.00462], [-119.65481, 37.00454], [-119.65478, 37.00448], [-119.65472, 37.00442], [-119.65462, 37.00438], [-119.65452, 37.00437], [-119.65451, 37.00432], [-119.65453, 37.00427], [-119.65457, 37.00423], [-119.65486, 37.00408], [-119.65523, 37.00386], [-119.65529, 37.00384], [-119.65537, 37.00384], [-119.65562, 37.00389], [-119.65713, 37.00461], [-119.65718, 37.0047], [-119.65722, 37.00484], [-119.65723, 37.00497], [-119.6572, 37.00512], [-119.65722, 37.00521], [-119.65727, 37.00532], [-119.65734, 37.00539], [-119.65759, 37.00554], [-119.65794, 37.00569], [-119.65891, 37.00617], [-119.65908, 37.00631], [-119.65936, 37.0066], [-119.65959, 37.00675], [-119.65971, 37.00681], [-119.6598, 37.00682], [-119.66006, 37.00685], [-119.66033, 37.00684], [-119.66047, 37.00683], [-119.66056, 37.00677], [-119.66061, 37.00671], [-119.66065, 37.00664], [-119.66066, 37.00656], [-119.66065, 37.00648], [-119.66062, 37.00642], [-119.66054, 37.00633], [-119.66045, 37.00617], [-119.66035, 37.00605], [-119.6602, 37.00592], [-119.66006, 37.00584], [-119.66001, 37.00578], [-119.66011, 37.00568], [-119.66027, 37.00562], [-119.66029, 37.0056], [-119.66031, 37.0055], [-119.66029, 37.00544], [-119.66025, 37.00539], [-119.66018, 37.00535], [-119.66005, 37.00532], [-119.65992, 37.00527], [-119.65972, 37.00513], [-119.6596, 37.00507], [-119.65948, 37.00504], [-119.65923, 37.00501], [-119.65915, 37.00498], [-119.65901, 37.00489], [-119.65874, 37.00486], [-119.6586, 37.00478], [-119.65856, 37.00468], [-119.65848, 37.00459], [-119.65844, 37.00452], [-119.65844, 37.00444], [-119.65848, 37.00435], [-119.65849, 37.00429], [-119.6584, 37.00408], [-119.65841, 37.00403], [-119.65844, 37.00396], [-119.65857, 37.00385], [-119.65863, 37.00374], [-119.65863, 37.00357], [-119.65858, 37.00341], [-119.65847, 37.00324], [-119.65831, 37.0031], [-119.65798, 37.00306], [-119.65784, 37.0028], [-119.65762, 37.00256], [-119.65709, 37.00256], [-119.65695, 37.0025], [-119.65413, 37.00244], [-119.64919, 37.0023], [-119.64502, 37.0022], [-119.64071, 37.00206], [-119.6362, 37.00195], [-119.63626, 36.99851], [-119.64068, 36.99849], [-119.6408, 36.99497], [-119.64527, 36.99502], [-119.64539, 36.9914], [-119.64986, 36.99146], [-119.66331, 36.99174], [-119.66324, 36.99539], [-119.66331, 36.99541], [-119.66344, 36.99556], [-119.6635, 36.99569], [-119.66352, 36.99582], [-119.66348, 36.99599], [-119.66342, 36.99609], [-119.66334, 36.99618], [-119.66322, 36.99644], [-119.66316, 36.99667], [-119.66316, 36.99694], [-119.66324, 36.99723], [-119.66335, 36.99745], [-119.66338, 36.99747], [-119.66338, 36.99751], [-119.66349, 36.99766], [-119.66349, 36.99779], [-119.66358, 36.9979], [-119.66356, 36.99791], [-119.66364, 36.99808], [-119.66365, 36.99827], [-119.66374, 36.99849], [-119.66384, 36.99863], [-119.66396, 36.99875], [-119.6641, 36.99886], [-119.66412, 36.99887], [-119.66413, 36.99886], [-119.66416, 36.9989], [-119.66431, 36.99898], [-119.66441, 36.99911], [-119.66443, 36.99921], [-119.66442, 36.99931], [-119.66438, 36.99939], [-119.66429, 36.99951], [-119.66426, 36.99957], [-119.66426, 36.99966], [-119.66429, 36.99973], [-119.66436, 36.99981], [-119.66447, 36.99987], [-119.66488, 36.99993], [-119.66523, 37.00005], [-119.66532, 37.00019], [-119.66536, 37.00035], [-119.66535, 37.00051], [-119.66527, 37.00072], [-119.66529, 37.00087], [-119.66532, 37.00095], [-119.6654, 37.00105], [-119.66544, 37.00109], [-119.66555, 37.00113], [-119.66575, 37.00117], [-119.66595, 37.00118], [-119.66615, 37.00116], [-119.6664, 37.00109], [-119.66654, 37.00109], [-119.6667, 37.00113], [-119.66682, 37.00119], [-119.66684, 37.00127], [-119.66695, 37.00136], [-119.66712, 37.00141], [-119.66727, 37.00138], [-119.66747, 37.0013], [-119.66779, 37.00114], [-119.66833, 37.00109], [-119.66877, 37.00129], [-119.66916, 37.00131], [-119.66922, 37.00172], [-119.66977, 37.00196], [-119.67002, 37.00253], [-119.6704, 37.00279], [-119.67069, 37.00418], [-119.67102, 37.00457], [-119.67099, 37.00479], [-119.67083, 37.00545], [-119.671, 37.00582], [-119.6713, 37.0058], [-119.67185, 37.0054], [-119.67188, 37.00515], [-119.67247, 37.00492], [-119.67246, 37.00444], [-119.6721, 37.00416], [-119.67217, 37.00367], [-119.67234, 37.00341], [-119.67301, 37.00309], [-119.67314, 37.00279], [-119.67303, 37.0025], [-119.67318, 37.00231], [-119.67373, 37.00213], [-119.67383, 37.00187], [-119.67366, 37.00154], [-119.67335, 37.00119], [-119.67334, 37.00101], [-119.67609, 37.00134], [-119.67705, 37.00182], [-119.67788, 37.00232], [-119.67825, 37.00242], [-119.67869, 37.00225], [-119.67882, 37.00192], [-119.67867, 37.00149], [-119.67839, 37.00111], [-119.67832, 37.00078], [-119.67819, 37.00043], [-119.67786, 37.00022], [-119.67769, 37.00016], [-119.67758, 37.0001], [-119.67745, 36.99999], [-119.67738, 36.99988], [-119.67733, 36.99971], [-119.67739, 36.9993], [-119.67736, 36.99911], [-119.67726, 36.99904], [-119.67715, 36.99902], [-119.67708, 36.99904], [-119.677, 36.99911], [-119.67677, 36.9991], [-119.67659, 36.9992], [-119.67634, 36.99904], [-119.67604, 36.99903], [-119.67605, 36.99871], [-119.67597, 36.99833], [-119.67555, 36.99803], [-119.67505, 36.99794], [-119.67497, 36.99779], [-119.6751, 36.99745], [-119.67485, 36.99724], [-119.67469, 36.99695], [-119.6749, 36.99679], [-119.67524, 36.99681], [-119.67563, 36.99649], [-119.67605, 36.99664], [-119.67684, 36.9971], [-119.67713, 36.99712], [-119.67715, 36.99688], [-119.67711, 36.99656], [-119.67745, 36.99648], [-119.67834, 36.99653], [-119.67851, 36.99633], [-119.6789, 36.99625], [-119.67907, 36.99598], [-119.67942, 36.99559], [-119.67934, 36.99527], [-119.67876, 36.99486], [-119.67893, 36.9947], [-119.67894, 36.99432], [-119.67857, 36.99371], [-119.67833, 36.99321], [-119.67829, 36.99276], [-119.67809, 36.99247], [-119.67788, 36.99226], [-119.67797, 36.99206], [-119.6781, 36.99192], [-119.67811, 36.99165], [-119.67861, 36.99181], [-119.67877, 36.99176], [-119.67877, 36.99174], [-119.67853, 36.9915], [-119.67875, 36.99127], [-119.67909, 36.99132], [-119.67956, 36.99107], [-119.68004, 36.99044], [-119.68029, 36.99035], [-119.68055, 36.9905], [-119.6808, 36.99058], [-119.68115, 36.98998], [-119.68086, 36.98959], [-119.68091, 36.98935], [-119.68117, 36.98902], [-119.68126, 36.98865], [-119.68111, 36.98803], [-119.6812, 36.9877], [-119.68109, 36.98734], [-119.68084, 36.98718], [-119.68058, 36.9873], [-119.68033, 36.9872], [-119.68, 36.987], [-119.67941, 36.98712], [-119.67919, 36.98738], [-119.67885, 36.98734], [-119.67848, 36.98711], [-119.67853, 36.98692], [-119.67886, 36.98695], [-119.67929, 36.98663], [-119.6793, 36.9864], [-119.67948, 36.98611], [-119.67957, 36.98582], [-119.67949, 36.98555], [-119.67907, 36.98551], [-119.67864, 36.98574], [-119.67822, 36.98593], [-119.67843, 36.98557], [-119.67802, 36.98534], [-119.67764, 36.9853], [-119.6774, 36.9853], [-119.67722, 36.98539], [-119.67659, 36.98522], [-119.67721, 36.98514], [-119.67957, 36.98524], [-119.68205, 36.98548], [-119.68201, 36.98564], [-119.68305, 36.98566], [-119.68402, 36.98593], [-119.68399, 36.98604], [-119.68646, 36.98681], [-119.68651, 36.98671], [-119.6898, 36.98782], [-119.68973, 36.98796], [-119.68973, 36.98798], [-119.69041, 36.98816], [-119.69098, 36.9883], [-119.691, 36.9907], [-119.69117, 36.99086], [-119.69105, 36.99109], [-119.69109, 36.99114], [-119.69103, 36.99121], [-119.69102, 36.99148], [-119.69178, 36.9922], [-119.69166, 36.99242], [-119.69167, 36.99243], [-119.69256, 36.9924], [-119.6936, 36.99239], [-119.69656, 36.99242], [-119.69846, 36.99246], [-119.69904, 36.99293], [-119.69914, 36.99282], [-119.69968, 36.99306], [-119.70046, 36.99323], [-119.70124, 36.99314], [-119.70155, 36.9932], [-119.70235, 36.99296], [-119.70307, 36.99286], [-119.70398, 36.99298], [-119.70398, 36.99296], [-119.70389, 36.99278], [-119.70534, 36.9926], [-119.70503, 36.99326], [-119.7051, 36.99345], [-119.70535, 36.99367], [-119.70559, 36.99404], [-119.7056, 36.99443], [-119.70461, 36.99548], [-119.70453, 36.9956], [-119.7045, 36.99575], [-119.70453, 36.9959], [-119.70458, 36.996], [-119.70484, 36.99635], [-119.70485, 36.99643], [-119.70484, 36.99651], [-119.70479, 36.99659], [-119.7047, 36.99668], [-119.70438, 36.99683], [-119.70426, 36.99693], [-119.70409, 36.99709], [-119.70399, 36.99723], [-119.7039, 36.99741], [-119.70383, 36.99762], [-119.70653, 36.99986]], [[-119.64502, 37.01783], [-119.64535, 37.0175], [-119.64464, 37.01728], [-119.64491, 37.0179], [-119.64502, 37.01783]], [[-119.64461, 37.01724], [-119.64463, 37.01724], [-119.64464, 37.01705], [-119.64438, 37.01679], [-119.64461, 37.01724]]]]} | Open Access 1 | 23064 | Millerton Lake State Recreation Area | 13825 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=587 | Fresno 9 | 5477.298 | Millerton Lake SRA | 1957 | State Recreation Area 39 | 4 |
| 3189 | 3189 | 3188 | {"type": "Polygon", "coordinates": [[[-119.71275, 36.9916], [-119.71191, 36.99249], [-119.7112, 36.99207], [-119.71091, 36.99196], [-119.71085, 36.99186], [-119.71077, 36.99183], [-119.71053, 36.99176], [-119.71044, 36.99178], [-119.71062, 36.99139], [-119.71109, 36.99063], [-119.71154, 36.99058], [-119.71275, 36.9916]]]} | Open Access 1 | 28051 | Friant Cove | 19113 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Fresno 9 | 5.884 | Friant Cove | None 262 | ||||
| 4066 | 4066 | 4065 | {"type": "Polygon", "coordinates": [[[-119.73129, 36.97793], [-119.7303, 36.97877], [-119.72525, 36.98164], [-119.72042, 36.98537], [-119.72043, 36.98505], [-119.72124, 36.98436], [-119.72154, 36.98342], [-119.72122, 36.98287], [-119.72074, 36.98281], [-119.72075, 36.98168], [-119.72235, 36.9798], [-119.72305, 36.97932], [-119.72304, 36.97794], [-119.73031, 36.97791], [-119.73129, 36.97793]]]} | Open Access 1 | 44427 | Lost Lake Fishing Access | 32207 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Fresno 9 | 73.033 | Lost Lake FA | 0 | State Recreation Area 39 | 4 | |
| 5107 | 5107 | 5106 | {"type": "Polygon", "coordinates": [[[-119.60553, 37.05469], [-119.60449, 37.05425], [-119.60262, 37.05784], [-119.6015, 37.05775], [-119.60101, 37.05784], [-119.601, 37.05774], [-119.59373, 37.05756], [-119.59561, 37.0567], [-119.59483, 37.05542], [-119.59485, 37.05373], [-119.59626, 37.05219], [-119.59418, 37.05221], [-119.59292, 37.05383], [-119.5928, 37.05544], [-119.5945, 37.05547], [-119.59074, 37.05716], [-119.59078, 37.05737], [-119.59075, 37.0575], [-119.58847, 37.05744], [-119.58843, 37.05385], [-119.58744, 37.05382], [-119.58743, 37.0538], [-119.58334, 37.05371], [-119.58328, 37.05365], [-119.58311, 37.05364], [-119.58327, 37.05066], [-119.58333, 37.04666], [-119.58338, 37.03919], [-119.58348, 37.03198], [-119.58438, 37.03198], [-119.58772, 37.03206], [-119.58766, 37.03928], [-119.59636, 37.03951], [-119.59663, 37.04673], [-119.60149, 37.04675], [-119.60149, 37.05056], [-119.60536, 37.05068], [-119.60538, 37.05426], [-119.60553, 37.05469]], [[-119.59199, 37.05068], [-119.59107, 37.04986], [-119.58966, 37.05296], [-119.59067, 37.05392], [-119.59199, 37.05068]]]} | Open Access 1 | 6874 | Big Table Mountain Ecological Reserve | 32054 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Big-Table-Mountain-ER | Fresno 9 | 759.911 | Big Table Mtn. ER | 2007 | State Conservation Area 8 | 2 |
| 5458 | 5458 | 5457 | {"type": "MultiPolygon", "coordinates": [[[[-120.21831, 36.13041], [-120.20929, 36.13044], [-120.20922, 36.12334], [-120.21828, 36.12324], [-120.21831, 36.13041]]], [[[-120.22847, 36.13753], [-120.22846, 36.152], [-120.21955, 36.15197], [-120.21952, 36.13764], [-120.22847, 36.13753]]], [[[-120.2647, 36.16611], [-120.24662, 36.16626], [-120.24645, 36.15181], [-120.25101, 36.15175], [-120.25101, 36.14812], [-120.25997, 36.14809], [-120.26001, 36.14443], [-120.26441, 36.14437], [-120.2645, 36.15162], [-120.26454, 36.15215], [-120.26466, 36.153], [-120.2647, 36.16611]]]]} | Open Access 1 | 8159 | Pleasant Valley Ecological Reserve | 32267 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Pleasant-Valley-ER | Fresno 9 | 1284.087 | Pleasant Valley ER | 2000 | State Conservation Area 8 | 2 |
| 5838 | 5838 | 5837 | {"type": "MultiPolygon", "coordinates": [[[[-120.19624, 36.73443], [-120.18674, 36.73448], [-120.17316, 36.73451], [-120.17319, 36.71998], [-120.19608, 36.71999], [-120.19624, 36.73443]]], [[[-120.20506, 36.73468], [-120.2048, 36.74922], [-120.18653, 36.74912], [-120.17739, 36.74918], [-120.17765, 36.73475], [-120.18677, 36.73478], [-120.20506, 36.73468]]]]} | Open Access 1 | 21960 | Kerman Ecological Reserve | 32193 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Kerman-ER | Fresno 9 | 1784.445 | Kerman ER | 1990 | State Conservation Area 8 | 2 |
| 7078 | 7078 | 7077 | {"type": "MultiPolygon", "coordinates": [[[[-120.28787, 36.71631], [-120.28778, 36.71975], [-120.28782, 36.72559], [-120.27868, 36.72398], [-120.26909, 36.72268], [-120.26219, 36.7218], [-120.26174, 36.72161], [-120.26129, 36.72122], [-120.26084, 36.72073], [-120.26064, 36.72029], [-120.2604, 36.71992], [-120.26045, 36.7166], [-120.27884, 36.7165], [-120.28787, 36.71631]], [[-120.27446, 36.71977], [-120.27446, 36.71975], [-120.26911, 36.71978], [-120.26427, 36.71987], [-120.27446, 36.71977]]], [[[-120.30576, 36.73425], [-120.29255, 36.73428], [-120.2923, 36.73425], [-120.29235, 36.72953], [-120.28779, 36.72947], [-120.28778, 36.72948], [-120.28774, 36.73423], [-120.27866, 36.73422], [-120.2787, 36.72438], [-120.28783, 36.72592], [-120.29689, 36.72721], [-120.30569, 36.7285], [-120.30576, 36.73425]]], [[[-120.30568, 36.7282], [-120.30568, 36.7282], [-120.29684, 36.72692], [-120.30563, 36.72689], [-120.30568, 36.7282]]]]} | Open Access 1 | 6618 | Alkali Sink Ecological Reserve | 32014 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Alkali-Sink-ER | Fresno 9 | 935.85 | Alkali Sink ER | 1979 | State Conservation Area 8 | 2 |
| 7132 | 7132 | 7131 | {"type": "MultiPolygon", "coordinates": [[[[-119.41323, 36.78389], [-119.41298, 36.78429], [-119.41297, 36.78478], [-119.41308, 36.78757], [-119.41299, 36.78847], [-119.41167, 36.78916], [-119.4116, 36.78454], [-119.40887, 36.78451], [-119.40928, 36.78346], [-119.41097, 36.78354], [-119.411, 36.7831], [-119.41, 36.78308], [-119.41079, 36.78223], [-119.41154, 36.78298], [-119.41323, 36.78389]]], [[[-119.41291, 36.78956], [-119.41289, 36.7902], [-119.41169, 36.79021], [-119.41169, 36.79009], [-119.41163, 36.79008], [-119.41163, 36.78953], [-119.41265, 36.78953], [-119.41266, 36.78957], [-119.41291, 36.78956]]]]} | Open Access 1 | 6750 | Avocado Lake | 32030 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Fresno 9 | 29.362 | Avocado Lake | 0 | State Resource Management Area 55 | 3 | |
| 7316 | 7316 | 7315 | {"type": "MultiPolygon", "coordinates": [[[[-119.56959, 37.04962], [-119.56956, 37.05304], [-119.56503, 37.05287], [-119.56502, 37.04939], [-119.56959, 37.04962]]], [[[-119.60101, 37.05774], [-119.60101, 37.06136], [-119.59197, 37.06115], [-119.59192, 37.06517], [-119.59145, 37.06583], [-119.59142, 37.06546], [-119.59057, 37.06551], [-119.59023, 37.06532], [-119.58999, 37.06493], [-119.58974, 37.06492], [-119.58962, 37.06504], [-119.58945, 37.06504], [-119.58931, 37.0649], [-119.58916, 37.06447], [-119.58885, 37.06447], [-119.58871, 37.06479], [-119.58831, 37.06509], [-119.58756, 37.06495], [-119.58639, 37.06497], [-119.58562, 37.0647], [-119.58542, 37.06453], [-119.58528, 37.06431], [-119.58527, 37.06364], [-119.58448, 37.0636], [-119.58422, 37.06417], [-119.58374, 37.06424], [-119.58325, 37.06449], [-119.58299, 37.06479], [-119.58274, 37.06485], [-119.58256, 37.0648], [-119.58263, 37.06429], [-119.58268, 37.06422], [-119.58297, 37.06233], [-119.58236, 37.06226], [-119.58334, 37.05371], [-119.58744, 37.0538], [-119.58744, 37.05741], [-119.59075, 37.0575], [-119.59125, 37.05884], [-119.59053, 37.0588], [-119.59052, 37.05969], [-119.5916, 37.05972], [-119.59162, 37.05935], [-119.59205, 37.05936], [-119.59211, 37.05891], [-119.5913, 37.05883], [-119.59359, 37.05756], [-119.60101, 37.05774]]]]} | Open Access 1 | 6626 | Millerton Lake State Recreation Area | 13825 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=587 | Fresno 9 | 315.256 | Millerton Lake SRA | 1957 | State Recreation Area 39 | 4 |
| 7436 | 7436 | 7435 | {"type": "Polygon", "coordinates": [[[-120.55936, 36.14655], [-120.55484, 36.14658], [-120.55048, 36.14653], [-120.54144, 36.14651], [-120.54142, 36.13932], [-120.55041, 36.13938], [-120.55925, 36.13938], [-120.55932, 36.14295], [-120.55936, 36.14655]]]} | Open Access 1 | 6994 | Coalinga Mineral Springs Public Access | 32124 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Fresno 9 | 316.828 | Coalinga Mineral Springs PA | 0 | State Recreation Area 39 | 4 | |
| 7536 | 7536 | 7535 | {"type": "MultiPolygon", "coordinates": [[[[-120.4594, 36.09525], [-120.45884, 36.09971], [-120.45356, 36.09967], [-120.454, 36.096], [-120.45465, 36.09599], [-120.45495, 36.09613], [-120.45535, 36.09628], [-120.4556, 36.09628], [-120.45586, 36.09634], [-120.45597, 36.09635], [-120.45623, 36.09634], [-120.45653, 36.09626], [-120.45684, 36.09612], [-120.45705, 36.096], [-120.45847, 36.09601], [-120.45855, 36.09539], [-120.4594, 36.09525]]], [[[-120.4602, 36.08884], [-120.45943, 36.09501], [-120.45866, 36.09511], [-120.45891, 36.09249], [-120.45453, 36.09211], [-120.45494, 36.08881], [-120.4602, 36.08884]]]]} | Open Access 1 | 7116 | Curry Mountain Public Access | 32142 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Fresno 9 | 98.979 | Curry Mtn. PA | 0 | State Recreation Area 39 | 4 | |
| 7674 | 7674 | 7673 | {"type": "Polygon", "coordinates": [[[-119.72154, 36.98342], [-119.72124, 36.98436], [-119.72043, 36.98505], [-119.72041, 36.98576], [-119.72081, 36.98612], [-119.71504, 36.98955], [-119.71421, 36.98877], [-119.71461, 36.98852], [-119.71382, 36.98803], [-119.71385, 36.98732], [-119.71406, 36.98693], [-119.71412, 36.9868], [-119.71485, 36.98589], [-119.7156, 36.98567], [-119.71653, 36.98603], [-119.71687, 36.98603], [-119.71851, 36.98504], [-119.7193, 36.98381], [-119.72074, 36.98281], [-119.72122, 36.98286], [-119.72154, 36.98342]]]} | Open Access 1 | 7583 | San Joaquin Fish Hatchery | 32294 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Fresno 9 | 49.554 | San Joaquin Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
| 10097 | 10097 | 10096 | {"type": "MultiPolygon", "coordinates": [[[[-120.38851, 36.07903], [-120.38402, 36.07898], [-120.38402, 36.07506], [-120.38845, 36.07502], [-120.38851, 36.07903]]], [[[-120.58648, 36.28432], [-120.56898, 36.28448], [-120.56891, 36.27347], [-120.57736, 36.27346], [-120.57738, 36.27704], [-120.58181, 36.27708], [-120.58182, 36.26987], [-120.58634, 36.26983], [-120.58625, 36.27704], [-120.58648, 36.28432]]], [[[-120.6209, 36.31956], [-120.62001, 36.31988], [-120.61962, 36.31972], [-120.61915, 36.31943], [-120.619, 36.31927], [-120.61892, 36.31921], [-120.61858, 36.31915], [-120.61844, 36.31908], [-120.61826, 36.31897], [-120.61801, 36.31877], [-120.61788, 36.31886], [-120.6177, 36.31914], [-120.61751, 36.31933], [-120.6173, 36.31945], [-120.61713, 36.3195], [-120.61694, 36.31946], [-120.61638, 36.3195], [-120.61612, 36.31957], [-120.61591, 36.31965], [-120.61558, 36.31993], [-120.61533, 36.32007], [-120.61508, 36.32025], [-120.6149, 36.32029], [-120.61468, 36.32026], [-120.61445, 36.32021], [-120.61406, 36.32021], [-120.61354, 36.32026], [-120.61338, 36.32031], [-120.61326, 36.32052], [-120.6131, 36.32067], [-120.61297, 36.32075], [-120.61283, 36.32087], [-120.61252, 36.32107], [-120.61216, 36.32146], [-120.61215, 36.32158], [-120.61226, 36.32178], [-120.6125, 36.32199], [-120.61255, 36.32226], [-120.61265, 36.32263], [-120.61277, 36.32284], [-120.61288, 36.32297], [-120.61297, 36.3233], [-120.61303, 36.32359], [-120.61295, 36.3239], [-120.61272, 36.32415], [-120.61251, 36.32431], [-120.6118, 36.32462], [-120.61154, 36.32465], [-120.61134, 36.32462], [-120.61079, 36.32436], [-120.61013, 36.32425], [-120.60988, 36.32425], [-120.60926, 36.32432], [-120.609, 36.32433], [-120.60875, 36.3243], [-120.60844, 36.32432], [-120.60822, 36.32437], [-120.60805, 36.32437], [-120.60753, 36.32427], [-120.60703, 36.3242], [-120.6068, 36.32419], [-120.60648, 36.32424], [-120.60597, 36.32425], [-120.60558, 36.32429], [-120.60535, 36.32425], [-120.60516, 36.32415], [-120.605, 36.32415], [-120.60461, 36.32434], [-120.6044, 36.32455], [-120.60423, 36.32467], [-120.60403, 36.32474], [-120.60394, 36.32491], [-120.6039, 36.32523], [-120.60382, 36.32541], [-120.60365, 36.32549], [-120.60346, 36.32547], [-120.60308, 36.3255], [-120.60257, 36.3255], [-120.60229, 36.32564], [-120.60214, 36.32573], [-120.60196, 36.32626], [-120.59657, 36.32616], [-120.59655, 36.32505], [-120.59647, 36.32298], [-120.59616, 36.31099], [-120.60401, 36.31092], [-120.61261, 36.31081], [-120.61716, 36.31079], [-120.62084, 36.31061], [-120.6209, 36.31956]]]]} | Open Access 1 | 17485 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Fresno 9 | 1266.224 | SLC | 0 | State Resource Management Area 55 | 3 | |
| 12983 | 12983 | 12982 | {"type": "Polygon", "coordinates": [[[-119.01902, 36.735], [-119.019, 36.73858], [-119.01004, 36.73851], [-119.01008, 36.73493], [-119.01902, 36.735]]]} | Open Access 1 | 44769 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Fresno 9 | 78.552 | SLC | 0 | State Resource Management Area 55 | 3 | |
| 15578 | 15578 | 15577 | {"type": "Polygon", "coordinates": [[[-120.79972, 36.68843], [-120.79051, 36.68826], [-120.79072, 36.68476], [-120.78171, 36.68455], [-120.78187, 36.67755], [-120.78639, 36.67756], [-120.78647, 36.66694], [-120.79072, 36.66697], [-120.79095, 36.67402], [-120.79963, 36.67422], [-120.79959, 36.68136], [-120.79972, 36.68843]]]} | Open Access 1 | 7984 | Panoche Hills Ecological Reserve | 32255 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Panoche-Hills-ER | Fresno 9 | 580.503 | Panoche Hills ER | 1990 | State Conservation Area 8 | 2 |
| 15580 | 15580 | 15579 | {"type": "MultiPolygon", "coordinates": [[[[-119.75149, 36.93449], [-119.75004, 36.93665], [-119.74807, 36.93775], [-119.7476, 36.93775], [-119.74664, 36.93813], [-119.74654, 36.93847], [-119.74512, 36.93902], [-119.74305, 36.94171], [-119.7421, 36.94133], [-119.74269, 36.94065], [-119.7424, 36.93959], [-119.74382, 36.93938], [-119.74593, 36.93776], [-119.74592, 36.93775], [-119.74577, 36.93775], [-119.74638, 36.93737], [-119.74673, 36.93674], [-119.74919, 36.93511], [-119.74916, 36.93178], [-119.74932, 36.93147], [-119.74951, 36.9313], [-119.74939, 36.93079], [-119.74911, 36.93064], [-119.74862, 36.93047], [-119.74793, 36.93041], [-119.7478, 36.93035], [-119.7472, 36.93076], [-119.74686, 36.93149], [-119.74685, 36.93201], [-119.74447, 36.93198], [-119.74333, 36.93159], [-119.74307, 36.93144], [-119.74177, 36.93195], [-119.73788, 36.93198], [-119.73781, 36.93219], [-119.73633, 36.93306], [-119.73427, 36.93358], [-119.73336, 36.93373], [-119.73044, 36.93311], [-119.73041, 36.93239], [-119.73061, 36.9316], [-119.73124, 36.9316], [-119.73126, 36.93255], [-119.73127, 36.93256], [-119.73161, 36.93254], [-119.73234, 36.93241], [-119.73304, 36.93225], [-119.73373, 36.93202], [-119.73406, 36.9319], [-119.73472, 36.9316], [-119.73979, 36.93156], [-119.74062, 36.93058], [-119.74138, 36.92971], [-119.74139, 36.9284], [-119.73931, 36.92732], [-119.73829, 36.92685], [-119.73672, 36.92627], [-119.73336, 36.92534], [-119.73339, 36.92527], [-119.73343, 36.9251], [-119.73343, 36.92504], [-119.73346, 36.92494], [-119.73358, 36.92405], [-119.7336, 36.92358], [-119.7341, 36.92354], [-119.73415, 36.92309], [-119.73918, 36.92306], [-119.73922, 36.92508], [-119.74372, 36.92507], [-119.74824, 36.92503], [-119.74827, 36.92686], [-119.75016, 36.92688], [-119.74997, 36.9272], [-119.74985, 36.92744], [-119.74977, 36.92779], [-119.74975, 36.92803], [-119.74978, 36.92809], [-119.74976, 36.92817], [-119.74967, 36.92829], [-119.74964, 36.9285], [-119.74964, 36.92858], [-119.74971, 36.92881], [-119.74987, 36.92909], [-119.74996, 36.92922], [-119.75003, 36.9294], [-119.75013, 36.92954], [-119.75019, 36.92969], [-119.75029, 36.92983], [-119.75034, 36.92994], [-119.75092, 36.93166], [-119.75089, 36.93182], [-119.75148, 36.93286], [-119.75149, 36.93449]]], [[[-119.77586, 36.91001], [-119.77555, 36.91048], [-119.77537, 36.91107], [-119.77446, 36.91292], [-119.7743, 36.91345], [-119.7743, 36.91431], [-119.77434, 36.91462], [-119.77429, 36.91505], [-119.77468, 36.91557], [-119.77477, 36.9159], [-119.77478, 36.91651], [-119.77441, 36.91741], [-119.77414, 36.91775], [-119.77314, 36.91823], [-119.77191, 36.91894], [-119.77042, 36.91939], [-119.76929, 36.91916], [-119.76793, 36.91875], [-119.76641, 36.91867], [-119.76577, 36.91878], [-119.76381, 36.91944], [-119.76246, 36.91996], [-119.76108, 36.91989], [-119.75946, 36.92006], [-119.75867, 36.92023], [-119.75865, 36.91991], [-119.75717, 36.91859], [-119.75586, 36.91748], [-119.75488, 36.91848], [-119.75433, 36.91911], [-119.75368, 36.91952], [-119.75344, 36.91935], [-119.75444, 36.91854], [-119.75504, 36.91767], [-119.75617, 36.91681], [-119.75693, 36.91639], [-119.75802, 36.91625], [-119.75862, 36.91606], [-119.75941, 36.91527], [-119.76011, 36.91496], [-119.7616, 36.91462], [-119.76287, 36.91421], [-119.76437, 36.91389], [-119.76516, 36.91395], [-119.76595, 36.91382], [-119.76732, 36.91341], [-119.76817, 36.91294], [-119.76874, 36.91139], [-119.76938, 36.91059], [-119.76964, 36.91015], [-119.77586, 36.91001]]], [[[-119.87928, 36.85578], [-119.87603, 36.85449], [-119.87533, 36.85429], [-119.87396, 36.85226], [-119.87062, 36.85148], [-119.86577, 36.85146], [-119.86576, 36.85122], [-119.86509, 36.85136], [-119.86496, 36.85146], [-119.86358, 36.85295], [-119.86216, 36.85392], [-119.86103, 36.85445], [-119.86019, 36.85415], [-119.85874, 36.85339], [-119.85886, 36.85305], [-119.86222, 36.85338], [-119.86251, 36.85301], [-119.86385, 36.85146], [-119.86576, 36.85078], [-119.86576, 36.84991], [-119.86568, 36.84623], [-119.86566, 36.84345], [-119.86698, 36.84314], [-119.86842, 36.84288], [-119.86992, 36.84279], [-119.87089, 36.84285], [-119.87165, 36.84313], [-119.87233, 36.84359], [-119.87239, 36.84365], [-119.87268, 36.84386], [-119.87294, 36.84402], [-119.87323, 36.84413], [-119.8736, 36.84431], [-119.87451, 36.84449], [-119.87477, 36.84458], [-119.8748, 36.84467], [-119.87606, 36.84495], [-119.87648, 36.845], [-119.87669, 36.8449], [-119.87925, 36.84684], [-119.87928, 36.85578]]], [[[-119.93262, 36.84369], [-119.93119, 36.84553], [-119.92798, 36.84853], [-119.92581, 36.84638], [-119.92803, 36.84555], [-119.93144, 36.84307], [-119.93262, 36.84369]]]]} | Open Access 1 | 8353 | San Joaquin River Ecological Reserve | 32295 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Joaquin-River-ER | Fresno 9 | 875.667 | San Joaquin River ER | 1990 | State Conservation Area 8 | 2 |
| 16357 | 16357 | 16356 | {"type": "MultiPolygon", "coordinates": [[[[-119.40892, 37.09687], [-119.40888, 37.10414], [-119.40433, 37.10414], [-119.40438, 37.09688], [-119.40892, 37.09687]]], [[[-119.41801, 37.10775], [-119.41344, 37.10776], [-119.41343, 37.11139], [-119.40885, 37.1114], [-119.40887, 37.10777], [-119.41344, 37.10776], [-119.41346, 37.09687], [-119.418, 37.09686], [-119.41801, 37.10775]]]]} | Open Access 1 | 44763 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Fresno 9 | 242.067 | SLC | 0 | State Resource Management Area 55 | 3 | |
| 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 | |
| 16726 | 16726 | 16725 | {"type": "MultiPolygon", "coordinates": [[[[-120.28698, 36.68854], [-120.28691, 36.68867], [-120.28649, 36.68864], [-120.28477, 36.68764], [-120.28466, 36.68675], [-120.28477, 36.68653], [-120.28495, 36.68645], [-120.28518, 36.68639], [-120.28545, 36.68647], [-120.28588, 36.68647], [-120.2865, 36.68675], [-120.2866, 36.68773], [-120.28698, 36.68854]]], [[[-120.29687, 36.693], [-120.29687, 36.693], [-120.29589, 36.69329], [-120.29586, 36.69313], [-120.29609, 36.69292], [-120.29683, 36.69292], [-120.29687, 36.693]]], [[[-120.30974, 36.69817], [-120.30964, 36.69822], [-120.30829, 36.69828], [-120.30802, 36.69816], [-120.30784, 36.69818], [-120.30793, 36.69932], [-120.308, 36.69965], [-120.30792, 36.6998], [-120.30775, 36.69983], [-120.30633, 36.69878], [-120.30596, 36.69822], [-120.30559, 36.69797], [-120.30544, 36.69797], [-120.30491, 36.69821], [-120.3044, 36.6983], [-120.30405, 36.69818], [-120.30374, 36.69798], [-120.30301, 36.69795], [-120.30269, 36.69816], [-120.30167, 36.69825], [-120.30093, 36.69808], [-120.29881, 36.69613], [-120.2982, 36.69582], [-120.29706, 36.69564], [-120.29644, 36.69536], [-120.29627, 36.69515], [-120.29639, 36.69498], [-120.29765, 36.6947], [-120.29772, 36.69445], [-120.29738, 36.69429], [-120.29671, 36.69409], [-120.29652, 36.69381], [-120.29659, 36.69359], [-120.29666, 36.69347], [-120.29753, 36.69329], [-120.29774, 36.6932], [-120.29784, 36.693], [-120.3001, 36.69253], [-120.30044, 36.69255], [-120.30354, 36.69441], [-120.3055, 36.69485], [-120.3062, 36.69497], [-120.30646, 36.69509], [-120.3071, 36.69564], [-120.30722, 36.69604], [-120.30861, 36.69681], [-120.30859, 36.69768], [-120.30888, 36.69794], [-120.30957, 36.69809], [-120.30974, 36.69817]]], [[[-120.36036, 36.70528], [-120.35157, 36.70523], [-120.35154, 36.70524], [-120.35136, 36.71225], [-120.3511, 36.71941], [-120.33576, 36.71952], [-120.33577, 36.71954], [-120.35105, 36.71958], [-120.35086, 36.73184], [-120.34305, 36.73267], [-120.34306, 36.73242], [-120.34276, 36.73218], [-120.34273, 36.73181], [-120.34321, 36.73175], [-120.3434, 36.73036], [-120.34386, 36.7306], [-120.34423, 36.73071], [-120.34466, 36.73052], [-120.34497, 36.73016], [-120.34506, 36.72991], [-120.34512, 36.7293], [-120.34508, 36.72857], [-120.34481, 36.72797], [-120.34384, 36.72789], [-120.34286, 36.72799], [-120.34214, 36.72781], [-120.34083, 36.72775], [-120.33935, 36.72759], [-120.3383, 36.7277], [-120.3375, 36.72799], [-120.33729, 36.72801], [-120.33714, 36.72788], [-120.33703, 36.72624], [-120.33715, 36.72604], [-120.33738, 36.72555], [-120.33743, 36.72337], [-120.33726, 36.72326], [-120.33686, 36.72318], [-120.33657, 36.72339], [-120.3363, 36.72332], [-120.33603, 36.72293], [-120.3353, 36.72225], [-120.3346, 36.72219], [-120.3341, 36.7222], [-120.33355, 36.72187], [-120.33318, 36.72149], [-120.33328, 36.71958], [-120.33367, 36.71953], [-120.3338, 36.71872], [-120.33341, 36.71847], [-120.33311, 36.71817], [-120.33315, 36.71787], [-120.3347, 36.71674], [-120.3349, 36.71539], [-120.33434, 36.71488], [-120.33407, 36.71426], [-120.33395, 36.7129], [-120.33358, 36.71259], [-120.3323, 36.71183], [-120.33011, 36.71179], [-120.32913, 36.71103], [-120.32648, 36.71012], [-120.32504, 36.70835], [-120.32435, 36.70795], [-120.32103, 36.70811], [-120.31944, 36.7068], [-120.31942, 36.70603], [-120.3195, 36.70514], [-120.31924, 36.7046], [-120.316, 36.70005], [-120.31588, 36.69915], [-120.31507, 36.69784], [-120.31387, 36.69738], [-120.31138, 36.69507], [-120.31044, 36.69409], [-120.3083, 36.69409], [-120.30832, 36.69363], [-120.30622, 36.69361], [-120.30567, 36.69346], [-120.30083, 36.69133], [-120.30052, 36.6916], [-120.29978, 36.69162], [-120.29954, 36.6916], [-120.29877, 36.69179], [-120.2985, 36.69174], [-120.29811, 36.69177], [-120.29744, 36.692], [-120.29606, 36.69213], [-120.29474, 36.69099], [-120.29464, 36.69048], [-120.29425, 36.69049], [-120.29392, 36.69029], [-120.2924, 36.69004], [-120.29168, 36.68998], [-120.29059, 36.6902], [-120.2904, 36.69016], [-120.28939, 36.68983], [-120.28845, 36.68968], [-120.28796, 36.68909], [-120.28763, 36.68824], [-120.28739, 36.68749], [-120.28729, 36.68661], [-120.28659, 36.68603], [-120.28579, 36.68589], [-120.28532, 36.68597], [-120.28502, 36.68575], [-120.28494, 36.68528], [-120.28511, 36.68437], [-120.2847, 36.68411], [-120.28268, 36.6838], [-120.28265, 36.68396], [-120.28258, 36.68413], [-120.28245, 36.68422], [-120.28225, 36.68427], [-120.28209, 36.6842], [-120.28191, 36.68393], [-120.28194, 36.68367], [-120.28202, 36.68219], [-120.28212, 36.68197], [-120.28245, 36.6818], [-120.2829, 36.68176], [-120.28342, 36.68176], [-120.28369, 36.68165], [-120.29051, 36.66852], [-120.29466, 36.66859], [-120.29747, 36.66857], [-120.2975, 36.66139], [-120.3158, 36.66142], [-120.33484, 36.66136], [-120.35203, 36.69043], [-120.35244, 36.69044], [-120.36025, 36.70453], [-120.36029, 36.70489], [-120.36036, 36.70528]]], [[[-120.27812, 36.70296], [-120.28293, 36.70287], [-120.28276, 36.69939], [-120.28387, 36.69873], [-120.28465, 36.69837], [-120.28524, 36.69817], [-120.28638, 36.6982], [-120.28688, 36.69811], [-120.28851, 36.69647], [-120.28931, 36.69578], [-120.29032, 36.69546], [-120.29063, 36.69547], [-120.29486, 36.69645], [-120.29617, 36.69689], [-120.29696, 36.69736], [-120.2998, 36.69732], [-120.30006, 36.69932], [-120.30106, 36.69956], [-120.30191, 36.69956], [-120.30265, 36.69947], [-120.30332, 36.69927], [-120.30373, 36.69918], [-120.30553, 36.69948], [-120.30608, 36.69959], [-120.30618, 36.69991], [-120.30616, 36.70008], [-120.30632, 36.70033], [-120.30647, 36.70093], [-120.30655, 36.70135], [-120.30689, 36.70167], [-120.30738, 36.70177], [-120.30972, 36.70186], [-120.31083, 36.70204], [-120.31107, 36.69988], [-120.31244, 36.70039], [-120.31442, 36.70081], [-120.3152, 36.70086], [-120.3151, 36.70259], [-120.31533, 36.70261], [-120.31774, 36.70521], [-120.31786, 36.70542], [-120.31794, 36.70608], [-120.3182, 36.70704], [-120.31896, 36.70806], [-120.32092, 36.70882], [-120.32123, 36.70912], [-120.32168, 36.70925], [-120.32358, 36.70947], [-120.3328, 36.71417], [-120.33296, 36.71464], [-120.33303, 36.71521], [-120.33275, 36.71649], [-120.33217, 36.71814], [-120.33226, 36.7185], [-120.33222, 36.71891], [-120.33189, 36.71946], [-120.33181, 36.71969], [-120.3314, 36.71982], [-120.33068, 36.72261], [-120.33098, 36.7231], [-120.33149, 36.72354], [-120.33217, 36.72383], [-120.33339, 36.72371], [-120.33406, 36.7235], [-120.33451, 36.72347], [-120.33584, 36.72448], [-120.33584, 36.72468], [-120.3357, 36.72501], [-120.33542, 36.72871], [-120.33538, 36.72889], [-120.33561, 36.72929], [-120.33604, 36.72956], [-120.33669, 36.72959], [-120.33786, 36.72921], [-120.33799, 36.72897], [-120.33834, 36.72854], [-120.33864, 36.72848], [-120.34155, 36.72866], [-120.34198, 36.72887], [-120.34239, 36.72886], [-120.34287, 36.729], [-120.34314, 36.72941], [-120.34131, 36.72968], [-120.34038, 36.73006], [-120.34002, 36.73057], [-120.33996, 36.73163], [-120.34023, 36.73198], [-120.34138, 36.73238], [-120.34161, 36.73253], [-120.34226, 36.73256], [-120.3424, 36.73275], [-120.3378, 36.73322], [-120.33693, 36.73278], [-120.33303, 36.73201], [-120.30568, 36.7282], [-120.30562, 36.72689], [-120.29684, 36.72692], [-120.29678, 36.71979], [-120.30565, 36.71979], [-120.30572, 36.712], [-120.30604, 36.71199], [-120.30621, 36.70516], [-120.30005, 36.7052], [-120.29998, 36.7109], [-120.29992, 36.71241], [-120.29701, 36.71243], [-120.29675, 36.71928], [-120.29547, 36.71926], [-120.29544, 36.71976], [-120.28785, 36.71975], [-120.28786, 36.71631], [-120.27884, 36.7165], [-120.26045, 36.71659], [-120.26091, 36.68498], [-120.26166, 36.68501], [-120.26239, 36.68306], [-120.26422, 36.68238], [-120.26658, 36.6819], [-120.26785, 36.67924], [-120.26771, 36.67834], [-120.26774, 36.67776], [-120.26813, 36.67729], [-120.26999, 36.67698], [-120.27023, 36.67714], [-120.27099, 36.67853], [-120.27366, 36.68017], [-120.27435, 36.68137], [-120.27613, 36.68248], [-120.27684, 36.68259], [-120.27816, 36.68255], [-120.27934, 36.68236], [-120.28121, 36.68257], [-120.28065, 36.68433], [-120.28075, 36.6847], [-120.28094, 36.68492], [-120.28132, 36.68497], [-120.28366, 36.68468], [-120.28389, 36.68475], [-120.2842, 36.68616], [-120.28352, 36.68742], [-120.2863, 36.69057], [-120.28696, 36.69054], [-120.28723, 36.69027], [-120.28841, 36.6905], [-120.2895, 36.6905], [-120.28982, 36.69076], [-120.28986, 36.69102], [-120.2897, 36.69117], [-120.28804, 36.6909], [-120.28786, 36.69106], [-120.28746, 36.69123], [-120.28711, 36.69127], [-120.28696, 36.69114], [-120.28659, 36.6911], [-120.28642, 36.69321], [-120.28487, 36.69773], [-120.28283, 36.69903], [-120.28116, 36.69951], [-120.27905, 36.70125], [-120.27667, 36.70159], [-120.27525, 36.70246], [-120.27442, 36.70314], [-120.27442, 36.70316], [-120.27812, 36.70296]], [[-120.29479, 36.71241], [-120.29477, 36.70971], [-120.2949, 36.70518], [-120.28771, 36.70518], [-120.28774, 36.70657], [-120.28798, 36.71246], [-120.29479, 36.71241]], [[-120.29526, 36.69789], [-120.29525, 36.69787], [-120.29447, 36.69787], [-120.29443, 36.6991], [-120.29521, 36.69912], [-120.29526, 36.69789]]]]} | Open Access 1 | 7783 | Mendota Wildlife Area | 30471 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Mendota-WA | Fresno 9 | 11286.241 | Mendota Wildlife Area | 1956 | 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]);