Innovate

Integrate

Inspire

About Us

We are a leading systems integrator and software development company with a passion for open source solutions, geospatial development, databases and IT support. We aim to use best of breed leading edge technologies and tools to deliver open and flexible future proof solutions that are tailored to satisfy our customer’s business requirements.

Working at the enterprise level, our team of specialists are able to support a wide range of technical and functional requirements. Our experience and expertise, combined with our commitment to work closely clients, enables us to provide comprehensive and complete service offerings.

We help your business achieve important business outcomes by:

  • Building new products, services and applications.

  • Modernizing and enhancing existing solutions.

  • Re-engineering legacy enterprise systems.

  • Introducing new ways of working at a process and tool level.

  • Providing expert inputs and resources on a just-in-time basis.

  • Helping to control the cost and effort of managing existing IT systems.

Our Services

We provide a wide range of IT services, so you can focus on your core business activities while we take care of the rest.

Explore our Services Graph to see some of the areas we excel in, and do not hesitate to Contact Us if you wish to know more.

click & drag the graph for detailed info

Information Architecture

We have many years of experience in the structural designing of shared information environments. We validate information and domain models to ensure that applications are able to make the most of databases. When working on a model for a customer the following areas are normally covered:

  • Liaising with stakeholders to understand what information is currently in use or is needed.
  • Understanding information workflows, performance requirements, and application requirements.
  • Evaluating and rationalizing legacy data models which have developed over time.
  • Designing information schemas, data models and data dictionaries.
  • Providing a database migration strategy and data update scripts.
  • Supporting the implementation of the strategy.

Audit

We carefully observe your database with the objective of identifying the actions of your database users. We run a diagnostic to establish security concerns and supply recommendations to ensure that only users with permission are able to access your valuable information.

Migration

Whether you are implementing, upgrading, or consolidating systems, we assist your organization in the migration process. Data migration is usually performed programmatically to achieve an automated migration, freeing up human resources from tedious tasks. Data migration is required for a variety of reasons, including server or storage equipment replacements, maintenance or upgrades, application migration, website consolidation and data center relocation.

Tuning

We perform tuning of your database to optimize and homogenize its performance. Our expert team of engineers will set clear goals with you based on your business requirements and database usage to maximize the use of your system resources to perform work as efficiently and rapidly as possible.
Although most systems are designed to manage their own system resources, we have identified there is much room to improve their efficiency by customizing their settings and configuration.

Replication

We perform replication of your database so that all users share the same level of information. The result is a distributed database in which users can access data relevant to their tasks without interfering with the work of others. We can also assist in the implementation of database replication for the purpose of eliminating data ambiguity or inconsistency among users.

Backup and recovery

In the unfortunate event of data loss, we offer complete backup and recovery services for enterprises. We know how valuable data is and how critical recovery times are, as such we have developed recovery plans to minimize your downtime and get you up and running in no time.

Scope

Our business analysts are both technically experienced as well as being excellent listeners and communicators. We have a long history developing applications and associated infrastructures; therefore, we can guide and advise the selection of the best strategies, processes and technical implementations to help you achieve your business goals. We believe that good development should integrate with a wider information design and strategy. Thanks to our many years of experience designing database schemas, data processing workflows, web based interfaces and associated standards; we can offer you complete solutions. Our scope process can be seen in the graph below:

devel_cycle

Design

We have a long history of software application development. Our highly skilled development team consists of Java, C/C++, AJAX, and Python developers and includes specialists in web development, GIS systems, data infrastructure, mobile devices, open source development and enterprise management systems. 

Build

Good development should integrate with a wider information design and strategy. Thanks to our many years of experience designing database schemas, data processing workflows, web based interfaces and associated standards; we can offer you complete solutions.

Testing and deployment

We supply objective application and systems testing services. These include the development of test plans, testing of applications and systems, and validation of the robustness of a system before it is taken into production.

Additionally, we provide services to support taking organizations through to operational readiness. This includes ensuring all checks, documentation and knowledge transfer is completed and ready to become operationally supported.

Design

Our goal is to design an adaptable and flexible physical infrastructure, to maximize the effective space utilization of all of your technology areas to accommodate today's ever changing needs and demands for future expansion or reconfiguration of your facilities using sound IT Infrastructure design and planning principles.

Procurement

We carefully and systematically select products and vendors in order to remove inefficiency and improve strategic collaboration with the supply chain. This approach benefits your organization by having the best infrastructure at highly competitive prices.

Deployment

