AnsweredAssumed Answered

Join SQL server table to shapefile that has exceeded max characters?

Question asked by RunnymedeGIS on Sep 10, 2014
Latest reply on Sep 10, 2014 by clm42

Hi

 

I have a SQL server table that has information that I would like to join to a shapefile, but a couple of the fields exceed the maximum number of characters allowed for a shapefile in a field (one field has 300 and the other 500).

 

It is a python script I am trying to compile, and when using the add join tool it gave me an error stating the fields were too large. Can anyone suggest how I can get this information over to my shapefile? Would creating fields in the shapefile and then calculating values work or would that error? I would be happy to only get the maximum number of characters allowed in the field for a shapefile (254?).

 

Hope that makes sense, any advice would be great!

Outcomes