I have lease shapefiles we receive from a company (numerous leases for each county). So for example if I have 3 counties already in an existing geodatabase, those counties for this example are named Harris County, Thomas County, and Johnson County. If the shapefile the company has provided has Johnson and Thomas counties (No Harris County data), I will want to delete all records with Johnson County and Thomas County from the existing geodatabase ... and replace them with the Johnson and Thomas County data from the shapefile. But here's the kicker, I want to keep all existing Harris County leases in the geodatabase. A truncate will not work because I want those existing Harris County leases.
Here's what would happen in a perfect world. Again this is just me dreaming and I'm asking all of you if this dream can be a reality.
Step 1: Get a list of what counties are in the incoming shapefile (Johnson and Thomas)
Step 2: Delete all records in the geodatabase that have a county of Johnson and Thomas
Step 3: Insert the Johnson and Thomas lease data
Step 4: End up with a geodatabase that has Harris (old data) Johnson (new data) and Thomas (new data)
This all sounds simple, but I'm stuck trying to make the idea work inside of a single FME Desktop job.
Any ideas out there on how to successfully do this?
Thanks in advance for any help and/or advice you can provide.
Tony
