Export from SQL and Concatenate two fields to one WHILE converting one of the fields.

AndrewWiegman — Wed, 06 Nov 2024 13:40:44 GMT

I'll start by saying I'm very new to everything "ESRI", so I am learning. My background has been in Network and Server administration for 2 decades and now I'm the GIS Server Administrator for my department.

We are in the process of trying to update our extremely old VB scripts to Python via ModelBuilder.

What the previous script did was
1. Truncate three seperate tables. (one dbf file and two shp files)
2. Import parcel data to the dbf file. (CAMA.dbf)
a. While importing, field names and some data will be changed. One of which is a "StDir" field that takes whatever is in the field and modifies/converts it to only 2 characters. (i.e. AVE to AV, HWY to HY).
b. I then need to take this modified/converted field data and concatenate/join it with another field. (i.e. STName + STType) and put that data in a new field named STName2. The output would be "Main St".
3. Import Polygon data to one of the shp files. (Parcel_Polygons.shp)
4. Create Points from newly imported Parcel_Polygons data. (Parcel_Points.shp)
a. I may reach back out for this item later....

Right now I'm stuck on modifying a table then joining two tables together into a new field in a new GDB file. *I've changed the process because we cannot truncate tables that are not Geodatabases, so instead I converted them to GeoDatabase tables.

Please let me know if there is anything you would like to see that might help, i.e. part of the script or the new modelbuilder I'm working on.

Thank you for any and all assistance you can provide.

topic Export from SQL and Concatenate two fields to one WHILE converting one of the fields. in ModelBuilder Questions

Export from SQL and Concatenate two fields to one WHILE converting one of the fields.