# Presentation: 805587

## SIC and NAICS Content Loading within for XMDR – May status report

**SIC and NAICS Content Loading ****within for XMDR – May status report**

**Fredric Gey**
**UC Berkeley**
**XMDR Project Meeting**
**May, 2007**
**UC Berkeley Faculty Club**

**Notes:**
A new name on the marque/masthead/title page credits
Karlo Berket joined LBL’s XMDR Project group as a part time programmer in January
He comes to us from the Cybersecurity and Network :& Distributed Systems Research Group at LBNL,
which continues to occupy and pay for the other half of his working hours.
I might add that both Karlo and Kevin are serious telecommuters – Karlo from MA and Kevin from NY,
But they keep in close touch with us via email, weekly teleconferences, and our project wiki

## SIC to NAICS Content (outline)

**What are SIC and NAICS?**
**How have they been loaded into the XMDR prototype?**
**Current loading status**
**mapping SIC-NAICS syntax for XMDR as special case of ontology mapping (next presentation)**

**Notes:**

Tell story about painful upgrade from T23 to T43
Analogy to upgrading 11179 to include more formal semantic information
We’ve been hearing about inference from Frank for a number of years (Prolog, etc.)

Problem that had a silver lining
Karlo machine crashed, so he had to re-install—did it on xmdr server and revised recipe

## SIC to NAICS content

**What are SIC and NAICS?**
**SIC – US Standard Industrial Classification**
**Hierarchical classification of US industry (2,3,4-digit)**
**Specified by the Office of Management and Budget**
**Used to report economic summary statistics until 1997**
**NAICS – North American Industrial Classification System**
**Replaced the SIC for uniform classification of industry in US, Canada, Mexico, beginning 1997**
**2,3,4,5,6-digit hierarchy**
**5-digit comparability between the three countries**
**6****th**** digit available for country-specific detail (zero used by USA where no additional detail is utilized)**

- 2

**Notes:**

Tell story about painful upgrade from T23 to T43
Analogy to upgrading 11179 to include more formal semantic information
We’ve been hearing about inference from Frank for a number of years (Prolog, etc.)

Problem that had a silver lining
Karlo machine crashed, so he had to re-install—did it on xmdr server and revised recipe

## NAICS loading into XMDR prototype 

**Load inputter for hierarchical classification list for LexGrid (thanks Harold)**
**Uses concept code construct**
**Uses NT relationship to specify hierarchy**

**Notes:**
Note more detailed explanation in NAICS.  Note partial matching

## NAICS loading into XMDR prototype 2

**Load inputter for hierarchical classification list for LexGrid **
**Uses NT relationship to specify hierarchy**
_**[-](http://bambam.lbl.gov:8080/xmdr/app.jsp)**_** ****<****lgRel:association association****="****NT****"**** forwardName****="****narrowerTerm****"**** isTransitive****="****true****"**** reverseName****="****broaderTerm****">**
** **** ****<****lgCommon:entityDescription****>****A generic broader/Narrower relationship****</****lgCommon:entityDescription****>**
**	****<****lgRel:sourceConcept sourceCodingScheme****="****SIC****"**** sourceConcept****="****104****">**
** ****	****<****lgRel:targetConcept**** ****targetCodingScheme****="****SIC****"**** targetConcept****="****1041****" />**** **
** **** ****	****<****lgRel:targetConcept**** ****targetCodingScheme****="****SIC****"**** targetConcept****="****1044****" />**** **
** **** ****	****</****lgRel:sourceConcept****>**
** **** ****</****lgRel:association****> **

**Notes:**
Note more detailed explanation in NAICS.  Note partial matching

## NAICS loading into XMDR prototype 3

**NAICS querying now in development version**
_**[http://bambam.lbl.gov:8080/xmdr/app.jsp](http://bambam.lbl.gov:8080/xmdr/app.jsp)**__** **_

**Notes:**
Note more detailed explanation in NAICS.  Note partial matching

## NAICS loading into XMDR prototype 4

**Definitions for NAICS loaded into the development version**
**Has embedded hyperlinks to other references NAICS codes**

**Notes:**
Note more detailed explanation in NAICS.  Note partial matching

## SIC to NAICS Matching(example for Mineral Industries)

- 47

**Notes:**
Note more detailed explanation in NAICS.  Note partial matching

## NAICS to SIC Matching

**Important for historical data comparison and development of time series**

**Notes:**
Note more detailed explanation in NAICS.  Note partial matching

## SIC-NAICS mapping into XMDR prototype

**SIC-NAICS mapping ‘just’ loaded  into development version**
_**[http://bambam.lbl.gov:8080/xmdr/app.jsp](http://bambam.lbl.gov:8080/xmdr/app.jsp)**__** **_
**Use “Application Search”**

**Notes:**
Note more detailed explanation in NAICS.  Note partial matching

## SIC-NAICS mapping into XMDR prototype

**SIC-NAICS mapping ‘just’ loaded  into development version**
_**[http://bambam.lbl.gov:8080/xmdr/app.jsp](http://bambam.lbl.gov:8080/xmdr/app.jsp)**__** **_
**Use “Application Search”**

**OOPS!**

**Notes:**
Note more detailed explanation in NAICS.  Note partial matching