[mapserver-users] MULTIPOINT and POINT in same geometry column
Hello all, Is there any way to append 'MULTIPOINT' shape files and 'POINT' shape files into same table with a geometry column ? I guess the geometry column should be 'MULTIPOINT' geometry-type, and the 'POINT' shape should be translated 'MULTIPOINT' (but only one point in one record)in the appending process. Any suggestions ? I'm using - PostgreSQL 8.0.3 - PostGIS 1.1.3 - Mapserver 4.10 Thanks, Isao Nasuno ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] MULTIPOINT and POINT in same geometry column
Hi, You can add a geometry column column of type geometry itself instead of fixing it as point or multipoint.This will support all types of geometry in one table. Regards, Subha NASUNO Isao wrote: > Hello all, > > Is there any way to append 'MULTIPOINT' shape files and 'POINT' shape files > into > same table with a geometry column ? > > I guess the geometry column should be 'MULTIPOINT' geometry-type, > and the 'POINT' shape should be translated 'MULTIPOINT' (but only one point > in one record)in the appending process. > > Any suggestions ? > > I'm using > - PostgreSQL 8.0.3 > - PostGIS 1.1.3 > - Mapserver 4.10 > > Thanks, > > Isao Nasuno > > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] MULTIPOINT and POINT in same geometry column
Hi Subha, So easy ! I'll try it. Thanks for your quick response. Isao Subha Ramakrishnan wrote: > Hi, > You can add a geometry column column of type geometry itself instead of > fixing it as point or multipoint.This will support all types of geometry > in one table. > > Regards, > Subha > > > NASUNO Isao wrote: >> Hello all, >> >> Is there any way to append 'MULTIPOINT' shape files and 'POINT' shape files >> into >> same table with a geometry column ? >> >> I guess the geometry column should be 'MULTIPOINT' geometry-type, >> and the 'POINT' shape should be translated 'MULTIPOINT' (but only one point >> in one record)in the appending process. >> >> Any suggestions ? >> >> I'm using >> - PostgreSQL 8.0.3 >> - PostGIS 1.1.3 >> - Mapserver 4.10 >> >> Thanks, >> >> Isao Nasuno >> ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users