[postgis-users] (no subject)

http://www.gordongatherer.com/find11.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] ST_DWITHIN indices

Thanks. I started using GIST. It works. Thanks, Sairam Krishnamurthy +1 612 859 8161 On Thu, May 5, 2011 at 8:39 PM, Ben Madin wrote: > Sairam, > > On 06/05/2011, at 5:50 AM, Sairam Krishnamurthy wrote: > > > Table structure: lat AS double, lon AS double, spatialPoint A

[postgis-users] ST_DWITHIN indices

00A0224DB03F00C05D6B324000A0224DB03F0020EE6B324000C050DDB03F0020EE6 ) AND _st_dwithin("spatialPoint", '010120E6102A7288B83995B03FCFF753E3A56B3240'::geometry, 0.0011::double precision) AND ('010120E6102A7288B83 recision))) (2 rows) Any

Re: [postgis-users] Distance constraints on spatial points

Krishnamurthy +1 612 859 8161 On Tue, May 3, 2011 at 3:45 PM, fork wrote: > Sairam Krishnamurthy gmail.com> writes: > > > Any idea about how to place this distance constraint on > > the spatial point field? > > A trigger in PL/PGSQL? > > http://www.postgr

[postgis-users] Distance constraints on spatial points

error thrown. Any idea about how to place this distance constraint on the spatial point field? TIA Thanks, Sairam Krishnamurthy +1 612 859 8161 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman

Re: [postgis-users] Unique Constraint on Spatial Point violated

Thanks Brent. Going to try this. I will update the progress. Thanks, Sairam Krishnamurthy +1 612 859 8161 On Fri, Apr 22, 2011 at 4:08 PM, wrote: > It is likely to be the fastest waty to initially populate the table as a > bulk insert. There is nothing stopping you adding rows later h

Re: [postgis-users] Unique Constraint on Spatial Point violated

, Sairam Krishnamurthy +1 612 859 8161 On Fri, Apr 22, 2011 at 2:35 PM, wrote: > I'd try a different approach to loading your data into the table. > > Try loading your lat/lon values using copy. This will be fastest (specify > the field delimiter char): eg: cat | psql -d -c &q

[postgis-users] Unique Constraint on Spatial Point violated

the filed spatialPoint. This happens when I try to load the point "-3.751046|-51.359041". But when I grep for the point in the file only one row exists. I am not sure if this is a precision problem in calculting the spatial points from the lat.lon value. Can someone help me with this? Thanks,

Re: [postgis-users] Loading spatial point from text file

> twice as > -- big physically) > UPDATE foo SET pt = ST_SetSRID(ST_MakePoint(lon, lat), 4326); > -- 18609 ms > > VACUUM FULL ANALYZE foo; > -- 5297 ms. > > > Cheers, > -- Kevin > > > > On 12/6/2010 12:06 PM, Sairam Krishnamurthy wrote: >

Re: [postgis-users] Loading spatial point from text file

ng, NEW.lat)); > > -- You would use your COPY command here to insert records > INSERT INTO foo_tmp (long, lat) VALUES (-56.57647, -64.7647); > DROP TABLE foo_tmp CASCADE; > > SELECT ST_AsText(pt) FROM foo; > st_astext > --- > POINT(-56.5764

[postgis-users] Loading spatial point from text file

in the table and have only the spatialPoint field. Because of the above problem I was forced to have lat,lon fields in the table. Someway to achieve this will help me a lot. Thanks, Sairam Krishnamurthy +1 612 859 8161 ___ pos