DSXchange

Hi,
I have columns with valuse as longitude and latitude.
we need to handle this in data stage as geographical datatype and not as varchar or char.
Could you pleae help on this


Thanks
Sudhir

What do you mean here by "geographical datatype"? Something specific to a software package? The geocodes (lat/long) I've dealt with in the past are simple decimal values with a scale of 5 or 6, from what I recall.

I usually encounter them as Decimal(7,3) or subrecord containing degrees, minutes, seconds and direction. In N years of working with databases I have not encountered a data type called Geographical (though QualityStage does have a GeoMatch matching technique).

What I've encountered working with the likes of Google and Yahoo is apparently known as "Signed Degrees format" as noted here.