units_with_maps

Table actions

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

1 row where COUNTY = 19, DES_TP = 3 and MNG_AGENCY = 798

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Santa Clara Valley Water District · 1 ✖

DES_TP 1

  • Local Recreation Area · 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
14838 14838 14837 {"type": "Polygon", "coordinates": [[[-121.99308, 37.19292], [-121.99305, 37.19343], [-121.99297, 37.19354], [-121.99128, 37.19329], [-121.99099, 37.19345], [-121.991, 37.19379], [-121.99117, 37.19418], [-121.99234, 37.19503], [-121.99246, 37.19526], [-121.99251, 37.19608], [-121.99234, 37.19624], [-121.99217, 37.19729], [-121.99103, 37.19773], [-121.99054, 37.1981], [-121.99031, 37.19859], [-121.99034, 37.19909], [-121.99051, 37.19934], [-121.99103, 37.19978], [-121.991, 37.20002], [-121.99028, 37.2005], [-121.98948, 37.20077], [-121.98882, 37.20087], [-121.98791, 37.2008], [-121.98739, 37.19988], [-121.98708, 37.19961], [-121.98665, 37.1995], [-121.98599, 37.19957], [-121.98545, 37.19995], [-121.98525, 37.19995], [-121.9851, 37.19986], [-121.98479, 37.19901], [-121.98407, 37.19835], [-121.98367, 37.19821], [-121.98284, 37.19821], [-121.98212, 37.19842], [-121.98101, 37.19951], [-121.98052, 37.20021], [-121.98027, 37.20025], [-121.98027, 37.19984], [-121.98081, 37.19888], [-121.98175, 37.19803], [-121.98258, 37.19753], [-121.9843, 37.19693], [-121.98464, 37.19629], [-121.98524, 37.19599], [-121.9855, 37.19556], [-121.98553, 37.19508], [-121.98533, 37.1949], [-121.98473, 37.19499], [-121.9845, 37.19483], [-121.98364, 37.19455], [-121.98367, 37.19441], [-121.98415, 37.19412], [-121.98438, 37.19385], [-121.98442, 37.19382], [-121.98443, 37.19379], [-121.98456, 37.19363], [-121.98473, 37.19361], [-121.98559, 37.19409], [-121.98593, 37.19421], [-121.98616, 37.19411], [-121.98613, 37.19299], [-121.98593, 37.1927], [-121.98593, 37.19242], [-121.98633, 37.19201], [-121.98664, 37.19123], [-121.98667, 37.19068], [-121.9865, 37.1905], [-121.98647, 37.1902], [-121.98676, 37.1894], [-121.98698, 37.18809], [-121.98678, 37.18761], [-121.9863, 37.18692], [-121.98581, 37.18491], [-121.98547, 37.18438], [-121.98489, 37.18411], [-121.98392, 37.18436], [-121.98366, 37.18436], [-121.98263, 37.18384], [-121.98189, 37.18356], [-121.98092, 37.18377], [-121.98103, 37.18352], [-121.98163, 37.18329], [-121.9824, 37.18317], [-121.98289, 37.18329], [-121.98366, 37.18363], [-121.98406, 37.18365], [-121.98481, 37.1834], [-121.98526, 37.18315], [-121.98521, 37.18214], [-121.98555, 37.18093], [-121.98552, 37.17951], [-121.98497, 37.17775], [-121.98406, 37.1758], [-121.98443, 37.17479], [-121.9844, 37.17324], [-121.98417, 37.17205], [-121.98403, 37.17177], [-121.98351, 37.17145], [-121.98145, 37.17152], [-121.98045, 37.17102], [-121.98019, 37.17065], [-121.98019, 37.17019], [-121.98068, 37.16928], [-121.98128, 37.16861], [-121.98142, 37.16868], [-121.98139, 37.16893], [-121.98083, 37.16987], [-121.98083, 37.17026], [-121.98157, 37.17088], [-121.98205, 37.17104], [-121.98294, 37.17104], [-121.98431, 37.17081], [-121.98474, 37.17081], [-121.98517, 37.17092], [-121.98537, 37.17114], [-121.98552, 37.17186], [-121.98592, 37.17287], [-121.98575, 37.17362], [-121.98549, 37.17408], [-121.98569, 37.17498], [-121.98616, 37.17549], [-121.98712, 37.17594], [-121.98786, 37.17582], [-121.98818, 37.17607], [-121.98827, 37.17646], [-121.98852, 37.17685], [-121.98852, 37.17724], [-121.98807, 37.17749], [-121.98792, 37.17788], [-121.98818, 37.17882], [-121.98815, 37.17926], [-121.98798, 37.17953], [-121.9879, 37.18061], [-121.98764, 37.18125], [-121.98767, 37.18154], [-121.98781, 37.18171], [-121.98953, 37.18148], [-121.9901, 37.18161], [-121.98976, 37.18205], [-121.98807, 37.1826], [-121.98795, 37.18274], [-121.98795, 37.18301], [-121.98819, 37.18326], [-121.98913, 37.18367], [-121.98976, 37.18422], [-121.98993, 37.18452], [-121.98985, 37.18711], [-121.99025, 37.18853], [-121.99059, 37.18905], [-121.99179, 37.19008], [-121.99176, 37.19031], [-121.99122, 37.19061], [-121.99105, 37.19086], [-121.99105, 37.1912], [-121.99117, 37.19127], [-121.99237, 37.19132], [-121.99282, 37.1915], [-121.99294, 37.19187], [-121.99274, 37.19235], [-121.99274, 37.19273], [-121.99308, 37.19292]]]} Open Access 1 45330 Lexington Reservoir 11943 2143 Santa Clara Valley Water District 483 Special District 4 Water District 13 http://www.valleywater.org/ Special District 4 2143 Santa Clara Valley Water District 798 Special District 4 Water District 13 http://www.valleywater.org/Services/LexingtonReservoirAndLenihanDam.aspx Santa Clara 19 319.187 Lexington Reservoir 1952 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]);