1,584 reputation
111
bio website atlefren.net
location Trondheim, Norway
age 29
visits member for 1 year, 6 months
seen 13 hours ago
stats profile views 90

Background: masters in Geomatics and ICT from Norwegian University of Science and Technology (2009). Works as a GIS software/web developer. JavaScript and Python ninja, web mapping in OpenLayers and Leaflet. Knowledgeable about PostGIS and Geoserver


13h
comment PostGIS, distance between two users
web mercator is lousy on distance calculations.. Try casting to geography? I think PostGIS tries to find the best possible projection, and then uses web mercator as last possibility
1d
comment How to assign a SQL query to a table attribute?
consider adding more relevant tags. I have no idea what you are talking about here..? A plugin for what?
1d
comment PostgreSQL, find points near points
I guess PostGIS is the way to go here, see for example this (recent) question: gis.stackexchange.com/questions/21903/…
2d
comment How to get a feature that lies closest to a point in openlayers?
Glad to be able to help. Perhaps you could accept my answer then?
2d
comment Trying to display some data in OpenLayers - it's not erroring, just not loading :(
Thank you! I guess it's difficult to give error messages, it should then be based on the fact that you are trying to add features outside of the map bounds. Always check coordinate systems in OpenLayers, it does not do any magic for you (might change in ol3?)
May
21
comment How to create a topologically correct dataset in PostGIS (with GRASS)?
You might want to look at PostGIS topology: postgis.refractions.net/docs/Topology.html as PostGIS in itself has no concept of topology
May
21
comment How to store data for gis system?
Oh, then I am not sure, i guess that if functional indicies does not support aggregate functions then this option is out. Sorry for the noise..
May
15
comment How to calculate the bounding box by a given center and scale in Android?
the only thing you need to know about the projection is its units, OpenLayers uses the OpenLayers.INCHES_PER_UNIT[units] array in Utils.js. web mercator uses meters as unit, which means 39.37 instead of 4374754 to calculate resolution
May
15
comment How to calculate the bounding box by a given center and scale in Android?
Yes, that is correct. As long as your users doesn't expect to use the map in the same fashion as a paper map (i.e measuring on it) any value can be used (and I think most mapping libraries use 72 or 96)
May
15
comment How to calculate the bounding box by a given center and scale in Android?
Android, are you using the Google Maps API or just plain displaying an image? I Would also recommend against using an unprojected coordinate system to display your map, as it will look heavily distorted.
May
15
comment How to calculate the bounding box by a given center and scale in Android?
What projection are your map in? Web Mercator? Or do you display a unprojected map in lat/lon? And the size of your viewport, is that in pixels? Is the scale in piels? Do you use any mapping framework/library that might have a function for this?
May
14
comment Display list of OpenLayers Features which are currently visible on screen
Aha, seems OpenLayers has got guite a few new features lately. I guess my solution is akin to setting boundsOnly to true on onScreen. But either way, you have to somehow loop through all features to check them. Glad to help!
May
31
comment How to use cql_filter in OpenLayers.Control.WMSGetFeatureInfo?
Yes, that's the point. Changes to the CQL of a layer does not automagically reflect themselves to the WMSGetFeatureInfo control. So, you have to apply the new CQL filter to the GetFeatureControl as well
May
31
comment How to check if a point is near or inside polygon?
Have you tried JTS? vividsolutions.com/jts/jtshome.htm
May
30
comment Can I prevent features from being created outside an OpenLayers map?
what this handler does is override the finishGeometry function of the Polygon handler. If the geometry that is drawn is intersecting, it undoes the last point added to the geometry. One major drawback is that this will only trigger on the last point added, and thus only undo this.. So, actually a bad solution. Let me try to rewrite it...
May
29
comment OpenLayers (allOverlays): Vector layer not rendered without raster layer beneath it
You are right (in theory). You could try to add an "empty" layer instead of the raster layer (just initialize it using OpenLayers.Layer())?
May
24
comment What is Spatial Reference System in Laymans Language?
and if you encounter a srid without the authority, you can usually assume its EPSG (this is the case for PostGIS and ogr/gdal at least)
May
23
comment Unselect all layers and clear the legend in Openlayers
What do you mean by "legend". AFAIK OpenLayers have no legend-control. Are you using some kind of framework such as GeoEXT or mapfish?
May
23
comment Geometry contains non-closed polygon: GeoServer output from PostGIS
try a query with ST_IsValidReason: postgis.refractions.net/documentation/manual-1.5/…
May
23
comment Tool For Generating Formula for Projection
have you checked spatialreference.org? a search for AGD84 gives: spatialreference.org/ref/?search=AGD84