Touchstone 4.0 Database Documentation
tECARingLocationList Table
Description
Stores information about the locations included in the Geospatial analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AnalysisSID

Unique system-generated sequential identifier for the analysis  record.

For a complete list of records, see tAnalysis Table.

Integer4   
Primary Key LocationIDUnique user-defined identifier for the location.Integer4   
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4  
 LocationNameUser-defined name for the location.VarChar255  
 CRESTANameCRESTA name.VarChar255  
 CountryNameName of the country.VarChar255  
 AreaCode

Area code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

VarChar15  
 CRESTACode

CRESTA code for the location, when applicable.

For a complete list of codes, see tGeography Table.

VarChar15  
 AreaNameName of the area.VarChar255  
 SubAreaCode

Subarea code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 SubAreaNameName of the subarea.VarChar255  
 PostalCode

Postal code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 PostalNameName for the postal code.VarChar255  
 CityName of the city.VarChar255  
 AddressStreet address for the location.VarChar255  
 LatitudeLatitude coordinate for the location. Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (9,6)  
 LongitudeLongitude coordinate for the location. Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian.Numeric9 (9,6)  
 GeoMatchLevelCode

Code for the level at which geocode match occurred.

For a complete list of codes, see tGeoMatchLevel Table.

VarChar10  
Objects that tECARingLocationList depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.1
tDataServer tabletDataServerTableStores information about each data server used in the project, including its sequential identifier (SID), name, description, connection information, and default MDF and LDF paths.3
tDataSource tabletDataSourceTableStores information about the data source used for the Touchstone project. A data source is a database that is registered with the Touchstone application.2
tECARingOption tabletECARingOptionTableStores information about the ring options selected for the Geospatial analysis.3
tExposureConcentrationAnalysisOption tabletExposureConcentrationAnalysisOptionTableStores the options used during a Geospatial analysis.2
tProject tabletProjectTableStores information regarding the project, such as project name and status code.1
See Also

Related Objects

AIRProject Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.