smithsonian / gbif-issues-explorer Goto Github PK

To provide a better readme file and experience, should test with older versions of R, trying back up to 3.2.0 (released in April, 2015).

This way, rows with problems can be ignored when downloading the occurrence file from the app. Also, collection managers can ignore these rows because they are not real problems or because they were fixed and will be updated in the next data sync.

This is due to the large size of the database (23M records). We need a better way to do the string matching, or do it in the database, when the string does not have a country and/or year to filter the options.

As an alternative, we can do the matching in chunks of data, but it will be slow.

Will be nice to reduce the number of packages required. For example, should be possible to skip XML by using jsonlite and querying the GBIF API.

To be done in a future version.

The results table is not clear on what is being displayed. Should always display one or the other or display the source in the header.

Insert queries fail when a dataset or institution name has a single quote, like:

The mammals collection (ZM) of the Muséum national d'Histoire naturelle (MNHN - Paris)
Dataset 3959ee49-7678-4a88-9049-5dfc55ccebf3

Should be a small dataset that has a variety of issues.