Re: [postgis-users] PostGIS 2.1 CREATE EXTENSION vs Loading postgis.sql and spatial_ref_sys.sql

BladeOfLight16 wrote: On Tue, Feb 3, 2015 at 11:41 PM, Puthick Hok > wrote: I use Perl DBI to connect to Postgresql. If I create the postgis database using 'CREATE EXTENSION' method, Perl DBI returns 'layer_id' as the primary key of my layer table. If I cre

Re: [postgis-users] PostGIS 2.1 CREATE EXTENSION vs Loading postgis.sql and spatial_ref_sys.sql

BladeOfLight16 wrote: On Tue, Feb 3, 2015 at 11:41 PM, Puthick Hok > wrote: I use Perl DBI to connect to Postgresql. If I create the postgis database using 'CREATE EXTENSION' method, Perl DBI returns 'layer_id' as the primary key of my layer table. If I cre

Re: [postgis-users] PostGIS 2.1 CREATE EXTENSION vs Loading postgis.sql and spatial_ref_sys.sql

On Tue, Feb 3, 2015 at 11:41 PM, Puthick Hok wrote: > I use Perl DBI to connect to Postgresql. If I create the postgis > database using 'CREATE EXTENSION' method, Perl DBI returns 'layer_id' as > the primary key of my layer table. If I create the postgis database using > the old incompatible wa

[postgis-users] PostGIS 2.1 CREATE EXTENSION vs Loading postgis.sql and spatial_ref_sys.sql

Hi, I was given a schema whose tables contain primary key fields named just 'id'. For example, layer table has 'id' field as it primary key and 'name' as a normal field. I already know that these two names are not good name because they are reserved words used in many places like they break X

Re: [postgis-users] Convert from Lat/Long point to postGIS geometry

I recommend you use QGIS to visualise your Postgis data & ensure it is correct before using Geoserver; QGIS & Postgis work very well together. Postgis can help with the automatic populating of the data. You can create an on insert (or update) trigger in Postgres which will populate the missing c

[postgis-users] Getting TopologyExections when trying to node linestrings to create an overlay

I'm trying to create a polygon overlay. The basic process is relatively simple: 1) Get the boundaries 2) Union the boundaries to node the linestrings 3) Polygonize the noded outlines 4) Filter out holes using a contains or intersects test. The problem I'm running into is that I'm getting "GEOSUnary

Re: [postgis-users] English please

You are welcom It wasn't a bug, so no ticket, so nothing to do ;-) Cheers, Rémi-C ~~~Français~ Pas de problème, comme il ne s'agissait pas d'un bug, je n'ai pas créé de ticket, donc il n'y a rien à faire. Salutations, Rémi-C 2015-02-03 14:53 GMT+01:00 Guillaume ARNAUD : > Thank you

Re: [postgis-users] English please

Thank you for your help. The example is exactly what I need. I apologize for speaking French to other users. If I again need help or if one day I can bring my own, I will try to do it in English. Good job for this function Remi and thank you again. How can i close this topic and note that my pro

Re: [postgis-users] English please (was: Get parallel some route.)

/*french version at the end*/ Ok I think I found the problem : your geometry are not simple, that is in postgis langage, there is no selfintersection. Your lines have tone of selfintersection , which is forbiden (because GEOS does topological computation)! So now of to fixe this : use this functio

Re: [postgis-users] English please (was: Get parallel some route.)

On Sun, Feb 01, 2015 at 08:46:16PM +0100, Rémi Cura wrote: > We are coming closer to a GEOS or PostGIS bug. Please use the bug tracker for these, thanks. --strk; ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bi

Re: [postgis-users] Convert from Lat/Long point to postGIS geometry

Hi Brent Wood, Many thanks, it works. UPDATE public.town SET geom = ST_SetSRID(ST_MakePoint(longitude, latitude), 4326); I am using postGIS to store the data and using GeoServer for publishing the data to maps. I'm thinking to use the GeoExplorer (from OpenGeo Suite) for digitizing and collectin