Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

2
votes
1answer
251 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 ...
1
vote
0answers
23 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 "...
1
vote
0answers
46 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 ...
0
votes
0answers
19 views

Limiting decimal digits in attribute table of a dbf file using writeOGR function of R?

I'm writing an ESRI shapefile using writeOGR function of R on a linux platform. Then I visualize the dbf file using dbfdump command to read the attributes but the real numbers in the attribute table ...
1
vote
1answer
31 views

Conversion of CSV to DBF is getting error message, why?

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" In_path = r"R:\...
1
vote
0answers
19 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 ...
1
vote
0answers
29 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 ...
1
vote
1answer
51 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 ...
0
votes
0answers
17 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....
-1
votes
1answer
26 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, ...
3
votes
1answer
36 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
2answers
123 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
1answer
49 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 ...
0
votes
1answer
624 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 ...
0
votes
1answer
91 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) #...
1
vote
1answer
49 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 ...
0
votes
1answer
377 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 ...
0
votes
1answer
1k 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 ...
4
votes
1answer
123 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, ...
1
vote
3answers
257 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 ...
2
votes
1answer
346 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 ...
1
vote
2answers
11k 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",...
2
votes
2answers
356 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:
3
votes
0answers
198 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 ...
3
votes
1answer
126 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 ...
1
vote
1answer
123 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 ...
0
votes
1answer
1k views

Impossible to save a layer as a 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 ...
0
votes
2answers
54 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 ...
2
votes
0answers
72 views

Overlaying thousands of points of a route from shapefile and dbf on google maps

I have to overlay thousands of points(data taken every second) of a route from shapefile and related data for each points in dbf. I have to show point related data in a popup on click of a point. I ...
1
vote
0answers
103 views

QGIS Intersection tool not allowing Save file as Shapefile

In QGIS 2.16.2 I am trying to intersect two Shapefiles to create a third Shapefile, however the Intersection tool is only allowing Save file as DBR, CSV, XLSX or ODS - not SHP. One of the Shapefiles ...
2
votes
1answer
224 views

Which Shapefile parts are necessary to convert to geojson?

Which of those files are needed, to be able to convert them to geojson without losing any information? From what i know: *.shp - contains coordinates for lines, points, and other geometries *.prj - ...
1
vote
0answers
52 views

Regular/continuous mapping [closed]

We've a regular (daily/weekly) provincial mapping process that uses .dbf files created with SAS (software like R, SPSS). An ArcMap document .mxd file (relative path) has map layers (crops) joined to ...
0
votes
1answer
553 views

How to export large attribute table from Arcmap and import it into R?

I intersected 5 shapefiles (you can find the question and data here) to get polygon shapefile. In which, each polygon has ALL the attributes from the 5 layers. You can find the shapefile resulting ...
4
votes
1answer
673 views

Why does shapefile's dbf convert YYYY date to YY-format?

I save date from database's timestamp to shapefile date attribute. For example, I took from database [2031,10,31] and set it to '31.10.2031' at shapefile using python's shapefile.py as sh: self.sh....
4
votes
1answer
3k views

How do I create/write a Shapefile with UTF-8 encoded attributes with ogr2ogr?

I'm using GDAL/OGR's ogr2ogr command line tool to export data from a PostGIS-enabled PostgreSQL database to various GIS file formats, Shapefile amongst them. To create a shapefile with the default ...
1
vote
1answer
377 views

ogr2ogr: How to convert Oracle tables DBF

I wish to convert a layer that has no geometry field from Oracle to the Esri Shape format (DBF file only). I can do it manually from within QGis but I'd like to automate the process and use ogr2ogr (...
1
vote
2answers
818 views

Fill fields in PDF with python from final product of Model Builder [closed]

I am trying to fill a PDF file from a Excel file data produced by a Model Builder after GIS processing with ArcMap. I am using the Python language. I consider that using a PDF form is the most ...
0
votes
1answer
91 views

Field Error in ArcPy TableToDbase conversion

I am trying to convert a .csv file in Python/ArcPy to dBase format. I am using this code: import arcpy inputcsv = "D:/2016_08_21.csv" outputfolder = "D:/" arcpy.TableToDBASE_conversion(inputcsv, ...
6
votes
1answer
167 views

Why are values different between attribute table in QGIS and dbf?

I'm working on a shapefile on QGIS 2.8.6, on Debian Jessy. Its attribute table contains two columns (real 8,6) for longitude and latitude coordinates. When working from QGIS I'm able to write normal ...
3
votes
1answer
180 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.
1
vote
1answer
122 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 ...
0
votes
1answer
1k 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 ...
1
vote
1answer
51 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 Shapefile. When I go into ArcCatalog all that appears is a dbase table and project file....
1
vote
0answers
126 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 ...
2
votes
1answer
175 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 ...
2
votes
1answer
128 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 ...
0
votes
0answers
453 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
1answer
705 views

Merging DBF files without using ArcPy? [closed]

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
1answer
283 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 ...
6
votes
1answer
595 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 ...