Table of Contents

Property TargetSpatialReference

Namespace
YndigoBlue.Velocity.Connections
Assembly
YndigoBlue.Velocity.dll

TargetSpatialReference

Gets or sets the target spatial reference system (SRS) in Well-Known Text (WKT) format for coordinate transformations.

public string TargetSpatialReference { get; set; }

Property Value

string

Examples

NAD27 California Albers WKT (default):

PROJCS["NAD27 / California Albers",GEOGCS["NAD27",DATUM["North_American_Datum_1927",
SPHEROID["Clarke 1866",6378206.4,294.9786982139006]],PRIMEM["Greenwich",0],
UNIT["degree",0.01745329251994328]],PROJECTION["Albers_Conic_Equal_Area"],
PARAMETER["standard_parallel_1",34],PARAMETER["standard_parallel_2",40.5],
PARAMETER["latitude_of_center",0],PARAMETER["longitude_of_center",-120],
PARAMETER["false_easting",0],PARAMETER["false_northing",-4000000],UNIT["metre",1]]

Generated SQL example for distance calculation:

geometry1.ST_TRANSFORM(1619, '{TargetSpatialReference}', '{SourceSpatialReference}')
         .ST_Distance(geometry2.ST_TRANSFORM(1619, '{TargetSpatialReference}', '{SourceSpatialReference}'))
         / conversion_factor

Remarks

Used by Teradata's ST_TRANSFORM function when performing metric calculations (distance, area, length, buffer) with units of measure. This must be a projected coordinate system that uses meters as the unit, enabling accurate metric-based spatial operations.

Default: NAD27 / California Albers (EPSG:2163 variant) - a projected coordinate system using meters.

The transformation workflow is:

  1. Transform geometry from SourceSpatialReference to TargetSpatialReference
  2. Perform metric calculation (e.g., ST_Distance, ST_Area, ST_Length, ST_Buffer)
  3. Convert result from meters to requested unit of measure
  4. For buffer operations, transform back to SourceSpatialReference