TheocBase/TheocBase
-
aa7afb6cafe14e28350d7d0e331c0105854c2a14
aa7afb6cafe14e28350d7d0e331c0105854c2a14
Working with the Territory Data in a Geographic Information System (GIS) -
bc84ed667ea0688249dae6acf5458de669d0d587
bc84ed667ea0688249dae6acf5458de669d0d587
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. -
af1821a5b5b1b4f63b85fde3533a38e3e9b2f4d5
af1821a5b5b1b4f63b85fde3533a38e3e9b2f4d5
<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>
-
c6b137b609e576ef7637e00de548c26c94d3ad25
c6b137b609e576ef7637e00de548c26c94d3ad25
<span><!-- Field name: -->
territory_number<!-- Don't translate this. --></span><br><span><!-- Field name: -->
locality<!-- Don't translate this. --></span>
-
ad6958f2b433b631732a81e01a91446e4c02709a
ad6958f2b433b631732a81e01a91446e4c02709a
<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>
-
59653c3d5bd7be70bcfc0f25c0a85affacda3f31
59653c3d5bd7be70bcfc0f25c0a85affacda3f31
Territories - Streets -
Anyigbãmamawo
Anyigbãmamawo
Territories -
5e3f3630ee59095b4c3b3d934804c2f5f3495230
5e3f3630ee59095b4c3b3d934804c2f5f3495230
Add Streets -
641490bd7aded4ce84490189127a12247de8f575
641490bd7aded4ce84490189127a12247de8f575
Select a territory. -
b1f34319835be88d657b6220cfdc4b3cd430dcf7
b1f34319835be88d657b6220cfdc4b3cd430dcf7
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. -
83423c198b6099edba08f185f940042d5dba3b79
83423c198b6099edba08f185f940042d5dba3b79
Note: -
7faa8887f254008e45d5542e37530b53dac39c51
7faa8887f254008e45d5542e37530b53dac39c51
Click on the<strong>
OK</strong>
button. -
d6af8ff27b022cd7abf2d3cd6c67a080e7142e40
d6af8ff27b022cd7abf2d3cd6c67a080e7142e40
Edit a Street -
05a5774fda1ae9b8849702e5e4580ab3dfa369bc
05a5774fda1ae9b8849702e5e4580ab3dfa369bc
Switch to the<strong>
Streets</strong>
tab. -
e17235b94cb153fc1364d1bd833dad86fa45ba51
e17235b94cb153fc1364d1bd833dad86fa45ba51
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. -
d8ff424a88d29adc6c3287ce0c2796449ae3fb4a
d8ff424a88d29adc6c3287ce0c2796449ae3fb4a
Click on the<strong>
Type</strong>
field and select the<a href="settings_territories.html#streets">
type of the street</a>
. -
b4420c4afad2160960f7e7a1782e563b682a351f
b4420c4afad2160960f7e7a1782e563b682a351f
Zoom to a Street -
69f68300167ac428feaecf7ff1f270af84d929ab
69f68300167ac428feaecf7ff1f270af84d929ab
Double-click a street in the street list box on the<strong>
Streets</strong>
tab. -
95696620f9ec8cb305add8c497a2f7fb36f8d810
95696620f9ec8cb305add8c497a2f7fb36f8d810
Switch to the<strong>
Map</strong>
tab. -
a87672a240952e18d235bd721a13f7b04751841d
a87672a240952e18d235bd721a13f7b04751841d
The map is refreshed and displays the selected street in the center.