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
9 views

pgsql2shp converting nulls to spaces

Why does PGSQL2SHP convert null values to spaces when exporting a table? I would have expected empty strings in the shapefile (dbf).
0
votes
0answers
8 views

proper way to export editor tracking information

I have several layers use editor tracking to trace the editing actions. Although I can get the editor tracking information through attribute table of individual layer, use want to use a button to ...
0
votes
1answer
41 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
24 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
50 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 ...
0
votes
1answer
28 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
0answers
18 views

Adding attributes to a hexagonal grid generated with MMQGIS

I generated a hexagonal grid with MMQGIS, and I need to add some attributes to each hexagon. Is there a convenient way to do this or I have to work with the dbf file? In that case, what is the meanign ...
0
votes
1answer
52 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
118 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
73 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
76 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
837 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 ...
0
votes
0answers
28 views

Joining by location - DIVA-GIS .dbf layer not included

I want to get place names from a .dbf file displayed on my map. I've imported the .dbf file as a vector layer. The gazetteer table does not have any ID fields so I was trying to use the "Join by ...
3
votes
1answer
222 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
votes
2answers
173 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 ...
0
votes
0answers
54 views

Removing multiple categories from GRASS vector feature

Pardon my lingo if this is not entirely correct - I am a software developer, not a GIS person. We're working a project that uses v.overlay to merge a map of slopes with a map of soil tests to produce ...
3
votes
2answers
77 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
137 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 ...
0
votes
0answers
14 views

How to export style in sld-format using attribut fields of a shape? [duplicate]

I have some ESRI-Shapes with a .dbf each. In the dbf-File there are attributes like a string. Now i can use one or more attributes to display for example a text on a point by configuring a style. This ...
2
votes
2answers
531 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
382 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
105 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
114 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). ...
1
vote
1answer
510 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
1answer
127 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 ...
0
votes
2answers
819 views

How to export 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 ...
1
vote
0answers
221 views

PyQGIS joining a dbf to a shapefile

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() ...
1
vote
0answers
141 views

How do I edit a shapefile DBF to repair an extra row?

Something got screwed up and now the rows of my DBF beyond #1210 are offset by one, meaning that each shape has the attributes that should be assigned to the next shape. If I were in a spreadsheet ...
-3
votes
3answers
873 views

How to add a field to a shapefile using R

This question is trying to make sense of a post that already exists that looks good, but is failing in practice. The second ranked answer uses the foreign package to read a shapefile attribute table ...
1
vote
1answer
2k 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 ...
2
votes
1answer
791 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
784 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 ...
0
votes
1answer
209 views

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

Is it possible to create a text field in a database table with a length that is greater than 254 characters? Using arcgis 10.1
3
votes
0answers
521 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 ...
18
votes
3answers
3k 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 ...
4
votes
2answers
330 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 ...
2
votes
2answers
381 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 ...
1
vote
1answer
198 views

v.dissolve renames the attribute table column and does not produce a dbf

When I run v.dissolve on my vector... v.dissolve --o input=pass2@mapset1 layer=1 column=fttcp output=pass3 The dissolving appears to work but the column name in the attribute table has changed from ...
1
vote
2answers
625 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 ...
4
votes
2answers
1k views

How do I convert a text file with coordinates to database table in Python?

How do I convert a text file with point coordinates to database tables in the Dbase.dbf format in Python?
5
votes
3answers
2k 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 ...
2
votes
1answer
422 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 ...
1
vote
1answer
226 views

ArcPy: Creating weekly-sum layers by summing field values from seven consecutive daily .dbf's

So 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 ...
1
vote
2answers
489 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 ...
0
votes
1answer
565 views

How to convert dbf to raster the short way?

I have got a dbf file and i want make it to raster file but shor way, Look at my long way, 1- First i add my dbf file 2- and i create tin http://i1211.photobucket.com/albums/cc421/mtnkou/2.jpg 3- ...
3
votes
2answers
3k 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
1answer
528 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 ...
20
votes
4answers
5k 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
0answers
50 views

What are the steps to go from raw address data to a locator report? [closed]

I'm a seasoned programmer, but I'm new to GIS in general. I've read a decent amount of ArcPY documentation but haven't seen an example that takes me from raw data to a locator report, from start to ...
1
vote
2answers
439 views

DBF write support in Ruby

this is repost of the same question on Stackoverflow where I got no answers so far http://stackoverflow.com/questions/5687130/how-to-write-into-dbase-tables-using-ruby-on-osx So, from OSX(Lion) using ...