190 likes | 299 Views
OlatheLocate: An Address/Environs Lookup Tool. DESIGN. DATA. WEB. Who? What? Why?. GIS SQL FC Views. ArcIMS. WHY? IS THERE A NEED?. WHO IS THE TARGET AUDIENCE?. Design Concerns. HOW IS THE BEST WAY TO PRESENT THE DATA?. WHAT DATA NEEDS TO BE INCLUDED?.
E N D
OlatheLocate: An Address/Environs Lookup Tool OlatheLocate
DESIGN DATA WEB Who? What? Why? GIS SQL FC Views ArcIMS OlatheLocate
WHY? IS THERE A NEED? WHO IS THE TARGET AUDIENCE? Design Concerns HOW IS THE BEST WAY TO PRESENT THE DATA? WHAT DATA NEEDS TO BE INCLUDED? IS THE DATA AVAILABLE? WHERE IS IT LOCATED? OlatheLocate
Why? Is there a need? 1. Staff recommendation 2. Need to present building activity 3. Consolidation of information 4. Format for zoning requests OlatheLocate
Who is the Target Audience? Internal Development Services Staff External Developers Residents Appraisers OlatheLocate
IS THE DATA AVAILABLE? WHERE IS IT LOCATED? SQL PermitsPlus SDE Masteraddr Service Districts Misc OlatheLocate
Property Information P+ FC Views School Information Governmental Information OlatheLocate OlatheLocate
OlatheLocate DATA 1. Permits Plus DB – SQL Server • Permits: Building, Zoning, Signs • Property Maintenance Cases 2. GIS ArcSDE DB – SQL Server • Address Points OlatheLocate
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) OlatheLocate
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 DB OlatheLocate
OlatheLocate website Two types of searches: My Address My Environs OlatheLocate
OlatheLocate website My Address Single address My Environs Multiple addresses Buffer (500 ft) OlatheLocate
OlatheLocate website Driven by ArcIMS Query tools: Attribute queries Location queries (buffer) Map display – custom navigation OlatheLocate
My Address My Environs OlatheLocate
My Address OlatheLocate
My Environs OlatheLocate