topic Re: Auto-populate field in Geoprocessing Questions

Auto-populate field

TomPiggott — Wed, 29 May 2019 10:20:53 GMT

Hi,

I am doing a project were I am taking all the survey data for archaeology found in an area and trying to make it into a simple user format to show people.

(Ive pulled all the survey from a CAD drawing so excuse some of the field names). I want to take the data in the layer column and refine it. the layer column is based on the data given to the archaeology (i.e bronze age, medieval) but there are over 30 variations in the name.

so as an example. I wanted to take all the variations of the spelling of medieval(_med, _m, med, MED) in the layer column and refine them just to medieval in the 'date_refined' column. I have over 30,000 entries and didn't want to do it by hand.

I have some very basic python knowledge - could this be achieved by an else if statement? if so what would it look like?

Thanks

Tom

Re: Auto-populate field

Egge-Jan_Pollé — Wed, 29 May 2019 11:28:25 GMT

Hi Tom Piggott‌,

Workflow (manual process):

Select records WHERE "Layer" IN ('_med',' _m',' med','MED')
Use Field Calculator to update field "Date_Refined" with value 'medieval' (only selected records will be affected)
Change selection and update (using Field Calculator) with other value
Repeat until all records have a value for "Date_Refined"

Does this work for you?

Egge-Jan

Re: Auto-populate field

TomPiggott — Fri, 31 May 2019 07:51:02 GMT

Hi thanks for sending this through, it works by selecting the required fields.

what should i bet putting in the field calculator.

[Date_Refined] = "Medieval" ???

Re: Auto-populate field

Egge-Jan_Pollé — Fri, 31 May 2019 09:18:23 GMT

Hi Tom,

Yes, [Date_Refined] = "Medieval". Did you try that already? If it doesn't work, it should be 'Medieval'. (I always forget whether it should be single or double quotes.)

The Field Calculator only affects the selected records (unless there is no selection; in that case all records will be updated).

Please let me know how you are proceeding. If you think your issue is solved, don't forget to mark the question as being answered.

Cheers,

Egge-Jan

Re: Auto-populate field

TomPiggott — Mon, 03 Jun 2019 07:32:32 GMT

Thanks Egge-Jan I got it to work after changing the quotes

Thanks

Tom