Friday, February 1, 2013

How to convert latitude and longitude to Geometry Point in Postgres?

Inroduction:

Here I will explain how to convert lat, long values into geometry format and insert it in PostgreSQL. Using ST_GeomFromText() function we get the geometry data in PostgreSQL. 

convert lat, long values into geometry format and insert in PostgreSQL database.

For example:

ST_GeomFromText('POINT(" + Longitude + " " + Latitude  + ")',4326)

No comments :

Post a Comment