Questions tagged [field-mapping]

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.

Filter by
Sorted by
Tagged with
3
votes
1answer
60 views

Defining fields to keep and deleting all other fields in feature class using ArcPy?

I am trying to write a script to read a feature class, list all fields and keep only specic ones. I.e. drop all remaining columns. I guess that pseudo code should be: allFields = create list of all ...
1
vote
0answers
38 views

Field Mappings control doesn't show the Add Input Field in the context menu of a Python Toolbox

I’m trying to build a Python Toolbox which uses a Field Mappings control (GPFieldMapping parameter). For some reason I don’t manage to get the same behaviour of the Field Mappings control as in the ...
1
vote
0answers
34 views

Are feature ids in QGIS and ArcMap stored differently?

I have a shapefile that I use as a layer in ArcMap. Opening the attribute table, shows a fid starting with 0 for the features. If I attach the same shapefile in QGIS and open the attribute table, the ...
1
vote
2answers
58 views

Understanding and using fieldmapping with ArcPy?

I'm having trouble trying to understand how fieldmapping works in ArcPy (I'm kinda new to Python). In the below example, I want to take a shapefile and append it to a feature class. But I want to use ...
0
votes
0answers
24 views

Fieldmapping for mean and max using arcpy

I'm trying to spatial join two features. One polygon layer and one point layer. The point layer contains one field of values that I want the Mean and Min of. Im trying to use the fieldmaper object to ...
1
vote
0answers
43 views

Creating Field Mapping Parameter in Arcpy Script

I'm trying to create a tool that compares two data sets. I do not want the Feature Compare tool. Most of the field names in the two data sets are the same, but not all. I want a way to map one field ...
2
votes
1answer
99 views

Using ArcPy FieldMappings?

This is a follow up to Output field name not showing up in spatial join result in which I received no response. I am trying to convert a shapefile to a feature class, I also have a GeoJSON file with ...
0
votes
0answers
39 views

Calculating field after arcpy.Append_management()?

I have some AutoCAD layers (f.e. Cad1, Cad2) and I want to export them into feature class in a geodatabase (f.e. feature_class). Also I want to calculate field in "feature_class" for objects from CAD. ...
0
votes
1answer
78 views

MultiValue Selection with MultiValue Input

I made this Python Toolbox as a practice run for a larger project I want to do as I am new to python toolboxes. While this was successful I am not able to the result that I want. I want to be able to ...
1
vote
1answer
55 views

Merging on specific fields

Lets say I have three shapefiles/features I want to merge: 'florida.shp', 'mississipi.shp' and 'louisiana.shp'. They all have 3 standard fields common to all: 'DFIRMID', 'SFX', and 'FIRMPAN'. I want ...
-1
votes
2answers
85 views

Field mappings remove field from arcpyTable to Table conversion

I want to export a table but would like to remove one of the fields before doing so using arcpy. I'm trying to use field mappings but am missing something: fields = arcpy.ListFields("some_table") ...
0
votes
0answers
69 views

Passing attributes from join features to target features in 'SpatialJoin_analysis'?

I'm doing a spatial join between two polygon data sets (A and B). B polygons are always smaller than A polygons and there's only a small number of them. They have 2 attributes that I'd like to pass on ...
1
vote
0answers
136 views

Renaming ESRI default SHAPE_Length and SHAPE_Area fields [closed]

I have been working on a draft feature class that will eventually go into our production database, and I just tested it against my organization's standards, but it fails because the "SHAPE_Length" and ...
2
votes
1answer
116 views

Cannot assign output field name to FieldMap

In attempting to map input fields to output fields, I am finding that I cannot correctly assign the output field name. Running the script produces no errors, but for a given FieldMap object, the ...
2
votes
1answer
42 views

Merging many different feature classes into one but only taking certain fields from each?

I'm trying to merge ~50 feature classes into 1. The problem is, these feature classes have many different fields, and some that i don't want in the final FC. I can delete the fields one by one ...
1
vote
1answer
105 views

How to bring over only 2 fields from the join feature class when using “SpatialJoin_analysis” and set up a merge rule?

I'm trying to understand how to use FieldMap and FieldMappings. I know very little about objects plus I'm finding the explanations on ESRI website not very good and far from comprehensive. All I'm ...
4
votes
1answer
113 views

What does “Do you want to reset the field mapping” mean in QGIS Refactor Fields dialog?

I want to convert the type of some fields in a vector layer from String to Real. I am trying to use the Processing -> QGIS geoalgorithms -> Vector table tools -> Refactor fields tool to do this. When ...
3
votes
4answers
794 views

Using Field Mapping with TableToTable_conversion in arcpy

I am importing csv files into a gdb, and need to change a couple field types during the import. I am trying to use the field mapping in TableToTable_conversion to change the field type as the table ...
3
votes
1answer
83 views

Split a vector into parallel grids [duplicate]

I have a piece of land (vector) with, for example, potatoes and I want to make a grid for spraying. That means i need a grid with size 45mx10m with different values per box. Important is that the grid ...
6
votes
1answer
116 views

Using Polygon or Multipolygon for mapping fields in QGIS?

I'm trying to map medieval field systems in QGIS, this means that I'll be drawing quite a few polygons. I've mapped quite a few fields already using Spatialite layers using polygons, though I was ...
2
votes
1answer
107 views

