units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, DES_TP = 16 and MNG_AGENCY = 492

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Mendocino Land Trust · 1 ✖

DES_TP 1

  • Private Conservation · 1 ✖

ACCESS_TYP 1

  • Restricted Access · 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
9770 9770 9769 {"type": "MultiPolygon", "coordinates": [[[[-123.76185, 39.54949], [-123.76118, 39.54902], [-123.76011, 39.5472], [-123.7588, 39.54569], [-123.75831, 39.54569], [-123.75672, 39.54449], [-123.75553, 39.54431], [-123.75476, 39.54407], [-123.75418, 39.5437], [-123.75396, 39.54312], [-123.75377, 39.54201], [-123.75357, 39.54166], [-123.75423, 39.54137], [-123.75428, 39.54131], [-123.7549, 39.54156], [-123.75556, 39.54185], [-123.75589, 39.54194], [-123.75614, 39.54205], [-123.75637, 39.54208], [-123.75651, 39.54204], [-123.75664, 39.54197], [-123.7567, 39.54186], [-123.75672, 39.54169], [-123.75712, 39.54228], [-123.75742, 39.54267], [-123.75774, 39.54303], [-123.75811, 39.54339], [-123.75871, 39.5439], [-123.75867, 39.54394], [-123.75913, 39.54439], [-123.76071, 39.54568], [-123.7599, 39.54568], [-123.76036, 39.54603], [-123.76073, 39.54666], [-123.76133, 39.54705], [-123.7617, 39.54781], [-123.76182, 39.5483], [-123.76185, 39.54949]]], [[[-123.76339, 39.54567], [-123.76334, 39.54762], [-123.76332, 39.55004], [-123.76284, 39.54949], [-123.76281, 39.54774], [-123.76275, 39.54734], [-123.76269, 39.547], [-123.76258, 39.54668], [-123.76239, 39.54629], [-123.76188, 39.54567], [-123.76339, 39.54567]]]]} Restricted Access 2 47882 Ten Mile Estuary Property 31826 3128 Mendocino Land Trust 500 Non Profit 6 Non Profit - Land Trust 10 http://mendocinolandtrust.org/ Non Governmental Organization 10 3128 Mendocino Land Trust 492 Non Profit 6 Non Profit - Land Trust 10   Mendocino 24 46.88 Ten Mile Estuary Property 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]);