sis-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From desruisse...@apache.org
Subject 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...
Date Mon, 16 May 2016 21:15:50 GMT
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




Mime
View raw message