[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] POINT/MULTIPOINT EMPTY problem in dump
From: Jan_Michálek <godzilalalala () gmail ! com>
Date: 2016-05-23 14:14:27
Message-ID: CAAYBy8bGaJVR0bHxMux+tWg0bV3N5S-Nv+DW4zJYhiPJoowhRQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
My trick with EWKT doesn't help, but your advice help me.
Thanks Je;
2016-05-23 13:22 GMT+02:00 Leknín Řepánek <godzilalalala@gmail.com>:
> Hm, maybe i can use EWKT notation instead of binary.
>
> On Sun, May 22, 2016 at 06:10:46PM -0700, Paul Ramsey wrote:
> > Temporarily change column type of the table you're loading from
> > Geometry(Point) to just plain Geometry, then you can load both types
> > and then change the MULTIPOINT EMPTY to POINT EMPTY then change the
> > type back to Geometry(Point)
> >
> > P
> >
> > On Sun, May 22, 2016 at 2:19 PM, Jan Michálek <godzilalalala@gmail.com>
> wrote:
> > > I need to solve this problem
> > >
> > > I have in table column POINT, some of values ARE 'POINT EMPTY' (dont
> ask me
> > > why, it is not my table).
> > > MULTIPOINT EMPTY and POINT EMPTY has same representation
> > > (010400000000000000).
> > > If i try restore table from dump, it is problem because postgis read
> this as
> > > multipoint empty, but the column has type POINT.
> > > My version of postgis
> > >
> > > jelen=# select postgis_version();
> > > postgis_version
> > > ---------------------------------------
> > > 2.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
> > > (1 row)
> > >
> > > Postgre is 9.3.
> > >
> > > Is there somebody who knows how to solve this problem?
> > >
> > > Thanks Je;
> > >
> > > ----------
> > > jelen=# CREATE TABLE t3 (id serial primary key, geom geometry(POINT,
> 0));
> > > CREATE TABLE
> > > jelen=# insert into t3(geom) VALUES ('POINT EMPTY'::geometry);
> > > INSERT 0 1
> > > jelen=# SELECT geom from t3;
> > > geom
> > > --------------------
> > > 010400000000000000
> > > (1 row)
> > >
> > > jelen=# SELECT ST_AsText('010400000000000000');
> > > st_astext
> > > ------------------
> > > MULTIPOINT EMPTY
> > > (1 row)
> > >
> > > jelen=# INSERT INTO t3(geom) values('010400000000000000');
> > > ERROR: Geometry type (MultiPoint) does not match column type (Point)
> > > jelen=# insert into t3(geom) SELECT geom FROM t3;
> > > INSERT 0 1
> > > jelen=#
> > > -------------------------------
> > >
> > >
> > > --
> > > Jelen
> > > Starší čeledín datovýho chlíva
> > >
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users@lists.osgeo.org
> > > http://lists.osgeo.org/mailman/listinfo/postgis-users
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users@lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/postgis-users
>
--
Jelen
Starší čeledín datovýho chlíva
[Attachment #5 (text/html)]
<div dir="ltr"><div>My trick with EWKT doesn't help, but your advice help \
me.<br><br></div>Thanks Je;<br></div><div class="gmail_extra"><br><div \
class="gmail_quote">2016-05-23 13:22 GMT+02:00 Leknín Řepánek <span \
dir="ltr"><<a href="mailto:godzilalalala@gmail.com" \
target="_blank">godzilalalala@gmail.com</a>></span>:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><span class="im HOEnZb">Hm, maybe i can use EWKT notation \
instead of binary.<br> <br>
On Sun, May 22, 2016 at 06:10:46PM -0700, Paul Ramsey wrote:<br>
</span><div class="HOEnZb"><div class="h5">> Temporarily change column type of the \
table you're loading from<br> > Geometry(Point) to just plain Geometry, then \
you can load both types<br> > and then change the MULTIPOINT EMPTY to POINT EMPTY \
then change the<br> > type back to Geometry(Point)<br>
><br>
> P<br>
><br>
> On Sun, May 22, 2016 at 2:19 PM, Jan Michálek <<a \
href="mailto:godzilalalala@gmail.com">godzilalalala@gmail.com</a>> wrote:<br> > \
> I need to solve this problem<br> > ><br>
> > I have in table column POINT, some of values ARE 'POINT EMPTY' \
(dont ask me<br> > > why, it is not my table).<br>
> > MULTIPOINT EMPTY and POINT EMPTY has same representation<br>
> > (010400000000000000).<br>
> > If i try restore table from dump, it is problem because postgis read this \
as<br> > > multipoint empty, but the column has type POINT.<br>
> > My version of postgis<br>
> ><br>
> > jelen=# select postgis_version();<br>
> > postgis_version<br>
> > ---------------------------------------<br>
> > 2.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1<br>
> > (1 row)<br>
> ><br>
> > Postgre is 9.3.<br>
> ><br>
> > Is there somebody who knows how to solve this problem?<br>
> ><br>
> > Thanks Je;<br>
> ><br>
> > ----------<br>
> > jelen=# CREATE TABLE t3 (id serial primary key, geom geometry(POINT, \
0));<br> > > CREATE TABLE<br>
> > jelen=# insert into t3(geom) VALUES ('POINT EMPTY'::geometry);<br>
> > INSERT 0 1<br>
> > jelen=# SELECT geom from t3;<br>
> > geom<br>
> > --------------------<br>
> > 010400000000000000<br>
> > (1 row)<br>
> ><br>
> > jelen=# SELECT ST_AsText('010400000000000000');<br>
> > st_astext<br>
> > ------------------<br>
> > MULTIPOINT EMPTY<br>
> > (1 row)<br>
> ><br>
> > jelen=# INSERT INTO t3(geom) values('010400000000000000');<br>
> > ERROR: Geometry type (MultiPoint) does not match column type (Point)<br>
> > jelen=# insert into t3(geom) SELECT geom FROM t3;<br>
> > INSERT 0 1<br>
> > jelen=#<br>
> > -------------------------------<br>
> ><br>
> ><br>
> > --<br>
> > Jelen<br>
> > Starší čeledín datovýho chlíva<br>
> ><br>
> > _______________________________________________<br>
> > postgis-users mailing list<br>
> > <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> > <a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" \
rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" \
rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><div \
class="gmail_signature"><div dir="ltr"><div>Jelen<br></div>Starší čeledín \
datovýho chlíva<br></div></div> </div>
[Attachment #6 (text/plain)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic