august 2007 aims coordinators meetingolathelocate olathelocate: an address/environs lookup tool
TRANSCRIPT
![Page 1: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/1.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
OlatheLocate:OlatheLocate:An Address/Environs Lookup ToolAn Address/Environs Lookup Tool
![Page 2: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/2.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
DESIGNDESIGN DATADATA WEBWEB
![Page 3: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/3.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
HOW IS THEHOW IS THEBEST WAYBEST WAY
TO PRESENT THE DATA?TO PRESENT THE DATA?
WHY?WHY?IS THERE A NEED?IS THERE A NEED? WHO IS THEWHO IS THE
TARGET AUDIENCE?TARGET AUDIENCE?
IS THE IS THE DATADATA AVAILABLE? AVAILABLE?WHERE IS IT LOCATED?WHERE IS IT LOCATED?
Design Design ConcernsConcerns
Design Design ConcernsConcerns
WHAT DATA NEEDSWHAT DATA NEEDSTO BE INCLUDED?TO BE INCLUDED?
![Page 4: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/4.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
1. Staff recommendation1. Staff recommendation
2. Need to present building activity 2. Need to present building activity
3. Consolidation of information 3. Consolidation of information
4. Format for zoning requests4. Format for zoning requests
Why? Is there a need?Why? Is there a need?
![Page 5: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/5.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
Internal Internal
Development Services Staff Development Services Staff
External External
DevelopersDevelopers
Who is the Target Audience?Who is the Target Audience?
Residents Residents
Appraisers Appraisers
![Page 6: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/6.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
SQLSQL
PermitsPlus PermitsPlus
SDE SDE
MasteraddrMasteraddr
IS THE DATA AVAILABLE?IS THE DATA AVAILABLE?WHERE IS IT LOCATED?WHERE IS IT LOCATED?
Service Districts Service Districts
Misc Misc
![Page 7: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/7.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
OlatheLocateOlatheLocate
PropertyPropertyInformationInformation
P+ P+ FC ViewsFC Views
SchoolSchoolInformationInformation
GovernmentalGovernmentalInformationInformation
![Page 8: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/8.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
1. Permits Plus DB – SQL Server1. Permits Plus DB – SQL Server
•Permits: Building, Zoning, Signs•Property Maintenance Cases
•Permits: Building, Zoning, Signs•Property Maintenance Cases
2. GIS ArcSDE DB – SQL Server 2. GIS ArcSDE DB – SQL Server
•Address Points•Address Points
OlatheLocate DATAOlatheLocate DATA
![Page 9: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/9.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
• Tables– Building Permits, Sign Permits, Property Maintenance
Cases, Zoning Violations• TAB_STYP• APD_BASE• APD_ADR• ADR_BASE
– Property Maintenance Cases• APD_PAR
– Zoning Violations• APD_PEO• APD_TXT0
• Linked Server with SDE SQL DB• Views created on ORTHOD DB on GIS Server
PermitsPlus DB (SQL)PermitsPlus DB (SQL)
![Page 10: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/10.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
• Views of P+ data in ORTHOD DB– Building Permits– Property Maintenance Cases– Sign Permits– Zoning Violations
• Views exported as Feature Classes to GIS DB
• Views created on GIS DB for each year
GIS and Ortho DBGIS and Ortho DB
![Page 11: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/11.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
![Page 12: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/12.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
![Page 13: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/13.jpg)
![Page 14: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/14.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
Two types of searches: Two types of searches:
My AddressMy Address
My EnvironsMy Environs
OlatheLocate websiteOlatheLocate website
![Page 15: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/15.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
My Address My Address
Single addressSingle address
My EnvironsMy Environs
OlatheLocate websiteOlatheLocate website
Multiple addresses Multiple addresses
Buffer (500 ft) Buffer (500 ft)
![Page 16: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/16.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
Driven by ArcIMS Driven by ArcIMS
Query tools:Query tools:
Attribute queriesAttribute queries
OlatheLocate websiteOlatheLocate website
Location queries (buffer) Location queries (buffer)
Map display – custom navigation Map display – custom navigation
![Page 17: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/17.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
My AddressMy Address
My EnvironsMy Environs
![Page 18: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/18.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
My AddressMy Address
![Page 19: August 2007 AIMS Coordinators MeetingOlatheLocate OlatheLocate: An Address/Environs Lookup Tool](https://reader036.vdocuments.us/reader036/viewer/2022070400/56649f115503460f94c237b2/html5/thumbnails/19.jpg)
AIMS Coordinators MeetingAIMS Coordinators Meeting OlatheLocateOlatheLocate August 2007August 2007
My EnvironsMy Environs