OK, got it down to:
select ?uri, ( ?sc * 3e-1 ) as ?sc, ?label, ( sql:rnk_scale (
<LONG::IRI_RANK> ( ?uri ) ) ) as ?rank where {
?uri <http://www.w3.org/2000/01/rdf-schema#label> ?label .
?uri <http://dbpedia.org/property/latDegrees> ?posLat .
?label bif:contains '( sand and dunes )' option ( score ?sc ) .
FILTER( lang(?label) = "en" ) .
} order by desc ( ?sc * 3e-1 + sql:rnk_scale ( <LONG::IRI_RANK> ( ?uri ) ) )
but there is only 1 result!?
Wrong endpoint? Is inference re. latDegrees == wgs84#lat disabled?
--
Joe Presbrey
On Wed, Nov 2, 2011 at 6:52 PM, Joe Presbrey <[email protected]> wrote:
> Hello, I copied a query /fct running fine for sand dunes:
>
> select ?s1, ( ?sc * 3e-1 ) as ?sc, ?o1, ( sql:rnk_scale (
> <LONG::IRI_RANK> ( ?s1 ) ) ) as ?rank where {
> ?s1 ?s1textp ?o1 .
> ?o1 bif:contains '( sand and dunes )' option ( score ?sc ) .
> } order by desc ( ?sc * 3e-1 + sql:rnk_scale ( <LONG::IRI_RANK> ( ?s1
> ) ) ) limit 20 offset 0
>
> It runs fine. After adding just 1 constraint, that these are locations
> (have longitude+latitude):
> ?o1 <http://dbpedia.org/property/latDegrees> ?posLat .
>
> Virtuoso 42000 Error The estimated execution time 751545 (sec) exceeds
> the limit of 1500 (sec).
>
> I am trying to build a query that lets me search for linked data
> places I can put on a map. Sorry I'm not more familiar with Virtuoso
> and thanks for any suggestions...
>
> Best regards,
>
> --
> Joe Presbrey
>
------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
