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

learn more… | top users | synonyms

8
votes
1answer
227 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 ...
2
votes
1answer
199 views

Edit attribute table for shapefiles in folders and subfolders with arcpy?

Continuously to Merge shapefiles in folders and subfolders with arcpy I try to edit attribute table for 20 shapefiles that spread in big a folder and are divided to a lot of sub folders. All ...
1
vote
1answer
51 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 ...
2
votes
1answer
4k 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 ...
0
votes
1answer
99 views

How can I refer to two tables in ArcPy's CalculateField_management? [closed]

I tried to refer to the different table's fields just like I saw in How to Calculate Field in joined table using ArcPy? but it doesn't work. There are two tables in my example. I have created table "...
0
votes
2answers
198 views

What fields can the CalculateField_management expression parameter contain?

What fields can the CalculateField_management expression parameter contain? I mean the parameters can be the fields what are in the output table, or can they be a field of another table too? There ...
1
vote
0answers
48 views

How to implement 3NF (third normal form) in ArcGIS attribute tables? [closed]

How can I implement 3NF (third normal form) in ArcGIS attribute tables? I have a field what have redundant values, and I need to run different functions for these redundant datas, so I need to place ...
1
vote
1answer
43 views

Compare 2 tables of different lengths

I have a problem and am looking for some help with the following: 2 Layers: Not_Joined and Joined Not_Joined: Old digitized data that has X attribute in it. Joined: Spatially joined layer that has ...
0
votes
2answers
316 views

Python column checker-comparing 2 fields

One problem I am having is the following: I want to create an automatic program to see how well the automozation has been with comparing the results of 2 columns to each other in the same column. In ...
1
vote
2answers
5k 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 ...
3
votes
3answers
5k 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 ...
0
votes
2answers
89 views

Why won't my csv file imported as a vector layer have attribute table headers?

I have a .csv file that has unique identifiers that I'd like to join with some legislative district shapefiles in QGIS. I've done this before, and the joins all worked fine -- and technically it still ...
2
votes
1answer
57 views

Converting character attribute to numeric attribute

I am following the very simple code found in this question Converting shapefile to raster: Character attributes to create a new numeric variable based on a factor. My proble is that the new numeric ...
0
votes
1answer
113 views

copy related table data into a single field in an attribute table

I have a featureclass of cities and a separate table of city administrators (multiple administrators for each city) and related contact info. What I need to do is consolidate all city administrator ...
11
votes
2answers
3k 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.
1
vote
1answer
264 views

How to get a total amount of cells per classification type in a raster in ArcGIS 10.1?

I did an supervised classification for for this watershed. The attribute table doesn't have the count for total number of cell for each classification. I've created a field titled 'Count' with type '...
2
votes
2answers
558 views

Classification to attribute

Using Esri Desktop Advanced 10.2.2 is it possible to create an attribute based on a classification method, i.e. Jenks? To elaborate - if you use the symbology tab in a layers properties, you can set ...
0
votes
1answer
338 views

ArcGIS 10.2 Changing 'null' to 'zero' in attribute table? [duplicate]

I have a table (Excel, csv) with county names and three additional column headings. I would like to ensure that everything under the three additional headings have a zero rather than a 'null' value. ...
0
votes
1answer
35 views

need to populate attribute table

I have two shapefiles, one polygon one points. The points represent specific field sampling locations. The polygons represent land divisions. The land divisions have a unique 16 digit identifier. ...
3
votes
2answers
86 views

ArcGIS Removing values from a shapefile with Python

I've got a monster shapefile with lots of duplicate records, however each duplicate record has an accuracy rating. I want to remove all duplicate records with a lower accuracy rating. This would be ...
0
votes
0answers
149 views

error converting shapefile to geoJSON with Ogre online tool

I am using on online tool built with ogr2ogr to convert shapefiles to geoJSON: http://ogre.adc4gis.com/ It's worked well except for one shapefile, and I can't see why... The shapefile has only six ...
5
votes
3answers
8k views

Automatically update field value in one column based on change to another column in same 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 ...
1
vote
2answers
273 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 ...
5
votes
1answer
283 views

editor tracking updated in attribute table, but not in sql server database

When I enable editor tracking and make modification on an object, I can find the edit user and edit time, but I cannot find the data updated in the sql server database. Is it because of the versioning?...
2
votes
1answer
353 views

Updating and inserting a field within the same loop

I am working with an empty feature class where I am writing a script to create polylines within the featureclass and attach an associated text value with the polyline. I am using a for loop as noted ...
2
votes
2answers
161 views

fit a wrap column in the print composer QGIS 2.4

i have an attribute table in the map composer, and the field i want to see is quite long...so i wrap it. but the field width is not fitting this new length. how can i do that. is qgis prepared to do ...
0
votes
1answer
242 views

