All Questions
Tagged with sql-server-spatial shapefile
4 questions
1
vote
2
answers
2k
views
Attempting to use ogr2ogr to convert shapefile to SQL Server table; getting error "unable to find driver mssqlspatial"
I have shapefiles with geographic data (polygon geometry only) that I'd like to import into tables in a SQL Server instance over which I have no direct control (but I'm working closely with someone ...
0
votes
0
answers
255
views
Convert a SQL Server table to a shapefile with projection info
I've been using ogr2ogr to write out shapefiles from my SQL Server spatial map layers. When I run the command it delivers the .shp, .shx, and the .dbf but no prj file. Is there a way to get ogr2ogr ...
- 437
1
vote
0
answers
81
views
How to deal with decimal separator when uploading geometries to MSSQL server using shape2sql.exe?
I'm using Shape2Sql.exe to upload .shp shapefile to MSSQL server 13.0.4502.0 on a Win10 64bit laptop. I've added Shape2Sql.exe.config
<?xml version="1.0" encoding="utf-8"?>
<configuration>...
2
votes
3
answers
777
views
ogr2ogr mssqlspatial string imports as a single special character
When importing a shapefile (in this case a public census tract shapefile) into SQL Server 2016 using ogr2ogr, the string fields are set to a single special character. The geography and integer fields ...
- 21