PTV Group - Logistics Forum

Hello there,

I hope this is the right topic

In Microsoft SQL Server Management Studio I have a database with a table that contains Geo-Coordinates (x/y).

Are there experiences / examples of how these coordinates can be enriched within SQL by using xServer (country, city, postcode)?
For example by using a procedure?

Thanks a lot for any feedback

Best regards
Max Beermann

Hello Max,

I have no experience doing this directly in SQL server. All the software designs i have encountered always do this in middle ware since it usually has more powerful tools for handling web connections.

With regards,
Joost

Hello Max,

I once did this in the early 2000nds. Have no source to provide.
Worked within a trigger so each
- insert
- update on address columns
Was used to perform a call to the geocoding interface.
Honestly spoken this was more a nice experiment than a real need. Therefore I agree with Joost: use the DB as a storage and an application layer to provide a frontend.
Best regards from Austria
Bernd
Ps we implemented a user defined function in T-SQL which created clients through a DLL. This shows how old school this approach is.

Hey there,

thanks for your feedback!
I will keep you informed, in case I have a solution / a need

Best regards (to Austria, Germany, anywhere in the world)
Max