[postgis-users] About Invalid OGC WKT Error

[Koji Yano]

Thanks for replies! Und vielen dank!

> Did you also upgrade postgis scripts ?
> Can you show the output of SELECT postgis_full_version() ?
> --strk;

I loaded lwpostgis.sql to my database.
Do I need to upgrade another scripts?
Here is the output of SELECT postgis_full_version.

# select postgis_full_version();
                                    postgis_full_version
--------------------------------------------------------------------------------------------
 POSTGIS="1.0.0RC2" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS
DBPROC="0.1.0" RELPROC="0.1.0"
(1 row)

> This is caused by the change of the canonical representation in
> PostGIS 1.0.
> All applications that use PostGIS specific ways to acces the GIS
> data instead of standard OpenGIS methods will have to be fixed to work
> with PostGIS 1.0.

> HTH,
> Markus

So do I have to wait aplications like QGis to be fixed...?



Guillaume SUEUR Write:
> If you type "select AsText(the_geom)..." what does it give ?

Here is an output example.
# select astext(the_geom) from gisdatatable where gid=1;











                             astext
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 MULTIPOLYGON(((141.035285377798 45.4507354457091,141.032958339858
45.4610162489808,141.045848615774 45.4539431035632,141.067446903638
45.4241639435773,141.062595100902 45.4221717163604,141.056538079865
45.4064737088129,141.058535244559 45.3966829368604,141.054612589546
45.3889056878123,141.059839162516 45.3726268545911,141.059363349557
45.3515872077209,141.049321654719 45.3395223170193,141.056692145358
45.3193556419327,141.04902910682 45.3011413822968,141.044472448689
45.2979601730628,141.046357215354 45.2779280443239,141.042963667653
45.2740091757784,141.026810623885 45.2733924679721,141.015934178811
45.2840028147885,141.025733236061 45.2913415037452,141.022971765628
45.3090304072433,141.002572686158 45.3281468757037,141.003874097059
45.3355115895582,140.999437291206 45.3516080211105,140.983159922735
45.3794214592879,140.983645570306 45.3838827925359,140.990745575141
45.3861049857612,140.984850681887 45.3982041462972,140.991594093426
45.4069056447536,140.990404524719 45.4108027485794,140.984432787776
45.4106376332912,140.986524285306 45.4140878387132,140.982600936686
45.4148254664823,140.992617136244 45.4178376305474,140.994274328606
45.4239177333574,140.982555807873 45.4353006065475,140.966428710639
45.4390669232697,140.976913242282 45.4470829227784,140.966010892091
45.4570552907577,140.967277683122 45.4641638874124,140.979785808854
45.453779334493,140.981088081262 45.4487669317952,140.985549560962
45.4474000820403,140.985376208266 45.4434985962787,141.003309418124
45.4339344207041,141.018152413709 45.4335922419942,141.033298682861
45.4388615838839,141.037768534202 45.4428197807109,141.035285377798
45.4507354457091)))
(1 row)


Is there any problems ?

Koji Yano
http://www.officeyano.net