Z.M. | 2 Mar 10:59 2009
Picon

Re: [pgsql-es-ayuda] instalar postgis

En Fri, 27 Feb 2009 16:32:41 -0300, Emanuel Calvo Franco <postgres.arg <at> gmail.com> escribió:

> 2009/2/27 Z.M. <nramire1 <at> rosario.gov.ar>:
>> Hola a todos. Estuve tratando de instalar postgis sobre postgresql
>> Instale postgresql desde el gestor de paquetes synaptic de la distribucion de debian.
>> al intentar instalar postgis me da el siguiente error:
>>
>> casa:/home/usuario# psql -version
>> psql: FATAL:  no existe la base de datos «root»
>> casa:/home/usuario# psql --version
>> psql (PostgreSQL) 8.1.11
>> incluye soporte para edición de línea de comandos
>> casa:/home/usuario# cd postgis-1.3.5
>> casa:/home/usuario/postgis-1.3.5# make # make install
>> ./configure
>> checking for gcc... gcc
>> checking for C compiler default output file name... a.out
>> checking whether the C compiler works... yes
>> checking whether we are cross compiling... no
>> checking for suffix of executables...
>> checking for suffix of object files... o
>> checking whether we are using the GNU C compiler... yes
>> checking whether gcc accepts -g... yes
>> checking for gcc option to accept ISO C89... none needed
>> checking for g++... g++
>> checking whether we are using the GNU C++ compiler... yes
>> checking whether g++ accepts -g... yes
>> checking whether ln -s works... yes
>> checking for iconv_open in -liconv... no
>> checking for libiconv_open in -liconv... no
(Continue reading)

Mark Cave-Ayland | 2 Mar 12:00 2009
Picon

Re: Stack Builder freezing on Windows

Jim Graham wrote:

Hi Jim,

> Mark,
> Thanks for the quick reply.  I searched my system and could not find a
> folder named "postgis_installer".  I tried using the "Stack Builder" from
> the "start" menu and received the following error shown in SBError_1.gif.
> If I click "Ignore" I receive the second error.  The log file is empty and
> the installer window then freezes.

As I mentioned before, it's in the local user's TEMP directory which 
should be under C:\Documents And Settings\<user>\Local Settings\Temp 
somewhere. In fact, you can see the directory path in your attached 
SBError_2.gif screenshot.

