A tabular set of data linked one-to-one to a set of spatial features.

learn more… | top users | synonyms

10
votes
5answers
14k views

Changing CSV layer attribute value from text to number in QGIS?

I read in a CSV file for linking to a .shp file. All the variables that are just numbers came in as text. How do I change the text variables to numeric in QGIS?
20
votes
10answers
22k views

Adding Attribute data to shapefile?

I can display a shapefile in openlayers but I need to add some attribute data. I can open the dbf file in excel but there is no save as option in excel to the updated file as a dbf. What is the ...
6
votes
1answer
6k views

How to add automate values to attribute field?

I have parcel, Buildings layers, without any information attribute table, and i want to replace "NULL" values with numbers form 1 to 2000, in "Parcel ID", or "Building ID" field thank you.
6
votes
1answer
2k views

How to force ArcGIS to recognize a text field in a CSV file?

Related to Data-type detection in ArcGIS table loading I have a CSV file which contains a mixture of numeric and text fields: ID,Txt,Int,Dbl 12345,abc,45,56.78 12346,9,65,23.12 12347,10,66,23.13 ...
4
votes
3answers
4k views

Automatically update field value in one column based on change to another column in same table?

When editing I want to be able to change the attributes of one field and upon doing this allow for the automatic update of another field in the same attribute table. Essentially I have one layer ...
6
votes
3answers
3k views

Is it possible to have a dynamic table in a data driven page environment?

