Object Type	Table
Datasource	IPMA
Database	icsa

Contains details of observations that use the PHT 32 AOT. The data attributes of this entity are derived directly from the uplink MDB table pht_geom_common.

Use and Related Data

None.

Population

This table is populated by the script uplink_data.csh. The script uses bcp dump files produced by the utility programs dump_mdb and dump_isolog.

The script can take one or more of the following arguments:

no args: This assumes that all tables have been created in the database
icsa, and that all temporary tables have been built and populated
with the necessary uplink data.

-build: Forces the building of the ICSA tables in the icsa database

-build_all: Forces the building and population of all temporary tables needed.

-compress: Is used to indicate that the datafiles have been compressed with
the UNIX utility 'compress'. The data files will be re-compressed
after use.

-nodrop: Indicates that temporary tables should not be dropped after use.

Columns

Name Datatype Null

obsno int No

scanrept int Yes

scanornt int Yes

tolangle int Yes

sampfact float Yes

column obsno

Observation number constructed as follows:

revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.

Please see SCREW 385.

column sampfact

Over sampling factor .

column scanornt

Scan orientation.

column scanrept

Scan repetition factor (1,2).

column tolangle

Tolerance angle.

Table Usage (MB)

Distribution of Table Space

Data	0.04	Data	55.00 %
Indexes	0.02	Indexes	20.00 %
Unused	0.02	Unused	25.00 %
Total	0.08	Number of Rows	1164

Dependencies

Referencing Objects

Object Name Object Type

dbo.pht_geom.pht_geom_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.pht_geom 
(
    obsno    int   NOT NULL,
    scanrept int   NULL,
    scanornt int   NULL,
    tolangle int   NULL,
    sampfact float NULL
)
LOCK ALLPAGES
go

Name	Datatype	Null

obsno	int	No

scanrept	int	Yes

scanornt	int	Yes

tolangle	int	Yes

sampfact	float	Yes