Sunday, 17 September 2017

arcgis desktop - Can't export features from PostGIS table into ESRI FGDB when text fields contain more than 255 characters


I am loading the PostGIS table in ArcMap 10.4.1 using a database connection. Then I export the loaded layer (Right click, Data, Export Data...) into a newly created File Geodatabase. The procedure is working, there are only a few of the features that are not exported.


Then I tried with QGIS 2.18.11 (Right click, Save, File GDB). The same happens. The same features are not exported to the FGDB.


I looked into the PostGIS table and the failing features all have something in common: they all have one or more text fields wider than 255 characters.


Those same fields in the destination FGDB have a limit of 255 characters.


Is there a way to make the text fields adjust automatically (and larger than 255 chars) to the size of the field in the table being imported?



It is possible to create text fields as wide as 2 147 483 647 characters according to the ESRI docs.



Answer



Try right clicking on the File Geodatabase and importing features, instead of right clicking the layer and exporting. That way you should have the option in field mapping to alter text field length


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...