MapCat Table

This table contains information on static map holdings as well as digital photographs and other images.

Field Name Field Description Data Type Field Size*
MapID The map or image ID int 4
MapTitle The title of the map or photograph varchar 255
Scale The map scale for the map image varchar 12
MapDate The date the map or image was produced. datetime 8
Source The agency source of the map or photograph image varchar 50
DetailSource A detailed description of the source of the image file varchar 255
ImageType 1 = map, 2 = photgraph tinyint 1
Comment A comment field for the map or photo text 16
Cataloged_ For internal use only varchar 1

*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.


Revised Wednesday September 28 2005