data (#23) - How to convert (x,y) coordinates to geometry (#248) - Message List
How to convert (x,y) coordinates to geometry
What's formula convert (x,y) coordinates to geometry coordinates. Example: I want convert from (3,4) to ("0101000020E6100000A054FB0462532241350C1F09EA2D3241") in data table
lanhlung696
04/16/09 10:51:14 (19 months ago)
-
Message #883
Did you ever take a look at PostGIS documentation or tutorials. This question again isn't a pgRouting related one.
Well, this is the link to the PostGIS docs: http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2747038
ST_GeomFromText(text,[<srid>])
for example
ST_GeomFromText('POINT(3 4)',4326)
daniel04/16/09 15:17:35 (19 months ago)