Re: [Dxf2postgis-discussion] New User

[Astrid E. (WhereGroup) <ast...@wh...>]

Hi Bob,


Bob Pawley schrieb:
> Thanks Guglielmo
>
> When I process a drawing of a single line the geometry column of the *_lin 
> table has the following :
> 0105000000010000000102000000020000000000000000003E400000000000004E400000000000003E400000000000004E40
>
> Is there any documentation that can help me understand the signifigance of 
> this set of characters??
>
> Bob

PostgreSQL/PostGIS stores geometries in WKB-format  (Well-known binary). 
I f you want to see the geometry as WKT (Well-known text) which is human 
readle use the following SQL:

Select asText(the_geom) from mytable;

Select asEWKT(the_geom) from mytable; (gives you uinformatin about the 
SRID too)

For more information about PostGIS have a look at the documentation. 
There you will find all you need:

http://postgis.refractions.net/documentation/

greetings astrid