| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | alias_code | int | |
| * | object_table_name | varchar(80) | |
| * | object_code | int | |
| * | naming_system_code | int | |
| * | alias | varchar(80) | |
| remarks | varchar(254) | ||
| Indexes | |||
| pk_epsg_alias | ON alias_code | ||
| fk_naming_system_code | ON naming_system_code | ||
| Foreign Keys | |||
| fk_naming_system_code | ( naming_system_code ) ref epsg_namingsystem (naming_system_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | change_id | double | |
| * | report_date | date | |
| date_closed | date | ||
| * | reporter | varchar(254) | |
| * | request | varchar(254) | |
| tables_affected | varchar(254) | ||
| codes_affected | varchar(254) | ||
| change_comment | varchar(254) | ||
| action | varchar(4000) | ||
| Indexes | |||
| change_id | ON change_id | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | conventional_rs_code | int | |
| * | conventional_rs_name | varchar(80) | |
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_conventionalrs | ON conventional_rs_code | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | coord_sys_code | int | |
| * | coord_axis_name_code | int | |
| coord_axis_code | int | ||
| * | coord_axis_orientation | varchar(24) | |
| * | coord_axis_abbreviation | varchar(24) | |
| uom_code | int | ||
| * | coord_axis_order | smallint | |
| Indexes | |||
| pk_epsg_coordinateaxis | ON coord_sys_code, coord_axis_name_code | ||
| coord_axis_code | ON coord_axis_code | ||
| fk_coord_axis_name_code | ON coord_axis_name_code | ||
| Foreign Keys | |||
| fk_coord_axis_name_code | ( coord_axis_name_code ) ref epsg_coordinateaxisname (coord_axis_name_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | coord_axis_name_code | int | |
| * | coord_axis_name | varchar(80) | |
| description | varchar(254) | ||
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_coordinateaxisname | ON coord_axis_name_code | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | coord_ref_sys_code | int | |
| * | coord_ref_sys_name | varchar(80) | |
| area_of_use_code | int | ||
| * | coord_ref_sys_kind | varchar(24) | |
| coord_sys_code | int | ||
| datum_code | int | ||
| base_crs_code | int | ||
| projection_conv_code | int | ||
| cmpd_horizcrs_code | int | ||
| cmpd_vertcrs_code | int | ||
| * | crs_scope | varchar(254) | |
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| * | show_crs | smallint | |
| Indexes | |||
| pk_epsg_coordinatereferencesystem | ON coord_ref_sys_code | ||
| fk_base_crs_code | ON base_crs_code | ||
| fk_cmpd_horizcrs_code | ON cmpd_horizcrs_code | ||
| fk_cmpd_vertcrs_code | ON cmpd_vertcrs_code | ||
| Foreign Keys | |||
| fk_base_crs_code | ( base_crs_code ) ref epsg_coordinatereferencesystem (coord_ref_sys_code) | ||
| fk_cmpd_horizcrs_code | ( cmpd_horizcrs_code ) ref epsg_coordinatereferencesystem (coord_ref_sys_code) | ||
| fk_cmpd_vertcrs_code | ( cmpd_vertcrs_code ) ref epsg_coordinatereferencesystem (coord_ref_sys_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | coord_sys_code | int | |
| * | coord_sys_name | varchar(254) | |
| * | coord_sys_type | varchar(24) | |
| * | dimension | smallint | |
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(50) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_coordinatesystem | ON coord_sys_code | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | coord_op_code | int | |
| * | coord_op_name | varchar(80) | |
| * | coord_op_type | varchar(24) | |
| source_crs_code | int | ||
| target_crs_code | int | ||
| coord_tfm_version | varchar(24) | ||
| coord_op_variant | smallint | ||
| area_of_use_code | int | ||
| * | coord_op_scope | varchar(254) | |
| coord_op_accuracy | float(12,0) | ||
| coord_op_method_code | int | ||
| uom_code_source_coord_diff | int | ||
| uom_code_target_coord_diff | int | ||
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | show_operation | smallint | |
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_coordoperation | ON coord_op_code | ||
| fk_coord_op_method_code | ON coord_op_method_code | ||
| fk_source_crs_code | ON source_crs_code | ||
| fk_target_crs_code | ON target_crs_code | ||
| fk_uom_code_source_coord_diff | ON uom_code_source_coord_diff | ||
| fk_uom_code_target_coord_diff | ON uom_code_target_coord_diff | ||
| Foreign Keys | |||
| fk_source_crs_code | ( source_crs_code ) ref epsg_coordinatereferencesystem (coord_ref_sys_code) | ||
| fk_target_crs_code | ( target_crs_code ) ref epsg_coordinatereferencesystem (coord_ref_sys_code) | ||
| fk_coord_op_method_code | ( coord_op_method_code ) ref epsg_coordoperationmethod (coord_op_method_code) | ||
| fk_uom_code_source_coord_diff | ( uom_code_source_coord_diff ) ref epsg_unitofmeasure (uom_code) | ||
| fk_uom_code_target_coord_diff | ( uom_code_target_coord_diff ) ref epsg_unitofmeasure (uom_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | coord_op_method_code | int | |
| * | coord_op_method_name | varchar(50) | |
| * | reverse_op | smallint | |
| formula | varchar(4000) | ||
| example | varchar(4000) | ||
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_coordoperationmethod | ON coord_op_method_code | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | parameter_code | int | |
| * | parameter_name | varchar(80) | |
| description | varchar(4000) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_coordoperationparam | ON parameter_code | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | parameter_code | int | |
| * | coord_op_method_code | int | |
| * | sort_order | smallint | |
| param_sign_reversal | varchar(3) | ||
| Indexes | |||
| pk_epsg_coordoperationparamusage | ON parameter_code, coord_op_method_code | ||
| fk_coord_op_method_code2 | ON coord_op_method_code | ||
| Foreign Keys | |||
| fk_coord_op_method_code2 | ( coord_op_method_code ) ref epsg_coordoperationmethod (coord_op_method_code) | ||
| fk_parameter_code | ( parameter_code ) ref epsg_coordoperationparam (parameter_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | coord_op_code | int | |
| * | parameter_code | int | |
| * | coord_op_method_code | int | |
| parameter_value | double | ||
| param_value_file_ref | varchar(254) | ||
| uom_code | int | ||
| Indexes | |||
| pk_epsg_coordoperationparamvalue | ON coord_op_code, parameter_code, coord_op_method_code | ||
| fk_parameter_codecoord_op_meth | ON parameter_code, coord_op_method_code | ||
| Foreign Keys | |||
| fk_parameter_codecoord_op_meth | ( parameter_code, coord_op_method_code ) ref epsg_coordoperationparamusage (parameter_code, coord_op_method_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | concat_operation_code | int | |
| * | single_operation_code | int | |
| * | op_path_step | smallint | |
| Indexes | |||
| pk_epsg_coordoperationpath | ON concat_operation_code, single_operation_code | ||
| Foreign Keys | |||
| fk_concat_operation_code | ( concat_operation_code ) ref epsg_coordoperation (coord_op_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | datum_code | int | |
| * | datum_name | varchar(80) | |
| * | datum_type | varchar(24) | |
| origin_description | varchar(254) | ||
| realization_epoch | varchar(10) | ||
| ellipsoid_code | int | ||
| prime_meridian_code | int | ||
| area_of_use_code | int | ||
| datum_scope | varchar(254) | ||
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| conventional_rs_code | int | ||
| publication_date | varchar(10) | ||
| frame_reference_epoch | float(12,0) | ||
| realization_method_code | int | ||
| Indexes | |||
| pk_epsg_datum | ON datum_code | ||
| fk_conventionalrs | ON conventional_rs_code | ||
| fk_prime_meridian_code | ON prime_meridian_code | ||
| fk_realization_method | ON realization_method_code | ||
| Foreign Keys | |||
| fk_conventionalrs | ( conventional_rs_code ) ref epsg_conventionalrs (conventional_rs_code) | ||
| fk_realization_method | ( realization_method_code ) ref epsg_datumrealizationmethod (realization_method_code) | ||
| fk_prime_meridian_code | ( prime_meridian_code ) ref epsg_primemeridian (prime_meridian_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | datum_ensemble_code | int | |
| ensemble_accuracy | float(12,0) | ||
| Indexes | |||
| pk_epsg_datumensemble | ON datum_ensemble_code | ||
| Foreign Keys | |||
| fk_datumensemble_datum | ( datum_ensemble_code ) ref epsg_datum (datum_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | datum_ensemble_code | int | |
| * | datum_code | int | |
| * | datum_sequence | int | |
| Indexes | |||
| pk_epsg_datumensemblemember | ON datum_ensemble_code, datum_code | ||
| fk_member_datum_code | ON datum_code | ||
| Foreign Keys | |||
| fk_member_datum_code | ( datum_code ) ref epsg_datum (datum_code) | ||
| fk_datum_ensemble_code | ( datum_ensemble_code ) ref epsg_datumensemble (datum_ensemble_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | realization_method_code | int | |
| * | realization_method_name | varchar(80) | |
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_datumrealizationmethod | ON realization_method_code | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | crs_code | int | |
| * | ct_code | int | |
| Indexes | |||
| pk_epsg_definingoperation | ON crs_code, ct_code | ||
| fk_defop_coordop_code | ON ct_code | ||
| Foreign Keys | |||
| fk_defop_crs_code | ( crs_code ) ref epsg_coordinatereferencesystem (coord_ref_sys_code) | ||
| fk_defop_coordop_code | ( ct_code ) ref epsg_coordoperation (coord_op_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | deprecation_id | int | |
| deprecation_date | date | ||
| * | change_id | double | |
| object_table_name | varchar(80) | ||
| object_code | int | ||
| replaced_by | int | ||
| deprecation_reason | varchar(254) | ||
| Indexes | |||
| pk_epsg_deprecation | ON deprecation_id | ||
| fk_change_id | ON change_id | ||
| Foreign Keys | |||
| fk_change_id | ( change_id ) ref epsg_change (change_id) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | ellipsoid_code | int | |
| * | ellipsoid_name | varchar(80) | |
| * | semi_major_axis | double | |
| * | uom_code | int | |
| inv_flattening | double | ||
| semi_minor_axis | double | ||
| * | ellipsoid_shape | smallint | |
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_ellipsoid | ON ellipsoid_code | ||
| fk_uom_code4 | ON uom_code | ||
| Foreign Keys | |||
| fk_uom_code4 | ( uom_code ) ref epsg_unitofmeasure (uom_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | extent_code | int | |
| * | extent_name | varchar(80) | |
| * | extent_description | varchar(4000) | |
| bbox_south_bound_lat | float(12,0) | ||
| bbox_west_bound_lon | float(12,0) | ||
| bbox_north_bound_lat | float(12,0) | ||
| bbox_east_bound_lon | float(12,0) | ||
| area_polygon_file_ref | varchar(254) | ||
| iso_a2_code | varchar(2) | ||
| iso_a3_code | varchar(3) | ||
| iso_n_code | int | ||
| vertical_extent_min | float(12,0) | ||
| vertical_extent_max | float(12,0) | ||
| vertical_extent_crs_code | int | ||
| temporal_extent_begin | varchar(254) | ||
| temporal_extent_end | varchar(254) | ||
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_extent | ON extent_code | ||
| fk_vertical_crs_code | ON vertical_extent_crs_code | ||
| Foreign Keys | |||
| fk_vertical_crs_code | ( vertical_extent_crs_code ) ref epsg_coordinatereferencesystem (coord_ref_sys_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | naming_system_code | int | |
| * | naming_system_name | varchar(80) | |
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_namingsystem | ON naming_system_code | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | prime_meridian_code | int | |
| * | prime_meridian_name | varchar(80) | |
| * | greenwich_longitude | double | |
| * | uom_code | int | |
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_primemeridian | ON prime_meridian_code | ||
| fk_uom_code | ON uom_code | ||
| Foreign Keys | |||
| fk_uom_code | ( uom_code ) ref epsg_unitofmeasure (uom_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | scope_code | int | |
| * | scope | varchar(254) | |
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_scope | ON scope_code | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | supersession_id | int | |
| * | object_table_name | varchar(80) | |
| * | object_code | int | |
| superseded_by | int | ||
| supersession_type | varchar(50) | ||
| supersession_year | smallint | ||
| remarks | varchar(254) | ||
| Indexes | |||
| pk_epsg_supersession | ON supersession_id | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | uom_code | int | |
| * | unit_of_meas_name | varchar(80) | |
| unit_of_meas_type | varchar(50) | ||
| * | target_uom_code | int | |
| factor_b | double | ||
| factor_c | double | ||
| remarks | varchar(254) | ||
| information_source | varchar(254) | ||
| * | data_source | varchar(40) | |
| * | revision_date | date | |
| change_id | varchar(254) | ||
| * | deprecated | smallint | |
| Indexes | |||
| pk_epsg_unitofmeasure | ON uom_code | ||
| fk_target_uom_code | ON target_uom_code | ||
| Foreign Keys | |||
| fk_target_uom_code | ( target_uom_code ) ref epsg_unitofmeasure (uom_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | usage_code | int | |
| * | object_table_name | varchar(80) | |
| * | object_code | int | |
| * | extent_code | int | |
| * | scope_code | int | |
| Indexes | |||
| pk_epsg_usage | ON usage_code | ||
| fk_usage_extent | ON extent_code | ||
| fk_usage_scope | ON scope_code | ||
| Foreign Keys | |||
| fk_usage_extent | ( extent_code ) ref epsg_extent (extent_code) | ||
| fk_usage_scope | ( scope_code ) ref epsg_scope (scope_code) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | version_history_code | int | |
| version_date | date | ||
| * | version_number | varchar(10) | |
| * | version_remarks | varchar(254) | |
| superceded_by | varchar(10) | ||
| supercedes | varchar(10) | ||
| Indexes | |||
| pk_epsg_versionhistory | ON version_history_code | ||
| version_number | ON version_number | ||