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/default.asp?page_id=531"

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
15146 15146 15145 {"type": "MultiPolygon", "coordinates": [[[[-122.43608, 37.42275], [-122.43599, 37.42273], [-122.42616, 37.42242], [-122.4261, 37.42217], [-122.42603, 37.42194], [-122.42633, 37.42193], [-122.42651, 37.4223], [-122.43336, 37.42249], [-122.43422, 37.42152], [-122.43421, 37.4215], [-122.43399, 37.42142], [-122.4341, 37.42131], [-122.43446, 37.42083], [-122.43469, 37.42038], [-122.43472, 37.4203], [-122.4352, 37.41972], [-122.43527, 37.41972], [-122.43553, 37.41982], [-122.43563, 37.41988], [-122.43573, 37.41988], [-122.43582, 37.41996], [-122.43584, 37.42], [-122.43581, 37.42009], [-122.43577, 37.42013], [-122.4356, 37.42044], [-122.43551, 37.42066], [-122.43546, 37.42087], [-122.43546, 37.42112], [-122.4356, 37.4217], [-122.43562, 37.42185], [-122.43593, 37.42255], [-122.43608, 37.42275]]], [[[-122.46056, 37.49295], [-122.46009, 37.49326], [-122.45908, 37.49234], [-122.45866, 37.49256], [-122.45852, 37.49248], [-122.45819, 37.49268], [-122.45819, 37.4927], [-122.45855, 37.49303], [-122.45824, 37.49308], [-122.456, 37.4897], [-122.45555, 37.48995], [-122.45527, 37.48972], [-122.45508, 37.48981], [-122.4542, 37.48876], [-122.45222, 37.49006], [-122.45223, 37.48995], [-122.45414, 37.48868], [-122.45306, 37.48739], [-122.45178, 37.48562], [-122.45011, 37.48274], [-122.44697, 37.48397], [-122.44651, 37.48338], [-122.44616, 37.48286], [-122.44634, 37.48294], [-122.44646, 37.48296], [-122.44673, 37.48289], [-122.44688, 37.48291], [-122.44709, 37.48303], [-122.44734, 37.48299], [-122.44758, 37.48285], [-122.44782, 37.48261], [-122.44847, 37.48242], [-122.44871, 37.48231], [-122.44903, 37.48193], [-122.4496, 37.48191], [-122.44961, 37.4819], [-122.44836, 37.48038], [-122.44925, 37.47992], [-122.44926, 37.47991], [-122.44606, 37.47602], [-122.44617, 37.47596], [-122.44617, 37.47594], [-122.44543, 37.47507], [-122.44524, 37.47512], [-122.44382, 37.47342], [-122.44428, 37.47355], [-122.44471, 37.47364], [-122.44507, 37.47362], [-122.44533, 37.47355], [-122.44551, 37.4734], [-122.44593, 37.47246], [-122.44573, 37.47234], [-122.44523, 37.4723], [-122.44544, 37.47012], [-122.4443, 37.46669], [-122.44446, 37.46508], [-122.44689, 37.46526], [-122.44727, 37.46733], [-122.4473, 37.46972], [-122.44755, 37.47076], [-122.44773, 37.47113], [-122.44787, 37.47203], [-122.4491, 37.47491], [-122.4493, 37.47579], [-122.44939, 37.47585], [-122.44953, 37.47642], [-122.45088, 37.47866], [-122.4512, 37.4794], [-122.45169, 37.48015], [-122.45172, 37.4804], [-122.45195, 37.48059], [-122.45244, 37.48127], [-122.45258, 37.48182], [-122.45281, 37.48233], [-122.45281, 37.48249], [-122.45396, 37.48441], [-122.45468, 37.48585], [-122.45557, 37.48729], [-122.45632, 37.4883], [-122.45638, 37.48851], [-122.45732, 37.48956], [-122.45784, 37.49029], [-122.45838, 37.49091], [-122.45925, 37.49165], [-122.46051, 37.49292], [-122.46056, 37.49295]]], [[[-122.46335, 37.49585], [-122.46314, 37.49602], [-122.46172, 37.49469], [-122.46195, 37.49453], [-122.4621, 37.4947], [-122.46243, 37.49496], [-122.46261, 37.49516], [-122.46298, 37.49549], [-122.46307, 37.49564], [-122.46314, 37.49571], [-122.46335, 37.49585]]]]} Open Access 1 Half Moon Bay State Beach http://www.parks.ca.gov/default.asp?page_id=531 1554 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 202.767 Half Moon Bay SB 1956

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