GISC 6389 GIS Master Project Automated Property Notification

1
GISC 6389 GIS Master ProjectAutomated Property
Notification Online Updating of Appraisal
Data A GIS Solution for Urban Planning

• Jianghong Li
• Advisor Dr. Fang Qiu
• Dr. Ron Briggs
• Summer 2007

2
Overview

• Introduction
• Problem Statement
• Project Objective
• Literature Review
• Data Source
• Design Implementation
• Case Study
• Conclusions
• My Contributions
• References
• Application Demo

3
Introduction

• Today GIS impacts nearly every aspect of local
  government and helps provide a foundation for
  integrating municipal services.
• One of the most common applications of GIS in
  local government involves notifications to
  property owners
• The goal of this project
• Customize notification tools to identify parcels
  and determine the affected properties within
  predefined buffer distance.
• Automated update of the selected properties
  database to ensure accuracy of property owners
  and their mailing addresses.
• Generate notification report and create mailing
  labels which are ready to print.
• All via a user friendly tool interface.

4
Problem Statement

• The current procedure for property notification
• Time Consuming Take hours and hours to complete
  a single notification process.
• Repetitive tasks The whole process is redone
  every time a request is received.
• Data accuracy Incorrect data may be used due to
  data not up to date with appraisors records.

5
Project Objectives

• Develop automated property notification tool to
  effectively support the urban planning process of
  local governments.
• Develop automated program to update appraisal
  data from online web sources to enhance accuracy
  of data.
• Develop a system suitable for an urban planner
  without extensive GIS experience.

6
Literature Review

• A few peer-reviewed papers are found to be
  directly relevant to the topic.
• Applicability of GIS technology in urban
  planning, such as zoning, land use,
  transportation, and economic development
  planning site selection, etc.
• Budic, Z. D., 1994. Effectiveness of Geographic
  Information System in Local Planning, Journal of
  the American Planning Association. 60(2) 244-264
• Harris, B.,1990. Urban and Regional Planning in
  the Third World with Geographic Information
  System Support, Regional Development Dialogue
  11(3) 17-57.
• Yeh, A. G., 1990. Geographic Information System
  for Urban Planning in Hong Kong, Regional
  Development Dialogue 11(3) 120-140.
• Automatic Data Updating for GIS data
• Volker Walter, Stuttgart., 1999. Automated GIS
  data collection and update, Photogrammetric Week
  '99. Fritsch and R. Spiller (Eds.), Wichmann
  Verlag, Heidelberg, pp. 267-280
• Olajide Kufoniyi., 1995. Spatial coincidence
  modeling, automated database updating and data
  consistency in vector GIS, Wageningen
  Agricultural University, 90-6164-105-5
• Marc M. Ansoult, Pierre J. Soille, Jean A.
  Loodts., 1990. Mathematical morphology - A tool
  for automated GIS data acquisition from scanned
  thematic maps , Photogrammetric Engineering and
  Remote Sensing. Vol. 56, pp. 1263-1271. Sept.
  1990
• No article was found on automatic GIS data update
  from online sources

7
Similar Applications

• Mailing Label Wizard for ArcGIS (An extension to
  ESRIs ArcMap)
• The wizard steps through the process of
  selecting a subject parcel, performing a buffer,
  adding parcels from the buffer selection, using
  Crystal Report to create a notification report,
  and viewing or printing pre-formatted labels.
• Farallon Geographics, Inc.
• Provides property notification solution
  User can click on a property and automatically
  generate a buffer zone around that property and
  generate mailing labels.
• -----No notification report to trace
  feedback
• Gilmore Associates, Inc.
• Provides search interface for locating the
  property and automatically create a buffer zone
  and generate mailing labels.
• ----No notification report to trace
  feedback.
• NCTCOG ArcIMS 200 Foot Buffer Application
• Create a tool that will select and buffer
  around a property within 200 and generates a
  report that includes a map and addresses of the
  selected properties, which may help in creating
  mailing labels. (Price 3800)
• ----No automatic generation of mailing
  labels.
• All those applications are commercial
  applications and there is no guarantee of the
  data accuracy.

8
Data Sources

• Offline 2006 Parcels Data for the City of Rowlett
  (Originally from Dallas Central Appraisal
  District)
• Parcels Shape File contains spatial information.
• Appraisal table contains owner name, owner
  address, situs address, legal description, etc.
• Online 2007 Parcels data directly From Dallas
  Central Appraisal District Website (attribute
  information only)

9
Methodology

• ArcObjects
• Component Object Model (COM)
• Regular Expression
• ActiveX Data Objects (ADO)
• Structured Query Language (SQL)

10
Methodology ArcObjects

• ArcObjects are a set of objects specially
  designed for programming with ArcGIS Desktop
  applications.