We ensure that changes deployed into a target system environment are executed in a structured and repeatable manner in order to reduce the risk of failure and error. We completely manage the deployment of servers and client systems, and network devices so that you can focus on your core business area. With increased visibility into operations and security issues, you can also have better control over your business.

Implementation

We monitor IT infrastructure implementation by identifying key risks and formulating mitigations plans to minimize them. We follow structured frameworks to ensure everything goes smoothly and you get your services up and running without delay.

Web mapping

Geospatial Open Source offers a robust stack of feature rich, fast and stable applications. We use and support open source software. By leveraging open source, we tap into a wealth of knowledge available in the international open source communities, we keep abreast of the ongoing development and best practices in geospatial development, and we provide cutting edge products to our clients. Where appropriate, we contribute with patches, new features and even new projects back into the open source communities in order to further the maturity of the products we use and ensure the longevity of our development efforts.

Location information can enhance most applications in the following ways:

  • Maps can be layered over external base maps.

  • Powerful feature editing and analysis tools can be included.

  • Editing and approval workflows can be applied.

  • Access to sensitive features can be limited to privileged users.

Spatial data

Our Geographic Mapping clients are built on rigorously proven, stable, robust, Open Source code bases. Location enhances application Geocoding and address validation improves data quality and usability. Coloured maps provide insights into datasets and displays geographic location of features and boundaries on Earth, such as natural or constructed features, oceans and more.

Powerful feature editing and analysis tools are available. Editing and approval workflows can be applied and access to sensitive features can be limited to privileged users. We often build these clients using widely supported open source applications which provide rapid innovations along with stable, robust code bases.

At the back end, we build and optimize spatial databases, we design information schemas and build automated data processing and validation pipelines. We style maps and publish them to the Internet through standard based interfaces.

Open source

We are leaders and contributors to many of the leading spatial Open Source technologies. We co-coordinate OSGeo-Live, a distribution of the best geospatial open source applications, preconfigured with datasets, project overviews and quickstarts, which have been translated into over 10 languages. Our staff is involved in many committees of the Open Source Geospatial Foundation (OSGeo), including co-authoring incubation processes, and we chaired the international OSGeo conference (FOSS4G) when it was hosted in Australia.

We are also actively involved in spatial research, actively developing and testing upcoming spatial standards on behalf of the international OGC testbeds. In these testbeds we have supported Australian and New Zealand agencies advance spatial standards initiatives within our region. We pride to be one of the few organizations in the world, let along within our region, that have such depth of knowledge and experience with spatial technologies.

*Visit our Case Studies Portfolio Gallery for examples of spatial development projects

Additionally, we run a full range of geospatial training courses as well as customized training tailored to particular systems, configurations and student skill levels. Visit our training page for course and schedule details.

Infrastructure support

We are here to make your life easier by providing support for your most critical business systems when you need it the most.

Our Infrastructure Support services are ideal for customers requiring:

  • Remote and onsite management of their IT resources.

  • Avoidance of crisis situations through a preventive
    approach to IT maintenance.

  • Offsetting limited staff and budgetary resources.

  • Improved consistency and discipline of IT operations.

  • Additional support and maintenance for a rapidly
    expanding IT infrastructure environment.

  • Reduced IT Infrastructure risk.

Managed Support

The IT systems of today are rarely composed of a single vendor’s products. Most often network, security, server, backup and other components are sourced from multiple OEMs (Original Equipment Manufacturer) and integrated to build the required platform. From a support perspective the result it is less than ideal:

  • Too many support contracts.

  • No one vendor able to take ownership.

Hence, we offer a wide selection of support options that are designed to meet your organisational needs. We will ensure that you get fast answers to cover your multi-vendor environment, leaving your resources free to concentrate on your core business by offering:

  • Management of your underlying software and hardware support contracts.

  • Unified SLA for services.

  • A team of engineers that understand your complete IT system.

  • Single point of contact for all support issues.

Application Support

As integration specialists, LISAsoft has experience with an impressive variety of software products. Utilising LISAsoft Support Services is an effective way to maximise your investment in software.

We offer a variety of support options with varying levels of support to ensure you get the help you need as promptly as your business needs require.

Benefits

  • Single point of contact access to market leading engineers with in depth knowledge of a broad range of specialised spatial software.

  • Reassurance that your LISAsoft Support Team has firsthand expertise in deploying and maintaining product spatial solutions.

  • Ability to select the level of service you need.

  • Chance to maximize your own internal IT resources.

