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

3
votes
1answer
27 views

DBF to geoserver

I have a table as DBF.I would like to add the DBF to geoserver.I know we can publish a postgres table to geoserver. But i would like to know is there any way to add a DBF directly to geoserver.
0
votes
0answers
19 views

Can a table (.dbf) be encoded in two different systems?

I am having a *.dbf-file. When I load it into QGIS (delimited text-file) I am having trouble getting all the characters right. Either I load it in encoding=windows-1252 - then the headers will be ...
2
votes
2answers
464 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 ...
0
votes
2answers
202 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
1answer
38 views

PostGIS Shapefile and DBF Loader - automatically Linked dbf file

This is my system: Windows 7 Postgresql 9.5 PGADMIN 3 PostGIS Shapefile and DBF Loader plugin I have imported data from a DBF file correctly with the plugin. My problem: This DBF file changes ...
0
votes
1answer
34 views

Files resulting in dBASE table and projection file but not shapefile

Received data from an agency I'm working with. The documentation they included said what they're sending me is a shapefil. When I go into ArcCatalog all that appears is a dbase table and project file. ...
4
votes
2answers
924 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 ...
3
votes
1answer
659 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 ...
18
votes
4answers
12k 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 ...
1
vote
0answers
40 views

Geocoding a DBF table on ArcGIS 10.3

I am trying to geocode address onto a map in ArcGIS 10.3. The table is in dbf format and contains address, city, state, and zip. I have attempted going to ArcCatalog and adding an address locator. I ...
1
vote
2answers
798 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 ...
4
votes
4answers
8k 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 ...
0
votes
2answers
1k views

Exporting data from DBF to Excel template using ModelBuilder?

I have created a model in ModelBuilder that uses the iterator tool to run through a polygon layer and clip a raster based on the polygon's unique name in the attribute table. The model then copies the ...
2
votes
1answer
96 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 ...
1
vote
1answer
69 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 ...
2
votes
1answer
42 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 ...
4
votes
4answers
4k 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 S:\...
0
votes
0answers
63 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
130 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
81 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 ...
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 ...
1
vote
1answer
205 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
162 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
71 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
188 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
131 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. ...
3
votes
1answer
73 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
50 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 ...
11
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 ...
2
votes
1answer
260 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 ...
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.
1
vote
2answers
111 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 "...
36
votes
4answers
28k 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' - ...
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
2answers
84 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
77 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
91 views

Adding dbf to ArcMap 10.2 receiving warning [closed]

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 unsupported ...
0
votes
1answer
28 views

Creating polygons or map book from DBF file through ArcPy? [closed]

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
143 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 ...
25
votes
4answers
13k 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 ...
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 ...
3
votes
1answer
918 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 ...
1
vote
1answer
106 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
111 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
65 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 ...
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?
0
votes
0answers
342 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
1answer
292 views

How to create DBF field with length > 254? [duplicate]

Is it possible to create a text field in a database (DBF) table with a length that is greater than 254 characters? Using ArcGIS 10.1 for Desktop.
1
vote
1answer
96 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
291 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 ...