Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [pgadmin-3]

pgAdmin III is an administration and management tool for the PostgreSQL database and derivative products

1
vote
1answer
62 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
29 views

Error 2 Creation of data source “A”.“B” failed: ERROR: relation “B” already exist [closed]

Does anyone know what I may be doing wrong? Foolish question from a newbie perhaps but as I reckon it may be the code for table "B" that I created, how do I edit the code in pgAdmin3? The key aim of ...
0
votes
1answer
40 views

Why does converting the_geom into lat/long gives me more than 1 coordinate?

I'm converting my the_geom into lat/long coordinates but I only want a single coordinate since I'm gonna use the coordinates to draw a polyline in google maps. Attached is the picture of the result of ...
0
votes
0answers
31 views

PostgreSQL plan not using index

I have a point table and a polygon table. I am looking to get data from the points to the polygon. Both tables have gist(geom) indexes. The plan doesn't use them and the query is taking forever on ...
0
votes
0answers
46 views

Trigger for a table with two geometries

I have a table with two geometry types, one with WGS 87 (4326, polygon) and the other with 5347 (local proyection, planar). When the table with 5437 is created or updated in QGIS, the trigger should ...
0
votes
1answer
106 views

Problem to convert geometry to coordinates of geometry(MultiLineString) data

I am stuck converting a geometry(MultiLineString) into coordinates. The following I did. I download the data from this Austin Contours data link I import the shape files using PGAdmin III and ...
0
votes
2answers
38 views

Creating a view in PostGIS - Having issue with view keeping my query

I'm trying to make a view from a table without a geometry column. My first issue is when I click on "New View" and then put the query in and click 'OK'. The query statement is replaced with some ...
3
votes
1answer
35 views

Increasing the x and y values of a point by a value

I have a point dataset with many overlapping points. For the locations where I have overlap, I want to increase the x and/or y location for 1 of the points by 0.1 meters. I need to do this ...
3
votes
1answer
143 views

How Can I View All Databases on a PostGIS server in QGIS

When I add a new PostGIS database connection to QGIS the dialog asks for the database name. At times I want to add a database and can't remember the exact name or I want to add a database from a ...
0
votes
2answers
348 views

pgAdmin III SQL creating a point

I have created a table, dc_crimes, that has eight columns. I would like to fill the geom column with point data created from the lat and long column. The syntax I used to create the table is: CREATE ...
2
votes
1answer
542 views

Trying to insert geometry in existing table (geom field stay empty) using PostGIS?

I'm trying to insert a new line in a big table with the following SQL using PostgreSQL 9.3 and PostGis 2.1.3: INSERT INTO "Edigeo"."GEOM"( cnig, geom_surf, etat, codcom) ...
1
vote
1answer
612 views

Server searching for wrong PostGIS extension file version?

Our database is hosted on a shared server, spatial queries are now failing unexpectedly returning the following error: ERROR: could not access file "$libdir/postgis-2.0": No such file or directory **...
3
votes
1answer
263 views

Dropping a table from PostGIS database using pgAdmin III

A table in my PostGIS database (PostgreSQL 9.3.5) had the wrong geometry-type, therefore I wanted to change the geometry type. I tried to do this by dropping the geometry column like this: ALTER ...
2
votes
1answer
124 views

Showing PostGIS geography with OpenJUMP

