units_with_maps

Table actions

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

1 row where ACCESS_TYP = 3, AGNCY_TYP = 13 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 1 ✖

ACCESS_TYP 1

  • No Public 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
8220 8220 8219 {"type": "MultiPolygon", "coordinates": [[[[-121.67375, 37.19466], [-121.67332, 37.19501], [-121.6721, 37.19402], [-121.66931, 37.19621], [-121.66716, 37.19428], [-121.66577, 37.19395], [-121.66325, 37.19234], [-121.66291, 37.19106], [-121.65873, 37.18793], [-121.65677, 37.18978], [-121.65701, 37.18997], [-121.6572, 37.1902], [-121.65728, 37.19036], [-121.65744, 37.1908], [-121.65752, 37.19093], [-121.65768, 37.19109], [-121.65782, 37.19118], [-121.65797, 37.19124], [-121.65814, 37.19129], [-121.65831, 37.1913], [-121.65903, 37.1915], [-121.65932, 37.19154], [-121.65951, 37.19153], [-121.6597, 37.19149], [-121.65996, 37.1914], [-121.66012, 37.1913], [-121.66116, 37.19129], [-121.6613, 37.19151], [-121.66078, 37.1925], [-121.66037, 37.19312], [-121.65995, 37.19326], [-121.65974, 37.19354], [-121.65972, 37.19382], [-121.65989, 37.19421], [-121.6605, 37.19431], [-121.6609, 37.19442], [-121.66129, 37.19454], [-121.6617, 37.19489], [-121.662, 37.19498], [-121.66253, 37.19545], [-121.66294, 37.19584], [-121.66305, 37.19586], [-121.66327, 37.19587], [-121.66349, 37.19586], [-121.6638, 37.19579], [-121.66439, 37.19537], [-121.66444, 37.19523], [-121.66481, 37.19494], [-121.66497, 37.19493], [-121.66523, 37.19506], [-121.66593, 37.1955], [-121.66643, 37.19552], [-121.66731, 37.19526], [-121.66776, 37.19538], [-121.66841, 37.19586], [-121.66844, 37.19627], [-121.66918, 37.19753], [-121.6694, 37.19754], [-121.66957, 37.19745], [-121.66991, 37.19746], [-121.67042, 37.19752], [-121.67092, 37.19764], [-121.67147, 37.19794], [-121.67173, 37.19829], [-121.67164, 37.19869], [-121.67182, 37.19903], [-121.67264, 37.1994], [-121.67294, 37.19944], [-121.6729, 37.19964], [-121.67274, 37.2], [-121.67273, 37.20041], [-121.67311, 37.2009], [-121.67291, 37.20106], [-121.6719, 37.20147], [-121.67156, 37.2015], [-121.67086, 37.20186], [-121.67039, 37.20185], [-121.67037, 37.20194], [-121.67046, 37.20195], [-121.67045, 37.20208], [-121.67064, 37.20215], [-121.6721, 37.20242], [-121.67219, 37.20247], [-121.67226, 37.20254], [-121.67229, 37.20263], [-121.6723, 37.20271], [-121.67076, 37.20315], [-121.67054, 37.20325], [-121.67028, 37.20347], [-121.67051, 37.20373], [-121.67054, 37.20382], [-121.6702, 37.20496], [-121.66781, 37.20618], [-121.66476, 37.20618], [-121.6638, 37.20497], [-121.66105, 37.20567], [-121.66095, 37.20549], [-121.65936, 37.20486], [-121.65888, 37.20465], [-121.65833, 37.20381], [-121.65789, 37.20355], [-121.65783, 37.20317], [-121.65723, 37.20271], [-121.65558, 37.20205], [-121.65509, 37.20198], [-121.65315, 37.20186], [-121.65243, 37.20147], [-121.65162, 37.20136], [-121.65087, 37.20155], [-121.6508, 37.20184], [-121.65101, 37.2022], [-121.65087, 37.20231], [-121.65047, 37.20198], [-121.65004, 37.20155], [-121.64942, 37.2015], [-121.64935, 37.20239], [-121.65039, 37.20416], [-121.65064, 37.20448], [-121.64971, 37.20385], [-121.64956, 37.20394], [-121.64947, 37.20448], [-121.64968, 37.20529], [-121.64911, 37.20421], [-121.64921, 37.2034], [-121.64911, 37.20312], [-121.64884, 37.20299], [-121.64858, 37.20242], [-121.64845, 37.20157], [-121.64816, 37.20148], [-121.64781, 37.20164], [-121.64757, 37.20189], [-121.64736, 37.20206], [-121.64705, 37.20252], [-121.64665, 37.20358], [-121.64617, 37.20431], [-121.64539, 37.20467], [-121.64594, 37.20319], [-121.64673, 37.20119], [-121.64707, 37.20093], [-121.64721, 37.20057], [-121.64569, 37.20077], [-121.64536, 37.20098], [-121.64461, 37.20026], [-121.64537, 37.20036], [-121.64596, 37.2003], [-121.64698, 37.20009], [-121.64725, 37.19995], [-121.64693, 37.19888], [-121.64662, 37.19767], [-121.64676, 37.19726], [-121.64666, 37.19657], [-121.64633, 37.19607], [-121.64615, 37.19585], [-121.64556, 37.19615], [-121.64435, 37.19653], [-121.6442, 37.19712], [-121.64375, 37.19745], [-121.6435, 37.19724], [-121.64379, 37.19688], [-121.64391, 37.19609], [-121.64415, 37.19598], [-121.64442, 37.19578], [-121.64476, 37.19564], [-121.64514, 37.19536], [-121.64532, 37.19502], [-121.64544, 37.19438], [-121.64532, 37.19405], [-121.64513, 37.19384], [-121.64466, 37.19347], [-121.64426, 37.19335], [-121.64369, 37.19288], [-121.64316, 37.19251], [-121.6469, 37.19007], [-121.64731, 37.18986], [-121.64827, 37.19022], [-121.64888, 37.19041], [-121.64927, 37.19081], [-121.64959, 37.19108], [-121.64978, 37.19134], [-121.65018, 37.19125], [-121.6506, 37.19122], [-121.65101, 37.19125], [-121.65141, 37.19134], [-121.65167, 37.19144], [-121.6519, 37.19155], [-121.65338, 37.1925], [-121.65464, 37.18997], [-121.65256, 37.18777], [-121.6494, 37.18505], [-121.65302, 37.17121], [-121.65615, 37.17223], [-121.65621, 37.17216], [-121.65783, 37.17259], [-121.65882, 37.17264], [-121.65952, 37.17264], [-121.66124, 37.17269], [-121.65752, 37.17852], [-121.65647, 37.18174], [-121.65872, 37.18298], [-121.66133, 37.18434], [-121.66205, 37.18443], [-121.66306, 37.18517], [-121.6641, 37.1855], [-121.66506, 37.18668], [-121.66659, 37.1872], [-121.66687, 37.18756], [-121.66654, 37.18865], [-121.66646, 37.18927], [-121.66776, 37.1906], [-121.66918, 37.19163], [-121.67142, 37.19208], [-121.67375, 37.19466]]], [[[-121.68743, 37.19048], [-121.68638, 37.19073], [-121.68551, 37.19118], [-121.6846, 37.19161], [-121.68377, 37.19207], [-121.68286, 37.19246], [-121.68243, 37.19194], [-121.68333, 37.19155], [-121.68419, 37.19107], [-121.68506, 37.19067], [-121.68593, 37.1902], [-121.68702, 37.18995], [-121.68743, 37.19048]]]]} No Public Access 3 47778 Coyote Ridge Property 31578 2143 Santa Clara Valley Water District 483 Special District 4 Water District 13 http://www.valleywater.org/ Special District 4 2142 Santa Clara Valley Open Space Authority 468 Special District 4 Recreation/Parks District 4   Santa Clara 19 1178.052 Coyote Ridge Property 0 Local Other or Unknown 14 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]);