Training

Upcoming Courses

PostgreSQL Administration
Sydney
17 May 2016 - 19 May 2016

book now

PostgreSQL Administration

Sydney
17 May 2016 - 19 May 2016

PostgreSQL Administration is a three day course and is one of three professional PostgreSQL courses that we offer.
This PostgreSQL Administration course focuses on PostgreSQL Community edition and it covers:

  • The essential details of PostgreSQL Administration including PostgreSQL architecture
  • Configuration
  • Maintenance
  • Monitoring
  • Backup
  • Recovery
  • Data movement.

Please Note: The PostgreSQL Administration course is prerequisite to the PostgreSQL High Availability and PostgreSQL Oracle Migration courses.

Target Audience: This module is suitable for DBAs, Data Architects, IT Managers, IT Directors, IT Strategists, System Administrators and GIS Professionals. It is designed for people with experience in database administration who are new to PostgreSQL and conveys the knowledge necessary to perform duties comparable to those of a PostgreSQL Database Administrator.

Pre Requisite Knowledge: No prior knowledge of PostgreSQL is required. Basic experience in databases or database administration would be advantageous.

Course Program:

DAY 1

Introduction
Installation
Database Management
Architecture
PSQL
SQL Primer
Roles
Schemas
Tablespaces
Partitions
Views
Indexes

DAY 2

Log Files
Configuration
Security
Contrib Modules
Statistics
PGAdmin
The Data Dictionary
Languages
Triggers
Rules

DAY 3

Logical Backups
Physical Backups
Point In Time Recovery (PITR)
Moving Data
Routine Maintenance
Supported PostgreSQL

Duration: 3 days

Delivery Method: Instructor Led, Classroom

Course Value (exc. GST): $3,620

Course Code: PSQLA01

Book Now

Simply send us your contact information using the form below, and we'll get in touch with you for an immediate booking!

Course Catalogue

Creating Metadata with GeoNetwork

GeoNetwork is a catalog application to manage spatially referenced resources. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. Module 1 is designed for GIS Architecture Managers, GIS Developers and GIS Users.

book now

Creating Metadata with GeoNetwork

GeoNetwork is a catalog application to manage spatially referenced resources. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. It is currently used in numerous Spatial Data Infrastructure initiatives across the world. This courses covers modern data and metadata standards and demonstrates how the use of these standards can secure data against the type of obsolescence caused by changing proprietary data formats or capabilities.

Target audience: Module 1 is designed for GIS Architecture Managers, GIS Developers and GIS Users.

Pre Requisite Knowledge: Familiarity with the architecture of the Open Geospatial Consortium (OGC) Web Service

Course Program:

DAY 1

What GeoNetwork Does
The United Nations Information Working Group (UNGIWG)
Open Geospatial Consortium (OGC) Map Services
Metadata standards and guidelines
GeoNetwork, XML and Web Services
Metadata preparation and management
GeoNetworks Internet Interface

DAY 2

Metadata Fields
Dataset Identification
Spatial Representation
Reference System Information
Constraints Information
Data Quality Information
Maintenance Information
Distribution Information

Duration: 2 Days

Delivery Method: Instructor Led, Classroom

Course Value (exc. GST): $2,550

Course Code: GNWCM01

Book Now

Simply send us your contact information using the form below, and we'll get in touch with you for an immediate booking!

GeoServer Module 1

Professional Geoserver Module 1 covers the publication and styling capabilities of GeoServer. It introduces the standards used, available data sources and performance considerations.

book now

GeoServer Module 1

Professional Geoserver Module 1 covers the publication and styling capabilities of GeoServer. It introduces the standards used, available data sources, performance considerations and covers:

  • Installing and configuring GeoServer and a Postgres/PostGIS spatial database and loading data.
  • Publishing vector and raster data through WMS, Tiled WMS, and WFS interfaces, as well as PDF printing.
  • Viewing in a webpage, using OpenLayers.
  • Introduction to styling and use of colour.
  • Introduction to benchmarking and tuning.

Target Audience: Module 1 is suitable for Geospatial Managers, GIS Professionals, Database Administrators, Database Professionals, System Administrators and relevant ICT Professionals.

Pre Requisite Knowledge: A working knowledge of GIS would be advantageous.

Course Program:

DAY 1

Installing and Configuring GeoServer
Installing and Configuring a Postgres/PostGIS Spatial Database
Loading Data
Publishing Vector & Raster Data Through WMS, Tiled WMS & WFS Interfaces
Publishing Vector and Raster Data to PDF Format

