Home

STDM User Manual - Social Tenure Domain Model

1. x BAOBAB 28 151847 15 217926 i e 28 144725 15 220266 X ni 28 139096 15 222029 Xo n2 28 104683 15 212273 KO NB 28094375 15 211497 X ma 28 08305 15 207806 X ONS 28 155648 15 218004 x ns 28 154137 15 216338 Xo ONT 28 153536 15 213819 Added Composer Items in the Document Designer e 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 A E EDADA FM m nT cc W6 6 nr APS es el Of I 100 Sim 6 al 150 200 250 Items Command history lt empty gt Picture added STOM Data Source Data Source Please select the name of the source table or view from the options below sodial_tenure_relations Show views only Show tables only Composition Item properties STOM item properties STOM tem properties Chart Type alll Vertical Bar Y Data Source References sodal_tenure_relationship Data source field party_surname Referencing part
2. Ez Document Designer P Document Generator Report Builder Logout 6 Change Password gt Login Help Contents About If the browser form appears without the column labels know that changes were not made You need to Exit QGIS window completely and start it again Party Records Manager E S A complete dialog should appear like this Party Records Manager 0 rows STDM is now configured for use Proceed to other modules or functions 35 143 User Manual 3 1 Creating new data profile 1 Login to STDM 2 Start Design Forms wizard Directory paths Settings path C Users Njogus stdm Change Source document path Change Document output path C Users Njogus stdm Reports Change Templates path C Users Njogus stdm Reports Templates Change 3 Click next to proceed Creating new profile Profile A profile in STDM tool refers to a series of questions to be used in a particular survey in which order of questions and responses is organized in a modular format for easier analysis and presentation within STDM The modules can be understand as tables in the database i e person details that includes surname given names age date of birth would be structured in a module within the survey form and in STDM therefore we would have a person table to record that specific information See attached sample of questionnaire in
3. Ea f check_document_type 2 check_sodal_tenure_type f check _gender Te check_marital_status Here we have for sections 1 The List of table in the default profile Top left panel 1 2 The column editor panel Top right panel 2 3 Data categories table Lookup tables Bottom left 3 4 Look up table choices Bottom right 4 By clicking on any of the modules in 1 above the available columns for the selected module will be loaded at 2 At this level if you right click on the top left panel 1 you have the option of adding editing and deleting tables and lookup options from the pop up menu Add Table Rename Table Delete Table Adding table field columns Steps 1 Select the table you want to add columns 2 Pre defined columns will appear on the column editor panel 2 Click the button to popup the add column sion AI 30 143 STDM User Manual Data Forms customization Add or Edit Fields Columns For Each Module Tables Table relation and constraint i Basic data types columns e T H y as ata types Geometry columns J mse f Desso settee usr JE tom so0dal_tenure_relationship 3 29 character varying other_names other given names Add Table Column 3 Table Column Name surname Description Family given name for the person ee E check document ty Column Data Type Shorttext Actions E3 f check_sodal_tenure
4. MAP ENUM C ewer 7 rrwyeerrwreenr Structure House Envronment Household Persons J This will ensure that any formatting you do on the current sheet will apply to all other sheet in the workbook e Goto the home tab of the excel document in the Cells group click Format Under Cell Size click Column Width In the Column width box type the value that you want You will find that the column for all the sheet have now been adjusted to the new width If you are okay with the new width un select the sheets from the shortcut menu nsert Delete Rename Mowe or Copy View Code Tab Color Fide Vnihide Select All Sheets ingroup Sheets Gee Ucture House Environment Househom Persons 2 For more information go to http www spreadsheets about com od excelformatting How to Use Excel Formatting Fe atures Format Excel Spreadsheets htm height HP001216383 aspx Formatting cell values Cleaning the data I e Capitalizing persons names The example uses random cells numbers To extract and capitalize the first name from the name collection use the following function IFERROR PROPER LEFT A2 FIND TRIM A2 1 To extract and capitalize the last name from the name collection use the following function IFERROR PROPER RIGHT A2 LEN TRIM A2 FIND TRIM A2 STDM User Manual To extract and capitalize sex information if defined as MALE FEMALE M or F in the Sex co
5. Solomon Family name bg Filter 3 Click on the desired record from the search result i Search 4 Click search to view the social tenure relationship created 4 The search results will appear on a panel below with all the information of the party and spatial unit Search Results Right cick an item for options Njogu 100 S Social Tenure Relationship Sodal tenure type Individual owner Share None 3 Spatial Unit Code 100 Name House 2 Type None Sp unit use None The STR view wizard also has an option to search the relationship by property information Search for social tenure relationship using spatial unit 1 Select spatial unit tab 2 On the search textbox enter the spatial unit code 3 Click Search button to pull all the relationship information from the database Search By Party Spatial unit bg Filter C Search Clear Results A tree view layout of the search result appears showing the social tenure relationship based on the Spatial unit selected Expand the tree view nodes to See all the details 71 148 STDM User Manual Search Results p Address Identifica Contact t Gender 2 Marital st in Share None B E Party 5 To search a different social tenure information click on the clear results button H Clear Results This will clear all the available information on the viewer panel and fields for a new search To view the se
6. Spatial Unit Manager D x Manage Layers Layer spatial _unit geom_point Add Layer to Canvas Set Display Name import Features import GPA File STDM Spatial Unit Manager Window is a dock able window that is only available when logged in to STDM Full view providing quick access to STDM layers in the database It also allows you to import data from GPS into STDM database directly The window quickly disappears when you logout STDM User Manual 2 Getting Started 2 1 Login to STDM Note Make sure QGIS is started and running while STDM is visible in QGIS interface tool bar To start QGIS Look for this Icon and double click to run or if you are using the custom build Downloaded from stdm website click on Gaais Desktop icon to start 1 Click the login button login information This will prompt a login dialog where user is required to provide the A login dialog will pop up You are required to provide login credential using the default user postgres created during installation of the software For the 1 user name default postgres Administrator can change the user name later 2 Password Provide your own password that was created during installation procedure W STDM Login UserName postgres 23 143 STDM User Manual 2 Then click on Login or hit Enter button on the keyboard The cancel button in the wizard will cancel the login procedure i STDM Login The
7. oe oe ee bee nistan tT Ee ae fee power oe ef jeer ppoe onmo eee aa fa e pe pem mee paee e e Masra WINNIE RS Ba 5 Party Entity Editor Form appears allowing you to fill the new record i Pi Party Records Manager 14 rows z xa Look For Type the filter keyword he 6 Enter the new Party Record 62 143 STDM User Manual Ses O CHARLES 474 0723758437 Female 7 Click OK A pop up appears showing that the record has been successfully saved 0 New record has been successfully saved 8 Click OK to finish the task Editing Updating a Party Record 1 On the Party browser form select the party record entity you wish to edit update 7 f 2 Select the edit button A party entity editor pops up allowing you to do the edits 63 143 STDM User Manual W Party Records Manager 15 rows Other Names Address 676767567 Identification 34534534 Contact Telephone 523113 Age 28 Gender Look For Type the filter keyword 3 Edit Update the existing record 4 Click OK A notification will appear showing that the record has been successfully updated 5 Click OK 6 Click Close button on the bottom right of the browser to finish the task NATAHSA SALIMU 456456455 45656456 41245 18 Female Look For Type the filter keyword here Deleting a Party Record 64 143 STDM User Manual When
8. In cell dropdown Apply these changes to all other cells with the same settings ere e Inthe Allow drop down box select List e Specify the Source of the list by o If the list is in the current worksheet enter a reference range to your list in the Source box If the list is in another worksheet enter the name that you defined for the list in the Source box e In both cases make sure that the reference or name is preceded by an equal sign e To specify whether the cell can be left blank select or clear the Ignore blank check box Removing drop down list e Select the cell within the list e Click the Data menu and then click Data Validation e Inthe Data validation dialog box that pops up e Click the Setting tab and then click Clear All button at the bottom of the dialog For more help visit http www office microsoft com en us excel help create or remove a drop down list HP005202215 aspx Adjusting sheet columns and rows to uniform width This can be done either in Microsoft excel or Open Office spreadsheet This guide will use the Microsoft excel e Open the excel workbook if it s not opened e Select all cells in one sheet You can use the shortcut CTRL A 138 143 STDM User Manual e Right click on the current sheet tab in the workbook and on the shortcut panel click Select All Sheets Insert Delete Rename Mowe of Copy View Code Protect Sheet Tab Color Hide Uinhide
9. ASS ssid 49 143 S TDM User Manual Creating table relations child to parent table constrains Table relation and constraint party spatial_unit socdial_tenure_relationship By default on the social tenure relationship table has relationship defined to core tables Tables Table relation and constraint To create a new relation click on the SF at the bottom A new dialog pops up where the relations parameters are defined Add relation from parent table Relation name parent to child relation name Local Column HH spatial_unit Reference table spatial_unit iai Referenced column id On Delete action CASCADE ha On Update action CASCADE T Column information to dispay when browsing for foreign key Display Column HH code Comments Relation name cannot be empty and can be given as any text e g person household number Local column refers to column in child table to reference the parent e g household number Reference table refers to parent table e g household 50 143 STDM User Manual Referenced column refers to unique or primary key column reference in the parent table e g id or household number Click Ok to save new relation A relation can be deleted by selecting the particular relation on the list and clicking the delete button at the bottom 3 1 4 Creating Geometry columns Geometry columns are defined in a similar way to normal columns apart fr
10. Video Files Rent certificate Lease rs 12 Browse to where the supporting document file is through the Add Supporting Document button to attach the file document New Social Tenure Relationship source Documents Upload one or more documents Supporting Documents At the bottom of the dialog box shows the upload of the selected supporting document as shown below 13 Click Next to continue 68 143 STDM User Manual Source Documents Upload one or more documents Supporting Documents Document Type 14 Click OK to continue A social tenure relationship summary will appear with all the information provided This will be the last wizard and by clicking the finish button the user will create the relationship e g i r Ei i ia a Eg mia E ae Anew social tenure relationship will be created based on the information that you have supplied as summarized below If you want to review or change any selections cick Back If you are satisified with the selections dick Finish Party Information j Spatial Unit Information E Socal Tenure Relationship Information H Source Documents 15 Click Finish button A notification pops up showing that the relationship has been successfully created 16 Click OK Now you have created a social tenure relationship 69 143 STDM User Manual g New Social Tenure Relationship STR Definition Summary A new s
11. administrator Are you sure you want to delete administrator Once deleted this role cannot be recovered A warning dialog appears and on this action and the user is required to confirm the delete action 3 Click yes if you wish to proceed with the action 126 143 STDM User Manual 8 3 User Mappings It is at this point that the user authorizes who has access to the content Various roles created are assigned to various users for management and execution a Users ee Roles Mappings Click on a role in the table on the left hand side below then check uncheck the users in the table on the right hand side to add remove them in this role 1 Click on the mappings button at the top of the management dialog for grouping The roles will appear on the left side of the dialog and the users will appear on the right 2 Select a role to assign users by clicking on it next check or uncheck the box against a user to assign that role to that user Do this for all the roles so that no roles are left unassigned 8 4 Content Authorization This is the point where various roles are assigned their content Each role is given certain content to be executed by the user assigned to that role 1 To achieve content authorization click on the admin settings button on the QGIS tool bar 2 Select content authorization o ma EN EE Content Authorization iA Manage Users Roles The dialog below will appear and it i
12. 15 207806 7 occ x 26 154137 15 216338 am F IG Ww ACM IAM 10 3Ww WH The table enables you to change which point you would like to import This is achieved by clicking on the checkbox shown on the first column of the table to ensure it s checked Let s take for instance you want to import a polygon feature captured in the gps to my polygon geometry layer in stdm Note when a row checkbox is selected or deselected respectively vertex marker on QGIS canvas is show using color green or red respectively This is displayed below You will select the four joining vertex that indicates the edges of your polygon feature as shown above The selected waypoints vertex will be highlighted on the map Once confirmed that those are the points of interest to complete the polygon Click Save to draw the polygon feature Attribute editor dialog will load to add the feature properties 100 143 STDM User Manual code Ni name polygon 1 sp _unit_use House Residential The polygon will be drawn for you on the map canvas The feature is also saved to STDM database Click on toggle editing icon to stop editing mode when done If the feature is a line A line will be drawn when the user selects the corresponding vertexes comprising the line feature Similarly for a point feature only one vertex is selectable to import the point feature to stdm toolbar 101 143 STDM User Manual 7 Generating report
13. S TDM USER MANUAL July 2015 Copyright lt 2015 gt by lt GLTN and Implementing partners gt All Rights Reserved Preface This document is the original user guide of the Social Tenure Domain Model STDM software The software components described in this document are registered trademarks of their respective providers and are therefore subject to legal requirements STDM is subject to the GNU General Public License For more information regarding STDM please visit the website at www stdm gltn net The details data and results in this document have been written and verified to the best of the knowledge and responsibility of the authors and editors Nevertheless mistakes concerning the content are possible Therefore data are not liable to any duties or guarantees The authors editors and publishers do not take any responsibility or liability for failures and their consequences You are always welcome to report possible mistakes License of this document Permission is granted to copy distribute and or modify this document under the terms of the GNU Free Documentation License Version 1 3 or any later version published by the Free Software Foundation with no Invariant Sections no Front Cover Texts and no Back Cover Texts A copy of the license is included in Appendix GNU Free Documentation License Contents ig Ba el eee en ee eee ne en ee re eee ee ee ee er er ee er 2 ke VT O CO accent crete neat pe nee ER A E ep ncaa tsa
14. between pe sons and properties which as represented as polygons on the map It also indudes conflict information associated with a given property This module provides a mechanism for defining STR applicable to property both land and building Click on the Next button below to proceed 4 Click Net gt the wizard to proceed 5 Search for the party person by typing in highlighted field The search text will be matched with data in the column selected in the drop down combo as shown Family Name X New Social Tenure Relationship Occupant Information Select the occupant information by searehing through the existing repository Search Criteria p in column Family Name 7 The search criteria may be by first name last name or ID number depending on currently selected field If the name entered is shared by multiple occupants you can use other criteria to identify which occupant is targeted 6 Select one row from the result of search and click inside the display panel below to load the person data 66 143 STDM User Manual vi New Social Tenure Relationship Occupant Information Select the occupant information by searching through the existing repository Search Criteria Family Name WABALE Other Names CLEIR Address 767876756 Identification 34535354 Contact Telephone 5313135 7 The person s information selected appears Click Next to continue A dialog displays
15. content_base 5 Perform source column to destination column matchning for the required field 6 Click Finish to import the data 79 143 STDM User Manual ign Columns Source Table __ Destination Table il Bi P ic gt lc A total_members x Total_members P p 2 E mian name HH field_s Match source and destination table columns 80 143 STDM User Manual 5 2 Importing Spatial Data Spatial Units can be imported into the STDM database from a shape file AutoCAD or comma separated values 1 To import clicking the button on the QGIS window interface A dialog box appears allowing you browse to the source folder of the data to be imported 2 Check the Spatial data circle to enable activate it 3 Browse to the folder where the shape files spatial data is stored Source Data Specify the location of the source file and representative data type Next gt 4 Go to the Sample data folder Map Data and select shape files and open the shape files i Select Source File Organize New folder Name Date modified ca Libraries E S g oe J Referenced Image 6 28 2015 3 12 AM E Documents Jim j _ shapefile 6 28 2015 3 12 AM usIC Pictures E Videos e Lia If nothing is displaying on the opened folder make sure that the file format is in ESRI Shapefile shp as shown below 81 143 STDM User Manual T d t sample data Digitized vect
16. 4 Select Geometry from the data type list STDM User Manual Table Attributes Add Table Column Table spatial_unit Column Name structures Description capture geometry of structures Column Data Type Geometry Character Length Auto Increment Primary Key Is Mandatory Field Select Geometry Type Polygon Field is a List Choice list Select Coordinate System Default Value EPSG 4326 On the pop up window select geometry type e Polygon if expected closed structures and will be marked by three or more points e Aline if itis a continuous stream of points that do not close e Pointif only one point is expected Click J button to select the desired Coordinate System from the coordinate selector By default WGS 84 is used 48 143 STDM User Manual Search by typing here Filter 4326 Recently used coordinate reference systems Coordinate Reference System Wis 34 EPS 4326 proj longlat datum GS84 no_defs Once selected only the EPSG code of the selected Coordinate System will appear Click OK Then Click Ok Table Attributes g Geometry column will not appear in the list of column but it is loaded in the 1 y background The above message will appear to alert you that the geometry columns are not part of the textual column Basic data types columns Geometry columns e eset Cohen emmcT _Preree_ _ ses il i s aee Io 2 geom_ point p spatial_unit structures POLYGON 326 m
17. 97 Fa GOWMCTAUNE reDON S readen a E O A 102 Taly STDM Document Desie NE uuris a a ae 102 Tele Generating map GOCUMICN Csitaevesatniasdtacccesdipeeansdsaeetedetatorasdsakeenadanviaa sdsaeetadatn tones Ginteansdteteaniddatstcretues 111 123 Generating Docunients and Reports reisis tiou ier eden S ETE 115 Customizing report ceciota tik ct acta nace a S Seamed nareatcenaca E 117 Oz Managing Userandi ROI CS jcc ce sect occtia ches lt emnsinnsast E E a Ta 122 8 1 User I aa NG a ie ca rend center ace E keene van edciag 122 8 2 Role Manageme Meeres a a cota a ae N O F a Te a laSa 125 8 3 User MapPpino Seinna a a a Ne Wiad aroha heen Macrae 127 8 4 Content Authorizations oa ged aa a eana aa a e aaia 127 9 Works WIth sample Data ispisna a a a a a 129 To use the sample data make sure QGIS is started and running while STDM is visible in QGIS interface tool ING EPEE EAE A E E E E E E A A A A E O AE S EAE T 129 9 1 Managing party MOGUIC rarene eee eee Gave area ea ee ae ae eas 129 9 2 Managing Spatial Unit Module vectsiiesccte crc cccbssussdoddiencths ea e A i OE 129 10 INITIO ROS Shere eeeurcnet evened eccueed EEA Wenn lus cuaeuuuuen eave oral usenet vonuaueen aun 130 10 1 Annex 1 Working with Spatial data in QGIS cece cece e eee eee eee renee eee eee ees eed ee sense eeseeesaeesaeenes 130 TOKI WVORKANG WGP eisene a E late ai R omega 130 TO Tt 2 Beforeusine GPSierrie nuin a N Ee a E e R 130 What to know when using GPS in the
18. AS CER 2 PEEL 0 0 100 150 200 a Se aay TERE Composer kdt vew Layout Atas settings B h k R D Re RAAS WHPAPR Or Pm E a N AN S 0 New map drawn 50 rep ai pase Next you can draw the map area on the designer field and can resize it accordingly You can opt to change the map back ground on the designer field 2 To change the map background click on the composition tool bar on the right side of the designer then select the page background option 103 143 STDM User Manual STOM data properties Presets A4 210x297 mm aa Width 297 00 Height 210 00 z Units mm M Number of pages 1 q Export resolution 300 dpi Print as raster ENIES m 1 EF T Command hasory x Item properties STDM data properties Compete x Ad 210057 men uar 257 00 Sarnple fill green 210 00 si onl m 1 Landscape sa 3 Click on the change button then select a suitable background from the options available 4 Click OK to apply the page background Adding a map title Add a template title on the map created 1 To do this click on the new label button This will set up a new QGIS data field where the user can label the template 2 To type down the title click on the item properties button on the designer task pane From here user can also change the font properties of the title text Once all the changes are made 104 143 STDM User Manual JEM WEI LeU Changed grid
19. By default STDM has a default look up table with predefined list You can select a list from the lookup table or define additional lookups if not include Default value This is the place holder text that will be given if the user does not specify any data for the column Geometry Columns Geometry columns are defined in a similar way to normal columns apart from the fact that you are supposed to select geometry for data type Geometry columns are not displayed together with the textual columns but in a separate tab as shown Data Forms customization Add or Edit Fields Columns For Each Module Tables Table relation and constraint Basic data types columns Geometry columns Table Name ometry Column Nar Geometry Type Projection Actions 1 spatial _unit geom _line LINESTRING 43526 2 spatial_unit geom_point POINT 4326 3 spatial_unit geom_polygon POLYGON 4326 i a oOo Geometry columns can only be added in spatial unit table of the basic profile Additional tables can be created to accepted geometry data 1 To add anew column geometry column follow the steps provided here Creating table relations child to parent table constrains Table relation and constraint party spatial_unit so0dal_tenure_relationship By default only the social tenure relationship table has relationship defined to core tables Tables Table relation and constraint Table Entity party To create a new relation g
20. Character Length j E check_gender fP i EE check_marital_status Auto Increment Primary Key Is Mandatory Field Field is a List Choice list Yes E g Gender Male Female Source Default Value Default value will be provided if user does not spe Is Searchable Field Wes ancel Help cae e Enter column name Le last name e Enter Description I e party s last name e Select data type Type of data expected for the new column e if text short text is required e if attribute data is to be given as integer or numeric you need to select whole number e See supported data types Date Long text Auto Increment Yes No Geometry Whole Number e Enter the maximum character length expected for words or names to be given By default its given as 50 Note this option is disabled for all the other data types 7 Click OK to save and dismiss the dialog To add a new column click the button again remember to check the table for which new columns are defined Mandatory fields while adding a column Column name column data type length the rest are optional Auto Increment is option and this is not a requirement as STDM creates by default when a new table is created 31 143 Is mandatory field depends on whether this field should not be none Set to Yes if it cannot be empty or None Field is a list is option For instance if the user is expected to select the choices from the pre defined list saved in a given table
21. Display Column family_name Ce ee CC Comments e Depending on the profile users have the option of explicitly specifying which entities will participate in the social tenure relationship i e which tables correspond to party and spatial unit respectively 7 Party table columns partidpating in STR definition id x family_name party x other_names address x identification i Party can be a person household or group contact_telephone Select table representing party in the Social Tenure Relationship definition Y Spatial unit table columns participating in STR defi id x code spatial_unit h x 2 name E type x sp_unit_use Select table representing spatial unit in the Social Tenure Relationship definition spatial unit or a group of spatial unit 1 2 5 Importing Data to Foreign Key Columns 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 10 143 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 k Import to STOM Assign Co
22. Login and configure data forms wizard to finish 1 5 3 Upgrade your configuration file The current version has rich and improved features that have also been changed in the configuration file Itis recommended to remove previous config file in your workspace so that the improved configuration can be copied This only applies if you are running stdm version 1 0 Error Duplicate keys for the modules exits This error is mostly attribute to mismatch of config file and especially where new module were created to replace the existing ones To remove this error you either restore the original config files or simply ask administrator to run pgadmin and open stdm database then truncate all the values in the content base and content roles tables The problem should be fixed 1 6 Using Bundled STDM installer STDM User Manual The bundled installer is the custom installer that is built to help you easily install stdm and dependent software packages Note 32bit machine please select and run STDM 1 1 Final x86 exe setup file 64bit machines run STDM 1 1 Final x86_64 exe setup file Installation steps Step 1 e Run the installer by double clicking on setup file and select Next G Social Tenure Domain Model Setup Welcome to Social Tenure Domain Model Setup Setup will guide you through the installation of Social Tenure Domain Model Social Tenure It is recommended that you close all other applications before sta
23. Manual 1 7 Installing From GLTN Plugin Repository For users with an already existing installation of QGIS version 2 6 or higher and do not want to uninstall current version we recommend that you download STDM plugin from the repository using the following steps e Start QGIS normally and wait for it to load e Goto menu Plugins gt Manage and Install Plugins con manag and Install Fi gins LigitizingTools FieldPyculator CRASE el e Wait for the plugin to fetch available plugins from the web repository only if online On the Plugins dialog select Settings tab ra F b Installed Not installed Upgradeable E EN ame Y Available repositories will be shown under Plugin repositories Plugin repositories sas e e E connected QGIS Official Plugin Repository http plugins qgis org plugins plugins xml qgis 2 8 e Select Add to open repository details dialog The dialog allows you to enter additional repository properties To add STDM plugin repository please enter the details as follows 1 Inthe Name field enter GLTN Plugin Repository 2 Inthe URL field enter http stdm gltn net plugin plugins xml 3 Ensure Enabled option is checked then select OK to close Name GLTN Plugin Repository e Click Ok to dismiss the dialog e The dialog will try accessing the added repository if online and pull the linked plugins If successful the repository will be added to
24. Next place a map legend on the template To add the space placement for the legend oO a n g3 1 Click on the add new legend button on the template tool bar The legend can be preferably placed on the bottom left corner of the template but the template arrangement is as the user wishes The system mainly picks the template legend from the STDM database Adding Photo User can also place an image on the template To do this 1 Add a space placement on the template where the image will appear O 2 Click on the add image button then put the placement on an ideal place on the template 3 From the STDM item properties task pane select a path from which the system will select the image to put on the image placement saepe TCS Data Source Please select the name of the source table or view from the options below Composition Item properties STDM item properties STOM item properties x Photo References Data source field Referencing 4 Once image is identified click open for the photo to appear on the template being worked on 5 Name the any image placed on the template by clicking on the data label button 6 Next put the space placement for the data label below the image created User can place multiple STDM data labels if the image has more than one name For example a first name and a last name 6 Click on the STDM data properties button SDM data properties This will source the name from a da
25. STDM User Manual This allows you to browse to where the map is Open raster Sol a p Map data Referenced Image v Search Referenced Image p Organize New folder d C Ministry d CAMERA d cars i Design a Flash J Fon videos Area_of_Interest_ modified_WS d HENRY ad Henry Photoz d images J NET PICS d Photos_TUK i pics d Sample data a Softwares File name 4 Select the File name you wish to georeference Many Image formats are supported 5 Click Open to load the map Raster Data is loaded on the QGIS interface 134 143 STDM User Manual f Are ote 3 A nn t 5 Ne fe Edit ew Shia gt Bisse PEs OD PLD AR f kA F Sne 6 To set properties of geo referencing gt Click the icon transformation settings A dialog box pops up so that you can set the coordinate reference system C Create world file Output raster Target SRS EPSG 4326 Generate pdf map Generate pdf report Set Target Resolution 1 00000 1 00000 Use 0 for transparency when needed Load in QGIS when done lt a Identify at least two points with well known points on the map that you will use to geo reference with 135 143 STDM User Manual Assign at least two ground control points GCPs to enable the geo referencing Note Set the Transformation type re sampling method as nearest neighborhood so as not to change the color code of pixel I
26. a name for the current template being saved Once complete Click Generate Report button to save the report based on your customization to the preferred location 120 143 STDM User Manual t ji sample data gt v Search sample data Organise New folder goo w wT Favourites Name Date modified B Desktop di Digitized vector 08 07 2015 16 06 File folder ig Downloads J Imagery 08 07 2015 15 52 File folder 3 Dropbox S Recent places Libraries Documents a Music Pictures E Videos File name Save as type Report Document pdf a gt Hide Folders Ifall goes well the following notification message will show The report has been successfully created and written to C Users Njogus Desktop sample data report 1 pdf Click open to view the report 121 143 STDM User Manual 8 Managing User and Roles 1 User Management To manage user roles and administrative settings 1 Click on the admin settings button shown in a red box 2 From the drop down contents 3 Click on the item named manage user roles EN FE Content Authorization i Manage Users Roles The dialog below appears and from here user can users and their roles and group them te Manage System Users and Roles A user is person authorized to manage and manipulate content set up on the configuration wizard The data management dialog will appear with the default user created however more users can set up
27. data is in excel sheets and in csv comma Delimited format 2 An import wizard appears Check the textual data circle 1 to activate enable you to import the attribute data 1 In the QGIS interface tool bar click the import data button to import new data 3 Browse to where you have stored the party data in excel z ARAA JOON aana AOA Wi Import to STDM n O mE source Data Specify the location of the source file and representative data type Source Destination Repository Type Spatial Data 4 Select the party data you wish to import 5 Click Open 58 143 Organize New folder Libraries Documents al Music Pictures E Videos wy Homegroup jE Computer amp Local Disk C cg DE MATEO D ca BEQNIZE E c MATATA F Po STDM User Manual Marne Map data photo fii Households_data records El person_partyrecords Date modified 6 26 2015 3 12 AM 6 28 2015 3 12 AM 6 26 2015 3 41 AM 5 4 2015 2 50 PM A browser appears showing the data imported 6 Click Next to continue Source Data Specify the location of the source file and represe 59 143 STDM User Manual A browse form appears 7 Check the Party box as shown below in 1 You only append when you want to preserve existing data Overwrite is used when there is an existing imported data in the database and you want to replace it with with the new data 8 Click Next to continue De
28. exit the pop up A dialog box appears showing the selected record in the list Note You can select more than one record for report generation 112 143 STDM User Manual Party Spatalunit 0 Fenty name other Names Adress Identfcaton fer be noe form fe 6 Select the Document template designed A template selector appears showing the designed template The user can choose from the wizard the tem EEO output to be as Image or as PDF ae VOCcUMeNT Generator Click on the plus button below to add a record from the database Party Spatial unit E E Select a document template from the list below Use matching records E Sample doc template 000 Sample residence doc Template E Select de Output Type Export as Image Export as PDF Write to output folde Output Document Naming Select the fields whose values will be used to name the output document files Address 7 Click Ok On the wizard Choose the kind of output you want either PDF or Image If it is an image a drop down list will show will provide options 113 143 STDM User Manual Output Type Export as Image Export as PDF Write to output folder Output Document Naming Select the fields whose values will be used to name Family Name Other Names Address 8 Check Activate the Write to output folder to select the values that will be used to name the output document files Te
29. or to do fastest House part owner business Tenant ower Sub tenant se to work Relative of owner Affordable rent Friend of owner Search for job or to do Li Drop down list makes data entry easier in Excel and restrict data recording to that in the list This eliminates typing error as well as saving on time A drop down list can be in column or row format Steps to follow when creating a list in Excel column e Define the entries for the list in the order you want it to appear e g Male Female e Type the list in the given cells without having a blank cell in between Male Female The list may be in the same or different worksheet e Fora list in a different worksheet type the list on that worksheet and define a name for it Cy 9 Home Insert Page Layout Cut Calibri Copy Paste ae J Format Painter Re fom Boalt Adding the list to a cell e On the working sheet select the cell you want e On the Data menu click Data Validation 137 148 STDM User Manual Book Microsoft Excel MULAS DATA REVIEW VIEW Clear vy E Flash Fill e Consolida Reapply t ff Remove Duplicates gt What lf Ar ext to T Advanced Columns Se Data Validation Relationsh Iter Cc Data Validation E Circle Invalid Da Data Validatic E Clear Validation F is i Pick from a lis turne nf data tF e Click the first tab Settings tab in the new dialog window Data Validation Validation criteria Allow
30. parameters when login has failed This feature is also important where the user is working with multiple database The user needs to pop up this dialog and change the database name and new database will be picked up Remember for new database Design Forms feature need to be configured Changing the connections parameters STDM User Manual W STDM Login Authentication Failed This step is necessary when the password or user name authentication has failed It also means either of the provided settings parameters are incorrect Also note that it only available when you are logging in as a super administrator 1 Click OK to dismiss the error message STDM Login UserName postgres Reset button is activated 2 Click Reset Settings button to load settings editor dialog O3 PostgreSQL Database Connection g Make required changes if provided setting are incorrect 3 Click Save button to save new parameters The login dialog will persist Enter the correct login credentials and click OK to proceed 142 143 STDM User Manual STDM Login ee UserName postgres Reset Settings 10 3 3 Logging out of STDM To log out of the QGIS wizard you must be logged in Click the logout button This immediately logs you out of the STDM system and the STDM command buttons disappears From here the log in button will be available for a later login 143 143
31. showing asking you to choose the property that you wish to relate with the person you had selected Choose the property by typing the structure code The selected property information displays as shown below Spatial unit information Select the land or building information Preview Spatial Unit G i Spatial Unit Information Code 100 n Name House 2 a Geom Line None cea Geom Pol yoon 01030000000 100000 8 Click Next to continue The next wizard is where the user selects a social tenure relationship of the identified occupant and the selected property The wizard has an STR Type field where there are several different relationship types From the drop down options select the required relationship type and click the next button For example Tenant Individual Owner Lease Occupant etc 9 In the drop down list select one option i e individual owner as a Social Tenure Relationship as shown below 67 143 STDM User Manual Select the type pf relationship that the specified person has with the selected property z Social Tenure Relationship STR Type STR Type Tenant Individual owner Part owner shared ownership Lease Occupant Others 10 Click Next to continue A supporting document wizard box appear 11 In the Document Type drop list select the type of the supporting document Supporting Documents Document Type v Audio Files g
32. you receive source code or can get it if you want it that you can change the software or use pieces of it 3 Accept the license agreement by clicking I Agree and then click Next 4 The next interface appears allowing the user to set up the configuration settings path the data path and reports path STDM User Manual For Windows users a default path is loaded For Linux and Mac this path may fail to appear Specify the desired location for for data storage By default the wizard will create a folder stdm in user profile directory where necessary configuration files will be stored 5 Click Next to continue Path Settings Set configuration and data directory path Directory paths Settings path C Users Njogus stdm Source document path Document output path C Users Njogus stdm Reports Change Templates path C Users Njogus stdm Reports Templates Note STDM comes with a default setup profile which has Party Spatial unit Supporting document Social Tenure Relation and social tenure supporting documents str_relations tables as shown below However a user can create new profiles and additional modules on the existing profile It is not advisable to remove the core modules provided in the configuration as this may affect other settings which may take time to configure for basic users Extending the modules and or editing of the field is allowed and better done through the config
33. IS canvas 6 1 Managing Spatial unit module Spatial units are categorized into three 1 Land as part of the settlement land parcels 2 Buildings Existing structures that were counted 3 Other object that may have been captured The default spatial unit layer has three geometry columns which enables you to load the same layer three times for different geometry Also the data will be stored in the same layer without any conflict You will access the Spatial Unit module through the Spatial Unit Manager at the bottom left side of the QGIS window interface This tool displays automatically after you Login Layers Browser vA Spatial Unit Manager EJE 9 Manage Layers Layer Me spatial unit geor Add Layer to Canvas E Set Display Name a Import Features Import GPX File STDM User Manual Manage Layers Layer ie spatial unit geor Add Layer to Canvas Set Display Name Import Features Import GPX File The spatial unit manager allows you to perform several tasks 1 The layer selection combo box allows you select geometry layer from the database For example a point feature line or polygon feature Spatial Unit Manager E x Manage Layers Layer _ spatial_unit geom_line X spatial_unit geom_line a spatial_unit geom_point amp spatial_unit geom_polygon amp spatial_unit geom_test amp social_tenure_relations geometry 2 The aa allows you to add the selected layer to the layer
34. M will try to apply the required updates This will happen if STDM detects that the configuration file installed from previous version is outdated Click Yes to update the configuration Note Any changes made to the configuration will be lost Click No to preserve your settings This however does not resolve the problem It gives you an opportunity to back up the config file and manually remove it so that the new one can be copied The following error message will appear if No is selected STOM has detected that the version of config installed is old and outdated Delete existing configuration folder or xml file and restart QGIS The following message may also appear for the first time to alert you to configure your settings soon after login This message only appear only when stdm detects your configuration file is missing STOM has detected that no configuration settings exist Please run Design Forms wizard and set the configuration path and other settings to get you started Click Ok to proceed The toolbar and STDM menu will be populated with STDM tool command icons Full View 25 143 STDM User Manual 6 A look at STDM Toolbar icons BERR OS eeeaeoo Designing Data Forms To proceed to other STDM features you MUST go to Designing data forms for first time use here and follow the steps for creating the default schema However if sample data was selected for installation this process can be skipped
35. Once you have configured the Design Forms wizard the other features can now be accessed without difficulty Note Design Form wizard is required only when you need to make changes to your database schema 2 2 Creating Data Forms To proceed with this step ensure QGIS is started and running You also need to have logged in to STDM To login follow the login instructions provided in the login section 26 143 STDM User Manual 3 Designing Data Forms for first time use If successful login the plugin menu will be populated with available STDM contents and likewise on the toolbar The Design Data Form configuration interface consists of e Title panel which reads the title of the main page e Main panel provides the functionality of various controls that user interacts with while setting up the main plug ins e Navigation panel provides controls for progressing or going back in the configuration steps Help buttons loads the help file document Setting up configuration file First time installation comes with empty database that needs to be populated with the default schema and tables As a first step STDM needs to configure a start up file before any other action is engaged in the plugin menu To do this configure the data entry forms and profile using the Design Forms wizard The configuration file can be edited manually but requires basic understanding of xml file structure The wizard allows you to edit the file without worr
36. Profile modules tables Number of families in the setiement_households settlement oe pieces of land within the ain spatal_unit settlement individual persons within the emi settlement services Services in the setement P _ Pary to spatial unit social tenure relationships _ o a supporting document for 6 supporting_documents __ social tenure relationships lll 2 Allows you to edit the created tables names and descriptions Delete button allows you to delete the selected table Adding a secondary or subsequent table provides the user with an option of importing columns from an already created table if the intended table is to contain columns that are similar to the existing table This avoids repetition when creating tables To do this check inherit columns from another table and select the source table in the combox box 3 1 3 Creating table attributes Table Attributes are the columns that will be created in the database to record information that will be entered in the form When creating table attributes the column text should be as short possible as this text shall appear on the data entry form 41 143 STDM User Manual To create tables attribute the Design Form wizard is used 1 Click on the Design Form Ab utton A path setting configuration table appears 2 Click Next to continue 3 Click Next on the profile and tables p
37. STDM database connection has not been configured in your system Would you like to configure it now Yes For the first time login the above dialog appears this is a prompt to setup the server connection parameters that STDM will use to interact with your database 3 Click yes to enable the settings dialog to load The server settings include 1 Port Port is the default access port for postgreSQL server i e 5432 or 5434 this was specified during the installation procedure 2 Database name stdm is default any other database the user has created postgis extension must be created added in the database 3 Host host is the server location if LAN setup provide IP address of the server else provide local host for local computer one computer I e localhost fi PostgreSQL Database Connection g localhost 4 Click Save button 5 Then click OK or hit Enter button on the keyboard If successful the dialog will disappear else the login dialog will persist with an error Reset Settings button will be visible to allow to you edit the server registry settings 6 Click Reset Settings if you need to edit the server settings saved in the registry Go to reset setting page to learn how to reset the server settings 24 143 STDM User Manual For successful Login The following messages may appear based on detected previous settings in your computer The contig version installed is old and outdated STD
38. TOM database Update existing STDM database Skip changes to database CUNSIKALNI PK SOUTER _fegion PRIMARY KEY yaJ CREATE TABLE spatial_units spatial_unit__id serial NOT NULL SELECT AddGeometryColumn spatial_unit geom_test 4326 POLYGON 2 SELECT AddGeometryColumn spatial_unit geom_line 4326 LINESTRING 2 bids FOREIGN KEY epatial_ unit REFERENCES spatial_unit id ON DELETE CASCADE ON ALTER TABLE social_tenure_relationship ADD CONSTRAINT partyid FOREIGN KEY party REFERENCES party id ON DELETE CASCADE ON UPDATE CASCADE ALTER TABLE household ADD CONSTRAINT household spatial_relation FOREIGN KEY structure_id REFERENCES spatial_units structure_id ON DELETE CASCADE ON UPDATE CASCADE CREATE OR REPLACE VIEW social_tenure_relations AS SELECT party id party family_name AS party_surname party other_names party identification spatial_unit spatial_unit_id AS spatial_unit_number spatial_unit name AS spatial_unit_name spatial_unit geom_polygon AS geometry socdial_tenure_relationship social_tenure_type FROM party spatial_unit social_tenure_relationship WHERE spatial_unit id sodal_tenure_relationship spatial_unit AND party id sodal_tenure_relationship party Create new STOM database Update existing STOM database Skip changes to database Show generated SOL file Note Create new STOM database 1 The allows you to create a database schema from the configuration you have made Previo
39. age 4 Click Next button to get you to Data forms customization You should be here Jata Forms customization Add or Edit Fields Columns For Each Module Tables Table relation and constraint Basic data types columns try columns settement households Se S LES hee Geometry columns party services id Primary key serial fals ap sodal_tenure_relationship a supporting_documents 2 Lookup choices check_document_type Es check_social_tenure_type check_gender E checlltens Creating table attributes When creating table attributes the user will deal with the first and the second section On the first section the user will choose the table to which columns will be added and in the second section the user will add and view new attributes of the table 1 Click a module you want to Add attributes For Example the settlement_household module A row appears on the second section where added attributes will be shown The id row is created by default when you create a table and should not be deleted Primary Key column Tables Table relation and constraint Basic data types columns Geometry columns settement_households spatial_unit party Services id Primary key serial Searchable Actions sodal_tenure_relationship supporting_documents 2 Click the Add button to add a new attribute 42 143 STDM User Manual Basic data
40. aging Spatial Unit Module Spatial units are areas of land or water where the rights and social tenure relationships apply The Spatial unit representation can cover community based administration system or rural or urban or other types of land administrations like marine areas Managing spatial units Refer to spatial unit module for details 10 Annexes 10 1 Annex 1 Working with Spatial data in QGIS 10 1 1 Working with GPS It is advisable to use GPS device in the open field to avoid obstruction from building and trees hinders visibility of satellites when collecting data Working with GPS in an obstructive environment reduces the accuracy of the final data Depending on the GPS device a GPS receiver must be locked to signals from at least 3 4 satellites to be able to calculate the position The higher the signal strength in terms of satellite signals the higher the accuracy reliability 10 1 2 Before using GPS What is a GPS It is a Global Positioning System GPS a satellite based navigation system constituting a constellation of 24 satellites and their ground stations The use of GPS circles around precise positioning of objects and people including scientific studies for the purpose of obtaining useful information relative to their geographic locations When using GPS the GPS device needs to communicate with the satellite at real time to give the positions This is why it is advisable to use GPS device in the open fiel
41. ame check_type content_base content_roles enumerator E 3 household Had other_names priority respondent E role sodal_tenure_relationship E3 spatial_unit survey 7 Select from the left Source table table data to be exported 8 Check by marking the textual columns you wish to be exported on the right 8 Click Next to proceed 9 Likewise when exporting spatial data Select it in the data source table and select the required fields Textual columns in the right side that will appear on the final generated file If the data source table has geometry columns the geometry column to be exported need to be selected 10 Click Next 87 143 STDM User Manual Export Table Select the table or view from the STOM database whose contents are to be exported Source Table check_previous_residence check_rent check_settlement_reason check_social_tenure_type E sp_unit_use check_type x El type content_base content_roles enumerator party priority respondent role sodal_tenure_relationship spatial_unit survey witness If specific queries need to be implemented on the resultant data they can be specified using the query build in the next page as shown below Ifno queries are required clear the query builder check box 88 143 STDM User Manual Filter Data Specify a custom query to filter out the resulting dataset Query Builder Columns Unique Valu
42. are added to software they introduce the possibility of new bugs if you encounter any problem with this release please report it on STDM s issue tracker so that the developers can check and fix it To get technical support please use the online resources listed the getting technical support to get in touch with the pool of STDM users and developers From GLTN we do hope that you will enjoy this release and are looking forward to getting your feedback including feature enhancements to consider for the next major release 1 2 1 Installation Enhanced Custom Build for Windows e 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 e 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 Read more Installing through GLTN Plugin Repository e Forusers 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
43. ated by default 10 Click Finish 84 143 STDM User Manual Assign Columns Match source and destination table columns Source Table type us Y spatial _unit_id The spatial units have now been imported into the STDM database A notification will pop up showing you that the data has been imported successfully 5 3 Export Data from the STDM 1 Select E Export Data command item from the menu BR lolek aale lelolo 2 An export STDM Data pops up allowing you to choose the destination file and format 85 143 STDM User Manual g Export STDM Data Destination Options Select destination file name and format J sample Digitized vector vw Search Digitized vector Organise New folder H x A Name f Date modified w Favourites B Desktop _ sample points shp 08 07 2015 18 03 Downloads __ samples structures shp 08 07 2015 18 04 3 Dropbox i m r 3 Select the destination format from the list 4 Browse to save location of the file Destination File 4 Enter a name for the file to be create 5 Click Save on the file save dialog 6 Click Next to proceed 86 143 STDM User Manual Export Table Select the table or view from the STOM database whose contents are to be exported Textual Columns check previous residence a C HF address check_rent EH contact_telephone check_settlement_reason EH date_of birth check_social_tenure_type E HH family_n
44. bles to Participate in Social Tenure Relations Views 7 Party table columns participating in STR definition id x surname party kal x other_names X E household_number date_of_birth Select table representing party in the Social Tenure Relationship definition individual persons within the settlement 7 Spatial unit table columns participating in STR definitior id x code Select table representing spatial unit in the Social Tenure Relationship definition spatial_unit pieces of land within the settement 1 Select from first drop down table representing Party 2 Select from the selected party table a columns that can be used in the representation of social tenure relationship 3 Select from the second drop down list the table representing spatial unit 4 Select from the spatial unit table a list of columns to participate in social tenure relationship Click Next to proceed A pop up appears showing you that database has been successfully created 3 1 7 Creating new data schema After creating the paths profiles tables attribute table relationships and STR the user will now be required to create data schema This appears as the last step in design form configuration where all the settings and tables created will be stored in a new config file The user can see the generated SQL by clicking to the Show generated SQL file STDM User Manual Update Database Commit SQL changes to the database Create new S
45. ct Edit View Layer Settings Plugins Vector Raster TE E 4 Snap the four corners of the structure and Right click on the last corner Arl BAR ae O R RaR Aa ag8GR 900 Pa El id a fe oa E x i itl 7 a tm CQ Se ae x Structures x Area_of_Interest_modified_WS PR Layers Browser Spatial Unit Manager E x Manage Layers Layer Q spatial_unit geom_polygon v 7 Add Layer to Canvas gt Set Display Name Import Features Import GPX File An attribute table appears allowing you to input data relating to the Hace 96 143 STDM User Manual nit_id_seq t regdass amp One STDM layer may have multiple geometry types ignore other geometries when adding the attribute data 5 Input the attributes on the attribute table and then click OK button to finish The feature is now created on the map Do this for all the features you want to digitize or captured into the spatial unit layer To Finish the Editing session Click save tool on the QGIs Soe toolbar as shown Then click on the a tool on the same tool bar to stop editing mode i e tag HIER ERO 6 6 Importing GPS data This functionality enables user to e Functionality for uploading of GPX files downloaded from a GPS device Functionality should enable user to select which coordinate pairs they would like to edit add attribute information save and append to an existing STDM spatial layer 97 143 STDM User Man
46. d if the user does not provide any text on the form Is Searchable Field this allows you to activate the attribute field on the form as a possible search field for filtering the data on the entity browser 43 143 STDM User Manual 4 Click OK to create the new attribute 5 The new attribute is created and appears as shown below Basic data types columns Geometry columns You have the option of adding as many attributes as required edit or delete the attributes by use of the Edit button lil Delete button For you to delete an attribute the table and column must be selected Adding a field with lookup option 1 Click to add a new column 2 Enter the the column properties on the attribute editor dialog Add Table Column Table settement_house Column Name ae Description Rent paid per month Column Data Type Shorttext Character Length Auto Increment Primary Key _ Yes Is Mandatory Field Field is a List Choice list Default Value Default value will be provided if user does not spe Is Searchable Field Yes cone On Field is a list select yes 3 Click Source button 4 On the Look up dialog check if the desired lookup exist and select it and then click ok If not click New 44 143 STDM User Manual HH Rent certificate HH Lease agreement HH Title 5 Anew Lookup dialog appears KA Lookup Source Select Lookup Table EE check_document_type hd A
47. d rights all types of rights holders and all kinds of land and property objects spatial units regardless of the level of formality 1 1 1 Core Values STDM s core values and principles are pro poor good governance equity subsidiarity sustainability affordability systematic large scale and gender responsiveness 1 1 2 The STDM Universe STDM is a pro poor participatory and affordable land tool that broadens the scope of land administration by incorporating all person s to land relationships beyond formal legal land rights cognisant of the continuum of land rights STDM has four inter related components 1 Anew way of thinking about land records 2 A free and open source software package to record information about land 3 An approach of collecting data about land 4 Away of using and disseminating information about land The STDM Universe consists of an extensible data model conceptual and operational model database implementation software modules and an extensible architecture 1 2 Changelog for STDM Version 1 1 July 2015 The emphasis of this release has been very much on stabilizing the platform and improving the feature set we have added many new features tweaked and enhanced the user experience making STDM easier to use than ever before Data management and document generation tools have had a lot of work done to simplify the design of tables data access and creation of rich cartographic outputs Whenever new features
48. d to avoid obstruction from building and trees hinders visibility of satellites This reduces the accuracy of the final data Depending on the GPS device a GPS receiver must be locked to signals from at least 3 4 satellites to be able to calculate the position The higher the signal strength in terms of satellite signals the higher the accuracy reliability What to know when using GPS in the field While using GPS in the field it is important to take note of the following What affect the accuracy of the data e Objects such as building mountains tall trees e t c have a reflection effect to transmitted signal which may cause delay to the received signal thereby introducing errors e The above mentioned objects also have an obstruction effect whereby the signals may be blocked thereby reducing the number of available satellites e The amount of humidity or density of the clouds in the atmosphere The signals slow down as it passes through them which affect the overall accuracy of the obtained position Working with Garmin GPS data Refer to Garmin website www garmin com for detailed description on how to capture data using Garmini GPS Having collected field data using the GPS Office work remains important to put the collected data to usable format Garmin by defaults stores its data in World geodetic system WGS 84 This becomes easy to use as it can be overlayed to Google maps and other global maps or images To learn how to downl
49. dd LookupLook up will begin with check_ once defined Table Name montly rent Lookup for monty rent selection _ Inherit columns from another table ok cae i 6 Enter lookup table name 7 Add lookup table description NOTE do not inherit columns from another table when creating lookup This is create automatically 8 Click Ok 45 143 STDM User Manual check_document_type 5 check social tenure_type a ae Lookup table is now created 9 Select the lookup table from the list so that it is now the currently selected lookup 1 z Select Lookup Table O New Lookup Table Choices 10 Click Add New Choice 2 11 On the Lookup Text box enter lookup text 3 12 Click Ok to dismiss the Lookup Text box 4 13 Click Add New Choice again to add more 46 143 MaAnil gt CAT VA p Lookup Table Choices HH Below 5000 EH 50001 10000 HH 10001 15000 HH Above 15000 Add New Choice 14 When done with choices click OK to dismiss the Lookup dialog 15 Click Ok to save the new column check_montly_rent Lookup option will be added in the column lookup field Adding geometry columns Geometry columns can only be added in spatial unit table of the basic profile Additional tables can be created to accepted geometry data 1 To add a new column click the button 2 Type the column in the column name text box 3 Enter description in the description column box
50. deleting a Party record button is used 1 On the Party browser select the party record you wish to delete 2 Click the delete button to execute the command W Party Records Manager 15 rows DIANA ma WARATTT BNC A eo Teo Tt Toe FT 240A CoA CT 17 a 7 AC A warning appears to confirm whether you are ready to delete the record 3 Click Yes to delete the record Wf Delete Record Are you sure you want to delete the selected record Once deleted it cannot be recovered MURRU o o 6 565 3456355454 9311553 pom oe omen ee om 4 Click Close to end the task 4 2 Define New Social Tenure Relationship Social Tenure Relationship entails defining the rights that a Party has to a given spatial unit To set up a Social tenure relationship 1 Click on the module settings button on the QGIS tool bar 2 Select Social Tenure Relationship from the modules available on the drop down options 65 143 STDM User Manual Before the Social tenure relationship wizard launches an integrity check will be performed for a given social tenure document id table in the database If this table is missing this wizard will fail to launch Check with administrator if this happens If everything is okay A social tenure wizard will appear New Social Tenure Relationship m LN p U About General information about Social Tenure Relationship STR Scoial Tenure Relationship refers to the right or relationship
51. e eee All iyi etid supporting _documents f _ SOENE character varying 50 yes other_names character varying 50 yes 4 Ensure party table is selected in the table view panel 5 Click button at the bottom a 93 143 STDM User Manual 6 Enter the relation parameters as shown Add relation from parent table Relation name party household Local Column HH household_number Reference table settement_households Referenced column id On Delete action CASCADE On Update action Column information to dispay when browsing for foreign key Display Column household_number Comments Relation name cannot be empty and can be given as any text e g person household number Local column refers to column in child table to reference the parent e g household number Reference table refers to parent table e g settlement household Referenced column refers to unique or primary key column reference in the parent table e g id or household number Click OK to save new relation A relation can be deleted by selecting the particular relation on the list and clicking the delete button at the bottom 3 1 6 Creating STR tables This step is available in the design form wizard after creating table attributes and clicking Next on the wizard Creating STR tables actually refers to selection of core tables that will participate in social tenure relation definition later 94 143 Defining Socal Tenure Tables Define Ta
52. e user config file will be stored for access in the local computer or network By selecting settings path the other paths will be loaded automatically pointing to the settings path This can also be changed Source document path this refers to location where supporting documents will be saved Document output path Set this path where stdm will store all output documents Templates path Set this path where stdm will store all design templates for document generation __ Change 1 Click on the Change Button A file open dialog will pop up allowing you select the new location to save your files 1 Choose the new directory source and destination file of your workings 2 Click Choose to proceed The new path is already set and user can proceed to setting other paths The other paths are also populated by default If there is an existing config in the selected directory a warning message will be given to alert you if you need to overwrite or Keep the current one STDM User Manual Wizard detected previous configuration exists in the current directory Do you want to overwrite the existing config By selecting yes the system will match the version of the two config and the latest will be updated Selecting No will not affect your previous settings and they will be used in the rest of configuration process If all the paths were set in one directory the following files and folders will be created The mandatory file here is the s
53. e_of_birth famiy name id other_names marital_status gt address Having selected your report fields 1 Select Filter tab Filtering allows you to query a data set matching a certain criteria which you should know prior to field selection The filter column must also be selected E g select persons whose gender is female 117 148 STDM User Manual 2 Select the column you want to use to filter the data i e gender Fields Filter Grouping Sorting Display Enter a WHERE dause to select records that will be appended to the report oth ames gender j contact_telephone identification Select FROM party WHERE lt gt LIKE ae e AND 3 lt i OR Clear Verify Apply 2 Select the operator to use in the filter expression 3 Get the data from the database to assist you in matching the criteria In this case the data is coded 1 for male and 2 for female 4 The filter expression is therefore generated for you gender 2 or gender Female 5 Click verify button to see the matched result from the filter expression If some records are returned You may proceed Multiple filter expression can be given as well i e gender Female AND age lt 20 AND marital status Married For such a filter the data must be existing and the columns should be selected for report fields Grouping report Fields Filter Grouping Sorting Display Report Fields family_name o ade
54. eaeeeeeesseeeeeeeesaaaeeeeeeeas 18 ro USF USING Cece ce cece cect E E geeaee qe eres eegacece sec E 20 E 2100 E E 0 eet etc noe ee eee T eee one ere eee eee ee cra ae ener A ene ee ee ere 23 Zad BOO S FDN aoee E E T E E E EE E E eee 23 22 Creanga Dala FONS seeria sanni nee eA e Aa apere D e REE n NESE AERE ere Reien 26 3 Designing Data Forms for first time Use xsi ccaivestccectnvccsdcwnyaecesssthocedamatborestececsd anos bese sestbonsieacteceauanestaeesnact 27 3 1 CP SAU TW daa O ee 36 3 1 1 Groatng Me paloset aier EEEE aa e EAE ERARE aao 36 Bales Creanne pronle and TaDlES ait ockcceneneaes thence inienn annae EAR AA ARANAN EENAA TAAA ANEAN NONANO 38 3 1 3 Creating table attributes iscccccccsecccesedacdendsnendcntctsceseeateddcedalacsendevacdeedebessvedeneddintadeatendanwedendevaseerses 41 SLA Cheating Geomeny Colins micanacacecuszentenmtsadesum Ea E EEEE R RR ET 51 3 9 Working with Foreign KEY ook cect ace etecatreatc ect escecbarmyneceseeicdenesaeataneseesmnss aeostese cee TEANA ENEAN AKENE 53 3 1 6 creating STR 2 gt ceninin aE ee ee EE eee ee 54 Seley AGMA new data SG WIN ten ce ccateusentensmtendcaueeaatenontdedenentdangeantiadcaesneantewedidadiuneenteunaeudcrutmeasenasaence D0 4 Data Management Working with MOodules cccccceceeeeeee eee e eee essen eee ee anes ee eeee essa eeda ees eeseeeseeseeeseeenes 58 While working and managing the STDM modules make sure QGIS is started and running while STDM is visible in QGIS i
55. er CRS original will be used Note For above data the coordinate system used was WGS 84 For the format ESRI Shape file format is preferred because it is supported by many GIS software Do not check the Skip attribute creation check box 10 Provide the output path 11 Click to check Add saved file to map 12 Click OK STDM User Manual Format ESRI Shapefile Save as ita Digitized vector strutures shp CRS _ Selected CRS EPSG 4326 WGS 84 Encoding System _ Save only selected features Skip attribute creation Add saved file to map Symbology export No symbology Scale 1 50000 P Extent current layer gt Datasource Options Layer Options P Custom Options A new layer will be created and added to the QGIS map canvas 10 1 4 Geo referencing Geo referencing is process of introducing world real coordinates on to a raw image so that the final product is a spatially enabled map that can give location of features in the two dimension space Steps 1 Click on the raster menu on the QGIS interface Vecter database Web MMOQGIS Processing 5ST Raster Calculator Heatmap Interpolation i Terrain Analysis gt zonal statistics Projections 2 On the drop down content click georeferencer gt georeferencer Dialog box will appear A pop up will appear allowing you to load a raster image 3 Click as below to load the image 133 143
56. es address age contact_telephone cer family_name cre gender household_id id identification Get Unique Values 11 Click Finish A message box will prompt the response when the action is completed dismiss the dialog Browse to the location of the file to see the results If you are not satisfied with the result the process can be repeated with new options 89 143 STDM User Manual Filter Data Specify a custom query to filter out the resulting dataset Unique Values cont T family i Features in party have been successfully exported 12 Click OK to finish the process 90 143 6 Spatial Unit Manager The Spatial Unit Manager has two main features Manage Layers and Import Layers Manage Layers Enables user to e List spatial layers from STDM database i e database table that contain geometry column the list should contained specific icon for respective layers i e point line and polygon or table e Loading of the listed spatial layers to QGIS canvas e Change display name of loaded features this is a profile name which is not stored in the database but on a configuration file inside QGIS local settings file This dock able window on the left of QGIS canvas is shown by default though it can be toggled using the spatial unit manager icon Listing of STDM spatial layers Shown when combo box is selected User can select any layer and it will be the active layer to be loaded to QG
57. f the selected Coordinate System will appear Click OK Then Click Ok Table Attributes Geometry column will not appear in the list of column but it amp loaded in the background The above message will appear to alert you that the geometry columns are not part of the textual column Basic data types columns Geometry columns Eea wae am me ot ca a ee ee a stunt scon pdygon rouvcon ape SSS a 92 143 STDM User Manual 3 1 5 Working with Foreign Key The STDM allows the user to extend to other modules by use of the Primary Key The Foreign Key is automatic defined during the module tables relationships Creating table relations child to parent table constrains To successfully create a relationship for tables the child table must have the relation column and should be of data type integer whole number The parent table must have the Primary Key field id column Sample relation 1 Create a column household number in the party table Add Table Column Table party ha Column Name household number Description Column Description Column Data Type Whole Number m Character Length Auto Increment Primary Key Yes Is Mandatory Field No Field is a List Choice list Yes E g Gender Male Female Source Default Value Default value will be provided if user does not spe Is Searchable Field No se SE LUTTE TL _ TWO OL spatial_unit retry columns HT scr croton Sear B
58. flleld 0 cece eee eee eee reer serene sees eesaeesaeeseesaeenes 130 1O 1 5 Downloading GPS data from QGIS tereonidi i eae el an trea E sc tanineh hae ate aaa 130 IOLA GOS SRE INCUIN ua cect ac ace cae cL acer ace erent acne 133 10 2 AnnhexZ Workine with spreadsheeEranmian na n ee inanee see tens 137 POD AS UBORMAING SpECACSNCEE Cate isc oats ciao tad ce stig alec iste tas ea ah celeste es 137 Formatting cell values Cleaning the data I e Capitalizing persons names cceeeeeeeeeeeeeeeeeeeeneeenees 139 TOS Amero Additional SEINES nisreen ie eae 141 t03 CHANGING DASSW ORG csi sepstet e E S 141 103 25 RESCLSEIVEL Selig 54 te ance tecies et ea ie eatsca E lai dean eebatios talc teat RA 141 T0323 Logom OUC OFS TDM icenian laine ele nena yaa ae a scared 143 1 Introduction 1 1 About STDM The Social Tenure Domain Model STDM is a pro poor gender responsive and participatory land information system developed by the Global Land Tool Network GLTN It is one of eighteen land tools being developed tested and applied by GLTN partners to promote secure land and property rights for all STDM as it stands has the capacity to broaden the scope of land administration by providing a land information management framework that would integrate formal informal and customary land systems and administrative and spatial components STDM makes this possible through tools that facilitates recording of all forms of lan
59. frame line thickness Map added x 7 Paper and quality Presets 4 Width Height 210 00 Units mm ahr dF 4 4k Number of pages 1 Page background Change 4k Export resolution 300 dpi Print as raster World file on Then on the label option type the name and edit as you wish it to appear empty gt Changed grid frame line thickness Map added Label added Label text changed position Ttem properties STDM data properties l Label Type the Title here Render as HTML Insert an expression 3 Click on OK for the changes to apply on the template 105 143 Setting a map scale Put a suitable scale on the map for distance measurement 1 To place a new scale bar click on the button 2 Then place the scale bar suitably below the maps space placement 3 Set the properties of the scale bar and the scale bar style Composition Item properties STOM data properties Item properties x Scalebar e Y Main properties Map Map Style Single Box es Single Box Double Box j a i Y Units ine Ticks Middle Line Ticks Down etel Line Ticks Up a EE Map units per bar 1 00 unit 4k Y Segments al da Co Any changes made on this item properties task pane will affect the scale bar placed on the template The scale used should give a true reflection of the actual distances and content size on the ground for which the map represents Adding a legend
60. from the combo selection Manage Layers Layer tt spatial_unit geom_line hi kE spatial_unit geom_line 5 spatial_unit geom_point spatal_unit geom_ polygon i sodal_tenure_relations geometry Ensure the required layer is currently selected on the combo Manage Layers Layer spatial_unit geom polygon Bee Add Layer to Canvas Set Display Name Add Layer to Canvas Click to add the layer on to QGIS 94 143 STDM User Manual Layers Ex aes 7 a a ji xi spatial unit geom_polygon 6 4 Renaming spatial unit layer Changing display name Layers Ex A 7 a aa Supposing the added geometry layer is the one above The existing name of the layer loaded to the canvas is not very appealing To set a friendly display name ensure the layer is selected Set Display Name Click on the spatial unit manager Provide a friendly name on the change display name dialog iy x Current Name is spatial_unit geom_polygon Structures Click Ok to change the name Note this only applies to layer in STDM database only 6 5 Digitizing into spatial unit layer Adding new record of spatial unit entails digitizing the structure from a base map imagery Ensure the Imagery or base map file is added on QGIS map canvas Steps 1 Select the spatial unit to digitize features into Layers The layer becomes active for editing 95 143 STDM User Manual 3 Click on the Add feature tool to start editing Proje
61. gltn net plugin plugins xml Read more 1 2 2 Management of Spatial Units Introduction of Spatial Unit Manager e 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 ESA Layers Browser s Spatial Unit Manager E Manage Layers Layer ke spatial unit geor Add Layer to Canvas bors amp bee Set Display Name d Import Features Import GPX File ka Importing Spatial Units from GPX Files e 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 dh 1 2 3 Document Outputs STDM User Manual
62. ick on its button on the tool bar shown ina red box below 1D Sl fi E olo The administrative units viewer displays to enable adding new administrative units 2 eto Clear Selection New Administrative Unit vv e A sample of Administrative units prepared is as below 74 1483 Administrative Units Viewer Name Kenya Nairobi Provicne Westlands Central Provione Kiambu E3 Delete Selection New Administrative Unit Unit Name Eastern province 2 To set up a new administrative unit type down its name and on the unit name field and its code on the code field The system sets a new unit as a parent unit if no existing unit is selected during a new unit creation If an already created unit is selected during creation of a new unit the new unit will be the child unit and will appear below the selected unit 3 If user intends to create a new parent unit when an already created unit is selected on the cascading view click on the Clear Selection button on the management wizard to reset selection 4 Next click on the plus sign shown in a red box below to enter the new unit name and code You have not selected any parent node for the new administrative unit Do you want to add it as one of the topmost administrative units Click Yes to proceed or No to cancel An alert message appears showing that the current unit will be a parent unit To proceed click Yes Deleting a unit The adminis
63. ion will be used in various ways like making informed decisions good management of resources security of tenure etc The generation of document will be based on the selected social tenure tables To generate a report based on the designed template 1 On the STDM interface tools Select Document Generator button Moanaad A Document Generator browser appears allowing the user to perform several tasks Click on the plus button below to add a record from the database Party Spatialunit E E 2 On the wizard select button to Add a person whose details you wish to appear in the document This allows you to browser to the party records 111 143 STDM User Manual 3 Select the person whose details you wish to appear in the document 4 Click Select button to proceed Click on the plus butto below to add a record from the database Party Spatial unit gt TG Yrren ore nanes aare serine ene oot at di i Tn Set Mires entei act Telepi te ot mat Sonder atal stat Peter James 2342342 423423 asdrfa 07 Jul 2015 1 Look For Type the filter keyword here In Column other_names z EXDOrTt as POF A notification will appears showing you that the record has been selected Record has been selected Peter Jam 2342342 423423 asdrfa 07 Jul 2015 1 2 k Look For Type the filter keyword here In Column other_names z 5 Click Close button to
64. k without it 3 3 PostGIS 2 1 7 This install the GIS plugin for PostgreSQL if you don t have it in your machine make sure you select for installation 3 4 Sample data This will install sample files for STDM plugin This is not a mandatory option but new users are recommended to install to help them jump start with STDM practice Note If you already have PostgreSQL or PostGIS installed the installer will skip installation of those components After your selection click Next to start the installation 15 143 STDM User Manual EE E G Social Tenure Domain Model Setup Check the components you want to install and uncheck the components you don t want to install Click Next to continue i select components to install QGIS Wein 2 8 2 for STD coe ee m Position your mouse PostgresQL 3 4 over a component to PostGIS 2 1 7 see its description Sample Data 4 4 4 Space required 0 0KB m Global Land Tool Network Step 4 Database connection properties G Social Tenure Domain Model Setup Database Connection Properties Please specify the database connection properties for installing PostgreSQL and Postals Database Connection Properties User Name postgres Password TETTI Fort 5433 Database Name ctdm Please take note of these values as they will be required for configuring STOM on using it for the first time alobal Land Tool Wetwork The wi
65. le modules tables sections 3 Creating additional tables to the default profile a Click the Add button A new form appears b Enter the table name and description Name a Party can be a person household or ia group Spatial unit or a group of spatial unit qin i spatial unit Services Community services and utilities Auto create default column with primary key Ww Inherit columns from another table l ox ii z Ensure Auto create default column with primary Key is checked Check Inherit columns from another table if you would like to fetch columns from another table with similar properties The table must be within the same profile c Click OK to create a table Additional tables can be created in the same way 39 143 STDM User Manual 4 Creating new profile and tables ai New Profile a Click button E Delete Selected A profile editor appears allowing you to create a profile name b Input the e Profile Name type the profile name that you wish for your project e Description give a small description to give a meaning to the profile name An example would be Profile Name Settlement profile Description A complete community inventory Manage Profile a ee eet Ge El Settlement Profle A rrr Jata eran mtu mam tar A comp ei E COMMURITY INVENT Y c Click Ok to dismiss the dialog d Select the created profile name to enable table creation by clicking on the drop do
66. lected spatial unit on the map 1 Click on the spatial unit code on the tree view area Search Results Right cick an item for options it Se lal Tenu Sodal tenure H Share None The spatial unit view area will project the geometry of the corresponding spatial unit form the database 72 1483 STDM User Manual Spatial Unit Preview Render Scale factor 1 000 Gel Local Web The local tab enables you to overlay the spatial unit on to an Imagery from the directory This should be loaded added on the qgis map canvas before opening the social tenure viewer The Web tab enables you to overlay the spatial unit on the web map layer Web overlay may vary from actual representation in the local map Imagery 2015 Terms of Use Reset Map j j i i i j i i Choose Base Layer Google Maps Open Street Maps Zoom level Sync GF Local Web Reset map button allows to return to original zoom level once the zoom level has changed Sync button allows you to refresh the map with the currently selected details Click Close to exit the wizard 73 143 STDM User Manual 4 4 Managing administrative unit Administrative units are set up on a hierarchical cascade structure For example from country to province then district division and location This could also be explained as a form of a parent unit to a child unit relationship 1 To access the administrative unit management cl
67. llection uses the following function IF D2 MALE PROPER D2 IF D2 M Male IF D2 F Female IF D2 FEMALE PROPER D2 To check if an integer cell is defined or set as a blank text if specified as zero IF F2 gt 0 F2 To set an option cell as a blank text it s specified as NA IF W2 NA PROPER W2 For more help visit http www office microsoft com en us excel help 140 143 10 3 Annex 3 Additional settings 10 3 1 Changing password For this command to work you must be logged in to STDM 1 To change the login password click on the change password button j This will prompt a change password dialog The change password button is only available once a user is logged in Mew Password TIT 2 The user is required to input a new password and its confirmation Then click on the save button for the new password to take effect Note This is the password to be used on the next login If the login password created has characters fewer than 6 the message bellow will appear 4 Change Password _ Password length must be equal to or greater than 6 characters This is due to the password strength The more characters on a password the stronger it is to avoid being compromised 4 Click the OK button and set a new password that has 6 or more characters 5 10 3 2 Reset Server settings Note This features allows the user to change the server configuration
68. lum Related Table Translator Configuration Match s l Destination Table Settings Sme i Table name party Column name household _id T m Referenced Table Settings Table name household None Output column id Cancel 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 1 2 6 Miscellaneous In addition a wide range of improvements have been made e Upon successful login the system now checks if the specified STDM database has the PostGIS extension installed and notifies the user accordingly if the extension is not detected This addresses some issues that previously arose if the user did not have a spatially enabled STDM database e The document generator module enables users to generate documents using records from the data source defined in the template This is applicable in cases where aggregate data from database views computed using for example settlement statistics derived from neighbourhood data is used e Icons for accessing the modules through the menu and toolbar have been reworked to have a consistent look and feel e The module for viewing social tenure relationships has bee
69. me and password is required to connect Help Contents Provides access to STDM user manual About Brings up the about us text Full view Login credentials are required to access full menu items especially if you are the administrator Read more about Login here 20 143 STDM User Manual STDM Menu Items View Social Tenure Relationship Manage Administrative Units E Import Data J Export Data Document Designer PE Document Generator Ed Report Builder Fo Logout Del Change Password Login F2 Help Contents F10 STDM Tool Bar Items BE RAR N ggg aaga Design Forms Brings up the configuration wizard that allows you create and customize data forms which is converted to database schema Keyboard shortcut is F7 FE Content Authorization ri Manage Users Roles Admin Settings Content Authorization allows you to grant access such as Create View Edit Delete to other STDM functions Admin Settings Manage Users Roles Brings up a dialog for you to create users and roles for accessing various STDM functionality Party Socal Tenure Relationship Modules Provides a quick access to module s data browser and data forms for data management which were designed in the Configuration wizard Foreign Keys Allows you to access parent table ids in the child table within the module browser and must be defined in the Design Forms Supporting Document Allows you to add files from the directo
70. mplate Select Document Template Document Generator Output Type Sos 9 Check the fields to appear on the output document 10 Click Generate Output Document Naming Select the fields whose values will be used to name the output document files X Address X Identification X Contact Telephone X Age amp Gender EJ Household Id gt E A pop up appears notifying you that the Document Generation has successfully been completed 114 143 STDM User Manual 11 Click OK to complete The document has been successfully generated The user can browse to the output path to see the document A similar process is followed to create a spatial unit document using the spatial unit tab 7 3 Generating Documents and Reports STDM provides a platform for report generation which can be used for decision making 1 Click on the Report builder button on the STDM tool bar A aj wale A report builder wizard appears allowing the you to customize the report based on the data and your selection items Fields Filter Grouping Sorting Display Entity Report Contents Fields Report Fields address contact_telephone date_of_birth family_name gender id identification ff marital status other_names 2 From the wizard select the Entity you wish to work on For example is it a report on Household Party Spatial Unit or Social Tenure Relationship Choose the entity you
71. n the output raster you give the geo referenced image a name Then select the reference system to be used in Target SRS 7 Check the Load in QGIS when done 8 Select then click OK 9 With identified points on the map and with their coordinated Use the Add point button to add control points on the map Once you click at any point on the map the pop below shows up allowing you to enter the coordinates of that point 10 Do this for the other points and then click OK for each pair of point entered K Enter map coord ate Enter X and Y coordinates DMS dd mm ss ss DD dd dd or projected coordinates mmmm mm which correspond with the selected point on the image Alternatively dick the button with icon of a pendil and then cick a corresponding point on map canvas of QGIS to fill in coordinates of that point gess dnt Snap to background layers OK g From map canvas Cancel 11 Click the icon Run to have all the point loaded 12 Then close the georeferencer dialog box F 13 Load the geo referenced image using the icon open raster in the QGIS interface view for viewing the geo referenced image NOTE This is just one of way of entering the coordinates during the geo referencing 136 143 STDM User Manual 10 2 Annex 2 Working with spreadsheet 10 2 1 Formatting spreadsheet data Creating lookups in excel sheet Reason for staying Tenure status I Affordable rent Search for job
72. n updated to take advantage of multithreading when fetching lookup values for keyword searches 1 3 Getting Technical Support Depending on the context of the support services required you can use the online resource below to get in touch with GLTN s STDM team e For more information please visit www stdm gltn net or subscribe to lists osgeo org cgi bin mailman listinfo stdm user e To receive important news and updates around STDM in general subscribe to lists osgeo org cgi bin mailman listinfo stdm announce e Ifyou find an issue working with STDM please report it so that developers can check and fix it To report a bug subscribe to lists osgeo org cgi bin mailman listinfo stdm dev or post it in GitHub at https github com gltn stdm plugin issues To browse the source codes or extend the core platform access the repository here https github com gltn stdm plugin Note While asking an STDM related question via the mailing lists kindly provide the following information along with it e A descriptive title for your email e The computer s operating system and version e The exact STDM version used at that moment e The process taking place when the system broke down e g new installation re installation system update etc e The exact error that has occurred If possible attach a screenshot or copy of the error text along with the email 1 4 Testing platforms Operating systems Windows e Windows 2000 Windo
73. ndow allows you to set the username and password to use with STDM Leave the default port to 5433 this is where PostgreSQL server will be listening for database connections for more details on PostgreSQL connections setup please see documentation in http www postgresgLorg Step 5 16 143 STDM User Manual This is the actual component installation QGIS STDM PostgreSQL PostGIS and all other dependencies will be installed in C Program Files QGIS Wein for STDM folder Depending on the speed of your machine this process might take slightly about 15 minutes Lo a Socia EhiUre Don air Viode Setup ee Installing A Please wait while Social Tenure Domain Model is being installed G Installing QGIS Wein 2 8 2 for STDM ee Output folder C Users ADMINI 1 ApoData Local Temp nsdAD6A tmp stdm_ installer Extract OGIS 5TDM 2 8 2 Setup x86 exe Installing OGIS Wein 2 8 2 for STDM Global Land Tool Network lt Back Next gt Cancel Step 6 After successful installation please close the installer by selecting Finish button Go ahead and run QGIS for STDM from the icon created on your computer desktop Completing Social Tenure Domain Model Setup Social Tenure Domain Model has been installed on your computer Social Tenure Click Finish to dose Setup Domain Model A Plugin for QGIS v2 8 el FACILITATED BY WZSLIN unwHasirar ee Continue to getting started 17 143 STDM User
74. new accounts for content management 4 To create a new user click on the new button to input the required information 122 143 STDM User Manual tA Manage System Users and Roles New User Information Password PTitiii nna _ Account Expres On 6 5 2014 On the new user dialog input the user name and create a password to login with The new user created can be given a timeline after which the user account created will expire By clearing the No Expiry Date check box the expiry date set up will be deactivated New User Information Password ooeeeee Confirm Password seesess June 2014 5 Click on the date button and set up an expiry date for which the new user account will be active 6 Once done click on the create user button on the dialog to create the new user Edit User The user management dialog also has a user editing option 1 To edit an already created account select the user to be edited then click on the edit button 123 143 STDM User Manual wf Manage System Users and Roles Users Roles Mappings So ee X No Expiry Date On the user update dialog user can make any changes required 2 Once done click on the update user button to effect the changes If user clicks on the edit button before selecting an account a warning dialog appears NEP Wattage System Users ond Roles 3 Click on OK button and select a user accoun
75. nterface tool bar ic vcisice vias oudensesvecessancnvesdenesnesdniantenastna deed nincecdnsss eaandsanedandasecdansanersenctieeseetes 58 4 1 Managing Party Modil seecae I EO T AE EIRE E ENER ARS EERE 58 4 2 Define New Social Tenure Relationship seis ctcscnsiasicceaeteassecuicadenctinds wencnacadsusateipecseieedeaanedennedvanadscantaneans 65 4 3 Vew Soda Teme Kelan ons MI er A E E 70 To view the selected spatial unit on the Map cccccccseeceeeseececeeeeseeeeeeeeeeeeeeeeeseeseeeseeseeeseeseeeseeseeeneeseeeseesaes 12 4 4 Managing administrative UNIT o psatcsc qpanccaacandeaaa Gastnndsqaueeascqpecneqsdnutaase EAA ANA ATARAR RANEA aE 14 3s Manapini data mpor E xpOTE prsi eee er ne ee E EE 78 5 1 h por ng Attribute Data ssessesssiassans enin E AERE eA EREN EEES 78 Aa Hapori o pai Date E AE A 81 Ovo Export Datadromi the SDM eadera a web case nce tepteees huidancdtsenwe ceases 85 Ga JODaua UIE Maia e ana a a a ee 91 6 1 Managing Spatial Unit MOdUle scrsectisien esna a aan aa 91 6 2 Addin Imagery 0 21s enna Ree nary pera Per are etme re Ree Rant nee tnt Penner er me ne fer earn ete ee nen eee ee ee ere 92 6 3 Adding spatial ULE lay OF enmener ianen aceite leone 94 6 4 REMAN E S PACA UTE liye ire ice sp sc snteaice acts sina me a he ascites cocaine E meaaliet ence 95 6 5 DiGiizIng IMtOSPatlal UNITE LAY OF sisi sen canebnnaevasien E dan teban cee aiue danni ers naan caw eee 95 6 6 HUMAN GP SCAU ates a a tt ears et as a Cea al ca es St
76. o to working with foreign keys here Selecting social tenure relations tables 7 Party table columns particpating in STR definition Select table representing party in the Social Tenure Relationship definition id x family_name x other_names address party x identification contact_telephone spatial_unit date_of_birth 5 x gender P marital_status Y Spatial unit table columns participating in STR definitior Select table representing spatial unit in the Social Tenure Relationship definition id x code x name x type spatial_unit ba x sp_unit_use spatial unit or a group of spatial unit You are required to select the table to represent party in your str definition Possible columns to focus on the social tenure relation str can also be checked on the selected table columns to the right You are also required to select spatial unit table to represent spatial unit entity in str definition Columns can also be selected The selected columns are just default columns and can always be checked or unchecked Social tenure relation table cannot be selected for either of the party The representation above may give the impression that only one str is possible at a time Nope Multiple str definition can be created using foreign key references to the core tables in your str definition The links to additional tables is then completed by creating custom views to various tables The views are accessible on the STDM reporting f
77. oad using STDM gps module go to importing gps data 10 1 3 Downloading GPS data from QGIS To download a GPS data from a GPS 1 Connect the GPS to your computer i e using USB cable STDM User Manual 2 Ensure the device is visible to your computer 3 Start QGIS normally 4 Launch the GPS plug in from QGIS Vector gt Gps gt Gps Tools mate MPL Coordinate Capture i ai GPS Tools Dxf25hp OpenStreetMap Road graph x Spatial Query Topology Checker 2 amp Analysis Tools i Ta Research Tools A new dialog box appears that allows you to browse to the location of field data from the Gps Load GPX file Import other file Download from GPS File C Users Njoqus Desktop sample data Waypoints_23 SEP 14 gpx Feature types Waypoints x Routes X Tracks 5 Select on first tab load GPX file 6 Browse to the location of GPS data and Click OK 131 148 s yaang Waypoints 23 SEP a Waypoints 23 SEP X Waypoints _23 SEP Structures x view _str_spatial_ unit Layers Browser Spatial Unit Manager EIE The loaded data should appear as a scatter of point depending on what was captured if all went okay 7 Right click on the way point probably it is the first on the listin the table of content 8 Select Save as in the shortcut panel and enter the details as required 9 Specify the format coordinate system for the new layer otherwise the source lay
78. ocal tenure relationship will be created based on the information that you have supplied as summarized below If you want to review or change any selections dick Back If you are satisified with the selections click Finish l Sur mary Information OE us Party Intormaton Family Name Peter Other Names James Address 2342542 J I gt bender i Marital Stat So Unit Use Geom Line None Geom Paint None Geom Polygon 01030000000 10000000 500000027868 1646 51552 0509844898 586 3240ebcdasthe41552c05a62 gt Social Tenure Relationst p Information STR Type Individual owner f If Source Documents cna The information text above should appear confirming if the saving operation was okay Click OK to dismiss the dialog 4 3 View Social Tenure Relationship To view the social tenure relationship click on the view STR button from the STDM tool bar This should start a view STR wizard where user can view the created relationship Search By Party Spatial unit Look for in column Filter Cj Search Clear Results The table that were selected as str tables in the design form wizard will appear in tabular format as shown A dialog box appears to allow you to search for saved social tenure relationship I e Search by party 2 On the name field type down the occupant s name whose relationship was created 70 143 STDM User Manual Search By Party Spatial unit re I
79. om the fact that you are supposed to select geometry for data type Geometry columns are not displayed together with the textual columns but in a separate tab as shown Spatial table should be created to accepted geometry data By default the spatial unit table of the basic profile is configured to accept this 1 To add a new column click the button 2 Type the column in the column name text box 3 Enter description in the description column box 4 Select Geometry from the data type list W Table Attributes Add Table Column Table spatial_unit Column Name structures Description capture geometry of structures Column Data Type Geometry Character Length z Auto Increment Primary Key _ Yes i Geometry Colum Is Mandatory Field No Select Geometry Type Folygon Field is a List Choice list Select Coordinate System Default Value EPSG 4326 OK On the pop up window select geometry type e Polygon if expected closed structures and will be marked by three or more points e Aline if itis a continuous stream of points that do not close e Point if only one point is expected Click button to select the desired Coordinate System from the coordinate selector By default WGS 84 is used 51 143 STDM User Manual Search by typing here Filter 4326 Recently used coordinate reference systems Coordinate Reference System EPSG 4326 WGS amp EP5G 43265 Once selected only the EPSG code o
80. or v Search Digitized vector Pp Organise New folder inn ie a Fane Name Date modified Type By Desktop __ sample points shp 08 07 2015 18 03 SHP File a Downloads el samples structures shp 08 07 2015 18 04 SHP File 42 Dropbox El Recent places aii ee a Music Pictures EE Videos ile Computer aa Local Disk C wt AutoCAD DXF cxf 5 Select the file and Click Open 6 Click Next to continue 82 143 STDM User Manual Source Data Specify the location of the source file and representative data type Dataset Users Njogus Desktop sample data Digitzed vector samples structures shp Destnation Repository Type _ Textual Data A dialog box appears allowing you to specify the destination table and the Geometry of the data being imported 7 Select the destination table of the data by checking enabling the Spatial_unit 8 In the Geometry Column a drop down list allows you to choose the data type of you data Select Polygon 9 Click Next to continue 83 143 STDM User Manual Destination table and import options Select Destination Table x spatial_unit _ Overwrite Existing Geometry Column geom_line X geom _line int a oe a A dialog box appears allowing you to match source and destination table column Use the UP and DOWN buttons to match the columns Note Do not select id field on the destination table This is cre
81. other_names RE address gender contact_telephone identification Group enables you to cluster your report in to categories based on the grouping fields Select accordingly Sorting 118 143 STDM User Manual Fields Filter Grouping Sorting Display Order Sorting the report field will produce a report with some order based on the sorting field A maximum of three field can be selected to sort your report Display tab Fore Color cri ett i tst StSCi sCS Height cm Horizontal Alignment Center ka Left cm Text Report title here cm Vertical Alignment This tab enables you to give your report a title and subtitles You can also customize the Layout of your report by clicking on the layout field of the elements 119 143 STDM User Manual Fields Filter Grouping Sorting Display Settings El Elements Title Subtitle i Field Names A r Orientation Landscape other_names gender Top Margin cm address contact_telephone identification El Groups aaa Bottom Margin cm Left Margin cm Right Margin cm Under fields you can change the display name of various fields to more friendly names Having done the customization of your report you can save the settings so that next time you just laod the saved template to generate similar report Load Save Generate Report Cancel Click Save to open file save dialog and provide
82. panel of QGIs for further data editing and viewing 3 The Pan ii allows you to edit the name of the selected spatial layer to a more friendly name 4 The HAEA allows you to import data directly from a GPS 6 2 Adding Imagery data 92 143 STDM User Manual To add Imagery data to the Canvas click Add Raster Layer button to add the imagery data into the canvas 2 Browse to where the imagery data source is 3 Select the imagery data 4 Click Open to add it to the canvas wi Open a GDAL Supported Raster Data Source b Map data Referenced Image Organize New folder Libraries E3 Documents a Music Pictures iTi Videos Area_of_Interest_ Area_of Interest_ modified WS modified W5 tif a a Homegroup ie Computer Local Disk C ca DE MATEO D c BEQNIZE E c MATATA F _ File name The Imagery data appears on the window as shown below 93 143 STDM User Manual layers E x 1 D Area of Interest modified WS Layers Browser _ Shortest path E x Start Stop Criterion Length z Length Time Cel oe doko Pose ook en Some of the tools that you can use to move the imagery data are used to Pan the map to a position you wish p e helps when you want to zoom in a working area of interest s helps the user to zoom out on the map 6 3 Adding spatial unit layer To add a particular spatial unit layer on to QGIS canvas Select the layer name
83. r EEE SEEE EA EER E e E R E 5 Tie ADU TD Me A E E E 5 1 1 1 COG N AUO aaa a E EE A E A 5 1 1 2 The STDM Universe cece ee eeeeeeeenceeeeee eee eeee teen eee eeaaaaaaaaaaaaaaaaaeeeeeeeeeeeaaaaaaaaaaaaaeaaaaeeeeeeeees 5 1 2 Changelog for STDM Version 1 1 July 2015 eecceececeeeeceeeeseeeeeeeeeeeeesaeeeseeeeeaeeseeeeseneesaeeeeeeeseneesaaes 6 1 2 1 SMAO e E A E E E E AN 6 1 2 2 Management of Spatial Units 2 0 0 ccccccccccceccseeseeeeeeeeeseeeeeeeeeeeeeeseseeeeeseeeeeessseeaeeeeeeeeeessaaaseeeess 6 1 2 3 Doc men OUMU eniri aiae aii aiia 7 LAA Daem Data OE e EEE T EE E A E 8 1 2 5 Importing Data to Foreign Key Columns ccccccsssseccecceeseeceeecaeaeeceeeeeaaeeeeeseeaaeseeeseeaeeeesssaaass 10 1 2 6 Miscellaneous c sata sstecesespicceantetataantetcantaspeedpancntachaeptedauenatachiasatadecanatasnsanatsbtegeatecsiass ecneqentainoatateaacetan 11 1 3 re CHI Teenie l SD MOE sea R E E E O E 12 1 4 PR ec at og 0 clade gi aeenee eee ne eee ene ec ee ee ee ee ee eee 13 1 5 Va to know Delore iN CAN sop to eed nateeatenserphe aiin Anaea EnD Aa a EAE N ERER RATRE 13 Error Duplicate keys for th modules Exits jaaacrccacictacisansisiacccacisuanaad sisi demansish AKNAN ANANA ERENER ERAKAR ANAR ANANA ANNAN EKARA 13 1 6 Using Bundled STDM installer cccccccccccscceeeceeseeeeeeeeeeeeeeeeseeeeeeeesaaeeeeeesseaeeeeesseeeeeeeeesaeeeeeeas 13 1 7 Installing From GLTN Plugin Repository ceeccceecceeeeeeeeeeeeeeceeeseeeeeeeeees
84. rting Setup This will make it possible to update Domain Model relevant system files without having to reboot your A Plugin for QGIS v2 8 computer Click Next to continue FACILITATED BY SCLIN UNPHABITAT Step 2 e Read the license agreement and if you accept select the first option and click Next to proceed to step 3 14 143 STDM User Manual G Social Tenure Domain Model Setup k mee Please review the license terms before installing Social Tenure Domain Model Press Pag Down to see the rest of the agreenent Socal Tenure Domain Model is Copyrigh C UN Habitat a and its implementing partners 2014 This program is free software you can redstribute it and or modify it under the terms of the GNU General Puble License as published by the Free Software Foundation either version 2 of the License or at your option any later version This nraoram is distributed in the hone that it will he vse fil If you accept the terms of the agreement select the first option below You must accept the agreement to install Social Tenure Domain Model Click Next to continue Step 3 Choose the components you would like to install the following are the available components 3 1 QGIS Wein 2 8 2 for STDM This will install QGIS with STDM plugin embedded 3 2 PostgreSQL 9 4 This will install PostgreSQL database server if you don t have PostgreSQL make sure you select this option STDM will not wor
85. ry during the definition of Social Tenure Relationship ss Manage Administrative Units Brings up the dialog for you to define geographic zones and administrative areas as per the project scope Access to these administrative areas is provided in the forms using foreign keys definitions 21 143 a Import Data The wizard allows you to import map or attributes data into specific module table in STDM database Export Data The wizard allows you to export data from STDM database into several output formats E Document Designer Brings up the QGIS Composer window with STDM toolbar items to allow you create document templates to be used when generating reporting and certificate formats Document Generator Provides a dialog that allows you to generate report specific module reports from the designed templates Report Builder Provides a wizard for creating and generating flexible report in PDF formats from the selected modules and views a View Social Tenure Relation Opens a window that allows to define and view defined social tenure relations in the database ty d Toggle Spatial Unit Editing mode Allows you to toggle the current STDM later editing state on and off Spatial Unit Manager Activates or deactivates the docked STDM spatial unit manager e Logout Closes the current session and returns you to minimal view Change Password Enables you to change the password of the current user in the current session
86. s 7 1 STDM Document Designer Document Designer is a QGIS tool that can be used to design and set up output maps Designing documents using STDM To Start the STDM Document Designer 1 Click on its launch button on the QGIS tool bar EOAE Ow A design tools appears allowing you to edit the template W STOM Document Designer Composer Edit View Layout Atlas Settings Jee HPAP ERANA too 150 200 5 i et Pt ee PO ko nnn annan The designer will start with an empty field where the user can work on to set up all properties and utilities of a map The tools allows you to perform several tasks This tools heps in drawing lines during the design of the template al N Label any graph photo etc by use this button used to add attribute table in the temple _ Enables you to add map on the document template You can add a photo of the owner of a spatial unit on the template Helps you to add chart After working on the template this button allows you to Save the template You can open the template from the storage file by use of this button HOMO In managing document template this button will help you in editing deleting etc selected template 102 148 STDM User Manual Adding a new map field 1 First click on the add map button to set up a new map on the designer field lt STDM Document Desi a Er sig Composer Edit View Layout Atas Settings pERGAeaeahhos
87. s on this wizard that the user assigns the content to roles 3 To do this user clicks on a content item on the left side of the dialog and assigns it to a role on the right side of the dialog by checking or unchecking the box against the role depending on whether the user is approving or disproving the assignment 127 143 STDM User Manual Click on a content item in the table on the left hand ade and checkfuncheck to approve desporove the authorised roles on the table in the right hand side below Content Authorization A role can be assigned multiple content depending on the nature of the content and the role description Once all content is assigned its role click on the close button 128 143 9 Working with Sample Data The sample data is provided during the STDM installation This sample data contains several forms of data 1 Geo referenced map data base map Raster data 2 Persons data in csv format in excel sheets 3 Shape files Vector data To use the sample data make sure QGIS is started and running while STDM is visible in QGIS interface tool bar 9 1 Managing party Module The sample data is copied during installation of STDM The person Occupant module is used to add update delete and edit person information Person in this case Natural person is an occupant with membership to a given household To learn in details how to manipulate party module data refer to party module data management 9 2 Man
88. s will be searchable The list of searchable columns is applied across multiple dialogs such as entity browsers and the module for viewing social tenure relationships 8 143 STDM User Manual Tables Table relation and constraint rrea Basic data types columns Geometry columns party y spatial_unit p social _te Lf Length Eapary ooo gt marital status ac Orrin pd E check_s wep Tees PSS E hek mandatory Fel wo Field is a List Choice list Yes E g Gender Male Female Source Default Value Default value will be provided if user does not spe Is Searchable Field e The module provides the option of defining relationships between tables by specifying foreign keys The result is that users can browse through related entities when adding or editing a record that is explicitly linked to another table For example when adding information for a person a user can browse and select the corresponding household record if the person table contains a foreign key column referring to the household primary key 9 143 STDM User Manual Tables Table relation and constraint Add relation from p t table Table Entity eee E party m Relation name party str id spatial_unit sodal_tenure_relationshit Local Column id 2 Reference table party Referenced column id On Delete action CASCADE On Update action CASCADE Column information to dispay when browsing for foreign key
89. stination table and import options Select Destination Table check monty income check previous residence check_rent check_settement_reason 5 check _sodal_tenure_type check _typ content base 5 content_roles i enumerator Overwrite Existing ccomery Colm priority respondent A browser appears This browser form allows you to compare and match the data entry columns in the imported data and those that are in the destination tables 9 Check the matching columns and make them align to each other on the same level For example the column on the Family Name on the Source table has to match with the column of the family name in the Destination Table The arrows helps you to move the columns up and down in the process of aligning them 10 Click Finish 60 143 STDM User Manual Match source and destination table columns Source Table Destination Table A pop up appears showing that the data has been imported successfully 11 Click OK to finish the task ri All features have been imported successfully Sy To add data in party record manager When adding new party data into the STDM 1 Click on the module settings button mm SG EG Ce od El ie eoo A pop up shows up 2 Select Party from the pop up 61 143 STDM User Manual 3 A party browser will appear allowing you to add any party record 4 Use the a button to add the party record
90. t to edit Delete User The user management dialog also has the option to delete an account 124 143 STDM User Manual ta Manage System Users and Roles Users SRoles J Mappings Are you sure you want to delete Stephen Once deleted this user account cannot be recovered gt 1 First select which user account to be deleted 2 Click the delete button A delete user warning appears user can confirm the delete action by clicking on the yes button to proceed This will erase the account from the user list and any roles 8 2 Role Management A role is an entity that can own database objects and have database privileges a role can be considered a user a group or both depending on how it is used 1 To manage roles on the management dialog click on the roles button circled in red below Default roles created will launch on the dialog User has an option to create new roles for the users 2 To set up a new role click on the new button on the dialog 125 143 STDM User Manual te Manage System Users and Roles 3 On the new role dialog input the name of the role and its description 4 Next click on create Role for the new role to be created Delete Role The role management dialog also has a delete option to delete a created role 1 User first selects a role to delete 2 Click on the delete button to erase the role ts Manage System Users and Roles re se to sinew
91. ta properties button is shown in the red box below Composition Item properties Data Source 5 Next place STDM data fields below the line for the name of the user signing the the template The template should now appear as shown below with all the content applied in the steps above Template arrangement may differ depending with the template s content and the users It should however be clear with all the information pertaining to the intended use of the template An alternative arrangement may be as shown below 109 143 STDM User Manual sample Residence Document Surname social tenure relatior ISSUED ON social tenure relat ISSUED BY 0 0001 O 0 00010 00020 0003 0 0004 m SS es After all the content is placed on the template user should now save the template 6 Click on the save button shown in a red box below to save the work PAE FLEO fs BS PO ifran This will prompt a name dialog where user should input the name for which to save the template with 7 Type down the name 110 143 STDM User Manual sample Residence Document 8 Click OK to save the work 9 To access a saved template on a later time click on the button on the menu bar A template selector dialog will appear with all the saved templates 7 2 Generating map document Generating a report is an important component in the STDM of disseminating information about land This informat
92. ta source list below the task pane Composition Item properties Data Field address unique_id contact_ telephone data field STDM Data Source gt lt Show tables only Show views only Using STDM database tables To use tables as source of the data for the fields defined views or tables can be loaded as follows 1 Select the data source from the available options by clicking on it 2 Then select a data field above the task pane the information selected on the data field is what will appear on the data label for the image Adding a north arrow User should place a north arrow with the maps true north i 1 Pick an arrow from the menu bar with the button and draw it facing upward for north The arrow can preferably be placed on the bottom right side of the map On placing the north arrow the template should appear more or less close to the image below Adding a signature field Here set up a signature placement below the template 1 Click on the line button to and draw a signature line below the template This can be accompanied by an STDM data field for the sign label The signature line and data fields can be resized and edited on the item properties task pane 3 To select the name to place on the data field click on the STDM data properties button and select which data source to use in the field 4 Select the data field from the list available from the data source the user selected The da
93. tdmConfig xml The rest can be created at run time Mame di Data di Reports di temp _ font cache _ stdmConfig sql stdmContig Click next on the wizard and the on entry to the next page all the settings will be saved in the registry If no further configuration is required the wizard can be closed 3 1 2 Creating profile and tables When creating Profile and Tables the Design Form wizard is used s button 1 Click on the Design Form A path setting configuration table appears 2 Click Next to continue 38 143 STDM User Manual Profiles A profile in STDM tool refers to a series Select Basic of questions to be used in a particular survey in which order of questions and responses is organized in a modular format for easier analysis and presentation within STDM Gp New Profile STOM Core Modules Profile modules tables Party can be a person household or group spatial unit or a group of spatial unit supporting_document Prove of evidence to the defined tenure a __ Relation of the person to unitas EE LETTE supported by supporting documents table to store party and spatial unit relationship id and supporting documents st_relations A profile option wizard opens with default settings To create new tables in the current profile The user needs to click on the Add button in the profi
94. the annex for more details 1 The New Profile button circled in red below enables you to create a new data profile The user is prompted to provide a profile name and a profile description in the profile editor dialog An example would be Profile Name Settlement profile Description A complete community inventory By default the basic profile is populated Learn more about Data forms here Creating new profile Creating tables attributes Creating Table relations Defining Social Tenure tables 3 1 1 Creating file paths When creating new paths in the configuration wizard if in the new paths there exist a configuration file an alert message will show to inform you that previous settings have been detected Log in p 1 Log in to the STDM Using the button 2 Click the Design Forms ibutton to open the Design Form wizard A wizard appears allowing the user to create settings and profiles Directory paths Settings path C Users Njogus stdm Change Change Source document path Document output path C Users Njogus stdm Reports Change Templates path C Users Njogus stdm Reports Templates Change In this opened Design Form wizard page the user can now create new four highlighted paths above When this form is loading it checks for previous paths that the user had set If none is found a default path in the user profile directory will be created and populated as shown above Settings path where th
95. the list 18 143 STDM User Manual connected GLTN Plugin Repository http stdm glin net olugin plugins xml qgis 2 8 a connected QGIS Official Plugin Repository http olugins ggis org plugins plugins xml qgis 2 8 e Still on the Plugins window select Not installed tab look for STDM plugin on the list of Not installed gales Select it and click os plugin e QGIS will download and install STDM plugin The plugin should now be available on the Installed tab and also on the QGIS main panel Bo Oracle Spatial GeoRaster Raster Terrain Analysis pit a Road graph plugin 3 Social Tenure Domairlifad spatial Query Plugin Bg SPIT Not installed Upgradeable settings e Click close to dismiss the dialog Now you ready to start using STDM nga 19 143 STDM User Manual 1 8 User Interface The user Interface for STDM is embedded within QGIS Main Window To access STDM QGIS Main window must be opened first STDM appears as follows in the QGIS Main Window Plugins Vector Raster Database Web MMOGIS Procedsi J AO Pep SupoWneg aA F m 5 bd g y O ese Soe SO fi po L i keh i Default view 1 STDM menu has the few command items when you are not logged in Clicking the menu from the QGIS Menu bar the following menu items appears fiep Login Help Contents M About Login Prompts you to connect to the database and access full STDM items userna
96. trative units viewer also has the option of deleting a unit 1 To do this select on an intended unit on the unit cascade and click on delete selection If the selected unit is a parent unit the delete action will erase the unit and its children unit s below it 76 143 STDM User Manual 77 143 STDM User Manual 5 Managing data Import Export 5 1 Importing Attribute Data Attribute data here refer to the non spatial data imported into the STDM database Attribute data for instance may refer to Party Records The process of data import is similar for all modules Before importing make sure that you are loged in QGIS is running and STDM tool bar is active 1 Click on the Import Data button on the STDM tool bar as shown below a IGP Si A gt Source Data Specify the location of the source file and representative data type 2 Browse to the location of file excel file in the directory 78 143 STDM User Manual source Data Specify the location of the source file and representative data type Source Dataset E Sample data Households_datarecords csv Destnation Repository Type Textual Data 3 Click Next 3 Select the destination table Destination table and import options Select Destination Table 5 admin_spatial_unit_set 5 check_document_typ 5 check_montly_income check_previous_residence check_rent Check settement_reason check social tenure_type check_type
97. types columns Geometry columns T oimne Sesspten Daa tpe iero Searchabe 1 tone aj a Primaykey se LAE 4 al Attribute editor appears as shown below for editing 3 Provide details of the on the form as follows Add Table Column Table Column Name household number Description the household unique number Column Data Type Short text Character Length Auto Increment Primary Ke Is Mandatory Field Field is a List Choice list es E g Gender Male Female Source Default Value Default value will be provided if user does not spe Is Searchable Field Yes con Table Refers to the currently selected table in which the attributes are being created Column name is the attribute name for the column in the database Should be as short as possible Description Friendly name description the attribute name Column data type this is the data type of the attribute being created Character length This refers to the longest expected length of the attribute when data is being entered in the form Auto Increment This applies to primary key Is Mandatory Field Check this if the attribute cannot be none Field is a List This enables you to select a pre defined choices or to create a list of choices where attribute value will be selected E g attribute gender may have an option of male female This is a list and can be defined in the wizard Default value this applies to the default value to be use
98. ual Importing GPX files When import GPX file button is click on the spatial unit manager Import GPX File A window is shown prompting the user to select a GPX file form their computer which will be imported Options for the currently supported formats include Waypoint Tracks and Route Feature types Waypoint Track _ Route Browse to the location of the GPX file I e In the sample data folder fi Import GPS Points File C Users Njogus Desktop sample data Waypoints_23 SEP 14 gpx Feature types Waypoint 0 Track _ Route Before clicking Ok activate layer editing option to edit mode in QGIS main window If not activated you will be prompted with the following message b Current layer is not in edit mode toogle start editing to be able to import Select your spatial unit layer in the layer panel of the qgis Click toggle layer edit mode 98 143 STDM User Manual E Import GPS Points Feature types Waypoint _ Track Route Click Ok on the import dialog Once clicked a GPX table is shown with all existing waypoints from the selected gpx file This table can be moved on the side so that you are able to see the GPX files loaded temporary to QGIS canvas before they are imported and saved to the database 99 143 STDM User Manual m pe prae 38 151847 15 217925 x pa 28 144726 15 220256 x Ee 28 104683 15 212273 26 094375 15 211497
99. unctions On the last page For first time Select Create New STDM database option to prepare your database with required changes This option clears any data in the existing schema A prompt dialog will pop up to alert you on the risk of losing any data Click Yes to continue Update existing STOM database Skip changes to database Show generated SQL file lt eack mn cance Hep Update existing STDM database is required if you are now configuring for the second time The initial changes and data will not be lost Skip changes to database will skip any changes made Show generated SOL file l Allows the user to browse and edit the SQL command generated by configuration if any error has occurred Click Finish to end configuration OK The above message will appear to inform you that the operation was successful At this level you need to logout Log Out To log out of the QGIS wizard you must be logged in Click the logout button logs you out of the STDM system and the STDM command buttons disappears This immediately Then login again so that changes can be effective To check everything went fine you need to load any of the modules e Goto STDM Menu e Select Modules e Select Party STDM User Manual Design Forms Admin Settings Social Tenure Relati Manage Administrative Units E Import Data E Export Data
100. uration wizard The core modules are person party spatial unit social tenure relationship and supporting documents 28 143 STDM User Manual Profile Options Set Modify Data Collection Levels Profiles Profiles A profile in STDM tool refers to a series of questions to be used in a particular survey in which order of questions and responses is organized in a modular format for easier analysis and presentation within STDM Profile modules tables Name al party Party can be a person household or group a spatial_unit spatial unit or a group of spatial unit supporting document Prove of evidence to the defined tenure social_tenure_relationship eae bal e E to spatial unit as supported by str_relations table to store party and spatial unit relationship id and supporting documents At this level the user has option of adding addition profile tables to the basic tables as shown above For the purpose of this exercise customizing profile will be skipped If you need to customize at this level go to Customizing for new profile 6 To proceed to the next page click Next The page below will appear 29 143 STDM User Manual Data Forms customization Add or Edit Fields Columns For Each Module Tables Table relation and constraint Basic data types columns Geometry columns spatial_unit M me Description Description j Data type Length socdal_tenure_relationship ae ed
101. us schema will be deleted Update existing STDM database 2 The allows you to update and save changes if the database was created and you were making some changes Skip changes to database 3 The allows you to skip making changes or updates to your database Show generated SOL file 4 The allows you to display the SQL file and you can also make changes from the SQL file in case there is an error when executing the database 56 143 Create new STOM database 4 Check on the circle A warning pop up appears to indicating that the selection will erase any previous data To continue with new changes click yes 6 Click Finish to end the process A confirmation of new changes made will pop up Restart QGIS for the new changes to be effective STDM User Manual 4 Data Management Working with Modules While working and managing the STDM modules make sure QGIS is started and running while STDM is visible in QGIS interface tool bar Each module has a browser that loads any existing data from the database and also sets data management sessions where you can add edit or deleted existing records 4 1 Managing Party Module Party may refers to a person group or an organization that has unique characteristics and their relationship to a spatial unit can be explicitly defined For the purposes of this documentation party here refers to a person Importing new Party Data When importing new party data into the STDM make sure that the
102. wish to generate report form 115 143 STDM User Manual Party p Socal Tenure Relationship Available attributes from the selected table module displays 3 Select the attributes that you would wish to be displayed on the report and in the order you want them to appear Report Contents Fields Available Fields date_of birth id family_ name other_names gender address contact_telephone identification 4 Using forward button click to push the selected columns to report fields panel Report Fields family_name other_names gender address contact_ telephone identification The selected attribute moves to the report fields Do this for every other attribute you wish it to appear in the report At this point if there is no customization is required to the final report 7 Click SAVE to browse to where you would like to store your report files Destination 116 143 STDM User Manual File name We a Save as type 5TDM Report trs 8 Click Generate report A notification pops up showing the user that the report has been created successfully in the specified folder at The report has been successfully created and written to WP c Users PATOE Household_Report pdf 9 Click OK to finish Customizing report Fields Fiter Grouping Sorting Display Entity Party hs i a Report Contents Fields Available Fields Report Fields dat
103. wn arrow of the combo box Basic Basic settement profile e The table module view area is empty as you have not defined any module or table The button in the module section to prompt you to input the table name and the table description This information will provide a basis upon which columns for the table will be created For purposes of the example provided above Table Name Settlement households Description Number of families in the settlement 40 143 STDM User Manual Profiles A profile in STDM tool refers to a series Select of questions to be used in a particular survey in which order of questions and responses is organized in a modular A complete community inventory format for easier analysis and presentation within STDM Gia New Profile EJ Delete Selected Profile modules tables Actions Table Editor Table Name Settlement households Description Number of families in the settlement P Auto create default column with primary key Inherit columns from another table Ensure Auto create default column with primary key is checked Check Inherit columns from another table if you would like to fetch columns from another table with similar properties The table must be within the same profile Click OK to create a table Additional tables can be added in the same manner as above
104. ws XP Windows Vista or Windows 7 Windows 8 Linux Based e Debian Ubuntu Fedora Red Hat openSUSE Hardware requirements e Atleast 2GB of RAM e Atleast 2GB free disk space e 1024x768 screen resolution or higher 1 5 What to know before installing 1 5 1 What do I need to install to have a fully functional STDM In the provided installation package there are there core component of software packages that are mandatory for installation for STDM to work properly The following need to be installed e Quantum GIS current version 2 8 2 e PostgreSQL current version 9 4 2 e PostGIS current version 2 1 7 Sample data is optional if you want to have a sample data to manipulate and test features of STDM 1 5 2 Do I need to uninstall previous installation of the above software This is not necessary especially if you are working with QGIS 2 6 or higher and postgres 8 4 or higher In this case you need to do the following e Start QGIS normally and wait for it to load e Download the latest version of STDM plugin from github https github com gltn stdm by adding STDM download repository in the QGIs Plugin manager see instructions here Download From repository e Using postgreSQL database browser i e pgadmin create a new database called stdm e Within stdm database create postgis extension e On the QGIS window check if STDM is enable on the menu and toolbar iy e Delete previous config files in the the working directory e
105. y P Series Properties Advanced Filtering in the Document Generator e Entities can now be selected by using filter expressions through an expression dialog that enables users to specify SQL like statements to filter items 7 148 more chart types will be added in the next major release STDM User Manual ie Document Generator Click on the plus butt Filter By Expression Party Spatial Function list _ 4 OMH Selected function help TIG Search Field cs eee E String Double click to add field name to expression El Color string Geometry i l E Record Right Click on field name to open context HF TimeManager ooo az i Field values MM El Fields and Values ara vid Kandara Road family_name NULL Use matchingrec kontact telephone Template ear of bith g o marital_status Load values Ww Operators Output Type Export as Imac Export as PDF Write to output fi Output Document Select the fields w _ Address Contact telepi Family name Output preview 0 Gender Household id Identification Marital status 1 2 4 Designing Data Forms The data forms design module has been greatly enhanced that screenshots only will not do it justice e The module has been stabilized and provides more friendly messages during the design process e When specifying the columns of a table users have the options of specifying which field
106. ying about the background activities Procedure for configuration 1 Click on the STDM plugin menu and select Design Forms or Press F7 to launch the wizard A splash screen will appear 2 Click Next to proceed Z Wizard eed carefully before you proceed GHU GENERAL PUBLIC LICENSE Version June 1997 Copyright C 1989 1391 Free Software Foundation Inc 51 Franklin Street Fifth Floor Boston MA 02110 1301 USA Everyone is permitted to copy and distribute verbatim copies of this license document but changing it is not allowed Preamble The licenses for most software are designed to take away your freedom to share and change it By contrast the GNU General Public License is intended to quarantee your freedom to share and change free software to make sure the software is free for all its users This General Public License applies to most of the Free Software Foundation s software and to any other program whose authors commit to using it Some other Free Software Foundation software is covered by the GNU Lesser General Public License instead You can apply it to your programs too When we speak of free software we are referring to freedom not price Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software and charge for this service if you wish that

STDM User Manual - Social Tenure Domain Model

Contents

Download Pdf Manuals

Related Search

Related Contents