TMS to CSpace Places crosswalk

Table

Columns

CSpace destination

Cleaned?

Migrated?

Mapping

Notes

AltNums

EnteredDate—?—————

ID 3• Custom field needed? see notes ——>LoginID—?—no

Remarks• Custom field needed?

EnteredDate—?—————

ExhVenueXrefIDLocationIDLoginID—?—no

EnteredDate—?—————

ExhVenueXrefIDLoginID—?—no

SysTimeStamp—?—————

ApprovedConstituentIDContactEnteredDate—?—————

ExhibitionIDLoginID—?—no

RemarksExhibition Authority Schema:_____SysTimeStamp—?—————

EnteredDate————————

GeoCodePlace Authority: Place name typeLoginID————————

SysTimeStamp—?—————

MTB_PlaceTermIDObject collection information: Field collection place: Place Authority: Place namepopulate

Provenancealign with Terms

ContinentPlace Authority: Place name (if terminal node when authority is made hierarchical)CountryPlace Authority: Place name (if terminal node when authority is made hierarchical)CountyPlace Authority: Place name (if terminal node when authority is made hierarchical)EnteredDate—?—————

GeoCodeIDPlace Authority: Place name typeLoginID—?—no

MTB_PlaceTermIDObject collection information: Field collection place: Place Authority: Place namepopulate

RegionPlace Authority: Place name (if terminal node when authority is made hierarchical)StatePlace Authority: Place name (if terminal node when authority is made hierarchical)SubRegionPlace Authority: Place name (if terminal node when authority is made hierarchical)SysTimeStamp—?—————

SiteClassification

DateBegSearchDateEndSearchDateTextDayBegSearchDayEndSearchEnteredDate—?—————

EventTypeLoginID—?—no

MonthBegSearchMonthEndSearchRemarksSiteIDSysTimeStamp—?—————

EnteredDate—?—————

LoginID—?—no

SiteGeoCodeSysTimeStamp—?—————

CityPlace Authority: Place name (if terminal node when authority is made hierarchical)Concession————move 2 notes elsewhere

ContinentPlace Authority: Place name (if terminal node when authority is made hierarchical)CountryPlace Authority: Place name (if terminal node when authority is made hierarchical)CountyPlace Authority: Place name (if terminal node when authority is made hierarchical)CulturalRegion• Schema extension/ custom field neededElevationPlace Authority: Place coordinates ?EnteredDate—?—————

GeoCodeIDPlace Authority: Place name typeLatitudePlace Authority: Place coordinatesLocalePlace Authority: Place name (if terminal node when authority is made hierarchical)LoginID—?—no

LongitudePlace Authority: Place coordinatesLot————MapReferenceNumberPlace Authority: Place coordinatesremove "29N 7E"

MTB_PlaceTermIDObject collection information: Field collection place: Place Authority: Place namepopulate

NationPlace Authority: Place name (if terminal node when authority is made hierarchical)NotesPlace Authority: Place notePoliticalRegion• Schema extension/ custom field needed?PrimaryDisplayRegionPlace Authority: Place name (if terminal node when authority is made hierarchical)RegionalCorp————needs cleaning

River• Schema extension/ custom field needed?SiteID————StatePlace Authority: Place name (if terminal node when authority is made hierarchical)SubContinentPlace Authority: Place name (if terminal node when authority is made hierarchical)SubRegionPlace Authority: Place name (if terminal node when authority is made hierarchical)SysTimeStamp—?—————

TownshipPlace Authority: Place name (if terminal node when authority is made hierarchical)UTMPlace Authority: Place coordinates ?VillageCorporation————merge with TMS.CulturalRegion

EnteredDate—?—————

LoginID—?—no

RemarksObject collection information: Field collection noteSiteIDObject collection information: Field collection placeSubsite1Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null)Subsite2Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null)Subsite3Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null)SysTimeStamp—?—————

EnteredDate—?—————

LoginID—?—no

ReferenceIDRemarksSiteIDSysTimeStamp—?—————

Active—?—DescriptionEnteredDate—?—————

HistoricalNotesIsPublic—?—LocationNotesLoginID—?—no

MTB_PlaceTermIDObject collection information: Field collection place: Place Authority: Place namepopulate

RemarksResearchActivityResearcherCommentsSiteClassificationIDSiteNameSiteNumberSiteStatusIDSiteTypeIDSysTimeStamp—?—————

SiteStatus

EnteredDate—?—————

LatitudeLatitudeDirectionLatitudeNumberLoginID—?—no

LongitudeLongitudeDirectionLongitudeNumberTermMasterID

AuthorConIDID 7LoginID—?—no

MTB_PlaceTermIDObject collection information: Field collection place: Place Authority: Place namepopulate

PurposeRemarksTextDateObject Description Information:Inscription content:Inscription dateTextEntryObject collection information: Field collection noteObject collection information: Field collection noteObject collection information: Field collection place?Object collection information: Field collection place: Place Authority: Place nameObject collection information: Field collection noteTextStatusID


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.


ExhVenLocXrefs
			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.
GeoCodes
			————	————	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


ObjGeography






			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.
SiteClassifications

SiteDates










			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.
SiteGeoCodes
			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.
SiteGeography


			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
SiteObjXrefs
			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.
Sites
				—?—



			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.
SiteStatuses

TermMasterGeo
			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.








TextEntries
				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