units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where DES_TP = 2 and MNG_AGENCY = 27 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, COUNTY, YR_EST
AGNCY_NAME 10 ✖
- Mountains Recreation and Conservation Authority 43
- Santa Monica Mountains Conservancy 15
- Rancho Palos Verdes, City of 2
- Los Angeles, City of 1
- Ventura, County of 1
- Los Angeles - Department of Water and Power, City of 1
- California Department of Transportation 1
- Whittier, City of 1
- Desert and Mountain Conservation Authority 1
- Baldwin Hills Regional Conservation Authority 1
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 67 ✖
DES_TP 1
- Local Park · 67 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5641 | 5641 | 5640 | {"type": "Polygon", "coordinates": [[[-118.22852, 34.08438], [-118.2285, 34.0844], [-118.22844, 34.0843], [-118.22835, 34.08422], [-118.22833, 34.08418], [-118.22835, 34.08399], [-118.22852, 34.08438]]]} | Open Access 1 | 46908 | Egret Park | 30449 | 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 | Los Angeles 6 | 0.055 | Egret Park | 0 | Local Park 2 | 4 | |
7412 | 7412 | 7411 | {"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 | 6926 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.218 | Oso Park | 0 | Local Park 2 | 4 | |
7447 | 7447 | 7446 | {"type": "MultiPolygon", "coordinates": [[[[-118.22877, 34.08683], [-118.22866, 34.08675], [-118.22875, 34.08668], [-118.22875, 34.08668], [-118.22877, 34.08683]]], [[[-118.22915, 34.08683], [-118.22891, 34.08704], [-118.22889, 34.08693], [-118.22882, 34.08688], [-118.22879, 34.08664], [-118.22885, 34.08659], [-118.22915, 34.08683]]]]} | No Public Access 3 | 6921 | Steelhead Park | 25823 | 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.219 | Steelhead Park | 0 | Local Park 2 | 4 | |
7446 | 7446 | 7445 | {"type": "MultiPolygon", "coordinates": [[[[-118.24291, 34.10283], [-118.24291, 34.10283], [-118.2429, 34.10308], [-118.24276, 34.10294], [-118.24291, 34.10283]]], [[[-118.24334, 34.103], [-118.24304, 34.10321], [-118.24295, 34.10313], [-118.24296, 34.1028], [-118.24306, 34.10272], [-118.24334, 34.103]]]]} | Open Access 1 | 6919 | Elysian Valley Gateway Park | 18608 | 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 | Los Angeles 6 | 0.321 | Elysian Valley Gateway Park | 0 | Local Park 2 | 4 | |
15240 | 15240 | 15239 | {"type": "Polygon", "coordinates": [[[-118.62073, 34.19735], [-118.62041, 34.19737], [-118.6201, 34.19741], [-118.6198, 34.19749], [-118.6194, 34.19763], [-118.6194, 34.19749], [-118.6193, 34.19749], [-118.6193, 34.19743], [-118.61926, 34.19743], [-118.61925, 34.19737], [-118.6188, 34.19737], [-118.6188, 34.19735], [-118.62073, 34.19735]]]} | Unknown Access 4 | 46238 | Bell Creek Park | 29516 | 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 | Los Angeles 6 | 0.384 | Bell Creek Park | 0 | Local Park 2 | 4 | |
7428 | 7428 | 7427 | {"type": "Polygon", "coordinates": [[[-118.22601, 34.0822], [-118.22554, 34.08201], [-118.22525, 34.08188], [-118.22546, 34.08173], [-118.22558, 34.08171], [-118.22568, 34.08174], [-118.22578, 34.08182], [-118.22601, 34.0822]]]} | No Public Access 3 | 6924 | Confluence Park | 29794 | 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 | Los Angeles 6 | 0.393 | Confluence Park | 2003 | Local Park 2 | 4 | |
15267 | 15267 | 15266 | {"type": "Polygon", "coordinates": [[[-118.39447, 34.12764], [-118.39428, 34.12782], [-118.39414, 34.12791], [-118.39396, 34.12797], [-118.39376, 34.12798], [-118.39355, 34.12794], [-118.39338, 34.12786], [-118.39328, 34.12777], [-118.39311, 34.12755], [-118.39321, 34.1275], [-118.39337, 34.12771], [-118.39347, 34.12779], [-118.39358, 34.12784], [-118.39376, 34.12789], [-118.39396, 34.12787], [-118.39408, 34.12783], [-118.39418, 34.12776], [-118.39438, 34.12758], [-118.39447, 34.12764]]]} | Open Access 1 | 46331 | Fryman Canyon Park | 29621 | 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 | Los Angeles 6 | 0.403 | Fryman Canyon Park | 0 | Local Park 2 | 4 | |
15272 | 15272 | 15271 | {"type": "Polygon", "coordinates": [[[-118.60349, 34.03929], [-118.60304, 34.03933], [-118.60253, 34.03932], [-118.60254, 34.03911], [-118.60277, 34.03913], [-118.60296, 34.03912], [-118.60331, 34.03908], [-118.60345, 34.03903], [-118.60349, 34.03929]]]} | Unknown Access 4 | 46353 | Las Tunas Beach | 29634 | 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 | Los Angeles 6 | 0.511 | Las Tunas Beach | 0 | Local Park 2 | 4 | |
13118 | 13118 | 13117 | {"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 | 45044 | Franklin Ivar Park | 19059 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.862 | Franklin Ivar Park | 0 | Local Park 2 | 4 | |
15201 | 15201 | 15200 | {"type": "Polygon", "coordinates": [[[-118.41981, 33.98441], [-118.4179, 33.98583], [-118.41786, 33.98591], [-118.41784, 33.98601], [-118.41786, 33.98605], [-118.41782, 33.98606], [-118.41773, 33.98597], [-118.41734, 33.98624], [-118.41726, 33.98615], [-118.41972, 33.98432], [-118.41981, 33.98441]]]} | Open Access 1 | 46080 | Milton Street Park | 29422 | 500 | Baldwin Hills Regional Conservation Authority 1140 | Joint 8 | Joint Powers Authority 24 | http://smmc.ca.gov/BHRCA.asp | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.029 | Milton Street Park | 0 | Local Park 2 | 4 | |
14719 | 14719 | 14718 | {"type": "Polygon", "coordinates": [[[-118.43673, 34.27426], [-118.43631, 34.27511], [-118.43575, 34.27622], [-118.43553, 34.27602], [-118.43556, 34.27597], [-118.43552, 34.27593], [-118.43595, 34.2753], [-118.43628, 34.27472], [-118.4367, 34.27423], [-118.43673, 34.27426]]]} | Open Access 1 | 45067 | Pacoima Wash Greenway - El Dorado Park | 28071 | 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 | Los Angeles 6 | 1.197 | Pacoima Wash Greenway - El Dorado Park | 0 | Local Park 2 | 4 | |
15258 | 15258 | 15257 | {"type": "Polygon", "coordinates": [[[-118.22167, 34.10123], [-118.22164, 34.10136], [-118.22162, 34.10133], [-118.2215, 34.10138], [-118.22152, 34.10147], [-118.22133, 34.10152], [-118.22133, 34.10135], [-118.22132, 34.10134], [-118.22045, 34.1016], [-118.22027, 34.1012], [-118.22067, 34.10102], [-118.2211, 34.10072], [-118.22167, 34.10123]]]} | Open Access 1 | 46322 | Elyria Canyon Park | 18607 | 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 | 1.644 | Elyria Canyon Park | 0 | Local Park 2 | 4 | |
6576 | 6576 | 6575 | {"type": "MultiPolygon", "coordinates": [[[[-118.86601, 34.03617], [-118.86592, 34.03642], [-118.86581, 34.03642], [-118.86573, 34.03683], [-118.86572, 34.03685], [-118.86569, 34.03684], [-118.86578, 34.03639], [-118.8659, 34.03639], [-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.86632, 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 | 3873 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 3.287 | Lechuza Beach | 0 | Local Park 2 | 4 | |
7419 | 7419 | 7418 | {"type": "MultiPolygon", "coordinates": [[[[-118.21146, 34.09879], [-118.21115, 34.09901], [-118.21029, 34.09818], [-118.21037, 34.0981], [-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.21266, 34.10092], [-118.21253, 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.21181, 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.21291, 34.10074], [-118.21365, 34.10135], [-118.21371, 34.10147], [-118.21383, 34.10142]]], [[[-118.2138, 34.10064], [-118.21391, 34.10081], [-118.21392, 34.10086], [-118.21386, 34.1012], [-118.21385, 34.10121], [-118.21383, 34.1012], [-118.2136, 34.10071], [-118.2138, 34.10064]]]]} | Open Access 1 | 6859 | Rainbow Canyon Park | 24084 | 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.762 | Rainbow Canyon Park | 0 | Local Park 2 | 4 | |
8430 | 8430 | 8429 | {"type": "Polygon", "coordinates": [[[-118.24826, 34.10728], [-118.24782, 34.10776], [-118.24662, 34.10738], [-118.24607, 34.10715], [-118.24571, 34.10698], [-118.24595, 34.10654], [-118.24634, 34.10669], [-118.24658, 34.10644], [-118.2469, 34.10665], [-118.24736, 34.10618], [-118.24816, 34.10671], [-118.24788, 34.10706], [-118.24826, 34.10728]]]} | Open Access 1 | 47966 | Lewis MacAdams Riverfront Park | 32845 | 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 | Los Angeles 6 | 5.449 | Lewis MacAdams Riverfront Park | 0 | Local Park 2 | 4 | |
6944 | 6944 | 6943 | {"type": "Polygon", "coordinates": [[[-118.51425, 34.12874], [-118.51314, 34.12885], [-118.51295, 34.12889], [-118.51277, 34.12897], [-118.51247, 34.12916], [-118.51234, 34.12922], [-118.5122, 34.12925], [-118.51188, 34.12928], [-118.51171, 34.12932], [-118.51174, 34.12898], [-118.51348, 34.12757], [-118.51357, 34.12725], [-118.51425, 34.12725], [-118.51425, 34.12874]]]} | Open Access 1 | 6365 | San Vicente Mountain Park | 29687 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 6.37 | San Vicente Mtn. Park | 0 | Local Park 2 | 4 | |
7438 | 7438 | 7437 | {"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.22388, 34.08444], [-118.22366, 34.08423], [-118.2238, 34.08412], [-118.22386, 34.08411], [-118.22391, 34.08411], [-118.22436, 34.08452], [-118.22478, 34.08421], [-118.22577, 34.08439]]]} | Open Access 1 | 6923 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 6.707 | Los Angeles River Ctr. and Gardens | 0 | Local Park 2 | 4 | |
9484 | 9484 | 9483 | {"type": "MultiPolygon", "coordinates": [[[[-118.3565, 34.11322], [-118.35646, 34.11335], [-118.35625, 34.11361], [-118.35628, 34.11372], [-118.35595, 34.11393], [-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.35482, 34.11485], [-118.35486, 34.11459], [-118.35493, 34.11444], [-118.35515, 34.11442], [-118.35543, 34.11456]]]]} | Open Access 1 | 47827 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 10.167 | Runyon Canyon Park | 0 | Local Park 2 | 4 | |
115 | 115 | 114 | {"type": "Polygon", "coordinates": [[[-118.77562, 34.03262], [-118.77533, 34.03337], [-118.77526, 34.03417], [-118.77391, 34.03402], [-118.77397, 34.03297], [-118.77225, 34.0325], [-118.77235, 34.03205], [-118.77242, 34.03192], [-118.7725, 34.03184], [-118.7726, 34.03179], [-118.77271, 34.03175], [-118.77283, 34.03174], [-118.773, 34.03177], [-118.77369, 34.03203], [-118.77383, 34.03206], [-118.77404, 34.03206], [-118.77425, 34.03201], [-118.77476, 34.03219], [-118.77512, 34.0325], [-118.77562, 34.03262]]]} | Open Access 1 | 345 | Escondido Canyon Park | 29611 | 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 | 10.379 | Escondido Canyon Park | 0 | Local Park 2 | 4 | |
415 | 415 | 414 | {"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.21136, 34.11055], [-118.21098, 34.11009], [-118.21022, 34.11025], [-118.21011, 34.11013], [-118.21088, 34.10996], [-118.21117, 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 | 1647 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 18.734 | Heidelberg 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]);