| gvSIG desktop 1

Epsg-hsql (geotools) project had to be modified in 1.9 version in order to

fix #777 bug (from gvSIG TRAC). As geotools JARs were not versioned in our

SVN repository, I had to guess the version (I used geotools 2.1.1).

The resulting JAR (geotools-epsg-hsql-2.1.1_gvsig.jar) replaced 'db_epsg.jar'.

 ------

Changes from original 2.1.1 version of Geotools:

- 20090518 by cmartinez:

   EPSG.sql: DB taken from db_epsg.jar (from gvSIG trunk repository):

- 20090518 by cmartinez:

   HSQLDataSource.java: create a different tmp dir for each GeoTools instance

<projectDescription>

  <name>gt2-epsg-hsql</name>

  <comment>Connection to an embedded EPSG database in HSQL format.

    This database is built from the SQL scripts delivered by EPSG.</comment>

  <projects/>

  <buildSpec>

    <buildCommand>

      <name>org.eclipse.jdt.core.javabuilder</name>

    </buildCommand>

  </buildSpec>

  <natures>

    <nature>org.eclipse.jdt.core.javanature</nature>

  </natures>

</projectDescription>

<?xml version="1.0" encoding="utf-8"?>

<project>

  <pomVersion>3</pomVersion>

  <extend>${basedir}/../../project.xml</extend>

  <name>geotools-epsg-hsql</name>

  <id>epsg-hsql</id>

  <currentVersion>2.1.1</currentVersion>

  <package>org.geotools.referencing</package>

  <shortDescription>EPSG Authoriy Service</shortDescription>

  <gumpRepositoryId>geotools</gumpRepositoryId>

  <description>

    Connection to an embedded EPSG database in HSQL format.

    This is database is built from the SQL scripts delivered by EPSG.

    This plugin is very short and the code contains nothing else than

    connection parameters through the use of a jar embedding the HSQL

    files.

  </description>

  <developers>

    <developer>

      <name>Didier Richard</name>

      <email>dgr@libertysurf.fr</email>

      <organization>Institut Géographique National - France</organization>

      <roles>

        <role>Contributor</role>

      </roles>

    </developer>

    <developer>

      <name>Martin Desruisseaux</name>

      <id>desruisseaux</id>

      <email>desruisseaux@users.sourceforge.net</email>

      <organization>Institut de Recherche pour le Développement</organization>

      <roles>

        <role>Java Developer</role>

        <role>Module Maintainer</role>

      </roles>

    </developer>

  </developers>

  <dependencies>

    <dependency>

      <artifactId>main</artifactId>

      <groupId>gt2</groupId>

      <version>2.1.1</version>

    </dependency>

    <dependency>

     <groupId>units</groupId>

     <artifactId>units</artifactId>

     <version>0.01</version>

     <url>http://jsr-108.sourceforge.net</url>

    </dependency>

    <dependency>

     <groupId>vecmath</groupId>

     <artifactId>vecmath</artifactId>

     <version>1.3</version>

     <url>http://java.sun.com/products/java-media/3D/</url>

    </dependency>

    <dependency>

     <artifactId>hsqldb</artifactId>

     <groupId>hsql</groupId>

     <version>1.8.0.1</version>

    </dependency>

    <dependency>

     <groupId>JTS</groupId>

     <artifactId>JTS</artifactId>

     <version>1.6</version>

     <type>jar</type>

    </dependency>

  </dependencies>

  <build>

    <resources>

      <resource>

        <directory>${basedir}/src</directory>

        <includes>

          <include>META-INF/services/**</include>

          <include>**/*.sql</include>

        </includes>

      </resource>

    </resources>

    <unitTest>

      <includes>

        <include>**/*Test.java</include>

      </includes>

      <resources>

        <resource>

          <directory>${basedir}/test</directory>

        </resource>

      </resources>

    </unitTest>

  </build>

</project>

org.geotools.referencing.factory.epsg.HSQLDataSource

/*

 * Geotools 2 - OpenSource mapping toolkit

 * (C) 2005, Geotools Project Managment Committee (PMC)

 *

 *    This library is free software; you can redistribute it and/or

 *    modify it under the terms of the GNU Lesser General Public

 *    License as published by the Free Software Foundation; either

 *    version 2.1 of the License, or (at your option) any later version.

 *

 *    This library is distributed in the hope that it will be useful,

 *    but WITHOUT ANY WARRANTY; without even the implied warranty of

 *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU

 *    Lesser General Public License for more details.

 *

 *    You should have received a copy of the GNU Lesser General Public

 *    License along with this library; if not, write to the Free Software

 *    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 */

package org.geotools.referencing.factory.epsg;

// J2SE dependencies

import java.sql.Statement;

import java.sql.Connection;

import java.sql.SQLException;

import java.util.regex.Pattern;

import java.util.regex.Matcher;

// Geotools dependencies

import org.geotools.factory.Hints;

import org.geotools.referencing.factory.FactoryGroup;

/**

 * Adapts SQL statements for HSQL. The HSQL database engine doesn't understand

 * the parenthesis in (INNER JOIN ... ON) statements for the "BursaWolfParameters"

 * query. Unfortunatly, those parenthesis are required by MS-Access. We need to

 * removes them programmatically here.

 *

 * @version $Id: FactoryUsingHSQL.java 14624 2005-06-29 02:19:08Z desruisseaux $

 * @author Martin Desruisseaux

 *

 * @since 2.2

 */

final class FactoryUsingHSQL extends FactoryUsingAnsiSQL {

    /**

     * The regular expression pattern for searching the "FROM (" clause.

     * This is the pattern for the opening parenthesis.

     */

    private static final Pattern OPENING_PATTERN =

            Pattern.compile("\\s+FROM\\s*\\(",

            Pattern.CASE_INSENSITIVE);

    /**

     * Constructs the factory for the given connection to the HSQL database.

     */

    public FactoryUsingHSQL(final FactoryGroup factories, final Connection connection) {

        super(factories, connection);

    }

    /**

     * If the query contains a "FROM (" expression, remove the parenthesis.

     */

    public String adaptSQL(String query) {

        query = super.adaptSQL(query);

        final Matcher matcher = OPENING_PATTERN.matcher(query);

        if (matcher.find()) {

            final int opening = matcher.end()-1;

            final int length  = query.length();

            int closing = opening;

            for (int count=0; ; closing++) {

                if (closing >= length) {

                    // Should never happen with well formed SQL statement.

                    // If it happen anyway, don't change anything and let

                    // the HSQL driver produces a "syntax error" message.

                    return query;

                }

                switch (query.charAt(closing)) {

                    case '(': count++; break;

                    case ')': count--; break;

                    default : continue;

                }

                if (count == 0) {

                    break;

                }

            }

            query = query.substring(0,         opening) +

                    query.substring(opening+1, closing) +

                    query.substring(closing+1);

        }

        return query;

    }

    /**

     * Shutdown the HSQL database engine.

     */

    void shutdown(final boolean active) throws SQLException {

        if (active) {

            final Statement statement = connection.createStatement();

            statement.execute("SHUTDOWN");

            statement.close();

        }

        super.shutdown(active);

    }

}

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<HTML>

  <HEAD>

    <TITLE>Creating EPSG database for HSQL</TITLE>

  </HEAD>

  <BODY>

    <H1>Creating EPSG database for HSQL</H1>

    <P ALIGN="justify">The following gives some hints for creating a HSQL database

    and populate it with EPSG data from the SQL scripts.</P>

    <UL>

      <LI><P>Copy the <CODE><A HREF="sqltool.rc">sqltool.rc</A></CODE> file in the developper's

      home directory and edit it URL path provided in this file.</P></LI>

      <LI><P>Prepare a copy of EPSG's SQL scripts and modify them for HSQL syntax. The

      following <A HREF="PrepareForHSQL.xml">Ant file</A> can be used for this purpose.</P></LI>

      <LI><P>Creates the database using the following commands:</P>

<BLOCKQUOTE><PRE>java org.hsqldb.util.SqlTool --autoCommit EPSG-admin EPSG_v67.hsql_Tables.sql

java org.hsqldb.util.SqlTool --autoCommit EPSG-admin EPSG_v67.hsql_Data.sql

java org.hsqldb.util.SqlTool --autoCommit EPSG-admin EPSG_v67.hsql_FKeys.sql</PRE></BLOCKQUOTE></LI>

      <LI><P>Launch the following application:</P></LI>

<BLOCKQUOTE><PRE>java org.hsqldb.util.DatabaseManagerSwing</PRE></BLOCKQUOTE></LI>

      <P>Make sure the database is okay, and invoke the following commands:</P>

<BLOCKQUOTE><PRE>SCRIPT 'EPSG.sql';

SHUTDOWN COMPACT;</PRE></BLOCKQUOTE></LI>

      <LI><P>Quit the application. Edit the <CODE>EPSG.sql</CODE> script as below:</P>

      <UL>

        <LI>Remove the <CODE>SET DELAY 60</CODE> statement; 60 is already the default.</LI>

        <LI>Remove the <CODE>CREATE USER "SA"</CODE> statement; this user will exists

            before the script is run.</LI>

        <LI>In the table <CODE>EPSG_DATUM</CODE>, change the type of column <CODE>REALIZATION_EPOCH</CODE>

            to <CODE>INTEGER</CODE>.</LI>

        <LI>Copy all <CODE>ALTER TABLE ... FOREIGN KEY</CODE> statements to the end of the script.</LI>

        <LI>Remove all <CODE>CONSTRAINT ... FOREIGN KEY</CODE> from the <CODE>CREATE TABLE</CODE>

            statements at the begining of the script, and move them as <CODE>ALTER TABLE ... FOREIGN KEY</CODE>

            statements at the end of the script.</LI>

        <LI>Add <CODE>SHUTDOWN COMPACT</CODE> statement at the end of file.</LI>

      </UL></LI>

      <LI><P>Run the following commands:</P>

<BLOCKQUOTE><PRE>java org.geotools.referencing.factory.epsg.Compactor</PRE></BLOCKQUOTE></LI>

      <LI><P>Copy the file created in the above step into the

          <CODE>org.geotools.referencing.factory.epsg</CODE> package directory

          using "<CODE>EPSG.sql</CODE>" filename. Finally, create the JAR file

          as usual, which should includes the <CODE>EPSG.sql</CODE> script.<P></LI>

    </UL>

  </BODY>

</HTML>

<?xml version="1.0" encoding="ISO-8859-1"?>

