Wow, Irene, I love the technique. I was going to finish up my work on it today (by manually bringing in triples from the spreadsheet), but I really like the way you've done this. I'm going to give it a try.
Thank you! On Sunday, November 22, 2015 at 7:29:06 PM UTC-7, Irene Polikoff wrote: > > Barton, > > Most likely I was the one who converted 2007 codes in the past. I just did > the same with 2012 – see attached Turtle file and the spreadsheet source. > > These days, doing conversions of hierarchical spreadsheets is a simpler > job than a few years ago. If you have TopBraid EVN or TopBraid RDM or > TopBraid Composer Maestro Edition with the demo version of these products, > you can convert a spreadsheet in a few minutes: > > > - Start TopBraid EVN > - Create a taxonomy > - Define class (es) that you need. You could go with just one class, > such as NAICS Classification. I created several subclasses so I could > split > the codes into Sectors, Subsectors, Industry Groups and Industries > - Create one property – NAICS 2012 code > - Go to Import tab and Import Spreadsheet using Pattern saying that > you are importing instances of NAICS Classification. > - Choose Path with Fixed Length Segments pattern. This creates a > hierarchy from NAICS or any other spreadsheet where IDs of children are > derived from the parent ID by appending a fixed number of characters. For > example, 111 has broader 11, 1110 and 1111 has broader 111, etc. In this > case, a child has the same ID as its parent plus 1 additional character. > - In the section Hierarchy (Path with fixed-length Segments) specify > the column that holds NAICS codes and say that the segment length is 1 > - Map the column containing titles to the label or preferred label > property > - In the Unique Identifiers section select the column that holds NAICS > codes as Id column #1 > - The unique identifier will be used to create URIs. You can also > chose the constant part of the URI. I selected “ > http://topquadrant.com/naics/2012/“. This creates URIs like > http://topquadrant.com/naics/2012/11 which in retrospect was probably > not the best choice as the local part of the URI should not start with the > number. One alternative would be something like “ > http://topquadrant.com/naics/2012/naics-“ so that the URI would be > http://topquadrant.com/naics/2012/naics-11. > > > This should be it except, unfortunately, there are a few areas where NAICS > codes in the spreadsheet don’t fit the pattern. All sectors have two digit > codes like 11, except for the following three that are combining them: > 31-33, 44-45, 48-49. Because they don’t fit the pattern, their children are > not automatically connected (we have no way of knowing that 485 is a child > of 48-49) and need to be adjusted manually. > > I also did some batch editing to separate into Sectors, Subsectors, etc. > > After you are done, use Export tab to export RDF serialization of your > choice. > > Irene Polikoff > > From: Barton Petersen <[email protected] <javascript:>> > Reply-To: <[email protected] <javascript:>> > Date: Friday, November 20, 2015 at 12:40 PM > To: TopBraid Suite Users <[email protected] <javascript:>> > Subject: [topbraid-users] NAICS 2012 from TQ? > > Right now I'm using the NAICS codes that Top Quadrant converted from 2007. > I need to move to 2012, but I'm not seeing an updated version. The NAICS > turtle documents that are laying around on the internet do not have the > same format as the TQ version from 2007. Is anyone aware of an updated > version from TQ? > > Thank you, > > Bart > > -- > You received this message because you are subscribed to the Google Group > "TopBraid Suite Users", the topics of which include Enterprise Vocabulary > Network (EVN), Reference Data Manager (RDM), TopBraid Composer, TopBraid > Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. > To post to this group, send email to [email protected] > <javascript:> > --- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), Reference Data Manager (RDM), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to [email protected] --- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
