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

learn more… | top users | synonyms

9
votes
4answers
9k 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
2answers
2k 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
461 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
304 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
2answers
554 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
1answer
194 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
4k 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
3k 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
962 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
4answers
7k 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 ...
6
votes
1answer
2k 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 ...
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
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
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 ...
6
votes
3answers
3k 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
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 ...
6
votes
1answer
4k 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
3k 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
3answers
592 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
1answer
1k 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
2answers
523 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
2answers
355 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
252 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
168 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
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 ...
5
votes
3answers
88 views

Calculation based on features in shapefile

I hope I get the terminilogy right! Correct me if I mess something up. I need to perform some calculations for a scoring system for different habitat types. The Problem is that I have two different ...
5
votes
2answers
2k 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
997 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
90 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
51 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
129 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
2k 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
4answers
16k 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 ...
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
512 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
1answer
2k 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
2answers
657 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
77 views

Most efficient method to join multiple fields in ArcGIS

I have as set of shapefiles with approximately 300000 polygons each, as well as corresponding point shapefiles and tables with approximately the same number of row (equal or less rows than the ...
4
votes
7answers
2k 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
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
3answers
643 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
1answer
548 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
145 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
1answer
3k 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
141 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
420 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
825 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, ...