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 = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Carlsbad-Highlands-ER"

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
610 610 609 {"type": "Polygon", "coordinates": [[[-117.28817, 33.1631], [-117.28814, 33.16312], [-117.28816, 33.1691], [-117.28679, 33.16836], [-117.28617, 33.16805], [-117.28522, 33.16881], [-117.28511, 33.16913], [-117.28473, 33.16932], [-117.28468, 33.16947], [-117.28458, 33.16947], [-117.28458, 33.16955], [-117.28435, 33.16972], [-117.28386, 33.16973], [-117.28384, 33.16947], [-117.27955, 33.16947], [-117.27951, 33.16855], [-117.27085, 33.1685], [-117.27085, 33.16222], [-117.27083, 33.16221], [-117.27078, 33.16226], [-117.27078, 33.161], [-117.27075, 33.15819], [-117.27711, 33.15812], [-117.27712, 33.1581], [-117.2767, 33.1566], [-117.28385, 33.15499], [-117.2843, 33.15626], [-117.28207, 33.1577], [-117.28371, 33.15971], [-117.28404, 33.16164], [-117.28732, 33.161], [-117.28784, 33.16226], [-117.28788, 33.16309], [-117.28817, 33.1631]], [[-117.28036, 33.16048], [-117.28028, 33.16048], [-117.28019, 33.16051], [-117.28012, 33.16057], [-117.28009, 33.16065], [-117.28009, 33.16073], [-117.28012, 33.16081], [-117.28019, 33.16087], [-117.28026, 33.1609], [-117.28037, 33.16091], [-117.28048, 33.16087], [-117.28055, 33.16081], [-117.28059, 33.16073], [-117.28058, 33.16063], [-117.28054, 33.16056], [-117.28047, 33.1605], [-117.28036, 33.16048]]]} Open Access 1 Carlsbad Highlands Ecological Reserve https://www.wildlife.ca.gov/Lands/Places-to-Visit/Carlsbad-Highlands-ER 32095 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 471.805 Carlsbad Highlands ER 2000

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