-
Notifications
You must be signed in to change notification settings - Fork 6
Description
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**