1,582 reputation
716
bio website emapsite.com
location Barcelona, Spain
age
visits member for 4 years, 3 months
seen 17 mins 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.


1h
comment OpenLayers and GeoJSON
If you put up a working example in jsfiddle, it might help also.
2h
comment OpenLayers and GeoJSON
Oh, sorry, my Serbo-Croat is a bit rusty :-) If they are the same projection, then there is a different problem.
2h
comment How to split linestrings where start/end points don't touch nearby lines
This looks like a fun problem. Sadly, I don't have time right now, but you might get some ideas from blog.cleverelephant.ca/2008/04/snapping-points-in-postgis.html. This will allow you to find the nearest point on each linestring to the end of another one, which you could then use to extend that linestring till they touch.
3h
comment OpenLayers and GeoJSON
From a quick glance I would say it is projection related, you wms is in 4326 (lat/lon) and your JSON in projected meters, 3765. This is a fairly common issue and can be dealt with by setting a map and display projection and using transform on your JSON to convert it. I am afraid I don't have time to give you a working example, but if you search for transform coordinates in OpenLayers you should find something.
13h
comment How to use shapefile in QGIS on Debian?
ArcReader works on Linux. Yee gads, what blasphemy is this.
13h
comment How to use shapefile in QGIS on Debian?
@AndreJ. Ooh, cool, didn't know that one. Drag n Drop works on Ubuntu with QGIS 2.6 also, I can confirm.
14h
comment PostGis: find distance if closer than X. For huge sets
As @MikeT says. A*B is a cartesian product, you can throw that out without even thinking about it. Buffering will basically involve creating a new feature, for no extra gain, as ST_DWithin already implicitly does this, with less overhead. If in doubt, test, but this one is pretty much a no brainer.
21h
comment Best program or tool for visualising big data sets really fast 10-20 GB data if the users don't know squat about GIS?
I was going to suggest something like MrSID, but OP hasn't stated what format the data are in or how they want to view it as, so hard to give any sensible answer.
21h
revised Delete user on ArcGIS server against Oracle backend
grammar, spelling, formatting.
21h
comment Best program or tool for visualising big data sets really fast 10-20 GB data if the users don't know squat about GIS?
Imagery or vector data? Web or desktop viewer?
22h
suggested suggested edit on Delete user on ArcGIS server against Oracle backend
22h
comment Delete user on ArcGIS server against Oracle backend
This is possibly caused by triggers, see: stackoverflow.com/questions/24901645/…
22h
comment strange result of spatial functions postgis
It would be useful if you could provide an example geometry.
22h
comment Openlayers - zoom specify a sub section of displayed map to zoom on
It is, yes, using a Feature.Vector, you can pretty much draw any shape you like with any opacity and color. I have done something at work with an opaque window, so you can only see part of the map (don't ask) and have also written code to prevent dragging past certain points.
1d
comment Get single layer in OpenLayers 3
doh, never mind. Gets more coffee.
1d
comment GeoServer 2.6 + PostgreSQL 9.3.5, GeoServer becoming unresponsive
Having a like query with leading % essentially means you are doing a full table scan. I'm not quite clear how your query works, it is rather unusual to have a the join table looked up with a like in this way. If you could explain a bit more, there may be a way to make it more efficient.
1d
comment Get single layer in OpenLayers 3
You can probably just do return lyr inside the if, and avoid var layer and return layer? A bit cleaner.
1d
comment Openlayers - zoom specify a sub section of displayed map to zoom on
It is unlikely that anyone will be able to help you without a minimal working code sample.
1d
comment How do I create a local web GIS server using Node.js?
You are welcome. I guess I had better try and find out why the node-js legacy bit is needed at some point.
1d
comment How do I create a local web GIS server using Node.js?
@Conor. Actually, I mentioned nodejs because it is fairly tightly coupled with OL3 and the obvious choice for any Javascript api, imho. Your points are good though, it is lightweight and easy to setup.