superunits_with_maps

Table actions

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

1 row where MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=426"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 1 ✖

ACCESS_TYP 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
15279 15279 15278 {"type": "Polygon", "coordinates": [[[-123.82852, 40.06923], [-123.8284, 40.06931], [-123.82833, 40.06939], [-123.82828, 40.06949], [-123.82826, 40.06959], [-123.82827, 40.07021], [-123.82842, 40.07231], [-123.82843, 40.07264], [-123.8284, 40.07297], [-123.82833, 40.0733], [-123.82808, 40.07413], [-123.82689, 40.07376], [-123.82676, 40.07407], [-123.82658, 40.07434], [-123.8256, 40.07545], [-123.82526, 40.07581], [-123.82483, 40.07622], [-123.82452, 40.07647], [-123.82412, 40.07673], [-123.82374, 40.06607], [-123.80985, 40.06641], [-123.80979, 40.06534], [-123.80793, 40.06484], [-123.80484, 40.06488], [-123.80483, 40.06483], [-123.80472, 40.06483], [-123.8042, 40.06509], [-123.80364, 40.06525], [-123.80347, 40.06558], [-123.80301, 40.06575], [-123.80266, 40.06613], [-123.80256, 40.06617], [-123.80256, 40.06644], [-123.80025, 40.06774], [-123.80024, 40.0678], [-123.80016, 40.06779], [-123.79981, 40.06784], [-123.7995, 40.06776], [-123.79917, 40.06752], [-123.79772, 40.06758], [-123.79738, 40.06753], [-123.79627, 40.06769], [-123.79588, 40.0676], [-123.79569, 40.06768], [-123.79552, 40.06801], [-123.79547, 40.06804], [-123.79533, 40.0674], [-123.7951, 40.06749], [-123.79484, 40.06755], [-123.79474, 40.06762], [-123.7947, 40.0676], [-123.79467, 40.06756], [-123.79458, 40.06756], [-123.79453, 40.06765], [-123.79448, 40.06771], [-123.79439, 40.06774], [-123.79427, 40.06772], [-123.79413, 40.06777], [-123.79392, 40.06782], [-123.79367, 40.06795], [-123.79372, 40.06816], [-123.79287, 40.06815], [-123.7926, 40.06816], [-123.79233, 40.06823], [-123.79192, 40.06816], [-123.79158, 40.06816], [-123.79115, 40.06823], [-123.79111, 40.06822], [-123.79117, 40.06798], [-123.79118, 40.06779], [-123.79115, 40.0676], [-123.79108, 40.06741], [-123.79098, 40.06723], [-123.79085, 40.06707], [-123.7907, 40.06692], [-123.79042, 40.06673], [-123.7903, 40.06668], [-123.79021, 40.06679], [-123.78984, 40.06661], [-123.78964, 40.06684], [-123.78808, 40.06607], [-123.78779, 40.06582], [-123.7876, 40.0656], [-123.78713, 40.06543], [-123.78523, 40.0648], [-123.78464, 40.06456], [-123.78358, 40.06403], [-123.78338, 40.06392], [-123.7832, 40.06379], [-123.78213, 40.06291], [-123.78185, 40.06274], [-123.78164, 40.06264], [-123.78142, 40.06256], [-123.78119, 40.0625], [-123.78087, 40.06245], [-123.78032, 40.06239], [-123.77935, 40.06218], [-123.77916, 40.06213], [-123.77899, 40.06205], [-123.77875, 40.06191], [-123.77863, 40.06179], [-123.77854, 40.06167], [-123.77837, 40.06134], [-123.77835, 40.06121], [-123.77835, 40.06109], [-123.77838, 40.06096], [-123.77863, 40.06044], [-123.7787, 40.06024], [-123.77874, 40.06006], [-123.77886, 40.05898], [-123.77926, 40.05863], [-123.7813, 40.05827], [-123.78128, 40.05728], [-123.7815, 40.05719], [-123.78192, 40.05699], [-123.78352, 40.05645], [-123.78374, 40.0564], [-123.78396, 40.05637], [-123.78418, 40.05636], [-123.7847, 40.05642], [-123.78558, 40.05629], [-123.78578, 40.05624], [-123.78663, 40.05596], [-123.78729, 40.05583], [-123.78786, 40.05578], [-123.78825, 40.05577], [-123.78946, 40.05585], [-123.79003, 40.05584], [-123.79041, 40.0558], [-123.7918, 40.05562], [-123.79169, 40.05432], [-123.79151, 40.05406], [-123.79142, 40.05389], [-123.79137, 40.05372], [-123.79135, 40.05354], [-123.79137, 40.05336], [-123.79164, 40.05219], [-123.79172, 40.0517], [-123.79141, 40.05008], [-123.79106, 40.04968], [-123.79508, 40.05025], [-123.80534, 40.05096], [-123.80536, 40.05429], [-123.81047, 40.05452], [-123.81046, 40.06236], [-123.81511, 40.06221], [-123.82203, 40.06227], [-123.82216, 40.06203], [-123.82224, 40.06162], [-123.82227, 40.06152], [-123.82239, 40.06132], [-123.82246, 40.06124], [-123.82272, 40.06102], [-123.82291, 40.06089], [-123.82318, 40.06078], [-123.82344, 40.06072], [-123.82362, 40.06223], [-123.8255, 40.06223], [-123.82538, 40.06249], [-123.82526, 40.06297], [-123.82519, 40.06337], [-123.82524, 40.06358], [-123.82541, 40.06413], [-123.82557, 40.06458], [-123.8257, 40.06488], [-123.82606, 40.06571], [-123.82615, 40.06587], [-123.82649, 40.06624], [-123.8272, 40.0669], [-123.82734, 40.06707], [-123.82746, 40.06728], [-123.8276, 40.06762], [-123.82788, 40.06854], [-123.82796, 40.06897], [-123.82789, 40.06922], [-123.82852, 40.06923]]]} Open Access 1 Benbow State Recreation Area http://www.parks.ca.gov/?page_id=426 30556 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 1138.013 Benbow SRA 1958

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