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

0
votes
0answers
10 views

geotools shapefile does not support utf-8 for dbf header

I create a ShapefileDataStore to create a new shapefile and call dataStore.createSchema(...) . But it does not work for utf-8 header fields. I checked the geotools source code and realized that it ...
3
votes
2answers
55 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 ...
1
vote
0answers
30 views

Export to .dbf changes my data in ArcMap 10.2.2

I have an excel table with parcel ID's (PINs). The PINs are in "number" format in excel. Iimported this excel table into ArcMap with the goal of joining them with the county parcel shapefile. I ...
3
votes
1answer
44 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 ...
1
vote
1answer
77 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
2answers
83 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 ...
3
votes
1answer
51 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 ...
4
votes
2answers
133 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 ...
1
vote
1answer
31 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. ...
2
votes
1answer
46 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 ...
0
votes
1answer
29 views

Failed to export all rows in attribute table in ArcMap to .dbf

I would like to export a large attribute table to .dbf format, which includes almost 5,000,000 rows. But the exported table only contains about half of the rows without showing any error message ...
1
vote
2answers
62 views

ogr2ogr unreadable dbf file header

I'm trying to convert Mapinfo tab file to ESRI shapefile using ogr2ogr either with sqlite dialect or without. When using sqlite dialect, ogr2ogr -overwrite -f "ESRI Shapefile" -dialect sqlite -sql ...
2
votes
2answers
70 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. ...
0
votes
0answers
57 views

How to effectively read and analyze multiple dbf tables?

