units_with_maps

Table actions

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

1 row where COUNTY = 17, MNG_AGENCY = 916 and MNG_AG_TYP = 13

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Water District · 1 ✖

MNG_AGENCY 1

  • Contra Costa Water District · 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
10613 10613 10612 {"type": "MultiPolygon", "coordinates": [[[[-121.73639, 37.76148], [-121.73611, 37.76222], [-121.73614, 37.76282], [-121.73472, 37.76518], [-121.73338, 37.76666], [-121.73162, 37.76728], [-121.72982, 37.76739], [-121.72862, 37.76745], [-121.72738, 37.76759], [-121.72698, 37.76793], [-121.72573, 37.76848], [-121.72478, 37.76905], [-121.72362, 37.77002], [-121.72268, 37.77117], [-121.72236, 37.77119], [-121.72234, 37.77166], [-121.72181, 37.77222], [-121.7206, 37.773], [-121.71961, 37.77435], [-121.71844, 37.77553], [-121.7166, 37.77682], [-121.7165, 37.77743], [-121.71624, 37.77767], [-121.71587, 37.77791], [-121.71188, 37.77889], [-121.7079, 37.77416], [-121.70961, 37.76866], [-121.71091, 37.76994], [-121.71406, 37.7677], [-121.71575, 37.76769], [-121.71575, 37.76768], [-121.7146, 37.76669], [-121.7156, 37.7667], [-121.71784, 37.76548], [-121.71964, 37.76469], [-121.72552, 37.76291], [-121.72703, 37.76344], [-121.73173, 37.7637], [-121.73306, 37.76322], [-121.73304, 37.76137], [-121.73427, 37.76107], [-121.73482, 37.76085], [-121.73519, 37.76029], [-121.7358, 37.76046], [-121.73597, 37.76055], [-121.73612, 37.76067], [-121.73621, 37.76078], [-121.73628, 37.76093], [-121.73639, 37.76148]]], [[[-121.73911, 37.77216], [-121.7276, 37.77506], [-121.71745, 37.77753], [-121.71742, 37.77716], [-121.71802, 37.77682], [-121.71852, 37.77616], [-121.71986, 37.77612], [-121.72017, 37.77469], [-121.72233, 37.77295], [-121.72326, 37.77233], [-121.72314, 37.77188], [-121.72691, 37.76855], [-121.72971, 37.76789], [-121.73002, 37.76789], [-121.73334, 37.76763], [-121.73342, 37.76743], [-121.73367, 37.76731], [-121.73384, 37.76705], [-121.73404, 37.7668], [-121.73426, 37.76657], [-121.73452, 37.76634], [-121.73434, 37.76651], [-121.73422, 37.76666], [-121.73409, 37.76686], [-121.73401, 37.76703], [-121.73395, 37.76724], [-121.73392, 37.7674], [-121.73391, 37.76758], [-121.73393, 37.7678], [-121.73399, 37.76804], [-121.73411, 37.7683], [-121.73422, 37.76847], [-121.73468, 37.76903], [-121.73479, 37.76924], [-121.73487, 37.76945], [-121.73496, 37.76996], [-121.73504, 37.77021], [-121.73517, 37.77049], [-121.73535, 37.77076], [-121.73561, 37.77103], [-121.73588, 37.77124], [-121.73618, 37.77141], [-121.73651, 37.77156], [-121.73682, 37.77165], [-121.73705, 37.7717], [-121.7386, 37.77192], [-121.73886, 37.77201], [-121.73911, 37.77216]]], [[[-121.76031, 37.76694], [-121.75947, 37.76707], [-121.73933, 37.77211], [-121.7392, 37.772], [-121.73905, 37.77191], [-121.73888, 37.77183], [-121.73871, 37.77177], [-121.73745, 37.77158], [-121.73711, 37.77154], [-121.73665, 37.77143], [-121.73645, 37.77135], [-121.73619, 37.77122], [-121.73602, 37.77112], [-121.7358, 37.77095], [-121.73566, 37.77082], [-121.73551, 37.77065], [-121.73531, 37.77034], [-121.73519, 37.77004], [-121.73507, 37.76943], [-121.735, 37.76921], [-121.73484, 37.76893], [-121.7344, 37.76838], [-121.73428, 37.7682], [-121.7342, 37.76802], [-121.73416, 37.76788], [-121.73412, 37.76758], [-121.73415, 37.76727], [-121.73424, 37.767], [-121.73441, 37.76672], [-121.73462, 37.7665], [-121.73518, 37.7661], [-121.73548, 37.76615], [-121.73629, 37.76563], [-121.73684, 37.76439], [-121.73678, 37.76245], [-121.73666, 37.76183], [-121.74139, 37.76322], [-121.74246, 37.76322], [-121.74251, 37.76692], [-121.7514, 37.76694], [-121.76031, 37.76694]]], [[[-121.76087, 37.76694], [-121.76064, 37.76699], [-121.76064, 37.76699], [-121.76064, 37.76694], [-121.76087, 37.76694]]]]} Open Access 1 22289 Los Vaqueros Watershed 2727 2027 Contra Costa Water District 944 Special District 4 Water District 13 http://www.ccwater.com/ Special District 4 2027 Contra Costa Water District 916 Special District 4 Water District 13 http://www.ccwater.com/losvaqueros/ Alameda 17 921.031 Los Vaqueros Watershed 1994 Local Resource Management Area 83 3

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