superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 3, MNG_AG_TYP = 4 and PARK_NAME = "Diablo Foothills Open Space Preserve"

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 PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
13037 13037 13036 {"type": "Polygon", "coordinates": [[[-121.4899, 37.01609], [-121.48766, 37.01759], [-121.48766, 37.01763], [-121.48324, 37.02135], [-121.47913, 37.02067], [-121.47955, 37.02882], [-121.47239, 37.02894], [-121.47235, 37.02828], [-121.46133, 37.02794], [-121.45596, 37.02863], [-121.45568, 37.02752], [-121.45566, 37.02711], [-121.456, 37.02498], [-121.45623, 37.02402], [-121.45649, 37.02349], [-121.4568, 37.02296], [-121.45744, 37.02235], [-121.45758, 37.02211], [-121.45803, 37.02126], [-121.4584, 37.02019], [-121.45844, 37.02018], [-121.4585, 37.01998], [-121.45919, 37.01959], [-121.46085, 37.01857], [-121.46124, 37.01828], [-121.46182, 37.01791], [-121.46204, 37.01742], [-121.46255, 37.01718], [-121.46268, 37.01678], [-121.46321, 37.01642], [-121.4643, 37.0159], [-121.46485, 37.0156], [-121.46505, 37.01539], [-121.46515, 37.01485], [-121.46495, 37.0145], [-121.46499, 37.01431], [-121.46502, 37.01423], [-121.47221, 37.01421], [-121.47223, 37.01455], [-121.48628, 37.0148], [-121.48629, 37.01478], [-121.48569, 37.01355], [-121.48667, 37.01355], [-121.48727, 37.01407], [-121.48768, 37.0146], [-121.48803, 37.01492], [-121.48856, 37.01515], [-121.48891, 37.01525], [-121.48929, 37.01529], [-121.48965, 37.01548], [-121.4899, 37.01587], [-121.4899, 37.01609]]]} No Public Access 3 Diablo Foothills Open Space Preserve http://www.openspaceauthority.org/ 31568 2142 Santa Clara Valley Open Space Authority 468 Special District 4 Recreation/Parks District 4 http://www.openspaceauthority.org/ Special District 4 819.087 Diablo Foothills OSP 2007

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);