units_with_maps

Table actions

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

1 row where COUNTY = 37 and MNG_AGENCY = 1

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • United States Bureau of Land Management · 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
11251 11251 11250 {"type": "MultiPolygon", "coordinates": [[[[-120.81619, 36.87248], [-120.81613, 36.87486], [-120.81608, 36.87965], [-120.81172, 36.87958], [-120.81232, 36.8833], [-120.80781, 36.88321], [-120.8072, 36.8795], [-120.80734, 36.87503], [-120.80738, 36.87225], [-120.8074, 36.86882], [-120.81191, 36.8689], [-120.81188, 36.8724], [-120.81619, 36.87248]]], [[[-120.86716, 36.80008], [-120.86715, 36.80731], [-120.85823, 36.8071], [-120.85819, 36.79988], [-120.86716, 36.80008]]], [[[-120.93752, 36.78778], [-120.93744, 36.79504], [-120.93387, 36.79478], [-120.93395, 36.78752], [-120.9307, 36.78692], [-120.93067, 36.78731], [-120.9306, 36.79419], [-120.92187, 36.79259], [-120.92184, 36.79484], [-120.92181, 36.79618], [-120.91575, 36.79507], [-120.91296, 36.79458], [-120.913, 36.79099], [-120.91302, 36.78376], [-120.91302, 36.77637], [-120.90375, 36.77718], [-120.90393, 36.75895], [-120.90846, 36.75854], [-120.90846, 36.76226], [-120.91298, 36.76186], [-120.92201, 36.76256], [-120.92202, 36.76642], [-120.93109, 36.76715], [-120.93109, 36.76328], [-120.93246, 36.76339], [-120.93406, 36.78016], [-120.93405, 36.78252], [-120.93397, 36.78735], [-120.93395, 36.7875], [-120.93752, 36.78778]]], [[[-120.92713, 36.75924], [-120.92173, 36.75881], [-120.91301, 36.75816], [-120.913, 36.75436], [-120.90847, 36.75477], [-120.90846, 36.75107], [-120.90561, 36.75133], [-120.90726, 36.74998], [-120.91299, 36.74539], [-120.91299, 36.74679], [-120.92647, 36.74619], [-120.92712, 36.7467], [-120.92713, 36.75924]]], [[[-120.96079, 36.78862], [-120.96008, 36.78864], [-120.95118, 36.78871], [-120.95116, 36.78918], [-120.95115, 36.79235], [-120.94664, 36.79204], [-120.94667, 36.78841], [-120.94216, 36.7881], [-120.94217, 36.78446], [-120.93758, 36.78413], [-120.93762, 36.78039], [-120.93762, 36.77461], [-120.93838, 36.7746], [-120.93838, 36.77223], [-120.95118, 36.77242], [-120.95977, 36.77252], [-120.95976, 36.77452], [-120.96078, 36.77452], [-120.96077, 36.78128], [-120.96079, 36.78862]]], [[[-120.94247, 36.81582], [-120.94247, 36.81582], [-120.93889, 36.81321], [-120.94243, 36.81328], [-120.94247, 36.81582]]], [[[-121.14563, 36.92035], [-121.14558, 36.92398], [-121.14415, 36.92394], [-121.1442, 36.92032], [-121.14563, 36.92035]]], [[[-121.14584, 36.90514], [-121.14576, 36.91255], [-121.14432, 36.91252], [-121.14438, 36.90874], [-121.1444, 36.90511], [-121.14584, 36.90514]]], [[[-121.14781, 36.85234], [-121.1461, 36.85231], [-121.14611, 36.84976], [-121.14626, 36.84999], [-121.14652, 36.85017], [-121.14672, 36.85036], [-121.14685, 36.85059], [-121.14715, 36.85148], [-121.14729, 36.85168], [-121.14746, 36.85199], [-121.14766, 36.85221], [-121.14781, 36.85234]]], [[[-121.17305, 36.90515], [-121.17296, 36.91251], [-121.16391, 36.91258], [-121.16384, 36.92004], [-121.15933, 36.92011], [-121.15939, 36.91257], [-121.15939, 36.90878], [-121.16391, 36.90878], [-121.16848, 36.90875], [-121.16849, 36.90518], [-121.17305, 36.90515]]]]} Open Access 1 21632 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   Merced 37 3993.055 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]);