TheocBase/TheocBase

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.

Switch to the <strong>Streets</strong> tab.

Click in the <strong>Name</strong>, <strong>From</strong>, <strong>To</strong> or <strong>Quantity</strong> field of the street and edit the corresponding value.

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

Double-click a street in the street list box on the <strong>Streets</strong> tab.

Switch to the <strong>Map</strong> tab.

The map is refreshed and displays the selected street in the center.