I am creating a map series that has many polygons per sheet. There is annotation for the polygons however some polygons are very small with no annotation for them (annotation would completely hide a ...
7
votes
2answers
2k views

How to Refresh open attribute table in ArcMap using ArcPy rather than ArcObjects?

I am running the Calculate Field GP tool from the arcpy in ArcMap. When a row value is updated, it does not show up untill I use the Reload Cache tool (Table Options > Reload Cache). How do I refresh ...
8
votes
1answer
323 views

How to automatically populate fields instantly?

I am looking to create an attribute table where the first field is a drop-down menu (I have achieved this by using the 'value map' edit widget), but I'm struggling to find a method for the next part; ...
10
votes
4answers
8k views

How to determine the centroid of polygons?

I have a polygon vector and I want to quickly attain the centroid of this polygon for insertion in a text document. I am working with QGIS. I searched through other questions and although some are ...
1
vote
1answer
82 views

organizing attribute table: multiple sets of variables per point

I would like to have hints on the best way to organize my dataset (I am working with ArcGIS 10.1, advanced license). I would like to build a points layer, each point being a weather station in the ...
7
votes
2answers
2k views

Join attributes of point and line layer by location (closest distance) in QGIS

My problem is the following: i have a line shp (target layer) and a point shp (join layer). the second one (point layer) holds an attribute which i want to join with a line layer based on closest ...
4
votes
1answer
2k views

Finding duplicate records in field using ArcGIS for Desktop?

im looking for duplicate records in dbf files based upon the attribute called 'ID'. I have various dbf files from 500,000 records to 1.5 million and I know there are a host of duplicates. I would ...
3
votes
1answer
2k views

find polygon corner coordinates

I am trying to get the coordinates of each node of the polygon I create. I would like the attribute table to display the name of the polygon (ex. address) and then the coordinates of the nodes (ex. ...
7
votes
2answers
7k views

How to select multiple values with Select by Attributes in ArcGIS 10

Can anyone help me with selecting multiple values from the attribute table? I tried "Classes"='14'AND'07' but it doesn't work.
5
votes
2answers
3k views

How to change position of columns in attribute table?

If I have an attribute table with columns A B C D, is it possible to move the columns to different positions, say, B C A D? When making a new column with the field calculator it would be useful to put ...
3
votes
3answers
3k views

How to get values of each cell in raster attribute table?

How do I get the values of each cell in the raster attribute table. Usually the attribute table gives you the value and number of counts. But, in my case I want each cell listed and corresponding cell ...
2
votes
1answer
307 views

Splitting strings into new rows, retaining geometry

UPDATED BELOW I have 9 shapefiles, each shapefile has 700,000+ rows and I have roughly 12 attribute fields in each shapefile. There are three attribute fields, common to every shapefile, that I am ...
7
votes
4answers
5k views

Where is my attribute table in ArcGIS 10.1? It is not visible

I've just updated to ArcGIS 10.1 and when I go to open an attribute table, I can not see it anywhere. Where did it go and how can I retrieve it? I'm wondering if it is off my screen somewhere or if ...
6
votes
2answers
3k views

Joining tables without losing original field names in ArcGIS for Desktop?

I'm wondering if there is any method to preserve the original field names in ArcGIS when I join csv. tables to a Shapefile. I ask, because sometimes I join tables with 10, 20 or even more columns ...
4
votes
1answer
2k views

Can I access a raster attribute table in QGIS?

I have some Python code that makes Raster Attribute Tables for GeoTiffs using GDAL. In ArcGIS I can see these attribute tables fine and they behave how I like (as classifications). But in QGIS the ...
3
votes
1answer
3k views

Why can't I edit attribute table imported through 'text as layer'

I imported the coordinates from an Excel table. They show as single points as intended. Now I want to add columns to the attribute table, but I'm not able to edit it. I wanted to import the following ...
2
votes
1answer
596 views

Generating sequential numbering for duplicate values in a field sorted by ObjectID

I am trying to figure out a solution to an field calculation problem. What I'm trying to do is automatically (using either ArcPy or the Field Calculator) generate sequential numbers, beginning at 1, ...
2
votes
1answer
885 views

Iterating through columns in table using ModelBuilder?

I am unable to find any info on how to use ModelBuilder to run a certain spatial analysis function on each column in a table. I have a table to sample locations and at each location there are a ...
1
vote
2answers
2k views

Adding new field in ArcMap from data of existing field?

I want to create a new field with years data. There is an existing field with the timestamp YYYYMMDDHHMM but I just want the years from that field to the new field. That way I can display just the ...
0
votes
1answer
28 views

Copying attributes of one row to another row in polygon shapefile in ArcGIS?

I have a single polygon shape file in ArcMap with 25*25m grids, and I want to assign the attribute values of a single grid/polygon to another one close by i.e. copy attributes from a row to another ...
0
votes
1answer
63 views

Why do field values change when exporting from QGIS?

Today I came across a very strange behavior of QGIS. Maybe someone knows what's going on? I have a table with two fields which are defined as Double, with a Length of 20 and a Precision of 0. Some ...
5
votes
2answers
724 views

Sort a feature table by geographic location

Here's in interesting challenge: I need to embed a table in a map layout so that the records in the table are sorted according to their geographic position on the ground. For example, in a ...
4
votes
1answer
2k views

Feature Layer Attribute table to Datatable and make it editable

Hi Currently i'm using this to turn it into a data table featureCursor = layer.FeatureClass.Search(que, false); row = featureCursor.NextFeature(); if (row != ...
12
votes
2answers
3k views

How to select features with NULL attributes in QGIS?

I need to identify which features have null attributes in the attribute table of a shapefile. When i try [field]= 'NULL' it selects the features with value=0 (see picture) Suggestions?
5
votes
4answers
12k views

How to export highlighted features from attribute table to an excel file?

When i selected some portion of the map in QGIS, in the attribute table the selected features gets highlighted... How to export the highlighted features from attribute table to an excel file ...
5
votes
1answer
2k views

How to fill my column with consecutive numbers

I m very new to Qgis, so forgive this simple question. Searching in older topics didn t help either.So: I make a new column in my attribute table and it has a default value(for example 0). I want to ...
2
votes
1answer
446 views

How to make autoIncrement number start with (001…009, 011…099)?

i have a challenge with my time in my work, i have feature class called "Parcel" storing many data, i generated an autoIncrement number by using field calculator, in field "parcel code" Expression: ...
0
votes
1answer
4k views

How to change field formats in ArcGIS 10.1 geodatabase? [duplicate]

I am working with data in an ArcGIS 10.1 geodatabase. I wanted to complete the simple task of taking a ten-digit ID field that is currently in String/Text format and create an identical field in ...
5
votes
0answers
60 views

Altering the order of attributes in a table [duplicate]

I have gone through a sequence of table joins. The resultant table should be with the attributes rearranged in more logical order. I cannot find this functionality within Arc GIS or any mention of it ...
4
votes
2answers
597 views

What is the most efficient way to search a geodatabase for NULL-like records?

The problem: I have a geodatabase with several datasets and many more feature classes within. The fields within the feature classes have been populated through joins with shapefiles and manual edits. ...
4
votes
8answers
5k views

What is the best way to change a data type in the ArcGIS attribute table?

What is the easiest way to change the data type in an attribute table in ArcGIS for multiple fields? Say if the fields have been exported as a string from Excel and I would like to use them as ...
4
votes
3answers
2k views

Comparing table attributes in ArcGIS 10(ArcInfo)

I'd like to compare attributes of two point layers . the layers have some similar records and i try to find these . ArcGIS 10.1 has a tool to comparing attributes but i could'nt find any similar tools ...
4
votes
1answer
3k views

How to detect duplicate attribute values in a table using ArcPy

In ArcMap, the right-click Summarize option very quickly creates a frequency listing of the chosen field: Note that the count field shows the count of duplicate values. How can I access this ...
3
votes
3answers
2k views

Zoom to Feature hotkey in ArcMap Table View

In ArcMap 10 table view, is there a way to set up a hotkey that when a feature is selected, pressing say "z" is equivalent to right-click-->Zoom To? I would like to be able to highlight a record and ...
2
votes
1answer
1k views

Adding fields to raster attribute table

I have a raster attribute table associated with an IMAGINE .img raster that I build and open with: IGPUtilities utils = new GPUtilities(); IRasterDatasetEdit2 raster = (IRasterDatasetEdit2) ...
1
vote
2answers
142 views

Open mail client when clicking feature in Attribute Table

One of the attributes/features of my layer contains an email address. I'd like to be able to open the default mail client by clicking on the mail address from the Attribute Table. After some initial ...
1
vote
2answers
3k views

Join Fields from Multiple Tables to One Table in Modelbuilder

I have 40 tables with about 2000 row with a shared ID that I want to merge into 1 table with 2000 rows. I only want to retain a distance field calculated within each table. The distance field is ...
9
votes
2answers
781 views

Python, GDAL and building raster attribute tables

I have an integer raster for which I would like to build a raster attribute table using Python and GDAL. I can create a GDAL raster attribute table in Python as follows: >>> rat = ...
7
votes
3answers
4k views

Table equivalent to Dissolve for features in ArcGIS for Desktop?

I have a data table that I need to trim down, merging records which have the same value in an ID field and performing a couple math operations on various other fields (summing, averaging). The ...
6
votes
3answers
1k views

ArcGIS 10 attribute table sort issue

what is the solution for this funky sorting Esri does in attribute tables with decimal places values... screen shot: http://i.imgur.com/0fqvF.png attribute table funky sort
5
votes
2answers
2k views

Total of attribute field of point layer per polygon layer

I have a polygon shapefile of many lakes, I also have a point shapefile of locations on those lakes where fish were caught. The point shapefile contains the attributes: Fisherman_iD, Fish_Caught, ...
4
votes
1answer
3k views

How to edit attribute tables using Python/ArcPy?

I am new to Python, so sorry for such a trivial question. There is a shapefile (let's call it Structures.shp) and the script I'm writing needs to update the value of only one record in only one field ...
4
votes
4answers
2k views

Updating 30 Shapefiles, adding attribute and populating based on data

I need to add an attribute to each shapefile attribute table in ArcMap, I was thinking to do it in SQL, but I'm not sure how to go about doing it since I'm very new to ArcMap. Can someone explain to ...
4
votes
4answers
1k views

How to insert a quotation mark through the Field Calculator of attribute table of a Shapefile?

I have a shapefile of polylines with information of diameter. But the problem is that i didn't enter the inch sign(") with the values of diameter. What would be the solution that qutation mark would ...
4
votes
5answers
594 views

Can a new point automatically be populated with data from the containing polygon

I need some help to create a script. Imagine that I'm using 3 shapes: 1 point and 2 polygons. When I create a new point I want it to assume some attributes of the polygons in which that point is ...