The relationship between from fields and to fields when performing append, merge or similar operations indicating how fields will be populated in the result dataset.

learn more… | top users | synonyms (1)

2
votes
1answer
31 views

Where is the field mapping for Attribute Transfer tool stored?

I can't seem to find any patterns in when the source-destination field mapping is preserved. Is this stored in the database, map document, or elsewhere? I'd like to know so I don't have to create the ...
1
vote
0answers
29 views

Spatial Join - Field mapping to delete and rename fields

I have a python script where the user can enter a study area (Polygon shapefile) and multiple point Features of interest (Point shapefiles). The point shapefiles are looped through and joined with ...
1
vote
1answer
42 views

What is the equivalent of city, county and state in the Philippines?

I am developing a map application using HERE Maps and wondering if what is the equivalent of the fields 'city', 'county' and 'state' for the addresses in the Philippines? Currently, I have mapped ...
4
votes
1answer
51 views

Can the field mapping be shortened in ArcToolbox tools?

I have converted a model to python in ArcGIS 10.3, and have found that the tool outputs a full and very very long field mapping. Is there a way to shorten this somehow? While I want all field ...
2
votes
1answer
24 views

Arcpy.addTable() error

I am having a little trouble debugging an ex-coworkers code. I was wondering if the SE community could be another set of eyes and help me. I am receiving this error: RuntimeError: FieldMappings: ...
1
vote
1answer
57 views

Change length of string fields in featureclass using arcpy v10.1

I am trying to edit the length of all the text fields in a feature class. The feature class has a lot of fields so I want to do this in python. I only have access to v10.1 so cannot use the ...
0
votes
1answer
31 views

Adding FieldName in Field Mapping - ArcGIS

In ArcGIS FieldMapping, is there any way to add "FieldName", while we use MergeRule-Join? Please refer the attachment; I know, we can concatenate Field Values using MergeRule-Join, with Delimiter ...
2
votes
1answer
71 views

Spatial Join Field Mapping in ArcPy?

I know there already are posts about this subject, I tried to derive a solution for my own problem but the code for field mapping is very complex to me. I have a Raster 100x100m and point layers that ...
0
votes
0answers
23 views

How to create a spectral library in ERDAS for field derived spectra

I have several spectral signatures derived from a field spectrometer that I want to use in ERDAS. The plan is to import them into a created spectral library and use these field derived signatures in ...
1
vote
1answer
179 views

Change Field Type using Field Mapping for List of Tables using Python

I have a collection of about 200 tables, and I would like to make sure that all the fields are text before merging them into a single table using python. There is at least one field ("Number_of") ...
0
votes
0answers
39 views

Using the 'Mean' mergeRule with a spatial join

I have two feature classes. The first is a point file, derived from a raster, with the values for slope of the terrain. The second is a shapefile of polygons. What I want to do is spatially join the ...
0
votes
4answers
73 views

ModelBuilder - Iterate through tabels to join and export and keep original field names

I am trying to iterate through an excel with over 200 sheets and join each to a ZIP code layer. I then need to symbolize each of those the three different ways and save that to a layer file. In order ...
1
vote
1answer
43 views

Field mappings object not functioning with Merge_management

I'm trying to limit the number of fields when I perform a merge to two. Below is the script I have created to do so. However, the merged feature class carries over all fields, despite my use of a ...
0
votes
1answer
65 views

Script not working as expected

I'm newbie to python and I wrote this script. It is supposed to check the text in the fields fld_o and fld_d and write a value (just numbers in a sequence) to a newly created field fld_name. While ...
3
votes
2answers
791 views

Scripting spatial join in arcpy - how to set field attribute in field mapping object?

I'm scripting a spatial join in ArcGIS with Python. I only want the resultant feature class to have a single field containing one attribute from the join features. In general, many join features ...
1
vote
1answer
109 views

When building fieldmappings, how do I handle the SHAPE field?

I have a collection of hundreds of shape files and a python dictionary mapping the input field to the output field. I'm building my fieldmappings dynamically using this dictionary since it already ...
2
votes
3answers
489 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 ...
1
vote
1answer
101 views

Using Spatial Join to copy a single attribute

I am attempting to use Spatial Join to combine tax parcels and zoning information, such that the parcels contain the designation of the underlying zone. However, I only want to take the "esmZONE" ...
0
votes
0answers
80 views

Field Mapping not recognizing fields in VRP?

I have created a VRP using Model Builder. Everything looks to be working fine other than the "load location" for Orders. Depots and Routes are directly called so they were fine, however Orders were ...
2
votes
1answer
60 views

Is there Data Loader for QGIS or Spatialite?

