Propchange:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql
------------------------------------------------------------------------------
svn:mime-type = text/plain;charset=UTF-8
Added:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/FKeys.sql
URL:
http://svn.apache.org/viewvc/sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/FKeys.sql?rev=1744141&view=auto
==============================================================================
---
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/FKeys.sql
(added)
+++
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/FKeys.sql
[UTF-8] Mon May 16 21:15:50 2016
@@ -0,0 +1,126 @@
+---
+--- Copyright International Association of Oil and Gas Producers (IOGP)
+--- See http://www.epsg.org/TermsOfUse (a copy is in ./LICENSE.txt).
+---
+--- This file has been modified for the needs of Apache SIS project.
+---
+
+ALTER TABLE epsg_coordoperation ADD CONSTRAINT fk_uom_code_target_coord_diff
FOREIGN KEY
+( uom_code_target_coord_diff ) REFERENCES epsg_unitofmeasure ( uom_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordoperationparamusage ADD CONSTRAINT fk_parameter_code
FOREIGN KEY
+( parameter_code ) REFERENCES epsg_coordoperationparam ( parameter_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_unitofmeasure ADD CONSTRAINT fk_target_uom_code FOREIGN KEY
+( target_uom_code ) REFERENCES epsg_unitofmeasure ( uom_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_deprecation ADD CONSTRAINT fk_change_id FOREIGN KEY
+( change_id ) REFERENCES epsg_change ( change_id )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_datum ADD CONSTRAINT fk_ellipsoid_code FOREIGN KEY
+( ellipsoid_code ) REFERENCES epsg_ellipsoid ( ellipsoid_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_primemeridian ADD CONSTRAINT fk_uom_code FOREIGN KEY
+( uom_code ) REFERENCES epsg_unitofmeasure ( uom_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordinateaxis ADD CONSTRAINT fk_uom_code2 FOREIGN KEY
+( uom_code ) REFERENCES epsg_unitofmeasure ( uom_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordinatereferencesystem ADD CONSTRAINT
fk_cmpd_horizcrs_code FOREIGN KEY
+( cmpd_horizcrs_code ) REFERENCES epsg_coordinatereferencesystem (
coord_ref_sys_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordoperation ADD CONSTRAINT fk_coord_op_method_code FOREIGN
KEY
+( coord_op_method_code ) REFERENCES epsg_coordoperationmethod (
coord_op_method_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordinatereferencesystem ADD CONSTRAINT fk_datum_code
FOREIGN KEY
+( datum_code ) REFERENCES epsg_datum ( datum_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_datum ADD CONSTRAINT fk_prime_meridian_code FOREIGN KEY
+( prime_meridian_code ) REFERENCES epsg_primemeridian ( prime_meridian_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordoperationparamvalue ADD CONSTRAINT fk_uom_code3 FOREIGN
KEY
+( uom_code ) REFERENCES epsg_unitofmeasure ( uom_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordinatereferencesystem ADD CONSTRAINT fk_area_of_use_code
FOREIGN KEY
+( area_of_use_code ) REFERENCES epsg_area ( area_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordinateaxis ADD CONSTRAINT fk_coord_axis_name_code FOREIGN
KEY
+( coord_axis_name_code ) REFERENCES epsg_coordinateaxisname (
coord_axis_name_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordoperation ADD CONSTRAINT fk_uom_code_source_coord_diff
FOREIGN KEY
+( uom_code_source_coord_diff ) REFERENCES epsg_unitofmeasure ( uom_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordoperationparamvalue ADD CONSTRAINT
fk_parameter_codecoord_op_meth FOREIGN KEY
+( parameter_code, coord_op_method_code ) REFERENCES
epsg_coordoperationparamusage ( parameter_code, coord_op_method_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordoperation ADD CONSTRAINT fk_source_crs_code FOREIGN KEY
+( source_crs_code ) REFERENCES epsg_coordinatereferencesystem (
coord_ref_sys_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordoperationpath ADD CONSTRAINT fk_concat_operation_code
FOREIGN KEY
+( concat_operation_code ) REFERENCES epsg_coordoperation ( coord_op_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordinateaxis ADD CONSTRAINT fk_coord_sys_code FOREIGN KEY
+( coord_sys_code ) REFERENCES epsg_coordinatesystem ( coord_sys_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordoperationpath ADD CONSTRAINT fk_single_operation_code
FOREIGN KEY
+( single_operation_code ) REFERENCES epsg_coordoperation ( coord_op_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordinatereferencesystem ADD CONSTRAINT fk_coord_sys_code2
FOREIGN KEY
+( coord_sys_code ) REFERENCES epsg_coordinatesystem ( coord_sys_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordinatereferencesystem ADD CONSTRAINT fk_cmpd_vertcrs_code
FOREIGN KEY
+( cmpd_vertcrs_code ) REFERENCES epsg_coordinatereferencesystem (
coord_ref_sys_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordinatereferencesystem ADD CONSTRAINT
fk_source_geogcrs_code FOREIGN KEY
+( source_geogcrs_code ) REFERENCES epsg_coordinatereferencesystem (
coord_ref_sys_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordoperation ADD CONSTRAINT fk_target_crs_code FOREIGN KEY
+( target_crs_code ) REFERENCES epsg_coordinatereferencesystem (
coord_ref_sys_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_datum ADD CONSTRAINT fk_area_of_use_code2 FOREIGN KEY
+( area_of_use_code ) REFERENCES epsg_area ( area_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_alias ADD CONSTRAINT fk_naming_system_code FOREIGN KEY
+( naming_system_code ) REFERENCES epsg_namingsystem ( naming_system_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordoperation ADD CONSTRAINT fk_area_of_use_code3 FOREIGN KEY
+( area_of_use_code ) REFERENCES epsg_area ( area_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordoperationparamvalue ADD CONSTRAINT fk_coord_op_code
FOREIGN KEY
+( coord_op_code ) REFERENCES epsg_coordoperation ( coord_op_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_ellipsoid ADD CONSTRAINT fk_uom_code4 FOREIGN KEY
+( uom_code ) REFERENCES epsg_unitofmeasure ( uom_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE epsg_coordoperationparamusage ADD CONSTRAINT
fk_coord_op_method_code2 FOREIGN KEY
+( coord_op_method_code ) REFERENCES epsg_coordoperationmethod (
coord_op_method_code )
+ON UPDATE RESTRICT ON DELETE RESTRICT;
Propchange:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/FKeys.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/FKeys.sql
------------------------------------------------------------------------------
svn:mime-type = text/plain;charset=UTF-8
Added:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/LICENSE.html
URL:
http://svn.apache.org/viewvc/sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/LICENSE.html?rev=1744141&view=auto
==============================================================================
---
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/LICENSE.html
(added)
+++
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/LICENSE.html
Mon May 16 21:15:50 2016
@@ -0,0 +1,82 @@
+<!DOCTYPE html>
+<html>
+ <head>
+ <title>EPSG dataset terms of use</title>
+ <meta charset="UTF-8">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+ </head>
+ <body>
+ <h1>EPSG dataset terms of use (6 November 2014)</h1>
+ <p><a
href="http://www.epsg.org/TermsOfUse";>http://www.epsg.org/TermsOfUse</a></p>
+
+ <ol>
+ <li><p>In this document the following definitions of terms apply:</p>
+ <ul>
+ <li>âRegistryâ means the EPSG Geodetic Parameter Registry;</li>
+ <li>âEPSG Datasetâ means EPSG Geodetic Parameter Dataset;</li>
+ <li>âIOGPâ means the International Association of Oil and Gas
Producers,
+ incorporated in England as a company limited by guarantee (number
1832064);</li>
+ <li>âEPSG Facilitiesâ means the Registry, the EPSG Dataset
(published through the Registry
+ or through a downloadable MS-Access file or through a set of SQL
scripts that enable a
+ user to create an Oracle, MySQL, PostgreSQL or other database and
populate that database
+ with the EPSG Dataset) and associated documentation consisting of
the Release Notes and
+ Guidance Notes 7.1 and 7.2</li>
+ <li>âthe dataâ means the geodetic parameter data and associated
metadata, contained in the
+ EPSG Dataset; it also refers to any subset of data from the EPSG
Dataset.</li>
+ </ul>
+ </li>
+
+ <li><p>The EPSG Facilities are published by IOGP at no charge.
Distribution for profit is forbidden.</p></li>
+
+ <li><p>The EPSG Facilities are owned by IOGP. They are compiled by the
Geodetic Subcommittee of the
+ IOGP from publicly available and member-supplied
information.</p></li>
+
+ <li><p>In order to use the EPSG Facilities, you must agree to these
Terms of Use. You may not use
+ the EPSG Facilities or any of them in whole or in part unless you
agree to these Terms of Use.</p></li>
+
+ <li><p>You can accept these Terms of Use by clicking the command button
âAccept Termsâ upon registering
+ as a new user. You will also be required to accept any revised Terms of
Use prior to using or
+ downloading any EPSG Facilities. You understand and agree that any use
of the EPSG Facilities
+ or any of them, even if obtained without clicking acceptance, will be
acceptance of these Terms
+ of Use.</p></li>
+
+ <li><p>The data may be used, copied and distributed subject to the
following conditions:</p>
+ <ol type="i">
+ <li><p>Whilst every effort has been made to ensure the accuracy of
the information contained
+ in the EPSG Facilities, neither the IOGP nor any of its members
past present or future
+ warrants their accuracy or will, regardless of its or their
negligence, assume liability
+ for any foreseeable or unforeseeable use made thereof, which
liability is hereby excluded.
+ Consequently, such use is at your own risk. You are obliged to
inform anyone to whom you
+ provide the EPSG Facilities of these Terms of Use.</p></li>
+
+ <li><p>DATA AND INFORMATION PROVIDED IN THE EPSG FACILITIES ARE
PROVIDED "AS IS" WITHOUT WARRANTY
+ OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT
LIMITED TO THE IMPLIED
+ WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR
PURPOSE.</p></li>
+
+ <li><p>The data may be included in any commercial package provided
that any commerciality is
+ based on value added by the provider and not on a value ascribed
to the EPSG Dataset
+ which is made available at no charge.</p></li>
+
+ <li><p>Ownership of the EPSG Dataset by IOGP must be acknowledged in
any publication or
+ transmission (by whatever means) thereof (including permitted
modifications).</p></li>
+
+ <li><p>Subsets of information may be extracted from the dataset.
Users are advised that
+ coordinate reference system and coordinate transformation
descriptions are incomplete
+ unless all elements detailed as essential in IOGP Surveying and
Positioning Guidance
+ Note 7-1 annex F are included.</p></li>
+
+ <li><p>Essential elements should preferably be reproduced as
described in the dataset.
+ Modification of parameter values is permitted as described in
the table 1 to allow
+ change to the content of the information provided that numeric
equivalence is achieved.
+ Numeric equivalence refers to the results of geodetic
calculations in which the
+ parameters are used, for example (i) conversion of ellipsoid
defining parameters,
+ or (ii) conversion of parameters between one and two standard
parallel projection methods,
+ or (iii) conversion of parameters between 7-parameter geocentric
transformation methods.</p></li>
+
+ <li><p>No data that has been modified other than as permitted in
these Terms of Use shall be
+ attributed to the EPSG Dataset.</p></li>
+ </ol>
+ </li>
+ </ol>
+ </body>
+</html>
Propchange:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/LICENSE.html
------------------------------------------------------------------------------
svn:eol-style = native
Propchange:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/LICENSE.html
------------------------------------------------------------------------------
svn:mime-type = text/html
Added:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/LICENSE.txt
URL:
http://svn.apache.org/viewvc/sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/LICENSE.txt?rev=1744141&view=auto
==============================================================================
---
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/LICENSE.txt
(added)
+++
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/LICENSE.txt
[UTF-8] Mon May 16 21:15:50 2016
@@ -0,0 +1,74 @@
+ EPSG dataset terms of use
+ Revised 6 November 2014
+ http://www.epsg.org/TermsOfUse
+
+
+
+1. In this document the following definitions of terms apply:
+
+ * “Registry” means the EPSG Geodetic Parameter Registry;
+
+ * “EPSG Dataset” means EPSG Geodetic Parameter Dataset;
+
+ * “IOGP” means the International Association of Oil and Gas Producers,
+ incorporated in England as a company limited by guarantee (number
1832064);
+
+ * “EPSG Facilities” means the Registry, the EPSG Dataset (published
through the Registry
+ or through a downloadable MS-Access file or through a set of SQL scripts
that enable a
+ user to create an Oracle, MySQL, PostgreSQL or other database and
populate that database
+ with the EPSG Dataset) and associated documentation consisting of the
Release Notes and
+ Guidance Notes 7.1 and 7.2
+
+ * “the data” means the geodetic parameter data and associated metadata,
contained in the
+ EPSG Dataset; it also refers to any subset of data from the EPSG Dataset.
+
+
+2. The EPSG Facilities are published by IOGP at no charge. Distribution for
profit is forbidden.
+
+3. The EPSG Facilities are owned by IOGP. They are compiled by the Geodetic
Subcommittee of the
+ IOGP from publicly available and member-supplied information.
+
+4. In order to use the EPSG Facilities, you must agree to these Terms of Use.
You may not use
+ the EPSG Facilities or any of them in whole or in part unless you agree to
these Terms of Use.
+
+5. You can accept these Terms of Use by clicking the command button ‘Accept
Terms’ upon registering
+ as a new user. You will also be required to accept any revised Terms of Use
prior to using or
+ downloading any EPSG Facilities. You understand and agree that any use of
the EPSG Facilities
+ or any of them, even if obtained without clicking acceptance, will be
acceptance of these Terms
+ of Use.
+
+6. The data may be used, copied and distributed subject to the following
conditions:
+
+ i. Whilst every effort has been made to ensure the accuracy of the
information contained
+ in the EPSG Facilities, neither the IOGP nor any of its members past
present or future
+ warrants their accuracy or will, regardless of its or their
negligence, assume liability
+ for any foreseeable or unforeseeable use made thereof, which
liability is hereby excluded.
+ Consequently, such use is at your own risk. You are obliged to inform
anyone to whom you
+ provide the EPSG Facilities of these Terms of Use.
+
+ ii. DATA AND INFORMATION PROVIDED IN THE EPSG FACILITIES ARE PROVIDED "AS
IS" WITHOUT WARRANTY
+ OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED
TO THE IMPLIED
+ WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE.
+
+ iii. The data may be included in any commercial package provided that any
commerciality is
+ based on value added by the provider and not on a value ascribed to
the EPSG Dataset
+ which is made available at no charge.
+
+ iv. Ownership of the EPSG Dataset by IOGP must be acknowledged in any
publication or
+ transmission (by whatever means) thereof (including permitted
modifications).
+
+ v. Subsets of information may be extracted from the dataset. Users are
advised that
+ coordinate reference system and coordinate transformation
descriptions are incomplete
+ unless all elements detailed as essential in IOGP Surveying and
Positioning Guidance
+ Note 7-1 annex F are included.
+
+ vi. Essential elements should preferably be reproduced as described in
the dataset.
+ Modification of parameter values is permitted as described in the
table 1 to allow
+ change to the content of the information provided that numeric
equivalence is achieved.
+ Numeric equivalence refers to the results of geodetic calculations in
which the
+ parameters are used, for example (i) conversion of ellipsoid defining
parameters,
+ or (ii) conversion of parameters between one and two standard
parallel projection methods,
+ or (iii) conversion of parameters between 7-parameter geocentric
transformation methods.
+
+ vii. No data that has been modified other than as permitted in these Terms
of Use shall be
+ attributed to the EPSG Dataset.
Propchange:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/LICENSE.txt
------------------------------------------------------------------------------
svn:eol-style = native
Propchange:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/LICENSE.txt
------------------------------------------------------------------------------
svn:mime-type = text/plain;charset=UTF-8
Added:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Tables.sql
URL:
http://svn.apache.org/viewvc/sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Tables.sql?rev=1744141&view=auto
==============================================================================
---
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Tables.sql
(added)
+++
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Tables.sql
[UTF-8] Mon May 16 21:15:50 2016
@@ -0,0 +1,289 @@
+---
+--- Copyright International Association of Oil and Gas Producers (IOGP)
+--- See http://www.epsg.org/TermsOfUse (a copy is in ./LICENSE.txt).
+---
+--- This file has been modified for the needs of Apache SIS project.
+--- See org.apache.sis.referencing.factory.sql.EPSGDataFormatter for
+--- a description of those changes.
+---
+
+
+--- This script depends on enumerated values defined in "EPSG_Prepare.sql"
file of Apache SIS project.
+--- If those enumerations are not desired, they can be removed if the
following replacements are done:
+---
+--- epsg_table_name --> VARCHAR(80)
+--- epsg_datum_kind --> VARCHAR(24)
+--- epsg_crs_kind --> VARCHAR(24)
+--- epsg_cs_kind --> VARCHAR(24)
+---
+--- Apache SIS will perform the above replacements automatically if this
script is executed on another
+--- database than PostgreSQL.
+
+CREATE TABLE epsg_alias (
+alias_code INTEGER NOT NULL,
+object_table_name epsg_table_name 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 TABLE epsg_area (
+area_code INTEGER NOT NULL,
+area_name VARCHAR(80) NOT NULL,
+area_of_use VARCHAR(4000) NOT NULL,
+area_south_bound_lat DOUBLE PRECISION,
+area_north_bound_lat DOUBLE PRECISION,
+area_west_bound_lon DOUBLE PRECISION,
+area_east_bound_lon DOUBLE PRECISION,
+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 BOOLEAN NOT NULL,
+CONSTRAINT pk_area PRIMARY KEY ( area_code ) );
+
+CREATE TABLE epsg_change (
+change_id DOUBLE PRECISION 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(4000),
+CONSTRAINT pk_change PRIMARY KEY ( change_id ) );
+
+CREATE TABLE epsg_coordinateaxis (
+coord_axis_code INTEGER NOT NULL UNIQUE,
+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 ) );
+
+CREATE 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 BOOLEAN NOT NULL,
+CONSTRAINT pk_coordinateaxisname PRIMARY KEY ( coord_axis_name_code ) );
+
+CREATE 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 epsg_crs_kind 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 BOOLEAN NOT NULL,
+deprecated BOOLEAN NOT NULL,
+CONSTRAINT pk_coordinatereferencesystem PRIMARY KEY ( coord_ref_sys_code ) );
+
+CREATE TABLE epsg_coordinatesystem (
+coord_sys_code INTEGER NOT NULL,
+coord_sys_name VARCHAR(254) NOT NULL,
+coord_sys_type epsg_cs_kind 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 BOOLEAN NOT NULL,
+CONSTRAINT pk_coordinatesystem PRIMARY KEY ( coord_sys_code ) );
+
+CREATE 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 BOOLEAN NOT NULL,
+deprecated BOOLEAN NOT NULL,
+CONSTRAINT pk_coordinate_operation PRIMARY KEY ( coord_op_code ) );
+
+CREATE TABLE epsg_coordoperationmethod (
+coord_op_method_code INTEGER NOT NULL,
+coord_op_method_name VARCHAR(50) NOT NULL,
+reverse_op BOOLEAN NOT NULL,
+formula VARCHAR(4000),
+example VARCHAR(4000),
+remarks VARCHAR(254),
+information_source VARCHAR(254),
+data_source VARCHAR(40) NOT NULL,
+revision_date DATE NOT NULL,
+change_id VARCHAR(255),
+deprecated BOOLEAN NOT NULL,
+CONSTRAINT pk_coordinate_operationmethod PRIMARY KEY ( coord_op_method_code )
);
+
+CREATE TABLE epsg_coordoperationparam (
+parameter_code INTEGER NOT NULL,
+parameter_name VARCHAR(80) NOT NULL,
+description VARCHAR(4000),
+information_source VARCHAR(254),
+data_source VARCHAR(40) NOT NULL,
+revision_date DATE NOT NULL,
+change_id VARCHAR(255),
+deprecated BOOLEAN NOT NULL,
+CONSTRAINT pk_coordinate_operationparamet PRIMARY KEY ( parameter_code ) );
+
+CREATE TABLE epsg_coordoperationparamusage (
+coord_op_method_code INTEGER NOT NULL,
+parameter_code INTEGER NOT NULL,
+sort_order SMALLINT NOT NULL,
+param_sign_reversal BOOLEAN,
+CONSTRAINT pk_coordinate_operationparame2 PRIMARY KEY ( parameter_code,
coord_op_method_code ) );
+
+CREATE TABLE epsg_coordoperationparamvalue (
+coord_op_code INTEGER NOT NULL,
+coord_op_method_code INTEGER NOT NULL,
+parameter_code INTEGER NOT NULL,
+parameter_value DOUBLE PRECISION,
+param_value_file_ref VARCHAR(254),
+uom_code INTEGER,
+CONSTRAINT pk_coordinate_operationparame3 PRIMARY KEY ( coord_op_code,
parameter_code, coord_op_method_code ) );
+
+CREATE TABLE epsg_coordoperationpath (
+concat_operation_code INTEGER NOT NULL,
+single_operation_code INTEGER NOT NULL,
+op_path_step SMALLINT NOT NULL,
+CONSTRAINT pk_coordinate_operationpath PRIMARY KEY ( concat_operation_code,
single_operation_code ) );
+
+CREATE TABLE epsg_datum (
+datum_code INTEGER NOT NULL,
+datum_name VARCHAR(80) NOT NULL,
+datum_type epsg_datum_kind NOT NULL,
+origin_description VARCHAR(254),
+realization_epoch SMALLINT,
+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 BOOLEAN NOT NULL,
+CONSTRAINT pk_datum PRIMARY KEY ( datum_code ) );
+
+CREATE TABLE epsg_deprecation (
+deprecation_id INTEGER,
+deprecation_date DATE,
+change_id DOUBLE PRECISION NOT NULL,
+object_table_name epsg_table_name,
+object_code INTEGER,
+replaced_by INTEGER,
+deprecation_reason VARCHAR(254),
+CONSTRAINT pk_deprecation PRIMARY KEY ( deprecation_id ) );
+
+CREATE TABLE epsg_ellipsoid (
+ellipsoid_code INTEGER NOT NULL,
+ellipsoid_name VARCHAR(80) NOT NULL,
+semi_major_axis DOUBLE PRECISION NOT NULL,
+uom_code INTEGER NOT NULL,
+inv_flattening DOUBLE PRECISION,
+semi_minor_axis DOUBLE PRECISION,
+ellipsoid_shape BOOLEAN 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 BOOLEAN NOT NULL,
+CONSTRAINT pk_ellipsoid PRIMARY KEY ( ellipsoid_code ) );
+
+CREATE 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 BOOLEAN NOT NULL,
+CONSTRAINT pk_namingsystem PRIMARY KEY ( naming_system_code ) );
+
+CREATE TABLE epsg_primemeridian (
+prime_meridian_code INTEGER NOT NULL,
+prime_meridian_name VARCHAR(80) NOT NULL,
+greenwich_longitude DOUBLE PRECISION 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 BOOLEAN NOT NULL,
+CONSTRAINT pk_primemeridian PRIMARY KEY ( prime_meridian_code ) );
+
+CREATE TABLE epsg_supersession (
+supersession_id INTEGER,
+object_table_name epsg_table_name 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 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 PRECISION,
+factor_c DOUBLE PRECISION,
+remarks VARCHAR(254),
+information_source VARCHAR(254),
+data_source VARCHAR(40) NOT NULL,
+revision_date DATE NOT NULL,
+change_id VARCHAR(255),
+deprecated BOOLEAN NOT NULL,
+CONSTRAINT pk_unitofmeasure PRIMARY KEY ( uom_code ) );
+
+CREATE TABLE epsg_versionhistory (
+version_history_code INTEGER NOT NULL,
+version_date DATE,
+version_number VARCHAR(10) NOT NULL UNIQUE,
+version_remarks VARCHAR(254) NOT NULL,
+superceded_by VARCHAR(10),
+supercedes VARCHAR(10),
+CONSTRAINT pk_versionhistory PRIMARY KEY ( version_history_code ) );
Propchange:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Tables.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange:
sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Tables.sql
------------------------------------------------------------------------------
svn:mime-type = text/plain;charset=UTF-8
Added:
sis/data/non-free/sis-epsg/src/test/java/org/apache/sis/referencing/factory/sql/epsg/ScriptProviderTest.java
URL:
http://svn.apache.org/viewvc/sis/data/non-free/sis-epsg/src/test/java/org/apache/sis/referencing/factory/sql/epsg/ScriptProviderTest.java?rev=1744141&view=auto
==============================================================================
---
sis/data/non-free/sis-epsg/src/test/java/org/apache/sis/referencing/factory/sql/epsg/ScriptProviderTest.java
(added)
+++
sis/data/non-free/sis-epsg/src/test/java/org/apache/sis/referencing/factory/sql/epsg/ScriptProviderTest.java
[UTF-8] Mon May 16 21:15:50 2016
@@ -0,0 +1,68 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.apache.sis.referencing.factory.sql.epsg;
+
+import java.util.Iterator;
+import java.io.IOException;
+import java.io.BufferedReader;
+import java.util.ServiceLoader;
+import org.apache.sis.setup.InstallationResources;
+import org.junit.Test;
+
+import static org.junit.Assert.*;
+
+
+/**
+ * Test {@link ScriptProvider}.
+ *
+ * @author Martin Desruisseaux (Geomatys)
+ */
+public final strictfp class ScriptProviderTest {
+ /**
+ * Returns the {@link ScriptProvider} instance declared in the {@code
META-INF/services/} directory.
+ */
+ private static InstallationResources getInstance() {
+ final Iterator<InstallationResources> it =
ServiceLoader.load(InstallationResources.class).iterator();
+ final InstallationResources provider = it.next();
+ assertFalse("Expected only one instance.", it.hasNext());
+ return provider;
+ }
+
+ /**
+ * Tests fetching the resources.
+ *
+ * @throws IOException if an error occurred while reading a resource.
+ */
+ @Test
+ public void testResources() throws IOException {
+ final ScriptProvider provider = (ScriptProvider) getInstance();
+ assertTrue(provider.getLicense("EPSG", null,
"text/plain").contains("IOGP"));
+ assertTrue(provider.getLicense("EPSG", null, "text/html"
).contains("IOGP"));
+
+ final String[] names = provider.getResourceNames("EPSG");
+ assertArrayEquals(new String[] {"Prepare", "Tables.sql", "Data.sql",
"FKeys.sql", "Finish"}, names);
+ for (int i=0; i<names.length; i++) {
+ final BufferedReader in = provider.openScript("EPSG", i);
+ try {
+ // Just verify that we can read.
+ assertFalse(in.readLine().isEmpty());
+ } finally {
+ in.close();
+ }
+ }
+ }
+}
Propchange:
sis/data/non-free/sis-epsg/src/test/java/org/apache/sis/referencing/factory/sql/epsg/ScriptProviderTest.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange:
sis/data/non-free/sis-epsg/src/test/java/org/apache/sis/referencing/factory/sql/epsg/ScriptProviderTest.java
------------------------------------------------------------------------------
svn:mime-type = text/plain;charset=UTF-8
