# Presentation: 372358

## GIS Infobase

- User Training
- GIS Coordinator Meeting
- February 22, 2000

- Tom Erkert
- (old GIS Coordinator)

- Gis Infobase

## Introduction 

- How to Implement GIS Infobase
- Learn how to install, input, edit, and produce output
- Learn how to complete Metadata and produce web page output
- Learn what the Request Module is for

- Gis Infobase

## Agenda

- Setup
- General Editing Procedures
- Metadata
- Request

- Gis Infobase

## Overview 

- GIS Infobase has 2 components:
- Metadata
- Work Requests
- Architecture

- Gis Infobase

## Setup

- Download Application
- Expand the Application File
- Server Side Setup
- Client Side Setup
- Getting Started

- Gis Infobase

## Setup – Download 

- Self Extracting File
**http://www.reo.gov/reo/projects/tools/infobase/infobase.htm**
- Place in temp directory
- Expand File
- Run Setup
**DO NOT PLACE IN DEFAULT PATH**
- No spaces in path, Metadata Parser aborts
- Upgrade Jet Database Engine

- Gis Infobase

## Setup – What’s there?

- Application Directory
- DbGen – Schema creation scripts
- Doc – User Guide
- Internet – Misc. files, need copy of all graphics
- Copy contents to Intranet
- Intranet – ASP and graphics
- Copy contents to Internet
- Library – Crucial files to fix Jet Database Engine
- fix_jet.bat
- JetSP4.exe (installed with fix_jet.bat)

- Gis Infobase

## Setup – Server Side

- Move scripts over to directory on IBM as there are calls to other scripts.
- Oracle creation scripts – **FSDBA** must run
- cr_gis – master control script, **run this**
- cr_table – creates tables and constraints
- cr_trig – creates insert and mod triggers
- cr_syn – creates public synonyms
- cr_grant – creates role and grants to role
- pop_lu.sql – populates lookup tables
- Creates the GISINFOBASE role
- Grant the role to users – full access
- Grants select to public

- Gis Infobase

## Setup – Patch Jet Engine

- Fixes Jet Database engine to work with Oracle insert triggers – finally!
- Only for Office 2000
- Expand the JetSP4.exe file
- Located in <app path>\library
- Write files into <app path>\library
- Run batch file fix_jet.bat
- Located in <app path>\library
- Copies files to correct place and registers them

- Gis Infobase

## Exercise 1 – Dowload & Install

- Download
- Expand
- Setup
- Patch Jet

- Gis Infobase

## Setup – Client Side

- Check Sql*Net connections
- Run SqlNet Easy Setup (Oracle group)
- Idb – standard install from OSE

- Gis Infobase

## Setup – Sql*Net

- Verify that you can connect with Sql+
- Log in with / or fs_public/fs_public
- Quirk in Sql*Net allows you to login with /
- Setup your windows login to be the same as your IBM login
- Other unit connections can be made
- handout

- Gis Infobase

## Setup – Client Side

- ODBC Setup – Oracle Connection
- Control Panel -> ODBC 32 Manager
- System Tab
- Should be idb DSN using Oracle’s ODBC

- Name of SQL*Net Alias

- Gis Infobase

## Setup - Client

- ODBC Setup – INFO Connection – Doric
- Set up a DSN for each corporate work space
- Navigate into the info directory and select **arc.dir**

- Mounted drive on IBM

- Gis Infobase

## Exercise 2 – Install Connections

- Check Sql*Net Connection
- Log in with SqL+
- Create a Alias to your home unit
- Check/Setup Oracle ODBC Connection
- User Oracle ODBC Driver
- Create another connection to your home unit
- Install Setup Doric Driver
- Get off reo web site

- Gis Infobase

## Setup – Getting Started

- Start GIS Infobase
- Will prompt on No Defaults Set
- Click on No
- Update Links to Tables
- Refresh links to the attached tables in Oracle
- Select Update Data Link on Main Menu
- Select the ODBC DSN you set up
- Watch the status bar for progress meter

- Gis Infobase

## Setup – Set Program Defaults

- Label for your Unit
- (Used on reports and web)

- Who is signed on
-  (Used for default person)

- GIS Coordinator
- (Used for contact in Web Page)

- Hyperlink address
- (point to url where your data will be available for download)

- Default coordinate system and projection info
- (Used in Metadata for defaults)

- Stored in <app_path\gisib.ini

- Gis Infobase

## General Editing

- Moving around and Adding Records
- All data is LIVE not a copy!
- Finding Records
- Some forms have Find button
- Access has default Find

- Go To First

- Previous

- Next

- Go To Last

- Add New Record

- Gis Infobase

## General Editing

- Helpful Keystrokes

- Important!

- Gis Infobase

## Create Agencies

- Create Agency Lookups
- Used to tie people to Requests and Stewardship

