superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
139 rows where ACCESS_TYP = 1 and MNG_AGENCY = 27 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 119 ✖
ACCESS_TYP 1
- Open Access · 119 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4401 | 4401 | 4400 | {"type": "Polygon", "coordinates": [[[-118.87495, 34.0908], [-118.87495, 34.09139], [-118.87424, 34.09139], [-118.87424, 34.0908], [-118.87495, 34.0908]]]} | Open Access 1 | Freeman Donation | 19090 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1.05 | Freeman Donation | ||
4432 | 4432 | 4431 | {"type": "Polygon", "coordinates": [[[-118.65026, 34.11082], [-118.65026, 34.11446], [-118.63785, 34.11446], [-118.63676, 34.11386], [-118.63676, 34.11084], [-118.6411, 34.11084], [-118.65026, 34.11082]]]} | Open Access 1 | Fritz & Alma Meier Natural Use Area | 19126 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 123.024 | Fritz & Alma Meier Natural Use Area | ||
5010 | 5010 | 5009 | {"type": "Polygon", "coordinates": [[[-118.21396, 34.10912], [-118.21373, 34.10945], [-118.21319, 34.10986], [-118.21289, 34.11018], [-118.21235, 34.11095], [-118.21288, 34.11156], [-118.21273, 34.11194], [-118.21216, 34.11203], [-118.21173, 34.11207], [-118.21061, 34.11072], [-118.21135, 34.11055], [-118.21099, 34.11009], [-118.21022, 34.11025], [-118.21011, 34.11013], [-118.21088, 34.10996], [-118.21116, 34.10978], [-118.2106, 34.10917], [-118.21198, 34.10827], [-118.21371, 34.10856], [-118.2137, 34.10865], [-118.21396, 34.10912]]]} | Open Access 1 | Heidelberg Park | 19791 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 18.763 | Heidelberg Park | ||
5945 | 5945 | 5944 | {"type": "Polygon", "coordinates": [[[-118.33232, 34.11518], [-118.33231, 34.11561], [-118.33188, 34.11561], [-118.33189, 34.11558], [-118.33202, 34.11557], [-118.33203, 34.11518], [-118.33232, 34.11518]]]} | Open Access 1 | Lake Hollywood MRCA Open Space | 20946 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.324 | Lake Hollywood MRCA OS | ||
6029 | 6029 | 6028 | {"type": "Polygon", "coordinates": [[[-118.77646, 34.04802], [-118.77625, 34.04824], [-118.77619, 34.04837], [-118.77564, 34.04817], [-118.77587, 34.04802], [-118.77593, 34.04779], [-118.77646, 34.04802]]]} | Open Access 1 | Latigo Canyon - Malibu Vista | 21080 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.582 | Latigo Canyon - Malibu Vista | ||
6071 | 6071 | 6070 | {"type": "Polygon", "coordinates": [[[-118.87967, 34.10373], [-118.87858, 34.10373], [-118.87858, 34.10003], [-118.87967, 34.10005], [-118.87967, 34.10373]]]} | Open Access 1 | Lebow | 21127 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 10.164 | Lebow | ||
6072 | 6072 | 6071 | {"type": "MultiPolygon", "coordinates": [[[[-118.86601, 34.03617], [-118.86592, 34.03642], [-118.86581, 34.03643], [-118.86573, 34.03683], [-118.86572, 34.03685], [-118.86569, 34.03684], [-118.86578, 34.03639], [-118.8659, 34.03638], [-118.86597, 34.03617], [-118.86601, 34.03617]]], [[[-118.86946, 34.03654], [-118.86936, 34.03691], [-118.86885, 34.03681], [-118.86829, 34.03667], [-118.86709, 34.03629], [-118.86633, 34.0361], [-118.86629, 34.03604], [-118.86583, 34.03594], [-118.86592, 34.03571], [-118.86878, 34.03637], [-118.86946, 34.03654]]], [[[-118.86709, 34.03642], [-118.86702, 34.03661], [-118.86684, 34.03656], [-118.86691, 34.03636], [-118.86709, 34.03642]]]]} | Open Access 1 | Lechuza Beach | 21128 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 3.288 | Lechuza Beach | ||
6387 | 6387 | 6386 | {"type": "Polygon", "coordinates": [[[-118.22577, 34.08439], [-118.22566, 34.08489], [-118.22559, 34.0853], [-118.22555, 34.08575], [-118.22553, 34.08633], [-118.22551, 34.08637], [-118.22547, 34.08639], [-118.22539, 34.08637], [-118.22356, 34.08469], [-118.22387, 34.08445], [-118.22366, 34.08423], [-118.2238, 34.08412], [-118.22386, 34.08411], [-118.22391, 34.08411], [-118.22435, 34.08452], [-118.22478, 34.08421], [-118.22577, 34.08439]]]} | Open Access 1 | Los Angeles River Center and Gardens | 21500 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 6.713 | Los Angeles River Ctr. and Gardens | ||
6545 | 6545 | 6544 | {"type": "Polygon", "coordinates": [[[-118.73648, 34.07426], [-118.73436, 34.0741], [-118.73435, 34.07234], [-118.73648, 34.07246], [-118.73648, 34.07426]]]} | Open Access 1 | Malibu Bowl | 21702 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 9.554 | Malibu Bowl | ||
6549 | 6549 | 6548 | {"type": "Polygon", "coordinates": [[[-118.68919, 34.06009], [-118.68919, 34.06354], [-118.68048, 34.06325], [-118.68047, 34.06006], [-118.68919, 34.06009]]]} | Open Access 1 | Malibu Canyon - Bovenzi Open Space | 21703 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 73.255 | Malibu Canyon - Bovenzi OS | ||
7255 | 7255 | 7254 | {"type": "MultiPolygon", "coordinates": [[[[-118.60598, 34.29886], [-118.60172, 34.29885], [-118.60177, 34.30173], [-118.60114, 34.30172], [-118.60114, 34.30135], [-118.60019, 34.30079], [-118.59895, 34.30037], [-118.59818, 34.2995], [-118.59745, 34.2991], [-118.59743, 34.29884], [-118.59337, 34.29882], [-118.59332, 34.29527], [-118.60594, 34.29532], [-118.60598, 34.29886]]], [[[-118.60192, 34.30954], [-118.5977, 34.30949], [-118.59753, 34.30234], [-118.60178, 34.3024], [-118.60192, 34.30954]]]]} | Open Access 1 | MRCA Parkland | 22570 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 207.436 | MRCA Parkland | ||
7258 | 7258 | 7257 | {"type": "Polygon", "coordinates": [[[-118.64876, 34.13111], [-118.64858, 34.13138], [-118.64815, 34.13161], [-118.64807, 34.13167], [-118.64806, 34.13091], [-118.6487, 34.13091], [-118.64871, 34.13102], [-118.64876, 34.13111]]]} | Open Access 1 | MRCA Calabasas Open Space | 22568 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.921 | MRCA Calabasas OS | ||
7280 | 7280 | 7279 | {"type": "Polygon", "coordinates": [[[-118.3611, 34.12682], [-118.36097, 34.12699], [-118.36109, 34.12708], [-118.36098, 34.12719], [-118.36091, 34.12732], [-118.36077, 34.12724], [-118.36072, 34.12735], [-118.36057, 34.12747], [-118.36053, 34.1274], [-118.36065, 34.1273], [-118.36073, 34.12714], [-118.36079, 34.12706], [-118.36095, 34.12689], [-118.36102, 34.12679], [-118.3611, 34.12682]]]} | Open Access 1 | Mulholland Adjacent Open Space | 22590 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.28 | Mulholland Adjacent OS | ||
7548 | 7548 | 7547 | {"type": "Polygon", "coordinates": [[[-118.44646, 34.13576], [-118.44628, 34.13615], [-118.44605, 34.13646], [-118.44587, 34.13678], [-118.44548, 34.13674], [-118.44557, 34.13626], [-118.44578, 34.13618], [-118.44598, 34.13604], [-118.44613, 34.13585], [-118.44621, 34.13569], [-118.44646, 34.13576]]]} | Open Access 1 | Oak Forest Canyon Natural Area | 22963 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1.136 | Oak Forest Canyon Natural Area | ||
7779 | 7779 | 7778 | {"type": "Polygon", "coordinates": [[[-118.22982, 34.08555], [-118.22966, 34.08568], [-118.22908, 34.08522], [-118.22911, 34.08519], [-118.22943, 34.08538], [-118.22981, 34.08552], [-118.22982, 34.08555]]]} | Open Access 1 | Oso Park | 23235 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.218 | Oso Park | ||
8214 | 8214 | 8213 | {"type": "MultiPolygon", "coordinates": [[[[-118.68048, 34.06325], [-118.67835, 34.06318], [-118.67835, 34.06513], [-118.67748, 34.06508], [-118.67728, 34.06512], [-118.677, 34.06527], [-118.67687, 34.06528], [-118.67676, 34.06524], [-118.67659, 34.06507], [-118.6765, 34.06501], [-118.67636, 34.06495], [-118.67625, 34.06492], [-118.67624, 34.06311], [-118.67739, 34.06314], [-118.67738, 34.06166], [-118.67818, 34.06164], [-118.6782, 34.06005], [-118.68047, 34.06006], [-118.68048, 34.06325]]], [[[-118.67835, 34.06631], [-118.67625, 34.06617], [-118.67625, 34.06509], [-118.67634, 34.06512], [-118.67642, 34.06517], [-118.67667, 34.06538], [-118.67686, 34.06544], [-118.67706, 34.06542], [-118.67737, 34.06528], [-118.67749, 34.06524], [-118.67834, 34.06529], [-118.67835, 34.06631]]]]} | Open Access 1 | Piuma Ridge Park | 23753 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 36.883 | Piuma Ridge Park | ||
8446 | 8446 | 8445 | {"type": "MultiPolygon", "coordinates": [[[[-118.68895, 34.0753], [-118.68871, 34.07523], [-118.68849, 34.07523], [-118.68831, 34.07529], [-118.68805, 34.07544], [-118.68783, 34.07549], [-118.68769, 34.07548], [-118.68737, 34.0754], [-118.68719, 34.0754], [-118.6871, 34.07542], [-118.687, 34.07548], [-118.68683, 34.07564], [-118.68674, 34.0757], [-118.68663, 34.07574], [-118.68653, 34.07575], [-118.68637, 34.07573], [-118.68639, 34.07538], [-118.68589, 34.07537], [-118.68556, 34.07528], [-118.68529, 34.07535], [-118.68522, 34.07526], [-118.68511, 34.07521], [-118.68467, 34.07523], [-118.6845, 34.07522], [-118.68436, 34.07518], [-118.68389, 34.07604], [-118.68297, 34.07555], [-118.68053, 34.07806], [-118.67631, 34.07804], [-118.6763, 34.07443], [-118.68622, 34.07447], [-118.6863, 34.07455], [-118.68641, 34.07461], [-118.6865, 34.07464], [-118.68669, 34.07465], [-118.68676, 34.07468], [-118.68755, 34.07516], [-118.68766, 34.0752], [-118.68778, 34.07522], [-118.68793, 34.0752], [-118.68805, 34.07516], [-118.68822, 34.07504], [-118.68834, 34.07502], [-118.68843, 34.07505], [-118.68895, 34.0753]]], [[[-118.6859, 34.07613], [-118.68515, 34.07671], [-118.68494, 34.0766], [-118.68534, 34.0762], [-118.68563, 34.07611], [-118.6859, 34.07613]]], [[[-118.68692, 34.07621], [-118.68649, 34.07661], [-118.68632, 34.07662], [-118.68587, 34.07693], [-118.6856, 34.07666], [-118.68612, 34.07626], [-118.68625, 34.07631], [-118.68635, 34.07632], [-118.6868, 34.07622], [-118.68692, 34.07621]]]]} | Open Access 1 | Quaker--Dark Canyon | 24055 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 66.226 | Quaker--Dark Canyon | ||
8469 | 8469 | 8468 | {"type": "MultiPolygon", "coordinates": [[[[-118.21146, 34.09879], [-118.21115, 34.09901], [-118.21029, 34.09818], [-118.21037, 34.09809], [-118.21019, 34.09794], [-118.21044, 34.09773], [-118.21054, 34.0978], [-118.21078, 34.0979], [-118.21109, 34.09815], [-118.21137, 34.09856], [-118.21146, 34.09879]]], [[[-118.21383, 34.10142], [-118.21382, 34.10174], [-118.21354, 34.10186], [-118.21353, 34.10171], [-118.2133, 34.10134], [-118.21263, 34.10094], [-118.21265, 34.10091], [-118.21254, 34.10075], [-118.21251, 34.10076], [-118.21242, 34.10048], [-118.21257, 34.10041], [-118.21253, 34.10028], [-118.21246, 34.10017], [-118.21231, 34.10022], [-118.21215, 34.09998], [-118.21182, 34.09966], [-118.21142, 34.09952], [-118.21125, 34.09928], [-118.21127, 34.09904], [-118.21147, 34.09898], [-118.2116, 34.09914], [-118.21263, 34.10009], [-118.21292, 34.10075], [-118.21365, 34.10135], [-118.21371, 34.10146], [-118.21383, 34.10142]]], [[[-118.21386, 34.1012], [-118.21385, 34.10121], [-118.21383, 34.1012], [-118.2136, 34.10071], [-118.2138, 34.10064], [-118.21391, 34.10081], [-118.21392, 34.10086], [-118.21386, 34.1012]]]]} | Open Access 1 | Rainbow Canyon Park | 24084 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 4.769 | Rainbow Canyon Park | ||
8492 | 8492 | 8491 | {"type": "Polygon", "coordinates": [[[-118.79535, 34.03826], [-118.79477, 34.03824], [-118.79477, 34.03957], [-118.79361, 34.03957], [-118.79359, 34.03837], [-118.79107, 34.0391], [-118.79254, 34.03838], [-118.79212, 34.0374], [-118.79008, 34.03869], [-118.79052, 34.03807], [-118.7899, 34.03768], [-118.79316, 34.03568], [-118.79317, 34.03571], [-118.7931, 34.03572], [-118.79308, 34.03578], [-118.79313, 34.03582], [-118.79319, 34.03581], [-118.79331, 34.03629], [-118.79429, 34.03684], [-118.79448, 34.03785], [-118.79535, 34.03826]]]} | Open Access 1 | Ramirez Canyon Park | 24108 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 21.851 | Ramirez Canyon Park | ||
9054 | 9054 | 9053 | {"type": "MultiPolygon", "coordinates": [[[[-118.3565, 34.11322], [-118.35646, 34.11335], [-118.35625, 34.11361], [-118.35628, 34.11372], [-118.35595, 34.11394], [-118.35588, 34.11402], [-118.35578, 34.11422], [-118.35564, 34.11432], [-118.35397, 34.11366], [-118.35456, 34.11268], [-118.35482, 34.11246], [-118.35648, 34.11247], [-118.35643, 34.11269], [-118.35634, 34.11317], [-118.3565, 34.11322]]], [[[-118.35543, 34.11456], [-118.35533, 34.11513], [-118.35528, 34.11523], [-118.35444, 34.11562], [-118.35425, 34.11566], [-118.35417, 34.11565], [-118.35426, 34.11513], [-118.35481, 34.11485], [-118.35486, 34.11459], [-118.35493, 34.11444], [-118.35515, 34.11442], [-118.35543, 34.11456]]]]} | Open Access 1 | Runyon Canyon Park | 24732 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 10.17 | Runyon Canyon Park |
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]);