[Ala-portal] Query to get data for a country not published by that country

[Rui Figueira]

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 at 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 at 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 at isa.ulisboa.pt 
>> <mailto:ruifigueira at 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 at gbif.org 
>>> <mailto:mraymond at gbif.org>> wrote:
>>>> -----Original Message-----
>>>> From: Rui Figueira [mailto:ruifigueira at isa.ulisboa.pt]
>>>> Sent: Tuesday, February 23, 2016 11:19 AM
>>>> To: Mélianie Raymond; ala-portal at lists.gbif.org 
>>>> <mailto:ala-portal at 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 at isa.ulisboa.pt <mailto:ruifigueira at 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 at gbif.org
>>>>> Website: www.gbif.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> -----Original Message-----
>>>>> From: Ala-portal [mailto:ala-portal-bounces at lists.gbif.org] On Behalf
>>>>> Of Rui Figueira
>>>>> Sent: Friday, February 19, 2016 3:57 PM
>>>>> To: ala-portal at 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 at lists.gbif.org
>>>>> http://lists.gbif.org/mailman/listinfo/ala-portal
>>
>> _______________________________________________
>> Ala-portal mailing list
>> Ala-portal at lists.gbif.org <mailto:Ala-portal at lists.gbif.org>
>> http://lists.gbif.org/mailman/listinfo/ala-portal
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gbif.org/pipermail/ala-portal/attachments/20160226/b053b6c1/attachment.html>