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 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 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 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 base_query() -> str: base = (Config.prefix() + "SELECT DISTINCT " + Constants.answer0() + " " + Constants.etiqueta()) if Config.graph() != "": base += " FROM <" + Config.graph() + ">" base += " WHERE { " return base
def fincas_cultivo_lenoso_regadio_municipio(query, municipio) -> str: query += (Constants.comarca() + " " + Constants.aux0() + " ei2a:cultivo_lenoso . ") query += (Constants.comarca() + " <http://purl.org/dc/elements/1.1/title> " + Constants.answer0() + " . ") query += (Constants.comarca() + " <http://www.w3.org/2003/01/geo/wgs84_pos#location> " + Constants.location() + " . ") query += (Constants.location() + " <http://www.w3.org/2003/01/geo/wgs84_pos#location> " + Constants.aux1() + " . ") query += (Constants.aux1() + " ei2a:organizationName " + Constants.etiqueta() + " . ") query += (TemplatesAgriculture.create_bif_contains( municipio, Constants.etiqueta()) + " . ") query += (Constants.comarca() + " <http://opendata.aragon.es/def/ei2a#dryOrIrrigated> " + Constants.etiqueta2() + " . ") query += (TemplatesAgriculture.create_bif_contains( "Regadío", Constants.etiqueta2()) + " . ") 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 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 info_villa(query, villa) -> str: query = query.replace( Constants.answer0(), Constants.answer0() + " " + Constants.answer1() + " " + Constants.answer2() + " " + Constants.answer3(), ) query += (Constants.comarca() + " " + Constants.aux0() + " ei2a:villas_y_tierras . ") query += (Constants.comarca() + " ei2a:organizationName " + Constants.etiqueta() + " . ") query += (TemplatesAgriculture.create_bif_contains( villa, Constants.etiqueta()) + " . ") query += (Constants.comarca() + " <http://www.w3.org/2003/01/geo/wgs84_pos#location> " + Constants.location() + " . ") query += (Constants.location() + " <http://www.w3.org/2003/01/geo/wgs84_pos#location> " + Constants.aux1() + " . ") query += (Constants.aux1() + " ei2a:organizationName " + Constants.answer0() + " . ") query += (Constants.comarca() + " <http://opendata.aragon.es/def/ei2a#phone> " + Constants.answer1() + " . ") query += (Constants.comarca() + " <http://xmlns.com/foaf/0.1/mbox> " + Constants.answer2() + " . ") query += (Constants.comarca() + " <http://opendata.aragon.es/def/ei2a#CIF> " + Constants.answer3() + " . ") 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 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 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 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 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
def num_parados(query, municipio) -> str: query = query.replace("WHERE", " FROM " + Constants.grafo_parados() + " WHERE") 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#n-parados> " + Constants.answer0() + " . ") return query
def hectareas_quemadas(query, municipio) -> str: query = query.replace( "WHERE", " FROM " + Constants.grafo_incendios() + " WHERE") 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#superficie-forestal-afectada> " + Constants.answer0() + " . ") return query
def renta_per_capita(query, municipio) -> str: query = query.replace("WHERE", " FROM " + Constants.grafo_renta() + " WHERE") 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#renta-disponible-bruta-per-capita> " + Constants.answer0() + " . ") 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 fax_municipio(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() + " org:hasSite " + Constants.sede( ) + " . " query += Constants.sede() + " org:siteAddress " + Constants.aux1( ) + " . " query += Constants.aux1() + " vcard:Fax " + Constants.answer0() + " . " return query
def municipio_comarca_agraria(query, comarca_agraria) -> str: query += (Constants.comarca() + " " + Constants.aux0() + " ei2a:comarca_agraria . ") query += (Constants.comarca() + " ei2a:organizationName " + Constants.etiqueta() + " . ") query += (TemplatesAgriculture.create_bif_contains( comarca_agraria, Constants.etiqueta()) + " . ") query += (Constants.comarca() + " <http://www.w3.org/2003/01/geo/wgs84_pos#location> " + Constants.location() + " . ") query += (Constants.location() + " <http://www.w3.org/2003/01/geo/wgs84_pos#location> " + Constants.aux1() + " . ") query += (Constants.aux1() + " ei2a:organizationName " + Constants.answer0() + " . ") return query
def villas_municipio(query, municipio) -> str: query += (Constants.comarca() + " " + Constants.aux0() + " ei2a:villas_y_tierras . ") query += (Constants.comarca() + " ei2a:organizationName " + Constants.answer0() + " . ") query += (Constants.comarca() + " <http://www.w3.org/2003/01/geo/wgs84_pos#location> " + Constants.location() + " . ") query += (Constants.location() + " <http://www.w3.org/2003/01/geo/wgs84_pos#location> " + Constants.aux1() + " . ") query += (Constants.aux1() + " ei2a:organizationName " + Constants.etiqueta() + " . ") query += (TemplatesAgriculture.create_bif_contains( municipio, Constants.etiqueta()) + " . ") return query
def empresas_por_trabajadores(query, municipio) -> str: query = query.replace("SELECT DISTINCT ?answer0", "SELECT DISTINCT SUM(?answer0) as ?answer0") query = query.replace( "WHERE", " FROM " + Constants.grafo_trabajadores_empresa() + " WHERE") 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#numero-empresas> " + Constants.answer0() + " . ") return query
def hectareas_zona(query, municipio) -> str: query = query.replace( "WHERE", " FROM " + Constants.grafo_hectareas_zona() + " 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#superficie-has> " + Constants.answer0() + " . ") query += answerpart query += TemplatesAragon.selecting_max_year( Constants.grafo_contenedores_vidrio(), answerpart) return query