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 AGNCY_WEB 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12230 | 12230 | 12229 | {"type": "Polygon", "coordinates": [[[-117.25793, 33.63037], [-117.25788, 33.63401], [-117.24921, 33.63405], [-117.24922, 33.63039], [-117.25793, 33.63037]]]} | Unknown Access 4 | 25434 | Rullo Property | 24729 | 2179 | Western Riverside County Regional Conservation Authority 957 | Special District 4 | Open Space District 6 | http://www.wrc-rca.org/ | Special District 4 | 2179 | Western Riverside County Regional Conservation Authority 927 | Special District 4 | Open Space District 6 | Riverside 10 | 80.657 | Rullo Property | 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 | ||
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 | ||
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 | ||
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 | ||
15287 | 15287 | 15286 | {"type": "MultiPolygon", "coordinates": [[[[-118.6575, 34.07699], [-118.65702, 34.07699], [-118.65724, 34.07654], [-118.65708, 34.07631], [-118.6561, 34.07608], [-118.65481, 34.07794], [-118.65519, 34.07852], [-118.65684, 34.07935], [-118.65688, 34.08176], [-118.65047, 34.08185], [-118.65079, 34.08151], [-118.65087, 34.08138], [-118.65094, 34.08117], [-118.65093, 34.08095], [-118.65085, 34.08074], [-118.6507, 34.08056], [-118.6505, 34.08042], [-118.65034, 34.08035], [-118.65019, 34.08032], [-118.65043, 34.08025], [-118.65077, 34.07999], [-118.65087, 34.07997], [-118.65096, 34.07999], [-118.65094, 34.07907], [-118.65093, 34.07906], [-118.65077, 34.07912], [-118.65034, 34.07919], [-118.65001, 34.07935], [-118.64998, 34.07481], [-118.65033, 34.0748], [-118.65074, 34.07488], [-118.65099, 34.07497], [-118.65132, 34.07516], [-118.65146, 34.07521], [-118.6516, 34.07522], [-118.65182, 34.0752], [-118.65201, 34.07512], [-118.65216, 34.075], [-118.65223, 34.07491], [-118.65228, 34.0748], [-118.65743, 34.07478], [-118.6575, 34.07699]], [[-118.65202, 34.07851], [-118.65202, 34.07849], [-118.65163, 34.07837], [-118.6514, 34.07845], [-118.65122, 34.07868], [-118.65157, 34.07893], [-118.65188, 34.07884], [-118.65202, 34.07851]]], [[[-118.65002, 34.08181], [-118.65001, 34.08047], [-118.65001, 34.08047], [-118.65017, 34.08048], [-118.65031, 34.08052], [-118.65044, 34.08059], [-118.65056, 34.08067], [-118.65068, 34.08083], [-118.65073, 34.08096], [-118.65074, 34.08108], [-118.65071, 34.08127], [-118.65065, 34.08138], [-118.65057, 34.08148], [-118.65041, 34.0816], [-118.65014, 34.08173], [-118.65002, 34.08181]]], [[[-118.65207, 34.0748], [-118.65198, 34.07493], [-118.65189, 34.07499], [-118.65172, 34.07505], [-118.6516, 34.07506], [-118.65148, 34.07504], [-118.65137, 34.075], [-118.65102, 34.0748], [-118.65207, 34.0748]]]]} | Unknown Access 4 | 46406 | Saddle Peak | 29684 | 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 | 108.695 | Saddle Peak | None 1347 | |||
15518 | 15518 | 15517 | {"type": "Polygon", "coordinates": [[[-118.6406, 34.26451], [-118.63942, 34.26478], [-118.63947, 34.26497], [-118.63903, 34.26505], [-118.63764, 34.26489], [-118.63789, 34.26483], [-118.63816, 34.26479], [-118.63839, 34.26478], [-118.63878, 34.2648], [-118.63911, 34.26477], [-118.63935, 34.2647], [-118.64053, 34.2643], [-118.6406, 34.26451]]]} | Unknown Access 4 | 46683 | 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 | 1.348 | 0 | Local Other or Unknown 14 | 4 | ||
15277 | 15277 | 15276 | {"type": "Polygon", "coordinates": [[[-118.01134, 34.00416], [-118.00978, 34.00681], [-118.00888, 34.00585], [-118.0079, 34.00193], [-118.00768, 34.00148], [-118.00739, 34.00133], [-118.00716, 34.00114], [-118.00703, 34.00099], [-118.00639, 34.00009], [-118.00618, 33.99987], [-118.00592, 33.9997], [-118.00515, 33.99931], [-118.00612, 33.99766], [-118.01134, 34.00416]]]} | Unknown Access 4 | 46393 | Hacienda Hills Open Space | 29675 | 6105 | Rose Hills Memorial Park and Mortuaries 1148 | Private 7 | Commercial 20 | http://www.rosehills.com/en-us/index.page | Private 14 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 40.216 | Hacienda Hills OS | 0 | Local Recreation Area 3 | 4 | |
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 | |||
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 | |
3955 | 3955 | 3954 | {"type": "Polygon", "coordinates": [[[-118.26969, 34.25985], [-118.2653, 34.25981], [-118.26529, 34.25816], [-118.26968, 34.25821], [-118.26969, 34.25985]]]} | Unknown Access 4 | 46417 | Haines Canyon | 29694 | 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 | 18.279 | Haines Canyon | None 341 | |||
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 | |||
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 | ||
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 | ||
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 |
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]);