Vertica place - create a circle with 10km of radius

Hi, I'm dealing with Vertica place and differences between geography and geometry types.

 

I'm using ST_Buffer to build a circle around a geographycal point: 

ST_Buffer( g, d ) 

g can be only a geometry 

d is expressed in cartesian coordinate units, not in meter/kilometers

 

Anyone knows how to write ST_Buffer statemet to create a circle with a radius of 10km? 

 

Thanks,

Vivian.

Comments

  • Hi Vivan,

     

    As you pointed out, ST_Buffer does not support GEOGRAPHY data types. Is there a specific reason you are using GEOGRAPHY data over GEOMETRY? The reason I ask is because if you used the GEOMETRY data type instead of GEOGRAPHY you wouldn't lose a ton of accuracy with a 10km polygon. It might be worth considering. Especially if you are do computations on a small area, e.g. a city like Boston.

     

    Let me know if this works for you, or if you have any other questions.

     

     

    -C

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.