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

learn more… | top users | synonyms

1
vote
2answers
2k 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 ...
1
vote
1answer
910 views

How to stop values from rounding to whole numbers in ArcGIS attribute tables?

I am trying to edit an attribute table in ArcGIS 10.1 and so far have been unable to keep it from rounding to whole numbers. Even when I manage to "pad with zeroes" using the numeric settings, it ...
1
vote
2answers
117 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?
1
vote
2answers
292 views

Edit Field Value of Feature Class Using Python in ArcGIS 10.2

I have a feature class whose attribute table looks like this: Latitude | Longitude | Area For the area column, all rows are null. I would like to put in a specific value for all rows using Python. ...
1
vote
3answers
142 views

How to sum all values with the same ID in ArcGIS Desktop? [duplicate]

I did a one to many spatial join and ended up with an attribute table as follows: Lets say we have 5 different IDs that have numerical values in 500 rows. I need to sum the values for each ID, and end ...
1
vote
3answers
110 views

How to add data to an attribute table?

I have a shape file (points) and would like to add points using the attribute table and not the Add Feature tool at the main screen. I went over the Qs here, but didn't find a similar problem to ...
1
vote
2answers
719 views

Trigger to fill attributes (data, client ip) in table for each new objects, PostGIS

In PostgreSQL/PostGIS database stores shapefiles. Client users software - QGIS. Please help me write PostgreSQL/PostGIS trigger, which for each newly added/updated feature in layer added 'time create' ...
1
vote
2answers
344 views

Setting custom valid values to a MapInfo field?

I was wondering if it was possible in MapInfo to set valid values for a field, e.g a field called material and only valid values being BIT, CON or STO? I have a basic knowledge of MapBasic. Thanks, ...
1
vote
1answer
31 views

In ArcPy, How to call specific columns of attribute table?

I'm trying to figure out how to spline specific columns of a shapefile attribute table, but my question is intermediate to this-- how do I select a range of columns, e.g. the 20th column to the ...
1
vote
1answer
73 views

How to get the average of a column?

So I have a shapefile with 160k elements. It is in UTM and I calculated the area (should be meters, right?). What I need now is the average size of each of my polygons. Meaning, summing up a column ...
1
vote
2answers
134 views

How to add images in attribute table

I want to add photos in my attribute table. I have created a new field but I am not able to select "raster" in the field type. They only show "short integer", "long integer", "float", "double", "text" ...
1
vote
1answer
1k views

Export attribute table (feature class) to text file in batch?

What would be the most efficient way to export attribute tables from multiple feature class files stored in a file geodatabase? Export to .txt or .csv. Is there any sort of batch process? Or python ...
1
vote
2answers
262 views

Generating Values in the Attribute Table

In the attribute table within GIS, I have a certain column with ascending values, and I want to assign ID numbers (for easier readability and display) to a corresponding column. So for instance: Feet ...
1
vote
2answers
116 views

Help excel table not transferring to Arc correctly!

New to GIS and Ive been trying to figure this out for a while. I have an excel sheet with CT names such as 0128.03, 0128.04, starting from 0001.00 and up. Not all CTs have .01, .02 at the end just ...
1
vote
1answer
220 views

How do you parse an HTML formatted attribute value to seperate columns in a database table?

All, I have an attribute field formatted using HTML all ready to go for google earth markers. The KML in question is here: http://dl.dropbox.com/u/95231813/state_pts_MI.kml Here is the value: ...
1
vote
2answers
75 views

How to merge shapefiles with the same attributes?

Let's say, I have two shapefiles, a.shp and b.shp, containing point features with the follwing attribute tables: a - id att1 att2 ----------------- 1 1 1 2 2 2 b - id att1 ...
1
vote
2answers
493 views

How to add a new column into an attribute table in ArcGIS Online?

Is it possible to add a new column in the attribute table using the ArcGIS Online version or do I have to return to my home computer and do this through QGIS? A little background to help better ...
1
vote
1answer
148 views

How to transpose reclassified field values from one polygon shapefile to identical polygons of another shapefile?

I used vector output from modeling software as clip features for ecoregion input. I reclassified and dissolved the clipped layers into 3 subunits, and now would like to transpose those simplified ...
1
vote
1answer
356 views

How to correctly use Datepart( ) in ArcGIS?

I have two date fields dd.mm.yyyy with a start and an end date in my attribute table. Now I want only to extract the years from these fields to new fields. So I created another field, and used ...
1
vote
1answer
165 views

extract shapefile attributes from raster colors

I have two layers: a shapefile with states and counties (shp) a raster file (with colors and some text and borders, but not a perfect map) (tiff) I want to use the colors in the raster file to ...
1
vote
3answers
77 views

How can I change more than one attibute at the same time?

I'm working in QGIS 2.0.1 Dufour. I started by cretaing a shape file form an AutoCad file. The problem is that in the AutoCad, my layers had symbols like: "~; ç; ^". As the QGIS does not support this ...
1
vote
2answers
70 views

Why do I have text of attribute table on my view in ArcMap 10?

Can anyone tell me why do I have attribute table text on my layers in ArcMap 10 and how I can get rid of those texts? I have no idea when the texts appeared into my workspace. I have been digitizing ...
1
vote
1answer
1k 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
1answer
247 views

How to concatenate XY values in attribute table without messing up the numbers in ArcGIS 10.1?

Here's the procedure I use and the resulting problem I'm having. First I use the Add XY coordinates tool to add POINT_X and POINT_Y fields to the attribute table of a point layer. I then add a new ...
1
vote
2answers
367 views

ArcGIS Find and Replace attribute search error

I am editing a vector layer in ArcMap 10.1 in the attribute table the no data value for some of my fields is -1.7976931348623157e+308. I would like to replace that with 0. I attempted to use the Find ...
1
vote
2answers
2k views

