| Attributes | Values |
|---|
| type
| |
| Date Created
| |
| Date Modified
| |
| label
| - VirtTipsAndTricksGuideGecodeData
|
| maker
| |
| Title
| - VirtTipsAndTricksGuideGecodeData
|
| isDescribedUsing
| |
| has creator
| |
| content
| - %META:TOPICPARENT{name="VirtTipsAndTricksGuide"}%
---+How Do I Gecode Data?
---++What?
Automatic geocoding of data in quad store.
---++Why?
Enable exploitation of SPARQL-GEO for geospatial oriented queries.
---++How?
To gecode data one should call the <b>[[http://docs.openlinksw.com/virtuoso/fn_rdf_geo_fill.html][rdf_geo_fill]]</b> API from Conductor or iSQL:
<verbatim>
SQL> rdf_geo_fill ();
Done. -- 282 msec.
</verbatim>
---+++SPARQL-GEO sample queries
* [[http://lod.openlinksw.com/b3s/search.vsp?q=20&sc=http%3A%2F%2Fdbpedia.org%2Fresource%2FOxford&sc2=5&sc3=http%3A%2F%2Fdbpedia.org%2Fproperty%2Festablished&sc4=en&fa=Execute][All Educational Institutions within 10km of Oxford, UK]]:
<verbatim>
SELECT DISTINCT ?thing AS ?uri ?thingLabel AS ?name ?date AS ?established ?lat ?long WHERE
{
<http://dbpedia.org/resource/Oxford> geo:geometry ?sourcegeo .
?resource geo:geometry ?matchgeo .
?resource geo:lat ?lat .
?resource geo:long ?long .
FILTER ( bif:st_intersects ( ?matchgeo, ?sourcegeo, 5 ) ) .
?thing ?somelink ?resource .
?thing <http://dbpedia.org/property/established> ?date .
?thing rdfs:label ?thingLabel .
FILTER ( lang ( ?thingLabel ) = "en" )
}
</verbatim>
* [[http://lod.openlinksw.com/b3s/search.vsp?q=18&sc=http%3A%2F%2Fdbpedia.org%2Fresource%2FLondon&sc2=20&sc3=en&fa=Execute][Things within close proximity of London]]:
<verbatim>
SELECT DISTINCT ?resource ?label ?location WHERE
{
<http://dbpedia.org/resource/London> geo:geometry ?sourcegeo .
?resource geo:geometry ?location ; rdfs:label ?label .
FILTER ( bif:st_intersects ( ?location, ?sourcegeo, 20 ) ) .
FILTER ( lang ( ?label ) = "en" )
}
</verbatim>
---++Related
* [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]]
* [[http://docs.openlinksw.com/virtuoso/fn_rdf_geo_fill.html][<nowiki>rdf_geo_fill</nowiki> API]]
* [[http://docs.openlinksw.com/virtuoso/fn_rdf_geo_add.html][<nowiki>rdf_geo_add</nowiki> API]]
* [[http://docs.openlinksw.com/virtuoso/rdfsparqlgeospat.html#rdfsparqlgeospatcrg][Creating Geometries From RDF Data]]
* [[http://docs.openlinksw.com/virtuoso/rdfsparqlgeospat.html#rdfsparqlgeospatprog][Programmatic Manipulation of Geometries in RDF]]
* [[http://docs.openlinksw.com/virtuoso/rdfsparqlgeospat.html#rdfsparqlgeospatusg][Using Geometries With Existing Databases]]
* [[http://lod.openlinksw.com/b3s/][OpenLink Billion Triple Demo queries]]
|
| id
| - 48fb05c0a943f07abc4586f5bcca048f
|
| link
| |
| has container
| |
| http://rdfs.org/si...ices#has_services
| |
| atom:title
| - VirtTipsAndTricksGuideGecodeData
|
| links to
| |
| atom:source
| |
| atom:author
| |
| atom:published
| |
| atom:updated
| |
| topic
| |
| is made
of | |
| is container of
of | |
| is link
of | |
| is http://rdfs.org/si...vices#services_of
of | |
| is links to
of | |
| is creator of
of | |
| is atom:entry
of | |
| is atom:contains
of | |
![[RDF Data]](/fct/images/sw-rdf-blue.png)
![[cxml]](/fct/images/cxml_doc.png)
![[csv]](/fct/images/csv_doc.png)
![[text]](/fct/images/ntriples_doc.png)
![[turtle]](/fct/images/n3turtle_doc.png)
![[ld+json]](/fct/images/jsonld_doc.png)
![[rdf+json]](/fct/images/json_doc.png)
![[rdf+xml]](/fct/images/xml_doc.png)
![[atom+xml]](/fct/images/atom_doc.png)
![[html]](/fct/images/html_doc.png)