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

learn more… | top users | synonyms

9
votes
4answers
7k views

How to change a CSV layer attribute value from text to number?

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?
9
votes
5answers
270 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
401 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
2answers
469 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

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?
8
votes
1answer
142 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 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 ...
7
votes
2answers
2k 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 ...
7
votes
2answers
733 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 ...
6
votes
3answers
927 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
2answers
2k views

How to join tables without losing the original field names in ArcGIS?

I'm wondering if there is any method to preserve the original field names in Arc GIS when I join csv. tables to a Shapefile. I ask, because sometimes I join tables with 10, 20 or even more columns ...
6
votes
3answers
2k 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
3k 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
1k 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
3answers
2k views

Is there an ArcGIS tool equivalent to “Dissolve” that can be used on tables?

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 ...
5
votes
4answers
6k 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
3answers
493 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
1k 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 ...
5
votes
2answers
412 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
1k 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 ...
5
votes
1answer
903 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
1answer
2k 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 ...
5
votes
2answers
246 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
1answer
221 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 ...
5
votes
2answers
126 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
1k views

ArcGIS 10 Field Calculator doesn't notice selection/Attribute Table problem?

I just have an annoying problem with the Field Calculator in ArcGIS 10. I selected specific points of a Shapefile I want to calculate, but FC is always calculating all fields. Unfortunately there is ...
5
votes
3answers
641 views

How to store data from ArcGIS layer in SQL Server?

I'm new to ArcGIS and I want to know if I can store data from a layer to a SQL Server table and if we can do this, then how? I have already made a connection between ArcGIS and SQL Server.
5
votes
1answer
80 views

Is there an Attribute Table Feature limit?

I am copying a table with 11,000+ features but only about 700 show up on the QGIS attribute table. Is there a limit? how can I avoid this problem? Thank You in advance!
5
votes
0answers
47 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 ...
5
votes
0answers
127 views

How to add shapefile name as attribute during merge? [duplicate]

Possible Duplicate: How to add field with filename when merging shapefiles with ogr2ogr? I have more 200 shapefiles with a unique name. I would like to merge all of these together and save ...
4
votes
4answers
576 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 ...
4
votes
4answers
1k 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
1answer
2k 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 ...
4
votes
5answers
474 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 ...
4
votes
2answers
598 views

Road Symbol/Label issues

I am trying to control how many road symbols and how do I do that ? I have geodatabase that has Transportation and in it has a featureclass, "Major_Rds" and it also has three symbology for Interstate, ...
4
votes
1answer
2k views

ArcMap tables - copying multiple horizontal cells between rows

I would like to be able to select a contiguous set of horizontal cells in a row, take a copy, then paste the values into another row at the same position in the same table. I do not want to copy all ...
4
votes
1answer
1k views

Adding a boolean yes/no field in Arcgis

How does one add a field to an Arcgis feature class with a boolean data type? That is an attribute where the allowed value is only one of a pair such as 1/0, Yes/No, On/Off, Present/Not-present, etc. ...
4
votes
1answer
177 views

Finding duplicate records in a field via Python in field calculator

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 ...
4
votes
1answer
119 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 ...
4
votes
3answers
2k 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 ...
4
votes
1answer
2k views

How to add field in attribute table by python

I have research on the question (How to add an attribute field to an existing Shapefile via Python) but could not implement it. If you can give me examples on how to add field name in attribute ...
4
votes
1answer
121 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 ...
4
votes
2answers
358 views

ArcGIS Attribute Assistant method not working

I don't know how many of you are using Attribute Assistant for ArcGIS 10.1, hope many:) I have some difficulties with a couple of methods. Well, I got the INTERSECTING_EDGE, the GENERATE_ID, and a ...
4
votes
2answers
539 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
123 views

convert a dbf into a raster image using python? work around for arcpy

ArcGIS' arcpy does not have a function to add a table to a layout. I was thinking that maybe taking that table (e.g. a dbf), there may be some python script command to turn it into a raster (e.g. do ...
4
votes
1answer
483 views

How to write values from arcpy statistical output to table?

The attached script is my stalled attempt to perform the following workflow: Create a table and create fields Loop through a folder of point shapefiles and perform average nearest neighbor analysis ...
4
votes
1answer
544 views

Refresh Currently Open ArcMap Attribute Table using ArcObjects

I have written an ArcMap Addin (ArcMap 10.0) that allows a user to perform a join between an in-memory table and a feature class (feature layer) added to the TOC. I want the attribute table of the ...
4
votes
1answer
1k 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 != ...
4
votes
1answer
96 views

Is there a way to modify an Excel sheet which is already open in ArcMap?

I have an excel sheet that is joined to a shapefile in ArcMap. I need to modify many elements of the table, but every time I need to close ArcMap in order to be able to do it. Is there any way to ...
4
votes
1answer
189 views

Join a table to a parcel layer and get duplicate parcels, reflecting individual leases

I have a table of 3,000+ lease files that I'm trying to join to our parcel layer. Each parcel has 4+ leases associated with it, and I need each to be represented by an actual polygon. When I do a ...