Page Comparison

Table

Columns

CSpace destination

Cleaned?

Migrated?

Mapping

Notes

AltNum

Object Identification Information:Other number

no

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?

no

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.

no

—?—

Only if useful for versioning context.

no

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.

no

—?—

Only if useful for versioning context.

no

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.

————

————

Only if useful for versioning context.

use as FK to Constituents.ConstituentID to get person info.

no

—?—

Only if useful for versioning context.

no

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.

————

————

Only if useful for versioning context.

————

————

Do not import — term creation info not needed

import as controlled list

Only 4 terms; perhaps better to import from place concordance table

————

————

Do not import — term creation info not needed

————

————

Do not import — term creation info not needed

use as FK to TMSThesaurus.Terms to
get info. on position within Places Authority

Used to align place info with TMSThesaurus.Terms

no

—?—

Only if useful for versioning context.

use as FK to GeoCodes.GeoCodeID to get GeoCode

no

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.

use as FK to TMSThesaurus.Terms to
get info. on position within Places Authority

Used to align place info with TMSThesaurus.Terms

————

————

Only if useful for versioning context.

no

—?—

Only if useful for versioning context.

no

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.

————

————

Only if useful for versioning context.

no

—?—

Only if useful for versioning context.

no

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.

————

————

Only if useful for versioning context.

no

————

move elsewhere? only 2 entries.

no

—?—

Only if useful for versioning context.

use as FK to GeoCodes.GeoCodeID to get GeoCode

no

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.

Do not import — no PAHMA data

————

contains township & range info.

use as FK to TMSThesaurus.Terms to
get info. on position within Places Authority

Used to align place info with TMSThesaurus.Terms

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 if useful for versioning context.

no

————

only 1 entry

no

—?—

Only if useful for versioning context.

no

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.

use as FK to Sites.SiteID to get place information

————

————

Only if useful for versioning context.

no

—?—

Only if useful for versioning context.

no

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.

————

————

Only if useful for versioning context.

—?—

no

—?—

Only if useful for versioning context.

—?—

no

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.

use as FK to TMSThesaurus.Terms to
get info. on position within Places Authority

Used to align place info with TMSThesaurus.Terms

can prob. merge with SiteName

————

————

Only if useful for versioning context.

no

—?—

Only if useful for versioning context.

no

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.

use as FK to Constituents.ConstituentID to get person info.

WHERE TableID=189, use as FK to Sites.SiteID to get place info.

no

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.

use as FK to TMSThesaurus.Terms to
get info. on position within Places Authority

Used to align place info with TMSThesaurus.Terms

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