All Questions
4 questions
2
votes
1
answer
118
views
intersect with ST_Buffer in PostGIS
I have a table called "gebaeude" with all types of buildings in the city.
In the following I want to use a Buffer around the central train station that has the id="2" and a radius ...
- 83
1
vote
0
answers
130
views
Read only certain columns (read permissions) of a PostGIS database in QGIS
In our administration, each employee is given various rights to read and edit data on the PostgreSQL/PostGIS database. To view the geodata, we use QGIS. In this case there should be read permissions ...
- 371
2
votes
0
answers
206
views
Optimize spatial intersect PostGIS POLYGON table with large PostGIS POINT table (point-within-polygon test) [closed]
I have a very large table with a PostGIS POINT geometry column, about 1.7 Billion points. I want to query all points that fall within a number of 30 PostGIS polygons, stored in another table. Both ...
- 714
2
votes
1
answer
240
views
PostgreSQL Create A Line Column From Two Point Columns
My database has beginning and end points [beginning(x,y) ending(x,y)]. I want to create lines from this database for each beginning-end points.
I tried ST_MAKELINE but this function wants location as ...
- 23