1,065 reputation
714
bio website emapsite.com
location Barcelona, Spain
age
visits member for 4 years, 2 months
seen 6 hours ago

I am a data architect (well I wrestle with large amounts of data and long running queries) specializing in GIS. I am also very interested in NoSQL and machine learning. Mountain biking, the taller the mountain the better, keeps me sane otherwise.


6h
comment Add Google Maps Layer to OpenLayers Page
Looks like you are importing google maps api, which you don't need, and not open layers, which you do
13h
comment openlayers display Control.MousePosition on div.olMap
That is the default behavior -- that it sits above and inside map div. Perhaps you could post a jsfiddle or similar.
16h
comment openlayers display Control.MousePosition on div.olMap
Can you not just override the css from olControlMousePosition and the associated control?
1d
comment Openlayers popup for markers issue
This is why it is usually a good idea to post a minimal working example :D
1d
comment Most efficient way to intersect overlapping polylines
You can run ST_Union in Postgis on Lines too. I don't completely understand your problem description, but when I have insanely complex intersection problems (millions of polygons against millions of polygons), I usually break it down into smaller chunks -- divide and conquer style that you learn in algorithms classes -- and then merge the results afterwards. This involves writing plpgsql (my language of choice) functions, but you could do the same in shapely, I'm sure. I have got orders of magnitude performance boosts over a straight intersection/union with spatial join approach.
1d
comment calling gdal_merge.py into another python script running GDAL processes
I think you can do all three in one line, but I have never tried. The order or operations presumably matters -- if you are clipping to input or reprojected srid. Think you'll have to test that.
1d
revised Order of polygon vertices in general GIS: clockwise or counterclockwise
added 164 characters in body
1d
comment Order of polygon vertices in general GIS: clockwise or counterclockwise
Also a nice answer. +1 for it's a wild world :-)
1d
comment Order of polygon vertices in general GIS: clockwise or counterclockwise
Yes, this is true of WKT for geometries too. For geographies it clearly matters more.
1d
revised Order of polygon vertices in general GIS: clockwise or counterclockwise
added 136 characters in body
1d
answered Order of polygon vertices in general GIS: clockwise or counterclockwise
1d
comment Openlayers popup for markers issue
What happens if you remove the mouseout listener, as a matter of interest?
1d
comment Using QGIS and PostGIS for multi-user capabilities, similar to ArcSDE for ArcGIS
postgresql.org/docs/8.1/static/user-manag.html will help get you started.
1d
comment calling gdal_merge.py into another python script running GDAL processes
gdalwarp input_tiles output_tile will definitely mosaic tiles and you could call it using subprocess also. Unfortunately, we just had a power cut at work and my laptop battery is a bit low, so can't do any testing :(
1d
comment What options are there for geolocation-aware SQL databses?
@Vince. Yes, I also wrote a post about NoSQL options, but the available functions are still some way away from Postgis, SQL Server, Oracle, etc.
1d
comment calling gdal_merge.py into another python script running GDAL processes
Are you in a position to use gdalwarp instead (depends what you are doing, I guess, but often recommended over gdal_merge). If so, you could use the suprocess module as it is C and not Python. Look particularly at Popen.
1d
awarded  Enthusiast
2d
comment What options are there for geolocation-aware SQL databses?
There is a question on Stack Overflow that deals with this -- note shameless plug for my own (very) long answer there :D If you feel a bit of TL;DR there, I recommend Postgis in the end -- Postgres is amazingly fully featured and stable and Postgis has far more functions than MySQL/Maria, MongoDB, CouchDB. Sqlite is OK for smaller projects too as HeyOverThere has said.
2d
comment Postgis - Split linestring between point A and B
It isn't very clear how you generate the linestrings from min/max time. What Postgis function are you using?
2d
revised calling gdal_merge.py into another python script running GDAL processes
deleted 2 characters in body