Articles in this section

What is the wkb_geometry field?

Daniel Caldwell
  • Updated
Follow

When you import data by uploading it to AmigoCloud, the default name for the field in the database that contains the geometry is called 'wkb_geometry' 

It is a very common name that is used in Open Source applications to give you a hint that field contains a Well Known Binary. That is, to imply that, you can use any of the postgis wkb operators.

 
That means that you can use the SQL operators on it, for example:
 
    SELECT st_buffer(wkb_geometry, 0.001) from dataset_<number>;
 
    SELECT st_centroid(wkb_geometry) from dataset_<number>;
 
And any of the hundreds of operators described above.

Comments

0 comments

Please sign in to leave a comment.