units_with_maps

Table actions

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

1 row where MNG_AGENCY = 457 and UNIT_NAME = "Elkhorn Slough / Porter Preserve - ESF"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Elkhorn Slough Foundation · 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
9148 9148 9147 {"type": "MultiPolygon", "coordinates": [[[[-121.74458, 36.87593], [-121.74453, 36.87593], [-121.74541, 36.87759], [-121.74583, 36.8787], [-121.74584, 36.8788], [-121.74583, 36.87888], [-121.74579, 36.87896], [-121.7457, 36.87905], [-121.74559, 36.8791], [-121.74543, 36.87915], [-121.74521, 36.87919], [-121.74491, 36.87922], [-121.74461, 36.87922], [-121.74405, 36.87915], [-121.74363, 36.87912], [-121.7431, 36.87912], [-121.74274, 36.87915], [-121.74254, 36.87922], [-121.74238, 36.8793], [-121.74226, 36.87939], [-121.74196, 36.87971], [-121.74184, 36.8798], [-121.74159, 36.87995], [-121.74136, 36.88004], [-121.74109, 36.8801], [-121.73857, 36.8804], [-121.73794, 36.87819], [-121.73765, 36.87745], [-121.73766, 36.87602], [-121.73779, 36.87571], [-121.73725, 36.87554], [-121.73722, 36.87511], [-121.73727, 36.87417], [-121.73732, 36.87395], [-121.73775, 36.87409], [-121.73759, 36.87442], [-121.7379, 36.87452], [-121.73803, 36.87427], [-121.7379, 36.87422], [-121.73796, 36.87409], [-121.73734, 36.87389], [-121.73745, 36.87348], [-121.73713, 36.87337], [-121.73685, 36.87322], [-121.73737, 36.87126], [-121.73617, 36.87117], [-121.73614, 36.87016], [-121.73674, 36.86987], [-121.73647, 36.86938], [-121.73587, 36.86966], [-121.73577, 36.86951], [-121.73563, 36.86936], [-121.73534, 36.86913], [-121.73626, 36.86879], [-121.73767, 36.86822], [-121.74001, 36.86641], [-121.74162, 36.86704], [-121.74248, 36.86762], [-121.74273, 36.86822], [-121.74254, 36.86848], [-121.74255, 36.86901], [-121.743, 36.86957], [-121.74351, 36.86962], [-121.74413, 36.87021], [-121.74425, 36.87092], [-121.74429, 36.87174], [-121.74435, 36.87175], [-121.74434, 36.87235], [-121.74424, 36.87309], [-121.7439, 36.87455], [-121.74388, 36.87481], [-121.74392, 36.87502], [-121.74404, 36.87527], [-121.74415, 36.87542], [-121.74439, 36.87568], [-121.74458, 36.87593]], [[-121.74404, 36.87043], [-121.74329, 36.87006], [-121.7427, 36.87029], [-121.74226, 36.87023], [-121.74082, 36.8726], [-121.74227, 36.87498], [-121.74329, 36.87545], [-121.74366, 36.87559], [-121.74411, 36.8757], [-121.74412, 36.87565], [-121.74363, 36.87499], [-121.7435, 36.87468], [-121.74349, 36.87456], [-121.74351, 36.87447], [-121.74359, 36.87435], [-121.74369, 36.87428], [-121.74393, 36.87357], [-121.74408, 36.87317], [-121.74417, 36.87202], [-121.74411, 36.87185], [-121.74404, 36.87043]]], [[[-121.74039, 36.86596], [-121.74013, 36.86591], [-121.74007, 36.86618], [-121.73927, 36.86602], [-121.73972, 36.86466], [-121.73837, 36.86466], [-121.7372, 36.86463], [-121.73726, 36.86385], [-121.73789, 36.86388], [-121.73793, 36.86333], [-121.73838, 36.86335], [-121.73971, 36.86332], [-121.73972, 36.86323], [-121.74015, 36.86322], [-121.74032, 36.86324], [-121.74045, 36.86502], [-121.74039, 36.86596]]]]} No Public Access 3 15180 Elkhorn Slough / Porter Preserve - ESF 18579 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 196.654 Elkhorn Slough / Porter Preserve - ESF 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]);