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 = 39 and MNG_AGENCY = 427

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

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
13145 13145 13144 {"type": "Polygon", "coordinates": [[[-121.02154, 38.22708], [-121.0211, 38.2271], [-121.02086, 38.22707], [-121.02064, 38.22702], [-121.02041, 38.22701], [-121.02011, 38.22706], [-121.01984, 38.22716], [-121.01964, 38.22729], [-121.0193, 38.22759], [-121.01898, 38.22779], [-121.0184, 38.22823], [-121.01814, 38.22831], [-121.01809, 38.22847], [-121.01811, 38.22862], [-121.01808, 38.22876], [-121.01811, 38.22886], [-121.0166, 38.22865], [-121.01663, 38.2284], [-121.01668, 38.22829], [-121.0168, 38.22819], [-121.01678, 38.22801], [-121.01668, 38.22805], [-121.01654, 38.22816], [-121.01641, 38.22811], [-121.01622, 38.22813], [-121.0159, 38.2281], [-121.0157, 38.22814], [-121.01548, 38.22804], [-121.01537, 38.22802], [-121.01537, 38.22794], [-121.01529, 38.22788], [-121.0152, 38.22787], [-121.01511, 38.22792], [-121.01509, 38.22782], [-121.01504, 38.22775], [-121.0149, 38.2277], [-121.01487, 38.22759], [-121.01495, 38.22748], [-121.01495, 38.22736], [-121.01492, 38.22731], [-121.01483, 38.2273], [-121.01474, 38.22731], [-121.01455, 38.22738], [-121.01433, 38.22749], [-121.01413, 38.22762], [-121.014, 38.22774], [-121.01399, 38.22779], [-121.01402, 38.22784], [-121.01407, 38.22787], [-121.01413, 38.22788], [-121.01434, 38.22807], [-121.01434, 38.22821], [-121.0143, 38.22836], [-121.01421, 38.22855], [-121.0142, 38.22862], [-121.0141, 38.22867], [-121.01403, 38.22873], [-121.01398, 38.22881], [-121.01395, 38.2289], [-121.01387, 38.22887], [-121.01377, 38.22888], [-121.01369, 38.22891], [-121.01363, 38.22898], [-121.01367, 38.22915], [-121.01385, 38.22924], [-121.01389, 38.22935], [-121.01376, 38.22944], [-121.01367, 38.22945], [-121.01342, 38.22934], [-121.01326, 38.22925], [-121.01311, 38.22914], [-121.01299, 38.22902], [-121.01268, 38.22862], [-121.01256, 38.22855], [-121.01242, 38.22854], [-121.01233, 38.22855], [-121.01226, 38.22858], [-121.0122, 38.22863], [-121.01217, 38.22869], [-121.01216, 38.22873], [-121.01224, 38.22898], [-121.01209, 38.22901], [-121.01189, 38.229], [-121.01175, 38.22904], [-121.01162, 38.22915], [-121.01168, 38.22925], [-121.01157, 38.22931], [-121.01124, 38.22925], [-121.01113, 38.22927], [-121.01105, 38.22932], [-121.01101, 38.22938], [-121.01101, 38.22945], [-121.01112, 38.22973], [-121.01113, 38.22988], [-121.01097, 38.2298], [-121.01078, 38.22977], [-121.01055, 38.22978], [-121.01034, 38.22984], [-121.01023, 38.22968], [-121.01016, 38.22965], [-121.01008, 38.22963], [-121.00981, 38.22966], [-121.00952, 38.22966], [-121.00941, 38.22969], [-121.00932, 38.22974], [-121.00925, 38.22983], [-121.00916, 38.23002], [-121.00908, 38.23025], [-121.00906, 38.23036], [-121.00908, 38.23056], [-121.00912, 38.23066], [-121.00919, 38.23077], [-121.00925, 38.23083], [-121.00942, 38.23091], [-121.00955, 38.23101], [-121.00965, 38.23115], [-121.0097, 38.23135], [-121.00992, 38.23152], [-121.0102, 38.23167], [-121.0105, 38.23181], [-121.0108, 38.2319], [-121.01117, 38.23197], [-121.01132, 38.23211], [-121.01139, 38.23237], [-121.01124, 38.23275], [-121.01098, 38.23302], [-121.01081, 38.23329], [-121.01084, 38.23348], [-121.01091, 38.23353], [-121.01074, 38.23358], [-121.0105, 38.23372], [-121.0103, 38.2339], [-121.01018, 38.23392], [-121.01008, 38.23397], [-121.01001, 38.23406], [-121.01001, 38.23417], [-121.00976, 38.2344], [-121.00959, 38.23461], [-121.00927, 38.23493], [-121.00911, 38.23505], [-121.00891, 38.23516], [-121.00862, 38.23525], [-121.00799, 38.23552], [-121.00743, 38.23569], [-121.00703, 38.23583], [-121.00642, 38.23633], [-121.00631, 38.23644], [-121.00615, 38.23663], [-121.00605, 38.2368], [-121.00595, 38.23706], [-121.00591, 38.23725], [-121.0059, 38.23745], [-121.00617, 38.23807], [-121.0057, 38.24077], [-121.00524, 38.24074], [-121.00498, 38.24076], [-121.00463, 38.24083], [-121.00433, 38.24093], [-121.00394, 38.24117], [-121.00381, 38.24128], [-121.0035, 38.24158], [-121.00317, 38.24197], [-121.00288, 38.24196], [-120.99563, 38.22533], [-120.98824, 38.20761], [-120.99041, 38.20788], [-120.99042, 38.20801], [-120.99039, 38.20811], [-120.99029, 38.20823], [-120.99013, 38.20832], [-120.99009, 38.20835], [-120.99005, 38.20845], [-120.99006, 38.20856], [-120.99014, 38.20866], [-120.99026, 38.20873], [-120.9905, 38.20876], [-120.99076, 38.20877], [-120.99087, 38.20875], [-120.99096, 38.2087], [-120.99101, 38.20863], [-120.99103, 38.20855], [-120.99101, 38.20847], [-120.99095, 38.2084], [-120.99084, 38.20831], [-120.99068, 38.20821], [-120.99063, 38.20815], [-120.99062, 38.20809], [-120.99063, 38.20803], [-120.99066, 38.20798], [-120.99073, 38.20792], [-120.99424, 38.20834], [-120.99453, 38.20835], [-120.99483, 38.20833], [-120.99519, 38.20826], [-120.99868, 38.20678], [-120.99914, 38.20689], [-120.99931, 38.20698], [-120.99947, 38.207], [-120.99961, 38.20699], [-120.99973, 38.20695], [-120.99983, 38.20689], [-120.99989, 38.20681], [-121.00446, 38.2087], [-121.00373, 38.20969], [-121.00348, 38.20996], [-121.00315, 38.21023], [-121.00278, 38.21045], [-121.00221, 38.21085], [-121.00204, 38.21101], [-121.00197, 38.21112], [-121.00193, 38.21124], [-121.00188, 38.21171], [-121.00191, 38.21176], [-121.00197, 38.21181], [-121.00204, 38.21185], [-121.00212, 38.21187], [-121.00222, 38.21186], [-121.00231, 38.21182], [-121.00269, 38.21152], [-121.00308, 38.21105], [-121.00338, 38.21054], [-121.00364, 38.2104], [-121.00369, 38.21034], [-121.004, 38.20994], [-121.00449, 38.20919], [-121.00465, 38.209], [-121.00481, 38.20886], [-121.00819, 38.21022], [-121.00839, 38.21031], [-121.00862, 38.21038], [-121.00887, 38.21042], [-121.00911, 38.21043], [-121.00935, 38.21041], [-121.01288, 38.20977], [-121.01321, 38.20974], [-121.01348, 38.20974], [-121.01774, 38.21011], [-121.01804, 38.21011], [-121.01836, 38.21017], [-121.01868, 38.2103], [-121.02208, 38.21279], [-121.02221, 38.21289], [-121.0224, 38.2131], [-121.02261, 38.21339], [-121.02419, 38.21625], [-121.02425, 38.21638], [-121.02429, 38.21653], [-121.0243, 38.21675], [-121.02427, 38.2169], [-121.02389, 38.21742], [-121.02367, 38.21777], [-121.02359, 38.21793], [-121.02351, 38.21818], [-121.02349, 38.21835], [-121.02349, 38.21852], [-121.02353, 38.21878], [-121.02362, 38.21902], [-121.02446, 38.22057], [-121.02452, 38.2208], [-121.0245, 38.22103], [-121.02444, 38.22119], [-121.02271, 38.22461], [-121.02154, 38.22708]]]} Open Access 1 35091 Camanche Reservoir 3190 2031 East Bay Municipal Utility District 433 Special District 4 Water District 13 http://www.ebmud.com/ Special District 4 2031 East Bay Municipal Utility District 427 Special District 4 Water District 13 https://ebmud.com/recreation/camanche-reservoir San Joaquin 39 1653.538 Camanche Reservoir 0 Local Recreation Area 3 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]);