superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 3 and MNG_AGENCY = 577

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Arcata, City of · 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
13145 13145 13144 {"type": "MultiPolygon", "coordinates": [[[[-124.0864, 40.88579], [-124.08616, 40.88604], [-124.08552, 40.8859], [-124.08554, 40.88586], [-124.08609, 40.88597], [-124.08628, 40.88577], [-124.0864, 40.88579]]], [[[-124.08872, 40.88422], [-124.08785, 40.88561], [-124.08769, 40.88558], [-124.08732, 40.88562], [-124.08738, 40.88553], [-124.08782, 40.88545], [-124.08839, 40.88455], [-124.08846, 40.88429], [-124.08854, 40.88416], [-124.08872, 40.88422]]], [[[-124.08879, 40.88379], [-124.08864, 40.88404], [-124.08855, 40.88401], [-124.08871, 40.88376], [-124.08879, 40.88379]]]]} No Public Access 3 Janes Creek Openspace   30677 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 0.744 Janes Creek Openspace  
13339 13339 13338 {"type": "MultiPolygon", "coordinates": [[[[-124.08853, 40.86727], [-124.08849, 40.86738], [-124.08823, 40.86732], [-124.08827, 40.86721], [-124.08853, 40.86727]]], [[[-124.09773, 40.87241], [-124.0977, 40.87249], [-124.09755, 40.87251], [-124.09741, 40.87256], [-124.09735, 40.8727], [-124.09726, 40.87269], [-124.09716, 40.87293], [-124.09704, 40.8729], [-124.09711, 40.87263], [-124.09748, 40.87243], [-124.09773, 40.87241]]]]} No Public Access 3 City of Arcata Openspace   30673 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 0.304 City of Arcata Openspace  

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