I have a table (pubacc_lo) from the US government with 500,00+ rows. It has
latitude and longitude in three columns each for degrees, minutes and seconds.
I need a Point geometry column. So I wrote this query:
with mydata AS (SELECT (pubacc_lo.lat_degrees + pubacc_lo.lat_minutes/60 +
Thank you! That worked fine.
From: bricklen [mailto:brick...@gmail.com]
Sent: Friday, August 23, 2013 10:08 AM
To: Hall, Samuel L (Sam)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Update quey
On Fri, Aug 23, 2013 at 8:04 AM, Hall, Samuel L (Sam)
sam.h...@alcatel
On Fri, Aug 23, 2013 at 8:04 AM, Hall, Samuel L (Sam)
sam.h...@alcatel-lucent.com wrote:
I have a table (pubacc_lo) from the US government with 500,00+ rows. It
has latitude and longitude in three columns each for degrees, minutes and
seconds. I need a Point geometry column. So I wrote this
