superunits_with_maps

Table actions

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

1 row where MNG_AGENCY = 631, MNG_AG_TYP = 4 and PARK_NAME = "St Joseph's Hill Open Space Preserve"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 1 ✖

MNG_AGENCY 1

  • Midpeninsula Regional Open Space 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
13076 13076 13075 {"type": "Polygon", "coordinates": [[[-121.98918, 37.21064], [-121.98875, 37.21109], [-121.98816, 37.21138], [-121.98764, 37.21182], [-121.98721, 37.21242], [-121.98703, 37.21306], [-121.98705, 37.21331], [-121.98614, 37.21319], [-121.98566, 37.21378], [-121.98535, 37.21407], [-121.98523, 37.21416], [-121.98514, 37.21437], [-121.98491, 37.21453], [-121.98453, 37.21487], [-121.98442, 37.21509], [-121.9844, 37.21517], [-121.98429, 37.21517], [-121.98431, 37.21507], [-121.98442, 37.21484], [-121.98484, 37.21446], [-121.98501, 37.21435], [-121.9851, 37.21419], [-121.98511, 37.21411], [-121.98527, 37.21401], [-121.98547, 37.2138], [-121.98558, 37.21352], [-121.98561, 37.21324], [-121.98569, 37.21281], [-121.98564, 37.21265], [-121.98567, 37.21258], [-121.98594, 37.21239], [-121.98602, 37.21208], [-121.98587, 37.20766], [-121.98632, 37.20703], [-121.98682, 37.20687], [-121.98692, 37.20682], [-121.98705, 37.20669], [-121.98707, 37.20661], [-121.98707, 37.20655], [-121.98702, 37.20644], [-121.98691, 37.2063], [-121.98689, 37.20621], [-121.98691, 37.20605], [-121.9869, 37.20598], [-121.98688, 37.20598], [-121.98675, 37.20617], [-121.98663, 37.20646], [-121.98652, 37.2065], [-121.98624, 37.20646], [-121.98583, 37.20628], [-121.9858, 37.20579], [-121.98567, 37.20578], [-121.9854, 37.20582], [-121.98492, 37.20602], [-121.98483, 37.20608], [-121.98462, 37.20629], [-121.98423, 37.20659], [-121.98412, 37.20663], [-121.98335, 37.20671], [-121.98304, 37.20685], [-121.98284, 37.20656], [-121.98266, 37.20626], [-121.98253, 37.20618], [-121.98237, 37.20616], [-121.98189, 37.20626], [-121.98172, 37.20626], [-121.98078, 37.20587], [-121.9806, 37.20581], [-121.98059, 37.20668], [-121.9807, 37.20708], [-121.9807, 37.20722], [-121.98065, 37.20736], [-121.98055, 37.20751], [-121.9801, 37.20784], [-121.98, 37.20834], [-121.97978, 37.20855], [-121.97948, 37.20861], [-121.97921, 37.20858], [-121.97858, 37.20831], [-121.97835, 37.20829], [-121.97815, 37.20837], [-121.97672, 37.20945], [-121.97631, 37.20956], [-121.97627, 37.20183], [-121.98585, 37.20139], [-121.9858, 37.2053], [-121.98861, 37.20532], [-121.98853, 37.20542], [-121.98853, 37.20558], [-121.98861, 37.20576], [-121.98856, 37.20601], [-121.9884, 37.2062], [-121.98844, 37.20655], [-121.98857, 37.20666], [-121.98876, 37.20686], [-121.98872, 37.20694], [-121.98858, 37.20697], [-121.98857, 37.20699], [-121.98906, 37.207], [-121.9891, 37.20728], [-121.98854, 37.2083], [-121.98872, 37.20877], [-121.98908, 37.20953], [-121.98922, 37.21011], [-121.98918, 37.21064]]]} Open Access 1 St Joseph's Hill Open Space Preserve   31673 2079 Midpeninsula Regional Open Space District 631 Special District 4 Recreation/Parks District 4 http://www.openspace.org Special District 4 181.514 St Joseph's Hill OSP  

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