The latest build of the STDM installer includes the latest versions of the dependent software components i.e. PostgreSQL 9.4, PostGIS 2.1.7 and QGIS 2.8.2. In addition, the installer is now available in 32 and 64 bit versions depending on the architecture of the target PC.
There is also the option of installing sample data, which can subsequently be used to guide users through the software using examples contained in the user guide. The sample data includes SQL scripts for inserting sample data into the STDM database as well as shapefiles, CSV files and satellite image which are copied into the local user directory.
For users with an already existing installation of QGIS, they can now download the STDM plugin by connecting QGIS’ plugin manager to the GLTN Plugin repository available through this link: http://stdm.gltn.net/plugin/plugins.xml.
Spatial units can now be accessed through a dockable ‘Spatial Unit Manager’ window. The window provides an option for listing all spatial units in the STDM database and adding them to the map canvas for visualization. The user can also set a display-friendly name for the layer which is applied in the legend each time the layer is loaded.
Geometry data for spatial units collected from the field and downloaded from GPS devices in GPX format can now be easily imported into the STDM database by loading a GPX file into the map canvas then selecting and editing the location of the individual points that constitute the geometry. Geometry construction from the collection of points is based on the type of the active spatial unit layer in the current edit session.
Note: Each GPX file must correspond to a single spatial unit for this to work.
The document designer has been updated to include support for linked attribute tables (for example, showing the members of a selected household entity); linked spatial units (which enables point and line spatial units to be drawn in the output document); charts and supporting documents (of image format).
Note: Only vertical bar graphs are supported for now; more chart types will be added in the next release major release.
Entities can now be selected by using filter expressions through an expression dialog that enables users to specify SQL-like statements to filter items.
The data forms design module has been greatly enhanced that screenshots only will not do it justice.
Users can now import data to a foreign key column in the destination table using the ‘Value Translation’ framework; one implementation of this framework is the related table translator.
In order to implement this translator, the source table must contain at least one column that refers to a unique value in a related table such as household code/number that a person belongs to. During the translation process, the system will attempt to look up this value and extract a corresponding value (ideally, the value of the foreign key column) and use this value in the primary reference table.
The ‘Value Translation’ framework opens up infinite possibilities of transforming data during the importation process such as calculations of age from date of birth; importing multiple enumeration values separated in the source table say by an asterisk or semicolon etc. Look out for sample code snippets on how to adopt the translation framework in the upcoming blog in the STDM website.
In addition a wide range of improvements have been made: