Creating square box polygon from Geography/Geometry Point

• darrin.wilkinson.66

  SSC Enthusiast

  Points: 195

  More actions

  November 19, 2012 at 1:23 pm

  #285122

  Hi,

  I have a set of world grid points (lat/long) values. For each point, I have a 'geography' point and a 'geometry' point representation.

  I would like to create a 10 km square ploygon around each point with the point being in the middle.

  I know that I can use STBuffer() to create a 10km circle around each point, but I need to create a 10 km square around each point.

  Anyone know how to do this using either the geography or geometry points?

  Thanks in advance,

  Darrin

• mickyT

  SSChampion

  Points: 10360

  More actions

  November 19, 2012 at 3:24 pm

  #1560543

  Hi Darrin

  Try the following

  SELECT geometrycolumn.STBuffer(5000).STEnvelope()

  FROM spatialtable

  This will only work with Geometries not Geographies. I could probably come up with something to do a rough extent on a geography if required.