superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, MNG_AGENCY = 607 and MNG_AG_LEV = 4

This data as json, copyable, CSV (advanced)

MNG_AGENCY 1

  • Manila Community Services District · 2 ✖

ACCESS_TYP 1

  • Open 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
657 657 656 {"type": "MultiPolygon", "coordinates": [[[[-124.16824, 40.85924], [-124.16709, 40.86133], [-124.16528, 40.86127], [-124.15926, 40.86121], [-124.15927, 40.86055], [-124.16009, 40.8591], [-124.16824, 40.85924]]], [[[-124.17983, 40.83876], [-124.17625, 40.84479], [-124.17547, 40.84606], [-124.17116, 40.85399], [-124.16888, 40.85808], [-124.16438, 40.85809], [-124.16426, 40.85767], [-124.16325, 40.85769], [-124.16253, 40.8578], [-124.16233, 40.85708], [-124.16173, 40.85708], [-124.16171, 40.85701], [-124.16406, 40.85699], [-124.164, 40.85397], [-124.16796, 40.85399], [-124.16798, 40.84978], [-124.16822, 40.84976], [-124.16816, 40.84801], [-124.16988, 40.84799], [-124.1699, 40.84788], [-124.17061, 40.84787], [-124.17056, 40.84614], [-124.17286, 40.84609], [-124.17275, 40.84247], [-124.17293, 40.84244], [-124.17281, 40.83882], [-124.17788, 40.83876], [-124.17983, 40.83876]]]]} Open Access 1 Manila Dunes Recreation Area http://www.friendsofthedunes.org/resources/ 6209 2319 Manila Community Services District 607 Special District 4 Community Services District 17 http://www.manilacsd.com/ Special District 4 265.116 Manila Dunes Rec. Area  
6582 6582 6581 {"type": "Polygon", "coordinates": [[[-124.16247, 40.85177], [-124.16166, 40.85293], [-124.16151, 40.85317], [-124.15946, 40.85236], [-124.15859, 40.852], [-124.15866, 40.85177], [-124.15859, 40.8514], [-124.15856, 40.85106], [-124.15866, 40.85071], [-124.15889, 40.85049], [-124.15943, 40.85029], [-124.16022, 40.85014], [-124.16032, 40.85011], [-124.16004, 40.85044], [-124.16003, 40.85068], [-124.16191, 40.85144], [-124.162, 40.85158], [-124.16247, 40.85177]]]} Open Access 1 Manila Community Park   21749 2319 Manila Community Services District 607 Special District 4 Community Services District 17 http://www.manilacsd.com/ Special District 4 15.04 Manila Community Park  

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