University of Illinois Library

1408 W. Gregory Drive

(MC-522)

Urbana, IL, 61801


Email:
dcc[at]library.uiuc.edu

Reconnecting Access Table Columns

(with FGDC Metadata Standard sections)


As part of the Imagebase project, each photo scan, and each set of photos scanned, was indexed. The standard employed for constructing the indexing metadata was derived from the FGDC (Federal Geographic Data Committee), Content Standards for Digital Geospatial Metadata, June 8, 1994 edition. Below are listed the metadata elements that were selected for this project. These metadata elements have been crosswalked to the applicable section of the FGDC metadata standard. The overall set records for the pilot portion of the collection will be crosswalked to the MARC format for inclusion in the University of Illinois Library's online catalog, ILLINET Online.


MS-Access TableAirPhotos

Access Column

FGDC Section

CountyID 8.4
FlightLine 8.4
PhotoNumber 8.4
CalendarDate 9.1.1
WestBoundingCoordinate 1.5.1.1
EastBoundingCoordinate 1.5.1.2
NorthBoundingCoordinate 1.5.1.3
SouthBoundingCoordinate 1.5.1.4
BrowseGraphicFileName 1.10.1
BrowseGraphicFileDescription 1.10.2
LatitudeResolution 4.1.1.1
LongitudeResolution 4.1.1.2
ColumnCount 3.4.3
RowCount 3.4.2
NetworkResourceName 6.4.2.2.1.1.1.1
FileSize 6.4.2.1.7
MS-Access TableAirPhotoSets

Access Column

FGDC Section

MetadataDate 7.1
Progress 1.4.1
MaintenanceUpdateFrequency 1.4.2
WestBoundingCoordinate 1.5.1.1
EastBoundingCoordinate 1.5.1.2
NorthBoundingCoordinate 1.5.1.3
SouthBoundingCoordinate 1.5.1.4
PlaceKeyword 1.6.2.2
SourceScaleDenominator 2.5.1.2
OriginatorFederal 8.1
OriginatorFlight 8.1
OriginatorFlightSubcontractor 8.1
PublicationDate 8.2
Title 8.4
PublicationPlace 8.8.1
Publisher 8.8.2
BeginningDate 9.3.1
EndingDate 9.3.2
ProcesDate 2.5.2.3
DataSetCredit 1.11
SourceCitationAbbreviation 2.5.1.5



MS-Access TableBaseInfo

Access Column

FGDC Section

Abstract 1.2.1
Purpose 1.2.2
CurrentnessReference 1.3.1
ThemeKeywordThesaurus 1.6.1.1
ThemeKeyword 1.6.1.2
PlaceKeywordThesaurus 1.6.2.1
AccessConstraints 1.7
UseConstraints 1.8
TypeOfSourceMaterial 2.5.1.3
SourceCurrentnessReference 2.5.1.4.1
SourceContribution 2.5.1.6
ProcessDescription 2.5.2.1
DirectSpatialReferenceMethod 3.2
RasterObjectType 3.4.1
GeographicUnitCoordinates 4.1.1.3

Access Column (con.)

FGDC Section

DistributionLiability 6.3
FormatName 6.4.2.1.1
BrowseGraphicFileType 1.10.3
Fees 6.4.3
MetadataStandardName 7.5
MetadataStandardVersion 7.6
GeospatialDataPresentationForm 8.6
ContactOrganization 10.1.2
AddressType 10.4.1
Address 10.4.2
City 10.4.3
State 10.4.4
PostalCode 10.4.5
VoiceTelephone 10.5