superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where ACCESS_TYP = 1, MNG_AGENCY = 47 and PARK_URL = "http://www.parks.ca.gov/?page_id=521"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Parks and Recreation · 1 ✖

ACCESS_TYP 1

  • Open Access · 1 ✖
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
15153 15153 15152 {"type": "MultiPolygon", "coordinates": [[[[-122.40432, 37.29977], [-122.40425, 37.30152], [-122.40431, 37.30496], [-122.40413, 37.30807], [-122.40354, 37.31222], [-122.38707, 37.31165], [-122.38706, 37.31158], [-122.38683, 37.31065], [-122.38673, 37.31042], [-122.38658, 37.31018], [-122.38646, 37.31008], [-122.38631, 37.31002], [-122.38562, 37.30993], [-122.38543, 37.30979], [-122.3852, 37.30969], [-122.38515, 37.30965], [-122.38514, 37.3096], [-122.3852, 37.30944], [-122.38521, 37.3093], [-122.38525, 37.30926], [-122.38531, 37.30924], [-122.38555, 37.30925], [-122.38572, 37.30923], [-122.38589, 37.30915], [-122.38601, 37.30904], [-122.3863, 37.30855], [-122.3865, 37.30753], [-122.38949, 37.30553], [-122.39023, 37.30427], [-122.39115, 37.30451], [-122.39139, 37.30449], [-122.39164, 37.30472], [-122.3917, 37.30487], [-122.39189, 37.30494], [-122.39221, 37.30482], [-122.3926, 37.30519], [-122.39314, 37.30524], [-122.39319, 37.30497], [-122.3937, 37.30529], [-122.39397, 37.30519], [-122.39389, 37.30497], [-122.39419, 37.30487], [-122.39442, 37.30501], [-122.39468, 37.30501], [-122.39521, 37.30472], [-122.3955, 37.30472], [-122.39567, 37.3049], [-122.39588, 37.30479], [-122.39649, 37.30497], [-122.39679, 37.30493], [-122.39678, 37.30513], [-122.39718, 37.3052], [-122.39726, 37.3051], [-122.39741, 37.30504], [-122.39779, 37.3051], [-122.39793, 37.30482], [-122.39809, 37.30468], [-122.39838, 37.30463], [-122.39871, 37.30468], [-122.399, 37.30465], [-122.39942, 37.30437], [-122.39929, 37.30398], [-122.3994, 37.30376], [-122.39983, 37.30383], [-122.40009, 37.30371], [-122.40022, 37.30334], [-122.40051, 37.30338], [-122.40078, 37.30325], [-122.4007, 37.30292], [-122.40068, 37.30264], [-122.40089, 37.30258], [-122.40124, 37.30267], [-122.40139, 37.30244], [-122.40162, 37.30237], [-122.40184, 37.30205], [-122.40199, 37.30195], [-122.40198, 37.30126], [-122.40228, 37.30118], [-122.40249, 37.30122], [-122.40279, 37.30117], [-122.40432, 37.29977]]], [[[-122.40857, 37.28288], [-122.40859, 37.283], [-122.40858, 37.28311], [-122.40846, 37.28337], [-122.40836, 37.28379], [-122.40829, 37.28395], [-122.40832, 37.28427], [-122.40829, 37.28441], [-122.40831, 37.28494], [-122.40818, 37.28572], [-122.40818, 37.28596], [-122.40813, 37.28617], [-122.40806, 37.28633], [-122.40795, 37.28647], [-122.4079, 37.28658], [-122.40786, 37.28672], [-122.40785, 37.28697], [-122.40774, 37.28689], [-122.40758, 37.28685], [-122.40755, 37.28695], [-122.40675, 37.29373], [-122.40675, 37.2969], [-122.40642, 37.29723], [-122.40626, 37.29744], [-122.40624, 37.29788], [-122.40629, 37.29893], [-122.40624, 37.29913], [-122.40621, 37.29945], [-122.40622, 37.29965], [-122.40629, 37.29987], [-122.40561, 37.30499], [-122.40478, 37.30498], [-122.40492, 37.30153], [-122.40483, 37.29977], [-122.40487, 37.29895], [-122.40518, 37.2977], [-122.40575, 37.29669], [-122.40599, 37.29617], [-122.40619, 37.29599], [-122.40623, 37.29584], [-122.40636, 37.29567], [-122.40644, 37.29553], [-122.40654, 37.29523], [-122.40656, 37.29498], [-122.40655, 37.2948], [-122.4065, 37.29464], [-122.40654, 37.29423], [-122.40654, 37.29383], [-122.4065, 37.29351], [-122.40645, 37.29324], [-122.40644, 37.29291], [-122.40639, 37.29264], [-122.40629, 37.29232], [-122.40612, 37.29198], [-122.40595, 37.29146], [-122.40508, 37.28939], [-122.405, 37.28912], [-122.4049, 37.28872], [-122.40485, 37.28831], [-122.40482, 37.28791], [-122.40477, 37.28775], [-122.40503, 37.28651], [-122.40527, 37.28606], [-122.40756, 37.28257], [-122.40857, 37.28288]]]]} Open Access 1 Pomponio State Beach http://www.parks.ca.gov/?page_id=521 1695 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 399.864 Pomponio SB 1960

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);