units_with_maps

Table actions

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

1 row where AGNCY_NAME = 587, DES_TP = 83 and SUID_NMA = 30365

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Resource Management Area · 1 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
12311 12311 12310 {"type": "Polygon", "coordinates": [[[-124.06293, 40.8633], [-124.06168, 40.86382], [-124.06167, 40.86462], [-124.05849, 40.86458], [-124.05808, 40.86461], [-124.05816, 40.86823], [-124.05666, 40.86826], [-124.05695, 40.86793], [-124.056, 40.86703], [-124.05661, 40.86662], [-124.05655, 40.86628], [-124.05593, 40.86594], [-124.05562, 40.86552], [-124.05559, 40.8648], [-124.05405, 40.86469], [-124.05273, 40.86514], [-124.05237, 40.86543], [-124.05212, 40.86571], [-124.05251, 40.86676], [-124.05205, 40.86678], [-124.05186, 40.86676], [-124.05124, 40.86658], [-124.0522, 40.8645], [-124.05184, 40.86447], [-124.05103, 40.86453], [-124.05046, 40.86427], [-124.05034, 40.86406], [-124.04936, 40.86388], [-124.04936, 40.86398], [-124.04909, 40.86398], [-124.04906, 40.86381], [-124.0482, 40.86377], [-124.04815, 40.86218], [-124.04621, 40.86218], [-124.0462, 40.86111], [-124.04623, 40.8611], [-124.04619, 40.86003], [-124.04329, 40.86005], [-124.04329, 40.85365], [-124.04388, 40.85362], [-124.04389, 40.85358], [-124.05275, 40.85358], [-124.05275, 40.85386], [-124.05268, 40.85387], [-124.05261, 40.8544], [-124.05296, 40.85444], [-124.05292, 40.85476], [-124.05565, 40.855], [-124.05558, 40.8563], [-124.05483, 40.85629], [-124.0548, 40.8571], [-124.05575, 40.85701], [-124.05572, 40.85733], [-124.05572, 40.85752], [-124.0561, 40.85751], [-124.05611, 40.85765], [-124.05672, 40.85764], [-124.05673, 40.85781], [-124.05783, 40.8578], [-124.05794, 40.86208], [-124.06258, 40.86195], [-124.06259, 40.86217], [-124.06228, 40.8623], [-124.06293, 40.8633]]]} Open Access 1 46883 Sunny Brae Forest 30365 1432 Arcata, City of 587 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1432 Arcata, City of 577 City 2 City Agency 2 http://www.cityofarcata.org/190/City-Forests Humboldt 45 342.381 Sunny Brae Forest 0 Local Resource Management Area 83 3

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);