calands: superunits_with_maps: 1 row where ACCESS_TYP = 1 and PARK_URL = "http://www.parks.ca.gov/?page

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

1 row where ACCESS_TYP = 1 and PARK_URL = "http://www.parks.ca.gov/?page_id=539"

Search:

descending

This data as json, copyable, CSV (advanced)

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
15250	15250	15249	{"type": "Polygon", "coordinates": [[[-122.22428, 37.27253], [-122.21984, 37.27249], [-122.21981, 37.26906], [-122.21531, 37.26902], [-122.21525, 37.26554], [-122.21112, 37.26553], [-122.21099, 37.26607], [-122.21098, 37.26618], [-122.21101, 37.26633], [-122.21123, 37.26679], [-122.21128, 37.26696], [-122.21128, 37.26712], [-122.21122, 37.26731], [-122.2112, 37.26751], [-122.21137, 37.26842], [-122.21132, 37.26985], [-122.21134, 37.26995], [-122.21143, 37.27008], [-122.2116, 37.27019], [-122.21172, 37.27022], [-122.21187, 37.27018], [-122.21193, 37.27014], [-122.21196, 37.27008], [-122.21209, 37.26948], [-122.21214, 37.26935], [-122.21228, 37.26913], [-122.21248, 37.26893], [-122.21255, 37.26886], [-122.21265, 37.26881], [-122.21276, 37.26878], [-122.21287, 37.26877], [-122.21306, 37.2688], [-122.21315, 37.26885], [-122.21321, 37.26892], [-122.21326, 37.26899], [-122.21337, 37.2705], [-122.21336, 37.27072], [-122.21321, 37.27154], [-122.21325, 37.27172], [-122.21357, 37.27247], [-122.21335, 37.27246], [-122.21306, 37.27177], [-122.21301, 37.2716], [-122.21301, 37.27147], [-122.21313, 37.27086], [-122.21315, 37.27057], [-122.21304, 37.26903], [-122.21302, 37.26901], [-122.21294, 37.26895], [-122.21278, 37.26896], [-122.2127, 37.269], [-122.21249, 37.2692], [-122.21238, 37.26935], [-122.21231, 37.26952], [-122.21216, 37.27016], [-122.21206, 37.27029], [-122.21196, 37.27035], [-122.21179, 37.27039], [-122.21167, 37.27039], [-122.21155, 37.27037], [-122.2114, 37.2703], [-122.21131, 37.27024], [-122.21121, 37.27015], [-122.21114, 37.27004], [-122.2111, 37.26992], [-122.21114, 37.26843], [-122.211, 37.26767], [-122.21098, 37.26752], [-122.21099, 37.26735], [-122.21105, 37.26714], [-122.21106, 37.26702], [-122.21102, 37.26685], [-122.21079, 37.26638], [-122.21076, 37.26625], [-122.21076, 37.26608], [-122.21088, 37.26554], [-122.21085, 37.26552], [-122.21085, 37.26498], [-122.21063, 37.26467], [-122.21084, 37.26443], [-122.2108, 37.26126], [-122.21038, 37.26127], [-122.21037, 37.2611], [-122.21023, 37.26095], [-122.21015, 37.26068], [-122.20995, 37.2607], [-122.20944, 37.26065], [-122.20897, 37.26047], [-122.20697, 37.25934], [-122.20731, 37.25919], [-122.20766, 37.25916], [-122.20866, 37.25852], [-122.20866, 37.2585], [-122.1974, 37.2586], [-122.19736, 37.2656], [-122.19714, 37.27232], [-122.19973, 37.27233], [-122.19977, 37.27115], [-122.20205, 37.27183], [-122.20205, 37.27208], [-122.2022, 37.27234], [-122.20618, 37.27235], [-122.20398, 37.27447], [-122.20137, 37.28064], [-122.20152, 37.28339], [-122.19516, 37.28343], [-122.19361, 37.27974], [-122.19282, 37.27974], [-122.19291, 37.27233], [-122.19287, 37.27234], [-122.19278, 37.27974], [-122.18844, 37.27976], [-122.18841, 37.27231], [-122.18844, 37.266], [-122.17941, 37.26552], [-122.17074, 37.2651], [-122.16183, 37.26505], [-122.16184, 37.26152], [-122.17065, 37.26162], [-122.1706, 37.25819], [-122.17933, 37.25843], [-122.17942, 37.25127], [-122.18603, 37.25139], [-122.18614, 37.24764], [-122.1907, 37.24769], [-122.19082, 37.2439], [-122.1978, 37.24392], [-122.2064, 37.24398], [-122.21365, 37.2439], [-122.2143, 37.24428], [-122.2161, 37.24579], [-122.21686, 37.24666], [-122.21835, 37.24741], [-122.22062, 37.24827], [-122.22094, 37.24857], [-122.22105, 37.24886], [-122.22104, 37.24937], [-122.22124, 37.24967], [-122.22243, 37.25047], [-122.22414, 37.25125], [-122.22431, 37.25837], [-122.22428, 37.27253]]]}	Open Access 1	Portola Redwoods State Park	http://www.parks.ca.gov/?page_id=539	1696	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	2718.252	Portola Redwoods SP	1945

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