units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, LABEL_NAME = "Haskell Canyon OS" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 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
16234 16234 16233 {"type": "Polygon", "coordinates": [[[-118.51584, 34.47057], [-118.51585, 34.47425], [-118.51582, 34.47789], [-118.51139, 34.47789], [-118.51138, 34.48164], [-118.50248, 34.48162], [-118.50251, 34.4779], [-118.49829, 34.47782], [-118.49832, 34.47411], [-118.4941, 34.47405], [-118.49413, 34.47035], [-118.4875, 34.47028], [-118.48753, 34.46757], [-118.48974, 34.46758], [-118.48975, 34.46662], [-118.49726, 34.46667], [-118.49772, 34.46108], [-118.49823, 34.4609], [-118.49852, 34.46081], [-118.49884, 34.46073], [-118.4992, 34.46067], [-118.49962, 34.46063], [-118.50004, 34.46062], [-118.50062, 34.46065], [-118.5012, 34.46075], [-118.50168, 34.46087], [-118.50214, 34.46104], [-118.50258, 34.46124], [-118.50263, 34.46671], [-118.51144, 34.46693], [-118.51142, 34.47053], [-118.51343, 34.47056], [-118.51341, 34.47099], [-118.51335, 34.47105], [-118.51331, 34.47106], [-118.51326, 34.47111], [-118.51308, 34.47121], [-118.51299, 34.47122], [-118.51293, 34.47117], [-118.5129, 34.47117], [-118.51281, 34.47123], [-118.51266, 34.47126], [-118.51264, 34.47131], [-118.5126, 34.47133], [-118.51251, 34.47132], [-118.51243, 34.47135], [-118.51225, 34.47148], [-118.5121, 34.47154], [-118.5121, 34.47165], [-118.51194, 34.47177], [-118.51186, 34.4718], [-118.51171, 34.47178], [-118.51169, 34.47183], [-118.51179, 34.47199], [-118.51183, 34.47224], [-118.51183, 34.4723], [-118.51175, 34.47245], [-118.51177, 34.47254], [-118.51182, 34.47258], [-118.51163, 34.47342], [-118.51246, 34.47335], [-118.51285, 34.47328], [-118.51358, 34.47251], [-118.51383, 34.47216], [-118.51392, 34.47207], [-118.514, 34.47194], [-118.51412, 34.47189], [-118.51414, 34.47173], [-118.51424, 34.47166], [-118.51436, 34.47167], [-118.51438, 34.47166], [-118.5144, 34.47162], [-118.51461, 34.47206], [-118.51484, 34.47206], [-118.51513, 34.4716], [-118.51512, 34.4717], [-118.51516, 34.47172], [-118.51525, 34.47167], [-118.51531, 34.47159], [-118.51543, 34.47155], [-118.51554, 34.47136], [-118.51565, 34.47122], [-118.5158, 34.47107], [-118.51578, 34.47083], [-118.51557, 34.47057], [-118.51584, 34.47057]]]} Open Access 1 45603 Haskell Canyon Open Space 28429 1319 Santa Clarita, City of 325 City 2 City Agency 2 http://www.santa-clarita.com/index.aspx?page=186 City 2 1319 Santa Clarita, City of 322 City 2 City Agency 2   Los Angeles 6 726.54 Haskell Canyon OS 0 Local Recreation Area 3 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]);