units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 2, COUNTY = 34 and MNG_AGENCY = 1

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • United States Bureau of Land Management · 2 ✖

ACCESS_TYP 1

  • Restricted Access · 2 ✖
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
13036 13036 13035 {"type": "MultiPolygon", "coordinates": [[[[-120.89266, 38.89126], [-120.89257, 38.89479], [-120.89056, 38.89479], [-120.89053, 38.89645], [-120.89055, 38.8965], [-120.89052, 38.89651], [-120.89051, 38.89665], [-120.89026, 38.89606], [-120.88994, 38.89557], [-120.8897, 38.89539], [-120.8902, 38.89507], [-120.8902, 38.89505], [-120.88701, 38.89192], [-120.8863, 38.89232], [-120.88538, 38.89288], [-120.88669, 38.89416], [-120.88634, 38.89408], [-120.88574, 38.89398], [-120.88504, 38.89384], [-120.88368, 38.89339], [-120.88316, 38.89325], [-120.88272, 38.89324], [-120.88239, 38.89325], [-120.88173, 38.89342], [-120.88175, 38.89109], [-120.88161, 38.88749], [-120.88598, 38.88758], [-120.88601, 38.88811], [-120.88448, 38.8884], [-120.88543, 38.89022], [-120.88525, 38.89116], [-120.88723, 38.89118], [-120.8875, 38.89026], [-120.89055, 38.89032], [-120.89056, 38.89124], [-120.89266, 38.89126]]], [[[-120.89052, 38.89708], [-120.8905, 38.89832], [-120.88629, 38.89826], [-120.88628, 38.8948], [-120.88172, 38.89471], [-120.88173, 38.89359], [-120.88261, 38.89353], [-120.88289, 38.89353], [-120.88321, 38.89357], [-120.88468, 38.89404], [-120.88557, 38.89425], [-120.88708, 38.89452], [-120.88862, 38.89603], [-120.88939, 38.89557], [-120.88966, 38.89576], [-120.89001, 38.89629], [-120.89025, 38.8967], [-120.89052, 38.89708]]], [[[-120.90802, 38.89769], [-120.90801, 38.8995], [-120.90421, 38.90102], [-120.90182, 38.89809], [-120.89949, 38.89818], [-120.89948, 38.89819], [-120.90211, 38.9014], [-120.90057, 38.90137], [-120.89993, 38.90132], [-120.89957, 38.90128], [-120.8991, 38.90119], [-120.89758, 38.90074], [-120.89596, 38.90018], [-120.89767, 38.90006], [-120.89943, 38.89996], [-120.89948, 38.89911], [-120.89947, 38.89808], [-120.90172, 38.89795], [-120.90373, 38.89788], [-120.90802, 38.89769]]], [[[-120.908, 38.89979], [-120.90797, 38.90135], [-120.90794, 38.90478], [-120.90656, 38.90475], [-120.90316, 38.90188], [-120.90172, 38.90292], [-120.90342, 38.90439], [-120.90344, 38.90474], [-120.90345, 38.90756], [-120.90024, 38.90617], [-120.89942, 38.90698], [-120.89945, 38.90553], [-120.89607, 38.90576], [-120.89515, 38.90581], [-120.89522, 38.90208], [-120.89524, 38.90015], [-120.89592, 38.90046], [-120.89747, 38.90106], [-120.89842, 38.90136], [-120.89937, 38.90157], [-120.90043, 38.90171], [-120.90143, 38.90177], [-120.90226, 38.90178], [-120.90291, 38.90174], [-120.90321, 38.90174], [-120.90373, 38.90161], [-120.90439, 38.90138], [-120.90532, 38.90099], [-120.90561, 38.90082], [-120.908, 38.89979]]]]} Restricted Access 2 34872 BLM 16163 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   El Dorado 34 313.299 BLM 1963 National Public Lands 1 3
13037 13037 13036 {"type": "MultiPolygon", "coordinates": [[[[-120.91216, 38.91541], [-120.91209, 38.91725], [-120.90299, 38.9179], [-120.90314, 38.91614], [-120.91216, 38.91541]]], [[[-120.91554, 38.91278], [-120.91489, 38.9134], [-120.91489, 38.91518], [-120.91293, 38.91536], [-120.9126, 38.91537], [-120.91264, 38.91385], [-120.91256, 38.91389], [-120.90898, 38.91085], [-120.908, 38.91025], [-120.90805, 38.90805], [-120.91228, 38.90808], [-120.9148, 38.90807], [-120.91488, 38.91165], [-120.91488, 38.91253], [-120.9149, 38.91254], [-120.91511, 38.91239], [-120.91554, 38.91278]]]]} Restricted Access 2 34873 BLM 16163 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   El Dorado 34 121.211 BLM 1963 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]);