4
votes
2answers
71 views

Storing SRID:4326 data as Geometry or Geography?

I used OGR2OGR to import SRID 4326 point data into MSSQL Server. Didn't realize that it defaults to creating a geometry column instead of detecting the data as 4326 and creating a geography column. ...
1
vote
0answers
30 views

No tables listed in connection to MSSQL 2012 in QGIS

I've (finally) made a connection to my MSSQL 2012 database, but no tables are listed. Here's the tree view of the connection, and the connection properties: Some notes and questions: I've read ...
0
votes
2answers
11 views

Consuming gml generated by sql server As.GML()

Sql server has a method As.GML to produce GML file from geography/geometric type. Is there a good example to utilize this GML on other mapping platform such as QGIS? I have ask a related question ...
0
votes
0answers
214 views

MSSQL Connection settings for QGIS

OK first lets get the blond elements out of the way- I'm not asking for how I connect to my actual database. What I'm asking for is an example or screen shot of the entries required when setting up a ...
0
votes
1answer
43 views

QGIS map tip / label showing a table

I have a MSSQQL Spatiatal layer with Point data (borehole locations, pointID) and a joint table lithology (soil info per borehole, pointID, depth from, depth to, constituent) Is there a way to use ...
3
votes
1answer
161 views

Load and display a layer using PYQGIS

I'm having a go at using pyqgis from within the QGIS python console to load a layer from SQL Server and display it. I feel like I'm part way there but I'm having a real issue getting the layer to ...
0
votes
0answers
21 views

Refreshing MSSQL Layer in QGIS

When working on a map in QGIS I will often set up a view in my SQL Server spatial database and create a MSSQL layer based on this. As part of my workflow I often make adjustments to the SQL view ...
3
votes
1answer
63 views

How to set up a QGIS project with SQL Server which can be opened on another computer?

I am using QGIS with SQL server 2008. I need to save project on one computer and then copy project to another 20 clients! After I save project and try to open it on another computer I am getting ...
0
votes
0answers
63 views

Publishing MSSQL spatial data as WFS with QGIS 2.0 results in empty layers

I am experiencing some very strange behaviour with a WFS layer served by QGIS Server through Apache, with data taken from an MSSQL table. There appears to be no problem at all getting the data into a ...
2
votes
1answer
46 views

How to use a SQL 2005 table as attribute data in QGIS

We have financial data in a SQL 2005 database which we would like to link to a cadastral shape file in QGIS. The idea is to be able to display up-to-date outstanding balances for each plot. How can we ...
3
votes
4answers
321 views

Esri File GDB multi-user edit through QGIS

I have an Esri File GDB with relationship classes. I would like to import this GDB in PostgreSQL or MSSQL to enable multi-user edit through QGIS (dufour) tool. What are the steps/procedures to ...
2
votes
1answer
86 views

Bug when viewing data from SQL Server in QGIS

I'm having an issue with viewing data in QGIS 2 based on a spatial query in SQL Server 2008 R2. The data appears to load, polygons appear and I can add thematic shading based on data. However when I ...
5
votes
1answer
617 views

QGIS and SQL Server Spatial Tables Performance

I'm trying to get a SQL Server 2008 R2 spatial database up and running to streamline the production of maps using QGIS. Currently I just have a handful of spatial tables (a postcode level point table ...
1
vote
0answers
122 views

How to add a MSSQL spatial layer using Python?

I'm having difficulty adding a MSSQL spatial data layer using Python. The database is password protected, and I can add the layer without any problems using the built in feature, but I can't make it ...
0
votes
2answers
300 views

MSSQL Data Not Showing Up in QGIS

I started using QGIS a few weeks ago. I've been able to create some very nice maps with it. I've used the OpenLayers plugins to bring in different basemaps, I've brought in shapefiles and connected ...
6
votes
2answers
78 views

Define projection at the record level

Hopefully this isn't too dumb a question, but is it possible to define projection at the record level, instead of a whole layer or table? I want to create a "project" database for all the work my ...
4
votes
1answer
140 views

QGIS 2.0.1 linking table issue, MSSQL 2008 database

I'm trying to link tables in QGIS 2.0.1 and MSSQL 2008 database. I can link them but when I try to open the attribute table QGIS throws an error and shuts down creating a *.dmp file. I saw that ...
1
vote
0answers
74 views

QGis 2.01 Fedora 19 vs Windows SQL-Server Access

i just installed QGis 2.01 on Ubuntu / Fedora 19 / windows 8, configured ODBC-support for Fedora 19 and created ODBC-DSNs on the windows machine and the Fedora machine to the same SQL-Server 2012 ...
1
vote
2answers
337 views

Import Zip codes into qgis

I have a list of zip codes (nearly thousands) which I want to show in qgis. After researching I found that I need to geocode them first into Lat/Long then I can use them to create a layer for qgis. I ...
1
vote
1answer
1k views

