units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 51, DES_TP = 1 and MNG_AGENCY = 1
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- United States Bureau of Land Management · 1 ✖
DES_TP 1
- National Public Lands · 1 ✖
ACCESS_TYP 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11191 | 11191 | 11190 | {"type": "MultiPolygon", "coordinates": [[[[-119.58703, 38.71109], [-119.58428, 38.71109], [-119.58402, 38.71076], [-119.5835, 38.70993], [-119.58318, 38.70964], [-119.58296, 38.70953], [-119.58243, 38.70919], [-119.58229, 38.70904], [-119.58208, 38.70863], [-119.58202, 38.70845], [-119.58185, 38.70823], [-119.58135, 38.7078], [-119.58075, 38.70746], [-119.58055, 38.70728], [-119.58023, 38.70704], [-119.58111, 38.70704], [-119.58703, 38.71109]]], [[[-119.6544, 38.64097], [-119.65412, 38.64098], [-119.65431, 38.64829], [-119.64951, 38.64812], [-119.64981, 38.65179], [-119.64056, 38.65198], [-119.63602, 38.65204], [-119.63617, 38.65567], [-119.63167, 38.65577], [-119.63177, 38.65931], [-119.62279, 38.65938], [-119.62274, 38.663], [-119.61813, 38.6631], [-119.61293, 38.66315], [-119.61286, 38.66271], [-119.61289, 38.66219], [-119.61285, 38.66146], [-119.61287, 38.66125], [-119.61303, 38.66051], [-119.61317, 38.66006], [-119.61329, 38.65984], [-119.61338, 38.65955], [-119.61344, 38.65915], [-119.61334, 38.65876], [-119.61326, 38.65859], [-119.61288, 38.65798], [-119.61261, 38.65743], [-119.6124, 38.65683], [-119.61239, 38.65669], [-119.61247, 38.65644], [-119.61266, 38.65623], [-119.61288, 38.65595], [-119.61297, 38.65574], [-119.613, 38.65509], [-119.61309, 38.65412], [-119.61315, 38.65392], [-119.61323, 38.65372], [-119.61336, 38.65356], [-119.61363, 38.65312], [-119.61378, 38.65271], [-119.61391, 38.65217], [-119.61395, 38.65193], [-119.61396, 38.65161], [-119.61393, 38.65116], [-119.6139, 38.65095], [-119.61367, 38.65024], [-119.61369, 38.6501], [-119.61391, 38.6499], [-119.61423, 38.64977], [-119.61455, 38.64966], [-119.61511, 38.6494], [-119.61534, 38.64934], [-119.61567, 38.64915], [-119.61574, 38.64907], [-119.61587, 38.6488], [-119.61599, 38.64812], [-119.61609, 38.64778], [-119.61612, 38.64753], [-119.61613, 38.64693], [-119.61609, 38.64638], [-119.61612, 38.64632], [-119.61612, 38.64623], [-119.616, 38.64608], [-119.61609, 38.64566], [-119.61613, 38.64553], [-119.61625, 38.64531], [-119.61682, 38.64492], [-119.61689, 38.6448], [-119.61691, 38.64471], [-119.61689, 38.64456], [-119.61669, 38.64419], [-119.61663, 38.644], [-119.61657, 38.64352], [-119.61651, 38.64332], [-119.61638, 38.64312], [-119.61632, 38.64297], [-119.61613, 38.64236], [-119.61611, 38.64194], [-119.61612, 38.64186], [-119.61612, 38.64165], [-119.616, 38.64092], [-119.61563, 38.64008], [-119.61554, 38.63972], [-119.61543, 38.6395], [-119.61525, 38.63917], [-119.61487, 38.63873], [-119.61474, 38.6384], [-119.61472, 38.63801], [-119.61491, 38.637], [-119.615, 38.63676], [-119.61527, 38.63638], [-119.61531, 38.63628], [-119.61535, 38.63605], [-119.61532, 38.63567], [-119.61515, 38.63449], [-119.61515, 38.63428], [-119.61517, 38.63412], [-119.61529, 38.63379], [-119.61537, 38.63364], [-119.6156, 38.63349], [-119.61582, 38.6334], [-119.61662, 38.63299], [-119.61697, 38.63283], [-119.61748, 38.63266], [-119.61775, 38.63259], [-119.61805, 38.63245], [-119.61815, 38.63237], [-119.61827, 38.63223], [-119.61831, 38.63205], [-119.61834, 38.63199], [-119.61831, 38.6318], [-119.61815, 38.6316], [-119.61792, 38.63146], [-119.61777, 38.6314], [-119.61754, 38.63134], [-119.61735, 38.63126], [-119.61718, 38.63121], [-119.61699, 38.63107], [-119.61667, 38.63069], [-119.61647, 38.63038], [-119.61632, 38.63012], [-119.61625, 38.62992], [-119.61617, 38.62939], [-119.61616, 38.62915], [-119.61622, 38.62875], [-119.61625, 38.62867], [-119.6167, 38.62797], [-119.61692, 38.62757], [-119.61696, 38.62728], [-119.61689, 38.62704], [-119.61664, 38.62669], [-119.61657, 38.62661], [-119.61649, 38.62644], [-119.61638, 38.62595], [-119.61654, 38.62569], [-119.61676, 38.62553], [-119.6177, 38.62525], [-119.6179, 38.62518], [-119.61815, 38.62506], [-119.61834, 38.62499], [-119.61849, 38.62491], [-119.61883, 38.62452], [-119.61913, 38.62431], [-119.61957, 38.62393], [-119.61972, 38.62367], [-119.61981, 38.62333], [-119.61981, 38.62314], [-119.61976, 38.6229], [-119.61965, 38.62272], [-119.61896, 38.62181], [-119.61871, 38.62143], [-119.61861, 38.62108], [-119.61826, 38.62024], [-119.61821, 38.62005], [-119.61821, 38.61974], [-119.61823, 38.61963], [-119.61831, 38.61946], [-119.61849, 38.61933], [-119.61878, 38.6192], [-119.61887, 38.61907], [-119.61913, 38.61811], [-119.6192, 38.61793], [-119.61946, 38.61748], [-119.61962, 38.61712], [-119.62002, 38.616], [-119.6201, 38.6158], [-119.62021, 38.61496], [-119.62028, 38.61484], [-119.62043, 38.61469], [-119.62053, 38.61462], [-119.6207, 38.61442], [-119.62079, 38.61386], [-119.62095, 38.61356], [-119.62102, 38.61334], [-119.62104, 38.61315], [-119.62101, 38.61283], [-119.62092, 38.61249], [-119.62075, 38.61205], [-119.62067, 38.61192], [-119.62026, 38.61139], [-119.62014, 38.61119], [-119.62005, 38.61096], [-119.61995, 38.61053], [-119.61995, 38.61032], [-119.61991, 38.61006], [-119.61984, 38.60976], [-119.61965, 38.60926], [-119.61944, 38.60849], [-119.61939, 38.60835], [-119.61908, 38.60795], [-119.61901, 38.60781], [-119.61889, 38.60756], [-119.61873, 38.60715], [-119.61868, 38.60696], [-119.61861, 38.60655], [-119.61852, 38.60621], [-119.61851, 38.60577], [-119.61878, 38.60534], [-119.61913, 38.60474], [-119.61916, 38.6045], [-119.61913, 38.60433], [-119.61897, 38.60414], [-119.6188, 38.60399], [-119.61812, 38.60353], [-119.61745, 38.6032], [-119.61682, 38.60302], [-119.61626, 38.60291], [-119.61524, 38.60264], [-119.61461, 38.60234], [-119.61437, 38.60212], [-119.61368, 38.60132], [-119.61295, 38.60063], [-119.61269, 38.60043], [-119.61245, 38.60018], [-119.61172, 38.59958], [-119.6112, 38.59919], [-119.61104, 38.599], [-119.6109, 38.59878], [-119.6104, 38.59757], [-119.61019, 38.59713], [-119.61, 38.59689], [-119.60979, 38.59657], [-119.60944, 38.5959], [-119.60913, 38.59549], [-119.60891, 38.59526], [-119.60869, 38.59512], [-119.60843, 38.59502], [-119.6076, 38.59475], [-119.60714, 38.59465], [-119.6068, 38.5946], [-119.6064, 38.59456], [-119.60595, 38.59456], [-119.60509, 38.5947], [-119.60489, 38.59468], [-119.60371, 38.59426], [-119.60251, 38.594], [-119.60161, 38.59385], [-119.6012, 38.59374], [-119.60081, 38.59373], [-119.60042, 38.59367], [-119.59939, 38.59343], [-119.59908, 38.5933], [-119.5988, 38.59315], [-119.59858, 38.593], [-119.5981, 38.59262], [-119.59776, 38.59216], [-119.59753, 38.59171], [-119.59726, 38.59126], [-119.59704, 38.59104], [-119.59684, 38.59092], [-119.59663, 38.59084], [-119.59614, 38.59066], [-119.5959, 38.59058], [-119.59586, 38.59055], [-119.59579, 38.58396], [-119.59579, 38.58309], [-119.59591, 38.58273], [-119.59595, 38.58251], [-119.59595, 38.5823], [-119.5959, 38.58207], [-119.5958, 38.58194], [-119.59583, 38.57678], [-119.60443, 38.57684], [-119.61261, 38.57673], [-119.61258, 38.58008], [-119.60956, 38.58023], [-119.60964, 38.58368], [-119.61253, 38.58362], [-119.61253, 38.5841], [-119.61264, 38.59146], [-119.62172, 38.591], [-119.62616, 38.591], [-119.62621, 38.59459], [-119.63064, 38.59456], [-119.63965, 38.5946], [-119.63975, 38.60561], [-119.63047, 38.6056], [-119.63059, 38.60919], [-119.63977, 38.60924], [-119.6398, 38.62005], [-119.64453, 38.62004], [-119.6447, 38.6337], [-119.65383, 38.63367], [-119.65398, 38.6373], [-119.65419, 38.63731], [-119.6544, 38.64097]], [[-119.636, 38.65204], [-119.63601, 38.65203], [-119.63586, 38.64842], [-119.63128, 38.64844], [-119.63147, 38.6521], [-119.636, 38.65204]], [[-119.64481, 38.64117], [-119.64482, 38.64115], [-119.64467, 38.63743], [-119.63995, 38.63751], [-119.64013, 38.64132], [-119.64481, 38.64117]]], [[[-119.6216, 38.57223], [-119.6215, 38.57634], [-119.61252, 38.57669], [-119.61245, 38.57195], [-119.6216, 38.57223]]], [[[-119.6303, 38.74437], [-119.62566, 38.74114], [-119.62566, 38.73794], [-119.6303, 38.74104], [-119.6303, 38.74437]]], [[[-119.65794, 38.59097], [-119.63961, 38.59101], [-119.63058, 38.591], [-119.63062, 38.57981], [-119.63496, 38.57994], [-119.63502, 38.58402], [-119.63938, 38.58392], [-119.63948, 38.57634], [-119.64833, 38.57621], [-119.6572, 38.57617], [-119.65794, 38.59097]]], [[[-119.81342, 38.72386], [-119.80871, 38.72386], [-119.80873, 38.7202], [-119.79934, 38.7202], [-119.79929, 38.71837], [-119.79695, 38.71837], [-119.79699, 38.7202], [-119.79695, 38.72203], [-119.7993, 38.72203], [-119.79919, 38.72753], [-119.80868, 38.72753], [-119.80863, 38.73485], [-119.80878, 38.7385], [-119.80399, 38.73848], [-119.80386, 38.73485], [-119.79456, 38.73487], [-119.79477, 38.74204], [-119.79944, 38.74208], [-119.79956, 38.74567], [-119.80423, 38.7457], [-119.80448, 38.75289], [-119.79977, 38.75285], [-119.79966, 38.74926], [-119.79497, 38.74923], [-119.79486, 38.74564], [-119.79022, 38.74568], [-119.79046, 38.75287], [-119.78586, 38.75292], [-119.786, 38.75652], [-119.78136, 38.75656], [-119.78135, 38.75657], [-119.78155, 38.76016], [-119.79071, 38.76006], [-119.79084, 38.76365], [-119.79537, 38.7636], [-119.79542, 38.76538], [-119.78822, 38.76539], [-119.77927, 38.76536], [-119.77927, 38.76902], [-119.77002, 38.76907], [-119.77002, 38.77272], [-119.76074, 38.77272], [-119.76077, 38.77631], [-119.75613, 38.77632], [-119.75617, 38.77991], [-119.75152, 38.77991], [-119.75145, 38.77996], [-119.75131, 38.76546], [-119.75879, 38.7654], [-119.75692, 38.73491], [-119.74974, 38.73464], [-119.73933, 38.73417], [-119.72205, 38.73485], [-119.70479, 38.73512], [-119.70543, 38.7205], [-119.72188, 38.72031], [-119.72182, 38.71297], [-119.73478, 38.71274], [-119.73461, 38.71304], [-119.73458, 38.71674], [-119.74812, 38.71662], [-119.74856, 38.70925], [-119.75739, 38.70921], [-119.75774, 38.70556], [-119.74877, 38.70555], [-119.74875, 38.70553], [-119.74851, 38.69126], [-119.74854, 38.68763], [-119.75774, 38.68762], [-119.75773, 38.68398], [-119.77635, 38.68397], [-119.78557, 38.68405], [-119.78556, 38.68407], [-119.78558, 38.68774], [-119.77628, 38.68768], [-119.77629, 38.69137], [-119.77633, 38.69501], [-119.77169, 38.69496], [-119.77172, 38.69859], [-119.76708, 38.69852], [-119.76704, 38.69491], [-119.76242, 38.69486], [-119.76243, 38.70562], [-119.76192, 38.71294], [-119.76187, 38.7166], [-119.76666, 38.71663], [-119.76697, 38.70934], [-119.77173, 38.70941], [-119.77181, 38.70574], [-119.7765, 38.7058], [-119.77652, 38.71314], [-119.77595, 38.72025], [-119.78063, 38.72022], [-119.78057, 38.72388], [-119.78525, 38.72387], [-119.78531, 38.72019], [-119.79464, 38.7202], [-119.79446, 38.71286], [-119.79442, 38.70919], [-119.80372, 38.7092], [-119.80859, 38.70926], [-119.80863, 38.71288], [-119.81342, 38.71288], [-119.81344, 38.7202], [-119.81342, 38.72386]], [[-119.76893, 38.74224], [-119.76859, 38.73489], [-119.77094, 38.73486], [-119.77116, 38.72392], [-119.76409, 38.72392], [-119.76387, 38.7349], [-119.76463, 38.74225], [-119.76482, 38.74587], [-119.76916, 38.74584], [-119.76893, 38.74224]], [[-119.78045, 38.7312], [-119.78039, 38.73485], [-119.78511, 38.73485], [-119.78516, 38.7312], [-119.78045, 38.7312]]], [[[-119.74685, 38.79082], [-119.7422, 38.79083], [-119.74221, 38.79444], [-119.73756, 38.79445], [-119.73755, 38.79807], [-119.73291, 38.79807], [-119.73292, 38.80168], [-119.72826, 38.8017], [-119.72827, 38.80531], [-119.72362, 38.80531], [-119.72364, 38.80892], [-119.72362, 38.80896], [-119.71421, 38.80246], [-119.71422, 38.80174], [-119.71318, 38.80175], [-119.70954, 38.79923], [-119.70954, 38.79465], [-119.70958, 38.79464], [-119.7329, 38.79451], [-119.73291, 38.78], [-119.74683, 38.77997], [-119.74684, 38.78031], [-119.74685, 38.79082]]], [[[-119.73293, 38.81253], [-119.73292, 38.81534], [-119.72881, 38.81253], [-119.72895, 38.81254], [-119.73293, 38.81253]]], [[[-119.79746, 38.79449], [-119.78817, 38.79438], [-119.77462, 38.79448], [-119.7746, 38.79091], [-119.76995, 38.79096], [-119.76537, 38.7909], [-119.76535, 38.79808], [-119.76075, 38.79806], [-119.76073, 38.80169], [-119.75612, 38.8017], [-119.75609, 38.80532], [-119.75147, 38.80533], [-119.75144, 38.80895], [-119.73295, 38.80892], [-119.73293, 38.81048], [-119.73062, 38.80891], [-119.73293, 38.80892], [-119.73293, 38.8053], [-119.73754, 38.8053], [-119.73755, 38.80169], [-119.74683, 38.8017], [-119.74686, 38.79443], [-119.75151, 38.79442], [-119.75151, 38.79807], [-119.75612, 38.79806], [-119.75615, 38.79082], [-119.76077, 38.79084], [-119.76536, 38.7909], [-119.76534, 38.78733], [-119.75613, 38.78719], [-119.75615, 38.78357], [-119.76079, 38.78358], [-119.76081, 38.77991], [-119.77003, 38.78003], [-119.77466, 38.77998], [-119.77464, 38.78365], [-119.78819, 38.78351], [-119.79282, 38.78355], [-119.79282, 38.7908], [-119.79746, 38.79086], [-119.79746, 38.79449]]], [[[-119.75141, 38.82346], [-119.75139, 38.82803], [-119.74463, 38.82339], [-119.74497, 38.82344], [-119.75141, 38.82346]]], [[[-119.76984, 38.82343], [-119.76982, 38.82559], [-119.76659, 38.82345], [-119.76984, 38.82343], [-119.76984, 38.82343]]], [[[-119.77441, 38.82706], [-119.77439, 38.82886], [-119.77188, 38.82706], [-119.77441, 38.82706], [-119.77441, 38.82706]]], [[[-119.77901, 38.83066], [-119.779, 38.83215], [-119.77692, 38.83067], [-119.77901, 38.83066], [-119.77901, 38.83066]]], [[[-119.80532, 38.85962], [-119.79722, 38.85963], [-119.7928, 38.85658], [-119.79281, 38.85656], [-119.79279, 38.85237], [-119.79461, 38.85237], [-119.80532, 38.85962]]], [[[-119.79954, 38.68415], [-119.79954, 38.68778], [-119.79491, 38.68781], [-119.7949, 38.68415], [-119.79954, 38.68415]]], [[[-119.80425, 38.69147], [-119.80411, 38.69498], [-119.79941, 38.69497], [-119.79954, 38.69143], [-119.80416, 38.69141], [-119.80425, 38.69147]]], [[[-119.8254, 38.87905], [-119.82075, 38.87584], [-119.82075, 38.8742], [-119.81834, 38.87418], [-119.81612, 38.87265], [-119.8161, 38.87057], [-119.81307, 38.87055], [-119.81131, 38.86934], [-119.81138, 38.86695], [-119.80784, 38.86695], [-119.80682, 38.86625], [-119.8068, 38.85962], [-119.80674, 38.85257], [-119.82051, 38.85234], [-119.82065, 38.85963], [-119.82075, 38.86694], [-119.82076, 38.87419], [-119.82538, 38.8742], [-119.8254, 38.87905]]], [[[-119.83188, 38.74555], [-119.82785, 38.7456], [-119.82778, 38.74201], [-119.82303, 38.74207], [-119.82294, 38.73846], [-119.82769, 38.73843], [-119.82759, 38.73485], [-119.82749, 38.72753], [-119.82281, 38.72753], [-119.82285, 38.73485], [-119.81338, 38.73485], [-119.81341, 38.72753], [-119.8181, 38.72752], [-119.81811, 38.72386], [-119.83141, 38.72386], [-119.83163, 38.73485], [-119.83183, 38.74196], [-119.83188, 38.74555]]]]} | Open Access 1 | 21465 | 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 | Alpine 51 | 18668.411 | BLM | 1899 | 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]);