STRM/STRC: Forskjell mellom sideversjoner
(Ny side: =STRC: A coded version of STR= ==Standardisation in progress== University of Groningen and the TRESOAR archive have standardised ports of departure, destination and shipmasters home po...) |
|||
| Linje 9: | Linje 9: | ||
===Loading main DATA=== | ===Loading main DATA=== | ||
====Passages==== | ====Passages==== | ||
If passages is downloaded from STRO using the query interface a CSV-file called passages_Year_=_YYYY.csv (e.g. YYYY=1754) will be crated. The file consist of the selected passsages, first line includes field names, each field is seperated with comma and values are qouted using dobble-qoute ". Exported data is encoded in "Latin1". By mailing the STRO-group it is also possible to get larger chucks of data, however it is encoded in UTF-8, lacks field names and each field are seperated by semi-colon. Therefore two import routines have been made, one for each of the supplied data format. | |||
====Taxes==== | ====Taxes==== | ||
====Cargoes==== | ====Cargoes==== | ||
Sideversjonen fra 2. des. 2015 kl. 08:52
STRC: A coded version of STR
Standardisation in progress
University of Groningen and the TRESOAR archive have standardised ports of departure, destination and shipmasters home port. By end of 2015 about 50.000 spelling variations of port names have been coded into a 6 letter alfanumeric code.
Standardisation using SQL
Loading main DATA
Passages
If passages is downloaded from STRO using the query interface a CSV-file called passages_Year_=_YYYY.csv (e.g. YYYY=1754) will be crated. The file consist of the selected passsages, first line includes field names, each field is seperated with comma and values are qouted using dobble-qoute ". Exported data is encoded in "Latin1". By mailing the STRO-group it is also possible to get larger chucks of data, however it is encoded in UTF-8, lacks field names and each field are seperated by semi-colon. Therefore two import routines have been made, one for each of the supplied data format.
Taxes
Cargoes
Loading aux DATA
In order to manage
Standardised place names
Port of departure
Port of destination
Classification systems by Nina Bang
- Nina E. Bangs classification of commodities converted into a database table.
- Nina E. Bangs coding of ports (departure, port of intended destination, shipmaster home port)
- Converted into a database table. Download as XLS. Download as DBF.
- Download the list of ports as geocoded GIS file (ArcGIS). Download as DBF
