[GIS] How to join MySQL database to QGIS polygons

databaseMySQLqgis

I Have an *.sql file that has no spatial information. For every record there is an id. I also have a Qgis project with polygons without any id. How can i connect the polygons with the database? I know that i have to add the same id to the shapes to make the connection. I don't know how to make the connection. Is there any tutorial that can help me?

Best Answer

Just, 1. add vector layer --> database--> Type-->MySQL --> connection-->New 2. complete the parameters 3. test the connection 4. import the layer(s) you want 5. add id(s) to shape's attribute tables--> join.

Related Solutions

[GIS] Delete table rows in non-spatial database using arcpy

Finally figured this one out. And apologies to @Vince - I see you mentioned this in a comment but I completely missed it until right now when I came to post this answer.

The tool arcpy.ArcSDESQLExecute() is the arcpy equivalent of pyodbc, but unlike pyodbc, ArcSDESQLExecute will in fact read a .sde connection file (so I don't need to pass login details through to the script).

# Delete/Truncate/Delete Rows of third-party DB table
nonGeoDB = "Database Connections/NonGeoDB.sde"

sqlConn = arcpy.ArcSDESQLExecute(nonGeoDB)

sqlQuery = """DELETE FROM [NonGeoDB].[dbo].[ALoad]"""

sqlConn.execute(sqlQuery)

I can then follow this up with the arcpy.da.InsertCursor() to insert the new records into that same table, as the Insert Cursor works to non GDB tables, it's just the Update Cursor that doesn't work.

Best Answer

Related Solutions

[GIS] Delete table rows in non-spatial database using arcpy

Related Question