ocorcho

1. General Background and Overview

• Probabilistic Data Structures for Web Analytics and Data Mining : A great overview of the space of probabilistic data structures and how they are used in approximation algorithm implementation.
• Models and Issues in Data Stream Systems
• Philippe Flajolet’s contribution to streaming algorithms : A presentation by Jérémie Lumbroso that visits some of the hostorical perspectives and how it all began with Flajolet
• Approximate Frequency Counts over Data Streams by Gurmeet Singh Manku & Rajeev Motwani : One of the early papers on the subject.
• [Methods for Finding Frequent Items in Data Streams](http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.187.9800&rep

ocorcho

[
  {
    "op": "core/column-removal",
    "description": "Remove column tipo",
    "columnName": "tipo"
  },
  {
    "op": "core/column-removal",
    "description": "Remove column lastUpdated",
    "columnName": "lastUpdated"

ocorcho

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

ocorcho

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

ocorcho

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

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

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

  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

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

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 .