calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES_TP = 61, MNG_AGENCY = 1 and UNIT

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

1 row where ACCESS_TYP = 1, DES_TP = 61, MNG_AGENCY = 1 and UNIT_NAME = "Mecca Hills Wilderness Area"

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
10418	10418	10417	{"type": "MultiPolygon", "coordinates": [[[[-115.99141, 33.57168], [-115.9914, 33.57946], [-115.98421, 33.58268], [-115.97834, 33.58744], [-115.97875, 33.58836], [-115.9805, 33.58927], [-115.98075, 33.58975], [-115.98079, 33.59074], [-115.97993, 33.59186], [-115.97644, 33.59084], [-115.97413, 33.59067], [-115.97109, 33.59108], [-115.96863, 33.59243], [-115.96664, 33.59231], [-115.9603, 33.58853], [-115.95399, 33.58621], [-115.95164, 33.58503], [-115.94742, 33.58502], [-115.94265, 33.5838], [-115.93993, 33.58381], [-115.93606, 33.58446], [-115.93598, 33.58449], [-115.93274, 33.58727], [-115.92716, 33.59059], [-115.92711, 33.59066], [-115.92671, 33.59191], [-115.92671, 33.59199], [-115.92692, 33.59248], [-115.92685, 33.59342], [-115.92425, 33.59869], [-115.88971, 33.59858], [-115.88786, 33.56905], [-115.90513, 33.56911], [-115.90441, 33.55438], [-115.91741, 33.55439], [-115.92175, 33.55441], [-115.92202, 33.56175], [-115.92956, 33.56179], [-115.92985, 33.56917], [-115.93306, 33.56919], [-115.93278, 33.5618], [-115.9344, 33.56181], [-115.93468, 33.56921], [-115.9438, 33.56927], [-115.94371, 33.56559], [-115.9394, 33.56556], [-115.93913, 33.55817], [-115.94373, 33.55819], [-115.9441, 33.55925], [-115.94792, 33.56184], [-115.94813, 33.56931], [-115.95675, 33.56937], [-115.97402, 33.56943], [-115.98728, 33.56954], [-115.99141, 33.57168]]], [[[-116.07804, 33.64241], [-116.06069, 33.64238], [-116.0607, 33.64509], [-116.06286, 33.6451], [-116.06287, 33.64601], [-116.06503, 33.64601], [-116.06503, 33.64783], [-116.0607, 33.64783], [-116.06074, 33.66415], [-116.05094, 33.66413], [-116.05093, 33.6605], [-116.04768, 33.66049], [-116.04768, 33.66412], [-116.04332, 33.66412], [-116.04332, 33.67138], [-116.02597, 33.67144], [-116.02598, 33.66056], [-116.02165, 33.66056], [-116.02164, 33.65875], [-116.01732, 33.65875], [-116.0173, 33.66419], [-116.01296, 33.6642], [-116.01296, 33.66601], [-116.01513, 33.66601], [-116.01513, 33.66782], [-116.00862, 33.66783], [-116.00861, 33.67146], [-115.99119, 33.67144], [-115.99126, 33.64242], [-115.97635, 33.6424], [-115.97629, 33.65691], [-115.95887, 33.65693], [-115.9589, 33.64242], [-115.9416, 33.64241], [-115.9242, 33.64238], [-115.92426, 33.62781], [-115.90692, 33.62777], [-115.90694, 33.62507], [-115.91, 33.62534], [-115.91153, 33.62228], [-115.91302, 33.62108], [-115.91434, 33.62018], [-115.91551, 33.61978], [-115.91827, 33.61832], [-115.91857, 33.6165], [-115.91715, 33.61496], [-115.91727, 33.61328], [-115.92434, 33.61329], [-115.9244, 33.5987], [-115.92453, 33.59869], [-115.9271, 33.59349], [-115.92718, 33.59245], [-115.92696, 33.59195], [-115.92734, 33.59076], [-115.93291, 33.58744], [-115.93614, 33.58467], [-115.93993, 33.58404], [-115.94261, 33.58402], [-115.94742, 33.58524], [-115.95157, 33.58525], [-115.95389, 33.58642], [-115.96017, 33.58873], [-115.96652, 33.5925], [-115.9666, 33.59252], [-115.96864, 33.59265], [-115.96873, 33.59263], [-115.97118, 33.59129], [-115.97413, 33.59089], [-115.97639, 33.59106], [-115.97993, 33.59208], [-115.98009, 33.59203], [-115.98102, 33.59083], [-115.98104, 33.59076], [-115.98101, 33.58973], [-115.98099, 33.58968], [-115.98072, 33.58916], [-115.98066, 33.5891], [-115.97895, 33.58821], [-115.97863, 33.5875], [-115.98436, 33.58286], [-115.9914, 33.57971], [-115.99139, 33.59889], [-116.01735, 33.59886], [-116.02605, 33.59888], [-116.04332, 33.59869], [-116.04332, 33.61322], [-116.06063, 33.61333], [-116.06066, 33.62785], [-116.07201, 33.62789], [-116.07218, 33.62819], [-116.07232, 33.6285], [-116.07243, 33.62881], [-116.07251, 33.62914], [-116.07258, 33.62956], [-116.07289, 33.63298], [-116.07297, 33.63335], [-116.07307, 33.63365], [-116.07321, 33.63394], [-116.07337, 33.63422], [-116.07361, 33.63454], [-116.07388, 33.63484], [-116.07424, 33.63515], [-116.07459, 33.63539], [-116.0749, 33.63556], [-116.07741, 33.63681], [-116.0777, 33.63693], [-116.07801, 33.63704], [-116.07804, 33.64241]], [[-115.99173, 33.65666], [-115.99157, 33.65665], [-115.99156, 33.65678], [-115.99172, 33.65679], [-115.99173, 33.65666]], [[-116.02382, 33.65875], [-116.02598, 33.65874], [-116.02599, 33.65693], [-116.02165, 33.65694], [-116.02165, 33.65874], [-116.02382, 33.65875]], [[-116.06066, 33.62786], [-116.04332, 33.62777], [-116.04332, 33.64231], [-116.03467, 33.64236], [-116.03466, 33.64963], [-116.03033, 33.64965], [-116.03033, 33.65328], [-116.03466, 33.65326], [-116.03466, 33.65689], [-116.04332, 33.65684], [-116.04332, 33.64594], [-116.05634, 33.64599], [-116.05634, 33.64417], [-116.05201, 33.64416], [-116.05201, 33.64234], [-116.06069, 33.64237], [-116.06066, 33.62786]], [[-116.05418, 33.64961], [-116.05419, 33.6496], [-116.05418, 33.6478], [-116.05201, 33.64779], [-116.05202, 33.6496], [-116.05418, 33.64961]]], [[[-116.00865, 33.59879], [-115.99148, 33.59881], [-115.99149, 33.58432], [-116.00855, 33.58428], [-116.00865, 33.59879]]]]}	Open Access 1	48541	Mecca Hills Wilderness Area	33260	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	https://www.blm.gov/visit/mecca-hills-wilderness	Riverside 10	28615.465	Mecca Hills Wilderness Area	1994	Wilderness Area 61	1

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