The Nuts & Bolts of GIS: Data Architecture

The Nuts & Bolts of GIS: Data Architecture

The Nuts & Bolts of GIS: Data Architecture & GIS! Presented By: John Woodard, MS Chagrin Valley Engineering What is the one item every GIS person must have? ENTERPRISE ARCHITECTURE (EA) What is it? How does it impact GIS? Where does GIS fit into an EA? Enterprise architecture is a comprehensive framework used to manage and align an organization's Information Technology (IT) assets, people, operations, and projects with its operational characteristics. In other words, the enterprise architecture defines how information and technology will support the business operations and provide benefit for the business. - National Institutes of Health Enterprise Architecture https://enterprisearchitecture.nih.gov/pages/what.aspx A BLUEPRINT OR FRAMEWORK Zachman Framework Dept. of Defense Architecture Framework (DoDAF) Federal Enterprise Architecture Framework (FEAF) The Open Group Architecture Framework (TOGAF) A FEW POSTIONS IN THE ENTERPRISE DESIGN

Enterprise Business Architect Architect Information Architect Technology Architect Procedure/Event Architect There can be many more!!!!!! WHAT ABOUT CONTENT? Enterprise Content Management (ECM) What is content? Documents (Project thoughts, Records Email Digital Assets (Downloads, Archiving, etc.) Digital Rights (Protecting Intellectual or copyright) Drawings (Maps, CAD, Paper, etc) AIIM. What is Enterprise Content Management (ECM)? MODELS &

INVENTORIES Strategic CYBER DRAGONS ON A PAGE INNOVATION --------------INFO/DATA CONSULTING ---------------RESEARCH & DEVELOPMENT Operational - PURSURE PARTNERED RESEARCH OPPURTUNITIES - SUPPORT WORK IN APPLICATION RESEARCH - ENCOURAGE INDIVIDUAL RESEARCH -SUPPORT SOFTWARE INNOVATION -PARTICIPATE IN NEW TECHNOLOGY DEVELOPMENT PROGRAMMING -WORK IN PYTHON, VBA, & DOT NET -FIND OPPORTUNITIES FOR CONSULTING. -DEVELOP WEB PAGES -CREATE RELATIONSHIPS WITH MUNICIPALITIES - WORK WITH OPEN SOURCE -DATABASE & GIS MODULES -CREATE SOFTWARE - CREATE NEW TECHNOLOGY -CREATE NEW APPS Enabling GEOGRAPHIC INFORMATION SYSTEM - USE OPEN SOURCE SOLUTIONS -PURSUE WEB BASED CLIENTS/SOLUTIONS ADVISING - PURSUE OPPORTUNITIES FOR CONSULTING.

- PROVIDE THE BEST ADVICE& OPPORTUNITIES FOR CLIENTS - ENCOURAGE COOPERATION WITH PRIVATE/PUBLIC SECTORS TEACHING - PROVIDE THE BEST INSTRUCTION FOR GIS - PROVIDE THE BEST INSTRUCTION FOR DATABASE/WEB PROGRAMS - PROVIDE THE BEST MENTORING FOR INTERN/CLIENTS -PARTNER OTHERS TO INCREASE OPPURTUNITIES 1. ENCOURAGE INTERNAL RESEARCH COLLOBORATION 2. ATTRACT AND RETAIN TALENTED WORKERS 3. ENCOURAGE EXTERNAL PARTNERSHIPS 6. FULFILL ALL CONTRACT AND LEGAL OBLIGATIONS 11. MANAGE FINANCIALS 7. MANAGE COMPANY RISK 12. MANAGE INFORMATION 8. PROVIDE A NURTURING WORK ENVIROMENT 13. COMMUNITY MEMBER 4. ENCOURAGE ASSOCIATION MEMBERSHIP 9.MAINTAIN WORK FOR SKILLS 5. SUPPORT CONFERENCE ATTENDANCE & PARTICIPATION. 10. PROVIDE A GOOD BENEFIT PACKAGE 11/9/13 CYBER-DRAGONS ARCHITECTURE Cyber-Dragons will provide IT, Information, GIS, programming and consulting services. 1.0 CREATE STABILITY CONTROL CLIENT & EMPLOYEE LOSS 2.0 BE PROFITABLE ELIMINATE UNECESSARY

EXPENSES 3.0 GROWTH 4.0 PRODUCT RANGE 5.0 SERVICES 6.0 SATISFACTIO N 4.1 GAMES ADD CLIENTS ADD CONTRACTS MOBILE DEVICES DESKTOPS ONLINE 4.2 APPLICATIONS MOBILE DEVICES DESKTOPS ONLINE 5.1 GIS Consulting 6.1 Clients 5.2 IT Consulting 6.2 Owners 5.3 Information Consulting 6.3 Employees 4.3 WEBSITES ADD PRODUCTS TURNKEY SITES CUSTOM SITES 4.4 GIS Mobile Apps Desktop Apps Programs CVE GIS DIVISON GOAL STATEMENT: ESTABLISH A GEOGRAPHIC INFORMATION SYSTEM (GIS) Goal Contributes

To (Vision) Goal Hiearchy ID Goal Name GIS SYSTEM 1.0 GIS SYSTEM 1.0 1.1 Eliminate System Redudancies 1.0 1.2 1.0 Intended Results Measurements A GIS that responds quickly to the needs of CVE or clients. The amount of positive feedback Eliminate, Remove, Prevent redudancies occurring in the GIS system. A streamlined mapping and data flow Timed saved/Number of duplicate fil es/Employee feedback User Friendly Make the system quick and easy to understand Create a system that is easy to learn and use. User feedback/number of users/ 1.3 Keep Technology updated Keep system hardware & tech current. Prevent system response lag times. Prevent "rush" or reactiv e upgrades to

software & technology. Use automated scripts & hardware specs to compare the company hardware vs market. GIS DATA 2.0 ACCURATE DATA Eliminate Inaccuracies in the the GIS informaiton To create a accurate dataset that is trusted by GIS users. 2.0 2.1 Clean data Develop a data "scrubbing" model Automate basic data cleaning methods 2.0 2.2 data/information standards Develop data/information standards about how to use, import, collect or distribute the datasets. 2.0 2.3 Data Security Develop standards, methods, and procedures for protecting company & client sensitive data. 2.0 2.4 Data backup Create an effi cient and redundant data/info back up system. GIS GROWTH 3.0

GROW THE GIS SYSTEM Expand the GIS system 3.0 3.1 Grow users Add CVE users & client users 3.0 3.2 Grow contracts Add new outside contracts for GIS work Create GIS Growth with new projects. Number of contracts signed each year 3.0 3.3 Recurring work Establish recurring or renewing contracts (bread & butte r work) Steady & recurring work Number of contracts per month 3.0 3.4 Growth thru GIS Consulting Contract analysis, programming, system design Produce a measurable value for GIS Contracts net monetary worth for CVE. 3.0 3.5 Growth through products Create new applications, programs, & mobile products Establish a foundation of products Number of new products added or

developed GIS SATISFACTION 4.0 User Satisfaction Clients, Partners, Employees satisfie d with the system. Retention How many repeats or employee loss Gain support for the GIS & GIS expansion Positive review from the 7 partners. 4.0 4.1 4.0 4.2 4.0 4.3 Partners Satisfaction Customer Satisfaction CVE Employees Satisfaction Description of Achievement Create an effi ecient (GIS) Satisfied with company production, services, and performances. Satisfie d with the company's work, services, and deliverables Satisfie d and develop trust in the GIS system. Decrease in errors/Decrease number of data "fixes"/Decrease complaints about dataset errors Decrease the time & manpower required to clean datasets/Increase the accuracy of the dataset. Maintain a consistent methodology for Reduce the number of data "misuse or working with company data. Remove released" incidents" over the course of confusion about what can be done with a business quarter. the information. Reduce the number of loss, accidents

Prevent the misuse, loss or theftof or theftincidents over the course of a company or client data/information. business year. Prevent a catastrophic loss of Log the number of times data reloaded information in times of computer/server from back up due to failure or user failure. error. Track number of CVE employees, Obtain more users for the system Clients, and Projects using the GIS. Gain new clients & prevent loss Number of new users added in year Retention & support for continuing GIS operations/expanision. Build support and trust for GIS services. Positive comments to CVE partners. Positive comments to the CVE GIS staff & Partners. ORGANIZATIONAL ROLES Roles are used in models to show who preforms the task associated with a capability or process. A role normal identifie s a single staffposition that performs the operation; however, a role may also describe an operation that is performed by more than one staffposition. The roles identifie d for any given project do not encompass the many hundreds of job titles in Chagrin Valley Engineering (CVE). Instead they represent the most common job titles in the proposed CVE GIS Division for support, professional and senior staff. ROLE NAME DESCRIPTION Description of Roles: Oversees and manages all aspect of the GIS department operations, is the liaison between unit staff, engineers, surveyors, CAD techs, and company owners. GIS Manager Applicable Job Titles: Varied: GIS Coordinator, Department Head, Description of Roles: Assists GIS Manager in supervising GIS operations and staff, Project manager for GIS projects Performs advanced GIS analysis and mapping, recommends staffto project vacancies, oversees training for GIS staff& interns. GIS Analyst Applicable Job Titles: Varied: Assistant Manager, Senior Staff, Senior Lead, Team Leader, Description of Roles: Performs GIS analysis and mapping, manages interns, manages data collection procedures, GIS Specialist Applicable Job Titles: Varied: GIS Analyst 1, Senior GIS Tech, Asst. Team Leader Description of Roles: Provides programming support for GIS applications, develops mobile applications ( smart phones, GPS units, Tablets) GIS Developer Applicable Job Titles: Varied: GIS Application Specialist, GIS Programmer Description of Roles: Performs cartographic dutie s, basic GIS Analysis, mentors Interns GIS Technician Applicable Job Titles: Varied: Cartographer 1, GIS Staff Description of Roles: Field Data Collection & verification, basic mapping, digitizing of infrastructure data GIS Intern Applicable Job Titles: Varied: Student, Temporary Employee, Contract Staffe r Description of Roles: Secretarial dutie s, manage meeting schedule, restock supplies

GIS Clerk Applicable Job Titles: Varied: Office manager, Secretary, Administrative Assistant ID 1 APPLICALTION ArcGIS VERSIO N 10.1 APPLICATION INVENTORY LEVEL Basic VENDOR ESRI ASSOCIATED BUSINESS CAPABILITY GIS 2 ArcReader 10.1 Basic ESRI GIS 3 ETGeoWizards 10 N/A ET GIS 4 ETGeoTools 10

N/A ET GIS 5 Adobe Acrobat Pro 8 PRO Adobe GIS / TEACHING / ADVISING / PROGRAMMING/RESEARCH & DEVELOPMENT Adobe GIS / TEACHING / ADVISING / PROGRAMMING/RESEARCH & DEVELOPMENT Adobe GIS / TEACHING / ADVISING / PROGRAMMING/RESEARCH & DEVELOPMENT Adobe GIS / TEACHING / ADVISING / PROGRAMMING/RESEARCH & DEVELOPMENT MicroSoft GIS / TEACHING / ADVISING / PROGRAMMING/RESEARCH & DEVELOPMENT MicroSoft GIS / TEACHING / ADVISING / PROGRAMMING/RESEARCH & DEVELOPMENT MicroSoft GIS / TEACHING / ADVISING / PROGRAMMING/RESEARCH & DEVELOPMENT 6 7

8 9 10 11 Adobe Photoshop Adobe Dreamweaver Adobe Fireworks MicroSoft Word MicroSoft Excel MicroSoft Powerpoint 4 4 4 2007 2007 2007 N/A N/A N/A N/A N/A N/A FAMILY DESCRIPTION GIS program SOFTWARE THAT ENABLES A USER TO CREATE DATABASES, QUERY INFORMATION, AND PERFORM INFORMATION MAPPING GIS program A FREE GIS VIEWER THAT CAN

READ ONLY .PMF FILES FROM ARCGIS. PROVIDES A SUITE OF GIS EDITING TOOLS EDITING TOOLS TO ARCGIS BASIC PROVIDES A SUITE OF GIS EDITING TOOLS EDITING TOOLS TO ARCGIS BASIC ALLOWS USER TO CREATE AND EDIT PDFS. ALSO ALLOWS CREATION OF MULTIPDF Tool Suite FILE PDFS GRAPHIC DESIGN GRAPHIC DESIGN GRAPHIC DESIGN OFFICE OFFICE OFFICE SOFTWARE THAT ALLOWS USER TO EDIT AND MANIUPLATE DIGITAL IMAGES. SOFTWARE THAT ALLOWS USER TO CREATE, EDIT & UPDATE WEBSITES OR PAGES. SOFTWARE THAT ALLOWS USER TO CREATE, EDIT IMAGES OR GRAPHICS FOR WEBSITES AND WEB PAGES. SOFTWARE THAT ALLOWS USER TO CREATE, EDIT WORD DOCUMENTS FOR CLIENTS, BUSINESS OR GIS. SOFTWARE THAT ALLOWS USER TO CREATE, EDIT SPREADHEETS OF DATA FOR THE BUSINESS OR GIS. SOFTWARE THAT ALLOWS USER TO CREATE, EDIT PRESENTATIONS FOR CLIENTS OR THE BUSINESS. OTHER APP DEPENDENCY MS: Word, Excel, Access, ET:GeoWizards, GeoTools, Adobe: Photoshop, Dreamweaver

#LICENSES STATUS # USERS 3 ACTIVE 3 ESRI ArcGIS 20 ACTIVE 35 ESRI ArcGIS 1 ACTIVE 1 ESRI ArcGIS 1 ACTIVE 1 ANY FILE TO BE CONVERTED TO PDF 4 ACTIVE 4 NONE 1 ACTIVE 1 MS: Word, Excel, Access, Adobe: Photoshop, Fireworks 1 ACTIVE

1 MS: Word, Excel, Access, Adobe: Photoshop, Dreamweaver 1 ACTIVE 1 NONE 35 ACTIVE 35 NONE 35 ACTIVE 35 NONE 10 ACTIVE 10 THANK YOU FOR YOUR TIME! DO YOU HAVE ANY QUESTIONS? CONTACT INFO: JOHN R. WOODARD CHAGRIN VALLEY ENGINEERING, LTD 440-439-0841 [email protected] OR [email protected]

Recently Viewed Presentations

  • Gestures That Can Cause Offense Around the World

    Gestures That Can Cause Offense Around the World

    In Turkey, that sign is also an insult toward gay people. So aside from keeping your hands firmly in your pockets while you are traveling, what can you do to ensure that you don't insult the locals or end up...
  • INTRO to GIS

    INTRO to GIS

    Feature: Spatial Relationship. 1. Which cities are within 50 kilometers of a river? 2. Which countries have a river that crosses their border? 3. which countries share a border with China?
  • Poetry Sound Devices Meter poetry's rhythm, or its

    Poetry Sound Devices Meter poetry's rhythm, or its

    Half Rhyme (Slant Rhyme): imperfect, approximate rhyme. In the . mustardseed. sun. By full tilt river and switchback sea. Where the cormorants scud, In his house on stilts high among beaks. Dylan Thomas. Poem on His Birthday
  • SVR 323  Windows Server   Windows Server 2003    Windows

    SVR 323 Windows Server Windows Server 2003 Windows

    应用1 应用2 应用3 应用n 部门a 部门b 部门z 缺陷1:据统计数据中心服务器的平均使用率低于 30%,但仍有相当数量的服务器无法满足其服务水平目标 缺陷2:一个新应用的部署需要历经预算、采购、安装测试、上线等过程,周期长达数周至数月,难以及时响应业务 ...
  • WHAT IS TAEKWONDO?  Taekwondo is a Korean self

    WHAT IS TAEKWONDO? Taekwondo is a Korean self

    WHAT IS TAEKWONDO? Taekwondo is a Korean self defence martial art which in English translates as foot and hand way. It dates back from the 19th century, and is well known for focusing on a variety of kicking techniques derived...
  • Y H P RA G EO IA G

    Y H P RA G EO IA G

    GEOGRAPHY OF EARLY INDIA LESSON 1 GEOGRAPHY AND EARLY INDIA The Big Idea Indian civilization first developed on the Indus River. Main Ideas The geography of India includes high mountains, great rivers, and heavy seasonal rain. Harappan civilization developed along...
  • CSE 142 Python Slides - GitHub Pages

    CSE 142 Python Slides - GitHub Pages

    Primitive types The primitive types on the Advanced Placement Computer Science A exam are: int - which store integers (whole numbers like 3, -76, 20393) double - which store floating point numbers (decimal numbers like 6.3, -0.9, and 60293.93032) boolean...
  • Andre-Adolphe Disderi (French, 1819-1890), uncut sheet of (8 ...

    Andre-Adolphe Disderi (French, 1819-1890), uncut sheet of (8 ...

    Max Kozloff Nadar, Sarah Bernhardt, 1863 Nadar, Georges Sand, 1877 Rossetti, Elizabeth Siddal Kneeling, Playing a Double Pipe, pencil on paper, 1854 Cameron's Dimbola Lodge on the Isle of Wight Cameron, Alfred Lord Tennyson, 1865, one of Cameron's famous artist...