Chris Hermansen | 1 Feb 04:23 2010
Picon

Re: Any functions for validating topology of areas, lines/points and/or routes?

Stefan;

This would be a nice "wish list" to make persistent somewhere, maybe on
the wiki?

On Sun, 2010-01-31 at 14:41 +0100, Stefan Keller wrote:
> Dear all
> 
> I’m preparing an introductory course about GIS and want to collect
> topology functions. We’re evaluating QGIS and PostGIS and have to
> be prepared that the functionality will be compared to ArcGIS/
> ArcEditor Geodatabase Topology (called topology rules there).
> 
> Thus my question: Can anyone point me to topology functions,
> most probably implements as stored procedures (pl/pgsql) and
> triggers (rules)?
> 
> I’ve compiled following “topology types” so far:
> * Area topology cleaning: Eliminating sliver polygons, overshoots,
>   undershoots (polygon topology, same polygon class).
> * Polygons are non-overlapping (polygon topology, same polygon class).
> * Polygons are inside other polygons (polygon topology, two different
>   polygon classes).
> * Line topology cleaning: Snapping close endpoints
>   (vertex-vertex/route topology).
> * Routes that share vertices (vertex-vertex/route topology, same
>   line class).
> * Line objects that share (inner) endpoints (node-vertex topology,
>   same line class).
> * Line objects that are “connected to” point objects at their
(Continue reading)

mukesh karanwal | 1 Feb 06:49 2010
Picon

Error Using WKTRASTER!

Hi,
 
I am trying to load raster data (Goetiff file) using "wktRaster" with the following command:
 
C:\Program Files\..\..>gdal2wktraster.py -r utmfile.tif -t utmtable -o utmfile.sql
As i execute this command from command prompt, it gives the following error:
 
File "C:\Program Files\..\..>gdal2wktraster.py" , line 32, in <module>
        from osgeo import gdal
        import error: no module named osgeo
 
I am having Python 2.5 with
system path: C:\gdalwin32-1.6\bin
GDAL_DATA:  C:\gdalwin32-1.6\data
 
how can i get rid of this error and store geotiff file in postgresql ?
 
 
With Regards,
Mukesh

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Paragon Corporation | 1 Feb 07:22 2010
Picon

Re: [Plr-general] Compiling PL/R under VC++ 2005

Jan et. al,
 
Right now we manage the building of the PostGIS one-click installer for the windows stack builder installs.
 
It wouldn't be appropriate to include this in with PostGIS though PostGIS people use it a lot. However we think it should be an option as a separate stack builder option.
 
If there is interest in this, we'd be happy to take this task on to build this, include it as a stack builder option and bring it up with stack builder folks to make sure there are no issues with doing so.
 
Thanks,
Leo and Regina

From: Jan Hartmann [mailto:j.l.h.hartmann <at> uva.nl]
Sent: Sunday, January 31, 2010 2:07 PM
To: Joe Conway
Cc: Paragon Corporation; plr-general <at> pgfoundry.org
Subject: Re: [Plr-general] Compiling PL/R under VC++ 2005

Great, Regina, Joe, I have been waiting for this for years. Thanks!

Jan

On 31-1-2010 19:48, Joe Conway wrote:
On 01/24/2010 11:40 AM, Paragon Corporation wrote:
We've been trying to compile PLR under the PostgreSQL VC+ version so it will work with the one-click installer Windows versions for 8.3/8.4
Binaries (still pre-release) are now available for 8.3 and 8.4 here: http://www.joeconway.com/web/guest/pl/r Two questions: 1) What needs to happen to get PL/R included in the one-click installer? 2) Can the one-click installer handle detection and setting of R_HOME? I hope to package up a new PL/R release before the end of today after retesting the Win32 changes against my Linux install to check for regressions there. Joe _______________________________________________ Plr-general mailing list Plr-general <at> pgfoundry.org http://pgfoundry.org/mailman/listinfo/plr-general
_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Jorge Arévalo | 1 Feb 08:03 2010
Picon

Re: Error Using WKTRASTER!

On Mon, Feb 1, 2010 at 6:49 AM, mukesh karanwal <mukesh_karanwal <at> yahoo.com> wrote:

Hi,
 
I am trying to load raster data (Goetiff file) using "wktRaster" with the following command:
 
C:\Program Files\..\..>gdal2wktraster.py -r utmfile.tif -t utmtable -o utmfile.sql
As i execute this command from command prompt, it gives the following error:
 
