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_AGENCY = 583 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • Port Hueneme, City of · 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
16832 16832 16831 {"type": "MultiPolygon", "coordinates": [[[[-119.19078, 34.14223], [-119.19054, 34.14233], [-119.19052, 34.14221], [-119.19013, 34.14195], [-119.18818, 34.1408], [-119.18823, 34.14074], [-119.19078, 34.14223]]], [[[-119.19114, 34.14742], [-119.19055, 34.1474], [-119.19052, 34.14738], [-119.19042, 34.14709], [-119.19037, 34.14681], [-119.19039, 34.14498], [-119.19105, 34.14499], [-119.19091, 34.14537], [-119.19086, 34.14561], [-119.19077, 34.14582], [-119.19072, 34.14603], [-119.19062, 34.14621], [-119.19075, 34.14631], [-119.19072, 34.14676], [-119.19079, 34.1471], [-119.19086, 34.14726], [-119.1911, 34.14727], [-119.19114, 34.14742]]], [[[-119.19156, 34.14326], [-119.1915, 34.14399], [-119.19141, 34.14442], [-119.19124, 34.14492], [-119.19083, 34.14492], [-119.19088, 34.1449], [-119.19105, 34.14436], [-119.19114, 34.14397], [-119.1912, 34.14325], [-119.1912, 34.14286], [-119.1911, 34.14272], [-119.19063, 34.14282], [-119.19047, 34.14276], [-119.19055, 34.14265], [-119.19065, 34.14255], [-119.19081, 34.14247], [-119.19095, 34.14243], [-119.19111, 34.14241], [-119.19126, 34.14243], [-119.19153, 34.14253], [-119.19153, 34.14324], [-119.19156, 34.14326]]], [[[-119.193, 34.15068], [-119.19266, 34.15067], [-119.19241, 34.14991], [-119.1917, 34.14914], [-119.19093, 34.14813], [-119.19068, 34.14772], [-119.19072, 34.14768], [-119.19085, 34.14769], [-119.19099, 34.14796], [-119.19158, 34.14883], [-119.19169, 34.1489], [-119.19182, 34.14912], [-119.19189, 34.14912], [-119.19222, 34.14952], [-119.19238, 34.14967], [-119.19264, 34.15048], [-119.19292, 34.15042], [-119.193, 34.15068]]], [[[-119.19455, 34.15469], [-119.19447, 34.15469], [-119.19448, 34.15466], [-119.19417, 34.1539], [-119.19391, 34.15397], [-119.19298, 34.15167], [-119.1932, 34.15167], [-119.19363, 34.15272], [-119.19366, 34.15272], [-119.19382, 34.15311], [-119.19382, 34.15324], [-119.19397, 34.15325], [-119.19455, 34.15469]]], [[[-119.19426, 34.15496], [-119.19386, 34.15608], [-119.19383, 34.15607], [-119.19422, 34.15496], [-119.19426, 34.15496]]]]} Open Access 1 48306 Bubbling Springs Recreation Corridor 32875 1259 Port Hueneme, City of 593 City 2 City Agency 2 http://www.ci.port-hueneme.ca.us/ City 2 1259 Port Hueneme, City of 583 City 2 City Agency 2   Ventura 8 8.856 Bubbling Springs Rec. Corridor 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]);