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 = 1225 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

DES_TP 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
14416 14416 14415 {"type": "Polygon", "coordinates": [[[-124.08511, 40.88587], [-124.08396, 40.88873], [-124.08299, 40.8885], [-124.08291, 40.88869], [-124.08254, 40.8887], [-124.08248, 40.88872], [-124.08231, 40.88899], [-124.08225, 40.889], [-124.08209, 40.88899], [-124.0825, 40.88849], [-124.08255, 40.88846], [-124.08271, 40.88841], [-124.08299, 40.8884], [-124.08333, 40.88846], [-124.08346, 40.88813], [-124.08351, 40.88808], [-124.0837, 40.88795], [-124.08381, 40.8877], [-124.08407, 40.88743], [-124.08412, 40.88735], [-124.08413, 40.88722], [-124.08402, 40.88687], [-124.08407, 40.88654], [-124.08409, 40.88648], [-124.08416, 40.8864], [-124.08428, 40.88634], [-124.08431, 40.88628], [-124.08427, 40.88623], [-124.08392, 40.88608], [-124.08335, 40.88579], [-124.08313, 40.88574], [-124.08272, 40.88605], [-124.0824, 40.88632], [-124.08238, 40.88637], [-124.08241, 40.8865], [-124.0824, 40.8867], [-124.08231, 40.88697], [-124.08161, 40.88806], [-124.08155, 40.88806], [-124.0815, 40.88804], [-124.08147, 40.888], [-124.08147, 40.88788], [-124.08148, 40.88782], [-124.08156, 40.88762], [-124.08194, 40.88677], [-124.08197, 40.88667], [-124.08197, 40.88643], [-124.08192, 40.8863], [-124.08184, 40.88613], [-124.08275, 40.88537], [-124.08511, 40.88587]]]} Open Access 1 47031 Janes Creek Meadows Openspace 30682 1432 Arcata, City of 587 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1432 Arcata, City of 577 City 2 City Agency 2   Humboldt 45 8.926 Janes Creek Meadows Openspace   None 1225  

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