Re: [postgis-users] Geography type: centroids and distance?

2011-03-12 Thread fork
Sandro Santilli keybit.net> writes: > > > st_centroid(geography, geography) is not available > > You meant st_centroid(geography) I guess ? Duh, yes. st_distance(geography, geography) is avail just fine. It was late... ___ postgis-users ma

Re: [postgis-users] shp2pgsql character set conversions

2011-03-12 Thread Stephen Woodbridge
On 3/12/2011 3:21 AM, Sandro Santilli wrote: On Sat, Mar 12, 2011 at 12:57:50AM -0500, Stephen Woodbridge wrote: Hi All, I am trying to load a shpfile that is in UTF8, but there is some random character that is not. This is causing a load error and rollback on the transaction. I notice looking

Re: [postgis-users] Geography type: centroids and distance?

2011-03-12 Thread Sandro Santilli
On Sat, Mar 12, 2011 at 06:28:53AM +, fork wrote: > st_centroid(geography, geography) is not available You meant st_centroid(geography) I guess ? --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html _

Re: [postgis-users] shp2pgsql character set conversions

2011-03-12 Thread Sandro Santilli
On Sat, Mar 12, 2011 at 12:57:50AM -0500, Stephen Woodbridge wrote: > Hi All, > > I am trying to load a shpfile that is in UTF8, but there is some random > character that is not. This is causing a load error and rollback on the > transaction. > > I notice looking at: > > man 2 iconv_open > >