units_with_maps

Table actions

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

1 row where ACCESS_TYP = 3, COUNTY = 55 and MNG_AGENCY = 44

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • United States Fish and Wildlife Service · 1 ✖

ACCESS_TYP 1

  • No Public Access · 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
15846 15846 15845 {"type": "MultiPolygon", "coordinates": [[[[-122.19365, 39.41663], [-122.19259, 39.41662], [-122.1926, 39.41509], [-122.19257, 39.4127], [-122.19286, 39.41004], [-122.19291, 39.40937], [-122.19291, 39.40713], [-122.19352, 39.40712], [-122.19387, 39.40745], [-122.1947, 39.40842], [-122.19506, 39.40936], [-122.19506, 39.40977], [-122.19493, 39.41059], [-122.19488, 39.41125], [-122.19465, 39.41219], [-122.19365, 39.41663]]], [[[-122.00865, 39.41919], [-122.00773, 39.41956], [-122.00761, 39.41956], [-122.00723, 39.41991], [-122.00383, 39.42133], [-122.00351, 39.42133], [-122.0027, 39.42194], [-122.0027, 39.42232], [-122.00189, 39.42357], [-122.00196, 39.42407], [-122.00155, 39.42434], [-121.99968, 39.42461], [-121.99888, 39.42512], [-121.99895, 39.42522], [-121.99767, 39.42601], [-121.99697, 39.42568], [-121.99605, 39.42558], [-121.99539, 39.42539], [-121.99507, 39.42534], [-121.99506, 39.4253], [-121.99478, 39.42522], [-121.99348, 39.4249], [-121.99322, 39.42472], [-121.9927, 39.42445], [-121.9922, 39.42404], [-121.99147, 39.42386], [-121.99166, 39.42352], [-121.99178, 39.42326], [-121.99183, 39.42308], [-121.99191, 39.42257], [-121.99231, 39.4191], [-121.99231, 39.4183], [-121.99232, 39.41258], [-121.99092, 39.41257], [-121.98999, 39.40997], [-121.99233, 39.40997], [-121.99233, 39.4119], [-122.00733, 39.41168], [-122.00744, 39.41175], [-122.0079, 39.41307], [-122.00618, 39.41351], [-122.00181, 39.41373], [-121.9993, 39.41447], [-121.99703, 39.41439], [-121.99702, 39.4144], [-121.99719, 39.41451], [-121.9983, 39.41459], [-121.99959, 39.41451], [-122.00194, 39.41382], [-122.00547, 39.41364], [-122.00653, 39.41355], [-122.00807, 39.4132], [-122.00844, 39.41433], [-122.00845, 39.41461], [-122.00827, 39.41463], [-122.00822, 39.41543], [-122.00855, 39.41622], [-122.00849, 39.41686], [-122.00881, 39.4183], [-122.00865, 39.41919]], [[-121.99745, 39.41496], [-121.99745, 39.41494], [-121.99698, 39.41491], [-121.99608, 39.41436], [-121.99605, 39.41436], [-121.99704, 39.41497], [-121.99745, 39.41496]], [[-121.99418, 39.41349], [-121.99418, 39.41351], [-121.99432, 39.41358], [-121.99461, 39.41359], [-121.99532, 39.4134], [-121.99514, 39.41329], [-121.99418, 39.41349]], [[-121.99339, 39.41311], [-121.99338, 39.41313], [-121.99373, 39.4133], [-121.99394, 39.41339], [-121.99339, 39.41311]], [[-121.99234, 39.41217], [-121.99232, 39.41217], [-121.99232, 39.41224], [-121.99242, 39.41226], [-121.99242, 39.41224], [-121.99234, 39.41217]]], [[[-122.00771, 39.43378], [-122.00759, 39.43395], [-122.00754, 39.43401], [-122.00765, 39.43375], [-122.00771, 39.43378]]], [[[-122.19222, 39.45106], [-122.15541, 39.45123], [-122.1366, 39.45121], [-122.13641, 39.4367], [-122.13643, 39.43552], [-122.13629, 39.42078], [-122.13626, 39.41463], [-122.13607, 39.41462], [-122.13618, 39.41461], [-122.13616, 39.40624], [-122.13609, 39.39468], [-122.136, 39.3855], [-122.15517, 39.38546], [-122.19167, 39.38531], [-122.19166, 39.38533], [-122.192, 39.40708], [-122.19196, 39.41087], [-122.19209, 39.43666], [-122.19216, 39.4386], [-122.19222, 39.45106]]], [[[-122.01729, 39.44905], [-122.01406, 39.44897], [-122.01268, 39.44927], [-122.01268, 39.44929], [-122.01729, 39.44978], [-122.01724, 39.45059], [-122.01697, 39.45129], [-122.01681, 39.45316], [-122.01508, 39.45432], [-122.01408, 39.45546], [-122.01247, 39.45611], [-122.00967, 39.4562], [-122.00966, 39.45667], [-122.0087, 39.45661], [-122.00589, 39.45653], [-122.00302, 39.45673], [-122.00105, 39.45692], [-121.99935, 39.45696], [-121.99895, 39.45698], [-121.99945, 39.45642], [-121.99798, 39.45443], [-121.99785, 39.45334], [-121.99593, 39.45068], [-121.99613, 39.44992], [-121.996, 39.44991], [-121.99592, 39.44594], [-121.99705, 39.44339], [-121.99853, 39.44241], [-121.99989, 39.44057], [-122.0006, 39.43923], [-122.00086, 39.43913], [-122.0022, 39.43891], [-122.0032, 39.43883], [-122.00306, 39.43712], [-122.01159, 39.43731], [-122.01276, 39.44151], [-122.01353, 39.44228], [-122.01405, 39.44274], [-122.01449, 39.44354], [-122.01729, 39.44905]]], [[[-122.01144, 39.47612], [-122.00951, 39.47537], [-122.00697, 39.47478], [-122.00646, 39.47497], [-122.00535, 39.47499], [-122.00511, 39.47502], [-122.00219, 39.47567], [-121.99899, 39.47573], [-121.99887, 39.47434], [-121.99891, 39.47393], [-121.99872, 39.47367], [-121.99856, 39.47292], [-121.9982, 39.47263], [-121.99716, 39.47086], [-121.9964, 39.46985], [-121.99586, 39.46894], [-121.99571, 39.46861], [-121.99555, 39.46756], [-121.99599, 39.46614], [-121.99642, 39.46523], [-121.9967, 39.46539], [-121.99701, 39.46445], [-121.99713, 39.46199], [-121.99664, 39.46059], [-121.99648, 39.46018], [-121.99598, 39.46044], [-121.99511, 39.46008], [-121.99681, 39.45985], [-121.99931, 39.45737], [-122.00931, 39.45722], [-122.00978, 39.45843], [-122.01052, 39.45954], [-122.01067, 39.4598], [-122.01051, 39.4599], [-122.01101, 39.46099], [-122.01119, 39.46288], [-122.01087, 39.46459], [-122.01012, 39.46654], [-122.0102, 39.4671], [-122.01012, 39.46745], [-122.0093, 39.46869], [-122.00775, 39.47005], [-122.00814, 39.47042], [-122.00847, 39.47047], [-122.00907, 39.47034], [-122.00977, 39.47066], [-122.00993, 39.47095], [-122.01033, 39.47098], [-122.0107, 39.47121], [-122.01085, 39.47224], [-122.01102, 39.47227], [-122.01144, 39.47612]]]]} No Public Access 3 25348 Sacramento River National Wildlife Refuge 24770 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   Glenn 55 10475.622 Sacramento River NWR 1989 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]);