superunits_with_maps

Table actions

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

4 rows where MNG_AGENCY = 613 and MNG_AG_TYP = 17

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • Community Services District · 4 ✖

MNG_AGENCY 1

  • McKinleyville Community Services District · 4 ✖
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
5165 5165 5164 {"type": "MultiPolygon", "coordinates": [[[[-124.12092, 40.949], [-124.11648, 40.94898], [-124.11663, 40.9423], [-124.12009, 40.94232], [-124.12005, 40.94415], [-124.12013, 40.94702], [-124.12017, 40.94729], [-124.12021, 40.94747], [-124.12035, 40.94787], [-124.12092, 40.949]]], [[[-124.12553, 40.94239], [-124.1243, 40.94901], [-124.12126, 40.949], [-124.12063, 40.94769], [-124.12055, 40.9475], [-124.12043, 40.9471], [-124.12037, 40.94679], [-124.1203, 40.9442], [-124.12032, 40.94239], [-124.12553, 40.94239]]]]} Open Access 1 Hiller Park Playground and Picnic Area   19973 2238 McKinleyville Community Services District 613 Special District 4 Community Services District 17 http://mckinleyvillecsd.com/ Special District 4 124.092 Hiller Park Playground and Picnic Area  
5983 5983 5982 {"type": "Polygon", "coordinates": [[[-124.10338, 40.95518], [-124.10286, 40.95518], [-124.10286, 40.95491], [-124.10338, 40.95491], [-124.10338, 40.95518]]]} Open Access 1 Larissa Park   21027 2238 McKinleyville Community Services District 613 Special District 4 Community Services District 17 http://mckinleyvillecsd.com/ Special District 4 0.324 Larissa Park  
8136 8136 8135 {"type": "Polygon", "coordinates": [[[-124.09944, 40.94435], [-124.09763, 40.94435], [-124.09762, 40.94319], [-124.09864, 40.94317], [-124.09865, 40.94306], [-124.09944, 40.94308], [-124.09944, 40.94435]]]} Open Access 1 Pierson Park http://mckinleyvillecsd.com/pierson-park 23666 2238 McKinleyville Community Services District 613 Special District 4 Community Services District 17 http://mckinleyvillecsd.com/ Special District 4 5.118 Pierson Park  
13807 13807 13806 {"type": "Polygon", "coordinates": [[[-124.08423, 40.91223], [-124.08337, 40.91339], [-124.08297, 40.91427], [-124.08271, 40.9151], [-124.08267, 40.91537], [-124.08199, 40.91665], [-124.07922, 40.91579], [-124.07921, 40.91543], [-124.07916, 40.91219], [-124.08423, 40.91223]]]} Restricted Access 2 Riverfront Park   31322 2238 McKinleyville Community Services District 613 Special District 4 Community Services District 17 http://mckinleyvillecsd.com/ Special District 4 36.388 Riverfront 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]);