TheocBase/TheocBase

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

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 in the <strong>Name</strong>, <strong>From</strong>, <strong>To</strong> or <strong>Quantity</strong> field of the street and edit the corresponding value.

In the <strong>Match KML Fields</strong> box choose the fields that correspond to the <strong>Name</strong> and <strong>Description</strong> of a territory in the KML-file.

Use the option <strong>Search by "Description" if territory is not found by "Name"</strong> to include the <strong>Description</strong> field also in the search.

Edit the territory <a href="territories_assignments.html">assignments</a>, <a href="territories_streets.html">streets</a> and <a href="territories_addresses.html">addresses</a> [6].

Click along the corners of the territory area in the map. The new territory area is displayed in red.

Zoom in and snap to the corners of a neighboring territory to avoid holes between them. As you move the mouse close to a point of the boundary, the cursor signals when snapping is possible.

The map is refreshed and displays the streets according to the current setting.

You can join two territories. The boundary, streets and addresses of one territory will be be added to another, while the territory itself and its assignment record will be maintained and can be removed later if necessary.

Select the territory in the territory list box or in the map to which you want to join another territory.

Assign the <strong>Name</strong> field only if it is distinctive.

Use this option only if <strong>Description</strong> is distinctive.

Working with GIS

Click the <img src="../images/territory_check_out_24x24.png" alt="" width="24" height="24" /> button on the <strong>Assignments</strong> tab to add a new row in the assignments table.

Click on the <strong>Request date</strong> field and enter a date, e.g. the date of a "Do not call"-request.

Enter the <strong>Type number</strong> and <strong>Name</strong> in the <strong>Address types</strong> field.