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


6

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 that you are viewing is simply the number selected that you specify. If you want to edit the query, simply click you the table and then from Tools in the menu bar ...


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

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,4326); UPDATE myTable SET geom_point = geometry WHERE GeometryType(geometry) = 'POINT'; If you want to record the geometry type, then you need to add a text ...


4

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 create function and then call that function using psycopg2 in python). Then do further processing in python. Finally return the results to postgres database using ...


3

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

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: WHERE uprn < 200 AND uprn > 99, but this won't find values like 1001... Cast the bigint to a string WHERE uprn::text LIKE '100%' In the second case the ...


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.


3

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 you already have in your current data directory to the new location alter the data_directory setting in postgresql.conf restart the server. Here are the ...


2

you can try this select * from pg_tables where tableowner='user'


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

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

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)


1

You seem to compare a BIGINT column (uprn) with a string matching sequence, using the LIKE operator. That´s not going to work. You can cast the uprn column to text (... WHERE uprn::text LIKE '100%') to filter with regex matching. Doinig this with the used statement, however, will match all values starting with 100 and followed by any character (or none), e....


1

There are two issues that prevents getting the expected result. First, you are using lat-long coordinates (4326) but declare them as 3857 ST_SetSRID(ST_MakePoint(124.263770, 8.265921),4326)) AS DIST Then the query computes the distance to the geom and return the 1st result. Since there is no ordering, a more or less random geom is used, regardless of its ...


1

The issue is caused when exporting a shapefile from Cadcorp sis into pgAdmin, something appears to go wrong here as when the shapefile is exported from Qgis the area is correct. The bug has been reported to Cadcorp.


1

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 EXTENTION postgis", and everything should work !


1

You need the bounding box of the raster. Something like this: where st_within("points inside raster_test".geom, st_envelope(myraster3.rast)) Should do it. (ref. to docs.)


1

I finally managed to solve my issue by creating the following extension: CREATE EXTENSION postgis_topology; It now works fine. Thank you all!


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