units_with_maps

Table actions

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

1 row where COUNTY = 24 and DES_TP = 82

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Resource 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
13002 13002 13001 {"type": "Polygon", "coordinates": [[[-123.18969, 39.19385], [-123.18868, 39.19444], [-123.18745, 39.19594], [-123.18723, 39.19605], [-123.18768, 39.19623], [-123.18788, 39.19648], [-123.18729, 39.19717], [-123.1881, 39.19824], [-123.18711, 39.19867], [-123.18619, 39.19918], [-123.18623, 39.19956], [-123.18722, 39.19954], [-123.18724, 39.19966], [-123.18725, 39.20048], [-123.18723, 39.2011], [-123.18767, 39.20122], [-123.18819, 39.20129], [-123.18857, 39.20148], [-123.18872, 39.20174], [-123.1888, 39.20198], [-123.18878, 39.20227], [-123.18855, 39.20273], [-123.18688, 39.20339], [-123.18685, 39.20515], [-123.18808, 39.20632], [-123.18806, 39.20806], [-123.18769, 39.21058], [-123.18551, 39.21061], [-123.18568, 39.21192], [-123.18521, 39.21195], [-123.18556, 39.21298], [-123.18536, 39.21329], [-123.18485, 39.21399], [-123.18578, 39.21499], [-123.18697, 39.21652], [-123.18498, 39.21651], [-123.18565, 39.21901], [-123.18318, 39.21979], [-123.18179, 39.22083], [-123.18131, 39.22122], [-123.18292, 39.22212], [-123.18356, 39.22336], [-123.18468, 39.22568], [-123.18484, 39.22592], [-123.18496, 39.22779], [-123.18497, 39.23], [-123.18504, 39.23102], [-123.18504, 39.23139], [-123.18489, 39.23301], [-123.1848, 39.23465], [-123.18476, 39.23507], [-123.18451, 39.23522], [-123.18403, 39.23564], [-123.18216, 39.23709], [-123.18297, 39.23718], [-123.18274, 39.23902], [-123.18383, 39.23906], [-123.18469, 39.2393], [-123.18467, 39.24057], [-123.18271, 39.24068], [-123.17973, 39.24059], [-123.17686, 39.2401], [-123.1747, 39.23893], [-123.17133, 39.23855], [-123.16923, 39.2392], [-123.16719, 39.23903], [-123.1665, 39.23906], [-123.16412, 39.23877], [-123.16311, 39.23862], [-123.1631, 39.23845], [-123.16015, 39.23882], [-123.15948, 39.23875], [-123.15876, 39.23878], [-123.15489, 39.23751], [-123.15465, 39.2368], [-123.15307, 39.23719], [-123.153, 39.23736], [-123.15291, 39.23749], [-123.15289, 39.23755], [-123.1528, 39.23771], [-123.15269, 39.23783], [-123.15242, 39.23798], [-123.15232, 39.23799], [-123.15222, 39.23798], [-123.15214, 39.23793], [-123.15204, 39.23779], [-123.15202, 39.23765], [-123.15203, 39.23744], [-123.15072, 39.23776], [-123.15066, 39.23518], [-123.15065, 39.2333], [-123.16272, 39.23321], [-123.16274, 39.23021], [-123.16012, 39.22825], [-123.15878, 39.22847], [-123.1587, 39.22684], [-123.1587, 39.22437], [-123.15878, 39.22154], [-123.15875, 39.22073], [-123.16012, 39.2208], [-123.16013, 39.22017], [-123.15454, 39.2148], [-123.15502, 39.21386], [-123.15563, 39.21221], [-123.15913, 39.21217], [-123.15927, 39.20985], [-123.16014, 39.20967], [-123.16245, 39.20907], [-123.16256, 39.20874], [-123.16335, 39.20876], [-123.16426, 39.2077], [-123.16427, 39.20746], [-123.16426, 39.20746], [-123.16273, 39.20776], [-123.16014, 39.20755], [-123.15926, 39.20763], [-123.15856, 39.20697], [-123.15738, 39.20541], [-123.15661, 39.20285], [-123.15524, 39.20266], [-123.1552, 39.20336], [-123.15297, 39.20333], [-123.15306, 39.19975], [-123.15552, 39.19975], [-123.15555, 39.196], [-123.16017, 39.19594], [-123.16018, 39.19242], [-123.16047, 39.19248], [-123.16838, 39.19245], [-123.1694, 39.18962], [-123.16985, 39.18894], [-123.17206, 39.18893], [-123.17381, 39.18831], [-123.1738, 39.18951], [-123.17522, 39.18949], [-123.17523, 39.19041], [-123.17517, 39.19248], [-123.17776, 39.19251], [-123.1785, 39.19144], [-123.17799, 39.19083], [-123.17835, 39.1904], [-123.18123, 39.19038], [-123.18243, 39.19216], [-123.18258, 39.19232], [-123.18276, 39.19243], [-123.18315, 39.19252], [-123.18444, 39.19253], [-123.18488, 39.19271], [-123.18508, 39.19298], [-123.18512, 39.19315], [-123.18531, 39.19312], [-123.18549, 39.19305], [-123.18572, 39.19303], [-123.18615, 39.19307], [-123.18641, 39.19301], [-123.18685, 39.19276], [-123.18777, 39.19253], [-123.18739, 39.19398], [-123.18944, 39.1937], [-123.18969, 39.19385]]]} Open Access 1 31030 Lake Mendocino 13566 100 United States Army Corps of Engineers 146 Federal 1 Federal Agency 1 http://www.usace.army.mil/ Other Federal 13 100 United States Army Corps of Engineers 142 Federal 1 Federal Agency 1 http://corpslakes.usace.army.mil/visitors/projects.cfm?Id=L374645 Mendocino 24 3201.844 Lake Mendocino 0 Resource Management Area 82 3

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