units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, LABEL_NAME = "Elyria Canyon Park" and MNG_AGENCY = 27

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 2 ✖
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
5220 5220 5219 {"type": "MultiPolygon", "coordinates": [[[[-118.22626, 34.10083], [-118.2251, 34.10204], [-118.2248, 34.10191], [-118.22459, 34.10212], [-118.2248, 34.10235], [-118.22469, 34.10246], [-118.22448, 34.10224], [-118.22413, 34.10259], [-118.22434, 34.10283], [-118.22327, 34.10394], [-118.22546, 34.10544], [-118.22513, 34.10557], [-118.2228, 34.10398], [-118.22289, 34.10389], [-118.22289, 34.10387], [-118.22041, 34.10391], [-118.22088, 34.1022], [-118.22161, 34.10217], [-118.22172, 34.10212], [-118.2218, 34.10204], [-118.22179, 34.10197], [-118.22173, 34.10193], [-118.22175, 34.10164], [-118.22164, 34.10136], [-118.22188, 34.10015], [-118.2227, 34.10039], [-118.22368, 34.10062], [-118.22387, 34.10034], [-118.22416, 34.10046], [-118.2244, 34.1001], [-118.22503, 34.10036], [-118.22514, 34.10036], [-118.22626, 34.10083]]], [[[-118.2272, 34.10176], [-118.22703, 34.10209], [-118.22661, 34.10185], [-118.22601, 34.10163], [-118.22614, 34.10138], [-118.2272, 34.10176]]], [[[-118.22675, 34.10103], [-118.22654, 34.10144], [-118.22607, 34.10127], [-118.22603, 34.10123], [-118.22605, 34.10118], [-118.22635, 34.10087], [-118.22675, 34.10103]]]]} Open Access 1 226 Elyria Canyon Park 18607 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 35.944 Elyria Canyon Park 0 Local Park 2 4
15258 15258 15257 {"type": "Polygon", "coordinates": [[[-118.22167, 34.10123], [-118.22164, 34.10136], [-118.22162, 34.10133], [-118.2215, 34.10138], [-118.22152, 34.10147], [-118.22133, 34.10152], [-118.22133, 34.10135], [-118.22132, 34.10134], [-118.22045, 34.1016], [-118.22027, 34.1012], [-118.22067, 34.10102], [-118.2211, 34.10072], [-118.22167, 34.10123]]]} Open Access 1 46322 Elyria Canyon Park 18607 215 Santa Monica Mountains Conservancy 49 State 5 State Agency 5 http://www.smmc.ca.gov Other State 5 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 1.644 Elyria Canyon Park 0 Local Park 2 4

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]);