units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, COUNTY = 6 and MNG_AGENCY = 902

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Los Cerritos Wetland Authority · 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
9815 9815 9814 {"type": "MultiPolygon", "coordinates": [[[[-118.0981, 33.75518], [-118.09806, 33.75524], [-118.09723, 33.75729], [-118.09712, 33.75727], [-118.09712, 33.7574], [-118.09718, 33.75742], [-118.09712, 33.75756], [-118.09679, 33.75796], [-118.09678, 33.7574], [-118.09397, 33.75741], [-118.0981, 33.75518]]], [[[-118.10823, 33.7587], [-118.10791, 33.75879], [-118.10789, 33.75877], [-118.10682, 33.75905], [-118.10565, 33.75931], [-118.10521, 33.75938], [-118.10477, 33.75942], [-118.10433, 33.75944], [-118.10388, 33.75944], [-118.10387, 33.7595], [-118.09897, 33.75948], [-118.09898, 33.75944], [-118.09888, 33.75943], [-118.09766, 33.75943], [-118.09756, 33.75944], [-118.09753, 33.75948], [-118.09711, 33.75947], [-118.09713, 33.75927], [-118.09719, 33.75906], [-118.09855, 33.75569], [-118.0987, 33.75543], [-118.09888, 33.75522], [-118.0991, 33.75502], [-118.09928, 33.75491], [-118.10004, 33.75448], [-118.10066, 33.75425], [-118.10133, 33.7539], [-118.1015, 33.75378], [-118.10179, 33.75355], [-118.10197, 33.75343], [-118.10391, 33.75239], [-118.1039, 33.75304], [-118.10392, 33.75305], [-118.10544, 33.75188], [-118.10505, 33.75144], [-118.10335, 33.75235], [-118.10275, 33.75234], [-118.10578, 33.75071], [-118.10581, 33.75113], [-118.10588, 33.75155], [-118.10546, 33.75189], [-118.10624, 33.75276], [-118.10496, 33.75373], [-118.10575, 33.75452], [-118.10487, 33.7551], [-118.10823, 33.7587]]], [[[-118.1037, 33.76073], [-118.10224, 33.76073], [-118.10201, 33.76064], [-118.10203, 33.75976], [-118.10363, 33.75977], [-118.10369, 33.75982], [-118.1037, 33.76073]]], [[[-118.1044, 33.76679], [-118.10413, 33.76701], [-118.10379, 33.76693], [-118.10378, 33.76689], [-118.10341, 33.76687], [-118.10336, 33.76683], [-118.1034, 33.76645], [-118.10346, 33.76609], [-118.1044, 33.76679]]], [[[-118.11507, 33.76323], [-118.11475, 33.7634], [-118.11459, 33.76373], [-118.11427, 33.76414], [-118.11409, 33.76433], [-118.11382, 33.76457], [-118.11347, 33.76479], [-118.11321, 33.76491], [-118.1129, 33.76502], [-118.1124, 33.76514], [-118.1115, 33.76493], [-118.11152, 33.76491], [-118.11151, 33.7649], [-118.11107, 33.76499], [-118.11113, 33.76522], [-118.10929, 33.76562], [-118.10921, 33.76539], [-118.10584, 33.76612], [-118.10538, 33.76627], [-118.10496, 33.76644], [-118.10362, 33.76543], [-118.10389, 33.76452], [-118.10395, 33.76416], [-118.10399, 33.76388], [-118.104, 33.7635], [-118.10401, 33.76043], [-118.104, 33.7599], [-118.10408, 33.7599], [-118.10408, 33.75983], [-118.10459, 33.75981], [-118.10511, 33.75977], [-118.10561, 33.7597], [-118.10597, 33.75963], [-118.10599, 33.75965], [-118.10654, 33.75953], [-118.10656, 33.75946], [-118.10676, 33.75945], [-118.10678, 33.75947], [-118.10725, 33.75935], [-118.10805, 33.75914], [-118.10805, 33.75911], [-118.10954, 33.7587], [-118.10954, 33.75868], [-118.11055, 33.75842], [-118.11056, 33.75844], [-118.1106, 33.75844], [-118.11072, 33.75876], [-118.11112, 33.75891], [-118.11151, 33.75866], [-118.11346, 33.76076], [-118.11388, 33.76125], [-118.11425, 33.76177], [-118.11479, 33.76278], [-118.11483, 33.76277], [-118.11507, 33.76323]]], [[[-118.1102, 33.76604], [-118.10804, 33.76789], [-118.10525, 33.76728], [-118.10565, 33.76708], [-118.10606, 33.76694], [-118.1102, 33.76604]]], [[[-118.11134, 33.76537], [-118.11087, 33.76547], [-118.11087, 33.76547], [-118.11104, 33.76532], [-118.11134, 33.76537]]]]} Restricted Access 2 47917 Los Cerritos Wetlands 32016 2418 Los Cerritos Wetland Authority 929 Special District 4 Joint Powers Authority 24 http://intoloscerritoswetlands.org Special District 4 2418 Los Cerritos Wetland Authority 902 Special District 4 Joint Powers Authority 23 http://intoloscerritoswetlands.org/ Los Angeles 6 311.339 Los Cerritos Wetlands 2006 Local Conservation Area 4 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]);