0 - 31 of 31 tags for geospatial

I want to add a new SRS record to the table SYSSPATIAL.SPATIAL_REF_SYS. However, the manual doesn't have more description on it. There are 4 columns in the table:

SRID: Spatial reference system identifier.

AUTH_NAME: Name of the standard or standards body that is being cited for this reference system.

I downloaded this Geospatial Shapefile:
The table that was created by loading the shapefile looks like this:

Hello there,
I have table in Teradata Express that contains the countries of the world. The NAME column contains the country names and the GEOM colum contains their geographical information (the GEOM colum is of type ST_Geography). I created this table by importing a shapefile using Teradata's TDGeospatialImporter tool.

The Teradata Database provides a powerful and scalable platform for storing and processing geospatial data

TD Geo Import/Export tool lets you translate ESRI Shape and KML files to TD format.

I heard someone saying that Geospatial functions introduced TD13 onwards were available as external UDFs in the earlier versions. I have been asked to compare the metrics of using these External UDFs and native Geospatial features. My problem is that I have been looking for any examples of such external UDFs but have been unsuccessful.

Has anybody used TD geospatial features in TD12? we ran a POC of the features and noticed soem challenges

1. Geospatial queries are mostly single AMP queries (becasue of the usage of UDF)

2. Geospatial functions, use product joins to merge data from multiple shapes.

The Teradata Temporal feature, available with Teradata 13.10 allows the customer to capture, track, and analyze the full history of evolving business data rather than just the most current updates.

I am using the Geospatial Import-Export Utility (v1.6) for TD 13.0 to load shapefiles to Teradata.  When I run the utility to import a shapefile I get an error that says:

I have a problem using the TDGeoExport tool V1.6 with Teradata express 13.0. I am trying to export some locations (ST_Geometry points) from a Teradata database to KML format for visualising on Google Earth.

The TDGeoExport running script is as follows:-

I am relatively new to using geo functions but I want to make sure my places dimension table does not have any duplicates by doing a delta operation from the freshly geocoded records in my staging table.  First, I attempted to do a left outer join on the point_geo column:

Since Teradata first introduced native Geospatial capabilities in the database there have been inquiries about how to interoperate with the spatial data via client GIS and visualization tools.  In this article we are going to discuss how to view and edit spatial features and attributes maintained within Teradata in real-time by using the GeoServer web services.

I am trying to find out how to get the bounding box of several geometries in teradata. I am currently working with 13.00 and have tried the following:

select SYSSPATIAL.AggGeomUnion(cast(geom.ST_Envelope() as VARBYTE(64000))) from road;
select SYSSPATIAL.AggGeomUnion(geom.ST_Envelope()) from road;

both of these statements return a byte array which is not wkb. The docs says it is a varbyte and can be cast to an ST_Geometry which I tried with the following statment:

select cast(SYSSPATIAL.AggGeomUnion(cast(geom.ST_Envelope() as VARBYTE(64000))) as ST_GEOMETRY) from road;

I´m developing a GIS for a company and the coordinates are in UTM ED50(old standard in Europe) and and I need to turn to those used in Google maps ....... (WGS-84)

I've tried using the function:
ST_Transform (SRS_to.srtext, SRS_from.srtext)

SRS_to.srtext = WGS-84
SRS_from.srtext =UTM coordinates

Anyone integrated geospatial data into 3rd party tools such as Cognos or Microsoft? I've attempted with Microsoft, but must be missing something in how certain data types translate between the .NET provider and ReportBuilder 3.0.

Thanks in advance

How do I convert between different Geospatial coordinates? Is there a Teradata function that I can use?

For example, i have a coordinate of 24.3N 97.8W; How do I convert this to a regular lat/long value?

As Teradata customers discover and begin to utilize the native Teradata database geospatial capabilities, one of the first questions that inevitably comes up is, how do I “Geocode” my data?  In fact, Geocoding will often be an important first phase of any Geospatial implementation project and sometimes even a barrier to start the project all together.  The purpose of this article is to discuss what Geocoding is, how it works, Geocoding options, precision, and sources available today for Geocoded information.

Teradata has added geospatial features to Teradata 13 (and earlier versions with the optional extension package - see my earlier article here).  These features enable powerful location based analytics, but often I'm asked how to get start

Someone asked a few days ago for an easier and quicker way to calculate distance between two points on a sphere without having to transform to the UTM SRS (Spatial Reference System) from the WGS84 SRS.

This technical presentation offers a detailed walkthrough of Teradata's Geospatial features using basic geometry shapes. With points, lines and polygons, we demonstrate the power of our geospatial analytical functions using easy to understand SQL examples.

This presentation is an introduction to Teradata's geospatial features. Starting with a brief background to location data and the benefits that geo-location data provides over traditional addresses, we then discuss the powerful functionality now available with Teradata's new spatial data type and methods. The presentation demonstrates some examples of these features using SQL queries, some customer success stories, Teradata's geospatial EDW strengths and finally a view into Teradata's geospatial roadmap.

The availability of Teradata's geospatial extension package in 2007 brought these location capabilities to Teradata 12, 6.2 and 6.1.  This package is still available as a free download from Teradata and when installed, adds geospatial functionality as a User Defined Type (UDT) along with a library of User Defined Functions (UDFs).  (

Teradata Geospatial Import/Export utilities for Windows and Linux.

 The Teradata Geospatial Extension includes types, methods, functions, and utilities for loading, modeling, and analyzing spatial objects.

In my previous article we explored Teradata's spatial features using geometric shapes on a 10x10 grid.  I hope this was a useful introduction into the new ST_Geometry data type and its powerful set of functions.  And now that we've covered the basics, let's t

Now that you’ve installed Teradata’s geospatial features with Teradata Express let’s roll up our sleeves and see what we can do with this. (If you haven’t setup your TD Express with Geospatial yet, see my article.

The Teradata Geospatial Extension includes types, methods, functions, and utilities for loading, modeling, and analyzing spatial objects.

We’re in the midst of an explosion in the world of location data. GPS tools have greatly expanded our ability to capture location data and mapping tools have broadly expanded its use. We have Web navigation sites like Google Earth and Yahoo Maps. Our cars have navigation devices to keep us from getting lost.

Maybe your company is thinking of opening a new branch office if there are enough customers who live within the target area. Or maybe you want to let your customers know which of your stores they are closest to. Maybe you want to investigate the routes your delivery trucks take.

This UDF implements the great circle distance algorithm to determine the distance in miles between two points expressed in longitude and latitude. This distribution contains full source code, REPLACE FUNCTION SQL, a test suite and documentation.