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.
- Open or create a new project in QGIS.
- Select the menu item Layer>Add Layer>Add Vector Layer...
- Choose File as Vector Source Type.
- Click on the Browse button and select the "theocbase.sqlite" file.
- Click on the Add button.
- Select the layers you want to use in QGIS:
territory: for editing boundaries
territories: for viewing and analyzing the territories
territory_address: for editing addresses
territoryaddresses: for viewing and analyzing the addresses
territory_street: for editing streets
territorystreets: for viewing and analyzing the streets
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 OK button.
- Right click the layer you want to export and select Export>Save Features As...
- In the Format field choose Keyhole Markup Language [KML].
- Click on the Browse button and select a filename.
- Choose the CRS (Coordinate Reference System): EPSG:4326.
- Under Select fields to export and their export options check the following fields:
- Edit the Datasource Options:
Enter "locality" next to DescriptionField.
Enter "territory_number" next to NameField.
- Click OK to save the KML file.