How to set feature coordinates to values in attribute table?

I have some shapefiles that were produced programatically, and everything came out okay EXCEPT that the geometry information was not written correctly. The coordinates for each feature are null. ...
0
votes
1answer
40 views

Append value(string) to multiple selected fields

In my attributes table I want to insert a new value to a few selected items, and keep the old data inside the field. The table contains multiple columns (street name, length... and public ...
2
votes
1answer
280 views

Filter query error in QGIS2.4 or 2.6

I get this error when undertaking in query in QGIS2.4 or QGIS2.6: An error occurred when executing the query. The data provider said: OGR[3] error 1: Unrecognised field name Fire....
2
votes
3answers
497 views

How can I do a batch edit of circle diameters using the attribute table in ArcGIS?

I need to edit the diameter of a bunch of circles to reflect their correct diameters, and I wondered if there was a way of drawing from the attribute table to make all the circles equal their correct ...
5
votes
1answer
242 views

How to preserve the order of fields when exporting a table from ArcMap?

ArcMap allows you to re-order fields in an attribute table, by dragging+dropping either within the layer's > Properties > Fields tab, or within the Table window. However, the order of the fields ...
3
votes
2answers
89 views

Averaging XY data for locations in QGIS

I wanted to find out mean of the selected point using QGIS. I tried out selecting using attribute table but could not find an option for mean in field calculator. I have attached a screenshot with ...
1
vote
2answers
6k 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" ...
3
votes
4answers
2k views

How to create a new Shapefile with the same attributes as an existing one?

It is quite a frequent occurrence that I want the data I'm about to add to a new shapefile, to have all the same attribute fields as one I created in a previous project. For example, I might have ...
4
votes
2answers
554 views

Export Raster Attribute Table using Open Source software

I've got 120 or so geotiff files that I'd like to build and export the raster attribute table to something a little more friendly (e.g. csv). I'm curious if there is an open source way to do this. ...
1
vote
1answer
254 views

Attaching pictures to polygons in attribute table in batch using ArcGIS for Desktop?

I use ArcGIS and I want to attach a picture of each polygon as raster in attribute table and I have 1900 of polygons. Can somehow attach batch photos as raster that have same ID like polygons? It is ...
2
votes
2answers
437 views

Auto fill second column with predefined names depending on first column (QGIS)

I want to create a point layer. In the attribute table I want to have two columns. In the first column I want to type an abbreviation like A. Then I want the second column to be auto filled with ...
1
vote
2answers
3k 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
3answers
2k 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 ...
7
votes
2answers
2k 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 ...
4
votes
1answer
2k views

how to delete a row in grid attribute table of a raster?

How can I delete a row in a raster file table? The raster format is GRID I get this error "grid attribute table is blocked from deletion". It seems absurd that I am not able to manipulate my own file....
0
votes
3answers
402 views

How to flip, or invert attribute tables with respect to row ID arcgis

I need to invert the fields of an attribute table relative to the row ID field. As a very simple example of what I need; if the row IDs of 1, 2, and 3 corresponded to identical values in another field,...
0
votes
2answers
168 views

Unable to plot values for individual fields in my table using ArcGIS for Desktop?

I'm having problems adding tabular data to an ArcGIS project and need some help! Example of my table is below (please note that the fields have been edited since the capture was taken to remove any ...
0
votes
0answers
42 views

unable to plot the values for the individual fields in my table

I'm having problems adding tabular data to an ArcGIS project and need some help! Example of my table is below (please note that the fields have been edited since the capture was taken to remove any ...
2
votes
1answer
166 views

Disappearing attribute values

Using ArcMap 10.1, I’m editing values in a feature class which was sent to me from within my organization. I realized I had a problem when trying to change the symbology of this feature class- the ...
10
votes
3answers
5k 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 ...
3
votes
1answer
2k views

How to Calculate Cumulative Field Values in Arcmap

My problem is conceptually quite simple; In Arcmap 10.2, I wish to create a field which contains the cumulative values of another field in the same attribute table. For example, if the first three ...
1
vote
1answer
181 views

organizing attribute table: multiple sets of variables per point

I would like to have hints on the best way to organize my dataset (I am working with ArcGIS 10.1, advanced license). I would like to build a points layer, each point being a weather station in the ...
3
votes
1answer
755 views

Convert KML to an Attribute table

So I was wondering if it's possible to convert the KML files to an CSV attribute table (of those geometric features). So I've found this code that converts the KML to CSV, but really just prints the ...
1
vote
2answers
182 views

Interpolation with z-values taken from a related table

This is a follow-up question (organizing attribute table: multiple sets of variables per point). I am working with ArcGIS 10.1, advanced license. My aim was to build a points layer, each point being ...