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
, andAddCode_R
fields in both versions.
-
[PostgreSQL] Fixed domain error in Speed Limit field
-
[PostgreSQL] Added missing
St_PreDir
andSt_PosDir
field missing from the v1.0 RoadCenterlines schema -
[PostgreSQL] Corrected longitude check error from
CHECK ( -90 <= Longitude AND Longitude <= 90 )
toCHECK ( -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 toREAL
to reflect theFLOAT
value defined in NENA-STA-006.2-2022 -
[PostgreSQL] Changed all
TIMESTAMP WITH TIME ZONE
datatypes toTIMESTAMPTZ
which is the proper datatype which is a time zone-aware data and time datatype. PostgreSQL converts theTIMESTAMPTZ
value into a UTC value and stores the UTC value in the table. -
[PostgreSQL] Changed all
CHARACTER VARYING
toVARCHAR
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 aSERIAL
orUUID
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.