<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    Hi Dave,<br>
    <br>
    Thanks for the good tip. It implies some coding, but then we avoid
    having to edit the dataset manually, which is always error prone.<br>
    <br>
    Cheers,<br>
    <br>
    Rui<br>
    <pre class="moz-signature" cols="72">------------------

Rui Figueira
Coordenador do Nó Português do GBIF
<a class="moz-txt-link-abbreviated" href="mailto:ruifigueira@isa.ulisboa.pt">ruifigueira@isa.ulisboa.pt</a>
Instituto Superior de Agronomia
Herbário
Tapada da Ajuda, 1349-017 Lisboa, Portugal
Tel. +351 213653421 | Fax. +351 213653195
<a class="moz-txt-link-freetext" href="http://www.gbif.pt">http://www.gbif.pt</a>
<a class="moz-txt-link-freetext" href="http://www.isa.ulisboa.pt">http://www.isa.ulisboa.pt</a></pre>
    <div class="moz-cite-prefix">On 02/24/2016 03:09 PM,
      <a class="moz-txt-link-abbreviated" href="mailto:David.Martin@csiro.au">David.Martin@csiro.au</a> wrote:<br>
    </div>
    <blockquote cite="mid:8EBE5BC5-DC85-4869-9716-FA9EF37ABB02@csiro.au"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <div class="">HI Rui,</div>
      <div class=""><br class="">
      </div>
      <div class="">In case it helps, you could do this with some code
        by querying the list of publishing countries:</div>
      <div class=""><br class="">
      </div>
      <div class=""><a moz-do-not-send="true"
          href="http://api.gbif.org/v1/node/country" class="">http://api.gbif.org/v1/node/country</a></div>
      <div class=""><br class="">
      </div>
      <div class="">and use this list (after removing PT) to query with
        country=PT&publishingCountry=AD.</div>
      <div class="">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.</div>
      <div class=""><br class="">
      </div>
      <div class="">Hope this helps,</div>
      <div class=""><br class="">
      </div>
      <div class="">Dave Martin</div>
      <div class="">ALA</div>
      <br class="">
      <div>
        <blockquote type="cite" class="">
          <div class="">On 24 Feb 2016, at 2:07 pm, Rui Figueira <<a
              moz-do-not-send="true"
              href="mailto:ruifigueira@isa.ulisboa.pt" class=""><a class="moz-txt-link-abbreviated" href="mailto:ruifigueira@isa.ulisboa.pt">ruifigueira@isa.ulisboa.pt</a></a>>
            wrote:</div>
          <br class="Apple-interchange-newline">
          <div class="">Dear Frederico,<br class="">
            <br class="">
            Many thanks for this clarification.<br class="">
            <br class="">
            If that sort of query could be implemented, it would greatly
            facilitate the data management of our national data portal
            in the future.<br class="">
            <br class="">
            Regards,<br class="">
            <br class="">
            Rui<br class="">
            <br class="">
            On 02/24/2016 12:29 PM, Federico Mendez wrote:<br class="">
            <blockquote type="cite" class="">Dear Rui, I¹m afraid that
              by now the only way of getting those records is<br
                class="">
              how you described: downloading all the portuguese records
              and then remove<br class="">
              records coming from portuguese institutions. In the next
              months we¹ll be<br class="">
              analysing the feasibility of implementing ¹negated¹
              expression in out API<br class="">
              to be able to compose queries like:
              country=PT&publishingCountry=NOT PT.<br class="">
              <br class="">
              Regards, Federico Mendez.<br class="">
              <br class="">
              <br class="">
              <br class="">
              On 23/02/16 15:04, "Mélianie Raymond" <<a
                moz-do-not-send="true" href="mailto:mraymond@gbif.org"
                class=""><a class="moz-txt-link-abbreviated" href="mailto:mraymond@gbif.org">mraymond@gbif.org</a></a>> wrote:<br class="">
              <blockquote type="cite" class="">-----Original
                Message-----<br class="">
                From: Rui Figueira [<a moz-do-not-send="true"
                  href="mailto:ruifigueira@isa.ulisboa.pt" class="">mailto:ruifigueira@isa.ulisboa.pt</a>]<br
                  class="">
                Sent: Tuesday, February 23, 2016 11:19 AM<br class="">
                To: Mélianie Raymond; <a moz-do-not-send="true"
                  href="mailto:ala-portal@lists.gbif.org" class="">ala-portal@lists.gbif.org</a>;
                Federico Mendez<br class="">
                Subject: Re: [Ala-portal] Query to get data for a
                country not published<br class="">
                by that country<br class="">
                <br class="">
                Hi Méliane,<br class="">
                <br class="">
                Yes, that's it:<br class="">
                <br class="">
                <blockquote type="cite" class="">identify all
                  occurrences in Portugal published by institutions NOT
                  in<br class="">
                  Portugal.<br class="">
                </blockquote>
                If you could create that custom query, it would greatly
                facilitate the<br class="">
                management of the national data portal in the future.<br
                  class="">
                <br class="">
                But for the time being, I understand that the only
                option is to download<br class="">
                all occurrences for Portugal, and afterwards filter it
                to remove records<br class="">
                published by Portuguese, right?<br class="">
                <br class="">
                Thanks,<br class="">
                <br class="">
                Rui<br class="">
                <br class="">
                ------------------<br class="">
                <br class="">
                Rui Figueira<br class="">
                Coordenador do Nó Português do GBIF<br class="">
                <a moz-do-not-send="true"
                  href="mailto:ruifigueira@isa.ulisboa.pt" class="">ruifigueira@isa.ulisboa.pt</a><br
                  class="">
                Instituto Superior de Agronomia<br class="">
                Herbário<br class="">
                Tapada da Ajuda, 1349-017 Lisboa, Portugal Tel. +351
                213653421 | Fax.<br class="">
                +351 213653195 <a class="moz-txt-link-freetext" href="http://www.gbif.pt">http://www.gbif.pt</a>
                <a class="moz-txt-link-freetext" href="http://www.isa.ulisboa.pt">http://www.isa.ulisboa.pt</a><br class="">
                <br class="">
                On 02/23/2016 09:05 AM, Mélianie Raymond wrote:<br
                  class="">
                <blockquote type="cite" class="">Dear Rui,<br class="">
                  <br class="">
                  Thanks for your message. I have discussed this with
                  Federico and we<br class="">
                  would just like to be sure we have understood the
                  request correctly.<br class="">
                  <br class="">
                  Here is an example of a dataset published by the
                  Netherlands about<br class="">
                  occurrences in Portugal: doi:10.15468/eswvar<br
                    class="">
