units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
149 rows where ACCESS_TYP = 4 and MNG_AGENCY = 27 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, COUNTY, GAP_STS
DES_TP 23
LAYER 3 ✖
- Special District 136
- Other State 12
- Private 1
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 149 ✖
ACCESS_TYP 1
- Unknown Access · 149 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4727 | 4727 | 4726 | {"type": "Polygon", "coordinates": [[[-118.50367, 34.09732], [-118.50364, 34.09732], [-118.50363, 34.09721], [-118.50366, 34.09721], [-118.50367, 34.09732]]]} | Unknown Access 4 | 46347 | 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.009 | 0 | Local Other or Unknown 14 | 4 | ||
15489 | 15489 | 15488 | {"type": "Polygon", "coordinates": [[[-118.32033, 34.23499], [-118.32019, 34.2351], [-118.32013, 34.23505], [-118.32027, 34.23494], [-118.32033, 34.23499]]]} | Unknown Access 4 | 46153 | 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.034 | 0 | Local Other or Unknown 14 | 4 | ||
4761 | 4761 | 4760 | {"type": "Polygon", "coordinates": [[[-118.63806, 34.24154], [-118.63783, 34.24155], [-118.63783, 34.24148], [-118.63804, 34.24148], [-118.63806, 34.24154]]]} | Unknown Access 4 | 46669 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 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 | Ventura 8 | 0.038 | 0 | Local Other or Unknown 14 | 4 | ||
4698 | 4698 | 4697 | {"type": "Polygon", "coordinates": [[[-118.44773, 34.10525], [-118.4477, 34.10553], [-118.44762, 34.10554], [-118.44765, 34.10524], [-118.44773, 34.10525]]]} | Unknown Access 4 | 46110 | 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.061 | 0 | Local Other or Unknown 14 | 4 | ||
4729 | 4729 | 4728 | {"type": "Polygon", "coordinates": [[[-118.37521, 34.10697], [-118.37511, 34.107], [-118.37498, 34.10675], [-118.37508, 34.10672], [-118.37521, 34.10697]]]} | Unknown Access 4 | 46361 | 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.069 | 0 | Local Other or Unknown 14 | 4 | ||
4721 | 4721 | 4720 | {"type": "Polygon", "coordinates": [[[-118.601, 34.12191], [-118.60099, 34.12209], [-118.60081, 34.12214], [-118.60084, 34.12191], [-118.60091, 34.12192], [-118.601, 34.12191]]]} | Unknown Access 4 | 46346 | 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.085 | 0 | Local Other or Unknown 14 | 4 | ||
15496 | 15496 | 15495 | {"type": "Polygon", "coordinates": [[[-118.21315, 34.10672], [-118.21311, 34.10678], [-118.21276, 34.10672], [-118.21276, 34.10658], [-118.21315, 34.10672]]]} | Unknown Access 4 | 46171 | 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.095 | 0 | Local Other or Unknown 14 | 4 | ||
13903 | 13903 | 13902 | {"type": "Polygon", "coordinates": [[[-118.55761, 34.03994], [-118.55761, 34.03994], [-118.55731, 34.04004], [-118.5573, 34.03991], [-118.5576, 34.03981], [-118.55761, 34.03994]]]} | Unknown Access 4 | 46379 | 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.096 | 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 | ||
4730 | 4730 | 4729 | {"type": "Polygon", "coordinates": [[[-118.37023, 34.10885], [-118.37007, 34.10885], [-118.37006, 34.10858], [-118.37022, 34.10857], [-118.37023, 34.10885]]]} | Unknown Access 4 | 46364 | 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.114 | 0 | Local Other or Unknown 14 | 4 | ||
4702 | 4702 | 4701 | {"type": "Polygon", "coordinates": [[[-118.37841, 34.10278], [-118.3783, 34.10284], [-118.37806, 34.10257], [-118.37817, 34.1025], [-118.37841, 34.10278]]]} | Unknown Access 4 | 46146 | 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.115 | 0 | Local Other or Unknown 14 | 4 | ||
4755 | 4755 | 4754 | {"type": "Polygon", "coordinates": [[[-118.37586, 34.10744], [-118.37552, 34.10755], [-118.37536, 34.10747], [-118.37578, 34.10731], [-118.37586, 34.10744]]]} | Unknown Access 4 | 46512 | 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.139 | 0 | Local Other or Unknown 14 | 4 | ||
4724 | 4724 | 4723 | {"type": "Polygon", "coordinates": [[[-118.37172, 34.10321], [-118.37135, 34.10341], [-118.37119, 34.10336], [-118.37126, 34.10321], [-118.37172, 34.10321]]]} | Unknown Access 4 | 46333 | 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.149 | 0 | Local Other or Unknown 14 | 4 | ||
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 | |||
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 | ||
4725 | 4725 | 4724 | {"type": "MultiPolygon", "coordinates": [[[[-118.60336, 34.12324], [-118.60346, 34.12329], [-118.60347, 34.12333], [-118.60345, 34.12337], [-118.60339, 34.12342], [-118.60315, 34.12351], [-118.6031, 34.1234], [-118.60319, 34.12337], [-118.60321, 34.12333], [-118.60336, 34.12324]]], [[[-118.60346, 34.12362], [-118.6033, 34.12361], [-118.6033, 34.12348], [-118.60346, 34.1234], [-118.60346, 34.12362]]]]} | Unknown Access 4 | 46335 | 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.199 | 0 | Local Other or Unknown 14 | 4 | ||
13940 | 13940 | 13939 | {"type": "Polygon", "coordinates": [[[-118.51887, 34.0562], [-118.51878, 34.05646], [-118.51849, 34.05646], [-118.51849, 34.05623], [-118.51887, 34.0562]]]} | Unknown Access 4 | 46470 | 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.207 | 0 | Local Other or Unknown 14 | 4 | ||
4754 | 4754 | 4753 | {"type": "MultiPolygon", "coordinates": [[[[-118.34592, 34.12353], [-118.3458, 34.12379], [-118.34566, 34.12375], [-118.34558, 34.12371], [-118.34569, 34.12346], [-118.34592, 34.12353]]], [[[-118.34798, 34.1232], [-118.3477, 34.12337], [-118.3477, 34.12337], [-118.34767, 34.12329], [-118.34796, 34.12316], [-118.34798, 34.1232]]]]} | Unknown Access 4 | 46463 | 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.222 | 0 | Local Other or Unknown 14 | 4 | ||
5685 | 5685 | 5684 | {"type": "Polygon", "coordinates": [[[-118.24162, 34.29361], [-118.24118, 34.29391], [-118.24105, 34.29377], [-118.24148, 34.29347], [-118.24162, 34.29361]]]} | Unknown Access 4 | 46196 | 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.253 | 0 | Local Other or Unknown 14 | 4 | ||
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 |
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]);