TheocBase/Test
-
The TheocBase SQLite database can be opened in a GIS software that allows users to analyze or combine the data with other sources e.g. create high quality maps for the Kingdom Hall. In the following instructions QGIS is used, a multi-platform GIS available for free, but other programs may be used similarly.
The TheocBase SQLite database can be opened in a GIS software that allows users to analyze or combine the data with other sources e.g. create high quality maps for the Kingdom Hall. In the following instructions QGIS is used, a multi-platform GIS available for free, but other programs may be used similarly.
Parent Translation in en - English:The TheocBase SQLite database can be opened in a GIS software that allows users to analyze or combine the data with other sources e.g. create high quality maps for the Kingdom Hall. In the following instructions QGIS is used, a multi-platform GIS available for free, but other programs may be used similarly.
-
Add Territory Layers to a QGIS Project
Add Territory Layers to a QGIS Project
Parent Translation in en - English:Add Territory Layers to a QGIS Project
-
Open or create a new project in QGIS.
Open or create a new project in QGIS.
Parent Translation in en - English:Open or create a new project in QGIS.
-
Select the menu item <strong>Layer>Add Layer>Add Vector Layer...</strong>
Select the menu item
<strong>Layer>Add Layer>Add Vector Layer...</strong>Parent Translation in en - English:Select the menu item
<strong>Layer>Add Layer>Add Vector Layer...</strong> -
Choose <strong>File</strong> as <strong>Vector Source Type</strong>.
Choose
<strong>File</strong>as<strong>Vector Source Type</strong>.Parent Translation in en - English:Choose
<strong>File</strong>as<strong>Vector Source Type</strong>. -
Click on the <strong>Browse</strong> button and select the "theocbase.sqlite" file.
Click on the
<strong>Browse</strong>button and select the "theocbase.sqlite" file.Parent Translation in en - English:Click on the
<strong>Browse</strong>button and select the "theocbase.sqlite" file. -
Click on the <strong>Add</strong> button.
Click on the
<strong>Add</strong>button.Parent Translation in en - English:Click on the
<strong>Add</strong>button. -
<span>Select the layers you want to use in QGIS:</span> <br><span><strong><!-- Table name: -->territory<!-- Don't translate this. --></strong>: for editing boundaries</span> <br><span><strong><!-- Table name: -->territories<!-- Don't translate this. --></strong>: for viewing and analyzing the territories</span> <br><span><strong><!-- Table name: -->territory_address<!-- Don't translate this. --></strong>: for editing addresses</span> <br><span><strong><!-- Table name: -->territoryaddresses<!-- Don't translate this. --></strong>: for viewing and analyzing the addresses</span> <br><span><strong><!-- Table name: -->territory_street<!-- Don't translate this. --></strong>: for editing streets</span> <br><span><strong><!-- Table name: -->territorystreets<!-- Don't translate this. --></strong>: for viewing and analyzing the streets</span>
<span>Select the layers you want to use in QGIS:</span><br><span><strong><!-- Table name: -->territory<!-- Don't translate this. --></strong>: for editing boundaries</span><br><span><strong><!-- Table name: -->territories<!-- Don't translate this. --></strong>: for viewing and analyzing the territories</span><br><span><strong><!-- Table name: -->territory_address<!-- Don't translate this. --></strong>: for editing addresses</span><br><span><strong><!-- Table name: -->territoryaddresses<!-- Don't translate this. --></strong>: for viewing and analyzing the addresses</span><br><span><strong><!-- Table name: -->territory_street<!-- Don't translate this. --></strong>: for editing streets</span><br><span><strong><!-- Table name: -->territorystreets<!-- Don't translate this. --></strong>: for viewing and analyzing the streets</span>Parent Translation in en - English:<span>Select the layers you want to use in QGIS:</span><br><span><strong><!-- Table name: -->territory<!-- Don't translate this. --></strong>: for editing boundaries</span><br><span><strong><!-- Table name: -->territories<!-- Don't translate this. --></strong>: for viewing and analyzing the territories</span><br><span><strong><!-- Table name: -->territory_address<!-- Don't translate this. --></strong>: for editing addresses</span><br><span><strong><!-- Table name: -->territoryaddresses<!-- Don't translate this. --></strong>: for viewing and analyzing the addresses</span><br><span><strong><!-- Table name: -->territory_street<!-- Don't translate this. --></strong>: for editing streets</span><br><span><strong><!-- Table name: -->territorystreets<!-- Don't translate this. --></strong>: for viewing and analyzing the streets</span> -
Caution:
Caution:
Parent Translation in en - English:Caution:
-
When editing the geometry in a third party tool like QGIS, TheocBase will not be aware of the changes during cloud syncing. In order to upload the changes you need to mark the territories as edited e.g. add a blank in the remark field. Alternatively you can also export the territories into a KML file and reimport this file in TheocBase.
When editing the geometry in a third party tool like QGIS, TheocBase will not be aware of the changes during cloud syncing. In order to upload the changes you need to mark the territories as edited e.g. add a blank in the remark field. Alternatively you can also export the territories into a KML file and reimport this file in TheocBase.
Parent Translation in en - English:When editing the geometry in a third party tool like QGIS, TheocBase will not be aware of the changes during cloud syncing. In order to upload the changes you need to mark the territories as edited e.g. add a blank in the remark field. Alternatively you can also export the territories into a KML file and reimport this file in TheocBase.
-
Add the layers by clicking on the <strong>OK</strong> button.
Add the layers by clicking on the
<strong>OK</strong>button.Parent Translation in en - English:Add the layers by clicking on the
<strong>OK</strong>button. -
Export into a KML File
Export into a KML File
Parent Translation in en - English:Export into a KML File
-
Right click the layer you want to export and select <strong>Export>Save Features As...</strong>
Right click the layer you want to export and select
<strong>Export>Save Features As...</strong>Parent Translation in en - English:Right click the layer you want to export and select
<strong>Export>Save Features As...</strong> -
In the <strong>Format</strong> field choose <strong>Keyhole Markup Language [KML]</strong>.
In the
<strong>Format</strong>field choose<strong>Keyhole Markup Language [KML]</strong>.Parent Translation in en - English:In the
<strong>Format</strong>field choose<strong>Keyhole Markup Language [KML]</strong>. -
Click on the <strong>Browse</strong> button and select a filename.
Click on the
<strong>Browse</strong>button and select a filename.Parent Translation in en - English:Click on the
<strong>Browse</strong>button and select a filename. -
Choose the <strong>CRS</strong> (Coordinate Reference System): <strong>EPSG:4326</strong>.
Choose the
<strong>CRS</strong>(Coordinate Reference System):<strong>EPSG:4326</strong>.Parent Translation in en - English:Choose the
<strong>CRS</strong>(Coordinate Reference System):<strong>EPSG:4326</strong>. -
Under <strong>Select fields to export and their export options</strong> check the following fields:
Under
<strong>Select fields to export and their export options</strong>check the following fields:Parent Translation in en - English:Under
<strong>Select fields to export and their export options</strong>check the following fields: -
<span><!-- Field name: -->territory_number<!-- Don't translate this. --></span><br><span><!-- Field name: -->locality<!-- Don't translate this. --></span>
<span><!-- Field name: -->territory_number<!-- Don't translate this. --></span><br><span><!-- Field name: -->locality<!-- Don't translate this. --></span>Parent Translation in en - English:<span><!-- Field name: -->territory_number<!-- Don't translate this. --></span><br><span><!-- Field name: -->locality<!-- Don't translate this. --></span> -
Edit the <strong>Datasource Options</strong>
Edit the
<strong>Datasource Options</strong>Parent Translation in en - English:Edit the
<strong>Datasource Options</strong> -
<span>Enter "<!-- Field name: -->locality<!-- Don't translate this. -->" next to <strong>DescriptionField</strong>.</span><br><span>Enter "<!-- Field name: -->territory_number<!-- Don't translate this. -->" next to <strong>NameField</strong>.</span>
<span>Enter "<!-- Field name: -->locality<!-- Don't translate this. -->" next to<strong>DescriptionField</strong>.</span><br><span>Enter "<!-- Field name: -->territory_number<!-- Don't translate this. -->" next to<strong>NameField</strong>.</span>Parent Translation in en - English:<span>Enter "<!-- Field name: -->locality<!-- Don't translate this. -->" next to<strong>DescriptionField</strong>.</span><br><span>Enter "<!-- Field name: -->territory_number<!-- Don't translate this. -->" next to<strong>NameField</strong>.</span>