id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc 4186,OGR to FileGeoDB Error,aestrada,warmerdam," {{{ I am running Centos version 6 with yesterday's build of GDAL trunk. Below you'll find the errors I am getting from ogr2ogr when trying to create a FGDB. [root@me filegdb]# vim run 1 #!/bin/bash 2 3 ogr2ogr -overwrite -skipfailures -f ""FileGDB"" country.gdb \ 4 PG:""host=172.16.2.66 user=me dbname=gossip password=password"" \ 5 -sql ""SELECT d.id as id, d.service as service, d.date_taken as date_taken, 6 d.date_inserted as date_inserted,d.url as url,d.translated as translated,d.geom as geom FROM 7 getdata d, world_boundaries b WHERE (b.cntry_name = 'country') AND d.geom && b.wkb_geometry 8 AND intersects(d.geom, b.wkb_geometry)"" -nln ""country"" -nlt POINT I've tried it with and without -nlt with each of the two geom types (GEOMETRY AND POINT). POINT throws this error: ""ERROR 1: FGDB driver does not support OGR type"" GEOMETRY type throws the following: [root@me filegdb]# ./run ERROR 1: Error: Failed to open Geodatabase (The system cannot find the path specified.) ERROR 1: Error: Failed to open Geodatabase (The system cannot find the path specified.) ERROR 1: Cannot map OGRwkbGeometryType (0) to ESRI type ERROR 1: Error (-1): Unable to map OGR type to ESRI type ERROR 1: Terminating translation prematurely after failed translation from sql statement. [root@gossip filegdb]# ERROR 1: Error: Failed to open Geodatabase (The system cannot find the path specified.) ERROR 1: Cannot map OGRwkbGeometryType (0) to ESRI type ERROR 1: Error (-1): Unable to map OGR type to ESRI type ERROR 1: Terminating translation prematurely after failed translation from sql statement. I believe this only happens when using the -sql flag. I am not around that machine now and can't officially test it as the FGDB driver doesn't want to behave on my Mac. Adam }}} ",defect,closed,normal,1.9.0,default,svn-trunk,normal,worksforme,FGDB,