Select to view content in your preferred language

Join SQL table to shapefile in ArcMap

3343
1
12-11-2012 06:10 AM
andrejjakubicka
New Contributor
Hello
I'm a totally newbie to GIS and my boss wants me to do some demo project.
I was supposed to create new layer, create some new polylines on it and here comes the point: after doing this, he wants me to join some SQL table or view where we store some non-spatial data (such as some url links to call our other services...). I was able to join this view to the shapefile (rigth-click on layer -> Joins and Relates -> Join), after adding query layer through database connection
But my question is: how to ensure, that after i create a new object(polyline, point) on this layer, that this new data are inserted into joined SQL table? e.g. objectId, description and so on, Or update some objects in ArcMap and consequently update in SQL table
Our GIS specialist is temporarily outsourced, so I've been googling around for about 2 weeks already and still no results found on my issue.

any help appreciated, thanks in advance

Andrej
0 Kudos
1 Reply
AlexeyTereshenkov
Deactivated User
Hi,

Query layers are used for read-only access which means you cannot edit the source data (SQL tables) via query layers. I'd go for using geodatabase relationship classes or database triggers if you want to go non-geodatabase way.
0 Kudos