A standard (but older and limited) data storage format developed for the once-popular dBASE DBMS. Of interest primarily because it forms part of the "shapefile" specification for sharing GIS data.

learn more… | top users | synonyms

35
votes
4answers
26k views

Which character encoding is used by the DBF file in shapefiles?

Which character-encoding is used by the dbf-file in Shape-files? It seems it is handled different, based on the program and the local encoding-settings of the machine. Which encoding is 'right' - ...
25
votes
4answers
12k views

How to bypass 10 character limit of field name in ShapeFiles?

I'm exporting geometry with attached text attributes from oracle database to esri shapefile format (.shp) with Java and Geotools library. Attribute columns in our database have names with more than ...
23
votes
3answers
9k views

How to easily edit attribute data using Regular Expressions?

I am writing a tutorial for MSc students that uses QGIS. One of the tasks requires the attribute data to be modified (see pdf draft of tutorial here if interested ). The question is how to get them ...
19
votes
4answers
6k views

How do you determine a shapefile's charset?

Is there a way to determine the charset used for a given shapefile?
18
votes
4answers
11k views

How to add attribute field to existing Shapefile via Python without ArcGIS?

I have a Python script that adds an attribute field to a Shapefile if doesn't exist. This is easy to do with ArcGIS (graphically or via Python), but I'm looking for something that doesn't depend on ...
10
votes
13answers
9k views

DBF creation and manipulation without excel 2003

My company just upgraded to Office 2007 and now I am no longer able to easily manipulate and create dbf's. I do not understand MS's decision by removing this capability but alas there is no use ...
6
votes
3answers
3k views

Saving *.dbf as *.xls using Python?

i've been let loose in the workplace to learn python to do things in Arcmap10. so, i've learning python as i go and trying to remember the programming i have done. where i am in this project is ...
5
votes
2answers
2k views

Converting text file with coordinates to database table in ArcGIS Desktop with Python?

How do I convert a text file with point coordinates to database tables in the dBase (*.dbf) format in Python? I am using ArcGIS Desktop.
5
votes
1answer
2k views

ArcGIS 10. Convert dbf to csv or similar in ArcPy without cursors

I have many dbf's created by the Spatial Analyst Sample tool. I would like to convert those dbf's into csv's or space delimited (or any text for that matter). I can't seem to find the ArcPy equivalent ...
4
votes
4answers
7k views

How do you add file name to an attribute field?

Does anybody know how to add the shape file name to a field in the file's attribute table? I've found a description: 'You have to use inline variable in CalculateField like %Name% in expresssion ...
4
votes
4answers
3k views

Bulk convert DBF to CSV in a folder ArcGIS 10.1 using Python

