This discussion is archived
2 Replies Latest reply: Aug 16, 2013 2:29 AM by don123 RSS

decimal points - geometry - sql developer georapter

don123 Newbie
Currently Being Moderated

Hi

 

I have loaded shape files with SQL developer Georaper and limited number of decimals to 8. There is option to limit number of decimals in georapter.

But there are some X, Y with many decimals. This may create problem in spatial functions in which geometries are compared and filtered.

Please suggest me how to control the decimal points of X,Y to be loaded in geometry column.

 

 

-0.4695623500000000172249770002963487058878                    51.47160360000000167701728059910237789154

-0.4702653600000000211345252409955719485879                    51.47174944999999723904693382792174816132

-0.4713475400000000092859409051015973091125                    51.47330664999999783049133839085698127747

-0.4717886499999999760923685698799090459943                    51.47432505999999818868673173710703849792

-0.4727564499999999947377204989606980234385                    51.47439456000000035373886930756270885468

-0.4710064700000000104118669241870520636439                    51.4703249599999992369703250005841255188

-0.4713933299999999992913046753528760746121                    51.4707325999999980581378622446209192276

-0.4708402500000000157065471739770146086812                    51.46869396999999679565007681958377361298

 

-0.48199913                            51.47069623

-0.48186682                            51.47069561

-0.48186696                            51.47070972

-0.48186738                            51.47073525

-0.48186786                            51.47076416

-0.48204026                            51.47076313

-0.48205911                            51.47077464

-0.44306117                            51.45944246

-0.44311694                            51.45944362

 

regards

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points