geoserver

PostGIS – convert multipolygon to single polygon

by

I used ST_DUMP to convert a table of multipolygon geometries in PostgreSQL to a new table with polygon geometries and other columns of data. CREATE TABLE poly AS –poly will be the new polygon table WITH dump AS ( SELECT id, test, –columns from your multipolygon table (ST_DUMP(geometry)).geom AS geometry FROM multi –the name of … Read more

The infamous java.sql.SQLException: No suitable driver found

by

The infamous java.sql.SQLException: No suitable driver found This exception can have basically two causes: 1. JDBC driver is not loaded In case of Tomcat, you need to ensure that the JDBC driver is placed in server’s own /lib folder. Or, when you’re actually not using a server-managed connection pool data source, but are manually fiddling … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)