calands: units_with_maps: 1 row where COUNTY = 2, DES_TP = 1 and MNG

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

1 row where COUNTY = 2, DES_TP = 1 and MNG_AGENCY = 1

Search:

descending

This data as json, copyable, CSV (advanced)

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
3148	3148	3147	{"type": "MultiPolygon", "coordinates": [[[[-120.45998, 37.64316], [-120.45993, 37.64497], [-120.45784, 37.645], [-120.45792, 37.64326], [-120.45998, 37.64316]]], [[[-120.46559, 37.64119], [-120.46545, 37.64299], [-120.4637, 37.64316], [-120.46381, 37.6411], [-120.46559, 37.64119]]], [[[-121.3307, 37.30271], [-121.3125, 37.30284], [-121.31173, 37.28836], [-121.32985, 37.28825], [-121.3307, 37.30271]]], [[[-121.38955, 37.38981], [-121.38933, 37.39681], [-121.38477, 37.39679], [-121.38478, 37.3932], [-121.37635, 37.39334], [-121.37646, 37.38986], [-121.38955, 37.38981]]], [[[-121.38719, 37.5323], [-121.38269, 37.53232], [-121.38271, 37.53599], [-121.37805, 37.53602], [-121.37792, 37.5215], [-121.38264, 37.52146], [-121.38267, 37.52498], [-121.38713, 37.52495], [-121.38719, 37.5323]]], [[[-121.39632, 37.53222], [-121.39171, 37.53226], [-121.39172, 37.52495], [-121.39624, 37.5249], [-121.39632, 37.53222]]], [[[-121.40273, 37.40393], [-121.40252, 37.4112], [-121.39352, 37.41123], [-121.39369, 37.40396], [-121.39817, 37.40393], [-121.40273, 37.40393]]], [[[-121.42546, 37.40023], [-121.42484, 37.40374], [-121.407, 37.40377], [-121.40749, 37.39687], [-121.41653, 37.39676], [-121.41636, 37.40039], [-121.42546, 37.40023]]], [[[-121.4577, 37.4105], [-121.45737, 37.41817], [-121.45005, 37.41803], [-121.45037, 37.41065], [-121.4577, 37.4105]]]]}	Open Access 1	21633	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		Stanislaus 2	1652.494	BLM	1899	National Public Lands 1	3

Advanced export

JSON shape: default, array, newline-delimited

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