units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where ACCESS_TYP = 1 and DES_TP = 105 sorted by MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15859 | 15859 | 15858 | {"type": "Polygon", "coordinates": [[[-122.00249, 39.57458], [-122.00235, 39.5755], [-122.00192, 39.576], [-122.00109, 39.57749], [-121.99926, 39.57891], [-121.99817, 39.57969], [-121.99802, 39.57977], [-121.99813, 39.57796], [-121.99846, 39.57666], [-121.99896, 39.57572], [-121.99954, 39.57505], [-122.00056, 39.57444], [-122.00039, 39.57489], [-122.00046, 39.57508], [-122.00099, 39.57478], [-122.00141, 39.57471], [-122.00233, 39.57433], [-122.00249, 39.57458]]]} | Open Access 1 | 44505 | Sacramento River National Wildlife Refuge | 13934 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/refuge/sacramento_river/ | Butte 42 | 28.065 | Sacramento River NWR | 1989 | National Wildlife Refuge 105 | 2 |
15863 | 15863 | 15862 | {"type": "MultiPolygon", "coordinates": [[[[-117.1224, 32.59828], [-117.12207, 32.59885], [-117.11716, 32.59546], [-117.11515, 32.59482], [-117.11503, 32.59405], [-117.11241, 32.59327], [-117.11025, 32.59329], [-117.10748, 32.5947], [-117.10747, 32.59472], [-117.10785, 32.59544], [-117.10556, 32.59675], [-117.10535, 32.59862], [-117.10509, 32.60151], [-117.10412, 32.60232], [-117.10235, 32.60392], [-117.10065, 32.60418], [-117.0985, 32.60523], [-117.09818, 32.60519], [-117.09805, 32.60689], [-117.09875, 32.60901], [-117.09863, 32.60984], [-117.0988, 32.61037], [-117.09841, 32.61236], [-117.09592, 32.61163], [-117.09606, 32.61062], [-117.09626, 32.61002], [-117.09618, 32.60967], [-117.09528, 32.60833], [-117.09524, 32.60766], [-117.09464, 32.60685], [-117.09424, 32.60674], [-117.09388, 32.60586], [-117.09397, 32.60586], [-117.09402, 32.60477], [-117.09407, 32.60476], [-117.09456, 32.60103], [-117.09339, 32.60089], [-117.09276, 32.60077], [-117.09285, 32.59869], [-117.09295, 32.59868], [-117.09296, 32.59823], [-117.09301, 32.59774], [-117.09343, 32.59671], [-117.09402, 32.59611], [-117.09712, 32.594], [-117.09712, 32.59392], [-117.10133, 32.59103], [-117.10132, 32.59085], [-117.09712, 32.59374], [-117.0971, 32.58904], [-117.10134, 32.58922], [-117.10134, 32.58948], [-117.10186, 32.5895], [-117.10408, 32.588], [-117.10557, 32.58755], [-117.10558, 32.58818], [-117.10595, 32.58805], [-117.10626, 32.58796], [-117.10676, 32.58789], [-117.10716, 32.58788], [-117.10757, 32.58792], [-117.10793, 32.58799], [-117.10895, 32.58831], [-117.10919, 32.58859], [-117.10932, 32.58882], [-117.10933, 32.58886], [-117.10944, 32.58904], [-117.10957, 32.58919], [-117.10969, 32.58928], [-117.10977, 32.58955], [-117.10998, 32.58969], [-117.11059, 32.58967], [-117.11112, 32.58959], [-117.11162, 32.58956], [-117.11182, 32.5895], [-117.11182, 32.58943], [-117.112, 32.58943], [-117.11226, 32.58946], [-117.11292, 32.58961], [-117.11332, 32.58965], [-117.11461, 32.59036], [-117.11477, 32.59053], [-117.11498, 32.59068], [-117.1161, 32.59115], [-117.11648, 32.59126], [-117.11684, 32.59134], [-117.11751, 32.59137], [-117.11778, 32.59134], [-117.11842, 32.59139], [-117.11837, 32.59142], [-117.11838, 32.59144], [-117.1193, 32.59151], [-117.11999, 32.59172], [-117.12088, 32.59216], [-117.12108, 32.59229], [-117.12132, 32.59247], [-117.12153, 32.59266], [-117.12183, 32.59299], [-117.12196, 32.59317], [-117.1221, 32.59341], [-117.12227, 32.5938], [-117.12237, 32.59419], [-117.12229, 32.59687], [-117.12227, 32.59688], [-117.12226, 32.59733], [-117.12224, 32.59743], [-117.12224, 32.59757], [-117.12234, 32.59805], [-117.1224, 32.59828]]], [[[-117.10811, 32.5879], [-117.10787, 32.58784], [-117.1075, 32.58777], [-117.10718, 32.58775], [-117.10696, 32.58775], [-117.10696, 32.58758], [-117.108, 32.58758], [-117.10803, 32.58772], [-117.10811, 32.5879]]], [[[-117.11454, 32.59024], [-117.11454, 32.59024], [-117.11347, 32.58967], [-117.11393, 32.58968], [-117.11412, 32.58972], [-117.1142, 32.58976], [-117.11439, 32.58992], [-117.11443, 32.58999], [-117.11454, 32.59024]]], [[[-117.12232, 32.59233], [-117.12072, 32.59168], [-117.1201, 32.59147], [-117.11983, 32.5914], [-117.11945, 32.59133], [-117.11861, 32.59124], [-117.11864, 32.58762], [-117.11997, 32.58761], [-117.12059, 32.58709], [-117.1209, 32.58698], [-117.12109, 32.58698], [-117.12132, 32.58759], [-117.12148, 32.58761], [-117.12166, 32.58797], [-117.12181, 32.58835], [-117.12196, 32.58886], [-117.12198, 32.58891], [-117.12175, 32.58899], [-117.12159, 32.58912], [-117.12178, 32.58947], [-117.12201, 32.59009], [-117.12216, 32.59031], [-117.12232, 32.59233]]], [[[-117.12241, 32.59358], [-117.12226, 32.59325], [-117.12207, 32.59296], [-117.12187, 32.59272], [-117.12157, 32.59243], [-117.12131, 32.59224], [-117.1209, 32.59202], [-117.12234, 32.59256], [-117.12241, 32.59339], [-117.12241, 32.59358]]]]} | Open Access 1 | 44825 | San Diego Bay National Wildlife Refuge | 13940 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/refuge/san_diego_bay/ | San Diego 4 | 721.883 | San Diego Bay NWR | 1988 | National Wildlife Refuge 105 | 2 |
1165 | 1165 | 1164 | {"type": "Polygon", "coordinates": [[[-116.90615, 32.72851], [-116.90484, 32.7283], [-116.90399, 32.72803], [-116.90394, 32.72518], [-116.90608, 32.72533], [-116.90615, 32.72851]]]} | Open Access 1 | 7381 | San Diego National Wildlife Refuge | 24858 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | San Diego 4 | 16.779 | San Diego NWR | 1996 | National Wildlife Refuge 105 | 2 | ||
15842 | 15842 | 15841 | {"type": "Polygon", "coordinates": [[[-121.22614, 41.89233], [-121.22612, 41.8925], [-121.22573, 41.89277], [-121.22273, 41.89414], [-121.22233, 41.89472], [-121.22233, 41.89564], [-121.22076, 41.89609], [-121.21966, 41.89576], [-121.21766, 41.89583], [-121.21613, 41.89655], [-121.21572, 41.89641], [-121.21523, 41.89618], [-121.21251, 41.89586], [-121.2118, 41.89614], [-121.21143, 41.89651], [-121.20834, 41.89607], [-121.20674, 41.89589], [-121.20647, 41.89566], [-121.20577, 41.89561], [-121.20553, 41.89575], [-121.20375, 41.89554], [-121.20056, 41.89493], [-121.19803, 41.89485], [-121.19701, 41.89475], [-121.19565, 41.89446], [-121.19417, 41.89438], [-121.19346, 41.89471], [-121.19226, 41.8953], [-121.19107, 41.89536], [-121.18966, 41.89618], [-121.18616, 41.89672], [-121.18445, 41.89666], [-121.18308, 41.89626], [-121.18169, 41.89595], [-121.18047, 41.89572], [-121.17946, 41.89541], [-121.17839, 41.89496], [-121.17653, 41.89439], [-121.17646, 41.8941], [-121.17587, 41.89384], [-121.17471, 41.89346], [-121.17391, 41.89304], [-121.17283, 41.8926], [-121.17236, 41.89042], [-121.17098, 41.88987], [-121.16933, 41.88862], [-121.15738, 41.88179], [-121.15737, 41.88135], [-121.1574, 41.881], [-121.15762, 41.88033], [-121.15787, 41.87928], [-121.15595, 41.87724], [-121.15602, 41.87641], [-121.15421, 41.87513], [-121.15389, 41.87335], [-121.15266, 41.87212], [-121.15172, 41.87124], [-121.15124, 41.87023], [-121.15108, 41.86934], [-121.15124, 41.86845], [-121.15169, 41.86773], [-121.1522, 41.86673], [-121.15247, 41.86602], [-121.15264, 41.86502], [-121.15272, 41.8638], [-121.15285, 41.86284], [-121.15334, 41.8617], [-121.15371, 41.86148], [-121.15394, 41.86063], [-121.15413, 41.85974], [-121.15455, 41.85883], [-121.15483, 41.85783], [-121.15546, 41.85662], [-121.15641, 41.85559], [-121.15711, 41.85564], [-121.1585, 41.85591], [-121.15953, 41.85509], [-121.15903, 41.85415], [-121.15877, 41.85401], [-121.15802, 41.85358], [-121.15782, 41.85329], [-121.15829, 41.85275], [-121.15895, 41.85019], [-121.15629, 41.84916], [-121.15263, 41.84854], [-121.15137, 41.84703], [-121.14747, 41.84601], [-121.14511, 41.84594], [-121.1426, 41.84459], [-121.1403, 41.84077], [-121.13826, 41.83776], [-121.13633, 41.83663], [-121.1346, 41.83625], [-121.13204, 41.83386], [-121.13054, 41.83199], [-121.1299, 41.83151], [-121.12996, 41.83127], [-121.13033, 41.82854], [-121.13008, 41.82799], [-121.12963, 41.8272], [-121.12961, 41.8267], [-121.12977, 41.82594], [-121.13057, 41.8251], [-121.13269, 41.81866], [-121.13239, 41.81809], [-121.13186, 41.81775], [-121.13204, 41.81741], [-121.13323, 41.81598], [-121.13365, 41.81557], [-121.13471, 41.81624], [-121.13538, 41.81618], [-121.13587, 41.81627], [-121.13625, 41.8164], [-121.13657, 41.81682], [-121.13817, 41.81658], [-121.13874, 41.81682], [-121.13929, 41.81715], [-121.13982, 41.81698], [-121.14052, 41.81673], [-121.14131, 41.81661], [-121.14157, 41.8168], [-121.14223, 41.81725], [-121.14303, 41.81812], [-121.14502, 41.8188], [-121.14601, 41.81889], [-121.14689, 41.81907], [-121.14836, 41.81929], [-121.14969, 41.82021], [-121.15116, 41.81971], [-121.15299, 41.81898], [-121.15399, 41.81875], [-121.15524, 41.819], [-121.15759, 41.81911], [-121.15858, 41.8193], [-121.15982, 41.81966], [-121.16055, 41.81975], [-121.16193, 41.82068], [-121.16384, 41.82111], [-121.16466, 41.82123], [-121.16514, 41.82163], [-121.16566, 41.82209], [-121.16635, 41.82251], [-121.16792, 41.8242], [-121.17068, 41.82477], [-121.17599, 41.82702], [-121.17778, 41.82973], [-121.18094, 41.83203], [-121.1842, 41.83252], [-121.1874, 41.83424], [-121.19169, 41.83713], [-121.1937, 41.83896], [-121.20119, 41.84332], [-121.20825, 41.84567], [-121.20945, 41.8478], [-121.20983, 41.84811], [-121.21005, 41.84847], [-121.21218, 41.85151], [-121.21221, 41.85295], [-121.21206, 41.85366], [-121.21166, 41.85459], [-121.21117, 41.85515], [-121.21028, 41.85567], [-121.20918, 41.857], [-121.20845, 41.8584], [-121.20848, 41.85899], [-121.20863, 41.85942], [-121.20901, 41.85997], [-121.20872, 41.86209], [-121.21103, 41.86446], [-121.20962, 41.86921], [-121.20882, 41.87121], [-121.20871, 41.87153], [-121.2087, 41.87203], [-121.20875, 41.87262], [-121.2085, 41.87312], [-121.20771, 41.87399], [-121.20773, 41.87452], [-121.20795, 41.87492], [-121.20849, 41.87554], [-121.20849, 41.87597], [-121.20825, 41.87651], [-121.20788, 41.87755], [-121.20631, 41.88107], [-121.20715, 41.88213], [-121.20798, 41.88337], [-121.20897, 41.88308], [-121.20988, 41.88263], [-121.21104, 41.88251], [-121.21171, 41.88288], [-121.2138, 41.88302], [-121.21444, 41.88294], [-121.21615, 41.88326], [-121.2169, 41.88363], [-121.21754, 41.88409], [-121.21829, 41.8849], [-121.21869, 41.88543], [-121.21894, 41.88617], [-121.21894, 41.88626], [-121.21879, 41.88636], [-121.21991, 41.88963], [-121.22257, 41.8893], [-121.22429, 41.89107], [-121.22614, 41.89233]]]} | Open Access 1 | 25247 | Clear Lake National Wildlife Refuge | 13799 | 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 | http://www.fws.gov/refuge/clear_lake/ | Modoc 56 | 9158.023 | Clear Lake NWR | 1911 | National Wildlife Refuge 105 | 2 |
15809 | 15809 | 15808 | {"type": "MultiPolygon", "coordinates": [[[[-115.63163, 33.19095], [-115.6144, 33.191], [-115.61443, 33.2056], [-115.59713, 33.20562], [-115.5972, 33.19108], [-115.5972, 33.18382], [-115.61447, 33.18381], [-115.61454, 33.17663], [-115.62301, 33.17662], [-115.62302, 33.16938], [-115.63151, 33.16937], [-115.63147, 33.17661], [-115.63163, 33.19095]]], [[[-115.66647, 33.19104], [-115.66645, 33.2056], [-115.64891, 33.20566], [-115.6489, 33.20569], [-115.64885, 33.2057], [-115.64879, 33.22008], [-115.63179, 33.22008], [-115.63178, 33.22013], [-115.63178, 33.23461], [-115.61433, 33.23471], [-115.61437, 33.22014], [-115.62588, 33.2201], [-115.63177, 33.22012], [-115.63169, 33.20562], [-115.64885, 33.20569], [-115.64877, 33.19098], [-115.66647, 33.19104]]], [[[-115.7311, 33.08957], [-115.73106, 33.09675], [-115.73101, 33.09684], [-115.72246, 33.09683], [-115.72244, 33.10411], [-115.70084, 33.10413], [-115.70083, 33.1186], [-115.68339, 33.11864], [-115.68339, 33.13303], [-115.68349, 33.14739], [-115.69213, 33.14742], [-115.69213, 33.15473], [-115.68349, 33.15472], [-115.68348, 33.1474], [-115.66632, 33.14745], [-115.6663, 33.13299], [-115.66633, 33.12578], [-115.6706, 33.12579], [-115.67062, 33.11859], [-115.68339, 33.11863], [-115.68355, 33.10408], [-115.68354, 33.10044], [-115.68787, 33.10044], [-115.68787, 33.08953], [-115.69223, 33.08954], [-115.69223, 33.09318], [-115.7009, 33.0932], [-115.70094, 33.08956], [-115.71774, 33.08956], [-115.71816, 33.08953], [-115.7311, 33.08957]]], [[[-115.71804, 33.16202], [-115.70088, 33.16204], [-115.70087, 33.16205], [-115.70076, 33.16206], [-115.70072, 33.17656], [-115.68364, 33.17653], [-115.68363, 33.17655], [-115.68352, 33.17655], [-115.68349, 33.16204], [-115.70075, 33.16205], [-115.70077, 33.14743], [-115.71803, 33.14745], [-115.71804, 33.16202]]], [[[-115.75251, 33.23471], [-115.75249, 33.24929], [-115.75081, 33.24922], [-115.73556, 33.24917], [-115.73553, 33.23463], [-115.7355, 33.23461], [-115.71832, 33.2346], [-115.71831, 33.23462], [-115.71822, 33.23463], [-115.71817, 33.24918], [-115.70103, 33.24913], [-115.70107, 33.23468], [-115.71821, 33.23462], [-115.71822, 33.2346], [-115.71831, 33.23459], [-115.71827, 33.22006], [-115.73548, 33.22009], [-115.73543, 33.20556], [-115.75235, 33.20575], [-115.75237, 33.22024], [-115.75082, 33.22017], [-115.73548, 33.2201], [-115.73553, 33.2346], [-115.73559, 33.23462], [-115.75246, 33.23475], [-115.75247, 33.23471], [-115.75251, 33.23471]]], [[[-115.77013, 33.17658], [-115.75241, 33.17654], [-115.75236, 33.16205], [-115.75229, 33.16205], [-115.75228, 33.16202], [-115.75142, 33.16202], [-115.75082, 33.16201], [-115.73539, 33.16202], [-115.73536, 33.14746], [-115.73529, 33.14745], [-115.73529, 33.14742], [-115.73536, 33.14742], [-115.73537, 33.14745], [-115.75242, 33.14742], [-115.75236, 33.16205], [-115.7701, 33.162], [-115.77008, 33.16923], [-115.77013, 33.17658]]], [[[-115.83922, 33.2347], [-115.82193, 33.23467], [-115.82184, 33.25008], [-115.8218, 33.25074], [-115.80456, 33.25072], [-115.80458, 33.25007], [-115.80462, 33.2347], [-115.78738, 33.23468], [-115.78737, 33.22012], [-115.77008, 33.22014], [-115.77008, 33.20569], [-115.78738, 33.2057], [-115.78738, 33.22013], [-115.80464, 33.22014], [-115.80465, 33.22013], [-115.80464, 33.20572], [-115.80463, 33.20569], [-115.822, 33.20566], [-115.82195, 33.22014], [-115.83921, 33.22016], [-115.83922, 33.2347]], [[-115.82195, 33.22015], [-115.80465, 33.22014], [-115.80462, 33.23469], [-115.82192, 33.23467], [-115.82195, 33.22015]]], [[[-115.78737, 33.23469], [-115.78727, 33.25067], [-115.77001, 33.25062], [-115.76999, 33.25005], [-115.77008, 33.23472], [-115.78737, 33.23469]]], [[[-115.82198, 33.1766], [-115.82196, 33.17661], [-115.82195, 33.19107], [-115.80467, 33.19122], [-115.80478, 33.17658], [-115.78742, 33.17653], [-115.78748, 33.16924], [-115.7875, 33.16199], [-115.80481, 33.16192], [-115.80479, 33.17657], [-115.82198, 33.1766]]]]} | Open Access 1 | 12950 | Sonny Bono Salton Sea National Wildlife Refuge | 4597 | 2048 | Imperial Irrigation District 379 | Special District 4 | Irrigation District 17 | http://www.iid.com/ | Special District 4 | 2048 | Imperial Irrigation District 374 | Special District 4 | Irrigation District 16 | http://www.fws.gov/refuge/sonny_bono_salton_sea/ | Imperial 20 | 17446.028 | Sonny Bono Salton Sea NWR | 1930 | National Wildlife Refuge 105 | 2 |
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]);