superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where ACCESS_TYP = 4 and MNG_AGENCY = 27 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 15 ✖
ACCESS_TYP 1
- Unknown Access · 15 ✖
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
12589 | 12589 | 12588 | {"type": "Polygon", "coordinates": [[[-118.63258, 34.35354], [-118.62383, 34.35366], [-118.62373, 34.34997], [-118.63242, 34.34997], [-118.63258, 34.35354]]]} | Unknown Access 4 | Ron Bishop & Judge Anderson Park | 29682 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 79.877 | Ron Bishop & Judge Anderson Park | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
3423 | 3423 | 3422 | {"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 | 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 | 345.905 | Holser Canyon OS | ||
3422 | 3422 | 3421 | {"type": "Polygon", "coordinates": [[[-118.80384, 34.13634], [-118.80042, 34.13935], [-118.78741, 34.13631], [-118.777, 34.13531], [-118.77703, 34.1303], [-118.77642, 34.13028], [-118.77627, 34.13026], [-118.77606, 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.12905], [-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 | 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 | 525.543 | Truinfo Canyon OS |
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]);