ocorcho’s gists

ocorcho / transformaciones composicion pleno

Created July 14, 2016 08:37

Transformaciones de fichero composición pleno Aragón

	[
	{
	"op": "core/column-removal",
	"description": "Remove column Column",
	"columnName": "Column"
	},
	{
	"op": "core/mass-edit",
	"description": "Mass edit cells in column CARGO",
	"engineConfig": {

ocorcho / Consulta1.sparql

Created June 21, 2016 13:17

Consultas sobre PPROC para el TFG de Luis Galdo

	SELECT DISTINCT ?uri str(min(?titulo)) as ?Titulo str(min(?nombre)) as ?Nombre ?fechaFormalizacion ucase(replace(replace(replace(?cif," ",""),"-",""),"/.","")) as ?Cif min(?servicioGestor) as ?ServicioGestor ?id ?precio
	WHERE {
	?uri a pproc:Contract.
	?uri dcterms:title ?titulo.
	?uri pc:tender ?tender.
	?tender a pproc:FormalizedTender.
	?tender pproc:formalizedDate ?fechaFormalizacion.
	FILTER ( regex(?fechaFormalizacion, "2016"))
	OPTIONAL {?tender pc:supplier ?empresaid.
	?empresaid <http://www.w3.org/ns/org#identifier> ?cif.

ocorcho / gist:e617a6b61483f129350835818dbb78f4

Created May 26, 2016 19:31

CRTM - DPaypoints con validaciones, y su geometría

	PREFIX dpay: <http://datos.crtm.es/recurso/transporte/validacion/dpaypoint/>
	PREFIX gsp: <http://www.opengis.net/ont/geosparql#>

	SELECT DISTINCT ?dPayPoint ?geometry
	WHERE {
	?obs a <http://datos.crtm.es/recurso/transporte/Validacion> .
	?obs ssn:observationResultTime ?time .
	?obs ssn:observedBy ?dPayPoint .
	?dPayPoint gsp:hasGeometry/gsp:asWKT ?geometry .
	#?obs ssn:featureOfInterest ?tarjeta .

ocorcho / gist:1e5dce0ac80cc1f0d31b8f85e2629094

Created May 26, 2016 10:06

CRTM - Número de validaciones que se producen en una lista de dPayPoint

	PREFIX dpay: <http://datos.crtm.es/recurso/transporte/validacion/dpaypoint/>
	SELECT DISTINCT ?dPayPoint ?tarjeta ?title ?perfil (COUNT (DISTINCT ?obs) AS ?numValidaciones)
	WHERE {
	?obs a <http://datos.crtm.es/recurso/transporte/Validacion> .
	?obs ssn:observationResultTime ?time .
	#?obs ssn:observedBy <http://datos.crtm.es/recurso/transporte/validacion/dpaypoint/25_L18_P846> .
	?obs ssn:observedBy ?dPayPoint .
	?obs ssn:featureOfInterest ?tarjeta .
	#?obs ssn:observedProperty ?property .
	?obs ssn:observationResult ?sensorOutput .

ocorcho / gist:cf1e4a2117136b2b0277abb1a90c316b

Created May 26, 2016 09:54

CRTM - Número de observaciones en un dPayPoint agrupados por TTP

	SELECT DISTINCT ?tarjeta (COUNT (DISTINCT ?obs) AS ?numValidaciones) #?title ?perfil ?dPayPoint
	WHERE {
	?obs a <http://datos.crtm.es/recurso/transporte/Validacion> .
	?obs ssn:observationResultTime ?time .
	#?obs ssn:observedBy <http://datos.crtm.es/recurso/transporte/validacion/dpaypoint/25_L18_P846> .
	?obs ssn:observedBy ?dPayPoint .
	FILTER(?dPayPoint=<http://datos.crtm.es/recurso/transporte/validacion/dpaypoint/25_L18_P846>)
	?obs ssn:featureOfInterest ?tarjeta .
	#?obs ssn:observedProperty ?property .
	?obs ssn:observationResult ?sensorOutput .

ocorcho / gist:a100b65dfabb2ca41f25f636182c9fce

Created May 26, 2016 09:49

CRTM - Observación, TTP, fecha-hora, título, perfil y dPayPoint

	SELECT DISTINCT ?obs ?tarjeta ?time ?title ?perfil ?dPayPoint
	WHERE {
	?obs a <http://datos.crtm.es/recurso/transporte/Validacion> .
	?obs ssn:observationResultTime ?time .
	#?obs ssn:observedBy <http://datos.crtm.es/recurso/transporte/validacion/dpaypoint/25_L18_P846> .
	?obs ssn:observedBy ?dPayPoint .
	FILTER(?dPayPoint=<http://datos.crtm.es/recurso/transporte/validacion/dpaypoint/25_L18_P846>)
	?obs ssn:featureOfInterest ?tarjeta .
	#?obs ssn:observedProperty ?property .
	?obs ssn:observationResult ?sensorOutput .

ocorcho / query.sparql

Created March 4, 2016 16:33

Consulta para evitar que se generen duplicados cuando los criterios son de varios tipos

	PREFIX pproc: <http://contsem.unizar.es/def/sector-publico/pproc#>
	PREFIX s: <http://schema.org/>
	PREFIX pc: <http://purl.org/procurement/public-contracts#>
	PREFIX gr: <http://purl.org/goodrelations/v1#>
	PREFIX dcterms: <http://purl.org/dc/terms/>
	SELECT DISTINCT ?contrato ?criterios ?tipo ?nombreCriterio ?pesoCriterio
	WHERE {
	?contrato a pproc:Contract;
	dcterms:identifier "CUL07-14"^^xsd:string.
	?contrato pc:awardCriteriaCombination/pc:awardCriterion ?criterios.

ocorcho / Consulta

Created May 11, 2015 21:07

Consulta para obtener contratos y su coste asociados a una empresa

	SELECT DISTINCT ?uriCont ?formalizedDate xsd:float(?currency) WHERE {
	{
	SELECT DISTINCT ?uriCont ?formalizedDate xsd:string(?currencyValue) AS ?currency WHERE {
	?uriCont a pproc:Contract;
	pproc:contractObject/pproc:contractEconomicConditions/pproc:budgetPrice ?budgetPrice;
	pc:tender ?tender.
	?tender pproc:formalizedDate ?formalizedDate;
	pc:supplier ?supplier;
	pc:offeredPrice ?offeredPrice.
	?supplier s:name ?name .

ocorcho / Error-received.txt

Created April 10, 2015 08:24

Two queries on http://3cixty.eurecom.fr/sparql with different behaviour: bug in query processing related to geo-related filters

Virtuoso 22023 Error GEO..: Function st_distance() expects a geometry of type 1 as argument 0, not geometry of type 26626

ocorcho / Query1.sparql

Created March 10, 2015 12:25

SPARQL queries para obtener la lista de contratos por servicio gestor en el SPARQL endpoint de Zaragoza

	PREFIX pproc: <http://contsem.unizar.es/def/sector-publico/pproc#>
	PREFIX dcterms: <http://purl.org/dc/terms/>

	SELECT DISTINCT ?uri ?titulo ?servicioGestor WHERE
	{
	?uri a <http://contsem.unizar.es/def/sector-publico/pproc#Contract>;
	dcterms:title ?titul;
	pproc:managingDepartment ?managingDepartment.
	?managingDepartment dcterms:title ?servicioGestor
	} ORDER BY ?titulo

Oscar Corcho ocorcho