Questions tagged [pgadmin]
The pgadmin tag has no usage guidance.
7 questions
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
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
2
votes
1
answer
95
views
Exporting polygons to existing database in QGIS
I have exported a shp polygon file in QGIS to a table in pgAdmin. Now I have more polygons in QGIS that I want to export to the same table in pgAdmin. This means that I want to add the new polygons to ...
- 71
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
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
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 ...
0
votes
0
answers
45
views
Displaying bit(1) data
I'm having an issue showing a type bit(1) data in QGIS.
I can see the field in the DB Manager but once I load the layer in QGIS, the field disappears.
Does it have anything to do with the default ...
- 1,134