def tipo_localizacion_cultivos(query, tipo_localizacion) -> str:
tipo_localizacion = tipo_localizacion.lower()
if tipo_localizacion == "aragon":
query = query.replace(
"WHERE",
" FROM " + Constants.grafo_agricultura_cultivos_aragon() +
" WHERE",
)
elif tipo_localizacion == "municipio":
query = query.replace(
"WHERE",
" FROM " + Constants.grafo_agricultura_cultivos_municipio() +
" WHERE",
)
elif tipo_localizacion == "provincia":
query = query.replace(
"WHERE",
" FROM " + Constants.grafo_agricultura_cultivos_provincia() +
" WHERE",
)
elif tipo_localizacion == "comarca":
query = query.replace(
"WHERE",
" FROM " + Constants.grafo_agricultura_cultivos_comarca() +
" WHERE",
)
return query
def base_query() -> str:
base = (Config.prefix() + "SELECT DISTINCT " + Constants.answer0() +
" " + Constants.etiqueta())
if Config.graph() != "":
base += " FROM <" + Config.graph() + ">"
base += " WHERE { "
return base
def year_dataset(query, year) -> str:
Log.log_debug("QUERIES_: Entrando a year_dataset()")
Log.log_debug("QUERIES_: Year entrante: {0} ".format(year))
if year == "":
query = TemplatesAragon.year_max_one_paramater(query)
else:
Log.log_debug(
"QUERIES_: query before replacing: {0} ".format(query))
pos_init = query.find("{ SELECT")
Log.log_debug("QUERIES_: posicion init: {0} ".format(pos_init))
pos_end = query.find(" }}")
Log.log_debug("QUERIES_: posicion end: {0} ".format(pos_end))
subquery = query[pos_init:pos_end + 3]
Log.log_debug("QUERIES_: subquery: {0} ".format(subquery))
query = query.replace(subquery, "")
Log.log_debug("QUERIES_: query post replace: {0} ".format(query))
query += (
Constants.municipio() +
" <http://purl.org/linked-data/sdmx/2009/dimension#refPeriod> "
+ Constants.fecha() + " . ")
query += (
TemplatesAragon.create_bif_contains(year, Constants.fecha()) +
" . ")
return query
def superficie_municipio(query, municipio) -> str:
query += (Constants.municipio() + " aragopedia:areaTotal " +
Constants.answer0() + " . ")
query += Constants.municipio() + " rdfs:label " + Constants.etiqueta()
query += (TemplatesAragon.create_bif_contains(
municipio, Constants.etiqueta()) + " . ")
return query
def num_trabajadores(query: str, trabajadores: str) -> str:
query += (Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/dimension#estrato> " +
Constants.etiqueta2() + " . ")
query += TemplatesAragon.create_bif_contains(trabajadores,
Constants.etiqueta2())
return query
def year(query, year) -> str:
query += Constants.observacion(
) + " aragopedia:year " + Constants.fecha()
query += TemplatesAragon.create_bif_contains(year,
Constants.fecha()) + " . "
return query
def year(query, year) -> str:
query += (
Constants.aux0() +
" <http://purl.org/linked-data/sdmx/2009/dimension#refPeriod> " +
Constants.etiqueta())
query += (TemplatesAgriculture.create_bif_contains(
year, Constants.etiqueta()) + " . ")
return query
def tipo_superficie(query: str, tipo_superficie: str) -> str:
query += (
Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/dimension#corine-land-cover-2000-nivel-1-descripcion> "
+ Constants.aux1() + " . ")
query += TemplatesAragon.create_bif_contains(tipo_superficie,
Constants.aux1())
return query
def area_filter_extranjeros(query, nombre_area) -> str:
nombre_area = nombre_area.lower()
query = query.replace(
Constants.etiqueta2() + " . ",
Constants.etiqueta2() + " . " +
TemplatesAragon.create_bif_contains(nombre_area,
Constants.etiqueta2()) + " . ",
)
return query
def actividad(query: str, actividad: str) -> str:
query += (
Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/dimension#rama-de-actividad> "
+ Constants.etiqueta2() + " . ")
query += (TemplatesAragon.create_bif_contains(
actividad, Constants.etiqueta2()) + " . ")
return query
def antiguedad(query: str, antiguedad: str) -> str:
query += (
Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/dimension#ano-de-construccion> "
+ Constants.etiqueta2() + " . ")
query += (TemplatesAragon.create_bif_contains(
antiguedad, Constants.etiqueta2()) + " . ")
return query
def poblacion_extranjeros(query, municipio) -> str:
query += (
Constants.municipio() +
" <http://purl.org/linked-data/sdmx/2009/dimension#refArea> " +
Constants.etiqueta() + " . ")
query += (TemplatesAragon.create_bif_contains(
municipio, Constants.etiqueta()) + " . ")
return query
def sector(query: str, sector: str) -> str:
query += (
Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/dimension#sector-descripcion> "
+ Constants.etiqueta2() + " . ")
query += TemplatesAragon.create_bif_contains(sector,
Constants.etiqueta2())
return query
def antiguedad_edificios(query, municipio) -> str:
query = query.replace(
"WHERE",
Constants.fecha() + " " + Constants.etiqueta2() + " FROM " +
Constants.grafo_edificios_construccion() + " WHERE",
)
query += (
Constants.municipio() +
" <http://purl.org/linked-data/sdmx/2009/dimension#refArea> " +
Constants.etiqueta() + " . ")
query += (TemplatesAragon.create_bif_contains(
municipio, Constants.etiqueta()) + " . ")
answerpart = (
Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/medida#numero-hogares> " +
Constants.answer0() + " . ")
query += answerpart
query += TemplatesAragon.selecting_max_year(
Constants.grafo_edificios_construccion(), answerpart)
return query
def uso_suelo(query, municipio) -> str:
query = query.replace(
"WHERE", " FROM " + Constants.grafo_uso_suelo() + " WHERE")
query += (
Constants.municipio() +
" <http://purl.org/linked-data/sdmx/2009/dimension#refArea> " +
Constants.etiqueta() + " . ")
query += (TemplatesAragon.create_bif_contains(
municipio, Constants.etiqueta()) + " . ")
answerpart = (
Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/dimension#corine-land-cover-2000-nivel-5-descripcion> "
+ Constants.aux1() + " . ")
query += answerpart
query += ("BIND(SUBSTR(STRDT(" + Constants.aux1() +
", xsd:string),80) as" + Constants.answer0() + ") . ")
query += TemplatesAragon.selecting_max_year(
Constants.grafo_uso_suelo(), answerpart)
return query
def cargo_municipio(query, municipio) -> str:
# municipio = municipio.upper() # En el campo esta en mayusculas el municipio
query += (Constants.id_membresia() + " org:organization " +
Constants.municipio() + " . ")
query += (Constants.municipio() + " ei2a:organizationName " +
Constants.etiqueta())
query += (TemplatesAragon.create_bif_contains(
municipio, Constants.etiqueta()) + " . ")
return query
def poblacion(query, municipio) -> str:
query += (
Constants.municipio() +
" <http://purl.org/linked-data/sdmx/2009/dimension#refArea> " +
Constants.etiqueta() + " . ")
query += (TemplatesAragon.create_bif_contains(
municipio, Constants.etiqueta()) + " . ")
query += (Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/medida#poblacion> " +
Constants.answer0() + " . ")
return query
def sexo(query, sexo) -> str:
sexo = sexo.lower()
query = query.replace("SELECT DISTINCT ?answer0",
"SELECT DISTINCT SUM(?answer0) as ?answer0")
query += (Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/dimension#sexo> " +
Constants.aux1() + " . ")
if sexo == "mujeres" or sexo == "hombres":
query += TemplatesAragon.create_bif_contains(
sexo, Constants.aux1()) + " . "
return query
def tipo_area_extranjeros(query, tipo_area) -> str:
tipo_area = tipo_area.lower()
if tipo_area == "continente":
query = query.replace(
"WHERE",
" FROM " + Constants.grafo_extranjeros_continente() + " WHERE")
query += (
Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/medida#personas> " +
Constants.answer0() + " . ")
elif tipo_area == "pais":
query = query.replace(
"WHERE",
" FROM " + Constants.grafo_extranjeros_pais() + " WHERE")
query += (
Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/medida#extranjeros> " +
Constants.answer0() + " . ")
query += (
Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/dimension#nacionalidad-" +
tipo_area + "-nombre> " + Constants.etiqueta2() + " . ")
return query
def year_dataset_max(query, cadena) -> str:
Log.log_debug("QUERIES_: Entrando a year_dataset_max()")
Log.log_debug("QUERIES_: query: {0} ".format(query))
query = query.replace(
Constants.etiqueta() + " FROM",
Constants.etiqueta() + " " + Constants.fecha() + " FROM",
)
query += (
Constants.municipio() +
" <http://purl.org/linked-data/sdmx/2009/dimension#refPeriod> " +
Constants.fecha() + " . ")
try:
if int(cadena) > 1900:
query += (TemplatesAragon.create_filter_regex_var(
"STRDT(" + str(cadena) + ", xsd:string)",
Constants.fecha()) + " . ")
except:
query += (TemplatesAragon.create_filter_regex_var(
"STRDT(" + Constants.year_max() + ", xsd:string)",
Constants.fecha()) + " . ")
return query
def secano(query, municipio) -> str:
query += (
Constants.aux0() +
" <http://opendata.aragon.es/def/iaest/medida#hectareas-en-tierras-labradas-de-secano> "
+ Constants.answer0() + " . ")
query += (
Constants.aux0() +
" <http://purl.org/linked-data/sdmx/2009/dimension#refArea> " +
Constants.etiqueta2() + " . ")
query += (TemplatesAgriculture.create_bif_contains(
municipio, Constants.etiqueta2()) + " . ")
return query
def ecologica(query, municipio) -> str:
query += (
Constants.aux0() +
" <http://opendata.aragon.es/def/iaest/medida#superficie-total-agricultura-ecologica> "
+ Constants.answer0() + " . ")
query += (
Constants.aux0() +
" <http://purl.org/linked-data/sdmx/2009/dimension#refArea> " +
Constants.etiqueta2() + " . ")
query += (TemplatesAgriculture.create_bif_contains(
municipio, Constants.etiqueta2()) + " . ")
return query
def habitantes_municipio(query, municipio) -> str:
query = query.replace(Constants.answer0(),
Constants.answer0() + " " + Constants.answer1())
query += (Constants.municipio() + " aragopedia:menPopulation " +
Constants.answer0() + " . ")
query += (Constants.municipio() + " aragopedia:womenPopulation " +
Constants.answer1() + " . ")
query += Constants.municipio() + " rdfs:label " + Constants.etiqueta()
query += (TemplatesAragon.create_bif_contains(
municipio, Constants.etiqueta()) + " . ")
return query
def empresas_por_actividad(query, municipio) -> str:
query = query.replace("SELECT DISTINCT ?answer0",
"SELECT DISTINCT SUM(?answer0) as ?answer0")
query = query.replace(
"WHERE", " FROM " + Constants.grafo_actividad_empresa() + " WHERE")
query += (
Constants.municipio() +
" <http://purl.org/linked-data/sdmx/2009/dimension#refArea> " +
Constants.etiqueta() + " . ")
query += (TemplatesAragon.create_bif_contains(
municipio, Constants.etiqueta()) + " . ")
answerpart = (
Constants.municipio() +
" <http://opendata.aragon.es/def/iaest/medida#numero-de-actividades> "
+ Constants.answer0() + " . ")
query += answerpart
query += TemplatesAragon.selecting_max_year(
Constants.grafo_sector_empresa(), answerpart)
return query
def empresasActivas(query: str, location: str) -> str:
query += (
'''
?emp rdf:type org:Organization .
?emp ei2a:organizationName ''' + Constants.answer0() + ' . ' +
'''?emp dc:type ?tipo .
FILTER regex(?tipo, "empresa_turismo_activo") .
?emp geo:location ?loc .
?loc ?b ''' + Constants.etiqueta() + ''' FILTER regex(''' +
Constants.etiqueta() + ''', "''' +
TemplatesAragon.create_bif_contains_only_change_cadena(location) +
'") .')
return query
def selecting_max_year(grafo: str, answerpart: str) -> str:
query = " { SELECT DISTINCT MAX(xsd:integer(?max)) as " + Constants.year_max(
)
query += " FROM " + grafo
query += " WHERE { "
query += (
Constants.municipio() +
" <http://purl.org/linked-data/sdmx/2009/dimension#refArea> " +
Constants.etiqueta() + " . ")
query += (
Constants.municipio() +
" <http://purl.org/linked-data/sdmx/2009/dimension#refPeriod> " +
Constants.fecha() + " . ")
query += ("BIND(SUBSTR(STRDT(" + Constants.fecha() +
", xsd:string),38,4) as ?max) . ")
query += answerpart
query += " }}"
return query
def superficie_secano(query, municipio) -> str:
query += (Constants.municipio() + " aragopedia:hasObservation " +
Constants.observacion() + " . ")
query += Constants.municipio() + " rdfs:label " + Constants.etiqueta()
query += (TemplatesAragon.create_bif_contains(
municipio, Constants.etiqueta()) + " . ")
query += (Constants.observacion() +
" aragopedia:hectareasCultivosSecano " +
Constants.answer0() + " . ")
return query
def comarca_del_municipio(query, municipio) -> str:
query += (Constants.municipio() + " aragopedia:enComarca " +
Constants.comarca() + " . ")
query += Constants.municipio() + " rdfs:label " + Constants.etiqueta()
query += (TemplatesAragon.create_bif_contains(
municipio, Constants.etiqueta()) + " . ")
query += Constants.comarca() + " rdfs:label " + Constants.answer0(
) + " . "
return query
def cargo(query, cargo) -> str:
query += Constants.id_membresia() + " org:role " + Constants.id_rol(
) + " . "
query += Constants.id_rol() + ' ei2a:roleName "' + cargo.upper(
) + '" . '
query += (Constants.id_membresia() + " org:member " +
Constants.id_persona() + " . ")
query += (Constants.id_persona() + " ei2a:fullName " +
Constants.answer0() + " . ")
return query
def email_ayuntamiento(query, municipio) -> str:
# municipio = municipio.upper() # En el campo esta en mayusculas el municipio
query += (Constants.municipio() + " " + Constants.aux0() +
" ei2a:Ayuntamiento . ")
query += (Constants.municipio() + " ei2a:organizationName " +
Constants.etiqueta())
query += (TemplatesAragon.create_bif_contains(
municipio, Constants.etiqueta()) + " . ")
query += Constants.municipio() + " foaf:mbox " + Constants.answer0(
) + " . "
return query