I have multiple standalone dbf tables in a geodatabase (when saying standalone, I mean they don't have spatial components). I found this post Reading File Geodatabase using R indicated R is a ...
0
votes
1answer
47 views

Adding dbf to ArcMap 10.2 receiving warning

This is the error message I receive when I am trying to add a dbf file to ArcMap 10.2. the warning reads: Could not add the specified data object to the map. The Field type is invalid or ...
0
votes
1answer
23 views

Creating polygons or map book from DBF file through ArcPy?

I have a dbf file, which contained a list of coordinate information as shown in below. It also could be thought as a catalog file. Example: ID XMIN YMIN XMAX YMAX 1 -52800.0 ...
-1
votes
1answer
107 views

How to extract information from world file of images into a DBF catalog file through PYTHON?

Here are thousands of pictures in JPG or TIF format with world file such as jgw and tfw. Inside each file, projection information for each pictures were contained. One example of the content for a ...
2
votes
1answer
289 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 ...
1
vote
1answer
83 views

Export to .dbf and .mdb

A have a number of shapefiles and I want to export their attribute table to .dbf and .mdb (Microsoft Access file). How can I do this with ArcGis or with any other tools? Notice that I want to keep ...
0
votes
1answer
81 views

Python error in search cursor function

I need to access the dbf file to extract variable list (i.e. "CODE"). Basically I am calling dbf file to allMamrows variable and then I am appending using for loop. On running the script I am getting ...
1
vote
1answer
61 views

How to turn a shapefile into a table?

How do you completely turn a shapefile (created with QGIS, including .shx and the other 4-5 files) into one tabular dataset. I am actually doing this when I import the shapefile into Postgresql ...
1
vote
2answers
616 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 ...
0
votes
2answers
136 views

Deleting rows on dbf table with python for ModelBuilder?

Being not very familiar with python, and after carrying out unfruitful long researches on internet, I submit to you my problem, hoping favorable reply. I have a DBF table with geochemical data and I ...
0
votes
0answers
213 views

Export geodatabase feature class to .dbf or .txt file

I have 40 super large (millions of records) geodatabase feature classes (areal data) and would like to export their attribute tables into .dbf or .txt files using model builder. I tried using "table ...
0
votes
0answers
9 views

Shapefile (dbf) to MySQL conversion? [duplicate]

Is it possible to convert the exported data of shapefile to MySQL? I want to use MySQL instead of dbf since dbf are prone to corruption.
1
vote
1answer
72 views

Joining dBase (*.dbf) table to Coverage?

I have a dbf table and a polygon coverage. How do I join and save the joined data to the coverage without exporting to feature class and then re-creating a coverage in python? I have been looking at ...
1
vote
1answer
212 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
0answers
39 views

Region partitions (shapefiles) comparison in ArcMap 10

I have 2 shapefiles, in each file the region is divided into zones. Each zone from 1st ("large") file is "almost" a union of a few zones from 2nd ("small") file. Specifically, for each union in ...
2
votes
0answers
76 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 ...
1
vote
1answer
123 views

How to import `numeric` fields from csv to dbf in ArcGIS?

I am trying to import a CSV into a DBF using ArcCatalog (10.1). In the field map, pictured below, I can only set an ID field to Long, Text, Double, etc. But there is no Numeric type as in DBF and ...
1
vote
0answers
51 views

BTS 2014 Highway Performance Monitoring System over 2gb dbf limit

http://www.rita.dot.gov/bts/sites/rita.dot.gov.bts/files/publications/national_transportation_atlas_database/2014/polyline The dbf in question is part of the hpms.shp The error I receive when trying ...
1
vote
1answer
83 views

Rename long column names for dbf conversion

Is there an ArcObjects API call that will rename long column name? If a column name is too long for conversion to a .dbf file, I want rename to a valid length. I have searched ArcObjects help. Either ...
5
votes
1answer
1k 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 ...
1
vote
1answer
182 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 ...
1
vote
0answers
26 views

Joined field not recognized as number in QGIS 2.4 [duplicate]

I have a weird problem. I've loaded in QGIS a point shapefile and a CSV table. Then I performed a join between the 2 layers and all works fine. But then the joined columns (made of integers or real ...
1
vote
1answer
174 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
121 views

Table to dBase tool failure when converting .xls files

Whenever I load my Excel 2010 worksheets into ArcMap 10 Table to dBASE tool, it fails, returning the error: "Failed to Copy Rows" The Copy Rows tool works just fine for me on a single document. There ...
0
votes
1answer
110 views

Problems Joining CSV to Shpfile arcgis 9.3

So I have been trying to get this to work all day and have had no success. I am attempting to join a CSV file with a Shapefile. The CSV is from the Hud's location affordability portal ...
1
vote
2answers
837 views

How to merge dbf files(zonal statistics as a table) in GIS environment.?

I am not very savvy at using Python. Actually I have around 1000 output files from using the tool zonal statistics as table in ArcGIS. The names of the files are jan_60, feb_60......dec_13. These all ...
0
votes
0answers
160 views

Generating XML to create a file geodatabase table from an existing shapefile DBF

I am writing a C# .NET application to convert a folder of shapefiles into a file geodatabase. Basic Info Windows 7 64 bit VS 2010 - Application is being run as 64 bit. Version 1.3 of the File ...
1
vote
2answers
202 views

Keep leading zeros when converting .txt into dbf using CopyRows management

I am writing a python code in order to bring my.txt file into a dbf file in arcgis. I am using CopyRows_management which seemed to be working just fine until I realized that one of the 40 fields from ...
4
votes
3answers
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 ...
3
votes
1answer
725 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 ...
2
votes
4answers
3k 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 ...
3
votes
2answers
121 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 ...
2
votes
0answers
229 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 ...
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
821 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 ...
1
vote
2answers
173 views

How to view dbase tables?

Using Linux, is there something out there to quickly view a dbase file? Sometimes there are look-up tables(.dbf) to accompany a shapefile. Libre Office Calc can't read it. Maybe a QGIS plugin that can ...
1
vote
1answer
198 views

dbf file size is increased after exporting opened Shape file into new Shapefile

I have a shape file(polygon features) which has 7 attributes(id,area,etc.,) in dbf file. After reading the shape file i am exporting to a new Shape file in Which i am adding 2 attibutes (id ,area). ...