Asset Management Using SharePoint and GIS Recording

A recording of our May webinar is available online at: http://youtu.be/N_lnMyFe5xE 

Webinar: Asset Management Using SharePoint and GIS, Tues 5/19/15 at 10:30am PT

Webinar: Tues, May 19^th 10:30am – 11:30am

Asset Management Using SharePoint and GIS

Please join us for an informative webinar featuring examples of asset management projects Interwest has implemented for local government agencies including facilities maintenance tracking in SharePoint and asset inspections and repair tracking using Collector for ArcGIS.

Warm regards, Steve Gay | GIS and IT Manager interwest Consulting Group | sgay@interwestgrp.com D 916.436.3017 |M 916.838.6870 | www.interwestgrp.com

GIS and SharePoint Integration with Enterprise Systems Recording

A recording of our February webinar is available online at: https://www.youtube.com/channel/UCxj0od5Zk4o6Jvdf4mz0lTg 

Webinar: GIS and SharePoint Integration with Enterprise Systems

Please join us for an informative webinar detailing GIS Integration with SharePoint and Enterprise Software Applications.  The webinar will feature examples from the City of Elk Grove’s integrations with their code enforcement, building permit and work management software applications.  We will also demonstrate using SharePoint as a management dashboard to view important details from multiple software applications in one place.  Examples will focus on the important requirements related to hosted cloud systems such as Sungard's ASP and Esri's ArcGIS.com.

When: Feb 17th at 10:30am PT  Register Now

GIS Integration Using Microsoft SharePoint

Interwest integrates Geographic Information Systems (GIS) with key enterprise software applications public agencies utilize including permitting, utility billing, property viewers, Computer Aided Dispatch and citizen reporting systems. For the City of Elk Grove, Interwest created a custom intranet site using Microsoft SharePoint. The site pulls data from GIS into reports to give managers updated information on projects such as transit routes, trails, and ADA compliance updates.

INTEGRATION

Interwest pulls data from Capital Improvement Projects (CIP) to update the city’s CIP maps as the status changes from planning to completion. The City of Elk Grove receives weekly updates from the County with parcel ownership changes and foreclosure status. Interwest pulls this data into GIS through an automated workflow that also updates the management console created in SharePoint.

Updates flow both into and out of SharePoint. Interwest pulls data from GIS into SharePoint through automated scripts. The City’s Bridge Inventory is maintained in GIS. When a manager views the Bridge Inventory report inside the management console in SharePoint, it displays the latest attribute data from GIS ensuring the city reports the most recent changes to CalTrans.

DATA SHARING

Interwest integrates GIS data with many applications to streamline the sharing of information and ensure an agency’s maps are updated nightly with data pulled from other software applications. SharePoint is customized to each client’s unique workflow and integration requirements.

Interwest customizes SharePoint to help public agencies integrate their project tracking data with GIS.

Management Dashboard

Interwest creates solutions for public agencies to pull data from their various software applications into one centralized dashboard for managers. For the City of Elk Grove, Interwest created a custom intranet site using Microsoft SharePoint. The site’s management console contains reports from other applications all in one spot as well as shared spreadsheets that managers collaborate on.

Interwest’s IT team assessed the needs of each manager and created customized forms, reports, spread-sheets, and workflows for each need.

FINANCE

The Finance Department Manager’s snapshot pulls data from the permitting system to track accounts that are past due, active business licenses, delinquent payments from Community Facility Districts and development financing.

DEVELOPMENT SERVICES

The Development Services Manager’s snapshot pulls data from the permitting system, utility system and hosts shared spreadsheets for tracking commercial and residential recycling programs. The console contains as City Wide section utilized by multiple department heads including GIS reports, ADA compliance tracking, parcel ownership changes, bank owned homes, vacant homes, rental homes and open con-tact management calls.

Interwest uses SharePoint to help public agencies save time by bringing together important content from multiple applications into a management console. Interwest tailored the console to each manager’s unique needs and the site is easily updated overtime as a manager’s priorities change.

Electronic Reporting Using Microsoft SharePoint

Interwest provides IT consulting services to public agencies to track and route requests. The IT team uses Microsoft SharePoint to customize a workflow based on each agency’s unique requirements.

For the City of Elk Grove, Interwest created a custom intranet site using SharePoint. The site is a starting point for many workflows including electronic contract routing, insurance requests, graphic design requests, and staff reports. Inter-west’s IT team assessed the needs of each department and created customized forms and workflows for each need to route the request from originator to the employees responsible for completing the task.


STAFF REPORT APPROVALS

A staff report is created each time a request is submitted or ap-proved by the City Council. Interwest met with various depart-ments to assess the needs for this workflow and customized a form and workflow to route the staff report from the originator to each point of review: department head, city attorney, finance, city clerk and city manager.


CONTRACT ROUTING

For the electronic contract routing solution, staff members enter contracts into a web based form and select the appropriate depart-ment head to receive the contract next. The department head re-ceives an email notification with a link back to the form and at-tached contract. The manager reviews the contract and either sends it on to the City Attorney or if changes are needed, back to the originator. After all the changes have been made and reviewed by the staff, manager and attorney, the City Manager receives the electronic contract. Staff and managers are notified of the con-tract’s progress as the status changes.


REQUEST AUTOMATION

When a staff member needs a graphic for a flyer, mailer, t-shirt or other need, the request begins in their intranet site designed using SharePoint. Interwest met with the graphic designer and other staff to customize a form ensuring that the graphic designer received all important information necessary to get started on the project in-cluding the type of project, due date, size, and description. The designer updates the form as progress continues and the original requestor as well has the requestor’s supervisor are updated as the status of the request changes from pre-production to proofing to finished design.

Interwest customizes SharePoint to help public agencies save both time and paper automating tasks electronically. The tailored elec-tronic forms save both time and paper and also ensure that the proper workflow is followed and all the necessary people have re-viewed the requests before it is given to the staff member responsi-ble for the final deliverable.