Tagged Questions

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

17
votes
3answers
970 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 ...
16
votes
3answers
2k 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 ...
13
votes
4answers
4k views

How to add an attribute field to an existing Shapefile via Python

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 ...
9
votes
11answers
3k 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 ...
7
votes
3answers
1k views

How do you determine a shapefile's charset?

Is there a way to determine the charset used for a given shapefile?
4
votes
2answers
147 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
2answers
921 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?
4
votes
1answer
311 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
806 views

saving a dbf as xls in 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 ...
3
votes
1answer
1k 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 ...
3
votes
2answers
1k 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 ...
2
votes
2answers
589 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
164 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 ...
2
votes
1answer
279 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
2answers
289 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
78 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 ...
1
vote
2answers
349 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 ...
1
vote
2answers
282 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
196 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
1answer
285 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 ...
1
vote
1answer
139 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
272 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 ...
1
vote
0answers
38 views

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

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

Python 3 module to read ArcGIS .dbf files

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. All the modules I found were only compatible with ...
0
votes
1answer
98 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
0
votes
1answer
351 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- ...