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

learn more… | top users | synonyms

11
votes
2answers
292 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
332 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 ...
6
votes
2answers
1k 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
2answers
825 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 ...
5
votes
4answers
5k 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 ...
5
votes
1answer
514 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
147 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 ...
4
votes
2answers
951 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
2answers
205 views

ArcMap: Calculate Quarter using Date field

I am using ArcMap 10.0 and making a map where I symbolize on annual quarter (i.e. Q1 2013, Q2 2013, and so on by quarter through 2015). If a date field contains this: 01/15/2013, and I wanted to ...
4
votes
1answer
55 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 ...
4
votes
1answer
164 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', ...
3
votes
5answers
5k views

Renaming a 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: EDIT: import sys import traceback import ...
3
votes
1answer
1k 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
2answers
257 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 ...
3
votes
4answers
1k 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
1answer
359 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' ...
3
votes
1answer
24 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
54 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
48 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
63 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
875 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
113 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
80 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
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
1answer
128 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
114 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
127 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
349 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
66 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
685 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
1answer
139 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
33 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
51 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
101 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
71 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
87 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
82 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 ...
2
votes
0answers
83 views

Exporting spatialite view to shapefile from QGIS modifies the original data types

We have a spatialite .sqlite database where we have views which are nicely rendered by QGis, with all the symbols and everything!! There are integer fields on the view which are based on fields of ...
2
votes
0answers
133 views

QGIS 2.4.0 Chugiak “reduced” real-type numbers. Precision problem? Bug?

I have a SHP point file created from CSV with QGIS 2.4.0 Chugiak. It contains some data on noise in a certain point. When I import from CSV, it seems to be fine, but when I export to SHP and open the ...
2
votes
0answers
45 views

Why is ArcMap deleting data from a field when I add a new one?

My copy of ArcMap 10 is acting pretty strangely. I have a shapefile and all I've done is added a new field as a FLOAT and for some reason all data in another one of my fields is being deleted! Does ...
1
vote
2answers
129 views

How to Invert Deleting multiple fields with delete tool in ArcGIS 10.1 SP1

I have a feature (polygon) with nearly 60 fields in it. Now I want to delete all fields except 20(or a list of) and they are not one after one, no they are somewhere in the droplist. But to select for ...
1
vote
1answer
58 views

Field's name with numbers: why not?

I have tried to create field in TOC called with numbers with python. But, it has a problem: it couldn't do it because name's of fields are numbers. It is strange for me. When I do new field in shape ...
1
vote
1answer
455 views

What might cause “ERROR 000728: Field <fieldName> does not exist within table” in this code?

I have seen ERROR 000728 several times and I could never figure out why it happens. Here is a snippet from my code: str_Dissolve = arcpy.Dissolve_management(Intersect_str, ...
1
vote
1answer
296 views

Updating the value of a field with pre-defined values

I am trying change the value of a row for a field whose type is "short" in arcmap using a python script. with arcpy.da.UpdateCursor(FILENAME, FIELD) as cursor: for row in cursor: row = ...
1
vote
2answers
1k 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?
1
vote
2answers
45 views

Using Python to Rename Feature Class by Field ArcMap

Alright so I made a pretty little model and at the end I want to rename the feature class file to something based on the fields in that feature class. I want to rename that feature class by the date ...
1
vote
1answer
36 views

Change the data type of a field in multiple shapefiles

Is there a way I can change the data type of a field (possibly using the python window). I have about 25 shapefiles which are all named differently, but the name of the fields I want to change from ...
1
vote
1answer
65 views

Postgres/PostGIS: Dissolve multiple fields with COUNT (Point shape)

I have loaded point .shp feature classes into Postgres 9.3 db, and enabled postgis,plpgsql,postgis_topology extensions. I'm looking to dissolve multiple fields within a single table 'TABLE1' and add ...
1
vote
2answers
84 views

Using the Rule-based style to calculate each grid cell from overlaps

I am using the Rule-based styling properties (QGIS 2.2) to determine the colour of grid cells for a merged shapefile. Each grid cell defined by its ID may be overlapped by several layers as defined by ...
1
vote
1answer
91 views

How to derive Z-score values for a given field

I have a shapefile with an attribute field with a range of numerical values. I would like to derive z-score values for this field within ArcGIS. Any tips?