Name: StreetNameAliasTable
Display Field: ASt_Name
Type: Table
Description:
Copyright Text:
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- DiscrpAgID (type: esriFieldTypeString, alias: Discrepancy Agency ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- DateUpdate (type: esriFieldTypeDate, alias: Date Updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Effective (type: esriFieldTypeDate, alias: Effective Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Expire (type: esriFieldTypeDate, alias: Expiration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- NGUID (type: esriFieldTypeString, alias: NENA Globally Unique ID (Primary Key), SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- RCL_NGUID (type: esriFieldTypeString, alias: Road Centerline NENA Globally Unique ID (Foreign Key), SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- ASt_PreMod (type: esriFieldTypeString, alias: Alias Street Name Pre Modifier, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- ASt_PreDir (type: esriFieldTypeString, alias: Alias Street Name Pre Directional, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [East: East], [Est: Est], [Nord: Nord], ... 13 more ...)
- ASt_PreTyp (type: esriFieldTypeString, alias: Alias Street Name Pre Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Abbey: Abbey], [Access Road: Access Road], [Acres: Acres], ... 370 more ...)
- ASt_PreSep (type: esriFieldTypeString, alias: Alias Street Name Pre Type Separator, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [at: at], [de: de], [de la: de la], ... 9 more ...)
- ASt_Name (type: esriFieldTypeString, alias: Alias Street Name, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- ASt_PosTyp (type: esriFieldTypeString, alias: Alias Street Name Post Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Abbey: Abbey], [Access Road: Access Road], [Acres: Acres], ... 370 more ...)
- ASt_PosDir (type: esriFieldTypeString, alias: Alias Street Name Post Directional, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [East: East], [Est: Est], [Nord: Nord], ... 13 more ...)
- ASt_PosMod (type: esriFieldTypeString, alias: Alias Street Name Post Modifier, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
Templates:
Name: StreetNameAliasTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 3/4/2026 8:40:40 PM
Schema Last Edit Date: 3/4/2026 8:40:40 PM
Data Last Edit Date: 3/4/2026 8:40:40 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat