- Количество слайдов: 32
GISC 6389 GIS Master Project Automated Property Notification & Online Updating of Appraisal Data: A GIS Solution for Urban Planning u Jianghong Li u Advisor: Dr. Fang Qiu u Dr. Ron Briggs u Summer 2007
Overview u Introduction u Problem Statement u Project Objective u Literature Review u Data Source u Design & Implementation u Case Study u Conclusions u My Contributions u References u Application Demo
Introduction u Today GIS impacts nearly every aspect of local government and helps provide a foundation for integrating municipal services. u One of the most common applications of GIS in local government involves notifications to property owners The goal of this project: u Customize notification tools to identify parcels and determine the affected properties within predefined buffer distance. u Automated update of the selected properties’ database to ensure accuracy of property owners and their mailing addresses. u Generate notification report and create mailing labels which are ready to print. u All via a user friendly tool interface.
Problem Statement The current procedure for property notification: u Time Consuming: Take hours and hours to complete a single notification process. u Repetitive tasks: The whole process is redone every time a request is received. u Data accuracy: Incorrect data may be used due to data not up to date with appraisor’s records.
Project Objectives u Develop automated property notification tool to effectively support the urban planning process of local governments. u Develop automated program to update appraisal data from online web sources to enhance accuracy of data. u Develop a system suitable for an urban planner without extensive GIS experience.
Literature Review A few peer-reviewed papers are found to be directly relevant to the topic. u Applicability of GIS technology in urban planning, such as zoning, land use, transportation, and economic development planning; site selection, etc. u u Harris, B. , 1990. “Urban and Regional Planning in the Third World with Geographic Information System Support, ” Regional Development Dialogue 11(3): 17 -57. u u Budic, Z. D. , 1994. “Effectiveness of Geographic Information System in Local Planning, ” Journal of the American Planning Association. 60(2): 244 -264 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 u u Olajide Kufoniyi. , 1995. “Spatial coincidence modeling, automated database updating and data consistency in vector GIS, ” Wageningen Agricultural University, 90 -6164 -105 -5 u u Volker Walter, Stuttgart. , 1999. “Automated GIS data collection and update, ” Photogrammetric Week '99. Fritsch and R. Spiller (Eds. ), Wichmann Verlag, Heidelberg, pp. 267 -280 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
Similar Applications u Mailing Label Wizard for Arc. GIS (An extension to ESRI’s Arc. Map) 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. u 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 u 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. u NCTCOG Arc. IMS 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.
Data Sources u Offline 2006 Parcels Data for the City of Rowlett (Originally from Dallas Central Appraisal District) u u u 1: 1 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)
Methodology u Arc. Objects u Component Object Model (COM) u Regular Expression u Active. X Data Objects (ADO) u Structured Query Language (SQL)
Methodology: Arc. Objects u Arc. Objects are a set of objects specially designed for programming with Arc. GIS Desktop applications. u Arc. Objects 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. u Arc. Objects is built using Microsoft’s Component Object Model (COM) technology. u In contrast, Arc. Objects provides a complete objects model that replicates Arc. GIS in its entirety. It provides a heavyweight solution for users to design their own GIS systems using ESRI technology.
Methodology: COM u COM is a set of programming standards developed by Microsoft. u COM is a protocol that contains one software component, or module, with another. u With COM, it is possible to build reusable components that can be dynamically interchanged in a distributed system. u COM classes use interface to organize properties and methods. u COM objects use COM interface to communicate with each other. u All Arc. Map and Arc. Catalog classes are COM classes.
Methodology: Regular Expression u Regular Expression is a set of pattern matching rules encode in a string according to certain syntax rules. u Regular Expression functions are available in many programming languages that allow for complex pattern matching and text manipulation. u 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.
Methodology: ADO (Active. X Data Objects) u ADO is a set of COM classes for accessing database. u ADO allows connections to database to be defined by a connecting string u 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.
Methodology: SQL u 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 Owner. Info SET Owner_Name = ‘Ella’ WHERE Owner_Address = ‘ 400 Main Street’ Owner. Info Table Owner_Name Owner_Address Jianghong Li 400 Main Street Dustin 2813 Lakefield Dr. Owner_Name Owner_Address Ella 400 Main Street Dustin 2813 Lakefield Dr.
Tool Interface u Settings: Allow the program to be used with GIS database of other cities Stored in Setting Table
Tool Interface u Search Parcels Interface
Tool Interface u Python Script for automatic updating of appraisal data from online source Python Script program to grab data from DCAD website
Tool Interface u Calculate Area for Selected Parcels Calculate selected parcels’ area Assemble comments from property owners: If there is greater than 20% opposition then a super-majority vote(4 out of 5) is required by the City Council for approval. Otherwise, a simple majority(3 out of 5) vote will do.
Case Study u Search Parcels Display all matched Parcels.
Case Study u Double Click on the Record in the List Box Selected Parcels’ information will stored in MS Access Focus Parcel
Case Study u Python Script for updating appraisal data Python Script EXE File for Updating Selected Parcels Data
Case Study u Generate Notification Report Before Updating data After Updating data
Case Study u Generating Mailing Labels Duplicate records only print one Before updating data After Updating Data
Case Study u Generate Notification Map
Batch mode online GIS data updating u Another program is also developed to automatically updated all parcel records online from DCAD website. Test 100 records Python Script
Conclusions u Efficiency: Compared to the repetitive and time-consuming procedure of manual notification, this application can quickly generate mailing labels with a few clicks. u User Friendliness: This application provides a user friendly tool interface useful for non-GIS urban planners in performing daily property notification tasks. u Accuracy: real-time online updating of appraisal data in this application improves data accuracy. u Economy: It’s easy to implement without any additional cost for software.
My Contributions u 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. u 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. u 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. O g Re r ula Ex s es pr io n& AD
Reference u ESRI Arc. Objects Online Help http: //edndoc. esri. com/arcobjects/9. 2/ u ESRI Developer Network