Skip to main content

Hello All

We are converting some City GML 3D models in Esri Shape format.

During the process we receive an error message :

DBF Writer: DBF file exceeds maximum size of 2 GB

Error running translation.

Any solution is very much appriciated

Hi @nikolas

Looks like the output is too large for a shapefile (this is a limitation of the SHP format). Maybe try and split your data into multiple shapefiles? If there is a suitable category in which you could subdivide your data, you could use a fanout on the writer to create multiple SHP...

See: https://knowledge.safe.com/articles/565/fanout-1.html

Hope this helps!


Hi @nikolas, I will echo @xilef here. One common method for splitting the data is tiling it. You can use the tile extents as the file names. If you keep this naming consistent then moving forward you'll find it's much easier to make changes to only affected ares. 2 km tiles is often common.

 

Also here it's the dfb file which is getting too big so perhaps there are some attributes in the data which can be removed?

 

Also look at the data types on the shape file writer, I think that if you make sure field names are only as big as they need to be and not 254 length stings you might find you save on space.


Reply