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

PostgreSQL - A5 polygon template - Uninc_Cond field is set as Required in script while it is conditional in data model #43

Closed katja-ng911 closed 1 year ago

katja-ng911 commented 1 year ago

Issue: PostgreSQL creates Uninc_Cond field on the A5 polygon as NOT NULL while the data model does not require values.

A5 polygon data model:

image

A5 polygon Esri fgdb script (nulls allowed):

image

A5 polygon PostgreSQL script (nulls not allowed):

image

Recommended action: Make the field nullable in PostgreSQL.

-HT to Hung Giang at the City of Mississauga and Michael Fashoway at Montana State Library for this submission.

tomneer commented 1 year ago

Thank you and confirmed.