units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 27, MNG_AGENCY = 364 and MNG_AG_TYP = 1
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
- Federal Agency · 2 ✖
MNG_AGENCY 1
- United States Bureau of Reclamation · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3092 | 3092 | 3091 | {"type": "MultiPolygon", "coordinates": [[[[-122.50346, 40.63652], [-122.50346, 40.63912], [-122.50327, 40.63918], [-122.50131, 40.63907], [-122.49859, 40.63901], [-122.49788, 40.63902], [-122.49787, 40.63908], [-122.49371, 40.63742], [-122.49382, 40.63681], [-122.50346, 40.63652]]], [[[-122.52689, 40.65487], [-122.52646, 40.6586], [-122.52177, 40.65854], [-122.52219, 40.65493], [-122.52469, 40.65491], [-122.52521, 40.65444], [-122.5266, 40.65469], [-122.52689, 40.65487]]]]} | Open Access 1 | 25177 | Ash Creek WA | 15647 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Shasta 27 | 87.712 | Ash Creek WA | None 251 | |||
11204 | 11204 | 11203 | {"type": "MultiPolygon", "coordinates": [[[[-122.45756, 40.67521], [-122.45621, 40.67521], [-122.45621, 40.67638], [-122.45598, 40.67667], [-122.45483, 40.6774], [-122.45392, 40.6778], [-122.45344, 40.67811], [-122.45296, 40.67853], [-122.45252, 40.67898], [-122.45076, 40.68029], [-122.45042, 40.68068], [-122.44957, 40.68214], [-122.44926, 40.68279], [-122.44898, 40.68375], [-122.44897, 40.68427], [-122.44887, 40.68479], [-122.4491, 40.6849], [-122.44919, 40.685], [-122.44948, 40.68577], [-122.44978, 40.68603], [-122.44981, 40.68642], [-122.45001, 40.68708], [-122.45001, 40.68787], [-122.44971, 40.68884], [-122.44945, 40.68944], [-122.44919, 40.6896], [-122.44929, 40.68986], [-122.44924, 40.69008], [-122.44878, 40.69027], [-122.44838, 40.69051], [-122.44796, 40.69106], [-122.44781, 40.69154], [-122.44779, 40.69199], [-122.44767, 40.69239], [-122.44738, 40.69283], [-122.44731, 40.69327], [-122.44742, 40.69368], [-122.44744, 40.69395], [-122.44851, 40.69474], [-122.44931, 40.69556], [-122.44958, 40.69577], [-122.44984, 40.69608], [-122.45009, 40.69614], [-122.45064, 40.6969], [-122.45072, 40.69739], [-122.45067, 40.69792], [-122.45014, 40.69883], [-122.44962, 40.69958], [-122.44971, 40.69995], [-122.4496, 40.70015], [-122.44922, 40.70038], [-122.44854, 40.70066], [-122.44816, 40.70103], [-122.44775, 40.70134], [-122.44744, 40.70151], [-122.44696, 40.70187], [-122.4468, 40.70208], [-122.4466, 40.70249], [-122.44624, 40.70304], [-122.44585, 40.7031], [-122.44492, 40.70377], [-122.44417, 40.70405], [-122.44362, 40.7043], [-122.44348, 40.70452], [-122.44295, 40.70456], [-122.44274, 40.70481], [-122.44213, 40.70512], [-122.44143, 40.70565], [-122.44088, 40.70632], [-122.44071, 40.70666], [-122.44054, 40.70756], [-122.44069, 40.70811], [-122.44043, 40.70874], [-122.44033, 40.7091], [-122.44018, 40.70938], [-122.43991, 40.70962], [-122.43934, 40.71003], [-122.43899, 40.71018], [-122.43759, 40.71062], [-122.43741, 40.71065], [-122.43732, 40.71092], [-122.42953, 40.70959], [-122.41128, 40.70971], [-122.41136, 40.70581], [-122.41194, 40.70582], [-122.41648, 40.70578], [-122.41645, 40.704], [-122.42099, 40.70398], [-122.42082, 40.69839], [-122.41631, 40.69851], [-122.41621, 40.69497], [-122.42502, 40.69468], [-122.42502, 40.69447], [-122.429, 40.69434], [-122.429, 40.69453], [-122.42898, 40.69455], [-122.42961, 40.70592], [-122.42998, 40.70598], [-122.43004, 40.70772], [-122.43411, 40.70836], [-122.43411, 40.7066], [-122.43823, 40.70733], [-122.43811, 40.70361], [-122.44021, 40.70397], [-122.44024, 40.69987], [-122.44241, 40.70017], [-122.44246, 40.6981], [-122.44257, 40.69612], [-122.44255, 40.69612], [-122.44374, 40.67997], [-122.44775, 40.67998], [-122.44795, 40.66899], [-122.45212, 40.66899], [-122.45196, 40.66548], [-122.44784, 40.66556], [-122.4477, 40.66166], [-122.44763, 40.66167], [-122.43733, 40.66157], [-122.438, 40.66033], [-122.43799, 40.66032], [-122.43614, 40.65976], [-122.4351, 40.66061], [-122.4346, 40.6603], [-122.43458, 40.65973], [-122.436, 40.65925], [-122.436, 40.65924], [-122.4345, 40.65709], [-122.43432, 40.65389], [-122.43263, 40.65399], [-122.43423, 40.65219], [-122.43413, 40.65044], [-122.43485, 40.64162], [-122.43977, 40.64163], [-122.43995, 40.63608], [-122.44734, 40.63594], [-122.44723, 40.62507], [-122.44722, 40.62506], [-122.44419, 40.6251], [-122.44427, 40.62141], [-122.44035, 40.62147], [-122.43981, 40.61053], [-122.43085, 40.60715], [-122.43511, 40.60709], [-122.43964, 40.607], [-122.44567, 40.60709], [-122.44568, 40.60707], [-122.44558, 40.60689], [-122.44559, 40.60683], [-122.44571, 40.60682], [-122.44582, 40.60729], [-122.44586, 40.60824], [-122.44574, 40.60924], [-122.4455, 40.60988], [-122.44544, 40.61036], [-122.44548, 40.61069], [-122.44554, 40.61082], [-122.44542, 40.61109], [-122.44515, 40.6111], [-122.44494, 40.61115], [-122.44502, 40.61155], [-122.44473, 40.61216], [-122.44464, 40.61259], [-122.4445, 40.61296], [-122.44438, 40.61306], [-122.44456, 40.61346], [-122.44446, 40.61394], [-122.44402, 40.61509], [-122.44406, 40.61553], [-122.44419, 40.61605], [-122.44419, 40.61658], [-122.44414, 40.61703], [-122.4443, 40.61744], [-122.44411, 40.6179], [-122.4436, 40.61833], [-122.44311, 40.61865], [-122.44305, 40.61878], [-122.44307, 40.61879], [-122.44364, 40.61857], [-122.44447, 40.61836], [-122.44469, 40.61878], [-122.4448, 40.61918], [-122.44468, 40.61948], [-122.44543, 40.62029], [-122.44557, 40.62051], [-122.44554, 40.62086], [-122.44573, 40.62206], [-122.44588, 40.622], [-122.44617, 40.6217], [-122.44667, 40.62187], [-122.44726, 40.62268], [-122.44774, 40.62296], [-122.44777, 40.62314], [-122.44765, 40.62347], [-122.44789, 40.62351], [-122.44817, 40.62371], [-122.4481, 40.62392], [-122.44814, 40.62418], [-122.44809, 40.6245], [-122.44846, 40.62456], [-122.44875, 40.62441], [-122.44899, 40.6244], [-122.4491, 40.62443], [-122.44908, 40.62443], [-122.44907, 40.62444], [-122.44924, 40.62526], [-122.4485, 40.62536], [-122.44852, 40.62899], [-122.44842, 40.62915], [-122.44821, 40.62934], [-122.44823, 40.62962], [-122.44839, 40.62967], [-122.44864, 40.63005], [-122.44876, 40.63055], [-122.44873, 40.63083], [-122.44885, 40.63105], [-122.44895, 40.63142], [-122.44888, 40.63174], [-122.44896, 40.63192], [-122.4492, 40.63212], [-122.44928, 40.63252], [-122.44928, 40.633], [-122.44916, 40.63315], [-122.44952, 40.63352], [-122.44929, 40.63532], [-122.4489, 40.63571], [-122.44861, 40.63608], [-122.44821, 40.63634], [-122.44676, 40.63708], [-122.44632, 40.63736], [-122.44558, 40.63806], [-122.44511, 40.63837], [-122.44476, 40.63838], [-122.44463, 40.63872], [-122.44443, 40.63909], [-122.44415, 40.63935], [-122.44379, 40.63985], [-122.44349, 40.64016], [-122.4436, 40.64054], [-122.44337, 40.64098], [-122.44315, 40.64154], [-122.44286, 40.64272], [-122.4428, 40.64315], [-122.44266, 40.64325], [-122.44265, 40.64365], [-122.44212, 40.64464], [-122.44139, 40.64547], [-122.44085, 40.64586], [-122.44053, 40.64629], [-122.44033, 40.64669], [-122.44009, 40.64698], [-122.43956, 40.64696], [-122.43982, 40.64759], [-122.43937, 40.64825], [-122.43929, 40.64867], [-122.4389, 40.64924], [-122.43825, 40.64954], [-122.43839, 40.64984], [-122.4383, 40.65024], [-122.43745, 40.65184], [-122.43713, 40.65217], [-122.43761, 40.6534], [-122.43805, 40.65398], [-122.438, 40.65437], [-122.43804, 40.65463], [-122.43828, 40.655], [-122.43823, 40.65612], [-122.4383, 40.65675], [-122.4386, 40.65728], [-122.43867, 40.65739], [-122.43903, 40.65769], [-122.43933, 40.65802], [-122.43984, 40.65842], [-122.43962, 40.65863], [-122.43962, 40.65865], [-122.43983, 40.65875], [-122.44051, 40.65886], [-122.44079, 40.65867], [-122.44159, 40.65882], [-122.44107, 40.65894], [-122.44106, 40.65895], [-122.442, 40.66072], [-122.44311, 40.66047], [-122.44307, 40.66035], [-122.44364, 40.66028], [-122.44327, 40.65867], [-122.44393, 40.65871], [-122.44539, 40.65868], [-122.44578, 40.65846], [-122.44772, 40.65837], [-122.44788, 40.65826], [-122.44839, 40.65816], [-122.44966, 40.65809], [-122.45, 40.65799], [-122.45078, 40.65808], [-122.45219, 40.65838], [-122.45268, 40.65828], [-122.4533, 40.65841], [-122.4535, 40.65852], [-122.45403, 40.65854], [-122.45473, 40.65869], [-122.45513, 40.65893], [-122.45549, 40.6589], [-122.45605, 40.65926], [-122.45635, 40.65973], [-122.45627, 40.65996], [-122.45633, 40.66016], [-122.45678, 40.65956], [-122.45755, 40.66001], [-122.45809, 40.6602], [-122.4585, 40.66048], [-122.45875, 40.66092], [-122.45882, 40.66138], [-122.45887, 40.66264], [-122.45874, 40.66298], [-122.45884, 40.66344], [-122.45878, 40.66398], [-122.45863, 40.66466], [-122.45858, 40.66616], [-122.4589, 40.66787], [-122.45911, 40.66845], [-122.45933, 40.6688], [-122.4595, 40.66923], [-122.45976, 40.67102], [-122.45975, 40.6718], [-122.4595, 40.67264], [-122.45934, 40.67304], [-122.45828, 40.67431], [-122.45794, 40.67455], [-122.4577, 40.67485], [-122.45756, 40.67521]], [[-122.42475, 40.70218], [-122.42544, 40.70294], [-122.42689, 40.70203], [-122.42559, 40.70055], [-122.42456, 40.69923], [-122.42332, 40.69563], [-122.42144, 40.69519], [-122.42187, 40.69651], [-122.42113, 40.69692], [-122.42069, 40.69748], [-122.42291, 40.69987], [-122.4228, 40.69995], [-122.4228, 40.69996], [-122.42401, 40.7014], [-122.42247, 40.70131], [-122.42254, 40.7024], [-122.42421, 40.70253], [-122.42475, 40.70218]]], [[[-122.49508, 40.62432], [-122.49509, 40.62488], [-122.49498, 40.63019], [-122.49329, 40.63032], [-122.49335, 40.6315], [-122.49498, 40.63158], [-122.49498, 40.63431], [-122.49357, 40.63436], [-122.4935, 40.63643], [-122.49382, 40.63681], [-122.4918, 40.63683], [-122.49179, 40.63685], [-122.4918, 40.63686], [-122.48463, 40.63706], [-122.46669, 40.63721], [-122.46553, 40.6372], [-122.46557, 40.63512], [-122.46666, 40.63549], [-122.46986, 40.63549], [-122.46989, 40.63247], [-122.46988, 40.63149], [-122.46565, 40.63141], [-122.46553, 40.63109], [-122.46258, 40.63184], [-122.46049, 40.6326], [-122.46048, 40.63155], [-122.45995, 40.63162], [-122.45982, 40.63272], [-122.45786, 40.63305], [-122.45676, 40.63319], [-122.45678, 40.63646], [-122.45644, 40.63644], [-122.45643, 40.63651], [-122.4528, 40.63631], [-122.45255, 40.63981], [-122.45578, 40.63988], [-122.45574, 40.63951], [-122.45593, 40.63866], [-122.45618, 40.63773], [-122.45642, 40.6372], [-122.45641, 40.63849], [-122.45615, 40.63945], [-122.45616, 40.63974], [-122.45639, 40.64032], [-122.45633, 40.64701], [-122.44771, 40.64575], [-122.44758, 40.64702], [-122.44748, 40.64704], [-122.4474, 40.64883], [-122.44307, 40.64879], [-122.44292, 40.65075], [-122.44732, 40.65083], [-122.44741, 40.65372], [-122.44749, 40.65483], [-122.45973, 40.65553], [-122.46271, 40.65565], [-122.46267, 40.6523], [-122.46485, 40.65246], [-122.4649, 40.6532], [-122.46491, 40.65321], [-122.46668, 40.65304], [-122.46663, 40.65229], [-122.46864, 40.65209], [-122.47274, 40.65266], [-122.47287, 40.65173], [-122.47454, 40.65161], [-122.4746, 40.65171], [-122.47445, 40.6584], [-122.4749, 40.65841], [-122.47479, 40.66024], [-122.46984, 40.66024], [-122.46977, 40.66173], [-122.46649, 40.66201], [-122.46649, 40.66136], [-122.46357, 40.66129], [-122.46355, 40.66163], [-122.46191, 40.6616], [-122.46187, 40.66257], [-122.46175, 40.66318], [-122.46162, 40.6637], [-122.46134, 40.66434], [-122.46139, 40.66454], [-122.46262, 40.66456], [-122.46296, 40.66492], [-122.46127, 40.66493], [-122.46108, 40.66565], [-122.46106, 40.6659], [-122.46258, 40.66614], [-122.46271, 40.66945], [-122.46459, 40.66943], [-122.46433, 40.67668], [-122.46184, 40.67666], [-122.46175, 40.67846], [-122.46169, 40.67933], [-122.461, 40.67931], [-122.46096, 40.67524], [-122.46025, 40.67522], [-122.45942, 40.67633], [-122.45884, 40.67683], [-122.45791, 40.67742], [-122.45621, 40.67832], [-122.45622, 40.67928], [-122.45961, 40.67937], [-122.45965, 40.68052], [-122.45971, 40.68054], [-122.45969, 40.68058], [-122.45369, 40.68027], [-122.45336, 40.68069], [-122.4526, 40.68099], [-122.45241, 40.68122], [-122.45241, 40.68477], [-122.45117, 40.68477], [-122.45182, 40.68554], [-122.45319, 40.68525], [-122.45417, 40.6858], [-122.45409, 40.68678], [-122.45305, 40.68632], [-122.45188, 40.68664], [-122.45191, 40.6873], [-122.45212, 40.68825], [-122.45216, 40.68942], [-122.45171, 40.6911], [-122.45095, 40.69223], [-122.45582, 40.69233], [-122.45591, 40.69652], [-122.45525, 40.69653], [-122.45523, 40.69655], [-122.45291, 40.69654], [-122.45291, 40.69701], [-122.45288, 40.69748], [-122.45275, 40.69777], [-122.45256, 40.69808], [-122.45246, 40.69849], [-122.45233, 40.69888], [-122.45213, 40.69924], [-122.45194, 40.69979], [-122.45148, 40.70051], [-122.45119, 40.70091], [-122.45048, 40.70143], [-122.44989, 40.70197], [-122.44814, 40.70304], [-122.44736, 40.70374], [-122.44648, 40.70423], [-122.44603, 40.70454], [-122.44557, 40.70491], [-122.44417, 40.70566], [-122.44365, 40.70597], [-122.4432, 40.70644], [-122.44278, 40.7074], [-122.44265, 40.70784], [-122.44239, 40.70885], [-122.44181, 40.70981], [-122.4417, 40.71015], [-122.44157, 40.71044], [-122.44125, 40.71056], [-122.4404, 40.71099], [-122.43969, 40.71088], [-122.43986, 40.71073], [-122.44069, 40.71035], [-122.44097, 40.71], [-122.44093, 40.7097], [-122.44139, 40.70903], [-122.4416, 40.7088], [-122.4416, 40.70841], [-122.44181, 40.70802], [-122.44191, 40.70755], [-122.44168, 40.70716], [-122.44212, 40.70683], [-122.44248, 40.70621], [-122.44264, 40.70602], [-122.44294, 40.70581], [-122.44314, 40.70558], [-122.44361, 40.70538], [-122.44382, 40.70508], [-122.44456, 40.70472], [-122.44479, 40.70449], [-122.44509, 40.70441], [-122.44533, 40.70414], [-122.4457, 40.70407], [-122.44668, 40.70357], [-122.44699, 40.7033], [-122.44774, 40.70244], [-122.44794, 40.70227], [-122.44829, 40.70188], [-122.44884, 40.70145], [-122.44928, 40.70128], [-122.44972, 40.70083], [-122.45009, 40.70052], [-122.45054, 40.70027], [-122.45122, 40.69943], [-122.45135, 40.69885], [-122.4516, 40.69862], [-122.4518, 40.69825], [-122.45189, 40.69789], [-122.45191, 40.69739], [-122.45168, 40.6971], [-122.4514, 40.69707], [-122.45138, 40.69672], [-122.45146, 40.69638], [-122.45156, 40.69626], [-122.45129, 40.69586], [-122.4509, 40.69568], [-122.45027, 40.69522], [-122.45005, 40.69491], [-122.44943, 40.69447], [-122.44914, 40.69381], [-122.44914, 40.69346], [-122.44981, 40.6925], [-122.45006, 40.69204], [-122.45073, 40.69112], [-122.45091, 40.69069], [-122.45102, 40.68988], [-122.45114, 40.68947], [-122.45151, 40.68855], [-122.45091, 40.68573], [-122.45076, 40.68534], [-122.45043, 40.68475], [-122.4501, 40.68429], [-122.45007, 40.68355], [-122.4505, 40.68247], [-122.45104, 40.68163], [-122.45147, 40.68118], [-122.45188, 40.68089], [-122.45256, 40.68022], [-122.45311, 40.67993], [-122.4538, 40.67935], [-122.45433, 40.67904], [-122.45606, 40.6775], [-122.45643, 40.67721], [-122.45736, 40.67672], [-122.45769, 40.67647], [-122.45785, 40.67629], [-122.45823, 40.67601], [-122.4585, 40.67522], [-122.45899, 40.67506], [-122.4592, 40.67511], [-122.45945, 40.67505], [-122.46006, 40.67448], [-122.46062, 40.67375], [-122.46099, 40.67301], [-122.46112, 40.67256], [-122.46121, 40.6719], [-122.46092, 40.67047], [-122.46079, 40.66929], [-122.46063, 40.66875], [-122.4604, 40.66827], [-122.46017, 40.66731], [-122.46012, 40.66674], [-122.46022, 40.6664], [-122.46028, 40.66535], [-122.46056, 40.66411], [-122.46104, 40.66312], [-122.461, 40.66298], [-122.46117, 40.66224], [-122.46115, 40.66183], [-122.46105, 40.66136], [-122.46027, 40.65989], [-122.45997, 40.6596], [-122.45944, 40.65927], [-122.45878, 40.65902], [-122.45685, 40.65809], [-122.45454, 40.65717], [-122.45389, 40.65695], [-122.45286, 40.65667], [-122.45201, 40.6565], [-122.45133, 40.65649], [-122.45089, 40.65654], [-122.45054, 40.65653], [-122.44866, 40.65701], [-122.44811, 40.6572], [-122.44751, 40.65732], [-122.44671, 40.65743], [-122.44356, 40.65771], [-122.44268, 40.65772], [-122.44171, 40.65763], [-122.44083, 40.65717], [-122.44045, 40.65652], [-122.44037, 40.65579], [-122.44037, 40.65536], [-122.43991, 40.65423], [-122.43904, 40.65267], [-122.43888, 40.65207], [-122.43929, 40.65119], [-122.43991, 40.65035], [-122.44028, 40.64993], [-122.44069, 40.6491], [-122.44092, 40.64892], [-122.44128, 40.64855], [-122.44187, 40.64776], [-122.4421, 40.64738], [-122.44244, 40.64651], [-122.4428, 40.646], [-122.44389, 40.64374], [-122.44436, 40.64213], [-122.44446, 40.64124], [-122.44459, 40.64087], [-122.44486, 40.64045], [-122.44497, 40.64018], [-122.44542, 40.63978], [-122.44677, 40.63887], [-122.44718, 40.63854], [-122.44748, 40.63841], [-122.44785, 40.63836], [-122.44825, 40.63798], [-122.44849, 40.63787], [-122.44873, 40.63781], [-122.44901, 40.6376], [-122.44926, 40.63752], [-122.44983, 40.63758], [-122.45031, 40.63727], [-122.45032, 40.63712], [-122.4505, 40.63677], [-122.45107, 40.6364], [-122.45119, 40.63613], [-122.45125, 40.63544], [-122.4514, 40.63502], [-122.45155, 40.63371], [-122.45175, 40.6333], [-122.45242, 40.63278], [-122.45192, 40.63269], [-122.45172, 40.63242], [-122.45175, 40.63195], [-122.45188, 40.63177], [-122.45177, 40.63143], [-122.45183, 40.63091], [-122.4521, 40.63047], [-122.45246, 40.63028], [-122.45269, 40.63009], [-122.45336, 40.63017], [-122.45372, 40.63039], [-122.45387, 40.63061], [-122.45389, 40.6308], [-122.45408, 40.63088], [-122.45461, 40.63075], [-122.45582, 40.63091], [-122.45803, 40.63097], [-122.45858, 40.63085], [-122.45954, 40.63045], [-122.45979, 40.63059], [-122.46019, 40.63068], [-122.46057, 40.63046], [-122.4607, 40.63025], [-122.46065, 40.63001], [-122.46035, 40.62982], [-122.45932, 40.62973], [-122.45853, 40.62972], [-122.45798, 40.62979], [-122.45772, 40.62997], [-122.45637, 40.63015], [-122.45429, 40.62936], [-122.45377, 40.62906], [-122.45376, 40.62867], [-122.45399, 40.6282], [-122.4567, 40.62839], [-122.45675, 40.62972], [-122.45742, 40.62967], [-122.4574, 40.62814], [-122.45771, 40.62658], [-122.45887, 40.62678], [-122.45887, 40.62637], [-122.46091, 40.62637], [-122.46094, 40.6273], [-122.46114, 40.62721], [-122.4635, 40.62785], [-122.46571, 40.62841], [-122.46578, 40.62591], [-122.4657, 40.62411], [-122.46572, 40.62359], [-122.46572, 40.62277], [-122.46753, 40.62282], [-122.46755, 40.62306], [-122.46844, 40.62305], [-122.46845, 40.62285], [-122.46917, 40.62286], [-122.47077, 40.62217], [-122.47938, 40.62151], [-122.47502, 40.62297], [-122.47501, 40.62392], [-122.47602, 40.62458], [-122.48231, 40.6223], [-122.48231, 40.62229], [-122.48169, 40.62134], [-122.48485, 40.62111], [-122.4902, 40.62112], [-122.49171, 40.62119], [-122.49172, 40.62118], [-122.4917, 40.62112], [-122.49389, 40.62113], [-122.49387, 40.62127], [-122.49388, 40.6243], [-122.49508, 40.62432]], [[-122.46069, 40.62801], [-122.46071, 40.628], [-122.4606, 40.62744], [-122.45995, 40.62775], [-122.46069, 40.62801]], [[-122.46211, 40.62817], [-122.4614, 40.62762], [-122.4612, 40.62815], [-122.46192, 40.62819], [-122.46197, 40.62832], [-122.46236, 40.62824], [-122.46211, 40.62817]], [[-122.46567, 40.62897], [-122.46575, 40.62895], [-122.46576, 40.62893], [-122.4644, 40.62842], [-122.46442, 40.62923], [-122.46546, 40.62901], [-122.46576, 40.629], [-122.46576, 40.62898], [-122.46567, 40.62897]]], [[[-122.45886, 40.62598], [-122.45659, 40.62591], [-122.45417, 40.62566], [-122.45415, 40.62609], [-122.45417, 40.62556], [-122.45406, 40.62539], [-122.45385, 40.62489], [-122.45381, 40.62488], [-122.45385, 40.62452], [-122.45367, 40.62431], [-122.45285, 40.62374], [-122.45079, 40.62273], [-122.45012, 40.62225], [-122.44954, 40.62173], [-122.44944, 40.62149], [-122.44949, 40.62123], [-122.44994, 40.62073], [-122.44996, 40.62063], [-122.44955, 40.62062], [-122.44878, 40.62073], [-122.44845, 40.62053], [-122.4484, 40.62041], [-122.4484, 40.62028], [-122.44804, 40.61979], [-122.44803, 40.61952], [-122.44788, 40.61938], [-122.44794, 40.61906], [-122.44818, 40.61861], [-122.44749, 40.61885], [-122.44714, 40.61871], [-122.44674, 40.618], [-122.4466, 40.61746], [-122.44656, 40.61683], [-122.44665, 40.61578], [-122.44671, 40.61558], [-122.4469, 40.61547], [-122.44736, 40.61547], [-122.44785, 40.61551], [-122.44821, 40.61544], [-122.44828, 40.61536], [-122.4476, 40.61513], [-122.44676, 40.61477], [-122.44666, 40.61454], [-122.44666, 40.61428], [-122.44682, 40.61408], [-122.447, 40.61401], [-122.44714, 40.61389], [-122.44707, 40.61377], [-122.44676, 40.61355], [-122.44661, 40.61324], [-122.44712, 40.61213], [-122.44671, 40.61151], [-122.44655, 40.61152], [-122.4465, 40.61089], [-122.44622, 40.61075], [-122.44592, 40.6105], [-122.44595, 40.6101], [-122.44618, 40.60936], [-122.44632, 40.60865], [-122.44623, 40.60837], [-122.44637, 40.60811], [-122.44637, 40.60749], [-122.4463, 40.6068], [-122.4464, 40.6068], [-122.44661, 40.60686], [-122.44707, 40.60715], [-122.44779, 40.6077], [-122.44837, 40.60806], [-122.44867, 40.60818], [-122.44868, 40.60817], [-122.44866, 40.60701], [-122.45278, 40.60733], [-122.45277, 40.60901], [-122.45243, 40.60901], [-122.45239, 40.61449], [-122.45215, 40.62204], [-122.4558, 40.62257], [-122.45612, 40.6226], [-122.45644, 40.6226], [-122.45645, 40.62304], [-122.45672, 40.62305], [-122.45673, 40.6239], [-122.45846, 40.6239], [-122.45847, 40.62415], [-122.45883, 40.62416], [-122.45886, 40.62598]]], [[[-122.48433, 40.67558], [-122.4792, 40.6759], [-122.47906, 40.6726], [-122.48348, 40.67369], [-122.48406, 40.67306], [-122.48407, 40.67228], [-122.48053, 40.67135], [-122.48176, 40.67012], [-122.48175, 40.6701], [-122.47735, 40.66851], [-122.47659, 40.66923], [-122.4766, 40.66709], [-122.47706, 40.66706], [-122.48159, 40.66866], [-122.48423, 40.66834], [-122.48422, 40.66896], [-122.48433, 40.67558]]]]} | Open Access 1 | 21513 | United States Bureau of Reclamation | 13858 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Shasta 27 | 4330.745 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 4 |
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]);