Difference between revisions of "OSM Planet"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
This page compares the different SPARQL endpoints available for querying OpenStreetMap (OSM) data. | This page compares the different SPARQL endpoints available for querying OpenStreetMap (OSM) data. | ||
| − | == Configuration == | + | == Configuration for pylodstorage sparqlquery tool == |
| + | see https://pypi.org/project/pyLodStorage/ | ||
| + | === installation === | ||
| + | <source lang='bash'> | ||
| + | pip install pylodstorage | ||
| + | </source> | ||
| + | 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 === | === endpoints.yaml === | ||
<syntaxhighlight lang='yaml'> | <syntaxhighlight lang='yaml'> | ||
| Line 30: | Line 37: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | === osmplanet.yaml === | + | === osmplanet.yaml (or queries.yaml as default) === |
<syntaxhighlight lang='yaml'> | <syntaxhighlight lang='yaml'> | ||
RelationStats: | RelationStats: | ||
Revision as of 10:18, 20 January 2025
OSM Planet SPARQL Endpoints
This page compares the different SPARQL endpoints available for querying OpenStreetMap (OSM) data.
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: virtuoso
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)