units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

4 rows where ACCESS_TYP = 1, DES_TP = 49 and LAYER = 7

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 4 ✖
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

CSV options: 

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]);