units_with_maps

Table actions

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

1 row where AGNCY_NAME = 906 and MNG_AGENCY = 27

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Mountains Recreation and Conservation Authority · 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
9267 9267 9266 {"type": "Polygon", "coordinates": [[[-118.89578, 34.04583], [-118.89545, 34.0465], [-118.89534, 34.04777], [-118.89495, 34.04803], [-118.89531, 34.04821], [-118.89497, 34.04882], [-118.895, 34.04908], [-118.89444, 34.04961], [-118.894, 34.04997], [-118.89375, 34.0506], [-118.89329, 34.05057], [-118.89309, 34.05109], [-118.89312, 34.05144], [-118.89217, 34.05168], [-118.89171, 34.05199], [-118.89167, 34.05245], [-118.89133, 34.05309], [-118.89159, 34.05384], [-118.89131, 34.05475], [-118.89087, 34.05501], [-118.89087, 34.0588], [-118.8852, 34.05699], [-118.88519, 34.06002], [-118.88513, 34.06086], [-118.88502, 34.06371], [-118.88079, 34.06367], [-118.88078, 34.06182], [-118.87713, 34.06178], [-118.87711, 34.06155], [-118.87705, 34.06135], [-118.87693, 34.06114], [-118.87676, 34.06093], [-118.87657, 34.06077], [-118.87635, 34.06064], [-118.8761, 34.06054], [-118.87586, 34.06048], [-118.87576, 34.05396], [-118.8764, 34.05415], [-118.8764, 34.04833], [-118.88472, 34.04835], [-118.88473, 34.04851], [-118.88971, 34.04852], [-118.89018, 34.04758], [-118.89017, 34.04756], [-118.89007, 34.04759], [-118.88998, 34.04755], [-118.88994, 34.04748], [-118.88998, 34.04738], [-118.89064, 34.04738], [-118.89172, 34.04673], [-118.89183, 34.04684], [-118.89343, 34.04588], [-118.89257, 34.04487], [-118.89169, 34.04565], [-118.89155, 34.04555], [-118.89134, 34.04558], [-118.89131, 34.0454], [-118.89104, 34.04593], [-118.8908, 34.0459], [-118.89068, 34.0459], [-118.89055, 34.04593], [-118.89051, 34.04586], [-118.89061, 34.04457], [-118.89139, 34.0446], [-118.89167, 34.04457], [-118.8919, 34.0445], [-118.89214, 34.04439], [-118.89214, 34.04436], [-118.89236, 34.0442], [-118.89252, 34.04402], [-118.89263, 34.04383], [-118.89312, 34.04483], [-118.89521, 34.04485], [-118.89558, 34.04522], [-118.89561, 34.04562], [-118.89578, 34.04583]]]} Open Access 1 15428 Charmlee Wilderness Park 29180 1193 Malibu, City of 906 City 2 City Agency 2 http://www.malibucity.org/Index.aspx?NID=335 City 2 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.malibucity.org/Facilities/Facility/Details/Charmlee-Wilderness-Park-8 Los Angeles 6 533.874 Charmlee Wilderness Park 0 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]);