DAY 2

Viewing In Webpages Using OpenLayers
Introduction to Styling and Colour
Introduction to Benchmarking
Introduction to Tuning

Duration: 2 Days

Delivery Method: Instructor Led, Classroom

Course Value (exc. GST): $2,450

Course Code: GSPRO01

Book Now

Simply send us your contact information using the form below, and we'll get in touch with you for an immediate booking!

GeoServer Module 2

Professional Geoserver Module 2 continues the journey of GeoServer Module 1 into advanced GeoServer topics by being designed for those wishing to take GeoServer into a production environment.

book now

GeoServer Module 2

Professional Geoserver Module 2 covers advanced GeoServer topics, and is designed for people wishing to take GeoServer into a production environment. This module covers:

  • Advanced mapping concepts, styling, filters, labelling
  • Incorporating GeoServer extensions
  • Using GeoServer in a range of clients
  • Style optimisation, comparing CSS and SLD
  • Advanced performance benchmarking
  • Security

Target Audience: Professional Geoserver Module 2 is suitable for Geospatial Managers, GIS Professionals, Database Administrators, Database Professionals, System Administrators and relevant ICT Professionals.

Pre Requisite Knowledge: Completion of Professional Geoserver Module 1.

Course Program:

DAY 1

Advanced: Mapping, Styling, Filtering, Labelling
Incorporating GeoServer Extensions
GeoServer Client Application Range and Usage
Style Optimisation and CSS/SLD Comparisons

DAY 2

Advanced Performance Benchmarking
Security Best Practices
Quality of Service
Upgrading
Backup
Deployment Processes

Duration: 2 Days

Delivery Method: Instructor Led, Classroom

Course Value (exc. GST): $2,680

Course Code: GSPRO02

Book Now

Simply send us your contact information using the form below, and we'll get in touch with you for an immediate booking!

Managing Metadata with GeoNetwork

How to deploy GeoNetwork, how an administrator can tailor GeoNetwork’s metadata entry templates for specific user communities, how to make use of automated data entry techniques and how to harvest data from external sources.

book now

Managing Metadata with GeoNetwork

How to deploy GeoNetwork, how an administrator can tailor GeoNetwork’s metadata entry templates for specific user communities, how to make use of automated data entry techniques and how to harvest data from external sources.

Target Audience:

System and GIS Administrators whose roles require them to support and maintain a GeoNetwork installation.

Pre Requisite Knowledge:

Familiarity with the architecture of the Open Geospatial Consortium (OGC) Web Service.

Course Program:

DAY 1

System configuration
Authentication
OGC CSW server configuration
Advanced configuration
User and Group Administration
Localization
System Monitoring

DAY 2

Templates
Ownership and Privileges
Import facilities
Export facilities
Status
Versioning
Formatter
Processing
Fragments
Schemas

Duration: 2 Days

Delivery Method: Instructor Led, Classroom

Course Value (exc. GST): $2,850

Course Code: GNWMM02

Book Now

Simply send us your contact information using the form below, and we'll get in touch with you for an immediate booking!

PostgreSQL Administration

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.

book now

PostgreSQL Administration

PostgreSQL Administration is a three day course and is one of three professional PostgreSQL courses that we offer.
This PostgreSQL Administration course focuses on PostgreSQL Community edition and it covers:

  • The essential details of PostgreSQL Administration including PostgreSQL architecture
  • Configuration
  • Maintenance
  • Monitoring
  • Backup
  • Recovery
  • Data movement.

Please Note: The PostgreSQL Administration course is prerequisite to the PostgreSQL High Availability and PostgreSQL Oracle Migration courses.

Target Audience: This module is suitable for DBAs, Data Architects, IT Managers, IT Directors, IT Strategists, System Administrators and GIS Professionals. It is designed for people with experience in database administration who are new to PostgreSQL and conveys the knowledge necessary to perform duties comparable to those of a PostgreSQL Database Administrator.

Pre Requisite Knowledge: No prior knowledge of PostgreSQL is required. Basic experience in databases or database administration would be advantageous.

Course Program:

DAY 1

Introduction
Installation
Database Management
Architecture
PSQL
SQL Primer
Roles
Schemas
Tablespaces
Partitions
Views
Indexes

DAY 2

Log Files
Configuration
Security
Contrib Modules
Statistics
PGAdmin
The Data Dictionary
Languages
Triggers
Rules

DAY 3

