I have run the postgis_upgrade_14_to_15.sql against the 8.4.1 database and
installed postgis-1.5.3 into the 9.0.4 database.
Is anything else required before running pg_upgrade?
Cheers and thanks,
Stephen
On Friday 21 October 2011 11:16:47 Paragon Corporation wrote:
> Steve,
>
> Haven't tried
Is there an easy way to convert data stored in lat/lon/alt to ECF
coordinates?
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
On Fri, Oct 21, 2011 at 03:54:28PM +0800, Ben Madin wrote:
> Thanks strk,
>
> but I'm still confused. If I don't select the .geom component, I can't
> dumprings... when I do, I end up with 90 rows in a table of geometry dumps.
>
> # select id, (the_geom).path, st_astext((the_geom).geom) from phl
Thanks strk,
but I'm still confused. If I don't select the .geom component, I can't
dumprings... when I do, I end up with 90 rows in a table of geometry dumps.
# select id, (the_geom).path, st_astext((the_geom).geom) from phl2 where id =
58;
id | path |
I've tried to increase the cost of _ST_Buffer and _ST_Overlaps
function but without success.
Then, I've tried to lower the cost of ST_Buffer to 1 and the index is used.
Now I'll try to see if it works for others queries (stored in views in
my database).
Many thanks for your hints Regina, it helps
On Fri, Oct 21, 2011 at 01:33:43PM +0800, Ben Madin wrote:
> But rebuilding the multipolygons is not so simple (for me) - I need to
> re-aggregate the remaining rings into a geometry dump to reinsert into the
> other dumped polygons to rebuild the multipolygon.
...
> insert into phl (the_geom)
