Archives for Codes

9.8.1 Data upload test

Posted by admin on 14th October 2015

Data in trim_test table:

[is_showtable table=”trim_test”]

Download trim_test:

[is_downtable table=”trim_test”]

9.9.8 Download table sample

Posted by admin on 30th September 2015

Example of Download CSV.

[is_downtable table=”code_db7″ fields=”” text=”Download DB7 codetable here”]

 

[is_downtable table=”code_nace” fields=”” text=”Download NACE codes  here”]

 

[is_downtable table=”spinstof” fields=”” text=”Download main substancetable  here”]

 

[is_downtable table=”spinname” fields=”” text=”Download substance names here”]

 

[is_downtable table=”useT” fields=”” text=”Download total use data here”]

 

[is_downtable table=”useI” FIELDS=”” text=”Download use data by industry here”]

 

[is_downtable table=”useId” fields=”” text=”Download use data by detailed industry here”]

 

[is_downtable table=”usePC” fields=”” text=”Download use data by Product Category here”]

 

[is_downtable table=”usePCd” fields=”” text=”Download use data by detailed Product Category here”]

 

[is_downtable table=”useexpo” fields=”” text=”Download exposure data here”]

 

 

9.9.9 Codetable samples

Posted by admin on 17th September 2015

Each code can be described with some text and a lookup to the actual codetable. Here’s some samples for the formating of the lookup:

Format 1
This sample uses the full sql syntax of the wordpress shortcode is_showtable:
sql=”SELECT code as Code, text as Explanation from code_nace  Limit 0,6″
[is_showtable table=”” sql=”SELECT TOP 6 code as Code, text as Explanation from code_nace “]
[is_showtable table=”” sql=”SELECT TOP 6 code as Code, text as Explanation from code_nace”]

Format 2
This sample uses the simple format of is_showtable: table=”code_nace”

[is_showtable table=”code_nace” fields=””]

Format 3
This sample uses the “table and fields” format of is_showtable: table=”code_db7″ fields=”code”

[is_showtable table=”code_db7″ fields=”code”]
[is_downtable table=”” sql=”SELECT TOP 10 code as Code, text as Explanation from code_nace”]

3.6 Colourindex

Posted by admin on 17th September 2015

The colourindex is a classification maintaned by the dye industry. You can find more information here.

Below you find the colourcodes used in SPIN. You can search in this list using your browsers search function: Hit Ctrl + F on your keyboard. Or you can download the entire table as a csv file [is_downtable table=”code_nace” sql=”SELECT code as Code, text as Explanation from code_nace” text=”Download Colourindex codetable here”]
[is_showtable table=” code_nace”] sql=”SELECT code as Code, meaning as Explanation from code_colourindex “

3.2.1 NACE codes for industrial use categories

Posted by Berit-Aya Jensen on 10th September 2015

The NACE codes are the european codes for industry: Nomenclature statistique des Activités économiques dans la Communauté Européenne. There is more information here and you can find the complete codelist here. The NACE codes used in SPIN is shown below. You can search for anything on this page by pressing Ctrl+F on your keyboard. The full table can be downloaded as a csv file by clicking [is_downtable table=”code_nace” fields=”” text=”here”]

 

[is_showtable table=”code_nace” fields=””]