Logical Backups
Physical Backups
Point In Time Recovery (PITR)
Moving Data
Routine Maintenance
Supported PostgreSQL

Duration: 3 days

Delivery Method: Instructor Led, Classroom

Course Value (exc. GST): $3,620

Course Code: PSQLA01

Book Now

Simply send us your contact information using the form below, and we'll get in touch with you for an immediate booking!

PostgreSQL High Availability

High Availability database clusters are groups of databases that can be reliably utilized with a minimum of down-time. They operate by harnessing redundant databases in groups or clusters that provide continued service when system components fail. Without clustering, if a database server running a particular application crashes, the application will be unavailable until the crashed server is fixed. High Availability database clustering remedies this situation.

book now

PostgreSQL High Availability

The PostgreSQL High Availability course is a two day advanced course which builds on the PostgreSQL Administration course, providing an insight into ways to tune, manage and extend your Postgres database to provide a highly available environment. The PostgreSQL High Availability course is a valuable asset to administrators looking to enhance their environment to its full potential. This course focuses on EnterpriseDB’s Postgres Plus editions of PostgreSQL and how to implement and manage fast failover, highly available replication solutions, the range of high availability deployment scenarios, advanced postgreSQL database administration, advanced database architecture techniques, basics of database scalability.

Target Audience: Database Administrators, Database Architects and Developers, System Administrators.

Pre Requisite Knowledge: Completion of our PostgreSQL Administration course. Systems Administration basics of PostgreSQL database administration and/or basics of applications design with databases or PostgreSQL would be advantageous.

Course Program:

DAY 1

Comparison of Different Solutions
Log Shipping Standby Servers
Planning
Standby Server Operation
Preparing the Master for Standby Servers
Setting Up a Standby Server
Streaming Replication
Cascading Replication
Synchronous Replication
Failover
Alternative Method for Log Shipping

DAY 2

Implementation
Record based Log Shipping
Hot Standby
User’s Overview
Handling Query Conflicts
Administrator’s Overview
Hot Standby Parameter Reference
Caveats

Duration: 2 Days

Delivery Method: Instructor Led, Classroom

Course Value (exc. GST): $3,750

Course Code: PSQLH02

Book Now

Simply send us your contact information using the form below, and we'll get in touch with you for an immediate booking!

PostreSQL Oracle Migration

Migrating from Oracle to another database is not a trivial task and will have a variety of issues that need to be resolved either manually, with migration tools, or with compatible feature/function mappings and substitutions.

book now

PostreSQL Oracle Migration

PostgreSQL Oracle Migration is a two day course that focuses on EnterpriseDB’s Enterprise Edition of PostgreSQL and it covers: The processes and techniques required to migrate Oracle database objects to Postgres Plus Advanced Server, how to identify suitable Oracle database migration candidates, how to use the EnterpriseDB Oracle compatibility and database migration tools.

Target Audience: Database Administrators, Database Architects and Developers who want to migrate Oracle Database Objects to Postgres Plus Advanced Server.

Pre Requisite Knowledge: Basic knowledge of Postgres Plus Advanced Server, completion of our PostgreSQL Administration course.

Course Program:

DAY 1

Introduction
Oracle Compatibility
Synonyms
Data Types
ALTER SESSION
DATABASE LINK
CREATE DIRECTORY
Migration
Oracle to Postgres Plus Advanced Server Migration
Migration Process
Migration Toolkit
Installation
Source Specific Drivers

DAY 2

Prepare a Connection
Perform Migration
Example Oracle to Postgres Plus Advanced Server Migration
EDB Loader
COPY Command

Duration: 2 Days

Delivery Method: Classroom

Course Value (exc. GST): $3,910

Course Code: PSQLM03

Book Now

Simply send us your contact information using the form below, and we'll get in touch with you for an immediate booking!

Spatially Enabled with PostGIS

PostGIS is a spatial database extender for the PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.In addition to basic location awareness, PostGIS offers many features rarely found in other competing spatial databases such as Oracle Locator/Spatial and SQL Server.

book now

Spatially Enabled with PostGIS

Spatially Enabled with PostGIS training course is designed to familiarise delegates with PostGIS and increase their competence in spatially enabling geographic objects in a PostgreSQL PostGIS enabled object relational database. Attendees will learn, the difference between spatial and non-spatial databases, the PostgreSQL database and PostGIS, how to load and manage spatial data using PostGIS , how to perform various types of queries and understand the difference between a simple and a spatial query, and how to manage the database.

