Transcript Application Objectives

NASA Marshall Space Flight Center
Facilities Engineering Management Office
Facilities GIS and Data Integration
October 2007 – Rocket City GeoSpatial Conference
Independent Data Sets
 No
Data
Linkages
 Specially
Map
Data
(SDE)
trained users.
ArcGIS
Business
Process
Business
Process
 Complex
Application
Database
Software
 Stove
Pipe
Solutions
Asset
Mgmt
(Oracle)
Maximo
Business
Process
Application
Data Files
Business
Process
Page 2
Before – Collection of Information
Space
Management
Planning
Department
Architecture/CAD
Department
Mapping
Department
Utilities
Department
Maintenance
and Operations
Page 3
Application Objectives

Rapid Information Gathering

Visual Information Portal

Access all Pertinent Data Sets

Integrate for Improved Information Gathering

Must make business sense

Improve Efficiencies

Enhance Decision Making Capabilities
Page 4
Application Objectives (cont’d)

Use Existing Databases

Use Existing Business Processes

Utilize Existing Software Products

Leverage off of Existing Systems Investments

DO NOT Migrate existing data into One Large
Central System

Users to Access Approximately 80% of
Common Reports
Page 5
Data Integration Objective
Map
Layers
CMMS
Reporting
Floor
Plans
UCS
Environmental
Facilities
GIS and Data
Integration
Web Application
Roof
Management
Location
Searches
Space
Utilization
Utilities
Spread
Sheets
Redlining
Page 6
Development Approach

Data Modeling

Data Flow Diagrams

Data and Systems Inventory

Interview Data Managers

Interview Data Users

Organize Systems into Components

Use UML Concepts

Map Data Flows throughout System

Observe Data Patterns

Detail All Systems
Page 7
Diagram Legend
File
Server
Enterprise
Database
Microsoft
Access
Application
Application
Process
Data
File
Tabular Data
Spread
Sheet
Access
Database
Map Layers
Web
Application
Report
System
Boundary
Info,
Operation,
Data Flow,
Action, etc.
Notes:
Development
Notes:
Data
Structure
Detail
Page 8
Data Flow Model
CMMS / Maximo Component
Roof Management Component
Space Utilization Component
Owner:
Owner:
Owner:
Create
Web
Reports
FFR Reports
FFR
Facility Functional Review
Web Application
Building Photos
JPEG Files
Link to
Web
Maximo
Interface
Query
Maximo
Hyperlink
Pass Variables
Data
Mngt.
TRIRIGA, Inc.
Data
Connection
Data
Sync
MicroStation Files
SPUT
Store
Roof DPRs
Work Order Report
Web Application
Web Report
Mobile CMMS
Portal
Search by Criteria
Form
 Submit Criteria
 Create Report
Web Application
@Hand
Store
Floor Plan
DPRs
MicroStation Files
Reported Office
Phone #
By
Symbol
Facilities Work
Order Information
Roof Management
System
(MDL Application built on
MicroStation)
Space Utilization
Floor Plans
Status Location
Middle-Tier Server
Tables
SPACENEWALLROOMS
SPBLDDTL
SPBLDINF
SPBLDROM
SPCHARGE
SPEMP
SPORG
SPORGLVL
SPORGTIE
Description
@Hand
 IPS Variable stored
in Archive.mdb
Database
CADD
Mngt.
Work Order Report
Work
Order #
DPR Files
 BldgNoVar+IPSid
variable is
generated from the
DPR Process.
by
Submit
Data
Submit
Hyperlink
Roof Management System
Notes:
Facility Center 7.3
Read-Only
ODBC Connection
Input Form
Data
Sync
Read-Only
ODBC Connection
CAD Integrator 7.2
Space Utilization Application
Hyperlink
Web Application
Maximo Web Report
 Section Information
 Inspection Information
On Demand Requests
OR
Custom Color Fill
Intranet Link
ODBC and SQL
Web Application
Facilities Engineering
Department (FED)
Roof Section Report
Space Utilization Data
Work Request
Form Data
Sent to:
Temp Maximo
Tables
Facilities Minor
Work Request
Oracle Database
Query
Data
Reports
Link to Web
Forms, Queries, Reports
Review
Data
CMMS
Link 2
Link 3
DPR Files
(via Bentley Web Viewing VPR)
Microsoft Access Application
Query
Data
Reports
Query
Maximo
BldgNoVar-ROOF +
SectionVar
Floor Plans
Maximo Reports
Process
Data
Create
Report
Roof Replace
Report
Link to Web
(via Bentley Web Viewing VPR)
SPAN Admin Reports
AWRS
Process Request
EqNum Condition
Roofs to be Replace
Maximo Web Report
DPR
Viewer
of
Roof Drawings
Facility Center
CAD Reports
Access Reports
Location
Roof Plan
Description
Web Application
Hyperlink
Query &
Generate
Reports
Update
Data
Roofs to be Replaced Report
Web Reports
 Consolidation/Closure
 Center Maps
 Space Utilization Summary
 Space Utilization by Organization &
