Hot answers tagged ogr2ogr
Something like: ogr2ogr -f XXX -s_srs epsg:27700 -t_srs epsg:4326 out.xxx in.shp The ogr2ogr manual page explains all the options.
FROM should contain table names, not column names (and 100 is missing here in the table name) The ON part should connect columns from both tables, but you have specified the same table on both sides. I suggest to put the whole sql statement in quotation marks, single ones for Linux and double for Windows. The roles of dst_datasource_name and ...
If you have National Grid coordinates with trailing letters, you can not use these in ogr2ogr. The ngconverter linked in the other answer will be the best solution. It will output coordinates in EPSG:27700. If you have numerical coordinates, EPSG:27700 will work in ogr2ogr, as pointed out by @iant.
I figured this out. It seems like there were some artifact functions with the name addGeometryColumn (overloading in postgres is possible). This error in the logfile made me suspect there is something very wrong with the addGeometryColumn function: ERROR: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) is not unique at ...
The solution for this problem was to create a table in oracle with the NULL value and 'No_elements' for tax_type field. I then add an extra ogr2ogr line in my batch file that appends the NULL observation into the existing file geodatabase that is exported in the previous line.
I struggled with this too! I managed to solve the problem ogr2ogr -f MSSQLSpatial "MSSQL:server=Servername\SQL2012;database=DatabaseName;UID= username;PWD=password" C:\Pathto\shape.shp All you need to do is get rid of the  and it should work...Hope this is still applicable to you.Just to show you I had the same issue here is a screensht of multiple ...
Only top voted, non community-wiki answers of a minimum length are eligible