270 reputation
27
bio website emapsite.com
location Barcelona, Spain
age
visits member for 3 years, 11 months
seen yesterday

I am a data architect specializing in GIS. I am also very interested in NoSQL and machine learning. Mountain biking, running, skiing, travelling, and cooking are my main passions away from the keyboard.


Jul
12
comment Converting file geodatabase with coded domains to PostgreSQL / PostGIS?
Coded domains are the equivalent of constraints in a db?
Jun
9
awarded  Commentator
Jun
8
answered How to limit zoom level in OpenLayers
May
27
awarded  Quorum
May
13
answered Creating simple maps to view on Mobile devices?
May
13
comment How do I transform a raster image to one with rounded corners (cylindrical to pseudocylindrical)?
Wow, a lot of projections there, and I consider myself a projections geek.
May
13
comment How do I transform a raster image to one with rounded corners (cylindrical to pseudocylindrical)?
Sadly that link is down
May
1
awarded  Supporter
Apr
20
comment How to simplify a polygon down to X amount of points?
Are you asking if you can calculate, a priori, if it is possible to derive a relationship between tolerance and percentage point reduction? My understanding of Dougles Peucker is that you would need to essentially run the algorithm to derive this information. An iterative approach in a loop ought to do it.
Jan
26
comment Openlayer is very slow when using WKT Multipolygon with a large number of Points
IE 11 is going to support webGL, so we will be able to get decent GPU-based speed across all browsers.
Jan
26
awarded  Autobiographer
Aug
8
awarded  Yearling
Feb
5
comment Is there a public Web Map Tiling Service (WMTS) available?
Also, I fail to see how restful WMTS is any harder to maintain than XYZ, seeing as both are a direct one-to-one mapping from url to resource?
Feb
5
comment Is there a public Web Map Tiling Service (WMTS) available?
If you implement WMTS with a restful interface, then the resulting urls look exactly like slippy map ones, eg, server/service/style/layer/scale/row/col.png. However, slippy maps forces you to use spherical mercator and fixed zoom levels, which means easier maths and no config, but at a cost of less flexibility. If you want to use a more accurate projected coordinate system, such as one a national mapping agency might use, and you want to define scale levels such as 1:250, 1:500, 1:1250, etc, then WMTS allows this -- sure, XML config is a pain, but you have to define your service somehow.
Feb
5
awarded  Critic
Jan
30
answered Display two layers with OpenLayers at once
Jan
30
comment Display two layers with OpenLayers at once
You probably need to explicity add the proj4js library. OpenLayers only has native support for common formats like 900913. See the example here: openlayers.org/dev/examples/using-proj4js.html Also, see the userguide on the proj4js page to see how it is done. trac.osgeo.org/proj4js
Aug
20
awarded  Enlightened
Aug
20
awarded  Nice Answer
May
9
comment Nearest Neighbor problem in Postgis 2.0 using GIST Index (<-> function)
You can use g1.gid>g2.gid in the where clause, which will reduce the number of distance calculations you have to do. Unfortunately, until the <-> operator works without constants, we won't see much of speed improvement in this kind of query.