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 = 685 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 1 ✖

DES_TP 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
8216 8216 8215 {"type": "Polygon", "coordinates": [[[-121.70445, 37.20053], [-121.70326, 37.20153], [-121.70223, 37.20075], [-121.69994, 37.20267], [-121.69238, 37.20067], [-121.67911, 37.20067], [-121.6791, 37.20242], [-121.67335, 37.20336], [-121.6702, 37.20496], [-121.67054, 37.20382], [-121.67051, 37.20373], [-121.67027, 37.20347], [-121.67054, 37.20325], [-121.67069, 37.20318], [-121.6723, 37.2027], [-121.67228, 37.20259], [-121.67223, 37.20251], [-121.67215, 37.20244], [-121.67204, 37.2024], [-121.67064, 37.20215], [-121.67045, 37.20208], [-121.67046, 37.20195], [-121.67037, 37.20194], [-121.67039, 37.20185], [-121.67086, 37.20186], [-121.67156, 37.2015], [-121.6719, 37.20147], [-121.6729, 37.20106], [-121.6731, 37.20091], [-121.67273, 37.20041], [-121.67274, 37.2], [-121.6729, 37.19964], [-121.67294, 37.19944], [-121.67264, 37.1994], [-121.67182, 37.19903], [-121.67164, 37.19869], [-121.67173, 37.19829], [-121.67147, 37.19794], [-121.67093, 37.19764], [-121.67042, 37.19752], [-121.66991, 37.19746], [-121.66957, 37.19745], [-121.66941, 37.19754], [-121.66918, 37.19753], [-121.66844, 37.19627], [-121.66841, 37.19586], [-121.66776, 37.19538], [-121.66731, 37.19526], [-121.66643, 37.19552], [-121.66593, 37.1955], [-121.66523, 37.19506], [-121.66497, 37.19493], [-121.66482, 37.19494], [-121.66444, 37.19523], [-121.66439, 37.19537], [-121.6638, 37.19579], [-121.66349, 37.19586], [-121.66327, 37.19587], [-121.66305, 37.19586], [-121.66294, 37.19584], [-121.66253, 37.19545], [-121.662, 37.19498], [-121.6617, 37.19489], [-121.66129, 37.19454], [-121.6609, 37.19442], [-121.6605, 37.19431], [-121.65989, 37.19421], [-121.65972, 37.19382], [-121.65974, 37.19354], [-121.65995, 37.19326], [-121.66037, 37.19312], [-121.66078, 37.1925], [-121.6613, 37.19151], [-121.66116, 37.19129], [-121.66012, 37.1913], [-121.65996, 37.1914], [-121.6597, 37.19149], [-121.65951, 37.19153], [-121.65932, 37.19154], [-121.65903, 37.1915], [-121.65831, 37.1913], [-121.65814, 37.19129], [-121.65797, 37.19124], [-121.65782, 37.19118], [-121.65768, 37.19109], [-121.65752, 37.19093], [-121.65744, 37.1908], [-121.65728, 37.19036], [-121.6572, 37.1902], [-121.65701, 37.18997], [-121.65677, 37.18978], [-121.65873, 37.18792], [-121.66291, 37.19106], [-121.66325, 37.19234], [-121.66577, 37.19395], [-121.66716, 37.19428], [-121.66931, 37.19621], [-121.67211, 37.19402], [-121.67332, 37.19501], [-121.67375, 37.19466], [-121.67383, 37.19394], [-121.67437, 37.19435], [-121.68242, 37.19194], [-121.68287, 37.19245], [-121.68377, 37.19207], [-121.6846, 37.19161], [-121.68551, 37.19118], [-121.68638, 37.19073], [-121.68742, 37.19049], [-121.68742, 37.19047], [-121.68702, 37.18995], [-121.68664, 37.18949], [-121.68865, 37.18836], [-121.68994, 37.1893], [-121.69016, 37.18949], [-121.69036, 37.1897], [-121.69053, 37.18992], [-121.69074, 37.19027], [-121.69084, 37.19052], [-121.69105, 37.19116], [-121.69108, 37.19133], [-121.69106, 37.19145], [-121.69102, 37.19157], [-121.69095, 37.19168], [-121.69086, 37.19177], [-121.69069, 37.19189], [-121.69056, 37.19195], [-121.69042, 37.19199], [-121.68968, 37.19185], [-121.68984, 37.19285], [-121.69031, 37.19277], [-121.69076, 37.19264], [-121.69176, 37.19272], [-121.69288, 37.19243], [-121.69449, 37.19269], [-121.69483, 37.19278], [-121.69513, 37.19291], [-121.69658, 37.19385], [-121.6948, 37.1945], [-121.69188, 37.19348], [-121.69103, 37.19408], [-121.6915, 37.19486], [-121.69268, 37.19613], [-121.6937, 37.19617], [-121.69621, 37.19724], [-121.69676, 37.19807], [-121.69838, 37.19861], [-121.6998, 37.19983], [-121.70166, 37.20045], [-121.70277, 37.20031], [-121.70325, 37.1999], [-121.7006, 37.19787], [-121.70093, 37.19744], [-121.70189, 37.19857], [-121.70445, 37.20053]], [[-121.68936, 37.19422], [-121.68936, 37.19339], [-121.68861, 37.19248], [-121.68665, 37.19622], [-121.68558, 37.19699], [-121.67959, 37.19319], [-121.67463, 37.19493], [-121.67589, 37.19574], [-121.68004, 37.19795], [-121.68235, 37.19634], [-121.68372, 37.19722], [-121.68189, 37.1985], [-121.68189, 37.19852], [-121.6879, 37.19909], [-121.68937, 37.19811], [-121.68936, 37.19422]]]} No Public Access 3 47777 Coyote Ridge 30262 2305 Santa Clara Valley Transportation Authority 887 Special District 4 Transportation Agency 32 http://www.vta.org/ Special District 4 2142 Santa Clara Valley Open Space Authority 468 Special District 4 Recreation/Parks District 4 http://www.openspaceauthority.org/ Santa Clara 19 553.269 Coyote Ridge 0 None 685  

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