> The firewall was turned off through the installation of PostgreSQL and
> PostGIS.  I have not changed any of the installation or configuration files.
> 
> I just spent some time with one of our networking folks and he verified that
> the port was open and PostgreSQL is listening.  We tried repeatedly with
> different variations and were unable to get it to install.  One of the
> errors was that a template database already existing and it could not remove
> it.  We checked PostgreSQL and did not see a a template database (it was a
> new install of PostgreSQL.
> 
> I was writing up this email and walking back through the installation and it
> worked!  I ran the installer from the downloaded temp file
> ("postgis_1_3_5_pg83.exe") and without creating a spatial database.  I still
> received the SBError_1 and it did create a database.  If there is a new
(Continue reading)

Mark Cave-Ayland | 2 Mar 12:31 2009
Picon

Re: Error using PostGIS and GEOM

Giri wrote:

> Hi Mark,
> I am using the latest stable versions of Geoserver and PostGIS, the 
> installation looks good, no errors were reported.
> 
> Thanks!
> 
> Giri

Hi Giri,

I think that you may have to bring this up on the Geoserver mailing 
lists. The only way I can see this problem occurring is if Geoserver is 
configured to connect to the wrong database (i.e. one which is not 
PostGIS-enabled).

HTH,

Mark.

--

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Kevin Neufeld | 2 Mar 17:43 2009
Picon

Re: Error using PostGIS and GEOM

Just a random thought here.  Did you accidentally install PostGIS in a schema other than public?   If so, is
that schema 
on the search_path of the user you are using to connect within GeoServer?

Do you get the same answer when you do this from psql or PgAdminIII?
postgis=# select public.extent('POINT(0 0)');
     extent
--------------
  BOX(0 0,0 0)
(1 row)

Cheers,
Kevin

Giri wrote:
> Hi Mark,
> I am using the latest stable versions of Geoserver and PostGIS, the 
> installation looks good, no errors were reported.
> 
> Thanks!
> 
> Giri
> 
> On Fri, Feb 27, 2009 at 10:11 AM, Mark Cave-Ayland 
> <mark.cave-ayland <at> siriusit.co.uk 
> <mailto:mark.cave-ayland <at> siriusit.co.uk>> wrote:
> 
>     Giri wrote:
> 
>         Thanks for the response, mmm I am using Geoserver (version1.7.2)
(Continue reading)

Greg King | 2 Mar 23:06 2009

Postgis Spatial Interpolation

Hi,

I'm fairly new to postgis and spatial databases but have been very pleased with the results I'm getting from postgis to date.  One of my projects is using postgis to load weather data from a 0.5 x 0.5 degree lat/long grid.  I'm looking to  interpolate data values that fall between that grid point I have values for.  A bit of googling has revealed a number of applications that interface to postgis and can do what I need (eg GRASS), but I don't need their full functionality or the overhead of interfacing with them.  My project needs simply to return interpolated values to a web page and I would rather just have a pl/pgsql procedure that gives me interpolated values for a given point.  My initial thoughts are to feed the necessary point data from my database into a custom pl/R function and get R to interpolate the data for my point.  However, that is going to involve a fair amount of custom code and for me to learn more about R.  I don't want to reinvent the wheel, so I'd be grateful for any thoughts on solutions that meet my needs?

Thanks,

G

PS In my googling I also saw references to PGRaster, but it looks like that's still under consideration for development in postgis?

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Stephen Woodbridge | 2 Mar 23:52 2009

Re: Postgis Spatial Interpolation

Greg King wrote:
> Hi,
> 
> I'm fairly new to postgis and spatial databases but have been very 
> pleased with the results I'm getting from postgis to date.  One of my 
> projects is using postgis to load weather data from a 0.5 x 0.5 degree 
> lat/long grid.  I'm looking to  interpolate data values that fall 
> between that grid point I have values for.  A bit of googling has 
> revealed a number of applications that interface to postgis and can do 
> what I need (eg GRASS), but I don't need their full functionality or the 
> overhead of interfacing with them.  My project needs simply to return 
> interpolated values to a web page and I would rather just have a 
> pl/pgsql procedure that gives me interpolated values for a given point. 
>  My initial thoughts are to feed the necessary point data from my 
> database into a custom pl/R function and get R to interpolate the data 
> for my point.  However, that is going to involve a fair amount of custom 
> code and for me to learn more about R.  I don't want to reinvent the 
> wheel, so I'd be grateful for any thoughts on solutions that meet my needs?
> 
> Thanks,
> 
> G
> 
> PS In my googling I also saw references to PGRaster, but it looks like 
> that's still under consideration for development in postgis?

Hi Greg,

There a bunch of people here that can probably help. If you had a 
working function what would be some sample input and output you would 
expect and describe the process of computing it. We can probably work 
out the details of the math and code a pl/pgsql function.

-Steve
Paragon Corporation | 3 Mar 05:21 2009
Picon

RE: Postgis Spatial Interpolation

Greg,
 
What data format is your lat/long grid in?

From: postgis-users-bounces <at> postgis.refractions.net [mailto:postgis-users-bounces <at> postgis.refractions.net] On Behalf Of Greg King
Sent: Monday, March 02, 2009 5:06 PM
To: postgis-users <at> postgis.refractions.net
Subject: [postgis-users] Postgis Spatial Interpolation

Hi,

I'm fairly new to postgis and spatial databases but have been very pleased with the results I'm getting from postgis to date.  One of my projects is using postgis to load weather data from a 0.5 x 0.5 degree lat/long grid.  I'm looking to  interpolate data values that fall between that grid point I have values for.  A bit of googling has revealed a number of applications that interface to postgis and can do what I need (eg GRASS), but I don't need their full functionality or the overhead of interfacing with them.  My project needs simply to return interpolated values to a web page and I would rather just have a pl/pgsql procedure that gives me interpolated values for a given point.  My initial thoughts are to feed the necessary point data from my database into a custom pl/R function and get R to interpolate the data for my point.  However, that is going to involve a fair amount of custom code and for me to learn more about R.  I don't want to reinvent the wheel, so I'd be grateful for any thoughts on solutions that meet my needs?

Thanks,

G

PS In my googling I also saw references to PGRaster, but it looks like that's still under consideration for development in postgis?
_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Paragon Corporation | 3 Mar 05:29 2009
Picon

RE: Postgis Spatial Interpolation

I'm not sure if the RGDAL package would help you.
 
Here is a bit about it
 
 
I have a somewhat complex example that reads data from tiff files and inserts into the database.  Though work on the WKT Raster project may be right up your alley.
 
 
Hope that helps,
Regina

From: postgis-users-bounces <at> postgis.refractions.net [mailto:postgis-users-bounces <at> postgis.refractions.net] On Behalf Of Greg King
Sent: Monday, March 02, 2009 5:06 PM
To: postgis-users <at> postgis.refractions.net
Subject: [postgis-users] Postgis Spatial Interpolation

Hi,

I'm fairly new to postgis and spatial databases but have been very pleased with the results I'm getting from postgis to date.  One of my projects is using postgis to load weather data from a 0.5 x 0.5 degree lat/long grid.  I'm looking to  interpolate data values that fall between that grid point I have values for.  A bit of googling has revealed a number of applications that interface to postgis and can do what I need (eg GRASS), but I don't need their full functionality or the overhead of interfacing with them.  My project needs simply to return interpolated values to a web page and I would rather just have a pl/pgsql procedure that gives me interpolated values for a given point.  My initial thoughts are to feed the necessary point data from my database into a custom pl/R function and get R to interpolate the data for my point.  However, that is going to involve a fair amount of custom code and for me to learn more about R.  I don't want to reinvent the wheel, so I'd be grateful for any thoughts on solutions that meet my needs?

Thanks,

G

PS In my googling I also saw references to PGRaster, but it looks like that's still under consideration for development in postgis?
_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Jan Hartmann | 3 Mar 17:47 2009
Picon
Picon

Re: Postgis Spatial Interpolation

There is a second solution, PL/R: the complete R system embedded in a PostgreSQL server, exactly the other way round from RGdal. On Unix you have to compile it with PostgreSQL, about the same way as you include PostGIS. There are Windows executables for PostgreSQL with PostGIS and PostgreSQL with PL/R, but not a complete combined system, I believe, although that should not be difficult to produce. I do not know what is easier, working in the R environment and doing GIS with RGDAL, or working in PostGIS and doing statistics with PL/R. Probably both. I have done some work with PL/R, and I have been flabbergasterd (is that English?) with the power of such a combined system. Problem is, I just haven't enough time to really explore it. You need to know a little about many things: SQL, R, MapScript, a bit of JavaScript, and so forth, all quite complex languages, more complex than they look at first sight. I *do* know a little about all that, but then you need the time and concentration to actually do something useful with it. I don't think there is anyone near me here in Amsterdam who knows even as little as me, so Regina's page will really help me, there should be more of them (Regina's, I mean). 

