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

learn more… | top users | synonyms

16
votes
5answers
22k 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?
8
votes
1answer
4k 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 ...
24
votes
10answers
31k 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 ...
8
votes
3answers
5k views

Displaying dynamic table in Data Driven Pages 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
1answer
9k views

Adding automated values to attribute field?

I have parcel and buildings layers. In their attribute tables I want to replace "NULL" values with numbers from 1 to 2000, in "Parcel ID", or "Building ID" field. How can I do this in ArcGIS ...
11
votes
2answers
289 views

Can labels for overlapping points be combined/merged into one label?

I have points representing sample locations. Often, multiple samples will be taken in the same location: multiple points with the same location but different sample IDs and other attributes. I'd like ...
18
votes
5answers
18k 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 ...
5
votes
3answers
7k 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 ...
10
votes
1answer
616 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; ...
7
votes
3answers
3k 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 ...
5
votes
2answers
3k 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, ...
1
vote
1answer
163 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 ...
9
votes
5answers
24k views

How to Change Field Name in ArcGIS 10.2

Can someone please let me know how I can change the field names (not the alias) in ArcGIS 10.2. I already found this page on ArcGIS support: "Renaming shapefile fields (Defense Mapping)" but there is ...
9
votes
10answers
15k views

Changing data type in ArcGIS attribute table?

How can I change the data type in an attribute table in ArcGIS for multiple fields? For example, if the fields have been exported as a string from Excel, and I would like to use them as numerical ...
3
votes
1answer
77 views

Exploding features based on numerical field in QGIS?

I have a set of data as polygons, each with a Number field with value X. Is there then a way to copy this into X number of polys at the same location? (ideally points distributed across the poly but ...
2
votes
1answer
2k 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 ...
9
votes
2answers
3k 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 ...
5
votes
2answers
5k 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 ...
5
votes
1answer
7k 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 ...
1
vote
1answer
9k 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 ...
4
votes
2answers
2k 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. ...
5
votes
4answers
12k views

How to export attribute table to Excel from QGIS?

I have seen all the questions for this question, and I try all the answer like copy paste, csv (in fact this I don't know where to find) but none of all is not the right answer. Can anyone help me?
5
votes
1answer
3k views

Accessing 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

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. ...
0
votes
1answer
300 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 ...
5
votes
2answers
2k 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 ...
7
votes
2answers
27k 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
1answer
733 views

Calculating Percentiles in ArcMap?

I have a large polygon dataset (26,000) records with numerous attributes columns. I wish to calculate the percentile rank of each attribute. Say I have population_density in an attribute, is there a ...
9
votes
4answers
9k views

Where is the attribute table in ArcGIS for Desktop when not visible?

I've just updated to ArcGIS 10.1 for Desktop 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 ...
5
votes
2answers
9k views

Adding simple table of text (Excel) into layout and preserving formatting and clarity?

I am trying to put a simple table of text (excel) into my layout and preserve cell formatting including alignment, borders and text sharpness. I've tried many approaches but nothing so far is ...
5
votes
2answers
5k 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 ...
4
votes
1answer
149 views

How can values in the attribute table be refreshed automatically when a geometry changes?

I can't find a solution for auto-refreshing attribute table data. For instance, how can the data related to features of a Shapefile (e.g., the area) be updated if the feature geometry is changed.
3
votes
3answers
5k 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
531 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 ...
1
vote
2answers
3k 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 ...
8
votes
3answers
6k 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 ...
8
votes
3answers
5k 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 ...
4
votes
3answers
533 views

Calculating file name with field calculator

Is it possible to calculate the file name in an attribute table? My shape file has a name like "cities.shp". In this shape file I want to have a attribute "cities").
4
votes
1answer
5k 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 ...
3
votes
1answer
4k views

Replacing all null values from attribute table with zeros using QGIS?

I have a new column in my attribute table with a lot of null values and I want to replace all them to zeros. How can I do that in field calculator? I'm using QGIS 1.8
2
votes
1answer
3k views

How to create attribute table for raster data?

I have raster dataset for rainfall but its not having attribute table. How can I create tabular data using the same raster file? How to join it back again to it? Software used is ArcMap 10.1.
2
votes
1answer
942 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, ...
0
votes
1answer
72 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 ...
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 != ...
19
votes
2answers
6k 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?
7
votes
1answer
217 views

How do I optimise performance on a local QGIS + PostGIS installation?

I'm learning how to manage a local PostGIS (ver 2.1) database, with spatial indexing enabled on the shapefiles that I've imported (using the PostGIS Shapefile Import/Export Manager). I have imported a ...
7
votes
4answers
17k 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 ...
7
votes
1answer
4k 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 ...
2
votes
1answer
1k 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: ...
1
vote
2answers
250 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 ...