units_with_maps

Table actions

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

1 row where ACRES = "47.964", DES_TP = 16 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 1 ✖

MNG_AGENCY 1

DES_TP 1

  • Private Conservation · 1 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
9064 9064 9063 {"type": "MultiPolygon", "coordinates": [[[[-121.75263, 36.85516], [-121.75065, 36.85699], [-121.75018, 36.85703], [-121.74877, 36.85849], [-121.74805, 36.85863], [-121.74789, 36.85532], [-121.75263, 36.85516]]], [[[-121.74646, 36.88109], [-121.73938, 36.88076], [-121.73873, 36.88092], [-121.73862, 36.88056], [-121.7411, 36.88026], [-121.74146, 36.88018], [-121.7417, 36.88009], [-121.74189, 36.87998], [-121.74208, 36.87984], [-121.74248, 36.87945], [-121.74262, 36.87937], [-121.74279, 36.87931], [-121.74322, 36.87929], [-121.74362, 36.87929], [-121.74433, 36.87935], [-121.74434, 36.87933], [-121.74445, 36.87935], [-121.74446, 36.87937], [-121.74459, 36.87938], [-121.74488, 36.87939], [-121.7452, 36.87936], [-121.74544, 36.87932], [-121.74569, 36.87925], [-121.74583, 36.87917], [-121.74593, 36.87908], [-121.74602, 36.87895], [-121.74605, 36.87882], [-121.74603, 36.87868], [-121.74553, 36.87736], [-121.74477, 36.87596], [-121.74529, 36.8759], [-121.7452, 36.87554], [-121.74532, 36.87554], [-121.74565, 36.87667], [-121.74582, 36.87665], [-121.74645, 36.87865], [-121.7465, 36.87886], [-121.74657, 36.87933], [-121.74658, 36.87979], [-121.74657, 36.88007], [-121.74646, 36.88109]]]]} No Public Access 3 15004 Elkhorn Slough 18572 3019 Elkhorn Slough Foundation 464 Non Profit 6 Non Profit - Land Trust 10 http://www.elkhornslough.org Non Governmental Organization 10 3019 Elkhorn Slough Foundation 457 Non Profit 6 Non Profit - Land Trust 10   Monterey 14 47.964 Elkhorn Slough 0 Private Conservation 16 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);