Stores information about the locations included in the Geospatial analysis.
Touchstone 2022 Database Reference
tECARingLocationList Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | AnalysisSID | Unique system-generated sequential identifier for the analysis record. For a complete list of records, see tAnalysis Table. | int | 4 | |||
| | LocationID | Unique user-defined identifier for the location. | int | 4 | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 |  | |||
| LocationName | User-defined name for the location. | varchar | 255 | | |||
| CRESTAName | CRESTA name. | varchar | 255 | | |||
| CountryName | Name of the country. | varchar | 255 | | |||
| AreaCode | Area code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| CountryCode | ISO 2-character code for the country in which the location resides. For a complete list of codes, see tCountry Table. | varchar | 15 | | |||
| CRESTACode | CRESTA code for the location, when applicable. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| AreaName | Name of the area. | varchar | 255 | | |||
| SubAreaCode | Subarea code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| SubAreaName | Name of the subarea. | varchar | 255 | | |||
| PostalCode | Postal code for the location. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| PostalName | Name for the postal code. | varchar | 255 | | |||
| City | Name of the city. | varchar | 255 | | |||
| Address | Street address for the location. | varchar | 255 | | |||
| Latitude | Latitude coordinate for the location. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (9,6) | | |||
| Longitude | Longitude 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. | numeric | 9 (9,6) | | |||
| GeoMatchLevelCode | Code for the level at which geocode match occurred. For a complete list of codes, see tGeoMatchLevel Table. | varchar | 10 | | |||
| UserGeoMatchLevel | User-specified geocode match level. | varchar | 60 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysis | Table | Stores information about each analysis. | 3 |
| tDataServer | Table | Stores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server. | 5 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 4 |
| tECARingOption | Table | Stores information about the ring options selected for the Geospatial analysis. | 1 |
| tExposureConcentrationAnalysisOption | Table | Stores the options used during a Geospatial analysis. | 2 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 5 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 4 |