I am trying to add data into open jump from a table in pgadmin. However there no geometry column in the table . I do have geography column. Can I transfer the geography to geometry ( i believe it ...
2
votes
0answers
47 views

Populate b.field into a.field when 2 vector points not always coincident but should be coincident

Using QGIS/pgAdmin3, I have a situation where two vector points, should be coincident but I can't guarantee they always are, I need to take feature a.field and populate a field in feature b, upon both ...
5
votes
1answer
401 views

Creating a PostGIS database on an external hard drive?

Is it possible to create a PostGIS database on an external hard drive? If so, is there anything to be mindful of and what would be the host address to connect to it with pgAdmin and QGIS ? ...
2
votes
2answers
802 views

Reading File Geodatabase into Postgres with ogr2ogr

I have looked at other Q&As on the subject and none have solved my problem. Reading Esri File Geodatabase (FileGDB) with OGR? How to Import ESRI Geodatabase format .gdb into PostGIS My problem ...
2
votes
1answer
210 views

Optimal Site Selection Vector Files

I have 5 different polygon vectors: All have over 20.000 features; All have multiple attributes; All overlap each other at least more than 80%, but are shaped differently; All display information of ...
7
votes
2answers
329 views

pgAdmin4 combines geometry SRID and type

Using PostGIS, I have a table with a geometry of LineStringZ with SRID 28356. In pgAdminIII (v1.22.2) its definition in the SQL pane shows as: geom geometry(LineStringZ,28356) In pgAdmin4 (v4.1) the ...
-2
votes
1answer
1k views

Connect a website to a postgresql database [closed]

I am using pgadmin 3 software for database. I would like to connect this database to my website so that I can retrieve ,add delete database entries from the website
3
votes
2answers
766 views

Incomplete export of data from a Postgres table

I'm having a serious data export problem with the PGAdmin widget and pgsql2shp (QGIS too). The problem lies within converting a PostGIS table to shapefile. I put in 3234 feature counts...and I get ...
2
votes
0answers
71 views

Merging features in PostgreSQL [duplicate]

I am using PostGIS on pgAdmin3 (PostgreSQL 9.3 e PostGIS 2.2). I have a shapefile with more than 500.000 features and I want to merge them into one. The geometries are MultiPolygon. I would like ...
20
votes
2answers
14k views

Shapefile loader in pgAdmin 4

Recently I have updated my postgresql version. I have also upgraded pgAdmin from 3 to 4. But I was unable to load shapefile. I didn't find any plugin called shapefile loader. How can I get the ...
0
votes
1answer
537 views

Loading raster in postgis via raster2pgsql

I need to import data file to my database. I created a web interface in order to upload file but I have already an error Warning: pg_query(): Query failed: ERROR: rt_raster_from_wkb: wkb size (0)...
2
votes
3answers
791 views

Buffer and union of large shapefile?

I want to create a buffer of 5km around the coastline, and save that as a separate shapefile. I have a shapefile with almost 180,000 features. It's a line shapefile, representing the coastlines of ...
2
votes
1answer
1k views

Restoring PostGIS 2.1. dump in PostGIS 2.2

I tryed to restore my old PostGIS dumps (Postgis 2.1, PostgreSQL 9.1) at my new system (PostGIS 2.2 and PostgreSQL 9.5) I was using pgadmin3 to dump the databases and was now trying to restore it ...
0
votes
1answer
1k views

PostGIS Shapefile and DBF Loader - automatically Linked dbf file

This is my system: Windows 7 Postgresql 9.5 PGADMIN 3 PostGIS Shapefile and DBF Loader plugin I have imported data from a DBF file correctly with the plugin. My problem: This DBF file changes ...
1
vote
0answers
190 views

Pg_dijkstra empty results

I am currently working on PgAdmin, and the pgrouting extension, in order to get the length and the path of the shortest path between every LNG terminal over the world (I have them as a table of points)...
2
votes
2answers
842 views

Backup GIS data on postgis database from pgadmin3

I am using a postgis database with qgis and managing it with pgadmin3 I have already investigated the backup/restore options within pgadmin 3 and done one test run on one database I am wondering if ...
0
votes
1answer
351 views

Problem with loop for pgr_Dijkstra

I try to use pgr_Dijkstra through Postgis and Pgadmin to find the shortest path in a network between a lot of nodes. So I thought I could to "automate" the process with a PLSQL query. Here is a query ...
2
votes
1answer
1k views

importing shapefile in postgres

I am trying to import a shapefile to my database in postgres but there is no shapefile loader appearing in the plugin menu in PgAdmin. Postgis is definitely installed as I have added it as an ...
1
vote
0answers
86 views

Geometry type error with LineString

I tried to process the following query with PgAdmin III, but it doesn't work and the hint provided doesn't make sense to me : UPDATE grille_segments_finale SET shipping_cost = 1000000 WHERE ...
6
votes
1answer
689 views

Create an optimised path between nodes avoiding polygons entities

I have a point shapefile representing seaports. I have the linear cost of shipping for every seaport pairing (specific shipping cost to go from one point to another point). I want to find a way of ...
1
vote
0answers
164 views

pgRouting “Can't find Table” [closed]

I am using pgRouting version 2.1.0. I am using pgAdmin III. I have created a street network using Anita Graser's guide: https://anitagraser.com/2013/07/06/pgrouting-2-0-for-windows-quick-guide/ But ...
1
vote
1answer
700 views

Change SRID of geometry column

I have in my table column geom with geometry, data type of this column is geometry(Point,102067). I want to change SRID from 102067 to 5514, but if I use this command select UpdateGeometrySRID('...
1
vote
1answer
63 views

Points to polygons transform, inserting columns

In this task I'am transforming points to polygons. I have table POINTStbl with four columns: ID, YEAR, CODE, POINT and i need to create table POLYGONStbl, where will be three same columns(with same ...
2
votes
1answer
1k views

Update one table from another based on spatial join

In beginning i had two tables of points and i wanted create from one of this POINT table new table CIRCLES which will contain circle polygons 300 metres around points. This step i have done here: ...
3
votes
1answer
797 views

CRS transform from EPSG 4326 (WGS 84) ? to EPSG 27700 (OSGB 1936 / British National Grid)

I have a table which is an import of a shp file from www.geofabrik.de/ England > Roads. I've tried to change the CRS to EPSG 27700 but when I add this back to QGIS along side other layers which are ...
0
votes
1answer
149 views

pgr_dijkstra working but pgr_ksp is returning empty an resultset

This pgr_ksp function is not working, as answered in an earlier question SELECT seq , id1 , id2 , cost FROM pgr_ksp( 'SELECT gid as id, fnode_ as source, tnode_ as target, length as cost ...
2
votes
4answers
6k views

Importing csv file with varying numbers of values per row into PostgreSQL?

I am trying to import a csv file into postgres using this statement: COPY T00_import FROM E'C:\\temp\\CSV\\Aberdeen City 9051_20150212_C_01.csv' CSV; The Table T00_import is a simple table with 17 ...
2
votes
0answers
386 views

How to install PostGIS shp2pgsql-gui on openSUSE 13.2?

I installed PostgreSQL 9.4.4 together with pgAdmin III (1.20.00) and the PostGIS extension (2.1.7, via the Stack Builder) from http://www.enterprisedb.com/products-services-training/pgdownload on my ...
1
vote
1answer
2k views

How to bring my PostGIS map from GeoServer to Leaflet based web application?

I have created a group of shapefiles using QGIS and I have stored their corresponding information in PostGIS database by importing the shapefile into pgAdmin3 using shapefile and DBF loader. Then I ...
2
votes
0answers
182 views

Not able to get the PostGIS Layer Viewer running in pgAdmin or command line

I've installed PostGIS Layer Viewer as a plugin for pgAdmin. I've downloaded postgis_viewer.py from the official repository on GitHub! and followed the install instructions described on Web site!. I'...
1
vote
0answers
1k views

Installing PostGIS Layer Viewer for pgAdmin III

I have difficulties installing pgAdmin's plugin PostGIS Layer Viewer. The official repository on GitHub gives this Web site for install procedure, then the former site gives this Web site for ...
4
votes
2answers
1k views

How to get Geography data to GeoJSON in PostgreSQL?

I am using PostgreSQL database and there is a field in a table(area), i.e., public.geography(Points,4326). It contains below type of records "0101000020E6100000BA83D89942334540780B24287ED051C0" I ...
1
vote
0answers
131 views

Why do pgadmin III views show up as empty ArcSDE geodatabase tables in ArcCatalog? [closed]

I have an SDE geodatabase connection set up in a server with data stored in a postgres database. I have successfully created views using pgadmin III but they show up as empty tables in ArcCatalog (...
1
vote
1answer
243 views

What date was a table loaded into PostGIS

Is it possible to find out the date a table was loaded into a PostGIS schema using PgAdmin3? The tables are usually supplied from varying external sources.
4
votes
4answers
48k views

postgresql export database by command or pgAdmin III [closed]

I want to export my postgresql db with pgadmin. I search all of its GUI, I also searched the web and I don't find some sueful information. I know how to import the db into postgresql: create a db with ...
4
votes
2answers
2k views

Error inserting GeoJSON in PostGIS

I know there is a similar question but I am getting a different error and none of those answers have helped. I am trying the following query (the GeoJSON itself is from the PostGIS website. INSERT ...
1
vote
1answer
358 views

Run PostGIS command line functions in pgAdmin?

Is it possible to utilize the PostGIS command line functions, e.g. shp2pgsql, from within pgAdmin III? I am using pgAdmin to connect to a remote server.