superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, ACRES = "215.854" and MNG_AGENCY = 754

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Rivers and Lands Conservancy · 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
14286 14286 14285 {"type": "MultiPolygon", "coordinates": [[[[-115.25908, 33.44142], [-115.25691, 33.44141], [-115.25692, 33.44321], [-115.24776, 33.44322], [-115.24775, 33.43111], [-115.25055, 33.43293], [-115.25107, 33.4333], [-115.25155, 33.43373], [-115.2538, 33.43597], [-115.25908, 33.44142]]], [[[-117.34544, 33.91468], [-117.34509, 33.91482], [-117.34481, 33.91495], [-117.34443, 33.91447], [-117.3444, 33.91406], [-117.3442, 33.91372], [-117.34412, 33.91333], [-117.34414, 33.91296], [-117.34378, 33.91232], [-117.3426, 33.91104], [-117.34229, 33.91079], [-117.3409, 33.91024], [-117.34062, 33.9102], [-117.34003, 33.91028], [-117.34003, 33.9097], [-117.3405, 33.90992], [-117.34147, 33.90992], [-117.34322, 33.91072], [-117.34324, 33.91092], [-117.34382, 33.91091], [-117.34444, 33.9118], [-117.34479, 33.91339], [-117.34492, 33.91372], [-117.34544, 33.91468]]]]} Restricted Access 2 Unnamed site - Riverside Land Conservancy   28657 3059 Rivers and Lands Conservancy 754 Non Profit 6 Non Profit - Land Trust 10 https://riversandlands.org/ Non Governmental Organization 10 215.854    

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