v2.0a

NENA NG9-1-1 GIS Data Model Template v2.0a - 2023-05-07

This release of the NENA NG9-1-1 GIS Data Model Templates is in alignment with NENA's NG9-1-1 Data Model (NENA-STA-006.2a-2023) adopted by NENA DSC on 2023-05-02. There was one minor code change in the PostgreSQL template due to an invalid domain range in the Speed Limit field.

Enhancements

• Migrated GIS Data Model Templates to GitHub.
• [ArcGIS] Added ArcGIS Toolboxes for both ArcGIS Pro and ArcGIS Desktop 10.x
• [ArcGIS] Refactored Python script to operated in multiple versions of ArcGIS Desktop

Updates

• Update layer names, table names, domain names, descriptions, & field names to align with the v2 standard.

• Addressed Items identified in NENA-STA-006.2-2022 Reason for Issue / ReIssue section

  • Redefined “P” field type and changed all “E” field type values to “P” field type in all layers.
  • Changed Discrepancy Agency ID field width from 75 to 100 in all layers.
  • Changed Street Name field width from 60 to 254 in the RoadCenterline layer and the SiteStructureAddressPoint layer.
  • Changed Alias Street Name field width from 60 to 254 in StreetNameAliasTable.
  • Changed field name for Longitude from “Long” to “Longitude” in the SiteStructureAddressPoint layer and CellSectorPoint layer.
  • Changed field name for Latitude from “Lat” to “Latitude” in the SiteStructureAddressPoint layer and CellSectorPoint layer.
  • Changed field name for Elevation from “Elev” to “Elevation” in SiteStructureAddressPoint layer.
  • Changed County Left and County Right field width from 40 to 100 in the RoadCenterLine layer.
  • Changed County field width from 40 to 100 in the SiteStructureAddressPoint layer, the A2-A5 Administrative Unit layers, and the CellSectorPoint layer.
  • Changed field name for primary key NGUIDs to just “NGUID” (i.e., removed “RCL” from RCL_NGUID) in all layers.
  • Changed field name for Site NENA Globally Unique ID (Foreign Key) from “Site_NGUID” to “SSAP_NGUID” in the LandmarkNamePartTable, the LandmarkNameCompleteAliasTable, and the CellSectorPoint layer.
  • Changed field name for Complete Landmark Name Alias NENA Globally Unique ID (Foreign Key) from “ACLMNNGUID” to “CLNA_NGUID” in the LandmarkNamePartTable.
  • Changed field name for Legacy Street Name Type from “LSt_Type” to “LSt_Typ” in the RoadCenterLine layer and the SiteStructureAddressPoint layer.
  • Changed descriptive name “Mile Post” to “Milepost” and changed associated field name “Mile_Post” to “Milepost” in the SiteStructureAddressPoint layer.
  • Changed field name for Rail Line Name from “RLNameE” to “RLName” in the RailroadCenterLine layer.
  • Changed “State” field to Not Required in all service boundary layers.
  • Added “Country” field as a Not Required field to all service boundary layers.
  • Added “Incorporated Municipality” field as a Required field to the A4Polygon layer.
  • Removed Alias Legacy Street Name Pre Directional field, Alias Legacy Street Name field, Alias Legacy Street Name Type field, and Alias Legacy Street Name Post Directional field from the StreetNameAliasTable.
  • Made many changes to the descriptive names, the field names, and the M/C/O categorization in the LocationMarkerPoint layer (previously named Mile Marker Location). Also added the Location Marker Label field as a Conditional field.
  • Changed descriptive name “ZIP Plus 4” to “Postal Code Extension” and changed associated field name “Post_Code4” to “PostCodeEx” in the SiteStructureAddressPoint layer.

• Update domain values based on current registry / source values.

  • Updated StreetNamePreTypesAndStreetNamePostTypes domain
  • Updated StreetNamePreTypeSeparators domain
  • Updated Alias Street Name Pre/Post Directional domains (added French values)
  • Updated Street Name Pre/Post Directional domains (added French values)
  • Updated Road Class domain
  • Updated PlaceType domain (intentionally left vehicles out of the domain)
  • Updated ServiceURN domain
  • Update administrative area (state, county, etc.) domain names to include Canadian equivalents.
  • Increase Street Name Pre and Post Directionals (not Legacy Directionals) to 10 characters to support new French domain values.
  • Increased "RoadClass" to 24 characters to support new domain values
  • Removed Legacy Street Name Type Domain and association with fields
  • Updated "PropertyAccess" domain value (from "Property Access")
  • Increase length of ServiceURN to 55 characters to support URN registry entries.
  • Removed the 'AdditionalCodes' domain requirement for AddCode, AddCode_L, and AddCode_R fields in both versions.

