[postgis-users] Error while MapInfo file to PostGIS

2008-01-22 Thread Surachai Locharoen
I import file in MapInfo format into PostGIS by using ogr2ogr Example export PGCLIENTENCODING=WIN874 // I import file which use this encoding. ogr2ogr -append -skipfailures -f PostgreSQL PG:dbname=MapDB ADMIN_BND.TAB -nln ADMIN_BND The map is composed in many file So I have write

Re: [postgis-users] PostGIS / PostgreSQL binaries for RedHat/Itanium II?

2008-01-22 Thread Doug_Newcomb
Dana, From what I recall of the Itanium family of processors, it is a pure 64 bit processor which does software emulation of a 32 bit x86 environment for 32 bit x86 binaries. I also remember that the performance of this 32 bit x86 emulation method was somewhat lacking. AMD came out with

[postgis-users] 3D data became 2d auf insertion?

2008-01-22 Thread Simon Schneider
Hi, I have the following table... _ create table objects ( name varchar(15) not null primary key, parent varchar(15), type varchar(15) not null ); select addgeometrycolumn('objects','geom',-1,'POLYGON',3); _

Re: [postgis-users] 3D data became 2d auf insertion?

2008-01-22 Thread Mark Cave-Ayland
On Tue, 2008-01-22 at 16:53 +0100, Simon Schneider wrote: Hi, I have the following table... _ create table objects ( name varchar(15) not null primary key, parent varchar(15), type varchar(15) not null ); select

Re: [postgis-users] PostGIS / PostgreSQL binaries for RedHat/Itanium II?

2008-01-22 Thread Kyle Wilcox
What Enterprise Linux do people here use for PostGIS/PostgreSQL (for personal work where there is little to no funding)? We have a few Itanium (IA64) boxes that we run with RedHat 5 and use Xen to emulate any environment we need. One of those is a slim gentoo installation which runs our

Re: [postgis-users] 3D data became 2d auf insertion?

2008-01-22 Thread Simon Schneider
Thx, your tip worked. My original query was select Astext(geom3d) from objects. With select AsEWKT(geom3d) from objects everythin worked fine. Bye, Simon ___ postgis-users mailing list postgis-users@postgis.refractions.net

RE: [postgis-users] Pipeline Data Model

2008-01-22 Thread Burgholzer,Robert
Just as an update, I have submitted a project for sourceforge hosting approval, called Environmental Data Models, short name envirodata. Perhaps the envirodata moniker is too restrictive, maybe, ogcdata would be better. Since I didn't get any feedback, I just called it something that I