units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 1, COUNTY = 41 and DES_TP = 1

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 3 ✖
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
13996 13996 13995 {"type": "Polygon", "coordinates": [[[-121.25323, 38.55936], [-121.2475, 38.55947], [-121.24737, 38.55661], [-121.24799, 38.55691], [-121.24868, 38.55735], [-121.24949, 38.55796], [-121.24999, 38.55811], [-121.25026, 38.55828], [-121.2505, 38.5584], [-121.25086, 38.55851], [-121.25148, 38.55861], [-121.2527, 38.55892], [-121.25299, 38.55896], [-121.25311, 38.559], [-121.25319, 38.55919], [-121.25323, 38.55936]]]} Open Access 1 37011 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   Sacramento 41 18.301 BLM 1899 National Public Lands 1 3
14010 14010 14009 {"type": "MultiPolygon", "coordinates": [[[[-121.16971, 38.68968], [-121.16956, 38.68978], [-121.16947, 38.69003], [-121.16953, 38.69019], [-121.16953, 38.69051], [-121.16963, 38.69076], [-121.16946, 38.69103], [-121.16939, 38.69126], [-121.16939, 38.69191], [-121.16934, 38.69192], [-121.16934, 38.69204], [-121.16816, 38.692], [-121.16732, 38.69206], [-121.16968, 38.68799], [-121.16971, 38.68968]]], [[[-121.17481, 38.68485], [-121.17481, 38.68485], [-121.17297, 38.68484], [-121.17407, 38.68395], [-121.17479, 38.68369], [-121.17481, 38.68485]]]]} Open Access 1 37012 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   Sacramento 41 13.162 BLM 1899 National Public Lands 1 3
14011 14011 14010 {"type": "MultiPolygon", "coordinates": [[[[-121.39308, 38.25788], [-121.39282, 38.25793], [-121.3912, 38.25765], [-121.39053, 38.25736], [-121.38989, 38.25736], [-121.38815, 38.25765], [-121.38745, 38.25829], [-121.38611, 38.25886], [-121.38527, 38.25893], [-121.38449, 38.25916], [-121.38449, 38.25883], [-121.38479, 38.25866], [-121.38562, 38.25835], [-121.38586, 38.25835], [-121.38673, 38.25793], [-121.38738, 38.25729], [-121.38738, 38.25722], [-121.38765, 38.25708], [-121.38841, 38.25699], [-121.3889, 38.25681], [-121.3894, 38.25639], [-121.38971, 38.25633], [-121.3905, 38.25651], [-121.39282, 38.25733], [-121.39308, 38.25765], [-121.39308, 38.25788]]], [[[-121.42286, 38.26178], [-121.42263, 38.26219], [-121.42237, 38.26226], [-121.42216, 38.26217], [-121.42211, 38.26176], [-121.42199, 38.26167], [-121.42004, 38.2622], [-121.42002, 38.2626], [-121.42022, 38.26286], [-121.42016, 38.2632], [-121.41981, 38.26391], [-121.41984, 38.26491], [-121.41973, 38.26515], [-121.41975, 38.26549], [-121.41993, 38.2656], [-121.42039, 38.26572], [-121.42059, 38.26595], [-121.42054, 38.26606], [-121.4199, 38.26618], [-121.41978, 38.26629], [-121.4197, 38.26661], [-121.41981, 38.2667], [-121.42123, 38.267], [-121.42117, 38.26716], [-121.42074, 38.26732], [-121.42065, 38.26748], [-121.42068, 38.26794], [-121.4208, 38.26844], [-121.42112, 38.26869], [-121.4211, 38.26875], [-121.42063, 38.26884], [-121.4222, 38.27507], [-121.42168, 38.27584], [-121.41959, 38.27586], [-121.41964, 38.28201], [-121.41166, 38.28198], [-121.4117, 38.27587], [-121.41178, 38.27586], [-121.41179, 38.2744], [-121.41042, 38.27372], [-121.40891, 38.27284], [-121.40773, 38.27283], [-121.40611, 38.27164], [-121.40584, 38.27084], [-121.40484, 38.26957], [-121.41045, 38.2696], [-121.41053, 38.26001], [-121.41761, 38.26002], [-121.41768, 38.26083], [-121.41767, 38.26132], [-121.42249, 38.26133], [-121.42286, 38.26155], [-121.42286, 38.26178]]]]} Open Access 1 37014 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   Sacramento 41 549.812 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]);