DBF data table
Disk & DatabaseDBF is an xBase table, also used for Shapefile attributes. It does not by itself contain map geometry. Check encoding, memo companions and row correspondence before editing.
- Main use
- Storing tables or geographic attributes
- Data type
- Binary data / document
All sections, questions and sources
Content reviewed: · Editor:Kai
Example: a practical checking sequence
Example: independently sorting a Shapefile DBF can break attributes. Check the original complete dataset and edit through GIS. For garbled Japanese, establish the correct encoding before export; do not overwrite undecoded text.
Opening steps
Choose your environment or purpose to see its steps.
Menu labels and support vary by app, OS and version. Preserve the original before making changes.
Troubleshooting by symptom
- Japanese text is garbled: inspect CPG and source encoding.
- No map: DBF holds attributes; obtain geometry companions.
- Empty memos: check companions and variant support.
- Wrong map attributes: isolated sorting/deletion may break correspondence.
- Truncated fields: inspect format limits for names, types and widths.
DBF → CSV or a complete GIS format
- Preserve source and companions.
- Export standalone tables to appropriately encoded CSV or complete geographic data to supported GIS formats.
- Verify rows, fields, text, coordinates and attribute correspondence.
CSV does not preserve all memo/type/spatial structure; do not independently reorder a Shapefile DBF and replace it.
Attributes versus geometry
Shapefiles combine geometry and attributes across companion files; edit through GIS to preserve their correspondence.
Source for these steps:GDAL · ESRI Shapefile / DBF driver
Check encoding before export
Saving garbled text can destroy original characters. Decode correctly before creating a new export.
- Keep encoding companions.
- Compare dates, numbers and nulls.
- Check destination field-name limits.
Source for these steps:GDAL · ESRI Shapefile / DBF driver / QGIS · Vector general algorithms
Related-format differences
| Format / purpose | Use and preserved information |
|---|---|
| DBF | Typed table data. |
| SHP | Shapefile geometry. |
| CSV | Text table with different type/structure semantics. |
Handling and security
Tables/maps can contain customer and location data; inspect before sharing and back up the complete set.
Questions and answers
Does DBF contain the map?
Not generally; geometry is separate.
Can I sort it externally and put it back?
Use GIS editing to avoid breaking correspondence.
Does garbling mean corruption?
Check encoding first.
Why are memos missing?
Check companions and format support.
Does CSV preserve everything?
No; types, memos and spatial structure differ.
Format facts: name, steward and MIME type
- Formal name
- dBASE / xBase table
- Steward / specification
- dBASE / xBase / GIS implementations
- MIME type
- Check the producer or implementation; do not assume a single universal MIME value.
Primary and official sources
- Project documentationESRI Shapefile / DBF driver
DBF attributes, encodings and related SHP data
GDAL · Link checked: - Software documentationVector general algorithms
Data conversion and Shapefile encodings
QGIS · Link checked: