units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, DES_TP = 54 and MNG_AGENCY = 27

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Mountains Recreation and Conservation Authority · 1 ✖

DES_TP 1

  • National Recreation Area · 1 ✖

ACCESS_TYP 1

  • Open 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
16976 16976 16975 {"type": "MultiPolygon", "coordinates": [[[[-118.65225, 34.0711], [-118.65226, 34.07125], [-118.65231, 34.0714], [-118.65249, 34.07175], [-118.65253, 34.07189], [-118.65254, 34.07204], [-118.65249, 34.07225], [-118.65236, 34.07244], [-118.65218, 34.07259], [-118.65163, 34.07282], [-118.65151, 34.07289], [-118.65142, 34.07298], [-118.65135, 34.07309], [-118.6513, 34.07327], [-118.65132, 34.07344], [-118.6514, 34.07361], [-118.65181, 34.074], [-118.65194, 34.07421], [-118.65209, 34.07457], [-118.6521, 34.07471], [-118.65207, 34.0748], [-118.65102, 34.0748], [-118.65078, 34.07472], [-118.64998, 34.07457], [-118.64993, 34.0711], [-118.65225, 34.0711]]], [[[-118.65033, 34.0748], [-118.64998, 34.07481], [-118.64998, 34.07474], [-118.64998, 34.07474], [-118.65033, 34.0748]]], [[[-118.65437, 34.07479], [-118.65228, 34.0748], [-118.6523, 34.07469], [-118.65228, 34.07452], [-118.6521, 34.07408], [-118.65195, 34.07388], [-118.65159, 34.07355], [-118.65153, 34.07346], [-118.6515, 34.07336], [-118.6515, 34.07326], [-118.65153, 34.07316], [-118.65158, 34.07307], [-118.65172, 34.07297], [-118.65211, 34.07282], [-118.65235, 34.07269], [-118.65254, 34.07252], [-118.65267, 34.07231], [-118.65273, 34.07208], [-118.65273, 34.07185], [-118.65268, 34.07169], [-118.65249, 34.07135], [-118.65246, 34.07122], [-118.65245, 34.0711], [-118.65434, 34.0711], [-118.65437, 34.07479]]], [[[-118.67145, 34.04751], [-118.66507, 34.04751], [-118.66312, 34.0475], [-118.66404, 34.0463], [-118.67144, 34.04627], [-118.67145, 34.04751]]], [[[-118.69063, 34.07447], [-118.68991, 34.07513], [-118.68976, 34.07506], [-118.6896, 34.07504], [-118.68949, 34.07507], [-118.68927, 34.07517], [-118.6892, 34.07518], [-118.6891, 34.07517], [-118.68854, 34.0749], [-118.68838, 34.07485], [-118.6882, 34.07486], [-118.68809, 34.07491], [-118.68789, 34.07503], [-118.68781, 34.07505], [-118.68774, 34.07504], [-118.68685, 34.07452], [-118.68675, 34.07449], [-118.68659, 34.07447], [-118.69063, 34.07447]]], [[[-118.68956, 34.07552], [-118.68909, 34.07535], [-118.68909, 34.07535], [-118.6892, 34.07536], [-118.68931, 34.07534], [-118.6896, 34.07522], [-118.6897, 34.07523], [-118.68978, 34.07527], [-118.68982, 34.07532], [-118.68983, 34.07537], [-118.68982, 34.07542], [-118.6898, 34.07547], [-118.68969, 34.07553], [-118.68956, 34.07552]]], [[[-118.8886, 34.10378], [-118.8874, 34.10378], [-118.8874, 34.10196], [-118.88855, 34.10196], [-118.8886, 34.10217], [-118.88879, 34.10254], [-118.88884, 34.10276], [-118.88881, 34.10297], [-118.8886, 34.10342], [-118.88857, 34.10352], [-118.88856, 34.10363], [-118.8886, 34.10378]]], [[[-118.8896, 34.10379], [-118.88883, 34.10379], [-118.88878, 34.10371], [-118.88876, 34.10362], [-118.88877, 34.10352], [-118.88899, 34.10302], [-118.88903, 34.10279], [-118.889, 34.10255], [-118.88894, 34.10241], [-118.88878, 34.10212], [-118.88874, 34.10196], [-118.88959, 34.10196], [-118.8896, 34.10379]]]]} Open Access 1 12629 Santa Monica Mountains National Recreation Area 25123 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 http://www.nps.gov/samo/index.htm Los Angeles 6 76.823 Santa Monica Mtns. NRA 0 National Recreation Area 54 3

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