units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where ACCESS_TYP = 4 and MNG_AG_TYP = 6 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY, GAP_STS
DES_TP 23
AGNCY_TYP 6 ✖
MNG_AGENCY 3
MNG_AG_TYP 1
- Open Space District · 151 ✖
ACCESS_TYP 1
- Unknown Access · 151 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
4482 | 4482 | 4481 | {"type": "Polygon", "coordinates": [[[-118.82809, 34.1109], [-118.82374, 34.11089], [-118.82373, 34.10731], [-118.82808, 34.10728], [-118.82809, 34.1109]]]} | Unknown Access 4 | 4333 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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 | 39.614 | 0 | Local Other or Unknown 14 | 4 | ||
4483 | 4483 | 4482 | {"type": "Polygon", "coordinates": [[[-118.83243, 34.10717], [-118.83243, 34.10853], [-118.82873, 34.10863], [-118.82809, 34.10863], [-118.82808, 34.10727], [-118.82875, 34.10727], [-118.83243, 34.10717]]]} | Unknown Access 4 | 4342 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 14.94 | 0 | Local Other or Unknown 14 | 4 | ||
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 | |||
4489 | 4489 | 4488 | {"type": "MultiPolygon", "coordinates": [[[[-118.21759, 34.10846], [-118.21735, 34.1085], [-118.21726, 34.10813], [-118.21751, 34.10809], [-118.21759, 34.10846]]], [[[-118.21918, 34.10822], [-118.21901, 34.10857], [-118.21832, 34.10834], [-118.21784, 34.10842], [-118.21775, 34.10805], [-118.21837, 34.10795], [-118.21918, 34.10822]]]]} | Unknown Access 4 | 4922 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.517 | 0 | Local Other or Unknown 14 | 4 | ||
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 | |||
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 | |||
7025 | 7025 | 7024 | {"type": "Polygon", "coordinates": [[[-118.00435, 34.00067], [-118.00072, 34.00684], [-117.99905, 34.00616], [-117.99865, 34.00604], [-117.99811, 34.00594], [-117.99769, 34.00592], [-117.9972, 34.00594], [-117.99674, 34.00602], [-117.99656, 34.00606], [-117.99617, 34.00619], [-117.99577, 34.00638], [-117.99538, 34.00662], [-117.995, 34.00693], [-117.99481, 34.00713], [-117.99462, 34.00739], [-117.99442, 34.00773], [-117.99436, 34.00788], [-117.99402, 34.00902], [-117.99395, 34.00922], [-117.99391, 34.0093], [-117.99494, 34.00555], [-117.99575, 34.0047], [-117.99784, 34.0031], [-117.99943, 34.00315], [-118.00071, 34.00186], [-118.00161, 34.00193], [-118.0024, 34.00178], [-118.00309, 34.0011], [-118.00371, 34.00108], [-118.00435, 34.00067]]]} | Unknown Access 4 | 6507 | Hacienda Hills Open Space | 29675 | 2332 | Puente Hills Habitat Preservation Authority 849 | Special District 4 | Conservation District 31 | http://www.habitatauthority.org | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 62.094 | Hacienda Hills OS | 0 | Local Recreation Area 3 | 4 | |
15589 | 15589 | 15588 | {"type": "Polygon", "coordinates": [[[-118.00977, 34.00681], [-118.00047, 34.02256], [-117.99322, 34.01961], [-117.99553, 34.01569], [-117.99582, 34.0158], [-117.99633, 34.01493], [-117.99605, 34.0148], [-118.00515, 33.99931], [-118.00592, 33.99969], [-118.00608, 33.99979], [-118.00624, 33.99992], [-118.00635, 34.00003], [-118.00702, 34.00098], [-118.00716, 34.00115], [-118.00742, 34.00135], [-118.00767, 34.00147], [-118.0079, 34.00193], [-118.00888, 34.00585], [-118.00977, 34.00681]]]} | Unknown Access 4 | 6546 | Hacienda Hills Open Space - Sanitation District | 29676 | 2139 | Sanitation Districts of Los Angeles County 290 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 419.341 | Hacienda Hills OS - Sanitation District | 0 | Local Other or Unknown 14 | 4 | |
4504 | 4504 | 4503 | {"type": "MultiPolygon", "coordinates": [[[[-118.27189, 34.25899], [-118.2716, 34.25922], [-118.2716, 34.25779], [-118.27178, 34.25778], [-118.27189, 34.25756], [-118.27189, 34.25899]]], [[[-118.27237, 34.25554], [-118.27236, 34.25643], [-118.27206, 34.25642], [-118.27207, 34.25578], [-118.27217, 34.25566], [-118.27237, 34.25554]]], [[[-118.27285, 34.2587], [-118.27285, 34.25987], [-118.27263, 34.25987], [-118.27263, 34.25887], [-118.27285, 34.2587]]], [[[-118.27406, 34.25636], [-118.27354, 34.2563], [-118.27351, 34.25638], [-118.27362, 34.25645], [-118.27348, 34.25653], [-118.27348, 34.25563], [-118.27335, 34.25554], [-118.27335, 34.25468], [-118.27359, 34.25468], [-118.27359, 34.25569], [-118.27369, 34.25576], [-118.27406, 34.25565], [-118.27406, 34.25636]]]]} | Unknown Access 4 | 6855 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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 | 3.721 | 0 | Local Other or Unknown 14 | 4 | ||
4507 | 4507 | 4506 | {"type": "Polygon", "coordinates": [[[-118.37116, 34.12047], [-118.37096, 34.12061], [-118.37088, 34.12062], [-118.37083, 34.12058], [-118.37088, 34.12031], [-118.37103, 34.12024], [-118.37116, 34.12047]]]} | Unknown Access 4 | 6890 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.191 | 0 | Local Other or Unknown 14 | 4 | ||
7204 | 7204 | 7203 | {"type": "Polygon", "coordinates": [[[-118.36759, 34.13349], [-118.36743, 34.13395], [-118.36738, 34.13394], [-118.36736, 34.13386], [-118.36729, 34.13382], [-118.36698, 34.13377], [-118.3668, 34.13377], [-118.36673, 34.13381], [-118.36668, 34.1337], [-118.36679, 34.13361], [-118.36681, 34.13361], [-118.36697, 34.1335], [-118.36722, 34.13344], [-118.36717, 34.13334], [-118.36759, 34.13349]]]} | Unknown Access 4 | 6892 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.681 | 0 | Local Other or Unknown 14 | 4 | ||
4511 | 4511 | 4510 | {"type": "Polygon", "coordinates": [[[-118.75427, 34.16206], [-118.7528, 34.16289], [-118.75305, 34.16324], [-118.75218, 34.16381], [-118.75052, 34.1638], [-118.75016, 34.1634], [-118.74922, 34.16397], [-118.74932, 34.16485], [-118.74577, 34.16484], [-118.74578, 34.15444], [-118.75019, 34.15445], [-118.75017, 34.15687], [-118.75077, 34.15683], [-118.75171, 34.15863], [-118.75245, 34.15924], [-118.75258, 34.15956], [-118.75315, 34.16008], [-118.75269, 34.16057], [-118.75282, 34.16118], [-118.75304, 34.16161], [-118.75416, 34.1616], [-118.75427, 34.16206]]]} | Unknown Access 4 | 7093 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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 | 154.044 | 0 | Local Other or Unknown 14 | 4 | ||
7291 | 7291 | 7290 | {"type": "Polygon", "coordinates": [[[-118.44137, 34.09262], [-118.44135, 34.09273], [-118.44123, 34.09285], [-118.44109, 34.09258], [-118.44137, 34.09262]]]} | Unknown Access 4 | 7131 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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.106 | 0 | Local Other or Unknown 14 | 4 | ||
7590 | 7590 | 7589 | {"type": "Polygon", "coordinates": [[[-118.58536, 34.37309], [-118.58501, 34.3731], [-118.58501, 34.37384], [-118.58474, 34.37372], [-118.58451, 34.37352], [-118.58428, 34.3737], [-118.58414, 34.37367], [-118.58393, 34.37354], [-118.58391, 34.37323], [-118.58372, 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.58214, 34.37467], [-118.58277, 34.37507], [-118.58274, 34.3754], [-118.58194, 34.37539], [-118.58193, 34.37574], [-118.5814, 34.37587], [-118.58139, 34.37426], [-118.58108, 34.37426], [-118.58101, 34.37074], [-118.58532, 34.37075], [-118.58536, 34.37309]]]} | Unknown Access 4 | 7299 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 37.175 | Laing - Brookfield | None 630 | |||
7591 | 7591 | 7590 | {"type": "Polygon", "coordinates": [[[-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 | 7300 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 44.522 | Laing - Brookfield | None 631 | |||
1208 | 1208 | 1207 | {"type": "Polygon", "coordinates": [[[-118.6372, 34.36427], [-118.62414, 34.36475], [-118.62394, 34.35736], [-118.63275, 34.35717], [-118.63292, 34.36076], [-118.63708, 34.36067], [-118.6372, 34.36427]]]} | Unknown Access 4 | 8425 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | 201.929 | 0 | Local Other or Unknown 14 | 4 | ||
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 | |||
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 |
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]);