Oscar Corcho ocorcho
ocorcho
/ transformaciones composicion pleno
Created
July 14, 2016 08:37
Transformaciones de fichero composición pleno Aragón
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
NewerOlder