units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where COUNTY = 9 and DES_TP = 39
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 | |
| 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 |
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]);