superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where ACCESS_TYP = 4 and MNG_AG_TYP = 6 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, AGNCY_WEB
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6011 | 6011 | 6010 | {"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 | 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 | 0.186 | Las Casas - Grenola | ||
6312 | 6312 | 6311 | {"type": "Polygon", "coordinates": [[[-118.6131, 34.15759], [-118.61284, 34.15773], [-118.61261, 34.15756], [-118.61257, 34.1575], [-118.61278, 34.15736], [-118.6131, 34.15759]]]} | Unknown Access 4 | Llano | 21388 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.253 | Llano | ||
9401 | 9401 | 9400 | {"type": "Polygon", "coordinates": [[[-118.5607, 34.04133], [-118.56059, 34.04153], [-118.56053, 34.04148], [-118.56016, 34.04145], [-118.5602, 34.04121], [-118.56031, 34.04121], [-118.56046, 34.04127], [-118.5607, 34.04133]]]} | Unknown Access 4 | Schwartz Property | 25197 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.267 | Schwartz Property | ||
6966 | 6966 | 6965 | {"type": "Polygon", "coordinates": [[[-118.57899, 34.14891], [-118.57845, 34.14895], [-118.57849, 34.14866], [-118.57892, 34.14859], [-118.57899, 34.14891]]]} | Unknown Access 4 | MGP Entrance | 22194 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.379 | MGP Entrance | ||
12473 | 12473 | 12472 | {"type": "Polygon", "coordinates": [[[-118.62073, 34.19735], [-118.62041, 34.19737], [-118.6201, 34.19741], [-118.6198, 34.19749], [-118.6194, 34.19763], [-118.6194, 34.1975], [-118.6193, 34.19749], [-118.6193, 34.19744], [-118.61926, 34.19743], [-118.61925, 34.19737], [-118.6188, 34.19737], [-118.6188, 34.19735], [-118.62073, 34.19735]]]} | Unknown Access 4 | Bell Creek Park | 29516 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.385 | Bell Creek Park | ||
12515 | 12515 | 12514 | {"type": "Polygon", "coordinates": [[[-118.60349, 34.03929], [-118.60304, 34.03933], [-118.60253, 34.03932], [-118.60254, 34.03911], [-118.60277, 34.03913], [-118.60296, 34.03912], [-118.60331, 34.03908], [-118.60345, 34.03903], [-118.60349, 34.03929]]]} | Unknown Access 4 | Las Tunas Beach | 29634 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.511 | Las Tunas Beach | ||
10391 | 10391 | 10390 | {"type": "MultiPolygon", "coordinates": [[[[-118.60299, 34.07904], [-118.60283, 34.07928], [-118.60279, 34.07931], [-118.60269, 34.07918], [-118.60291, 34.07891], [-118.60298, 34.07897], [-118.60299, 34.07904]]], [[[-118.6063, 34.08091], [-118.60629, 34.08167], [-118.60523, 34.08168], [-118.60535, 34.08091], [-118.6063, 34.08091]]]]} | Unknown Access 4 | Topanga Canyon - Fernwood | 26405 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2.097 | Topanga Canyon - Fernwood | ||
8584 | 8584 | 8583 | {"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 | 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 | 2.508 | Red Rover Mine TaxDef | ||
12590 | 12590 | 12589 | {"type": "MultiPolygon", "coordinates": [[[[-118.12099, 34.19885], [-118.12089, 34.19905], [-118.12033, 34.19937], [-118.11986, 34.19938], [-118.11984, 34.19943], [-118.11946, 34.19944], [-118.11946, 34.19941], [-118.11953, 34.19939], [-118.11956, 34.19919], [-118.11969, 34.19915], [-118.12006, 34.19936], [-118.12019, 34.19921], [-118.12013, 34.19895], [-118.12027, 34.19892], [-118.12037, 34.19881], [-118.12036, 34.1986], [-118.1205, 34.19852], [-118.12062, 34.19832], [-118.12079, 34.19852], [-118.12086, 34.19866], [-118.12082, 34.19878], [-118.12099, 34.19885]]], [[[-118.12059, 34.19829], [-118.12046, 34.19849], [-118.12031, 34.19859], [-118.12032, 34.1988], [-118.12024, 34.19889], [-118.12008, 34.19893], [-118.12014, 34.1992], [-118.12004, 34.19931], [-118.11969, 34.1991], [-118.11951, 34.19916], [-118.11949, 34.19936], [-118.11946, 34.19937], [-118.11947, 34.19916], [-118.11991, 34.19873], [-118.11995, 34.19842], [-118.12012, 34.19824], [-118.12059, 34.19829]]], [[[-118.12117, 34.19889], [-118.12097, 34.199], [-118.12105, 34.19883], [-118.12088, 34.19876], [-118.12091, 34.19865], [-118.12083, 34.1985], [-118.12066, 34.1983], [-118.12088, 34.19832], [-118.12117, 34.19889]]]]} | Unknown Access 4 | Rubio Canyon | 29683 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2.876 | Rubio Canyon | ||
7359 | 7359 | 7358 | {"type": "Polygon", "coordinates": [[[-118.54192, 34.34956], [-118.5414, 34.34944], [-118.54058, 34.34899], [-118.54043, 34.34858], [-118.53937, 34.348], [-118.54131, 34.348], [-118.5413, 34.34712], [-118.54183, 34.34712], [-118.54192, 34.34956]]]} | Unknown Access 4 | Newhall Pass | 22727 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 6.628 | Newhall Pass | ||
8883 | 8883 | 8882 | {"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 | 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 | 9.685 | Rocky Peak Adj. Tax Default | ||
12539 | 12539 | 12538 | {"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 | 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 | 11.627 | Malibu Canyon | ||
12504 | 12504 | 12503 | {"type": "Polygon", "coordinates": [[[-118.65002, 34.08174], [-118.64987, 34.08185], [-118.6439, 34.08195], [-118.64441, 34.0814], [-118.64487, 34.08123], [-118.64515, 34.08131], [-118.64532, 34.08135], [-118.64552, 34.08136], [-118.64571, 34.08135], [-118.64588, 34.08131], [-118.64666, 34.08106], [-118.64687, 34.08101], [-118.64822, 34.08085], [-118.64848, 34.08078], [-118.64869, 34.08068], [-118.64998, 34.08047], [-118.65001, 34.08047], [-118.65002, 34.08174]]]} | Unknown Access 4 | Cold Creek Canyon Preserve | 29572 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 13.405 | Cold Creek Canyon Preserve | ||
12611 | 12611 | 12610 | {"type": "Polygon", "coordinates": [[[-118.64114, 34.04646], [-118.64114, 34.04927], [-118.63883, 34.04927], [-118.6389, 34.04916], [-118.63895, 34.04894], [-118.63908, 34.04862], [-118.63914, 34.04837], [-118.63942, 34.04697], [-118.63947, 34.04677], [-118.63956, 34.04655], [-118.63956, 34.04642], [-118.63952, 34.04633], [-118.64114, 34.04646]]]} | Unknown Access 4 | Tom & Giselle Hennesy Nature Preserve | 29704 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 13.88 | Tom & Giselle Hennesy Nature Preserve | ||
12509 | 12509 | 12508 | {"type": "MultiPolygon", "coordinates": [[[[-118.606, 34.28059], [-118.60598, 34.28457], [-118.60541, 34.28457], [-118.60473, 34.28409], [-118.6043, 34.28325], [-118.60451, 34.28287], [-118.60329, 34.28219], [-118.60452, 34.28219], [-118.60454, 34.28209], [-118.60477, 34.2821], [-118.60485, 34.28213], [-118.60493, 34.28219], [-118.60496, 34.28219], [-118.60496, 34.28217], [-118.60491, 34.28213], [-118.60482, 34.28209], [-118.60473, 34.28206], [-118.60454, 34.28206], [-118.60454, 34.28136], [-118.60496, 34.28119], [-118.60534, 34.28106], [-118.6055, 34.28099], [-118.60563, 34.28089], [-118.60578, 34.28075], [-118.60582, 34.28067], [-118.60584, 34.28059], [-118.606, 34.28059]]], [[[-118.6058, 34.28059], [-118.60578, 34.28068], [-118.6057, 34.28078], [-118.60559, 34.28088], [-118.60546, 34.28097], [-118.60454, 34.28132], [-118.60455, 34.28033], [-118.60497, 34.28033], [-118.60514, 34.28035], [-118.60573, 34.28048], [-118.60578, 34.28052], [-118.6058, 34.28059]]]]} | Unknown Access 4 | Devil Canyon Red Mesa | 29588 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 15.666 | Devil Canyon Red Mesa | ||
12604 | 12604 | 12603 | {"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 | 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 | 18.275 | Haines Canyon | ||
5853 | 5853 | 5852 | {"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.87049, 34.20068], [-118.8705, 34.20045], [-118.87138, 34.20058], [-118.87227, 34.20084], [-118.87308, 34.20101], [-118.87397, 34.20157], [-118.87375, 34.20181], [-118.87375, 34.20183], [-118.87445, 34.2023], [-118.8749, 34.20224], [-118.87531, 34.20277]]]} | Unknown Access 4 | Labisco Hill Open Space | 20815 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 23.902 | Labisco Hill OS | ||
12544 | 12544 | 12543 | {"type": "Polygon", "coordinates": [[[-118.6587, 34.05186], [-118.65574, 34.05186], [-118.65572, 34.0492], [-118.65578, 34.04918], [-118.65576, 34.04829], [-118.65868, 34.04827], [-118.6587, 34.05186]]]} | Unknown Access 4 | 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 | 26.734 | Carbon Canyon OS | ||
6359 | 6359 | 6358 | {"type": "MultiPolygon", "coordinates": [[[[-118.29844, 34.44508], [-118.29404, 34.44509], [-118.29401, 34.44186], [-118.29504, 34.44221], [-118.2953, 34.44234], [-118.29557, 34.44244], [-118.2959, 34.44251], [-118.29627, 34.44254], [-118.29669, 34.44251], [-118.29719, 34.44244], [-118.29748, 34.44236], [-118.29796, 34.44218], [-118.29818, 34.44207], [-118.2984, 34.44193], [-118.29841, 34.44299], [-118.29831, 34.4431], [-118.29828, 34.44322], [-118.2983, 34.44331], [-118.29842, 34.44357], [-118.29842, 34.44367], [-118.29836, 34.44368], [-118.29816, 34.44362], [-118.29804, 34.44363], [-118.29797, 34.44366], [-118.29791, 34.44371], [-118.29788, 34.44377], [-118.29786, 34.44384], [-118.29788, 34.4444], [-118.29792, 34.44455], [-118.29799, 34.44466], [-118.29827, 34.44495], [-118.29835, 34.445], [-118.29844, 34.44502], [-118.29844, 34.44508]]], [[[-118.29807, 34.44144], [-118.29789, 34.44157], [-118.29769, 34.44168], [-118.29739, 34.44177], [-118.29685, 34.44187], [-118.29629, 34.4419], [-118.29592, 34.44188], [-118.29555, 34.44183], [-118.29556, 34.44176], [-118.29537, 34.44172], [-118.29486, 34.44142], [-118.29807, 34.44144]]], [[[-118.29843, 34.44485], [-118.29815, 34.44456], [-118.29809, 34.44445], [-118.29806, 34.44384], [-118.29808, 34.4438], [-118.29811, 34.44378], [-118.29815, 34.44378], [-118.29831, 34.44384], [-118.29842, 34.44384], [-118.29843, 34.44485]]]]} | Unknown Access 4 | Long-Nellus Canyon | 21446 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 32.554 | Long-Nellus Canyon | ||
10586 | 10586 | 10585 | {"type": "Polygon", "coordinates": [[[-118.67703, 34.11763], [-118.67638, 34.11763], [-118.67637, 34.11811], [-118.67199, 34.11812], [-118.67201, 34.11443], [-118.6737, 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 | 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 | 45.591 | Upper Stokes |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);