units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
152 rows where DES_TP = 14 and MNG_AGENCY = 27 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, COUNTY
ACCESS_TYP 3
- Unknown Access 118
- Open Access 30
- No Public Access 4
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 152 ✖
DES_TP 1
- Local Other or Unknown · 152 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15519 | 15519 | 15518 | {"type": "Polygon", "coordinates": [[[-119.07188, 34.33932], [-119.07001, 34.34137], [-119.06933, 34.3406], [-119.07126, 34.33863], [-119.07188, 34.33932]]]} | Unknown Access 4 | 46684 | 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 | Ventura 8 | 6.801 | 0 | Local Other or Unknown 14 | 4 | ||
15517 | 15517 | 15516 | {"type": "Polygon", "coordinates": [[[-118.89394, 34.10736], [-118.89393, 34.10915], [-118.89173, 34.10916], [-118.89175, 34.10736], [-118.89394, 34.10736]]]} | Unknown Access 4 | 46682 | 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 | Ventura 8 | 9.935 | 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 | ||
4695 | 4695 | 4694 | {"type": "Polygon", "coordinates": [[[-118.83097, 34.10947], [-118.83097, 34.11083], [-118.82952, 34.11087], [-118.82952, 34.10951], [-118.83097, 34.10947]]]} | No Public Access 3 | 46094 | Unnamed site - Mountains Recreation and Conservation Authority | 29443 | 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.983 | 0 | Local Other or Unknown 14 | 4 | ||
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 | ||
4689 | 4689 | 4688 | {"type": "Polygon", "coordinates": [[[-118.79853, 34.03843], [-118.79767, 34.03942], [-118.79749, 34.03967], [-118.79725, 34.0401], [-118.79709, 34.04053], [-118.797, 34.04097], [-118.79698, 34.04141], [-118.79702, 34.04173], [-118.79728, 34.04272], [-118.79624, 34.04243], [-118.79622, 34.03831], [-118.79853, 34.03843]]]} | Unknown Access 4 | 44379 | 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 | 12.472 | 0 | Local Other or Unknown 14 | 4 | ||
4739 | 4739 | 4738 | {"type": "Polygon", "coordinates": [[[-118.79359, 34.05637], [-118.79355, 34.05992], [-118.78747, 34.05991], [-118.78756, 34.05629], [-118.79359, 34.05637]]]} | Unknown Access 4 | 46396 | 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 | 54.881 | 0 | Local Other or Unknown 14 | 4 | ||
4474 | 4474 | 4473 | {"type": "Polygon", "coordinates": [[[-118.79355, 34.05992], [-118.79347, 34.06171], [-118.78758, 34.06172], [-118.78748, 34.05991], [-118.79355, 34.05992]], [[-118.78798, 34.06012], [-118.78789, 34.06023], [-118.78799, 34.06049], [-118.78817, 34.06057], [-118.78837, 34.06052], [-118.78844, 34.0604], [-118.78835, 34.06025], [-118.78816, 34.06007], [-118.78798, 34.06012]]]} | Open Access 1 | 2664 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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 | 26.845 | 0 | Local Other or Unknown 14 | 4 | ||
4757 | 4757 | 4756 | {"type": "Polygon", "coordinates": [[[-118.76475, 34.03485], [-118.76381, 34.03533], [-118.76361, 34.03528], [-118.76272, 34.03512], [-118.76248, 34.0351], [-118.7627, 34.03502], [-118.76305, 34.03465], [-118.76327, 34.03464], [-118.76361, 34.03474], [-118.76422, 34.03461], [-118.7647, 34.03481], [-118.76475, 34.03485]]]} | Unknown Access 4 | 46583 | 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 | 2.346 | 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 | ||
4719 | 4719 | 4718 | {"type": "Polygon", "coordinates": [[[-118.74907, 34.06809], [-118.74798, 34.0681], [-118.74796, 34.06714], [-118.74905, 34.06714], [-118.74907, 34.06809]]]} | Unknown Access 4 | 46299 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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.649 | 0 | Local Other or Unknown 14 | 4 | ||
4741 | 4741 | 4740 | {"type": "Polygon", "coordinates": [[[-118.74577, 34.16152], [-118.74576, 34.16801], [-118.74242, 34.16799], [-118.74241, 34.16749], [-118.74091, 34.1668], [-118.74072, 34.16666], [-118.74038, 34.16591], [-118.74168, 34.16511], [-118.74155, 34.1648], [-118.74142, 34.16463], [-118.74078, 34.16423], [-118.74069, 34.16403], [-118.73906, 34.16418], [-118.73821, 34.16242], [-118.73776, 34.16246], [-118.73805, 34.16205], [-118.73867, 34.16205], [-118.74107, 34.16399], [-118.74176, 34.16393], [-118.74177, 34.16391], [-118.74102, 34.16272], [-118.74577, 34.16152]]]} | Unknown Access 4 | 46398 | 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 | 74.251 | 0 | Local Other or Unknown 14 | 4 | ||
4743 | 4743 | 4742 | {"type": "Polygon", "coordinates": [[[-118.67177, 34.44402], [-118.6684, 34.44399], [-118.66865, 34.44562], [-118.66805, 34.44562], [-118.66804, 34.44548], [-118.66716, 34.44548], [-118.66716, 34.4452], [-118.66662, 34.44519], [-118.66661, 34.44503], [-118.66663, 34.44486], [-118.6667, 34.44469], [-118.66685, 34.44445], [-118.66692, 34.44428], [-118.66695, 34.44411], [-118.66697, 34.44381], [-118.66699, 34.44373], [-118.66707, 34.44363], [-118.66755, 34.44325], [-118.669, 34.44397], [-118.66921, 34.4437], [-118.67038, 34.4437], [-118.67038, 34.44368], [-118.66793, 34.4425], [-118.66827, 34.44229], [-118.66861, 34.44198], [-118.67145, 34.44201], [-118.67177, 34.44402]]]} | Unknown Access 4 | 46407 | 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 | 22.13 | 0 | Local Other or Unknown 14 | 4 | ||
4731 | 4731 | 4730 | {"type": "Polygon", "coordinates": [[[-118.66777, 34.22702], [-118.66777, 34.22769], [-118.6666, 34.22769], [-118.66661, 34.22887], [-118.66504, 34.22887], [-118.66504, 34.22703], [-118.66777, 34.22702]]]} | Unknown Access 4 | 46365 | 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 | 9.234 | 0 | Local Other or Unknown 14 | 4 | ||
15495 | 15495 | 15494 | {"type": "Polygon", "coordinates": [[[-118.66761, 34.11812], [-118.66761, 34.11957], [-118.66491, 34.11956], [-118.66492, 34.11868], [-118.6639, 34.11868], [-118.66391, 34.11811], [-118.66761, 34.11812]]]} | Unknown Access 4 | 46169 | 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 | 11.277 | 0 | Local Other or Unknown 14 | 4 | ||
4762 | 4762 | 4761 | {"type": "Polygon", "coordinates": [[[-118.66534, 34.24698], [-118.66528, 34.24712], [-118.66311, 34.24541], [-118.66318, 34.24533], [-118.66323, 34.24532], [-118.66534, 34.24698]]]} | Unknown Access 4 | 46670 | 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 | Ventura 8 | 0.999 | 0 | Local Other or Unknown 14 | 4 | ||
4701 | 4701 | 4700 | {"type": "Polygon", "coordinates": [[[-118.65885, 34.1108], [-118.65883, 34.11113], [-118.65881, 34.11263], [-118.65455, 34.11263], [-118.65456, 34.11081], [-118.65885, 34.1108]]]} | Open Access 1 | 46140 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 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 | 19.766 | 0 | Local Other or Unknown 14 | 4 | ||
4760 | 4760 | 4759 | {"type": "Polygon", "coordinates": [[[-118.65746, 34.24951], [-118.65728, 34.24972], [-118.65503, 34.24773], [-118.65546, 34.24758], [-118.65746, 34.24951]]]} | Unknown Access 4 | 46668 | 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 | Ventura 8 | 2.487 | 0 | Local Other or Unknown 14 | 4 | ||
15500 | 15500 | 15499 | {"type": "Polygon", "coordinates": [[[-118.65573, 34.05073], [-118.65459, 34.05115], [-118.65458, 34.05125], [-118.65465, 34.05133], [-118.65432, 34.05117], [-118.65389, 34.05104], [-118.65345, 34.05094], [-118.65334, 34.05084], [-118.65325, 34.0508], [-118.65317, 34.05079], [-118.6531, 34.05081], [-118.65302, 34.05086], [-118.65305, 34.0509], [-118.65295, 34.0509], [-118.65289, 34.05086], [-118.65287, 34.05075], [-118.6529, 34.05069], [-118.65341, 34.05007], [-118.65347, 34.05009], [-118.65388, 34.05008], [-118.65387, 34.04921], [-118.65572, 34.0492], [-118.65573, 34.05073]]]} | Unknown Access 4 | 46174 | 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 | 10.178 | 0 | Local Other or Unknown 14 | 4 | ||
15501 | 15501 | 15500 | {"type": "Polygon", "coordinates": [[[-118.65299, 34.22381], [-118.65275, 34.22399], [-118.65269, 34.22392], [-118.65241, 34.2235], [-118.65281, 34.2235], [-118.65285, 34.22366], [-118.65299, 34.22381]]]} | Unknown Access 4 | 46175 | 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.371 | 0 | Local Other or Unknown 14 | 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]);