File "C:\Program Files\..\..>gdal2wktraster.py" , line 32, in <module>
        from osgeo import gdal
        import error: no module named osgeo
 
I am having Python 2.5 with
system path: C:\gdalwin32-1.6\bin
GDAL_DATA:  C:\gdalwin32-1.6\data
 
how can i get rid of this error and store geotiff file in postgresql ?
 
 
With Regards,
Mukesh


Hi Mukesh,

Probably, the solution to your problem is here:


Best regards,
Jorge
 

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Marko Čubranić | 1 Feb 10:05 2010
Picon

brake MPolygon to polygons

Dear colleagues,

if i have x Mpolygons in table (country) and i want to brake each of them in polygons, and put polygons in new columns, how should i do that?..

thank you

Marko Cubranic

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Nicklas Avén | 1 Feb 10:14 2010
Picon

Re: brake MPolygon to polygons

Hallo
 
If I understand you right you have multipolygons representing countries that you want splitted to single polygons.
 
That is no problem but they will not fit in the same table since you will get additional rows.
 
If you want to make a new table with this country polygons as single polygons you can do
 
create table single_polygon_countries as
select (ST_Dump(the_geom)).geom as the_geom, countryID from original_country_table;
 
I put countryID there, just to illustrate that you probably want to bring some id or name to the new table. That will be repeated for all single polygons from original multi polygon
 
Hope that helps
Nicklas
 


2010-02-01 Marko Èubraniæ wrote:

Dear colleagues,
>
>if i have x Mpolygons in table (country) and i want to brake each of them in polygons, and put polygons in new columns, how should i do that?..
>
>thank you
>
>Marko Cubranic
>
_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Marko Čubranić | 1 Feb 10:15 2010
Picon

Re: brake MPolygon to polygons

thanks Nicklas,

2010/2/1 Nicklas Avén <nicklas.aven <at> jordogskog.no>
Hallo
 
If I understand you right you have multipolygons representing countries that you want splitted to single polygons.
 
That is no problem but they will not fit in the same table since you will get additional rows.
 
If you want to make a new table with this country polygons as single polygons you can do
 
create table single_polygon_countries as
select (ST_Dump(the_geom)).geom as the_geom, countryID from original_country_table;
 
I put countryID there, just to illustrate that you probably want to bring some id or name to the new table. That will be repeated for all single polygons from original multi polygon
 
Hope that helps
Nicklas
 


2010-02-01 Marko Èubraniæ wrote:

Dear colleagues,
>
>if i have x Mpolygons in table (country) and i want to brake each of them in polygons, and put polygons in new columns, how should i do that?..
>
>thank you
>
>Marko Cubranic
>

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
mukesh karanwal | 1 Feb 11:06 2010
Picon

Re: Error Using WKTRASTER!

Yeah, I had gone through this article and installed FW Tools still the problem remains the same!!
do i need to change the system path and Gdal_Data variables again?


--- On Mon, 2/1/10, Jorge Arévalo <jorge.arevalo <at> gmail.com> wrote:

From: Jorge Arévalo <jorge.arevalo <at> gmail.com>
Subject: Re: [postgis-users] Error Using WKTRASTER!
To: "PostGIS Users Discussion" <postgis-users <at> postgis.refractions.net>
Date: Monday, February 1, 2010, 12:33 PM

On Mon, Feb 1, 2010 at 6:49 AM, mukesh karanwal <mukesh_karanwal <at> yahoo.com> wrote:
Hi,
 
I am trying to load raster data (Goetiff file) using "wktRaster" with the following command:
 
C:\Program Files\..\..>gdal2wktraster.py -r utmfile.tif -t utmtable -o utmfile.sql
As i execute this command from command prompt, it gives the following error:
 
File "C:\Program Files\..\..>gdal2wktraster.py" , line 32, in <module>
        from osgeo import gdal
        import error: no module named osgeo
 
I am having Python 2.5 with
system path: C:\gdalwin32-1.6\bin
GDAL_DATA:  C:\gdalwin32-1.6\data
 
how can i get rid of this error and store geotiff file in postgresql ?
 
 
With Regards,
Mukesh


Hi Mukesh,

Probably, the solution to your problem is here:


Best regards,
Jorge
 

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



-----Inline Attachment Follows-----

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Jorge Arévalo | 1 Feb 12:12 2010
Picon

Re: Error Using WKTRASTER!

Correct me if I'm wrong (I'm not a Windows user), but FWTools may use the old python bindings. That is:


