1

Programs like Golden Surfer and AutoCAD (GIS versions) allow you to connect to tables in databases. When new data is entered into the database, it is automatically updated on our map. In the case of QGIS, I don't know how to do this. The method I know is the "Create Point Layer from Table" tool. But I'd like to see if it can be done automatically with SQL Server, MySQL, or SQLite (Spatial).

Vince
20.5k16 gold badges49 silver badges65 bronze badges
asked Apr 15 at 7:09
1
  • Are you talking about automatically loading new tables in the database as QGIS layers? If so, no, QGIS can't do that. Are you talking about refreshing already loaded layers? You have several refresh options available in Layer > Properties > Tab: Rendering Commented Apr 17 at 8:51

1 Answer 1

5

In the Browser window, right-click the relevant database type and click New Connection.

You will be prompted for the connection information and authorisation credentials.

If the connection is successful, the layers will appear in the Browser and can be dragged into the map. They will react to changes made in the underlying database.

enter image description here

answered Apr 15 at 10:28
0

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.