Is there a tool that works like the data loader of ArcGIS for QGIS (or via Spatialite )? To integrate data in a database or a shapefile without having the same structure (and the tool allows to ...
1
vote
1answer
84 views

How to fill column with several conditions using QGIS field calculator?

I know the synthax in order to fill one field with only one condition (field calculator): case When "attribut" = 'value' then value End But how to do populate automatically one field with ...
0
votes
1answer
258 views

Field Mapping in ArcPy gives Error in adding input field to field map?

I have a process in which I am joining a DBF table to multiple shapefiles to create a new output of some selected fields which result from the join. I am new to fieldMapping and need help figuring out ...
2
votes
1answer
257 views

FieldMap in Arcpy Merge for Selected Fields Only

I am trying to use FieldMap in arcpy to merge only a few of the same fields from 8 feature classes. There are many different fields in all of the different feature classes, but I have identified the 9 ...
1
vote
3answers
338 views

Export selected fields in ArcGIS to Excel using Python

I'm am creating a script that will allow a user to add XY coordinates to a point layer, then export (along with any addition user selected fields) to Excel. I am getting stuck on the iteration of the ...
1
vote
0answers
118 views

Field mapping for append crashes python

I am trying to append multiple feature classes to a new one. As they come from different sources, the fields are all different, so I have to map the fields of the input feature classes to the fields ...
1
vote
1answer
72 views

How to add IDs of the links composing a polygon?

I built up a polygon layer from a road network for finding roundabouts using the compactness factor of a polygon. Then I have to intersect the extracted roundabout polygons with the road network so ...
0
votes
1answer
304 views

vb.net arcobjects mapping different field values in attribute table

I need to mapping different field values in an attribute table. The attribute table as follows: For example, I want to get the "DrainName" value when "BQ no." = "22/22" and "Segment ID" = ...
1
vote
1answer
166 views

ArcPy FieldMappings syntax using Merge tool

I'm working on script that takes several table results from the Zonal Statistics As Table tool and merges them into a single table. When merging I encounter the issue that the exported .dbf files have ...
0
votes
1answer
168 views

Can FieldMappings be used to drop all attributes?

We have a script that regularly copies a bunch of feature classes out to shapefiles, keeping only the most important attributes (e.g. customer category) and dropping useless/private information (e.g. ...
3
votes
0answers
117 views

Pulling ArcSDE feature classes from current map to fieldmapping as DETable?

I'm working with SDE layers in arcmap. trying to avoid pointing to the sde file itself. I've tried workspace.Pathname, it was empty for sde remote workspace. I've also tried IName from workspace, ...
2
votes
0answers
274 views

arcpy fieldmappings: can't set output field name for fieldmap

I am testing out some code in the Python window of ArcGIS so that I can insert it into a standalone script later. I want to create a copy of a table and add a new field that is the result of ...
2
votes
2answers
453 views

Android Tablet KML/KMZ App for polygons w/offline & GPS capabilities?

I am looking for an Android app which allows me to view and query polygons stored in KML and/or KMZ with a GPS point representing my location and offline capabilities. My KMZ files are being output ...
1
vote
2answers
171 views

Change field map properties in ArcMap

I am trying to import csv files in ArcGIS to do a join. However, some of the fields are identified as double, some as long and some as long. Therefore the join results in bunch of columns with NULL ...
4
votes
1answer
1k views

copy feature class and retain selected fields with arcpy

I've got a featureclass (fc) that I want to copy, but only retaining a selected number of fields, let's say field 9, 11, and 12 from the total of 15 fields. I want to use arcpy and suspect that ...
3
votes
1answer
409 views

Field Value Mapping QGIS

I am wondering if there is a way to do field value maps that are filtered based on another attribute field? I know how to associate value maps, but not that are connected to another field. I have ...
1
vote
0answers
479 views

Need help using FieldMappings object with Append_management in Python [closed]

I have a fairly large script that I'm reworking. The script is manipulating tables with 50 or so fields. (I will be cleaning some of these up to reduce the number.) Toward the end of my script I call ...
3
votes
1answer
659 views

ArcPy merge datasets with slightly different fields

i have many (>15) shapefiles which have slightly differing fields. s1: (Name, age, layer_1, ...) s2: (Name, age, layer_1, layer_2, ...) ... s_n: (Name, age, layer_1, layer_1_extra, ...) I want to ...
3
votes
1answer
330 views

How to avoid field map change when altering file locations in a model (e.g. using feature class to feature class tool)?

I have a backed up file GDB which I have to use because the current one had some broken models in it. I got this backup delivered on my local D:\ drive and have to copy models from this GDB to a ...
3
votes
1answer
938 views

Using field mappings to remove fields from a merged table

EDIT: Soreted, thanks :-) I'm trying to combine a (large) number of tables into a merged table, keeping only certain fields. I've tried the below, but it still gives all the fields. Any ideas? ...
1
vote
1answer
72 views

How to use in_field_map parameter of CreateCompositeAddressLocator_geocoding?

I would like to know if anyone who has worked with the CreateCompositeAddressLocator_geocoding method knows how the "in_field_map" parameter is formed?
2
votes
3answers
659 views

Field Type Date invalid when run in Python, but not in Model?

Using ArcGIS Desktop Advanced 10.1 and PyScripter When running the arcpy.FeatureClassToFeatureClass_conversion, I get the error that the field type of Date is not valid. However, when running this ...
1
vote
2answers
2k views

Arcpy Error in adding input field to field map

hi guys i m doing a script in Arcgis i m new to this, i have to append some field from a table to another, i did this script in python but i have a problem when it want make the Mapping field with a ...
4
votes
1answer
712 views

How to fill Field Mappings parameter in script tool on updateParameters?

My goal is to get a list of fields choosen by an user from existing fields in feature class. I think that I can show all fields in Field Mappings dialog, an user deletes unwanted fields and I get a ...
11
votes
1answer
6k views

“Field Mapping” in ArcGIS 10 - ArcPy

I've wrote a Python script that does a spatial join and some simple calculations. My problem is with setting the merge rule for one specific field, and leaving the rest of the fields as is. For ...
19
votes
11answers
6k views

Permanently reorder fields in data (shp, gdb)

If I have a shapefile or geodatabase featureclass that has fields that I want to permanently reorder, is there a tool, script, or utility that will help me quickly accomplish this task? Generally I ...
0
votes
1answer
367 views

Eliminating a column from a copied feature class via a fieldmap object in ArcGIS Python

The use case is exporting a feature class via a Python script (arcgisscripting v9.3x. Only a few of the columns are needed in the result feature class. I commonly use the fieldmappings/fieldmap ...