units_with_maps

Table actions

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

1 row where COUNTY = 19, DES_TP = 1 and MNG_AG_TYP = 1

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Federal Agency · 1 ✖

DES_TP 1

  • National Public Lands · 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
11549 11549 11548 {"type": "MultiPolygon", "coordinates": [[[[-121.29712, 37.14253], [-121.2971, 37.14615], [-121.28838, 37.14614], [-121.28844, 37.14253], [-121.29712, 37.14253]]], [[[-121.46858, 37.40598], [-121.46698, 37.41181], [-121.46632, 37.41195], [-121.46777, 37.40803], [-121.46562, 37.40803], [-121.46635, 37.40611], [-121.46431, 37.40547], [-121.46786, 37.4055], [-121.46783, 37.40568], [-121.46858, 37.40598]]], [[[-121.47286, 37.40907], [-121.46994, 37.41053], [-121.46781, 37.41159], [-121.46786, 37.4091], [-121.47286, 37.40907]]], [[[-121.48258, 37.41862], [-121.48023, 37.41798], [-121.47953, 37.41952], [-121.48202, 37.42021], [-121.47043, 37.42032], [-121.47051, 37.4198], [-121.4705, 37.4197], [-121.47046, 37.4196], [-121.47028, 37.41929], [-121.47014, 37.41903], [-121.47235, 37.41869], [-121.47403, 37.41785], [-121.47373, 37.4174], [-121.47819, 37.41521], [-121.47719, 37.41362], [-121.47899, 37.41326], [-121.47845, 37.41462], [-121.47935, 37.41604], [-121.4825, 37.41601], [-121.48258, 37.41862]]], [[[-121.4827, 37.40568], [-121.4827, 37.40911], [-121.47831, 37.40899], [-121.47843, 37.41187], [-121.47682, 37.4093], [-121.4747, 37.40968], [-121.4741, 37.40895], [-121.4783, 37.40899], [-121.47816, 37.40564], [-121.4827, 37.40568]]], [[[-121.50674, 37.22769], [-121.49806, 37.22767], [-121.49804, 37.22146], [-121.50672, 37.22122], [-121.50674, 37.22769]]], [[[-121.55854, 37.26361], [-121.55397, 37.2636], [-121.55395, 37.25973], [-121.54939, 37.25972], [-121.54936, 37.25199], [-121.54117, 37.25233], [-121.54116, 37.24874], [-121.53703, 37.24891], [-121.53702, 37.24552], [-121.54934, 37.24504], [-121.54937, 37.25198], [-121.55849, 37.25201], [-121.55854, 37.26361]]], [[[-121.58695, 37.27141], [-121.58209, 37.2714], [-121.58203, 37.26753], [-121.57225, 37.26751], [-121.57223, 37.26364], [-121.56311, 37.26362], [-121.56308, 37.25589], [-121.57219, 37.25591], [-121.57216, 37.24845], [-121.57671, 37.24846], [-121.57675, 37.25591], [-121.57767, 37.25592], [-121.57774, 37.26073], [-121.58195, 37.26075], [-121.58204, 37.26753], [-121.5869, 37.26754], [-121.58695, 37.27141]]], [[[-121.56775, 37.2785], [-121.56318, 37.27851], [-121.56317, 37.27529], [-121.56774, 37.2753], [-121.56775, 37.2785]]], [[[-121.5742, 37.15901], [-121.56967, 37.15903], [-121.56966, 37.15543], [-121.57418, 37.15542], [-121.5742, 37.15901]]], [[[-121.77458, 37.09927], [-121.77003, 37.09933], [-121.76998, 37.09717], [-121.77454, 37.09738], [-121.77458, 37.09927]]]]} Open Access 1 23590 BLM 16162 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   Santa Clara 19 1397.348 BLM 1899 National Public Lands 1 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]);