topic best method to prevent null attribute values in ArcGIS Pro Questions

best method to prevent null attribute values

joecastellana — Mon, 17 Jun 2024 04:38:46 GMT

Hello all,

We have several feature attributes that require values and are using different methods to enforce population: contingent values, attribute rules, and the "allow null" check box on the attribute itself.

In order to enforce population, what would be the best practice method of the above options? This attribute is not related to other attributes, not a network attribute (we use a utility network model), and not dependant on sub-type.

My initial thought was the simplest method would be to de-select the "null allowed" field on the attribute itself. Any other consequence of that method?

Thanks,

Re: best method to prevent null attribute values

DanPatterson — Mon, 17 Jun 2024 09:10:46 GMT

Have you tried to deselect that property for a field?

I was under the impression that it only works for an empty table

Re: best method to prevent null attribute values

Robert_LeClair — Mon, 17 Jun 2024 21:25:12 GMT

If you're using an Enterprise geodatabase, you can use a NOT NULL constraint on the field(s) of interest. You can learn the SQL code to do this here.

Re: best method to prevent null attribute values

joecastellana — Mon, 17 Jun 2024 23:11:33 GMT

Thanks all, I'll go with a contingent value in this case as we've used that solution on another field so at least it will be consistent.

Re: best method to prevent null attribute values

joecastellana — Mon, 17 Jun 2024 23:13:56 GMT

Im glad Im not the only one thinking this is complicated 😉

Re: best method to prevent null attribute values

joecastellana — Tue, 18 Jun 2024 00:53:31 GMT

Good info there, thanks for sharing.