Vector product information on a given HPD Server schema.
Output
Column | Type | Description |
|---|---|---|
product_id | NUMBER | Primary key of product. |
geom | SDO_GEOMETRY | Geographical extent associated with this product. |
objectclass_id | NUMBER | ID of related object class. |
srcext_id | NUMBER | ID of external source. |
name | VARCHAR2 | Name given to product. |
scale | NUMBER | The scale of the product. |
cut | CHAR | Has this product been populated with data: • Y: Yes • N: No |
version | VARCHAR2 | Version information. |
edition | NUMBER | Product's edition. |
productversion_id | NUMBER | Primary key of the product version. |
type_name | VARCHAR2 | The product type. Valid values may include: ENC, CLB, ESB, LBO, MFF, RAL, SBO, GML, IENC, IENC Overlay, and others. |
type_key | VARCHAR2 | The category of product type. Valid values may include: ENC, AML, GML, IENC, IENC_OVERLAY. |
type_version | VARCHAR2 | The version of the product profile. |
SoundingRound | VARCHAR2 | The sounding rounding rule for this product. |
productgroup | VARCHAR2 | The name of the group the product belongs to. |
profile_id | NUMBER | ID of the product profile. |
product_status | VARCHAR2 | Status can be one of the following: • Active • Rejected • Retired • Locked |
SetIssueDateOnExport | CHAR | Whether the issue date will be changed to the current date when the product is exported: • Y: Yes • N: No |
writable | VARCHAR2 | 'Y' if the user has write access to the product, 'N' otherwise. |
scamin_filter | NUMBER | If not NULL, then source features that have a SCAMIN which is less than this value are excluded from the product. |
conversion_name | VARCHAR2 | The name of the conversion used to create and update the product. |
Example
The following example shows the use of this view in an SQL statement.
select * from VECTOR_PRODUCT_VIEW; |
One can use the view to find productversion_ids from product_ids, or vice-versa.
column version format a10 column type_name format a10 column type_key format a10 column type_version format a10 select product_id, productversion_id, edition, version, type_name, type_key, type_version, product_status, name from VECTOR_PRODUCT_VIEW; |