superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 2 and PARK_URL = "http://coaloilpoint.ucnrs.org/"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

ACCESS_TYP 1

  • Restricted Access · 1 ✖
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
11168 11168 11167 {"type": "Polygon", "coordinates": [[[-119.88447, 34.41537], [-119.8811, 34.41543], [-119.8811, 34.41769], [-119.87698, 34.41751], [-119.87697, 34.41748], [-119.87253, 34.41749], [-119.87264, 34.41654], [-119.87287, 34.41634], [-119.87326, 34.41582], [-119.87337, 34.41572], [-119.87354, 34.41562], [-119.87402, 34.41543], [-119.87405, 34.41541], [-119.87415, 34.41527], [-119.87415, 34.4152], [-119.87413, 34.41511], [-119.87398, 34.41487], [-119.8737, 34.41454], [-119.8736, 34.41438], [-119.87358, 34.41429], [-119.87366, 34.41409], [-119.87406, 34.41367], [-119.87424, 34.41353], [-119.87484, 34.41345], [-119.87492, 34.41343], [-119.87511, 34.4133], [-119.87521, 34.41316], [-119.87535, 34.41284], [-119.87544, 34.41272], [-119.87573, 34.41241], [-119.87588, 34.41226], [-119.87597, 34.4122], [-119.8761, 34.41214], [-119.87647, 34.41204], [-119.87677, 34.41185], [-119.87692, 34.41168], [-119.87702, 34.41149], [-119.87731, 34.41112], [-119.87748, 34.41083], [-119.87809, 34.41023], [-119.87832, 34.40993], [-119.87843, 34.40976], [-119.8785, 34.40956], [-119.87847, 34.4095], [-119.87828, 34.40933], [-119.87753, 34.40893], [-119.87745, 34.40884], [-119.87746, 34.40873], [-119.87745, 34.40867], [-119.87755, 34.40846], [-119.8776, 34.4082], [-119.87773, 34.40793], [-119.87778, 34.40784], [-119.87783, 34.4078], [-119.87802, 34.40771], [-119.87823, 34.40767], [-119.87837, 34.40768], [-119.87891, 34.40783], [-119.87898, 34.40775], [-119.87895, 34.40755], [-119.87836, 34.40717], [-119.87818, 34.4072], [-119.87779, 34.40751], [-119.87745, 34.40752], [-119.87739, 34.40733], [-119.87753, 34.40714], [-119.87764, 34.40705], [-119.8778, 34.40697], [-119.87796, 34.40689], [-119.87807, 34.40685], [-119.87821, 34.40684], [-119.87839, 34.40687], [-119.87864, 34.40696], [-119.87905, 34.40717], [-119.88006, 34.40796], [-119.88044, 34.40829], [-119.88136, 34.40918], [-119.88176, 34.40962], [-119.88228, 34.41026], [-119.88332, 34.41179], [-119.88351, 34.41198], [-119.8837, 34.41226], [-119.88443, 34.41319], [-119.88447, 34.41537]]]} Restricted Access 2 Coal Oil Point Natural Reserve http://coaloilpoint.ucnrs.org/ 33181 217 University of California 51 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 174.205 Coal Oil Point Natural Reserve  

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