search

NENA911 / NG911GISDataModel

GIS Data Model templates based on the NENA Standard for NG9-1-1 GIS Data Model (NENA-STA-006.x)
Apache License 2.0
15 stars 7 forks source link

Country #58

Closed dawnblanchard-DOIT closed 1 year ago

dawnblanchard-DOIT commented 1 year ago

The domain of value is restricted to 2, but when I create a point, I can only chose a country fully spelled out

tomneer commented 1 year ago

The domain value of the Country field is defined in NENA-STA-006.2-2022, Section 5.24 Country explicitly as "its ISO 3166-1 English country alpha-2 code elements". Extending the field length is not compliant with the NENA GIS Standard.

Nothing prevents you internally adjusting the field width, however, the transfer of data between organizations and to the Spatial Interface (SI) requires two characters.

jasonhorning commented 1 year ago

I think what you're seeing Dawn is how Esri presents the value in a table or attribute dialog. You're choosing "United States" as the domain but the actual value being stored is "US". There is a setting to change that in ArcMap.

dawnblanchard-DOIT commented 1 year ago

I put these in for Émilie Tanguay as the reporter for our section. This was her explanation.

I the first image, you can see the values available in the drop menu.

In this image, you can see how it is saved in the DB, which is the full length name, both for Country and State. It should be the shorter abreviation, CA (for Canada) and FL (for Florida) as stated in the DataModel document. Canadian provinces (equivalent to states) will effectively be added 😊

Here you can see that the template imposes me an empty drop menu to select a County. I also cannot modifiy this field manually (enter text).

It has been decided that no domain of value will be imposed in the templates for this field since it would be an enourmous one (1000+), but then it means it should not have a drop menu.

I’ve been able to create and save geometries with the “wrong” values.

Don’t hesitate if you need more info 😊

On Tue, Dec 27, 2022 at 5:22 PM jasonhorning @.***> wrote:

I think what you're seeing Dawn is how Esri presents the value in a table or attribute dialog. You're choosing "United States" as the domain but the actual value being stored is "US". There is a setting to change that in ArcMap.

— Reply to this email directly, view it on GitHub https://github.com/NENA911/NG911GISDataModel/issues/58#issuecomment-1366217291, or unsubscribe https://github.com/notifications/unsubscribe-auth/APGK62KHXPJQVBIBPN7HB6DWPNT3VANCNFSM6AAAAAATKT2G6Q . You are receiving this because you authored the thread.Message ID: @.***>

--

[image: Changing Maryland for the Better]

Dawn Blanchard

GIS Program Manager

Dept of Information Technology

100 Community Place

Crownsville, MD 21032

@.***

410.697.9427 (O)

240.460.9940 (M)

Website | Facebook https://www.facebook.com/MarylandDoIT/ | LinkedIn https://www.linkedin.com/company/15083280

jasonhorning commented 1 year ago

Ok I’ll research that in some more detail.  Thanks!Sent from my iPhoneOn Dec 27, 2022, at 8:29 PM, Dawn Blanchard - DOIT @.***> wrote: I put these in for Émilie Tanguay as the reporter for our section. This was her explanation.

I the first image, you can see the values available in the drop menu.

In this image, you can see how it is saved in the DB, which is the full length name, both for Country and State. It should be the shorter abreviation, CA (for Canada) and FL (for Florida) as stated in the DataModel document. Canadian provinces (equivalent to states) will effectively be added 😊

Here you can see that the template imposes me an empty drop menu to select a County. I also cannot modifiy this field manually (enter text).

It has been decided that no domain of value will be imposed in the templates for this field since it would be an enourmous one (1000+), but then it means it should not have a drop menu.

I’ve been able to create and save geometries with the “wrong” values.

Don’t hesitate if you need more info 😊

On Tue, Dec 27, 2022 at 5:22 PM jasonhorning @.***> wrote:

I think what you're seeing Dawn is how Esri presents the value in a table or attribute dialog. You're choosing "United States" as the domain but the actual value being stored is "US". There is a setting to change that in ArcMap.

— Reply to this email directly, view it on GitHub https://github.com/NENA911/NG911GISDataModel/issues/58#issuecomment-1366217291, or unsubscribe https://github.com/notifications/unsubscribe-auth/APGK62KHXPJQVBIBPN7HB6DWPNT3VANCNFSM6AAAAAATKT2G6Q . You are receiving this because you authored the thread.Message ID: @.***>

--

[image: Changing Maryland for the Better]

Dawn Blanchard

GIS Program Manager

Dept of Information Technology

100 Community Place

Crownsville, MD 21032

@.***

410.697.9427 (O)

240.460.9940 (M)

Website | Facebook https://www.facebook.com/MarylandDoIT/ | LinkedIn https://www.linkedin.com/company/15083280

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: @.***>

tomneer commented 1 year ago

Could you forward the images and also ask if in the Appearance dialog of the attribute table view has the option 'Display coded value domain and subtype descriptions' unchecked?

Thank you.

dawnblanchard-DOIT commented 1 year ago

Sure no problem!

Dawn

On Wed, Dec 28, 2022 at 10:47 AM Tom Neer @.***> wrote:

Could you forward the images and also ask if in the Appearance dialog of the attribute table view has the option 'Display coded value domain and subtype descriptions' unchecked?

Thank you.

— Reply to this email directly, view it on GitHub https://github.com/NENA911/NG911GISDataModel/issues/58#issuecomment-1366747108, or unsubscribe https://github.com/notifications/unsubscribe-auth/APGK62KTGQFSX5ETPUSIZADWPROK7ANCNFSM6AAAAAATKT2G6Q . You are receiving this because you authored the thread.Message ID: @.***>

--

[image: Changing Maryland for the Better]

Dawn Blanchard

GIS Program Manager

Dept of Information Technology

100 Community Place

Crownsville, MD 21032

@.***

410.697.9427 (O)

240.460.9940 (M)

Website | Facebook https://www.facebook.com/MarylandDoIT/ | LinkedIn https://www.linkedin.com/company/15083280

jasonhorning commented 1 year ago

I still haven't seen the screen captures so I'm not certain if the person reporting this issue is using postgresql or the gdb. But here's what I can say... it sounds to me like the person reporting the issue has "Display coded value domain and subtype descriptions" selected in their Table Appearance settings in ArcMap. That would explain the US vs United States values being visible. On the County point... County is a domain, and it's currently empty. So it will be a dropdown pick from Arcmap but the user has to first populate the values in the CountyOrEquivalentA2 domain.