Object Type	Table
Datasource	IPMA
Database	icsa

Used to hold information about a raster map for all observations that perform a raster map. The columns of this table are derived directly from those of the uplink MDB map table.

Use and Related Data

Related to observations that use raster maps.

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

m	int	Yes

n	int	Yes

dm	int	Yes

dn	int	Yes

ornt	int	Yes

rflag	tinyint	Yes

column dm

Distance between horizontal axis points. Units: arc seconds.

column dn

Distance between vertical axis points. Units: arcseconds.

column m

Number of points along the horizontal axis.

column n

Number of points along the vertical axis.

column obsno

Observation number constructed as follows:

revolution number * 1000000 + target number * 1000 + observation sequence number*10 + type (1 for CAM parallel, 2 for LWS parallel and 0 otherwise).

column ornt

Orientation of the map.Units: degrees (0-180 increasing clockwise).

column rflag

Specifies the direction of the raster map:

0 indicates from north

1 indicates from Y-axis.

Table Usage (MB)

Distribution of Table Space

Data	0.40	Data	43.62 %
Indexes	0.45	Indexes	48.51 %
Unused	0.07	Unused	7.87 %
Total	0.92	Number of Rows	10396

Dependencies

Referencing Objects

Object Name Object Type

dbo.raster_map.raster_map_pk INDEX

dbo.raster_map.raster_map_ix1 INDEX

dbo.raster_map.raster_map_ix2 INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.raster_map 
(
    obsno int     NOT NULL,
    m     int     NULL,
    n     int     NULL,
    dm    int     NULL,
    dn    int     NULL,
    ornt  int     NULL,
    rflag tinyint NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.raster_map.raster_map_pk	INDEX
dbo.raster_map.raster_map_ix1	INDEX
dbo.raster_map.raster_map_ix2	INDEX