superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
181 rows where MNG_AGENCY = 27
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4376 | 4376 | 4375 | {"type": "Polygon", "coordinates": [[[-118.32897, 34.10547], [-118.32877, 34.10597], [-118.32865, 34.10616], [-118.32806, 34.1056], [-118.32807, 34.10559], [-118.32819, 34.10555], [-118.32853, 34.1055], [-118.32891, 34.10541], [-118.32895, 34.10543], [-118.32897, 34.10547]]]} | Open Access 1 | Franklin Ivar Park | 19059 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.862 | Franklin Ivar Park | ||
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 | ||
5891 | 5891 | 5890 | {"type": "MultiPolygon", "coordinates": [[[[-118.58536, 34.37309], [-118.58501, 34.37311], [-118.58501, 34.37384], [-118.58474, 34.37372], [-118.58451, 34.37352], [-118.58428, 34.3737], [-118.58413, 34.37367], [-118.58393, 34.37354], [-118.58391, 34.37323], [-118.58371, 34.3731], [-118.58347, 34.37331], [-118.58335, 34.37347], [-118.58331, 34.37362], [-118.58326, 34.37363], [-118.5832, 34.37367], [-118.58317, 34.37372], [-118.58317, 34.37376], [-118.58271, 34.37408], [-118.58263, 34.37427], [-118.58266, 34.37444], [-118.5827, 34.37452], [-118.58287, 34.37454], [-118.58286, 34.37458], [-118.58273, 34.37456], [-118.58215, 34.37455], [-118.58215, 34.37467], [-118.58277, 34.37507], [-118.58274, 34.3754], [-118.58195, 34.37539], [-118.58193, 34.37574], [-118.5814, 34.37587], [-118.58139, 34.37427], [-118.58108, 34.37426], [-118.58101, 34.37074], [-118.58532, 34.37075], [-118.58536, 34.37309]]], [[[-118.59396, 34.37062], [-118.59325, 34.37056], [-118.59308, 34.3706], [-118.59305, 34.37054], [-118.59297, 34.3705], [-118.5929, 34.3705], [-118.59285, 34.37052], [-118.59275, 34.37046], [-118.59255, 34.37043], [-118.59241, 34.37045], [-118.59231, 34.37057], [-118.59228, 34.37085], [-118.59228, 34.37129], [-118.59226, 34.37143], [-118.59063, 34.37142], [-118.58965, 34.37239], [-118.58961, 34.36807], [-118.58962, 34.36713], [-118.59392, 34.36708], [-118.59396, 34.37062]]]]} | Unknown Access 4 | Laing - Brookfield | 20873 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 81.718 | Laing - Brookfield | ||
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 | ||
6011 | 6011 | 6010 | {"type": "Polygon", "coordinates": [[[-118.54326, 34.04416], [-118.54305, 34.04417], [-118.54302, 34.0442], [-118.54286, 34.04405], [-118.54306, 34.04392], [-118.54313, 34.04389], [-118.54316, 34.04389], [-118.54323, 34.04403], [-118.54326, 34.04416]]]} | Unknown Access 4 | Las Casas - Grenola | 21045 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.186 | Las Casas - Grenola | ||
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 | ||
6312 | 6312 | 6311 | {"type": "Polygon", "coordinates": [[[-118.6131, 34.15759], [-118.61284, 34.15773], [-118.61261, 34.15756], [-118.61257, 34.1575], [-118.61278, 34.15736], [-118.6131, 34.15759]]]} | Unknown Access 4 | Llano | 21388 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.253 | Llano | ||
6359 | 6359 | 6358 | {"type": "MultiPolygon", "coordinates": [[[[-118.29844, 34.44508], [-118.29404, 34.44509], [-118.29401, 34.44186], [-118.29504, 34.44221], [-118.2953, 34.44234], [-118.29557, 34.44244], [-118.2959, 34.44251], [-118.29627, 34.44254], [-118.29669, 34.44251], [-118.29719, 34.44244], [-118.29748, 34.44236], [-118.29796, 34.44218], [-118.29818, 34.44207], [-118.2984, 34.44193], [-118.29841, 34.44299], [-118.29831, 34.4431], [-118.29828, 34.44322], [-118.2983, 34.44331], [-118.29842, 34.44357], [-118.29842, 34.44367], [-118.29836, 34.44368], [-118.29816, 34.44362], [-118.29804, 34.44363], [-118.29797, 34.44366], [-118.29791, 34.44371], [-118.29788, 34.44377], [-118.29786, 34.44384], [-118.29788, 34.4444], [-118.29792, 34.44455], [-118.29799, 34.44466], [-118.29827, 34.44495], [-118.29835, 34.445], [-118.29844, 34.44502], [-118.29844, 34.44508]]], [[[-118.29807, 34.44144], [-118.29789, 34.44157], [-118.29769, 34.44168], [-118.29739, 34.44177], [-118.29685, 34.44187], [-118.29629, 34.4419], [-118.29592, 34.44188], [-118.29555, 34.44183], [-118.29556, 34.44176], [-118.29537, 34.44172], [-118.29486, 34.44142], [-118.29807, 34.44144]]], [[[-118.29843, 34.44485], [-118.29815, 34.44456], [-118.29809, 34.44445], [-118.29806, 34.44384], [-118.29808, 34.4438], [-118.29811, 34.44378], [-118.29815, 34.44378], [-118.29831, 34.44384], [-118.29842, 34.44384], [-118.29843, 34.44485]]]]} | Unknown Access 4 | Long-Nellus Canyon | 21446 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 32.554 | Long-Nellus Canyon | ||
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 | ||
6966 | 6966 | 6965 | {"type": "Polygon", "coordinates": [[[-118.57899, 34.14891], [-118.57845, 34.14895], [-118.57849, 34.14866], [-118.57892, 34.14859], [-118.57899, 34.14891]]]} | Unknown Access 4 | MGP Entrance | 22194 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.379 | MGP Entrance | ||
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 | ||
7359 | 7359 | 7358 | {"type": "Polygon", "coordinates": [[[-118.54192, 34.34956], [-118.5414, 34.34944], [-118.54058, 34.34899], [-118.54043, 34.34858], [-118.53937, 34.348], [-118.54131, 34.348], [-118.5413, 34.34712], [-118.54183, 34.34712], [-118.54192, 34.34956]]]} | Unknown Access 4 | Newhall Pass | 22727 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 6.628 | Newhall Pass |
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]);