

Imagine you had a polygon feature class representing cadastral boundaries (i.e.
#TRYONG TO JON DATA ARCGIS FILE DBLANK HOW TO#
Recently, a couple of my clients asked me how to solve the following problem. You are now ready to prepare the shapefiles for localization.From time to time, even the experienced GIS users (my 17 years in GIS allow me to call myself one) come across hidden tools and workflows that have existed in ArcGIS for Desktop for ages, but have never been used. Select Remove Join(s), then select xxxx_ref_basins. Right-click the basins_all layer and select Joins and Relates. Īfter verifying that the above edits are what you want, Click the Editor button and select Stop Editing.This “yes” flag in the Cust_name field will indicate that the names of these basins have been transferred from the xxxx_ref_basins shapefile. In the box that appears type “yes” in the calculation box. Right-click the basins_all.CUST_NAME field in the table and select Field Calculator. The names from xxxx_ref_basins.STREAMNAME should be copied to the basins_all.STREAMNAME field for the selected basins only. In the Field Calculator box that appears, double-click "xxxx_ref_basins.STREAMNAME" so it appears in the calculation box. Right-click the basins_all.STREAMNAME field in the table and select Field Calculator. This will select only the basins that have a name in xxxx_ref_basins to avoid copying over blank values. “xxxx_ref_basins.STREAMNAME” ‘’ (NOTE: These are two single-quotes after the. In the same Select by Attributes window, change the “Method” to “Selectįrom current selection”. This will select all of the basins that have different names in the old and new basins. “basins_all.STREAMNAME” “xxxx_ref_basins.STREAMNAME”Ĭlick Apply. Double-click the attribute names in the Fields list and the operand buttons to create the following query:

In the Select by Attributes window that appears, make sure the “Method” at the top In the basins_all table, click the Options button and choose Select by Attributes. We will do two queries to select the basins for which names will be transferred: Layer (including its attribute table) in edit mode. In the box that appears, select the basins_all layer to edit and click the Start Editing button.

Choose the field in this layer that the join will be based on: PFAF_IDĢ. What do you want to join to this layer? Join attributes from a tableġ. In the Join Data box that appears, make the following selections: Right-click the basins_all layer again, select Joins and Relates, and then select Join.

Text for the type, and Length of at least 20. In the Table window, click Options and select Add Field. Right-click the basins_all layer and select Open Attribute Table. Use the xxxx_ref_sl shapefile if it contains your customized names).Īdd the two layers (xxxx_ref_basins and basins_all) to the Data Frame. This procedure will result in a direct transfer of all customized stream names to theįor these instructions, we will use the xxxx_ref_basins shapefile (but you could also Shapefile with those you have added or modified in your xxxx_ref_basins or xxxx_ref_sl
#TRYONG TO JON DATA ARCGIS FILE DBLANK UPDATE#
The following steps will allow you to update the stream names in your new basins_all Xxxx_ref_basins or xxxx_ref_sl to basins_all in ArcGIS 9.2 Task A1-b: Transferring basin/stream name attributes from
