In GIS, Fields, also known as attributes, contain information about features.

learn more… | top users | synonyms

11
votes
2answers
354 views

How to sort by multiple fields at the same time?

Is it possible to sort multiple fields at the same time in QGIS? For example, I'd like to sort a table by state name, and then within each state, sort by county name. This would be the same as the ...
8
votes
5answers
369 views

Print out the properties of the attribute table in qgis?

I have to merge a lot of shapefiles into one great shapefile. So I want to compare the properties of the attribute tables to see if there are differences between the tableproperties of each shape ...
8
votes
2answers
1k views

How to specify fields to export from QGIS?

I'm using QGIS 2.0.1 and am connected to a MS SQL Server spatially enabled database (not ESRI). I am able to connect to the layer and load it into my TOC just fine. I have hidden a number of fields ...
7
votes
2answers
2k views

Maximimum length of text fields in shapefile and geodatabase formats?

The maximum text string for a field in a geodatabase is 320 characters. The data I am importing has long character strings and it seems to be truncating when I convert into shapefile at the max ...
6
votes
4answers
10k views

How to Change Field Name in ArcGIS 10.2

Can someone please let me know how I can change the field names (not the alias) in ArcGIS 10.2. I already found this page on ArcGIS support: "Renaming shapefile fields (Defense Mapping)" but there is ...
6
votes
2answers
127 views

Clean up attributes

I want to clean up the attribute table of a road shapefile for all the entries in the fields. For example: As seen below I have a road feature with a "Name", Name From and Name To in the attribute ...
6
votes
1answer
274 views

How can I exclude a field on a table from being copied?

