superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 2 and ACRES = "1.431"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

ACCESS_TYP 1

  • Restricted 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
7637 7637 7636 {"type": "MultiPolygon", "coordinates": [[[[-118.38426, 33.41378], [-118.3842, 33.41383], [-118.38414, 33.41394], [-118.38401, 33.41383], [-118.384, 33.41378], [-118.38413, 33.41372], [-118.38426, 33.41372], [-118.38426, 33.41378]]], [[[-118.38964, 33.41779], [-118.38964, 33.41785], [-118.38958, 33.41785], [-118.38951, 33.41779], [-118.38951, 33.41769], [-118.38957, 33.41769], [-118.38964, 33.41779]]], [[[-118.40478, 33.42155], [-118.4047, 33.42166], [-118.40464, 33.42166], [-118.40457, 33.42161], [-118.40457, 33.42155], [-118.40464, 33.42149], [-118.4047, 33.42155], [-118.40478, 33.42155]]], [[[-118.40497, 33.42045], [-118.40496, 33.42056], [-118.4049, 33.42056], [-118.40477, 33.42051], [-118.40484, 33.42045], [-118.40497, 33.42045]]], [[[-118.47979, 33.38818], [-118.47972, 33.38823], [-118.47959, 33.38823], [-118.47959, 33.38818], [-118.47946, 33.38806], [-118.47946, 33.38796], [-118.47952, 33.38796], [-118.47959, 33.38802], [-118.47972, 33.38807], [-118.47979, 33.38818]]], [[[-118.4811, 33.38065], [-118.48097, 33.38071], [-118.48091, 33.38065], [-118.4809, 33.38059], [-118.4811, 33.3806], [-118.4811, 33.38065]]], [[[-118.48156, 33.37878], [-118.4815, 33.37889], [-118.48142, 33.37894], [-118.4813, 33.37889], [-118.48129, 33.37878], [-118.48133, 33.37875], [-118.48139, 33.37878], [-118.48144, 33.37879], [-118.48152, 33.37875], [-118.48156, 33.37878]]], [[[-118.4815, 33.37944], [-118.48149, 33.37954], [-118.48142, 33.37955], [-118.48136, 33.37949], [-118.48143, 33.37944], [-118.4815, 33.37944]]], [[[-118.48404, 33.39928], [-118.48397, 33.39934], [-118.48391, 33.39934], [-118.48391, 33.39926], [-118.48396, 33.39927], [-118.48401, 33.39924], [-118.48404, 33.39928]]], [[[-118.48436, 33.39945], [-118.48417, 33.39945], [-118.48417, 33.3994], [-118.48423, 33.39934], [-118.4843, 33.39934], [-118.48436, 33.39945]]], [[[-118.48607, 33.39978], [-118.48594, 33.39984], [-118.48588, 33.39978], [-118.48587, 33.39969], [-118.48595, 33.39971], [-118.48601, 33.39968], [-118.48607, 33.39978]]], [[[-118.52159, 33.4659], [-118.52152, 33.46601], [-118.52146, 33.46606], [-118.52132, 33.46612], [-118.52126, 33.46616], [-118.52119, 33.46606], [-118.5212, 33.46595], [-118.52126, 33.46589], [-118.52133, 33.46589], [-118.52146, 33.46584], [-118.52158, 33.46584], [-118.52159, 33.4659]]], [[[-118.52702, 33.46803], [-118.5269, 33.46799], [-118.52682, 33.468], [-118.52666, 33.46817], [-118.52666, 33.46821], [-118.52663, 33.46821], [-118.52656, 33.46816], [-118.52656, 33.4681], [-118.5267, 33.46799], [-118.52683, 33.46794], [-118.52696, 33.46799], [-118.52702, 33.46799], [-118.52702, 33.46803]]], [[[-118.56014, 33.43285], [-118.56001, 33.43285], [-118.55987, 33.4328], [-118.55988, 33.43274], [-118.55994, 33.43269], [-118.56007, 33.43274], [-118.56014, 33.43279], [-118.56014, 33.43285]]], [[[-118.58083, 33.4493], [-118.58077, 33.44936], [-118.58064, 33.44941], [-118.58051, 33.44931], [-118.58051, 33.44914], [-118.58057, 33.44908], [-118.5807, 33.44909], [-118.58083, 33.4492], [-118.58083, 33.4493]]], [[[-118.60553, 33.47252], [-118.60547, 33.47263], [-118.60527, 33.47264], [-118.60527, 33.47247], [-118.6052, 33.47236], [-118.6052, 33.47225], [-118.60533, 33.47225], [-118.60547, 33.4723], [-118.60553, 33.47242], [-118.60553, 33.47252]]]]} Restricted Access 2 Offshore Island   23072 3070 Santa Catalina Island Conservancy 377 Non Profit 6 Non Profit - Land Trust 10 http://www.catalinaconservancy.org/ Non Governmental Organization 10 1.431 Offshore Island  

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