Re: Linked SDMX Data
On 2014-08-11 22:58, Gannon Dick wrote: Sorry for the x-post Don't be. It is a natural thing. Hi Sarven, I noticed you used GeoNames for the Australian Bureau of Statistics Linked Data hack mentioned below. GeoNames does much useful work ... but everyone in the Linked Data business could use a little help. Domains - in theory, the countries of the world are a group of (federalized data set of ...) (groups of) Court Houses, Jurisdictions, keyed with two and three letter acronyms (ISO 3166). This set for all practical purposes is a Unicode Code Page, but instead of (16x4)=256 members there are (169x4)=676 Latin Alphabet Capital Letters. Statistical metrics at the domain level are manipulated with Linear Algebra and Linear Programming. Diacritics (Côte d'Ivoire) or alternate forms (Ivory Coast) do nothing semantically useful, the acronym is the leveler. So, I rewrote the GeoName table (http://www.geonames.org/countries/) to be: 1) Unicode compliant for XML (HTML entities are HEX escaped) 2) The Geo's, Country Profiles, whatever are local links. I left those as is and included/matched the MARC System / US Library of Congress Linked Data Service URI's (http://id.loc.gov/vocabulary/countries.html). 3) Finally, I used an SQL RDB to do an Outer Join on the Code Set - all 676 possibilities. Adding a three character code synonym does not increase the code page size. It is then possible to split this registry into lists of codes 1) Present, 2) Missing and 3) Slack (in the Linear Programming usage). 4) Put the files in (FODS - (Flat XML) Open Document Spreadsheets format) so that European Civil Servants can not whine about data quality (got your back, DERI, you too ABS). http://www.rustprivacy.org/2014/balance/gts/geonames_domains.zip Unfortunately, when RDF Lists of Place Names are filtered through previously written applications the result is often unhelpful additions, however these steps should ameliorate the problem significantly. --Gannon Thanks Gannon. If I understand correctly, you got around to implement your suggestion back in 2012Q1: http://lists.w3.org/Archives/Public/public-lod/2012Mar/0108.html Care to clarify what I should make of: http://www.rustprivacy.org/2012/urn-lex/artificial-bureaucracy.html ? -Sarven http://csarven.ca/#i smime.p7s Description: S/MIME Cryptographic Signature
Re: Linked SDMX Data
Hi Sarven, Yes, I have implemented Artificial Bureaucracy, a derivative, so to speak, of Artificial Intelligence. Much more importantly, it was also officially adopted by a reputable *cough* Spook Shop *cough* Authority on June 30, 2014 [1]. The two letter (country/domain) codes are affine [2] with all other systems of similar codes (eg. ISO 3166-1 (2A), ISO 3166-2 (3A), MARC (2A), FIPS (2N), etc.. Artificial Bureaucracy is shorthand for: There are only 676 names in the hat, draw one and put it back before you draw another one.. There are many subdivisions, and a RESTful *stovepipe* has an unlimited number of variations, but a RESTful *top level domain* does not. Display Language Codes (2A), Bibliographic Language Codes (2A or 3A) have the same property, although the US Library of Congress is the ISO Authority and Librarians in general are mean enough to use it on hapless Scholars caught in their web. I doubt that the scheme has changed much since I linked it two years ago[3]. Anyway, Time Shifting (think: Quarterly Conference Calls with Analysts) and Shape Shifting (think: National Boundaries disputed or not) are part and parcel of the same geometry[4], as I observed yesterday[5], spreadsheets [6]. At all costs you want to avoid inversion of the Work-Life-(rest) Balance. This may be a deep question for Finance (money works 24x7), but it is very simple principle for a local Grocery Store (is there somewhere we can send cabbage overnight where it could be sold = will be a performing asset ? Um, no.). None of this is an attempt to own Linked Data in the Embrace, Extend, Extinguish sense. The NGA Undersea Feature is owl:sameAs the UN-LOCODE Installations in International Waters. --Gannon [1] http://geonames.nga.mil/namesgaz/ [2] http://en.wikipedia.org/wiki/Affine_transformation [3] http://www.rustprivacy.org/2012/urn/lang/person/ [4] http://en.wikipedia.org/wiki/Pythagorean_theorem [5] http://lists.w3.org/Archives/Public/public-egov-ig/2014Aug/0003.html [6] spreadsheets http://lists.w3.org/Archives/Public/public-egov-ig/2014Aug/0001.html On Fri, 8/15/14, Sarven Capadisli i...@csarven.ca wrote: Subject: Re: Linked SDMX Data To: Gannon Dick gannon_d...@yahoo.com, public-lod@w3.org Cc: KevinFord k...@loc.gov, public-loc...@w3.org public-loc...@w3.org, public-egov...@w3.org public-egov...@w3.org, public-open...@w3.org public-open...@w3.org Date: Friday, August 15, 2014, 4:12 AM On 2014-08-11 22:58, Gannon Dick wrote: Sorry for the x-post Don't be. It is a natural thing. Hi Sarven, I noticed you used GeoNames for the Australian Bureau of Statistics Linked Data hack mentioned below. GeoNames does much useful work ... but everyone in the Linked Data business could use a little help. Domains - in theory, the countries of the world are a group of (federalized data set of ...) (groups of) Court Houses, Jurisdictions, keyed with two and three letter acronyms (ISO 3166). This set for all practical purposes is a Unicode Code Page, but instead of (16x4)=256 members there are (169x4)=676 Latin Alphabet Capital Letters. Statistical metrics at the domain level are manipulated with Linear Algebra and Linear Programming. Diacritics (Côte d'Ivoire) or alternate forms (Ivory Coast) do nothing semantically useful, the acronym is the leveler. So, I rewrote the GeoName table (http://www.geonames.org/countries/) to be: 1) Unicode compliant for XML (HTML entities are HEX escaped) 2) The Geo's, Country Profiles, whatever are local links. I left those as is and included/matched the MARC System / US Library of Congress Linked Data Service URI's (http://id.loc.gov/vocabulary/countries.html). 3) Finally, I used an SQL RDB to do an Outer Join on the Code Set - all 676 possibilities. Adding a three character code synonym does not increase the code page size. It is then possible to split this registry into lists of codes 1) Present, 2) Missing and 3) Slack (in the Linear Programming usage). 4) Put the files in (FODS - (Flat XML) Open Document Spreadsheets format) so that European Civil Servants can not whine about data quality (got your back, DERI, you too ABS). http://www.rustprivacy.org/2014/balance/gts/geonames_domains.zip Unfortunately, when RDF Lists of Place Names are filtered through previously written applications the result is often unhelpful additions, however these steps should ameliorate the problem significantly. --Gannon Thanks Gannon. If I understand correctly, you got around to implement your suggestion back in 2012Q1: http://lists.w3.org/Archives/Public/public-lod/2012Mar/0108.html Care to clarify what I should make of: http://www.rustprivacy.org/2012/urn-lex/artificial-bureaucracy.html ? -Sarven http://csarven.ca/#i
Re: Linked SDMX Data
On 2014-08-05 12:08, Sarven Capadisli wrote: On 2014-04-23 15:31, Sarven Capadisli wrote: On 2014-04-22 14:18, Sarven Capadisli wrote: On 2013-08-08 15:17, Sarven Capadisli wrote: On 03/08/2013 01:04 PM, Sarven Capadisli wrote: On 02/15/2013 02:42 PM, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-data ECB Linked Data: http://ecb.270a.info/ IMF Linked Data: http://imf.270a.info/ UIS Linked Data: http://uis.270a.info/ FRB Linked Data: http://frb.270a.info/ BIS Linked Data: http://bis.270a.info/ ABS Linked Data: http://abs.270a.info/ -Sarven http://csarven.ca/#i smime.p7s Description: S/MIME Cryptographic Signature
Re: Linked SDMX Data
Sorry for the x-post Hi Sarven, I noticed you used GeoNames for the Australian Bureau of Statistics Linked Data hack mentioned below. GeoNames does much useful work ... but everyone in the Linked Data business could use a little help. Domains - in theory, the countries of the world are a group of (federalized data set of ...) (groups of) Court Houses, Jurisdictions, keyed with two and three letter acronyms (ISO 3166). This set for all practical purposes is a Unicode Code Page, but instead of (16x4)=256 members there are (169x4)=676 Latin Alphabet Capital Letters. Statistical metrics at the domain level are manipulated with Linear Algebra and Linear Programming. Diacritics (Côte d'Ivoire) or alternate forms (Ivory Coast) do nothing semantically useful, the acronym is the leveler. So, I rewrote the GeoName table (http://www.geonames.org/countries/) to be: 1) Unicode compliant for XML (HTML entities are HEX escaped) 2) The Geo's, Country Profiles, whatever are local links. I left those as is and included/matched the MARC System / US Library of Congress Linked Data Service URI's (http://id.loc.gov/vocabulary/countries.html). 3) Finally, I used an SQL RDB to do an Outer Join on the Code Set - all 676 possibilities. Adding a three character code synonym does not increase the code page size. It is then possible to split this registry into lists of codes 1) Present, 2) Missing and 3) Slack (in the Linear Programming usage). 4) Put the files in (FODS - (Flat XML) Open Document Spreadsheets format) so that European Civil Servants can not whine about data quality (got your back, DERI, you too ABS). http://www.rustprivacy.org/2014/balance/gts/geonames_domains.zip Unfortunately, when RDF Lists of Place Names are filtered through previously written applications the result is often unhelpful additions, however these steps should ameliorate the problem significantly. --Gannon On Mon, 8/11/14, Sarven Capadisli i...@csarven.ca wrote: Subject: Re: Linked SDMX Data To: public-lod@w3.org Date: Monday, August 11, 2014, 7:20 AM On 2014-08-05 12:08, Sarven Capadisli wrote: On 2014-04-23 15:31, Sarven Capadisli wrote: On 2014-04-22 14:18, Sarven Capadisli wrote: On 2013-08-08 15:17, Sarven Capadisli wrote: On 03/08/2013 01:04 PM, Sarven Capadisli wrote: On 02/15/2013 02:42 PM, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-data ECB Linked Data: http://ecb.270a.info/ IMF Linked Data: http://imf.270a.info/ UIS Linked Data: http://uis.270a.info/ FRB Linked Data: http://frb.270a.info/ BIS Linked Data: http://bis.270a.info/ ABS Linked Data: http://abs.270a.info/ -Sarven http://csarven.ca/#i
Re: Linked SDMX Data
On 2014-04-23 15:31, Sarven Capadisli wrote: On 2014-04-22 14:18, Sarven Capadisli wrote: On 2013-08-08 15:17, Sarven Capadisli wrote: On 03/08/2013 01:04 PM, Sarven Capadisli wrote: On 02/15/2013 02:42 PM, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-data ECB Linked Data: http://ecb.270a.info/ IMF Linked Data: http://imf.270a.info/ UIS Linked Data: http://uis.270a.info/ FRB Linked Data: http://frb.270a.info/ BIS Linked Data: http://bis.270a.info/ -Sarven http://csarven.ca/#i smime.p7s Description: S/MIME Cryptographic Signature
Re: Linked SDMX Data
On 2014-04-22 14:18, Sarven Capadisli wrote: On 2013-08-08 15:17, Sarven Capadisli wrote: On 03/08/2013 01:04 PM, Sarven Capadisli wrote: On 02/15/2013 02:42 PM, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-data ECB Linked Data: http://ecb.270a.info/ IMF Linked Data: http://imf.270a.info/ UIS Linked Data: http://uis.270a.info/ FRB Linked Data: http://frb.270a.info/ -Sarven http://csarven.ca/#i smime.p7s Description: S/MIME Cryptographic Signature
Re: Linked SDMX Data
On 4/23/14 9:31 AM, Sarven Capadisli wrote: On 2014-04-22 14:18, Sarven Capadisli wrote: On 2013-08-08 15:17, Sarven Capadisli wrote: On 03/08/2013 01:04 PM, Sarven Capadisli wrote: On 02/15/2013 02:42 PM, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-data ECB Linked Data: http://ecb.270a.info/ IMF Linked Data: http://imf.270a.info/ UIS Linked Data: http://uis.270a.info/ FRB Linked Data: http://frb.270a.info/ -Sarven http://csarven.ca/#i Awesome! Great contributions to the LOD cloud :-) -- Regards, Kingsley Idehen Founder CEO OpenLink Software Company Web: http://www.openlinksw.com Personal Weblog: http://www.openlinksw.com/blog/~kidehen Twitter Profile: https://twitter.com/kidehen Google+ Profile: https://plus.google.com/+KingsleyIdehen/about LinkedIn Profile: http://www.linkedin.com/in/kidehen smime.p7s Description: S/MIME Cryptographic Signature
Re: Linked SDMX Data
On 2013-08-08 15:17, Sarven Capadisli wrote: On 03/08/2013 01:04 PM, Sarven Capadisli wrote: On 02/15/2013 02:42 PM, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-data ECB Linked Data: http://ecb.270a.info/ IMF Linked Data: http://imf.270a.info/ UIS Linked Data: http://uis.270a.info/ -Sarven http://csarven.ca/#i smime.p7s Description: S/MIME Cryptographic Signature
Re: Linked SDMX Data
On 03/08/2013 01:04 PM, Sarven Capadisli wrote: On 02/15/2013 02:42 PM, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-data ECB Linked Data: http://ecb.270a.info/ IMF Linked Data: http://imf.270a.info/ -Sarven http://csarven.ca/#i smime.p7s Description: S/MIME Cryptographic Signature
Re: Linked SDMX Data
On 02/15/2013 02:42 PM, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-data ECB Linked Data: http://ecb.270a.info/ -Sarven http://csarven.ca/#i smime.p7s Description: S/MIME Cryptographic Signature
Re: Linked SDMX Data
On 3/8/13 7:04 AM, Sarven Capadisli wrote: On 02/15/2013 02:42 PM, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-data ECB Linked Data: http://ecb.270a.info/ -Sarven http://csarven.ca/#i Great stuff ! -- Regards, Kingsley Idehen Founder CEO OpenLink Software Company Web: http://www.openlinksw.com Personal Weblog: http://www.openlinksw.com/blog/~kidehen Twitter/Identi.ca handle: @kidehen Google+ Profile: https://plus.google.com/112399767740508618350/about LinkedIn Profile: http://www.linkedin.com/in/kidehen smime.p7s Description: S/MIME Cryptographic Signature
Re: Linked SDMX Data
On 02/15/2013 09:09 PM, Hugh Glaser wrote: Awesome indeed. From the dump (found from void.ttl, of course!) I found some (4135) new exactMatches that I didn't have before and put them in sameas.org - thanks. Eg http://www.sameas.org/?uri=http://oecd.270a.info/code/1.0/CL_7HA_LOCATION/AUS Nice OECD chunk you got there. I can bring up a separate 270a store at something like sameas.org/store/270a with only your data in, if you would find it useful. That's might not be a bad idea because there will be a few more datasets coming up as soon as I retrieve them :) But you may want to be a bit more careful with the closeMatches. They are sometimes not very close :-) But I did get a laugh on this one! http://oecd.270a.info/code/1.0/CL_AMNE_IN_LOCATION/USA http://www.w3.org/2004/02/skos/core#closeMatch http://dbpedia.org/resource/United_Arab_States . Whoop. Okay, I guess that highlights an important point; I should not bother with anything that's not an exact match for countries. Because it doesn't make sense. It would only be really useful if I was trying to interlink the countries from A with the regions from B with some partitive relationship. BTW, I've just interlinked FAO Species with DBpedia, where the exactMatches are I think fairly accurate. I didn't bother to go deep into with anything else because I have zero clue about species. I'll add countries from FAO at some point, but right now as I see it, there are a bunch of codelists which consists of codes from different geoarea levels. Just a bit more work but no biggie. -Sarven smime.p7s Description: S/MIME Cryptographic Signature
Re: Linked SDMX Data
Thanks Michiaki. In my opinion, the most significant work on the Linked Data end was already done by the folks that originally worked on SDMX-RDF and RDF Data Cube vocabs. The Linked SDMX transformation is merely a bridge to bring in SDMX-ML data into the RDF world using those vocabs. -Sarven On 02/16/2013 02:39 AM, Michiaki Tatsubori wrote: Hi, Really great work! Just want to clarify the relevance to: http://publishing-statistical-data.googlecode.com/svn/trunk/specs/src/main/html/index.html It seems to spec about so-called SDMX-RDF. Thanks, Mich On Friday, February 15, 2013, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-__data http://csarven.ca/linked-sdmx-data -Sarven http://csarven.ca/#i -- - Michiaki (Mich) Tatsubori, PhD. m...@acm.org mailto:m...@acm.org IBM Research, Tokyo Research Laboratory smime.p7s Description: S/MIME Cryptographic Signature
Re: Linked SDMX Data
Hi, Really great work! Just want to clarify the relevance to: http://publishing-statistical-data.googlecode.com/svn/trunk/specs/src/main/html/index.html It seems to spec about so-called SDMX-RDF. Thanks, Mich On Friday, February 15, 2013, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-**data http://csarven.ca/linked-sdmx-data -Sarven http://csarven.ca/#i -- - Michiaki (Mich) Tatsubori, PhD. m...@acm.org IBM Research, Tokyo Research Laboratory
Re: Linked SDMX Data
On 2/15/13 8:42 AM, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-data -Sarven http://csarven.ca/#i Awesome job !! -- Regards, Kingsley Idehen Founder CEO OpenLink Software Company Web: http://www.openlinksw.com Personal Weblog: http://www.openlinksw.com/blog/~kidehen Twitter/Identi.ca handle: @kidehen Google+ Profile: https://plus.google.com/112399767740508618350/about LinkedIn Profile: http://www.linkedin.com/in/kidehen smime.p7s Description: S/MIME Cryptographic Signature
Re: Linked SDMX Data
On 15 February 2013 15:51, Kingsley Idehen kide...@openlinksw.com wrote: On 2/15/13 8:42 AM, Sarven Capadisli wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-**data http://csarven.ca/linked-sdmx-data -Sarven http://csarven.ca/#i Awesome job !! +1 to that and great write up too -- Regards, Kingsley Idehen Founder CEO OpenLink Software Company Web: http://www.openlinksw.com Personal Weblog: http://www.openlinksw.com/**blog/~kidehenhttp://www.openlinksw.com/blog/~kidehen Twitter/Identi.ca handle: @kidehen Google+ Profile: https://plus.google.com/**112399767740508618350/abouthttps://plus.google.com/112399767740508618350/about LinkedIn Profile: http://www.linkedin.com/in/**kidehenhttp://www.linkedin.com/in/kidehen
Re: Linked SDMX Data
Awesome indeed. From the dump (found from void.ttl, of course!) I found some (4135) new exactMatches that I didn't have before and put them in sameas.org - thanks. Eg http://www.sameas.org/?uri=http://oecd.270a.info/code/1.0/CL_7HA_LOCATION/AUS I can bring up a separate 270a store at something like sameas.org/store/270a with only your data in, if you would find it useful. But you may want to be a bit more careful with the closeMatches. They are sometimes not very close :-) But I did get a laugh on this one! http://oecd.270a.info/code/1.0/CL_AMNE_IN_LOCATION/USA http://www.w3.org/2004/02/skos/core#closeMatch http://dbpedia.org/resource/United_Arab_States . Best Hugh On 15 Feb 2013, at 13:42, Sarven Capadisli i...@csarven.ca wrote: Ahoy hoy, OECD Linked Data: http://oecd.270a.info/ BFS Linked Data: http://bfs.270a.info/ FAO Linked Data: http://fao.270a.info/ Linked SDMX Data: http://csarven.ca/linked-sdmx-data -Sarven http://csarven.ca/#i