- Gis Infobase

## Create Personnel

- Create records for GIS People to start and all Data Stewards
- Used in Metadata and Requests

- Gis Infobase

## Create Quad Lookup (opt)

- Was used in Cover Edit Log (broke)
- Managed source data for use in plotting

- Gis Infobase

## Exercise 3 – Setup up defaults

- Add your own unit to the database
- Add your name to the employee list
- Configure program for you being user and Andy Peavy being the GIS Coordinator

- Gis Infobase

## Metadata

- Condensed version of FGDC
- Not all items available from standard
- Consists of two parts
- Coverage documentation
- Related Table documentation
- Output
- FGDC format
- Easy Read format
- Web Pages – start page plus all related
- Report

- Gis Infobase

## Metadata - Input

- Field Captions noted in **bold** are required for program to work
- Some fields can be generated
- Bounding Coordinates
- Export File Size

- Gis Infobase

## Metadata - Input

- General Process to document a cover
- Document coverage in Data Dictionary Screen
- Document feature attribute tables and related lookup tables (oracle, info, whatever)
- Maintain Edit Log as you go forward

- Gis Infobase

## Metadata – Coverage Input

- Related
- Tables

- Gis Infobase

## Metadata – Table Input

- Columns in Table

- Codes in Column

- Active
- Row

- Table
- Documenters

- Gis Infobase

## Metadata – What is this stuff?

- User Guide – page 35 – 37
- Source – checked means the coverage is a source coverage and not derived.  Plays into what covers are presented for export.
- Source Date – Date the coverage was originally compiled.  Edit Log shows the edit history.
- Keywords – a FGDC requirement, general search words for cover (road – transportation, etc)

- Gis Infobase

## Metadata – Documenting Tables

- A lot of detail, so automation important
- Use Table Documenters
- Oracle
- INFO
- Copying data from a spreadsheet

- Gis Infobase

## Metadata – Table Documenters

- Oracle and INFO, works the same
- Click Documenter button, don’t enter table header data as it will be undone
- Select the table to document in the list
- Info tables have **.** Replaced with –
- Oracle shows views and tables
- Sit back and will populate
- Table
- Columns
- Data types

- Gis Infobase

## Metadata – Table Bugs

- Problem in Access 2000
- SubForms for Columns and Codes will be blank when you add the table
- Close Table form, then re-open – geez 

- Gis Infobase

## Metadata – Edit Log

- General entry for a round of editing
- Reports use for last update date

- Gis Infobase

## Exercise 4 – Document a Cover

- Document a coverage from your unit
- Document a coverage from the Winema Pool
- Have Agencies and People input first
- Complete
- Coverage Page
- Several Tables
- Edit log records

**OR**

- Gis Infobase

## Metadata – Loading Data

- Can load data from external sources
- Copy/paste into large text blocks
- For tables, Create spreadsheet with exactly the same columns in same order as Infobase
- Select range in Spreadsheet
- Switch to Infobase
- Click in the subform
- Edit, Paste Append (Not just paste)

- Gis Infobase

## Metadata – Loading  McGuinnes

- Jim created metadata for several forests with local back end Access Database
- Strategy
- Clean install of oracle schema
- Disable insert/modification triggers in Oracle
- trig_off.sql in <app_path>/dbgen
- Load data through back end .mdb file
- For tblCover, tblCoverDataType, tblCoverEdit, tblCoverKeyword, tblCoverTable, tblTable, tblItem, tblTableCode, tblCompanyAgency, tblPerson
- Enable insert/modification triggers in Oracle
- Drop and re-create sequences with max values
- trig_on.sql in <app_path>/dbgen

- Gis Infobase

## Metadata Output - Intranet

- Goal is to produce web site for the dictionary

- Gis Infobase

## Metadata Output - Intranet

- Intranet – creates a dictionary via html

- Defaults to install directory

- Leave both checked for linked set of pages.  Listing is the home page, Data Dictionaries are the pages for each coverage

- Include Edit Log, places edit history on page

- Gis Infobase

## Metadata Output - Intranet 

- Produces pages for everything in the database
- Writes files out to the directory set
- Start page is index.html
- Naming convention:
- c#.htm – coverage, # is ID number of cover
- t#.htm – table, # is ID number of table
- Move files over to your web server and you are on line...

- Gis Infobase

## Exercise 5 

- Produce the Data Dictionary in Web ready format.

- Gis Infobase

## Customizing the Web Page

- Add your own graphics, rest is fixed

- Gis Infobase

## Metadata – Intranet ASP Files

- Use if you have access to a NT server on your network
- Default ODBC DSN used – idb
- Edit files, replace “No Name” with Forest Name (Winema, etc)
- ddmain.asp
- dd.asp

- Gis Infobase

## Metadata/Data Prep - Internet

