issue_comments

Table actions

2 rows where issue = 1374911473 and user = 4160723 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

user 1

  • benbovy · 2 ✖

issue 1

  • Xarray returns duplicate Longitude/Latitude values with sel method · 2 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
1249353885 https://github.com/pydata/xarray/issues/7042#issuecomment-1249353885 https://api.github.com/repos/pydata/xarray/issues/7042 IC_kwDOAMm_X85Kd6Cd benbovy 4160723 2022-09-16T13:16:43Z 2022-09-16T13:16:43Z MEMBER

You'd need to adjust the latitude / longitude values passed to sel so that your ROI contains (or is nearest to) more than one gird point in latitude or longitude. I'm afraid there's not automatic way in Xarray to do that.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Xarray returns duplicate Longitude/Latitude values with sel method  1374911473
1249295769 https://github.com/pydata/xarray/issues/7042#issuecomment-1249295769 https://api.github.com/repos/pydata/xarray/issues/7042 IC_kwDOAMm_X85Kdr2Z benbovy 4160723 2022-09-16T12:19:48Z 2022-09-16T12:19:48Z MEMBER

Hi @rogomichael,

It is expected in your example that sel with your given values and method='nearest' returns coordinates with duplicate longitude & latitude values.

The resolution of the grid is too coarse compared to your ROI, which is why the two provided values for latitude (longitude) both select the same grid point.

If you want to use sel for extracting a range over the latitude and longitude dimensions, it is better to use slices. It better illustrates that your ROI is smaller than the grid resolution:

```python ds.sel( longitude=slice(49.294, 49.376), latitude=slice(10.971, 11.087) )

<xarray.Dataset>

Dimensions: (time: 365, longitude: 1, latitude: 0)

Coordinates:

* time (time) datetime64[ns] 2019-01-01 2019-01-02 ... 2019-12-31

* longitude (longitude) float64 49.38

* latitude (latitude) float64

Data variables:

tg (time, latitude, longitude) float32 ...

``` 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Xarray returns duplicate Longitude/Latitude values with sel method  1374911473

Advanced export

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

CSV options: 

CREATE TABLE [issue_comments] (
   [html_url] TEXT,
   [issue_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [updated_at] TEXT,
   [author_association] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [performed_via_github_app] TEXT,
   [issue] INTEGER REFERENCES [issues]([id])
);
CREATE INDEX [idx_issue_comments_issue]
    ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
    ON [issue_comments] ([user]);