7 OCTOBER 2002 - circabc.europa.eu file3 Landesamt für Datenverarbeitung und Statistik Nordrhein-Westfalen - Statistik-Online - Statistik-Online Landesamt für Datenverarbeitung und

COLLECTION OF RAW DATA

TASK FORCE

MEETING N° 6

7 OCTOBER 2002

Doc. CoRD 094

Statistik-Online German Internet project

For information

2

Landesamt für Datenverarbeitungund Statistik

Nordrhein-Westfalen- Statistik-Online -


Nordrhein-Westfalen

Dr. Thomas Pricking

StatistikStatistik--OnlineOnline

A new approach to collect statistical data in A new approach to collect statistical data in NorthrhineNorthrhine--Westphalia Westphalia -- GermanyGermany



AAggendaenda

our objectivesour objectivessome organisational aspectssome organisational aspectsour clientsour clientspresentationspresentationssome technical remarkssome technical remarks

3



Statistik-Online

Landesamt für Datenverarbeitung

und StatistikNordrhein-Westfalen

- Statistik-Online -

Our objectivesOur objectivesServiceService

A mA modernodern sstattatee –– a a modern modern administrationadministration

EfficiencyEfficiencyReducing the burden for companies and firmsReducing the burden for companies and firmsTransfer of checkedTransfer of checked ddatataa

ProduProducctivittivityyProcessing data in one continous electronic pipelineProcessing data in one continous electronic pipelineReducingReducing of required processing timeof required processing time




Our adresseesOur adressees

Companies, firmsCompanies, firmsdirectlydirectlyindirectlyindirectly

Local authorities, public administrationLocal authorities, public administrationPrivatPrivat personpersonss aandnd householdshouseholds

4



Sending organisationSending organisation

2002

2001

Jahreserhebung ...

9.2001

8.2001

6.2001

5.2001

III. 2001

II. 2001

Monatsbericht Handel Umweltstatistik

Betrieb 1 Betrieb 2

9.2001

8.2001

Monatsbericht ...

Firma Fleischwolf Firma Gerüstbau

Betrieb 1

Firma Steinzeug GmbH

Tax consultantMax Mustermann

A single user-IDA single password



ReReggistristration of usersation of users

Every user must be registered.Every user must be registered.Service bureauService bureau StatistikStatistik--OnlineOnlinePersonaliPersonalization of participantszation of participantsMailing ofMailing of UserID UserID aandnd passwordpassword

5



Three ways of data inputThree ways of data input: I: I

manually filling out internet

forms



LiveLive presentationpresentation stepstep II

6



EvaluationEvaluation☺☺ Use of modern ITUse of modern IT☺☺ Direct data transferDirect data transfer☺☺ ReceiptReceipt☺☺ Checked dataChecked data –– nno return questionso return questions☺☺ Electronic archiveElectronic archive☺☺ No mailing costsNo mailing costs

EditingEditingOnlineOnline costscosts



Three ways of data inputThree ways of data input: : IIIITranfer of data from

data processing systems into internet

forms

7



LiveLive presentation steppresentation step II II




EvaluationEvaluation☺☺ Use of modern ITUse of modern IT☺☺ Direct data transferDirect data transfer☺☺ ReceiptReceipt☺☺ Checked dataChecked data –– nno return questionso return questions☺☺ Electronic archiveElectronic archive☺☺ No mailing costsNo mailing costs

OnlineOnline costscosts –– mailing costsmailing costs

☺☺Direct import into web formsDirect import into web forms




GGood but not perfectood but not perfect......

Possible problemsPossible problems::Several statistical inquiries per monthSeveral statistical inquiries per monthMore than one time periodMore than one time periodMore than one reporting unitMore than one reporting unitLarge amount of dataLarge amount of data

8



Three ways of data inputThree ways of data input: III: III

Classical EDI:Transfer of data

by XML-files



XMLXML--formatformat<?xml version="1.0" encoding="ISO-8859-1" ?> <XML>

<RDRMES> <UNB>

<_0001>UNOC</_0001> <_0002>3</_0002> <_0004>##SendingOrgID##</_0004> <_0010>LDS NRW</_0010> <_0017>##Sendedatum##</_0017> <_0019>##Sendezeit##</_0019> <_0020>001</_0020>

</UNB>

<IDE> <_7495>1</_7495> <_7402>##StatistikID##</_7402>

- <NAD> <_3035>DT</_3035> <_3039>##RespOrgID##</_3039> <_3039B>##StatOfficeID##</_3039B>

