Skip to main content
Geographic Information Systems

Return to Question

naming
Source Link
Vince
Vince
  • 20.3k
  • 16
  • 48
  • 65

Reducing Shapefile Sizeshapefile size from PostGreSQL UsingPostgreSQL using ogr2ogr

I have a POSTGISPostGIS database created from an old AutoCAD system. Because of this, every column is type varchar(254), even though actual data lengths are small. I need to export tables as shapefiles, and would like to minimize the extra space created in the shapefile due to the large column fields, in order to reduce the overall size of the .dbsdbf file. Is there any way to reduce the size of fields when utilizing ogr2ogr to convert PostgresPostgreSQL data to Esri shapefiles?

Reducing Shapefile Size from PostGreSQL Using ogr2ogr

I have a POSTGIS database created from an old AutoCAD system. Because of this, every column is type varchar(254), even though actual data lengths are small. I need to export tables as shapefiles, and would like to minimize the extra space created in the shapefile due to the large column fields, in order to reduce the overall size of the .dbs file. Is there any way to reduce the size of fields when utilizing ogr2ogr to convert Postgres data to Esri shapefiles?

Reducing shapefile size from PostgreSQL using ogr2ogr

I have a PostGIS database created from an old AutoCAD system. Because of this, every column is type varchar(254), even though actual data lengths are small. I need to export tables as shapefiles, and would like to minimize the extra space created in the shapefile due to the large column fields, in order to reduce the overall size of the .dbf file. Is there any way to reduce the size of fields when utilizing ogr2ogr to convert PostgreSQL data to Esri shapefiles?

Source Link
TCW
TCW
  • 21
  • 1

Reducing Shapefile Size from PostGreSQL Using ogr2ogr

I have a POSTGIS database created from an old AutoCAD system. Because of this, every column is type varchar(254), even though actual data lengths are small. I need to export tables as shapefiles, and would like to minimize the extra space created in the shapefile due to the large column fields, in order to reduce the overall size of the .dbs file. Is there any way to reduce the size of fields when utilizing ogr2ogr to convert Postgres data to Esri shapefiles?