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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15847 | 15847 | 15846 | {"type": "MultiPolygon", "coordinates": [[[[-122.47646, 37.97128], [-122.47203, 37.97146], [-122.47208, 37.97494], [-122.46979, 37.97493], [-122.46988, 37.96842], [-122.47633, 37.96825], [-122.47646, 37.97128]]], [[[-122.4787, 37.96437], [-122.47642, 37.96441], [-122.47643, 37.96495], [-122.47411, 37.96404], [-122.47393, 37.95724], [-122.47508, 37.95722], [-122.47518, 37.96081], [-122.4786, 37.96075], [-122.4787, 37.96437]]]]} | Open Access 1 | 25783 | Marin Island National Wildlife Refuge | 21817 | 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 | Marin 23 | 117.37 | Marin Island NWR | 0 | National Wildlife Refuge 105 | 2 | |
15857 | 15857 | 15856 | {"type": "Polygon", "coordinates": [[[-122.07265, 39.84151], [-122.07266, 39.84172], [-122.0729, 39.84251], [-122.07291, 39.84356], [-122.07285, 39.84422], [-122.07281, 39.84441], [-122.07268, 39.84469], [-122.07264, 39.84502], [-122.07258, 39.84534], [-122.07237, 39.84571], [-122.0722, 39.8461], [-122.07209, 39.84639], [-122.0715, 39.84689], [-122.07125, 39.84719], [-122.07092, 39.84746], [-122.0707, 39.8476], [-122.07015, 39.8482], [-122.06986, 39.84846], [-122.06962, 39.84874], [-122.06949, 39.84894], [-122.06946, 39.84911], [-122.06947, 39.84919], [-122.06795, 39.85307], [-122.06633, 39.85408], [-122.06592, 39.8541], [-122.06563, 39.85414], [-122.06549, 39.8542], [-122.06533, 39.8543], [-122.06488, 39.85467], [-122.06454, 39.85491], [-122.06435, 39.85503], [-122.06348, 39.85566], [-122.06308, 39.8559], [-122.06219, 39.85658], [-122.06188, 39.85679], [-122.06171, 39.85688], [-122.06121, 39.85723], [-122.06097, 39.85747], [-122.06039, 39.85789], [-122.05915, 39.85866], [-122.05887, 39.85881], [-122.0585, 39.85909], [-122.05816, 39.8593], [-122.05819, 39.85874], [-122.05829, 39.85792], [-122.05831, 39.85761], [-122.05823, 39.85699], [-122.05816, 39.85666], [-122.05808, 39.85646], [-122.05797, 39.85623], [-122.05791, 39.85618], [-122.05784, 39.85618], [-122.05773, 39.85624], [-122.05762, 39.85626], [-122.0571, 39.85586], [-122.05694, 39.85585], [-122.05678, 39.8559], [-122.05671, 39.85599], [-122.05656, 39.85603], [-122.05645, 39.85602], [-122.05625, 39.85595], [-122.05617, 39.85585], [-122.05611, 39.8557], [-122.0561, 39.85549], [-122.05629, 39.85487], [-122.05644, 39.8546], [-122.0567, 39.85428], [-122.05694, 39.85403], [-122.05702, 39.8539], [-122.05721, 39.85323], [-122.05725, 39.85297], [-122.05726, 39.85262], [-122.05728, 39.85229], [-122.0573, 39.8522], [-122.05754, 39.85175], [-122.05776, 39.85144], [-122.05799, 39.85117], [-122.05817, 39.85105], [-122.05832, 39.85102], [-122.05844, 39.85104], [-122.05848, 39.85111], [-122.05844, 39.85126], [-122.05835, 39.85146], [-122.05825, 39.85184], [-122.05824, 39.85204], [-122.0583, 39.85213], [-122.05836, 39.85212], [-122.05842, 39.85209], [-122.05855, 39.85195], [-122.05862, 39.85172], [-122.05882, 39.85137], [-122.05905, 39.85106], [-122.0593, 39.85073], [-122.0598, 39.85018], [-122.06025, 39.84978], [-122.06117, 39.84906], [-122.06227, 39.84825], [-122.06318, 39.84762], [-122.0633, 39.84757], [-122.06343, 39.84755], [-122.06356, 39.8475], [-122.0637, 39.84748], [-122.06377, 39.84753], [-122.06378, 39.84764], [-122.06383, 39.84767], [-122.06388, 39.84766], [-122.06397, 39.84752], [-122.06411, 39.84738], [-122.06462, 39.84714], [-122.06498, 39.84702], [-122.06513, 39.84694], [-122.06575, 39.8463], [-122.06634, 39.84581], [-122.06732, 39.8448], [-122.06747, 39.8446], [-122.06761, 39.84445], [-122.06775, 39.84433], [-122.06809, 39.8441], [-122.06842, 39.8438], [-122.06861, 39.84367], [-122.06934, 39.84297], [-122.06956, 39.84271], [-122.06973, 39.84244], [-122.06983, 39.84219], [-122.06991, 39.84186], [-122.07008, 39.84133], [-122.07044, 39.84043], [-122.07049, 39.84021], [-122.07048, 39.84001], [-122.07044, 39.83986], [-122.07052, 39.83975], [-122.071, 39.84002], [-122.07132, 39.84012], [-122.07162, 39.84026], [-122.07182, 39.8404], [-122.07201, 39.84063], [-122.07265, 39.84151]]]} | Open Access 1 | 44502 | 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/ | Tehama 18 | 275.97 | Sacramento River NWR | 1989 | National Wildlife Refuge 105 | 2 |
15858 | 15858 | 15857 | {"type": "Polygon", "coordinates": [[[-122.00419, 39.57964], [-122.00405, 39.57976], [-122.003, 39.57939], [-122.00098, 39.57999], [-122.00086, 39.58014], [-121.99819, 39.58045], [-121.99802, 39.57977], [-121.99817, 39.57969], [-121.99926, 39.57891], [-122.00109, 39.57749], [-122.00192, 39.576], [-122.00235, 39.5755], [-122.0022, 39.57641], [-122.00258, 39.57683], [-122.00248, 39.57681], [-122.00419, 39.57964]]]} | Open Access 1 | 44504 | 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/ | Glenn 55 | 27.601 | Sacramento River NWR | 1989 | National Wildlife Refuge 105 | 2 |
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 |
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]);