• ArcObjects include objects like data frames,
  layers, features, tables, cartographic symbols,
  and the pieces that make up these things points,
  lines, tables, records, fields. colors, and so
  on.
• ArcObjects is built using Microsofts Component
  Object Model (COM) technology.
• In contrast, ArcObjects provides a complete
  objects model that replicates ArcGIS in its
  entirety. It provides a heavyweight solution for
  users to design their own GIS systems using ESRI
  technology.

11
Methodology COM

• COM is a set of programming standards developed
  by Microsoft.
• COM is a protocol that contains one software
  component, or module, with another.
• With COM, it is possible to build reusable
  components that can be dynamically interchanged
  in a distributed system.
• COM classes use interface to organize properties
  and methods.
• COM objects use COM interface to communicate with
  each other.
• All ArcMap and ArcCatalog classes are COM classes.

12
Methodology Regular Expression

• Regular Expression is a set of pattern matching
  rules encode in a string according to certain
  syntax rules.
• Regular Expression functions are available in
  many programming languages that allow for complex
  pattern matching and text manipulation.
• For example a regular expression could tell a
  programmer to search for all text lines that
  contain the word Windows XP and then to print
  out each line in which a match is found or
  substitute another text sequence (e.g. just
  Windows) where any match occurs.

13
Methodology ADO (ActiveX Data Objects)

• ADO is a set of COM classes for accessing
  database.
• ADO allows connections to database to be defined
  by a connecting string
• Once connected, SQL queries can be run on those
  database to inset new data, modify existing data
  or return results from them.

Object Linking and Embedding Database is an API
designed by Microsoft for accessing Different
types of data stores in an uniform manner. It is
a set of interfaces implemented using the COM.
Open Database Connectivity API drivers developed
by Microsoft to allow access to most Database
Management Systems.
14
Methodology SQL

• SQL (Structured Query Language) is a computer
  language aimed to store, manipulate, update, and
  retrieve data stored in database.
• UPDATE table_Name
• SET Column_Name New_Value
• WHERE Column_Name Some_Value
• UPDATE OwnerInfo SET Owner_Name Ella
  WHERE Owner_Address 400 Main Street

OwnerInfo Table

15
Implementation flow
16
Tool Interface

• Settings Allow the program to be used with GIS
  database of other cities

Stored in Setting Table
17
Tool Interface

• Search Parcels Interface

18
Tool Interface

• Python Script for automatic updating of appraisal
  data from online source

19
Tool Interface

• Calculate Area for Selected Parcels

Calculate selected parcels area
20
Case Study

• Search Parcels

21
Case Study

• Double Click on the Record in the List Box

22
Case Study

• Python Script for updating appraisal data

23
Case Study

• Generate Notification Report

24
Case Study

• Generating Mailing Labels

25
Case Study

• Generate Notification Map

26
Batch mode online GIS data updating

• Another program is also developed to
  automatically updated all parcel records online
  from DCAD website.

27
Conclusions

• Efficiency Compared to the repetitive and
  time-consuming procedure of manual notification,
  this application can quickly generate mailing
  labels with a few clicks.
• User Friendliness This application provides a
  user friendly tool interface useful for non-GIS
  urban planners in performing daily property
  notification tasks.
• Accuracy real-time online updating of appraisal
  data in this application improves data
  accuracy.
• Economy Its easy to implement without any
  additional cost for software.

28
My Contributions

• Geographic Information Systems are dependent on
  accurate and up-to-date data sets. The manual
  revision of GIS data is very costly and time
  consuming.
• Using python script for real-time update of GIS
  appraisal data from an online source is a fast
  and economic way to improve data accuracy.
• Data collection is still the major bottleneck for
  the wide-spread use of GIS. Therefore, any kind
  of automation is welcome. Using Python script to
  grab data can also be used to collect GIS data
  such as Sex offenders, churches, restaurants
  information from website. Geoprocessing can then
  be used to generate their locations based on
  addresses. Other attribute information can also
  be stored in a table to be linked with their
  location automatically.

29
Reference

• ESRI ArcObjects Online Help
• http//edndoc.esri.com/arcobjects/9.2/
• ESRI Developer Network
• lthttp//edn.esri.com/gt
• Robert Burke. 2003 Getting to know ArcObjects,
  ESRI Press
• Michael Zeiler. Exploring ArcObjects, ESRI Press
• Harvey M. Deitel, Paul J. Deitel, Jonathan P.
  Liperi, BA Wiedermann. 2002 Python How to
  Program, Prentice Hall
• Patricia Cardoza, Teresa Henning, Graham Seach,
  Armen Stein. 2003
• Access 2003 VBA Programmers Reference,
  Wrox

30
Application Demo
31
(No Transcript)
32
(No Transcript)