units_with_maps

Table actions

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

1 row where DES_TP = 3, MNG_AG_TYP = 2 and UNIT_NAME = "Valley Vista Open Space"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 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
4948 4948 4947 {"type": "MultiPolygon", "coordinates": [[[[-118.5101, 34.34486], [-118.50618, 34.34465], [-118.50656, 34.34395], [-118.50649, 34.3432], [-118.50688, 34.3418], [-118.50724, 34.34095], [-118.50722, 34.34007], [-118.50774, 34.33964], [-118.5078, 34.33937], [-118.50772, 34.33916], [-118.50812, 34.33937], [-118.50833, 34.33951], [-118.50851, 34.33967], [-118.50875, 34.33994], [-118.50888, 34.34014], [-118.50898, 34.34035], [-118.50899, 34.34038], [-118.50895, 34.34057], [-118.50897, 34.3407], [-118.50902, 34.34082], [-118.50913, 34.34096], [-118.5091, 34.34099], [-118.50918, 34.3411], [-118.50928, 34.34149], [-118.50927, 34.34161], [-118.50929, 34.34169], [-118.50935, 34.34176], [-118.51006, 34.34462], [-118.5101, 34.34486]]], [[[-118.51238, 34.34498], [-118.51044, 34.34488], [-118.51038, 34.34456], [-118.50938, 34.34054], [-118.50925, 34.34017], [-118.50925, 34.33995], [-118.50921, 34.3398], [-118.50914, 34.33965], [-118.50904, 34.33953], [-118.50884, 34.33937], [-118.50869, 34.33929], [-118.50843, 34.33921], [-118.50816, 34.33905], [-118.50779, 34.33888], [-118.50789, 34.33866], [-118.50839, 34.33881], [-118.50908, 34.3384], [-118.51238, 34.34498]]], [[[-118.52867, 34.34888], [-118.51973, 34.34889], [-118.51974, 34.34714], [-118.5151, 34.34688], [-118.51522, 34.34514], [-118.51311, 34.34502], [-118.50912, 34.33703], [-118.50917, 34.33682], [-118.50936, 34.33678], [-118.5093, 34.33699], [-118.50931, 34.33708], [-118.50942, 34.33727], [-118.50944, 34.33725], [-118.50934, 34.33708], [-118.50934, 34.33702], [-118.50973, 34.3369], [-118.50995, 34.33696], [-118.50993, 34.33727], [-118.51012, 34.3374], [-118.5107, 34.33739], [-118.51095, 34.33715], [-118.51119, 34.33713], [-118.51129, 34.33719], [-118.51115, 34.33737], [-118.51111, 34.33738], [-118.51109, 34.33741], [-118.51094, 34.33745], [-118.51094, 34.33751], [-118.51119, 34.33746], [-118.51122, 34.33738], [-118.51134, 34.33722], [-118.51154, 34.33733], [-118.51156, 34.33741], [-118.5116, 34.33745], [-118.51168, 34.33746], [-118.51175, 34.33742], [-118.51338, 34.33813], [-118.5184, 34.34041], [-118.51929, 34.34083], [-118.51949, 34.34099], [-118.51978, 34.34119], [-118.51976, 34.34538], [-118.52865, 34.34534], [-118.52867, 34.34888]]], [[[-118.50972, 34.33687], [-118.50934, 34.33698], [-118.50934, 34.33698], [-118.5094, 34.33678], [-118.50961, 34.33677], [-118.50972, 34.33687]]], [[[-118.50995, 34.33688], [-118.50995, 34.33694], [-118.50976, 34.33688], [-118.50978, 34.33688], [-118.50995, 34.33688]]], [[[-118.51169, 34.3374], [-118.51164, 34.3374], [-118.51162, 34.33736], [-118.51165, 34.33738], [-118.51169, 34.3374]]]]} Open Access 1 47481 Valley Vista Open Space 31203 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 284.605 Valley Vista 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]);