13 reputation
3
bio website nicolamonaca.wordpress.com
location
age
visits member for 1 year, 6 months
seen Mar 13 '13 at 15:07

Feb
18
awarded  Scholar
Feb
18
accepted How to realign (PostGIS) layers in QGIS?
Feb
18
comment How to realign (PostGIS) layers in QGIS?
It worked: goo.gl/fWUa8! :D My gratitude for your invaluable help will never be enough.. thank you mate, my respect.. You've gained a special mention in my next project: Freefall (goo.gl/BTWy8) :)
Feb
18
comment How to realign (PostGIS) layers in QGIS?
If I set "background" CRS to ED50 (both EPSG:4230 and IGNF:ED50G) and project's CRS to WGS84-UTM32 the layer is not displayed, nor zooming to layer extent or hitting "Refresh".
Feb
18
comment How to realign (PostGIS) layers in QGIS?
I'm going to try it right now, but the project's CRS must be set to which CRS?
Feb
18
comment How to realign (PostGIS) layers in QGIS?
I read 539388,5017988, so they're the same. As of the borders, yes, they're stored as Istat codes. I tried both adding a PostGIS layer, and exporting tables as .shp from pgAdmin and then importing them in QGIS, but nothing changes: "background" remains displaced with respect to the other layers..
Feb
17
comment How to realign (PostGIS) layers in QGIS?
So Andre, in my application I have records such as: INSERT INTO Call VALUES(..., ST_buffer(ST_GeomFromEWKT('srid=32632;POINT(538669,5016683)'), ...)); which store positions of calls and messages. As you can see, I set CRS to 32632 because the tables given to me had that CRS set (apart from "background", as I explained above). If I change CRS as you suggested wouldn't I mess things up? Unfortunately I still feel unconfortable within this field. As to the coordinates of a point, Google Maps tells me goo.gl/LN1kW (see address for coords) and it corresponds to QGIS: 539388,5017988
Feb
16
awarded  Student
Feb
16
comment How to realign (PostGIS) layers in QGIS?
The offset is about 220 metres.
Feb
16
revised How to realign (PostGIS) layers in QGIS?
edited body
Feb
16
comment How to realign (PostGIS) layers in QGIS?
Hi Andre, so the 4 layers in the image were given to me. When I imported them via "Add PostGIS Layers" I noticed that "background" layer had SRID set to 0. pgAdmin said the same thing. I fixed this in pgAdmin as it now says 32632 in the QGIS "Add PostGIS Layers" dialog box (just like the other layers), but apparently this did'nt solve anything. When I explore those tables they all contain exadecimal values (no Lat/Lon). I also have other 2 layers representing phone calls and SMSs as points consisting of lan/lon values from tables I created, but I don't think this is the problem. Am I right?
Feb
16
revised How to realign (PostGIS) layers in QGIS?
edited title
Feb
16
awarded  Editor
Feb
16
revised How to realign (PostGIS) layers in QGIS?
deleted 1 characters in body
Feb
16
asked How to realign (PostGIS) layers in QGIS?