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?
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 ...
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 ...
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.
7
votes
2answers
1k 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 ...
9
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 ...
8
votes
1answer
200 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; ...
2
votes
1answer
1k 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
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 ...
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 ...
4
votes
1answer
1k 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 ...
2
votes
1answer
303 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, ...
5
votes
2answers
393 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 != ...
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?
6
votes
4answers
8k 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
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
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
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 ...
3
votes
3answers
1k 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 ...
3
votes
1answer
2k 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
1k 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
193 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 ...
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
79 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
1answer
1k 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 ...
0
votes
1answer
2k 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 ...
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
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 ...
4
votes
2answers
900 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
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
3answers
688 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
525 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 ...
3
votes
1answer
1k 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
52 views

Why don't all the attributes in the SQL query appear in table?

I have an SQL query that works fine in the DB Manager but when I load the table as a layer one column does not get loaded. The different thing about this column is that it is static -- text generated ...
2
votes
3answers
2k views

Update a field attribute in one column based on a change to another column in one 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 with ...
1
vote
1answer
730 views

How to Build Raster Attribute Table from .tif with pixel type of float or double?

I have a raster with the extension .tif. It's a subset of 87x87 pixel with values from some 6,66 to -4,27. If I right click on it there is no Attribute Table available. However, I can change the ...
1
vote
0answers
132 views

How do I edit a shapefile DBF to repair an extra row?

Something got screwed up and now the rows of my DBF beyond #1210 are offset by one, meaning that each shape has the attributes that should be assigned to the next shape. If I were in a spreadsheet ...
1
vote
2answers
210 views

How to re-calculate area, perim, p2a,width and length in QGIS?

I cut a part out of one feature and added it to another feature in a polygon shapefile. My problem now is that both features has the same values in the area-, perim-, p2a-, width- and length-columns? ...
1
vote
3answers
2k 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 ...
1
vote
2answers
2k views

Adding a new field in ArcMap from data of an 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 ...
1
vote
3answers
506 views

Select by Attribute --Top 500 values selection in attribute table - ArcGis

Is there any way we can select top 500 values in attribute table? I tried by sorting area field ascending/descending... but I can't count big numbers to select. In microsoft excell we can do know, ...
1
vote
2answers
836 views

ArcGIS problem accessing fields attribute table

I encounter a strange problem. I have a simple shape file to which I added some fields and then populated them. Now I wanna access those fields from a script to run some buffer operations. I wanna ...
0
votes
2answers
102 views

Attribute Table Doubt in Qgis

I am having a shape file which consists of various fields for example: shape area ,shape length, locality, sub-locality,district etc.In my company they are demanding seprate shapefiles say for example ...
0
votes
1answer
172 views

Sum of values within a buffer polygon

I need to do the following in QGIS and hope so much anyone could help. I have a vector layer with points. Each point represents a firm with the number of employees in the attribute table. I want to ...
0
votes
1answer
201 views

How to create a dbf field with length > 254? [duplicate]

Is it possible to create a text field in a database table with a length that is greater than 254 characters? Using arcgis 10.1
0
votes
1answer
2k views

How to divide polygon layer into multiple layers by values in attribute table column in ArcGIS 10.1

I have polygon layer with multiple types of area (forest, grass, and many more), and I´d like to divide this layer into many layers by the area type. I´ve tried Split function but I receive an error ...