| From: | "Hall, Samuel L (Sam)" <sam(dot)hall(at)alcatel-lucent(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Update quey |
| Date: | 2013-08-23 15:04:11 |
| Message-ID: | 69751890A64B3241A83BDB52A30BF29D0EB9C3@US70UWXCHMBA05.zam.alcatel-lucent.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 + pubacc_lo.lat_seconds/3600) as lat , (pubacc_lo.long_degrees + pubacc_lo.long_minutes/60 + pubacc_lo.long_seconds/3600) as long FROM pubacc_lo)
UPDATE pubacc_lo SET lonlat_84 = ST_SetSRID(ST_makePOINT(long,lat),4326) FROM mydata;
It appears to work, but is going to take days it seems to finish. Anybody have a faster way?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bricklen | 2013-08-23 15:08:06 | Re: Update quey |
| Previous Message | David Johnston | 2013-08-23 14:32:47 | Re: Column names for INSERT with query |