Questions tagged [pgadmin-4]

pgAdmin 4 is designed to meet the needs of both novice and experienced Postgres users alike, providing a powerful graphical interface that simplifies the creation, maintenance and use of database objects

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
52 views

ERROR: function st_orientedenvelope(unknown) does not exist

I tried the example for ST_OrientedEnvelope given in PostGIS website but that failed. This function is failing for my table geometry column also. SELECT ST_AsText(ST_OrientedEnvelope('MULTIPOINT ((0 ...
1
vote
0answers
55 views

Import CSV to QGIS 3 where the geometry is in GeoJSON format

I have a CSV file with different attributes for each polygon. One of the attributes (column name) is GeoJSON which hold the geometry. For example, in the first polygon the geojson attribute is: {"...
1
vote
0answers
53 views

Setting PostgreSQL privileges for ArcGIS?

I'm migrating from SQL Server and setting up my first PostgreSQL server for use with ArcGIS. I've followed esri tutorials and related how-tos. I'll be using a versioned editing environment, as I ...
1
vote
1answer
37 views

Why does my source and target repeats itself when I use pgr_createtopology()?

I created my path in QGIS v2.18.18, making the lines and a combination of cleaning tool and explode lines tool to get my desired output. I tried using ROAD GRAPH plugin in order to check whether my ...
0
votes
0answers
150 views

Is Spatial clustering with PostGIS possible to generate N number of groups that have 10 elements?

I need to create a query using some sort of spatial clustering algorithm within PostGIS database. Currently, I am using pgAdmin version 4. More specifically, I need to create N number of groups that ...
0
votes
0answers
131 views

pgr_createTopology() 'Connection to the server has been lost'

When trying to create topology from pgAdmin 4 (version 2.1) with the pgr_createTopology function I get an error: "Connection to the server has been lost." The database is on localhost. The input ...