units_with_maps

Table actions

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

1 row where AGNCY_NAME = 1, DES_TP = 1017 and MNG_AG_TYP = 1

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Federal Agency · 1 ✖

DES_TP 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
11451 11451 11450 {"type": "MultiPolygon", "coordinates": [[[[-116.59234, 34.03268], [-116.5923, 34.0347], [-116.59123, 34.03474], [-116.59115, 34.03652], [-116.58466, 34.03678], [-116.58481, 34.03853], [-116.5809, 34.0386], [-116.58091, 34.04038], [-116.57644, 34.04023], [-116.57642, 34.04155], [-116.57328, 34.04159], [-116.57, 34.04162], [-116.56986, 34.04692], [-116.56352, 34.04691], [-116.56354, 34.05456], [-116.55475, 34.05448], [-116.55492, 34.05811], [-116.56122, 34.05806], [-116.56128, 34.05923], [-116.55487, 34.0591], [-116.55488, 34.0601], [-116.55259, 34.06009], [-116.55251, 34.0614], [-116.5501, 34.0614], [-116.54994, 34.06339], [-116.54835, 34.06346], [-116.54828, 34.06424], [-116.54626, 34.06421], [-116.54624, 34.06519], [-116.53262, 34.06536], [-116.53247, 34.07285], [-116.51983, 34.07282], [-116.51988, 34.06964], [-116.51517, 34.06958], [-116.51515, 34.07569], [-116.51343, 34.0757], [-116.51333, 34.07759], [-116.51126, 34.07747], [-116.51124, 34.07925], [-116.50641, 34.07913], [-116.50655, 34.08834], [-116.50548, 34.08832], [-116.50565, 34.09019], [-116.49264, 34.09016], [-116.49274, 34.09717], [-116.49033, 34.09701], [-116.4903, 34.09914], [-116.49031, 34.09915], [-116.49276, 34.09914], [-116.49281, 34.1027], [-116.49049, 34.10282], [-116.49064, 34.10459], [-116.48031, 34.1046], [-116.48035, 34.10279], [-116.48167, 34.10281], [-116.48147, 34.10097], [-116.48384, 34.10094], [-116.48374, 34.09934], [-116.48492, 34.09922], [-116.48503, 34.10082], [-116.48684, 34.10087], [-116.48689, 34.0955], [-116.48821, 34.09556], [-116.48805, 34.09156], [-116.49033, 34.09162], [-116.49023, 34.09017], [-116.49264, 34.09015], [-116.49279, 34.07579], [-116.49276, 34.07578], [-116.49276, 34.07564], [-116.47486, 34.07595], [-116.45762, 34.07597], [-116.45749, 34.04727], [-116.45702, 34.03291], [-116.47522, 34.03278], [-116.49258, 34.03289], [-116.4927, 34.03289], [-116.49271, 34.03282], [-116.50153, 34.03285], [-116.50154, 34.03287], [-116.5104, 34.03285], [-116.51135, 34.03285], [-116.51135, 34.0331], [-116.5124, 34.03294], [-116.5902, 34.03278], [-116.59234, 34.03268]], [[-116.49261, 34.06174], [-116.49262, 34.06173], [-116.49247, 34.04721], [-116.48377, 34.04722], [-116.48374, 34.06177], [-116.49261, 34.06174]]], [[[-116.52859, 34.13276], [-116.52407, 34.13273], [-116.52413, 34.13143], [-116.52327, 34.13146], [-116.52251, 34.12986], [-116.52392, 34.12954], [-116.52402, 34.12872], [-116.51927, 34.12869], [-116.51926, 34.1287], [-116.51951, 34.1302], [-116.51394, 34.13273], [-116.51117, 34.13274], [-116.51124, 34.1208], [-116.49298, 34.12073], [-116.49296, 34.11736], [-116.49486, 34.11749], [-116.49488, 34.11668], [-116.49809, 34.11667], [-116.49814, 34.11471], [-116.49949, 34.11475], [-116.4995, 34.11474], [-116.4994, 34.11285], [-116.49293, 34.11273], [-116.49285, 34.10822], [-116.49684, 34.10815], [-116.4972, 34.1046], [-116.50082, 34.10465], [-116.50082, 34.10624], [-116.50349, 34.10627], [-116.50381, 34.10466], [-116.51143, 34.10466], [-116.51113, 34.11831], [-116.51416, 34.11832], [-116.51433, 34.11849], [-116.51481, 34.11846], [-116.51518, 34.11852], [-116.51538, 34.11911], [-116.51572, 34.11928], [-116.51629, 34.11937], [-116.51724, 34.11932], [-116.51779, 34.11912], [-116.5186, 34.11946], [-116.5186, 34.11969], [-116.5188, 34.12005], [-116.51931, 34.12023], [-116.51985, 34.12026], [-116.52008, 34.12043], [-116.52049, 34.12068], [-116.52062, 34.12082], [-116.52092, 34.12108], [-116.5212, 34.12105], [-116.52187, 34.12102], [-116.52204, 34.12125], [-116.52225, 34.12142], [-116.52343, 34.12171], [-116.52377, 34.12199], [-116.52421, 34.12219], [-116.52451, 34.12242], [-116.52468, 34.12267], [-116.52475, 34.12301], [-116.52512, 34.12318], [-116.52566, 34.12324], [-116.52613, 34.12392], [-116.52681, 34.12431], [-116.52735, 34.12446], [-116.52792, 34.12446], [-116.52802, 34.12457], [-116.52858, 34.1249], [-116.52859, 34.13276]], [[-116.50294, 34.11678], [-116.50298, 34.11475], [-116.50159, 34.11474], [-116.50156, 34.11287], [-116.50032, 34.11286], [-116.50047, 34.11673], [-116.50294, 34.11678]]]]} Open Access 1 23057 Big Morongo Canyon Preserve 16082 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   San Bernardino 22 12367.553 Big Morongo Canyon Preserve   None 1017  

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