On 8/27/10 11:09 AM, Ted Thibodeau Jr wrote:
SELECT DISTINCT
?resource
?hasValue
?isValueOf
bif:min(?elevation) as ?minelev
bif:max(?elevation) as ?maxelev
?icao
?iata
WHERE {
{<http://dbpedia.org/ontology/Elevation> ?resource ?hasValue }
UNION
{ ?isValueOf ?resource<http://dbpedia.org/ontology/Airport> }
{ ?isValueOf<http://dbpedia.org/ontology/elevation>
?elevation }
{ ?isValueOf<http://dbpedia.org/ontology/icaoLocationIdentifier>
?icao }
OPTIONAL
{ ?isValueOf<http://dbpedia.org/ontology/iataLocationIdentifier>
?iata }
FILTER regex(?icao, "^K")
}
Ted,
Or this :-)
SELECT DISTINCT
?resource
?hasValue
?isValueOf
bif:round(bif:min(?elevation)) as ?minelev
bif:round(bif:max(?elevation)) as ?maxelev
?icao
?iata
WHERE {
{ <http://dbpedia.org/ontology/Elevation> ?resource ?hasValue }
UNION
{ ?isValueOf ?resource <http://dbpedia.org/ontology/Airport> }
{ ?isValueOf
<http://dbpedia.org/ontology/elevation>
?elevation }
{ ?isValueOf
<http://dbpedia.org/ontology/icaoLocationIdentifier>
?icao }
OPTIONAL
{ ?isValueOf
<http://dbpedia.org/ontology/iataLocationIdentifier>
?iata }
FILTER regex(?icao, "^K")
}
Links:
1. http://bit.ly/cknyIe -- query results
2. http://bit.ly/9FupZ1 -- query definition .
--
Regards,
Kingsley Idehen
President& CEO
OpenLink Software
Web: http://www.openlinksw.com
Weblog: http://www.openlinksw.com/blog/~kidehen
Twitter/Identi.ca: kidehen
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users
worldwide. Take advantage of special opportunities to increase revenue and
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
