Sgvizler map question

[Robbert Jaspers]

Hello,

I build a database that holds the ranks of the top 200 universities in the world. I enrich this dataset with the locations, which I construct query from linkedgeodata.org. So I have the names, some more data and most importantly the Long and Lat coordinates. 

I have all the data setup in a file now, in triples and validated, and I can do queries with Joseki over my own database. I want to use sgvizler to visualize the locations of the universities on the map! 

 The problem is, that when Joseki returns a query, it shows the Long en Lat values in quotation marks. I'll show u with these screenshots:

I don't wants those quotation marks there. I want just the numbers. Because sgvizler can't read the data like this, it wants just the numbers.

This was my query:

Select str(?Lat) str(?Long) ?Uni 

Where {

?I <http://www.w3.org/2003/01/geo/wgs84_pos#lat>  ?Lat.

?I <http://www.w3.org/2003/01/geo/wgs84_pos#long>  ?Long.

?I <http://www.w3.org/2000/01/rdf-schema#label> ?Uni. }

I'll show how my database is build up.

This is a part of my triples database:

@prefix ns1: <http://linkedgeodata.org/triplify/> .

@prefix ns2: <http://linkedgeodata.org/ontology/> .

@prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> .

# BOSTON UNI .

ns1:node358276801 rdf:type ns2:School ,

ns2:Amenity ,

ns2:Node .

ns1:node358276801 rdfs:label "Boston University" .

ns1:node358276801 owl:sameAs <http://sws.geonames.org/4931016/> ;

ns2:directType ns2:School .

ns1:node358276801 geo:geometry "POINT(-71.1048 42.334)"^^virtrdf:Geometry ;

<http://linkedgeodata.org/ontology/gnis%3Astate_id> 25 ;

geo:lat 42.3339865 ;

geo:long -71.1047742 ;

Is it possible to rewrite the query so u remove the brackets? Or do we have to rewrite the database, and if so how? Or is there another way I can use sgvizler so it does read this data input and shows the locations?

Thanks a lot for your time, I hope you can help me out!

Sincerely,

Robbert Jaspers

Masters student Artificial Intelligence, Vrije Universiteit Amsterdam, Netherlands

["Martin G. Skjæveland"]

On 10/12/11 14:46, Robbert Jaspers wrote:

Hi Robbert.

> Is it possible to rewrite the query so u remove the brackets?

Yes, I think so.

> /Select str(?Lat) str(?Long) ?Uni /
> /Where {/
> /?I <http://www.w3.org/2003/01/geo/wgs84_pos#lat> ?Lat./
> /?I <http://www.w3.org/2003/01/geo/wgs84_pos#long> ?Long./
> /?I <http://www.w3.org/2000/01/rdf-schema#label> ?Uni. }/

Instead of
/Select str(?Lat) str(?Long) ?Uni /

try just
/Select ?Lat ?Long ?Uni /

or
/Select xsd:float(?Lat) xsd:float(?Long) ?Uni /

Martin