Centralizing address updating with GIS

Blog_Centralizing_address_updating_with_GIS.jpg

Addresses play an important role in the daily activities of Village
of Riverside staff whether it is for water billing information, permits,
or locating a resident in case of an emergency. In addition, a physical
address can serve as a link for answering such questions as what school
district do I belong to or what zoning district am I in? However,
obtaining this information for a specific address often requires
searching through multiple spreadsheets, databases, and paper documents.

In order to create a centralized location for the address information
in Riverside a master address database was created in the Geographic
Information System (GIS). This database was generated from several
sources including water billing, permits, fire inspections, and business
licenses. It was necessary to utilize all address resources to ensure
the existing databases and spreadsheets could relate to this new address
resource. Because these independent sources were each developed with a
specific focus, which limited them from including all addresses within
the community, it is also important to obtain all address records from
these independents sources. For example, one address database may have
only included business addresses, another contained residential
addresses, and a third identified suite and apartment information.

Each address in the master database follows the United States Postal
standard with a prefix direction, address number, street, street type
(such as boulevard or avenue) and a suffix direction. This information
is captured in separate fields that allows for combining all of those
values or just a select few. An example is 1190 Arlington Heights or
1190 S Arlington Heights Rd.

The GIS allows for all of the addresses in the database to be
represented by a point feature referencing an x and y coordinate that
places it in a known location on the earth. This point is linked to a
table containing additional information about that particular address
including a Property Identification Number or PIN number and assessor
information. The address point is typically placed in the center of the
corresponding parcel, but can be placed at a more descriptive location
such as the main entrance by using aerial imagery and building footprint
information. Moreover, this address is stored as a primary address
point. Often times additional buildings and parking lots that have the
same address as the main building are located on another parcel. These
structures are given a secondary address point to differentiate them
from the primary address location.

By design, the GIS allows for quick and simple retrieval of data at a
particular location. An address point can be identified and overlaid
with additional data layers including utilities, subdivisions, school
districts, and a road network to quickly determine the location of the
nearest fire hydrant to a property or the number of homes within a
particular school district. This eliminates the need for village staff
to check multiple sources of information which can save time, money, and
in the case of emergency services, lives. Overall, it is safe to say
that the enhancements a village receives by having an accurate address
database will become known as the GIS programs continue to evolve.

Centralizing address updating with GIS

Blog_Centralizing_address_updating_with_GIS.jpg

Addresses play an important role in the daily activities of Village
of Riverside staff whether it is for water billing information, permits,
or locating a resident in case of an emergency. In addition, a physical
address can serve as a link for answering such questions as what school
district do I belong to or what zoning district am I in? However,
obtaining this information for a specific address often requires
searching through multiple spreadsheets, databases, and paper documents.

In order to create a centralized location for the address information
in Riverside a master address database was created in the Geographic
Information System (GIS). This database was generated from several
sources including water billing, permits, fire inspections, and business
licenses. It was necessary to utilize all address resources to ensure
the existing databases and spreadsheets could relate to this new address
resource. Because these independent sources were each developed with a
specific focus, which limited them from including all addresses within
the community, it is also important to obtain all address records from
these independents sources. For example, one address database may have
only included business addresses, another contained residential
addresses, and a third identified suite and apartment information.

Each address in the master database follows the United States Postal
standard with a prefix direction, address number, street, street type
(such as boulevard or avenue) and a suffix direction. This information
is captured in separate fields that allows for combining all of those
values or just a select few. An example is 1190 Arlington Heights or
1190 S Arlington Heights Rd.

The GIS allows for all of the addresses in the database to be
represented by a point feature referencing an x and y coordinate that
places it in a known location on the earth. This point is linked to a
table containing additional information about that particular address
including a Property Identification Number or PIN number and assessor
information. The address point is typically placed in the center of the
corresponding parcel, but can be placed at a more descriptive location
such as the main entrance by using aerial imagery and building footprint
information. Moreover, this address is stored as a primary address
point. Often times additional buildings and parking lots that have the
same address as the main building are located on another parcel. These
structures are given a secondary address point to differentiate them
from the primary address location.

By design, the GIS allows for quick and simple retrieval of data at a
particular location. An address point can be identified and overlaid
with additional data layers including utilities, subdivisions, school
districts, and a road network to quickly determine the location of the
nearest fire hydrant to a property or the number of homes within a
particular school district. This eliminates the need for village staff
to check multiple sources of information which can save time, money, and
in the case of emergency services, lives. Overall, it is safe to say
that the enhancements a village receives by having an accurate address
database will become known as the GIS programs continue to evolve.