units_with_maps

Table actions

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

1 row where UNIT_NAME = "Modoc National Wildlife Refuge"

This data as json, copyable, CSV (advanced)

These facets timed out: ACCESS_TYP, MNG_AGENCY

MNG_AG_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
15817 15817 15816 {"type": "MultiPolygon", "coordinates": [[[[-120.55429, 41.47581], [-120.55354, 41.47624], [-120.55341, 41.4763], [-120.55194, 41.47629], [-120.55188, 41.47621], [-120.55176, 41.47615], [-120.55156, 41.47611], [-120.55135, 41.47614], [-120.55122, 41.47621], [-120.55108, 41.47635], [-120.55093, 41.47655], [-120.53813, 41.47641], [-120.53784, 41.47637], [-120.53755, 41.47632], [-120.53708, 41.47618], [-120.53665, 41.47599], [-120.53642, 41.47585], [-120.53621, 41.47569], [-120.53591, 41.47539], [-120.53581, 41.47526], [-120.53568, 41.47505], [-120.53612, 41.47276], [-120.5363, 41.47275], [-120.5363, 41.46839], [-120.53559, 41.46838], [-120.53564, 41.46464], [-120.53532, 41.46393], [-120.53497, 41.46252], [-120.53463, 41.46192], [-120.53442, 41.46166], [-120.53483, 41.46143], [-120.53482, 41.46133], [-120.53469, 41.46123], [-120.53417, 41.46104], [-120.53394, 41.46082], [-120.53365, 41.46045], [-120.53333, 41.45972], [-120.53242, 41.45865], [-120.53182, 41.45767], [-120.53148, 41.45725], [-120.53094, 41.45689], [-120.52969, 41.45618], [-120.52948, 41.45593], [-120.52826, 41.45458], [-120.52767, 41.45381], [-120.5267, 41.45251], [-120.52627, 41.45153], [-120.52606, 41.45028], [-120.5261, 41.44501], [-120.52608, 41.43654], [-120.5261, 41.43291], [-120.52582, 41.42782], [-120.526, 41.4257], [-120.52615, 41.42569], [-120.52618, 41.4252], [-120.52625, 41.4247], [-120.52639, 41.42422], [-120.52651, 41.42389], [-120.5268, 41.4232], [-120.52695, 41.4229], [-120.52717, 41.42254], [-120.52735, 41.42227], [-120.5278, 41.42173], [-120.52977, 41.41968], [-120.5308, 41.41864], [-120.53121, 41.41811], [-120.53128, 41.41811], [-120.53148, 41.41787], [-120.53217, 41.417], [-120.53262, 41.41635], [-120.53312, 41.41553], [-120.53382, 41.41428], [-120.53411, 41.41383], [-120.53513, 41.41212], [-120.5353, 41.41158], [-120.53526, 41.40724], [-120.54198, 41.40699], [-120.54251, 41.41088], [-120.54323, 41.41221], [-120.54893, 41.45453], [-120.5497, 41.45453], [-120.54966, 41.45818], [-120.54966, 41.4655], [-120.55133, 41.46551], [-120.55155, 41.46702], [-120.55162, 41.46774], [-120.55315, 41.46814], [-120.55354, 41.46939], [-120.55401, 41.47002], [-120.55429, 41.47581]], [[-120.53061, 41.41949], [-120.53059, 41.41949], [-120.53048, 41.4257], [-120.53049, 41.42571], [-120.53062, 41.4257], [-120.5307, 41.42207], [-120.53061, 41.41949]]], [[[-120.58338, 41.4726], [-120.58337, 41.48006], [-120.57183, 41.48008], [-120.56886, 41.47506], [-120.56414, 41.47509], [-120.56414, 41.47647], [-120.55932, 41.47646], [-120.55931, 41.47365], [-120.56003, 41.47342], [-120.56011, 41.47323], [-120.56038, 41.47102], [-120.5593, 41.47093], [-120.55929, 41.467], [-120.55948, 41.46687], [-120.56409, 41.4656], [-120.56894, 41.46451], [-120.56897, 41.46914], [-120.57376, 41.46906], [-120.57376, 41.47272], [-120.58338, 41.4726]]], [[[-120.53511, 41.47819], [-120.53405, 41.47818], [-120.53404, 41.47811], [-120.53361, 41.47849], [-120.5336, 41.47992], [-120.53404, 41.47993], [-120.53404, 41.48002], [-120.53156, 41.48], [-120.53155, 41.47987], [-120.53133, 41.47985], [-120.53115, 41.4798], [-120.53095, 41.47972], [-120.53078, 41.47961], [-120.53066, 41.4795], [-120.53057, 41.47937], [-120.53051, 41.47921], [-120.53048, 41.47904], [-120.53031, 41.47903], [-120.53028, 41.47999], [-120.52547, 41.47995], [-120.5255, 41.48742], [-120.51074, 41.48731], [-120.50595, 41.48735], [-120.50593, 41.48356], [-120.50595, 41.47986], [-120.50945, 41.47974], [-120.51002, 41.47926], [-120.51152, 41.47892], [-120.51157, 41.47257], [-120.51561, 41.4726], [-120.51563, 41.46943], [-120.50598, 41.46934], [-120.50599, 41.46543], [-120.50602, 41.4654], [-120.50619, 41.46543], [-120.5062, 41.46542], [-120.50624, 41.4618], [-120.50632, 41.46145], [-120.50556, 41.46114], [-120.50534, 41.46114], [-120.50509, 41.46119], [-120.5043, 41.4614], [-120.50402, 41.46142], [-120.50345, 41.46142], [-120.50317, 41.46139], [-120.50284, 41.46133], [-120.50254, 41.46123], [-120.50217, 41.46105], [-120.50197, 41.46093], [-120.50168, 41.46069], [-120.5015, 41.46048], [-120.50131, 41.46019], [-120.50121, 41.45989], [-120.50121, 41.45889], [-120.50132, 41.4585], [-120.50141, 41.45825], [-120.50299, 41.45452], [-120.49626, 41.4545], [-120.4866, 41.4545], [-120.48661, 41.45085], [-120.48167, 41.45079], [-120.48153, 41.44718], [-120.48162, 41.44353], [-120.48168, 41.44183], [-120.48407, 41.44181], [-120.484, 41.43997], [-120.50108, 41.44008], [-120.50109, 41.44369], [-120.50582, 41.44374], [-120.50583, 41.44373], [-120.50584, 41.4401], [-120.51553, 41.44014], [-120.51551, 41.44377], [-120.52567, 41.4438], [-120.52564, 41.44755], [-120.52565, 41.45018], [-120.52543, 41.45042], [-120.52566, 41.45139], [-120.52663, 41.4534], [-120.52746, 41.45438], [-120.53089, 41.45808], [-120.53116, 41.45832], [-120.53258, 41.46015], [-120.5332, 41.46263], [-120.53066, 41.4626], [-120.53062, 41.4655], [-120.53371, 41.46549], [-120.53418, 41.46804], [-120.5342, 41.46862], [-120.53418, 41.46879], [-120.53413, 41.46895], [-120.53407, 41.46911], [-120.53398, 41.46926], [-120.53379, 41.4695], [-120.5335, 41.46974], [-120.53321, 41.46991], [-120.53295, 41.47002], [-120.5326, 41.47011], [-120.53217, 41.47016], [-120.53137, 41.47029], [-120.53138, 41.46923], [-120.53062, 41.46922], [-120.53061, 41.47068], [-120.53218, 41.47044], [-120.53278, 41.47044], [-120.5335, 41.47062], [-120.53392, 41.47082], [-120.53426, 41.47111], [-120.53456, 41.47158], [-120.53514, 41.4733], [-120.53511, 41.47819]], [[-120.52546, 41.47994], [-120.52554, 41.47592], [-120.52338, 41.47591], [-120.5233, 41.47993], [-120.52546, 41.47994]]], [[[-120.49574, 41.47996], [-120.49352, 41.48076], [-120.49051, 41.48202], [-120.48966, 41.4825], [-120.48887, 41.48354], [-120.48888, 41.48355], [-120.49119, 41.48355], [-120.4912, 41.49023], [-120.49144, 41.4909], [-120.49155, 41.49127], [-120.49153, 41.49178], [-120.49141, 41.49212], [-120.4912, 41.49262], [-120.4912, 41.4945], [-120.48632, 41.49446], [-120.48632, 41.49478], [-120.48184, 41.49548], [-120.47788, 41.49615], [-120.4764, 41.49635], [-120.47497, 41.49668], [-120.47156, 41.4985], [-120.47145, 41.49055], [-120.47142, 41.4905], [-120.47145, 41.49051], [-120.47146, 41.4905], [-120.47143, 41.48691], [-120.46649, 41.48681], [-120.46656, 41.47957], [-120.47151, 41.47965], [-120.47155, 41.47233], [-120.4765, 41.47237], [-120.47641, 41.48335], [-120.48626, 41.48355], [-120.48628, 41.47986], [-120.49574, 41.47996]]]]} Restricted Access 2 8934 Modoc National Wildlife Refuge 22345 106 United States Fish and Wildlife Service 45 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1   Modoc 56 7101.15 Modoc NWR 1961 National Wildlife Refuge 105 2

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