calands: units_with_maps: 1 row where ACCESS_TYP = 1 and DES

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

1 row where ACCESS_TYP = 1 and DES_TP = 401

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
4555	4555	4554	{"type": "MultiPolygon", "coordinates": [[[[-119.00489, 38.20378], [-119.00419, 38.20573], [-119.00401, 38.20569], [-119.00219, 38.20938], [-119.00209, 38.20934], [-119.00386, 38.20563], [-119.00318, 38.20541], [-119.00489, 38.20378]]], [[[-119.01184, 38.20947], [-119.01172, 38.20947], [-119.01177, 38.20938], [-119.01117, 38.20913], [-119.01103, 38.20932], [-119.0114, 38.20947], [-119.01055, 38.20946], [-119.01026, 38.20929], [-119.01015, 38.20939], [-119.00946, 38.20914], [-119.00928, 38.20942], [-119.00931, 38.20944], [-119.00723, 38.20942], [-119.00723, 38.20998], [-119.0066, 38.20972], [-119.00674, 38.20945], [-119.00579, 38.20896], [-119.00696, 38.20699], [-119.00587, 38.20659], [-119.00605, 38.20635], [-119.00579, 38.20617], [-119.00461, 38.20757], [-119.0052, 38.20589], [-119.00684, 38.20645], [-119.00752, 38.20522], [-119.0065, 38.20485], [-119.00744, 38.20338], [-119.00791, 38.20356], [-119.00722, 38.20469], [-119.00753, 38.20482], [-119.00743, 38.20504], [-119.00775, 38.20515], [-119.00885, 38.2033], [-119.00886, 38.20341], [-119.00711, 38.20641], [-119.00738, 38.20653], [-119.00917, 38.20349], [-119.01066, 38.20426], [-119.01115, 38.20197], [-119.01162, 38.20198], [-119.0118, 38.20814], [-119.01122, 38.20895], [-119.01184, 38.2092], [-119.01184, 38.20947]], [[-119.01142, 38.20459], [-119.01142, 38.20457], [-119.01079, 38.20431], [-119.00849, 38.20799], [-119.00849, 38.20801], [-119.00909, 38.20828], [-119.0088, 38.20876], [-119.0088, 38.20878], [-119.00911, 38.20892], [-119.01142, 38.20524], [-119.01142, 38.20523], [-119.01111, 38.20508], [-119.01142, 38.20459]]], [[[-119.00643, 38.21121], [-119.00643, 38.21121], [-119.00571, 38.21158], [-119.00612, 38.21073], [-119.00634, 38.21082], [-119.00643, 38.21121]]], [[[-119.00594, 38.21192], [-119.0051, 38.21333], [-119.00494, 38.21329], [-119.00562, 38.21179], [-119.00594, 38.21192]]], [[[-119.02794, 38.19935], [-119.02742, 38.19971], [-119.02627, 38.20043], [-119.02545, 38.20064], [-119.02451, 38.20112], [-119.0233, 38.20167], [-119.02227, 38.2021], [-119.02178, 38.20228], [-119.02095, 38.20278], [-119.02085, 38.19868], [-119.01375, 38.19859], [-119.01374, 38.19735], [-119.01286, 38.19726], [-119.01296, 38.19642], [-119.0124, 38.19636], [-119.01246, 38.19478], [-119.01214, 38.19478], [-119.01207, 38.19633], [-119.01105, 38.19624], [-119.01169, 38.19597], [-119.01115, 38.19401], [-119.01249, 38.19401], [-119.0131, 38.19144], [-119.01532, 38.19145], [-119.0153, 38.19135], [-119.01509, 38.19115], [-119.01435, 38.19059], [-119.01397, 38.18969], [-119.01339, 38.18926], [-119.01286, 38.1892], [-119.01226, 38.18931], [-119.01187, 38.18955], [-119.01185, 38.19002], [-119.01162, 38.19003], [-119.01135, 38.19028], [-119.01082, 38.19313], [-119.00998, 38.19352], [-119.00987, 38.19162], [-119.00786, 38.19184], [-119.00839, 38.19582], [-119.00786, 38.19573], [-119.00631, 38.19953], [-119.00458, 38.19909], [-119.00298, 38.203], [-119.00298, 38.20301], [-119.00305, 38.20302], [-119.00058, 38.2053], [-119.00217, 38.20642], [-119.00091, 38.20889], [-119.0002, 38.20864], [-118.99802, 38.21142], [-119.00114, 38.21272], [-118.99931, 38.21655], [-118.99745, 38.21582], [-118.99455, 38.21913], [-118.99648, 38.21992], [-118.99542, 38.22108], [-118.99542, 38.22109], [-118.99715, 38.22201], [-118.9969, 38.22227], [-118.9969, 38.22229], [-118.99865, 38.22318], [-118.99827, 38.22362], [-118.99827, 38.22364], [-119.00024, 38.22428], [-119.00264, 38.22131], [-119.00285, 38.22137], [-119.00453, 38.21764], [-119.00464, 38.21767], [-119.00282, 38.2215], [-119.00274, 38.22539], [-119.00218, 38.22574], [-119.00111, 38.22607], [-118.99994, 38.22647], [-118.99818, 38.22622], [-118.99691, 38.22598], [-118.99627, 38.22566], [-118.99588, 38.2254], [-118.99483, 38.22493], [-118.99407, 38.22433], [-118.99349, 38.22363], [-118.99348, 38.22168], [-118.99229, 38.22139], [-118.99212, 38.22179], [-118.99137, 38.2216], [-118.99085, 38.22124], [-118.99062, 38.22094], [-118.98993, 38.2207], [-118.98947, 38.2204], [-118.98899, 38.2199], [-118.98821, 38.21954], [-118.98754, 38.21955], [-118.98685, 38.21939], [-118.98611, 38.21913], [-118.98544, 38.21899], [-118.98389, 38.21894], [-118.98207, 38.2195], [-118.98164, 38.2195], [-118.98143, 38.21664], [-118.97613, 38.21698], [-118.97609, 38.21336], [-118.97145, 38.21334], [-118.97135, 38.20972], [-118.96515, 38.20971], [-118.9652, 38.20843], [-118.96611, 38.20681], [-118.96735, 38.20479], [-118.96995, 38.20248], [-118.97082, 38.20054], [-118.97159, 38.19852], [-118.97214, 38.19728], [-118.97592, 38.19488], [-118.97736, 38.19428], [-118.98323, 38.19353], [-118.98908, 38.19303], [-118.99119, 38.19281], [-118.99366, 38.19313], [-118.99573, 38.19365], [-118.99666, 38.19406], [-118.99668, 38.19461], [-118.99742, 38.19519], [-118.99825, 38.19538], [-118.99976, 38.1952], [-119.0041, 38.19415], [-119.00472, 38.19362], [-119.006, 38.19077], [-119.00741, 38.1891], [-119.01052, 38.18708], [-119.01261, 38.18719], [-119.01405, 38.18747], [-119.01463, 38.18813], [-119.01589, 38.19006], [-119.01623, 38.19087], [-119.01726, 38.19041], [-119.02013, 38.18998], [-119.02507, 38.1923], [-119.02691, 38.19359], [-119.02731, 38.19448], [-119.02756, 38.19608], [-119.02791, 38.19762], [-119.02777, 38.19832], [-119.02794, 38.19935]], [[-118.99686, 38.2162], [-118.99712, 38.21569], [-118.99645, 38.21541], [-118.99833, 38.2125], [-118.99684, 38.21205], [-118.99505, 38.21566], [-118.99686, 38.2162]]], [[[-118.99351, 38.22712], [-118.99042, 38.22521], [-118.98888, 38.22439], [-118.98696, 38.22397], [-118.98538, 38.22383], [-118.98369, 38.22485], [-118.98219, 38.22543], [-118.98081, 38.2259], [-118.98075, 38.2203], [-118.98508, 38.22031], [-118.98508, 38.21928], [-118.98599, 38.21938], [-118.98675, 38.21965], [-118.98742, 38.21979], [-118.98809, 38.21978], [-118.98839, 38.21987], [-118.98901, 38.22034], [-118.98969, 38.22089], [-118.99024, 38.22107], [-118.99033, 38.22121], [-118.99077, 38.22146], [-118.99155, 38.22202], [-118.99221, 38.22243], [-118.99278, 38.22306], [-118.99318, 38.22361], [-118.99349, 38.22405], [-118.99351, 38.22712]]], [[[-119.06995, 38.22688], [-119.06854, 38.22729], [-119.06713, 38.22798], [-119.06582, 38.22868], [-119.06119, 38.22964], [-119.05837, 38.23069], [-119.05581, 38.23213], [-119.05189, 38.23455], [-119.04769, 38.23617], [-119.04704, 38.2362], [-119.04685, 38.23597], [-119.04657, 38.23577], [-119.04617, 38.23565], [-119.04563, 38.23544], [-119.04546, 38.23534], [-119.0453, 38.23521], [-119.04523, 38.2349], [-119.04511, 38.23469], [-119.04486, 38.2344], [-119.04462, 38.2342], [-119.04436, 38.23391], [-119.04386, 38.23305], [-119.04361, 38.2327], [-119.0434, 38.23237], [-119.04313, 38.23218], [-119.04201, 38.23175], [-119.04183, 38.23166], [-119.04164, 38.23147], [-119.04145, 38.23114], [-119.04123, 38.23087], [-119.04107, 38.23059], [-119.04089, 38.23021], [-119.04079, 38.22992], [-119.0406, 38.22961], [-119.04033, 38.2294], [-119.04016, 38.22908], [-119.04003, 38.22866], [-119.03995, 38.22825], [-119.03971, 38.22761], [-119.03962, 38.22685], [-119.03962, 38.22646], [-119.03966, 38.22608], [-119.03971, 38.22584], [-119.03967, 38.2256], [-119.03957, 38.2253], [-119.03938, 38.22485], [-119.03923, 38.22432], [-119.03911, 38.22407], [-119.03906, 38.22278], [-119.03896, 38.22249], [-119.03872, 38.22229], [-119.03838, 38.22219], [-119.03793, 38.22213], [-119.03771, 38.22212], [-119.0366, 38.22183], [-119.03606, 38.22164], [-119.03554, 38.22142], [-119.0345, 38.22108], [-119.0336, 38.22093], [-119.03315, 38.2209], [-119.03286, 38.22094], [-119.03263, 38.22089], [-119.0323, 38.22067], [-119.03205, 38.22056], [-119.03169, 38.2205], [-119.03139, 38.22051], [-119.03119, 38.22049], [-119.03093, 38.22035], [-119.03056, 38.22008], [-119.03023, 38.2199], [-119.02984, 38.21971], [-119.02899, 38.2192], [-119.02791, 38.21829], [-119.02662, 38.21757], [-119.02547, 38.21704], [-119.02487, 38.21681], [-119.02439, 38.21671], [-119.0241, 38.21676], [-119.02378, 38.21674], [-119.02258, 38.21636], [-119.02182, 38.21606], [-119.01987, 38.2152], [-119.01974, 38.21518], [-119.019, 38.21515], [-119.01884, 38.21516], [-119.01859, 38.21509], [-119.01815, 38.21483], [-119.01774, 38.21452], [-119.01656, 38.21401], [-119.01657, 38.21318], [-119.0189, 38.21321], [-119.01886, 38.2115], [-119.01884, 38.21149], [-119.0187, 38.20593], [-119.02102, 38.20596], [-119.02096, 38.20309], [-119.02196, 38.20254], [-119.0239, 38.20177], [-119.02542, 38.20104], [-119.02638, 38.20065], [-119.02788, 38.19978], [-119.02796, 38.19971], [-119.02803, 38.20024], [-119.02881, 38.2028], [-119.02976, 38.20383], [-119.03595, 38.2056], [-119.03855, 38.2071], [-119.04198, 38.20844], [-119.05162, 38.2114], [-119.0635, 38.21928], [-119.06498, 38.22128], [-119.06647, 38.22245], [-119.06779, 38.22315], [-119.06841, 38.22381], [-119.06872, 38.22479], [-119.06941, 38.2257], [-119.06986, 38.22611], [-119.06995, 38.22688]]], [[[-119.04286, 38.23246], [-119.04083, 38.23212], [-119.03695, 38.23253], [-119.03494, 38.23312], [-119.03348, 38.23373], [-119.03231, 38.23411], [-119.03143, 38.2343], [-119.02978, 38.23382], [-119.02896, 38.23337], [-119.02712, 38.2322], [-119.02503, 38.23097], [-119.02373, 38.22966], [-119.02264, 38.22826], [-119.02155, 38.22758], [-119.0205, 38.2275], [-119.01945, 38.22822], [-119.01808, 38.22886], [-119.01697, 38.22931], [-119.01585, 38.22993], [-119.01481, 38.23129], [-119.01373, 38.23356], [-119.0129, 38.23447], [-119.01161, 38.23572], [-119.01061, 38.23621], [-119.00947, 38.2364], [-119.00821, 38.23638], [-119.00735, 38.23631], [-119.00671, 38.23613], [-119.00523, 38.23553], [-119.00014, 38.23564], [-118.99881, 38.23556], [-118.9972, 38.23464], [-118.99647, 38.23343], [-118.99602, 38.23224], [-118.99575, 38.23142], [-118.99549, 38.23], [-118.9947, 38.22873], [-118.99376, 38.22739], [-119.00269, 38.22751], [-119.00274, 38.22578], [-119.00335, 38.22538], [-119.00531, 38.22459], [-119.00602, 38.22414], [-119.00651, 38.22378], [-119.00684, 38.22347], [-119.00709, 38.22287], [-119.0071, 38.22472], [-119.01198, 38.22471], [-119.01199, 38.2221], [-119.0145, 38.22283], [-119.01512, 38.22152], [-119.012, 38.21969], [-119.01196, 38.21697], [-119.01202, 38.21676], [-119.01659, 38.21683], [-119.01643, 38.21426], [-119.01752, 38.21481], [-119.01841, 38.21532], [-119.01862, 38.2154], [-119.01883, 38.21545], [-119.01962, 38.21545], [-119.0199, 38.21554], [-119.02118, 38.21612], [-119.02119, 38.2161], [-119.02203, 38.21646], [-119.02326, 38.21692], [-119.0238, 38.21707], [-119.02426, 38.21708], [-119.02457, 38.21706], [-119.02505, 38.21723], [-119.02581, 38.21754], [-119.02665, 38.21795], [-119.02723, 38.21826], [-119.02827, 38.21905], [-119.02875, 38.21944], [-119.02939, 38.21983], [-119.0299, 38.22008], [-119.0308, 38.22062], [-119.03104, 38.22082], [-119.03129, 38.22083], [-119.03155, 38.22081], [-119.03182, 38.22084], [-119.03205, 38.22089], [-119.03234, 38.22112], [-119.03264, 38.22123], [-119.03298, 38.22123], [-119.03328, 38.22119], [-119.03364, 38.22123], [-119.03414, 38.22132], [-119.03496, 38.22156], [-119.03658, 38.22212], [-119.03714, 38.2223], [-119.03839, 38.2225], [-119.03863, 38.22271], [-119.0387, 38.22296], [-119.03869, 38.2234], [-119.03871, 38.22394], [-119.03878, 38.22431], [-119.03894, 38.22468], [-119.03905, 38.225], [-119.03918, 38.22543], [-119.03926, 38.2258], [-119.03923, 38.22689], [-119.03925, 38.22735], [-119.03937, 38.22774], [-119.03971, 38.22901], [-119.03992, 38.22944], [-119.04017, 38.22971], [-119.04039, 38.22993], [-119.0406, 38.23053], [-119.04075, 38.23081], [-119.04101, 38.23123], [-119.04153, 38.23185], [-119.04183, 38.232], [-119.04225, 38.23215], [-119.04274, 38.23238], [-119.04286, 38.23246]]]]}	Open Access 1	29208	BLM	16166	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	204	California Department of Parks and Recreation 47	State 5	State Agency 5		Mono 32	5743.897	BLM	0	None 401

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