Name: StreetNameAliasTable

Display Field:

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:

Name : OBJECTID

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: 75, nullable: false, editable: true)
• DateUpdate (type: esriFieldTypeDate, alias: Date Updated, SQL Type: sqlTypeOther, length: 8, nullable: false, 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)
• ASt_NGUID (type: esriFieldTypeString, alias: Alias Street Name Unique ID, SQL Type: sqlTypeOther, length: 254, nullable: false, editable: true)
• RCL_NGUID (type: esriFieldTypeString, alias: Road Centerline NENA Globally Unique ID, SQL Type: sqlTypeOther, length: 254, nullable: false, 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: 9, nullable: true, editable: true, Coded Values: [N: North], [NE: North East], [NW: North West], ... 5 more ...)
• ASt_PreTyp (type: esriFieldTypeString, alias: Alias Street Name Pre Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Access Road: Access Road], [Acres: Acres], [Alcove: Alcove], ... 303 more ...)
• ASt_PreSep (type: esriFieldTypeString, alias: Alias Street Name Pre Type Separator, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [of the: of the], [at: at], [de: de], ... 9 more ...)
• ASt_Name (type: esriFieldTypeString, alias: Alias Street Name, SQL Type: sqlTypeOther, length: 60, nullable: false, editable: true)
• ASt_PosTyp (type: esriFieldTypeString, alias: Alias Street Name Post Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Access Road: Access Road], [Acres: Acres], [Alcove: Alcove], ... 303 more ...)
• ASt_PosDir (type: esriFieldTypeString, alias: Alias Street Name Post Directional, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [N: North], [NE: North East], [NW: North West], ... 5 more ...)
• ASt_PosMod (type: esriFieldTypeString, alias: Alias Street Name Post Modifier, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ALStPreDir (type: esriFieldTypeString, alias: Alias Legacy Street Name Pre Directional, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [E: East], [N: North], [NE: Northeast], ... 5 more ...)
• ALStName (type: esriFieldTypeString, alias: Alias Legacy Street Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• ALStTyp (type: esriFieldTypeString, alias: Alias Legacy Street Name Type, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• ALStPosDir (type: esriFieldTypeString, alias: Alias Legacy Street Name Post Directional, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [E: East], [N: North], [NE: Northeast], ... 5 more ...)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/23/2021 8:48:01 PM

Schema Last Edit Date: 7/23/2021 8:48:01 PM

Data Last Edit Date: 7/23/2021 8:48:01 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat