New answers tagged ogr2ogr
I used to have the same problem, the fastest way was to use this tool. http://www.dknezevic.com/blog/2014/10/import-shapefiles-into-sql-server.html It's quick and easy to work with. Hope that helps.
In order to determine the correct coordinate system for the input SQL Server data, I exported the data as a shapefile, and ran the following command on the prj file: gdalsrsinfo [table].prj This generated the following PROJ.4 string: +proj=tpeqd +lat_1=49 +lon_1=-110 +lat_2=49 +lon_2=-77 +x_0=0 +y_0=0 +datum=NAD83 +units=m +no_defs I then placed the ...
This worked for me in the ogr shell. First change your directory to the folder that contains your shapefile (cd full path to shapefile folder) ogr2ogr -overwrite -f "MSSQLSpatial" "MSSQL:server=...;database=...;trusted_connection=yes" test.shp -a_srs "EPSG:4326" -nln "test" Hope it works for you.
I have had this issue too previously. I assume you are using a shapefile to do this? This was my mistake too. Adapt the script to run for Mapinfo .tab files. Firstly, convert your input shapefile to a .tab file (QGIS does this no problem). Try this method and see what happen. Perhaps post your whole script for this to give us more insight?
You may want to check the EMOSLIB at ECMWF software website. It is suited for interpolations.
S57 stores both data and symbology in the same format while shapefiles only store the data. So infact the depth information is present in the shapefile, what is missing are the instructions to display that number as text and a dot (or whatever S57 uses for depth points) - thus ArcMap or QGis will just display the point by default. You will need to add some ...
Finally the solution was a combination of these two posts: How to re-compile ogrinfo against gdal used by QGIS? for the install / uninstall / clean part, and How to repair broken GDAL and PROJ.4 on Ubuntu? For the final touch. It was a path issue, fixed by typing in the terminal export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib Thanks to all for the ...
You will probably need to build GDAL from source; you can download the tar ball here. Before compiling, ensure that you have installed the Spatialite libraries (& you could also install the binaries at the same time): apt-get install libspatialite-dev libspatialite5 spatialite-bin Then run the following to build GDAL/OGR with spatialite support: ...
Top 50 recent answers are included