Archives on September, 2015

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 “

1.6.1 NACE Report

Posted by Berit-Aya Jensen on 15th September 2015

1.6.1             NACE Report

For a selected Nordic country and year, the NACE Report gives you an overview of the total volume of each specific substance and the total number of preparations containing this substance in a selected industrial branch. Country, year and branch code are selected from drop down menus in the top of the report before the “find” button is pressed. The branch codes that are used follows the NACE system on a 2-digit level as described in section “1.6.3 On-line help – Industrial use”.

 

1_1.6.1

2_1.6.1

 

When you press the “Find” button after country, year and branch code have been selected, the substances are listed with the higher volumes first. Please note that if the total volume of a substance equals “0,0”, it only means that it is below the limit of accuracy, which is 100 kg.

 

3_1.6.1.
If you press the button “Return from report” you will return to the report window. If you press the “Print report” button, a preview of the printed report will appear. From here you can either print the report on paper, or you can save it as a file using the standard web features. Pressing the “New search” button resets the report and new parameters can be selected.

image006_15

6.5 SPIN contact – Sweden

Posted by Berit-Aya Jensen on 10th September 2015

6.5      SPIN contact – Sweden

 

Swedish Chemicals Agency

P.O. Box 2
SE – 172 13 Sundbyberg
Sweden

Phone: +46 8 519 411 00

Fax: +46 8 735 76 98

E-mail: kemi@kemi.se

6.3 SPIN contact – Finland

Posted by Berit-Aya Jensen on 10th September 2015

6.3      SPIN contact – Finland

 

National Product Control Agency for Welfare and Health
Product Register Unit
P.O. Box 686 (Uimalankatu 1)
33101 Tampere

Phone: +358 3 260 8200

Fax: +358 3 260 8222

E-mail: tuote.rekisteri@sttv.fi