units_with_maps

Table actions

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

1 row where DES_TP = 2, MNG_AGENCY = 465, MNG_AG_TYP = 7 and SUID_NMA = 16679

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency - Parks · 1 ✖

MNG_AGENCY 1

  • Santa Clara County Parks and Recreation Dept., County of · 1 ✖

DES_TP 1

  • Local Park · 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
12239 12239 12238 {"type": "MultiPolygon", "coordinates": [[[[-121.81481, 37.18545], [-121.81443, 37.18597], [-121.81411, 37.18586], [-121.81364, 37.18607], [-121.81328, 37.18597], [-121.81248, 37.18616], [-121.8121, 37.18634], [-121.81191, 37.1867], [-121.81129, 37.18674], [-121.81119, 37.18707], [-121.81007, 37.18754], [-121.80967, 37.18793], [-121.80876, 37.18806], [-121.80828, 37.18817], [-121.80768, 37.1887], [-121.80721, 37.18917], [-121.80733, 37.18936], [-121.80713, 37.18941], [-121.80652, 37.18941], [-121.80585, 37.18957], [-121.80484, 37.18906], [-121.80459, 37.1887], [-121.80433, 37.18869], [-121.80389, 37.18904], [-121.80401, 37.18967], [-121.8038, 37.18975], [-121.80308, 37.18935], [-121.80225, 37.18942], [-121.80234, 37.18906], [-121.80212, 37.18882], [-121.80163, 37.18877], [-121.80144, 37.18892], [-121.80106, 37.18913], [-121.80106, 37.18872], [-121.80086, 37.18855], [-121.79987, 37.1886], [-121.79945, 37.18855], [-121.79942, 37.18814], [-121.79966, 37.18806], [-121.79993, 37.18815], [-121.80072, 37.18789], [-121.80062, 37.18771], [-121.80016, 37.1876], [-121.80011, 37.18752], [-121.80048, 37.18729], [-121.80037, 37.18708], [-121.80011, 37.18699], [-121.79949, 37.18707], [-121.79953, 37.1867], [-121.79952, 37.18669], [-121.79918, 37.18667], [-121.79884, 37.18685], [-121.79882, 37.18684], [-121.79892, 37.1866], [-121.7987, 37.18623], [-121.7983, 37.18624], [-121.79766, 37.18685], [-121.79754, 37.18628], [-121.79722, 37.18623], [-121.79694, 37.18653], [-121.7968, 37.18633], [-121.79705, 37.18608], [-121.79691, 37.18585], [-121.79713, 37.18572], [-121.79689, 37.18547], [-121.79672, 37.18544], [-121.79659, 37.18535], [-121.79644, 37.18517], [-121.79633, 37.18496], [-121.79629, 37.18479], [-121.79617, 37.18353], [-121.79606, 37.18286], [-121.79494, 37.17798], [-121.7893, 37.17799], [-121.78787, 37.17503], [-121.79735, 37.17316], [-121.79728, 37.1727], [-121.79721, 37.17205], [-121.79887, 37.17199], [-121.80285, 37.17191], [-121.81129, 37.17604], [-121.81128, 37.17607], [-121.81161, 37.1763], [-121.81395, 37.17834], [-121.81422, 37.17843], [-121.81424, 37.17881], [-121.8145, 37.17904], [-121.8143, 37.17932], [-121.8142, 37.17969], [-121.81354, 37.18042], [-121.81255, 37.18117], [-121.81253, 37.1814], [-121.81326, 37.18189], [-121.81377, 37.18342], [-121.81418, 37.18413], [-121.81453, 37.18459], [-121.81481, 37.18545]], [[-121.8138, 37.18355], [-121.81379, 37.18354], [-121.81252, 37.1835], [-121.81247, 37.1844], [-121.81375, 37.18444], [-121.8138, 37.18355]]], [[[-121.81966, 37.19051], [-121.81954, 37.19058], [-121.81966, 37.19073], [-121.81628, 37.19243], [-121.81628, 37.19244], [-121.81771, 37.19348], [-121.81621, 37.19407], [-121.81534, 37.19382], [-121.81409, 37.197], [-121.81255, 37.19662], [-121.80925, 37.19534], [-121.80926, 37.1953], [-121.80483, 37.19356], [-121.80121, 37.19199], [-121.80043, 37.19164], [-121.79993, 37.19139], [-121.79978, 37.1913], [-121.79948, 37.19106], [-121.79815, 37.18987], [-121.79774, 37.18931], [-121.79705, 37.18819], [-121.79685, 37.18793], [-121.79667, 37.18773], [-121.79643, 37.18752], [-121.79622, 37.18738], [-121.79626, 37.18738], [-121.79728, 37.187], [-121.79742, 37.18696], [-121.79746, 37.18705], [-121.79766, 37.18713], [-121.79822, 37.18683], [-121.79849, 37.18655], [-121.79858, 37.18709], [-121.79917, 37.18697], [-121.79927, 37.18717], [-121.79974, 37.18734], [-121.79993, 37.18781], [-121.79945, 37.18779], [-121.79906, 37.18801], [-121.79921, 37.18869], [-121.79971, 37.18887], [-121.80075, 37.18882], [-121.80068, 37.18913], [-121.80092, 37.18935], [-121.80182, 37.18906], [-121.80197, 37.18946], [-121.80237, 37.18968], [-121.80289, 37.18959], [-121.80373, 37.19001], [-121.80437, 37.18981], [-121.80451, 37.18921], [-121.80487, 37.18956], [-121.80581, 37.18993], [-121.80753, 37.18959], [-121.80818, 37.18894], [-121.80837, 37.18891], [-121.80875, 37.18857], [-121.8102, 37.18806], [-121.81041, 37.1878], [-121.81085, 37.18764], [-121.81182, 37.18708], [-121.81219, 37.18702], [-121.81246, 37.18655], [-121.81315, 37.18646], [-121.8134, 37.18627], [-121.81369, 37.18628], [-121.81411, 37.1862], [-121.81436, 37.18625], [-121.81461, 37.18613], [-121.81494, 37.18576], [-121.81511, 37.18541], [-121.81503, 37.1848], [-121.81446, 37.18409], [-121.81444, 37.18399], [-121.81554, 37.18375], [-121.81547, 37.18401], [-121.81584, 37.18451], [-121.81613, 37.1848], [-121.81612, 37.18486], [-121.81578, 37.18507], [-121.8158, 37.1853], [-121.81578, 37.18554], [-121.81565, 37.18646], [-121.81576, 37.18744], [-121.81583, 37.18771], [-121.81582, 37.18783], [-121.81578, 37.18791], [-121.81534, 37.18815], [-121.81486, 37.18815], [-121.81462, 37.18823], [-121.81441, 37.18879], [-121.81477, 37.18888], [-121.81561, 37.18868], [-121.81639, 37.19007], [-121.81727, 37.18963], [-121.81845, 37.1891], [-121.81883, 37.18887], [-121.81959, 37.1894], [-121.81897, 37.18971], [-121.819, 37.18985], [-121.81911, 37.18992], [-121.81966, 37.19051]]]]} No Public Access 3 25443 Calero County Park 16679 326 Santa Clara County Parks and Recreation Dept., County of 472 County 3 County Agency - Parks 7 http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx County 3 326 Santa Clara County Parks and Recreation Dept., County of 465 County 3 County Agency - Parks 7   Santa Clara 19 963.38 Calero County Park 0 Local Park 2 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]);