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

learn more… | top users | synonyms

5
votes
2answers
487 views

Split one field into 3 fields?

I need to split the values in a field according to what they represent to be able to do a join on the data. As seen above I have a ID field that needs to be split into the following: The ID consist ...
2
votes
2answers
327 views

QGIS exporting attributes in a KML file

Here is what I am doing: Create a layer by uploading a shape file into QGIS Select Attributes of that file Export selected attributes with the "save only selected features" check box when I save the ...
2
votes
5answers
245 views

How to export attribute table with start and end coordinates of lines to Excel?

I am working in QGIS. I have a georeferenced line layer and I want to export the attribute table and the coordinates of start and end points of my lines to Excel. Can I do this with QGIS?
1
vote
1answer
28 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
0answers
54 views

Get Feature Count

My situation is as below, Database 1 : SDE database.Topo Feature Class : 170 Database 2 : SDE database.AOI Feature Class : 1 I want to get feature count of 170 feature classes base on selected AOI ...
1
vote
2answers
983 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?
0
votes
2answers
51 views

Diverse values to one field for soil analysis

I have soil analysis data in an Excel table. For one analysis point there are values at three depths. Besides the Excel file I also have a shapefile with the points to which I want to add the soil ...
1
vote
0answers
91 views

Updating attribute table from an Excel file using Python

I am kinda new to Python, please excuse for such a trivial questions. There is a shapefile (let's call it Materials.shp). I have an attribute table with different fields (for example, windows, doors, ...
1
vote
2answers
3k 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
46 views

Changed Projected Coordinate System back to original but, Shape_Area field is still off by about 55 SF

I recieved some GIS parcel data a little over a year ago. This data is the basis for the majority of my work. About a week ago I noticed that the Projected Coordinate System had somehow been converted ...
0
votes
1answer
154 views

Populating a field in an attribute table with a consecutive number sequence? [duplicate]

I know that this is probably a very basic question but I cant seem to find an answer through Google searches. I would like to create a field in an attribute table (in ArcMap 10.2) for a Number Label ...
3
votes
1answer
512 views

Build Raster Attribute Table with GDAL Utilities

Is there a way to build a raster attribute table using one of the GDAL utilities? I know you can view it using gdalinfo and I have successfully created one using Python, but it would be so much ...
3
votes
1answer
50 views

Joined tables and now field calulator is greyed out

In ArcMap (10.2), I accidentally calculated the wrong field outside of an edit session, so there was no way to reverse my action. I restored a previous version (shadow copy) and joined the tables ...
12
votes
4answers
9k 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 ...
0
votes
1answer
39 views

Why are rows automatically deleted after inserting them into attribute table?

In ArcMap 10.2 I go into Editor mode and Start Editing. After this I insert a new row into an attribute table and if I click on Save Edits, the newly inserted row is disappear. What is the problem? ...
3
votes
3answers
203 views

Calculating file name with field calculator

Is it possible to calculate the file name in an attribute table? My shape file has a name like "cities.shp". In this shape file I want to have a attribute "cities").
0
votes
2answers
59 views

Number shape files

Is it possible to number shape files? Before merging the single point layer I want to give them numbers. After filtering the merged files I need to split them (the number should be a marker for the ...
7
votes
2answers
4k views

Joining tables without losing original field names in ArcGIS for Desktop?

I'm wondering if there is any method to preserve the original field names in ArcGIS 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
200 views

Calculating Percentiles in ArcMap?

I have a large polygon dataset (26,000) records with numerous attributes columns. I wish to calculate the percentile rank of each attribute. Say I have population_density in an attribute, is there a ...
2
votes
1answer
48 views

Specific renaming of elements in Attribute table failing until closing and reopen attribute table

Well the title tells it already. I have a column name and 100 objects. I have given them all a name. Now I mentioned that I have written some wrong of them. So I tried to correct them by double click ...
2
votes
1answer
35 views

How to get the attribute list of a point that is clicked on the map

I would like to double click a point on map and directly getting to its attributes. I'm too lazy to go through the list auf 400 items, just to find it. Is there any way to do this?
1
vote
3answers
56 views

Selecting Features and Averaging Attributes

I currently have two point shapefiles, SHP A with approximately 75 points and SHP B with approximately 2000 points. What I would like to do is: 1) For each point in SHP A I would like to find the ...
1
vote
0answers
26 views

Sort Field in Pie Charts

I'm working on a class project where we make a pie chart out of an attribute table. The attributes are geologic layers (UNITNAME), and the area they occupy (area_pct). In the "Create Graph Wizard", ...
8
votes
1answer
135 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
108 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
37 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
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 ...
0
votes
1answer
63 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
0answers
22 views

How to use calculatefield_management with ArcPy and joined second table? [duplicate]

How can I use calculatefield_management with ArcPy if I have a joined second table? I want to go through the attached table's field and I want to get records where the certain fields is. How can I ...
0
votes
2answers
71 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
38 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
31 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
93 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
928 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
4k 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
42 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
29 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
64 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 ...
8
votes
2answers
963 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
70 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
201 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 ...
7
votes
3answers
4k 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 ...
7
votes
2answers
9k views

How to select multiple values with Select by Attributes in ArcGIS 10

Can anyone help me with selecting multiple values from the attribute table? I tried "Classes"='14'AND'07' but it doesn't work.
0
votes
1answer
169 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
33 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
79 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
10 views

Add Image attribute in QGIS [duplicate]

Anyone knows how to add an image attribute in qgis, so that when I click on the shape file for information it shows me the picture along with the attribute-table?
4
votes
1answer
3k views

Finding duplicate records in field using ArcGIS for Desktop?

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 ...
6
votes
2answers
690 views

How to stop writeOGR from abbreviating Field Names when using “ESRI Shapefile” driver

I'm currently using the following script to add some attribute data from a table to lots of individual shapefiles: library(rgdal) specieslist <- read.csv("SpeciesList1.txt", header=F) attdata ...
0
votes
0answers
70 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 ...