All Questions
Tagged with pgadmin postgresql
5 questions
0
votes
0
answers
26
views
Data source repair not working
Out of the blue, two table in my PostGIS are being flagged for multiple users as needing the data source repaired.
The permissions, schema and database have not changed. Navigating to the table in the ...
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