Skip to content

Instantly share code, notes, and snippets.

View ncarboni's full-sized avatar

Nicola Carboni ncarboni

View GitHub Profile
@ncarboni
ncarboni / hashlib-openrefine.py
Created January 31, 2022 17:15
hashlib-openrefine
import hashlib
return hashlib.sha1(value.encode('utf-8')).digest().encode('hex')
@ncarboni
ncarboni / query_wikidata_visual_VC.rq
Created January 31, 2022 09:50
Wikidata query used for retrieving visual elements with their images for the VC project
SELECT * WHERE {
?visual wdt:P31 ?type .
?type wdt:P279*|wdt:P31 wd:Q4502142 .
?visual wdt:P18 ?image ;
wdt:P571 ?time .
OPTIONAL {
?visual wdt:P170 ?creator
}
@ncarboni
ncarboni / smithsonian_crm.sparql
Last active April 24, 2021 23:05
CRM query for obtaining appellation, dimension and creation date of an object
SELECT ?creation_date ?appellation ?label ?dimension_value ?dimension_unit
WHERE {
?x crm:P1_is_identified_by ?appellation ;
crm:P43_has_dimension ?dimension .
?creation_event crm:P108_has_produced ?x ;
crm:P4_has_time-span ?creation_date .
@ncarboni
ncarboni / names_mermaid.mmd
Created December 15, 2020 18:13
names_mermaid.mmd
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@ncarboni
ncarboni / artwork_mmd.mmd
Created December 15, 2020 18:10
Mermaid mmd
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@ncarboni
ncarboni / convert_geonames.py
Created May 26, 2020 10:16
Convert geonames RDF to usable format
# script modified from https://github.com/rhasan/sw/blob/master/genames/convert2ntriples.py
# This script will take genames rdf dump available here http://download.geonames.org/all-geonames-rdf.zip
# and convert each triples to N-Triple seralization.
# The dump has one rdf document per toponym on every line of the file.
# The produced N-Triples will be written in geonames.nt file. The final geonames.nt file is approximately 13.21GB
#!/usr/bin/python
import rdflib
fo = open("geonames.nt", "wb")
@ncarboni
ncarboni / authorityname_loc.ttl
Created April 1, 2020 09:56
AuthorityNames_LOC
@prefix ns0: <http://www.loc.gov/mads/rdf/v1#> .
@prefix ns1: <http://id.loc.gov/vocabulary/identifiers/> .
@prefix ns2: <http://id.loc.gov/ontologies/RecordInfo#> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix foaf: <http://xmlns.com/foaf/0.1/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix ns3: <http://id.loc.gov/ontologies/bflc/> .
<http://id.loc.gov/authorities/names/n50069453>
a <http://www.loc.gov/mads/rdf/v1#CorporateName>, <http://www.loc.gov/mads/rdf/v1#Authority> ;
@ncarboni
ncarboni / viaf_sameness.nt
Created March 25, 2020 15:24
VIAF encoding sameness
<http://viaf.org/viaf/122650373> <http://schema.org/sameAs> <http://www.wikidata.org/entity/Q19596483> .
<http://viaf.org/viaf/122650373> <http://schema.org/sameAs> <http://viaf.org/viaf/122650373> .
@ncarboni
ncarboni / bnf_encoding_sameness.nt
Created March 19, 2020 13:28
BNF encoding sameness
<http://data.bnf.fr/ark:/12148/cb11896729n> <http://www.w3.org/2002/07/owl#sameAs> <http://wikidata.org/entity/Q7192019> .
<http://data.bnf.fr/ark:/12148/cb11896729n> <http://xmlns.com/foaf/0.1/focus> <http://data.bnf.fr/ark:/12148/cb11896729n#about> .
<http://data.bnf.fr/ark:/12148/cb11896729n#about> <http://www.w3.org/2002/07/owl#sameAs> <http://data.bnf.fr/ark:/12148/cb11896729n#foaf:Person> .
<http://data.bnf.fr/ark:/12148/cb11896729n#about> <http://www.w3.org/2002/07/owl#sameAs> <http://viaf.org/viaf/44296876> .
<http://data.bnf.fr/ark:/12148/cb11896729n#about> <http://www.w3.org/2002/07/owl#sameAs> <http://www.idref.fr/026787431/id> .
@ncarboni
ncarboni / bnf_encoding_labels.nt
Created March 19, 2020 13:20
BNF Encoding labels
<http://data.bnf.fr/ark:/12148/cb11896729n> <http://xmlns.com/foaf/0.1/focus> <http://data.bnf.fr/ark:/12148/cb11896729n#about> .
<http://data.bnf.fr/ark:/12148/cb11896729n#about> <http://xmlns.com/foaf/0.1/familyName> "Choffard" .
<http://data.bnf.fr/ark:/12148/cb11896729n#about> <http://xmlns.com/foaf/0.1/gender> "male" .
<http://data.bnf.fr/ark:/12148/cb11896729n#about> <http://xmlns.com/foaf/0.1/givenName> "Pierre-Philippe" .
<http://data.bnf.fr/ark:/12148/cb11896729n#about> <http://xmlns.com/foaf/0.1/name> "Pierre-Philippe Choffard" .