Target Audience: Database Scientists, Geoscientists, Geospatial Technology Managers, GIS Data Coordinators, Spatial Operations Managers, Metadata Managers, Enterprise Architects.

Pre Requisite Knowledge: Familiarity with SQL SELECT statements, knowledge of relational database models and structures, familiarity with spatial data and concepts.

Course Program:

DAY 1

Introduction to PostGIS
PostGIS Case Studies
Basic Tools
Datatabase Basics
Overview of the Data
Representing Geometries
Formatting your Output
PostGIS Metadata
Geographic Objects and Geometry Accessors
Visualising Data
Importing Data
Projection Overview

DAY 2

Projecting Data
Measurement Functions
Spatial Joins
Indexing Tablespaces
Tuning the Database
Optimising Query Plans
Clustering
Equality and Validity
Aggregate Functions
Set Returning Functions
Pointset Operations

Duration: 2 Days

Delivery Method Instructor Led, Classroom

Course Value (exc. GST): $2,550

Course Code: PSGIS01

Book Now

Simply send us your contact information using the form below, and we'll get in touch with you for an immediate booking!

Web Mapping With OpenLayers

OpenLayers is an open source JavaScript library for displaying map data in web browsers. It provides an API for building rich web-based geographic applications similar to Google Maps and Bing Maps. The library was originally based on the Prototype JavaScript Framework.

book now

Web Mapping With OpenLayers

LISAsoft’s Web Mapping With OpenLayers is a two day course designed for web developers creating sites requiring map functionality. This course shows, how to put a dynamic maps into any web page, integrate data from a variety of sources, add vector data layers on top of base map sources.

Target Audience: Data Managers, Data Scientists, Geospatial Administrators, Geospatial Systems Analysts, Geospatial Technology Manager,GIS Team Leaders, GIS Data Coordinators, GIS Systems Managers, Spatial Analysts.

Pre Requisite Knowledge: Familiarity with basic GIS and/or web development concepts would be advantageous.

Course Program:

DAY 1

Web Mapping Applications
Getting Started With OpenLayers 3
Understanding OpenLayers 3 Key Components
Debugging OpenLayers
Controlling Map Views

DAY 2

Interacting With Your Map
Map Renderers
Different Layers in OpenLayers 3
Vector Layers

Duration: 2 Days

Delivery Method: Instructor Led, Classroom

Course Value (exc. GST): $2,250

Course Code: OLWMW01

Book Now

Simply send us your contact information using the form below, and we'll get in touch with you for an immediate booking!

Case Studies

  • Geoscience Australia

    LISAsoft was approached to investigate the feasibility of adopting the PostgreSQL open-source database to replace some Oracle workloads, and allow Geoscience Australia to move toward a de-coupled database platform with less restrictive licensing.

    read more
  • Sportsbet - Distributed Website Performance Monitoring

    LISAsoft designed, implemented and are supporting a distributed website performance monitoring tool based on open source tools for Sportsbet. This has enabled Sportsbet to significantly reduce their ongoing licensing costs.

    read more
  • BOSCAR - GeoSpatial Implementation

    The NSW Bureau of Crime Statistics and Research (BOCSAR) have recently built an interactive mapping application that allows users to view rates and changes in various crime categories around NSW over the past few decades. Unfortunately, the application was unable to meet the performance and stability requirements of a highly-available web application.

    read more
  • Australian Bureau of Meteorology - National Environmental Information Infrastructure Pilot

    The natural environment plays an important role in Australia’s economy and way of life. To manage it effectively, governments, industry and the community need comprehensive, trusted and timely environmental information to make sound environmental decisions. To support this need, the Australian Bureau of Meteorology (the Bureau) is leading the National Plan for Environmental Information initiative that will deliver improved quality, coverage, usability and access to environmental information.

    read more
  • Snowy Hydro - GIS database

    Snowy Hydro’s previous GIS Database was facing procedural, structural, and content issues. These cumulated in higher maintenance costs, potential data integrity issues, and difficulty for business to capitalise on potential value held within the geospatial data assets.

    read more

Geoscience Australia

The Challenge

Most of Geoscience Australia’s applications store data in a small number of highly linked schemas in Oracle databases hosted on Oracle Exadata servers.

Geoscience Australia had identified that this high dependence upon one vendor combined with the highly coupled schema design was limiting cost effective deployment and maintenance of future services, was constraining adoption of scalable and cloud based architectures, and was not in line with Geoscience Australia’s ICT strategy. The ICT Strategy highlights the importance of Open Standards and Open Source Software, as well as promoting associated benefits such as modular architectures, interoperability, collaboration, reusability and agility.

