Hi to all, i am new here and i try to find help. I have a big database with 80000 gps records.
BUT ther are 10000 with dot (50.1234) and 70000 without the dot in the latitude and longtitude, like this 501234.
I have also a map with spartial search and i can also update the records via apex, there is also a updateproces when i change gps data so the location spartial data is updatet when i change the latitude or longtitude.
so now the spartial data (SDO_GEOMETRY) on the map is only viewing the data from the rows with dot.
How can i change this so all data are on the map? Sure i can update the rows manual, 70000 rows i take a lot time hehe.
Update: Latitude and Longtitude are numbers.
This is the update process for the location data:
update sitetb_gps
set location = sdo_geometry(2001,4326,sdo_point_type(longtitude,latitude,null),null,null)
where latitude is not null and
longtitude is not null and
rowid = :P1061_ROWID;
commit;