import gdal;

instead of

from osgeo import gdal;

So, from my point of view, 2 fast solutions are:

- Use OSGeo4W instead of FWTools, at least for gdal2wktraster.py execution (http://osgeo4w.osgeo.org/)
- "Hack" gdal2wktraster code using try - except:

try:
   from osgeo import gdal
except ImportError:
   import gdal


On Mon, Feb 1, 2010 at 11:06 AM, mukesh karanwal <mukesh_karanwal <at> yahoo.com> wrote:
Yeah, I had gone through this article and installed FW Tools still the problem remains the same!!
do i need to change the system path and Gdal_Data variables again?


--- On Mon, 2/1/10, Jorge Arévalo <jorge.arevalo <at> gmail.com> wrote:

From: Jorge Arévalo <jorge.arevalo <at> gmail.com>
Subject: Re: [postgis-users] Error Using WKTRASTER!
To: "PostGIS Users Discussion" <postgis-users <at> postgis.refractions.net>
Date: Monday, February 1, 2010, 12:33 PM


On Mon, Feb 1, 2010 at 6:49 AM, mukesh karanwal <mukesh_karanwal <at> yahoo.com> wrote:
Hi,
 
I am trying to load raster data (Goetiff file) using "wktRaster" with the following command:
 
C:\Program Files\..\..>gdal2wktraster.py -r utmfile.tif -t utmtable -o utmfile.sql
As i execute this command from command prompt, it gives the following error:
 
File "C:\Program Files\..\..>gdal2wktraster.py" , line 32, in <module>
        from osgeo import gdal
        import error: no module named osgeo
 
I am having Python 2.5 with
system path: C:\gdalwin32-1.6\bin
GDAL_DATA:  C:\gdalwin32-1.6\data
 
how can i get rid of this error and store geotiff file in postgresql ?
 
 
With Regards,
Mukesh


Hi Mukesh,

Probably, the solution to your problem is here:


Best regards,
Jorge
 

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



-----Inline Attachment Follows-----


_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Steve.Toutant | 1 Feb 15:39 2010
Picon

Re: Error Using WKTRASTER!


I didn't use fw tools.

I have installed python 2.6 and python gdal package (see bottom of this page)
http://pypi.python.org/pypi/GDAL/

You might need numpy as well
http://sourceforge.net/projects/numpy/

Hope this help,
Steve

 




mukesh karanwal <mukesh_karanwal <at> yahoo.com> <at> postgis.refractions.net
Envoyé par : postgis-users-bounces <at> postgis.refractions.net

01/02/2010 05:06 AM

Veuillez répondre à
PostGIS Users Discussion <postgis-users <at> postgis.refractions.net>

A
PostGIS Users Discussion <postgis-users <at> postgis.refractions.net>
cc
Objet
Re: [postgis-users] Error Using WKTRASTER!







Yeah, I had gone through this article and installed FW Tools still the problem remains the same!!
do i need to change the system path and Gdal_Data variables again?


--- On Mon, 2/1/10, Jorge Arévalo <jorge.arevalo <at> gmail.com> wrote:

From: Jorge Arévalo <jorge.arevalo <at> gmail.com>
Subject: Re: [postgis-users] Error Using WKTRASTER!
To: "PostGIS Users Discussion" <postgis-users <at> postgis.refractions.net>
Date: Monday, February 1, 2010, 12:33 PM

On Mon, Feb 1, 2010 at 6:49 AM, mukesh karanwal <mukesh_karanwal <at> yahoo.com> wrote:
Hi,
 
I am trying to load raster data (Goetiff file) using "wktRaster" with the following command:
 
C:\Program Files\..\..>gdal2wktraster.py -r utmfile.tif -t utmtable -o utmfile.sql
As i execute this command from command prompt, it gives the following error:
 
File "C:\Program Files\..\..>gdal2wktraster.py" , line 32, in <module>
        from osgeo import gdal
        import error: no module named osgeo
 
I am having Python 2.5 with
system path: C:\gdalwin32-1.6\bin
GDAL_DATA:  C:\gdalwin32-1.6\data
 
how can i get rid of this error and store geotiff file in postgresql ?
 
 
With Regards,
Mukesh



Hi Mukesh,

Probably, the solution to your problem is here:

http://lists.osgeo.org/pipermail/gdal-dev/2009-December/022916.html

Best regards,
Jorge
 

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



-----Inline Attachment Follows-----

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Gmane