units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where COUNTY = 24, DES_TP = 8 and MNG_AGENCY = 47
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Parks and Recreation · 5 ✖
DES_TP 1
- State Conservation Area · 5 ✖
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2562 | 2562 | 2561 | {"type": "MultiPolygon", "coordinates": [[[[-123.75739, 39.90509], [-123.75573, 39.90595], [-123.74592, 39.90583], [-123.73665, 39.90574], [-123.73206, 39.90566], [-123.73215, 39.89843], [-123.73667, 39.89851], [-123.73688, 39.89141], [-123.7507, 39.89151], [-123.7507, 39.892], [-123.75154, 39.89218], [-123.75235, 39.89226], [-123.75262, 39.89231], [-123.75272, 39.89212], [-123.75296, 39.89222], [-123.75317, 39.89234], [-123.75338, 39.89252], [-123.75352, 39.89269], [-123.7536, 39.89284], [-123.75365, 39.893], [-123.75367, 39.89312], [-123.75367, 39.89328], [-123.7534, 39.89327], [-123.75332, 39.89436], [-123.75329, 39.89453], [-123.7532, 39.89481], [-123.75302, 39.89512], [-123.75528, 39.89514], [-123.75524, 39.89874], [-123.75527, 39.90319], [-123.75739, 39.90509]]], [[[-123.76006, 39.9024], [-123.76002, 39.90493], [-123.75717, 39.90236], [-123.76006, 39.9024], [-123.76006, 39.9024]]]]} | Open Access 1 | 20520 | Smithe Redwoods State Natural Reserve | 1748 | 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/default.asp?page_id=427 | Mendocino 24 | 697.703 | Smithe Redwoods SNR | 1963 | State Conservation Area 8 | 2 |
| 2855 | 2855 | 2854 | {"type": "MultiPolygon", "coordinates": [[[[-123.82187, 39.36052], [-123.82181, 39.36061], [-123.82169, 39.36065], [-123.82162, 39.36078], [-123.82155, 39.36082], [-123.82145, 39.36074], [-123.82141, 39.36068], [-123.82133, 39.36064], [-123.82131, 39.36057], [-123.82132, 39.36051], [-123.82158, 39.36028], [-123.82186, 39.36045], [-123.82179, 39.36046], [-123.82177, 39.36048], [-123.82183, 39.36049], [-123.82187, 39.36052]]], [[[-123.8228, 39.36144], [-123.82276, 39.36146], [-123.82269, 39.36143], [-123.82259, 39.36148], [-123.82258, 39.36155], [-123.82252, 39.36153], [-123.82241, 39.36153], [-123.8221, 39.3613], [-123.82218, 39.36104], [-123.82217, 39.36096], [-123.82219, 39.36093], [-123.82217, 39.36088], [-123.82209, 39.36082], [-123.82276, 39.36083], [-123.8228, 39.36144]]], [[[-123.8239, 39.36142], [-123.82384, 39.36148], [-123.82388, 39.36153], [-123.82388, 39.36156], [-123.82384, 39.36163], [-123.82363, 39.3617], [-123.82356, 39.36169], [-123.82352, 39.36164], [-123.82328, 39.36152], [-123.82323, 39.36141], [-123.82319, 39.36134], [-123.8234, 39.36118], [-123.82373, 39.36127], [-123.82371, 39.36132], [-123.8239, 39.36142]]], [[[-123.82509, 39.36092], [-123.825, 39.36098], [-123.82499, 39.36102], [-123.82493, 39.36101], [-123.82473, 39.36109], [-123.82458, 39.36104], [-123.8245, 39.36097], [-123.82444, 39.36087], [-123.82437, 39.36085], [-123.82435, 39.36088], [-123.82436, 39.36092], [-123.82433, 39.36095], [-123.82424, 39.36095], [-123.82419, 39.36096], [-123.82414, 39.3609], [-123.8241, 39.36079], [-123.8241, 39.36073], [-123.82405, 39.36071], [-123.82401, 39.36072], [-123.82397, 39.36082], [-123.82387, 39.36069], [-123.82396, 39.36045], [-123.824, 39.36045], [-123.82406, 39.36037], [-123.82415, 39.36036], [-123.82422, 39.36032], [-123.82435, 39.36035], [-123.82449, 39.36041], [-123.82471, 39.36049], [-123.82476, 39.36057], [-123.8249, 39.3606], [-123.82495, 39.36063], [-123.825, 39.3607], [-123.82501, 39.36074], [-123.82508, 39.36083], [-123.8251, 39.36086], [-123.82509, 39.36092]]]]} | Open Access 1 | 22153 | Caspar Headlands State Natural Reserve | 1468 | 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=444 | Mendocino 24 | 3.22 | Caspar Headlands SNR | 1972 | State Conservation Area 8 | 2 |
| 2964 | 2964 | 2963 | {"type": "Polygon", "coordinates": [[[-123.33958, 38.90004], [-123.33952, 38.90731], [-123.33875, 38.90764], [-123.33462, 38.90853], [-123.33013, 38.9079], [-123.33004, 38.90648], [-123.32894, 38.9064], [-123.3282, 38.90648], [-123.32743, 38.90655], [-123.32659, 38.90634], [-123.32591, 38.90596], [-123.32539, 38.90573], [-123.32493, 38.90572], [-123.32413, 38.90583], [-123.3233, 38.90523], [-123.32357, 38.90481], [-123.32369, 38.90343], [-123.32424, 38.90238], [-123.32625, 38.90133], [-123.32773, 38.9022], [-123.32762, 38.90344], [-123.32812, 38.90364], [-123.32886, 38.90311], [-123.32891, 38.90139], [-123.32983, 38.90062], [-123.32947, 38.89991], [-123.32905, 38.89971], [-123.32942, 38.89913], [-123.33029, 38.89944], [-123.33141, 38.90032], [-123.33356, 38.89979], [-123.33626, 38.89987], [-123.33663, 38.90029], [-123.3377, 38.90011], [-123.33872, 38.89972], [-123.33958, 38.90004]]]} | Open Access 1 | 20497 | Mailliard Redwoods State Natural Reserve | 30660 | 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=439 | Mendocino 24 | 249.25 | Mailliard Redwoods SNR | 1945 | State Conservation Area 8 | 2 |
| 5187 | 5187 | 5186 | {"type": "MultiPolygon", "coordinates": [[[[-123.78065, 39.3808], [-123.77832, 39.38069], [-123.77834, 39.38249], [-123.77831, 39.3829], [-123.77605, 39.38242], [-123.77616, 39.38388], [-123.77492, 39.38378], [-123.77493, 39.38348], [-123.77385, 39.38345], [-123.77379, 39.38208], [-123.77504, 39.38217], [-123.77449, 39.38175], [-123.77435, 39.38146], [-123.77341, 39.38151], [-123.77329, 39.38204], [-123.7726, 39.3819], [-123.77135, 39.38189], [-123.77148, 39.37831], [-123.77176, 39.37302], [-123.77029, 39.37301], [-123.76991, 39.37268], [-123.76908, 39.37281], [-123.76908, 39.3727], [-123.76849, 39.37269], [-123.7685, 39.37249], [-123.7709, 39.37243], [-123.77173, 39.37243], [-123.77179, 39.3717], [-123.77179, 39.37116], [-123.7711, 39.37115], [-123.77107, 39.37183], [-123.77092, 39.37187], [-123.77047, 39.37181], [-123.7705, 39.37115], [-123.77044, 39.36946], [-123.77164, 39.36945], [-123.7718, 39.37116], [-123.7739, 39.37126], [-123.77637, 39.37143], [-123.77618, 39.37867], [-123.78058, 39.37891], [-123.78058, 39.38049], [-123.78065, 39.3808]]], [[[-123.78522, 39.36825], [-123.78083, 39.36804], [-123.78062, 39.36458], [-123.78503, 39.36474], [-123.78518, 39.3664], [-123.78522, 39.36825]]], [[[-123.82222, 39.38018], [-123.82212, 39.38021], [-123.82191, 39.3802], [-123.82189, 39.38023], [-123.82184, 39.38018], [-123.82176, 39.38017], [-123.8217, 39.38021], [-123.8217, 39.38027], [-123.82175, 39.38039], [-123.82172, 39.38045], [-123.82167, 39.3805], [-123.8216, 39.38052], [-123.82156, 39.38056], [-123.82153, 39.3807], [-123.82154, 39.38085], [-123.82142, 39.38099], [-123.82138, 39.38103], [-123.8213, 39.38102], [-123.82107, 39.38105], [-123.82083, 39.38102], [-123.8207, 39.38093], [-123.82059, 39.38095], [-123.82028, 39.3809], [-123.82014, 39.3809], [-123.82007, 39.38093], [-123.8201, 39.38119], [-123.82016, 39.38126], [-123.82022, 39.3814], [-123.82027, 39.38145], [-123.82051, 39.38159], [-123.82063, 39.3817], [-123.82069, 39.38201], [-123.82062, 39.38208], [-123.82054, 39.38211], [-123.82045, 39.38205], [-123.82035, 39.38204], [-123.8202, 39.38201], [-123.81993, 39.3819], [-123.81981, 39.38191], [-123.81974, 39.38197], [-123.81978, 39.38201], [-123.81973, 39.38202], [-123.81658, 39.381], [-123.81587, 39.3824], [-123.82026, 39.38364], [-123.82017, 39.38376], [-123.82017, 39.38409], [-123.82011, 39.38417], [-123.82005, 39.38423], [-123.81997, 39.38427], [-123.81986, 39.38429], [-123.81975, 39.38425], [-123.81971, 39.3843], [-123.81959, 39.38429], [-123.81955, 39.38431], [-123.81954, 39.38434], [-123.81961, 39.38441], [-123.81994, 39.38456], [-123.81997, 39.3846], [-123.81996, 39.38464], [-123.81991, 39.38467], [-123.81974, 39.38466], [-123.81962, 39.38468], [-123.81957, 39.38474], [-123.81967, 39.38491], [-123.81992, 39.3851], [-123.82001, 39.38515], [-123.82025, 39.38519], [-123.82031, 39.38524], [-123.82048, 39.38532], [-123.82054, 39.38543], [-123.8206, 39.38548], [-123.82065, 39.38561], [-123.82067, 39.38575], [-123.8208, 39.38592], [-123.82106, 39.38606], [-123.8211, 39.38611], [-123.82107, 39.38613], [-123.82099, 39.38613], [-123.82066, 39.38606], [-123.82062, 39.38606], [-123.82056, 39.38599], [-123.82046, 39.38593], [-123.82041, 39.38595], [-123.82042, 39.38603], [-123.82037, 39.38609], [-123.82031, 39.38611], [-123.82025, 39.3861], [-123.82022, 39.38612], [-123.82021, 39.38616], [-123.81972, 39.38601], [-123.81946, 39.38601], [-123.81944, 39.38606], [-123.81946, 39.38612], [-123.81942, 39.38613], [-123.81941, 39.38617], [-123.81922, 39.38617], [-123.81911, 39.38613], [-123.81905, 39.38616], [-123.81897, 39.38613], [-123.81892, 39.38615], [-123.81877, 39.3864], [-123.81871, 39.38645], [-123.81861, 39.38648], [-123.81856, 39.38652], [-123.81821, 39.38645], [-123.81804, 39.387], [-123.81693, 39.38671], [-123.81705, 39.38638], [-123.81721, 39.38603], [-123.8173, 39.38579], [-123.8154, 39.38534], [-123.81369, 39.3849], [-123.81385, 39.38445], [-123.81401, 39.38441], [-123.81404, 39.38434], [-123.81395, 39.38423], [-123.81413, 39.38376], [-123.81419, 39.38349], [-123.81457, 39.38328], [-123.81423, 39.38314], [-123.8144, 39.3825], [-123.81462, 39.38208], [-123.81507, 39.38048], [-123.81532, 39.37975], [-123.81049, 39.37932], [-123.80851, 39.37919], [-123.80842, 39.37843], [-123.80765, 39.37834], [-123.80764, 39.37835], [-123.80766, 39.37911], [-123.80765, 39.3793], [-123.80512, 39.37927], [-123.80129, 39.37935], [-123.80195, 39.37728], [-123.8022, 39.37663], [-123.80263, 39.37588], [-123.80262, 39.37587], [-123.7997, 39.37583], [-123.79574, 39.37582], [-123.7934, 39.37584], [-123.79342, 39.37678], [-123.793, 39.37681], [-123.79288, 39.37814], [-123.79274, 39.37938], [-123.78995, 39.3794], [-123.79005, 39.37491], [-123.79014, 39.37216], [-123.78978, 39.36677], [-123.7901, 39.36659], [-123.79037, 39.36689], [-123.79075, 39.3671], [-123.79108, 39.3671], [-123.79121, 39.36746], [-123.79148, 39.3677], [-123.79197, 39.36776], [-123.79206, 39.36771], [-123.79211, 39.36761], [-123.79208, 39.36845], [-123.79368, 39.36849], [-123.79929, 39.3685], [-123.79904, 39.36984], [-123.79907, 39.37224], [-123.80504, 39.37231], [-123.80784, 39.37232], [-123.80775, 39.37441], [-123.80928, 39.37459], [-123.8102, 39.37429], [-123.81113, 39.37496], [-123.81217, 39.37536], [-123.8159, 39.37529], [-123.81591, 39.37586], [-123.81634, 39.37586], [-123.81634, 39.37529], [-123.81628, 39.37495], [-123.81627, 39.37449], [-123.81616, 39.37393], [-123.81544, 39.37237], [-123.81521, 39.37202], [-123.81598, 39.37205], [-123.81641, 39.37218], [-123.81668, 39.37219], [-123.81692, 39.3723], [-123.81606, 39.37224], [-123.81551, 39.37222], [-123.8155, 39.37223], [-123.81555, 39.37237], [-123.81707, 39.37248], [-123.81722, 39.37302], [-123.81794, 39.37356], [-123.81807, 39.3735], [-123.81836, 39.37356], [-123.81856, 39.37356], [-123.8188, 39.37351], [-123.81904, 39.37348], [-123.81904, 39.37361], [-123.81931, 39.37367], [-123.81949, 39.37377], [-123.81966, 39.37377], [-123.81996, 39.37395], [-123.82016, 39.37393], [-123.82012, 39.3741], [-123.82016, 39.37425], [-123.82016, 39.37435], [-123.8202, 39.37446], [-123.82028, 39.37453], [-123.82057, 39.3747], [-123.82064, 39.37489], [-123.82085, 39.37498], [-123.82099, 39.37508], [-123.82113, 39.37508], [-123.82126, 39.37512], [-123.82135, 39.37509], [-123.8214, 39.37514], [-123.82164, 39.37525], [-123.82174, 39.37536], [-123.82188, 39.37559], [-123.82211, 39.37578], [-123.82217, 39.37585], [-123.8222, 39.37595], [-123.822, 39.37594], [-123.82184, 39.37585], [-123.82181, 39.37579], [-123.82171, 39.37576], [-123.82167, 39.37572], [-123.82149, 39.37574], [-123.82142, 39.37579], [-123.82133, 39.37579], [-123.82117, 39.37576], [-123.82104, 39.37568], [-123.82085, 39.37561], [-123.82058, 39.37562], [-123.8202, 39.3757], [-123.82017, 39.37572], [-123.82001, 39.37575], [-123.81996, 39.37577], [-123.81978, 39.37596], [-123.81975, 39.37616], [-123.81978, 39.37629], [-123.81956, 39.37643], [-123.81942, 39.37642], [-123.81904, 39.37643], [-123.81883, 39.37648], [-123.81857, 39.37646], [-123.81843, 39.37653], [-123.81835, 39.37663], [-123.81829, 39.37676], [-123.81828, 39.37703], [-123.81814, 39.37704], [-123.818, 39.37704], [-123.8178, 39.37693], [-123.8177, 39.37684], [-123.81751, 39.37679], [-123.81745, 39.37675], [-123.81738, 39.37673], [-123.81729, 39.37673], [-123.81726, 39.37683], [-123.81731, 39.3769], [-123.8174, 39.37693], [-123.8175, 39.37702], [-123.81778, 39.37716], [-123.81788, 39.37725], [-123.8181, 39.37736], [-123.81834, 39.37743], [-123.81881, 39.37739], [-123.81899, 39.37734], [-123.8191, 39.37736], [-123.81915, 39.37745], [-123.81915, 39.37749], [-123.81909, 39.37758], [-123.81891, 39.37795], [-123.81887, 39.378], [-123.81887, 39.37818], [-123.81891, 39.37827], [-123.81901, 39.37833], [-123.81906, 39.37835], [-123.81912, 39.37839], [-123.81924, 39.37843], [-123.81934, 39.3785], [-123.81953, 39.3787], [-123.81972, 39.37868], [-123.8198, 39.37874], [-123.81989, 39.37878], [-123.81998, 39.37874], [-123.82007, 39.37863], [-123.82018, 39.37854], [-123.82028, 39.37848], [-123.82055, 39.37842], [-123.82063, 39.37844], [-123.82073, 39.37852], [-123.82084, 39.37857], [-123.82089, 39.37864], [-123.82091, 39.37871], [-123.82091, 39.37878], [-123.82087, 39.37886], [-123.82073, 39.37895], [-123.82073, 39.37902], [-123.82098, 39.37909], [-123.8211, 39.37915], [-123.82116, 39.37922], [-123.82124, 39.37924], [-123.82131, 39.37921], [-123.82137, 39.37915], [-123.82152, 39.37912], [-123.82159, 39.37912], [-123.82175, 39.37919], [-123.82179, 39.37942], [-123.82194, 39.37947], [-123.82195, 39.37951], [-123.8219, 39.3796], [-123.82195, 39.37964], [-123.82201, 39.3796], [-123.82206, 39.37961], [-123.82208, 39.37963], [-123.82204, 39.3797], [-123.82217, 39.37977], [-123.82224, 39.37988], [-123.82226, 39.38], [-123.82222, 39.38018]], [[-123.81623, 39.37681], [-123.81622, 39.37679], [-123.8159, 39.37673], [-123.81589, 39.37674], [-123.81619, 39.37691], [-123.81623, 39.37681]]], [[[-123.82052, 39.39172], [-123.82045, 39.39178], [-123.82028, 39.3918], [-123.82016, 39.39179], [-123.82009, 39.39175], [-123.82002, 39.39174], [-123.81994, 39.39173], [-123.81989, 39.39177], [-123.81972, 39.39177], [-123.81961, 39.39183], [-123.81959, 39.39188], [-123.8196, 39.392], [-123.81955, 39.392], [-123.81931, 39.39194], [-123.81925, 39.39189], [-123.81917, 39.39186], [-123.81908, 39.39176], [-123.81863, 39.39154], [-123.81617, 39.39123], [-123.81538, 39.39114], [-123.81536, 39.39012], [-123.81537, 39.38977], [-123.81505, 39.38928], [-123.81274, 39.38894], [-123.81262, 39.38863], [-123.81319, 39.38871], [-123.8131, 39.38815], [-123.81315, 39.38787], [-123.81369, 39.38684], [-123.81403, 39.38685], [-123.81427, 39.38687], [-123.81445, 39.38694], [-123.81476, 39.38688], [-123.81494, 39.3869], [-123.81506, 39.38694], [-123.81522, 39.38693], [-123.81542, 39.38697], [-123.81581, 39.38712], [-123.81609, 39.38738], [-123.81657, 39.3875], [-123.81684, 39.38746], [-123.81701, 39.38749], [-123.81737, 39.3877], [-123.81736, 39.38773], [-123.81738, 39.38778], [-123.81743, 39.38787], [-123.81749, 39.38805], [-123.81754, 39.3881], [-123.81769, 39.3884], [-123.8178, 39.38857], [-123.81791, 39.38867], [-123.81801, 39.38873], [-123.8181, 39.38883], [-123.81821, 39.38885], [-123.8183, 39.38884], [-123.81843, 39.3888], [-123.81849, 39.3888], [-123.81852, 39.3888], [-123.81863, 39.38889], [-123.81879, 39.3889], [-123.81903, 39.38896], [-123.81909, 39.38898], [-123.8192, 39.38907], [-123.8193, 39.38909], [-123.81938, 39.38914], [-123.81954, 39.38932], [-123.81956, 39.38936], [-123.81944, 39.38941], [-123.81925, 39.3894], [-123.81906, 39.38932], [-123.81894, 39.38929], [-123.81861, 39.38914], [-123.81824, 39.38907], [-123.81817, 39.38914], [-123.81818, 39.38919], [-123.81817, 39.38923], [-123.81822, 39.38928], [-123.81823, 39.38932], [-123.81817, 39.38943], [-123.81795, 39.38955], [-123.81792, 39.38965], [-123.81793, 39.38976], [-123.81801, 39.38987], [-123.81809, 39.38994], [-123.81824, 39.39], [-123.81829, 39.39007], [-123.81821, 39.39018], [-123.81823, 39.39025], [-123.81835, 39.39027], [-123.81846, 39.39039], [-123.81854, 39.39041], [-123.81859, 39.3903], [-123.81875, 39.39036], [-123.81891, 39.39039], [-123.81904, 39.39047], [-123.81922, 39.39055], [-123.81944, 39.39062], [-123.81949, 39.39078], [-123.8196, 39.39088], [-123.81967, 39.39099], [-123.81977, 39.3911], [-123.81993, 39.39116], [-123.82003, 39.39124], [-123.82018, 39.39137], [-123.82021, 39.39145], [-123.82027, 39.39156], [-123.82043, 39.39166], [-123.8205, 39.39168], [-123.82052, 39.39172]]], [[[-123.82051, 39.37236], [-123.82051, 39.37243], [-123.82027, 39.37255], [-123.82018, 39.37258], [-123.81884, 39.37196], [-123.81894, 39.37171], [-123.82051, 39.37236]]]]} | Open Access 1 | 20491 | Jug Handle State Natural Reserve | 31545 | 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=441 | Mendocino 24 | 775.877 | Jug Handle SNR | 1976 | State Conservation Area 8 | 2 |
| 10802 | 10802 | 10801 | {"type": "Polygon", "coordinates": [[[-123.37785, 39.2331], [-123.37783, 39.22954], [-123.37609, 39.2295], [-123.37336, 39.22927], [-123.3732, 39.22205], [-123.36849, 39.22206], [-123.36853, 39.21849], [-123.36626, 39.21852], [-123.36618, 39.21491], [-123.36615, 39.21138], [-123.36838, 39.21129], [-123.36844, 39.21495], [-123.37313, 39.21486], [-123.37772, 39.21508], [-123.37773, 39.21866], [-123.37778, 39.22201], [-123.39156, 39.22222], [-123.40058, 39.22234], [-123.40066, 39.22956], [-123.4007, 39.23677], [-123.39962, 39.23676], [-123.39959, 39.23635], [-123.39953, 39.23597], [-123.39935, 39.23563], [-123.39902, 39.2353], [-123.39873, 39.23505], [-123.3982, 39.23467], [-123.39742, 39.23454], [-123.39634, 39.23483], [-123.39644, 39.23675], [-123.39633, 39.24346], [-123.39638, 39.24722], [-123.39198, 39.24724], [-123.39194, 39.24339], [-123.39186, 39.24029], [-123.38724, 39.2403], [-123.38723, 39.24031], [-123.38735, 39.24342], [-123.3874, 39.24726], [-123.38279, 39.24729], [-123.38281, 39.25114], [-123.38745, 39.25115], [-123.38749, 39.25494], [-123.39195, 39.25495], [-123.39664, 39.25473], [-123.39651, 39.25848], [-123.39193, 39.25849], [-123.38281, 39.25841], [-123.37364, 39.25837], [-123.37363, 39.25838], [-123.37371, 39.26176], [-123.3592, 39.26178], [-123.35938, 39.25821], [-123.35465, 39.25816], [-123.35481, 39.25458], [-123.35021, 39.2545], [-123.35045, 39.25103], [-123.35508, 39.25107], [-123.3595, 39.25108], [-123.35946, 39.24726], [-123.35749, 39.24725], [-123.35772, 39.24663], [-123.35926, 39.24558], [-123.35941, 39.24525], [-123.36021, 39.24393], [-123.36441, 39.24394], [-123.36442, 39.24344], [-123.3644, 39.24105], [-123.36707, 39.24104], [-123.37134, 39.24294], [-123.3735, 39.24345], [-123.37522, 39.24222], [-123.37515, 39.24208], [-123.37507, 39.242], [-123.37497, 39.24168], [-123.37498, 39.24157], [-123.37513, 39.24137], [-123.37552, 39.24105], [-123.37572, 39.24093], [-123.37578, 39.2408], [-123.37585, 39.2407], [-123.37593, 39.24055], [-123.37601, 39.24039], [-123.37602, 39.24032], [-123.37346, 39.24031], [-123.37341, 39.23659], [-123.37572, 39.23668], [-123.37798, 39.2367], [-123.37785, 39.2331]]]} | Open Access 1 | 20504 | Montgomery Woods State Natural Reserve | 1641 | 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=434 | Mendocino 24 | 2690.737 | Montgomery Woods SNR | 1947 | 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]);