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

learn more… | top users | synonyms

20
votes
10answers
25k 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 ...
16
votes
2answers
10k views

How to rename attributes/fields in a shapefile attribute table?

I would like to rename some fields in my attribute table: Like rename XRF_N3in something else. It seems quite a easy issue but I don't find any information about how can I do that... I've QGIS 1.8 ...
15
votes
2answers
4k 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?
14
votes
5answers
16k 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?
13
votes
4answers
11k 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 ...
9
votes
2answers
899 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 = ...
8
votes
2answers
1k views

What does an asterisk (*) mean when shown beside a field name in the attribute table?

What does an asterisk (*) mean when shown beside a field name in the attribute table? I would think those are reserved field names but they are not.
8
votes
2answers
140 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 ...
8
votes
1answer
726 views

Fastest methods for modifying attribute tables with Python?

A while ago, I wrote a quick Python function for converting an attribute table to a python dictionary, where the key is taken from a user-specified unique ID field (typically the OID field). ...
8
votes
5answers
391 views

Print out the properties of the attribute table in qgis?

I have to merge a lot of shapefiles into one great shapefile. So I want to compare the properties of the attribute tables to see if there are differences between the tableproperties of each shape ...
8
votes
1answer
413 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; ...
8
votes
4answers
6k 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 ...
8
votes
1answer
147 views

Can you use wildcards for column headers in Field Calculator?

I know you can use wildcards for fields like so (in the Field Calculator): case when "column" ILIKE '%example%' then 1 else 0 end Can you do something similar for the column headers themselves? I ...
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 ...
7
votes
4answers
14k 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
3answers
263 views

Zoom from one feature to another in edit mode?

I have to manually edit a shapefile of a couple of hundred points. I would like a quick way to jump from one point to the next in both the attribute sense and the visual/spatial sense i.e I would ...
7
votes
4answers
51k views

How to export attribute tables to Excel? [duplicate]

Possible Duplicate: How do I export an attribute table in ArcGIS version 9.3.1 to Excel? We are running 10.0 and are trying to simply export an attribute table to Excel other than exporting ...
7
votes
2answers
4k 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 ...
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 ...
7
votes
3answers
4k 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 ...
7
votes
2answers
808 views

How to stop writeOGR from abbreviating Field Names when using “ESRI Shapefile” driver

I'm currently using the following script to add some attribute data from a table to lots of individual shapefiles: library(rgdal) specieslist <- read.csv("SpeciesList1.txt", header=F) attdata ...
6
votes
4answers
12k 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 ...
6
votes
2answers
12k 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.
6
votes
7answers
398 views

Is there a quick way to clear all attributes from a layer but leave the polygons in place?

I have a Shapefile layer in QGIS 2.6 with several polygons, each of which has data in over 100 fields. I need to create a new layer with all the same polygons, but with all their data fields blank ...
6
votes
1answer
4k views

How do I edit shape file attribute tables so they all have the same information?

I am trying to merge several pipeline shapefiles using GEOMERGE but it cannot complete the function because they have different column definitions. So I need to edit the attribute tables so that ...
6
votes
2answers
2k views

ArcObjects: How to insert data into a table?

I have a table in ArcCatalog named WorkOrderAss. This table contains 3 columns: (OBJECTID, FeatureName, Name). I want to insert data to this table from the code behind in C#. Any help would be ...
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
6
votes
1answer
3k 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 ...
6
votes
3answers
4k views

ArcObjects 10 - copying fields (table structure) to a new feature class

I'm creating a new feature class with the attribute table schema (field names, types etc.) copied from another feature class. Then, I'd like to modify this schema slightly (e.g. add an additional ...
6
votes
1answer
5k views

Select all “NULL” values in the attribute table?

I have a quite simple syntax question. I want to select ALL my null values in an attribute table of a feature class, not just the values in a single field. So the question would be: what is the ...
6
votes
1answer
369 views

Python/GDAL get unique values in discrete-valued raster

I would like to get some advice on the most efficient way to return a list of unique values of a discrete-valued raster using Python and GDAL. I had thought that the most obvious way would be to ...
6
votes
1answer
7k 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
102 views

Minimizing attribute tables in ArcMap?

Prior to ArcGIS 10.0, I worked on several attribute tables at once and I often minimized them. Now, the attribute tables have no icon to minimize them using ArcGIS 10.1 for Desktop on our Windows 7 ...
6
votes
3answers
456 views

How to combine raster and attribute table in QGIS?

I have some rasters representing string categorical variables. Each raster contains integers, used to translate the categorical variables. I have also the .csv tables giving the meanings of the ...
5
votes
2answers
504 views

Split one field into 3 fields?

I need to split the values in a field according to what they represent to be able to do a join on the data. As seen above I have a ID field that needs to be split into the following: The ID consist ...
5
votes
1answer
3k 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 ...
5
votes
3answers
862 views

Is it possible, in QGIS, to create buffers with a set radius, but with individual values taken from the attribute table?

I am looking to create an output that consists of an 11KM buffer around a number of discrete points, where the buffer has a value defined by a column in the data sets attribute table. Is this ...
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 ...
5
votes
2answers
522 views

How to enter a date into the attribute table?

This may be something simple stupid but in QGIS 2.4 I have created a date column. How do I enter the date in correctly. Every time I type a date in, in whatever format it does not move that entered ...
5
votes
2answers
1k views

How to add a sequence to the attribute table?

Is there a way to use the field calculator in QGIS to create a range of values in a count sequence with a specified input range? For example, if I wanted to have the values 1 to 5 repeated within my ...
5
votes
1answer
252 views

How to remove Commas from field values in multiple files?

I'm working in QGIS, presenting data in ArcMap, and Arc is having trouble with the attribute tables. I have a "species" column which lists the species found in that area and have added commas "," in ...
5
votes
8answers
7k 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 ...
5
votes
2answers
992 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 ...
5
votes
2answers
6k views

How to add simple table of text (Excel) into layout and preserve 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
296 views

Is it possible to force uppercase in a geodatabase string field?

I have certain string fields in my geodatabase tables with which I would like to enforce an all-uppercase rule. These fields are ones that do not lend themselves to domains (such as address fields). ...
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, ...
5
votes
1answer
290 views

How to convert a column of numeric IDs to letters?

I'm working with qgis 1.8.0. I divided a map into 500 features (small rectangles), and now I have the doubt if there is any way to change the ID of the attributes from numbers to letters? When I did ...
5
votes
1answer
303 views

How do “join field” and “target field” work?

New user. This should be simple, but I can't figure out how to perform this basic join in QGIS. (It works in Cartographica.) My shapefile (IL_BNDY_County_Py) has two fields/columns in its attribute ...
5
votes
1answer
286 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 ...