Business example 1: Monitoring of ships in an offshore windfarm construction site for health and safety considerations.
Very brief explanation of AIS (ship GIS) messages: dynamic indicating ship’s position, speed, name, destination, rate of turn, MMSI (id), etc.; static indicating destination, weight, draught, etc. Such info is sent every 2 seconds by a moving ship. Spatio-temporal indexing, ie, spatial index for ship’s position plus a time stamp for the ais signal.Example queries that can be written against such an index for business support and health and safety:
Business example 2: Business location.
Using a number of different databases maintained by our company, demonstrate how spatial and non-spatial attributes can be used together with spatial functions such as contains, distance, and area to answer a wide range of business location questions. For example find all parcels of land greater than 500 hectares, within 10km of a town with a population of at least 20,000, not within 5km of a site of scientific special interest, more than 50m above sea level, where no chemical spills have occurred in the last 50 years and group this by local authority. Query parameters to be tweaked and output shown in a Java front end to show the speed and power of these kinds of business location queries.
Briefly mention other areas where spatial data types and functions enable similar analysis, for example, epidemiology, crime monitoring, animal monitoring in wildlife reserves.
Conclusion: Vast quantities of spatial data and accompanying attributes can easily be stored and rapidly retrieved using MySQL’s spatial functions and indexing. Numerous spatial functions allow this data to be analysed in ways that have been traditionally the preserve of expensive, proprietary GIS systems. Some very sophisticated analysis can be done directly using SQL functions, however, the open standards supported by MySQL make it easy to import/export spatial data for visualization or further analysis. A programming language like Java, with good libraries in areas such as graphics, XML, and threading in conjunction with a MySQL backend can be used to build sophisticated, distributed, customized applications with all of the capabilities of a traditional GIS system.
An ex-economist who was introduced to programming via Excel VBA on an investment bank trading floor. Fled banking, took an MSc in GIS. Have spent last five years as a Java and MySQL evangelist at an online UK mapping company.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.