112 east main street frankfort, kentucky 40601 tel 502 223-1501 fax 502 223-1235
TRANSCRIPT
![Page 1: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/1.jpg)
112 East Main StreetFrankfort, Kentucky 40601tel 502 223-1501Fax 502 223-1235www.plangraphics.com
![Page 2: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/2.jpg)
An Enterprise Approach to Land Records Management
WLIA Conference 2003
Annie MetcalfJanette Lovely
PlanGraphics, Inc.
February 13, 2003
![Page 3: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/3.jpg)
Presentation OverviewPresentation Overview
• IntroductionIntroduction
• BackgroundBackground
• Maintenance ApproachMaintenance Approach
• Application DemonstrationApplication Demonstration
• QuestionsQuestions
![Page 4: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/4.jpg)
Before GISBefore GIS
![Page 5: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/5.jpg)
Implementation ApproachImplementation Approach
• Phase 1 -- Proof of Concept(2000-2002)Phase 1 -- Proof of Concept(2000-2002)– Data Development Data Development – Support Strategic InitiativesSupport Strategic Initiatives– Application Development Application Development – System Integration and CoordinationSystem Integration and Coordination– GIS Implementation Using Outside AssistanceGIS Implementation Using Outside Assistance
![Page 6: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/6.jpg)
Software ConfigurationSoftware Configuration
New World
PoliceDepartment
FireHouse
Fire Department
Other
Other Departmental
Systems
AutoCAD
Computer-aided
Drawing
Govern Universe
CAMA
ArcPAD
GPS Data
Collection
Web Server(Future)
ArcView 8.2
Custom QueriesCustom Mapping
Analysis
ArcIMS
Query ViewInternet Access
ArcGIS
Analysis Data
SQL
Server
ArcSDE 8.2
Data Management
GIS DataWarehouse
![Page 7: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/7.jpg)
DataData
• Lots of digital data in various formatsLots of digital data in various formats– Genamap, AutoCAD, shape files, flat filesGenamap, AutoCAD, shape files, flat files
• Contracted data conversion Contracted data conversion
• Conversion to Coverages, SQL tables and Conversion to Coverages, SQL tables and SDE layersSDE layers
• Data ThemesData Themes
![Page 8: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/8.jpg)
ApplicationsApplications
• QC applicationQC application
• ArcView ProjectsArcView Projects
• ArcIMS applicationsArcIMS applications– Standard QueryStandard Query– Standard MappingStandard Mapping
• Data Maintenance ToolsData Maintenance Tools
![Page 9: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/9.jpg)
![Page 10: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/10.jpg)
![Page 11: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/11.jpg)
![Page 12: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/12.jpg)
![Page 13: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/13.jpg)
![Page 14: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/14.jpg)
ImplementationImplementation
Phase 2 -- Extended ImplementationPhase 2 -- Extended Implementation– 2002 and Beyond2002 and Beyond– Technology Transfer/Mentoring to City StaffTechnology Transfer/Mentoring to City Staff– Support Operations, Database Maintenance, and UsersSupport Operations, Database Maintenance, and Users– Support Strategic Initiatives with maps and products Support Strategic Initiatives with maps and products – User Training – 3 TiersUser Training – 3 Tiers– System Integration- Govern, Fire House, Police RMS, System Integration- Govern, Fire House, Police RMS,
Appraisal systemAppraisal system– Database Improvements/EnhancementsDatabase Improvements/Enhancements– Intranet/Internet GIS Query ApplicationIntranet/Internet GIS Query Application
![Page 15: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/15.jpg)
City of Franklin: GISCity of Franklin: GIS
• Tangible Impact on:Tangible Impact on:– Efficiency, service levels, effectivenessEfficiency, service levels, effectiveness– Management of growthManagement of growth– Increasing staff capabilities Increasing staff capabilities
• Users in every department – Daily use by over Users in every department – Daily use by over 25 staff members25 staff members
• Latest proven technologiesLatest proven technologies• Achieves early successesAchieves early successes
![Page 16: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/16.jpg)
Maintenance Workflow Before GIS
GOVERNSoftware
AssessorEngineeringUtility Billing
UNIVERSSoftware
AutoCAD Plat MapsCadastral
Maps
Fire
Map Book
GOVERN Database
SQL Server 2000
Windows 2000
CLT Database
Windows 2000
![Page 17: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/17.jpg)
GIS Data Architecture
SQL Server 2000__________________
ArcSDE 8.2
Windows 2000
![Page 18: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/18.jpg)
System Integration
ArcGIS 8.2(ArcView)
SQL Server 2000__________________
ArcSDE 8.2
ArcGIS 8.2(ArcInfo)
ArcPad ArcIMS 4.0
FIREHOUSE____________
Fire
EnforcerTechnology
____________Police
GCS____________
PlanningTreasurer
GOVERN____________
Utility Billing
UNIVERS____________
Assessor
AutoCAD____________
Engineering
Cartegraph____________
Engineering
Windows 2000
![Page 19: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/19.jpg)
Maintenance Tools - Maintenance Tools - TechnologyTechnology
• Visual BasicVisual Basic
• ArcGIS 8.2ArcGIS 8.2
• ArcSDE 8.2ArcSDE 8.2
• SQL Server 2000SQL Server 2000
![Page 20: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/20.jpg)
Maintenance Workflow After GIS
ParcelMaintenanceApplication
GOVERNSoftware
GOVERN Database
SQL Server 2000
Windows 2000
SQL Server 2000__________________
ArcSDE 8.2
Windows 2000
GIS Database
AssessorEngineeringUtility Billing
Export
UNIVERSSoftware
TransferTables
OwnerNames
FIREHOUSESoftware
ExportIncident
PointLocator
FIREHOUSEDatabase
Windows2000
Fire
Windows2000
CLTDatabase
![Page 21: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/21.jpg)
GIS/GOVERN Integration
ParcelMaintenanceApplication
GOVERNSoftware
GOVERN Database
SQL Server 2000
Windows 2000
SQL Server 2000__________________
ArcSDE 8.2
Windows 2000
GIS Database
TransferTables
ArcGIS 8.2(ArcInfo)
![Page 22: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/22.jpg)
GIS/UNIVERS Integration
ParcelMaintenanceApplication
VB ExportUtility
UNIVERSSoftware
SQL Server 2000__________________
ArcSDE 8.2
Windows 2000
ArcGIS 8.2(ArcInfo)
![Page 23: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/23.jpg)
GIS/FIREHOUSE Integration
ArcGIS 8.2(ArcView)
FIREHOUSESoftware
ExportIncident
PointLocator
Map Book
FIREHOUSEDatabase
Windows2000
SQL Server 2000__________________
ArcSDE 8.2
Windows 2000
GIS Database
![Page 24: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/24.jpg)
Relationship Between Tools
Parcels
Buildings
Ownership
Base &Address
Condos Subdivisions CSM ROW BuildingsAssessor
Edits
BuildingAttributes
Create NewBuilding
Link Buildingto Parcels
DemolishBuilding
UpdateParcel
Assessment
AddAssessment
SingleOwnershipTransfer
MassOwnershipTransfer
Split
CombineUpdate Tax
Key
Create NewBuilding Link Building
to Parcel RemoveBuilding
From Parcel MarkBuilding asDemolished
Edit Tools
Subdivisions
ParcelAttributes
Create NewParcels
![Page 25: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/25.jpg)
Startup
![Page 26: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/26.jpg)
Startup
![Page 27: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/27.jpg)
Select Parcel
![Page 28: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/28.jpg)
Parcel Edits – Base & Address
![Page 29: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/29.jpg)
Parcel Edits – Ownership
![Page 30: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/30.jpg)
Parcel Edits - Buildings
![Page 31: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/31.jpg)
Condo
![Page 32: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/32.jpg)
Adjust Parcels with Condo Boundary
![Page 33: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/33.jpg)
Edit Condo Boundary Attributes
![Page 34: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/34.jpg)
Subdivision
![Page 35: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/35.jpg)
Adjust Parcel with Subdivision Boundary
![Page 36: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/36.jpg)
Edit Subdivision Boundary Attributes
![Page 37: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/37.jpg)
CSM
![Page 38: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/38.jpg)
Adjust Parcel with CSM Boundary
![Page 39: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/39.jpg)
Edit CSM Boundary Attributes
![Page 40: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/40.jpg)
ROW
![Page 41: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/41.jpg)
Adjust Parcel to ROW
![Page 42: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/42.jpg)
Edit ROW Attributes
![Page 43: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/43.jpg)
Assessor Edits – Existing Assessment
![Page 44: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/44.jpg)
Assessor Edits – New Assessment
![Page 45: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/45.jpg)
Single Ownership Transfer
![Page 46: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/46.jpg)
Mass Ownership Transfer
![Page 47: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/47.jpg)
Building Update
![Page 48: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/48.jpg)
Add a New Building
![Page 49: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/49.jpg)
Link Building to Property
![Page 50: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/50.jpg)
Parcel Graphic Edits
![Page 51: 112 East Main Street Frankfort, Kentucky 40601 tel 502 223-1501 Fax 502 223-1235](https://reader035.vdocuments.us/reader035/viewer/2022062515/56649f465503460f94c67a61/html5/thumbnails/51.jpg)
Building Graphic Edits