Help with projection
We are in the process of adding a SRID number to our geometries. We are using Geomedia as a frontend and am having some issues. when I query a record
SELECT idnum,mslink, MDSYS.SDO_GEOM.SDO_LENGTH(GEOMETRY1, .00005, 'unit=METER')
FROM struc_so where idnum = 13308;
I get a length of 226000.315193743 returned. The length of the record shows as 68.9 meters in GeoMedia. If I multiply the Oracle result by 0.003048 I get the correct length
SELECT idnum,mslink, MDSYS.SDO_GEOM.SDO_LENGTH(GEOMETRY1, .00005)*0.0003048
FROM struc_so where idnum = 13308;
In my GeoMedia coordinate system file we have a Horizontal storage unit defined as 0.0003048 and feel this is throwing my value off, and have not found away to adjust the projection in CS_SRS to correct the horizontal storage unit.
Projection being used:
INSERT INTO mdsys.cs_srs
(
CS_NAME,
SRID,
AUTH_SRID,
AUTH_NAME,
WKTEXT,
CS_BOUNDS
)
VALUES (
'GIS Lambert, Iowa DOT Projection - meters',
1050020,
1050020,
'Iowa DOT',
'PROJCS["GIS Lambert, Iowa DOT Projection - meters", '||
'GEOGCS ["NAD 83 (Continental US)", '||
'DATUM ["NAD 83 (Continental US)", '||
'SPHEROID ["GRS 80", 6378137.000000, 298.257222]], '||
'PRIMEM [ "Greenwich", 0.000000 ], '||
'UNIT ["Decimal Degree", 0.01745329251994330]], '||
'PROJECTION ["Lambert Conformal Conic"], '||
'PARAMETER ["Latitude_Of_Origin", 40.000000], '||
'PARAMETER ["False_Easting", 304800.000000], '||
'PARAMETER ["False_Northing", 0.000000], '||
'PARAMETER ["Standard_Parallel_1", 40.375000], '||
'PARAMETER ["Standard_Parallel_2", 43.625000], '||
'PARAMETER ["Central_Meridian", -93.500000], '||
'UNIT ["Meter", 1.00000000]]',
NULL
);
Any advice/direction would be appreciated.