Making model in ModelBuilder output fields based on user input shapefile and not shapefile used to build model?

I made a model with which I would like to process various shapefiles that have different fields. I built it using a test shapefile that had its own fields. When I try running another shapefile ...
5
votes
1answer
396 views

Resources for Arcpy Field Mappings String Syntax

I need to edit an existing python script to add an additional field to a field mapping function. This field mapping function does NOT use the arcpy field mapping object--it instead uses a structured ...
0
votes
2answers
251 views

ArcPy ERROR 000800 AlterField_management

I made some adjustments to existing code, and now there seems to be a glitch down the line in an area where no adjustments were made. My initial goal was to ensure the correct data types are shown ...
2
votes
1answer
147 views

Select all fields from table and use with arcpy.DeleteIdentical_management()?

I would like to use arcpy.DeleteIdentical_management() function without having to specify all fields in the table. Is there a keyword used to select all field in a table? I tried "*" or "ALL" but ...
3
votes
1answer
744 views

How to directly add new fields at the right position with PyQGIS?

I have an existing Attribute Table. I add new fields with PyQGIS but I would like to set this fields at the second and third position and, not at the end. Because by default, the new field is added at ...
2
votes
0answers
587 views

Using arcpy.FieldMappings() to load data into tables

I have been tasked with bringing in a dataset from one table with a hard and fast schema into another table with the same. Both tables have very similar fields, but the names and capitalization are ...
1
vote
2answers
62 views

Ignore Fields in Target Table When using FieldMapping in Append Tool

I am transforming one feature class into another (currently empty) feature class. The input feature class and output feature class share the same fields, but the output feature class has some ...
2
votes
0answers
126 views

Field Mapping in Custom ArcMap Script

I'm writing a script which takes, for its first two parameters, feature classes (or tables). For the third parameter, I want to provide the user with a field mapping option similar to what ArcMap uses ...
1
vote
0answers
333 views

Get field name of shapefile geometry for using GeoDjango LayerMapping

I want to use LayerMapping to insert any shapefile to PostGIS. I insert the geometry only, into generic tables. For that i need a mapping between the shapefile field names and the django models field ...
4
votes
1answer
887 views

Setting list of fields to field mapping of spatial join using ArcPy?

I try to code spatial join tool and delete some fields in the result. to delete the fields i list the fields of source layer and the result layer then use the list of differences in the two list and ...
0
votes
2answers
2k views

App for recording waypoints and photos for GIS on android

I'm looking to collect photos and notes during a field trip to add to (just for comparison) a landcover raster dataset I'm working with. Ideally I want to visit certain field sites, take photos with ...
0
votes
1answer
71 views

How to compare feature sets with different field names?

I am trying to compare the fields of 2 feature layers to each other. The fields, though, have different names. I think this image shows this a little better: I am lost as to how this can be ...
1
vote
0answers
276 views

Append not populating target dataset - Arcpy

I am attempting to append several features from an input dataset to a target dataset. Both datasets have several matching fields, which are the ones that I would like to keep - fields that do not ...
1
vote
2answers
245 views

Simpler Method to Map Fields in Spatial Join

I've cobbled together a script, part of which creates field mapping to sum fields in a spatial join. It took 13 lines of codes just to define which fields I want summed in the output. Is there a ...
0
votes
1answer
177 views

Changing the target field width using Fieldmappings. ArcGis, Merge,

I need to merge several shapefiles. All of them has the same attribute/field structure, but the width is not the same for the attributes with the same name. I tried to use Fieldmappings to set a wide ...
0
votes
1answer
127 views

Batch append features with custom attributes

I have a directory with 2,000+ subdirectories that contain shapefiles submitted by project managers through a web form. Some contain additional subdirectories that hold the shapefiles as follows: L:\...
1
vote
0answers
258 views

spatial join field mapping Arcpy, change merge rule

I have a line feature class which represents a stream network. At a confluence of two river segments, I'm joining the stream segments to the point of intersection via spatial join (one to one join). I ...
1
vote
3answers
493 views

Dissolving while retaining field informations in the same entry instead of multiple entries

I have 1520 covenants. Many covenants have more than 1 VM symbols attached to it, currently showing as rows. EG. Covenant #97 has 4 VM Symbols, with the VM Symbols 1, 67, 117 and 171. How do I change ...
2
votes
1answer
813 views

Spatial Join in Python Field Mapping with Multiple Merge Rules

I'm performing a Spatial Join with a polygon (target) and a point (joinFeature)- which has 5 fields in it that I need to "sum". I have written a Spatial Join and (after many long days) gotten the ...
2
votes
1answer
152 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 ...
2
votes
1answer
15k 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 ...
3
votes
1answer
376 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 names/...
2
votes
1answer
274 views

Arcpy.addTable() error

I am having a little trouble debugging an ex-coworkers code. I am receiving this error: RuntimeError: FieldMappings: Error in adding table to field mappings The code: CIP_FDFC_Tuple = [('...
1
vote
1answer
1k 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
59 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
1k 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 ...
1
vote
1answer
2k 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") ...
1
vote
0answers
436 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 ...
2
votes
2answers
959 views

Limiting available values in dropdown field of QGIS form according to value selected in previous field?

I'm building a rather complex entry form for a layer stored in a PostGIS database. I am following this usage scenario: On several occasions I have dropdown fields which lets the user select a type of ...
0
votes
4answers
280 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 ...