Skip to main content
Question

GDB to SHP field length >254

  • June 30, 2022
  • 5 replies
  • 77 views

viviancfhung
Contributor
Forum|alt.badge.img+1

We want to convert a GDB to SHP file with field type string and length>254. How can we keep the data with maximum size 254, but not ignore the data

Thanks

5 replies

birgit
Influencer
Forum|alt.badge.img+21
  • Influencer
  • 131 replies
  • June 30, 2022

I don't think this is possible it is literally a limitation of the .shp format. Your only option is to use another format. I guess you could split up the attribute that contains more than 254 characters into multiple attributes.

 

See the same question on another site


viviancfhung
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • 51 replies
  • June 30, 2022

I don't think this is possible it is literally a limitation of the .shp format. Your only option is to use another format. I guess you could split up the attribute that contains more than 254 characters into multiple attributes.

 

See the same question on another site

understand. Is any tramsformer can I used to change the max field length of schema if the data is not long, but the schema field length is 65536


redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3699 replies
  • June 30, 2022

understand. Is any tramsformer can I used to change the max field length of schema if the data is not long, but the schema field length is 65536

There's no need to use a transformer for that, you can specify the field length in the Shape writer (with that 254 char maximum of course)


viviancfhung
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • 51 replies
  • June 30, 2022

understand. Is any tramsformer can I used to change the max field length of schema if the data is not long, but the schema field length is 65536

Thanks, But we are using Dynamic schema


Forum|alt.badge.img+2
  • 1891 replies
  • July 4, 2022

@viviancfhung​ The shape file .dbf file has a limit on the text length of 254 as mentioned by @Hans van der Maarel​