Questions tagged [dbf]
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.
148 questions
1
vote
0
answers
47
views
Classifying spatial data using QGIS [closed]
I have two files: geologie.dbf and Legenda_Geologie.xls. I need to classify some regions within the area that I am studying but I am not exactly sure how to do that.
Do I need to manually type the ...
- 11
0
votes
2
answers
33
views
Table to Geodatabase script in ArcGIS Pro failing with error 000210
After adding a .csv file (Some_Table.csv) to a project in ArcGIS Pro, I need to save the file to a .dbf file. The Table to Geodatabase script runs without creating any output whatsoever, and I get the ...
- 629
0
votes
1
answer
78
views
Can't load DBF attribute table correctly - QGIS
I'm trying to load in QGIS a shapefile with an edited DBF file. The objects are loaded correctly, but not the attribute table, which mixes the data from different cells.
It is a very large DBF with ...
0
votes
1
answer
1k
views
ArcGIS Pro Shapefile : polygon not visible
I'm a Master's student in oceanography research and I'm using the latest version of ArcGIS Pro. I am using data from the Canadian Ice Service Arctic Regional Sea Ice Charts in SIGRID-3 Format, Version ...
0
votes
1
answer
92
views
Remove "orphaned" entries from a .dbf file in PyQGIS
I have some shapefiles.
They have associated .dbf files with them that contain many many rows of data corresponding to objects that were clipped from an earlier file.
How can I use Python to clean up ...
- 1,481
1
vote
1
answer
380
views
Sort SHP features by feature ID in QGIS
I have a shapefile which does not have any ID column. I put them in a validator, which indicates the ID of faulty features, based on the DBF line order. But by opening the shapefile attribute table in ...
- 363
1
vote
0
answers
745
views
Converting dbf to shp with QGIS
I want to transform dbf to shapefile with QGIS. I see the polygons in QGIS, but when I try "export", "save as", or from Toolbox "Extract/Clip by extent" - I see the ...
- 11
1
vote
1
answer
444
views
Creating empty DBF table and populate it with PyQGIS
I need to create a standalone DBF file with some features. I know how to add the fields but I'm not able to add features and to create only a standalone DBF, without any other files such as .shp or ....
1
vote
0
answers
374
views
How to reduce the dbf size in shapefile in QGIS?
Edit of post: I decided to edit the post to answer the comments below / and to change the example of shapefile that I used originally.
I am working with QGIS and I have a shapefile with points (that ...
- 11
0
votes
0
answers
99
views
Construct a shapefile from information in a dBase file in QGIS
I am using QGIS. I have been provided a dbf file but no shp or index files. Each line in the .dbf file corresponds to a line I wish to show on the map. Each line in the .dbf file has a unique ...
0
votes
0
answers
745
views
Unable to delete .shp and .dbf files from directory when on canvas PyQGIS
I am creating a standalone PyQGIS application and is met with a problem.
When a shapefile is shown on my canvas, I am unable to delete the corresponding .shp and .dbf files in my directory.
This is ...
- 143
3
votes
1
answer
1k
views
No .shp files only .dbf files
I've recently been given a set of files to work on/analyze with QGIS, but they seem to be missing any .shp files.
Basically, the data is organized into a bunch of folders labelled land, water, etc. ...
- 55
2
votes
0
answers
97
views
When importing shapefile attributes (in a DBF) does the order of columns matter?
I'm working to import a batch of 250+ shapefiles into PostGIS. I'm using the shp2pgsql utility to load data.
While doing some basic preparation I've realized that a few are missing 1-2 columns (...
- 21
3
votes
2
answers
15k
views
Importing DBF files into Microsoft Excel [closed]
I'm working through the book "GIS Tutorial 1" and it wants me to open up a DBF file in Microsoft Excel. But when I try to open it, I'm running into some issues. First thing that seems weird ...
0
votes
1
answer
355
views
How to open .dbf table exported from ArcMap 10.7 with Access 2013 or later Microsoft Office versions? [closed]
I have exported an attribute table as .dbf file with ArcMap 10.7 but if I try to link it to an Access 2013 database (it works fine with Access 2007) I get a message error "Could not find installable ...
- 33
1
vote
1
answer
434
views
Dump all spatialite tables to shp and dbf
Given a spatialite database i want to export/dump all tables to shapefile (or dbf for those without geometry).
I want to do it programatically so acceptable solutions will be using a (bash) command ...
- 4,638
1
vote
1
answer
319
views
Excel to Table Conversion on multiple Excel files in folder using ArcPy gives ERROR 000814
I am trying to convert all of xls files (including single sheet) a folder into dbf tables in a gdb.
Here is my code:
import arcpy, os, xlrd
arcpy.env.overwriteOutput = True
arcpy.env.workspace = "C:...
0
votes
1
answer
32
views
Adding dbfs in ModelBuilder?
I have built a model in ArcGIS ModelBuilder for which the output is several dbfs having five columns. I want to merge all the output dbfs into a 'master' dbf sheet in the model itself.
How would I ...
1
vote
1
answer
129
views
Export DBF from shapefile with ModelBuilder (to make a XY event layer)
I'm using ModelBuilder and I need to export a shapefile to a DBF. Usually I go to "table option" and I click to "Export", how can I do it with ModelBuilder?
I need to do this process because I have ...
- 13
0
votes
0
answers
93
views
When re-saving a GeoJSON file to a shapefile, the .dbf significantly increases in size
When re-saving a GeoJSON file to a shapefile, the .dbf significantly increases in size to the point where the file size becomes unmanageable.
For example, I re-saved a 250 MB GeoJSON file to ...
- 649
1
vote
1
answer
5k
views
Why is PyShp unable to open my .dbf or .shp files? [closed]
Trying to learn to use Python to map some geographic data by following some tutorial and I can't seem to get them to work. I'm hoping this is just a simple error on my part.
First, the link(s) to ...
- 11
0
votes
1
answer
134
views
pyqgis: dbf blocked after removeLayer
I developed a plugin in QGIS. One of the processes consists in remove some layers from the QGisProject, use them with other third party code in C# (maybe layers are modified by C# code) and finally ...
- 1
1
vote
2
answers
229
views
Attribute Joining with .shp and .dbf showing NULL values in ArcMap?
I have a shapefile that only has 2 fields, one of which is the same as one of the fields in the .dbf file. I tried joining these 2 by their common field but after I do so, the 10 other fields in the ....
- 155
4
votes
1
answer
5k
views
Why are Shapefiles limited to 2GB in size? [closed]
I'm hoping somebody can clarify for me why .shp are limited to a 2GB file size? Having read through the ESRI considerations and technical description, I cannot understand why it exists.
Since they ...
- 426
1
vote
0
answers
232
views
Merge dbf files from different folders in Python or Arcpy
I am new to Python. I have over one hundred dbf files to merge in two diffrent workspaces.
Workspace 1:
PCPT100100
PCPT101101
PCPT102101
Workspace 2:
s100100
PCPT101101
s102101
I want to merge "...
- 11
1
vote
0
answers
616
views
Large increase in .dbf file size after attribute table join
I have a polygon shapefile of about 12,000 features that I joined a CSV attribute table to using 'Join attributes by field value' in QGIS 3.2.1
The .dbf file size before the join = 5.6 MB
The .dbf ...
- 649
2
votes
1
answer
437
views
Converting CSV to DBF using ArcPy giving ERROR 000732
My code
import arcpy, os, shutil, re
from arcpy import env
arcpy.env.workspace = "R:\GIS_Data\Earthquake_Data\Updates\Eq_updates.mdb"
path = r"R:\GIS_Data\Earthquake_Data\Updates"
...
- 31
1
vote
0
answers
90
views
What happens to .dbf file with TableToDBASE?
I have been trying to use TableToDBASE without success. I looked at this help link: http://desktop.arcgis.com/en/arcmap/10.3/tools/conversion-toolbox/table-to-dbase.htm. The code runs fine but it does ...
- 11
1
vote
0
answers
89
views
DBF file type changed to .txt - how do i return to original source
I have opened a dbf file as txt to edit some of the data, now I cannot find the original default programme to open the dbf file with. I tried changing the default programme for the dbf but the QGIS ...
- 11
1
vote
1
answer
123
views
999999 Generic Error when converting CSVs to dBase with TableToTable_conversion()
I am attempting to convert 5 fairly large CSV files into DBFs using ArcPy.
My code is below.
Currently when I run this script I am met with the following error:
ExecuteError: ERROR 999999: Error ...
- 348
0
votes
0
answers
31
views
Precision and scale 0 after passing parameters
I have a field in GIS that it needs a precision and scale argument. Using Arcpy, I pass the argument like this:
d_fields = ["acres" , "p_dev"]
for field in d_fields:
arcpy....
- 359
-1
votes
1
answer
75
views
Using dBase table converted from CSV to Make Route Event Layer?
I'm using the tool 'Make Route Event Layer' and I need to use a dBase table for the event table, but the data are saved in a CSV file. When I try with dBase table that I created myself all go good, ...
- 21
3
votes
1
answer
352
views
Geotools: Set custom primary key
I have a script which reload data from dbf file and create a new table in postgres database using geotools plugin.
My problem is when geotools reload fields name from the file it adds a new field fid ...
0
votes
2
answers
2k
views
Edit a shapefile
I am in the ag field and no time or resources for learning or buying GIS to solve one problem.
I have a shapefile that came off a Raven monitor in a tractor that was used to plant a crop.
I use ...
0
votes
1
answer
98
views
Using ModelBuilder to intersect point data against multiple polygons?
I'm a novice GIS user and looking to create a model in ModelBuilder that can intersect point data which is a survey data made up of 1000's of individual points in dbf format.
This data will change ...
- 1
2
votes
1
answer
9k
views
Saving dataframe as dbf with simpledbf in Python?
I am doing a number of joins outside of ArcGIS as pandas seems to outperform it. I read in the dbf file with simpledbf, convert it to a dataframe, then do the join:
import pandas as pd
from simpledbf ...
- 843
2
votes
1
answer
418
views
ArcGIS Error: ERROR 000223: Cannot extract event table properties while trying to create an event layer using ArcPy
I have a .dbf file and want to change it to a .shp file with its LAT/LON.
ArcPy Code,
import arcpy
arcpy.env.overwriteOutput=True
dbffile = "GIS_counts.dbf"
spref = arcpy.SpatialReference(4326) #...
- 794
1
vote
1
answer
431
views
Fix the data type properties of fields when a shapefile is manipulated in R
I manipulated a shapefile in R with this code:
d<-readOGR("RECFE.shp")
dsub<-d[d$MUNICIPIO==86,]
writeOGR(obj=dsub, dsn="data", layer="ledes", driver="ESRI Shapefile")
In the dsub dataset some ...
- 35
0
votes
1
answer
2k
views
Manipulate dbf files in R
I load dbf files in R and then I manipulate it because I only want some features and after that I export it.
But when I will open the shapefile with the same name in a GIS software features are ...
- 35
0
votes
1
answer
11k
views
How to color different regions that are on one single layer
I received the following files:
.shp .shx .dbf
I opened the shapefile using QGIS 2.18 and I see there only one layer. I did Add vector layer.
I'd like to be able to color different regions with ...
- 11
4
votes
1
answer
426
views
Clipping large shapefile in ArcMap and .dbf size remains same?
I'm working with a large point dataset (700,000+) features which is just over 2gb in size. I wanted to split the dataset to reduce file size. However when I do a clip in ArcMap 10.5 on the shapefile, ...
- 12.1k
1
vote
3
answers
2k
views
dbf to excel format
I have a .dbf file from arcgis 10.1 and it contains 370 columns and 582 rows. I want to open it in excel but it can only open 256 columns no more than that.
There's a way that I can break a file and ...
- 39
2
votes
1
answer
956
views
Change Datatype of .dbf Column in QGIS
Software: QGIS 2.18.19
Spreadsheet: Office Libre 5.3.4.2
GitHub Link: Bklyn
Update 1
@ben-w
I turned on Toggle Editing. When I tried to change datatype, I get error
Original Question
I wish to ...
- 301
5
votes
2
answers
59k
views
Error in (function (classes, fdef, mtable) : unable to find an inherited method for function ‘shapefile’ for signature ‘"NULL"’
I've used the following code to generate home range isopleths using r:
library(rhr)
library(rgeos)
#list all *.txt files.
fls <- list.files(path = "C:/Users/evan/Desktop/mydir", pattern = "*.txt",...
- 338
2
votes
2
answers
2k
views
Creating GeoJSON from DBF file
Can I create GeoJSON from DBF where X and Y coordinates are stored as normal attributes.
Is there something in ogr2ogr, which can create GeoJSON?
Example DBF file link:
- 752
2
votes
0
answers
429
views
Convert node data to lat/ long > DBF to CSV conversion
I have a DBF table with nodal data locating cycle injuries in Portland, OR. I'd like to convert the table to a .CSV. Transferring the attribute data isn't a problem, but I'd like to get lat/long ...
- 197
2
votes
1
answer
418
views
When converting xls to DBF table, can I change the length of text fields?
I used the code:
arcpy.ExcelToTable_conversion(XLSfile, DBFfile)
The data comes across looking fine, but all text fields in the dbf have length of 254. Is there a way, either in the excel file ...
- 486
1
vote
1
answer
609
views
In a shapefile, is it possible to have multiple rows linked to a same map feature?
I want to know whether it is possible to have more than one row of the dbf file that comes with a shapefile map linked to the same feature of such shapefile. The reason for that is simple: to have ...
- 19
0
votes
1
answer
2k
views
Saving layer as shapefile (shp)
I'm trying several spatial statistics analysis in my QGIS 2.18.3 project (convex hull, random points inside polygons, point sampling tool, basic statistics for numeric fields, distance matrix, nearest ...
- 375
0
votes
2
answers
339
views
Generating dbf from gdb feature class
I'm interested in generating a dbf from a feature class in a gdb. I am also interested in selecting only 6 out of the many fields, which is why I added steps to keep only wanted fields. I am using ...
- 246