search

mattyschell / geodatabase-buildings

Creative Commons Zero v1.0 Universal
2 stars 0 forks source link

Align BIN and BBL data types #60

Open mattyschell opened 6 months ago

mattyschell commented 6 months ago

Currently we have

From the editor perspective BIN is annoyingly strict. When copying and pasting a cell from excel to ArcGIS Pro the invisible line ending CR/LFs get rejected. Editors must click into the excel cell and select the digits to copy.

From the data maintainer perspective the BBL data type is annoyingly loose. We check for disallowed characters in QA instead of enforcing it in the data model.

Consider making the BBL columns numeric, correct, and matching BIN.

Before doing this though research options to allow copy/paste from excel cells. Perhaps there is an arcade function we can apply to the columns? More research required.

mattyschell commented 1 month ago

Also base_bbl and BIN should be exactly 10 and 7 digits respectively. It is easy to type fewer digits and not find out about it until nightly qa.