Dublin City Council Spatial Data Capture and Delivery Methodology

Dublin City Council Spatial Data Capture
and Delivery Methodology.
Name:
Course Code: DT9419/20
Module: SSPL9043
Year of Course: 2018-2019
Staff: Dr. Audrey Martin /. Dr Eugene McGovern

Abstract
This report is about Dublin City Council, which wants to create a geo-referenced spatial database
for their street assets. The report explains the optimal methodologies that the Georeferencing
team should take to capture that data and record it, store it in the database, use it for
Georeferencing and finally maintain the quality of the data.
The report has three parts:
 Data collection methods
 Geo referencing process
 Data Quality maintenance
The first part explains in detail how the team should collect accurate data, using optimum
methods and techniques.
The second part deals with how the team should use the data for geo referencing.
The third part is about the techniques of data maintenance and validation, as well as data quality.
1

Table of contents
Chapter 1: Asset Data Collection...................................................................................................5
1.1 Why good recording?........................................................................................................5
1.2 Recording of localities......................................................................................................5
1.3 Coordinate recording.........................................................................................................6
1.4 Global Positioning System................................................................................................7
1.5 Elevation recording...........................................................................................................7
1.6 Recording the size of the area...........................................................................................8
1.7 Collection year..................................................................................................................8
1.8 Documentation..................................................................................................................8
Chapter 2: The Georeferencing process..........................................................................................9
2.1 Tools and resources...............................................................................................................9
2.2 Setting up the database..........................................................................................................9
2.2.1 Locality description fields.......................................................................................10
2.2.2 Fields associated with Georeferencing.........................................................................11
2.2.3 Handling ecological data..............................................................................................13
2.2.4 Database constraints.....................................................................................................13
2.3 User Interfaces for Georeferences.......................................................................................13
2.4 Standards and guidelines.....................................................................................................14
2

2.5 Georeferencing procedure...................................................................................................15
Chapter 3: Data Quality Maintenance...........................................................................................16
3.1 Feedback to the data collection team...................................................................................16
3.2 User feedback......................................................................................................................16
3.3 Cleaning and Checking of data............................................................................................17
3.3.1 Data entry......................................................................................................................17
3.3.2 Data validation..............................................................................................................17
3.3.3 Correcting.....................................................................................................................18
3

Introduction
Georeferencing is the process of relating the coordinates of a map to real objects on the earth’s
surface. There are various techniques to geo reference. This report includes the optimum
methods that enhance geo referencing. Any kind of specimen can be geo referenced as long as it
can be associated with a map.
This report specifically covers the methods that the Dublin City Council team can implement in
the city to locate their required assets. The extent of data collection in this case will be the
Dublin City.
The report suggests the optimum methods that the DCC team can adopt to get accurate and
explicit results. Data collection, geo referencing and data maintenance are explained in details in
the chapters that follow
4

Chapter 1: Asset Data Collection
Georeferencing can be a hard task. Therefore, good methods of data collection in the field are
essential as they form the back bone of Georeferencing. Nowadays, many efficient and accurate
data collection techniques are there to facilitate the process. However, recording the locations
correctly reduces errors. Since using a Global Positioning system (GPS) is more accurate and
efficient, the Dublin City council (DCC) data collection team should use it.
1.1 Why good recording?
Describing locality well yields more reliable georeferences with minimum levels of uncertainty,
Huang, B. (2018). This outputs data that has a high quality. Recording locality information is
essential, whether one is using a map or GPS, to make data validation easier.
Validating coordinates is one way of good locality description. Spatial and locality description
play an important role in the accuracy of data. They determine how reliable the recorded data is.
For example, using a small reference point increases the data accuracy. Choosing a reference
point that is nearby also reduces errors in offset data measurements, Farkas, G. (2017). The DCC
should use reference points that are easily findable on maps. If a locality has two places with
names that can cause confusion, add the feature type alongside the name of the feature. For
example;
1.2 Recording of localities
The team should ensure that the localities are highly described, even when they are using
geographic coordinates. To avoid possible uncertainty, each locality should be clear, unbroken,
specific and accurate, Pehcevski, J. (2018). Localities that describe reference points should be
5