uic-utah / uic-addin

An ArcGIS Pro add-in to help manage, create, and validate the UIC GIS database

MIT License

1 stars 1 forks source link

AOR Validations #31

Closed steveoh closed 5 years ago

steveoh commented 5 years ago

Find AOR Issues,

[x] Find AORs with no Artificial Penetration Record
[x] Find AORs without an Authorization

CanDKD commented 5 years ago

'Find AOR Issues' is not activated under Area of Review Validations. Perhaps you haven't finished with this one yet??

CanDKD commented 5 years ago

Please add another query in the AOR Validation query set: 'Find AORs without an Authorization.'

steveoh commented 5 years ago

@CanDKD would you explain how to determine this AORs with no Artificial Penetration Record? I don't see any relation between the two.

CanDKD commented 5 years ago

I apologize for not explaining this. The UICAreaOfReview tbl has a field NoArtPenDate. This is the date it was determined that there were no artificial penetrations into the permitted injection zone. If this field is not populated there should be at least one UICArtPen well associated with the AOR. Also, remember there is a many to many relationship between UICAreaOfReview and UICArtPen so there isn't an AOR_FK in the UICArtPen record.