Convert Hydraulic Conductivity (k) from a Text field to a number field

[LolandaE]

As a (User Type/Persona) I want the hydraulic conductivity field to only display numbers so that the data is in the correct format and useful.

Additional Context

• The Hydraulic Conductivity field is current a text field. It should be fixed to be a numbers field.

• There are 323 records with entries that were all checked to ensure they are numbers, and no text fields.

• The remaining records are all blank.

• Values range between 0.22 to 0.000000016 --> but for m/s the value could be as low as 10^-12, so i think 12 values behind the decimal make sense

• So maybe Number (1,12) for the spatial layer? is that feasible?

• Relates to https://apps.nrs.gov.bc.ca/int/jira/browse/WATER-2007

Team Review Comments

• Need to find out where to find this field. it is an external data point, its something that is done on particular wells, often it comes from an environmental consultant running a test
• SO to confirm where this data is kept and entered

Acceptance Criteria

• [ ] Given (Context), When (action carried out), Then (expected outcome)
• [ ] Given (Context), When (action carried out), Then (expected outcome)

[QSu-2023]

This ticket can be closed (not needed) IF this refers to the field of column CZ "hydraulic_conductivity_m/s" (Well Search page - Download all wells - "well" tab). It is retired and has been replaced with column I "hydraulic_conductivity_m/s" (Well Search page - Download all wells - "pt_aquifer_parameters" tab).