I have data which looks like this
I hope to create sdo_geometry's from the lat longs
FYI - Most of our tables use srid 26916 (so I will eventually want to have sdo_geometry's with that srid)
I looked at a few posts in this spatial community, but was not clear as to how.
I saw references to
SDO_CS.TRANSFORM
and other api's such as
SELECT
sdo_geometry(2001, 8307, null, sdo_elem_info_array(1, 2001, 1),
sdo_ordinate_array(52.849497, 5.723975, 52.883151, 5.999025))
FROM DUAL
but still I was not sure what SRID to use to pull in the lat/longs (in screen/image above)
Thank you in advance
ps: My real intent is to make linestrings from the various points/records/rows,
...but for now, I just want a starting point (no pun intended)
pss: I know how to get lat/longs FROM sdo_geometry's but I am not sure of the reverse process.