units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1, GAP_STS = 4 and MNG_AGENCY = 37
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6482 | 6482 | 6481 | {"type": "Polygon", "coordinates": [[[-117.49208, 34.25165], [-117.49191, 34.25249], [-117.49152, 34.25285], [-117.49137, 34.25324], [-117.49132, 34.25361], [-117.49123, 34.25396], [-117.49105, 34.25424], [-117.49036, 34.25487], [-117.4893, 34.25482], [-117.48921, 34.25572], [-117.48903, 34.25595], [-117.48918, 34.25659], [-117.48857, 34.25675], [-117.48821, 34.25693], [-117.48831, 34.25044], [-117.48889, 34.25065], [-117.48902, 34.25061], [-117.48981, 34.25022], [-117.49014, 34.24998], [-117.49082, 34.249], [-117.49174, 34.24937], [-117.49085, 34.25064], [-117.49156, 34.25086], [-117.49165, 34.25102], [-117.49152, 34.25158], [-117.49208, 34.25165]], [[-117.49013, 34.25218], [-117.48925, 34.25195], [-117.48893, 34.25197], [-117.48878, 34.25203], [-117.48864, 34.25212], [-117.48854, 34.25234], [-117.4886, 34.25252], [-117.48868, 34.25264], [-117.48886, 34.25268], [-117.49103, 34.25281], [-117.49118, 34.2523], [-117.49087, 34.25222], [-117.49059, 34.25219], [-117.49013, 34.25218]], [[-117.49121, 34.25106], [-117.491, 34.25096], [-117.49079, 34.25096], [-117.49009, 34.25081], [-117.48986, 34.25081], [-117.48975, 34.25092], [-117.48964, 34.2511], [-117.48964, 34.25126], [-117.48972, 34.25137], [-117.48993, 34.25146], [-117.49091, 34.25163], [-117.49119, 34.25161], [-117.49123, 34.25158], [-117.49126, 34.25121], [-117.49121, 34.25106]]]} | Open Access 1 | 2304 | Applewhite Campground | 15543 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 36.645 | Applewhite Campground | 0 | Recreation Management Area 49 | 4 | |
10057 | 10057 | 10056 | {"type": "MultiPolygon", "coordinates": [[[[-120.15944, 39.11112], [-120.15898, 39.11163], [-120.15858, 39.11216], [-120.15822, 39.11273], [-120.15808, 39.113], [-120.158, 39.11325], [-120.15795, 39.11346], [-120.15792, 39.11367], [-120.15792, 39.11389], [-120.15794, 39.1141], [-120.15798, 39.11431], [-120.15813, 39.11475], [-120.1579, 39.11475], [-120.15779, 39.11452], [-120.1577, 39.11413], [-120.15768, 39.11388], [-120.15768, 39.11367], [-120.15773, 39.11321], [-120.15776, 39.1131], [-120.1578, 39.113], [-120.15783, 39.11279], [-120.15793, 39.11248], [-120.15795, 39.11229], [-120.15806, 39.11206], [-120.1583, 39.11158], [-120.1586, 39.11111], [-120.15944, 39.11112]]], [[[-120.16538, 39.11475], [-120.16269, 39.11475], [-120.15978, 39.11469], [-120.1595, 39.11469], [-120.15843, 39.11474], [-120.15829, 39.11437], [-120.15822, 39.11406], [-120.1582, 39.11379], [-120.15823, 39.11348], [-120.1583, 39.11322], [-120.1584, 39.11296], [-120.15873, 39.1124], [-120.15878, 39.11236], [-120.15908, 39.11237], [-120.15926, 39.11234], [-120.15943, 39.11227], [-120.15957, 39.11215], [-120.15957, 39.11245], [-120.16153, 39.1125], [-120.16154, 39.11117], [-120.16208, 39.1112], [-120.16538, 39.11475]]]]} | Open Access 1 | 49029 | Kaspian Recreation Area | 33730 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | https://www.fs.usda.gov/Internet/FSE_DOCUMENTS/fseprd632577.pdf | Placer 35 | 39.38 | Kaspian Rec. Area | 0 | Recreation Management Area 49 | 4 |
12084 | 12084 | 12083 | {"type": "Polygon", "coordinates": [[[-117.24699, 34.22787], [-117.24641, 34.2278], [-117.24625, 34.22776], [-117.24604, 34.22767], [-117.24588, 34.22753], [-117.24579, 34.22741], [-117.24574, 34.2273], [-117.24558, 34.22653], [-117.24552, 34.22637], [-117.24544, 34.22621], [-117.24695, 34.22622], [-117.24699, 34.22787]]]} | Open Access 1 | 24892 | Baylis Park Picnic Area | 15888 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 5.039 | Baylis Park Picnic Area | 0 | Recreation Management Area 49 | 4 | |
13116 | 13116 | 13115 | {"type": "MultiPolygon", "coordinates": [[[[-122.18916, 40.15308], [-122.1889, 40.1533], [-122.18756, 40.15347], [-122.18574, 40.15332], [-122.18462, 40.15316], [-122.18431, 40.15314], [-122.18617, 40.15049], [-122.187, 40.15061], [-122.18861, 40.151], [-122.18892, 40.15132], [-122.18872, 40.1516], [-122.18847, 40.15163], [-122.18821, 40.15172], [-122.18694, 40.15192], [-122.18654, 40.1521], [-122.18649, 40.15239], [-122.18716, 40.1526], [-122.18801, 40.15267], [-122.18851, 40.15264], [-122.18916, 40.15283], [-122.18916, 40.15308]]], [[[-122.1945, 40.15185], [-122.19435, 40.15201], [-122.19397, 40.15227], [-122.19325, 40.15246], [-122.19265, 40.15254], [-122.19192, 40.15272], [-122.19106, 40.15279], [-122.19, 40.15318], [-122.18989, 40.15288], [-122.19007, 40.15244], [-122.1906, 40.15218], [-122.19195, 40.15194], [-122.19382, 40.15173], [-122.19428, 40.15174], [-122.1945, 40.15185]]], [[[-122.21916, 40.16856], [-122.21848, 40.16793], [-122.21818, 40.16733], [-122.21763, 40.16657], [-122.21712, 40.16598], [-122.21566, 40.16474], [-122.21501, 40.16432], [-122.21346, 40.16357], [-122.21267, 40.16324], [-122.21213, 40.1628], [-122.21042, 40.16243], [-122.2091, 40.16225], [-122.20826, 40.16217], [-122.20761, 40.16223], [-122.20542, 40.16223], [-122.20318, 40.16214], [-122.20073, 40.16188], [-122.19927, 40.16152], [-122.19713, 40.15879], [-122.19622, 40.1574], [-122.19388, 40.15425], [-122.19377, 40.15397], [-122.19506, 40.15379], [-122.19583, 40.15364], [-122.19775, 40.15348], [-122.19882, 40.15345], [-122.19998, 40.15352], [-122.20195, 40.15398], [-122.20269, 40.15421], [-122.20483, 40.15503], [-122.20586, 40.1555], [-122.20655, 40.15604], [-122.2075, 40.15722], [-122.20818, 40.15788], [-122.20942, 40.15863], [-122.21037, 40.15927], [-122.21291, 40.16043], [-122.21403, 40.16104], [-122.21643, 40.16282], [-122.21836, 40.16477], [-122.21858, 40.16492], [-122.21914, 40.16583], [-122.21916, 40.16856]]], [[[-122.21331, 40.1589], [-122.21309, 40.15899], [-122.21248, 40.15887], [-122.21052, 40.15749], [-122.20954, 40.15666], [-122.20894, 40.15599], [-122.20978, 40.1562], [-122.21115, 40.157], [-122.21249, 40.15791], [-122.21289, 40.15825], [-122.21321, 40.15864], [-122.21331, 40.1589]]], [[[-122.68423, 40.04403], [-122.66608, 40.04437], [-122.66577, 40.02991], [-122.68398, 40.02961], [-122.68423, 40.04403]]]]} | Open Access 1 | 35035 | Red Bluff Recreation Area | 14102 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | http://www.fs.usda.gov/recarea/mendocino/recreation/recarea/?recid=25236 | Tehama 18 | 927.46 | Red Bluff Rec. Area | 0 | Recreation Management Area 49 | 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]);