superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 2, MNG_AGENCY = 87 and YR_EST = 1985

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • East Bay Regional Park District · 2 ✖

ACCESS_TYP 1

  • Restricted Access · 2 ✖
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
13221 13221 13220 {"type": "MultiPolygon", "coordinates": [[[[-122.31376, 37.89702], [-122.31276, 37.89724], [-122.3125, 37.89694], [-122.31163, 37.89607], [-122.31036, 37.89455], [-122.31003, 37.89409], [-122.30983, 37.89374], [-122.30966, 37.89338], [-122.30945, 37.89281], [-122.30929, 37.89225], [-122.30916, 37.89226], [-122.30913, 37.89207], [-122.30909, 37.8916], [-122.3091, 37.89106], [-122.30915, 37.89066], [-122.3093, 37.8898], [-122.30997, 37.89189], [-122.31013, 37.89227], [-122.31036, 37.89272], [-122.31064, 37.89313], [-122.31376, 37.89702]]], [[[-122.32444, 37.89221], [-122.32262, 37.89493], [-122.32102, 37.89532], [-122.321, 37.89499], [-122.31873, 37.89504], [-122.31871, 37.89587], [-122.31644, 37.89642], [-122.31394, 37.89698], [-122.31081, 37.89309], [-122.31056, 37.89272], [-122.31042, 37.89247], [-122.31022, 37.89207], [-122.31011, 37.89177], [-122.30943, 37.88964], [-122.30934, 37.88963], [-122.30949, 37.88875], [-122.30955, 37.8886], [-122.30959, 37.88857], [-122.30966, 37.88854], [-122.30979, 37.88855], [-122.30993, 37.88863], [-122.31022, 37.88909], [-122.31037, 37.88923], [-122.31047, 37.88963], [-122.31333, 37.88964], [-122.31334, 37.88985], [-122.31201, 37.88997], [-122.31197, 37.89022], [-122.31394, 37.8917], [-122.31623, 37.89168], [-122.31634, 37.8909], [-122.31763, 37.89086], [-122.31991, 37.88993], [-122.32312, 37.8899], [-122.32356, 37.8913], [-122.32409, 37.89131], [-122.32444, 37.89221]]]]} Restricted Access 2 Albany State Marine Reserve   30562 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 181.87 Albany State Marine Reserve 1985
13233 13233 13232 {"type": "Polygon", "coordinates": [[[-122.3031, 37.83648], [-122.3031, 37.837], [-122.30105, 37.837], [-122.2977, 37.83767], [-122.29768, 37.83765], [-122.29741, 37.8377], [-122.29731, 37.83767], [-122.2972, 37.83753], [-122.29701, 37.83712], [-122.29573, 37.83491], [-122.29545, 37.83431], [-122.29553, 37.83429], [-122.29554, 37.83428], [-122.2955, 37.8342], [-122.29541, 37.83422], [-122.29463, 37.83252], [-122.29457, 37.8323], [-122.29463, 37.83227], [-122.29454, 37.83193], [-122.29448, 37.83192], [-122.29442, 37.83131], [-122.29443, 37.83091], [-122.29455, 37.82968], [-122.29459, 37.82943], [-122.29471, 37.82908], [-122.29486, 37.82876], [-122.29531, 37.82894], [-122.29539, 37.82884], [-122.29539, 37.82882], [-122.29494, 37.82864], [-122.29515, 37.82836], [-122.29537, 37.82813], [-122.29566, 37.82789], [-122.29604, 37.82765], [-122.2964, 37.82748], [-122.29679, 37.82734], [-122.29713, 37.82725], [-122.3011, 37.82645], [-122.30112, 37.82678], [-122.29925, 37.8278], [-122.29901, 37.82821], [-122.29865, 37.82825], [-122.29849, 37.82846], [-122.29825, 37.82844], [-122.29797, 37.82915], [-122.2982, 37.82942], [-122.2983, 37.82971], [-122.29816, 37.83018], [-122.29786, 37.83006], [-122.29727, 37.83023], [-122.29654, 37.82997], [-122.29596, 37.82963], [-122.29576, 37.82964], [-122.29629, 37.83016], [-122.29641, 37.83044], [-122.29632, 37.83055], [-122.29616, 37.83062], [-122.29629, 37.83081], [-122.29613, 37.83127], [-122.29588, 37.83155], [-122.29628, 37.83193], [-122.29619, 37.83224], [-122.29672, 37.8329], [-122.29659, 37.83311], [-122.29611, 37.83345], [-122.29554, 37.83363], [-122.29548, 37.83374], [-122.29615, 37.83373], [-122.29688, 37.8339], [-122.29694, 37.83457], [-122.29744, 37.83499], [-122.29801, 37.83651], [-122.29895, 37.83704], [-122.29922, 37.83705], [-122.30051, 37.83676], [-122.30152, 37.83669], [-122.3021, 37.83672], [-122.30259, 37.83653], [-122.3031, 37.83648]]]} Restricted Access 2 Emeryville Crescent State Marine Reserve   30564 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 59.016 Emeryville Crescent State Marine Reserve 1985

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