Geoconnect
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
How to use Geoconnect
2
Welcome to the "new" Geoconnect! Geoconnect is a harmonized
crowd sourced database for district geography for
Neglected Tropical Diseases in over 80 countries.

This database was formerly managed by the team at
Standard Co, a global health data platform designed to simplify
the collection, management, and analysis of data for global health
programs.

Effective October 1st, 2020, this database has been moved to this
google sheet where it is managed by the NTD community.

Below are instructions for how to manage commont requests.

Updating this file
This file was designed to let a group of NTD experts (who have
read/write permission on this file) to update it themselves. There are two tabs in this file of note: All Districts and Change log:
All districts -- this contains active and inactive districts! Looking for a admin0, admin1, admin2, or admin3? Look here
Change log -- any updates made to this file should be captured here!
You will note that we discourge removing any data from this file. When you delete, merge, or split a district
you should update the status of the old district to 0. This allows us to track both currently active districts
as well as historical districts

Creating new IDs
Most of the changes to this file will require the creation
of a new ID (admin1, admin2, geo_id, etc). To create a
new ID All IDs (geo_id, admin1_id, admin2_id, admin3_id )
are created following the same pattern, which is the check the
system for the highest ID number for that type, and add 1 to it.

Adding a new district
Add a row, fill out the name. Then follow the ID creation pattern.

Splitting a district
- When a district is 'Split', that district is marked 'inactive', which means that the column 'status' is updated from 1 to 0.
- New districts are created for each district that the original district is split into. Follow the ID creation pattern for setting IDs on these newly created districts.
- The subdistricts of the original district need to be redistributed between the new districts that result from the split.
Edit each row of the subdistricts so that they belong to the new districts. This typically means editing the admin IDs and names of parent districts.

Merging a district
Add a row, fill out the name. Then follow the ID creation pattern.

Deleting a district
Update the row of the district by marking the column 'status' to 0.
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...