-1
votes
1answer
46 views

ST_buffer display creates big circle [closed]

$result = pg_query("SELECT ST_Astext(ST_Buffer(ST_GeomFromText('POINT( 80.7605 7.67833 )'),1))"); ST_buffer display creates big circle..
2
votes
1answer
98 views

Problem with matching a buffer in Openlayers and the same buffer in PostGIS query

I am using a buffer tool to create a buffer on my base map in Openlayers. In addition to creating and visualizing this buffer, I pass the center point and radius to a query. The query collects all ...
3
votes
1answer
171 views

How to create a buffer on a linestring with varying or increasing/decreasing width

I want to buffer rivers/streams for a topographic map. I'm using a PostgreSQL/PostGIS database. Usually, I create buffer with ST_Buffer with a constant width. For example, the width of a river buffer ...
1
vote
1answer
64 views

How to restrict buffer extent within land area only?

I need to create buffer for a point feature, but the buffer area will be restricted within the land area only. For example consider the following: A buffer of say 500 km radius is to be generated ...
0
votes
2answers
333 views

postGIS union multiple tables, big dataset, faster approach?

my goal is simple. I want to union a given set of shapefiles. In the shapefile are stored polygons. The data bounding box is germany, so the data is relatively big. I tried to use all functions ...
2
votes
2answers
152 views

Separate a polygon in different polygons depending of the distance to another polygon

I have a reference polygon "R", and others polygons (in grey). I want to separate each grey polygon in multiple polygons, depending on the distance to R with different Buffers : - The red line is R ...
0
votes
2answers
245 views

How to perform a buffer analysis in PostGIS?

Need to Implement Spatial Analysis in Postgresql. Can Any one guide me to accomplish the spatial analysis eg) 2 km buffer for road network layer.
2
votes
0answers
93 views

Large buffers in PostGIS (5000 km radius)

I have a number of points stored as geographies in PostGIS (version 2.0.1), and I'd like to create rather large buffers around them (with a radius of 5000+ km). However, ST_Buffer doesn't handle this ...
1
vote
1answer
219 views

Buffer along a route

I'm using Googlemaps service to plot some marker on the map. All markers are stored in a postgresql table, named "locations" and that has a location column (data type to geometry). When the user ...
1
vote
1answer
176 views

How do I convert MultiLines to MultiPolygons using Postgis

In postgis I'm using the following query to buffer lines to polygons: UPDATE rivers SET poly = ST_Multi(ST_Buffer(lines, 0.01)) where id = 1; The column 'lines' is a MultiLine and the column ...
2
votes
1answer
93 views

How to create a buffer zone for notification

I am new to PostGIS. I am working on a project, for this i need to find out abutter notification that generates a list of properties within the buffer zone from the selected property with user input ...
7
votes
1answer
430 views

Is there a significantly faster way to buffer than arcmap? [duplicate]

I hope this question is appropriate here and I apologize if it is more of a discussion question than a specific technical problem. I have to buffer 150,000 polygons for a real estate project. While ...
4
votes
2answers
347 views

PostGIS algorithm to unite points of two geometries that are within specified radius

I want to find an PostGIS algorithm to unite points of two geometries that are "near" to each other. That is: I want a function, that takes as input two geometries, and returns 1 geometry, that ...
5
votes
2answers
587 views

memory issue when trying to buffer/union large dataset using postgis

I am trying to generated a dissolved buffer of a large point dataset (Ideally 29 million points - Address data in Great-Britain, but I receive the data by chunks of 1 million points, so these could be ...
7
votes
2answers
786 views

Growing a PostGIS geometry by a percentage

I'm looking for a way to add a buffer around a PostGIS geometry, but the size of the buffer should depend on size of the geometry. That is, I want each geometry to be enlargened by, say, 5%. The idea ...
2
votes
1answer
223 views

Query for segments at same place and time in PostGIS

A newbie-question: I've imported the segments of several GPX-Tracks in a PostGIS-Table. Now I'm looking for a query that returns all segments that: are spatially overlapping (within a specific ...
3
votes
2answers
802 views

Generate non-overlapping shapes from a buffer

I have a collection of points, and I need to generate shapes around these points. Let's assume that these points are locations of offices and that the shapes are the 'area of responsibility' around ...
2
votes
2answers
157 views

After two buffers operations (+/-), why is the result file bigger than the original?

First file ( .shp ) had 1000KB, after 2buffers ( buffers on polygon, 1st buffer +100, 2nd buffer -100 ( small things near polygon should be removed )) in quantum gis file grown to 1500KB, and after ...
5
votes
3answers
2k views

When should I use ST_Buffer?

I would like to know what is the sense of using st_buffer operation. In PostGIS reference guide there is only the syntax and a short description of this operation. Could you give some examples to ...
5
votes
3answers
1k views

How can I display with OpenLayers the geometry returned from a ST_Buffer in POSTGIS?

Im using PostGIS, GeoServer and OpenLayers, and the thing is that i want to display the geometry result from a query like this: SELECT ST_Buffer(ST_GeomFromText('POINT(100 100)'), 500); To perform ...
13
votes
4answers
3k views

How to create one-sided buffers or parallel lines in PostGIS?

I'm looking for a way to create so-called one-sided buffers or parallel lines in PostGIS. Example: 1. buffer, 2. one-side, 3. both-sides I've found some discussion on the mailing list from 2009 and ...