units_with_maps

Table actions

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

1 row where AGNCY_TYP = 1, COUNTY = 58 and DES_TP = 1

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • National Public Lands · 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
11178 11178 11177 {"type": "MultiPolygon", "coordinates": [[[[-120.00657, 39.65015], [-120.00653, 39.66473], [-120.00116, 39.6647], [-120.00116, 39.66007], [-120.00121, 39.65009], [-120.00657, 39.65015]]], [[[-120.01404, 39.60717], [-120.00909, 39.60708], [-120.00903, 39.59956], [-120.01401, 39.59938], [-120.01404, 39.60717]]], [[[-120.03637, 39.65403], [-120.03614, 39.66141], [-120.03274, 39.66134], [-120.03265, 39.65409], [-120.03637, 39.65403]]], [[[-120.05121, 39.6505], [-120.04188, 39.65052], [-120.04178, 39.64678], [-120.05119, 39.64701], [-120.05121, 39.6505]]], [[[-120.05135, 39.63944], [-120.04179, 39.63956], [-120.04196, 39.6362], [-120.05135, 39.6363], [-120.05135, 39.63944]]], [[[-120.11132, 39.70868], [-120.11131, 39.70888], [-120.11124, 39.70889], [-120.09296, 39.70858], [-120.09296, 39.70852], [-120.11132, 39.70868]]], [[[-120.15173, 39.66909], [-120.15167, 39.68007], [-120.14703, 39.68012], [-120.14707, 39.69446], [-120.12876, 39.6946], [-120.12871, 39.68021], [-120.14703, 39.68011], [-120.14701, 39.66911], [-120.15173, 39.66909]]], [[[-120.16318, 39.67583], [-120.15826, 39.67603], [-120.15817, 39.67238], [-120.16306, 39.6722], [-120.16318, 39.67583]]], [[[-120.18386, 39.67978], [-120.18386, 39.69066], [-120.16568, 39.69038], [-120.16565, 39.68675], [-120.17407, 39.68688], [-120.17426, 39.67986], [-120.18386, 39.67978]]], [[[-120.21615, 39.69393], [-120.21132, 39.69397], [-120.21149, 39.70132], [-120.21152, 39.70795], [-120.20198, 39.7079], [-120.202, 39.70145], [-120.18826, 39.7016], [-120.18817, 39.69414], [-120.19277, 39.6941], [-120.19276, 39.68674], [-120.20206, 39.68665], [-120.20209, 39.6797], [-120.20654, 39.67968], [-120.20663, 39.68301], [-120.21136, 39.68299], [-120.21138, 39.68662], [-120.21608, 39.6866], [-120.21615, 39.69393]]], [[[-120.35307, 39.62169], [-120.353, 39.64703], [-120.34827, 39.64702], [-120.34825, 39.65063], [-120.34359, 39.65062], [-120.34364, 39.63607], [-120.34375, 39.62168], [-120.35307, 39.62169]]], [[[-120.34942, 39.6144], [-120.34475, 39.61442], [-120.34468, 39.60716], [-120.34937, 39.60713], [-120.34942, 39.6144]]], [[[-120.40897, 39.70472], [-120.40894, 39.70846], [-120.40427, 39.70845], [-120.40429, 39.70475], [-120.40897, 39.70472]]]]} Open Access 1 21456 BLM 16162 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1 http://www.blm.gov/wo/st/en.html US Bureau of Land Management 1 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1   Sierra 58 3385.091 BLM 1899 National Public Lands 1 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]);