units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, DES_TP = 2 and PARK_URL = "http://www.lamountains.com/parks.asp?parkid=34"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7236 | 7236 | 7235 | {"type": "MultiPolygon", "coordinates": [[[[-118.55281, 34.13042], [-118.55281, 34.13081], [-118.55278, 34.13088], [-118.55279, 34.13116], [-118.55284, 34.13124], [-118.55288, 34.13141], [-118.55312, 34.1321], [-118.55318, 34.13231], [-118.5532, 34.13262], [-118.55317, 34.13283], [-118.55311, 34.13302], [-118.55302, 34.13322], [-118.55282, 34.13348], [-118.55257, 34.1337], [-118.55212, 34.13397], [-118.55092, 34.13287], [-118.54979, 34.13265], [-118.54782, 34.13113], [-118.54744, 34.13054], [-118.55281, 34.13042]]], [[[-118.56115, 34.13075], [-118.56102, 34.13269], [-118.55843, 34.13257], [-118.55817, 34.13257], [-118.55791, 34.1326], [-118.55754, 34.1327], [-118.55731, 34.13279], [-118.5571, 34.13292], [-118.55682, 34.13314], [-118.55659, 34.1334], [-118.55648, 34.13359], [-118.5564, 34.1338], [-118.55635, 34.13401], [-118.55633, 34.13422], [-118.55637, 34.13454], [-118.55669, 34.13587], [-118.55675, 34.13625], [-118.55677, 34.13656], [-118.55676, 34.13688], [-118.55673, 34.1372], [-118.55667, 34.13751], [-118.55609, 34.13735], [-118.55555, 34.13662], [-118.55589, 34.13551], [-118.55502, 34.13472], [-118.55457, 34.13475], [-118.5529, 34.13436], [-118.5525, 34.134], [-118.55281, 34.13379], [-118.55299, 34.13363], [-118.55315, 34.13344], [-118.55332, 34.13314], [-118.55342, 34.13282], [-118.55345, 34.13249], [-118.55342, 34.13227], [-118.55338, 34.1321], [-118.55311, 34.13134], [-118.55307, 34.13117], [-118.55305, 34.13042], [-118.55994, 34.13027], [-118.56071, 34.13063], [-118.56092, 34.1307], [-118.56115, 34.13075]]], [[[-118.55665, 34.13757], [-118.55643, 34.13832], [-118.55594, 34.13909], [-118.55481, 34.14054], [-118.55481, 34.14093], [-118.55512, 34.14093], [-118.55524, 34.1409], [-118.55536, 34.14093], [-118.55552, 34.14093], [-118.55552, 34.14177], [-118.55505, 34.14208], [-118.55426, 34.1421], [-118.55423, 34.14146], [-118.55338, 34.14101], [-118.55311, 34.14055], [-118.55407, 34.13981], [-118.55398, 34.13873], [-118.55415, 34.1383], [-118.55442, 34.13797], [-118.55473, 34.13727], [-118.5555, 34.13666], [-118.55605, 34.13739], [-118.55665, 34.13757]]], [[[-118.55206, 34.134], [-118.55032, 34.13496], [-118.55015, 34.13508], [-118.54998, 34.13524], [-118.54977, 34.13549], [-118.54965, 34.13569], [-118.54954, 34.136], [-118.54951, 34.1362], [-118.54943, 34.13699], [-118.54933, 34.13747], [-118.54914, 34.13795], [-118.54857, 34.13917], [-118.54765, 34.13876], [-118.54632, 34.13886], [-118.54547, 34.13993], [-118.54523, 34.14043], [-118.5443, 34.14029], [-118.54388, 34.1403], [-118.54347, 34.14036], [-118.54309, 34.14047], [-118.54274, 34.14063], [-118.54242, 34.14084], [-118.54221, 34.14103], [-118.54225, 34.14097], [-118.54162, 34.14058], [-118.54126, 34.14104], [-118.54092, 34.14137], [-118.54065, 34.14172], [-118.54053, 34.14193], [-118.5405, 34.14209], [-118.54051, 34.14219], [-118.5405, 34.14244], [-118.53957, 34.14214], [-118.53887, 34.14302], [-118.5388, 34.14302], [-118.53878, 34.14312], [-118.53741, 34.14281], [-118.53738, 34.13106], [-118.53765, 34.1312], [-118.53821, 34.1314], [-118.53854, 34.13145], [-118.53888, 34.13144], [-118.53919, 34.13149], [-118.53934, 34.13149], [-118.53949, 34.13146], [-118.53963, 34.13141], [-118.53976, 34.13134], [-118.53986, 34.13125], [-118.53994, 34.13114], [-118.53999, 34.13102], [-118.54001, 34.13089], [-118.54, 34.13076], [-118.54004, 34.1307], [-118.54737, 34.13054], [-118.54777, 34.13116], [-118.54975, 34.1327], [-118.55088, 34.13292], [-118.55206, 34.134]]], [[[-118.60568, 34.14574], [-118.60551, 34.1459], [-118.60543, 34.14601], [-118.60537, 34.14617], [-118.60536, 34.14617], [-118.59468, 34.14211], [-118.5945, 34.14216], [-118.59427, 34.14233], [-118.59426, 34.14245], [-118.59424, 34.1425], [-118.59415, 34.14256], [-118.59403, 34.14257], [-118.59363, 34.14248], [-118.59354, 34.1425], [-118.59345, 34.14259], [-118.5937, 34.14295], [-118.59448, 34.14321], [-118.59424, 34.14327], [-118.59392, 34.1434], [-118.59354, 34.14362], [-118.59332, 34.14378], [-118.59305, 34.14403], [-118.59248, 34.14475], [-118.59233, 34.14482], [-118.59214, 34.14482], [-118.59204, 34.14477], [-118.59198, 34.14472], [-118.59192, 34.14462], [-118.59192, 34.14449], [-118.59194, 34.14443], [-118.59194, 34.14424], [-118.59188, 34.14406], [-118.59179, 34.14393], [-118.5917, 34.14384], [-118.59159, 34.14376], [-118.5914, 34.14367], [-118.59115, 34.14362], [-118.59097, 34.14362], [-118.59085, 34.14364], [-118.59055, 34.14373], [-118.59042, 34.14372], [-118.59034, 34.14369], [-118.59022, 34.1436], [-118.58974, 34.14289], [-118.5896, 34.14275], [-118.5894, 34.1426], [-118.58913, 34.14246], [-118.58886, 34.14237], [-118.58863, 34.14233], [-118.58831, 34.14231], [-118.58831, 34.13913], [-118.59832, 34.14293], [-118.59813, 34.1433], [-118.59858, 34.14348], [-118.59907, 34.14366], [-118.59927, 34.1433], [-118.60337, 34.14486], [-118.60317, 34.14521], [-118.60318, 34.14523], [-118.60362, 34.14539], [-118.60378, 34.14511], [-118.60407, 34.14522], [-118.60412, 34.14514], [-118.60568, 34.14574]]]]} | Open Access 1 | 6406 | Mulholland Gateway Park | 7189 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.lamountains.com/parks.asp?parkid=34 | Los Angeles 6 | 489.039 | Mulholland Gateway Park | 0 | Local Park 2 | 4 |
7241 | 7241 | 7240 | {"type": "MultiPolygon", "coordinates": [[[[-118.53739, 34.13313], [-118.53157, 34.13325], [-118.53157, 34.13088], [-118.53199, 34.13087], [-118.53211, 34.13106], [-118.53222, 34.13116], [-118.53235, 34.13123], [-118.53257, 34.13131], [-118.53273, 34.13133], [-118.53286, 34.13133], [-118.53312, 34.13149], [-118.53349, 34.13164], [-118.53375, 34.13172], [-118.53402, 34.13177], [-118.53442, 34.13179], [-118.53454, 34.13185], [-118.53467, 34.13189], [-118.53488, 34.13191], [-118.53512, 34.13187], [-118.53526, 34.13182], [-118.53538, 34.13174], [-118.53601, 34.13113], [-118.5361, 34.13098], [-118.53633, 34.1309], [-118.53662, 34.13086], [-118.53691, 34.13088], [-118.5371, 34.13094], [-118.53738, 34.13106], [-118.53739, 34.13313]]], [[[-118.56486, 34.13297], [-118.56316, 34.13469], [-118.56295, 34.13455], [-118.56085, 34.13667], [-118.5606, 34.13685], [-118.5603, 34.137], [-118.56009, 34.13706], [-118.55987, 34.13711], [-118.5585, 34.13724], [-118.55818, 34.13731], [-118.55806, 34.13707], [-118.55768, 34.13697], [-118.5576, 34.13691], [-118.55753, 34.13684], [-118.55749, 34.13675], [-118.55725, 34.13596], [-118.55671, 34.13596], [-118.55637, 34.13454], [-118.55633, 34.13422], [-118.55635, 34.13401], [-118.5564, 34.13379], [-118.55653, 34.13349], [-118.55666, 34.13331], [-118.55682, 34.13314], [-118.557, 34.13298], [-118.55731, 34.13279], [-118.55766, 34.13266], [-118.55804, 34.13258], [-118.55843, 34.13257], [-118.56101, 34.13269], [-118.56115, 34.13075], [-118.56138, 34.13078], [-118.56162, 34.13079], [-118.56206, 34.13074], [-118.56224, 34.13074], [-118.56251, 34.13079], [-118.56275, 34.1309], [-118.56288, 34.131], [-118.56454, 34.13248], [-118.5647, 34.13267], [-118.56486, 34.13297]]], [[[-118.57461, 34.13938], [-118.57442, 34.13933], [-118.57435, 34.13928], [-118.5743, 34.13921], [-118.57461, 34.13938]]], [[[-118.5767, 34.13939], [-118.57671, 34.13952], [-118.57676, 34.13972], [-118.57675, 34.1398], [-118.57635, 34.1406], [-118.5763, 34.1408], [-118.57596, 34.14006], [-118.57581, 34.13986], [-118.57562, 34.13969], [-118.57595, 34.13967], [-118.57616, 34.13962], [-118.5767, 34.13939]]], [[[-118.58569, 34.14247], [-118.58537, 34.14244], [-118.58491, 34.14234], [-118.58471, 34.14219], [-118.58456, 34.14211], [-118.58439, 34.14205], [-118.58406, 34.14197], [-118.58392, 34.14188], [-118.58341, 34.14141], [-118.58323, 34.14126], [-118.58291, 34.14107], [-118.58256, 34.14094], [-118.5816, 34.14028], [-118.58121, 34.14005], [-118.58093, 34.13992], [-118.57856, 34.13893], [-118.57785, 34.13868], [-118.57759, 34.13865], [-118.57741, 34.13867], [-118.57725, 34.13871], [-118.57709, 34.13878], [-118.5769, 34.13893], [-118.57617, 34.13925], [-118.57592, 34.13934], [-118.57573, 34.13936], [-118.57546, 34.13935], [-118.57528, 34.13932], [-118.57511, 34.13926], [-118.57413, 34.13873], [-118.57402, 34.13863], [-118.5739, 34.13856], [-118.57375, 34.1385], [-118.57359, 34.13847], [-118.57335, 34.13849], [-118.57208, 34.13873], [-118.57179, 34.13883], [-118.57154, 34.13899], [-118.57092, 34.13917], [-118.57067, 34.13919], [-118.57049, 34.13918], [-118.57031, 34.13915], [-118.57014, 34.13909], [-118.57006, 34.13905], [-118.56968, 34.13848], [-118.56952, 34.13833], [-118.56932, 34.13823], [-118.56916, 34.13819], [-118.569, 34.13818], [-118.56884, 34.13819], [-118.56841, 34.13796], [-118.56831, 34.13775], [-118.56821, 34.13762], [-118.56808, 34.13751], [-118.56793, 34.13743], [-118.56776, 34.13737], [-118.56758, 34.13733], [-118.56741, 34.13732], [-118.56724, 34.13734], [-118.5669, 34.13709], [-118.5667, 34.1369], [-118.56652, 34.1367], [-118.56643, 34.13651], [-118.56626, 34.13635], [-118.56612, 34.136], [-118.56605, 34.13574], [-118.56583, 34.13433], [-118.5659, 34.1342], [-118.56594, 34.13406], [-118.56595, 34.13385], [-118.56589, 34.13365], [-118.56573, 34.13332], [-118.56874, 34.13168], [-118.58139, 34.1365], [-118.5814, 34.13648], [-118.58368, 34.13647], [-118.58368, 34.13715], [-118.58382, 34.13716], [-118.58383, 34.13742], [-118.58568, 34.13813], [-118.58569, 34.14247]]], [[[-118.58569, 34.14299], [-118.58557, 34.14299], [-118.58538, 34.14295], [-118.58527, 34.14289], [-118.58516, 34.14276], [-118.58524, 34.14275], [-118.58569, 34.1428], [-118.58569, 34.14299]]], [[[-118.57569, 34.141], [-118.57511, 34.14315], [-118.57159, 34.14326], [-118.57087, 34.14295], [-118.57069, 34.14157], [-118.569, 34.14107], [-118.56925, 34.13989], [-118.56661, 34.139], [-118.56666, 34.13809], [-118.56682, 34.13808], [-118.56696, 34.13806], [-118.5671, 34.13801], [-118.56731, 34.1379], [-118.5674, 34.13787], [-118.56749, 34.13788], [-118.56772, 34.13799], [-118.56775, 34.13805], [-118.56781, 34.13822], [-118.56789, 34.13836], [-118.56806, 34.13853], [-118.56819, 34.13862], [-118.56835, 34.13869], [-118.5686, 34.13874], [-118.56878, 34.13875], [-118.56898, 34.13873], [-118.56905, 34.13873], [-118.56916, 34.13882], [-118.56968, 34.13961], [-118.56977, 34.13973], [-118.56989, 34.13983], [-118.57003, 34.13992], [-118.57019, 34.13998], [-118.5704, 34.14003], [-118.57062, 34.14003], [-118.57085, 34.14], [-118.57152, 34.13975], [-118.57175, 34.13962], [-118.57208, 34.13933], [-118.57226, 34.13925], [-118.57354, 34.13902], [-118.5736, 34.13907], [-118.57362, 34.13924], [-118.5737, 34.13945], [-118.57385, 34.13964], [-118.57398, 34.13975], [-118.57414, 34.13983], [-118.57431, 34.13989], [-118.57489, 34.13999], [-118.57503, 34.14003], [-118.57516, 34.14009], [-118.57526, 34.14017], [-118.57538, 34.14033], [-118.57569, 34.141]]], [[[-118.5751, 34.14321], [-118.57499, 34.14364], [-118.56847, 34.14354], [-118.56899, 34.14112], [-118.57063, 34.14161], [-118.57081, 34.14296], [-118.57086, 34.14297], [-118.57087, 34.14301], [-118.57158, 34.14331], [-118.5751, 34.14321]]]]} | Open Access 1 | 6410 | Mulholland Gateway Park | 7189 | 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 | http://www.lamountains.com/parks.asp?parkid=34 | Los Angeles 6 | 417.91 | Mulholland Gateway Park | 0 | Local Park 2 | 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]);