Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (22)
- All (399)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Conversion (2)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (5)
- Open Source (18)
- Oracle Spatial and Locator (194)
- Partitioning (1)
- PostGIS (36)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (37)
- Space Curves (9)
- Spatial Database Functions (109)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (17)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
A Biography
Simon Greener has university qualifications in geomatics, computing science, database technologies, and project management.
He started his working career with mining and surveying experience. He then found his calling as a computer scientist with his first job being as a database programmer on IBM mainframes for Telstra. He switched to GIS three years later through working in a multi-disciplinary GIS research team at Telecom’s Research Laboratories (TRL) in Clayton, Victoria. While at TRL he worked on projects whose outcome saw the creation of what is now Telstra’s Sensis group.
After leaving TRL, he worked as a lecturer and consultant for CenSIS (University of Tasmania) under Prof Peter Zwart, writing student and technical training courses. While there, he continued to consult to Telstra’s Directory Services and Mobile groups. It was here that he came in contact with the Spatial DataBase Engine (SDBE) from Geographic Technologies Incorporated (GTI) and saw its potential for the management of large scale spatial databases within relational database technologies: a merging of his IT and GIS “worlds”. This led to the foundation of Salamanca Software Pty Ltd (SalSoft) of which he was a Director until it was purchased by ESRI Au in 1996.
Some notable achievements while at SalSoft included helping broker the sale of SDBE to ESRI Inc (now ArcSDE), the winning of the first ArcSDE sale to Telstra to power its Whitepages/Yellowpages mapping portal, co-authoring a geocoding specification for Spatial Decision Systems (now Sensis), consulting for Geographic Technologies Australia on numerous projects based on Universal Press street directory data, and the creation of GeoCASE/Blueprint: the world’s first data modeling tool that enabled the modeling of spatial data and relationships.
In 1997 he was appointed GIS Manager for Forestry Tasmania (FT) in Hobart, Tasmania. While at FT he architected the complete revamp of FT’s GIS systems using Oracle Spatial (being one of the earliest adopters of the Sdo_Geometry implementation) as the core data management technology. He concentrating on embedding geospatial data and processing within business systems via a value-oriented business-centric computing model. He designed and built numerous systems during those years, the best of which was MapComposer: a three-click web-enabled business map production system that, when he left in 2005, had grown (2000-) to over 320 online uses, producing over 50,000 maps a year from a repository of over 100 different map templates (still in operation in 2013). His years at FT concluded with the writing of a GIS Strategy that saw the use of GIS increase yet the cost of the technology to the organization decrease.
He left FT in September 2005 for the precarious world of self-employment. He was a sometime copyist for Directions Magazine. As a subcontractor to a 1Spatial distributor in Australia, he wrote a Radius Topology training course and provided Radius Topology and Oracle Spatial consulting services for them at numerous customer sites until May 2006. From May to August 2006 he was engaged by 1Spatial, Cambridge, UK under a UK Government Department of Trade and Industry’s GlobalWatch program to conduct research and development in relation to enhancing the export potential of their latest product, Radius Studio (resulted in Radius Studio being integrated with Feature Data Objects � FDO � technology to extend its data access capabilities).
In his consulting career, he has written a spatial strategy document and conducted a database performance analysis review for a large Tasmanian Government department; conducted a number of Oracle spatial database best-practice, tender and system, and return on investment reviews at a number of Victorian Government departments; wrote and delivered a user requirements document for Enterprise GIS at a large Australian corporation; provided guidance and implementation services to an ambulance service helping integrate Oracle Spatial into a data warehouse project that used Oracle Portal, Discoverer and Data Warehouse Builder; delivered many, many solutions for a NSW water authority; and finally successfully completed many migration, publication, return on investment, process improvement and database design contracts for a number of Canberra based Federal Government departments.
Simon makes available a collection of PL/SQL and Java based sample solutions for the Oracle database via his website. He is also principal programmer for the SQL Developer spatial extension, GeoRaptor. Finally, he was awarded, by Oracle, the �2011 Oracle Spatial Excellence Award for Education and Research�.
His technical areas of expertise include systems design and architecture, (spatial and attribute) data management and modeling in both the OLTP and OLAP spaces, and is an evangelist for O-RDMS based spatial data. He is available for free-lance geospatial solutions architecture work, Java and PL/SQL programming, and provides Oracle Spatial benchmarking and performance enhancement services.
He is currently writing a book on Oracle Spatial with Siva Ravada (Oracle Spatial Product Development Manager) for PACKT publishing due for release in Q4 2013.
His non-technical interests are his family, friends, walking, reading, singing and motorcycle riding.
Documentation
- MySQL Spatial General Functions
- Oracle LRS Objects
- Oracle Spatial Exporter (Java + pl/SQL)
- Oracle Spatial Object Functions
- Oracle Spatial Object Functions (Multi Page)
- PostGIS pl/pgSQL Functions
- SC4O Oracle Java Topology Suite (Java + pl/SQL)
- SQL Server Spatial General TSQL Functions
- SQL Server Spatial LRS TSQL Functions