Tagged Questions
0
votes
0answers
31 views
How to add attribute from analysis to database mySQL?
I need to prepare a GIS for a customer. They insist to use a MySQL-Database (not the best option, I know). They need to digitize some geometries (areas) and add some attributes. The geometries and ...
1
vote
1answer
57 views
How to add MS SQL table using python console?
I have MS SQL Server 2008 R2 database. How to add MS SQL Table using python console in QGIS?
1
vote
1answer
295 views
How to connect to MySQL from QGIS in Ubuntu10?
I have just installed Quantum GIS 1.8.0 on my Ubuntu 10. I want to add a MySql table as a data source but I can't see any options for connecting to mysql.
Can any one guide me how to connect to ...
0
votes
0answers
139 views
Qgis Mysql data import and show on the map based on coordinates
I have a mysql table with points with some attributes (name, lat, long, elevation, ect...)
I import to Qgis with the Add Raster -> Database -> Mysql function.
The connection is succesfull and I can ...
1
vote
1answer
114 views
QGIS crashes when adding vector layer from mysql or testing connection to mysql
For a while I have been adding layers from my mySql database and all went well.
Then I got crashes when adding new vector layers.
Then I only got crashes and it is not possible to add layers from ...
3
votes
1answer
93 views
Why can't I edit polygons once they have been saved to MySQL?
I have a simple table with an id field and a polygon field in mySql.
Using QGIS I can add new polygons and give them an id. Before saving them I can also edit them.
But once a polygon has been saved ...
3
votes
2answers
375 views
How did QGIS fix a shapefile's character encoding, and can I do this on the command line with ogr2ogr?
Solved: I'm not sure why, but it works fine if I specify --config SHAPE_ENCODING "ISO-8859-1" in my ogr2ogr command. For whatever reason, this allowed ogr2ogr to go from the original TigerLine ...
3
votes
1answer
1k views
Convert Shapefile to MySql
I have used Grass GIS imported a .shp file; I now want to export this file to MySQL.
I understood that MySQL will contain the function of all three the files necessary in a Shape file system (.shp - ...
7
votes
1answer
110 views
What constitutes a valid spatial layer when connecting QGIS to MySQL?
I'm trying to work with a MySQL 5.5 table using QGIS 1.8. I can do "Add Vector Layer", choose "Database", and successfully connect to the MySQL connection I previously set up. QGIS shows me a ...
2
votes
0answers
134 views
Problem connecting QGIS to MySQL [closed]
I'm trying to create a new vector layer and store it in a MySql-database, but when I test the connection I get an error with no detailed information at all. If I give an erroneus password I get a ...
1
vote
2answers
116 views
How to get only one feature from MySQL?
I would like to get only one feature from a MySQL database.
What am I currently doing?
I use the Add Vector Layer functionality in QGis to get the features (polygons) from the MySQL database. They ...
1
vote
1answer
93 views
How to change the path to the mysql socket in Quantum GIS?
I would like to use Mysql in QGIS. But when I want to create a new connection to the database (Add Vector Layer), I can't connect because QGIS is looking for
/tmp/mysql.sock
But I'm using XAMPP ...
2
votes
0answers
193 views
How to access mysql data from python built-in console?
I'm writing a QGIS Plugin, and somewhere I want to present data from a MySQL database. It's simple data(strings,etc), not Geospatial, or vector data. I'm familiar with querying databases from python ...
2
votes
2answers
327 views
Map Coordinates to Neighborhoods from MySQL Table
I have a MySQL database with a set of coordinates and a shape file (Zillow Neighborhood Database for Chicago) containing the boundaries for each neighborhood which I have converted to a spatial ...
1
vote
1answer
2k views
Import MySQL Spatial vector layer in QGIS
I have a spatial table called 'places' in MySQL, with a spatial column 'pt' (point). I tried to import it in QGIS and no points appear. I created a view 'places_as_text' which reproduces the table but ...
