Table of Contents

Property ImportCastGeo

Namespace
YndigoBlue.Velocity.Data.Teradata
Assembly
YndigoBlue.Velocity.dll

ImportCastGeo

Gets or sets whether geospatial columns are converted to VARCHAR before import operations.

public bool ImportCastGeo { get; set; }

Property Value

bool

Remarks

When enabled (default), geospatial geometries are converted from Well-Known Text (WKT) format to VARCHAR during import, significantly improving import performance.

Trade-off:

  • Enabled (True - Default): Much faster imports for spatial data, but complex geometries with many coordinate points may be truncated if their WKT representation exceeds VarCharCastSize (default 32,000 characters). Works for most real-world geometries (polygons, linestrings, etc.).
  • Disabled (False): Slower imports, but handles geometries of any complexity without truncation. Use for datasets with very complex or detailed geometries (high-resolution satellite data, intricate coastlines).

Recommendation: Keep enabled for performance. Only disable if you encounter geometry truncation errors during import.