Skip to content

esites module

Jump to bottom
Sharon Grant edited this page Apr 7, 2022 · 35 revisions

FAQ | Q&A | ISSUES

What does an esites record represent?

A record in the sites module represents a place and is a record of a position or point in space. There is no time element associated with a site record other than as a result of a place name no longer being used commonly. Detailed time elements such as collection date and/or chronostratigraphy should be captured at the catalogue level as part of a collection event or stratigraphy attachment

Tab Switching:

  • Column Name: SitRecordClassification
  • Lookup List: Site Record Classification
  • Tab switching: Yes

Record Types:

Aquatic

  • An aquatic site record refers to a place that is located within a body of water, freshwater or marine. If that place is maritime and falls outside of a national territorial boundary then the continent should be set to “International Waters”.

Cultural

  • A cultural site record refers to a place, region or area which has particular significance to a cultural group.

Terrestrial

  • A terrestrial site record refers to a place that falls on the land.

Record Structure:

Parent/Child; Hierarchical; Is a special case of a Parent/Child: Here there is a parent/child relationship inherent to the nature of the record and its data.The record itself inherits data from its parent and/or there may be logic that changes data, based on the presence of a parent/child attachment.

You can use them in combinations to fully document the place you are describing. There are four:

  • 2 Terrestrial
    • Political
    • Island
  • 2 Aquatic
    • Freshwater
    • Aquatic (Nautical/Maritime)

Fields

Mandatory

Unique

Ditto Skip

Insert Deafults

Query Defaults

Software Dependencies

Resources -> Tools

Summary String(s)

Requests and updates to the summary string should be submitted as issues and tagged esites. When approved they should be documented in structural changes.

Default

PolContinent + “, “ + PolPD1 + “ (“ + ClaCurrentNameRef.PolPD1 + “), ” + PolPD2 + “, “ + PolPD3 + “, “ + LocIslandGrouping + ”: “ + LocPreciseLocation

if LatCentroidLatitude0 OR LatCentroidLongitude0 is not NULL

THEN + “ [LL], “

if MapTRSTownship_tab is not NULL

THEN + “ [TRS], “

If PolPD1 = LocIslandGrouping OR LocIslandName DO NOT display PolPD1

If PolPD1 = United States of America THEN Replace with USA

e.g.(444953) - North America, USA, Indiana, Lake Co.: Gary, Portage Quadrangle. [LL] [TRS]
e.g. (587388) - Africa, Rhodesia (Zimbabwe)

Record Classification (SitRecordClassification)

= Aquatic

“[“+ SitSiteNumber +“] ” + ClaWaterbodyOcean + “, “ + ClaWaterbodyWB1 + “, “ + ClaWaterbodyWB2 + “, “ + ClaWaterbodyWB3 + “, “ + AquRiverBasin + “, “ + ClaFreshwaterRiver + “, “ + PolContinent + “, “ + PolPD1 + “ (“ + ClaCurrentNameRef.PolPD1 + “), “ + LocIslandGrouping + “, “ + LocIslandSubgroup + “, “ + LocIslandName + “: “ + LocPreciseLocation

if LatCentroidLatitude0 OR LatCentroidLongitude0 is not NULL

THEN + “ [LL], “

if MapTRSTownship_tab is not NULL

THEN + “ [TRS], “

If PolPD1 = LocIslandGrouping OR LocIslandName DO NOT display PolPD1

e.g.(577528) - [MW96-1] Pacific Ocean, Oceania, Vanuatu, Erromango: Dillon's Bay, 2 km along shore southwest of village

= Cultural

Default summary string (comma = primary separator except for site number which is enclosed by parentheses):

CulCulturalRegion + “, “ + LocSpecialGeographicUnit_tab + “, “ + LocIslandGrouping + “, “ + LocIslandName + “, “ + PolPD1 “ (“ + ClaCurrentNameRef.PolPD1 + “), “ + PolPD2 + “, “ + PolPD3 + “, “ + PolPopn + “, “ + LocNearestNamedPlace_tab + “, [“ + SitSiteName_tab + “ - “ + SitSiteNumber + “]: “ + LocPreciseLocation

if LatCentroidLatitude0 OR LatCentroidLongitude0 is not NULL

THEN + “ [LL], “

if MapTRSTownship_tab is not NULL

THEN + “ [TRS], “

If PolPD1 = LocIslandGrouping OR LocIslandName DO NOT display PolPD1

e.g. (427850) - Pacific, Micronesia, Marianas Islands, Saipan Island, Laulo I: below rock next to Latte 9, .9' below present ground level

e.g. (429314) - Pacific, Melanesia, Solomon Islands, San Cristobal Island, Melanesia

= Terrestrial

“[“+ SitSiteNumber +“] ” + PolContinent + “, “ + PolPD1 + “ (“ + NEW FIELD Current NameRef.PolPD1 + “), “ + PolPD2 + “, “ + PolPD3 + “, “ + LocIslandGrouping + “, “ + LocIslandName + “, “ +

If metres entered originally: If LocElevationASLFromMt = LocElevationASLToMt

LocElevationASLFromMt

Else LocElevationASLFromMt + “-” + LocElevationASLToMt + “m: ”

If feet entered originally: If LocElevationASLFromFt = LocElevationASLToFt

	LocElevationASLFromFt

Else LocElevationASLFromFt + “-” + LocElevationASLToFt + “ft: ”

THEN + LocPreciseLocation

if LatCentroidLatitude0 OR LatCentroidLongitude0 is not NULL

THEN + “ [LL], “

if MapTRSTownship_tab is not NULL

THEN + “ [TRS], “

If PolPD1 = LocIslandGrouping OR LocIslandName DO NOT display PolPD1

e.g. (303509) - [BS-2462] North America, Panama, Bocas del Toro, 1490m: Cerro Colorado cloud for., Qda. 3w

(302421) - [BS-1510] North America, Dominican Republic, La Vega, West Indies: PN. A. Bermudez, Cienaga [LL], 1000m

(42599) - [Myr-2677] North America, U.S.A., Michigan, Shiawassee: Sawyer Drain, Chipman Road, 4 mi N Owosso [LL], [TRS]

STRUCTURAL CHANGES: Rationale

Reason(s) for Change Request [version 2]

Status

  • Version 5.1
  • Funded - [In live]
  • FMNH Specific customisation

Details

  • Standardise the use of the module to make it more efficient and reflect consolidation of internal processes and workflows. Prepare for newer versions of EMu by not transferring bad data structures and dirty data.
  • Implement a parent/child structure that more closely ressembles a hierarchical taxonomic hierarchy. This will allow synonymization and better handling of equivalent names for example historical place names.
  • Allow us to rationalise and de-duplicate records
  • Fix existing bugs: ** ????

Field Museum EMu documentation repository 2021-

Clone this wiki locally