units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
22 rows where ACCESS_TYP = 1 and MNG_AGENCY = 44 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- United States Fish and Wildlife Service · 2 ✖
DES_TP 1
ACCESS_TYP 1
- Open Access · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15818 | 15818 | 15817 | {"type": "MultiPolygon", "coordinates": [[[[-115.8564, 33.23466], [-115.83922, 33.23474], [-115.8392, 33.25007], [-115.83917, 33.25073], [-115.8218, 33.25074], [-115.82184, 33.25008], [-115.82192, 33.23468], [-115.82191, 33.23467], [-115.80462, 33.2347], [-115.80458, 33.25007], [-115.80456, 33.25072], [-115.78727, 33.25067], [-115.78736, 33.23738], [-115.78738, 33.23471], [-115.78737, 33.2347], [-115.77008, 33.23472], [-115.76999, 33.25005], [-115.77001, 33.25062], [-115.76328, 33.25008], [-115.7622, 33.25009], [-115.75249, 33.24929], [-115.75251, 33.23475], [-115.77003, 33.23472], [-115.77007, 33.22016], [-115.77006, 33.22015], [-115.75238, 33.22027], [-115.75247, 33.23475], [-115.73553, 33.23461], [-115.73556, 33.24916], [-115.7356, 33.24917], [-115.7356, 33.2492], [-115.73557, 33.2492], [-115.73555, 33.24917], [-115.71817, 33.24918], [-115.71822, 33.23462], [-115.71831, 33.23462], [-115.7183, 33.2346], [-115.70107, 33.23466], [-115.70103, 33.24915], [-115.70101, 33.24913], [-115.68368, 33.24913], [-115.68367, 33.24914], [-115.6317, 33.24918], [-115.6143, 33.24922], [-115.61437, 33.23472], [-115.63179, 33.23461], [-115.63179, 33.22008], [-115.64885, 33.22008], [-115.6489, 33.20566], [-115.66648, 33.20559], [-115.66654, 33.19099], [-115.68368, 33.19101], [-115.68363, 33.17653], [-115.70082, 33.17656], [-115.70087, 33.16204], [-115.71818, 33.16202], [-115.71809, 33.14748], [-115.73536, 33.14745], [-115.73534, 33.13307], [-115.7524, 33.13311], [-115.7524, 33.14741], [-115.7701, 33.14745], [-115.7701, 33.162], [-115.75236, 33.16202], [-115.75242, 33.14742], [-115.73537, 33.14745], [-115.73539, 33.16205], [-115.75229, 33.16202], [-115.75237, 33.17654], [-115.77015, 33.17658], [-115.78742, 33.17649], [-115.78743, 33.17653], [-115.80478, 33.17657], [-115.80467, 33.19122], [-115.80468, 33.19124], [-115.82194, 33.19111], [-115.82196, 33.1766], [-115.8307, 33.17664], [-115.83059, 33.19111], [-115.82195, 33.19112], [-115.82199, 33.20566], [-115.80463, 33.20569], [-115.80464, 33.20571], [-115.80465, 33.22014], [-115.82195, 33.22016], [-115.82193, 33.23468], [-115.83922, 33.23474], [-115.83921, 33.22019], [-115.85231, 33.22013], [-115.85232, 33.22091], [-115.85639, 33.22091], [-115.8564, 33.23466]], [[-115.73548, 33.22015], [-115.73547, 33.22009], [-115.71827, 33.22006], [-115.71832, 33.23459], [-115.73024, 33.23461], [-115.73552, 33.23461], [-115.73548, 33.22015]], [[-115.75235, 33.20576], [-115.73544, 33.20556], [-115.73548, 33.22009], [-115.75082, 33.22017], [-115.75236, 33.22024], [-115.75235, 33.20576]], [[-115.78738, 33.20571], [-115.77831, 33.20569], [-115.77008, 33.20569], [-115.77008, 33.22015], [-115.78733, 33.22013], [-115.78737, 33.22011], [-115.78738, 33.20571]], [[-115.80464, 33.22015], [-115.80463, 33.22014], [-115.78734, 33.22013], [-115.78738, 33.22809], [-115.78738, 33.23467], [-115.80462, 33.23469], [-115.80464, 33.22015]]], [[[-115.62281, 33.16931], [-115.62279, 33.17662], [-115.61455, 33.17663], [-115.61452, 33.1693], [-115.62281, 33.16931]]], [[[-115.70083, 33.14743], [-115.70077, 33.14744], [-115.70075, 33.16204], [-115.68359, 33.16203], [-115.68356, 33.15473], [-115.69221, 33.15473], [-115.69218, 33.14743], [-115.70076, 33.14743], [-115.70083, 33.14742], [-115.70083, 33.14743]]], [[[-115.71823, 33.07505], [-115.71813, 33.08228], [-115.71817, 33.08229], [-115.71817, 33.0823], [-115.70951, 33.08221], [-115.7096, 33.07496], [-115.70094, 33.07502], [-115.70091, 33.075], [-115.70091, 33.07496], [-115.69903, 33.07352], [-115.69907, 33.06708], [-115.70701, 33.06709], [-115.70702, 33.06715], [-115.70759, 33.06715], [-115.7076, 33.0671], [-115.7122, 33.06709], [-115.71229, 33.06315], [-115.71442, 33.06316], [-115.71437, 33.06709], [-115.71655, 33.06707], [-115.71639, 33.07448], [-115.71644, 33.0746], [-115.71657, 33.07471], [-115.71771, 33.07473], [-115.71792, 33.0749], [-115.71796, 33.07504], [-115.71823, 33.07505]]]]} | Open Access 1 | 12849 | Sonny Bono Salton Sea National Wildlife Refuge | 13989 | 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/sonny_bono_salton_sea/ | Imperial 20 | 31831.176 | Sonny Bono Salton Sea NWR | 1930 | National Wildlife Refuge 105 | 2 |
15813 | 15813 | 15812 | {"type": "MultiPolygon", "coordinates": [[[[-121.87583, 42.00316], [-121.87583, 42.00323], [-121.84316, 42.00279], [-121.83345, 42.0026], [-121.83344, 41.99966], [-121.84312, 41.99961], [-121.84311, 41.99617], [-121.82754, 41.99603], [-121.82732, 41.99749], [-121.82965, 42.00112], [-121.8292, 42.00251], [-121.82479, 42.00243], [-121.80113, 42.00213], [-121.77359, 42.00184], [-121.75112, 42.00156], [-121.75107, 42.00153], [-121.72713, 42.00117], [-121.68062, 42.00042], [-121.62611, 41.99967], [-121.62362, 41.99961], [-121.6236, 41.99906], [-121.62265, 41.99904], [-121.62262, 41.99848], [-121.62171, 41.99801], [-121.61841, 41.99606], [-121.61691, 41.99418], [-121.61691, 41.99395], [-121.61683, 41.99313], [-121.61656, 41.99263], [-121.61634, 41.9926], [-121.61575, 41.9895], [-121.61346, 41.9828], [-121.61273, 41.98277], [-121.61255, 41.98647], [-121.60773, 41.98647], [-121.60785, 41.98279], [-121.603, 41.98279], [-121.60303, 41.97923], [-121.60318, 41.97542], [-121.59828, 41.97545], [-121.59842, 41.97189], [-121.5934, 41.97192], [-121.59367, 41.96478], [-121.59376, 41.95019], [-121.59892, 41.95019], [-121.59903, 41.94313], [-121.59907, 41.93932], [-121.59904, 41.93651], [-121.59862, 41.9365], [-121.59863, 41.93572], [-121.59925, 41.93571], [-121.59919, 41.93198], [-121.59911, 41.9318], [-121.60373, 41.93185], [-121.60366, 41.94629], [-121.61323, 41.94626], [-121.61316, 41.9502], [-121.6311, 41.95033], [-121.63529, 41.93923], [-121.63509, 41.93189], [-121.62838, 41.92158], [-121.62836, 41.92158], [-121.62825, 41.92489], [-121.62239, 41.92484], [-121.62126, 41.92524], [-121.62027, 41.92577], [-121.61986, 41.92585], [-121.61944, 41.92577], [-121.61846, 41.92538], [-121.61821, 41.92526], [-121.61779, 41.92526], [-121.61733, 41.92533], [-121.61696, 41.92529], [-121.61639, 41.92517], [-121.61582, 41.92512], [-121.61556, 41.92504], [-121.61544, 41.92479], [-121.60863, 41.92474], [-121.60853, 41.92101], [-121.61381, 41.92104], [-121.61368, 41.91004], [-121.61859, 41.91003], [-121.61853, 41.90634], [-121.62342, 41.90637], [-121.64286, 41.9066], [-121.64499, 41.90664], [-121.6457, 41.90526], [-121.64746, 41.90375], [-121.65103, 41.90287], [-121.65358, 41.90251], [-121.65572, 41.90192], [-121.6613, 41.90184], [-121.66272, 41.90069], [-121.66298, 41.9001], [-121.6668, 41.89777], [-121.66965, 41.89638], [-121.67157, 41.895], [-121.67808, 41.89289], [-121.68089, 41.89219], [-121.68247, 41.89221], [-121.68246, 41.89235], [-121.68247, 41.89236], [-121.68352, 41.89153], [-121.68437, 41.89144], [-121.68562, 41.89054], [-121.68606, 41.89064], [-121.68788, 41.88993], [-121.68899, 41.88979], [-121.69004, 41.88944], [-121.69129, 41.88845], [-121.69233, 41.88812], [-121.69325, 41.8887], [-121.69358, 41.88875], [-121.69387, 41.88839], [-121.6947, 41.8872], [-121.69514, 41.88602], [-121.6956, 41.88514], [-121.69614, 41.88382], [-121.69662, 41.88019], [-121.69725, 41.87866], [-121.6973, 41.87847], [-121.69988, 41.87416], [-121.7015, 41.87375], [-121.703, 41.87533], [-121.70518, 41.87509], [-121.70818, 41.8738], [-121.70927, 41.87274], [-121.71465, 41.86975], [-121.72112, 41.87107], [-121.7243, 41.87256], [-121.72457, 41.87338], [-121.72639, 41.87441], [-121.7264, 41.87494], [-121.7284, 41.87494], [-121.72842, 41.87915], [-121.72495, 41.87906], [-121.72498, 41.87928], [-121.72915, 41.8937], [-121.73102, 41.89372], [-121.73102, 41.89378], [-121.73196, 41.89469], [-121.7334, 41.8975], [-121.73387, 41.89741], [-121.73439, 41.89866], [-121.73522, 41.89943], [-121.73577, 41.90029], [-121.73641, 41.90067], [-121.7366, 41.90222], [-121.73736, 41.90356], [-121.73727, 41.90424], [-121.73832, 41.90425], [-121.73842, 41.90433], [-121.73821, 41.90449], [-121.73833, 41.90462], [-121.73849, 41.90472], [-121.74071, 41.90532], [-121.74296, 41.9067], [-121.74296, 41.90682], [-121.74473, 41.90862], [-121.74619, 41.90921], [-121.74629, 41.91062], [-121.74569, 41.91146], [-121.74423, 41.91147], [-121.74295, 41.91237], [-121.74295, 41.91179], [-121.74188, 41.91197], [-121.74117, 41.91211], [-121.74064, 41.91228], [-121.74022, 41.91315], [-121.73943, 41.91373], [-121.73922, 41.91404], [-121.73926, 41.91474], [-121.73895, 41.91604], [-121.73865, 41.91695], [-121.73958, 41.91791], [-121.74157, 41.9184], [-121.74288, 41.91951], [-121.74284, 41.92319], [-121.7524, 41.92318], [-121.75236, 41.93044], [-121.76235, 41.93036], [-121.76241, 41.93041], [-121.77694, 41.93038], [-121.77695, 41.93042], [-121.78183, 41.93037], [-121.79626, 41.93045], [-121.7965, 41.95286], [-121.79651, 41.95287], [-121.79951, 41.95282], [-121.79946, 41.96732], [-121.80415, 41.96734], [-121.80409, 41.97092], [-121.80949, 41.97092], [-121.80949, 41.97445], [-121.81909, 41.97444], [-121.84323, 41.97434], [-121.84319, 41.98165], [-121.85715, 41.98182], [-121.85922, 41.9829], [-121.86286, 41.98704], [-121.86288, 41.98704], [-121.86289, 41.98748], [-121.86371, 41.98782], [-121.86414, 41.98801], [-121.86515, 41.98787], [-121.86613, 41.98821], [-121.86713, 41.98795], [-121.86776, 41.98823], [-121.86786, 41.98987], [-121.86732, 41.99012], [-121.86647, 41.99002], [-121.86565, 41.99014], [-121.86566, 41.99015], [-121.86641, 41.99043], [-121.86697, 41.99072], [-121.8669, 41.99126], [-121.86596, 41.9919], [-121.86556, 41.99239], [-121.86569, 41.9926], [-121.86518, 41.99399], [-121.86549, 41.99506], [-121.86719, 41.99798], [-121.86892, 41.99856], [-121.86973, 41.99927], [-121.87143, 42.00042], [-121.8719, 42.00072], [-121.87192, 42.00149], [-121.87208, 42.00169], [-121.87347, 42.00282], [-121.87583, 42.00316]], [[-121.62774, 41.92107], [-121.62775, 41.92109], [-121.62805, 41.92108], [-121.62799, 41.92099], [-121.62774, 41.92107]], [[-121.6488, 41.99375], [-121.65134, 41.99376], [-121.65149, 41.98652], [-121.64895, 41.98653], [-121.64736, 41.98573], [-121.6467, 41.98655], [-121.64189, 41.98649], [-121.64189, 41.98534], [-121.63705, 41.98371], [-121.63653, 41.98569], [-121.63667, 41.98571], [-121.63693, 41.98584], [-121.63692, 41.98651], [-121.63754, 41.98655], [-121.63768, 41.98672], [-121.63759, 41.98697], [-121.63731, 41.98703], [-121.63731, 41.98704], [-121.63843, 41.988], [-121.63894, 41.98775], [-121.63924, 41.98773], [-121.63964, 41.98788], [-121.63986, 41.98811], [-121.64078, 41.98866], [-121.64145, 41.98923], [-121.64178, 41.98936], [-121.64176, 41.99096], [-121.64311, 41.99202], [-121.64628, 41.99345], [-121.64794, 41.99365], [-121.64817, 41.99416], [-121.6488, 41.99375]]], [[[-121.60451, 41.92828], [-121.60396, 41.92946], [-121.60389, 41.92946], [-121.6039, 41.92878], [-121.60414, 41.92828], [-121.60451, 41.92828]]]]} | Open Access 1 | 8811 | Lower Klamath National Wildlife Refuge | 13921 | 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/lower_klamath/ | Siskiyou 28 | 44588.839 | Lower Klamath NWR | 1908 | 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]);