I am the GIS lead for integrating geospatial technology and business systems throughout the City of Sacramento. Various business systems exist in the city and many of them are starting to integrate GIS technology into them. The following briefly describes the integration solution I created.

Infor is one of the city's major work order and asset management software. The street sign inventory was the first full integration of GIS, field asset collection, and work order management information.

Integration Overview

 

This project required 1-4 sign maintenance supervisors to collect data using Trimble GPS, ArcPad (GPS Correct), post processing of the GPS data using GPS Analyst, and some direct editing of ArcSDE sign layers (6). The ArcSDE data is checked out to a personal geodatabase from the primary SDE database, then checked out as a series of shapefiles to the Trimble GeoXT using the GPS Analyst toolbar. Once data is collected and brought back to the office, the data is corrected using GPS Analyst, then checked back in (synced) to the primary SDE. The new data is synchronized with the Infor work order database using the Infor ArcGIS tools, then an automated Python script is run to push the new data to a publication SDE database so that sign field workers can see the updated sign inventory.

 

 

Systems Integrated

 

Trimble GPS - Field Data Collection

ArcPad - Field Data Collection (Trimble GPS Analyst and GPS Correct)

ArcSDE - Enterprise GIS

-Disconnected Editing

-Data Replication

-Multi-user editing

-Python scripting

ArcIMS - end user mapping and address query

Infor EAM - Work Order Management

 

 

The City of Sacramento is installing water meters throughout the city. The Dept. of Utilities needs a solution to locate the position of the meter as well as the meter information.

The Challenge

High-end GPS field trials fell short of being able to accurately locate the water meters in and around buildings and under tree canopies. The installers also wanted to be able to relate the bar code to the water meter position.

 

The Solution

 

-ArcPad

-Laptop with XP Tablet OS

-Bar Code Scanner

-Water Meter file created and managed in ArcSDE (or personal geodatabase)

 

The solution incorporated ArcPad, basically out-of-the-box, using a water meter file created in ArcSDE. Attribute domains were developed which avoided the need for customizing ArcPad. The bar code scanner was connected to the tablet PC. When the user zapped the water meter bar code, the value was placed in a "bar code" attribute automatically.

 

The Urban Forest Service group with the City of Sacramento contracted with Davey Resources Group to complete the field work for the full Urban Forest Inventory for City managed trees. Their current system based in an archaic system is no longer viable or translatable into the Infor EAM system. The data collected directly integrates with ArcSDE and the Infor EAM workorder database using the base integration template the City developed for the Signs and Parking Spaces.

Systems Integrated

 

 

-ArcSDE - on-going data maintenance

-Infor EAM - tree assets into Infor EAM

-Infor EAM Table Views/Materialized Views to maintain non-spatial attributes

-SDE Table Views to connect with Infor EAM Table Views

-ArcIM - Use table views for display in Infor EAM

-3rd Party data collection (contracted Davey Resources for Field Data collection)

 

This project involved geocoding the parking spaces collected by the Parking Enforcement Division of the City of Sacramento's Dept. of Transportation. Parking Enforcement staff collected parking space and meter information into an Excel file that contained a "location" of the space (i.e. a pseudo address). These pseduo addresses were able to be geocoded to the city's street centerline file. Manual adjustments were made to some of the geocoded locations. The parking space was integrated into SDE for on-going maintenance and then integrated into the Infor EAM work order management system.

GeoProcessing

 

-Geocode Parking Space Assets via pseudo address

-Manual adjustment of some parking space assets

 

Systems Integrated

 

-ArcSDE - on-going data maintenance

-Infor EAM - parking assets into Infor EAM

-Infor EAM Table Views to maintain non-spatial attributes

-SDE Table Views to connect with Infor EAM Table Views

-ArcIM - Use table views for display in Infor EAM