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 map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY, GAP_STS
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 | ||
16130 | 16130 | 16129 | {"type": "Polygon", "coordinates": [[[-118.87531, 34.20277], [-118.8746, 34.20316], [-118.87384, 34.2035], [-118.87306, 34.20327], [-118.87173, 34.20299], [-118.87011, 34.20208], [-118.86977, 34.20202], [-118.86977, 34.20128], [-118.87009, 34.20089], [-118.8705, 34.20068], [-118.8705, 34.20045], [-118.87138, 34.20058], [-118.87227, 34.20084], [-118.87308, 34.20101], [-118.87397, 34.20157], [-118.87374, 34.20181], [-118.87374, 34.20183], [-118.87445, 34.20231], [-118.8749, 34.20224], [-118.87531, 34.20277]]]} | Unknown Access 4 | 17173 | Labisco Hill Open Space | 20815 | 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 | 23.9 | Labisco Hill OS | 0 | Local Recreation Area 3 | 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 | ||
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 | ||
15308 | 15308 | 15307 | {"type": "Polygon", "coordinates": [[[-118.80384, 34.13634], [-118.80042, 34.13935], [-118.78741, 34.13631], [-118.777, 34.13531], [-118.77703, 34.13029], [-118.77642, 34.13028], [-118.77627, 34.13026], [-118.77605, 34.13018], [-118.77593, 34.1301], [-118.77583, 34.13001], [-118.77548, 34.12953], [-118.77573, 34.1294], [-118.77599, 34.12923], [-118.77622, 34.12904], [-118.77644, 34.12884], [-118.77663, 34.12862], [-118.77679, 34.12839], [-118.77694, 34.12813], [-118.77704, 34.12788], [-118.77712, 34.12763], [-118.77717, 34.12737], [-118.77785, 34.12235], [-118.77798, 34.12189], [-118.77811, 34.1216], [-118.77826, 34.12131], [-118.77855, 34.12091], [-118.77877, 34.12065], [-118.77951, 34.12141], [-118.79034, 34.12722], [-118.79411, 34.13556], [-118.80384, 34.13634]]]} | Unknown Access 4 | 46454 | Truinfo Canyon Open Space | 29730 | 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 | 525.504 | Truinfo Canyon OS | 0 | Local Recreation Area 3 | 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 | ||
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 | ||
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 | |
15243 | 15243 | 15242 | {"type": "Polygon", "coordinates": [[[-118.68918, 34.07074], [-118.68702, 34.07066], [-118.68703, 34.06893], [-118.68805, 34.06845], [-118.68823, 34.06839], [-118.68842, 34.06839], [-118.68918, 34.06858], [-118.68918, 34.07074]]]} | Unknown Access 4 | 46343 | Malibu Canyon | 29630 | 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.629 | Malibu Canyon | None 1340 | |||
9008 | 9008 | 9007 | {"type": "Polygon", "coordinates": [[[-118.67703, 34.11763], [-118.67637, 34.11763], [-118.67637, 34.11811], [-118.67199, 34.11812], [-118.67201, 34.11443], [-118.67371, 34.11443], [-118.67372, 34.11417], [-118.67636, 34.11416], [-118.67637, 34.11576], [-118.67703, 34.11577], [-118.67703, 34.11763]]]} | Unknown Access 4 | 14913 | Upper Stokes | 26736 | 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 | 45.58 | Upper Stokes | None 751 | |||
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 | ||
16263 | 16263 | 16262 | {"type": "Polygon", "coordinates": [[[-118.6587, 34.05186], [-118.65574, 34.05186], [-118.65572, 34.0492], [-118.65578, 34.04919], [-118.65576, 34.04829], [-118.65868, 34.04827], [-118.6587, 34.05186]]]} | Unknown Access 4 | 46376 | Carbon Canyon Open Space | 29656 | 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.736 | Carbon Canyon OS | 0 | Local Recreation Area 3 | 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]);