SPARQL query for Agent and Applicant

This is the place where the linked data/open data community can ask and respond to questions about or share experiences with EPO’s open bulk data sets. The moderator will use this forum to announce product related news.
Post Reply

Kolotilova
Posts: 3
Joined: Wed Feb 20, 2019 4:51 pm

SPARQL query for Agent and Applicant

Post by Kolotilova » Wed Feb 20, 2019 5:30 pm

Dear all! Tried to perform a query for an Applicant and for an Agent, but seems it retrieves the information about an application only (have seen it after performing SPARQL queries for Vns of Agents and Applicants). Can you please explain me how can I see all linked information for a particular applicant or agent via SPARQL? Thank you in advance, best regards, Yuliya


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: SPARQL query for Agent and Applicant

Post by EPO / PATSTAT Support » Thu Feb 21, 2019 11:07 am

Hi Yuliya,

You may try a SPARQL query like this which retrieves up to 100 publications of the applicant "HUAWEI...":

Code: Select all

SELECT * {
  ?publn rdf:type patent:Publication;
         patent:applicantVC ?applicant;
         patent:publicationAuthority/skos:notation ?auth;
         patent:publicationNumber ?nr;
         patent:publicationKind/skos:notation ?kind.
  ?applicant vcard:fn ?name.
  FILTER(STRSTARTS(UCASE(?name), "HUAWEI"))
} LIMIT 100
And if you replace "patent:applicantVC " by "patent:agentVC" you can do the same for agents / legal representative.

In fact, this query is the sample query 2.6 of the document "Sample SPARQL queries", which you can access on the bottom of the page epo.org/linked-data.

Does this help?

Best regards,
Martin / EPO


Kolotilova
Posts: 3
Joined: Wed Feb 20, 2019 4:51 pm

Re: SPARQL query for Agent and Applicant

Post by Kolotilova » Thu Feb 21, 2019 11:42 am

Thank you very much Martin!

I mean that I was trying, for example, this link:

https://data.epo.org/linked-data/doc/ap ... P/99203729:

Then, as the next step, I proceeded to publication:
https://data.epo.org/linked-data/data/p ... 00000/A1/-

Then, from the Publication, I proceeded to the agent vC:

46719 cF9 d838 c925 cFF98 e3 f01545910
http://data.epo.org/linked-data/data/vc ... 3F01545910
fn
Schumann, Bernard Herman Johan
has address
e6 e429 b134 f1 e0 c1828765 d604 bCFFE0
http://data.epo.org/linked-data/data/ad ... D604BCFFE0
a Address
country code
NL

Then, directly to Query and I have seen the following:

SELECT ?application ?appNum ?filingDate ?authority {
?application rdf:type patent:Application ;
patent:applicationNumber ?appNum ;
patent:filingDate ?filingDate ;
patent:applicationAuthority ?authority ;
.
} LIMIT 10

What did I make wrong? And how to get the Query for Agent from Agent VC directly then?

Thanks a lot,
Yuliya


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: SPARQL query for Agent and Applicant

Post by EPO / PATSTAT Support » Fri Feb 22, 2019 12:02 pm

Hi Yulyia,

Let me sum up what I understand:

First, you used the "API" menu item of https://data.epo.org/linked-data/ to navigate from one application https://data.epo.org/linked-data/doc/ap ... P/99203729 to its A1 publication, then to the agent and the agent's address. This is very fine. That's what the API and the simple browser is for: To manually (or programmatically) navigate from one resource to the next and to explore the data set.

Then you go to the "SPARQL query" menu item which allows for complex queries over the EP data set. By default, the query editor contains a sample query (see you recent post) which just returns the application ID, the application number, the filing date and the application authority of 10 random(!)applications.

I assume you wrongly believe that your actions in the API / the browser and the SPARQL query are somehow related - but they are not.

A query which retrieves the agent(s) from a specific application will look like this:

Code: Select all

SELECT ?applnnr ?publn ?name ?address {
  ?application rdf:type patent:Application ;
               patent:applicationAuthority <http://data.epo.org/linked-data/id/st3/EP>;
               patent:applicationNumber  ?applnnr;
               patent:publication ?publn.
  ?publn patent:agentVC ?agent.
  ?agent vcard:fn ?name; 
         vcard:hasAddress/patent:countryCode ?address.
FILTER(?applnnr = "99203729")
} LIMIT 10
You get 2 hits, because the application has an A1 and a B1 publication, which actually have different agents.

If you have not done so already, I recommend having a look at the User Guide document at the bottom of page epo.org/linked-data.

Martin / EPO
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Kolotilova
Posts: 3
Joined: Wed Feb 20, 2019 4:51 pm

Re: SPARQL query for Agent and Applicant

Post by Kolotilova » Fri Feb 22, 2019 2:31 pm

Thank you very much Martin, got it!

Kind regards,

Yuliya


Post Reply