How to delete multiple fields in an attribute table?

Is there a way to select multiple fields in an attribute table and delete them together in Arcmap without writing the script?
1
vote
2answers
1k views

ArcMap attribute table has disappeared [duplicate]

I am having the same problem discussed here:. I don't know what I did but my attribute table is now lurking somewhere but I can't find it. I use only one monitor. The previous question was resolved ...
1
vote
1answer
250 views

Stuck updating one field based on the condition of another using Acrpy or Field Calculator

I have a shapefile with 5,000 city points. I need to populate a new field, "cls_pop", based on each cities population, so that cities with a population > 2,000,000 will have "cls_pop" = 1, cites with ...
1
vote
1answer
2k views

How to avoid General function failure and delete table field in ArcGIS for Desktop?

I am trying to delete a table field: From ArcMap table view, I right click on the field heading and select Delete field. Unfortunately, I obtain the following message: Failed to delete the selected ...
1
vote
2answers
1k views

Get Number of Rows, ArcObjects (VBA 6.0)

I am sorry to bother with what may be an easy question for most of you but i am new to ArcObjects (VBA 6.0) in ArcMap (ArcGIS 10.0) and i am really struggling here. I am trying to count the number of ...
1
vote
3answers
822 views

Deleting columns from joined attribute table in QGIS

After joining the attribute tables from two layers, I have a lot of duplicate columns on my table, making it hard to read. However, even when in "edit" mode I am unable to select and delete columns. ...
1
vote
3answers
644 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
1answer
316 views

How can the scale be projected correctly in Quantum GIS when it is imported from google earth (KML) files?

While importing KML files from google Earth to Quantum GIS, the scale is not being projected properly and the area of a particular selected feature is not being calculated in the attribute table by ...
1
vote
1answer
117 views

Error while trying to view the attribute table

I have a shapefile which displays fine in ArcMap. When I view the attribute table I get the following error. However the same shapefile loads fine and can view its attribute table to in QGIS. Any ...
1
vote
1answer
25 views

Is there an out-of-the-box way to manage 1:n data in QGIS?

I think an image explains the question best: What I basically want to do is select the object, view its attributes and from there call the second table to view/edit/add status entries. Since I ...
1
vote
1answer
30 views

Arcmap record value is not displaying entirely

On this project i have a column composed of numeric and alphanumeric values. The data comes from multiple sources, so it is quite messy. Using python I am trying to filter the data and copy the values ...
1
vote
1answer
143 views

Adding attributes to line feature according to adjacent polygon

I'm trying to add attributes to a field in a polylines attribute table according to directly adjacent polygons.... In the pic, the purple line has an empty field labelled 'FG' and I'd like to fill ...
1
vote
1answer
77 views

Summary statistics on attribute table

I've got a polygon feature class with attributes fields y2010, y2011, y2012, y2013, y2014, country The 'year' fields contain counts of an event occurrence, which can be 0 or > 0. The 'country' field' ...
1
vote
1answer
150 views

Join of two attribute tables with different amounts of rows

I have a hard time sorting the following out: I have two different Shapefiles. The attributetable of one, lets call it shapefile A looks the following: SHAPEFILE A ATTRIBUTETABLE Name Type ...
1
vote
2answers
116 views

Using the Rule-based style to calculate each grid cell from overlaps

I am using the Rule-based styling properties (QGIS 2.2) to determine the colour of grid cells for a merged shapefile. Each grid cell defined by its ID may be overlapped by several layers as defined by ...
1
vote
2answers
136 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
2answers
2k views

How to combine rows in attribute table using ArcGIS for Desktop?

I have an attribute table with three columns "FID" "Shape" and "Class" All records have the same shape (polygon). Each record has its own FID. I have three classes, "A", "B", or "C". I have twenty ...
1
vote
1answer
101 views

How do I add coordinates to a polygon layer to be able to sort the polygons from north to south in QGIS?

I have a polygon file, where each polygon represents one property. I want to be able to sort the polygons from north to south or vice versa. I need them to be sorted in this way when I export them to ...
1
vote
1answer
92 views

Is there any way to add an area column to new shapefile created from raster with gdal's polygonize in the same step?

I've been going through a fairly lengthy process of polygonizing very intricate raster images, then creating a new layer with the extra area attribute, so that I can then remove the millions of tiny ...
1
vote
2answers
403 views

How to add a new column in attribute table with attribute with indexes of another max-min ordered attribute field?

I've an attribute column named e.g. VALUE with different values I would like to make a column named e.g. ORDERsuch that the greatest value has the attribute 1 the second value 2 etc. etc. so order ...
1
vote
2answers
990 views

How can I replace all null values from attribute table to zeros?

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 calculator? I'm using QGis 1.8 Thank you!
1
vote
1answer
135 views

Problem of linear records with zero shape length and no geometry in attribute table

I am working with a bicycle and pedestrian facility file geodatabase in ArcMap. I noticed a some of the records in the shapefiles/feature classes have a shape length of zero in the shape length ...
1
vote
1answer
144 views

How to solve 'syntax error, unexpected LE' in QGIS query builder?

I have a very simple question about the advanced query builder in QGIS. I'd like to search for a range of numerical data values in the attribute table, but asking QGIS to show me values that are ...
1
vote
4answers
102 views

Add only unique features from another shapefile

I've got a problem that I am sure at least one of you have dealt with. I'm new to a company that makes use of a rather large database of point data. For whatever reason, the woman who was here before ...
1
vote
1answer
69 views

Why are attributes missing in overlay tab QGIS 1.8.0?

I want to add a diagram overlay onto a shapefile layer. When I look at the attribute table, all the correct columns are shown. However, when I open the layer property box, the attribute columns I want ...