units_with_maps

Table actions

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

1 row where COUNTY = 18 and DES_TP = 49

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Recreation Management Area · 1 ✖

ACCESS_TYP 1

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