View unanswered posts | View active topics It is currently Fri Jan 24, 2020 6:07 am

Reply to topic  [ 3 posts ] 
 Part 4 spreadsheets - in machine readable xls and csv 
Author Message

Joined: Mon May 06, 2013 6:54 am
Posts: 18
I have taken the time to make the ISO 15926-4 spreadsheets referenced here[1] machine readable so that I could compare them to the contents of the RDL at the PCA endpoint.

.xls files are not very friendly to read since they support far too many features and provide to much history in the files. The work has been to:

- change headers so that they are consistent throughout the spreadsheets
- clear all empty whitespace
- redo borders

The .xls files were then converted to .csv files (with , "" in utf-8). These are much easier to parse.

Everything is available at:


1: ... /index.htm

Håvard Mikkelsen Ottestad @ PCA

Wed Jul 31, 2013 8:16 am

Joined: Mon Feb 27, 2012 11:01 pm
Posts: 282
Location: Moscow, Russia
What kind of comparison you are planning? In my understanding completely new mapping of these spreadsheets is required to include all data in RDL. To do such mapping a number of decision should be taken. For example, whether to map alternative URIs to alternative URIs, or to common string identifiers. Whether to map to ClassOfIdentification or to corresponding template? If identification is classified - what class of identification is required in RDL?

Wed Jul 31, 2013 8:29 am
Profile WWW

Joined: Mon May 06, 2013 6:54 am
Posts: 18
I have written sparql queries for these coloumns:

Unique name
Text definition
superclass 1
superclass 2
superclass 3
ISO 15926-2 entity
classification 1
classification 2
classification 3

I always presume that the unique name can be found in the RDL by using "hasDesignation" [1].

Then I show any difference in a table. There are some differences and we are working on categorising the differences and making a plan for managing the changes for the ISO meeting in November in South Korea.


Håvard Mikkelsen Ottestad @ PCA

Wed Jul 31, 2013 8:39 am
Display posts from previous:  Sort by  
Reply to topic   [ 3 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
eXTReMe Tracker
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software.