calands: units_with_maps: 1 row where DES_TP = 1, MNG_AGENCY = 1 and SUID

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

1 row where DES_TP = 1, MNG_AGENCY = 1 and SUID_NMA = 20797

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
6192	6192	6191	{"type": "MultiPolygon", "coordinates": [[[[-116.24333, 32.62806], [-116.24326, 32.63187], [-116.23893, 32.63197], [-116.23882, 32.63916], [-116.23868, 32.63919], [-116.23864, 32.63923], [-116.23859, 32.63929], [-116.23866, 32.63934], [-116.23863, 32.63938], [-116.23456, 32.63939], [-116.23461, 32.63584], [-116.23233, 32.6359], [-116.23235, 32.63502], [-116.23459, 32.63495], [-116.23461, 32.63405], [-116.23236, 32.63409], [-116.23238, 32.6332], [-116.23029, 32.63329], [-116.2303, 32.63219], [-116.23406, 32.63209], [-116.23465, 32.63206], [-116.23473, 32.62842], [-116.23475, 32.62521], [-116.23906, 32.62483], [-116.23901, 32.62825], [-116.24333, 32.62806]]], [[[-116.25126, 32.62118], [-116.25119, 32.62478], [-116.25122, 32.62843], [-116.24737, 32.62824], [-116.24733, 32.62459], [-116.24733, 32.62104], [-116.25126, 32.62118]]], [[[-116.264, 32.64655], [-116.25971, 32.64654], [-116.25599, 32.64659], [-116.25599, 32.6429], [-116.26398, 32.64296], [-116.264, 32.64655]]], [[[-116.26077, 32.61059], [-116.25656, 32.6106], [-116.25646, 32.60668], [-116.26064, 32.60631], [-116.26077, 32.61059]]], [[[-116.26927, 32.62176], [-116.2692, 32.6254], [-116.26479, 32.62531], [-116.26471, 32.62166], [-116.26927, 32.62176]]], [[[-116.3854, 32.7172], [-116.38542, 32.71826], [-116.38539, 32.71971], [-116.37279, 32.71974], [-116.37279, 32.71827], [-116.37668, 32.71827], [-116.37676, 32.71822], [-116.37676, 32.711], [-116.38104, 32.711], [-116.38104, 32.71358], [-116.38137, 32.71381], [-116.38138, 32.7146], [-116.38532, 32.7146], [-116.38537, 32.71717], [-116.3854, 32.7172]]], [[[-116.4495, 32.60128], [-116.4366, 32.60155], [-116.43686, 32.61615], [-116.42796, 32.61623], [-116.42795, 32.61974], [-116.42351, 32.61974], [-116.42346, 32.61627], [-116.41911, 32.61631], [-116.41471, 32.61628], [-116.41473, 32.62], [-116.41528, 32.62001], [-116.41527, 32.62049], [-116.411, 32.62052], [-116.41099, 32.62412], [-116.40671, 32.62413], [-116.40671, 32.62452], [-116.4054, 32.62395], [-116.40527, 32.62386], [-116.40522, 32.62378], [-116.4052, 32.62369], [-116.40525, 32.62337], [-116.40523, 32.62324], [-116.40517, 32.62313], [-116.40493, 32.62284], [-116.40486, 32.62273], [-116.40482, 32.62258], [-116.40482, 32.6223], [-116.40477, 32.62214], [-116.40461, 32.62197], [-116.40433, 32.62185], [-116.40418, 32.62175], [-116.40408, 32.62165], [-116.40401, 32.6215], [-116.40399, 32.62141], [-116.40399, 32.6213], [-116.40408, 32.621], [-116.40409, 32.62092], [-116.40408, 32.62081], [-116.40407, 32.62074], [-116.40368, 32.61957], [-116.40367, 32.61949], [-116.40368, 32.61938], [-116.40377, 32.61908], [-116.40378, 32.61896], [-116.40375, 32.6188], [-116.4037, 32.61866], [-116.40275, 32.61692], [-116.40267, 32.61681], [-116.40249, 32.61661], [-116.39966, 32.61188], [-116.39939, 32.61136], [-116.39938, 32.61123], [-116.39942, 32.61102], [-116.39923, 32.61099], [-116.39917, 32.61126], [-116.39918, 32.61134], [-116.39923, 32.61147], [-116.39945, 32.61188], [-116.40218, 32.6164], [-116.40243, 32.6168], [-116.40249, 32.61681], [-116.40249, 32.61689], [-116.40258, 32.617], [-116.40352, 32.61872], [-116.40356, 32.61882], [-116.40358, 32.61901], [-116.40357, 32.61911], [-116.40348, 32.61938], [-116.40348, 32.61956], [-116.40387, 32.6208], [-116.40388, 32.62087], [-116.40388, 32.62098], [-116.40382, 32.62121], [-116.4038, 32.62145], [-116.40388, 32.62168], [-116.40395, 32.62178], [-116.40403, 32.62186], [-116.40415, 32.62196], [-116.40447, 32.62209], [-116.40455, 32.62215], [-116.40459, 32.62221], [-116.40463, 32.62231], [-116.40463, 32.62258], [-116.40468, 32.62278], [-116.40479, 32.62297], [-116.40502, 32.62324], [-116.40504, 32.62329], [-116.40505, 32.62334], [-116.40501, 32.62367], [-116.40502, 32.62377], [-116.40506, 32.62386], [-116.40514, 32.62398], [-116.40527, 32.62407], [-116.4067, 32.6247], [-116.4067, 32.63139], [-116.4025, 32.63141], [-116.39815, 32.63141], [-116.39819, 32.63863], [-116.39385, 32.63862], [-116.39386, 32.63142], [-116.39391, 32.61682], [-116.39403, 32.60232], [-116.40246, 32.60225], [-116.40245, 32.59495], [-116.44947, 32.59112], [-116.4495, 32.60128]]], [[[-116.4316, 32.68532], [-116.43157, 32.68881], [-116.43157, 32.69649], [-116.42802, 32.6965], [-116.42804, 32.70379], [-116.41621, 32.70382], [-116.4067, 32.70383], [-116.40674, 32.71503], [-116.40364, 32.71504], [-116.40364, 32.71465], [-116.40248, 32.71466], [-116.40246, 32.71832], [-116.3939, 32.71829], [-116.39388, 32.71467], [-116.39819, 32.71465], [-116.39816, 32.70741], [-116.4025, 32.70739], [-116.40244, 32.70383], [-116.40669, 32.70382], [-116.40671, 32.69904], [-116.4067, 32.69304], [-116.41099, 32.69304], [-116.411, 32.68936], [-116.41527, 32.68934], [-116.41527, 32.69673], [-116.41941, 32.69673], [-116.41942, 32.69652], [-116.42371, 32.6965], [-116.42371, 32.69285], [-116.41942, 32.69287], [-116.41942, 32.68915], [-116.41939, 32.68635], [-116.4194, 32.68534], [-116.42315, 32.68531], [-116.42314, 32.68166], [-116.42533, 32.68166], [-116.4273, 32.68166], [-116.42727, 32.68533], [-116.4316, 32.68532]]], [[[-116.41533, 32.63855], [-116.40675, 32.63859], [-116.4067, 32.63516], [-116.41037, 32.63515], [-116.41529, 32.63511], [-116.41533, 32.63855]]], [[[-116.41954, 32.65852], [-116.41952, 32.65853], [-116.4195, 32.66029], [-116.41525, 32.66029], [-116.41524, 32.65661], [-116.41204, 32.6566], [-116.41188, 32.65626], [-116.41175, 32.65584], [-116.41167, 32.65547], [-116.41163, 32.65506], [-116.41164, 32.65466], [-116.41188, 32.65296], [-116.41188, 32.65263], [-116.41185, 32.65232], [-116.41178, 32.65198], [-116.4116, 32.65153], [-116.41103, 32.65045], [-116.41102, 32.64583], [-116.41845, 32.6458], [-116.41911, 32.64604], [-116.41954, 32.64615], [-116.41954, 32.65852]]], [[[-116.42811, 32.6603], [-116.42809, 32.678], [-116.4195, 32.678], [-116.41953, 32.6748], [-116.41952, 32.6603], [-116.42811, 32.6603]]], [[[-116.48816, 32.68019], [-116.48815, 32.68203], [-116.4753, 32.68203], [-116.4753, 32.67865], [-116.47529, 32.67842], [-116.47102, 32.67843], [-116.47101, 32.68202], [-116.46671, 32.68201], [-116.46672, 32.68931], [-116.4625, 32.68933], [-116.46246, 32.69291], [-116.45398, 32.6929], [-116.45394, 32.69656], [-116.45819, 32.69657], [-116.45814, 32.70016], [-116.45391, 32.70018], [-116.45386, 32.70378], [-116.44525, 32.70377], [-116.44538, 32.68933], [-116.43665, 32.6893], [-116.43666, 32.69649], [-116.436, 32.69649], [-116.43599, 32.6893], [-116.43665, 32.68929], [-116.43667, 32.68205], [-116.44953, 32.68204], [-116.44955, 32.6784], [-116.44997, 32.67842], [-116.44997, 32.68157], [-116.4543, 32.6815], [-116.45435, 32.67058], [-116.45857, 32.67051], [-116.45856, 32.6712], [-116.45823, 32.67121], [-116.45824, 32.67482], [-116.46677, 32.67482], [-116.46683, 32.66022], [-116.46257, 32.66025], [-116.46257, 32.65951], [-116.46284, 32.65949], [-116.46285, 32.65656], [-116.47524, 32.65663], [-116.47524, 32.6589], [-116.47526, 32.66019], [-116.47958, 32.66021], [-116.47959, 32.6675], [-116.47619, 32.6675], [-116.47533, 32.66751], [-116.4753, 32.67481], [-116.47531, 32.67795], [-116.4753, 32.67798], [-116.4753, 32.67841], [-116.48596, 32.67838], [-116.48597, 32.67928], [-116.48388, 32.67929], [-116.48385, 32.67981], [-116.48385, 32.68018], [-116.48816, 32.68019]]], [[[-116.45863, 32.65304], [-116.45402, 32.65305], [-116.45408, 32.65649], [-116.44541, 32.65653], [-116.44538, 32.6603], [-116.43673, 32.66028], [-116.43699, 32.64556], [-116.43695, 32.6419], [-116.44099, 32.64182], [-116.441, 32.64545], [-116.44971, 32.64521], [-116.44968, 32.64933], [-116.45556, 32.64938], [-116.45862, 32.64937], [-116.45863, 32.65304]]]]}	Open Access 1	1209	La Posta/Jewell Valley Management Area	20797	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 Diego 4	8512.763	La Posta/Jewell Valley Management Area	0	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]);