Tag Info

New answers tagged

0

In Ubuntu 14.04 you also need to install the postgresql-9.3-postgis-scripts package. After I ran sudo apt-get install postgis postgresql-9.3-postgis-scripts I was then able to successfully run CREATE EXTENSION postgis; in my database to initialise PostGIS.


1

Query for ST_IsValid([your geometry]) = 'f'


0

Looks like you are missing hibernate spatial in your pom.xml Here is the pom I used with PostGIS and Hibernate spatial https://github.com/thesteve0/parkshibernatespatial/blob/master/pom.xml


0

I think this might do the trick. Let's say you created your topology like this: SELECT topology.CreateTopology('my_topo', 4326, 0.01); SELECT topology.AddTopoGeometryColumn('my_topo', 'my_layer', 'topogeom', 'MULTIPOLYGON'); where my_layer is an existing table. Remove any data from tables with a TopoGeometry column using this topology. DELETE FROM ...


1

After all @janechii clues.... and purging all possible residuals, sudo apt-get purge build-essential libgeos-3.4 libgeos-c1 libgeos-dev libxml2-dev libgdal-dev libproj-dev libjson0-dev xsltproc docbook-xsl docbook-mathml sudo apt-get purge postgis I statart with (adapting!) recipes of this link: wget http://download.osgeo.org/geos/geos-3.4.2.tar.bz2 ...


0

This is how I got around it select * from polygon where st_disjoint( ( select polygon from polygons where id=1), neighbourhoods.polygon) =0 See more details here http://stackoverflow.com/questions/26241751/find-neighbouring-polygons-in-ruby


1

I had a similar issue. Even recompiling against the new GEOS didn't help when you have 2 versions. It kept trying to use the older version. Firstly, try to uninstall the old library, and see if that works. If not, try to follow this link's instructions using a custom PostgreSQL repository. If all else fails, check your ldconfig to see if older version of ...


2

You need to cast from the output of ST_MAKE() which is a geometry to the geography data type. This casting is done by using the :: operator. The following command should work: UPDATE customer_campaign set geom=ST_MakePoint(customer_campaign.long, customer_campaign.lat)::geography;



Top 50 recent answers are included