The Solution

LISAsoft analysed Geoscience Australia’s use of Oracle, PostgreSQL and MySQL databases and described strategies to migrate a PostgreSQL based system. These included:

  • Applications that are database agnostic, and straight forward to migrate.

  • Applications with a heavy dependence upon the Oracle syntax, such as PL/SQL, which can be migrated using EnterpriseDB’s Oracle Compatibility functionality. These applications usually have a reasonably straightforward migration path.

  • Applications that can use automated migration tools or require minor changes to existing code. These require moderate effort to migrate.

  • Complex migrations, including applications that have a high lock-in dependency upon the Oracle database, and/or have to be manually migrated to another framework, such as Oracle APEX.

Based on this assessment LISAsoft identified that there were established and viable migration strategies available for most Geoscience Australia applications. Much of the data stored in Oracle is scientific data, stored in a highly-linked, monolithic database. The linked data allows powerful cross-domain queries, however the lack of modularity impacts cloud readiness, maintainability and stability.

As part of the assessment, LISAsoft described how to de-couple the data into numerous point-of-truth databases, breaking the interdependencies, while still providing cross database SQL querying by using an aggregated data warehouse. LISAsoft concluded by describing the next steps to follow in order to further embrace the opportunities PostgreSQL offers.

Sportsbet - Distributed Website Performance Monitoring

The Challenge

Sportsbet approached LISAsoft with the aims of lowering their ongoing licensing costs in applications to support their websites' features.

The Solution

LISAsoft designed, implemented and are supporting a distributed website performance monitoring tool based on open source tools for Sportsbet. This platform measures the performance of multiple websites as seen from different locations through several different browsers. Measurements are scheduled and recorded by a control server, which sends requests to probe servers to run customised workflows. The platform reports on various metrics, including page load time, DNS lookup time, client load time and blocking time.

The solution is based around Selenium, an open source distributed browser automation suite, and also makes use of Zabbix, Java, JUnit and Maven. The platform tests performance of mobile and standard websites using Internet Explorer, Firefox and Chrome browsers.

Zabbix was integrated into the solution to automate the tests and graph key performance metrics over time. This allows Sportsbet to easily identify periods of performance problems as well as monitor trends over long periods.

Moving forward LISAsoft has provided Sportsbet with the tools and support to extend their monitoring capability across a greater range of metrics, websites, browsers and locations while lowering the total cost of ownership for the platform.

BOSCAR - GeoSpatial Implementation

The Challenge

The NSW Bureau of Crime Statistics and Research (BOCSAR) have recently built an interactive mapping application that allows users to view rates and changes in various crime categories around NSW over the past few decades. The application provides a large map interface that displays GeoServer / GeoWebCache rendered thematic layers showing the relative rate of incidents by various political boundaries overlayed on a Google base map. A menu bar on the side provides users the ability to change the type of incident to show, as well as details regarding the victim, perpetrator and venue. Temporal adjustments are available in the tool bar at the top, alongside a search field that provides name searching for available political boundaries, including suburbs and postcodes.

This application provides a wealth of information in an easy to navigate interface which was fully functional on delivery. Unfortunately, the application was unable to meet the performance and stability requirements of a highly-available web application.

The Solution

As experts in GeoServer deployments, LISAsoft was contracted to investigate the issues and determine what was needed to improve the performance of the map service and to resolve the stability issues. LISAsoft engineers visited BOCSAR offices to perform static analysis on the existing configuration and logs from the application servers, web applications and Java Virtual Machine. Local staff were then enlisted to assist with the performance of load testing and resource monitoring of both the application and database servers on the staging environment in order to replicate some of the issues causing instability in the system. This allowed LISAsoft to leverage the skills and knowledge of BOCSAR’s systems to streamline the collection of resource metrics during load and provide a wealth of information regarding the execution of mapping requests.

On completion of the on-site analysis and testing, LISAsoft researched and drafted a set of prioritised requirements. These outlined a series of steps to update the software and configuration, and perform some optimistic pre-caching of mapping layers to eliminate the system instability and greatly improve the performance of the map rendering and service.

Having completed the first few recommendations, the NSW Crime Tool is sufficiently stable for a public release. BOCSAR is continuing with the remaining recommendations in order to further improve the performance and scalability of the application in the lead up to a marketing push for the application.

