Difference between revisions of "OSM Planet"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | = OSM Planet SPARQL | + | == Links == |
| − | + | * https://wiki.openstreetmap.org/wiki/Sophox | |
| + | * https://qlever.cs.uni-freiburg.de/osm | ||
| + | * https://wiki.bitplan.com/index.php?title=OSM_Planet | ||
| + | * https://wiki.openstreetmap.org/wiki/Sophox/Example_queries | ||
| + | |||
| + | = OSM Planet SPARQL Queries with pylodstorage query tool = | ||
== Configuration for pylodstorage sparqlquery tool == | == Configuration for pylodstorage sparqlquery tool == | ||
| Line 15: | Line 20: | ||
endpoint: https://sophox.org/sparql | endpoint: https://sophox.org/sparql | ||
website: https://sophox.org | website: https://sophox.org | ||
| − | database: | + | database: blazegraph |
method: POST | method: POST | ||
lang: sparql | lang: sparql | ||
| Line 56: | Line 61: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | == | + | == Example queries == |
=== Sophox Queries === | === Sophox Queries === | ||
<source lang='bash' highlight='1'> | <source lang='bash' highlight='1'> | ||
| Line 135: | Line 140: | ||
| https://www.openstreetmap.org/meta/has || https://www.openstreetmap.org/node/6767844278 | | https://www.openstreetmap.org/meta/has || https://www.openstreetmap.org/node/6767844278 | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 10:47, 20 January 2025
Links
- https://wiki.openstreetmap.org/wiki/Sophox
- https://qlever.cs.uni-freiburg.de/osm
- https://wiki.bitplan.com/index.php?title=OSM_Planet
- https://wiki.openstreetmap.org/wiki/Sophox/Example_queries
OSM Planet SPARQL Queries with pylodstorage query tool
Configuration for pylodstorage sparqlquery tool
see https://pypi.org/project/pyLodStorage/
installation
pip install pylodstorage
The configuration files need to be in $HOME/.pylodstorage or you have to explicitly give the path with the -ep and -qp options
endpoints.yaml
osm-sophox:
endpoint: https://sophox.org/sparql
website: https://sophox.org
database: blazegraph
method: POST
lang: sparql
prefixes: |
PREFIX osmrel: <https://www.openstreetmap.org/relation/>
PREFIX osmt: <https://wiki.openstreetmap.org/wiki/Key:>
PREFIX osmm: <https://www.openstreetmap.org/meta/>
PREFIX geo: <http://www.opengis.net/ont/geosparql#>
osm-qlever:
endpoint: https://qlever.cs.uni-freiburg.de/api/osm
website: https://qlever.cs.uni-freiburg.de/osm
database: qlever
method: POST
lang: sparql
prefixes: |
PREFIX osmrel: <https://www.openstreetmap.org/relation/>
PREFIX osmt: <https://wiki.openstreetmap.org/wiki/Key:>
PREFIX osmm: <https://www.openstreetmap.org/meta/>
PREFIX geo: <http://www.opengis.net/ont/geosparql#>
osmplanet.yaml (or queries.yaml as default)
RelationStats:
endpoint: osm-qlever
param_list:
- name: relid
type: str
default_value: "6843452"
sparql: |
# Get statistics about predicates used in an OSM relation
SELECT ?p (COUNT(?o) as ?count)
WHERE {
osmrel:{{relid}} ?p ?o .
}
GROUP BY ?p
HAVING (?count > 1)
ORDER BY DESC(?count)
Example queries
Sophox Queries
sparqlquery -qp osmplanet.yaml -qn RelationStats -en osm-sophox --param relid=6843452 -f mediawiki
RelationStats
query
# Get statistics about predicates used in an OSM relation
PREFIX osmrel: <https://www.openstreetmap.org/relation/>
SELECT ?p (COUNT(?o) as ?count)
WHERE {
osmrel:6843452 ?p ?o .
}
GROUP BY ?p
HAVING (?count > 1)
ORDER BY DESC(?count)
result
| p | count |
|---|---|
| https://www.openstreetmap.org/meta/has | 186 |
sparqlquery -qp osmplanet.yaml -qn RelationNodes -en osm-sophox --param relid=6843452 -f mediawiki
RelationNodes
query
# Get all nodes for an OSM relation
PREFIX osmrel: <https://www.openstreetmap.org/relation/>
SELECT *
WHERE {
osmrel:6843452 ?p ?o .
FILTER(STRSTARTS(STR(?o), "https://www.openstreetmap.org/node/"))
}