Oracle NAD27 to NAD83

This tools allows you to convert the coordinates stored within Latitude/Longitude fields in Oracle from NAD27 to NAD83.

Usage Tips

Only works with Oracle tables.

Command line syntax

oracle_nad27to83 <table> <user_ID> <password> <instance> <lat_degrees_field> {lat_minutes_field} {lat_seconds_field} <long_degrees_field> {long_minutes_field} {long_seconds_field} <output_lat_field> <output_long_field> {temp_workspace}

Parameters

Expression Explanation
<table>

The Oracle table that contains the lat/long fields to be converted from NAD27 to NAD83.

  • Enter the name in this format: "Database Connections/<connection_name>.odc/<owner>.<table>"
<user_ID>

A valid User ID for connecting to Oracle.
<password>

A valid password for connecting to Oracle.
<instance>

The Oracle instance that contains the <table>.
<lat_degrees_field>

The field of the <table> that contains the input degrees (or decimal degrees) of latitude, using NAD27 coordinates.
{lat_minutes_field}

The field of the <table> that contains the input minutes of latitude, using NAD27 coordinates.

  • Do not enter a field if the <lat degrees field> is in decimal degrees.
{lat_seconds_field}

The field of the <table> that contains the input seconds of latitude, using NAD27 coordinates.

  • Do not enter a field if the <lat degrees field> is in decimal degrees.
<long_degrees_field>

The field of the <table> that contains the input degrees (or decimal degrees) of longitude, using NAD27 coordinates.
{long_minutes_field}

The field of the <table> that contains the input minutes of longitude, using NAD27 coordinates.

  • Do not enter a field if the <long degrees field> is in decimal degrees.
{long_seconds_field}

The field of the <table> that contains the input seconds of longitude, using NAD27 coordinates.

  • Do not enter a field if the <long degrees field> is in decimal degrees.
<output_lat_field>

The field of the <table> that is to contain the output latitude (in decimal degrees), using NAD83 coordinates.
<output_long_field>

The field of the <table> that is to contain the output longitude (in decimal degrees), using NAD83 coordinates.
{temp_workspace}

The path to a workspace to be used for temporary files.

  • By default the directory specified by the TMP environment variable is used.

Command Line Example 

oracle_nad27to83 "Database Connections\dv.odc\DHATFIELD.FRED" dhatfield fido idb.dv.r5 lat_degrees lat_minutes lat_seconds long_degrees long_minutes long_seconds latd longd c:/docume~1/dchatfie/mydocu~1/lei
Executing (oracle_nad27to83_2): oracle_nad27to83 "Database Connections\dv.odc\DHATFIELD.FRED" dhatfield hatsize9 idb.dv.r5 lat_degrees lat_minutes lat_seconds long_degrees long_minutes long_seconds latd longd "C:\Documents and Settings\dchatfie\My Documents\lei"
Start Time: Wed Jan 04 18:43:48 2006
Running script oracle_nad27to83...
Wed Jan 04 18:44:01 2006 - converting to DD...
Wed Jan 04 18:44:01 2006 - creating XY events...
Wed Jan 04 18:44:08 2006 - reprojecting...
Wed Jan 04 18:44:15 2006 - exporting XY data...
Wed Jan 04 18:44:27 2006 - misc...
Wed Jan 04 18:44:27 2006 - loading back into Oracle...
Wed Jan 04 18:44:31 2006 - transferring back into original table...
Wed Jan 04 18:44:36 2006 - Done!
Completed script oracle_nad27to83...
Executed (oracle_nad27to83_2) successfully.
End Time: Wed Jan 04 18:44:36 2006 (Elapsed Time: 48.00 secs)

Scripting syntax

oracle_nad27to83 (table, user_ID, password, instance, lat_degrees_field, lat_minutes_field, lat_seconds_field, long_degrees_field, long_minutes_field, long_seconds_field, output_lat_field, output_long_field, temp_workspace)

Parameters

Expression Explanation
table (Required)

The Oracle table that contains the lat/long fields to be converted from NAD27 to NAD83.

  • Enter the name in this format: "Database Connections/<connection_name>.odc/<owner>.<table>"
user ID (Required)

A valid User ID for connecting to Oracle.
password (Required)

A valid password for connecting to Oracle.
instance (Required)

The Oracle instance that contains the <table>.
lat degrees field (Required)

The field of the <table> that contains the input degrees (or decimal degrees) of latitude, using NAD27 coordinates.
lat minutes field (Optional)

The field of the <table> that contains the input minutes of latitude, using NAD27 coordinates.

  • Do not enter a field if the <lat degrees field> is in decimal degrees.
lat seconds field (Optional)

The field of the <table> that contains the input seconds of latitude, using NAD27 coordinates.

  • Do not enter a field if the <lat degrees field> is in decimal degrees.
long degrees field (Required)

The field of the <table> that contains the input degrees (or decimal degrees) of longitude, using NAD27 coordinates.
long minutes field (Optional)

The field of the <table> that contains the input minutes of longitude, using NAD27 coordinates.

  • Do not enter a field if the <long degrees field> is in decimal degrees.
long seconds field (Optional)

The field of the <table> that contains the input seconds of longitude, using NAD27 coordinates.

  • Do not enter a field if the <long degrees field> is in decimal degrees.
output lat field (Required)

The field of the <table> that is to contain the output latitude (in decimal degrees), using NAD83 coordinates.
output long field (Required)

The field of the <table> that is to contain the output longitude (in decimal degrees), using NAD83 coordinates.
temp workspace (Optional)

The path to a workspace to be used for temporary files.

  • By default the directory specified by the TMP environment variable is used.

Script Example 

import oracle_nad27to83
oracle_nad27to83.main("Database Connections\dv.odc\DHATFIELD.FRED", "dhatfield", "fido", "idb.dv.r5", \
"lat_degrees", "lat_minutes", "lat_seconds", "long_degrees", "long_minutes", "long_seconds", "latd", \
"longd", "c:\docume~1\dchatfie\mydocu~1\lei")