I would like to convert 1000 dbf files to CSV. All dbf files are in one folder and they have sequential names (S:\output_tables\tcb1.dbf, S:\output_tables\tcb2.dbf, S:\output_tables\tcb3.dbf, up to ...
4
votes
2answers
168 views

Editing the DBF for a shapefile is yielding totally different results in R and QGIS, but the attribute tables are identical

I'm having kind of a peculiar issue that I'm hoping someone can shed some light on. I'm actually creating my map in R, but I'm using QGIS as a tool to check my mapping process (R newb here). So let's ...
4
votes
2answers
563 views

Is it possible to add a new line in a non-spatial table using Qgis?

While using QGIS, and having loaded a non spatial table (from a dbf or a Spatialite table), is it possible to add a new row to its table attributes? Normally in a spatial layer you have to use "add ...
4
votes
1answer
877 views

ArcObjects joins and non-persistent fields after joining to multiple tables

I have inherited a truly awful and very large ArcObjects project that was originally written in VB and then ported to C#. Apparently the source code I have been given is not the latest version and I ...
4
votes
1answer
1k views

How do I map data by zip code?

I have a set of data that corresponds to zip code, and I'd like to turn that into a map. From what I've gathered thus far, zip code shapefiles are difficult to find and work with due to the fact that ...
4
votes
0answers
2k views

problem with saving to esri file

I was using Wroclaw 1.7/GDAL 1.9(earlier release)/Grass 6.4/GSL 1.15-2 and started getting the following message when saving any item to esri format. "Export to vector file failed. Error: creation of ...
3
votes
1answer
859 views

Shapefile to table within python

I was just curious as to whats the best way within a python script to get the output a dbf file/ table while the input is a shapefile. (if possible which i'm assuming it is) Is there a way of ...
3
votes
1answer
3k views

Is there Python 3 module to read .dbf files written by ArcGIS for Desktop?

I would like to know whether there are Python 3.x-compatible (preferably Python 3.3) modules to read the kind of .dbf files produced by ArcGIS for Desktop. All the modules I found were only ...
3
votes
2answers
125 views

Are Xbase-dbf-files still the common standard for shapefiles?

For a Java application and for my personal understanding, I am exploring how to read and write shapefiles (at least shx, shp, dbf). The main purpose is to keep the resulting Shapefile-class and it's ...
3
votes
1answer
70 views

How is the record count of a multipoint shapefile dbf file determined?

I'm writing a program to create a multipoint shapefile (.shp .shx .dbf), and I'm not sure how the format of the .dbf file should look. The .dbf starts off with a record header, followed by field ...
3
votes
2answers
2k views

How to Open a Table, Convert it to ShapeFile & projecting the data using the X and Y

it's my first project using ArcObject, i create this interface : http://i118.photobucket.com/albums/o104/b_sara/Cap2-1.png i did programme the button "Parcourir" ( browse ) using a commonDialog, it ...
3
votes
1answer
63 views

in QGIS how to add (join?) another table to a layer

Very new so bear with me. I have QGIS loaded with a TIGER/Line Shapefile at the Block level for a County, and need to join other detailed CENSUS data various tables (which also have a Block ID to ...
3
votes
2answers
95 views

merge dbf files - without using arcpy?

I have ~7,000 2 line dbf files (zonal stats output) that I would like merged into one table, all the same format. I have used the arcpy merge tool, as seen below. #merge tables together ...
3
votes
1answer
63 views

Display of DIVA-GIS Gazetteer *.dbf Files in QGIS

I've looked through other questions/answers and not seen what I am looking for... How do I display the contents of a DIVA-GIS Gazetteer *.dbf file in QGIS? Ideally I would like to take contents of ...
3
votes
1answer
518 views

How to create a new shape file from jts geometries?

What I use: Java 1.7, JTS 1.13, geotools.api 14 What I have finished: Creating correct JTS geometries from OSM relations, ways and nodes. What I want to achieve: Create a csv file which contains the ...
3
votes
0answers
275 views

PyQGIS joining a dbf to a shapefile [duplicate]

I am trying to join a shp and dbf file using the PyQGIS API. The code I'll use is below: from PyQt4.QtCore import * vector1 = QgsVectorLayer("path to dbf file", "test1", "ogr") id1 = vector1.id() ...
2
votes
2answers
872 views

Why does ESRI make me store my DBF doubles as strings?

As far as I can tell I have to store all numeric values in a shapefile's associated DBF file as strings (yes, the N type is essentially a string). Can anyone confirm that ESRI does not support the use ...
2
votes
2answers
1k views

How to merge dbf files in Python or arcpy?

I have over one hundred dbf files to merge. Each of files have two columns: ID and another field which differs from one file to another. I want to merge those fields based on ID such that each raw ...
2
votes
1answer
256 views

Creating sum layers by summing field values from *.dbf files using ArcPy?

I have 490 consecutive daily rainfall shapefiles/.dbf files in a single directory. Each consists of a uniform even-spaced grid of 220 points having uniform pointIDs, number of records, field names and ...
2
votes
2answers
901 views

Problems closing dbf-table edited with ArcObjects

To change values and add new values to a dbf-file, I connect to the dbf and use the ITable interface to make the edits. At the end I release the COM-objects of the table and the workspace. But when I ...
2
votes
1answer
1k views

Python - read shapefile .dbf for encoding

I've written a python script that formats a .shp such that its fields structure matches my office's database view in order to ingest the data of said shapefile. This original shapefile was encoded ...
2
votes
1answer
91 views

How to join and display .shp lines with values in .dbf

I've got a shapefile lines with ID attribute and .dbf with values which corresponds do ID. Every value in dbf is in different record. I want to style lines and display label using these values from ...
2
votes
1answer
579 views

coordinates in dbf file wrong

I am new to ArcGis, so please bare with me :D . I converted a polygon in an mdx file I have to a shape file, then converted its vertices to points, then used "add X Y feature" and choosed coordinates ...
2
votes
1answer
36 views

Calculating distance between points from table of UIDs [ArcMap]

I have a .dbf file containing pairs of point feature Unique Identifiers (UIDs), and need to calculate the straight-line distance between each of these pairs. The XY coordinates of the individual ...
2
votes
2answers
81 views

How can I use a DBF layer in an R script in QGIS?

How can I use a DBF layer in an R script in QGIS? For example, I can input a vector by using ##Layer=vector, and a CSV table with ##Table=table, but it will fail if the table is based on a DBF file. ...
2
votes
4answers
4k views

What software for direct editing of a DBF file?

I am currently processing GPS log data from my holiday and need to add information to the points. I remember I used OpenOffice and later LibreOffice to directly edit the files but currently I am ...
2
votes
1answer
880 views

How to export Select By Location result to Excel using Python and ArcPy?

I have been using ArcGIS for a few years now but have only started using Python scripting for ArcGIS for a month or so. I am trying to create a script and I am having a hard time trying to get it to ...
2
votes
2answers
455 views

Error Importing dbf File Into GRASS

I am working on an assignment which requires me to connect to a database, then import a dbf file into the database using the command db.in.ogr (as can be seen below). However, GRASS simply won't ...
2
votes
0answers
79 views

SHP, SHX and DBF files became empty (zero byte) overnight on QGIS

This literally happened overnight. I was working on a shapefile in QGIS 2.4 last night but my files (SHP, SHX and DBF) all become zero byte this morning. Has this happened to anyone before? How ...
2
votes
0answers
250 views

ArcGIS 10.0 - problem with exporting a huge geodatabase table to CSV or DBF

ArcGIS 10.0 SP5 @ Windows XP Intel® Core™2 Quad Processor Q9650 (12M Cache, 3.00 GHz, 1333 MHz FSB) 3 GB RAM In a file geodatabase I have a point feature class with a huge amount of records (over ...
1
vote
2answers
107 views

Moving shapefile using Python shutil?

I'm attempting to iterate through several shape files within a folder and only move some of them to a new folder. I'm doing this based on contents of the DBF file where I'm using dbfread to determine ...
1
vote
1answer
1k views

How to access row from dbf table?

I have got the following problem: I would like to access a row from a dbf table. I have tried to access it through SearchCursor, but I am not able to do it without knowing the field name. This is my ...
1
vote
2answers
1k views

How to read ArcGIS files in R?

I am new to using spatial data in R. So far the tutorials I have seen consist of using maptools, map, ggplot2 and rgdal to open ".shp" files along with ".csv" files to plot the polygons/ points using ...
1
vote
2answers
765 views

NA values in dbf when exporting shapefile from R with writeOGR?

I´m writing an esri shapefile from R (2.14.1) on windows, using writeOGR in the rgdal package, in the resulting dbf file, NA values in the spatialpointdataframe (in numeric columns) are not translated ...
1
vote
1answer
51 views

How can I open a standalone .dbf file in QGIS?

Unlike the apparently similar question already asked where the .dbf is associated with the .shp, my problem is simply opening a .dbf in order to join it with a disconnected shapefile by table join. ...
1
vote
1answer
261 views

How to import multiple shapefiles without any dbf to a postgis database?

I have a polyline shapefile (.shp and .shx) without .dbf. I would like to import the shp into Postgis. In order to do that, I created the corresponding .dbf using the r code provided by mdsumner in ...
1
vote
1answer
231 views

vb.net arcmap add-in loop through a dbf file get 'System.NullReferenceException' error

I am using vb.net arcmap add-in. I encounter a System.NullReferenceException error and cause arcmap crash. The workflow in my vb.net code is: (1) create a ShapefileWorkspaceFactory (2) use the ...
1
vote
1answer
338 views

Why does QGIS generate Shapefiles without DBF?

I need to output shape files for archiving, which requires generating .shp, .shx and .dbf files. When I save a layer as a shape file it generates the first two, but not the dbf. All the help I can ...
1
vote
1answer
131 views

How to check the encoding in the .dbf files?

I am having difficulties when I try to load a shapefile into my database, the is because I do not know the encoding of the dbf portion of the shapefile. The attribute tables are in Spanish, I have ...
1
vote
1answer
231 views

arcmap layer export as shapefile, in the dbf file the time value is missing

In arcmap, I export a layer as shapefile. After that I find from the dbf file, the editor tracking date-time columns (created_date, last_edited_date) value only contain the date value, The time value ...