units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, DES_TP = 867 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 1 ✖

DES_TP 1

ACCESS_TYP 1

  • Restricted 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
10050 10050 10049 {"type": "MultiPolygon", "coordinates": [[[[-121.5504, 37.81996], [-121.55037, 37.82003], [-121.55026, 37.82006], [-121.55015, 37.82005], [-121.55003, 37.82001], [-121.5497, 37.81985], [-121.54955, 37.8198], [-121.54921, 37.81974], [-121.54909, 37.81969], [-121.54905, 37.81963], [-121.54906, 37.81953], [-121.54904, 37.81943], [-121.54883, 37.81913], [-121.5488, 37.81906], [-121.54885, 37.81898], [-121.54892, 37.81894], [-121.54902, 37.81894], [-121.54918, 37.81899], [-121.54959, 37.81916], [-121.54998, 37.81948], [-121.55031, 37.81964], [-121.55038, 37.8197], [-121.55038, 37.81981], [-121.5504, 37.81996]]], [[[-121.55519, 37.81644], [-121.5552, 37.81652], [-121.55515, 37.81671], [-121.55508, 37.81681], [-121.55496, 37.8169], [-121.5547, 37.81714], [-121.55391, 37.81771], [-121.55365, 37.81793], [-121.55346, 37.81816], [-121.55327, 37.81857], [-121.55309, 37.81929], [-121.55301, 37.81955], [-121.55289, 37.81981], [-121.55287, 37.81989], [-121.55264, 37.82016], [-121.55244, 37.82024], [-121.5522, 37.82026], [-121.5519, 37.82024], [-121.55144, 37.82011], [-121.55116, 37.81998], [-121.55094, 37.81982], [-121.55077, 37.81964], [-121.55053, 37.81949], [-121.54958, 37.81885], [-121.54934, 37.81872], [-121.55268, 37.8155], [-121.55287, 37.81562], [-121.55298, 37.81575], [-121.55328, 37.81602], [-121.55345, 37.81609], [-121.5538, 37.81617], [-121.55403, 37.8162], [-121.55452, 37.81624], [-121.55477, 37.81622], [-121.55505, 37.8163], [-121.55519, 37.81644]]]]} Restricted Access 2 17388 Clifton Court Forebay 29182 207 California Department of Water Resources 477 State 5 State Agency 5 http://www.water.ca.gov/ Other State 5 207 California Department of Water Resources 470 State 5 State Agency 5   San Joaquin 39 34.457 Clifton Court Forebay   None 867  

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