superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 3, MNG_AGENCY = 46 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 2 ✖

MNG_AGENCY 1

  • Monterey Peninsula Regional Park District · 2 ✖

ACCESS_TYP 1

  • No Public 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
6987 6987 6986 {"type": "Polygon", "coordinates": [[[-121.85903, 36.36976], [-121.85515, 36.36988], [-121.85527, 36.37368], [-121.85075, 36.37382], [-121.85089, 36.37715], [-121.84711, 36.37728], [-121.84692, 36.37392], [-121.84353, 36.37402], [-121.84363, 36.37741], [-121.82097, 36.37768], [-121.82074, 36.37357], [-121.82012, 36.36611], [-121.8216, 36.36609], [-121.82098, 36.35867], [-121.84327, 36.3589], [-121.8434, 36.36607], [-121.84725, 36.36603], [-121.84713, 36.35909], [-121.85092, 36.35929], [-121.85093, 36.35927], [-121.85093, 36.35901], [-121.85097, 36.35901], [-121.85107, 36.36251], [-121.85878, 36.36245], [-121.85903, 36.36976]], [[-121.83075, 36.36977], [-121.83516, 36.36972], [-121.83501, 36.3661], [-121.82608, 36.36611], [-121.82634, 36.3698], [-121.83075, 36.36977]]]} No Public Access 3 Mill Creek Redwood Preserve   22227 2085 Monterey Peninsula Regional Park District 46 Special District 4 Recreation/Parks District 4 http://www.mprpd.org/ Special District 4 1387.839 Mill Creek Redwood Preserve  
10329 10329 10328 {"type": "Polygon", "coordinates": [[[-121.79058, 36.52123], [-121.79045, 36.52142], [-121.79048, 36.52155], [-121.79052, 36.52163], [-121.79026, 36.52171], [-121.7886, 36.52066], [-121.7887, 36.52057], [-121.78783, 36.5197], [-121.78919, 36.51943], [-121.7892, 36.51992], [-121.78948, 36.52042], [-121.78993, 36.52087], [-121.79025, 36.52083], [-121.79058, 36.52123]]]} No Public Access 3 Thomas Open Space   26308 2085 Monterey Peninsula Regional Park District 46 Special District 4 Recreation/Parks District 4 http://www.mprpd.org/ Special District 4 5.317 Thomas OS  

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