Implementing geometry_columns table in SQL Server for QGIS

We are using QGIS 1.8 and Sqlserver 2008.Following http://hub.qgis.org/issues/8525 solution we have created table geometry_columns. since we already have lots of table how do I fill this table ...
0
votes
0answers
80 views

QGIS: MSSQL spatial layer bug with estimated metadata

It looks like there is a bug when connecting to MSSQL databases to add a spatial layer when using estimated table parameters. Connecting one time works fine and all the spatial enabled tables are ...
2
votes
0answers
127 views

Spatial Precision for Editing in Multiple GIS Clients

I have something I'd like to discuss, I'll try to explain it first, why it's important, and I'll explain how ArcGIS handles the issue, which I think is a good way to handle it. Finally I'd like to ...
0
votes
1answer
147 views

What is required to get OGR to work with SQL Server?

All, I've been having heaps of trouble getting OGR to connect to our SQL Server development environment. (read about it here and here) SQL Versions: 2008, 2012 OS's: Windows 7, Ubuntu 12.04 My ...
0
votes
0answers
202 views

What does OGR “driver not loaded” mean when connecting to SQL Server through QGIS?

All, Using QGIS 1.8, SQL Server 2012, and OGR 1.9.2 (also fails on our SQL Server 2008 sandbox machine) When creating a connection in QGIS I'm getting the following errors: Ubuntu 12.04 Driver ...
0
votes
0answers
65 views

Why does importing data through MSSQL provider throw this error?

(Sorry for the awful title, but I will refine if we can figure this out...) I've imported data through drag 'n drop without using the geometry_columns name specifically - the default name when ...
1
vote
0answers
475 views

Why can't QGIS connect to MS SQL Server?

All, Up until yesterday, QGIS connected to my SQL Server 2012 database no problem. However, yesterday I installed SQL Server Management Studio (SSMS), and the SQL Server Client tools, and now I get ...
1
vote
0answers
301 views

Connect QGIS to MSSQL view (i.e. not a table)

I've got a MSSQL view containing data I want to show in QGIS. The view transforms a BLOB field containing WKB that is in one of my tables into a SQL geometry, which QGIS will be able to display. ...
0
votes
0answers
106 views

Can osm way records in SQL spatial be merged to one geographic record if they have same Id?

I've imported England shp file of roads to mssql using OSM2MSSQL and I've noticed that the same road has couple of records with same Id but different geographic (probably it was segmented). Is there ...
2
votes
0answers
311 views

MSSQL spatial layer import error

I am currently working on a project in which spatial data are stored in a Microsoft SQL Server 2008 database. The tables which hold the spatial table contain 3 rows and are: RoomId - BIGINT, ...
4
votes
1answer
484 views

Why don't my polygons from MSSQL2008 display in QGIS?

I have imported a polygon shape file in MSSQL2008 using Shape2SQL loader without any issue. When I import the loaded polygon file in QGIS, I can't see it ! When I import other point or line features ...
7
votes
0answers
66 views

How can I automatically split a spatial layer to a grid [duplicate]

Possible Duplicate: Divide vector in equal smaller parts in QGIS or similar I am a software engineer and the company I work for has a project that needs some spatial data manipulation in ...
0
votes
1answer
615 views

Ogr2Ogr doesn't work with QGIS 1.8

I'm trying to use Ogr2Ogr.exe to import some shapefiles. It came installed with QGIS 1.8. When I try and run it, i get the following error: C:\Program Files (x86)\Quantum GIS Lisboa\bin>ogr2ogr ...
1
vote
1answer
1k views

How to save a vector layer from QGIS to Sql Server 2008 or 2012?

using QGIS, i've loaded up some administrative boundary data of New Zealand. I wish to now import this vector data from QGIS into my Sql Server 2012. Is there any way to do this with QGIS ...
2
votes
3answers
5k views

How to import shapefiles into MS SQL 2008 and then view that data using QGIS?

I'm a QGIS users but not a database person and I need some help on the DB side. I'm currently in the need to import several shape files into MSSQL 2008 and I have no clue how to do that and my IT guy ...
2
votes
3answers
310 views

How to save a QGIS workspace with database link for offline use?

Is it possible to save current workspace of QGIS for offline usage like in mapinfo? My workspace has link to database. and when I reopen workspace unlink in mapinfo it can't open it.
3
votes
2answers
893 views

Can I fix 'qodbc3:unable to execute statement' when querying SQL Server 2008?

I was testing features of QGIS and its really cool.I tried to query each table using right click and query but I can't query sql server 2008 database : Error: An error occured when executing the ...
2
votes
0answers
373 views

Is it acceptable to store OSGB36 data as geometry in SQL Server?

I've set myself a project of getting some geo data into SQL Server but before I get started doing any of the big jobs I wanted to see if I was on the right track. All of my data is for the UK and is ...