9

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 reveal other issues


5

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 topo LEFT OUTER JOIN public.wolv_adb_slim as adb ON ST_WITHIN(adb.geom, topo.geom) Conversely, obtain all adb rows, whether they have a topo or not, use: ...


4

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 paste it in the same directory. Rename it, libintl-9.dll (with the number 9) instead of libintl-8 - Copie.dll Now, re-run PostGIS 2.0 Shapefile and DBF Loader ...


3

In Windows, I have been using and upgrading pgAdmin 4 since version 3.1. Now, have just upgraded to 4.4.3 version. What I do is just download the installer (see here) and run it. It will overwrite previous version. The server connection setups I had in previous versions are all kept when starting the new version as well.


2

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 answer from https://tutel.me/c/gis/questions/229819/how+to+solve+missing+libintl8dll+error+with+postgis)


2

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 remove the superfluous [ and ] around your text string. Use the Postgres concat operator to add a leading LINESTRING, so that you have a valid textual ...


2

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 overlapping polygons to dissolve then use ST_UNION


2

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 located in the corresponding cell of the EXCEL table, see Figure 1, note that the numeric fields have a numeric type, the text fields have a text type, and the ...


1

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 rows_where parameter that is available in the function (see documentation at Selecting rows using rows_where parameter). With this parameter you can split up the ...


1

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; with src as (select ' 0101000000A7E8482EFFC55B402063EE5A42064140'::text txt) select st_asText(txt::geometry) from src; ERROR: parse error - invalid geometry ...


1

It suggests the existing data in the large table was inserted using an objectID coming from a different sequence than the default one. The new insert fetch objectID = 1 from the sequence, which already exists. You can use the tool that you previously used to insert the features (i.e. ArcGIS). Alternatively, you can bump the default sequence to the current ...


1

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 geographic text format that I'm familiar with -- you may need to use some SQL string functions to get this into, for example, WKT what kind of geometry type you ...


1

Juste upgrade your PostgreSQL and your PostGIS to the last version I got the same problem with postgreSQL 11.2 and postgis 2.5.2. Apparently this problem has been solved since then. I now run with postgreSQL 11.5 and postgis 2.5.3 and everything is fine


1

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 and it worked.


Only top voted, non community-wiki answers of a minimum length are eligible