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_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=643"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 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
15147 15147 15146 {"type": "Polygon", "coordinates": [[[-117.98834, 33.64701], [-117.98813, 33.64738], [-117.98811, 33.64739], [-117.98791, 33.6478], [-117.97361, 33.63942], [-117.96958, 33.63745], [-117.96882, 33.63728], [-117.96708, 33.63642], [-117.96309, 33.63401], [-117.95841, 33.63113], [-117.9583, 33.63108], [-117.95861, 33.63082], [-117.95913, 33.63002], [-117.95912, 33.62999], [-117.95931, 33.6295], [-117.95943, 33.62955], [-117.96027, 33.63023], [-117.96078, 33.6307], [-117.96163, 33.6312], [-117.96193, 33.63147], [-117.96282, 33.63208], [-117.96297, 33.63214], [-117.96332, 33.63234], [-117.96355, 33.63251], [-117.9641, 33.63284], [-117.9645, 33.63312], [-117.96484, 33.6332], [-117.96544, 33.63356], [-117.96577, 33.6338], [-117.96605, 33.63397], [-117.96638, 33.63407], [-117.96742, 33.63467], [-117.96945, 33.63579], [-117.96988, 33.63609], [-117.97027, 33.63622], [-117.97138, 33.63698], [-117.97183, 33.63718], [-117.97223, 33.63741], [-117.97277, 33.63778], [-117.97325, 33.63802], [-117.97374, 33.63833], [-117.974, 33.63845], [-117.97433, 33.63856], [-117.97451, 33.63868], [-117.97481, 33.63875], [-117.9754, 33.63905], [-117.97558, 33.63919], [-117.97594, 33.63938], [-117.97662, 33.63989], [-117.97695, 33.63994], [-117.97745, 33.64018], [-117.9787, 33.64102], [-117.97926, 33.64124], [-117.97971, 33.64156], [-117.98037, 33.64188], [-117.98143, 33.64262], [-117.98168, 33.64282], [-117.98287, 33.64338], [-117.98322, 33.64368], [-117.98376, 33.64397], [-117.98437, 33.64439], [-117.98535, 33.64486], [-117.98588, 33.64525], [-117.98633, 33.64546], [-117.98673, 33.6459], [-117.987, 33.64595], [-117.98709, 33.64615], [-117.98739, 33.64636], [-117.98792, 33.64668], [-117.98814, 33.64688], [-117.98834, 33.64701]]]} Open Access 1 Huntington State Beach http://www.parks.ca.gov/?page_id=643 1575 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 115.774 Huntington SB 1942

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