Geography Reference
In-Depth Information
Testing the Output Functions
Let's try the following:
SELECT * FROM ukcitys LIMIT 5
You should receive something like the following output:
Figure 49: Data Output with Binary Geometry
As you can see, the
geometry
column is displayed in its binary form, which may or may not
be in WKB format.
Now let's try this:
SELECT gid,number,name,admin_name,AsText(geometry) FROM ukcitys LIMIT 5
You should receive the following:
Figure 50: Data Output with Text Geometry
As shown in the previous figure, the output is in WKT format with the coordinates in meters
since we're using OSGB36 as the SRID.
Let's swap
AsText
for
AsEWKT
. We should get the following:
