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 = 3 and SUID_NMA = 31221

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, DES_TP

MNG_AG_TYP 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
14541 14541 14540 {"type": "Polygon", "coordinates": [[[-118.88948, 34.21947], [-118.88913, 34.2195], [-118.88904, 34.21966], [-118.88901, 34.21992], [-118.8889, 34.22008], [-118.88883, 34.22009], [-118.88878, 34.22013], [-118.88863, 34.22005], [-118.88767, 34.22129], [-118.8865, 34.22191], [-118.88675, 34.22239], [-118.8867, 34.22249], [-118.88637, 34.22262], [-118.8861, 34.22254], [-118.88574, 34.22278], [-118.88574, 34.22269], [-118.88551, 34.22264], [-118.88491, 34.2229], [-118.88469, 34.2229], [-118.88448, 34.22294], [-118.88318, 34.22294], [-118.88318, 34.22036], [-118.88316, 34.22035], [-118.88375, 34.21992], [-118.88371, 34.21986], [-118.88376, 34.21982], [-118.88384, 34.21986], [-118.88448, 34.21939], [-118.88443, 34.21931], [-118.88448, 34.21927], [-118.88458, 34.21932], [-118.8849, 34.21908], [-118.88512, 34.21889], [-118.88513, 34.21884], [-118.8852, 34.21883], [-118.88523, 34.21888], [-118.88565, 34.21883], [-118.88562, 34.21863], [-118.88552, 34.21843], [-118.88537, 34.21821], [-118.88518, 34.21802], [-118.88492, 34.21788], [-118.88463, 34.21781], [-118.88412, 34.21779], [-118.88412, 34.21756], [-118.88443, 34.21743], [-118.88477, 34.21736], [-118.88503, 34.21733], [-118.88575, 34.21733], [-118.88575, 34.21901], [-118.88716, 34.21844], [-118.88895, 34.21819], [-118.88916, 34.21851], [-118.8893, 34.21881], [-118.8894, 34.21911], [-118.88948, 34.21947]]]} Open Access 1 47506 Summit House Open Space 31221 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/summit-house.html Ventura 8 49.994 Summit House 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]);