units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, COUNTY = 25 and MNG_AGENCY = 1

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 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
10301 10301 10300 {"type": "MultiPolygon", "coordinates": [[[[-121.13353, 39.37174], [-121.13349, 39.37388], [-121.13281, 39.37414], [-121.12863, 39.37409], [-121.12668, 39.37401], [-121.1268, 39.3736], [-121.12692, 39.37303], [-121.12699, 39.37286], [-121.12732, 39.3724], [-121.12747, 39.37224], [-121.12766, 39.37216], [-121.12796, 39.37211], [-121.12833, 39.37209], [-121.12987, 39.37206], [-121.1307, 39.372], [-121.13166, 39.372], [-121.13283, 39.37187], [-121.13353, 39.37174]]], [[[-121.14503, 39.36234], [-121.14494, 39.3659], [-121.14114, 39.36695], [-121.14123, 39.36341], [-121.14503, 39.36234]]], [[[-121.16268, 39.35354], [-121.16254, 39.35727], [-121.15808, 39.35744], [-121.15789, 39.36099], [-121.15585, 39.367], [-121.147, 39.36712], [-121.14889, 39.35365], [-121.15822, 39.35356], [-121.16268, 39.35354]]], [[[-121.16389, 39.33712], [-121.16065, 39.33713], [-121.16057, 39.34053], [-121.15778, 39.34058], [-121.15752, 39.34057], [-121.15758, 39.34046], [-121.1577, 39.34006], [-121.15774, 39.33971], [-121.15768, 39.33945], [-121.15759, 39.33924], [-121.15725, 39.33781], [-121.15701, 39.33714], [-121.15704, 39.33713], [-121.15701, 39.33712], [-121.15692, 39.33687], [-121.15675, 39.33592], [-121.15673, 39.3356], [-121.15668, 39.33527], [-121.15666, 39.33429], [-121.15668, 39.33388], [-121.15676, 39.33343], [-121.15685, 39.33317], [-121.157, 39.33295], [-121.15725, 39.33269], [-121.15756, 39.33249], [-121.15824, 39.33215], [-121.15876, 39.33194], [-121.159, 39.33187], [-121.15945, 39.33186], [-121.16016, 39.33199], [-121.16043, 39.33207], [-121.16089, 39.33213], [-121.16121, 39.3322], [-121.16202, 39.33232], [-121.16227, 39.33237], [-121.16242, 39.33248], [-121.16267, 39.33271], [-121.1628, 39.33292], [-121.16287, 39.33312], [-121.16293, 39.33335], [-121.16294, 39.33366], [-121.16293, 39.33422], [-121.16294, 39.33446], [-121.16294, 39.33501], [-121.16299, 39.33531], [-121.16341, 39.33626], [-121.16362, 39.33661], [-121.16389, 39.33712]]], [[[-121.17781, 39.34295], [-121.17767, 39.346], [-121.173, 39.34586], [-121.17258, 39.34924], [-121.16792, 39.34905], [-121.16859, 39.34277], [-121.17781, 39.34295]]], [[[-121.20793, 39.34291], [-121.203, 39.34296], [-121.2031, 39.33929], [-121.20791, 39.33918], [-121.20793, 39.34291]]], [[[-121.23399, 39.4108], [-121.2315, 39.41075], [-121.23133, 39.41424], [-121.22135, 39.41411], [-121.22129, 39.41051], [-121.21683, 39.41066], [-121.21681, 39.40796], [-121.21781, 39.40847], [-121.21847, 39.40932], [-121.2192, 39.41033], [-121.22081, 39.40979], [-121.21994, 39.40857], [-121.21921, 39.40773], [-121.21814, 39.40682], [-121.21681, 39.40752], [-121.21678, 39.40318], [-121.22128, 39.40322], [-121.2213, 39.4105], [-121.23046, 39.41072], [-121.23049, 39.40937], [-121.23185, 39.4094], [-121.2319, 39.41018], [-121.23396, 39.41025], [-121.23399, 39.4108]]], [[[-121.23115, 39.41809], [-121.23079, 39.42555], [-121.22624, 39.42562], [-121.22632, 39.41812], [-121.23115, 39.41809]]], [[[-121.27837, 39.49482], [-121.27805, 39.49492], [-121.2774, 39.49544], [-121.27739, 39.49531], [-121.27744, 39.49476], [-121.27837, 39.49482]]], [[[-121.29646, 39.46142], [-121.29639, 39.46874], [-121.28239, 39.46865], [-121.28243, 39.46511], [-121.287, 39.46509], [-121.29159, 39.46493], [-121.29177, 39.46142], [-121.28702, 39.46142], [-121.28704, 39.45803], [-121.28916, 39.458], [-121.2909, 39.45775], [-121.29182, 39.45777], [-121.29177, 39.46142], [-121.29646, 39.46142]]], [[[-121.29698, 39.32405], [-121.28276, 39.32409], [-121.28267, 39.32075], [-121.29694, 39.32063], [-121.29698, 39.32405]]], [[[-121.29209, 39.31717], [-121.28751, 39.31714], [-121.28739, 39.31331], [-121.292, 39.31341], [-121.29209, 39.31717]]], [[[-121.29633, 39.21321], [-121.2962, 39.21942], [-121.29394, 39.21942], [-121.29404, 39.21319], [-121.29633, 39.21321]]], [[[-121.30519, 39.4433], [-121.30068, 39.44328], [-121.30051, 39.4397], [-121.30511, 39.43974], [-121.30519, 39.4433]]], [[[-121.31498, 39.45429], [-121.30978, 39.45421], [-121.30991, 39.45057], [-121.31007, 39.45058], [-121.30993, 39.45094], [-121.3104, 39.45106], [-121.31214, 39.44698], [-121.31444, 39.4437], [-121.314, 39.44359], [-121.31153, 39.44697], [-121.31004, 39.44696], [-121.3101, 39.44331], [-121.31486, 39.44331], [-121.31498, 39.45429]]], [[[-121.33342, 39.46521], [-121.33331, 39.46882], [-121.32876, 39.46878], [-121.32882, 39.46519], [-121.33342, 39.46521]]], [[[-121.334, 39.07991], [-121.33121, 39.08001], [-121.33147, 39.07643], [-121.3315, 39.07583], [-121.334, 39.07991]]], [[[-121.37272, 39.22249], [-121.37083, 39.22254], [-121.37083, 39.22227], [-121.37083, 39.22227], [-121.37272, 39.22249]]], [[[-121.40859, 39.21196], [-121.40697, 39.21554], [-121.40429, 39.21923], [-121.40151, 39.22046], [-121.4036, 39.22399], [-121.40357, 39.22401], [-121.40355, 39.22892], [-121.40166, 39.22894], [-121.40008, 39.22535], [-121.39814, 39.22536], [-121.39424, 39.22534], [-121.38968, 39.22387], [-121.38969, 39.22362], [-121.39178, 39.22423], [-121.39345, 39.22477], [-121.39418, 39.2249], [-121.39419, 39.22448], [-121.39493, 39.22191], [-121.39522, 39.22074], [-121.39438, 39.22037], [-121.39351, 39.2203], [-121.39224, 39.22016], [-121.39096, 39.21999], [-121.38971, 39.21979], [-121.38971, 39.21356], [-121.39901, 39.21351], [-121.39905, 39.20929], [-121.40358, 39.20925], [-121.40363, 39.20744], [-121.40826, 39.20742], [-121.4083, 39.21236], [-121.40859, 39.21196]]], [[[-121.39947, 39.22893], [-121.39892, 39.22892], [-121.39892, 39.22782], [-121.39947, 39.22893], [-121.39947, 39.22893]]], [[[-121.44574, 39.20706], [-121.43158, 39.20719], [-121.43164, 39.20713], [-121.43163, 39.20712], [-121.43032, 39.20713], [-121.43031, 39.20721], [-121.42971, 39.20721], [-121.43002, 39.20657], [-121.43, 39.20657], [-121.42971, 39.20714], [-121.42925, 39.20714], [-121.4291, 39.20704], [-121.42941, 39.20656], [-121.42941, 39.20654], [-121.4288, 39.20722], [-121.42695, 39.20724], [-121.42691, 39.20194], [-121.42699, 39.20191], [-121.42695, 39.20134], [-121.42695, 39.20053], [-121.4275, 39.20076], [-121.42751, 39.20075], [-121.42728, 39.20026], [-121.42689, 39.19893], [-121.42687, 39.19642], [-121.43152, 39.19632], [-121.43139, 39.19274], [-121.43294, 39.19271], [-121.44566, 39.19255], [-121.44574, 39.20706]]], [[[-121.48181, 39.19206], [-121.48094, 39.19245], [-121.47004, 39.19439], [-121.46507, 39.19476], [-121.46441, 39.19555], [-121.46446, 39.19232], [-121.48181, 39.19206]]]]} Open Access 1 18105 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   Yuba 25 2646.601 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]);