superunits_with_maps

Table actions

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

1 row where MNG_AGENCY = 87, MNG_AG_TYP = 4 and PARK_URL = "http://www.ebparks.org/parks/sycamore"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 1 ✖

MNG_AGENCY 1

  • East Bay Regional Park District · 1 ✖

ACCESS_TYP 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
15031 15031 15030 {"type": "MultiPolygon", "coordinates": [[[[-121.95106, 37.80222], [-121.94955, 37.80374], [-121.94685, 37.8028], [-121.94647, 37.8025], [-121.94503, 37.80219], [-121.9446, 37.80132], [-121.94506, 37.79975], [-121.9445, 37.79663], [-121.94448, 37.79663], [-121.9433, 37.79753], [-121.94244, 37.79656], [-121.94128, 37.7963], [-121.94034, 37.79587], [-121.94045, 37.79496], [-121.93913, 37.79507], [-121.93819, 37.79492], [-121.93765, 37.795], [-121.93713, 37.7958], [-121.93648, 37.79654], [-121.93557, 37.79737], [-121.93505, 37.7972], [-121.9363, 37.79615], [-121.93664, 37.79504], [-121.93596, 37.79475], [-121.9362, 37.79437], [-121.93619, 37.79435], [-121.93546, 37.79417], [-121.93526, 37.79447], [-121.93483, 37.7943], [-121.93399, 37.79526], [-121.93307, 37.79577], [-121.93274, 37.79629], [-121.93202, 37.79618], [-121.93226, 37.79547], [-121.93203, 37.79519], [-121.93263, 37.79487], [-121.93227, 37.79449], [-121.93169, 37.79479], [-121.9314, 37.79446], [-121.93048, 37.79484], [-121.93054, 37.7953], [-121.93032, 37.79551], [-121.92918, 37.79557], [-121.92902, 37.79523], [-121.92961, 37.79479], [-121.93011, 37.79474], [-121.93041, 37.79424], [-121.93056, 37.79345], [-121.93051, 37.79275], [-121.93069, 37.7924], [-121.93278, 37.79238], [-121.93284, 37.7889], [-121.94194, 37.78879], [-121.94195, 37.79106], [-121.94648, 37.79314], [-121.94646, 37.7951], [-121.95102, 37.79501], [-121.95103, 37.79879], [-121.95106, 37.80222]]], [[[-121.95111, 37.81978], [-121.95083, 37.81981], [-121.95025, 37.81958], [-121.94917, 37.81955], [-121.94888, 37.81937], [-121.94832, 37.81846], [-121.94799, 37.81765], [-121.94788, 37.8172], [-121.94746, 37.81682], [-121.94754, 37.81677], [-121.94754, 37.81675], [-121.94582, 37.81558], [-121.94329, 37.81472], [-121.94166, 37.81514], [-121.94083, 37.81606], [-121.93981, 37.81644], [-121.9397, 37.81667], [-121.93666, 37.81602], [-121.93554, 37.81608], [-121.93464, 37.81592], [-121.93366, 37.81642], [-121.93305, 37.81648], [-121.93307, 37.81697], [-121.93287, 37.8171], [-121.93286, 37.81693], [-121.93212, 37.81671], [-121.93192, 37.81637], [-121.932, 37.81597], [-121.9323, 37.81486], [-121.9309, 37.81208], [-121.93056, 37.81199], [-121.92988, 37.81117], [-121.93037, 37.81091], [-121.93054, 37.81023], [-121.93084, 37.8099], [-121.9311, 37.80945], [-121.93134, 37.80923], [-121.93123, 37.80909], [-121.93121, 37.80876], [-121.93064, 37.80841], [-121.93062, 37.80791], [-121.93047, 37.80733], [-121.93068, 37.80712], [-121.93069, 37.8068], [-121.93015, 37.80588], [-121.93037, 37.80581], [-121.93056, 37.80606], [-121.93071, 37.80615], [-121.93152, 37.80629], [-121.93199, 37.80652], [-121.93213, 37.80676], [-121.93237, 37.80697], [-121.93268, 37.80714], [-121.93307, 37.80761], [-121.93311, 37.80788], [-121.93382, 37.80813], [-121.93587, 37.80772], [-121.93673, 37.80739], [-121.93691, 37.80749], [-121.93713, 37.80801], [-121.93753, 37.80823], [-121.93839, 37.80843], [-121.9392, 37.80811], [-121.94033, 37.80732], [-121.94172, 37.80585], [-121.94172, 37.80697], [-121.94193, 37.80707], [-121.94217, 37.80728], [-121.94224, 37.80766], [-121.94253, 37.80796], [-121.94237, 37.80844], [-121.9424, 37.80867], [-121.94263, 37.80906], [-121.94292, 37.80901], [-121.94322, 37.80938], [-121.94435, 37.80988], [-121.94503, 37.81028], [-121.94544, 37.81016], [-121.9456, 37.80968], [-121.94587, 37.80913], [-121.94675, 37.80979], [-121.94686, 37.81006], [-121.947, 37.81011], [-121.94734, 37.81028], [-121.9483, 37.8106], [-121.94917, 37.81102], [-121.94927, 37.81153], [-121.94918, 37.81186], [-121.94905, 37.81201], [-121.94903, 37.81263], [-121.95111, 37.81218], [-121.95111, 37.81978]]]]} Open Access 1 Sycamore Valley Open Space Regional Preserve http://www.ebparks.org/parks/sycamore 33755 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 696.008 Sycamore Valley OS RPr 1990

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