• [PostgreSQL] Fixed domain error in Speed Limit field

• [PostgreSQL] Added missing St_PreDir and St_PosDir field missing from the v1.0 RoadCenterlines schema

• [PostgreSQL] Corrected longitude check error from CHECK ( -90 <= Longitude AND Longitude <= 90 ) to CHECK ( -180 <= Longitude AND Longitude <= 180 ) in multiple tables.

• [PostgreSQL] Changed domain and reference tables to follow NENA table and field naming conventions

• [PostgreSQL] Reordered fields in schema to the same order as GIS Data Model documentation for ease of quality assurance and control.

• [PostgreSQL] Changed all DOUBLE PRECISION datatypes to REAL to reflect the FLOAT value defined in NENA-STA-006.2-2022

• [PostgreSQL] Changed all TIMESTAMP WITH TIME ZONE datatypes to TIMESTAMPTZ which is the proper datatype which is a time zone-aware data and time datatype. PostgreSQL converts the TIMESTAMPTZ value into a UTC value and stores the UTC value in the table.

• [PostgreSQL] Changed all CHARACTER VARYING to VARCHAR which is the more common alias.

• [PostgreSQL] Added id field otherwise editing is slow and open to error. Not part of the standard but it best practice to have a SERIAL or UUID as the Primary Key. The NGUID could fulfill this requirement but it would require creating a TRIGGER.

• [PostgreSQL] Changed 'POLYGON' geometry datatypes to 'MULTIPOLYGON'.

Issues

Found a bug or want to suggest an enhancement? Check out previously logged Issues. If you don't see what you're looking for, feel free to submit a new issue.

v2.0

NENA NG9-1-1 GIS Data Model Template v2.0 - 2023-03-21

This release of the NENA NG9-1-1 GIS Data Model Templates are based on NENA's NG9-1-1 Data Model (NENA-STA-006.2-2022). This release includes errata changes to NENA-STA-006.2-2022 to be adopted as NENA-STA-006.2a-2023.

Enhancements

• Migrated GIS Data Model Templates to GitHub.
• [ArcGIS] Added ArcGIS Toolboxes for both ArcGIS Pro and ArcGIS Desktop 10.x
• [ArcGIS] Refactored Python script to operated in multiple versions of ArcGIS Desktop

Updates

• Update layer names, table names, domain names, descriptions, & field names to align with the v2 standard.

• Addressed Items identified in NENA-STA-006.2-2022 Reason for Issue / ReIssue section

  • Redefined “P” field type and changed all “E” field type values to “P” field type in all layers.
  • Changed Discrepancy Agency ID field width from 75 to 100 in all layers.
  • Changed Street Name field width from 60 to 254 in the RoadCenterline layer and the SiteStructureAddressPoint layer.
  • Changed Alias Street Name field width from 60 to 254 in StreetNameAliasTable.
  • Changed field name for Longitude from “Long” to “Longitude” in the SiteStructureAddressPoint layer and CellSectorPoint layer.
  • Changed field name for Latitude from “Lat” to “Latitude” in the SiteStructureAddressPoint layer and CellSectorPoint layer.
  • Changed field name for Elevation from “Elev” to “Elevation” in SiteStructureAddressPoint layer.
  • Changed County Left and County Right field width from 40 to 100 in the RoadCenterLine layer.
  • Changed County field width from 40 to 100 in the SiteStructureAddressPoint layer, the A2-A5 Administrative Unit layers, and the CellSectorPoint layer.
  • Changed field name for primary key NGUIDs to just “NGUID” (i.e., removed “RCL” from RCL_NGUID) in all layers.
  • Changed field name for Site NENA Globally Unique ID (Foreign Key) from “Site_NGUID” to “SSAP_NGUID” in the LandmarkNamePartTable, the LandmarkNameCompleteAliasTable, and the CellSectorPoint layer.
  • Changed field name for Complete Landmark Name Alias NENA Globally Unique ID (Foreign Key) from “ACLMNNGUID” to “CLNA_NGUID” in the LandmarkNamePartTable.
  • Changed field name for Legacy Street Name Type from “LSt_Type” to “LSt_Typ” in the RoadCenterLine layer and the SiteStructureAddressPoint layer.
  • Changed descriptive name “Mile Post” to “Milepost” and changed associated field name “Mile_Post” to “Milepost” in the SiteStructureAddressPoint layer.
  • Changed field name for Rail Line Name from “RLNameE” to “RLName” in the RailroadCenterLine layer.
  • Changed “State” field to Not Required in all service boundary layers.
  • Added “Country” field as a Not Required field to all service boundary layers.
  • Added “Incorporated Municipality” field as a Required field to the A4Polygon layer.
  • Removed Alias Legacy Street Name Pre Directional field, Alias Legacy Street Name field, Alias Legacy Street Name Type field, and Alias Legacy Street Name Post Directional field from the StreetNameAliasTable.
  • Made many changes to the descriptive names, the field names, and the M/C/O categorization in the LocationMarkerPoint layer (previously named Mile Marker Location). Also added the Location Marker Label field as a Conditional field.
  • Changed descriptive name “ZIP Plus 4” to “Postal Code Extension” and changed associated field name “Post_Code4” to “PostCodeEx” in the SiteStructureAddressPoint layer.

