Table of Contents

Abstract

Adopts ISO 19125-2:2004 which specifies an SQL schema that supports storage, retrieval, query and update of simple geospatial feature collections via the SQL Call Level Interface (SQL/CLI) (ISO/IEC 9075-3:1999).
RECONFIRMATION NOTICE
Technical Committee IT-004 has reviewed the content of this publication and in accordance with Standards Australia procedures for reconfirmation, it has been determined that the publication is still valid and does not require change.
Certain documents referenced in the publication may have been amended since the original date of publication. Users are advised to ensure that they are using the latest versions of such documents as appropriate, unless advised otherwise in this Reconfirmation Notice.
Approved for reconfirmation in accordance with Standards Australia procedures for reconfirmation on 18 May 2015.
Approved for reconfirmation in New Zealand on behalf of the Standards Council of New Zealand on 4 November 2016.
The following are represented on Technical Committee IT-004:
ANZLIC - the Spatial Information Council
Australian Antarctic Division
Australian Bureau of Meteorology
Australian Bureau of Statistics
Australian Hydrographic Office
CSIRO
Curtin University of Technology
Department of Communications (Australian Government)
Department of Defence (Australian Government)
Geoscience Australia
Master Builders Australia
New Zealand Geospatial Office
Science New Zealand
Spatial Industries Business Association

Scope

This part of ISO 19125 specifies an SQL schema that supports storage, retrieval, query and update of simple geospatial feature collections via the SQL Call Level Interface (SQL/CLI) (ISO/IEC 9075-3:2003).
This part of ISO 19125 establishes an architecture for the implementation of feature tables.
This part of ISO 19125 defines terms to use within the architecture.
This part of ISO 19125 defines a simple feature profile of ISO 19107.
This part of ISO 19125 describes a set of SQL Geometry Types together with SQL functions on those types.
The Geometry Types and Functions described in this part of ISO 19125 represent a profile of ISO 13249-3.
This part of ISO 19125 does not attempt to standardize and does not depend upon any part of the mechanism by which Types are added and maintained in the SQL environment including the following:
a) the syntax and functionality provided for defining types;
b) the syntax and functionality provided for defining SQL functions;
c) the physical storage of type instances in the database;
d) specific terminology used to refer to User Defined Types, for example, UDT.
This part of ISO 19125 does standardize:
names and geometric definitions of the SQL Types for Geometry;
names, signatures and geometric definitions of the SQL Functions for Geometry.
This part of ISO 19125 describes a feature access implementation in SQL based on a profile of ISO 19107.
ISO 19107 does not place any requirements on how to define the Geometry Types in the internal schema.
ISO 19107 does not place any requirements on when or how or who defines the Geometry Types. In
particular, a compliant system may be shipped to the database user with the set of Geometry Types and Functions already built into the SQL-implementation, or with the set of Geometry Types and Functions supplied to the database user as a dynamically loaded extension to the SQL-implementation or in any other manner not mentioned in this part of ISO 19125.

General Product Information

Published
Document Type	Standard
Status	Current
Publisher	Standards Australia
ProductNote	Reconfirmed 23/12/2016. This standard has been reconfirmed in Australia in 2016 and remains current in New Zealand. Reconfirmation Notice 23/12/2016
Pages
ISBN
Committee	IT-004
Supersedes	DR 04272 CP