</NAD> <SCD>SCD3</SCD> <ARR>##Nutzdaten##</ARR>

- <DTM><_2005>320</_2005> <_2380>##ReportPeriodID##</_2380> <_2379>610</_2379>

</DTM> </IDE>

de factostandard

9



EvaluationEvaluation☺☺ Use of modern ITUse of modern IT

☺☺ Direct data transferDirect data transfer

☺☺ ReceiptReceipt

☺☺ Checked dataChecked data –– nno return questionso return questions

☺☺ Electronic archiveElectronic archive☺☺ Direct import into web formsDirect import into web formsAutomatic data transfer from internal book keeping systems to external statistical offices




The data workflow in the statistical officeThe data workflow in the statistical office

Forms in XML Attached XML-files

Open Data Exchange Server for Statistics and Administration

ODESSA

Programsstat. network









TechniTechnicalcal requirementsrequirements::Access to the webAccess to the webBBrowserrowser based techniquebased technique

Internet Explorer 5.5 (SP2)Internet Explorer 5.5 (SP2)Netscape Navigator 6.1Netscape Navigator 6.1Acrobat Reader 4.0Acrobat Reader 4.0

ccorreorrecct t internet ointernet optionsptionsSSLSSL--encryptionencryptionJavaJava--ScriptScript

MonitorMonitor resolutionresolution 1024x7681024x768

10



WEB

Authentification

ODESSAOpen Data Exchange Server for Statistics and Administration

Internet

Statistical register

URS, BRLAWI, ...

EDISTAT-mailbox

Forms and data

Mail

Information management

Survey controlling

Statistical production(German network)

��

��Firewall

��

��

Firewall

��

��Firewall

Registration



Work stagesWork stages

Start Start of the pof the pilotilot projectproject in 2001in 2001solicitingsoliciting ofof participating firmsparticipating firms iinn ococt./t./nnovov. 2001. 2001ca. 1.300 ca. 1.300 have registeredhave registered

MonMonthly report of mining and producing industrythly report of mining and producing industry

Start of production (report of mining...) onStart of production (report of mining...) on 7.1.20027.1.2002

InIn aaprilpril 2002: 2002: introduction of further statisticsintroduction of further statistics

11



Responses byResponses by InternetInternetMonMonthly report of mining and producing industrythly report of mining and producing industry

Responses≅ 7% of all units

Registered usersTotal reporting units: ca. 11.000

0

2 0 0

4 0 0

6 0 0

8 0 0

1 0 0 0

1 2 0 0

1 4 0 0

1 6 0 0

1 2 1 2 3 4 5 6 7 8



Further statistical inquiriesFurther statistical inquiries

Nordrhein-Westfalen:Monatliche ProduktionserhebungVierteljährliche ProduktionserhebungMonatsbericht im Bauhauptgewerbe (einschl. Auftragseingangsindizes)SondererhebungenMonatsbericht zur EinzelhandelsstatistikTourismusstatistikErhebung der Waren und Dienstleistungen für den UmweltschutzErhebung der Investitionen für den UmweltschutzSchuldenstand der Gemeinden

MecklenburgMecklenburg--Vorpommern:Vorpommern:TourismusstatistikTourismusstatistik

Bayern:Bayern:Laufende VerdiensterhebungLaufende Verdiensterhebung

Statistische Bundesamt:Statistische Bundesamt:Intrahandel Intrahandel (w3stat)(w3stat)

12



Classic EDI (Classic EDI (10% of all statistics10% of all statistics))

83%83%migrationmigration

9%9%civil civil registy officesregisty offices

16%16%registy offices for industryregisty offices for industry

53%53%universitiesuniversities

100%100%state attorneystate attorney

100%100%bankruptcybankruptcy

coveragecoveragestatistical areastatistical area




Ressources for developmentRessources for development

6 man6 man--years years 5 programmers5 programmers

JavaSkript, CGI, Perl, PHP, MySQLJavaSkript, CGI, Perl, PHP, MySQL

2 employees for coordiniation 2 employees for coordiniation

ressources in various statistical ressources in various statistical departmentsdepartments



Dr. Thomas Pricking

ThanksThanks forfor youryour interestinterest!!

AnyAny questionsquestions? ?


Documents

7 OCTOBER 2002 - circabc.europa.eu file3 Landesamt für Datenverarbeitung und Statistik Nordrhein-Westfalen - Statistik-Online - Statistik-Online Landesamt für Datenverarbeitung und