Re: [postgis-users] ST_Intersects not finding everythng?

Individually your observation does not hold. Testing the literals pairwise returns true in all cases. select st_intersects('SRID=4326;POLYGON((-71.0004167 43.0004167,-69.9995833 43.0004167,-69.9995833 41.9995833,-71.0004167 41.9995833,-71.0004167 43.0004167))', 'srid=4326;POLYGON((-70.707854431152

[postgis-users] ST_Intersects not finding everythng?

I am sure this is my faulty understanding. I have been noticing that some EPSG4326 polygons are only being found only in a smaller search bbox, not in a larger search bbox. Even though the larger box is entirely bigger on all sides (I actually get the bbox from Google Maps). I am using ST_INTERSEC

Re: [postgis-users] Diff. Between 2 tables

Thank you for your answers. -- View this message in context: http://postgis.17.n6.nabble.com/Diff-Between-2-tables-tp4998062p4998090.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postg

Re: [postgis-users] loading only geometries of shp files into PostGIS

There's no reason technically you can't do it. You will need to hack the loader to ignore the fact that the other files are missing, but shp file alone does contain all the information you need. P. On Wed, Jun 6, 2012 at 10:23 PM, karsten wrote: > ** > Hi All, > > I am working on a data upload

Re: [postgis-users] postgis installation issue

Yogesh, The first official release of PostGIS with raster support is 2.0. There is nothing to support before that. Pierre > -Original Message- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of Yogesh Dahiya > Sen

Re: [postgis-users] Error adding raster support

Luis, PostGIS 2.0 does support GDAL 1.6. I'm expecting that the GDAL 1.6 coming from the repos uses the naming convention libgdal16.so.1 instead of the default libgdal.so.1, which is known to cause problems. Were you compiling PostGIS 2.0 or using a package from a repo? -bborie On Thu, Jun 7,

Re: [postgis-users] Diff. Between 2 tables

You could also try with not exists select * from table2 where not exists (select unique_key from table1 where table1.unique_key = table2.unique_key) Hugues. De : postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refr

Re: [postgis-users] Diff. Between 2 tables

On 06/07/2012 09:14 AM, Hemin Tofiq wrote: Thank you, I have 2 tables with the same structure, so we don't need to create alias for the same table, however that is fine with updated rows, how can I get newly created rows? Regards, Hemin I assume you mean you have a

Re: [postgis-users] Diff. Between 2 tables

Thank you, I have 2 tables with the same structure, so we don't need to create alias for the same table, however that is fine with updated rows, how can I get newly created rows? Regards, Hemin -- View this message in context: http://postgis.17.n6.nabble.com/Diff-Between-2-tables-tp4998062p49980

Re: [postgis-users] PostgreSQL/PostGIS x64 Error on PostGIS Install

Thanks, Regina. After uninstalling, I tried a fresh install of PostgreSQL followed by a fresh install of PostGIS. The difference this time is that I did not use the existing data structure and started with a new one. The installation went well and without error. I uninstalled then repeated the ab

[postgis-users] postgis installation issue

I am trying to install postgis-pg90-binaries-2.0.0svn which has older version of raster support(which I required to build my app) but getting error saying current transaction aborted , commands ignored until end of transaction block. And is there documentation for older raster support. Thanks

Re: [postgis-users] Error adding raster support

Thank you all for the replies. Initially I tried to install GDAL from the repos, which for Ubuntu 10.04 is only available in version 1.6.0. But contrary to what the readme files says PostGis 2 doesn't go with this version of GDAL. So I download and compiled GDAL 1.9.1, hence I doubt it is an issue

Re: [postgis-users] Diff. Between 2 tables

Hello, I'm not sure I understand the whole thing but in a basic way and if your table have a primary key a self join should help you : select a.* from mytable a, mytable b where a.id = b.id and (a.attr1 != b.attr1 or a.attr2 != b.attr2) The attribut can be a geometry or anything else. Hugues

Re: [postgis-users] PostgreSQL/PostGIS x64 Error on PostGIS Install

Donald, This is extremely odd. Seems like its breaking when its trying to compile the topology addtosearchpath function as you are getting compiled function gibberish it seems. That function is in postgis_topology, so what you could do is just use the binaries (you might not even need to as the

[postgis-users] Diff. Between 2 tables

Hi, I would like to ask if there is a way to compare (find the difference) between 2 tables? Updated geometries or attributes), i.e. An sql som returnes the rows that are updated. Thanks in advance, Hemin -- View this message in context: http://postgis.17.n6.nabble.com/Diff-Between-2-tables-tp49