United Nations Technical Meeting on Use of Technology in Population and Housing Censuses
undefined
Session 5
Plans and Preparations
U
n
i
t
e
d
N
a
t
i
o
n
s
T
e
c
h
n
i
c
a
l
M
e
e
t
i
n
g
o
n
U
s
e
o
f
T
e
c
h
n
o
l
o
g
y
i
n
P
o
p
u
l
a
t
i
o
n
a
n
d
H
o
u
s
i
n
g
C
e
n
s
u
s
e
s
A
m
m
a
n
,
J
o
r
d
a
n
28
t h
- 1
st
December 2016
Statistic
s Estonia
Diana Beltadze
UNECE meeting in Amman 2016
T
i
m
e
t
a
b
l
e
o
f
P
o
p
u
l
a
t
i
o
n
a
n
d
H
o
u
s
i
n
g
C
e
n
s
u
s
2
0
1
1
2
0
1
2
-
2
0
1
3
P
o
s
t
-
e
n
u
m
e
r
a
t
i
o
n
a
c
t
i
v
i
t
i
e
s
3
1
.
1
2
.
2
0
1
1
-
3
1
.
0
3
.
2
0
1
2
E
n
u
m
e
r
a
t
i
o
n
3
1
.
1
2
.
2
0
0
9
-
3
1
.
0
3
.
2
0
1
0
P
i
l
o
t
T
e
s
t
i
n
g
v
a
r
i
o
u
s
a
s
p
e
c
t
s
o
f
c
e
n
s
u
s
p
l
a
n
a
n
d
p
r
o
c
e
d
u
r
e
s
2
0
0
7
-
2
0
1
1
P
r
e
-
e
n
u
m
e
r
a
t
i
o
n
a
c
t
i
v
i
t
i
e
s
UNECE meeting in Amman 2016
UNECE meeting in Amman 2016
T
r
a
i
n
i
n
g
A 5-
day training for district chiefs
and
supervisors
(
15+132
)
;
A
5
-
day training for census
takers
(2,200).
G
o
a
l
s
o
f
t
h
e
i
n
f
o
r
m
a
t
i
o
n
s
y
s
t
e
m
Universal software useable in all surveys
Improve the coverage of studies
Improve quality of raw data
Improve efficiency of field work management
Reduce data collection cost
Increase speed of post-collection data processing
UNECE meeting in Amman 2016
D
e
s
c
r
i
p
t
i
o
n
o
f
t
h
e
a
p
p
l
i
c
a
t
i
o
n
s
Questionnaire definition tool
Enumerators application
E-respondent application
Management application
E-respondent map application
Management map application
Enumerators map application
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
H
i
g
h
l
e
v
e
l
v
i
e
w
o
f
t
h
e
i
n
v
o
l
v
e
d
a
p
p
l
i
c
a
t
i
o
n
s
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
E
-
c
e
n
s
u
s
d
a
t
a
c
o
l
l
e
c
t
i
o
n
p
r
o
c
e
s
s
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
L
i
v
e
e
n
v
i
r
o
n
m
e
n
t
6 physical (12 virtual) Oracle Weblogic Java application servers
2 Oracle physical database servers
Apache load balancers
ESRI GIS server
Check Point firewall and VPN software
SAS and VAIS data processing servers
Suse Linux Enterprise and MS Windows operating systems
used in servers
MS Windows XP operating system used for enumerators
laptops
Mainly Hewlet Packard hardware used
UNECE meeting in Amman 2016
UNECE meeting in Amman 2016
E
x
t
e
r
n
a
l
r
e
s
o
u
r
c
e
s
META data database
Active Directory
Statistical database
GIS database
UNECE meeting in Amman 2016
I
T
s
e
c
u
r
i
t
y
IT security analyzes (2008)
IT security analyzes and complete testing (2010)
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
I
T
r
e
l
a
t
e
d
r
i
s
k
s
Data leakage
Attacks against IT solutions
Load tolerance is not sufficient
Failures of software
Data loss
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
D
a
t
a
p
r
o
t
e
c
t
i
o
n
Operations with sensitive data are logged
Separate log tables and special rights in
management system and enumerators application
Hard drive encryption in enumerator’s computer
Database encryption and high availability
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
H
a
r
d
w
a
r
e
a
n
d
s
o
f
t
w
a
r
e
p
u
r
c
h
a
s
e
s
Cost efficiency analyzes (laptops)
Load tolerance evaluation (servers)
Later use of hardware and software
UNECE meeting in Amman 2016
P
r
e
p
a
r
a
t
i
o
n
o
f
h
a
r
d
w
a
r
e
Servers and other peripherals
were shipped in April 2011, laptops in Sept-Oct 2011
External partners were used
Secure VPN connection between two physical
locations created
1979 code lines used in personalization script.
About 26,4 computers per day was prepared on a
assembly line
Live sample downloaded during the fieldwork
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
UNECE meeting in Amman 2016
L
o
a
d
t
o
l
e
r
a
n
c
e
t
e
s
t
i
n
g
Tests were done between 2009-2012
Test requirements (Live environment)
E-respondents application - 2500 parallel
sessions
Enumerators application – 2000 parallel
sessions
Emulating robots used
Testing lasted about 9 months (Live environment)
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
L
o
a
d
t
o
l
e
r
a
n
c
e
t
e
s
t
i
n
g
p
r
o
c
e
s
s
>2500 sessions - personal computers
2500 - 5000 sessions – Amazon cloud
5000 - 7500 sessions – Estonian Information
Systems Authority’s servers
UNECE meeting in Amman 2016
I
T
s
u
p
p
o
r
t
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
T
h
e
a
v
e
r
a
g
e
t
i
m
e
f
o
r
f
u
l
f
i
l
l
i
n
g
p
e
r
s
o
n
a
l
q
u
e
s
t
i
o
n
n
a
i
r
e
UNECE meeting in Amman 2016
M
a
a
i
l
m
a
r
e
k
o
r
d
i
s
ü
n
d
l
ä
b
i
r
a
h
v
a
-
j
a
e
l
u
r
u
u
m
i
d
e
l
o
e
n
d
u
s
e
e
-
l
a
h
e
n
d
u
s
e
UNECE meeting in Amman 2016
A
u
t
h
e
n
t
i
c
a
t
i
o
n
c
h
a
n
n
e
l
s
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
H
o
u
r
l
y
s
t
a
t
i
s
t
i
c
s
UNECE meeting in Amman 2016
F
e
a
r
s
a
n
d
p
r
o
b
l
e
m
s
d
u
r
i
n
g
E
-
c
e
n
s
u
s
E-census environment becomes unavailable
System load is too high, people quit
Enumerators computers don’t get
ready in time
Security problems stop E-census
Problems downloading Live sample
Training fails
Fieldworks are getting delayed
UNECE meeting in Amman 2016
G
o
o
d
d
e
c
i
s
i
o
n
s
Information system for general service
Sizable load tolerance tests
Buying out laptops used by the enumerators
Outsourcing information system maintenance
Tachometer for indicating system load
UNECE meeting in Amman 2016
S
u
b
s
e
q
u
e
n
t
k
n
o
w
l
e
d
g
e
It’s all about testing
Pilots as real as possible
Hire more people for longer period
Buy experience, because there’s no time to
experiment and learn
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
C
r
i
t
i
c
a
l
c
o
m
p
e
t
e
n
c
e
s
System architect
A moderator between software development and
maintenance team
UNECE meeting in Amman 2016
H
a
r
d
w
a
r
e
I
n
f
r
a
s
t
r
u
c
t
u
r
e
Oracle Weblogic J2EE server
LIVE
cluster
2 physical server nodes (Linux)
Load balancer (Apache)
Oracle Database server
1 physical server (Linux)
Cold standby (Linux)
Interviewers computers (Acer One netbooks)
Mobile internet connection modems
Portable GPS receivers
UNECE meeting in Amman 2016
P
r
e
p
a
r
a
t
i
o
n
o
f
h
a
r
d
w
a
r
e
Interviewers computers
Windows XP operating system with last updates
Forbidden hardware for non working purposes
Webcam
USB/MMC storage
Wi-Fi/LAN
UNECE meeting in Amman 2016
P
r
e
p
a
r
a
t
i
o
n
o
f
h
a
r
d
w
a
r
e
(
c
o
n
t
i
n
u
e
s
)
Interviewers computers
Forbidden functionality for non working purposes
Local computer and registry
BIOS password protection, denial of bootable removable
storage
Web traffic limitations
Forbidden access to control panel functionality
Forbidden access to hidden files
Hibernate in case of closing the lid
UNECE meeting in Amman 2016
P
r
e
p
a
r
a
t
i
o
n
o
f
h
a
r
d
w
a
r
e
(
c
o
n
t
i
n
u
e
s
)
Interviewers computers
Forbidden functionality for non working purposes
Domain Policy
Screen saver with password prompt in case of an idle
Interviewer only specific VPN rules
UNECE meeting in Amman 2016
P
r
e
p
a
r
a
t
i
o
n
o
f
h
a
r
d
w
a
r
e
(
c
o
n
t
i
n
u
e
s
)
Interviewers computers
Forbidden functionality for non working purposes
Domain Policy
Screen saver with password prompt in case of an idle
Interviewer only specific VPN rules
UNECE meeting in Amman 2016
P
r
e
p
a
r
a
t
i
o
n
o
f
h
a
r
d
w
a
r
e
(
c
o
n
t
i
n
u
e
s
)
Interviewers computers
Personalization
True Crypts default password change
Delicate data folders access rights
Hiding the delicate data folders
Verification
True Crypt and Active Directory passwords
VPN connection
Interviewers application load, update and
synchronization
UNECE meeting in Amman 2016
S
e
c
u
r
i
t
y
o
f
d
a
t
a
Passwords
One password for everything
Predefined and unchangeable passwords
True Crypt password changed and stored in the
process of personalization
Active Directory authentication for Windows logon
and web applications
UNECE meeting in Amman 2016
S
e
c
u
r
i
t
y
o
f
c
o
m
p
u
t
e
r
s
Fully encrypted hard drive
HTTP/SFTP connection inside encrypted VPN tunnel
UNECE meeting in Amman 2016
P
h
y
s
i
c
a
l
s
e
c
u
r
i
t
y
Servers
Access protected server rooms
Interviewers computer
Based on interviewers training
Handle personal passwords
Protect computer in bad we
at
her conditions
Act in case of robbery or computer loss
Handle unauthorized use
of computer
UNECE meeting in Amman 2016
I
T
-
a
r
c
h
i
t
e
c
t
u
r
e
,
s
e
c
u
r
i
t
y
,
h
a
r
d
w
a
r
e
a
n
d
C
e
n
s
u
s
O
u
r
p
a
r
t
n
e
r
s
UNECE meeting in Amman 2016
D
u
r
i
n
g
c
e
n
s
u
s
s
p
a
t
i
a
l
-
a
n
d
a
t
t
r
i
b
u
t
e
d
a
t
a
w
e
r
e
r
e
n
e
w
e
d
t
h
r
o
u
g
h
e
n
u
m
e
r
a
t
o
r
’
s
m
a
p
a
p
p
l
i
c
a
t
i
o
n
E
n
u
m
e
r
a
t
o
r
’
s
t
a
s
k
s
:
R
e
n
e
w
i
n
g
o
f
e
x
i
s
t
i
n
g
b
u
i
l
d
i
n
g
s
a
t
t
r
i
b
u
t
e
s
-
t
h
e
t
y
p
e
a
n
d
c
o
n
d
i
t
i
o
n
o
f
t
h
e
b
u
i
l
d
i
n
g
A
d
d
n
e
w
h
o
u
s
e
s
t
o
m
a
p
a
n
d
a
d
d
t
h
e
i
r
t
y
p
e
a
n
d
c
o
n
d
i
t
i
o
n
UNECE meeting in Amman 2016
T
h
e
m
a
p
d
a
t
a
o
n
E
n
u
m
e
r
a
t
o
r
’
s
m
a
p
a
p
p
l
i
c
a
t
i
o
n
Raster data (1:1 - 1:25 000):
Ortophoto – from Estonian Land Board OR
Base Map – topographic data from Estonian Land
Board, cartographic work from eGEOStat project –
Statistics Estonia
UNECE meeting in Amman 2016
T
h
e
m
a
p
d
a
t
a
o
n
E
n
u
m
e
r
a
t
o
r
’
s
m
a
p
a
p
p
l
i
c
a
t
i
o
n
Vector data (1:1 – ...)
District borders
Building numbers from ADS
Cadastral parcels (for agricultural census)
Administrative borders
Bus stops
Topographic data (roads, rivers, forests, etc.)
UNECE meeting in Amman 2016
E
n
u
m
e
r
a
t
o
r
’
s
m
a
p
a
p
p
l
i
c
a
t
i
o
n
b
u
i
l
d
i
n
g
d
a
t
a
u
p
d
a
t
e
Data syncronisation
The XY coordinates of new buildings and the type
and condition of buildings is sent through secure
VPN with GPRS connection to the Statistics Estonia
server.
This takes place together with the census data
syncronisation
UNECE meeting in Amman 2016
E
-
c
e
n
s
u
s
m
a
p
a
p
p
l
i
c
a
t
i
o
n
Every citizen can come to our web page and e-
count themselves.
They search and choose their address from our
database (ADS) and connect all their answers to
ADS address point and XY coordinates
If we don’t have data on the citizen’s address,
they can add their location on a web map and
write their own address
The map is similar to enumerator’s map
UNECE meeting in Amman 2016
S
u
p
e
r
v
i
s
o
r
y
a
p
p
l
i
c
a
t
i
o
n
’
s
m
a
p
The supervisors can see how their enumerators are
working
It is also displayed on a map
The map looks just like enumerator’s map
UNECE meeting in Amman 2016
W
h
a
t
a
r
e
d
i
s
t
r
i
c
t
s
?
Districts are bordered areas on the Census enumerator’s
map where he/she has to collect data.
Districts are NOT the areas by which the Census data
are later being presented.
District borders must be easily detectable on the
landscape to make the Census enumerator’s work faster
and better.
Kristjan Roosild
UNECE meeting in Amman 2016
G
I
S
t
e
c
h
n
o
l
o
g
y
u
s
e
d
Arc
GIS Server for the Java Platform
(Advanced/Standard/EDN) 10.0.3 + REST API
Arc
GIS Desktop (Info/Editor) 9.3/10.0
Arc
SDE
Arc
GIS Viewer for Flex
Districting for Arc
GIS
X
tools
Pro
UNECE meeting in Amman 2016
UNECE meeting in Amman 2016
e
G
E
O
S
t
a
t
eGEOStat is the Estonian geostatistical database
Enables to collect, manage, process, analyse, visualise
and maintain spatial data
We get data from Estonian Land Board:
Topographic data
Address data
Administrative and settlement units data
Cadastrial information
Ortophotos
Is related to data collection system VVIS:
Maps
Location info of buildings
Hierarchy of district division
D
a
t
a
f
o
r
d
a
t
a
c
o
l
l
e
c
t
i
o
n
s
y
s
t
e
m
Vector data and basemaps for enumerators desktop and
eCensus application
Address data
Address locators
ArcGIS services
UNECE meeting in Amman 2016
UNECE meeting in Amman 2016
R
e
c
r
u
i
t
e
r
s
m
a
p
a
p
p
l
i
c
a
t
i
o
n
UNECE meeting in Amman 2016
e
C
e
n
s
u
s
w
e
b
m
a
p
a
p
p
l
i
c
a
t
i
o
n
UNECE meeting in Amman 2016
e
C
e
n
s
u
s
w
e
b
m
a
p
a
p
p
l
i
c
a
t
i
o
n
UNECE meeting in Amman 2016
e
C
e
n
s
u
s
w
e
b
m
a
p
a
p
p
l
i
c
a
t
i
o
n
UNECE meeting in Amman 2016
E
n
u
m
e
r
a
t
o
r
s
d
e
s
k
t
o
p
a
p
p
l
i
c
a
t
i
o
n
UNECE meeting in Amman 2016
M
a
n
a
g
e
m
e
n
t
M
a
p
A
p
p
l
i
c
a
t
i
o
n
UNECE meeting in Amman 2016
A
d
d
r
e
s
s
o
p
e
r
a
t
o
r
m
a
p
a
p
p
l
i
c
a
t
i
o
n
d
u
r
i
n
g
d
a
t
a
p
r
o
c
e
s
s
i
n
g
UNECE meeting in Amman 2016
C
o
n
c
l
u
s
i
o
n
Statistics Estonia has built an electronic data
collection environment
The system supports the whole data collection
process, including
Study form creation
Task division between collectors
CAPI module (filling in of study forms in
collectors’ laptops)
CAWI module (public e-survey environment)
Preliminary data quality assurance module
Final testing 2 weeks in 2009 , LIVE launch in 3
months in 2010 during a
g
ricultural census
T
h
a
n
k
Y
o
u
!
UNECE meeting in Amman 2016
Session 5 Plans and Preparations for the United Nations Technical Meeting on Use of Technology in Population and Housing Censuses held in Amman, Jordan from 28th November to 1st December 2016. The session covered topics such as timetable of Population and Housing Census 2011, training programs for supervisors and census takers, goals of the information system, descriptions of applications used, high-level view of involved applications, e-census data collection process, and the live environment setup including servers and operating systems.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
Session 5 Plans and Preparations United Nations Technical Meeting on Use of Technology in Population and Housing Censuses Amman, Jordan 28t h - 1stDecember 2016 Statistics Estonia Diana Beltadze
Timetable of Population and Housing Census 2011 31.03.2010 Pilot 31.12.2011- 31.03.2012 Enumeration 2012- 2013 Post-enumeration activities 31.12.2009- 2007-2011 Pre-enumeration activities Testing various aspects of census plan and procedures UNECE meeting in Amman 2016
Training A 5-day training for district chiefs and supervisors (15+132); A 5-day training for census takers (2,200). UNECE meeting in Amman 2016
Goals of the information system Universal software useable in all surveys Improve the coverage of studies Improve quality of raw data Improve efficiency of field work management Reduce data collection cost Increase speed of post-collection data processing UNECE meeting in Amman 2016
Description of the applications Questionnaire definition tool Enumerators application E-respondent application Management application E-respondent map application Management map application Enumerators map application UNECE meeting in Amman 2016
High level view of the involved applications IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
E-census data collection process IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
Live environment 6 physical (12 virtual) Oracle Weblogic Java application servers 2 Oracle physical database servers Apache load balancers ESRI GIS server Check Point firewall and VPN software SAS and VAIS data processing servers Suse Linux Enterprise and MS Windows operating systems used in servers MS Windows XP operating system used for enumerators laptops Mainly Hewlet Packard hardware used IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
External resources META data database Active Directory Statistical database GIS database UNECE meeting in Amman 2016
IT security IT security analyzes (2008) IT security analyzes and complete testing (2010) UNECE meeting in Amman 2016
IT related risks Data leakage Attacks against IT solutions Load tolerance is not sufficient Failures of software Data loss IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
Data protection Operations with sensitive data are logged Separate log tables and special rights in management system and enumerators application Hard drive encryption in enumerator s computer Database encryption and high availability IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
Hardware and software purchases Cost efficiency analyzes (laptops) Load tolerance evaluation (servers) Later use of hardware and software IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
Preparation of hardware Servers and other peripherals were shipped in April 2011, laptops in Sept-Oct 2011 External partners were used Secure VPN connection between two physical locations created 1979 code lines used in personalization script. About 26,4 computers per day was prepared on a assembly line Live sample downloaded during the fieldwork UNECE meeting in Amman 2016
IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
Load tolerance testing Tests were done between 2009-2012 Test requirements (Live environment) E-respondents application - 2500 parallel sessions Enumerators application 2000 parallel sessions Emulating robots used Testing lasted about 9 months (Live environment) UNECE meeting in Amman 2016
Load tolerance testing process >2500 sessions - personal computers 2500 - 5000 sessions Amazon cloud 5000 - 7500 sessions Estonian Information Systems Authority s servers IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
IT support UNECE meeting in Amman 2016
IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
The average time for fulfilling personal questionnaire IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
Maailmarekordi snd lbi rahva- ja eluruumide loenduse e- UNECE meeting in Amman 2016 lahenduse
Authentication channels UNECE meeting in Amman 2016
Hourly statistics IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
Fears and problems during E-census E-census environment becomes unavailable System load is too high, people quit Enumerators computers don t get ready in time Security problems stop E-census Problems downloading Live sample Training fails Fieldworks are getting delayed UNECE meeting in Amman 2016
Good decisions Information system for general service Sizable load tolerance tests Buying out laptops used by the enumerators Outsourcing information system maintenance Tachometer for indicating system load UNECE meeting in Amman 2016
Subsequent knowledge It s all about testing Pilots as real as possible Hire more people for longer period Buy experience, because there s no time to experiment and learn UNECE meeting in Amman 2016
Critical competences System architect A moderator between software development and maintenance team IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
Hardware Infrastructure Oracle Weblogic J2EE server LIVE cluster 2 physical server nodes (Linux) Load balancer (Apache) Oracle Database server 1 physical server (Linux) Cold standby (Linux) Interviewers computers (Acer One netbooks) Mobile internet connection modems Portable GPS receivers UNECE meeting in Amman 2016
Preparation of hardware Interviewers computers Windows XP operating system with last updates Forbidden hardware for non working purposes Webcam USB/MMC storage Wi-Fi/LAN UNECE meeting in Amman 2016
Preparation of hardware (continues) Interviewers computers Forbidden functionality for non working purposes Local computer and registry BIOS password protection, denial of bootable removable storage Web traffic limitations Forbidden access to control panel functionality Forbidden access to hidden files Hibernate in case of closing the lid UNECE meeting in Amman 2016
Preparation of hardware (continues) Interviewers computers Forbidden functionality for non working purposes Domain Policy Screen saver with password prompt in case of an idle Interviewer only specific VPN rules UNECE meeting in Amman 2016
Preparation of hardware (continues) Interviewers computers Forbidden functionality for non working purposes Domain Policy Screen saver with password prompt in case of an idle Interviewer only specific VPN rules UNECE meeting in Amman 2016
Preparation of hardware (continues) Interviewers computers Personalization True Crypts default password change Delicate data folders access rights Hiding the delicate data folders Verification True Crypt and Active Directory passwords VPN connection Interviewers application load, update and synchronization UNECE meeting in Amman 2016
Security of data Passwords One password for everything Predefined and unchangeable passwords True Crypt password changed and stored in the process of personalization Active Directory authentication for Windows logon and web applications UNECE meeting in Amman 2016
Security of computers Fully encrypted hard drive HTTP/SFTP connection inside encrypted VPN tunnel UNECE meeting in Amman 2016
Physical security Servers Access protected server rooms Interviewers computer Based on interviewers training Handle personal passwords Protect computer in bad weather conditions Act in case of robbery or computer loss Handle unauthorized use of computer UNECE meeting in Amman 2016
Our partners IT-architecture, security, hardware and Census UNECE meeting in Amman 2016
During census spatial- and attribute data were renewed through enumerator s map application Enumerator s tasks: Renewing of existing buildings attributes - the type and condition of the building Add new houses to map and add their type and condition UNECE meeting in Amman 2016
The map data on Enumerators map application Raster data (1:1 - 1:25 000): Ortophoto from Estonian Land Board OR Base Map topographic data from Estonian Land Board, cartographic work from eGEOStat project Statistics Estonia UNECE meeting in Amman 2016
The map data on Enumerators map application Vector data (1:1 ...) District borders Building numbers from ADS Cadastral parcels (for agricultural census) Administrative borders Bus stops Topographic data (roads, rivers, forests, etc.) UNECE meeting in Amman 2016
Enumerators map application building data update Data syncronisation The XY coordinates of new buildings and the type and condition of buildings is sent through secure VPN with GPRS connection to the Statistics Estonia server. This takes place together with the census data syncronisation UNECE meeting in Amman 2016
E-census map application Every citizen can come to our web page and e- count themselves. They search and choose their address from our database (ADS) and connect all their answers to ADS address point and XY coordinates If we don t have data on the citizen s address, they can add their location on a web map and write their own address The map is similar to enumerator s map UNECE meeting in Amman 2016
Supervisory applications map The supervisors can see how their enumerators are working It is also displayed on a map The map looks just like enumerator s map UNECE meeting in Amman 2016
What are districts? Districts are bordered areas on the Census enumerator s map where he/she has to collect data. Districts are NOT the areas by which the Census data are later being presented. District borders must be easily detectable on the landscape to make the Census enumerator s work faster and better. UNECE meeting in Amman 2016 Kristjan Roosild
GIS technology used Arc GIS Server for the Java Platform (Advanced/Standard/EDN) 10.0.3 + REST API Arc GIS Desktop (Info/Editor) 9.3/10.0 Arc SDE Arc GIS Viewer for Flex Districting for Arc GIS X tools Pro UNECE meeting in Amman 2016
eGEOStat eGEOStat is the Estonian geostatistical database Enables to collect, manage, process, analyse, visualise and maintain spatial data We get data from Estonian Land Board: Topographic data Address data Administrative and settlement units data Cadastrial information Ortophotos Is related to data collection system VVIS: Maps Location info of buildings Hierarchy of district division UNECE meeting in Amman 2016
Data for data collection system Vector data and basemaps for enumerators desktop and eCensus application Address data Address locators ArcGIS services UNECE meeting in Amman 2016
Recruiters map application UNECE meeting in Amman 2016
