units_with_maps

Table actions

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

1 row where DES_TP = 4, GAP_STS = 2 and MNG_AGENCY = 557

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Folsom, 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
13642 13642 13641 {"type": "MultiPolygon", "coordinates": [[[[-121.18821, 38.69751], [-121.18796, 38.69788], [-121.18743, 38.69852], [-121.1872, 38.69842], [-121.1847, 38.69719], [-121.18512, 38.6954], [-121.18515, 38.69494], [-121.18498, 38.69438], [-121.18495, 38.69431], [-121.18437, 38.69352], [-121.18388, 38.69307], [-121.18309, 38.69262], [-121.18226, 38.69195], [-121.18229, 38.68996], [-121.18261, 38.69034], [-121.18366, 38.69038], [-121.18369, 38.69063], [-121.18319, 38.69105], [-121.18342, 38.69163], [-121.18432, 38.69187], [-121.18482, 38.69223], [-121.18559, 38.69269], [-121.18591, 38.69281], [-121.1861, 38.69247], [-121.18614, 38.69249], [-121.18576, 38.69327], [-121.1861, 38.6939], [-121.18658, 38.69391], [-121.18664, 38.69393], [-121.18689, 38.6948], [-121.18688, 38.69523], [-121.18671, 38.69569], [-121.18638, 38.69603], [-121.18627, 38.69643], [-121.18661, 38.69693], [-121.18675, 38.69697], [-121.18726, 38.69684], [-121.18821, 38.69751]]], [[[-121.18563, 38.68925], [-121.18556, 38.68927], [-121.18542, 38.68899], [-121.1852, 38.68874], [-121.18494, 38.68852], [-121.18397, 38.68802], [-121.18341, 38.68827], [-121.18328, 38.68906], [-121.18311, 38.68914], [-121.18287, 38.68914], [-121.18283, 38.68954], [-121.18291, 38.68968], [-121.18285, 38.6897], [-121.18276, 38.68956], [-121.18232, 38.68937], [-121.18246, 38.68625], [-121.18269, 38.68643], [-121.18341, 38.68683], [-121.18381, 38.68688], [-121.18423, 38.68659], [-121.18464, 38.68638], [-121.18515, 38.68636], [-121.18468, 38.68665], [-121.18442, 38.68706], [-121.18448, 38.68747], [-121.18487, 38.6883], [-121.18546, 38.68893], [-121.18563, 38.68925]]]]} Open Access 1 36009 Hinkle Creek Nature Area 20002 1108 Folsom, City of 565 City 2 City Agency 2 http://www.folsom.ca.us/depts/parks_n_recreation/default.asp City 2 1108 Folsom, City of 557 City 2 City Agency 2   Sacramento 41 45.196 Hinkle Creek Nature Area 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]);