On Saturday, April 28, 2012 12:03:09 PM UTC-7, pcr...@pcreso.com wrote:
>
> Hi Shaun,
>
> You add a geometry column to the table, then run an update sql to populate
> it.
>
> eg, assuming your table is called mytable, located in the public schema, &
> you want to create a two dimensional point wi
on, lat),4326);
Note that if you are doing any spatial queries (such as point in polygon, etc),
that you should also add a spatial index to this column.
HTH,
Brent Wood
--- On Sun, 4/29/12, Shaun Langley wrote:
From: Shaun Langley
Subject: [postgis-users] Adding geometry to an existin
Thanks! I'll try that in a minute and see if it works!
Regards,
Shaun
On Apr 28, 2012, at 2:57 PM, Puneet Kishor wrote:
>
> On Apr 28, 2012, at 1:34 PM, Shaun Langley wrote:
>
>> I got myself into quite a mess and I'm hoping somebody out there can help
>> me. I've created a database that in
On Apr 28, 2012, at 1:34 PM, Shaun Langley wrote:
> I got myself into quite a mess and I'm hoping somebody out there can help me.
> I've created a database that includes in the range of 150 million records so
> far and I need to make a change to it. I have lat lon fields stored as
> strings in
I got myself into quite a mess and I'm hoping somebody out there can help me.
I've created a database that includes in the range of 150 million records so
far and I need to make a change to it. I have lat lon fields stored as strings
in separate columns. What I would like to do is to take these