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

learn more… | top users | synonyms

5
votes
3answers
2k 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
117 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
0answers
63 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
137 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
3k 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
2k 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
1answer
3k 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
5answers
617 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
1answer
190 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
2answers
799 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
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 ...
4
votes
4answers
1k 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
3answers
4k 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
1answer
3k 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
818 views

Road Symbol/Label issues

I am trying to control how many road symbols and how do I do that ? I have geodatabase that has Transportation and in it has a featureclass, "Major_Rds" and it also has three symbology for Interstate, ...
4
votes
1answer
358 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
2answers
448 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
3k 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
3k 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 ...
4
votes
1answer
4k 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
166 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
638 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
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 ...
4
votes
3answers
555 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
962 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
1answer
74 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
112 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
229 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
291 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
538 views

ArcGIS: Rapid digitizing of Point Data

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 ...
3
votes
4answers
665 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
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 ...
3
votes
3answers
233 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?
3
votes
1answer
4k 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 ...
3
votes
3answers
732 views

How to color-code geology maps with given CMYK colors?

I'm trying to understand whether it is possible to corectly display colours in British Geological Survey maps. Our client has a licence to use the shapefiles but unfortunately BGS don't provide SDL ...
3
votes
1answer
1k 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 ...
3
votes
1answer
2k views

Creating a multiple bar graph in ArcMap

I would like to graph my data from a shapefile. The data I wish to display is the sum of the nominal data per each year that it occurred. I have enclosed a screenshot to illustrate my idea. There is ...
3
votes
3answers
2k 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 ...
3
votes
3answers
198 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").
3
votes
2answers
82 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 ...
3
votes
1answer
227 views

Not able to save edits to vector layer in QGIS

I have a vector layer with about 200 features. So far I have been able to add polygons to this layer just fine, now it is giving me trouble. When I draw the polygon and try to save edits, the polygon ...
3
votes
1answer
157 views

QGIS - Is it possible to increase Output Field Name?

When creating a new Column, the default value for the length of the name is 10. Using the Field Calculator via the Model Builder, I want to include the names of regional areas into the columns which ...
3
votes
2answers
523 views

How to Select by Attributes on features sharing common value?

I am attempting to 'select by attributes' a point feature with the lowest numeric value which shares a common value with other point features in another field. For example: I may have 3 point features ...
3
votes
2answers
122 views

Efficient ways to read table data from a large feature layer?

I have a feature layer that contains about 460,000 records and it currently takes about 20 minutes to read that table using the arcpy.da.TableToNumPyArray() tool. Is there a more efficient way to read ...
3
votes
2answers
78 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 ...
3
votes
1answer
441 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 ...
3
votes
3answers
48 views

Is there a way to shift data in an attribute table so that all attributes are moved to a different coordinate?

I have several shapefiles where the attribute table is composed of timestamped data that is appended to the coordinates. Because of the nature of my data, I need to apply a time lag so that the data ...
3
votes
1answer
113 views

Calculating distances from points to the centre of cells

I am using QGIS 1.8.0 (using older version because I need the Qmarxan plugin which is not available for 2.4.0). I have a study area that has a vector laying of "planning units", or cells over the top ...