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

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

1 row where AGNCY_LEV = 1 and DES_TP = 1365

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
15542	15542	15541	{"type": "MultiPolygon", "coordinates": [[[[-120.22503, 37.57551], [-120.22499, 37.57901], [-120.22021, 37.57897], [-120.22011, 37.57541], [-120.22503, 37.57551]]], [[[-120.2707, 37.58198], [-120.27045, 37.58865], [-120.27047, 37.59077], [-120.2684, 37.58746], [-120.26758, 37.58728], [-120.26856, 37.58369], [-120.26686, 37.58326], [-120.26589, 37.58691], [-120.26573, 37.58693], [-120.26833, 37.59129], [-120.27042, 37.59216], [-120.27039, 37.59315], [-120.26292, 37.59371], [-120.26335, 37.58292], [-120.26334, 37.58243], [-120.2707, 37.58198]]], [[[-120.27059, 37.60756], [-120.27047, 37.61134], [-120.26169, 37.61141], [-120.26167, 37.61157], [-120.25669, 37.61142], [-120.25693, 37.60439], [-120.26218, 37.60437], [-120.26222, 37.60397], [-120.26637, 37.60387], [-120.26629, 37.60763], [-120.27059, 37.60756]]], [[[-120.26141, 37.61509], [-120.2612, 37.61794], [-120.26119, 37.61878], [-120.25643, 37.61877], [-120.25656, 37.61554], [-120.25645, 37.61508], [-120.26141, 37.61509]]], [[[-120.27469, 37.61905], [-120.27469, 37.62289], [-120.27008, 37.62283], [-120.27016, 37.619], [-120.26565, 37.61894], [-120.26576, 37.61514], [-120.27026, 37.61519], [-120.27017, 37.619], [-120.27469, 37.61905]]], [[[-120.15147, 37.62161], [-120.15144, 37.62212], [-120.15132, 37.62212], [-120.14929, 37.62046], [-120.14621, 37.6205], [-120.14753, 37.62193], [-120.1503, 37.62429], [-120.15047, 37.62425], [-120.15126, 37.62425], [-120.15145, 37.62423], [-120.151, 37.62466], [-120.15031, 37.62429], [-120.14971, 37.62442], [-120.14602, 37.62187], [-120.14282, 37.61934], [-120.14288, 37.61761], [-120.14137, 37.61643], [-120.14006, 37.61676], [-120.13921, 37.6149], [-120.13847, 37.61432], [-120.13846, 37.61434], [-120.13864, 37.61585], [-120.13812, 37.61617], [-120.13572, 37.61394], [-120.13721, 37.61397], [-120.13722, 37.61096], [-120.1377, 37.61113], [-120.13824, 37.61118], [-120.13977, 37.6116], [-120.14039, 37.61255], [-120.14143, 37.6126], [-120.14144, 37.6112], [-120.14356, 37.61189], [-120.14296, 37.61408], [-120.14399, 37.61608], [-120.15147, 37.62161]]], [[[-120.27469, 37.63688], [-120.27456, 37.63999], [-120.27428, 37.63999], [-120.2739, 37.63785], [-120.27129, 37.64012], [-120.26991, 37.64025], [-120.27011, 37.63697], [-120.27197, 37.63689], [-120.27469, 37.63688]]], [[[-120.28804, 37.64771], [-120.28802, 37.65131], [-120.2833, 37.65117], [-120.28348, 37.64757], [-120.28804, 37.64771]]], [[[-120.16434, 37.63453], [-120.16406, 37.63432], [-120.16535, 37.63319], [-120.16603, 37.63368], [-120.1673, 37.63235], [-120.1656, 37.63111], [-120.16432, 37.63244], [-120.16277, 37.6313], [-120.16239, 37.6281], [-120.16033, 37.62802], [-120.16008, 37.62628], [-120.15808, 37.62623], [-120.15759, 37.62358], [-120.16225, 37.6236], [-120.16234, 37.62766], [-120.1624, 37.62809], [-120.16292, 37.6281], [-120.1677, 37.63159], [-120.16901, 37.6324], [-120.17146, 37.63519], [-120.17345, 37.63571], [-120.17324, 37.63639], [-120.17598, 37.63906], [-120.17923, 37.64257], [-120.18133, 37.64228], [-120.18288, 37.64263], [-120.18234, 37.64313], [-120.18233, 37.64296], [-120.17785, 37.64318], [-120.17787, 37.64534], [-120.17718, 37.64381], [-120.17639, 37.64407], [-120.17712, 37.64586], [-120.17785, 37.64561], [-120.17785, 37.6483], [-120.17676, 37.64667], [-120.17517, 37.64819], [-120.17505, 37.65158], [-120.17274, 37.65274], [-120.17426, 37.64964], [-120.17384, 37.64535], [-120.17611, 37.64493], [-120.17611, 37.64491], [-120.17123, 37.6391], [-120.16886, 37.63914], [-120.16636, 37.63625], [-120.16517, 37.6351], [-120.16434, 37.63453]]], [[[-120.19942, 37.65321], [-120.18545, 37.65312], [-120.18509, 37.65278], [-120.1821, 37.65287], [-120.18004, 37.6516], [-120.17956, 37.65087], [-120.19147, 37.65012], [-120.19147, 37.64977], [-120.19365, 37.65053], [-120.19393, 37.65183], [-120.19747, 37.65306], [-120.19888, 37.65255], [-120.19942, 37.65321]]], [[[-120.32305, 37.6929], [-120.32256, 37.69339], [-120.32235, 37.69302], [-120.32227, 37.69294], [-120.3221, 37.69286], [-120.32176, 37.69274], [-120.32161, 37.69263], [-120.32143, 37.69239], [-120.32126, 37.69198], [-120.32113, 37.69178], [-120.32092, 37.69156], [-120.32062, 37.69136], [-120.32015, 37.69118], [-120.32006, 37.69112], [-120.31983, 37.69094], [-120.31979, 37.69133], [-120.31971, 37.69128], [-120.31938, 37.69116], [-120.31902, 37.69113], [-120.31896, 37.69114], [-120.31889, 37.69119], [-120.31885, 37.69132], [-120.31884, 37.69143], [-120.31887, 37.69159], [-120.31893, 37.69175], [-120.31901, 37.6919], [-120.31943, 37.69248], [-120.31951, 37.69265], [-120.31982, 37.69306], [-120.32007, 37.69329], [-120.32016, 37.69342], [-120.32023, 37.69355], [-120.32026, 37.69369], [-120.32027, 37.69383], [-120.32028, 37.69444], [-120.32056, 37.69487], [-120.32084, 37.69527], [-120.32105, 37.69563], [-120.32118, 37.696], [-120.3212, 37.69643], [-120.32086, 37.69643], [-120.3197, 37.6944], [-120.31824, 37.69241], [-120.31532, 37.69246], [-120.31535, 37.68888], [-120.31775, 37.68889], [-120.3178, 37.6886], [-120.3178, 37.68845], [-120.31767, 37.68824], [-120.31753, 37.68788], [-120.31753, 37.68768], [-120.31709, 37.6873], [-120.31691, 37.68708], [-120.31655, 37.68676], [-120.31617, 37.68626], [-120.31599, 37.6861], [-120.31534, 37.68535], [-120.31534, 37.68524], [-120.31523, 37.68515], [-120.31504, 37.68506], [-120.31498, 37.68502], [-120.31481, 37.68485], [-120.31462, 37.68472], [-120.3145, 37.68466], [-120.31443, 37.68458], [-120.31441, 37.68448], [-120.31439, 37.68431], [-120.31435, 37.68422], [-120.31429, 37.68414], [-120.31412, 37.68399], [-120.31399, 37.68373], [-120.31395, 37.6837], [-120.31361, 37.68358], [-120.31354, 37.68353], [-120.31337, 37.68333], [-120.31326, 37.68315], [-120.31318, 37.68285], [-120.31303, 37.68272], [-120.31304, 37.68255], [-120.313, 37.68249], [-120.31282, 37.68233], [-120.31263, 37.68224], [-120.31257, 37.68218], [-120.31251, 37.6821], [-120.31246, 37.68195], [-120.3124, 37.68183], [-120.31227, 37.68165], [-120.31221, 37.6816], [-120.31201, 37.68153], [-120.31183, 37.68139], [-120.31169, 37.68126], [-120.31139, 37.68091], [-120.31135, 37.68082], [-120.31132, 37.6807], [-120.3111, 37.68059], [-120.31087, 37.68022], [-120.31086, 37.68023], [-120.31069, 37.68154], [-120.30587, 37.68156], [-120.30091, 37.68154], [-120.30127, 37.67781], [-120.29598, 37.67777], [-120.29599, 37.67625], [-120.29264, 37.67623], [-120.29254, 37.67982], [-120.28809, 37.6796], [-120.28798, 37.67589], [-120.27894, 37.67524], [-120.27489, 37.67552], [-120.27428, 37.66634], [-120.2695, 37.66665], [-120.25918, 37.66738], [-120.25934, 37.66452], [-120.25342, 37.66433], [-120.25337, 37.66659], [-120.25346, 37.67204], [-120.259, 37.67216], [-120.25906, 37.67037], [-120.26472, 37.6705], [-120.26468, 37.6737], [-120.25895, 37.67352], [-120.25908, 37.67961], [-120.25912, 37.6831], [-120.25926, 37.6879], [-120.2593, 37.69219], [-120.25901, 37.70076], [-120.25742, 37.70101], [-120.2511, 37.70193], [-120.24991, 37.70291], [-120.24956, 37.70111], [-120.25362, 37.70124], [-120.25316, 37.6977], [-120.24992, 37.69762], [-120.24995, 37.6939], [-120.24057, 37.69398], [-120.24063, 37.69036], [-120.23613, 37.69035], [-120.2362, 37.68773], [-120.23425, 37.6875], [-120.23624, 37.68642], [-120.23633, 37.68273], [-120.23624, 37.67886], [-120.24057, 37.67893], [-120.24056, 37.67513], [-120.24488, 37.67535], [-120.24494, 37.67161], [-120.24049, 37.67142], [-120.24046, 37.66835], [-120.23718, 37.66815], [-120.23774, 37.66769], [-120.23774, 37.66767], [-120.2361, 37.66763], [-120.23608, 37.66387], [-120.23163, 37.66386], [-120.23171, 37.66762], [-120.22714, 37.66752], [-120.22712, 37.66377], [-120.22263, 37.66368], [-120.22261, 37.66399], [-120.22242, 37.66373], [-120.21858, 37.66373], [-120.21868, 37.66748], [-120.21678, 37.66747], [-120.21833, 37.66692], [-120.21707, 37.66522], [-120.21357, 37.6652], [-120.21263, 37.6644], [-120.20855, 37.66382], [-120.20633, 37.66352], [-120.2072, 37.66117], [-120.20544, 37.66051], [-120.20562, 37.65411], [-120.20421, 37.65318], [-120.20069, 37.65268], [-120.20013, 37.6517], [-120.20566, 37.65192], [-120.21415, 37.65222], [-120.21414, 37.65998], [-120.2241, 37.66008], [-120.23154, 37.66014], [-120.23151, 37.65263], [-120.23604, 37.65269], [-120.23604, 37.66016], [-120.23996, 37.66022], [-120.24001, 37.66018], [-120.24354, 37.66028], [-120.24952, 37.66038], [-120.24948, 37.66418], [-120.2534, 37.66433], [-120.25341, 37.66432], [-120.2535, 37.65857], [-120.25354, 37.65678], [-120.25079, 37.6567], [-120.24049, 37.6565], [-120.24041, 37.65274], [-120.2444, 37.65279], [-120.25129, 37.65295], [-120.25924, 37.65308], [-120.26, 37.65316], [-120.26007, 37.65206], [-120.26188, 37.65241], [-120.27418, 37.65138], [-120.27434, 37.65323], [-120.27433, 37.65594], [-120.27882, 37.65561], [-120.27902, 37.65909], [-120.27885, 37.66059], [-120.27878, 37.66246], [-120.28739, 37.66277], [-120.28739, 37.66138], [-120.28731, 37.65918], [-120.29672, 37.65947], [-120.29602, 37.67399], [-120.30164, 37.67407], [-120.30066, 37.67467], [-120.30149, 37.67546], [-120.3015, 37.67546], [-120.30154, 37.67505], [-120.30185, 37.67533], [-120.30218, 37.67553], [-120.30224, 37.67558], [-120.3023, 37.67567], [-120.30232, 37.67567], [-120.30237, 37.67558], [-120.30238, 37.67552], [-120.30234, 37.67536], [-120.30234, 37.67533], [-120.30259, 37.67519], [-120.30272, 37.67507], [-120.30281, 37.67501], [-120.30293, 37.67498], [-120.30301, 37.67491], [-120.30306, 37.6749], [-120.30317, 37.6749], [-120.30324, 37.67492], [-120.3034, 37.67502], [-120.30383, 37.67551], [-120.3043, 37.67623], [-120.30469, 37.6766], [-120.30479, 37.67689], [-120.3048, 37.67707], [-120.30482, 37.67709], [-120.30505, 37.67711], [-120.30518, 37.67716], [-120.3055, 37.67741], [-120.30558, 37.67754], [-120.30558, 37.6776], [-120.30554, 37.6777], [-120.30544, 37.67784], [-120.30518, 37.67817], [-120.30509, 37.67844], [-120.30502, 37.67873], [-120.30504, 37.67875], [-120.30517, 37.67872], [-120.30526, 37.67862], [-120.30533, 37.67858], [-120.3057, 37.67848], [-120.30613, 37.67843], [-120.30623, 37.67845], [-120.30659, 37.67533], [-120.30658, 37.67533], [-120.30653, 37.67538], [-120.30641, 37.67545], [-120.30627, 37.67548], [-120.30612, 37.67544], [-120.3058, 37.67522], [-120.3057, 37.67512], [-120.30556, 37.67494], [-120.30515, 37.6743], [-120.30499, 37.67412], [-120.30549, 37.67412], [-120.30622, 37.67516], [-120.30665, 37.67487], [-120.30673, 37.67414], [-120.31161, 37.67416], [-120.31107, 37.67951], [-120.31123, 37.68028], [-120.31281, 37.6815], [-120.31386, 37.68277], [-120.31429, 37.68337], [-120.31482, 37.6843], [-120.31535, 37.68474], [-120.31586, 37.68497], [-120.31645, 37.68558], [-120.31761, 37.68696], [-120.31802, 37.6875], [-120.31827, 37.68825], [-120.31822, 37.68889], [-120.31988, 37.69035], [-120.32142, 37.69134], [-120.32248, 37.69239], [-120.32305, 37.6929]], [[-120.27867, 37.66359], [-120.27868, 37.66358], [-120.27877, 37.66248], [-120.27792, 37.6635], [-120.27867, 37.66359]]]]}	Open Access 1	48981	Lake McClure (Exchequer Reservoir)	6445	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	2240	Merced Irrigation District 620	Special District 4	Irrigation District 16	http://www.lakemcclure.com/	Mariposa 31	5305.275	Lake McClure (Exchequer Reservoir)	0	None 1365

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