superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 47, MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=453"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 1 ✖
MNG_AGENCY 1
- California Department of Parks and Recreation · 1 ✖
ACCESS_TYP 1
| Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 334 | 334 | 333 | {"type": "MultiPolygon", "coordinates": [[[[-123.34556, 38.59505], [-123.34537, 38.59535], [-123.34481, 38.59559], [-123.34429, 38.59553], [-123.34405, 38.59564], [-123.3432, 38.59524], [-123.34323, 38.59512], [-123.34273, 38.59473], [-123.34236, 38.59475], [-123.3417, 38.5944], [-123.34109, 38.59405], [-123.34077, 38.59383], [-123.3414, 38.59338], [-123.33824, 38.59012], [-123.33421, 38.58782], [-123.32751, 38.58816], [-123.32409, 38.59224], [-123.31652, 38.58958], [-123.31598, 38.59033], [-123.3077, 38.58719], [-123.30689, 38.58837], [-123.30671, 38.58828], [-123.30651, 38.58823], [-123.30606, 38.58818], [-123.30567, 38.5882], [-123.30546, 38.58819], [-123.30494, 38.58801], [-123.30467, 38.5879], [-123.30435, 38.58786], [-123.3039, 38.58793], [-123.30349, 38.58804], [-123.30315, 38.58822], [-123.30281, 38.58833], [-123.30114, 38.58764], [-123.30213, 38.58583], [-123.29748, 38.58419], [-123.29412, 38.5797], [-123.29327, 38.57967], [-123.29298, 38.57942], [-123.29267, 38.57923], [-123.29225, 38.57901], [-123.29187, 38.57885], [-123.29163, 38.57866], [-123.29147, 38.57847], [-123.29128, 38.57779], [-123.29105, 38.57756], [-123.29071, 38.57732], [-123.29035, 38.57717], [-123.28999, 38.57706], [-123.28971, 38.57678], [-123.28961, 38.57649], [-123.28958, 38.5762], [-123.28946, 38.57593], [-123.28926, 38.5758], [-123.28906, 38.57572], [-123.28876, 38.57542], [-123.28859, 38.57507], [-123.28847, 38.5747], [-123.28827, 38.57441], [-123.28801, 38.57422], [-123.28785, 38.57406], [-123.28787, 38.57367], [-123.28797, 38.57295], [-123.28795, 38.57266], [-123.2878, 38.57248], [-123.28761, 38.5724], [-123.28709, 38.57241], [-123.28681, 38.57232], [-123.28654, 38.57235], [-123.28554, 38.57259], [-123.28535, 38.57261], [-123.28491, 38.57274], [-123.28473, 38.57285], [-123.28449, 38.57282], [-123.28408, 38.57246], [-123.28378, 38.57232], [-123.28261, 38.57211], [-123.28313, 38.55879], [-123.28324, 38.55879], [-123.28325, 38.5587], [-123.31, 38.55873], [-123.31012, 38.559], [-123.31038, 38.5593], [-123.3107, 38.55953], [-123.31097, 38.55969], [-123.31123, 38.55989], [-123.31162, 38.5603], [-123.31181, 38.56056], [-123.31193, 38.56091], [-123.31191, 38.56109], [-123.31174, 38.56189], [-123.31178, 38.56203], [-123.3119, 38.56215], [-123.31278, 38.56243], [-123.31302, 38.56253], [-123.31354, 38.56288], [-123.31368, 38.56301], [-123.31387, 38.56342], [-123.31403, 38.56359], [-123.31438, 38.56384], [-123.31562, 38.56403], [-123.31616, 38.56418], [-123.31715, 38.5646], [-123.31887, 38.5655], [-123.31901, 38.56567], [-123.31924, 38.56614], [-123.31934, 38.56667], [-123.31934, 38.56698], [-123.31918, 38.56766], [-123.3192, 38.56789], [-123.31927, 38.56811], [-123.31938, 38.56824], [-123.32002, 38.56871], [-123.32037, 38.56888], [-123.32062, 38.56897], [-123.32108, 38.56923], [-123.32151, 38.56939], [-123.32208, 38.56967], [-123.32288, 38.56999], [-123.32333, 38.5701], [-123.32409, 38.57037], [-123.32506, 38.57089], [-123.32567, 38.57144], [-123.3258, 38.57167], [-123.32595, 38.5721], [-123.32606, 38.57228], [-123.32622, 38.57243], [-123.32642, 38.57257], [-123.32773, 38.57305], [-123.32814, 38.57306], [-123.32971, 38.57325], [-123.33116, 38.57336], [-123.33191, 38.57356], [-123.33272, 38.57394], [-123.33315, 38.57426], [-123.33428, 38.57665], [-123.33429, 38.57674], [-123.33444, 38.5771], [-123.33454, 38.57727], [-123.33465, 38.57758], [-123.33459, 38.57787], [-123.33432, 38.57809], [-123.33411, 38.57817], [-123.33379, 38.57817], [-123.33341, 38.57805], [-123.33248, 38.57757], [-123.33228, 38.57755], [-123.33198, 38.57757], [-123.3318, 38.57763], [-123.3317, 38.57769], [-123.33165, 38.57782], [-123.33168, 38.57814], [-123.33178, 38.57822], [-123.33195, 38.57831], [-123.33251, 38.57849], [-123.33297, 38.57892], [-123.3332, 38.57901], [-123.33322, 38.57923], [-123.33289, 38.57995], [-123.33289, 38.58012], [-123.33265, 38.58049], [-123.33254, 38.58068], [-123.33254, 38.58083], [-123.33215, 38.58139], [-123.33212, 38.58158], [-123.33218, 38.58169], [-123.33226, 38.58179], [-123.33244, 38.58191], [-123.33265, 38.5821], [-123.33361, 38.58277], [-123.33424, 38.5831], [-123.33557, 38.58364], [-123.33631, 38.58374], [-123.33695, 38.58378], [-123.33737, 38.58394], [-123.3375, 38.58412], [-123.33741, 38.58446], [-123.33729, 38.58479], [-123.33713, 38.58504], [-123.33673, 38.58537], [-123.33667, 38.5855], [-123.33664, 38.58568], [-123.33669, 38.58587], [-123.3369, 38.58596], [-123.33716, 38.58595], [-123.33757, 38.58596], [-123.33783, 38.586], [-123.33886, 38.58631], [-123.34027, 38.58714], [-123.34059, 38.58742], [-123.34086, 38.58814], [-123.34088, 38.58864], [-123.34098, 38.58949], [-123.34102, 38.58991], [-123.34117, 38.59042], [-123.34139, 38.5908], [-123.34175, 38.59133], [-123.34188, 38.59157], [-123.34298, 38.59264], [-123.34362, 38.59344], [-123.3443, 38.59406], [-123.34517, 38.59466], [-123.34556, 38.59505]]], [[[-123.37201, 38.60712], [-123.37201, 38.60725], [-123.37188, 38.60734], [-123.37131, 38.60759], [-123.37121, 38.60771], [-123.37114, 38.60783], [-123.37098, 38.60798], [-123.37088, 38.60805], [-123.37053, 38.60813], [-123.37032, 38.60816], [-123.37022, 38.60821], [-123.3701, 38.6083], [-123.36991, 38.60832], [-123.36972, 38.60827], [-123.36961, 38.60821], [-123.36915, 38.60819], [-123.36907, 38.60839], [-123.369, 38.60839], [-123.36878, 38.60825], [-123.36869, 38.60816], [-123.36845, 38.60802], [-123.36834, 38.60798], [-123.36825, 38.60798], [-123.36803, 38.60821], [-123.36789, 38.60822], [-123.36775, 38.6082], [-123.36749, 38.60806], [-123.36739, 38.60804], [-123.3669, 38.60824], [-123.36681, 38.60833], [-123.36673, 38.60848], [-123.36669, 38.60869], [-123.36673, 38.60886], [-123.36678, 38.609], [-123.3668, 38.60929], [-123.36699, 38.60957], [-123.36733, 38.6098], [-123.36754, 38.60987], [-123.3677, 38.60997], [-123.36758, 38.61005], [-123.36751, 38.61005], [-123.36742, 38.61009], [-123.36737, 38.61018], [-123.36739, 38.61025], [-123.36744, 38.61033], [-123.36753, 38.61065], [-123.36747, 38.61075], [-123.36716, 38.61098], [-123.36695, 38.61117], [-123.36678, 38.61127], [-123.36671, 38.61141], [-123.36669, 38.61159], [-123.36664, 38.61171], [-123.36637, 38.61195], [-123.36628, 38.61209], [-123.36629, 38.61235], [-123.36636, 38.6125], [-123.36647, 38.61269], [-123.36666, 38.61296], [-123.3668, 38.61321], [-123.36697, 38.61343], [-123.35717, 38.62471], [-123.35959, 38.6263], [-123.36016, 38.6267], [-123.36008, 38.62864], [-123.35568, 38.62865], [-123.35565, 38.62493], [-123.35093, 38.62492], [-123.3509, 38.62095], [-123.34602, 38.62096], [-123.346, 38.61477], [-123.3429, 38.61214], [-123.34045, 38.61096], [-123.34897, 38.59863], [-123.34908, 38.59843], [-123.34866, 38.59807], [-123.34831, 38.59773], [-123.34812, 38.59744], [-123.34808, 38.59727], [-123.34807, 38.59706], [-123.34799, 38.59686], [-123.34774, 38.59658], [-123.34718, 38.59613], [-123.3468, 38.59592], [-123.34651, 38.5957], [-123.34577, 38.59486], [-123.34535, 38.59447], [-123.34456, 38.59388], [-123.3433, 38.59243], [-123.34235, 38.59168], [-123.34195, 38.59111], [-123.34168, 38.59077], [-123.34148, 38.59039], [-123.34129, 38.58952], [-123.34118, 38.58838], [-123.34102, 38.5878], [-123.34087, 38.58733], [-123.3407, 38.58712], [-123.34027, 38.58681], [-123.33986, 38.58659], [-123.33934, 38.58627], [-123.33896, 38.5861], [-123.33861, 38.58597], [-123.33762, 38.58573], [-123.33707, 38.58578], [-123.33689, 38.58572], [-123.33695, 38.58551], [-123.33728, 38.58522], [-123.33757, 38.58483], [-123.33776, 38.58422], [-123.33771, 38.58395], [-123.33759, 38.58383], [-123.33735, 38.58371], [-123.33703, 38.58358], [-123.3365, 38.58355], [-123.33578, 38.58346], [-123.33511, 38.58321], [-123.3347, 38.58303], [-123.33435, 38.58282], [-123.33387, 38.58259], [-123.33364, 38.58245], [-123.33262, 38.58173], [-123.33245, 38.58158], [-123.33244, 38.58136], [-123.33268, 38.58106], [-123.33278, 38.58088], [-123.33286, 38.58068], [-123.33317, 38.58023], [-123.33322, 38.57977], [-123.33349, 38.57926], [-123.33355, 38.57904], [-123.33351, 38.57894], [-123.33341, 38.57886], [-123.33321, 38.5788], [-123.3327, 38.57837], [-123.33245, 38.57823], [-123.33211, 38.57812], [-123.33193, 38.578], [-123.33196, 38.57783], [-123.33222, 38.57777], [-123.33314, 38.57824], [-123.33351, 38.57837], [-123.33372, 38.57844], [-123.33415, 38.57844], [-123.3344, 38.57838], [-123.3346, 38.57829], [-123.33482, 38.57807], [-123.33489, 38.57797], [-123.33496, 38.57767], [-123.33494, 38.57731], [-123.33478, 38.577], [-123.33463, 38.57673], [-123.33461, 38.57659], [-123.33373, 38.57454], [-123.33344, 38.5741], [-123.33294, 38.57373], [-123.33207, 38.57332], [-123.33124, 38.57309], [-123.32773, 38.57281], [-123.32656, 38.57235], [-123.32639, 38.57221], [-123.32625, 38.57203], [-123.3259, 38.57127], [-123.32565, 38.57099], [-123.32521, 38.57071], [-123.32469, 38.57042], [-123.32405, 38.57014], [-123.32358, 38.56995], [-123.32299, 38.56978], [-123.32212, 38.56943], [-123.3216, 38.56917], [-123.32114, 38.56899], [-123.32011, 38.56847], [-123.31966, 38.56813], [-123.31951, 38.568], [-123.31948, 38.56772], [-123.31962, 38.56714], [-123.31965, 38.56677], [-123.31952, 38.56604], [-123.31939, 38.56572], [-123.31913, 38.56533], [-123.31896, 38.5652], [-123.31733, 38.56437], [-123.31662, 38.56408], [-123.31603, 38.5639], [-123.31562, 38.5638], [-123.31462, 38.56368], [-123.31442, 38.5636], [-123.31429, 38.56348], [-123.31417, 38.56332], [-123.31392, 38.5629], [-123.3138, 38.56277], [-123.3136, 38.56265], [-123.31332, 38.56243], [-123.31296, 38.56224], [-123.31216, 38.56203], [-123.31203, 38.56196], [-123.31201, 38.5618], [-123.31204, 38.56165], [-123.31206, 38.56143], [-123.31219, 38.56105], [-123.31219, 38.56088], [-123.31209, 38.56054], [-123.31185, 38.56018], [-123.31658, 38.56013], [-123.31742, 38.55866], [-123.3175, 38.55879], [-123.32628, 38.55098], [-123.35633, 38.57351], [-123.34164, 38.58632], [-123.34154, 38.58612], [-123.34153, 38.58612], [-123.34156, 38.58639], [-123.34183, 38.58672], [-123.34216, 38.58691], [-123.34244, 38.58685], [-123.34257, 38.58679], [-123.34273, 38.58664], [-123.34291, 38.58655], [-123.34296, 38.58663], [-123.343, 38.58673], [-123.34324, 38.58687], [-123.34326, 38.587], [-123.34338, 38.58712], [-123.34332, 38.5872], [-123.34325, 38.5872], [-123.34315, 38.58722], [-123.34307, 38.58727], [-123.343, 38.58729], [-123.34289, 38.58727], [-123.34284, 38.58728], [-123.34254, 38.58754], [-123.34244, 38.58753], [-123.34238, 38.5875], [-123.34218, 38.58745], [-123.34211, 38.58749], [-123.34203, 38.5876], [-123.34204, 38.58765], [-123.34211, 38.58774], [-123.34216, 38.58775], [-123.34244, 38.58777], [-123.34256, 38.58781], [-123.34261, 38.5879], [-123.3426, 38.58797], [-123.34246, 38.58814], [-123.34247, 38.58829], [-123.34254, 38.58841], [-123.34294, 38.5887], [-123.3431, 38.58876], [-123.34331, 38.58891], [-123.34345, 38.58904], [-123.34355, 38.58923], [-123.34358, 38.58939], [-123.34357, 38.58958], [-123.3436, 38.58977], [-123.34357, 38.58991], [-123.34338, 38.58992], [-123.34333, 38.58997], [-123.34331, 38.59005], [-123.34333, 38.59016], [-123.34341, 38.59027], [-123.34362, 38.59043], [-123.34381, 38.59047], [-123.34428, 38.59072], [-123.34518, 38.59114], [-123.34546, 38.59132], [-123.3456, 38.59154], [-123.34575, 38.59165], [-123.34582, 38.59181], [-123.34576, 38.59207], [-123.34562, 38.59224], [-123.34556, 38.59233], [-123.34553, 38.59243], [-123.34553, 38.59249], [-123.34556, 38.59258], [-123.34565, 38.59272], [-123.34591, 38.5929], [-123.34619, 38.59298], [-123.34634, 38.593], [-123.34649, 38.59307], [-123.34666, 38.59323], [-123.34678, 38.59341], [-123.34706, 38.59369], [-123.34777, 38.59429], [-123.34815, 38.59456], [-123.34833, 38.59463], [-123.34852, 38.59475], [-123.34869, 38.59492], [-123.34908, 38.59522], [-123.34928, 38.59528], [-123.34938, 38.59537], [-123.34945, 38.59564], [-123.34949, 38.59609], [-123.34945, 38.59625], [-123.34935, 38.59649], [-123.34952, 38.59677], [-123.34963, 38.59689], [-123.34975, 38.59696], [-123.35023, 38.59696], [-123.35044, 38.59708], [-123.3506, 38.59723], [-123.3507, 38.5973], [-123.35091, 38.59732], [-123.35107, 38.59731], [-123.35121, 38.59726], [-123.35145, 38.59696], [-123.35155, 38.5969], [-123.35169, 38.59693], [-123.35185, 38.59701], [-123.35192, 38.59713], [-123.35201, 38.5974], [-123.35227, 38.59756], [-123.35255, 38.59798], [-123.35267, 38.59803], [-123.35294, 38.59785], [-123.35308, 38.59787], [-123.35334, 38.59803], [-123.35341, 38.59814], [-123.35345, 38.59838], [-123.35355, 38.59845], [-123.35376, 38.59852], [-123.35386, 38.59852], [-123.35416, 38.59844], [-123.35452, 38.59826], [-123.35468, 38.59826], [-123.35496, 38.59834], [-123.35515, 38.59843], [-123.35539, 38.59848], [-123.35567, 38.59845], [-123.35588, 38.59834], [-123.35635, 38.59792], [-123.35654, 38.59779], [-123.35674, 38.59762], [-123.35694, 38.59735], [-123.35711, 38.59724], [-123.35723, 38.59712], [-123.3573, 38.5971], [-123.3577, 38.5972], [-123.35807, 38.59724], [-123.35829, 38.59733], [-123.35904, 38.59775], [-123.35923, 38.59776], [-123.35935, 38.5977], [-123.35945, 38.59746], [-123.35954, 38.59737], [-123.35964, 38.59744], [-123.35978, 38.59762], [-123.35994, 38.59776], [-123.36013, 38.59781], [-123.3603, 38.59788], [-123.36058, 38.59814], [-123.36067, 38.59829], [-123.36065, 38.59839], [-123.36058, 38.59845], [-123.36051, 38.59844], [-123.36035, 38.59845], [-123.36025, 38.5986], [-123.36024, 38.59885], [-123.36025, 38.599], [-123.36032, 38.59911], [-123.36043, 38.59918], [-123.36057, 38.59922], [-123.36072, 38.59931], [-123.36088, 38.59952], [-123.36095, 38.59964], [-123.36117, 38.6002], [-123.36121, 38.60043], [-123.36117, 38.60053], [-123.3611, 38.6006], [-123.36095, 38.60062], [-123.36088, 38.6007], [-123.36086, 38.60075], [-123.36088, 38.60082], [-123.36095, 38.60089], [-123.36104, 38.60093], [-123.36112, 38.60093], [-123.36121, 38.6009], [-123.36124, 38.60084], [-123.36124, 38.60076], [-123.36128, 38.60063], [-123.36136, 38.60056], [-123.36154, 38.60063], [-123.36183, 38.60089], [-123.36206, 38.601], [-123.36216, 38.60102], [-123.36234, 38.60097], [-123.36268, 38.60094], [-123.36282, 38.60099], [-123.36291, 38.60107], [-123.363, 38.60123], [-123.36331, 38.60161], [-123.36351, 38.60181], [-123.36385, 38.60199], [-123.36416, 38.60202], [-123.36432, 38.60197], [-123.3644, 38.60192], [-123.36445, 38.60176], [-123.36452, 38.60163], [-123.36458, 38.60161], [-123.36466, 38.60162], [-123.36499, 38.60175], [-123.36516, 38.60186], [-123.36531, 38.60198], [-123.36553, 38.60208], [-123.36567, 38.60212], [-123.36583, 38.60209], [-123.366, 38.60208], [-123.36622, 38.60211], [-123.3664, 38.60211], [-123.3665, 38.60219], [-123.36647, 38.60231], [-123.36636, 38.60235], [-123.36612, 38.60237], [-123.36596, 38.60235], [-123.36586, 38.60242], [-123.36586, 38.60251], [-123.36591, 38.6026], [-123.36602, 38.60268], [-123.36616, 38.60276], [-123.3664, 38.603], [-123.3665, 38.60307], [-123.36666, 38.60316], [-123.36676, 38.60325], [-123.36711, 38.60347], [-123.36728, 38.60363], [-123.36747, 38.60375], [-123.3682, 38.60401], [-123.36868, 38.60428], [-123.36872, 38.60424], [-123.36859, 38.60407], [-123.3685, 38.60399], [-123.36841, 38.60385], [-123.36846, 38.60372], [-123.36862, 38.60372], [-123.36874, 38.60375], [-123.36891, 38.60374], [-123.36902, 38.60379], [-123.36904, 38.60386], [-123.3691, 38.60395], [-123.36923, 38.60405], [-123.36928, 38.60413], [-123.3694, 38.6042], [-123.36971, 38.60432], [-123.3698, 38.60442], [-123.36987, 38.6046], [-123.36998, 38.60468], [-123.37015, 38.60477], [-123.37023, 38.60484], [-123.37032, 38.60499], [-123.37046, 38.6051], [-123.37048, 38.60521], [-123.37039, 38.60523], [-123.37013, 38.60518], [-123.37001, 38.60509], [-123.36989, 38.60505], [-123.36984, 38.60512], [-123.36984, 38.60521], [-123.36992, 38.60533], [-123.37016, 38.60557], [-123.3703, 38.60567], [-123.37036, 38.60577], [-123.37048, 38.60589], [-123.37069, 38.60624], [-123.37098, 38.60639], [-123.371, 38.60657], [-123.37134, 38.6066], [-123.37146, 38.60658], [-123.37157, 38.60651], [-123.37173, 38.60647], [-123.37185, 38.60641], [-123.37199, 38.60647], [-123.37199, 38.60658], [-123.37192, 38.60662], [-123.37168, 38.60664], [-123.37164, 38.60673], [-123.3717, 38.60684], [-123.37187, 38.60701], [-123.37201, 38.60712]]]]} | Open Access 1 | Salt Point State Park | http://www.parks.ca.gov/?page_id=453 | 1981 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 5656.837 | Salt Point SP | 1968 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps(
id INT,
map,
ACCESS_TYP INT,
PARK_NAME TEXT,
PARK_URL TEXT,
SUID_NMA INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
ON [superunits_with_maps] ([ACCESS_TYP]);