units_with_maps

Table actions

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

5 rows where ACCESS_TYP = 1, COUNTY = 22 and DES_TP = 61

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, DES_TP

MNG_AG_TYP 1

ACCESS_TYP 1

  • Open Access · 5 ✖
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
641 641 640 {"type": "Polygon", "coordinates": [[[-116.7198, 34.11981], [-116.70246, 34.11977], [-116.70251, 34.10579], [-116.71018, 34.10612], [-116.71976, 34.10633], [-116.71977, 34.11761], [-116.7198, 34.11981]]]} Open Access 1 2745 San Gorgonio Wilderness 24903 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1 http://www.blm.gov/wo/st/en.html US Bureau of Land Management 1 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1   San Bernardino 22 598.093 San Gorgonio Wilderness 0 Wilderness Area 61 1
1739 1739 1738 {"type": "Polygon", "coordinates": [[[-116.58089, 34.11817], [-116.58086, 34.13271], [-116.56346, 34.1327], [-116.56345, 34.1182], [-116.56997, 34.11821], [-116.58089, 34.11817]]]} Open Access 1 12948 San Gorgonio Wilderness 24903 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1 http://www.blm.gov/wo/st/en.html US Bureau of Land Management 1 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1   San Bernardino 22 639.291 San Gorgonio Wilderness 0 Wilderness Area 61 1
5280 5280 5279 {"type": "Polygon", "coordinates": [[[-116.65041, 34.07675], [-116.63292, 34.07673], [-116.63292, 34.06229], [-116.65036, 34.06223], [-116.65041, 34.07675]]]} Open Access 1 2739 San Gorgonio Wilderness 24903 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1 http://www.blm.gov/wo/st/en.html US Bureau of Land Management 1 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1   San Bernardino 22 639.84 San Gorgonio Wilderness 0 Wilderness Area 61 1
6520 6520 6519 {"type": "Polygon", "coordinates": [[[-116.72005, 34.06233], [-116.71996, 34.06301], [-116.71996, 34.07689], [-116.70265, 34.07679], [-116.70266, 34.06231], [-116.72005, 34.06233]]]} Open Access 1 2765 San Gorgonio Wilderness 24903 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1 http://www.blm.gov/wo/st/en.html US Bureau of Land Management 1 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1   San Bernardino 22 635.831 San Gorgonio Wilderness 0 Wilderness Area 61 1
6547 6547 6546 {"type": "Polygon", "coordinates": [[[-116.64768, 34.26478], [-116.64761, 34.27934], [-116.6302, 34.27921], [-116.63013, 34.28917], [-116.63014, 34.29368], [-116.62398, 34.29372], [-116.61282, 34.29369], [-116.61286, 34.28368], [-116.61285, 34.27918], [-116.63019, 34.2792], [-116.63023, 34.27349], [-116.63023, 34.26472], [-116.64768, 34.26478]]]} Open Access 1 3228 Bighorn Mountains Wilderness 16099 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1 http://www.blm.gov/wo/st/en.html US Bureau of Land Management 1 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1   San Bernardino 22 1272.489 Bighorn Mtns. Wilderness 0 Wilderness Area 61 1

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