units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, COUNTY = 27 and DES_TP = 742

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 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
8849 8849 8848 {"type": "MultiPolygon", "coordinates": [[[[-122.36715, 40.58632], [-122.367, 40.58675], [-122.36655, 40.58706], [-122.36559, 40.58763], [-122.36512, 40.58778], [-122.36471, 40.58802], [-122.36363, 40.5889], [-122.36323, 40.58934], [-122.3622, 40.58935], [-122.36219, 40.58931], [-122.36214, 40.58929], [-122.36099, 40.58931], [-122.36127, 40.58849], [-122.36163, 40.58793], [-122.36227, 40.5875], [-122.36295, 40.5872], [-122.36329, 40.58681], [-122.36377, 40.58642], [-122.36435, 40.58629], [-122.36512, 40.58625], [-122.36517, 40.58621], [-122.36525, 40.5862], [-122.36715, 40.58632]]], [[[-122.3784, 40.58752], [-122.37836, 40.5879], [-122.37811, 40.58817], [-122.37642, 40.58984], [-122.37589, 40.58941], [-122.3756, 40.58986], [-122.37555, 40.59047], [-122.37576, 40.59099], [-122.37612, 40.59155], [-122.37386, 40.59156], [-122.37183, 40.59166], [-122.37085, 40.59163], [-122.36993, 40.59131], [-122.37021, 40.59114], [-122.37022, 40.59112], [-122.37022, 40.59111], [-122.36908, 40.5909], [-122.36762, 40.59082], [-122.36662, 40.59067], [-122.36573, 40.59012], [-122.36492, 40.58942], [-122.36553, 40.58909], [-122.36611, 40.58956], [-122.36727, 40.58982], [-122.36834, 40.58944], [-122.36907, 40.58882], [-122.36964, 40.5882], [-122.37003, 40.58784], [-122.36955, 40.58736], [-122.3694, 40.58638], [-122.37158, 40.58654], [-122.372, 40.58654], [-122.37662, 40.58685], [-122.37752, 40.58707], [-122.37802, 40.58725], [-122.37818, 40.58735], [-122.37824, 40.58742], [-122.37828, 40.58751], [-122.3784, 40.58752]]]]} Open Access 1 14464 Turtle Bay 32808 1268 Redding, City of 403 City 2 City Agency 2 http://reddingrecreation.org/ City 2 1268 Redding, City of 397 City 2 City Agency 2   Shasta 27 118.162 Turtle Bay   None 742  

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