Changes

Jump to: navigation, search

Using Staging Area Generator

1,787 bytes removed, 21:23, 20 February 2020
no edit summary
* '''Gazetteer Seq No:''' this option allows to specify the flattening of the country structure into the main object tables, if gazetteer alternative names are used in {{IMSMANG}}. Alternative names in the country structure, if defined, have a sequence number. For example, if for each country structure element two alternative names are defined, the first one has sequence number 0 , the second one sequence number 1. If the standard gazetteer names should be used in the staging area, choose '''None'''. Otherwise, choose the appropriate sequence number.
* '''Do Geodata:''' this is a switch to enable/disable the generation of geodata. The staging area can either be created with non-geodata only, or including all the coordinates (points, polylines and polygons), i.e. the data stored in the GEOPOINT, GEOSPATIALINFO and related tables in {{IMSMANG}}. Refer to the section on geodata below for more details.
* '''Target SRID:''' when generating geodata in the staging area, the data can be re-projected. The Target SRID allows to define the projection. The default, 4326, corresponds to '''WGS 84''' and 3857 corresponds to '''WGS84 Web Mercator'''. For a complete list of available projections, issue the following query on an empty staging area (i.e. the one created after clicking on '''Validate Selections'''):<pre>select *from spatial_ref_sys</pre>
You may also consult http://spatialreference.org/ to find the SRID that you would like to use. PostgreSQL is using the EPSG standard.
{{Warning|Conversions/re-projections cannot be done between all coordinate You find more information about Staging Area Generator and spatial reference systems/SRIDs. In fact, some coordinate systems are defined for and focus on a specific part of the world, and coordinates outside of this specific range cannot be represented. If this is the case, an error message such as the following will be displayed in the staging area generator progress window:'''[[File:SAG_geo_error.pngSAG Spatial reference system | here]][[File:SAG_geo_error2'''.png]]If you encounter this error, please verify whether the chosen SRID for re-projection and the coordinates in the source IMSMA are compatible. It could also be something wrong with references between tables in the {{IMSMANG}} database. You will find more information in the log file.}}|-
|}
[[Image:Staging_Area_Generator_GUI_options.png|center]]
A log with all the steps is written in this window as the generation process goes on. This might take some time, depending on the size of the source IMSMA database. The range is from very few minutes up to two hours for very big databases. Once the generation is finished, the newly generated staging area database can be explored with a database query tool such as ''pgAdmin3'' or ''Navicat'', and reporting tools can be connected to it.
==Changing the log level of the Staging Area Generator==__NOEDITSECTION__{{Note|This is only required in case of doubt/error, when more details are needed in order to investigate what goes wrong.}}In order to change the log level of the SAG, for example to write a more detailed output to the log file (etl.log in ''C:\IMSMAETLTool'[[Name_Rules_Staging_Area | page]]'), the following steps are required:# Open a command line window and go to ''C:\IMSMAETLTool\bin''# Extract the configuration file by typing the following in the command line: <pre> C:\IMSMAETLTool\jdk1.6.0_45\bin\jar xf etl-1.0-jar-with-dependencies.jar mylog4j.properties </pre># Open the resulting file mylog4jcontains information about rules for CDF names and known issues.properties (in ''C:\IMSMAETLTool\bin'') in an editor (e.g. Notepad++)# Change the line <pre> log4j.category.com.fgm=INFO </pre> to <pre> log4j.category.com.fgm=DEBUG </pre># Bundle the log file in the jar again by typing the following in the command line: <pre> C:\IMSMAETLTool\jdk1.6.0_45\bin\jar uf etl-1.0-jar-with-dependencies.jar mylog4j.properties </pre>More output is now written to the '''etl.log''' file.{{NoteContact your [[Information Management Team |This is only required in case of doubt/error, when more details are needed in order to investigate what goes wrongGICHD IM advisor]] if you need help.}}
{{NavBox Business Intelligence}}
[[Category:VIENAA]]
Alnaucler
NoPublic, bureaucrat, administrator
6,632
edits
Retrieved from "http://mwiki.gichd.org:8090/IM/Special:MobileDiff/22665...24411"

Navigation menu