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

learn more… | top users | synonyms

5
votes
2answers
352 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
2answers
3k 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, ...
5
votes
1answer
324 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 ...
5
votes
1answer
392 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 ...
5
votes
1answer
509 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 ...
5
votes
1answer
193 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 ...
5
votes
3answers
141 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
1answer
1k views

Refresh Currently Open ArcMap Attribute Table using ArcObjects

I have written an ArcMap Addin (ArcMap 10.0) that allows a user to perform a join between an in-memory table and a feature class (feature layer) added to the TOC. I want the attribute table of the ...
5
votes
1answer
206 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 ...
5
votes
1answer
313 views

How to open QGIS attribute table in form view using Python?

I've got a plugin where I load some layers. After the last layer loaded, I show the attribute table. However, I would like to select the form view and not the table view (see image). How can I do ...
5
votes
3answers
4k 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
136 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
2answers
636 views

Rapid digitizing of Point Data using ArcGIS Desktop?

I have several big maps with a lot of points that I have to digitize. All these Points have different Values (depth in Meter, double) and will be stored in 1 Shapefile. Is there a way to speed up my ...
5
votes
0answers
70 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
140 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
4k 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
3k 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 ...
4
votes
2answers
124 views

How to create a consecutive alphanumeric column in a QGIS attribute table?

I am trying to create a column in the attribute table such that each cell lable is a prefix (M) follwed by a unique number ie M1, M2,.. etc
4
votes
1answer
5k views

How to edit attribute tables using Python/ArcPy?

I am new to Python, so sorry for such a trivial question. There is a shapefile (let's call it Structures.shp) and the script I'm writing needs to update the value of only one record in only one field ...
4
votes
1answer
6k 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 ...
4
votes
4answers
2k 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
678 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
2answers
133 views

Editing the DBF for a shapefile is yielding totally different results in R and QGIS, but the attribute tables are identical

I'm having kind of a peculiar issue that I'm hoping someone can shed some light on. I'm actually creating my map in R, but I'm using QGIS as a tool to check my mapping process (R newb here). So let's ...
4
votes
3answers
429 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").
4
votes
1answer
193 views

Extract one GPS fix per day from data?

I am in the fortunate position of having 2 years worth of animal movement data. With such a large amount of data I would like to extract only one fix per day to make it easier to work with. Data = 14 ...
4
votes
1answer
2k views

Add multiple fields in attribute table

How do I add in multiple fields in the attribute table? In the attribute table I have crop types such as corn, cotton, sorghum....etc (as shown image below), in square meters. and I want to generate ...
4
votes
1answer
4k 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
2k views

What is the most efficient way to search a geodatabase for NULL-like records?

The problem: I have a geodatabase with several datasets and many more feature classes within. The fields within the feature classes have been populated through joins with shapefiles and manual edits. ...
4
votes
1answer
921 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
1answer
4k views

Detecting duplicate attribute values in table using ArcPy without Advanced/ArcInfo level license?

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 ...
4
votes
3answers
6k 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 ...
4
votes
2answers
572 views

Does QGIS support internationalization?

Does QGIS support multiple languages? I have some shapefile with Arabic names in its attributes, and they appear as: ???? If I want to see the names in Arabic, do I need to purchase multi-language ...
4
votes
1answer
4k 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
1answer
5k views

How to add field in attribute table using ArcPy?

I have researched How to add attribute field to existing Shapefile via Python without ArcGIS? but could not implement it. Can give me examples of how to add field name in attribute table? I have ...
4
votes
1answer
183 views

Converting dbf into raster image using Python as way to add table to layout?

ArcPy does not have a function to add a table to a layout. I was thinking that maybe taking that table (e.g. a dbf), there may be some python script command to turn it into a raster (e.g. do ...
4
votes
2answers
851 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
3answers
972 views

How to get a list of attributes in FME when there are no records in table?

How to get a list of attributes in FME when there are no records in the table? I try use a PythonCaller but when there are no records, FME passes over this table. In PythonCaller I write: import ...
4
votes
1answer
1k views

How to write values from arcpy statistical output to table?

The attached script is my stalled attempt to perform the following workflow: Create a table and create fields Loop through a folder of point shapefiles and perform average nearest neighbor analysis ...
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 != ...
4
votes
2answers
44 views

Is there a way to get the current way a table is sorted in order to iterate over it?

I have a tool in ArcObjects that I'm working on where the OnClick() method finds the current row in the active attribute table (not the selection, but the row that has the carat to the left of the ...
4
votes
1answer
100 views

Using QGIS to create a table of correspondence between two area layers

I have two area layers over a map of Australia, and I want to know if it's possible to use QGIS to create a table of correspondences between them. The Australian Bureau of Statistics provides ...
4
votes
1answer
229 views

Make table views in ModelBuilder with Iterator

I'm trying to use the model as shown in the image to get 300 tables for the 300 points in the input feature class. I can get 300 viewshed rasters but can only get the table of the last point. It ...
4
votes
1answer
339 views

Is there a way to modify an Excel sheet which is already open in ArcMap?

I have an excel sheet that is joined to a shapefile in ArcMap. I need to modify many elements of the table, but every time I need to close ArcMap in order to be able to do it. Is there any way to ...
4
votes
1answer
337 views

Join a table to a parcel layer and get duplicate parcels, reflecting individual leases

I have a table of 3,000+ lease files that I'm trying to join to our parcel layer. Each parcel has 4+ leases associated with it, and I need each to be represented by an actual polygon. When I do a ...
4
votes
1answer
2k 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 ...
4
votes
2answers
3k views

Field Calculator does not notice selection? [closed]

I have a 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 no checkbox in ...
3
votes
4answers
1k 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 ...
3
votes
2answers
7k 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?
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 ...
3
votes
3answers
241 views

What FOSS GIS has the option to link attribute tables to rasters

In ArcGIS rasters can have attribute tables. What FOSS GIS offers a similar option?