units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
341 rows where AGNCY_LEV = 4 and MNG_AG_TYP = 6 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, COUNTY, GAP_STS
DES_TP >30
MNG_AGENCY 7
- Mountains Recreation and Conservation Authority 274
- Conejo Open Space Conservation Agency 43
- Riverside County Habitat Conservation Agency 11
- Western Riverside County Regional Conservation Authority 7
- Solano Tri-City and County Cooperative Planning Group 2
- Rancho Simi Open Space Conservation Agency 2
- San Dieguito River Park Joint Powers Authority 2
ACCESS_TYP 4
- Open Access 179
- Unknown Access 138
- No Public Access 18
- Restricted Access 6
MNG_AG_TYP 1
- Open Space District · 341 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1047 | 1047 | 1046 | {"type": "MultiPolygon", "coordinates": [[[[-118.52781, 34.12892], [-118.52765, 34.12897], [-118.52752, 34.12899], [-118.52699, 34.12889], [-118.5269, 34.12887], [-118.52682, 34.12882], [-118.52674, 34.12872], [-118.52724, 34.12879], [-118.52781, 34.12892]]], [[[-118.52963, 34.12976], [-118.52948, 34.12986], [-118.5294, 34.12995], [-118.52935, 34.12974], [-118.52925, 34.12956], [-118.52963, 34.12976]]]]} | Open Access 1 | 6364 | Dirt Mulholland | 18160 | 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.435 | Dirt Mulholland | None 95 | |||
1273 | 1273 | 1272 | {"type": "Polygon", "coordinates": [[[-118.21161, 34.50894], [-118.21051, 34.50893], [-118.21051, 34.50802], [-118.2116, 34.50803], [-118.21161, 34.50894]]]} | Unknown Access 4 | 9563 | Red Rover Mine TaxDef | 24228 | 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 | 2.509 | Red Rover Mine TaxDef | None 110 | |||
2511 | 2511 | 2510 | {"type": "Polygon", "coordinates": [[[-118.51605, 34.05992], [-118.51605, 34.05992], [-118.51557, 34.05983], [-118.51602, 34.0595], [-118.51598, 34.0597], [-118.516, 34.05981], [-118.51605, 34.05992]]]} | Open Access 1 | 6356 | Topanga State Park | 26410 | 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.parks.ca.gov/?page_id=629 | Los Angeles 6 | 0.22 | Topanga SP | 1967 | None 206 | |
2757 | 2757 | 2756 | {"type": "MultiPolygon", "coordinates": [[[[-118.59473, 34.28578], [-118.59293, 34.28578], [-118.59293, 34.285], [-118.59312, 34.285], [-118.59312, 34.28575], [-118.59473, 34.28575], [-118.59473, 34.28578]]], [[[-118.59361, 34.28526], [-118.59361, 34.28556], [-118.59351, 34.28556], [-118.59352, 34.28526], [-118.59361, 34.28526]]], [[[-118.59668, 34.28578], [-118.59486, 34.28578], [-118.59486, 34.28575], [-118.59668, 34.28575], [-118.59668, 34.28578]]], [[[-118.60597, 34.28577], [-118.60597, 34.28579], [-118.59688, 34.28578], [-118.59688, 34.28575], [-118.60597, 34.28577]]], [[[-118.60374, 34.28244], [-118.60374, 34.28248], [-118.60327, 34.28222], [-118.59971, 34.28221], [-118.59971, 34.28218], [-118.60328, 34.28219], [-118.60374, 34.28244]]], [[[-118.60598, 34.2846], [-118.6054, 34.2846], [-118.60471, 34.2841], [-118.60429, 34.28329], [-118.6043, 34.28325], [-118.60474, 34.28409], [-118.60541, 34.28457], [-118.60598, 34.28457], [-118.60598, 34.2846]]]]} | Open Access 1 | 18451 | Deer Lake Highlands | 17998 | 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.806 | Deer Lake Highlands | None 231 | |||
3821 | 3821 | 3820 | {"type": "MultiPolygon", "coordinates": [[[[-116.37096, 33.91459], [-116.37095, 33.91825], [-116.36879, 33.91825], [-116.36881, 33.9146], [-116.37096, 33.91459]]], [[[-116.75455, 33.48392], [-116.75058, 33.48397], [-116.75043, 33.48095], [-116.75448, 33.4809], [-116.75455, 33.48392]]]]} | No Public Access 3 | 35202 | Riverside County Habitat Conservation Agency 4 | 24448 | 2122 | Riverside County Habitat Conservation Agency 570 | Special District 4 | Open Space District 6 | http://www.skrplan.org/ | Special District 4 | 2122 | Riverside County Habitat Conservation Agency 562 | Special District 4 | Open Space District 6 | Riverside 10 | 50.849 | Riverside County Habitat Conservation Agency 4 | None 321 | |||
3955 | 3955 | 3954 | {"type": "Polygon", "coordinates": [[[-118.26969, 34.25985], [-118.2653, 34.25981], [-118.26529, 34.25816], [-118.26968, 34.25821], [-118.26969, 34.25985]]]} | Unknown Access 4 | 46417 | Haines Canyon | 29694 | 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.279 | Haines Canyon | None 341 | |||
4309 | 4309 | 4308 | {"type": "Polygon", "coordinates": [[[-118.6329, 34.27478], [-118.63179, 34.27479], [-118.63171, 34.27158], [-118.63223, 34.2712], [-118.63279, 34.2712], [-118.6329, 34.27478]]]} | Unknown Access 4 | 10272 | Rocky Peak Adj. Tax Default | 24544 | 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 | 9.687 | Rocky Peak Adj. Tax Default | None 381 | |||
4961 | 4961 | 4960 | {"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 | 3659 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.186 | Las Casas - Grenola | None 411 | |||
4975 | 4975 | 4974 | {"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 | 3757 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.581 | Latigo Canyon - Malibu Vista | 0 | None 413 | ||
5327 | 5327 | 5326 | {"type": "Polygon", "coordinates": [[[-118.54192, 34.34956], [-118.5414, 34.34944], [-118.54058, 34.34899], [-118.54043, 34.34858], [-118.53937, 34.348], [-118.54132, 34.348], [-118.5413, 34.34712], [-118.54183, 34.34712], [-118.54192, 34.34956]]]} | Unknown Access 4 | 5651 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 6.619 | Newhall Pass | None 432 | |||
5467 | 5467 | 5466 | {"type": "MultiPolygon", "coordinates": [[[[-118.7371, 34.14821], [-118.73682, 34.14836], [-118.73634, 34.14855], [-118.73616, 34.14852], [-118.7357, 34.14837], [-118.73563, 34.14838], [-118.73559, 34.14843], [-118.73535, 34.14835], [-118.73448, 34.14736], [-118.73436, 34.14742], [-118.73395, 34.14693], [-118.73209, 34.14661], [-118.73173, 34.14543], [-118.73148, 34.14471], [-118.732, 34.14462], [-118.732, 34.14451], [-118.7311, 34.14255], [-118.73163, 34.14128], [-118.73169, 34.14123], [-118.73269, 34.14103], [-118.73382, 34.14184], [-118.73449, 34.14223], [-118.73474, 34.14262], [-118.73549, 34.14331], [-118.73632, 34.14342], [-118.73708, 34.14358], [-118.7371, 34.14821]]], [[[-118.7371, 34.1484], [-118.73693, 34.14849], [-118.73677, 34.14854], [-118.73661, 34.14857], [-118.73645, 34.14858], [-118.73677, 34.14846], [-118.7371, 34.14828], [-118.7371, 34.1484]]]]} | Open Access 1 | 48526 | Fran Pavley Meadow | 33240 | 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 | https://mrca.ca.gov/parks/park-listing/fran-pavley-meadow/ | Los Angeles 6 | 72.315 | Fran Pavley Meadow | 2016 | None 441 | |
5471 | 5471 | 5470 | {"type": "Polygon", "coordinates": [[[-118.81077, 34.11086], [-118.80637, 34.11085], [-118.80651, 34.10737], [-118.81077, 34.10736], [-118.81077, 34.11086]]]} | Open Access 1 | 48527 | Ballard Mountain | 33241 | 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 | 38.205 | Ballard Mtn. | 2017 | None 442 | ||
6005 | 6005 | 6004 | {"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 | 657 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.05 | Freeman Donation | None 484 | |||
6236 | 6236 | 6235 | {"type": "Polygon", "coordinates": [[[-118.89246, 34.19315], [-118.89175, 34.1939], [-118.89028, 34.19443], [-118.88966, 34.19408], [-118.88906, 34.19476], [-118.88987, 34.19604], [-118.8894, 34.19694], [-118.88972, 34.19697], [-118.88966, 34.19713], [-118.89015, 34.19725], [-118.89006, 34.19751], [-118.89001, 34.19774], [-118.88999, 34.198], [-118.88959, 34.19769], [-118.88879, 34.19745], [-118.88855, 34.19751], [-118.88834, 34.19765], [-118.88824, 34.19794], [-118.88804, 34.19816], [-118.88797, 34.19836], [-118.88738, 34.19819], [-118.88725, 34.19844], [-118.88696, 34.19837], [-118.88709, 34.19803], [-118.88613, 34.1978], [-118.88581, 34.19769], [-118.88563, 34.19762], [-118.88526, 34.19732], [-118.88448, 34.19616], [-118.88486, 34.19595], [-118.88521, 34.19571], [-118.8855, 34.19543], [-118.886, 34.19466], [-118.88615, 34.19447], [-118.88644, 34.1942], [-118.88685, 34.1946], [-118.88875, 34.19472], [-118.89055, 34.19262], [-118.89102, 34.19164], [-118.89122, 34.1917], [-118.891, 34.19217], [-118.89246, 34.19315]], [[-118.88823, 34.19625], [-118.88823, 34.19623], [-118.88779, 34.19566], [-118.88733, 34.19589], [-118.88775, 34.1965], [-118.88823, 34.19625]]]} | Open Access 1 | 1296 | Tarantula Hill | 26188 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | Ventura 8 | 45.359 | Tarantula Hill | None 504 | |||
6575 | 6575 | 6574 | {"type": "Polygon", "coordinates": [[[-118.87967, 34.10374], [-118.87858, 34.10373], [-118.87858, 34.10003], [-118.87967, 34.10005], [-118.87967, 34.10374]]]} | Open Access 1 | 3862 | Lebow | 21127 | 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.165 | Lebow | None 528 | |||
6628 | 6628 | 6627 | {"type": "Polygon", "coordinates": [[[-118.6131, 34.15759], [-118.61284, 34.15773], [-118.6126, 34.15756], [-118.61257, 34.1575], [-118.61278, 34.15736], [-118.6131, 34.15759]]]} | Unknown Access 4 | 4323 | Llano | 21388 | 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.253 | Llano | None 535 | |||
6649 | 6649 | 6648 | {"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.29749, 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.29796, 34.44367], [-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.29557, 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.44383], [-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 | 4665 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 32.557 | Long-Nellus Canyon | None 538 | |||
6803 | 6803 | 6802 | {"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 | 5319 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.379 | MGP Entrance | None 553 | |||
7507 | 7507 | 7506 | {"type": "MultiPolygon", "coordinates": [[[[-118.76984, 34.13463], [-118.76979, 34.14307], [-118.76879, 34.14306], [-118.76756, 34.14353], [-118.76664, 34.14329], [-118.76421, 34.14197], [-118.76402, 34.14081], [-118.76074, 34.13944], [-118.76063, 34.1394], [-118.76039, 34.13904], [-118.76984, 34.13463]]], [[[-118.78434, 34.14415], [-118.78301, 34.14387], [-118.78264, 34.14342], [-118.78207, 34.14297], [-118.78149, 34.14303], [-118.78095, 34.14403], [-118.78032, 34.14421], [-118.7804, 34.13564], [-118.78432, 34.13601], [-118.78434, 34.14415]]], [[[-118.78946, 34.14068], [-118.78571, 34.14064], [-118.78567, 34.13615], [-118.78741, 34.13631], [-118.78945, 34.13679], [-118.78946, 34.14068]]]]} | No Public Access 3 | 7088 | Ladyface Mountain | 29854 | 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 | 237.912 | Ladyface Mtn. | None 623 | |||
7533 | 7533 | 7532 | {"type": "Polygon", "coordinates": [[[-118.7905, 34.14119], [-118.79047, 34.14315], [-118.79021, 34.14303], [-118.78999, 34.143], [-118.78983, 34.143], [-118.78968, 34.14304], [-118.78947, 34.14313], [-118.78946, 34.1412], [-118.7905, 34.14119]]]} | Open Access 1 | 7111 | Ladyface Agoura | 29646 | 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 | 4.778 | Ladyface Agoura | None 627 |
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]);