Hi Dave,

Thanks for the good tip. It implies some coding, but then we avoid having to edit the dataset manually, which is always error prone.

Cheers,

Rui
------------------

Rui Figueira
Coordenador do Nó Português do GBIF
ruifigueira@isa.ulisboa.pt
Instituto Superior de Agronomia
Herbário
Tapada da Ajuda, 1349-017 Lisboa, Portugal
Tel. +351 213653421 | Fax. +351 213653195
http://www.gbif.pt
http://www.isa.ulisboa.pt
On 02/24/2016 03:09 PM, David.Martin@csiro.au wrote:
HI Rui,

In case it helps, you could do this with some code by querying the list of publishing countries:

http://api.gbif.org/v1/node/country

and use this list (after removing PT) to query with country=PT&publishingCountry=AD.
This isn’t as handy as the single query (and single download) you are suggesting, but it should get you there via a longer route.

Hope this helps,

Dave Martin
ALA

On 24 Feb 2016, at 2:07 pm, Rui Figueira <ruifigueira@isa.ulisboa.pt> wrote:

Dear Frederico,

Many thanks for this clarification.

If that sort of query could be implemented, it would greatly facilitate the data management of our national data portal in the future.

Regards,

Rui

On 02/24/2016 12:29 PM, Federico Mendez wrote:
Dear Rui, I¹m afraid that by now the only way of getting those records is
how you described: downloading all the portuguese records and then remove
records coming from portuguese institutions. In the next months we¹ll be
analysing the feasibility of implementing ¹negated¹ expression in out API
to be able to compose queries like: country=PT&publishingCountry=NOT PT.

Regards, Federico Mendez.



On 23/02/16 15:04, "Mélianie Raymond" <mraymond@gbif.org> wrote:
-----Original Message-----
From: Rui Figueira [mailto:ruifigueira@isa.ulisboa.pt]
Sent: Tuesday, February 23, 2016 11:19 AM
To: Mélianie Raymond; ala-portal@lists.gbif.org; Federico Mendez
Subject: Re: [Ala-portal] Query to get data for a country not published
by that country

Hi Méliane,

Yes, that's it:

identify all occurrences in Portugal published by institutions NOT in
Portugal.
If you could create that custom query, it would greatly facilitate the
management of the national data portal in the future.

But for the time being, I understand that the only option is to download
all occurrences for Portugal, and afterwards filter it to remove records
published by Portuguese, right?

Thanks,

Rui

------------------

Rui Figueira
Coordenador do Nó Português do GBIF
ruifigueira@isa.ulisboa.pt
Instituto Superior de Agronomia
Herbário
Tapada da Ajuda, 1349-017 Lisboa, Portugal Tel. +351 213653421 | Fax.
+351 213653195 http://www.gbif.pt http://www.isa.ulisboa.pt

On 02/23/2016 09:05 AM, Mélianie Raymond wrote:
Dear Rui,

Thanks for your message. I have discussed this with Federico and we
would just like to be sure we have understood the request correctly.

Here is an example of a dataset published by the Netherlands about
occurrences in Portugal: doi:10.15468/eswvar
(http://www.gbif.org/dataset/9cbcf2b3-448f-48ce-9510-39e25c6234a8).

However, the datasets published by institutions NOT in Portugal
typically tend to be on broader areas, only including some occurrences
that fall in Portugal. You can use the API to identify all occurrences
in Portugal: http://api.gbif.org/v1/occurrence/search?country=PT.

We could make a custom query to identify all occurrences in Portugal
published by institutions NOT in Portugal if this is what you need?

Thanks!
Melianie

---------------------------------------
Dr. Mélianie Raymond
Senior Programme Officer for Node Development GBIF Secretariat
Universitetsparken 15
DK-2100 Copenhagen, Denmark
Tel.: +45 35 32 14 96/ Fax: +45 35 32 14 80
E-mail: mraymond@gbif.org
Website: www.gbif.org




-----Original Message-----
From: Ala-portal [mailto:ala-portal-bounces@lists.gbif.org] On Behalf
Of Rui Figueira
Sent: Friday, February 19, 2016 3:57 PM
To: ala-portal@lists.gbif.org
Subject: [Ala-portal] Query to get data for a country not published by
that country

Hello,

We would like to add to our test implementation of ALA one resource
with the data for Portugal which IS NOT published by portuguese
institutions.
Is it possible to define a query in the GBIF data portal to achieve
this?

Thanks,

Rui Figueira

_______________________________________________
Ala-portal mailing list
Ala-portal@lists.gbif.org
http://lists.gbif.org/mailman/listinfo/ala-portal

_______________________________________________
Ala-portal mailing list
Ala-portal@lists.gbif.org
http://lists.gbif.org/mailman/listinfo/ala-portal