On Oct 28, 11:40 am, Joice <[EMAIL PROTECTED]> wrote:
>
> shp2pgsql file.shp file.sql -w
>
> to get the coordinates for my city neighbourhoods. The inserts looks
> like this below. My question: is there an easy (automatic) way to
> switch the coordinates for these points? Instead of Lng Lat I would
> like to have Lat Lng.
>
> gis=# INSERT INTO bairros (nome,limites) VALUES ('Bom
> Pastor',GeomFromText('POLYGON(
> (-51.9907015470433 -29.44012500993,
> -51.9907671988144 -29.4405196485255...
But the Polygon geometric data type takes points defined as (x,y) --
which I would take to be longitude,latitude. It won't work the other
way round, which is why shp2pgsql produces that output. (I take it you
are in Lajeado, Brazil?)
Perhaps you could elaborate on what you *actually* want to do with the
data?
Andrew
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Maps API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Google-Maps-API?hl=en
-~----------~----~----~----~------~----~------~--~---