Building
 Employee Total by Building Group
 Facility Function By Org
 Space Utilization By Org
 Building Information
 Building Number
PDA
Application
Search by
Criteria Form
Go
Space Utilization and Real Property
mslink
Process
Roof Drawings
Create DPR Process
SPUT.mdb
Read
Write
Data Maintenance
Application
 Saved MS Views
 Use Digital Print Room
 Use InterPlot (IPS)
 Create DPR Files
 Update Database

Process
Floor Plan
Data
Archives.mdb
DPR Database
Update
Database
Facility Mapping Component
Owner:
Auto
Data
Input
Data Process
Upload data from
MAMS to SPUT
Auto
Data
Input
Security Component
Referenced
Drawings
Process
Data
MIW / MAMS












Location
Information
ArcGIS
ArcView
Shape Files
AccessControl.shp
buildings.shp
buildings_historic.shp
cercla.shp
Cl_rds.shp
drainages.shp
IndSewer.shp
MSFC_brdr.shp
ordinance.shp
QD_zone.shp
roads.shp
well.shp
Map Viewer
GIS Data Sets
Partial Owner: Environmental Department
View Map
s
(Development)
(Production)
Shape Files
Geodatabase
ArcGIS Access Database
ArcIMS Map Services
Marshall Assets Management
System
Data Process
Upload data from
MEDIS to SPUT
Master Floor Plans Component
Emergency
Evacuation
Referenced
Drawings
MicroStation Files
Other Sources
Process
Data
Master Floor Plans
Process
Data
MicroStation Files
Update
Maps
Security Database
Directory location:
Move
Data
Enterprise Database
Owner:
CADD
Mngt.
Manual Update
Process
PARCH
Project Architect
Map.dgn Levels
9 Culverts
19 Building Name
10 Boundary
20 Streams
11 Boundary Name
21 Water Flow
12 Buildings
22 Fences
13 Building Numbers 23 Gate Width
14 Streets
24 Runway
15 Street Name
25 Runway Labels
16 Road Material
29 Trees
18 Structures Other 31 Monuments
Management
Application
Data
Link
Various
Virtual Server:
Image Type: JPEG
Referenced
Drawing
MEDIS
(Uses Web
Applications
Owner:
Databases
CADD
Mngt.
Ascii File
(data used by
PARCH
Application)
Base Map
(Map.dgn)
33 Sidewalks
35 Major Elevations
36 Minor Elevations
37 Drainages
40 Airport Approach
42 Safety Perimeter
45 Utility Area
51 Building No. Alt
52 Courtyards
update
MicroStation
Building.shp
Service Name
Shape File
Aerial1943
Map File
Aerial1950
update
Aeria2000
 Reference Map.dgn file
to shape file.
 Copy or Modify data to
the shape file.
AllAerials
Basemap
CERCLAmxd
DigPermit
MSFCIndexMap
RSACERCLAmxd
Update
FacGIS
Update
Maps
SDE
 GPS Collection
 Field Surveys
Document Repository Component
(Survey data collection
application)
Collect
Data
MicroStation Files
Owner: EDS
Owner: UNITeS
(Electric, Mechanical, Plumbing)
Referenced
Drawings
Documentation Repository
Utility Maps
Update
Maps
Referenced
Drawings
Archive
Data
Notes:
Design Projects Reports
Design
Projects
Archived Asbuilt Data
MicroStation Files
Owner:
Document Repository Process
 Scan Drawing if not electronic.
 Generate PDF file.
 Submit Data to Documentum.
Environmental
GIS
Environ
mental
Maps
Update
Map Notes:
Map Projection: Alabama State
Plane East NAD 83
(Distributed via email)
Owner:
Update
Drawings
Data
Retrieval
Base
Map
EDS FINAL+Date.xls
Project Design Component
Documentum
Database Name
Utility
Maps
MrSID files
Survey Data
Spreadsheet
PROJECT LIST.xls
Documentum Login
PDF
ArcIMS
Aerials
nitrogen.dgn
sewer.dgn
steam.dgn
telecom.dgn
ucs.dgn
water.dgn
 Data Capture Project in
progress.
 Directory naming
convention is not
consistent.
Archived
Asbuilt
Server:
Service:
Database:
User Name:
Owner:
Owner:
Data Retrieval
Periodic
Data Migration
MicroStation
chilled_water.dgn
electrical.dgn
helium.dgn
HPair.dgn
hydrogen.dgn
ngas.dgn
Web Application
Documentation Repository Home Page
SQL Server Database
Referenced
Drawing
Survey Select CAD
System Drawings
Design
Projects
Design Process
(Directory Structure)
1. DesignProjects
2. AcceptedForConstruction
3. Asbuilts
4. Archive
Track
Progress
HP Gas Component
Output
Reports
Owner:
Work Request Number
Correlation
Manual Process
(FWR# fed into Design
Project database from
Maximo)
Create
PDF Files
Archive
Design Projects Database
UCS Component
MSFC HP Gas System
Web Application
Maximo: Work Request
---------------------------------------Design Projects: Facility Work
Request (FWR#)
Microsoft Access Database
Archived As-builts
Utility Control System
Process
Floor Plan
Data
MicroStation Files
HPGas Database
Query
Data
Reports
MicroStation Files
Access Application and
Database
Utility Control System
Web Application
Design Projects
Facility Work
Request (FWR#)
BLDB
Title
Hyperlink
Component Specification
Sheet
Utility Control System
PM
Web Page
DPR Files
Store
UCS DPRs
Link to Web
(via Bentley Web Viewing VPR)
Page 9
Application Development

Integration Hub
Built into code
 Correlate Non-Homogeneous Databases
 Re-group numerous data sets into useable reports


Access Control Module (Security)
 Allow
Restricted Data to Specific Users.
 All Objects (reports, map layers, tools, etc.) in Application
can be Controlled.
Page 10
Data Integration Model
Page 11
Modular Design

Scalable

Map Navigation Tools

Web Menu Controls

Layer Controls

Search Tools

Database Reports

Data Copy and Paste Tools

Printing Tools
Page 12
Story Board Web Pages
Customer
Driven Design Requirements
Interactive Floor Plan Viewer - Bldg: BldgNumber Floor: FloorNumber
Zoom
In
Select Building Name
Zoom
Pan
Out
Fit
Fence Rotate
Redline
Delete
Copy
Move
Redline Redline Redline
Circle Polygon Cloud Text
Redline Line Size
Color
Text Size
Print
Save
Drawing
Format
Key-in Building No
Go
Measure Units
Length
ft-in
dec-ft
meters
Measure Units
Area
2
ft
m2
Identify
Fixed Size
Drawing Control Frame
Floor & Layer Control
Floor Frame
Select Floor
First Floor
Second Floor
Third Floor
Roof Plan
Floor Plan - SVG File - Adobe SVG Viewer
Layers

Architectural
Details

Drawing Text On
Room

UCS

Emergency
Evacuation
Plans

Configuration
Control (Future)
Name
centroid
Sq Ft
Type
Searches
By Floor
By Building

Person Search:
MSFC
Name List
Go
Enter Last Name
Room Search:
Bldg: BldgNumber Floor: FloorNumber Room: RoomNumber
Room List
Go
Enter Room Number
Occupants
Room Info
Enter Work Order Number
Go
Equipment Search:
Equipment List
Enter Equipment Number
Go
Name 1
Phone 1
Org 1
Email1
Name2
Phone 2
Org 2
Email 2
Sq Footage
Charge Back
Class
Type
Equipment
Report
Work Order
Report
MAMS
Report
Fixed Size
Work Order Search:
Work Order List
Room
Report
Color Coding
Color By
Organization
Directorate
Vacant Space
Legend
 OnClick Email function.
Item #230 No. 49
Clear Color
Color Palate
Manual
Color Fill
Page 13
The Application
Major Components
Map
Map Component – Query and Report from
Center Perspective
Interactive
Floor Plan
Interactive Floor Plan – Query and Report
from Floor and Room Perspective
FacGIS Web Site
Page 14
Application – Snap Shot
Page 15
Results – Access to Pertinent Information

Utility Maps

Architecture Floor Plans

Space Management

Asset Reports
Interactive
Floor Plan

Work Orders

Room Data
FacGIS Web Site

Environmental Maps

Master Planning Maps

Support Maps
Map
Decision Makers
Page 16
Results – Analyze Data
Map
Decision Makers
Interactive
Floor Plan
FacGIS Web Site

Map Layers

Thematic Maps

Map Searches

Person Searches

Space Mgmt Reports

Asset Mgmt Reports

Color Code Rooms

Measurement Tools

Red Line Tools
Page 17