search

tilemill-project / tilemill

TileMill is a modern map design studio
https://tilemill-project.github.io/tilemill/
BSD 3-Clause "New" or "Revised" License
3.1k stars 526 forks source link

tilemill add layer from postgis showing wrong vector #2592

Open chanyap92 opened 7 years ago

chanyap92 commented 7 years ago

I am using osm2pgsql to import my pbf data to PostGis using this command osm2pgsql.exe -H localhost -d gis -U postgres -c -G -k -C 1200 -S default.style centro.osm.pdf after that i launch TileMill v0.10.1 and add a new layer using the postgis data i just import. import setting But the map display vector wrongly which the roads should not be like that roadsfailed and i cannot change the SRS setting to WGS84 because of error "out of bound" keep showing up so i use 900913 instead. i had tried several country pbf file and the same problem occured. anyone have a solution for this? thank you very much

pnorman commented 7 years ago

If you look at the database in qgis or another tool, do the geometries look normal?

chanyap92 commented 7 years ago

i look at the rows in planet_osm_roads table here is the data in "way geometry" column 010200002031BF0D0005000000CDCCCCCC4FB3264148E17A1456875541713D0A5746B326413D0AD743568755417B14AE47DA9F2641A4703DFA6484554166666666809F2641D7A3704D68845541295C8FC21F96264185EB51486F835541