- Goal is to distribute digital data driven from metadata
- Ensures metadata is included with data
- Reduces your work load (producing exports)
- Produce in 2 formats
- FGDC – post on a NSDI Clearinghouse Server
- Quick reference format for Humans

- Gis Infobase

## Metadata/Data Prep - Internet

- Steps in Procedure
- Run Internet Metadata and Data Export but _**only**_ select check boxes for AML production and table exports from Oracle and INFO
- Run the aml’s
- Chkcname.aml – validates names/paths
- Covexp.aml – Exports covers and info lookups
- Genextent.aml – Generates bounding coordinates
- Move the Oracle table export files to the IBM with BINARY FTP (preserves cr/lf) and compress with compress <filename>

- Gis Infobase

## Metadata/Data Prep - Internet

- Procedure continued....
- Create a text file of the compressed object names 	    **list –al *.Z > filelist.txt**
- Load coverage extent file back into the database
- Load the file list with file sizes into the database
- Run the Internet Metadata and Data Export routine again and produce the final metadata documents
- Post all files to the web server
- Go have many beers....

- Gis Infobase

## Step 1 – AML’s/Table Exports

- Check boxes for aml’s and table exports only
- Select Covers

- Must Select Covers to Operate on

- Don’t
- Check These

- Check
- These

- Gis Infobase

## Step 1 – Selecting Covers

- Select Covers you want or Select All
- Check boxes govern what you see

- Check to change Coverages shown

- Gis Infobase

## Step 2 – Run AML’s

- Move AML’s over to the IBM and run
- Covexp.aml – Exports coverage and INFO lookup tables.  Compresses if selected with unix compress command (.Z)
- Calls chkcovname.aml to verify names and paths if errors found will report them and stop
- Genextent.aml – Produces a file called covextent.txt that holds the id and bounding coordinates in lat/long.

- Gis Infobase

## Step 3 – Move Oracle text files

- Text files produced from Oracle tables exports data into ascii delimited text files
- Column names in first row
- Quotes have been stripped for loading
- Move files over to IBM with ftp in _**BINARY**_ mode (preserve cr/lf)
- Compress the .txt files with compress
- compress *.txt

- Gis Infobase

## Step 4 – Create File Size List

- Need to get actual file sizes for covers and table exports back into the database so users can see how large they are.
- Create text file with list
**	****ls –al *.Z > filelist.txt**
- FTP file to PC in _**Ascii**_ mode (CR/LF)

- Run this

- Gis Infobase

## Step 5 – Load Extent File

- Need to get coverage extents in lat/long back into database (FGDC requirement)
- Run the Load Cover Extent routine
- FTP file to PC in _**Ascii**_ mode (CR/LF)
- Load Cover Extent file
- Review a few covers to see if bounding coordinates and file sizes are there

- Gis Infobase

## Step 6 – Produce Final Metadata

- Uncheck AML/Table Export & Check others

- Don’t
- Check These

- Check
- These

- URL of data directory

- Protocol to Use

- Gis Infobase

## Step 7 – FGDC Option

- Directory created under
- <application>/internet/fgdc
- DOS Screen flashing is the Metadata Parser (MP) running
- Review Error Log and Correct
- Files Produced
- text  => Ascii file formated to fgdc spec
- html => fgdc format in html
- sgml => fgdc format in sgml
- err    => error files

- Gis Infobase

## Step 8 – Move Files

- Move all files to your web server
- Move _**all**_ files in fgdc directory to NSDI Clearinghouse web server
- Congrats!
- You have your data on line
- You have complied with Executive Order 12906
- You are doing the right thing!
- Lets go have beer 

- Gis Infobase

## Break

- Gis Infobase

## Requests

- Track work requests and provide a structured place to document work
- Store procedures and amls
- Store related documents
- Manage larger projects
- Track hours by Job Code
- Provides place to Repeat Work

- Gis Infobase

## Request – Basic Input

- Basic data then buttons for related stuff

- Components

- Gis Infobase

## Request – Storing Aml’s

- Select the AML button
- Copy aml into windows clipboard
-  Paste in with shift + insert

- Gis Infobase

## Request - Reports

- Request Form
- Request Status
- Request by Employee
- Requests by Project
- Request Log
- Staff Summary

- Gis Infobase

## Help

- REO will Support
- 1-800-CALL Bob
- 1-800-CALL John
- 1-800-CALL Dale
- User Guide

- Gis Infobase

## Future Needs

- Write metadata out to coverage directories
- File dialog buttons where needed
- Keep on Microsoft for fixes
- Sub form problems

- Gis Infobase

## Summary

- Setup the Application
- Produce Metadata
- Internet, Intranet
- Quick Referent & FGDC
- Produce Requests

- Gis Infobase

## Remember....

- Don't Duck that Metadata!

- Gis Infobase