Vjylku

Free fall ellipse or parabola?

Shortening a title without changing its meaning

pgfplots: How to draw a tangent graph below two others?

logical reads on global temp table, but not on session-level temp table

Is a distribution that is normal, but highly skewed, considered Gaussian?

Why did the Drakh emissary look so blurred in S04:E11 "Lines of Communication"?

How dangerous is XSS

Is it okay to majorly distort historical facts while writing a fiction story?

How can I replace x-axis labels with pre-determined symbols?

Is it possible to make a 9x9 table fit within the default margins?

What is the difference between 'contrib' and 'non-free' packages repositories?

Compilation of a 2d array and a 1d array

Creating a script with console commands

Masking layers by a vector polygon layer in QGIS

Incomplete cube

Read/write a pipe-delimited file line by line with some simple text manipulation

A hang glider, sudden unexpected lift to 25,000 feet altitude, what could do this?

Create custom note boxes

How can I separate the number from the unit in argument?

How can the PCs determine if an item is a phylactery?

Finitely generated matrix groups whose eigenvalues are all algebraic

Find the majority element, which appears more than half the time

How can I prove that a state of equilibrium is unstable?

How to coordinate airplane tickets?

PostGIS st_scale with factor and origin

0

I'm trying to buffer points and scale the buffer around the points themselves. According to the documentation this can be done by supplying the factor as a point to the second argument and the origin to the third.

But my scaled buffers are not coming out correctly and have no extent according to QGIS. How can I scale the buffers around the points' origins?

Here's an example of what I have currently:

DROP TABLE IF EXISTS zones;

CREATE TABLE zones AS (

WITH

coords AS (

SELECT *

FROM ( VALUES

    (1, 101, 201),

    (2, 104, 204),

    (3, 109, 209)

) p(id, x, y)

),

points AS (

SELECT id, st_setsrid(st_point(x, y), 32616) geom

FROM coords

)

SELECT id, st_scale(st_buffer(geom, 1), st_point(4, 8), geom) geom

FROM points

)

postgis

share

asked 1 min ago

rovykorovyko

1011

New contributor

rovyko is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I'm trying to buffer points and scale the buffer around the points themselves. According to the documentation this can be done by supplying the factor as a point to the second argument and the origin to the third.

But my scaled buffers are not coming out correctly and have no extent according to QGIS. How can I scale the buffers around the points' origins?

Here's an example of what I have currently:

DROP TABLE IF EXISTS zones;

CREATE TABLE zones AS (

WITH

coords AS (

SELECT *

FROM ( VALUES

    (1, 101, 201),

    (2, 104, 204),

    (3, 109, 209)

) p(id, x, y)

),

points AS (

SELECT id, st_setsrid(st_point(x, y), 32616) geom

FROM coords

)

SELECT id, st_scale(st_buffer(geom, 1), st_point(4, 8), geom) geom

FROM points

)

postgis

share

asked 1 min ago

rovykorovyko

1011

New contributor

rovyko is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I'm trying to buffer points and scale the buffer around the points themselves. According to the documentation this can be done by supplying the factor as a point to the second argument and the origin to the third.

But my scaled buffers are not coming out correctly and have no extent according to QGIS. How can I scale the buffers around the points' origins?

Here's an example of what I have currently:

DROP TABLE IF EXISTS zones;

CREATE TABLE zones AS (

WITH

coords AS (

SELECT *

FROM ( VALUES

    (1, 101, 201),

    (2, 104, 204),

    (3, 109, 209)

) p(id, x, y)

),

points AS (

SELECT id, st_setsrid(st_point(x, y), 32616) geom

FROM coords

)

SELECT id, st_scale(st_buffer(geom, 1), st_point(4, 8), geom) geom

FROM points

)

postgis

share

asked 1 min ago

rovykorovyko

1011

New contributor

rovyko is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

DROP TABLE IF EXISTS zones;

CREATE TABLE zones AS (

WITH

coords AS (

SELECT *

FROM ( VALUES

    (1, 101, 201),

    (2, 104, 204),

    (3, 109, 209)

) p(id, x, y)

),

points AS (

SELECT id, st_setsrid(st_point(x, y), 32616) geom

FROM coords

)

SELECT id, st_scale(st_buffer(geom, 1), st_point(4, 8), geom) geom

FROM points

)

share

asked 1 min ago

rovykorovyko

1011

New contributor

rovyko is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 1 min ago

rovykorovyko

1011

New contributor

rovyko is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

rovykorovyko

1011

New contributor

rovyko is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

rovykorovyko

1011