Opened 14 years ago
Closed 14 years ago
#56 closed defect (fixed)
Deprecated EPSG systems cause errors in Oracle access
| Reported by: | Norm Olsen | Owned by: | Norm Olsen |
|---|---|---|---|
| Priority: | minor | Milestone: | |
| Component: | Dictionaries | Version: | |
| Keywords: | NameMapper | Cc: |
Description
There are a dozen or so system definitions which have been deprecated by EPSG, but for which Oracle still supports. Acceessing Oracle data which references these system causes problems in vertical applications.
Note:
See TracTickets
for help on using tickets.
Corrected in revision 1836.
The following systems were omitted/deleted from the NameMapper in an attempt to update the NameMapper to EPSG 6.18. These errors resulted from the fact that EPSG decprecated many of these definitions and then added replacements. Turns out, that while EPSG deprecations tend to disappear, Oracle maintains them in its coordinate system database. Thus, in future, EPSG deprecations will need to be maintained in the NameMapper.
The systems affected by this submission are as follows, the names being Oracle names and the numeric values being Oracle SRID numbers:
Swedish National System (RT 90) - 82202 MGI (Ferro) / Austria West Zone - 31291 MGI (Ferro) / Austria Central Zone - 31292 MGI (Ferro) / Austria East Zone - 31293 MGI / 3-degree Gauss zone 5 - 31265 MGI / 3-degree Gauss zone 6 - 31266 MGI / 3-degree Gauss zone 7 - 31267 MGI / 3-degree Gauss zone 8 - 31268 MGI (Ferro) / Austria West Zone - 31281 MGI (Ferro) / Austria Central Zone - 31282 MGI (Ferro) / Austria East Zone - 31283 NAD83(CSRS98) / UTM zone 21N - 2148 NAD83(CSRS98) / UTM zone 18N - 2149 NAD83(CSRS98) / UTM zone 17N - 2150 NAD83(CSRS98) / UTM zone 13N - 2151 NAD83(CSRS98) / UTM zone 12N - 2152 NAD83(CSRS98) / UTM zone 11N - 2153
Oracle names and SRID numbers are often the same as EPSG, but not always.
No code changes were required, only an update to the NameMapper.csv file.