Skip to content

Instantly share code, notes, and snippets.

Avatar

Ethan Gruber ewg118

  • American Numismatic Society
  • Charlottesville, Virginia
View GitHub Profile
@ewg118
ewg118 / test.geojson
Created May 30, 2020
Lost River State Park
View test.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@ewg118
ewg118 / bnf_pco.sparql
Created May 27, 2020
BnF coins in PCO
View bnf_pco.sparql
PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
PREFIX dcmitype: <http://purl.org/dc/dcmitype/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX nm: <http://nomisma.org/id/>
PREFIX nmo: <http://nomisma.org/ontology#>
PREFIX org: <http://www.w3.org/ns/org#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
@ewg118
ewg118 / delta-eta-types.sparql
Created May 14, 2020
Alexander coinage with letters, ordered by date
View delta-eta-types.sparql
PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX nmo: <http://nomisma.org/ontology#>
PREFIX org: <http://www.w3.org/ns/org#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT ?type ?date ?mint ?label ?lat ?long WHERE {
?monogram crm:P106_is_composed_of "Δ", "Η" .
?side nmo:hasControlmark ?monogram .
@ewg118
ewg118 / hadrian-concordances.csv
Created May 13, 2020
Concordance of old and new Hadrian RIC IDs for coins in OCRE
View hadrian-concordances.csv
We can't make this file beautiful and searchable because it's too large.
coin,id,collection,dataset,old,new
https://finds.org.uk/database/artefacts/record/id/145988,BH-FB1820,,"Roman coins from the Portable Antiquities Scheme",ric.2.hdn.577A,ric.2_3(2).hdn.241
https://finds.org.uk/database/artefacts/record/id/146671,BERK-7CEA81,,"Roman coins from the Portable Antiquities Scheme",ric.2.hdn.617,ric.2_3(2).hdn.649|ric.2_3(2).hdn.650
https://finds.org.uk/database/artefacts/record/id/181058,SUSS-45EEB0,,"Roman coins from the Portable Antiquities Scheme",ric.2.hdn.975b,ric.2_3(2).hdn.881
https://finds.org.uk/database/artefacts/record/id/224361,SF-A41513,,"Roman coins from the Portable Antiquities Scheme",ric.2.hdn.577B,ric.2_3(2).hdn.242
https://finds.org.uk/database/artefacts/record/id/22606,SOMDOR220,,"Roman coins from the Portable Antiquities Scheme",ric.2.hdn.85b,ric.2_3(2).hdn.394
https://finds.org.uk/database/artefacts/record/id/240230,LEIC-7AB954,,"Roman coins from the Portable Antiquities Scheme",ric.2.hdn.577B,ric.2_3(2).hdn.242
https://finds.org.uk/database/artefacts/record/id
@ewg118
ewg118 / test.geojson
Last active May 5, 2020
test geojson polygon
View test.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@ewg118
ewg118 / geonames_feature_codes.csv
Created Apr 16, 2020
Geonames - Wikidata - Getty AAT Feature Code Concordance
View geonames_feature_codes.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 9 columns, instead of 3. in line 5.
Geonames Feature Code,Geonames Label,Wikidata URI,Wikidata label,AAT ID,AAT label,description,Geonames Feature Class,Wikipedia Code
ADM1,first-order administrative division,http://www.wikidata.org/entity/Q10864048,first-level administrative country subdivision,http://vocab.getty.edu/aat/300387064,first level subdivisions (political entities),"a primary administrative division of a country, such as a state in the United States",A,A.ADM1
ADM1H,historical first-order administrative division,,,,,a former first-order administrative division,A,A.ADM1H
ADM2,second-order administrative division,http://www.wikidata.org/entity/Q13220204,second-level administrative country subdivision,http://vocab.getty.edu/aat/300387145,second level subdivisions (political entities),a subdivision of a first-order administrative division,A,A.ADM2
ADM2H,historical second-order administrative division,,,,,a former second-order administrative division,A,A.ADM2H
ADM3,third-order administrative division,http://www.wikidata.org/entity/Q132217
@ewg118
ewg118 / counts-by-types.sparql
Last active Mar 24, 2020
Get a count of each type (including subtypes) in the PELLA corpus with a photo
View counts-by-types.sparql
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX nm: <http://nomisma.org/id/>
PREFIX nmo: <http://nomisma.org/ontology#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT ?type (count(?coin) as ?count) WHERE {
?type dcterms:source|skos:exactMatch/dcterms:source nm:pella_type_series .
?coin nmo:hasTypeSeriesItem|nmo:hasTypeSeriesItem/skos:broader ?type .
@ewg118
ewg118 / bm-lerider.sparql
Created Mar 19, 2020
SPARQL query of (old) BM data model, running locally, for the coins of Philip II from Le Rider 1977
View bm-lerider.sparql
PREFIX bmo: <http://collection.britishmuseum.org/id/ontology/>
PREFIX dcmitype: <http://purl.org/dc/dcmitype/>
PREFIX ecrm: <http://erlangen-crm.org/current/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX object: <http://collection.britishmuseum.org/id/object/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX thes: <http://collection.britishmuseum.org/id/thesauri/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
@ewg118
ewg118 / railroad-trespassing.csv
Created Jan 10, 2020
Citations for railroad trespassing in Charlottesville, georeferenced, 1997-2020
View railroad-trespassing.csv
Address Coordinates City Date-Time Date
600 BRANDON AVE 38.029233,-78.504678 Charlottesville 1998-02-24T10:53:00Z 1998-02-24
100 GARRETT ST 38.028772,-78.482812 Charlottesville 1998-08-26T01:15:00Z 1998-08-26
100 GARRETT ST 38.028772,-78.482812 Charlottesville 1998-08-26T11:15:00Z 1998-08-26
RR TRACKS UNDER JEFFERSON PK AVE 38.0288016,-78.5088788 Charlottesville 1999-04-02T00:33:00Z 1999-04-02
RR TRACKS UNDER JEFFERSON PK AVE 38.0288016,-78.5088788 Charlottesville 1999-04-02T00:35:00Z 1999-04-02
RR TRACKS UNDER JEFFERSON PK AVE 38.0288016,-78.5088788 Charlottesville 1999-04-02T00:35:00Z 1999-04-02
RR TRACKS UNDER JEFFERSON PK AVE 38.0288016,-78.5088788 Charlottesville 1999-04-02T00:35:00Z 1999-04-02
RR TRACKS UNDER JEFFERSON PK AVE 38.0288016,-78.5088788 Charlottesville 1999-04-02T00:39:00Z 1999-04-02
1159 N EMMET ST 38.05152,-78.50217 Charlottesville 1999-04-17T16:15:00Z 1999-04-17
@ewg118
ewg118 / monogram-letters.sparql
Created Jan 8, 2020
Example monogram query for letters
View monogram-letters.sparql
PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
PREFIX dcmitype: <http://purl.org/dc/dcmitype/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX nm: <http://nomisma.org/id/>
PREFIX nmo: <http://nomisma.org/ontology#>
PREFIX org: <http://www.w3.org/ns/org#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
You can’t perform that action at this time.