Anyway, give it a try (www.joeconway.com).  Joe is one of the leading PostgreSQL developers, certainly on a par with Steve, Frank, Daniel and Paul,  and equally courteous and helpful as they always have been on his mailing list. I was surprised to see how small the code is, with which he linked those two massive Open Source packages. That alone is a triumph of Open Source.

Greetings from a cloudy Amsterdam (but spring is near).

Jan

Paragon Corporation wrote:
I'm not sure if the RGDAL package would help you.
 
Here is a bit about it
 
 
I have a somewhat complex example that reads data from tiff files and inserts into the database.  Though work on the WKT Raster project may be right up your alley.
 
 
Hope that helps,
Regina

From: postgis-users-bounces <at> postgis.refractions.net [mailto:postgis-users-bounces <at> postgis.refractions.net] On Behalf Of Greg King
Sent: Monday, March 02, 2009 5:06 PM
To: postgis-users <at> postgis.refractions.net
Subject: [postgis-users] Postgis Spatial Interpolation

Hi,

I'm fairly new to postgis and spatial databases but have been very pleased with the results I'm getting from postgis to date.  One of my projects is using postgis to load weather data from a 0.5 x 0.5 degree lat/long grid.  I'm looking to  interpolate data values that fall between that grid point I have values for.  A bit of googling has revealed a number of applications that interface to postgis and can do what I need (eg GRASS), but I don't need their full functionality or the overhead of interfacing with them.  My project needs simply to return interpolated values to a web page and I would rather just have a pl/pgsql procedure that gives me interpolated values for a given point.  My initial thoughts are to feed the necessary point data from my database into a custom pl/R function and get R to interpolate the data for my point.  However, that is going to involve a fair amount of custom code and for me to learn more about R.  I don't want to reinvent the wheel, so I'd be grateful for any thoughts on solutions that meet my needs?

Thanks,

G

PS In my googling I also saw references to PGRaster, but it looks like that's still under consideration for development in postgis? _______________________________________________ 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
marta vicente romero | 3 Mar 18:24 2009
Picon

I can't see the geometry column by console

Hello
 
I have a table with geographics dates
I can't see the geometry column in the console
however with a GIS or pgadmin it shows correctly ..
what is the problem?
 
with linux it shows, but I need work with windows 
 I do an text file whith  pg_dump ..
when I put this file in de BD by windows, it fails.
 
 
(sorry I don't speak English very well)

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

Gmane