Nicklas Avén

6,334 reputation

11121

bio	website	blog.jordogskog.no
	location	Hedmark, Norway
	age
visits	member for	2 years, 7 months
	seen	18 hours ago
stats	profile views	344

	6,334 reputation	bio	website	blog.jordogskog.no	visits	member for	2 years, 7 months
11121 badges		location	Hedmark, Norway		seen	18 hours ago

summary answers questions tags badges favorites bounties reputation activity

430 Actions

suggestions reviews revisions comments badges posts accepts all

May 18	answered	PostGIS - ST_Collect but only include POLYGONs not POINTs?
May 13	comment	javascript WKB to WKT function Btw, you should not use blobs but arraybuffer.
May 13	comment	javascript WKB to WKT function +1 TopoJSON seems very interesting
May 13	answered	javascript WKB to WKT function
Apr 17	awarded	Caucus
Apr 15	answered	How can I make a Postgres/PostGIS ST_Distance_sphere query more efficient?
Apr 8	comment	Storing features in PostGIS and then creating layers using queries As you say it is a common case, but mostly it is just ignored and the redundant information is accepted. That can cause problems when editing with separate polygons, but is much easier to implement and port between different formats and needs.
Apr 6	comment	Storing features in PostGIS and then creating layers using queries If I understand you right, PostGIS topology might be what you are looking for.
Apr 3	comment	How to draw line in leaflet using postGIS road data well, then your question is about how to get the point in the road crossing, right? Then, what is your problem? Is it to find out the coordinates of the road-crossing, or is it how to get that coordinates into the linestring in PostGIS?
Apr 3	comment	How to draw line in leaflet using postGIS road data From your illustration it looks like you don't have any point in the crossing. Then, how can you expect the line to go there?
Apr 2	comment	How to sum values of points inside polygons? A cast will be needed since coalesce outputs text I realize. A link to the postgresql coalesce function .postgresql.org/docs/9.2/static/functions-conditional.html
Apr 2	revised	How to sum values of points inside polygons? added 73 characters in body
Apr 2	answered	How to sum values of points inside polygons?
Mar 28	revised	Measuring distances between simultaneous points edited body
Mar 27	revised	Measuring distances between simultaneous points added 4 characters in body
Mar 27	answered	Measuring distances between simultaneous points
Mar 25	comment	How to create a buffer zone for notification ST_DWithin is a better choise than the combination of intersects and buffer since buffering is a quite expensive operation.
Mar 19	answered	geography_columns and geometry_columns purpose
Mar 18	answered	maximum circle inside an irregular polygon from a random point
Mar 18	comment	How to calculate the “depth” of a linestring using postgis No, it is the key_word geom that should be used.