[postgis-users] Upgrading from PostgreSQL 8.0 with PostGIS 0.9 to PostgreSQL 8.1 with PostGIS 1.0

strk at refractions.net strk at refractions.net
Sat Jan 21 00:28:40 PST 2006


On Fri, Jan 20, 2006 at 04:08:58PM -0300, Mario Servin wrote:
> By the way Stephen, it seems that there's something missed at the new
> the_geom column:
> in older versions geometry data was stored as
> SRID=-1;POINT(-66.046532 -21.951437)
> Now the select asewkt shows the following:
> POINT(-66.046532 -21.951437)
> What happens with SRID?

Standard WKT does not include SRID.
We consider that an extension, thus *E*WKT,
which is returned by asEWKT()
OGC-standard asText() function now returns 
conforming WKT.

--strk;

> 
> 
> On 1/20/06, Mario Servin <mservin at gmail.com> wrote:
> >
> > Thanks Stephen! now I can see them!!. How can I change the default
> > behavior for seeing as simple text ?
> >
> > On 1/20/06, Stephen Woodbridge <woodbri at swoodbridge.com> wrote:
> > >
> > > Mario Servin wrote:
> > > > Hi everybody,
> > > >
> > > [snip]
> > > >
> > > > Additionally, I still have the results from the old shp2pgsql and so I
> > >
> > > > tried to insert the data form psql using \i mysqlinsertionscript.sql.
> > > > Tables are created ok, but geom columns results in meaningless
> > > > characters where it is supossed to be something like "POINT (-
> > > 66.046532
> > > > -21.951437)" for example.
> > >
> > > The default behavior changed. Try:
> > >
> > > select aswkt(the_geom) from table;
> > >
> > > the default is to display the geometry in a hex representation of the
> > > binary.
> > >
> > > -Steve W.
> > >
> > > > Can anybody help me?.
> > > > Regards,
> > > >             Mario Servin
> > > >
> > > >
> > > >
> > > ------------------------------------------------------------------------
> > > >
> > > > _______________________________________________
> > > > postgis-users mailing list
> > > > postgis-users at postgis.refractions.net
> > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > >
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users at postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > >
> >
> >

> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for low technology.
  X     Keep e-mail messages readable by any computer system.
 / \    Keep it ASCII. 




More information about the postgis-users mailing list