TheocBase/TheocBase

Click on the <strong>Browse</strong> button and select a filename.

Under <strong>Select fields to export and their export options</strong> check the following fields:

Edit the <strong>Datasource Options</strong>

Click <strong>OK</strong> to save the KML file.

Choose <strong>File</strong> as <strong>Vector Source Type</strong>.

Choose the <strong>CRS</strong> (Coordinate Reference System): <strong>EPSG:4326</strong>.

Working with the Territory Data in a Geographic Information System (GIS)

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.

<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><!-- Field name: -->territory_number<!-- Don't translate this. --></span><br><span><!-- Field name: -->locality<!-- Don't translate this. --></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>

Click the <img src="../images/street_add_24x24.png" alt="" width="24" height="24" /> button on the <strong>Streets</strong> tab to add a new row in the street list box.

Click on the <strong>Type</strong> field and select the <a href="settings_territories.html#streets">type of the street</a>.

Click the <img src="../images/street_remove_24x24.png" alt="" width="24" height="24" /> button on the <strong>Streets</strong> tab to remove the street.

The <strong>Add streets</strong> dialog displays the streets within the territory's boundary. Uncheck the field <strong>Hide already added streets</strong> to see the complete list.

It is mandatory to <a href="territories_view_edit.html#import_territory_boundaries">add a territory boundary</a> first, before this feature can be used.

Tip:

Enter a street name in the <strong>search</strong> field in order to quickly find a specific street.

Select the check boxes next to the streets you want to add. Click on the column header to select all at once.

Edit the <a href="#edit_territory_attributes">territory attributes</a> of the selected territory [4].