Australian Bureau of Meteorology - National Environmental Information Infrastructure Pilot

The Challenge

There are multiple challenges involved in achieving an effective infrastructure. First, the source data, which is continuously updated by multiple agencies, needs to be dynamically collated into aggregated datasets to facilitate macro analysis. This requires development and agreement upon standard data formats, processes and tools which source agencies can use to publish the source data. Once aggregated, the data requires distribution and publishing in a manner that can easily be accessed and manipulated by end users. This requires a robust and reliable publishing infrastructure, built upon standard interfaces, which can be used easily and efficiently by existing or provided tools. Furthermore, the infra­structure developed needs to be both feasible and sustainable. As such, the Bureau has selected a distributed design based upon OGC standards based services and formats.

  • Consulting on and documenting the NEII architecture design.

  • Defining some of the information models required.

  • Developing pilot implementations of an NEII node. The NEII node publishes data via a Web Feature Service (WFS) interface using the GeoServer spatial data server. GeoServer has been the target of recent CSIRO development efforts to create a service capable of supporting the complexity of data models required for projects such as NEII.

  • Configuring a web based catalogue which can be used to find datasets. This is based upon the Catalogue Service for the Web (CSW) interface, and implemented using the Open Source GeoNetwork application.

  • Web services compliance testing.

The Solution

As one element of the initiative LISAsoft has supported the Bureau in piloting parts of a National Environmental Information Infrastructure (NEII). This pilot has demonstrated the process of modelling and publication of environmental information from atmosphere, ocean, land and water domains. To support the Bureau, LISAsoft has drawn upon years of relevant experience, including:

  • Domain Modelling during international, OGC standards development testbeds,

  • Co-authoring a Domain Modelling Cookbook with CSIRO,

  • Testing conformance of Web Feature Services in both Australian Spatial Data Infrastructures as well as in OGC testbeds, and

  • Deploying, configuring and optimising GeoServer for multiple projects.

The NEII pilot completed successfully and has validated the feasibility of the proposed design, and provided valuable feedback into the practicality of the approach and tools. These valuable lessons will be fed into the greater National Plan for Environmental Information.

Snowy Hydro - GIS database

The Challenge

Snowy Hydro’s internal business groups use unconnected third party software platforms when performing operational tasks such as real-time monitoring, reporting, and asset maintenance. These systems mostly lack the ability to share information across business group domains.

Snowy Hydro also maintained a GIS system based on an open source stack of PostgreSQL/PostGISdatabase, GeoServer, and QGIS desktop client. The GIS database developed organically over time to meet business needs and consisted of a variegated collection of datasets of internal and external origin. As a result, the GIS data content and design lacked consistency in naming conventions, projections, attribute types and values.

The existing system represented many lost business opportunities for Snowy Hydro in leveraging its existing data systems. While each system worked well and was essential to individual business groups, Snowy Hydro didn’t have a solution for integrating the data across business groups. The GIS system had the potential to grow from its current modest usage into a more full featured and essential system.

The Solution

In order to determine the best structure for the new system, LISAsoft started with on site consultation at Snowy Hydro where needs of business groups were assessed. User stories were created that described how each group used the current system and how they would like to use the system in the future. The process helped business users articulate their needs clearly. For the first time, a holistic view of current and potential GIS use cases was gathered, enabling Snowy Hydro to prioritise future projects that provided the best return of investment for development time and cost.

In order to clearly define what changes would be made during the refactoring process, LISAsoft produced a Database Strategy Document that was presented and discussed with Snowy Hydro. The strategy documented the user stories as well as the planned restructuring of the GIS system. The document also presented a preliminary specification of the new guidelines that would be followed during the database migration as well as the steps that would be followed in the data migration.

To document the new system, LISAsoft created a Data Model Document that catalogued and described the newly refactored database schemas and tables. Each table was described along with the source and licensing information for the dataset. The fields were individually listed along with any table constraints. This document was presented in an editable final form so that Snowy Hydro could continue to update the document as the GIS system grew and changed. LISAsoft used a multi-strategy approach to unlock the potential value in Snowy Hydro’s GIS database.

The refactored GIS system is more consistent and is based on a set of opaque standards. The standards can be used to update the current data and to ensure that future datasets were added in a consistent manner. Snowy Hydro also received a review of the structure of the database to ensure that the system was able to grow with business needs. The new system is also more accessible and useful for existing business users as well as unlocking value for other business groups that were not previously using the system.

Our Partners