units_with_maps

Table actions

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

1 row where ACRES = "351.834", DES_TP = 3 and MNG_AGENCY = 496

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Conejo Open Space Conservation 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
16137 16137 16136 {"type": "Polygon", "coordinates": [[[-118.89026, 34.1622], [-118.89023, 34.17519], [-118.88975, 34.17513], [-118.88929, 34.17506], [-118.88884, 34.17506], [-118.88808, 34.17521], [-118.88774, 34.17537], [-118.88749, 34.17544], [-118.88729, 34.17552], [-118.88693, 34.17545], [-118.88663, 34.17535], [-118.88619, 34.1751], [-118.88589, 34.17496], [-118.88565, 34.17503], [-118.88528, 34.17508], [-118.88495, 34.17518], [-118.8845, 34.17538], [-118.8842, 34.17541], [-118.88398, 34.17541], [-118.88357, 34.17528], [-118.8833, 34.17515], [-118.88275, 34.17483], [-118.88249, 34.17463], [-118.88217, 34.17432], [-118.88196, 34.17405], [-118.88176, 34.17369], [-118.88105, 34.17225], [-118.88091, 34.17191], [-118.88095, 34.17186], [-118.88137, 34.17173], [-118.88127, 34.17151], [-118.88118, 34.17109], [-118.88121, 34.17023], [-118.88138, 34.17003], [-118.88153, 34.16997], [-118.8816, 34.16973], [-118.88184, 34.16945], [-118.88195, 34.16896], [-118.88162, 34.16837], [-118.8802, 34.16689], [-118.88019, 34.16514], [-118.8799, 34.16491], [-118.87845, 34.16389], [-118.87554, 34.16431], [-118.87532, 34.16384], [-118.87502, 34.16394], [-118.87523, 34.1644], [-118.87278, 34.16343], [-118.86846, 34.16337], [-118.86847, 34.16213], [-118.89026, 34.1622]], [[-118.88101, 34.16585], [-118.881, 34.16586], [-118.88115, 34.16651], [-118.8825, 34.16631], [-118.88236, 34.16564], [-118.88101, 34.16585]]]} Open Access 1 17471 Los Robles Open Space 2562 2024 Conejo Open Space Conservation Agency 504 Special District 4 Open Space District 6 http://www.conejo-openspace.org/ Special District 4 2024 Conejo Open Space Conservation Agency 496 Special District 4 Open Space District 6 http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Los Robles Ventura 8 351.834 Los Robles 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]);