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:
https://www2.census.gov/geo/tiger/TIGER2015/UAC/
 
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.

Hi,
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.

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:
    
 

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?