• Update domain values based on current registry / source values.

  • Updated StreetNamePreTypesAndStreetNamePostTypes domain
  • Updated StreetNamePreTypeSeparators domain
  • Updated Alias Street Name Pre/Post Directional domains (added French values)
  • Updated Street Name Pre/Post Directional domains (added French values)
  • Updated Road Class domain
  • Updated PlaceType domain (intentionally left vehicles out of the domain)
  • Updated ServiceURN domain
  • Update administrative area (state, county, etc.) domain names to include Canadian equivalents.
  • Increase Street Name Pre and Post Directionals (not Legacy Directionals) to 10 characters to support new French domain values.
  • Increased "RoadClass" to 24 characters to support new domain values
  • Removed Legacy Street Name Type Domain and association with fields
  • Updated "PropertyAccess" domain value (from "Property Access")
  • Increase length of ServiceURN to 55 characters to support URN registry entries.
  • Removed the 'AdditionalCodes' domain requirement for AddCode, AddCode_L, and AddCode_R fields in both versions.

• [PostgreSQL] Added missing St_PreDir and St_PosDir field missing from the v1.0 RoadCenterlines schema

• [PostgreSQL] Corrected longitude check error from CHECK ( -90 <= Longitude AND Longitude <= 90 ) to CHECK ( -180 <= Longitude AND Longitude <= 180 ) in multiple tables.

• [PostgreSQL] Changed domain and reference tables to follow NENA table and field naming conventions

• [PostgreSQL] Reordered fields in schema to the same order as GIS Data Model documentation for ease of quality assurance and control.

• [PostgreSQL] Changed all DOUBLE PRECISION datatypes to REAL to reflect the FLOAT value defined in NENA-STA-006.2-2022

• [PostgreSQL] Changed all TIMESTAMP WITH TIME ZONE datatypes to TIMESTAMPTZ which is the proper datatype which is a time zone-aware data and time datatype. PostgreSQL converts the TIMESTAMPTZ value into a UTC value and stores the UTC value in the table.

• [PostgreSQL] Changed all CHARACTER VARYING to VARCHAR which is the more common alias.

• [PostgreSQL] Added id field otherwise editing is slow and open to error. Not part of the standard but it best practice to have a SERIAL or UUID as the Primary Key. The NGUID could fulfill this requirement but it would require creating a TRIGGER.

• [PostgreSQL] Changed 'POLYGON' geometry datatypes to 'MULTIPOLYGON'.

Issues

Found a bug or want to suggest an enhancement? Check out previously logged Issues. If you don't see what you're looking for, feel free to submit a new issue.

v1.0

This release is a direct import of the NG911_GIS_TEMPLATE_FILES_20200521 from NG9-1-1 GIS Data Model. It was used as the initial baseline for this repository.

These GIS Data Model Templates are based on NENA's NG9-1-1 GIS Data Model NENA-STA-006.1.1-2020.