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
3answers
107 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 ...
0
votes
1answer
57 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
41 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
49 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
46 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
77 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
100 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
158 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
73 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
58 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
186 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
111 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
95 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
95 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
143 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 ...
1
vote
1answer
274 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
126 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
657 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
214 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
293 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
485 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
250 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
538 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
62 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
550 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
1k 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 ...
10
votes
1answer
5k 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 ...
17
votes
11answers
5k 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
335 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 ...