Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have a question. I'd like to join .shp to table by using AddJoin_management. But I'd like to make join to sqlserver table (not to *.dbf). Is it possible to do? it should look something like this:

AddJoin_management ("my_layer.shp", "ID", SQL-SERVER-TABLE, "ID")
share|improve this question

1 Answer 1

This should be straightforward.

Add your shapefile and SQL Server table to ArcMap 10.0 or later.

Open, fill in the fields, and run the Add Join tool interactively.

Now go to Geoprocessing | Results and use Copy As Python Snippet on the tool to get the correct syntax in your Python script.

You may also need to use Make Feature Layer and Make Table View to make the shapefile and table accessible to Add Join.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.