Hello all
I have used shp2pgsql in this format:
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.
All help is welcome!
Joice
gis=# INSERT INTO bairros (nome,limites) VALUES ('Bom
Pastor',GeomFromText('POLYGON((-51.9907015470433
-29.44012500993,-51.9907671988144 -29.4405196485255,-51.9909107163935
-29.441718130331,-51.9912748526022 -29.443906906351,-51.9915323930046
-29.4459811301083,-51.9921360051866 -29.4497327136819,-51.994032222984
-29.4495198556567,-52.0024234853715
-29.4487925728541,-52.0094338599246
-29.4482044271469,-52.0136318509516
-29.4477954929463,-52.0113612160474
-29.4317011980853,-52.0105432546893
-29.4320754501743,-52.0078621596198
-29.4334709969594,-52.0071017604674
-29.4336792263321,-52.0064625419177 -29.4338745058137,-52.005656059236
-29.4340770558222,-52.0055309128059
-29.4340812857374,-52.0040332587739
-29.4343815363951,-52.0024216283925
-29.4346392557673,-52.0002485811884
-29.4349011645262,-51.9986381435001
-29.4352816189808,-51.9971710380989
-29.4359679459337,-51.9969499734138
-29.4362028344623,-51.9963361038805
-29.4367109236394,-51.9955023657715
-29.4375766859011,-51.9944580687714
-29.4384440065994,-51.9936218988798
-29.4390641872844,-51.9927143588767
-29.4395621052856,-51.9907015470433 -29.44012500993))',4326));
INSERT 0 1
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