<!-- ========================================================================

     ANT BUILD FILE (Ref. http://jakarta.apache.org/ant )

     Ant script preparing SQL scripts for HSQL. The scripts provided by EPSG

     can't be run "as is" because of minor SQL language differences. Some

     keywords must be replaced, and the date format must be changed from

     "yyyy/mm/dd" to "yyyy-mm-dd". This scripts performs those changes in a

     copy of EPSG scripts.

     There is one change that this script doesn't performs. Column creation

     in the form "columnName type UNIQUE" must move the "unique" keyword at

     the end of table creation in the form "UNIQUE (columnName)". This change

     need to be done by hand in the "EPSG_v66.hsql_Tables.sql" file.

     The SQL scripts must be executed in the following order:

         EPSG_v66.hsql_Tables.sql

         EPSG_v66.hsql_Data.sql

         EPSG_v66.hsql_FKeys.sql

     Author:  Martin Desruisseaux

     Version: $Id: PrepareForHSQL.xml 14624 2005-06-29 02:19:08Z desruisseaux $

     ======================================================================== -->

<project name="Create HSQL scripts" default="create">

  <target name="create">

    <copy file="EPSG_v67.mdb_Tables.sql" tofile="EPSG_v67.hsql_Tables.sql"/>

    <copy file="EPSG_v67.mdb_FKeys.sql"  tofile="EPSG_v67.hsql_FKeys.sql" />

    <copy file="EPSG_v67.mdb_Data.sql"   tofile="EPSG_v67.hsql_Data.sql"  />

    <replace file="EPSG_v67.hsql_Tables.sql">

      <replacefilter token="CREATE TABLE" value="CREATE CACHED TABLE"/>

      <replacefilter token="TEXT"         value="VARCHAR"            />

    </replace>

    <replaceregexp file="EPSG_v67.hsql_Data.sql" byline="true">

      <regexp pattern="'(\d{4})/(\d{2})/(\d{2})',\s*"/>

      <substitution expression="'\1-\2-\3',"/>

    </replaceregexp>

  </target>

</project>

#

# Connection parameters to the EPSG database with HSQL. Developpers should

# copy this file in their home directory and change the path name to their

# database installation directory. Note: the trailing "EPSG" is the database

# name, not a directory name.

#

# This file doesn't need to be distributed in the JAR file. It is

# included here only for maintenance of the EPSG database for HSQL.

#

# Author: Martin Desruisseaux

# Revision: $Id: sqltool.rc 14624 2005-06-29 02:19:08Z desruisseaux $

#

urlid EPSG

url jdbc:hsqldb:file:/tmp/Geotools/Cached databases/EPSG

username Geotools

password Geotools

urlid EPSG-admin

url jdbc:hsqldb:file:/tmp/Geotools/Cached databases/EPSG

username sa

password

CREATE CACHED TABLE EPSG_ALIAS(ALIAS_CODE INTEGER NOT NULL,OBJECT_TABLE_NAME VARCHAR(80) NOT NULL,OBJECT_CODE INTEGER NOT NULL,NAMING_SYSTEM_CODE INTEGER NOT NULL,ALIAS VARCHAR(80) NOT NULL,REMARKS VARCHAR(254),CONSTRAINT PK_ALIAS PRIMARY KEY(ALIAS_CODE))

CREATE CACHED TABLE EPSG_AREA(AREA_CODE INTEGER NOT NULL,AREA_NAME VARCHAR(80) NOT NULL,AREA_OF_USE VARCHAR NOT NULL,AREA_SOUTH_BOUND_LAT DOUBLE,AREA_NORTH_BOUND_LAT DOUBLE,AREA_WEST_BOUND_LON DOUBLE,AREA_EAST_BOUND_LON DOUBLE,AREA_POLYGON_FILE_REF VARCHAR(254),ISO_A2_CODE VARCHAR(2),ISO_A3_CODE VARCHAR(3),ISO_N_CODE INTEGER,REMARKS VARCHAR(254),INFORMATION_SOURCE VARCHAR(254),DATA_SOURCE VARCHAR(40) NOT NULL,REVISION_DATE DATE NOT NULL,CHANGE_ID VARCHAR(255),DEPRECATED SMALLINT NOT NULL,CONSTRAINT PK_AREA PRIMARY KEY(AREA_CODE))

CREATE CACHED TABLE EPSG_CHANGE(CHANGE_ID DOUBLE NOT NULL,REPORT_DATE DATE NOT NULL,DATE_CLOSED DATE,REPORTER VARCHAR(254) NOT NULL,REQUEST VARCHAR(254) NOT NULL,TABLES_AFFECTED VARCHAR(254),CODES_AFFECTED VARCHAR(254),CHANGE_COMMENT VARCHAR(254),ACTION VARCHAR,CONSTRAINT UN_CHANGE_ID UNIQUE(CHANGE_ID))

CREATE CACHED TABLE EPSG_COORDINATEAXIS(COORD_AXIS_CODE INTEGER NOT NULL,COORD_SYS_CODE INTEGER NOT NULL,COORD_AXIS_NAME_CODE INTEGER NOT NULL,COORD_AXIS_ORIENTATION VARCHAR(24) NOT NULL,COORD_AXIS_ABBREVIATION VARCHAR(24) NOT NULL,UOM_CODE INTEGER NOT NULL,COORD_AXIS_ORDER SMALLINT NOT NULL,CONSTRAINT PK_COORDINATEAXIS PRIMARY KEY(COORD_SYS_CODE,COORD_AXIS_NAME_CODE),CONSTRAINT UN_COORD_AXIS_CODE UNIQUE(COORD_AXIS_CODE))

CREATE CACHED TABLE EPSG_COORDINATEAXISNAME(COORD_AXIS_NAME_CODE INTEGER NOT NULL,COORD_AXIS_NAME VARCHAR(80) NOT NULL,DESCRIPTION VARCHAR(254),REMARKS VARCHAR(254),INFORMATION_SOURCE VARCHAR(254),DATA_SOURCE VARCHAR(40) NOT NULL,REVISION_DATE DATE NOT NULL,CHANGE_ID VARCHAR(255),DEPRECATED SMALLINT NOT NULL,CONSTRAINT PK_COORDINATEAXISNAME PRIMARY KEY(COORD_AXIS_NAME_CODE))

CREATE CACHED TABLE EPSG_COORDINATEREFERENCESYSTEM(COORD_REF_SYS_CODE INTEGER NOT NULL,COORD_REF_SYS_NAME VARCHAR(80) NOT NULL,AREA_OF_USE_CODE INTEGER NOT NULL,COORD_REF_SYS_KIND VARCHAR(24) NOT NULL,COORD_SYS_CODE INTEGER,DATUM_CODE INTEGER,SOURCE_GEOGCRS_CODE INTEGER,PROJECTION_CONV_CODE INTEGER,CMPD_HORIZCRS_CODE INTEGER,CMPD_VERTCRS_CODE INTEGER,CRS_SCOPE VARCHAR(254) NOT NULL,REMARKS VARCHAR(254),INFORMATION_SOURCE VARCHAR(254),DATA_SOURCE VARCHAR(40) NOT NULL,REVISION_DATE DATE NOT NULL,CHANGE_ID VARCHAR(255),SHOW_CRS SMALLINT NOT NULL,DEPRECATED SMALLINT NOT NULL,CONSTRAINT PK_COORDINATEREFERENCESYSTEM PRIMARY KEY(COORD_REF_SYS_CODE))

CREATE CACHED TABLE EPSG_COORDINATESYSTEM(COORD_SYS_CODE INTEGER NOT NULL,COORD_SYS_NAME VARCHAR(254) NOT NULL,COORD_SYS_TYPE VARCHAR(24) NOT NULL,DIMENSION SMALLINT NOT NULL,REMARKS VARCHAR(254),INFORMATION_SOURCE VARCHAR(254),DATA_SOURCE VARCHAR(50) NOT NULL,REVISION_DATE DATE NOT NULL,CHANGE_ID VARCHAR(255),DEPRECATED SMALLINT NOT NULL,CONSTRAINT PK_COORDINATESYSTEM PRIMARY KEY(COORD_SYS_CODE))

CREATE CACHED TABLE EPSG_COORDOPERATION(COORD_OP_CODE INTEGER NOT NULL,COORD_OP_NAME VARCHAR(80) NOT NULL,COORD_OP_TYPE VARCHAR(24) NOT NULL,SOURCE_CRS_CODE INTEGER,TARGET_CRS_CODE INTEGER,COORD_TFM_VERSION VARCHAR(24),COORD_OP_VARIANT SMALLINT,AREA_OF_USE_CODE INTEGER NOT NULL,COORD_OP_SCOPE VARCHAR(254) NOT NULL,COORD_OP_ACCURACY FLOAT,COORD_OP_METHOD_CODE INTEGER,UOM_CODE_SOURCE_COORD_DIFF INTEGER,UOM_CODE_TARGET_COORD_DIFF INTEGER,REMARKS VARCHAR(254),INFORMATION_SOURCE VARCHAR(254),DATA_SOURCE VARCHAR(40) NOT NULL,REVISION_DATE DATE NOT NULL,CHANGE_ID VARCHAR(255),SHOW_OPERATION SMALLINT NOT NULL,DEPRECATED SMALLINT NOT NULL,CONSTRAINT PK_COORDOPERATION PRIMARY KEY(COORD_OP_CODE))

CREATE CACHED TABLE EPSG_COORDOPERATIONMETHOD(COORD_OP_METHOD_CODE INTEGER NOT NULL,COORD_OP_METHOD_NAME VARCHAR(50) NOT NULL,REVERSE_OP SMALLINT NOT NULL,FORMULA VARCHAR,EXAMPLE VARCHAR,REMARKS VARCHAR(254),INFORMATION_SOURCE VARCHAR(254),DATA_SOURCE VARCHAR(40) NOT NULL,REVISION_DATE DATE NOT NULL,CHANGE_ID VARCHAR(255),DEPRECATED SMALLINT NOT NULL,CONSTRAINT PK_COORDOPERATIONMETHOD PRIMARY KEY(COORD_OP_METHOD_CODE))

CREATE CACHED TABLE EPSG_COORDOPERATIONPARAM(PARAMETER_CODE INTEGER NOT NULL,PARAMETER_NAME VARCHAR(80) NOT NULL,DESCRIPTION VARCHAR,INFORMATION_SOURCE VARCHAR(254),DATA_SOURCE VARCHAR(40) NOT NULL,REVISION_DATE DATE NOT NULL,CHANGE_ID VARCHAR(255),DEPRECATED SMALLINT NOT NULL,CONSTRAINT PK_COORDOPERATIONPARAM PRIMARY KEY(PARAMETER_CODE))

CREATE CACHED TABLE EPSG_COORDOPERATIONPARAMUSAGE(COORD_OP_METHOD_CODE INTEGER NOT NULL,PARAMETER_CODE INTEGER NOT NULL,SORT_ORDER SMALLINT NOT NULL,PARAM_SIGN_REVERSAL VARCHAR(3),CONSTRAINT PK_COORDOPERATIONPARAMUSAGE PRIMARY KEY(PARAMETER_CODE,COORD_OP_METHOD_CODE))

CREATE CACHED TABLE EPSG_COORDOPERATIONPARAMVALUE(COORD_OP_CODE INTEGER NOT NULL,COORD_OP_METHOD_CODE INTEGER NOT NULL,PARAMETER_CODE INTEGER NOT NULL,PARAMETER_VALUE DOUBLE,PARAM_VALUE_FILE_REF VARCHAR(254),UOM_CODE INTEGER,CONSTRAINT PK_COORDOPERATIONPARAMVALUE PRIMARY KEY(COORD_OP_CODE,PARAMETER_CODE,COORD_OP_METHOD_CODE))

CREATE CACHED TABLE EPSG_COORDOPERATIONPATH(CONCAT_OPERATION_CODE INTEGER NOT NULL,SINGLE_OPERATION_CODE INTEGER NOT NULL,OP_PATH_STEP SMALLINT NOT NULL,CONSTRAINT PK_COORDOPERATIONPATH PRIMARY KEY(CONCAT_OPERATION_CODE,SINGLE_OPERATION_CODE))

CREATE CACHED TABLE EPSG_DATUM(DATUM_CODE INTEGER NOT NULL,DATUM_NAME VARCHAR(80) NOT NULL,DATUM_TYPE VARCHAR(24) NOT NULL,ORIGIN_DESCRIPTION VARCHAR(254),REALIZATION_EPOCH INTEGER,ELLIPSOID_CODE INTEGER,PRIME_MERIDIAN_CODE INTEGER,AREA_OF_USE_CODE INTEGER NOT NULL,DATUM_SCOPE VARCHAR(254) NOT NULL,REMARKS VARCHAR(254),INFORMATION_SOURCE VARCHAR(254),DATA_SOURCE VARCHAR(40) NOT NULL,REVISION_DATE DATE NOT NULL,CHANGE_ID VARCHAR(255),DEPRECATED SMALLINT NOT NULL,CONSTRAINT PK_DATUM PRIMARY KEY(DATUM_CODE))

CREATE CACHED TABLE EPSG_DEPRECATION(DEPRECATION_ID INTEGER NOT NULL,DEPRECATION_DATE DATE,CHANGE_ID DOUBLE NOT NULL,OBJECT_TABLE_NAME VARCHAR(80),OBJECT_CODE INTEGER,REPLACED_BY INTEGER,DEPRECATION_REASON VARCHAR(254),CONSTRAINT PK_DEPRECATION PRIMARY KEY(DEPRECATION_ID))

CREATE CACHED TABLE EPSG_ELLIPSOID(ELLIPSOID_CODE INTEGER NOT NULL,ELLIPSOID_NAME VARCHAR(80) NOT NULL,SEMI_MAJOR_AXIS DOUBLE NOT NULL,UOM_CODE INTEGER NOT NULL,INV_FLATTENING DOUBLE,SEMI_MINOR_AXIS DOUBLE,ELLIPSOID_SHAPE SMALLINT NOT NULL,REMARKS VARCHAR(254),INFORMATION_SOURCE VARCHAR(254),DATA_SOURCE VARCHAR(40) NOT NULL,REVISION_DATE DATE NOT NULL,CHANGE_ID VARCHAR(255),DEPRECATED SMALLINT NOT NULL,CONSTRAINT PK_ELLIPSOID PRIMARY KEY(ELLIPSOID_CODE))

CREATE CACHED TABLE EPSG_NAMINGSYSTEM(NAMING_SYSTEM_CODE INTEGER NOT NULL,NAMING_SYSTEM_NAME VARCHAR(80) NOT NULL,REMARKS VARCHAR(254),INFORMATION_SOURCE VARCHAR(254),DATA_SOURCE VARCHAR(40) NOT NULL,REVISION_DATE DATE NOT NULL,CHANGE_ID VARCHAR(255),DEPRECATED SMALLINT NOT NULL,CONSTRAINT PK_NAMINGSYSTEM PRIMARY KEY(NAMING_SYSTEM_CODE))

CREATE CACHED TABLE EPSG_PRIMEMERIDIAN(PRIME_MERIDIAN_CODE INTEGER NOT NULL,PRIME_MERIDIAN_NAME VARCHAR(80) NOT NULL,GREENWICH_LONGITUDE DOUBLE NOT NULL,UOM_CODE INTEGER NOT NULL,REMARKS VARCHAR(254),INFORMATION_SOURCE VARCHAR(254),DATA_SOURCE VARCHAR(40) NOT NULL,REVISION_DATE DATE NOT NULL,CHANGE_ID VARCHAR(255),DEPRECATED SMALLINT NOT NULL,CONSTRAINT PK_PRIMEMERIDIAN PRIMARY KEY(PRIME_MERIDIAN_CODE))

CREATE CACHED TABLE EPSG_SUPERSESSION(SUPERSESSION_ID INTEGER NOT NULL,OBJECT_TABLE_NAME VARCHAR(80) NOT NULL,OBJECT_CODE INTEGER NOT NULL,SUPERSEDED_BY INTEGER,SUPERSESSION_TYPE VARCHAR(50),SUPERSESSION_YEAR SMALLINT,REMARKS VARCHAR(254),CONSTRAINT PK_SUPERSESSION PRIMARY KEY(SUPERSESSION_ID))

CREATE CACHED TABLE EPSG_UNITOFMEASURE(UOM_CODE INTEGER NOT NULL,UNIT_OF_MEAS_NAME VARCHAR(80) NOT NULL,UNIT_OF_MEAS_TYPE VARCHAR(50),TARGET_UOM_CODE INTEGER NOT NULL,FACTOR_B DOUBLE,FACTOR_C DOUBLE,REMARKS VARCHAR(254),INFORMATION_SOURCE VARCHAR(254),DATA_SOURCE VARCHAR(40) NOT NULL,REVISION_DATE DATE NOT NULL,CHANGE_ID VARCHAR(255),DEPRECATED SMALLINT NOT NULL,CONSTRAINT PK_UNITOFMEASURE PRIMARY KEY(UOM_CODE))

CREATE CACHED TABLE EPSG_VERSIONHISTORY(VERSION_HISTORY_CODE INTEGER NOT NULL,VERSION_DATE DATE,VERSION_NUMBER VARCHAR(10) NOT NULL,VERSION_REMARKS VARCHAR(254) NOT NULL,SUPERCEDED_BY VARCHAR(10),SUPERCEDES VARCHAR(10),CONSTRAINT PK_VERSIONHISTORY PRIMARY KEY(VERSION_HISTORY_CODE),CONSTRAINT UN_VERSION_HISTORY_CODE UNIQUE(VERSION_HISTORY_CODE))

INSERT INTO EPSG_ALIAS VALUES

(4,'Datum',6258,7300,'ETRF89',''),

(5,'Ellipsoid',7013,7300,'Modified Clarke 1880 (South Africa)','The Clarke 1880 (Arc) figure is one of several modifications to the original definition.  The name Clarke Modified is usually taken to be the RGS modification.  But in southern Africa it is usually taken to be the Arc or Cape modification.'),

(6,'Coordinate_Operation',8570,7300,'ED50 to EUREF89 (2)',''),

(7,'Unit of Measure',9001,7300,'meter',''),

(8,'Unit of Measure',9036,7300,'kilometer','Spelling used in US'),

(9,'Coordinate Reference System',21100,7300,'Genuk / NEIEZ',''),

(10,'Coordinate_Operation',1036,7301,'OSTN97',''),

(11,'Coordinate_Operation',1123,7301,'Genuk to WGS 84 (1)',''),

(12,'Coordinate_Operation',1149,7301,'ETRF89 to WGS 84 (1)',''),

(13,'Coordinate_Operation',1273,7301,'HD72 to ETRF89 (1)',''),

(14,'Coordinate_Operation',1309,7301,'DHDN to ETRF89 (1)',''),

(15,'Coordinate_Operation',1310,7301,'Pulkovo 1942 to ETRF89 (1)',''),

(16,'Coordinate_Operation',1311,7301,'ED50 to WGS 84 (Common Offshore)',''),

(17,'Coordinate_Operation',1331,7301,'EST92 to ETRF89 (1)',''),

(19,'Coordinate_Operation',1513,7301,'Final Datum 1958 to WGS 84 (1)',''),

(20,'Coordinate_Operation',1571,7301,'Amersfoort to ETRF89 (1)',''),

(21,'Coordinate_Operation',1584,7301,'Levant to WGS 72BE (1)',''),

(22,'Coordinate_Operation',1585,7301,'Levant to WGS 84 (2)',''),

(23,'Coordinate_Operation',1586,7301,'Levant to WGS 84 (3)',''),

(24,'Coordinate_Operation',1587,7301,'Levant to WGS 84 (4)',''),

(26,'Coordinate_Operation',1589,7301,'ED50 to ETRF89 (3)',''),

(28,'Coordinate_Operation',1611,7301,'IRENET95 to ETRF89 (1)',''),

(29,'Coordinate Reference System',2140,7301,'NAD83(CSRS98) / SCoPQ zone 3',''),

(30,'Coordinate Reference System',2141,7301,'NAD83(CSRS98) / SCoPQ zone 4',''),

(31,'Coordinate Reference System',2142,7301,'NAD83(CSRS98) / SCoPQ zone 5',''),

(32,'Coordinate Reference System',2143,7301,'NAD83(CSRS98) / SCoPQ zone 6',''),

(33,'Coordinate Reference System',2144,7301,'NAD83(CSRS98) / SCoPQ zone 7',''),

(34,'Coordinate Reference System',2145,7301,'NAD83(CSRS98) / SCoPQ zone 8',''),

(35,'Coordinate Reference System',2146,7301,'NAD83(CSRS98) / SCoPQ zone 9',''),

(36,'Coordinate Reference System',2147,7301,'NAD83(CSRS98) / SCoPQ zone 10',''),

(37,'Coordinate Reference System',2159,7301,'Sierra Leone 1924 / Peninsular Grid',''),

(38,'Coordinate Reference System',2291,7301,'NAD83 / PEI Stereo',''),

(39,'Coordinate Reference System',3200,7301,'Final Datum 1958 / Iraq zone',''),

(40,'Coordinate Reference System',4132,7301,'Final Datum 1958 (Iran)',''),

(41,'Coordinate Reference System',4140,7301,'NAD83(CSRS)',''),

(42,'Coordinate Reference System',4172,7301,'National Geodetic System [Argentina]','see http://www.igm.gov.ar/posgar.html'),

(43,'Coordinate Reference System',4211,7301,'Genuk',''),

(44,'Datum',4218,7301,'Bogota',''),

(45,'Coordinate Reference System',4227,7301,'Levant',''),

(46,'Coordinate Reference System',4258,7301,'ETRF89',''),

(47,'Coordinate Reference System',4272,7301,'GD49',''),

(48,'Coordinate Reference System',4813,7301,'Genuk (Jakarta)',''),

(49,'Datum',5104,7301,'Huang Hai 1956',''),

(50,'Datum',6120,7301,'Old Greek','Adjective "Old" applied since introduction of GGRS87 (code 6121)'),

(51,'Datum',6125,7301,'Samboja P2 exc T9',''),

(52,'Datum',6160,7301,'Quini-Huao',''),

(53,'Datum',6174,7301,'Sierra Leone Peninsular 1924',''),

(54,'Datum',6211,7301,'Genuk',''),

(55,'Datum',6218,7301,'Bogota',''),

(56,'Datum',6222,7301,'South Africa',''),

(57,'Datum',6227,7301,'Levant',''),

(58,'Datum',6258,7301,'European Terrestrial Reference Frame 1989',''),

(59,'Datum',6269,7301,'NAD83 (1986)',''),

(60,'Datum',6272,7301,'GD49',''),

(61,'Datum',6308,7301,'Rikets koordinatsystem 1938',''),

(62,'Ellipsoid',7012,7301,'Clarke Modified 1880','The Clarke 1880 (RGS) figure is one of several modifications to the original definition.  The name Clarke Modified is usually taken to be the RGS modification.'),

(63,'Ellipsoid',7013,7301,'Clarke 1880 (Cape)',''),

(64,'Ellipsoid',7019,7301,'International 1979','Adopted by IUGG 1979 Canberra as the Geodetic Reference Spheroid of 1980 (GRS 1980).'),

(65,'Ellipsoid',7022,7301,'Hayford 1909','Described as a=6378388 m. and b=6356909 m. from which 1/f derived to be 296.95926...   The figure was adopted as the International ellipsoid in 1924 but with 1/f taken as 297 exactly from which b is derved as 6356911.946 m.'),

(66,'Ellipsoid',7029,7301,'McCaw 1924',''),

(67,'Ellipsoid',7030,7301,'WGS84',''),

(68,'Ellipsoid',7036,7301,'International 1967','More usually known as GRS 1967 to avoid confusion with the International 1924 figure.'),

(69,'Ellipsoid',7043,7301,'NWL 10D','Used by Transit Broadcast Ephemeris before 1989. Also referred to as WGS72 spheroid.'),

(70,'Coordinate_Operation',8568,7301,'Levant to WGS 84 (1)',''),

(71,'Coordinate_Operation',8570,7301,'ED50 to ETRF89 (2)',''),

(72,'Coordinate_Operation Parameter',8602,7301,'Longitude rotation',''),

(73,'Prime Meridian',8913,7301,'Kristiania',''),

(74,'Unit of Measure',9001,7301,'International metre',''),

(75,'Unit of Measure',9002,7301,'international foot',''),

(76,'Unit of Measure',9003,7301,'American foot',''),

(77,'Unit of Measure',9005,7301,'South African geodetic foot','Not to be confused with the Cape foot.'),

(78,'Unit of Measure',9030,7301,'International nautical mile',''),

(79,'Unit of Measure',9039,7301,'link (Clarke''s ratio)',''),

(80,'Unit of Measure',9040,7301,'yard',''),

(81,'Unit of Measure',9041,7301,'foot',''),

(82,'Unit of Measure',9042,7301,'chain',''),

(83,'Unit of Measure',9043,7301,'link',''),

(84,'Unit of Measure',9050,7301,'yard',''),

(85,'Unit of Measure',9051,7301,'foot',''),

(86,'Unit of Measure',9052,7301,'chain',''),

(87,'Unit of Measure',9053,7301,'link',''),

(88,'Unit of Measure',9060,7301,'yard',''),

(89,'Unit of Measure',9061,7301,'foot',''),

(90,'Unit of Measure',9062,7301,'chain',''),

(91,'Unit of Measure',9063,7301,'link',''),

(92,'Unit of Measure',9070,7301,'foot',''),

(93,'Unit of Measure',9080,7301,'Indian geodetic foot',''),

(94,'Unit of Measure',9081,7301,'Indian geodetic foot',''),

(95,'Unit of Measure',9084,7301,'yard','= 3 Indian feet.'),

(96,'Unit of Measure',9085,7301,'yard','= 3 Indian feet.'),

(97,'Unit of Measure',9094,7301,'foot',''),

(98,'Unit of Measure',9114,7301,'mil','Alias also applies to other variations of a mil, especially mil_6300 and mil_6000.'),

(100,'Coordinate_Operation',17001,7301,'Ghana TM',''),

(101,'Coordinate_Operation',17901,7301,'Mount Eden Circuit 1949',''),

(102,'Coordinate_Operation',17902,7301,'Bay of Plenty Circuit 1949',''),

(103,'Coordinate_Operation',17903,7301,'Poverty Bay Circuit 1949',''),

(104,'Coordinate_Operation',17904,7301,'Hawkes Bay Circuit 1949',''),

(105,'Coordinate_Operation',17905,7301,'Taranaki Circuit 1949',''),

(106,'Coordinate_Operation',17906,7301,'Tuhirangi Circuit 1949',''),

(107,'Coordinate_Operation',17907,7301,'Wanganui Circuit 1949',''),

(108,'Coordinate_Operation',17908,7301,'Wairarapa Circuit 1949',''),

(109,'Coordinate_Operation',17909,7301,'Wellington Circuit 1949',''),

(110,'Coordinate_Operation',17910,7301,'Collingwood Circuit 1949',''),

(111,'Coordinate_Operation',17911,7301,'Nelson Circuit 1949',''),

(112,'Coordinate_Operation',17912,7301,'Karamea Circuit 1949',''),

(113,'Coordinate_Operation',17913,7301,'Buller Circuit 1949',''),

(114,'Coordinate_Operation',17914,7301,'Grey Circuit 1949',''),

(115,'Coordinate_Operation',17915,7301,'Amuri Circuit 1949',''),

(116,'Coordinate_Operation',17916,7301,'Marlborough Circuit 1949',''),

(117,'Coordinate_Operation',17917,7301,'Hokitika Circuit 1949',''),

(118,'Coordinate_Operation',17918,7301,'Okarito Circuit 1949',''),

(119,'Coordinate_Operation',17919,7301,'Jacksons Bay Circuit 1949',''),

(120,'Coordinate_Operation',17920,7301,'Mount Pleasant Circuit 1949',''),

(121,'Coordinate_Operation',17921,7301,'Gawler Circuit 1949',''),

(122,'Coordinate_Operation',17922,7301,'Timaru Circuit 1949',''),

(123,'Coordinate_Operation',17923,7301,'Lindis Peak Circuit 1949',''),

(124,'Coordinate_Operation',17924,7301,'Mount Nicholas Circuit 1949',''),

(125,'Coordinate_Operation',17925,7301,'Mount York Circuit 1949',''),

(126,'Coordinate_Operation',17926,7301,'Observation Point Circuit 1949',''),

(127,'Coordinate_Operation',17927,7301,'North Taieri Circuit 1949',''),

(128,'Coordinate_Operation',17928,7301,'Bluff Circuit 1949',''),

(129,'Coordinate_Operation',19906,7301,'IOEPC Lambert','Sometimes seen defined with 2 standard parallels.'),

(130,'Coordinate_Operation',19959,7301,'Gold Coast Grid',''),

(131,'Coordinate_Operation',19963,7301,'Sierra Leone Peninsula Grid',''),

(132,'Coordinate Reference System',21100,7301,'Genuk (Jakarta) / NEIEZ',''),

(133,'Coordinate Reference System',21148,7301,'Genuk / UTM zone 48S',''),

(134,'Coordinate Reference System',21150,7301,'Genuk / UTM zone 50S',''),

(135,'Coordinate Reference System',22700,7301,'Levant / Levant Zone',''),

(136,'Coordinate Reference System',22770,7301,'Levant / Syria Lambert',''),

(137,'Coordinate Reference System',22780,7301,'Levant / Levant Stereographic',''),

(138,'Coordinate Reference System',25828,7301,'ETRF89 / UTM zone 28N',''),

(139,'Coordinate Reference System',25829,7301,'ETRF89 / UTM zone 29N',''),

(140,'Coordinate Reference System',25830,7301,'ETRF89 / UTM zone 30N',''),

(141,'Coordinate Reference System',25831,7301,'ETRF89 / UTM zone 31N',''),

(142,'Coordinate Reference System',25832,7301,'ETRF89 / UTM zone 32N',''),

(143,'Coordinate Reference System',25833,7301,'ETRF89 / UTM zone 33N',''),

(144,'Coordinate Reference System',25834,7301,'ETRF89 / UTM zone 34N',''),

(145,'Coordinate Reference System',25835,7301,'ETRF89 / UTM zone 35N',''),

(146,'Coordinate Reference System',25836,7301,'ETRF89 / UTM zone 36N',''),

(147,'Coordinate Reference System',25837,7301,'ETRF89 / UTM zone 37N',''),

(148,'Coordinate Reference System',25838,7301,'ETRF89 / UTM zone 38N',''),

(149,'Coordinate Reference System',25884,7301,'ETRF89 / TM Baltic93',''),

(150,'Coordinate Reference System',27258,7301,'GD49 / UTM zone 58',''),

(151,'Coordinate Reference System',27259,7301,'GD49 / UTM zone 59',''),

(152,'Coordinate Reference System',27260,7301,'GD49 / UTM zone 60',''),

(153,'Coordinate Reference System',27291,7301,'GD49 / North Island Grid',''),

(154,'Coordinate Reference System',27292,7301,'GD49 / South Island Grid',''),

(155,'Coordinate Reference System',30592,7301,'Nord Sahara 1959/Voirol Unifie S Algerie',''),

(156,'Coordinate Reference System',30791,7301,'Nord Sahara 1959 / Lambert Nord Voirol Unifie 1960','Voirol Unifie 1960 is NOT a geodetic datum nor GeogCRS.  It is two Lambert projected coordinate reference systems based on Nord Sahara 1959 Datum. See also code 30792.'),

(157,'Coordinate Reference System',30792,7301,'Nord Sahara 1959 / Lambert Sud Voirol Unifie 1960','Voirol Unifie 1960 is NOT a geodetic datum nor GeogCRS.  It is two Lambert projected coordinate reference systems based on Nord Sahara 1959 Datum. See also code 30791.'),

(158,'Coordinate Reference System',31170,7301,'Zanderij / Surinam Old TM','Old country name spelling.'),

(159,'Coordinate Reference System',31171,7301,'Zanderij / Surinam TM','Old spelling for country name.'),

(160,'Coordinate Reference System',31300,7301,'Belge Lambert 72',''),

(161,'Coordinate_Operation',1026,7302,'Madrid to ED50 (1)',''),

(162,'Coordinate_Operation',1027,7302,'Madrid to ED50 (2)',''),

(163,'Coordinate_Operation',1028,7302,'Madrid to ED50 (3)',''),

(164,'Coordinate_Operation',1029,7302,'RD New to ED50/UTM31 (1)',''),

(165,'Coordinate_Operation',1030,7302,'ED50/UTM31 to RD New (1)',''),

(166,'Coordinate_Operation',1031,7302,'RD New to ED50/UTM31 (2)',''),

(167,'Coordinate_Operation',1032,7302,'ED50/UTM31 to RD New (2)',''),

(170,'Coordinate Reference System',2000,7302,'Anguilla 1957 / BWI Grid',''),

(171,'Coordinate Reference System',2001,7302,'Antigua 1943 / BWI Grid',''),

(172,'Coordinate Reference System',2002,7302,'Dominica 1945 / BWI Grid',''),

(173,'Coordinate Reference System',2003,7302,'Grenada 1953 / BWI Grid',''),

(174,'Coordinate Reference System',2004,7302,'Montserrat 58 / BWI Grid',''),

(175,'Coordinate Reference System',2005,7302,'St. Kitts 1955 / BWI Grid',''),

(176,'Coordinate Reference System',2006,7302,'St. Lucia 1955 / BWI Grid',''),

(177,'Coordinate Reference System',2007,7302,'St. Vincent 45 / BWI Grid',''),

(178,'Coordinate Reference System',2008,7302,'CGQ77 / SCoPQ zone 2',''),

(179,'Coordinate Reference System',2009,7302,'CGQ77 / SCoPQ zone 3',''),

(180,'Coordinate Reference System',2010,7302,'CGQ77 / SCoPQ zone 4',''),

(181,'Coordinate Reference System',2011,7302,'CGQ77 / SCoPQ zone 5',''),

(182,'Coordinate Reference System',2012,7302,'CGQ77 / SCoPQ zone 6',''),

(183,'Coordinate Reference System',2013,7302,'CGQ77 / SCoPQ zone 7',''),

(184,'Coordinate Reference System',2014,7302,'CGQ77 / SCoPQ zone 8',''),

(185,'Coordinate Reference System',2015,7302,'CGQ77 / SCoPQ zone 9',''),

(186,'Coordinate Reference System',2016,7302,'CGQ77 / SCoPQ zone 10',''),

(187,'Coordinate Reference System',2036,7302,'NAD83(CSRS) / NB Stereo',''),

(188,'Coordinate Reference System',2037,7302,'NAD83(CSRS) / UTM 19N',''),

(189,'Coordinate Reference System',2038,7302,'NAD83(CSRS) / UTM 20N',''),

(190,'Coordinate Reference System',2039,7302,'Israeli TM Grid',''),

(191,'Coordinate Reference System',2040,7302,'Locodjo 65 / UTM 30N',''),

(192,'Coordinate Reference System',2041,7302,'Abidjan 87 / UTM 30N',''),

(193,'Coordinate Reference System',2042,7302,'Locodjo 65 / UTM 29N',''),

(194,'Coordinate Reference System',2043,7302,'Abidjan 87 / UTM 29N',''),

(195,'Coordinate Reference System',2044,7302,'Hanoi 72 / Gauss zone 18',''),

(196,'Coordinate Reference System',2045,7302,'Hanoi 72 / Gauss zone 19',''),

(197,'Coordinate Reference System',2046,7302,'New S African CS zone 15',''),

(198,'Coordinate Reference System',2047,7302,'New S African CS zone 17',''),

(199,'Coordinate Reference System',2048,7302,'New S African CS zone 19',''),

(200,'Coordinate Reference System',2049,7302,'New S African CS zone 21',''),

(201,'Coordinate Reference System',2050,7302,'New S African CS zone 23',''),

(202,'Coordinate Reference System',2051,7302,'New S African CS zone 25',''),

(203,'Coordinate Reference System',2052,7302,'New S African CS zone 27',''),

(204,'Coordinate Reference System',2053,7302,'New S African CS zone 29',''),

(205,'Coordinate Reference System',2054,7302,'New S African CS zone 31',''),

(206,'Coordinate Reference System',2055,7302,'New S African CS zone 33',''),

(207,'Coordinate Reference System',2056,7302,'LV95',''),

(208,'Coordinate Reference System',2066,7302,'Mount Dillon / Tobago',''),

(209,'Coordinate Reference System',2067,7302,'Naparima 1955 / UTM 20N',''),

(210,'Coordinate Reference System',2081,7302,'Chos Malal / Argentina 2',''),

(211,'Coordinate Reference System',2082,7302,'Pampa d Castillo / Arg 2',''),

(212,'Coordinate Reference System',2083,7302,'Hito XVIII / Argentina 2',''),

(213,'Coordinate Reference System',2084,7302,'Hito XVIII / UTM 19S',''),

(214,'Coordinate Reference System',2089,7302,'Yemen NGN96 / UTM 38N',''),

(215,'Coordinate Reference System',2090,7302,'Yemen NGN96 / UTM 39N',''),

(216,'Coordinate Reference System',2091,7302,'S Yemen / Gauss zone 8',''),

(217,'Coordinate Reference System',2092,7302,'S Yemen / Gauss zone 9',''),

(218,'Coordinate Reference System',2096,7302,'Korean 1985 / East Belt',''),

(219,'Coordinate Reference System',2097,7302,'Korean 1985 / Cen. Belt',''),

(220,'Coordinate Reference System',2098,7302,'Korean 1985 / West Belt',''),

(221,'Coordinate Reference System',2099,7302,'Qatar Plane CS',''),

(222,'Coordinate Reference System',2136,7301,'Accra / Gold Coast Grid',''),

(223,'Coordinate Reference System',2137,7301,'Accra / Ghana TM',''),

(224,'Coordinate Reference System',2157,7302,'IRENET95 / ITM',''),

(225,'Coordinate Reference System',2200,7302,'ATS77 / NB Stereographic',''),

(226,'Coordinate Reference System',2290,7302,'ATS77 / PEI Stereo',''),

(227,'Coordinate Reference System',2291,7302,'NAD83(CSRS) / PEI Stereo',''),

(228,'Coordinate Reference System',2294,7302,'ATS77 / MTM NS zone 4',''),

(229,'Coordinate Reference System',2295,7302,'ATS77 / MTM NS zone 5',''),

(230,'Coordinate Reference System',2393,7302,'KKJ / Finland zone 3',''),

(231,'Coordinate Reference System',2600,7302,'LKS94','This alias is also used for geographical and geocentric CRSs.'),

(232,'Coordinate Reference System',3561,7302,'Old Hawaiian / SP zone 1',''),

(233,'Coordinate Reference System',3562,7302,'Old Hawaiian / SP zone 2',''),

(234,'Coordinate Reference System',3563,7302,'Old Hawaiian / SP zone 3',''),

(235,'Coordinate Reference System',3564,7302,'Old Hawaiian / SP zone 4',''),

(236,'Coordinate Reference System',3565,7302,'Old Hawaiian / SP zone 5',''),

(237,'Coordinate Reference System',3991,7302,'Puerto Rico SPCS 27',''),

(238,'Coordinate Reference System',4134,7302,'PSD93',''),

(239,'Coordinate Reference System',4215,7302,'BD 50',''),

(240,'Coordinate Reference System',4268,7302,'NAD Michigan',''),

(241,'Coordinate Reference System',4313,7302,'BD 72',''),

(242,'Coordinate Reference System',4609,7302,'CGQ77',''),

(243,'Coordinate Reference System',4809,7302,'BD 50 (Brussels)',''),

(244,'Datum',5100,7302,'msl',''),

(245,'Datum',5101,7302,'ODN',''),

(246,'Datum',5102,7302,'NGVD29',''),

(247,'Datum',5103,7302,'NAVD88',''),

(248,'Datum',5104,7302,'Yellow Sea',''),

(249,'Datum',5105,7302,'Baltic',''),

(250,'Datum',5106,7302,'Caspian',''),

(251,'Datum',5107,7302,'NGF',''),

(252,'Datum',5109,7302,'NAP',''),

(253,'Datum',5111,7302,'AHD',''),

(254,'Datum',5112,7302,'AHD (Tasmania)',''),

(255,'Datum',5114,7301,'CVD28',''),

(256,'Datum',5115,7302,'Piraeus86',''),

(257,'Datum',5116,7302,'N60',''),

(258,'Datum',5117,7302,'RH70',''),

(259,'Datum',5118,7302,'NGF - Lallemand',''),

(260,'Datum',5119,7302,'NGF - IGN69',''),

(261,'Datum',5120,7302,'NGF - IGN78',''),

(262,'Datum',5122,7302,'JSLD',''),

(263,'Datum',5123,7302,'PHD93',''),

(264,'Datum',5127,7302,'LN02',''),

(265,'Datum',5128,7302,'LHN95',''),

(266,'Datum',5129,7302,'EVRF2000',''),

(267,'Coordinate Reference System',5701,7302,'ODN',''),

(268,'Coordinate Reference System',5702,7302,'NGVD29',''),

(269,'Coordinate Reference System',5703,7302,'NAVD88',''),

(270,'Coordinate Reference System',5709,7302,'NAP',''),

(271,'Coordinate Reference System',5711,7302,'AHD',''),

(272,'Coordinate Reference System',5712,7302,'AHD (Tasmania)',''),

(273,'Coordinate Reference System',5713,7302,'CGVD28',''),

(274,'Coordinate Reference System',5714,7302,'msl height',''),

(275,'Coordinate Reference System',5715,7302,'msl depth',''),

(276,'Coordinate Reference System',5723,7302,'Japan Levelling Datum',''),

(277,'Coordinate Reference System',5724,7302,'PHD93',''),

(278,'Coordinate Reference System',5728,7302,'LN02',''),

(279,'Coordinate Reference System',5729,7302,'LHN95',''),

(281,'Datum',6121,7302,'GGRS87',''),

(282,'Datum',6122,7302,'ATS77',''),

(283,'Datum',6123,7302,'KKJ',''),

(284,'Datum',6124,7302,'RT90',''),

(285,'Datum',6126,7302,'LKS94 (ETRS89)',''),

(286,'Datum',6130,7302,'Moznet',''),

(287,'Datum',6132,7302,'FD58',''),

(288,'Datum',6133,7302,'EST92',''),

(289,'Datum',6134,7302,'PSD93',''),

(290,'Datum',6140,7302,'NAD83(CSRS98)',''),

(291,'Datum',6151,7302,'CHTRF95',''),

(292,'Datum',6152,7302,'NAD83(HARN)',''),

(293,'Datum',6154,7302,'ED50(ED77)',''),

(294,'Datum',6156,7302,'S-JTSK',''),

(295,'Datum',6159,7302,'ELD79',''),

(296,'Datum',6163,7302,'YNGN96',''),

(297,'Datum',6170,7302,'SIRGAS 1995',''),

(298,'Datum',6171,7302,'RGF93',''),

(299,'Datum',6172,7302,'POSGAR',''),

(300,'Datum',6202,7302,'AGD66',''),

(301,'Datum',6203,7302,'AGD84',''),

(302,'Datum',6204,7302,'Ain el Abd',''),

(303,'Datum',6215,7302,'Belge 1950',''),

(304,'Datum',6230,7302,'ED50',''),

(305,'Datum',6231,7302,'ED87',''),

(306,'Datum',6237,7302,'HD72',''),

(307,'Datum',6238,7302,'ID74',''),

(308,'Datum',6242,7302,'JAD69',''),

(309,'Datum',6246,7302,'KOC',''),

(310,'Datum',6248,7302,'PSAD56',''),

(311,'Datum',6258,7302,'ETRS89',''),

(312,'Datum',6267,7302,'NAD27',''),

(313,'Datum',6269,7302,'NAD83',''),

(314,'Datum',6272,7302,'NZGD49',''),

(315,'Datum',6275,7302,'NTF',''),

(316,'Datum',6278,7302,'OSGB70',''),

(317,'Datum',6279,7302,'OS(SN)80',''),

(318,'Datum',6280,7302,'Padang',''),

(319,'Datum',6283,7302,'GDA94',''),

(320,'Datum',6291,7302,'SAD69',''),

(321,'Datum',6297,7302,'Tananarive',''),

(322,'Datum',6303,7302,'TC(1948)',''),

(323,'Datum',6305,7302,'Voirol Unifie',''),

(324,'Datum',6308,7302,'RT38',''),

(325,'Datum',6312,7302,'MGI',''),

(326,'Datum',6313,7302,'Belge 1972',''),

(327,'Datum',6314,7302,'DHDN',''),

(328,'Datum',6318,7302,'NGN',''),

(329,'Datum',6319,7302,'KUDAMS',''),

(330,'Datum',6322,7302,'WGS 72',''),

(331,'Datum',6324,7302,'WGS 72BE',''),

(332,'Datum',6326,7302,'WGS 84',''),

(333,'Datum',6608,7302,'NAD27(76)',''),

(334,'Datum',6609,7302,'CGQ77',''),

(335,'Datum',6901,7302,'ATF (Paris)',''),

(336,'Datum',6902,7302,'NDG (Paris)',''),

(337,'Ellipsoid',7003,7302,'ANS',''),

(338,'Coordinate Reference System',7401,7302,'NTF / France II + Lalle',''),

(339,'Coordinate Reference System',7402,7302,'NTF / France II + IGN69',''),

(340,'Coordinate Reference System',7403,7302,'NTF / France III + IGN69',''),

(341,'Coordinate Reference System',7405,7302,'GB National Grid + ODN',''),

(342,'Coordinate Reference System',7407,7302,'NAD27 / TX_N + NGVD29',''),

(343,'Coordinate_Operation Parameter',8663,7302,'k',''),

(344,'Unit of Measure',9001,7302,'m',''),

(345,'Unit of Measure',9002,7302,'ft',''),

(346,'Unit of Measure',9003,7302,'ftUS',''),

(347,'Unit of Measure',9005,7302,'ftCla',''),

(348,'Unit of Measure',9014,7302,'f',''),

(349,'Unit of Measure',9030,7302,'NM',''),

(350,'Unit of Measure',9031,7302,'GLM',''),

(351,'Unit of Measure',9033,7302,'chUS',''),

(352,'Unit of Measure',9034,7302,'lkUS',''),

(353,'Unit of Measure',9035,7302,'miUS',''),

(354,'Unit of Measure',9036,7302,'km',''),

(355,'Unit of Measure',9037,7302,'ydCla',''),

(356,'Unit of Measure',9038,7302,'chCla',''),

(357,'Unit of Measure',9039,7302,'lkCla',''),

(358,'Unit of Measure',9040,7302,'ydSe',''),

(359,'Unit of Measure',9041,7302,'ftSe',''),

(360,'Unit of Measure',9042,7302,'chSe',''),

(361,'Unit of Measure',9043,7302,'lkSe',''),

(362,'Unit of Measure',9050,7302,'ydBnA',''),

(363,'Unit of Measure',9051,7302,'ftBnA',''),

(364,'Unit of Measure',9052,7302,'chBnA',''),

(365,'Unit of Measure',9053,7302,'lkBnA',''),

(366,'Unit of Measure',9060,7302,'ydBnB',''),

(367,'Unit of Measure',9061,7302,'ftBnB',''),

(368,'Unit of Measure',9062,7302,'chBnB',''),

(369,'Unit of Measure',9063,7302,'lkBnB',''),

(370,'Unit of Measure',9070,7302,'ftBr(65)',''),

(371,'Unit of Measure',9080,7302,'ftInd',''),

(372,'Unit of Measure',9081,7302,'ftInd(37)',''),

(373,'Unit of Measure',9082,7302,'ftInd(62)',''),

(374,'Unit of Measure',9083,7302,'ftInd(75)',''),

(375,'Unit of Measure',9084,7302,'ydInd',''),

(376,'Unit of Measure',9085,7302,'ydInd(37)',''),

(377,'Unit of Measure',9086,7302,'ydInd(62)',''),

(378,'Unit of Measure',9087,7302,'ydInd(75)',''),

(379,'Unit of Measure',9093,7302,'mi',''),

(380,'Unit of Measure',9094,7302,'ftGC',''),

(381,'Unit of Measure',9101,7302,'rad',''),

(382,'Unit of Measure',9102,7302,'deg',''),

(383,'Unit of Measure',9103,7302,'min',''),

(384,'Unit of Measure',9104,7302,'sec',''),

(385,'Unit of Measure',9105,7302,'gr',''),

(386,'Unit of Measure',9106,7302,'g',''),

(387,'Unit of Measure',9107,7302,'DMS',''),

(388,'Unit of Measure',9108,7302,'DMSH',''),

(389,'Unit of Measure',9109,7302,'\ufffd\ufffd\ufffdrad',''),

(390,'Unit of Measure',9110,7302,'DDD.MMSSsss',''),

(391,'Unit of Measure',9111,7302,'DDD.MMm',''),

(392,'Unit of Measure',9112,7302,'c',''),

(393,'Unit of Measure',9113,7302,'cc',''),

(394,'Unit of Measure',9114,7302,'mil',''),

(395,'Unit of Measure',9202,7302,'ppm',''),

(396,'Unit of Measure',9204,7302,'Bin330ftUS',''),

(397,'Unit of Measure',9205,7302,'Bin165ftUS',''),

(398,'Unit of Measure',9206,7302,'Bin82.5ftUS',''),

(399,'Unit of Measure',9207,7302,'Bin37.5m',''),

(400,'Unit of Measure',9208,7302,'Bin25m',''),

(401,'Unit of Measure',9209,7302,'Bin12.5m',''),

(402,'Unit of Measure',9210,7302,'Bin6.25m',''),

(403,'Unit of Measure',9211,7302,'Bin3.125m',''),

(404,'Coordinate_Operation Method',9633,7302,'OSTN',''),

(405,'Coordinate_Operation Method',9824,7302,'UTM',''),

(406,'Coordinate_Operation',10101,7302,'Alabama East',''),

(407,'Coordinate_Operation',10102,7302,'Alabama West',''),

(408,'Coordinate_Operation',10131,7302,'Alabama East',''),

(409,'Coordinate_Operation',10132,7302,'Alabama West',''),

(410,'Coordinate_Operation',10201,7302,'Arizona East',''),

(411,'Coordinate_Operation',10202,7302,'Arizona Central',''),

(412,'Coordinate_Operation',10203,7302,'Arizona West',''),

(413,'Coordinate_Operation',10231,7302,'Arizona East',''),

(414,'Coordinate_Operation',10232,7302,'Arizona Central',''),

(415,'Coordinate_Operation',10233,7302,'Arizona West',''),

(416,'Coordinate_Operation',10301,7302,'Arkansas North',''),

(417,'Coordinate_Operation',10302,7302,'Arkansas South',''),

(418,'Coordinate_Operation Method',9809,7301,'Roussilhe',''),

(419,'Coordinate_Operation',10331,7302,'Arkansas North',''),

(420,'Coordinate_Operation',10332,7302,'Arkansas South',''),

(421,'Coordinate_Operation',10401,7302,'California zone I',''),

(422,'Coordinate_Operation',10402,7302,'California zone II',''),

(423,'Coordinate_Operation',10403,7302,'California zone III',''),

(424,'Coordinate_Operation',10404,7302,'California zone IV',''),

(425,'Coordinate_Operation',10405,7302,'California zone V',''),

(426,'Coordinate_Operation',10406,7302,'California zone VI',''),

(427,'Coordinate_Operation',10407,7302,'California zone VII',''),

(428,'Coordinate_Operation',10431,7302,'California zone 1',''),

(429,'Coordinate_Operation',10432,7302,'California zone 2',''),

(430,'Coordinate_Operation',10433,7302,'California zone 3',''),

(431,'Coordinate_Operation',10434,7302,'California zone 4',''),

(432,'Coordinate_Operation',10435,7302,'California zone 5',''),

(433,'Coordinate_Operation',10436,7302,'California zone 6',''),

(434,'Coordinate_Operation',10501,7302,'Colorado North',''),

(435,'Coordinate_Operation',10503,7302,'Colorado South',''),

(436,'Coordinate_Operation',10531,7302,'Colorado North',''),

(437,'Coordinate_Operation',10533,7302,'Colorado South',''),

(438,'Coordinate_Operation',10600,7302,'Connecticut',''),

(439,'Coordinate_Operation',10630,7302,'Connecticut',''),

(440,'Coordinate_Operation',10700,7302,'Delaware',''),

(441,'Coordinate_Operation',10730,7302,'Delaware',''),

(442,'Coordinate_Operation',10901,7302,'Florida East',''),

(443,'Coordinate_Operation',10902,7302,'Florida West',''),

(444,'Coordinate_Operation',10903,7302,'Florida North',''),

(445,'Coordinate_Operation',10931,7302,'Florida East',''),

(446,'Coordinate_Operation',10932,7302,'Florida West',''),

(447,'Coordinate_Operation',10933,7302,'Florida North',''),

(448,'Coordinate_Operation',11001,7302,'Georgia East',''),

(449,'Coordinate_Operation',11002,7302,'Georgia West',''),

(450,'Coordinate_Operation',11031,7302,'Georgia East',''),

(451,'Coordinate_Operation',11032,7302,'Georgia West',''),

(452,'Coordinate_Operation',11101,7302,'Idaho East',''),

(453,'Coordinate_Operation',11102,7302,'Idaho Central',''),

(454,'Coordinate_Operation',11103,7302,'Idaho West',''),

(455,'Coordinate_Operation',11131,7302,'Idaho East',''),

(456,'Coordinate_Operation',11132,7302,'Idaho Central',''),

(457,'Coordinate_Operation',11133,7302,'Idaho West',''),

(458,'Coordinate_Operation',11201,7302,'Illinois East',''),

(459,'Coordinate_Operation',11202,7302,'Illinois West',''),

(460,'Coordinate_Operation',11231,7302,'Illinois East',''),

(461,'Coordinate_Operation',11232,7302,'Illinois West',''),

(462,'Coordinate_Operation',11301,7302,'Indiana East',''),

(463,'Coordinate_Operation',11302,7302,'Indiana West',''),

(464,'Coordinate_Operation',11331,7302,'Indiana East',''),

(465,'Coordinate_Operation',11332,7302,'Indiana West',''),

(466,'Coordinate_Operation',11401,7302,'Iowa North',''),

(467,'Coordinate_Operation',11402,7302,'Iowa South',''),

(468,'Coordinate_Operation',11431,7302,'Iowa North',''),

(469,'Coordinate_Operation',11432,7302,'Iowa South',''),

(470,'Coordinate_Operation',11501,7302,'Kansas North',''),

(471,'Coordinate_Operation',11502,7302,'Kansas South',''),

(472,'Coordinate_Operation',11531,7302,'Kansas North',''),

(473,'Coordinate_Operation',11532,7302,'Kansas South',''),

(474,'Coordinate_Operation',11601,7302,'Kentucky North',''),

(475,'Coordinate_Operation',11602,7302,'Kentucky South',''),

(476,'Coordinate_Operation',11631,7302,'Kentucky North',''),

(477,'Coordinate_Operation',11632,7302,'Kentucky South',''),

(478,'Coordinate_Operation',11701,7302,'Louisiana North',''),

(479,'Coordinate_Operation',11702,7302,'Louisiana South',''),

(480,'Coordinate_Operation',11731,7302,'Louisiana North',''),

(481,'Coordinate_Operation',11732,7302,'Louisiana South',''),

(482,'Coordinate_Operation',11801,7302,'Maine East',''),

(483,'Coordinate_Operation',11802,7302,'Maine West',''),

(484,'Coordinate_Operation',11831,7302,'Maine East',''),

(485,'Coordinate_Operation',11832,7302,'Maine West',''),

(486,'Coordinate_Operation',11900,7302,'Maryland',''),

(487,'Coordinate_Operation',11930,7302,'Maryland',''),

(488,'Coordinate_Operation',12001,7302,'Massachusetts Mainland',''),

(489,'Coordinate_Operation',12002,7302,'Massachusetts Island',''),

(490,'Coordinate_Operation',12031,7302,'Massachusetts Mainland',''),

(491,'Coordinate_Operation',12032,7302,'Massachusetts Island',''),

(492,'Coordinate_Operation',12101,7302,'Michigan East',''),

(493,'Coordinate_Operation',12102,7302,'Michigan Old Central',''),

(494,'Coordinate_Operation',12111,7302,'Michigan North',''),

(495,'Coordinate_Operation',12112,7302,'Michigan Central',''),

(496,'Coordinate_Operation',12113,7302,'Michigan South',''),

(497,'Coordinate_Operation',12141,7302,'Michigan North',''),

(498,'Coordinate_Operation',12142,7302,'Michigan Central',''),

(499,'Coordinate_Operation',12143,7302,'Michigan South',''),

(500,'Coordinate_Operation',12201,7302,'Minnesota North',''),

(501,'Coordinate_Operation',12202,7302,'Minnesota Central',''),

(502,'Coordinate_Operation',12203,7302,'Minnesota South',''),

(503,'Coordinate_Operation',12231,7302,'Minnesota North',''),

(504,'Coordinate_Operation',12232,7302,'Minnesota Central',''),

(505,'Coordinate_Operation',12233,7302,'Minnesota South',''),

(506,'Coordinate_Operation',12301,7302,'Mississippi East',''),

(507,'Coordinate_Operation',12302,7302,'Mississippi West',''),

(508,'Coordinate_Operation',12331,7302,'Mississippi East',''),

(509,'Coordinate_Operation',12332,7302,'Mississippi West',''),

(510,'Coordinate_Operation',12401,7302,'Missouri  East',''),

(511,'Coordinate_Operation',12402,7302,'Missouri Central',''),

(512,'Coordinate_Operation',12403,7302,'Missouri West',''),

(513,'Coordinate_Operation',12431,7302,'Missouri East',''),

(514,'Coordinate_Operation',12432,7302,'Missouri Central',''),

(515,'Coordinate_Operation',12433,7302,'Missouri West',''),

(516,'Coordinate_Operation',12501,7302,'Montana North',''),

(517,'Coordinate_Operation',12502,7302,'Montana Central',''),

(518,'Coordinate_Operation',12503,7302,'Montana South',''),

(519,'Coordinate_Operation',12530,7302,'Montana',''),

(520,'Coordinate_Operation',12601,7302,'Nebraska North',''),

(521,'Coordinate_Operation',12602,7302,'Nebraska South',''),

(522,'Coordinate_Operation',12630,7302,'Nebraska',''),

(523,'Coordinate_Operation',12701,7302,'Nevada  East',''),

(524,'Coordinate_Operation',12702,7302,'Nevada Central',''),

(525,'Coordinate_Operation',12703,7302,'Nevada West',''),

(526,'Coordinate_Operation',12731,7302,'Nevada East',''),

(527,'Coordinate_Operation',12732,7302,'Nevada Central',''),

(528,'Coordinate_Operation',12733,7302,'Nevada West',''),

(529,'Coordinate_Operation',12800,7302,'New Hampshire',''),

(530,'Coordinate_Operation',12830,7302,'New Hampshire',''),

(531,'Coordinate_Operation',12900,7302,'New Jersey',''),

(532,'Coordinate_Operation',12930,7302,'New Jersey',''),

(533,'Coordinate_Operation',13001,7302,'New Mexico East',''),

(534,'Coordinate_Operation',13002,7302,'New Mexico Central',''),

(535,'Coordinate_Operation',13003,7302,'New Mexico West',''),

(536,'Coordinate_Operation',13031,7302,'New Mexico East',''),

(537,'Coordinate_Operation',13032,7302,'New Mexico Central',''),

(538,'Coordinate_Operation',13033,7302,'New Mexico West',''),

(539,'Coordinate_Operation',13101,7302,'New York East',''),

(540,'Coordinate_Operation',13102,7302,'New York Central',''),

(541,'Coordinate_Operation',13103,7302,'New York  West',''),

(542,'Coordinate_Operation',13104,7302,'New York Long Island',''),

(543,'Coordinate_Operation',13131,7302,'New York East',''),

(544,'Coordinate_Operation',13132,7302,'New York Central',''),

(545,'Coordinate_Operation',13133,7302,'New York  West',''),

(546,'Coordinate_Operation',13134,7302,'New York Long Island',''),

(547,'Coordinate_Operation',13200,7302,'North Carolina',''),

(548,'Coordinate_Operation',13230,7302,'North Carolina',''),

(549,'Coordinate_Operation',13301,7302,'North Dakota North',''),

(550,'Coordinate_Operation',13302,7302,'North Dakota South',''),

(551,'Coordinate_Operation',13331,7302,'North Dakota North',''),

(552,'Coordinate_Operation',13332,7302,'North Dakota South',''),

(553,'Coordinate_Operation',13401,7302,'Ohio North',''),

(554,'Coordinate_Operation',13402,7302,'Ohio South',''),

(555,'Coordinate_Operation',13431,7302,'Ohio North',''),

(556,'Coordinate_Operation',13432,7302,'Ohio South',''),

(557,'Coordinate_Operation',13501,7302,'Oklahoma North',''),

(558,'Coordinate_Operation',13502,7302,'Oklahoma South',''),

(559,'Coordinate_Operation',13531,7302,'Oklahoma North',''),

(560,'Coordinate_Operation',13532,7302,'Oklahoma South',''),

(561,'Coordinate_Operation',13601,7302,'Oregon North',''),

(562,'Coordinate_Operation',13602,7302,'Oregon South',''),

(563,'Coordinate_Operation',13631,7302,'Oregon North',''),

(564,'Coordinate_Operation',13632,7302,'Oregon South',''),

(565,'Coordinate_Operation',13701,7302,'Pennsylvania North',''),

(566,'Coordinate_Operation',13702,7302,'Pennsylvania South',''),

(567,'Coordinate_Operation',13731,7302,'Pennsylvania North',''),

(568,'Coordinate_Operation',13732,7302,'Pennsylvania South',''),

(569,'Coordinate_Operation',13800,7302,'Rhode Island',''),

(570,'Coordinate_Operation',13830,7302,'Rhode Island',''),

(571,'Coordinate_Operation',13901,7302,'South Carolina North',''),

(572,'Coordinate_Operation',13902,7302,'South Carolina South',''),

(573,'Coordinate_Operation',13930,7302,'South Carolina',''),

(574,'Coordinate_Operation',14001,7302,'South Dakota North',''),

(575,'Coordinate_Operation',14002,7302,'South Dakota South',''),

(576,'Coordinate_Operation',14031,7302,'South Dakota North',''),

(577,'Coordinate_Operation',14032,7302,'South Dakota South',''),

(578,'Coordinate_Operation',14100,7302,'Tennessee',''),

(579,'Coordinate_Operation',14130,7302,'Tennessee',''),

(580,'Coordinate_Operation',14201,7302,'Texas North',''),

(581,'Coordinate_Operation',14202,7302,'Texas North Central',''),

(582,'Coordinate_Operation',14203,7302,'Texas Central',''),

(583,'Coordinate_Operation',14204,7302,'Texas South Central',''),

(584,'Coordinate_Operation',14205,7302,'Texas South',''),

(585,'Coordinate_Operation',14231,7302,'Texas North',''),

(586,'Coordinate_Operation',14232,7302,'Texas North Central',''),

(587,'Coordinate_Operation',14233,7302,'Texas Central',''),

(588,'Coordinate_Operation',14234,7302,'Texas South Central',''),

(589,'Coordinate_Operation',14235,7302,'Texas South',''),

(590,'Coordinate_Operation',14301,7302,'Utah North',''),

(591,'Coordinate_Operation',14302,7302,'Utah Central',''),

(592,'Coordinate_Operation',14303,7302,'Utah South',''),

(593,'Coordinate_Operation',14331,7302,'Utah North',''),

(594,'Coordinate_Operation',14332,7302,'Utah Central',''),

(595,'Coordinate_Operation',14333,7302,'Utah South',''),

(596,'Coordinate_Operation',14400,7302,'Vermont',''),

(597,'Coordinate_Operation',14430,7302,'Vermont',''),

(598,'Coordinate_Operation',14501,7302,'Virginia North',''),

(599,'Coordinate_Operation',14502,7302,'Virginia South',''),

(600,'Coordinate_Operation',14531,7302,'Virginia North',''),

(601,'Coordinate_Operation',14532,7302,'Virginia South',''),

(602,'Coordinate_Operation',14601,7302,'Washington North',''),

(603,'Coordinate_Operation',14602,7302,'Washington South',''),

(604,'Coordinate_Operation',14631,7302,'Washington North',''),

(605,'Coordinate_Operation',14632,7302,'Washington South',''),

(606,'Coordinate_Operation',14701,7302,'West Virginia North',''),

(607,'Coordinate_Operation',14702,7302,'West Virginia South',''),

(608,'Coordinate_Operation',14731,7302,'West Virginia North',''),

(609,'Coordinate_Operation',14732,7302,'West Virginia South',''),

(610,'Coordinate_Operation',14801,7302,'Wisconsin North',''),

(611,'Coordinate_Operation',14802,7302,'Wisconsin Central',''),

(612,'Coordinate_Operation',14803,7302,'Wisconsin South',''),

(613,'Coordinate_Operation',14831,7302,'Wisconsin North',''),

(614,'Coordinate_Operation',14832,7302,'Wisconsin Central',''),

(615,'Coordinate_Operation',14833,7302,'Wisconsin South',''),

(616,'Coordinate_Operation',14901,7302,'Wyoming East',''),

(617,'Coordinate_Operation',14902,7302,'Wyoming East Central',''),

(618,'Coordinate_Operation',14903,7302,'Wyoming West Central',''),

(619,'Coordinate_Operation',14904,7302,'Wyoming West',''),

(620,'Coordinate_Operation',14931,7302,'Wyoming East',''),

(621,'Coordinate_Operation',14932,7302,'Wyoming East Central',''),

(622,'Coordinate_Operation',14933,7302,'Wyoming West Central',''),

(623,'Coordinate_Operation',14934,7302,'Wyoming West',''),

(624,'Coordinate_Operation',15001,7302,'Alaska zone 1',''),

(625,'Coordinate_Operation',15002,7302,'Alaska zone 2',''),

(626,'Coordinate_Operation',15003,7302,'Alaska zone 3',''),

(627,'Coordinate_Operation',15004,7302,'Alaska zone 4',''),

(628,'Coordinate_Operation',15005,7302,'Alaska zone 5',''),

(629,'Coordinate_Operation',15006,7302,'Alaska zone 6',''),

(630,'Coordinate_Operation',15007,7302,'Alaska zone 7',''),

(631,'Coordinate_Operation',15008,7302,'Alaska zone 8',''),

(632,'Coordinate_Operation',15009,7302,'Alaska zone 9',''),

(633,'Coordinate_Operation',15010,7302,'Alaska zone 10',''),

(634,'Coordinate_Operation',15031,7302,'Alaska zone 1',''),

(635,'Coordinate_Operation',15032,7302,'Alaska zone 2',''),

(636,'Coordinate_Operation',15033,7302,'Alaska zone 3',''),

(637,'Coordinate_Operation',15034,7302,'Alaska zone 4',''),

(638,'Coordinate_Operation',15035,7302,'Alaska zone 5',''),

(639,'Coordinate_Operation',15036,7302,'Alaska zone 6',''),

(640,'Coordinate_Operation',15037,7302,'Alaska zone 7',''),

(641,'Coordinate_Operation',15038,7302,'Alaska zone 8',''),

(642,'Coordinate_Operation',15039,7302,'Alaska zone 9',''),

(643,'Coordinate_Operation',15040,7302,'Alaska zone 10',''),

(644,'Coordinate_Operation',15101,7302,'Hawaii  zone 1',''),

(645,'Coordinate_Operation',15102,7302,'Hawaii  zone 2',''),

(646,'Coordinate_Operation',15103,7302,'Hawaii  zone 3',''),

(647,'Coordinate_Operation',15104,7302,'Hawaii  zone 4',''),

(648,'Coordinate_Operation',15105,7302,'Hawaii  zone 5',''),

(649,'Coordinate_Operation',15131,7302,'Hawaii zone 1',''),

(650,'Coordinate_Operation',15132,7302,'Hawaii zone 2',''),

(651,'Coordinate_Operation',15133,7302,'Hawaii zone 3',''),

(652,'Coordinate_Operation',15134,7302,'Hawaii zone 4',''),

(653,'Coordinate_Operation',15135,7302,'Hawaii zone 5',''),

(654,'Coordinate_Operation',15201,7302,'Puerto Rico',''),

(655,'Coordinate_Operation',15202,7302,'St. Croix',''),

(656,'Coordinate_Operation',15230,7302,'Puerto Rico & Virgin Is.',''),

(657,'Coordinate_Operation',15914,7302,'BLM 14N (ftUS)',''),

(658,'Coordinate_Operation',15915,7302,'BLM 15N (ftUS)',''),

(659,'Coordinate_Operation',15916,7302,'BLM 16N (ftUS)',''),

(660,'Coordinate_Operation',15917,7302,'BLM 17N (ftUS)',''),

(661,'Coordinate_Operation',16061,7302,'UPS North',''),

(662,'Coordinate_Operation',16062,7302,'UPS South',''),

(663,'Coordinate_Operation',16261,7302,'3-degree Gauss zone 1',''),

(664,'Coordinate_Operation',16262,7302,'3-degree Gauss zone 2',''),

(665,'Coordinate_Operation',16263,7302,'3-degree Gauss zone 3',''),

(666,'Coordinate_Operation',16264,7302,'3-degree Gauss zone 4',''),

(667,'Coordinate_Operation',16265,7302,'3-degree Gauss zone 5',''),

(668,'Coordinate_Operation',16266,7302,'3-degree Gauss zone 6',''),

(669,'Coordinate_Operation',16267,7302,'3-degree Gauss zone 7',''),

(670,'Coordinate_Operation',16268,7302,'3-degree Gauss zone 8',''),

(671,'Coordinate_Operation',16361,7302,'3-deg Gauss-Kruger 3E',''),

(672,'Coordinate_Operation',16362,7302,'3-deg Gauss-Kruger 6E',''),

(673,'Coordinate_Operation',16363,7302,'3-deg Gauss-Kruger 9E',''),

(674,'Coordinate_Operation',16364,7302,'3-deg Gauss-Kruger 12E',''),

(675,'Coordinate_Operation',16365,7302,'3-deg Gauss-Kruger 15E',''),

(676,'Coordinate_Operation',16366,7302,'3-deg Gauss-Kruger 18E',''),

(677,'Coordinate_Operation',16367,7302,'3-deg Gauss-Kruger 21E',''),

(678,'Coordinate_Operation',16368,7302,'3-deg Gauss-Kruger 24E',''),

(679,'Coordinate_Operation',17348,7302,'MGA zone 48',''),

(680,'Coordinate_Operation',17349,7302,'MGA zone 49',''),

(681,'Coordinate_Operation',17350,7302,'MGA zone 50',''),

(682,'Coordinate_Operation',17351,7302,'MGA zone 51',''),

(683,'Coordinate_Operation',17352,7302,'MGA zone 52',''),

(684,'Coordinate_Operation',17353,7302,'MGA zone 53',''),

(685,'Coordinate_Operation',17354,7302,'MGA zone 54',''),

(686,'Coordinate_Operation',17355,7302,'MGA zone 55',''),

(687,'Coordinate_Operation',17356,7302,'MGA zone 56',''),

(688,'Coordinate_Operation',17357,7302,'MGA zone 57',''),

(689,'Coordinate_Operation',17358,7302,'MGA zone 58',''),

(690,'Coordinate_Operation',17448,7302,'AMG zone 48',''),

(691,'Coordinate_Operation',17449,7302,'AMG zone 49',''),

(692,'Coordinate_Operation',17450,7302,'AMG zone 50',''),

(693,'Coordinate_Operation',17451,7302,'AMG zone 51',''),

(694,'Coordinate_Operation',17452,7302,'AMG zone 52',''),

(695,'Coordinate_Operation',17453,7302,'AMG zone 53',''),

(696,'Coordinate_Operation',17454,7302,'AMG zone 54',''),

(697,'Coordinate_Operation',17455,7302,'AMG zone 55',''),

(698,'Coordinate_Operation',17456,7302,'AMG zone 56',''),

(699,'Coordinate_Operation',17457,7302,'AMG zone 57',''),

(700,'Coordinate_Operation',17458,7302,'AMG zone 58',''),

(701,'Coordinate_Operation',17515,7302,'S. African Grid zone 15',''),

(702,'Coordinate_Operation',17517,7302,'S. African Grid zone 17',''),

(703,'Coordinate_Operation',17519,7302,'S. African Grid zone 19',''),

(704,'Coordinate_Operation',17521,7302,'S. African Grid zone 21',''),

(705,'Coordinate_Operation',17523,7302,'S. African Grid zone 23',''),

(706,'Coordinate_Operation',17525,7302,'S. African Grid zone 25',''),

(707,'Coordinate_Operation',17527,7302,'S. African Grid zone 27',''),

(708,'Coordinate_Operation',17529,7302,'S. African Grid zone 29',''),

(709,'Coordinate_Operation',17531,7302,'S. African Grid zone 31',''),

(710,'Coordinate_Operation',17533,7302,'S. African Grid zone 33',''),

(711,'Coordinate_Operation',17611,7302,'SW African Grid zone 11',''),

(712,'Coordinate_Operation',17613,7302,'SW African Grid zone 13',''),

(713,'Coordinate_Operation',17615,7302,'SW African Grid zone 15',''),

(714,'Coordinate_Operation',17617,7302,'SW African Grid zone 17',''),

(715,'Coordinate_Operation',17619,7302,'SW African Grid zone 19',''),

(716,'Coordinate_Operation',17621,7302,'SW African Grid zone 21',''),

(717,'Coordinate_Operation',17623,7302,'SW African Grid zone 23',''),

(718,'Coordinate_Operation',17625,7302,'SW African Grid zone 25',''),

(719,'Coordinate_Operation',17702,7302,'MTM zone 2',''),

(720,'Coordinate_Operation',17801,7302,'Japan zone I',''),

(721,'Coordinate_Operation',17802,7302,'Japan zone II',''),

(722,'Coordinate_Operation',17803,7302,'Japan zone III',''),

(723,'Coordinate_Operation',17804,7302,'Japan zone IV',''),

(724,'Coordinate_Operation',17805,7302,'Japan zone V',''),

(725,'Coordinate_Operation',17806,7302,'Japan zone VI',''),

(726,'Coordinate_Operation',17807,7302,'Japan zone VII',''),

(727,'Coordinate_Operation',17808,7302,'Japan zone VIII',''),

(728,'Coordinate_Operation',17809,7302,'Japan zone IX',''),

(729,'Coordinate_Operation',17810,7302,'Japan zone X',''),

(730,'Coordinate_Operation',17811,7302,'Japan zone XI',''),

(731,'Coordinate_Operation',17812,7302,'Japan zone XII',''),

(732,'Coordinate_Operation',17813,7302,'Japan zone XIII',''),

(733,'Coordinate_Operation',17814,7302,'Japan zone XIV',''),

(734,'Coordinate_Operation',17815,7302,'Japan zone XV',''),

(735,'Coordinate_Operation',17816,7302,'Japan zone XVI',''),

(736,'Coordinate_Operation',17817,7302,'Japan zone XVII',''),

(737,'Coordinate_Operation',17818,7302,'Japan zone XVIII',''),

(738,'Coordinate_Operation',17901,7302,'Mt Eden Circuit',''),

(739,'Coordinate_Operation',17920,7302,'Mt Pleasant Circuit',''),

(740,'Coordinate_Operation',17924,7302,'Mt Nicholas Circuit',''),

(741,'Coordinate_Operation',17925,7302,'Mt York Circuit',''),

(742,'Coordinate_Operation',17926,7302,'Observation Pt Circuit',''),

(743,'Coordinate_Operation',18031,7302,'Argentina 1',''),

(744,'Coordinate_Operation',18032,7302,'Argentina 2',''),

(745,'Coordinate_Operation',18033,7302,'Argentina 3',''),

(746,'Coordinate_Operation',18034,7302,'Argentina 4',''),

(747,'Coordinate_Operation',18035,7302,'Argentina 5',''),

(748,'Coordinate_Operation',18036,7302,'Argentina 6',''),

(749,'Coordinate_Operation',18037,7302,'Argentina 7',''),

(750,'Coordinate_Operation',18044,7302,'M28',''),

(751,'Coordinate_Operation',18045,7302,'M31',''),

(752,'Coordinate_Operation',18046,7302,'M34',''),

(753,'Coordinate_Operation',18051,7302,'Colombia 3W',''),

(754,'Coordinate_Operation',18052,7302,'Colombia Bogota',''),

(755,'Coordinate_Operation',18053,7302,'Colombia 3E',''),

(756,'Coordinate_Operation',18054,7302,'Colombia 6E',''),

(757,'Coordinate_Operation',18071,7302,'Blue Belt',''),

(758,'Coordinate_Operation',18072,7302,'Red Belt',''),

(759,'Coordinate_Operation',18073,7302,'Purple Belt',''),

(760,'Coordinate_Operation',18074,7302,'Extended Purple Belt',''),

(761,'Coordinate_Operation',18141,7302,'North Island Grid',''),

(762,'Coordinate_Operation',18142,7302,'South Island Grid',''),

(763,'Coordinate_Operation',18193,7302,'Finland zone 3',''),

(764,'Coordinate_Operation',18203,7302,'ICS',''),

(765,'Coordinate_Operation',18204,7302,'ITM',''),

(766,'Coordinate_Operation',18231,7302,'India zone I',''),

(767,'Coordinate_Operation',18232,7302,'India zone IIa',''),

(768,'Coordinate_Operation',18233,7302,'India zone IIIa',''),

(769,'Coordinate_Operation',18234,7302,'India zone IVa',''),

(770,'Coordinate_Operation',18235,7302,'India zone IIb',''),

(771,'Coordinate_Operation',18236,7302,'India zone I',''),

(772,'Coordinate_Operation',18237,7302,'India zone IIa',''),

(773,'Coordinate_Operation',18238,7302,'India zone IIb',''),

(774,'Coordinate_Operation',19900,7302,'Bahrain Grid',''),

(775,'Coordinate_Operation',19905,7302,'NEIEZ',''),

(776,'Coordinate_Operation',19917,7302,'NZMG',''),

(777,'Coordinate_Operation',19922,7302,'LV03',''),

(778,'Coordinate_Operation',19923,7302,'LV03C',''),

(779,'Coordinate_Operation',19928,7302,'KTM',''),

(781,'Coordinate_Operation',19931,7302,'EOV',''),

(782,'Coordinate_Operation',19933,7302,'PEI Stereographic ATS77',''),

(783,'Coordinate_Operation',19935,7302,'R.S.O. Malaya',''),

(784,'Coordinate_Operation',19945,7302,'NB Stereographic ATS77',''),

(785,'Coordinate_Operation',19946,7302,'NB Stereographic NAD83',''),

(786,'Coordinate_Operation',19950,7302,'LV95',''),

(787,'Coordinate_Operation',19951,7302,'Nakhl e Taqi',''),

(788,'Coordinate_Operation',19956,7302,'RSO Borneo (chSe)',''),

(789,'Coordinate_Operation',19957,7302,'RSO Borneo (ftSe)',''),

(790,'Coordinate_Operation',19958,7302,'RSO Borneo (m)',''),

(791,'Coordinate_Operation',19960,7302,'PEI Stereographic NAD83',''),

(792,'Coordinate_Operation',19962,7302,'ITM',''),

(793,'Coordinate Reference System',20004,7302,'1995 Coord. Sys. zone 4',''),

(794,'Coordinate Reference System',20005,7302,'1995 Coord. Sys. zone 5',''),

(795,'Coordinate Reference System',20006,7302,'1995 Coord. Sys. zone 6',''),

(796,'Coordinate Reference System',20007,7302,'1995 Coord. Sys. zone 7',''),

(797,'Coordinate Reference System',20008,7302,'1995 Coord. Sys. zone 8',''),

(798,'Coordinate Reference System',20009,7302,'1995 Coord. Sys. zone 9',''),

(799,'Coordinate Reference System',20010,7302,'1995 Coord. Sys. zone 10',''),

(800,'Coordinate Reference System',20011,7302,'1995 Coord. Sys. zone 11',''),

(801,'Coordinate Reference System',20012,7302,'1995 Coord. Sys. zone 12',''),

(802,'Coordinate Reference System',20013,7302,'1995 Coord. Sys. zone 13',''),

(803,'Coordinate Reference System',20014,7302,'1995 Coord. Sys. zone 14',''),

(804,'Coordinate Reference System',20015,7302,'1995 Coord. Sys. zone 15',''),

(805,'Coordinate Reference System',20016,7302,'1995 Coord. Sys. zone 16',''),

(806,'Coordinate Reference System',20017,7302,'1995 Coord. Sys. zone 17',''),

(807,'Coordinate Reference System',20018,7302,'1995 Coord. Sys. zone 18',''),

(808,'Coordinate Reference System',20019,7302,'1995 Coord. Sys. zone 19',''),

(809,'Coordinate Reference System',20020,7302,'1995 Coord. Sys. zone 20',''),

(810,'Coordinate Reference System',20021,7302,'1995 Coord. Sys. zone 21',''),

(811,'Coordinate Reference System',20022,7302,'1995 Coord. Sys. zone 22',''),

(812,'Coordinate Reference System',20023,7302,'1995 Coord. Sys. zone 23',''),

(813,'Coordinate Reference System',20024,7302,'1995 Coord. Sys. zone 24',''),

(814,'Coordinate Reference System',20025,7302,'1995 Coord. Sys. zone 25',''),

(815,'Coordinate Reference System',20026,7302,'1995 Coord. Sys. zone 26',''),

(816,'Coordinate Reference System',20027,7302,'1995 Coord. Sys. zone 27',''),

(817,'Coordinate Reference System',20028,7302,'1995 Coord. Sys. zone 28',''),

(818,'Coordinate Reference System',20029,7302,'1995 Coord. Sys. zone 29',''),

(819,'Coordinate Reference System',20030,7302,'1995 Coord. Sys. zone 30',''),

(820,'Coordinate Reference System',20031,7302,'1995 Coord. Sys. zone 31',''),

(821,'Coordinate Reference System',20032,7302,'1995 Coord. Sys. zone 32',''),

(822,'Coordinate Reference System',20064,7302,'Pulkovo 1995 / Gauss 4N',''),

(823,'Coordinate Reference System',20065,7302,'Pulkovo 1995 / Gauss 5N',''),

(824,'Coordinate Reference System',20066,7302,'Pulkovo 1995 / Gauss 6N',''),

(825,'Coordinate Reference System',20067,7302,'Pulkovo 1995 / Gauss 7N',''),

(826,'Coordinate Reference System',20068,7302,'Pulkovo 1995 / Gauss 8N',''),

(827,'Coordinate Reference System',20069,7302,'Pulkovo 1995 / Gauss 9N',''),

(828,'Coordinate Reference System',20070,7302,'Pulkovo 1995 / Gauss 10N',''),

(829,'Coordinate Reference System',20071,7302,'Pulkovo 1995 / Gauss 11N',''),

(830,'Coordinate Reference System',20072,7302,'Pulkovo 1995 / Gauss 12N',''),

(831,'Coordinate Reference System',20073,7302,'Pulkovo 1995 / Gauss 13N',''),

(832,'Coordinate Reference System',20074,7302,'Pulkovo 1995 / Gauss 14N',''),

(833,'Coordinate Reference System',20075,7302,'Pulkovo 1995 / Gauss 15N',''),

(834,'Coordinate Reference System',20076,7302,'Pulkovo 1995 / Gauss 16N',''),

(835,'Coordinate Reference System',20077,7302,'Pulkovo 1995 / Gauss 17N',''),

(836,'Coordinate Reference System',20078,7302,'Pulkovo 1995 / Gauss 18N',''),

(837,'Coordinate Reference System',20079,7302,'Pulkovo 1995 / Gauss 19N',''),

(838,'Coordinate Reference System',20080,7302,'Pulkovo 1995 / Gauss 20N',''),

(839,'Coordinate Reference System',20081,7302,'Pulkovo 1995 / Gauss 21N',''),

(840,'Coordinate Reference System',20082,7302,'Pulkovo 1995 / Gauss 22N',''),

(841,'Coordinate Reference System',20083,7302,'Pulkovo 1995 / Gauss 23N',''),

(842,'Coordinate Reference System',20084,7302,'Pulkovo 1995 / Gauss 24N',''),

(843,'Coordinate Reference System',20085,7302,'Pulkovo 1995 / Gauss 25N',''),

(844,'Coordinate Reference System',20086,7302,'Pulkovo 1995 / Gauss 26N',''),

(845,'Coordinate Reference System',20087,7302,'Pulkovo 1995 / Gauss 27N',''),

(846,'Coordinate Reference System',20088,7302,'Pulkovo 1995 / Gauss 28N',''),

(847,'Coordinate Reference System',20089,7302,'Pulkovo 1995 / Gauss 29N',''),

(848,'Coordinate Reference System',20090,7302,'Pulkovo 1995 / Gauss 30N',''),

(849,'Coordinate Reference System',20091,7302,'Pulkovo 1995 / Gauss 31N',''),

(850,'Coordinate Reference System',20092,7302,'Pulkovo 1995 / Gauss 32N',''),

(851,'Coordinate Reference System',20437,7302,'Ain el Abd / UTM 37N',''),

(852,'Coordinate Reference System',20438,7302,'Ain el Abd / UTM 38N',''),

(853,'Coordinate Reference System',20439,7302,'Ain el Abd / UTM 39N',''),

(854,'Coordinate Reference System',20790,7302,'Lisbon / Portuguese National Grid',''),

(855,'Coordinate Reference System',21100,7302,'Batavia / NEIEZ',''),

(856,'Coordinate Reference System',21291,7302,'Barbados 1938 / BWI Grid',''),

(857,'Coordinate Reference System',21292,7302,'Barbados NationaI Grid',''),

(858,'Coordinate Reference System',21413,7302,'Beijing / Gauss zone 13',''),

(859,'Coordinate Reference System',21414,7302,'Beijing / Gauss zone 14',''),

(860,'Coordinate Reference System',21415,7302,'Beijing / Gauss zone 15',''),

(861,'Coordinate Reference System',21416,7302,'Beijing / Gauss zone 16',''),

(862,'Coordinate Reference System',21417,7302,'Beijing / Gauss zone 17',''),

(863,'Coordinate Reference System',21418,7302,'Beijing / Gauss zone 18',''),

(864,'Coordinate Reference System',21419,7302,'Beijing / Gauss zone 19',''),

(865,'Coordinate Reference System',21420,7302,'Beijing / Gauss zone 20',''),

(866,'Coordinate Reference System',21421,7302,'Beijing / Gauss zone 21',''),

(867,'Coordinate Reference System',21422,7302,'Beijing / Gauss zone 22',''),

(868,'Coordinate Reference System',21423,7302,'Beijing / Gauss zone 23',''),

(869,'Coordinate Reference System',21473,7302,'Beijing / Gauss 13N',''),

(870,'Coordinate Reference System',21474,7302,'Beijing / Gauss 14N',''),

(871,'Coordinate Reference System',21475,7302,'Beijing / Gauss 15N',''),

(872,'Coordinate Reference System',21476,7302,'Beijing / Gauss 16N',''),

(873,'Coordinate Reference System',21477,7302,'Beijing / Gauss 17N',''),

(874,'Coordinate Reference System',21478,7302,'Beijing / Gauss 18N',''),

(875,'Coordinate Reference System',21479,7302,'Beijing / Gauss 19N',''),

(876,'Coordinate Reference System',21480,7302,'Beijing / Gauss 20N',''),

(877,'Coordinate Reference System',21481,7302,'Beijing / Gauss 21N',''),

(878,'Coordinate Reference System',21482,7302,'Beijing / Gauss 22N',''),

(879,'Coordinate Reference System',21483,7302,'Beijing / Gauss 23N',''),

(880,'Coordinate Reference System',21500,7302,'Belge Lambert 50',''),

(881,'Coordinate Reference System',21780,7302,'LV03C',''),

(882,'Coordinate Reference System',21781,7302,'LV03',''),

(883,'Coordinate Reference System',21891,7302,'Bogota / Colombia 3W',''),

(884,'Coordinate Reference System',21892,7302,'Bogota / Colombia Bogota',''),

(885,'Coordinate Reference System',21893,7302,'Bogota / Colombia 3E',''),

(886,'Coordinate Reference System',21894,7302,'Bogota / Colombia 6E',''),

(887,'Coordinate Reference System',22191,7302,'C Inchauspe /Argentina 1',''),

(888,'Coordinate Reference System',22192,7302,'C Inchauspe /Argentina 2',''),

(889,'Coordinate Reference System',22193,7302,'C Inchauspe /Argentina 3',''),

(890,'Coordinate Reference System',22194,7302,'C Inchauspe /Argentina 4',''),

(891,'Coordinate Reference System',22195,7302,'C Inchauspe /Argentina 5',''),

(892,'Coordinate Reference System',22196,7302,'C Inchauspe /Argentina 6',''),

(893,'Coordinate Reference System',22197,7302,'C Inchauspe /Argentina 7',''),

(894,'Coordinate Reference System',22275,7302,'South African CS zone 15',''),

(895,'Coordinate Reference System',22277,7302,'South African CS zone 17',''),

(896,'Coordinate Reference System',22279,7302,'South African CS zone 19',''),

(897,'Coordinate Reference System',22281,7302,'South African CS zone 21',''),

(898,'Coordinate Reference System',22283,7302,'South African CS zone 23',''),

(899,'Coordinate Reference System',22285,7302,'South African CS zone 25',''),

(900,'Coordinate Reference System',22287,7302,'South African CS zone 27',''),

(901,'Coordinate Reference System',22289,7302,'South African CS zone 29',''),

(902,'Coordinate Reference System',22291,7302,'South African CS zone 31',''),

(903,'Coordinate Reference System',22293,7302,'South African CS zone 33',''),

(904,'Coordinate Reference System',22300,7302,'Tunisia Mining Grid',''),

(905,'Coordinate Reference System',22523,7302,'Corrego Alegre / UTM 23S',''),

(906,'Coordinate Reference System',22524,7302,'Corrego Alegre / UTM 24S',''),

(907,'Coordinate Reference System',22994,7302,'Egypt 1907 / Ext. Purple',''),

(908,'Coordinate Reference System',23946,7302,'Indian 1954 / UTM 46N',''),

(909,'Coordinate Reference System',23947,7302,'Indian 1954 / UTM 47N',''),

(910,'Coordinate Reference System',23948,7302,'Indian 1954 / UTM 48N',''),

(911,'Coordinate Reference System',24047,7302,'Indian 1975 / UTM 47N',''),

(912,'Coordinate Reference System',24048,7302,'Indian 1975 / UTM 48N',''),

(913,'Coordinate Reference System',24100,7302,'Jamaica 1875 / Old Grid',''),

(914,'Coordinate Reference System',24200,7302,'JAD69 / Jamaica Grid',''),

(915,'Coordinate Reference System',24305,7302,'Kalianpur 37 / UTM 45N',''),

(916,'Coordinate Reference System',24306,7302,'Kalianpur 37 / UTM 46N',''),

(917,'Coordinate Reference System',24311,7302,'Kalianpur 62 / UTM 41N',''),

(918,'Coordinate Reference System',24312,7302,'Kalianpur 62 / UTM 42N',''),

(919,'Coordinate Reference System',24313,7302,'Kalianpur 62 / UTM 43N',''),

(920,'Coordinate Reference System',24342,7302,'Kalianpur 75 / UTM 42N',''),

(921,'Coordinate Reference System',24343,7302,'Kalianpur 75 / UTM 43N',''),

(922,'Coordinate Reference System',24344,7302,'Kalianpur 75 / UTM 44N',''),

(923,'Coordinate Reference System',24345,7302,'Kalianpur 75 / UTM 45N',''),

(924,'Coordinate Reference System',24346,7302,'Kalianpur 75 / UTM 46N',''),

(925,'Coordinate Reference System',24347,7302,'Kalianpur 75 / UTM 47N',''),

(926,'Coordinate Reference System',24370,7302,'Kalianpur / India 0',''),

(927,'Coordinate Reference System',24371,7302,'Kalianpur / India I',''),

(928,'Coordinate Reference System',24372,7302,'Kalianpur / India IIa',''),

(929,'Coordinate Reference System',24373,7302,'Kalianpur / India III',''),

(930,'Coordinate Reference System',24374,7302,'Kalianpur / India IV',''),

(931,'Coordinate Reference System',24375,7302,'Kalianpur 37 / India IIb',''),

(932,'Coordinate Reference System',24376,7302,'Kalianpur 62 / India I',''),

(933,'Coordinate Reference System',24377,7302,'Kalianpur 62 / India IIa',''),

(934,'Coordinate Reference System',24378,7302,'Kalianpur 75 / India I',''),

(935,'Coordinate Reference System',24379,7302,'Kalianpur 75 / India IIa',''),

(936,'Coordinate Reference System',24380,7302,'Kalianpur 75 / India IIb',''),

(937,'Coordinate Reference System',24381,7302,'Kalianpur 75 / India III',''),

(938,'Coordinate Reference System',24382,7302,'Kalianpur / India IIb',''),

(939,'Coordinate Reference System',24383,7302,'Kalianpur 75 / India IV',''),

(940,'Coordinate Reference System',24892,7302,'PSAD56 / Peru central',''),

(941,'Coordinate Reference System',25000,7302,'Leigon / Ghana Grid',''),

(942,'Coordinate Reference System',25391,7302,'Luzon / Philippines I',''),

(943,'Coordinate Reference System',25392,7302,'Luzon / Philippines II',''),

(944,'Coordinate Reference System',25393,7302,'Luzon / Philippines III',''),

(945,'Coordinate Reference System',25394,7302,'Luzon / Philippines IV',''),

(946,'Coordinate Reference System',25395,7302,'Luzon / Philippines V',''),

(947,'Coordinate Reference System',25700,7302,'Makassar / NEIEZ',''),

(948,'Coordinate Reference System',25932,7302,'Malongo 1987 / UTM 32S',''),

(949,'Coordinate Reference System',26391,7302,'Minna / Nigeria West',''),

(950,'Coordinate Reference System',26393,7302,'Minna / Nigeria East',''),

(951,'Coordinate Reference System',26591,7302,'Monte Mario / Italy 1',''),

(952,'Coordinate Reference System',26592,7302,'Monte Mario / Italy 2',''),

(953,'Coordinate Reference System',26632,7302,'M''poraloko / UTM 32N',''),

(954,'Coordinate Reference System',26692,7302,'M''poraloko / UTM 32S',''),

(955,'Coordinate Reference System',26741,7302,'NAD27 / California I',''),

(956,'Coordinate Reference System',26742,7302,'NAD27 / California II',''),

(957,'Coordinate Reference System',26743,7302,'NAD27 / California III',''),

(958,'Coordinate Reference System',26744,7302,'NAD27 / California IV',''),

(959,'Coordinate Reference System',26745,7302,'NAD27 / California V',''),

(960,'Coordinate Reference System',26746,7302,'NAD27 / California VI',''),

(961,'Coordinate Reference System',26747,7302,'NAD27 / California VII',''),

(962,'Coordinate Reference System',26786,7302,'NAD27 / Massachusetts',''),

(963,'Coordinate Reference System',26787,7302,'NAD27 / Massachusetts Is',''),

(964,'Coordinate Reference System',26792,7302,'NAD27 / Minnesota Cent.',''),

(965,'Coordinate Reference System',26801,7302,'NAD27 / Michigan East',''),

(966,'Coordinate Reference System',26802,7302,'NAD27 / Michigan Old Cen',''),

(967,'Coordinate Reference System',26803,7302,'NAD27 / Michigan West',''),

(968,'Coordinate Reference System',26811,7302,'NAD27 / Michigan North',''),

(969,'Coordinate Reference System',26812,7302,'NAD27 / Michigan Central',''),

(970,'Coordinate Reference System',26813,7302,'NAD27 / Michigan South',''),

(971,'Coordinate Reference System',26941,7302,'NAD83 / California 1',''),

(972,'Coordinate Reference System',26942,7302,'NAD83 / California 2',''),

(973,'Coordinate Reference System',26943,7302,'NAD83 / California 3',''),

(974,'Coordinate Reference System',26944,7302,'NAD83 / California 4',''),

(975,'Coordinate Reference System',26945,7302,'NAD83 / California 5',''),

(976,'Coordinate Reference System',26946,7302,'NAD83 / California 6',''),

(977,'Coordinate Reference System',26986,7302,'NAD83 / Massachusetts',''),

(978,'Coordinate Reference System',26987,7302,'NAD83 / Massachusetts Is',''),

(979,'Coordinate Reference System',26992,7302,'NAD83 / Minnesota Cent.',''),

(980,'Coordinate Reference System',27038,7302,'Nahrwan 1967 / UTM 38N',''),

(981,'Coordinate Reference System',27039,7302,'Nahrwan 1967 / UTM 39N',''),

(982,'Coordinate Reference System',27040,7302,'Nahrwan 1967 / UTM 40N',''),

(983,'Coordinate Reference System',27120,7302,'Naparima 1972 / UTM 20N',''),

(984,'Coordinate Reference System',27200,7302,'GD49 / NZ Map Grid',''),

(985,'Coordinate Reference System',27391,7302,'NGO 1948 / I',''),

(986,'Coordinate Reference System',27392,7302,'NGO 1948 / II',''),

(987,'Coordinate Reference System',27393,7302,'NGO 1948 / III',''),

(988,'Coordinate Reference System',27394,7302,'NGO 1948 / IV',''),

(989,'Coordinate Reference System',27395,7302,'NGO 1948 / V',''),

(990,'Coordinate Reference System',27396,7302,'NGO 1948 / VI',''),

(991,'Coordinate Reference System',27397,7302,'NGO 1948 / VII',''),

(992,'Coordinate Reference System',27398,7302,'NGO 1948 / VIII',''),

(993,'Coordinate Reference System',27500,7302,'ATF / Nord de Guerre',''),

(994,'Coordinate Reference System',27581,7302,'NTF / France I',''),

(995,'Coordinate Reference System',27582,7302,'NTF / France II',''),

(996,'Coordinate Reference System',27583,7302,'NTF / France III',''),

(997,'Coordinate Reference System',27584,7302,'NTF / France IV',''),

(998,'Coordinate Reference System',27591,7302,'NTF / Nord France',''),

(999,'Coordinate Reference System',27592,7302,'NTF / Centre France',''),

(1000,'Coordinate Reference System',27593,7302,'NTF / Sud France',''),

(1001,'Coordinate Reference System',27594,7302,'NTF / Corse',''),

(1002,'Coordinate Reference System',27700,7302,'British National Grid',''),

(1003,'Coordinate Reference System',28191,7302,'Palestine Grid',''),

(1004,'Coordinate Reference System',28192,7302,'Palestine Belt',''),

(1005,'Coordinate Reference System',28193,7302,'Israeli CS Grid',''),

(1006,'Coordinate Reference System',28232,7302,'Point Noire / UTM 32S',''),

(1007,'Coordinate Reference System',28402,7302,'1942 Coord. Sys. zone 2',''),

(1008,'Coordinate Reference System',28403,7302,'1942 Coord. Sys. zone 3',''),

(1009,'Coordinate Reference System',28404,7302,'1942 Coord. Sys. zone 4',''),

(1010,'Coordinate Reference System',28405,7302,'1942 Coord. Sys. zone 5',''),

(1011,'Coordinate Reference System',28406,7302,'1942 Coord. Sys. zone 6',''),

(1012,'Coordinate Reference System',28407,7302,'1942 Coord. Sys. zone 7',''),

(1013,'Coordinate Reference System',28408,7302,'1942 Coord. Sys. zone 8',''),

(1014,'Coordinate Reference System',28409,7302,'1942 Coord. Sys. zone 9',''),

(1015,'Coordinate Reference System',28410,7302,'1942 Coord. Sys. zone 10',''),

(1016,'Coordinate Reference System',28411,7302,'1942 Coord. Sys. zone 11',''),

(1017,'Coordinate Reference System',28412,7302,'1942 Coord. Sys. zone 12',''),

(1018,'Coordinate Reference System',28413,7302,'1942 Coord. Sys. zone 13',''),

(1019,'Coordinate Reference System',28414,7302,'1942 Coord. Sys. zone 14',''),

(1020,'Coordinate Reference System',28415,7302,'1942 Coord. Sys. zone 15',''),

(1021,'Coordinate Reference System',28416,7302,'1942 Coord. Sys. zone 16',''),

(1022,'Coordinate Reference System',28417,7302,'1942 Coord. Sys. zone 17',''),

(1023,'Coordinate Reference System',28418,7302,'1942 Coord. Sys. zone 18',''),

(1024,'Coordinate Reference System',28419,7302,'1942 Coord. Sys. zone 19',''),

(1025,'Coordinate Reference System',28420,7302,'1942 Coord. Sys. zone 20',''),

(1026,'Coordinate Reference System',28421,7302,'1942 Coord. Sys. zone 21',''),

(1027,'Coordinate Reference System',28422,7302,'1942 Coord. Sys. zone 22',''),

(1028,'Coordinate Reference System',28423,7302,'1942 Coord. Sys. zone 23',''),