changes.mady.by.user Michael T. Black
Saved on Mar 17, 2011
Table
Columns
CSpace destination
Cleaned?
Migrated?
Mapping
Notes
AltNum
Object Identification Information:Other number
no
—?—
Only if useful for versioning context.
WHERE TableID=189, use as FK to Sites.SiteID to get place info.
• Where would an alternate name for a place go in CSpace?
use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info
Only if useful for attribution content.
ExhVenLocXrefs
————
use as FK to Constituents.ConstituentID to get person info.
GeoCodes
Do not import — term creation info not needed
import as controlled list
Only 4 terms; perhaps better to import from place concordance table
use as FK to TMSThesaurus.Terms to get info. on position within Places Authority
Used to align place info with TMSThesaurus.Terms
ObjGeography
use as FK to GeoCodes.GeoCodeID to get GeoCode
SiteClassifications
SiteDates
SiteGeoCodes
SiteGeography
move elsewhere? only 2 entries.
Do not import — no PAHMA data
contains township & range info.
name of primary map of site (usually USGS)
? contains township & range info. [merge with similar]
will usually not fit into hierarchy
use as FK to Sites.SiteID to get place info
only 1 entry
SiteObjXrefs
use as FK to Sites.SiteID to get place information
Sites
can prob. merge with SiteName
SiteStatuses
TermMasterGeo
TextEntries
WHERE TextTypeID IN (19,20,22,78)
note possible overlap with MTB_Dated (above)
WHERE TextTypeID=0
(not assigned)
WHERE TextTypeID=1
Object/Provenience Comment
WHERE TextTypeID=8
NAGPRA Concord Comment
WHERE TextTypeID=14
Some site names, some site notes
WHERE TextTypeID=45
Object Use Site
WHERE TextTypeID=46
Provenience comments