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

PostgreSQL - RoadCenterline template - PostCode and PostComm Ordering #42

Closed NCT911-DLindsey closed 1 year ago

NCT911-DLindsey commented 1 year ago

Tom,

I'm not sure how relevant this is, but I did notice that PostCode and PostComm were flip-flopped in the code compared to the GIS Data Model. The GIS Data Model shows PostCode_L, PostCode_R, PostComm_L, PostComm_R. The PostgreSQL script shows PostComm_L, PostComm_R, PostCode_L, PostCode_R.

image

https://github.com/NENA911/NG911GISDataModel/blob/986686da9ae68cdcadf9766cd5943f93969fbbf9/postgresql/postgresql_data_model_schema_template.md?plain=1#L462-L465

-- David L.

tomneer commented 1 year ago

Will flip for consistency. Thanks!