18
votes
Accepted
"libintl-9.dll is missing" when trying to run PostGIS 2.0 Shapefile and DBF Loader Exporter
It might be required in C:\Program Files\PostgreSQL\10\bin\postgisgui (or wherever the loader is installed).
It is however suspicious that the lib isn't included in the installer, and it might ...
- 43.1k
15
votes
"libintl-9.dll is missing" when trying to run PostGIS 2.0 Shapefile and DBF Loader Exporter
I found the libintl-9.dll file in the folder :
C:\Program Files\PostgreSQL\11\bin\
and copied it to the folder :
C:\Program Files\PostgreSQL\11\bin\postgisgui
then ran the .exe file in that folder ...
- 151
12
votes
Query field disabled in edit data mode in pgadmin 4
This happens when you view a specific number of records from your table by right clicking on it and pgAdmin4 allows you to only view the records and does not allow you to edit the query. The Query ...
- 2,281
9
votes
Accepted
pgAdmin version 4-5.3 where is the geometry viewer
Go to the far right of the geometry column and click on the eye icon
==>
- 43.1k
7
votes
"libintl-9.dll is missing" when trying to run PostGIS 2.0 Shapefile and DBF Loader Exporter
Go to C:\Program Files\PostgreSQL\10\bin\postgisgui (or wherever the loader is installed).
For example, for me, C:\Program Files\PostgreSQL\11\bin\postgisgui.
Make a copy of the libintl-8.dll and ...
- 151
7
votes
Accepted
PostgreSQL PostGIS: Spatial join but keep all features that don't intersect
To obtain all topo rows, whether they have an adb or not, use LEFT OUTER JOIN:
SELECT
topo.id,
topo.geom,
topo.ogc_fid,
topo.theme,
topo.class,
adb.uprn
FROM
public.wolv_topobuild as ...
- 20.3k
6
votes
Accepted
PostGIS update column with selected
If you want to copy the geometry, you would add a new geometry column then copy the selected records. Assuming your data is using SRID 4326:
ALTER TABLE myTable ADD COLUMN geom_point geometry(point,...
- 43.1k
6
votes
Accepted
Load LINESTRING in WKT-format from CSV to pgAdmin?
If I understand your question correctly, then there are various ways to load data from the * .csv format in PostgreSQL DBMS, and here is one of them.
1) Prepare your data so that each data set is ...
- 4,507
5
votes
Accepted
ERROR: parse error - invalid geometry (Postgis)
I have no idea how you got the [] round what appears to be a textual representation of a LINESTRING, and there is a fairly strong clue in the error message. To remove them:
use regexp_replace to ...
- 13.7k
5
votes
Accepted
How to upgrade pgAdmin 4 in Windows?
Update:
After upgrading to version 5.2, it created a new folder 'v5' within 'Program Files\pgAdmin 4' (instead of overwriting 'v4'). So, I manually uninstalled pgAdmin 4 'v4' (through Windows 'Control ...
- 10.3k
5
votes
Saving modifications in PostGIS layer edited in QGIS
TL;DR: You can modify data physically present inside individual tables, but you cannot alter their columnar structure (or row counts) based on a join of multiple data sources.
Make sure you ...
- 30.9k
5
votes
Accepted
View two geometry columns together in pgAdmin Geometry Viewer
Not directly, but you can construct a new geometry - or a geometry collection - containing the two geometries using st_collect
select st_collect('point(1 1)'::geometry, 'linestring(0 0, 0 1)'::...
- 43.1k
4
votes
Accepted
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 think you are trying to use postgres and python together. One option could be that:
You use pyscopg2 to execute your postgres script and return your
results to python (you can use PL/pgsql to ...
- 1,634
4
votes
Create new database in shared drive Postgresql
You can do this in one of two ways.
Move you entire data directory to a new drive. The data_directory is a config setting in postgresql.conf .
So, you would need to stop the server
move everything ...
- 13.7k
4
votes
Accepted
PostgreSQL select value where '100%' using bigint
The LIKE keyword in SQL operates on strings not numeric datatypes like bigints.
Presumably you want all the items where the uprn field begins '100'.
There are 2 approaches:
Select a range of values:...
- 2,176
4
votes
Accepted
Create PostgreSQL user for QGIS project
By default, the public role (which is assigned to everybody in the DB) allows creating objects in the public schema. You can revoke this.
It is indeed a good practice to remove every rights from the ...
- 43.1k
4
votes
Accepted
Forcing geometry columns to be small on pgAdmin 4
On the top left menu, go to "Files > Preferences" and then click the "Results grid" in the left column.
Change the "Maximum column width" to the desired value, here ...
- 10.9k
3
votes
Accepted
pgr_createTopology uses too much memory and "connection to the server has been lost"
This problem is a very common one when using huge graphs with pgrouting and a limited amount of RAM.
One solution (which may be automated with Python - but not necessarily) would be to use the ...
- 2,385
3
votes
ERROR: parse error - invalid geometry (Postgis)
It looks like you're getting that error because you're attempting to change the data type on a column that is already populated with a different data type.
The data you have doesn't look like any ...
- 156
3
votes
"libintl-9.dll is missing" when trying to run PostGIS 2.0 Shapefile and DBF Loader Exporter
That worked for me (postgresql-11.3-1-windows-x64) :
check that there is a libintl-9.dll in C:\Program
Files\PostgreSQL\11\bin directory
add that directory to PATH environment variable (original ...
3
votes
Accepted
Problem with PostGis Shapefile Import/Export Manager with no explanation
Finally, that was quite a simple stupid error : I forgot to enable postgis in this specific Database, as JGH mentionned !
If you have the same problem, run "CREATE EXTENSION postgis", and ...
- 505
3
votes
Finding all isolated buffer points using PostGIS
You can use ST_ClusterDBSCAN:
with cte as (
select id, ST_ClusterDBSCAN(geom, eps := 0, minpoints := 2) over () AS cluster_id, geom
from public.buffers100k)
select id, geom from cte where cluster_id ...
- 77.8k
3
votes
QGIS will not save edits for data stored in PostGIS
As I understand you tried to not just edit but create new object (insert new row). So, you have not such privileges on table primary key sequence. In your example it's "Test_Line_Layer_id_seq&...
- 1,150
2
votes
Accepted
How to find name of tables for which you are the owner in pgAdmin 4
you can try this
select * from pg_tables where tableowner='user'
- 1,634
2
votes
Accepted
Parse Error on PostgreSQL when using ST_AsText
The error message mentions " 0101000000A7E8482EFFC", with a trailing space, which makes the geometry invalid.
The dirty solution is to trim your data
SELECT ST_AsText(TRIM(GPS)) from schema.table;
...
- 43.1k
2
votes
Accepted
Updating geometry as Multipolygon from Polygon table using PostGIS?
Try ST_COLLECT:
update master as m
set geom = w.geom
from
(select st_collect(geom) geom, layer
from wise
group by layer) w
where m.layer = w.layer
If you want the borders of ...
- 77.8k
2
votes
Accepted
Error when creating PostGIS extension in pgAdmin4
Try to reinstall PostGIS by the following executable on this page : http://download.osgeo.org/postgis/windows/pg12/
The download will allow you to get the necessary dll files.
When PgAdmin4 was ...
- 4,120
2
votes
Accepted
Error when publishing a table/layer from PostGIS to GeoServer
Checking the GeoTools code base indicates that this was switched 4 years ago. So you are probably running a very old version of GeoServer and this will go away if you update as @geozelot suggests.
- 83.2k
2
votes
QGIS error message while running PostgreSQL code. WARNING Invalid PostgreSQL layer
Normally that error occurs when QGIS cannot find a column with a unique "primary key". Ensure that the pin column has no duplicates, or add another field with a proper primary key.
See this ...
- 41
2
votes
Saving modifications in PostGIS layer edited in QGIS
As soon as you save your edits in a PostGIS layer, the modifications will be committed to PostGIS, so that it will be visible in any other tools (e.g. pgAdmin).
Although, if you do a attribute join in ...
- 3,836
Only top scored, non community-wiki answers of a minimum length are eligible