2,234 reputation
718
bio website stackoverflow.com
location Barcelona, Catalunya
age 94
visits member for 4 years, 5 months
seen 1 hour ago

We love hats


6h
comment how to Find nearest line for the given point from a collection of lines?
What is your table called that contains the column geom. Do you want to find the nearest point on each line to the given point?
2d
revised How to inverse Y axis
added 7 characters in body
Dec
24
comment GIS technical challanges
@Vince. Good word, trifecta, had to look it up, 1, 2, 3 in horse racing.
Dec
24
answered geometries with different SRIDs errors (even after setting SRID)
Dec
24
comment box2d spatial type
Try using ST_MakeBox2D(ST_MakePoint(x,y), ST_MakePoint(x1,y1)). ST_Collect is pointless in this scenario as you only have two points anyway.
Dec
23
comment PostGIS: Ensure Intersection of 2 Polygons results in a Polygon
That is a slightly different question. The query planner will not recognize that, but you can avoid comparing polygons twice in a spatial self join, answer updated. Agreed, ST_Relate matrices are hard to understand.
Dec
23
revised PostGIS: Ensure Intersection of 2 Polygons results in a Polygon
added 437 characters in body
Dec
23
answered PostGIS: Ensure Intersection of 2 Polygons results in a Polygon
Dec
22
comment Ways of editing Postgis tables from remote desktops (WFS?)
You would be better to edit the question with this information.
Dec
22
comment Is OpenLayers appropriate for creating maps of a fantasy world?
I would say yes to all of them. You can mix any number of layers and zoom levels. OL3 has a somewhat steep learning curve, (compared to Google Maps), but also supports more formats and your own backdrops, but the examples are quickly growing.
Dec
22
comment Ways of editing Postgis tables from remote desktops (WFS?)
@user30184. Anyway, I am a GeoServer person, so I will shut up and go away now. I still think the question could do with some work.
Dec
22
comment Ways of editing Postgis tables from remote desktops (WFS?)
@user30184. OK, fair enough, I guess I should have read the tags, there wasn't much clue in the actual question.
Dec
22
comment PostGIS replace pixel value by lookup table?
Very welcome. It's a crazy looking query, but awesome what you can do with imagery inside the db with Postgis these days. I see you are a Haskell guy -- I just did an edX FP course with Haskell as main language. A very humbling experience.
Dec
21
revised PostGIS replace pixel value by lookup table?
edited body
Dec
21
comment PostGIS replace pixel value by lookup table?
Try casting the inner query that creates the actual expression, '[0-0]:-99999, [1-1]:100', as a reclassexpr rather than text. Again, apologies, I can't test right now.
Dec
21
reviewed Approve Shapes not matching number of records
Dec
21
comment PostGIS replace pixel value by lookup table?
Sorry, there was a typo in the cast, it should be regclassarg, though I'm not sure that will fix it. You are talking about the 2nd query, no, or the first one, with hardcoded reclass values? I don't have a box with raster functions on right now to test, so can't look properly till the morning.
Dec
21
comment Ways of editing Postgis tables from remote desktops (WFS?)
Could you clarify what you mean by a mapfile. What format, for where?
Dec
21
revised PostGIS replace pixel value by lookup table?
edited tags
Dec
21
revised PostGIS replace pixel value by lookup table?
added 610 characters in body