units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
129 rows where ACCESS_TYP = 4, GAP_STS = 4 and MNG_AG_TYP = 6
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
2390 | 2390 | 2389 | {"type": "Polygon", "coordinates": [[[-118.71787, 34.45684], [-118.71569, 34.45684], [-118.71568, 34.46041], [-118.71122, 34.4604], [-118.70698, 34.46033], [-118.70695, 34.45676], [-118.70268, 34.45668], [-118.70267, 34.45669], [-118.70272, 34.46026], [-118.69843, 34.46019], [-118.6982, 34.45301], [-118.70692, 34.45318], [-118.70696, 34.44953], [-118.71123, 34.44959], [-118.71339, 34.44958], [-118.71341, 34.45326], [-118.71611, 34.45327], [-118.71787, 34.45684]]]} | Unknown Access 4 | 11474 | Holser Canyon Open Space | 29737 | 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 | 345.8 | Holser Canyon OS | 0 | Local Recreation Area 3 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
4514 | 4514 | 4513 | {"type": "Polygon", "coordinates": [[[-118.36336, 34.26205], [-118.36208, 34.26532], [-118.36242, 34.26582], [-118.36086, 34.2658], [-118.36086, 34.2641], [-118.36323, 34.26203], [-118.36336, 34.26205]]]} | Unknown Access 4 | 12349 | 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.984 | 0 | Local Other or Unknown 14 | 4 | ||
4516 | 4516 | 4515 | {"type": "MultiPolygon", "coordinates": [[[[-118.6416, 34.13135], [-118.6416, 34.13144], [-118.64151, 34.13165], [-118.64161, 34.13202], [-118.6416, 34.13272], [-118.64118, 34.13272], [-118.64117, 34.13135], [-118.6416, 34.13135]]], [[[-118.64237, 34.13272], [-118.64169, 34.13272], [-118.64169, 34.132], [-118.6416, 34.13165], [-118.64168, 34.13145], [-118.64168, 34.13113], [-118.6416, 34.13088], [-118.64198, 34.13088], [-118.6422, 34.13114], [-118.64222, 34.13139], [-118.64203, 34.13179], [-118.64222, 34.13252], [-118.64237, 34.13272]]], [[[-118.64323, 34.13088], [-118.64323, 34.13111], [-118.64308, 34.13132], [-118.64272, 34.13136], [-118.64245, 34.13177], [-118.64261, 34.13219], [-118.64277, 34.1323], [-118.6428, 34.13246], [-118.64299, 34.13272], [-118.64247, 34.13272], [-118.6423, 34.1325], [-118.64211, 34.1318], [-118.64231, 34.1314], [-118.64228, 34.13112], [-118.64208, 34.13088], [-118.64323, 34.13088]]]]} | Unknown Access 4 | 12479 | 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 | 6.231 | 0 | Local Other or Unknown 14 | 4 | ||
4521 | 4521 | 4520 | {"type": "Polygon", "coordinates": [[[-118.47583, 34.33719], [-118.46689, 34.33699], [-118.46707, 34.3301], [-118.46764, 34.33011], [-118.47158, 34.32993], [-118.4757, 34.32915], [-118.47581, 34.32922], [-118.47583, 34.33719]], [[-118.46964, 34.33229], [-118.47016, 34.33283], [-118.47061, 34.33269], [-118.47003, 34.33102], [-118.46957, 34.33034], [-118.46943, 34.33022], [-118.46915, 34.33012], [-118.46839, 34.33012], [-118.46838, 34.33055], [-118.46883, 34.33059], [-118.46832, 34.33146], [-118.46763, 34.33149], [-118.46779, 34.33473], [-118.46846, 34.33474], [-118.4686, 34.33234], [-118.46964, 34.33229]]]} | Unknown Access 4 | 14635 | 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 | 146.941 | 0 | Local Other or Unknown 14 | 4 | ||
4523 | 4523 | 4522 | {"type": "Polygon", "coordinates": [[[-118.52638, 34.34073], [-118.52611, 34.34068], [-118.52602, 34.34082], [-118.52551, 34.34042], [-118.52522, 34.3407], [-118.52444, 34.34014], [-118.52444, 34.33818], [-118.52633, 34.3382], [-118.52638, 34.34073]]]} | Unknown Access 4 | 15193 | 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.377 | 0 | Local Other or Unknown 14 | 4 | ||
4527 | 4527 | 4526 | {"type": "Polygon", "coordinates": [[[-117.72013, 34.57987], [-117.72007, 34.58708], [-117.71578, 34.58707], [-117.71584, 34.57984], [-117.72013, 34.57987]]]} | Unknown Access 4 | 17524 | 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 | 78.061 | 0 | Local Other or Unknown 14 | 4 | ||
4528 | 4528 | 4527 | {"type": "Polygon", "coordinates": [[[-118.41348, 34.74982], [-118.40925, 34.74988], [-118.4093, 34.75713], [-118.40483, 34.7572], [-118.40473, 34.7463], [-118.41347, 34.74617], [-118.41348, 34.74982]]]} | Unknown Access 4 | 17564 | 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 | 161.323 | 0 | Local Other or Unknown 14 | 4 | ||
4544 | 4544 | 4543 | {"type": "Polygon", "coordinates": [[[-118.52444, 34.33818], [-118.52444, 34.34014], [-118.5235, 34.33946], [-118.523, 34.33996], [-118.52197, 34.33991], [-118.52118, 34.33889], [-118.52002, 34.3394], [-118.51979, 34.33938], [-118.5198, 34.33815], [-118.52444, 34.33818]]]} | Unknown Access 4 | 22032 | 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 | 16.452 | 0 | Local Other or Unknown 14 | 4 | ||
4545 | 4545 | 4544 | {"type": "Polygon", "coordinates": [[[-118.61503, 34.34495], [-118.61398, 34.34496], [-118.61394, 34.34328], [-118.61499, 34.34327], [-118.61503, 34.34495]]]} | Unknown Access 4 | 22033 | 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 | 4.457 | 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 | ||
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 | ||
4700 | 4700 | 4699 | {"type": "Polygon", "coordinates": [[[-118.07, 34.1792], [-118.07, 34.1792], [-118.06835, 34.17925], [-118.06999, 34.17782], [-118.07, 34.1792]]]} | Unknown Access 4 | 46136 | 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.879 | 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 |
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]);