171 reputation
6
bio website evaneos.com
location
age
visits member for 1 year, 9 months
seen Jan 7 at 21:04

Feb
19
awarded  Nice Answer
Jan
22
awarded  Self-Learner
Jan
21
answered How to add topology to PostGIS 2.0?
Jan
21
asked How to add topology to PostGIS 2.0?
Aug
27
awarded  Teacher
Aug
27
answered small difference in projection between tilemill and postgis
Aug
27
comment small difference in projection between tilemill and postgis
... I'm really sorry, The background image didn't have the bounds I thought... so the command is working well and the image is perfekt. As often the bug wasn't in complex things :s Thanks for you help.
Aug
27
comment small difference in projection between tilemill and postgis
Thanks for your answer. I'd like to have interaction with the SVG created. I don't think Tilemill manage that. I'm using Raphaeljs to manage the interaction (mouseover, click...). The objective is to have SVG in pixel. So yes, st_scale and st_translate change coordinates but normally, it doesn't change the "projection"... (I removed st_simplify of the request in the question to make it shorter. but yes in the final query, I'll add it.)
Aug
26
comment small difference in projection between tilemill and postgis
Ok I added those information in the question. st_scale doesn't seem to do anything else than multiplying all the data. I don't see an easy solution to show data on a web browser without scaling it before. (scaling a svg with such big numbers doesn't work). I'll try tomorrow with only some points... but I don't have any idea from the source of this problem...
Aug
26
awarded  Editor
Aug
26
revised small difference in projection between tilemill and postgis
added 280 characters in body
Aug
26
comment small difference in projection between tilemill and postgis
Thanks for your answer. I'm using the same data for Tilemill and the svg. I added in the tilemill project the example of tilemill there is no problem of projection. In the layer in tilemill I'm using 900913. st_srid give me 3857 in Postgis which seems ok? I'm a beginner in SIG... Is there something else I should check?
Aug
26
asked small difference in projection between tilemill and postgis
Aug
26
awarded  Scholar
Aug
26
accepted PostGis, export Svg in pixels
Aug
26
answered PostGis, export Svg in pixels
Aug
26
comment PostGis, export Svg in pixels
I finally manage to do that with st_scale and st_translate. Thanks for your help.
Aug
26
comment PostGis, export Svg in pixels
Sorry I was not clear, I needed svg to manage interaction in javascript.
Jul
5
awarded  Student
Jul
5
asked PostGis, export Svg in pixels