UsingArcGIS and VB.Net for E911 Addressing
Using ArcGIS and VB.Net for E911 Addressing Victoria Smith GIS Programmer/Analyst
Putnam County, Florida GIS 1
The E-911 Division became under the direction of the IT Department GIS Office in March 2004. The Uniform Addressing System Ordinance was rewritten in May 2006. The E911 Division assigns Addresses and Street Names within the unincorporated areas of Putnam County, Town of Interlachen, Pomona Park, Town of Welaka, and the City of Palatka The E-911 Division maintains the ALI (Automatic Location Identification) database which is what is shown to 911 call takers. The E-911 Division maintains the MSAG (Master Street Address Guide) Database which contains valid street names and address ranges . This ensures that the ALI database has valid information. Putnam County, Florida GIS 2
Need a way to accomplish the following in ArcMap •Maintain addressing history •Provide output for the resident
•Maintain communication with other departments
Keep GIS addressing data accurate
•Photos and field verification
•External data •Aerials •Plat maps
•Existing address verification
•ALI verification •Handle addressing municipalities 3
üData
•Mysql database
•Plat maps
•Existing addressing point data •Aerials •Existing street data
•Photos
üSOFTWARE:
•MSAG and ALI data •Property Appraiser’s parcel dataüMicrosoft visual studio (vb.net 2005) üEsri ARCMAP APPLICATION
Putnam County, Florida GIS
4
Putnam County, Florida GIS
5
•Maintain address history •Changes •Additions •Problems •Having time stamped data
•Make the system a multi-user system •Records stored in a central location accessible by all •Data Analysis •Database offers reporting and other data manipulating benefits
•Maintain address history •Add and modify addressing data while maintaining database structure and schema (unique IDs, external data (Communities, zip codes etc •Make the system a multi-user system •Enable all users at all GIS levels to work with program
•Data Analysis •Help maintain accurate data
6
Major addressing layer effected •STREETS layer •ADDRESS layer Customized tools created •Maintain unique identification numbers •Calculate address house numbers •Reduce data inconsistencies due to data entry errors •Auto-population of data from other layers (ESN, Community, etc) •Ease of use for non-GIS personnel Putnam County, Florida GIS
7
Putnam County, Florida GIS
8
Address Generator Tool Usage Address Generator Tool Benefits •Click gathers inside the desired •Automatically required parcel information needed: •Street information (name, unique id) •Cross the desired •Parcel ID (parcel layer) street of •Community name (community the new address layer) •Emergency Service Number (ESN •Populates layer) •Street name •Zip code (zipcode layer)
• Estimated address numberof unique address •Automatic creation identifier •Address type (primary or subaddress) •Parcel •Existing domains areIDused in dropdowns •Community •Data entry control •ESN •Etc 9
Address AddressEditor Editor Tool Tool Benefits Usage •Select the address •Same interface as thepoint address generator tool.
•The dialog displays with •All spatial •Attribute data relationships are of the point
checked to make •Photo of the sure saved data is correctstructure(s) (i.e. Community, parcel ID, zip code, and emergency service number)
•Data entry control 10
Street Creator Tool Benefits Street Creator Tool required Usage •Automatically gathers information needed: •Click and double click the by •Street information (*name beginning and ending community, unique id) points respectively in the •Community name (community map display layer) •Emergency Service Number •The dialog (ESN layer) displays with attribute data of •Zip•Default code (zipcode layer) the street •Automatic creation of unique street identifier •Existing domains are used in dropdowns •Data entry control
11
Street Editor Tool Benefits Street Editor Tool Usage •Same interface as the street •Select the street generator tool. (polyline) •The with are •All dialog spatialdisplays relationships •Attribute data sure of thesaved street checked to make (polyline) data is correct (i.e. Community, parcel ID, zip code, and emergency service number) •Data entry control •Alias names are shown •Data validation (community, emergency service number 12
Putnam County, Florida GIS
13
Parcel selection form Step 1
Option 1 (data entry) Enter parcel identification number (no dashes or tabbing) to zoom to the parcel and bring up the address form
Option 2 (interactive map selection Click on the parcel in the map document to zoom to the parcel and bring up the address form
14
Parcel selection form
If the parcel is a split or combination and not in GIS enter the parent parcel subdivision, block and lot REASONING: •Splits and combinations are not immediately available in GIS 15
Previously saved records for the parcel Form type i.e. New Address, Change of Address, Unit Designator Change, or New Address Added
Form reason i.e. Wrong Address, Out of Sequence, Wrong side of street etc
Auto-populated parcel owner information
16
Auto-populated information about the parcel
This is the designated area of the form to: • Assign the address. •Walk-in or telephone •Check the address range
Comments by E911 Staff
ADDRESS CHANGED, ORIGINAL ALI VERIFICATION 02-16ADDRESS: 620 S COUNTY RD 21, BY E911 VERIFICATION 02-16-2011 2011 BY VSMI14 HAWTHORNE [309] 02-16-2011 BY VSMI14 VSMI14
17
This will pull up to section map pertaining the selected parcel
18
Displays the 2006 section aerial PDF documents
19
Displays a word document created by the form. The document is archived for nonGIS users and address history maintenance
20
Displays a word document created by the form. This document is given to the resident for address assignment verification
21
Displays a word document created by the form. This document is mailed to the resident for address verification according to ALI discrepancies or other similar issues
22
Email Triggers •Change of Address •Unit Designator Change
23
Clicking in the listbox will display the update record form This allows viewing and updating of previously saved address forms
24
Future Enhancements: •Database will be moved from MySQL to ArcSDE •Validation tools will be expanded •Work Closely with Planning •Driveway permits •Work closely with Property Appraiser’s office •Parcel splits and combinations •Deed changes •Easements
25
Thank You Questions or Comments Victoria Smith Putnam County GIS Programmer/Analyst [email protected]
26
Putnam County, Florida GIS 1
The E-911 Division became under the direction of the IT Department GIS Office in March 2004. The Uniform Addressing System Ordinance was rewritten in May 2006. The E911 Division assigns Addresses and Street Names within the unincorporated areas of Putnam County, Town of Interlachen, Pomona Park, Town of Welaka, and the City of Palatka The E-911 Division maintains the ALI (Automatic Location Identification) database which is what is shown to 911 call takers. The E-911 Division maintains the MSAG (Master Street Address Guide) Database which contains valid street names and address ranges . This ensures that the ALI database has valid information. Putnam County, Florida GIS 2
Need a way to accomplish the following in ArcMap •Maintain addressing history •Provide output for the resident
•Maintain communication with other departments
Keep GIS addressing data accurate
•Photos and field verification
•External data •Aerials •Plat maps
•Existing address verification
•ALI verification •Handle addressing municipalities 3
üData
•Mysql database
•Plat maps
•Existing addressing point data •Aerials •Existing street data
•Photos
üSOFTWARE:
•MSAG and ALI data •Property Appraiser’s parcel dataüMicrosoft visual studio (vb.net 2005) üEsri ARCMAP APPLICATION
Putnam County, Florida GIS
4
Putnam County, Florida GIS
5
•Maintain address history •Changes •Additions •Problems •Having time stamped data
•Make the system a multi-user system •Records stored in a central location accessible by all •Data Analysis •Database offers reporting and other data manipulating benefits
•Maintain address history •Add and modify addressing data while maintaining database structure and schema (unique IDs, external data (Communities, zip codes etc •Make the system a multi-user system •Enable all users at all GIS levels to work with program
•Data Analysis •Help maintain accurate data
6
Major addressing layer effected •STREETS layer •ADDRESS layer Customized tools created •Maintain unique identification numbers •Calculate address house numbers •Reduce data inconsistencies due to data entry errors •Auto-population of data from other layers (ESN, Community, etc) •Ease of use for non-GIS personnel Putnam County, Florida GIS
7
Putnam County, Florida GIS
8
Address Generator Tool Usage Address Generator Tool Benefits •Click gathers inside the desired •Automatically required parcel information needed: •Street information (name, unique id) •Cross the desired •Parcel ID (parcel layer) street of •Community name (community the new address layer) •Emergency Service Number (ESN •Populates layer) •Street name •Zip code (zipcode layer)
• Estimated address numberof unique address •Automatic creation identifier •Address type (primary or subaddress) •Parcel •Existing domains areIDused in dropdowns •Community •Data entry control •ESN •Etc 9
Address AddressEditor Editor Tool Tool Benefits Usage •Select the address •Same interface as thepoint address generator tool.
•The dialog displays with •All spatial •Attribute data relationships are of the point
checked to make •Photo of the sure saved data is correctstructure(s) (i.e. Community, parcel ID, zip code, and emergency service number)
•Data entry control 10
Street Creator Tool Benefits Street Creator Tool required Usage •Automatically gathers information needed: •Click and double click the by •Street information (*name beginning and ending community, unique id) points respectively in the •Community name (community map display layer) •Emergency Service Number •The dialog (ESN layer) displays with attribute data of •Zip•Default code (zipcode layer) the street •Automatic creation of unique street identifier •Existing domains are used in dropdowns •Data entry control
11
Street Editor Tool Benefits Street Editor Tool Usage •Same interface as the street •Select the street generator tool. (polyline) •The with are •All dialog spatialdisplays relationships •Attribute data sure of thesaved street checked to make (polyline) data is correct (i.e. Community, parcel ID, zip code, and emergency service number) •Data entry control •Alias names are shown •Data validation (community, emergency service number 12
Putnam County, Florida GIS
13
Parcel selection form Step 1
Option 1 (data entry) Enter parcel identification number (no dashes or tabbing) to zoom to the parcel and bring up the address form
Option 2 (interactive map selection Click on the parcel in the map document to zoom to the parcel and bring up the address form
14
Parcel selection form
If the parcel is a split or combination and not in GIS enter the parent parcel subdivision, block and lot REASONING: •Splits and combinations are not immediately available in GIS 15
Previously saved records for the parcel Form type i.e. New Address, Change of Address, Unit Designator Change, or New Address Added
Form reason i.e. Wrong Address, Out of Sequence, Wrong side of street etc
Auto-populated parcel owner information
16
Auto-populated information about the parcel
This is the designated area of the form to: • Assign the address. •Walk-in or telephone •Check the address range
Comments by E911 Staff
ADDRESS CHANGED, ORIGINAL ALI VERIFICATION 02-16ADDRESS: 620 S COUNTY RD 21, BY E911 VERIFICATION 02-16-2011 2011 BY VSMI14 HAWTHORNE [309] 02-16-2011 BY VSMI14 VSMI14
17
This will pull up to section map pertaining the selected parcel
18
Displays the 2006 section aerial PDF documents
19
Displays a word document created by the form. The document is archived for nonGIS users and address history maintenance
20
Displays a word document created by the form. This document is given to the resident for address assignment verification
21
Displays a word document created by the form. This document is mailed to the resident for address verification according to ALI discrepancies or other similar issues
22
Email Triggers •Change of Address •Unit Designator Change
23
Clicking in the listbox will display the update record form This allows viewing and updating of previously saved address forms
24
Future Enhancements: •Database will be moved from MySQL to ArcSDE •Validation tools will be expanded •Work Closely with Planning •Driveway permits •Work closely with Property Appraiser’s office •Parcel splits and combinations •Deed changes •Easements
25
Thank You Questions or Comments Victoria Smith Putnam County GIS Programmer/Analyst [email protected]
26
