Differences between EPSG 4170 and EPSG 4674

[BrunoMendes]

I'm currently creating a spatial database using Oracle Spatial and it lists both EPSG 4170 and EPSG 4674 as SIRGAS for SDO_GEOMETRY type.

The problem is when I try to transform from WGS 84 (EPSG 4326) to SIRGAS. If my table is defined as EPSG 4674, I get an error about different dimensions. If my table is defined as EPSG 4170, the transformation works.

Because of that, all my tables metadata are currently defined as EPSG 4170.

But what are the differences between EPSG 4170 and 4674? Should I expect any displacement by storing data defined as 4674 in 4170 without transforming it?

[NeilAyres · Accepted solution]

According to EPSG..

Wkid 4674 is called SIRGAS2000 (and uses the ITRF200 epoch).

4170 is called SIRGAS1995 (and uses ITRF 1994).

I would say that both are "functionally equivalent" to WGS84.

Unless your data is extraordinarily accurate, I don't think you will see any miss-alignment between them.