Skip to content

geosparql example doesn't work #31

@ZuSEnA

Description

@ZuSEnA

As shown in the example, the code:

import json
import re
import string

import folium
import mapclassify
import matplotlib as mpl
import matplotlib.pyplot as plt
import pandas as pd
import plotly.express as px
import plotly.graph_objects as go
from plotly.subplots import make_subplots

from graphly.api_client import SparqlClient

sparql = SparqlClient("https://lindas.admin.ch/query")
geosparql = SparqlClient("https://ld.geo.admin.ch/query")

sparql.add_prefixes({
"schema": "http://schema.org/",
"cube": "https://cube.link/",
"elcom": "https://energy.ld.admin.ch/elcom/electricityprice/dimension/",
"admin": "https://schema.ld.admin.ch/"
})

geosparql.add_prefixes({
"dct": "http://purl.org/dc/terms/",
"geonames": "http://www.geonames.org/ontology#",
"schema": "http://schema.org/",
"geosparql": "http://www.opengis.net/ont/geosparql#",
})

query = """
SELECT ?municipality ?boundary

WHERE {
?muni_iri dct:hasVersion ?version ;
geonames:featureCode geonames:A.ADM3 .

?version schema:validUntil "2020-12-31"^^http://www.w3.org/2001/XMLSchema#date;
geonames:population ?population;
schema:name ?municipality;
geosparql:hasGeometry/geosparql:asWKT ?boundary.

BIND(IRI(REPLACE(STR(?muni_iri), "https://ld.geo.admin.ch/boundaries/", "https://ld.admin.ch/")) AS ?municipality_id)
}

"""
communes = geosparql.send_query(query)
communes = communes.set_crs(epsg=4326)
communes.head()

However, it causes an error.

SSLError: HTTPSConnectionPool(host='ld.geo.admin.ch', port=443): Max retries exceeded with url: /query?query=PREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0APREFIX+geonames%3A+%3Chttp%3A%2F%2Fwww.geonames.org%2Fontology%23%3E%0APREFIX+schema%3A+%3Chttp%3A%2F%2Fschema.org%2F%3E%0APREFIX+geosparql%3A+%3Chttp%3A%2F%2Fwww.opengis.net%2Font%2Fgeosparql%23%3E%0A++++%0ASELECT+%3Fmunicipality+%3Fboundary+%0A%0AWHERE+%7B%0A++%3Fmuni_iri+dct%3AhasVersion+%3Fversion+%3B%0A++++++++++++geonames%3AfeatureCode+geonames%3AA.ADM3+.%0A++%0A++%3Fversion+schema%3AvalidUntil+%222020-12-31%22%5E%5E%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23date%3E%3B%0A+++++++++++geonames%3Apopulation+%3Fpopulation%3B%0A+++++++++++schema%3Aname+%3Fmunicipality%3B%0A+++++++++++geosparql%3AhasGeometry%2Fgeosparql%3AasWKT+%3Fboundary.%0A++%0A++BIND%28IRI%28REPLACE%28STR%28%3Fmuni_iri%29%2C+%22https%3A%2F%2Fld.geo.admin.ch%2Fboundaries%2F%22%2C+%22https%3A%2F%2Fld.admin.ch%2F%22%29%29+AS+%3Fmunicipality_id%29%0A%7D%0A%0A (Caused by SSLError(SSLError(1, '[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:1000)')))

**What can I do?

Thanks in advance!

ZuS**

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions