units_with_maps

Table actions

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

1 row where AGNCY_TYP = 2, DES_TP = 4 and MNG_AGENCY = 601

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • La Quinta, City of · 1 ✖

DES_TP 1

  • Local Conservation 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
14069 14069 14068 {"type": "Polygon", "coordinates": [[[-116.31953, 33.65617], [-116.32016, 33.6585], [-116.3202, 33.6588], [-116.32022, 33.6591], [-116.32022, 33.65941], [-116.32019, 33.65971], [-116.32012, 33.66008], [-116.32001, 33.66045], [-116.31986, 33.66081], [-116.31967, 33.66116], [-116.31951, 33.6614], [-116.31829, 33.66299], [-116.31802, 33.66342], [-116.31803, 33.66343], [-116.31811, 33.66343], [-116.31796, 33.66386], [-116.31783, 33.66438], [-116.31776, 33.66491], [-116.31774, 33.66544], [-116.31777, 33.66597], [-116.31786, 33.6665], [-116.31807, 33.66701], [-116.31724, 33.66614], [-116.31706, 33.6659], [-116.31692, 33.66566], [-116.31681, 33.6654], [-116.31671, 33.66501], [-116.31668, 33.66465], [-116.3167, 33.66433], [-116.31675, 33.66411], [-116.31682, 33.66389], [-116.31691, 33.66367], [-116.31704, 33.66343], [-116.31735, 33.66303], [-116.31797, 33.66244], [-116.31817, 33.66222], [-116.31838, 33.6619], [-116.31856, 33.6615], [-116.31863, 33.66127], [-116.31942, 33.65795], [-116.31946, 33.65772], [-116.31948, 33.65736], [-116.31944, 33.65703], [-116.31938, 33.65676], [-116.31918, 33.65617], [-116.31953, 33.65617]]]} Open Access 1 39078 Fred Wolff Nature Preserve 19077 1161 La Quinta, City of 612 City 2 City Agency 2 http://www.la-quinta.org/your-government/community-services/city-parks City 2 1161 La Quinta, City of 601 City 2 City Agency 2   Riverside 10 22.526 Fred Wolff Nature Preserve 0 Local Conservation Area 4 2

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]);