(<a class="moz-txt-link-freetext" href="http://www.gbif.org/dataset/9cbcf2b3-448f-48ce-9510-39e25c6234a8">http://www.gbif.org/dataset/9cbcf2b3-448f-48ce-9510-39e25c6234a8</a>).<br
                    class="">
                  <br class="">
                  However, the datasets published by institutions NOT in
                  Portugal<br class="">
                  typically tend to be on broader areas, only including
                  some occurrences<br class="">
                  that fall in Portugal. You can use the API to identify
                  all occurrences<br class="">
                  in Portugal:
                  <a class="moz-txt-link-freetext" href="http://api.gbif.org/v1/occurrence/search?country=PT">http://api.gbif.org/v1/occurrence/search?country=PT</a>.<br
                    class="">
                  <br class="">
                  We could make a custom query to identify all
                  occurrences in Portugal<br class="">
                  published by institutions NOT in Portugal if this is
                  what you need?<br class="">
                  <br class="">
                  Thanks!<br class="">
                  Melianie<br class="">
                  <br class="">
                  ---------------------------------------<br class="">
                  Dr. Mélianie Raymond<br class="">
                  Senior Programme Officer for Node Development GBIF
                  Secretariat<br class="">
                  Universitetsparken 15<br class="">
                  DK-2100 Copenhagen, Denmark<br class="">
                  Tel.: +45 35 32 14 96/ Fax: +45 35 32 14 80<br
                    class="">
                  E-mail: <a class="moz-txt-link-abbreviated" href="mailto:mraymond@gbif.org">mraymond@gbif.org</a><br class="">
                  Website: <a class="moz-txt-link-abbreviated" href="http://www.gbif.org">www.gbif.org</a><br class="">
                  <br class="">
                  <br class="">
                  <br class="">
                  <br class="">
                  -----Original Message-----<br class="">
                  From: Ala-portal
                  [<a class="moz-txt-link-freetext" href="mailto:ala-portal-bounces@lists.gbif.org">mailto:ala-portal-bounces@lists.gbif.org</a>] On Behalf<br
                    class="">
                  Of Rui Figueira<br class="">
                  Sent: Friday, February 19, 2016 3:57 PM<br class="">
                  To: <a class="moz-txt-link-abbreviated" href="mailto:ala-portal@lists.gbif.org">ala-portal@lists.gbif.org</a><br class="">
                  Subject: [Ala-portal] Query to get data for a country
                  not published by<br class="">
                  that country<br class="">
                  <br class="">
                  Hello,<br class="">
                  <br class="">
                  We would like to add to our test implementation of ALA
                  one resource<br class="">
                  with the data for Portugal which IS NOT published by
                  portuguese<br class="">
                  institutions.<br class="">
                  Is it possible to define a query in the GBIF data
                  portal to achieve<br class="">
                  this?<br class="">
                  <br class="">
                  Thanks,<br class="">
                  <br class="">
                  Rui Figueira<br class="">
                  <br class="">
                  _______________________________________________<br
                    class="">
                  Ala-portal mailing list<br class="">
                  <a class="moz-txt-link-abbreviated" href="mailto:Ala-portal@lists.gbif.org">Ala-portal@lists.gbif.org</a><br class="">
                  <a class="moz-txt-link-freetext" href="http://lists.gbif.org/mailman/listinfo/ala-portal">http://lists.gbif.org/mailman/listinfo/ala-portal</a><br
                    class="">
                </blockquote>
              </blockquote>
            </blockquote>
            <br class="">
            _______________________________________________<br class="">
            Ala-portal mailing list<br class="">
            <a moz-do-not-send="true"
              href="mailto:Ala-portal@lists.gbif.org" class="">Ala-portal@lists.gbif.org</a><br
              class="">
            <a class="moz-txt-link-freetext" href="http://lists.gbif.org/mailman/listinfo/ala-portal">http://lists.gbif.org/mailman/listinfo/ala-portal</a><br
              class="">
          </div>
        </blockquote>
      </div>
      <br class="">
    </blockquote>
    <br>
  </body>
</html>