mentby.com
Blog | Jobs | Help | Signup | Login

loading

Import excel file to postgresql

Wed, 13 Jun 2012 07:10:53 -0700 Post Comments

Hi José,

ogr2org can import excel files for you.  http://www.gdal.org/ogr/drv_xls.html  
Or you compile gdal/ogr from svn then you can also import xlsx files. http://www.gdal.org/ogr/drv_xlsx.html

Gr
Ralf
Hi Richard,

a transformated height are no "artifact". You can only get one by using 7
parameter transformation. Using the 3 parameter transformation (cartesian
coordinate system) or nadgrid can not change the z value.

I think the better way is having a function ST_Transform2D() and the normal
ST_Transform(). A function named ST_Transform3D can't be satisfied if the
proj4text having nadgrid or only 3 parameter defined.

Gr
Ralf

PostGIS Types Across Schemas

Fri, 17 Feb 2012 01:53:53 -0800 Post Comments

Hi Steve,

you only need to enable postgis for public schema. In every other schema the
geography typ will be used as public.geography.

Gr
Ralf
Group(s)
Profile Widget
Copy and paste this HTML code to your blog or website: