units_with_maps

Table actions

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

1 row where AGNCY_LEV = 5, DES_TP = 707 and MNG_AGENCY = 470

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Water Resources · 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
8447 8447 8446 {"type": "MultiPolygon", "coordinates": [[[[-121.62267, 37.80157], [-121.62226, 37.80072], [-121.62267, 37.80062], [-121.62267, 37.80062], [-121.62267, 37.80157]]], [[[-121.55271, 37.82044], [-121.5527, 37.82055], [-121.55258, 37.82072], [-121.55211, 37.82084], [-121.5519, 37.82083], [-121.55134, 37.82068], [-121.55128, 37.82061], [-121.55125, 37.82052], [-121.55127, 37.82045], [-121.55133, 37.82041], [-121.55148, 37.82039], [-121.55211, 37.82049], [-121.55256, 37.82043], [-121.55271, 37.82044]]], [[[-121.61977, 37.80132], [-121.61811, 37.80233], [-121.60775, 37.81064], [-121.60703, 37.81129], [-121.60645, 37.81193], [-121.59685, 37.82357], [-121.59566, 37.82283], [-121.59566, 37.82262], [-121.59995, 37.81661], [-121.60495, 37.81028], [-121.60494, 37.80939], [-121.60484, 37.80938], [-121.60486, 37.80574], [-121.60879, 37.80398], [-121.61977, 37.80132]]], [[[-121.62324, 37.80314], [-121.62261, 37.80386], [-121.62268, 37.80861], [-121.62145, 37.80934], [-121.61396, 37.80941], [-121.60494, 37.81918], [-121.60473, 37.81939], [-121.59966, 37.82384], [-121.59888, 37.82485], [-121.59861, 37.82466], [-121.59756, 37.82401], [-121.6072, 37.81232], [-121.60773, 37.81173], [-121.60839, 37.81115], [-121.62101, 37.80102], [-121.62209, 37.80076], [-121.62267, 37.80196], [-121.62267, 37.80228], [-121.62283, 37.80228], [-121.62324, 37.80314]]], [[[-121.60028, 37.83829], [-121.59481, 37.83821], [-121.59483, 37.83946], [-121.59478, 37.83962], [-121.59461, 37.83973], [-121.59436, 37.83973], [-121.59423, 37.83967], [-121.59408, 37.83952], [-121.59409, 37.83933], [-121.59415, 37.83907], [-121.59372, 37.83863], [-121.59371, 37.83864], [-121.59376, 37.83898], [-121.59362, 37.83937], [-121.59289, 37.8395], [-121.59271, 37.84067], [-121.59224, 37.84168], [-121.5918, 37.84299], [-121.59147, 37.84356], [-121.59136, 37.84414], [-121.59164, 37.84485], [-121.5914, 37.84562], [-121.59176, 37.84608], [-121.592, 37.84684], [-121.59184, 37.84734], [-121.59107, 37.84797], [-121.59055, 37.84814], [-121.59054, 37.84838], [-121.5902, 37.84881], [-121.58979, 37.84904], [-121.58929, 37.84921], [-121.58897, 37.84925], [-121.58851, 37.84919], [-121.58805, 37.84896], [-121.58786, 37.84883], [-121.58727, 37.8488], [-121.58631, 37.84888], [-121.5852, 37.84904], [-121.58491, 37.84914], [-121.5849, 37.84975], [-121.58538, 37.84994], [-121.58533, 37.85066], [-121.58551, 37.8512], [-121.58601, 37.85189], [-121.58598, 37.85264], [-121.58555, 37.85313], [-121.58501, 37.85341], [-121.58502, 37.85346], [-121.5844, 37.85383], [-121.58409, 37.85522], [-121.58396, 37.85539], [-121.58346, 37.85618], [-121.58343, 37.85676], [-121.58347, 37.85742], [-121.58344, 37.85804], [-121.58332, 37.85835], [-121.58306, 37.85853], [-121.58233, 37.85875], [-121.58124, 37.85883], [-121.58047, 37.85883], [-121.58013, 37.85882], [-121.57969, 37.85865], [-121.5764, 37.8585], [-121.5764, 37.85848], [-121.5775, 37.85806], [-121.57724, 37.85739], [-121.57561, 37.85733], [-121.57328, 37.85701], [-121.56941, 37.85671], [-121.56829, 37.85672], [-121.56799, 37.85707], [-121.56788, 37.85681], [-121.56625, 37.85743], [-121.56515, 37.85624], [-121.56291, 37.85322], [-121.56211, 37.85322], [-121.55881, 37.8459], [-121.55961, 37.84589], [-121.553, 37.82898], [-121.55738, 37.82822], [-121.55891, 37.8263], [-121.56794, 37.82621], [-121.56796, 37.82531], [-121.57554, 37.82543], [-121.57738, 37.82369], [-121.58162, 37.82007], [-121.58339, 37.82005], [-121.58611, 37.82058], [-121.58617, 37.82384], [-121.58999, 37.82384], [-121.59262, 37.82531], [-121.59363, 37.82576], [-121.59479, 37.82384], [-121.59565, 37.82384], [-121.59568, 37.82497], [-121.59656, 37.82391], [-121.59727, 37.82435], [-121.59569, 37.82627], [-121.59571, 37.82748], [-121.59686, 37.82747], [-121.59659, 37.82758], [-121.59507, 37.8298], [-121.59535, 37.83007], [-121.59559, 37.83007], [-121.59881, 37.83171], [-121.59931, 37.83214], [-121.60036, 37.83424], [-121.60028, 37.83829]]]]} Restricted Access 2 13126 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   Contra Costa 12 3217.242 Clifton Court Forebay 0 None 707  

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