units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 1, AGNCY_TYP = 5 and DES_TP = 3
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6864 | 6864 | 6863 | {"type": "Polygon", "coordinates": [[[-118.6568, 34.21294], [-118.65513, 34.21294], [-118.65513, 34.21258], [-118.65501, 34.21255], [-118.65501, 34.21249], [-118.65514, 34.21247], [-118.65521, 34.21216], [-118.65486, 34.21197], [-118.65513, 34.21137], [-118.65534, 34.21143], [-118.65627, 34.21214], [-118.65639, 34.21229], [-118.65654, 34.21258], [-118.6568, 34.21294]]]} | Open Access 1 | 5496 | Bell Canyon Open Space | 15969 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 4.298 | Bell Canyon OS | 0 | Local Recreation Area 3 | 4 | |
11576 | 11576 | 11575 | {"type": "Polygon", "coordinates": [[[-122.21582, 37.7497], [-122.2122, 37.75089], [-122.21219, 37.7509], [-122.21281, 37.75156], [-122.21461, 37.75149], [-122.21142, 37.75331], [-122.21104, 37.75277], [-122.21118, 37.75272], [-122.21131, 37.75252], [-122.21132, 37.75241], [-122.21105, 37.75174], [-122.21078, 37.75094], [-122.21108, 37.75075], [-122.21072, 37.75029], [-122.2115, 37.74985], [-122.21127, 37.74958], [-122.21182, 37.74903], [-122.21102, 37.74812], [-122.21109, 37.74794], [-122.2099, 37.74658], [-122.20975, 37.74657], [-122.20956, 37.74634], [-122.20952, 37.74636], [-122.20871, 37.74544], [-122.20851, 37.74554], [-122.20847, 37.7455], [-122.20866, 37.74539], [-122.20866, 37.74538], [-122.20713, 37.74363], [-122.20579, 37.74437], [-122.20566, 37.74422], [-122.20795, 37.74294], [-122.20849, 37.74357], [-122.2085, 37.74356], [-122.20844, 37.74313], [-122.21245, 37.74313], [-122.21582, 37.7497]]]} | Open Access 1 | 23671 | Oakport Field | 23035 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 92.032 | Oakport Field | 0 | Local Recreation Area 3 | 4 | |
16027 | 16027 | 16026 | {"type": "MultiPolygon", "coordinates": [[[[-118.50384, 34.08843], [-118.50318, 34.08848], [-118.50327, 34.08935], [-118.50312, 34.08974], [-118.50236, 34.08972], [-118.5023, 34.0909], [-118.50263, 34.09094], [-118.50225, 34.09178], [-118.50012, 34.09144], [-118.50023, 34.09288], [-118.49954, 34.09574], [-118.49868, 34.09591], [-118.49822, 34.09578], [-118.49783, 34.09526], [-118.49764, 34.09488], [-118.49781, 34.09407], [-118.49762, 34.09323], [-118.49767, 34.09284], [-118.49752, 34.09233], [-118.49756, 34.09207], [-118.49815, 34.0913], [-118.4981, 34.0908], [-118.49819, 34.09042], [-118.49818, 34.09017], [-118.49725, 34.08937], [-118.49689, 34.08849], [-118.49654, 34.08799], [-118.49644, 34.08791], [-118.49561, 34.08421], [-118.49554, 34.08374], [-118.49597, 34.08372], [-118.49595, 34.08383], [-118.49599, 34.08395], [-118.49605, 34.08402], [-118.49619, 34.0841], [-118.49624, 34.08415], [-118.49626, 34.0842], [-118.49626, 34.08425], [-118.49616, 34.08455], [-118.49618, 34.08463], [-118.49623, 34.0847], [-118.4962, 34.08485], [-118.49645, 34.08522], [-118.49769, 34.08467], [-118.49975, 34.08396], [-118.50069, 34.08418], [-118.50244, 34.0841], [-118.50252, 34.08529], [-118.50293, 34.08527], [-118.50296, 34.08591], [-118.5031, 34.08661], [-118.50313, 34.08797], [-118.5038, 34.08793], [-118.50384, 34.08843]]], [[[-118.49607, 34.08373], [-118.49607, 34.08373], [-118.49606, 34.0839], [-118.49604, 34.0838], [-118.49607, 34.08373]]], [[[-118.49629, 34.08408], [-118.49613, 34.08398], [-118.49608, 34.08392], [-118.49626, 34.08401], [-118.49629, 34.08408]]], [[[-118.49632, 34.08436], [-118.49626, 34.08459], [-118.49626, 34.08459], [-118.49626, 34.08453], [-118.49632, 34.08436]]], [[[-118.49636, 34.0842], [-118.49636, 34.0842], [-118.49635, 34.08423], [-118.49635, 34.08417], [-118.49636, 34.0842]]]]} | Open Access 1 | 6377 | Hilton Open Space | 19999 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 135.829 | Hilton OS | 0 | Local Recreation Area 3 | 4 | |
16047 | 16047 | 16046 | {"type": "MultiPolygon", "coordinates": [[[[-118.70235, 34.07092], [-118.70224, 34.07455], [-118.69792, 34.0745], [-118.69589, 34.0745], [-118.69357, 34.07448], [-118.69357, 34.07293], [-118.6937, 34.07293], [-118.69401, 34.07288], [-118.69406, 34.07288], [-118.69417, 34.07292], [-118.69425, 34.07299], [-118.69427, 34.07305], [-118.69427, 34.0731], [-118.69422, 34.07323], [-118.69421, 34.07331], [-118.69425, 34.07345], [-118.69437, 34.07358], [-118.69447, 34.07363], [-118.69457, 34.07366], [-118.69532, 34.07369], [-118.69552, 34.07363], [-118.69562, 34.07353], [-118.6957, 34.07341], [-118.69577, 34.07336], [-118.69584, 34.07334], [-118.69651, 34.07338], [-118.69705, 34.07359], [-118.69714, 34.07365], [-118.69717, 34.07371], [-118.69716, 34.07389], [-118.69719, 34.07398], [-118.69726, 34.07408], [-118.69739, 34.07417], [-118.6975, 34.0742], [-118.69764, 34.07419], [-118.69771, 34.07418], [-118.69787, 34.07408], [-118.69791, 34.07403], [-118.69795, 34.07394], [-118.69796, 34.07384], [-118.69794, 34.07376], [-118.6979, 34.07369], [-118.69754, 34.07339], [-118.69733, 34.07327], [-118.69656, 34.07289], [-118.69642, 34.07284], [-118.69613, 34.07279], [-118.69607, 34.07276], [-118.6959, 34.07265], [-118.69579, 34.07261], [-118.69558, 34.0726], [-118.69547, 34.07257], [-118.69539, 34.07248], [-118.69518, 34.07205], [-118.69508, 34.07193], [-118.6949, 34.07183], [-118.69451, 34.07178], [-118.69443, 34.07176], [-118.69437, 34.07171], [-118.69433, 34.07165], [-118.69433, 34.07157], [-118.69442, 34.07111], [-118.69442, 34.07097], [-118.69439, 34.07089], [-118.70235, 34.07092]]], [[[-118.69776, 34.07391], [-118.69768, 34.074], [-118.69762, 34.07403], [-118.69751, 34.07403], [-118.69745, 34.07401], [-118.6974, 34.07397], [-118.69737, 34.07392], [-118.69735, 34.07365], [-118.69732, 34.07358], [-118.69724, 34.0735], [-118.69712, 34.07343], [-118.69661, 34.07324], [-118.69652, 34.07322], [-118.69593, 34.07317], [-118.69577, 34.07318], [-118.69562, 34.07325], [-118.69553, 34.07334], [-118.69543, 34.07347], [-118.69537, 34.07351], [-118.6953, 34.07353], [-118.6946, 34.0735], [-118.69452, 34.07347], [-118.69445, 34.07342], [-118.69442, 34.07335], [-118.69442, 34.07326], [-118.69447, 34.07313], [-118.69446, 34.07298], [-118.69441, 34.07289], [-118.69431, 34.0728], [-118.6942, 34.07275], [-118.69407, 34.07272], [-118.69358, 34.07277], [-118.69357, 34.07088], [-118.69418, 34.07088], [-118.69421, 34.07095], [-118.69422, 34.07108], [-118.69412, 34.07158], [-118.69414, 34.07168], [-118.6942, 34.07179], [-118.69431, 34.07189], [-118.69441, 34.07193], [-118.6948, 34.07198], [-118.69491, 34.07202], [-118.69497, 34.07207], [-118.69501, 34.07213], [-118.69523, 34.07258], [-118.69535, 34.07269], [-118.69544, 34.07274], [-118.69555, 34.07276], [-118.69575, 34.07277], [-118.69602, 34.07293], [-118.69634, 34.07299], [-118.6965, 34.07305], [-118.69728, 34.07344], [-118.69744, 34.07354], [-118.69771, 34.07375], [-118.69776, 34.07381], [-118.69776, 34.07391]]]]} | Open Access 1 | 6466 | Malibu Canyon Piuma Ridge Open Space | 21704 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 74.802 | Malibu Canyon Piuma Ridge OS | 0 | Local Recreation Area 3 | 4 | |
16055 | 16055 | 16054 | {"type": "Polygon", "coordinates": [[[-118.41376, 34.13176], [-118.41291, 34.13177], [-118.41301, 34.13079], [-118.41376, 34.13074], [-118.41376, 34.13176]]]} | Open Access 1 | 6866 | Coldwater Canyon Open Space Park | 29574 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.034 | Coldwater Canyon OS Park | 0 | Local Recreation Area 3 | 4 | |
16255 | 16255 | 16254 | {"type": "Polygon", "coordinates": [[[-118.43531, 34.11052], [-118.4348, 34.11052], [-118.43482, 34.11034], [-118.43522, 34.11034], [-118.43531, 34.11052]]]} | Open Access 1 | 46496 | Benedict Canyon Open Space | 16009 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.203 | Benedict Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16638 | 16638 | 16637 | {"type": "MultiPolygon", "coordinates": [[[[-121.68009, 37.56802], [-121.68007, 37.57196], [-121.67069, 37.57206], [-121.67068, 37.57153], [-121.67092, 37.56801], [-121.68009, 37.56802]]], [[[-121.75246, 37.62111], [-121.7509, 37.62112], [-121.74958, 37.62186], [-121.74837, 37.62184], [-121.74806, 37.62246], [-121.74691, 37.62312], [-121.74699, 37.62353], [-121.74526, 37.62599], [-121.74283, 37.62803], [-121.74131, 37.62789], [-121.74099, 37.62211], [-121.73255, 37.62201], [-121.72876, 37.61978], [-121.72583, 37.61775], [-121.72459, 37.61429], [-121.72235, 37.60768], [-121.72202, 37.60661], [-121.71757, 37.60609], [-121.71465, 37.60075], [-121.70746, 37.60051], [-121.70274, 37.60031], [-121.69821, 37.60029], [-121.6969, 37.60016], [-121.69481, 37.60002], [-121.68929, 37.59975], [-121.68806, 37.60524], [-121.68772, 37.60502], [-121.68755, 37.60487], [-121.68735, 37.60465], [-121.68719, 37.60441], [-121.6871, 37.60422], [-121.68703, 37.60403], [-121.68698, 37.60376], [-121.68698, 37.60355], [-121.687, 37.60335], [-121.68705, 37.60315], [-121.68712, 37.60296], [-121.68722, 37.60277], [-121.68734, 37.60259], [-121.68749, 37.60242], [-121.68852, 37.60137], [-121.68868, 37.60116], [-121.68882, 37.60093], [-121.68895, 37.60057], [-121.68905, 37.59996], [-121.68916, 37.59976], [-121.68915, 37.59974], [-121.68908, 37.59974], [-121.68907, 37.59964], [-121.68913, 37.5994], [-121.68924, 37.59917], [-121.68967, 37.59852], [-121.68977, 37.5983], [-121.68982, 37.59812], [-121.68983, 37.59793], [-121.68982, 37.59774], [-121.68977, 37.59756], [-121.68966, 37.59734], [-121.68921, 37.59661], [-121.69368, 37.59664], [-121.69366, 37.59323], [-121.68823, 37.59339], [-121.68825, 37.59314], [-121.68843, 37.59202], [-121.68842, 37.59178], [-121.68836, 37.59155], [-121.68825, 37.59133], [-121.68805, 37.59109], [-121.68789, 37.59095], [-121.68733, 37.59055], [-121.68714, 37.59037], [-121.68705, 37.59023], [-121.68698, 37.59009], [-121.68694, 37.58997], [-121.68691, 37.5898], [-121.68693, 37.58959], [-121.68763, 37.58629], [-121.68796, 37.58607], [-121.68796, 37.58606], [-121.68035, 37.58639], [-121.68036, 37.56411], [-121.6895, 37.56405], [-121.68904, 37.56571], [-121.68899, 37.56577], [-121.69498, 37.56996], [-121.70798, 37.57891], [-121.71095, 37.58324], [-121.71589, 37.5859], [-121.71967, 37.58835], [-121.72581, 37.59067], [-121.73422, 37.59831], [-121.7459, 37.60902], [-121.74736, 37.61049], [-121.74896, 37.61319], [-121.74962, 37.61621], [-121.74793, 37.61702], [-121.74793, 37.61704], [-121.74834, 37.61757], [-121.74891, 37.61788], [-121.75182, 37.61916], [-121.7518, 37.6192], [-121.7515, 37.62024], [-121.75246, 37.62111]], [[-121.74972, 37.62053], [-121.75031, 37.61969], [-121.74918, 37.6192], [-121.7486, 37.62004], [-121.74972, 37.62053]]]]} | Open Access 1 | 47527 | Lake Del Valle State Recreation Area | 31232 | 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 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.parks.ca.gov/?page_id=537 | Alameda 17 | 3851.412 | Lake Del Valle SRA | 1967 | Local Recreation Area 3 | 4 |
16649 | 16649 | 16648 | {"type": "MultiPolygon", "coordinates": [[[[-118.34831, 34.00313], [-118.34773, 34.00358], [-118.3476, 34.00373], [-118.34747, 34.00393], [-118.3474, 34.0041], [-118.34731, 34.00446], [-118.34727, 34.0045], [-118.34641, 34.00439], [-118.34582, 34.00436], [-118.3424, 34.00438], [-118.34203, 34.00442], [-118.34175, 34.00448], [-118.3417, 34.00434], [-118.34169, 34.00402], [-118.34342, 34.00384], [-118.34413, 34.00379], [-118.34579, 34.00333], [-118.34655, 34.0035], [-118.34712, 34.0035], [-118.34815, 34.00291], [-118.34831, 34.00313]]], [[[-118.35757, 33.99682], [-118.35756, 33.99689], [-118.35692, 33.99745], [-118.35673, 33.99772], [-118.35663, 33.99797], [-118.35659, 33.99814], [-118.35638, 33.99942], [-118.35633, 33.99965], [-118.35627, 33.99982], [-118.3561, 34.00016], [-118.35594, 34.0004], [-118.35561, 34.00076], [-118.35538, 34.00096], [-118.3546, 34.00146], [-118.35408, 34.00186], [-118.35375, 34.00217], [-118.35199, 34.00392], [-118.35175, 34.00413], [-118.35132, 34.00443], [-118.35113, 34.00452], [-118.35079, 34.00466], [-118.35042, 34.00476], [-118.35005, 34.00483], [-118.34983, 34.00485], [-118.34945, 34.00485], [-118.34902, 34.00481], [-118.34755, 34.00456], [-118.34751, 34.00452], [-118.34751, 34.00448], [-118.34758, 34.00419], [-118.34768, 34.00395], [-118.34776, 34.00384], [-118.34786, 34.00371], [-118.34801, 34.00357], [-118.34838, 34.0033], [-118.34859, 34.00348], [-118.34836, 34.00366], [-118.34859, 34.00376], [-118.34853, 34.00386], [-118.34927, 34.00403], [-118.35055, 34.00383], [-118.35158, 34.00351], [-118.35234, 34.00286], [-118.3527, 34.0022], [-118.35302, 34.00192], [-118.35409, 34.001], [-118.35517, 34.00047], [-118.35562, 34.0], [-118.35649, 33.99812], [-118.3566, 33.99764], [-118.35664, 33.99732], [-118.35661, 33.997], [-118.35729, 33.99636], [-118.35757, 33.99682]]], [[[-118.35787, 34.00675], [-118.35897, 34.00314], [-118.35972, 34.00328], [-118.36002, 34.00231], [-118.35926, 34.00215], [-118.35934, 34.00188], [-118.35937, 34.00168], [-118.35937, 34.00136], [-118.35931, 34.00106], [-118.35917, 34.00073], [-118.35898, 34.00045], [-118.35864, 33.99978], [-118.35847, 33.99934], [-118.35835, 33.99888], [-118.35823, 33.99812], [-118.35823, 33.99798], [-118.35813, 33.99742], [-118.35813, 33.99736], [-118.35817, 33.9973], [-118.3583, 33.99719], [-118.35839, 33.99715], [-118.35883, 33.99703], [-118.35919, 33.99777], [-118.35965, 33.99887], [-118.3597, 33.9989], [-118.35995, 33.99936], [-118.36004, 33.99933], [-118.3601, 33.999], [-118.36013, 33.99897], [-118.36028, 33.99899], [-118.3606, 33.99918], [-118.36063, 33.99924], [-118.36063, 33.99934], [-118.36063, 33.99945], [-118.3606, 33.99957], [-118.36053, 33.99973], [-118.36041, 33.99977], [-118.36034, 33.99984], [-118.36032, 33.9999], [-118.36032, 33.99998], [-118.36038, 34.00007], [-118.36042, 34.00011], [-118.36051, 34.00013], [-118.36052, 34.00016], [-118.36105, 34.00019], [-118.36114, 34.00035], [-118.36114, 34.00042], [-118.3611, 34.00048], [-118.36082, 34.00057], [-118.36092, 34.00077], [-118.36153, 34.00056], [-118.36155, 34.00062], [-118.36145, 34.0008], [-118.36142, 34.00091], [-118.3613, 34.00108], [-118.3613, 34.00114], [-118.36135, 34.00121], [-118.36178, 34.00149], [-118.36212, 34.00184], [-118.3623, 34.00174], [-118.36223, 34.00166], [-118.36225, 34.00157], [-118.36228, 34.00154], [-118.36235, 34.00154], [-118.36278, 34.0017], [-118.36278, 34.00298], [-118.36273, 34.00313], [-118.36273, 34.00359], [-118.36275, 34.00364], [-118.3628, 34.00367], [-118.3631, 34.00368], [-118.36316, 34.0037], [-118.36319, 34.00374], [-118.36323, 34.00383], [-118.36324, 34.00399], [-118.36319, 34.00413], [-118.3631, 34.00423], [-118.36282, 34.00437], [-118.36276, 34.00446], [-118.36273, 34.00547], [-118.36302, 34.00544], [-118.36328, 34.00596], [-118.36435, 34.00558], [-118.36468, 34.00566], [-118.36502, 34.00555], [-118.36533, 34.00575], [-118.36572, 34.00574], [-118.36598, 34.00579], [-118.36632, 34.0058], [-118.36631, 34.006], [-118.36636, 34.00605], [-118.36648, 34.00606], [-118.36656, 34.00613], [-118.36689, 34.00614], [-118.36671, 34.00951], [-118.36649, 34.00944], [-118.36567, 34.00934], [-118.36566, 34.00941], [-118.36559, 34.00955], [-118.36551, 34.00967], [-118.36542, 34.00976], [-118.3658, 34.01021], [-118.36576, 34.01079], [-118.3647, 34.01095], [-118.36353, 34.01238], [-118.36301, 34.01239], [-118.36265, 34.00988], [-118.36257, 34.00983], [-118.3624, 34.00969], [-118.36234, 34.00961], [-118.36226, 34.00946], [-118.36221, 34.00929], [-118.36216, 34.0086], [-118.36176, 34.00861], [-118.36139, 34.00885], [-118.36069, 34.00903], [-118.36059, 34.00947], [-118.36081, 34.01031], [-118.36081, 34.01046], [-118.36079, 34.01051], [-118.36071, 34.01051], [-118.36066, 34.01048], [-118.36064, 34.01035], [-118.36061, 34.0103], [-118.36053, 34.01022], [-118.36016, 34.01048], [-118.35993, 34.01057], [-118.35958, 34.01057], [-118.35944, 34.01133], [-118.35888, 34.01123], [-118.35872, 34.01176], [-118.35801, 34.01162], [-118.35746, 34.01135], [-118.35713, 34.01164], [-118.35676, 34.01253], [-118.35625, 34.01245], [-118.35572, 34.01241], [-118.3558, 34.01214], [-118.35597, 34.01181], [-118.35611, 34.01161], [-118.35636, 34.01132], [-118.35706, 34.01063], [-118.3573, 34.01034], [-118.35742, 34.01017], [-118.35752, 34.00999], [-118.35767, 34.00966], [-118.35777, 34.0093], [-118.35866, 34.00922], [-118.36114, 34.00859], [-118.36145, 34.00849], [-118.36143, 34.00833], [-118.35861, 34.00905], [-118.3578, 34.00913], [-118.35782, 34.00868], [-118.3577, 34.00777], [-118.35772, 34.00736], [-118.35787, 34.00675]], [[-118.36462, 34.00779], [-118.36456, 34.0074], [-118.36387, 34.0075], [-118.36414, 34.00882], [-118.36479, 34.00874], [-118.36462, 34.00779]], [[-118.36192, 34.0073], [-118.36187, 34.00715], [-118.36148, 34.00725], [-118.36159, 34.00757], [-118.36198, 34.00748], [-118.36197, 34.00729], [-118.36192, 34.0073]]], [[[-118.37393, 34.01466], [-118.37395, 34.01485], [-118.37394, 34.0152], [-118.37391, 34.01541], [-118.37382, 34.01581], [-118.3737, 34.01614], [-118.37359, 34.0164], [-118.37276, 34.01791], [-118.37253, 34.01802], [-118.37256, 34.01751], [-118.37183, 34.01748], [-118.3712, 34.01725], [-118.37128, 34.01706], [-118.37118, 34.01685], [-118.37109, 34.01682], [-118.37133, 34.01636], [-118.37063, 34.01611], [-118.37026, 34.01593], [-118.37033, 34.01575], [-118.36672, 34.01562], [-118.36689, 34.0123], [-118.36709, 34.01102], [-118.36736, 34.00572], [-118.36938, 34.0058], [-118.36948, 34.00592], [-118.37003, 34.00645], [-118.37011, 34.00668], [-118.37023, 34.00718], [-118.37035, 34.00732], [-118.37056, 34.00747], [-118.37077, 34.00767], [-118.37082, 34.00774], [-118.37117, 34.00874], [-118.3715, 34.00958], [-118.3719, 34.0107], [-118.37209, 34.01116], [-118.37206, 34.01121], [-118.37215, 34.01131], [-118.37228, 34.01135], [-118.37248, 34.01135], [-118.37279, 34.01143], [-118.37287, 34.01141], [-118.37285, 34.01163], [-118.37286, 34.01191], [-118.37288, 34.01215], [-118.37293, 34.01231], [-118.37293, 34.01239], [-118.37288, 34.01247], [-118.37277, 34.01254], [-118.37284, 34.01268], [-118.37296, 34.01267], [-118.37308, 34.01274], [-118.3732, 34.01294], [-118.37353, 34.01338], [-118.37362, 34.01353], [-118.37369, 34.01368], [-118.37376, 34.01387], [-118.37393, 34.01466]]], [[[-118.38515, 34.01768], [-118.38493, 34.01795], [-118.38487, 34.01797], [-118.38488, 34.01808], [-118.38482, 34.01861], [-118.38479, 34.01875], [-118.38468, 34.01905], [-118.38463, 34.01912], [-118.38483, 34.01923], [-118.38433, 34.01942], [-118.38449, 34.0198], [-118.38271, 34.02031], [-118.38222, 34.02043], [-118.38131, 34.02057], [-118.38089, 34.02012], [-118.38051, 34.01986], [-118.37953, 34.01922], [-118.3791, 34.01929], [-118.37905, 34.01924], [-118.37943, 34.01918], [-118.37944, 34.01917], [-118.37876, 34.01873], [-118.37798, 34.01802], [-118.37914, 34.0173], [-118.37917, 34.01717], [-118.37924, 34.01718], [-118.37942, 34.01713], [-118.38069, 34.01635], [-118.38063, 34.01624], [-118.38053, 34.01615], [-118.38065, 34.01613], [-118.38061, 34.01581], [-118.38068, 34.01557], [-118.38064, 34.01526], [-118.38028, 34.01448], [-118.38298, 34.01585], [-118.38295, 34.01592], [-118.38465, 34.01689], [-118.38437, 34.01723], [-118.38515, 34.01768]], [[-118.38399, 34.01729], [-118.384, 34.01727], [-118.38397, 34.01715], [-118.38387, 34.017], [-118.38379, 34.01693], [-118.38372, 34.01689], [-118.38355, 34.01685], [-118.38334, 34.01686], [-118.38317, 34.01694], [-118.38303, 34.01707], [-118.38297, 34.01723], [-118.38298, 34.01737], [-118.38304, 34.0175], [-118.38312, 34.01758], [-118.38322, 34.01764], [-118.3834, 34.0177], [-118.38362, 34.01769], [-118.38369, 34.01767], [-118.38381, 34.0176], [-118.38395, 34.01746], [-118.38399, 34.01735], [-118.38399, 34.01729]]]]} | Open Access 1 | 6297 | Kenneth Hahn State Recreation Area | 32640 | 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 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://www.parks.ca.gov/?page_id=612 | Los Angeles 6 | 396.851 | Kenneth Hahn SRA | 0 | Local Recreation Area 3 | 4 |
16981 | 16981 | 16980 | {"type": "MultiPolygon", "coordinates": [[[[-118.78029, 34.06725], [-118.78027, 34.06762], [-118.77943, 34.06768], [-118.77942, 34.0682], [-118.77933, 34.06836], [-118.77924, 34.06846], [-118.77924, 34.06725], [-118.78029, 34.06725]]], [[[-118.79565, 34.08971], [-118.79456, 34.08971], [-118.79447, 34.08771], [-118.79557, 34.08772], [-118.79565, 34.08971]]], [[[-118.78033, 34.09684], [-118.77389, 34.09669], [-118.77389, 34.0976], [-118.7718, 34.09756], [-118.77172, 34.08925], [-118.78031, 34.08972], [-118.78033, 34.09684]]], [[[-118.34099, 34.1216], [-118.34086, 34.12169], [-118.34079, 34.12158], [-118.34061, 34.12124], [-118.34052, 34.12099], [-118.34043, 34.12068], [-118.34059, 34.12064], [-118.34074, 34.12113], [-118.34086, 34.12139], [-118.34099, 34.1216]]], [[[-118.74316, 34.13218], [-118.74273, 34.1326], [-118.73825, 34.13259], [-118.73676, 34.13119], [-118.74079, 34.12825], [-118.7414, 34.12957], [-118.74049, 34.13056], [-118.74091, 34.13105], [-118.74147, 34.13073], [-118.74173, 34.13146], [-118.74228, 34.13198], [-118.74316, 34.13218]]], [[[-118.72856, 34.13719], [-118.72831, 34.13737], [-118.72792, 34.1373], [-118.72732, 34.13723], [-118.72681, 34.13721], [-118.72614, 34.13723], [-118.72615, 34.13639], [-118.72652, 34.13639], [-118.72685, 34.13642], [-118.72711, 34.13646], [-118.72736, 34.13653], [-118.72759, 34.13661], [-118.72781, 34.13672], [-118.72856, 34.13719]]], [[[-118.80298, 34.14144], [-118.80298, 34.14144], [-118.7992, 34.14145], [-118.80024, 34.14054], [-118.80193, 34.13983], [-118.80298, 34.14144]]], [[[-117.74445, 34.13594], [-117.74441, 34.13607], [-117.744, 34.13607], [-117.74401, 34.13594], [-117.74445, 34.13594]]], [[[-117.74436, 34.13621], [-117.74431, 34.13635], [-117.744, 34.13635], [-117.744, 34.13621], [-117.74436, 34.13621]]], [[[-118.34497, 34.23305], [-118.34433, 34.23344], [-118.34435, 34.23237], [-118.34476, 34.23233], [-118.34484, 34.23284], [-118.3449, 34.23296], [-118.34497, 34.23305]]], [[[-118.33505, 34.26354], [-118.33487, 34.26359], [-118.33435, 34.26379], [-118.33417, 34.26352], [-118.33443, 34.2631], [-118.334, 34.2624], [-118.3341, 34.26243], [-118.33421, 34.26243], [-118.33458, 34.26241], [-118.33478, 34.26237], [-118.33505, 34.26354]]]]} | Open Access 1 | 47489 | Santa Monica Mountains Conservancy Open Space | 31208 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 219.446 | Santa Monica Mtns. Conservancy OS | 0 | Local Recreation Area 3 | 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]);