units_with_maps

Table actions

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

1 row where DES_TP = 2, MNG_AG_TYP = 4 and SUID_NMA = 16091

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 1 ✖

DES_TP 1

  • Local Park · 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
4147 4147 4146 {"type": "Polygon", "coordinates": [[[-118.75503, 34.31017], [-118.755, 34.31038], [-118.75436, 34.31114], [-118.75424, 34.31146], [-118.7541, 34.31133], [-118.75389, 34.31143], [-118.75346, 34.31152], [-118.75343, 34.31145], [-118.7532, 34.3115], [-118.75314, 34.31153], [-118.75307, 34.31161], [-118.75304, 34.31171], [-118.75275, 34.31095], [-118.7526, 34.31063], [-118.75242, 34.31053], [-118.75243, 34.31051], [-118.7525, 34.31055], [-118.75258, 34.31057], [-118.75267, 34.31051], [-118.75252, 34.31024], [-118.75237, 34.31004], [-118.7523, 34.30995], [-118.7521, 34.30985], [-118.75209, 34.30982], [-118.75211, 34.3098], [-118.75239, 34.30974], [-118.7527, 34.30974], [-118.75311, 34.30964], [-118.75382, 34.30937], [-118.75389, 34.30939], [-118.75408, 34.30957], [-118.75412, 34.30962], [-118.7541, 34.30967], [-118.75421, 34.30966], [-118.75424, 34.30963], [-118.75423, 34.30959], [-118.75413, 34.30946], [-118.75402, 34.30927], [-118.75395, 34.30916], [-118.75407, 34.30911], [-118.75417, 34.30925], [-118.75427, 34.30949], [-118.75439, 34.30964], [-118.75442, 34.30966], [-118.75449, 34.30963], [-118.75474, 34.30983], [-118.75503, 34.31017]]]} Open Access 1 44678 Big Sky Park 16091 2118 Rancho Simi Recreation and Park District 80 Special District 4 Recreation/Parks District 4 http://www.rsrpd.org/ Special District 4 2118 Rancho Simi Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Ventura 8 10.075 Big Sky Park 0 Local Park 2 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]);