Thanks Bryan's answers.
Moderator, where is my modified poster?
I included two figures (two links) in the modified poster.
If there are anything that are not allowed in my poster, please let me know.
This is your very participation as a member/user of the OTN forum site.
Every time you modified it, you threw the thread into an examination queue -- all over again -- same as when it first existed when you started it.
Do NOT modify posts that you have made.
When you do that you destroy the original information and people that may be ready to respond will be answering to "nonsense".
ALWAYS add a reply to yourself with whatever information you hope to change and the reason(s) for such change, even if it is to correct a simply typographical error..
Here is my whole story. I posted my first unfinished one in accident.
We have many polyline features of the USA in the format of Shape file.
The Shape files are uploaded to Oracle database and the length of the features are displayed to the Web when required.
The lengths of the features are in decimal degree (Geographic Coordinate System) in default in Shape files,
However, Kilometers (KM) or Miles are required when to be displayed on the Web.
We think that there are two quick ways to convert the decimal degree to miles (if there are other quick ways, please let us know, we appreciate it):
1) Using ESRI ArcMap to re-project the Geographic Coordinate System (GCS) to one of Planar Projection Systems, e.g. UTM, SPCS.
Then, use ArcMap's "Calculate Geometry" function to convert decimal degree to meters in Shape file.
Finally, upload Shape files to Oracle database where the lengths are stored in meters.
The meters are directly used to display the lengths of the features on the Web.
2) Directly uploading Shape files to Oracle database where the lengths are stored in decimal degree.
When the lengths are required to be displayed, using Oracle Spatial (SDO_GEOM.SDO_LENGTH) to calculate the lengths in meters on the fly.
There is another way to calculate the length of any two points in the Earth surface directly based on Haversine Formula.
For deciding which the above ways is the best considering the accuracy and speed,
we firstly compared the accuracy of the Oracle Spatial by comparing with ESRI UTM.
We selected 461 features in Alaska (AK), 1105 features in California (CA), 1227 features in Florida (FL).
Figure 1 shows the accuracy of the lengths compared between Oracle Spatial and ESRI UTM.
We think that the State Plane Coordinate System (SPCS) is the most accurate coordinate system that applied to the whole USA.
Therefore, we take SPCS as a reference. It means that we use the lengths calculated based on ESRI SPCS as a baseline,
we compared the lengths calculated based on ESRI UTM and Oracle Spatial respectively.
Figure 2 shows the comparison results. It looks like that Oracle Spatial provides more accurate lengths than ESRI UTM while taking ESRI SPCS as a reference.
We did not consider the speed yet.
Now, we have below questions:
1) What projection is used in Oracle Spatial, especially for SDO_GEOM.SDO_LENGTH?
2) Does SDO_GEOM.SDO_LENGTH use the same projection as SDO_GEOM.SDO_DISTANCE?
3) Anyone has an experience to use Haversine Formula? What about the accuracy comparing with current available other ways, e.g. Oracle Spatial, UTM, SPCS?
4) Is there any other professional or open source software providing with higher accuracy?
5) From Figure 2, what other conclusions we can get, especially the line of Oracle Spatial to UTM compared with other two lines?
6) What is the difference between Haversine Formula and Geodetic Calculation (after I saw Brian's response)?