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

Filter by
Sorted by
Tagged with
1
vote
0answers
29 views

Rendering 3D map in pgAdmin 4 to view Data? [on hold]

I found this error 3D geometrics not rendered in view data (pgAdmin 4). In GeoDjango I've updated my PointField model with dim=3. After successful migration, I cannot see my data in map. My Django ...
0
votes
1answer
18 views

Parse Error on PostgreSQL when using ST_AsText

I am new to using POSTGIS and PostgreSQL. I am trying to convert PostGIS coordinates into lat and long values. When I copy one of the values and query like SELECT ST_AsText('...
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 ...
1
vote
1answer
32 views

Updating geometry as Multipolygon from Polygon table using PostGIS? [closed]

There are two tables in PostGIS. In which, one has polygon geometries with layer name wise and another one table has master layer name list. The requirement is to collect the polygon geometries as ...
4
votes
3answers
2k views

How to solve “libintl-9.dll is missing” when trying to run PostGIS 2.0 Shapefile and DBF Loader Exporter

When I try to run PostGIS 2.0 Shapefile and DBF Loader Exporter I get the following error: The program can't start because libintl-9.dll is missing from your computer. Try reinstalling the ...
1
vote
1answer
21 views

pgAdmin 4 load query from server [closed]

I installed pgAdmin 4.4. In the query tool I wanted to load a query that is saved on our server but this seems to be impossible because only the local drives c: d: etc. are provided. I tried to insert ...
1
vote
0answers
53 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
2answers
167 views

Load LINESTRING in WKT-format from CSV to pgAdmin?

I've got a CSV file with a column containing LINESTRINGs that looks something like this: 1,"LINESTRING(20.331 54.33, 21.67 44.89, 12.67 13.5679)",2014-03-09 13:30:33,2014-03-09 13:31:33 2,"LINESTRING(...
0
votes
1answer
4k views

How to upgrade pgAdmin 4 in Windows? [closed]

A new version of pgAdmin 4 is released almost every month. I wonder what is the correct way to upgrade a newer version of it? Is it necessary to uninstall the older version first and install the new ...
1
vote
1answer
81 views

PostgreSQL PostGIS: append table to another table [closed]

I have a large polygon table (30+million rows) and a smaller polygon table (45,000 rows). Both are PostGIS enabled. The smaller table only contains polygons that do not exist in the large table. Both ...
1
vote
1answer
64 views

PostgreSQL PostGIS: Spatial join but keep all features that don't intersect

Spatial joining a point table to a polygon table, creating a new output table. So far I can only get the output table to contain features that satisfy the spatial join. However, I want the output to ...
0
votes
2answers
768 views

ERROR: parse error - invalid geometry (Postgis)

Initially I was storing my column as path and then following this question I changed it to text. I'm trying to convert my column from text to geometry type by running this command: ALTER TABLE ...
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
54 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
2answers
516 views

PostgreSQL select value where '100%' using bigint

I am trying to select data from a bigint column in PgAdmin using SQL: SELECT FROM public.addressbaseplus WHERE uprn LIKE '100%' However, I am getting the following error: ERROR: operator does not ...
0
votes
1answer
60 views

ST_DISTANCE isn't giving the expected result

I don't get why ST_DISTANCE is giving me the same closest node when clearly it is not the one nearest to the starting point. Also, using 2 different starting points, I still have the same result. My ...
0
votes
1answer
134 views

How to find name of tables for which you are the owner in pgAdmin 4 [closed]

How to find name of tables for which you are the owner in pgAdmin 4?
0
votes
1answer
301 views

PostGIS update column with selected

I am new to database sorry if this is basic. I have selected point geometry from a geometry column in pgAdmin, however, I would like to know how to now copy the selected points to a new column? This ...
1
vote
1answer
61 views

Postgis pgAdmin ST_area returning different to other GIS's

I have a shapefile which is returning a different area value in pgAdmin than in FME, Cadcorp SIS and QGIS and I don't know why it is different in pgAdmin. The setting used in pgAdmin are: SELECT ...
0
votes
1answer
349 views

Create new database in shared drive Postgresql

I have my postgresql/ postgis installed in the c drive but I am running out of space. Is it possible to create a new database in the shared drive and access it from local pgadmin?
0
votes
0answers
151 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 ...
1
vote
1answer
479 views

Problem with PostGis Shapefile Import/Export Manager with no explanation

I am trying to import a shapefile into PgAdmin4. I do it with PostGis Shapefile Import/Export Manager. I have a « connection failed » message with no explanation so I do no know where to search … My ...
2
votes
1answer
709 views

Is there a way to run a Python script inside pgAdmin 4 without relying on e.g. the QGIS Python console to do so?

I have a python script that contains within it an SQL command. When I execute this through QGIS Python console it also runs smoothly and returns the expected results without any problems. I would ...
0
votes
0answers
132 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 ...
2
votes
1answer
163 views

i want to Search for points within a raster layer using ST_Contains. Keep getting no function matches given error

I have made a Simple points shapefile with seven points and I would like to be able to query which of these points are contained within the boundary of the raster layer. SELECT "points inside ...
1
vote
2answers
2k views

psycopg2 not working because column “geom” does not exist

I was planning to post this question on Stack Overflow before realizing that it probably was more related to my poor knowledge of GIS (I'm an absolute beginner in GIS and my knowledge of Python is ...
4
votes
1answer
4k views

Query field disabled in edit data mode in pgadmin 4 [closed]

I want to make a SELECT statement in the "View/Edit Data" mode in pgAdmin 4 but the query field is disabled. How can I enable it? (I have all privileges for all, the database, schema and table and I ...