New answers tagged sql-server
Try adding: iface.mapCanvas().refresh() as last line.
Some kinds of transformations are lossy. Transverse mercator for example can only be used for the visible half of the globe. The back side gets lost when you try to re-transform. Mercator only looses the poles, because it is accepted that the cylinder is unrolled in a world map. This is important if you have huge shapefiles, e.g. complete Russia or the ...
projections of vector datasets are not lossy in theory (if you don't have rounding errors, of course, which will depend on your software and your data storage precision). You should however be careful with projection of raster datasets, which are lossy because of the resampling. Now, if you change the datum (from one geographic coordinate system to ...
Good question. You need to add the database connection to each computer. Unfortunately this is stored as a registry setting (see the MSSQL section in the image below). But you can script the installation of registry settings, so if you roll our QGIS to many computers somehow, include the registry settings for the QGIS database connections. The way I have ...
See http://geographika.co.uk/linear-referencing-in-sql-server-2008, that offers sqlspatialtools ( http://sqlspatialtools.codeplex.com/ ) But when i tested sqlspatialtools , i didn't get it work. Far as i know ESRI C# libraries are easiest way to some processing in C#, FME also offers some interface for c#. I havent used those and both are commercial ...
You can use Entity Framework or Nhibernate.Spatial to speak to Sql Server. You'll have to solve the OpenLayers vector feature handling yourself in this case.
You can use Geoserver to connect to Sql Server, (you would need the SqlServer plugin for this) and then publish the data as WFS-T. On the client side you could use the Openlayers Editor
pyodbc library is capable of executing stored procedures. Check out the getting started guide here. It is a Python 2.x and 3.x module that allows you to use ODBC to connect to almost any database from Windows, Linux, OS/X, and more. It implements the Python Database API Specification v2.0, but additional features have been added to simplify ...
A few things to try to get data inside QGIS: The button 'Add MSSQL Server Layer' The button 'Add vector layer', Source type set to Database, Database type set to MSSQL The button 'Add vector layer', Source type set to ODBC Export data as CSV from MSSQL and open the CSV file in QGIS Once the attribute data is inside QGIS it can be linked to a Shape file ...
Top 50 recent answers are included