You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sis.apache.org by de...@apache.org on 2016/05/16 21:15:50 UTC
svn commit: r1744141 [3/3] - in /sis/data/non-free: ./ sis-epsg/
sis-epsg/src/ sis-epsg/src/main/ sis-epsg/src/main/java/
sis-epsg/src/main/java/org/ sis-epsg/src/main/java/org/apache/
sis-epsg/src/main/java/org/apache/sis/ sis-epsg/src/main/java/org/a...
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:
+
+ * \u201cRegistry\u201d means the EPSG Geodetic Parameter Registry;
+
+ * \u201cEPSG Dataset\u201d means EPSG Geodetic Parameter Dataset;
+
+ * \u201cIOGP\u201d means the International Association of Oil and Gas Producers,
+ incorporated in England as a company limited by guarantee (number 1832064);
+
+ * \u201cEPSG Facilities\u201d 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
+
+ * \u201cthe data\u201d 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 \u2018Accept Terms\u2019 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