units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, COUNTY = 12 and MNG_AGENCY = 916

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open 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
10091 10091 10090 {"type": "MultiPolygon", "coordinates": [[[[-121.65977, 37.82913], [-121.65649, 37.82914], [-121.65608, 37.83012], [-121.65541, 37.83012], [-121.65551, 37.82967], [-121.65559, 37.82908], [-121.65562, 37.82864], [-121.65561, 37.82807], [-121.65569, 37.82703], [-121.65557, 37.82519], [-121.65924, 37.82522], [-121.65924, 37.8252], [-121.65772, 37.82378], [-121.65974, 37.82378], [-121.65977, 37.82913]]], [[[-121.66769, 37.80896], [-121.66734, 37.80927], [-121.66617, 37.80947], [-121.66545, 37.81035], [-121.6654, 37.80925], [-121.66557, 37.80901], [-121.66602, 37.80903], [-121.66685, 37.80846], [-121.66769, 37.80896]]], [[[-121.79505, 37.8131], [-121.79439, 37.81358], [-121.79282, 37.81288], [-121.79218, 37.81385], [-121.79132, 37.81425], [-121.78978, 37.81615], [-121.79091, 37.81774], [-121.78719, 37.81788], [-121.78717, 37.81739], [-121.78692, 37.81738], [-121.78351, 37.81974], [-121.78374, 37.82279], [-121.78701, 37.82442], [-121.78702, 37.83164], [-121.7782, 37.83161], [-121.77824, 37.83871], [-121.78694, 37.83874], [-121.79161, 37.83879], [-121.7916, 37.84595], [-121.78699, 37.84591], [-121.77327, 37.84574], [-121.76901, 37.84586], [-121.76984, 37.85308], [-121.75089, 37.85318], [-121.74117, 37.85304], [-121.74116, 37.85432], [-121.74056, 37.8544], [-121.74028, 37.85478], [-121.74023, 37.85479], [-121.7349, 37.8612], [-121.73295, 37.86135], [-121.73298, 37.87053], [-121.73263, 37.87057], [-121.72354, 37.87434], [-121.7219, 37.875], [-121.72226, 37.87379], [-121.72358, 37.87351], [-121.72368, 37.87149], [-121.72452, 37.87169], [-121.72464, 37.87106], [-121.72839, 37.86856], [-121.72849, 37.86755], [-121.72767, 37.86755], [-121.72661, 37.86869], [-121.72241, 37.86908], [-121.72156, 37.87042], [-121.71716, 37.87064], [-121.71729, 37.87077], [-121.71679, 37.87066], [-121.71779, 37.87248], [-121.71734, 37.87308], [-121.71621, 37.87378], [-121.71495, 37.87522], [-121.71241, 37.87628], [-121.71085, 37.87599], [-121.70562, 37.87326], [-121.69933, 37.87341], [-121.69931, 37.87346], [-121.69882, 37.87343], [-121.69913, 37.87213], [-121.69918, 37.87182], [-121.69921, 37.87152], [-121.69927, 37.86985], [-121.69925, 37.86954], [-121.69919, 37.86915], [-121.69884, 37.86787], [-121.69874, 37.86744], [-121.69846, 37.86747], [-121.69857, 37.86792], [-121.6989, 37.86912], [-121.69896, 37.86941], [-121.699, 37.86993], [-121.69896, 37.8708], [-121.69631, 37.86857], [-121.69154, 37.86747], [-121.69328, 37.86747], [-121.69327, 37.86745], [-121.6927, 37.86724], [-121.69223, 37.86692], [-121.69226, 37.86609], [-121.69226, 37.86554], [-121.69228, 37.86555], [-121.69375, 37.8649], [-121.69417, 37.86492], [-121.69518, 37.86363], [-121.69398, 37.86325], [-121.69313, 37.8623], [-121.69288, 37.86226], [-121.69204, 37.86274], [-121.69155, 37.86275], [-121.69131, 37.8626], [-121.69123, 37.86264], [-121.69115, 37.86257], [-121.68989, 37.8645], [-121.68924, 37.86417], [-121.68901, 37.86411], [-121.6889, 37.86409], [-121.68866, 37.86408], [-121.68842, 37.86411], [-121.6882, 37.86418], [-121.688, 37.86428], [-121.68788, 37.86438], [-121.68599, 37.86603], [-121.68599, 37.86598], [-121.68589, 37.86591], [-121.68574, 37.86572], [-121.6853, 37.86499], [-121.68391, 37.86324], [-121.68369, 37.8629], [-121.68285, 37.86121], [-121.68278, 37.8612], [-121.68216, 37.86133], [-121.68213, 37.86135], [-121.68211, 37.86139], [-121.68209, 37.86127], [-121.68199, 37.86103], [-121.68183, 37.86082], [-121.68173, 37.86072], [-121.68157, 37.8606], [-121.68084, 37.86013], [-121.67813, 37.86012], [-121.67813, 37.85971], [-121.67807, 37.8597], [-121.67813, 37.85291], [-121.68287, 37.8529], [-121.68753, 37.85098], [-121.68753, 37.84929], [-121.67811, 37.84926], [-121.67812, 37.84561], [-121.68753, 37.84567], [-121.68753, 37.84246], [-121.68993, 37.84072], [-121.69015, 37.84072], [-121.69015, 37.83851], [-121.68342, 37.83846], [-121.68342, 37.8352], [-121.67427, 37.83118], [-121.66808, 37.8311], [-121.66808, 37.82748], [-121.67806, 37.82763], [-121.70252, 37.82763], [-121.70253, 37.82482], [-121.70141, 37.82368], [-121.70141, 37.82264], [-121.70702, 37.81946], [-121.70873, 37.81939], [-121.70821, 37.81724], [-121.70532, 37.81749], [-121.70217, 37.81544], [-121.70228, 37.8138], [-121.70228, 37.80995], [-121.70562, 37.80994], [-121.70712, 37.80747], [-121.70656, 37.80532], [-121.70847, 37.8047], [-121.70775, 37.79993], [-121.70504, 37.79682], [-121.70433, 37.7955], [-121.70866, 37.78948], [-121.70947, 37.79019], [-121.7099, 37.79038], [-121.71049, 37.78929], [-121.71326, 37.78926], [-121.71633, 37.78529], [-121.71394, 37.78433], [-121.71272, 37.78492], [-121.71259, 37.77882], [-121.71754, 37.77758], [-121.71753, 37.77756], [-121.71745, 37.77753], [-121.7276, 37.77506], [-121.75947, 37.76707], [-121.76064, 37.76689], [-121.76072, 37.7741], [-121.76974, 37.7741], [-121.76973, 37.78087], [-121.76949, 37.78087], [-121.76948, 37.78119], [-121.76514, 37.78119], [-121.76513, 37.78147], [-121.76495, 37.78214], [-121.76512, 37.78269], [-121.76532, 37.78317], [-121.76532, 37.78356], [-121.76521, 37.78361], [-121.76523, 37.78382], [-121.7652, 37.78389], [-121.76493, 37.78448], [-121.76448, 37.78498], [-121.76423, 37.78506], [-121.76337, 37.78512], [-121.76335, 37.78596], [-121.76487, 37.78621], [-121.76519, 37.78632], [-121.76532, 37.78667], [-121.76536, 37.78668], [-121.76564, 37.78725], [-121.766, 37.7879], [-121.76654, 37.78836], [-121.76878, 37.78836], [-121.76883, 37.78882], [-121.76922, 37.78973], [-121.77515, 37.79423], [-121.77598, 37.79554], [-121.77504, 37.79555], [-121.77509, 37.79735], [-121.77744, 37.79735], [-121.77756, 37.80291], [-121.78021, 37.8029], [-121.78472, 37.80638], [-121.78477, 37.808], [-121.78676, 37.80796], [-121.78677, 37.8087], [-121.78676, 37.81001], [-121.78695, 37.81284], [-121.7905, 37.81021], [-121.79231, 37.80875], [-121.79312, 37.80959], [-121.79355, 37.81023], [-121.79356, 37.81024], [-121.79353, 37.81026], [-121.7941, 37.81155], [-121.79452, 37.81262], [-121.79462, 37.81277], [-121.79473, 37.81289], [-121.79505, 37.8131]]], [[[-121.67, 37.86742], [-121.66902, 37.86741], [-121.66902, 37.8666], [-121.67, 37.86742], [-121.67, 37.86742]]], [[[-121.67689, 37.80772], [-121.67644, 37.8081], [-121.67492, 37.80766], [-121.67326, 37.80765], [-121.67254, 37.80801], [-121.67206, 37.80767], [-121.67107, 37.80805], [-121.66941, 37.80835], [-121.67173, 37.80708], [-121.67211, 37.80685], [-121.6726, 37.80649], [-121.67286, 37.80627], [-121.67315, 37.80597], [-121.67438, 37.80564], [-121.67422, 37.80609], [-121.67429, 37.8064], [-121.67445, 37.80668], [-121.6751, 37.80698], [-121.67541, 37.80729], [-121.67572, 37.80766], [-121.67609, 37.8078], [-121.67689, 37.80772]]], [[[-121.69651, 37.87978], [-121.69649, 37.87984], [-121.69512, 37.87927], [-121.69419, 37.8807], [-121.69237, 37.88046], [-121.68725, 37.87682], [-121.68862, 37.87558], [-121.6923, 37.87816], [-121.69642, 37.87868], [-121.69645, 37.87891], [-121.6965, 37.87906], [-121.69659, 37.87923], [-121.69662, 37.87932], [-121.69662, 37.87941], [-121.69651, 37.87978]]]]} Open Access 1 17470 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/ Contra Costa 12 17806.484 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]);