intip.in/sparql

# Query
SELECT *
{ ?s ?p ?o }
LIMIT 10

# Ngecek ada atau tidak
ASK { <http//dbpedia.org/resource/Indonesia> ?p ?o }

#
SELECT *
{ ?si ?pi <http//dbpedia.org/resource/Indonesia> }


#
SELECT *
{ ?si <http//dbpedia.org/ontology/genre> <http//dbpedia.org/resource/Dangdut> .
  ?si <http//www.w3.org/2000/01/rdf-schema#label> ?nama
}
LIMIT 100


# list film
SELECT ?name ?durasi ?sutradara
WHERE {
  ?ins <http//purl.org/dc/terms/subject> <http//dbpedia.org/resource/Category:Indonesian_films> .
  ?ins <http//dbpedia.org/property/name> ?name .
  ?ins <http//dbpedia.org/ontology/Work/runtime> ?durasi .
  ?ins <http//dbpedia.org/property/director> ?sutradara .
}
LIMIT 10


# list film horror
SELECT ?name ?durasi ?sutradara
WHERE {
  ?ins <http//purl.org/dc/terms/subject> <http//dbpedia.org/resource/Category:Indonesian_horror_films> .
  ?ins <http//dbpedia.org/property/name> ?name .
  ?ins <http//dbpedia.org/ontology/Work/runtime> ?durasi .
  ?ins <http//dbpedia.org/property/director> ?sutradara .
}
LIMIT 100


# service
SELECT *
WHERE {
  SERVICE <http//data.intip.in/sparql/> {
    SELECT ?Provinsi ?Populasi_Proyeksi_BPS_2014 ?PDRB_per_kapita_2014_juta_rupiah WHERE {}
  }
}
LIMIT 25


# local
PREFIX owl: <http//www.w3.org/2002/07/owl#>
PREFIX ex: <http//example.com/filariasis.csv>
PREFIX ol: <http//data.intip.in/sparql/>
PREFIX eol: <http//purl.org/biodiversity/eol/>

SELECT *
WHERE {
  SERVICE <http//data.intip.in/sparql/> { SELECT ?Provinsi ?PDRB_per_kapita_2014_juta_rupiah WHERE {} } .
  #?Provinsi owl:sameAs ex:nama_provinsi .
  ?ins ex:nama_provinsi ?Provinsi .
  ?ins ex:pemberian_asi_2013 ?pemberian_asi_2013 .
  ?ins ex:terjangkit ?terjangkit .
  ?terjangkit ex:penderita_balita_u1 ?penderita_balita_u1 .
  ?terjangkit ex:penderita_balita_1to4 ?penderita_balita_1to4 .
}
LIMIT 100


# local baru [done]
PREFIX owl: <http//www.w3.org/2002/07/owl#>
PREFIX ex: <http//example.com/filariasis.csv>
PREFIX ol: <http//data.intip.in/sparql/>
PREFIX eol: <http//purl.org/biodiversity/eol/>
PREFIX rdf: <http//www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http//www.w3.org/2000/01/rdf-schema#>

SELECT *
WHERE {

  SERVICE <http//data.intip.in/sparql/> {
    SELECT ?Provinsi ?Populasi_Proyeksi_BPS_2014 ?PDRB_per_kapita_2014_juta_rupiah WHERE {}
  } .

  ?ins rdfs:label ?Provinsi .
  ?ins ex:pemberian_asi_2013 ?pemberian_asi_2013 .
  ?ins ex:terjangkit ?terjangkit .
  ?terjangkit ex:penderita_balita_u1 ?penderita_balita_u1 .
  ?terjangkit ex:penderita_balita_1to4 ?penderita_balita_1to4 .
}
LIMIT 100


# Long lat by id.dbpedia.org
SELECT DISTINCT ?provinsi ?long ?lat WHERE {
    ?provinsi rdf:type dbpedia-owl:Province .
    ?provinsi geo:lat ?lat .
    ?provinsi geo:long ?long .
}


# Fix data.intip.in + longlat
PREFIX ex: <http://example.com/filariasis.csv>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT *
WHERE {

  SERVICE <http//data.intip.in/sparql/> {
    SELECT ?Provinsi ?Populasi_Proyeksi_BPS_2014 ?PDRB_per_kapita_2014_juta_rupiah ?Longitude ?Latitude
    WHERE {}
  } .

  ?ins rdfs:label ?Provinsi .
  ?ins ex:pemberian_asi_2013 ?pemberian_asi_2013 .
  ?ins ex:terjangkit ?terjangkit .
  ?terjangkit ex:penderita_balita_u1 ?penderita_balita_u1 .
  ?terjangkit ex:penderita_balita_1to4 ?penderita_balita_1to4 .
}

LIMIT 100