Hi Ankit,
A thing in advance: Result sets are currently limited to 2000 results, so LIMIT 100000 won't return that much.
Unfortunately it seems that the OSM data is very incomplete for Singapore:
Running the following simplified query on the virtual Sparql endpoint (which rewrites the query to a complete OSM database) at
http://linkedgeodata.org/vsnorql,
only yields 3 results:
?b <
http://linkedgeodata.org/ontology/is_in%3Acountry> ?c .
Filter(str(?c) = "Singapore")
}
Fortunately you can do a bounding box query:
I quickly derived a bounding box from the GADM (
http://gadm.org) polygon for Signapore.
I am locally experimenting in integrating this dataset with LinkedGeoData; but first have to ask the people there whether it would be ok to 'redistribute' parts of their data via SPARQL.
Here is your query:
Note that this currently only works on
http://linkedgeodata.org/vsnorql (and
http://linkedgeodata.org/vsparql)
but NOT on
http://linkedgeodata.org/sparql
Prefix rdfs: <
http://www.w3.org/2000/01/rdf-schema#>
Prefix ogc: <
http://www.opengis.net/ont/geosparql#>
Prefix geom: <
http://geovocab.org/geometry#>
Prefix lgdo: <
http://linkedgeodata.org/ontology/>
Select *
{
?s
geom:geometry [
ogc:asWKT ?g
] .
Filter(bif:st_intersects(?g, bif:st_geomFromText('POLYGON((103.616668701172 1.16638994216925,103.616668701172 1.47138798236875,104.085800170899 1.47138798236875,104.085800170899 1.16638994216925,103.616668701172 1.16638994216925))')))
}
Cheers,
Claus
> --
> You received this message because you are subscribed to the Google Groups "Linked Geo Data" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to
linked-geo-da...@googlegroups.com.
> To post to this group, send email to
linked-...@googlegroups.com.
> Visit this group at
http://groups.google.com/group/linked-geo-data.
> For more options, visit
https://groups.google.com/groups/opt_out.
--
Dipl. Inf. Claus Stadler
Department of Computer Science, University of Leipzig
Research Group:
http://aksw.org/
Workpage & WebID:
http://aksw.org/ClausStadler
Phone:
+49 341 97-32260