<commit_before>PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#> 
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
PREFIX strdf: <http://strdf.di.uoa.gr/ontology#> 
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 
PREFIX gag: <http://geo.linkedopendata.gr/greekadministrativeregion/ontology#>

INSERT {?newHotspot rdf:type noa:Hotspot ;
		    noa:hasConfidence ?hConfidence ;
		    noa:hasGeometry ?hGeometry1 ;
		    noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ; 
		    noa:isDerivedFromSensor "SENSOR"^^xsd:string ;
		    noa:hasConfirmation noa:unknown ;
		    noa:producedFromProcessingChain "PROCESSING_CHAIN-TimePersistence"^^xsd:string ; 
		    noa:isProducedBy noa:noa ;
		    gag:hasMunicipality ?hMunicipality1 ;
		    noa:isDerivedFromSatellite "SAT"^^xsd:string ;
                    noa:refinedBy noa:temporalPersistence ;
                    noa:refinedBy ?refined .
}
WHERE {
	SELECT  (URI(CONCAT(STR(MAX(?h1)),"/virtual/NEW_HOTSPOT")) AS ?newHotspot)
			(SUM(?hConfidence1)/ACQUISITIONS_IN_HALF_AN_HOUR AS ?hConfidence)
			?hGeometry1 ?hMunicipality1
  WHERE {
    ?h1 noa:hasConfidence ?hConfidence1 ;
        noa:hasGeometry ?hGeometry1 ;
        gag:hasMunicipality ?hMunicipality1 ;
        noa:hasAcquisitionTime ?hAcquisitionTime1 ;
        noa:isDerivedFromSensor "SENSOR"^^xsd:string ;
        noa:producedFromProcessingChain "PROCESSING_CHAIN"^^xsd:string .
    OPTIONAL { ?h1 noa:isDiscarded ?z } .
    FILTER (!BOUND(?z)) .
    OPTIONAL { ?h1 noa:refinedBy ?refined } .
    FILTER( "MIN_ACQUISITION_TIME"^^xsd:dateTime <= ?hAcquisitionTime1 && ?hAcquisitionTime1 < "TIMESTAMP"^^xsd:dateTime ) .
    OPTIONAL {
      ?h2 noa:hasGeometry ?hGeometry2 ;
          noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ;<commit_msg>TimePersistence creates different URI for each virtual hotspost with common parent but different timestamp<commit_after>PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#> 
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
PREFIX strdf: <http://strdf.di.uoa.gr/ontology#> 
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 
PREFIX gag: <http://geo.linkedopendata.gr/greekadministrativeregion/ontology#>

INSERT {?newHotspot rdf:type noa:Hotspot ;
		    noa:hasConfidence ?hConfidence ;
		    noa:hasGeometry ?hGeometry1 ;
		    noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ; 
		    noa:isDerivedFromSensor "SENSOR"^^xsd:string ;
		    noa:hasConfirmation noa:unknown ;
		    noa:producedFromProcessingChain "PROCESSING_CHAIN-TimePersistence"^^xsd:string ; 
		    noa:isProducedBy noa:noa ;
		    gag:hasMunicipality ?hMunicipality1 ;
		    noa:isDerivedFromSatellite "SAT"^^xsd:string ;
                    noa:refinedBy noa:temporalPersistence ;
                    noa:refinedBy ?refined .
}
WHERE {
	SELECT  (URI(CONCAT(STR(MAX(?h1)),"/virtual/", substr("TIMESTAMP", 3, 2), substr("TIMESTAMP", 6, 2), substr("TIMESTAMP", 9, 2), "_", substr("TIMESTAMP", 12, 2), substr("TIMESTAMP", 15, 2) )) AS ?newHotspot)
			(SUM(?hConfidence1)/ACQUISITIONS_IN_HALF_AN_HOUR AS ?hConfidence)
			?hGeometry1 ?hMunicipality1
  WHERE {
    ?h1 noa:hasConfidence ?hConfidence1 ;
        noa:hasGeometry ?hGeometry1 ;
        gag:hasMunicipality ?hMunicipality1 ;
        noa:hasAcquisitionTime ?hAcquisitionTime1 ;
        noa:isDerivedFromSensor "SENSOR"^^xsd:string ;
        noa:producedFromProcessingChain "PROCESSING_CHAIN"^^xsd:string .
    OPTIONAL { ?h1 noa:isDiscarded ?z } .
    FILTER (!BOUND(?z)) .
    OPTIONAL { ?h1 noa:refinedBy ?refined } .
    FILTER( "MIN_ACQUISITION_TIME"^^xsd:dateTime <= ?hAcquisitionTime1 && ?hAcquisitionTime1 < "TIMESTAMP"^^xsd:dateTime ) .
    OPTIONAL {
      ?h2 noa:hasGeometry ?hGeometry2 ;
          noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ;
{'fraction_non_alphanumeric': 0.12939001848428835, 'fraction_numerical': 0.01954053340374967, 'mean_word_length': 4.07095046854083, 'pattern_counts': {'":': 0, '<': 17, '<?xml version=': 0, '>': 13, 'https://': 0, 'lorem ipsum': 0, 'www.': 4, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6634195', 'n_tokens_mistral': 1547, 'n_tokens_neox': 1390, 'n_words': 200}