Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

A polygon I am drawing onto Google Maps is showing up in the wrong location - can you help me understand why?

By
josemi
on 4/14/16, 6:56 AM 294 views

Looking google maps have located 4 points and have created a polygon with them in this way

insert into dummy_zip values (4,'prueba_directa','2016-04-13 08:08:15.973731','prueba_directa',1,1,100,'2016-04-13 08:08:15.973731',(SELECT ST_Transform(ST_GeomFromText('MULTIPOLYGON(((37.986504 -1.121951,37.986741 -1.121243,37.985794 -1.120792,37.985608 -1.121479,37.986504 -1.121951)))',4326),900913)));

but when displayed on the map in a completely different location that should be, because it can be?


0
josemi
On 4/14/16, 10:56 AM

Solved, i'm stupid.  I mistook  longitude and latitude, the correct sentence is

insert into dummy_zip values (4,'prueba_directa','2016-04-13 08:08:15.973731','prueba_directa',1,1,100,'2016-04-13 08:08:15.973731',(SELECT ST_Transform(ST_GeomFromText('MULTIPOLYGON(((-1.121951 37.986504,-1.121243 37.986741,-1.120792 37.985794,-1.121479 37.985608,-1.121951 37.986504)))',4326),900913)));

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 4/14/16, 6:56 AM
Seen: 294 times
Last updated: 4/21/16, 5:13 AM