245 reputation
24
bio website emapsite.com
location Barcelona, Spain
age 48
visits member for 3 years, 8 months
seen Apr 4 at 14:54

I am a data architect specializing in GIS. I am also very interested in NoSQL and machine learning.


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.
Aug
3
comment How can I convert an excel file with x, y columns to a shapefile?
I suppose you could write something in excel vba to rearrange your columns first so that date, x, y were always the first 3 columns. Without some kind of column naming conventions, I think it would be difficult to completely automate what you have in mind, though.
Aug
2
awarded  Teacher
Aug
2
answered ArcGIS Buffer/Dissolve performance
Aug
2
answered How can I convert an excel file with x, y columns to a shapefile?