home / github

Menu
  • Search all tables
  • GraphQL API

issues

Table actions
  • GraphQL API for issues

2 rows where type = "issue" and user = 4701070 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date), closed_at (date)

state 2

  • closed 1
  • open 1

type 1

  • issue · 2 ✖

repo 1

  • xarray 2
id node_id number title user state locked assignee milestone comments created_at updated_at ▲ closed_at author_association active_lock_reason draft pull_request body reactions performed_via_github_app state_reason repo type
264321376 MDU6SXNzdWUyNjQzMjEzNzY= 1621 Undesired decoding to timedelta64 (was: units of "seconds" translated to time coordinate) pacioos 4701070 open 0     16 2017-10-10T17:58:45Z 2022-05-01T08:49:43Z   NONE      

When using open_dataset( ), it is translating data variables with units of "seconds" to time coordinates. For example, measurements of wave period. I don't believe xarray should treat variables as time coordinates unless their units are of "seconds since...". I have noticed that changing my units to "second" or "sec" or "s" prevents xarray from translating the variable to datetime64 and keeps it float64, as desired. More details and an OPeNDAP example posted on github here: https://stackoverflow.com/questions/46552078/xarray-wave-period-in-seconds-ingested-as-timedelta64

{
    "url": "https://api.github.com/repos/pydata/xarray/issues/1621/reactions",
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
    xarray 13221727 issue
262619571 MDU6SXNzdWUyNjI2MTk1NzE= 1601 _FillValue and missing_value mismatch if float pacioos 4701070 closed 0     2 2017-10-03T23:12:25Z 2017-10-11T21:39:47Z 2017-10-11T21:39:47Z NONE      

I get the following error when _FillValue and missing_value are both floating-point decimals, even though they are the same value (-999.99):

File "/usr/local/lib/python2.7/dist-packages/xarray/backends/api.py", line 301, in open_dataset return maybe_decode_store(store, lock) File "/usr/local/lib/python2.7/dist-packages/xarray/backends/api.py", line 225, in maybe_decode_store drop_variables=drop_variables) File "/usr/local/lib/python2.7/dist-packages/xarray/conventions.py", line 955, in decode_cf decode_coords, drop_variables=drop_variables) File "/usr/local/lib/python2.7/dist-packages/xarray/conventions.py", line 888, in decode_cf_variables decode_times=decode_times) File "/usr/local/lib/python2.7/dist-packages/xarray/conventions.py", line 800, in decode_cf_variable "and decoding explicitly using " ValueError: ('Discovered conflicting _FillValue and missing_value. Considering opening the offending dataset using decode_cf=False, corrected the attributes', 'and decoding explicitly using xarray.conventions.decode_cf(ds)')

Here is the OPeNDAP end point that causes the error:

http://oos.soest.hawaii.edu/thredds/dodsC/hioos/tide_mhi

The error is unwarranted since the values match. My workaround thus far has been to first open the dataset with decode_cf=False, then I remove the duplicate missing_value attributes, and then decode explicitly using decode_cf(ds).

{
    "url": "https://api.github.com/repos/pydata/xarray/issues/1601/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  completed xarray 13221727 issue

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [issues] (
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [number] INTEGER,
   [title] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [state] TEXT,
   [locked] INTEGER,
   [assignee] INTEGER REFERENCES [users]([id]),
   [milestone] INTEGER REFERENCES [milestones]([id]),
   [comments] INTEGER,
   [created_at] TEXT,
   [updated_at] TEXT,
   [closed_at] TEXT,
   [author_association] TEXT,
   [active_lock_reason] TEXT,
   [draft] INTEGER,
   [pull_request] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [performed_via_github_app] TEXT,
   [state_reason] TEXT,
   [repo] INTEGER REFERENCES [repos]([id]),
   [type] TEXT
);
CREATE INDEX [idx_issues_repo]
    ON [issues] ([repo]);
CREATE INDEX [idx_issues_milestone]
    ON [issues] ([milestone]);
CREATE INDEX [idx_issues_assignee]
    ON [issues] ([assignee]);
CREATE INDEX [idx_issues_user]
    ON [issues] ([user]);
Powered by Datasette · Queries took 1047.834ms · About: xarray-datasette