I have had a counties table, which I have used many times. It's sdo_geometry column (polygons) called "GEOMETRY" has an srid of 26916
The Y range is near 4,600,000 and
the X range is near 700,000
select GEOMETRY, polys.geometry.sdo_srid, polys.geometry.sdo_gtype, get_geo_text(geometry) from county polys;
SELECT u.owner, u.table_name, u.column_name, u.srid,
t.sdo_dimname, round(t.sdo_ub,2) UpperLimit, round(t.sdo_lb,2) LowerLimit, t.sdo_tolerance
FROM all_sdo_geom_metadata u, TABLE(u.diminfo) t
where table_name like '%COU%'
ORDER BY 1, 2, 3;
I recently imported a shape file with road segment info (linestring's) into a table called INRIX_SHAP
its Y is near 41 and
x is near 84
select geo, lines.geo.sdo_srid, lines.geo.sdo_gtype, get_geo_text(geo) from INRIX_SHAP lines;
SELECT u.owner, u.table_name, u.column_name, u.srid,
t.sdo_dimname, round(t.sdo_ub,2) UpperLimit, round(t.sdo_lb,2) LowerLimit, t.sdo_tolerance
FROM all_sdo_geom_metadata u, TABLE(u.diminfo) t
where table_name like '%INR%'
ORDER BY 1, 2, 3;
see attached
Needless to say, my overlap/interact queries do NOT show ANY matches.
Both of these are supposed to cover Indiana. I know the county/polygon srid and lat/longs are correct.
Is there a chance the INRIX_SHAP table (with the linestrings) has the wrong SRID?
I welcome thoughts...