TECHNOLOGY DESIGN AND DEVELOPMENT

GIS is an extremely powerful tool that can bring benefits to many areas within your organization. “Out-of-the-box,” however, a GIS is seldom optimized to meet your organization’s specific needs. This is where SSP-Wind Lake can help. Our team of experienced GIS analysts / developers will work with you to customize your GIS environment to achieve the maximum return on your substantial investment in this technology.

Geospatial Data Models

Whether you’re upgrading a system, changing to a different platform, or just want to improve your ability to meet your organization’s needs, a sound data model is a must. Our experience as data modelers and system integrators, as well as end users of geospatial data, uniquely qualifies us to design data models that position you for success. We have extensive experience with standard models and frequently work with customers to evaluate them, identifying areas that may need enhancement.

GIS Tools

GIS systems rarely meet an organization’s needs “out of the box.” Although it may be possible to perform all necessary tasks without any customization, it is rarely the most efficient way. With extensive experience developing solutions for GIS environments, our developers know how to create tools that meet your specific needs without becoming a maintenance problem. Our track record of developing flexible and reliable tools that have been in production for years demonstrates that “custom” is not something to avoid in your GIS environment if you have the right partner.

Applications

If your needs go beyond developing tools for your GIS and you’re looking for more sophisticated software, we can help. SSP-Wind Lake has developed numerous applications that are used to automate entire processes and solve business problems. Typical characteristics of our solutions include high performance, robust configurability, user-friendly and intuitive interfaces, and long-term reusability. We pride ourselves on delivering highly reliable solutions the first time, which our customers continue to use without support for many years.

Interfaces

Our expertise extends beyond GIS. The most significant benefits of investing in your GIS are often realized when it is integrated with other enterprise systems. Whether it’s OMS, AMI, Work Management, Mobile Workforce Management, or virtually any other system that can benefit from integration, our consultants and developers can design and develop an interface. Our experience with these operational systems is the key to providing seamless integration for our customers.


Project Summary:
Work Management Integration

WLS recently developed an interface to streamline the work order posting process for a customer. Instead of recreating facility features in the GIS based on the as-built sketch, the customer simply keys in the work order number and the interface automatically retrieves the information from their work management system. The configurable interface creates all the necessary features and populates the appropriate attributes. Users only need to digitize the location of the features, dramatically reducing data entry time and improving the quality of the GIS database.

Project Summary:
Routing Software Integration

WLS assisted one of its customers with their automated routing application, enabling them to maximize the benefits of their solution. The customer chose RouteSmart Technologies’ software to generate routes for their meter reading and inspection activities. WLS designed and developed an add-on to enhance the resulting route data and export the routes to Excel or PDF format. The resulting output contains additional navigation aids, such as turn arrows and parking locations, interpreted from the RouteSmart data. The customer replaced their time-consuming manual procedures with the integrated tool that provides their users with the information they need.

Project Summary:
Data Modeling and Tool Development

WLS has worked with several of our customers over the years to customize and enhance their Electric Distribution, AC Network, Electric Transmission and Gas Distribution data models. In collaboration with our customers, we have produced customized model designs which incorporated the customer’s current and future business practices for tracking and managing their system assets. In addition to data modeling, WLS has designed and developed custom user tools to improve efficiency and ensure data quality. Many of these tools have been used for years and have gone through several system upgrades.

Project Summary:
Data Migration Development

WLS was contracted by a major GIS software vendor to assist with the development of data migration software for a major telecommunications company. WLS developers were instrumental in the design and development of a solution capable of migrating large quantities of data to a very complex data model. Some key features of the migration software included configurable settings for attribute and table transformations, sophisticated connectivity processing specific to the telecommunications industry, migration of thousands of detail drawings with complex relationships to geographic features, and load-balancing migration processes on multiple servers from a centralized user interface.

Routing Software Integration

WLS assisted one of its customers with their automated routing application, enabling them to maximize the benefits of their solution. The customer chose RouteSmart Technologies’ software to generate routes for their meter reading and inspection activities. WLS designed and developed an add-on to enhance the resulting route data and export the routes to Excel or PDF format. The resulting output contains additional navigation aids, such as turn arrows and parking locations, interpreted from the RouteSmart data. The customer replaced their time-consuming manual procedures with the integrated tool that provides their users with the information they need.

Work Management Integration

WLS recently developed an interface to streamline the work order posting process for a customer. Instead of recreating facility features in the GIS based on the as-built sketch, the customer simply keys in the work order number and the interface automatically retrieves the information from their work management system. The configurable interface creates all the necessary features and populates the appropriate attributes. Users only need to digitize the location of the features, dramatically reducing data entry time and improving the quality of the GIS database.

Data Quality Verification

Verification/acceptance program for a customer who had contracted with a third party for a field inventory. There were three major components to this project:
  1. Statistical visual verification and scoring of adherence to the customer’s mapping standards and practices. This was completed by WLS.
  2. Automated verification of adherence to the customer’s data format and content, connectivity and feature relationship requirements. This was completed by WLS.
  3. Statistical field verification and scoring of data collected during the inventory. The sampling plan and scoring methodology were developed by WLS. Actual field verification was completed by the customer.

Data Extension, Enhancement & Integration

Examples of some of the data services WLS has provided to our customers over the years include: establishing feature connectivity, reconciling SAP and GIS asset data, assigning phasing to electrical features, periodically back feeding data from the customers OMS to GIS, incorporating cathodic protection data into the customer’s gas model and linking work order images to their associated features.

GIS Data Maintenance

WLS has been providing ongoing work order posting services for one of its customers since 2005, with support over the last several years averaging between 5,000 and 10,000 orders per year. Recently, that customer requested that we provide a dramatic, but short- term increase in our capacity for them. We ramped-up significantly and were able to complete over 20,000 repair orders within a five-month period.

Data Quality Verification

WLS recently assisted a customer from beginning to end through a major conflation project, with services that included RFP development, vendor selection support, specification development, acceptance process implementation, QA software development and implementation, visual data QA with statistical sampling and scoring, overall project management support and on-site staffing to assist in the go-live cutover.