I have a query "layer": >>> r = arcpy.MakeQueryLayer_management(r'C:\path\to\connection\file\connection.sde', 'TEST', 'SELECT T.ID AS OBJECTID, T.* FROM MY_TABLE T WHERE T.SOME_COLUMN = 1', ...
5
votes
2answers
486 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 ...
5
votes
1answer
954 views

How to check if feature class or table contains field with specific name before adding it?

Im trying to write a script that finds out if the shapefile has a specific field and if not to add the field. I get it to show me the field, but the loop goes through each field, so it would create a ...
5
votes
1answer
172 views

How do I extract partial data from one field to another?

Answer Below I am attempting to extract a date stamp that is contained in one field and insert it into another field. The issue is that the date (in bold below) is not in the same location in each ...
5
votes
1answer
648 views

How to change the field value of a Shapefile using GDAL/OGR?

I am trying to change the field value of a shapefile. However it doesn't change the value. What's wrong with my code? import ogr driver = ogr.GetDriverByName('ESRI Shapefile') fn = 'dist.shp' ...
4
votes
2answers
1k views

Choosing Shapefile attribute data type to use?

I am trying to figure out when to use (in the Data Type of SHAPEFILE PROPERTIES) - TEXT - SHORT-INTEG - LONG-INTEG - FLOAT AND DOUBLE. I am using ArcView 9.3 and I know when it is all text or use ...
4
votes
1answer
2k views

How to List field name aliases in one shapefile/layer using ArcPy?

I want to use arcpy/python to print out a list of all the field name aliases for a specified shapefile. So far I have been able to hack a script I found to list all the field name aliases associated ...
4
votes
1answer
92 views

Adding GUID field with ArcObjects

I'm trying to add a GUID field programmatically to an existing FeatureClass using ArcObjects. Here is my code: ISchemaLock schemaLock = (ISchemaLock)ipFC; try { // A try block is necessary, as ...
3
votes
5answers
7k views

Renaming field using ArcPy?

What I need to do: rename a field name of a table/feature class copy all values to the new field So far I have done following code as @artwork21 suggests: import sys import traceback import arcpy ...
3
votes
2answers
2k views

How to retain Field Name / Alias on Export of Table?

Is there a way I can modify the Field Name or to make him keep the Alias when a table is exported? Or is there a way to keep the Alias instead of the Field Name, when exporting for example to .dbf ? ...
3
votes
4answers
2k views

Why does Field Calculator return 0 values when decimals are expected?

I realize I posed this question, and got answers, several days ago (see (Field calculator error)) , but none seem to really be working, and so am posing again. Below are two screenshots that show the ...
3
votes
2answers
82 views

Looping field name change

I need to alter all of the field names through multiple feature classes. I have a pretty good idea of which tools to use but I'm not sure how to loop them through each feature class and each field. ...
3
votes
1answer
41 views

ArcMap Using Python to Rename a Feature Class based on Print Results

I would like to rename a feature class based on the EDITOR and DATE fields. I wrote this code: import arcpy fc = "C:\Users\PythonTesting.gdb\MyFile" f1, f2, f3 = "EDITOR", "DATE", "OBJECTID" ...
3
votes
1answer
64 views

Crosstable two fields of a pointfile (ArcMap)

I'd like to produce a simple crosstabulation from two fields of a point feature class. These fields contain land use class information which I'd like to compare. One option is to export a dbf and do ...
3
votes
1answer
50 views

New field names after joining 2 tables in QGIS

When joining two files (A.csv and B.shp with a common unique ID) in QGIS the new fields in B.shp (from A.txt) include the name of the field + the name of the file where it comes from (A). For example ...
3
votes
1answer
78 views

How to remove a specific unique value with arcpy

using arcpy, i would like to remove,from 50 mxd files, a specific unique value called "residence a" (exist in 3 layers) from the table of content. so i will get this result: The value of ...
3
votes
1answer
113 views

Changing Visible Field Properties on Multiple Layers at once

I am pretty new to all of this and I apologize that I don't know all the correct verbiage. I am using ArcGIS 10.0 I have a map with a layer dealing with electrical primary circuits, that I split ...
3
votes
3answers
1k views

Field format lost when exporting events layer to shapefile - long field type converted to double

I have a MS Access 2010 database with about 80 000 records in it. It is point data for animal locations. I would like to bring this into GIS and project the data into lambert conformal conic. I am ...
3
votes
2answers
155 views

How to add iteration in model to join fields from several shapefiles into final one?

I have one grid (Atl1x1.shp) to which I need to add 9 Fields from 9 different shapefiles which are also grids (that is, 1 column from each shp, all with the same name). These shapefiles have the same ...
3
votes
1answer
98 views

How do I add a field to a table using the QGIS graphic modeler?

I was wondering if anyone could help as I'm struggling to get anything out of the QGIS graphic modeler. For info I have no programming skills whatsoever. I need to be able to add a new field to an ...
2
votes
3answers
133 views

How to rename field via ModelBuilder?

I joined some fields to my tables and now I need a tool or something to change that field's name. How can I do this in ModelBuilder? I didn't find any tool to do that.
2
votes
3answers
125 views

Best way to delete many fields from many feature classes using arcpy?

I'm currently formatting our GIS data for use in a mobile app. The purpose of altering the data is to reduce the output file size that's imported into the app. I need to delete many fields from many ...
2
votes
2answers
414 views

How to set NULL as default value for a date field in QGIS 2.4?

In QGIS 2.4, i am unable to set the default value as NULL if i have not updated any value on date fields. Its automatically taking the current system date. I am expecting to set the default ...
2
votes
2answers
78 views

Ignoring field types in Python list returned by arcpy.ListFields()?

I am generally just wondering if there is a nice and easy way in python to ignore all fields of a specifiy type (eg string) in a feature class. At the moment I am doing it with field_names = ...
2
votes
1answer
321 views

Change field names automatically

I have an attribute table with over 2500 fields. About 2000 fields start with the name "All_txt_" (eg "All_txt_Watermelon"). Is there a way to remove this "All_txt_" from all the fieldnames ...
2
votes
2answers
3k 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?
2
votes
1answer
973 views

How to create a date field in QGIS shapefile

When I create a new shapefile in QGIS, I'm presented with the "New Vector Layer" window, where I specify the Shapefile type (Point/Line/Polygon) and am then able to create attribute fields. I'm only ...
2
votes
2answers
1k views

rename feature layer fields

Guys and gals could you please provide me with a sample code as to how to rename a field name in a Feature Layer or Table. I've been trying to use the FieldInfo object to do so over the last couple ...
2
votes
2answers
41 views

QGIS joins 2 FIELDS

I. a new to GIS and mapping. Using QGIS. Have an excel with 4 columns (Region; District; village; number of cases) Have a shapefile with dots for villages with many columns including (Region ; ...
2
votes
1answer
37 views

Leaving out specific values from labels

I am trying to label a field using two fields. Example: "[FieldOne] / [FieldTwo]". But I don't want to show FieldOne if the value is zero. Example: 0 / 1050 should read just 1050 whereas 1/1050 should ...
2
votes
1answer
209 views

Possible to set an attribute field to update automatically based on another field?

If I have 2 attribute columns and I wish to change certain values, is it possible for the second attribute column to automatically update its values based on an expression? Example: Age | Status 10 ...
2
votes
1answer
208 views

*Value relation* widget in QGIS

I cannot understand what the Value Relation widget of the Fields menu in QGIS actually does. For example: I have a point layer with some columns (ID, value1...) and a table (so just a dbf file) with ...
2
votes
1answer
173 views

Using the UpdateCursor to change the values in fields added with arcpy.Addfield_management

I am working with some ArcGIS data and trying to add fields using AddField_management. >>> arcpy.AddField_management("huc4","Class","TEXT") I want to populate this new field using the ...
2
votes
1answer
617 views

How to copy values from field to another using arcpy?

Can some one please let me know how I can do simple field calculation like Copying From "A" to "B" in ArcPy? I have found lots os example on web which they all used extra expression and they were ...
2
votes
2answers
67 views

How to travers fields of records without introducing them all in the function?

In my previous question I wanted to reach a field in the field calculation; however, it was pretty easy to introduce a few more inputs for that function. Now, I am facing a problem which needs around ...
2
votes
1answer
155 views

How to hide all fields at once in QGIS 1.7

Is there a way to hide all the fields at once in QGIS 1.7? I see where I can hide one field at a time but I would like a button which does it all at once.
2
votes
1answer
34 views

How to display map tips only for one layer?

I'm relatively new to QGIS. I added the hover labels to my map using the Map Tips. My issue is that it makes hover labels for EVERY layer on my map. I only want it to make labels for one layer. Is ...
2
votes
2answers
52 views

How would one format an Excel sheet so numeric fields are set to numeric field types when importing to ArcGIS 10.2?

I have a large Excel spreadsheet that contains lots of numeric data that I would like to import to ArcGIS 10.2 as a table using the Excel To Table (Conversion) tool. The frustrating thing is that ...
2
votes
1answer
40 views

Atributing fields in arcmap and excel

How do I populate a field in ArcMap (and Excel) with only a specific part of another field's attributes? For example: I want to populate the LATDEG field with only the degree part of a latitudinal ...
2
votes
1answer
55 views

Expression to create and populate column based on filtered fields

I wanted to create a column and populate it with data based on data from other fields. If column_1 contains fields which has similar string (eg. field_1 = "Country: UK", field_2 = "Country: US", ...
2
votes
1answer
237 views

How to create a Qgis python script to manipulate fields with some parameters?

I'm just beginning with QGIS. I have a shape file with 10 fields field1, ..., field10, and many thousands of data. I will like to automatize the next sequence (in a python script or a model): load ...
2
votes
1answer
205 views

Assignment of defaults to field not working

I am using ArcGIS 10.2.2 for Desktop. I have assigned default values to some fields in a feature class, which is sitting in a file geodatabase. I used the "Assign Default To Field Tool", which ...
2
votes
1answer
132 views

QGIS: Expression WHEN property1 = 'FOO' THEN property2 = 'BAR'

Our Foundation is adding additional properties to points. If property1 = FOO , then add property2 = BAR WHEN property1 = 'FOO' THEN property2 = 'BAR' END When I run this the ...
2
votes
1answer
83 views

Python scripting for making rings from the city center

Problem description: I have two layers: 1) [Polygon] city blocks, and 2) [Point] the city center. The City blocks layer has 110,681 records. And The city center layer has just one record because ...