units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, DES_TP = 14 and MNG_AGENCY = 12

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Conejo Recreation and Park District · 1 ✖

DES_TP 1

  • Local Other or Unknown · 1 ✖

ACCESS_TYP 1

  • Restricted 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
10163 10163 10162 {"type": "MultiPolygon", "coordinates": [[[[-118.85683, 34.23954], [-118.8568, 34.23959], [-118.8567, 34.23938], [-118.8567, 34.23937], [-118.85683, 34.23954]]], [[[-118.85689, 34.23975], [-118.85688, 34.23975], [-118.85685, 34.23971], [-118.85689, 34.23975], [-118.85689, 34.23975]]], [[[-118.85275, 34.24064], [-118.85264, 34.24059], [-118.85237, 34.24061], [-118.85243, 34.24058], [-118.85242, 34.2406], [-118.85264, 34.24058], [-118.85275, 34.24064]]], [[[-118.85339, 34.24098], [-118.85317, 34.24081], [-118.85289, 34.2407], [-118.85298, 34.24071], [-118.85321, 34.24082], [-118.85339, 34.24098]]], [[[-118.8536, 34.2412], [-118.85343, 34.24101], [-118.85343, 34.24101], [-118.85345, 34.24102], [-118.8536, 34.2412]]], [[[-118.84856, 34.24296], [-118.84855, 34.24427], [-118.84855, 34.24422], [-118.84856, 34.24296]]], [[[-118.86424, 34.24569], [-118.86392, 34.24579], [-118.86363, 34.24573], [-118.86183, 34.24504], [-118.85908, 34.24514], [-118.85907, 34.24557], [-118.85582, 34.24601], [-118.85521, 34.24539], [-118.85472, 34.24505], [-118.85435, 34.2448], [-118.85356, 34.24447], [-118.85308, 34.24441], [-118.85229, 34.24447], [-118.85197, 34.24434], [-118.85209, 34.24376], [-118.85209, 34.2433], [-118.85238, 34.24315], [-118.85305, 34.24322], [-118.85335, 34.24361], [-118.85382, 34.24395], [-118.85445, 34.24414], [-118.85491, 34.24409], [-118.85552, 34.24377], [-118.85678, 34.24345], [-118.85787, 34.24342], [-118.85893, 34.24344], [-118.86001, 34.24322], [-118.86029, 34.24304], [-118.86109, 34.2424], [-118.86142, 34.24204], [-118.86166, 34.24164], [-118.86184, 34.24115], [-118.86212, 34.24004], [-118.86244, 34.23969], [-118.86267, 34.23997], [-118.86275, 34.24039], [-118.86274, 34.24099], [-118.86322, 34.24375], [-118.86361, 34.24494], [-118.86381, 34.24529], [-118.86424, 34.24569]]], [[[-118.85901, 34.24664], [-118.8583, 34.24676], [-118.8579, 34.24681], [-118.85901, 34.24664]]], [[[-118.85211, 34.24762], [-118.8504, 34.24762], [-118.85039, 34.24535], [-118.84855, 34.24563], [-118.85039, 34.24535], [-118.85042, 34.2476], [-118.85211, 34.24762]]]]} Restricted Access 2 17736 McCrea Ranch 22015 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 63.673 McCrea Ranch 0 Local Other or Unknown 14 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]);