units_with_maps

Table actions

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

4 rows where COUNTY = 35, DES_TP = 14 and MNG_AGENCY = 597

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Lincoln, City of · 4 ✖

DES_TP 1

  • Local Other or Unknown · 4 ✖

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
4778 4778 4777 {"type": "MultiPolygon", "coordinates": [[[[-121.30582, 38.89588], [-121.30559, 38.8959], [-121.30475, 38.8959], [-121.30429, 38.89528], [-121.30359, 38.89544], [-121.30309, 38.89545], [-121.30309, 38.89517], [-121.30353, 38.89517], [-121.30418, 38.89501], [-121.30449, 38.89501], [-121.30498, 38.89563], [-121.30582, 38.89562], [-121.30582, 38.89588]]], [[[-121.30763, 38.89595], [-121.30639, 38.89595], [-121.30639, 38.89569], [-121.30727, 38.89569], [-121.30763, 38.89564], [-121.30763, 38.89595]]]]} Open Access 1 47087 Unnamed site - Lincoln, City of 30741 1175 Lincoln, City of 608 City 2 City Agency 2 http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 City 2 1175 Lincoln, City of 597 City 2 City Agency 2   Placer 35 2.938   0 Local Other or Unknown 14 4
13818 13818 13817 {"type": "Polygon", "coordinates": [[[-121.32619, 38.89999], [-121.3253, 38.90062], [-121.32526, 38.9011], [-121.32521, 38.90115], [-121.32521, 38.90105], [-121.32524, 38.90093], [-121.32522, 38.90087], [-121.32519, 38.90083], [-121.32512, 38.90079], [-121.32499, 38.90077], [-121.32477, 38.90069], [-121.32468, 38.90063], [-121.32462, 38.90061], [-121.32451, 38.90061], [-121.3244, 38.90067], [-121.32437, 38.90072], [-121.32435, 38.90081], [-121.32425, 38.90099], [-121.32379, 38.90082], [-121.32387, 38.90041], [-121.3239, 38.9], [-121.32505, 38.89967], [-121.3254, 38.89949], [-121.32561, 38.89955], [-121.32619, 38.89999]]]} Open Access 1 36401 Lincoln holding 2 21252 1175 Lincoln, City of 608 City 2 City Agency 2 http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 City 2 1175 Lincoln, City of 597 City 2 City Agency 2   Placer 35 4.755 Lincoln holding 2 0 Local Other or Unknown 14 4
13875 13875 13874 {"type": "Polygon", "coordinates": [[[-121.29014, 38.89172], [-121.28968, 38.89172], [-121.28967, 38.89118], [-121.29013, 38.89117], [-121.29014, 38.89172]]]} Open Access 1 36466 Lincoln holding 7 21257 1175 Lincoln, City of 608 City 2 City Agency 2 http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 City 2 1175 Lincoln, City of 597 City 2 City Agency 2   Placer 35 0.604 Lincoln holding 7 0 Local Other or Unknown 14 4
13884 13884 13883 {"type": "Polygon", "coordinates": [[[-121.2909, 38.89235], [-121.29044, 38.89235], [-121.29044, 38.89222], [-121.29075, 38.89221], [-121.29075, 38.89194], [-121.29089, 38.89194], [-121.2909, 38.89235]]]} Open Access 1 36474 Lincoln holding 5 21255 1175 Lincoln, City of 608 City 2 City Agency 2 http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 City 2 1175 Lincoln, City of 597 City 2 City Agency 2   Placer 35 0.245 Lincoln holding 5 0 Local Other or Unknown 14 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]);