[postgis-users] Lon Lat Polygon Table Query

Wed Jun 13 14:58:27 PDT 2012

Hi James,

select * from tablex
where ST_Contains(poly,ST_Setsrid(ST_MakePoint(-120.00707803487512, 38.71309927715416),4326));

You need to convert you lat/lon numbers to a point geometry, then tell postgis what coordinate system this point uses (4326 = lat/lon WGS84), then return the containing polygons.

You might find useful hints on the BostonGis website, eg: 

http://www.bostongis.com/postgis_quickguide_1_5.bqg

HTH,

  Brent Wood

--- On Thu, 6/14/12, james butler <butler.james1 at gmail.com> wrote:

From: james butler <butler.james1 at gmail.com>
Subject: [postgis-users] Lon Lat Polygon Table Query
To: postgis-users at postgis.refractions.net
Date: Thursday, June 14, 2012, 8:18 AM

What is the proper snytax to query a table with a geom column?
Select * 
From TableX 
Where lon lat  =  (-120.00707803487512, 38.71309927715416)

I need to get the record details of the polygon where this coordinate is located.

On Wed, Jun 13, 2012 at 12:00 PM, <postgis-users-request at postgis.refractions.net> wrote:

Send postgis-users mailing list submissions to
       postgis-users at postgis.refractions.net

To subscribe or unsubscribe via the World Wide Web, visit
       http://postgis.refractions.net/mailman/listinfo/postgis-users

or, via email, send a message with subject or body 'help' to
       postgis-users-request at postgis.refractions.net

You can reach the person managing the list at

       postgis-users-owner at postgis.refractions.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of postgis-users digest..."

Today's Topics:

  1. Re: postgresql backup (Gold, Jack L  (US SSA))
  2. Re: row-wise geometry intersecting (Puneet Kishor)
  3. Re: row-wise geometry intersecting (Stephen Woodbridge)
  4. Re: row-wise geometry intersecting (Brent Fraser)

  5. Import excel file to postgresql (Jos? Mar?a Amuedo)
  6. Re: Import excel file to postgresql (Pedro Costa)
  7. Re: Import excel file to postgresql (Horst D?ster)
  8. Re: Import excel file to postgresql (Ralf Suhr)

  9. Re: Import excel file to postgresql (Jos? Mar?a Amuedo)
 10. Re: Import excel file to postgresql (Pedro Costa)
 11. Re: Import excel file to postgresql (Jos? Mar?a Amuedo)
 12. Re: Import excel file to postgresql (Pedro Costa)

 13. How does ST_Slope works ? (Francois Hugues)

----------------------------------------------------------------------

Message: 1
Date: Tue, 12 Jun 2012 15:15:07 -0400
From: "Gold, Jack L  (US SSA)" <jack.gold at baesystems.com>

Subject: Re: [postgis-users] postgresql backup
To: Greg Williamson <gwilliamson39 at yahoo.com>, PostGIS Users
       Discussion      <postgis-users at postgis.refractions.net>

Message-ID: <20120612191305.B1389CC844A at lists.refractions.net>
Content-Type: text/plain; charset="iso-8859-1"

In addition, postgis has a perl script (postgis_restore.pl) for handling restores of the custom hard dump described in the postgreSQL manual.

First dump the old db: pg_dump -Fc MYDB > MYDB.dmp

Then  build your new DB, install PostGIS, install topology and/or raster if you are using them, and finally pass the MYDB.dmp file to the perl script.

createdb MYDB
psql -f postgis/postgis.sql
psql -f topology/topology.sql
psql -f raster/raster.sql
 postgis_restore.pl MYDB.dmp | psql MYDB

The instructions are all in the script.

Jack Gold
BAE SYSTEMS

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Greg Williamson

Sent: Tuesday, June 12, 2012 2:56 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] postgresql backup

Sean --

Check the postgres manual for your version for details.

pg_dumpall -- used to backup an entire cluster (all databases); can be used to backup global info such as users / roles as well.

pg_dump -- used to backup a single database (no global info); like fumpall can be told to do schema only, data only, or both.

Both can output to a plain text SQL file that can be used to restore from the file, such as ?psql -d mynewdb < dump.sql

Both can output in compressed formats (highly desirable in some circumstances) which are then restored using pg_restore.

The manual will provide more details; try dumping to a text file first and study what it has. Then move to the more compressed formats.

You can use these to migrate to a new version of postgres; in that case you want to use the most recent version of pg_dump / restore to do the work. The newer versions know how to read older databases and collect all the needed data.

HTH,

Greg Williamson

ps the postgres admin mailing list might be a good place to ask more pointed questions since it has a lot of DBAs looking at it; this forum probably has more GIS types who may well rely on a regular DBA to do this sort of (necessary) work.

?

----- Original Message -----
> From: Sean Christopher Conway <seanc at backroadmapbooks.com>
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>

> Cc:
> Sent: Tuesday, June 12, 2012 10:10 AM
> Subject: [postgis-users] postgresql backup
>
>
> Hello, I am fairly new to POSTGIS and postgresql in general and am
> wondering if somebody can explain to me the best and most efficient

> way to backup and restore postgresql databases. Kind regards,
>
>
> Sean.
> _______________________________________________
> 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

------------------------------

Message: 2
Date: Tue, 12 Jun 2012 15:34:13 -0400
From: Puneet Kishor <punk.kish at gmail.com>
Subject: Re: [postgis-users] row-wise geometry intersecting

To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <7C1138FE-2FD4-4ADF-AD4C-E32A5782CB58 at gmail.com>

Content-Type: text/plain;       charset=us-ascii

On Jun 12, 2012, at 1:52 PM, Brent Fraser <bfraser at geoanalytic.com> wrote:

> SELECT image_id, ST_Intersection(wkb_geom_extent, wkb_geom_digitized) as image_area FROM v _images

The query looks fine, but what do you want to accomplish with it? It will give you the area of the intersection, if any.

>
> but I get an error:
>
> NOTICE:  TopologyException: side location conflict at -17.2242 79.1865

> ERROR:  GEOS Intersection() threw an error!
> ********** Error **********
> ERROR: GEOS Intersection() threw an error!
> SQL state: XX000

Ha! I got the same error the other day, and, iirc, it was because of the dreaded self-intersections.

--
Puneet Kishor
http://punkish.org

------------------------------

Message: 3
Date: Tue, 12 Jun 2012 15:52:40 -0400
From: Stephen Woodbridge <woodbri at swoodbridge.com>

Subject: Re: [postgis-users] row-wise geometry intersecting
To: postgis-users at postgis.refractions.net
Message-ID: <4FD79E08.9040906 at swoodbridge.com>

Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Brent,

select count(*) from v_images where not isvalid(wkb_geom_extent);

select count(*) from v_images where not isvalid(wkb_geom_extent) and not

isvalid(st_buffer(wkb_geom_extent, 0.0));

update v_images set wkb_geom_extent=st_buffer(wkb_geom_extent, 0.0)
 where not isvalid(wkb_geom_extent);

You might want to backup your table first. If the second query returns

zero then it should fix all the problems. You might want to get a list
of the invalid ones and check them against the buffered ones also.

-Steve

On 6/12/2012 1:52 PM, Brent Fraser wrote:
> Hi All,

>
> I've got a table (a view actually) with two multipolygon geometry
> columns: wkb_geom_extent and wkb_geom_digitized.
>
> They contain polygons representing the footprint of images and the areas

> digitized in the images.
>
> So the view looks like:
> v_images
> image_id: wkb_geom_extent: wkb_geom_digitized:
> 1 xxxxx xxxx
> 2 xxxxx
> 3 xxxxxx xxxxx
>
>

> I want to calculate the area digitized in each of the images and since
> some of the polygons representing the area digitized could have be
> sloppily defined to extend outside of the image footprint , I thought I

> would intersect the two geometries:
>
> SELECT image_id, ST_Intersection(wkb_geom_extent, wkb_geom_digitized) as
> image_area FROM v _images
>
> but I get an error:
>
> NOTICE: TopologyException: side location conflict at -17.2242 79.1865

> ERROR: GEOS Intersection() threw an error!
> ********** Error **********
> ERROR: GEOS Intersection() threw an error!
> SQL state: XX000
>
> This may be due to some problems in my geometries, but I thought I would

> check to see if my query was reasonable...
>
> Thanks!
>

------------------------------

Message: 4
Date: Tue, 12 Jun 2012 15:20:00 -0600
From: Brent Fraser <bfraser at geoanalytic.com>

Subject: Re: [postgis-users] row-wise geometry intersecting
To: postgis-users at postgis.refractions.net
Message-ID: <4FD7B280.8090000 at geoanalytic.com>

Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Steve,  Puneet,

  Sure enough, the "not isvalid()" query yields 65 (out of 138), and
the query with the "not is valid(st_buffer" returns 0 .  Looks like I've

got some polygon cleaning to do...

Many thanks!

Best Regards,
Brent Fraser

On 6/12/2012 1:52 PM, Stephen Woodbridge wrote:
> select count(*) from v_images where not isvalid(wkb_geom_extent);

------------------------------

Message: 5
Date: Wed, 13 Jun 2012 15:46:20 +0200
From: Jos? Mar?a Amuedo <jmamuedo at gmail.com>
Subject: [postgis-users] Import excel file to postgresql

To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID:
       <CANVkuyhafoCZNYFXYosszepBRMDHDQwa9VnJSMRSW8NNVyny8w at mail.gmail.com>

Content-Type: text/plain; charset="iso-8859-1"

Hi,

I would like to know how can import excel file to postgresql. I'm working
with linux OS.

Thanks
-------------- next part --------------

An HTML attachment was scrubbed...
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/3a537fc4/attachment-0001.html>

------------------------------

Message: 6
Date: Wed, 13 Jun 2012 14:49:01 +0100
From: Pedro Costa <pedrocostaarma at sapo.pt>
Subject: Re: [postgis-users] Import excel file to postgresql

To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <4FD89A4D.3040007 at sapo.pt>

Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"

Hi Jos?,

You have to convert the excel file to csv and use the copy command like
that:

copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV DELIMITER ';';

You have to create the table before and delete the column names of csv file.

Em 13-06-2012 14:46, Jos? Mar?a Amuedo escreveu:
> Hi,
>
> I would like to know how can import excel file to postgresql. I'm

> working with linux OS.
>
> Thanks
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net

> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...

URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/bd3ca761/attachment-0001.html>

------------------------------

Message: 7
Date: Wed, 13 Jun 2012 15:57:27 +0200
From: Horst D?ster <horst.duester at kappasys.ch>
Subject: Re: [postgis-users] Import excel file to postgresql

To: postgis-users at postgis.refractions.net
Message-ID: <4FD89C47.4050508 at kappasys.ch>
Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"

As an other option you can use an ETL-Tool like Talend OpenStudio [1] or
Geokettle [2]

Regards
Horst

[1] http://www.talend.com/index.php

[2] http://www.spatialytics.org/projects/geokettle/

Am 13.06.2012 15:46, schrieb Jos? Mar?a Amuedo:
> Hi,
>
> I would like to know how can import excel file to postgresql. I'm

> working with linux OS.
>
> Thanks
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net

> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...

URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/efe32bd6/attachment-0001.html>

------------------------------

Message: 8
Date: Wed, 13 Jun 2012 16:10:41 +0200
From: Ralf Suhr <Ralf.Suhr at itc-halle.de>
Subject: Re: [postgis-users] Import excel file to postgresql

To: postgis-users at postgis.refractions.net
Message-ID: <201206131610.41759.Ralf.Suhr at itc-halle.de>

Content-Type: text/plain; charset="iso-8859-15"

Hi Jos?,

ogr2org can import excel files for you. http://www.gdal.org/ogr/drv_xls.html

Or you compile gdal/ogr from svn then you can also import xlsx files.
http://www.gdal.org/ogr/drv_xlsx.html

Gr
Ralf

On Mittwoch 13 Juni 2012 15:46:20 Jos? Mar?a Amuedo wrote:

> Hi,
>
> I would like to know how can import excel file to postgresql. I'm working
> with linux OS.
>
> Thanks
-------------- next part --------------
An HTML attachment was scrubbed...

URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/ad17dc36/attachment-0001.html>

------------------------------

Message: 9
Date: Wed, 13 Jun 2012 16:34:37 +0200
From: Jos? Mar?a Amuedo <jmamuedo at gmail.com>
Subject: Re: [postgis-users] Import excel file to postgresql

To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID:
       <CANVkuygfgDQyVbmw2GjqnCv6Y+M1iijtiHVc5Ox-VStTS1YBSg at mail.gmail.com>

Content-Type: text/plain; charset="iso-8859-1"

I obtened this error:

RROR: extra data after last expected column
SQL state: 22P04
Context: COPY nueva, line 1:
"CODIGO;TIPO;DESCRIPCION;REPRESENTACION;PERFIL;CLAVE;VER3D;CARACBUSQ;LETRA;CAPITULO;SUBCAPITULO;ESTA;..."

2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt>

>  Hi Jos?,
>
> You have to convert the excel file to csv and use the copy command like
> that:

>
>
> copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV DELIMITER ';';
>
>
> You have to create the table before and delete the column names of csv
> file.

>
>
>
>
> Em 13-06-2012 14:46, Jos? Mar?a Amuedo escreveu:
>
> Hi,
>
> I would like to know how can import excel file to postgresql. I'm working
> with linux OS.

>
> Thanks
>
>
> _______________________________________________
> postgis-users mailing listpostgis-users at postgis.refractions.nethttp://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
>
>
-------------- next part --------------

An HTML attachment was scrubbed...
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/5cf0b5b6/attachment-0001.html>

------------------------------

Message: 10
Date: Wed, 13 Jun 2012 15:38:46 +0100
From: Pedro Costa <pedrocostaarma at sapo.pt>
Subject: Re: [postgis-users] Import excel file to postgresql

To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <4FD8A5F6.9020008 at sapo.pt>

Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"

Send me a sample of your file. But you have to remove the last semicolon.

Your file have to be like that:

column1;column2;column3;333333.3333

column1_r2;column2_r2;column3_r2;333333.3333

Em 13-06-2012 15:34, Jos? Mar?a Amuedo escreveu:
> I obtened this error:
>
> RROR: extra data after last expected column
> SQL state: 22P04

> Context: COPY nueva, line 1:
> "CODIGO;TIPO;DESCRIPCION;REPRESENTACION;PERFIL;CLAVE;VER3D;CARACBUSQ;LETRA;CAPITULO;SUBCAPITULO;ESTA;..."
>
> 2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt

> <mailto:pedrocostaarma at sapo.pt>>
>
>     Hi Jos?,
>
>     You have to convert the excel file to csv and use the copy command
>     like that:

>
>
>     copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV
>     DELIMITER ';';
>
>
>     You have to create the table before and delete the column names of

>     csv file.
>
>
>
>
>     Em 13-06-2012 14:46, Jos? Mar?a Amuedo escreveu:
>>     Hi,
>>
>>     I would like to know how can import excel file to postgresql. I'm

>>     working with linux OS.
>>
>>     Thanks
>>
>>
>>     _______________________________________________
>>     postgis-users mailing list
>>     postgis-users at postgis.refractions.net  <mailto:postgis-users at postgis.refractions.net>

>>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>     _______________________________________________

>     postgis-users mailing list
>     postgis-users at postgis.refractions.net
>     <mailto: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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/197681ae/attachment-0001.html>

------------------------------

Message: 11
Date: Wed, 13 Jun 2012 16:50:30 +0200
From: Jos? Mar?a Amuedo <jmamuedo at gmail.com>
Subject: Re: [postgis-users] Import excel file to postgresql

To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID:
       <CANVkuygb1_cXoNT45yrS44QqgGk4qG9qnROvGYWwBnqxSn1Pcw at mail.gmail.com>

Content-Type: text/plain; charset="iso-8859-1"

this is my file

2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt>

>  Send me a sample of your file. But you have to remove the last semicolon.

>
> Your file have to be like that:
>
>
> column1;column2;column3;333333.3333
> column1_r2;column2_r2;column3_r2;333333.3333
>
>
>
>
> Em 13-06-2012 15:34, Jos? Mar?a Amuedo escreveu:

>
> I obtened this error:
>
> RROR: extra data after last expected column
> SQL state: 22P04
> Context: COPY nueva, line 1:
> "CODIGO;TIPO;DESCRIPCION;REPRESENTACION;PERFIL;CLAVE;VER3D;CARACBUSQ;LETRA;CAPITULO;SUBCAPITULO;ESTA;..."

>
> 2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt>
>
>>  Hi Jos?,
>>
>> You have to convert the excel file to csv and use the copy command like

>> that:
>>
>>
>> copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV DELIMITER ';';
>>
>>
>> You have to create the table before and delete the column names of csv

>> file.
>>
>>
>>
>>
>> Em 13-06-2012 14:46, Jos? Mar?a Amuedo escreveu:
>>
>> Hi,
>>
>> I would like to know how can import excel file to postgresql. I'm working

>> with linux OS.
>>
>> Thanks
>>
>>
>>  _______________________________________________
>> postgis-users mailing listpostgis-users at postgis.refractions.nethttp://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 listpostgis-users at postgis.refractions.nethttp://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
>
>
-------------- next part --------------

An HTML attachment was scrubbed...
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/d533754a/attachment-0001.html>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: elements.csv
Type: text/csv
Size: 34817 bytes
Desc: not available
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/d533754a/attachment-0001.bin>

------------------------------

Message: 12
Date: Wed, 13 Jun 2012 15:55:15 +0100
From: Pedro Costa <pedrocostaarma at sapo.pt>
Subject: Re: [postgis-users] Import excel file to postgresql

To: postgis-users at postgis.refractions.net
Message-ID: <4FD8A9D3.7050103 at sapo.pt>
Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"

Try with i sample attached.
be sure that your table must have columns according to the file

Em 13-06-2012 15:50, Jos? Mar?a Amuedo escreveu:
> this is my file
>
> 2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt

> <mailto:pedrocostaarma at sapo.pt>>
>
>     Send me a sample of your file. But you have to remove the last
>     semicolon.
>
>     Your file have to be like that:

>
>
>     column1;column2;column3;333333.3333
>     column1_r2;column2_r2;column3_r2;333333.3333
>
>
>
>
>     Em 13-06-2012 15:34, Jos? Mar?a Amuedo escreveu:
>>     I obtened this error:

>>
>>     RROR: extra data after last expected column
>>     SQL state: 22P04
>>     Context: COPY nueva, line 1:
>>     "CODIGO;TIPO;DESCRIPCION;REPRESENTACION;PERFIL;CLAVE;VER3D;CARACBUSQ;LETRA;CAPITULO;SUBCAPITULO;ESTA;..."

>>
>>     2012/6/13 Pedro Costa <pedrocostaarma at sapo.pt
>>     <mailto:pedrocostaarma at sapo.pt>>

>>
>>         Hi Jos?,
>>
>>         You have to convert the excel file to csv and use the copy
>>         command like that:
>>
>>
>>         copy table_name from 'C:\Users\TEMP\filename.csv' WITH CSV

>>         DELIMITER ';';
>>
>>
>>         You have to create the table before and delete the column
>>         names of csv file.
>>
>>
>>
>>

>>         Em 13-06-2012 14:46, Jos? Mar?a Amuedo escreveu:
>>>         Hi,
>>>
>>>         I would like to know how can import excel file to
>>>         postgresql. I'm working with linux OS.

>>>
>>>         Thanks
>>>
>>>
>>>         _______________________________________________
>>>         postgis-users mailing list
>>>         postgis-users at postgis.refractions.net  <mailto:postgis-users at postgis.refractions.net>

>>>         http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>>         _______________________________________________

>>         postgis-users mailing list
>>         postgis-users at postgis.refractions.net
>>         <mailto:postgis-users at postgis.refractions.net>

>>         http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>>

>>     _______________________________________________
>>     postgis-users mailing list
>>     postgis-users at postgis.refractions.net  <mailto:postgis-users at postgis.refractions.net>

>>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>     _______________________________________________

>     postgis-users mailing list
>     postgis-users at postgis.refractions.net
>     <mailto: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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/668603d2/attachment-0001.html>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: elements.csv
Type: text/csv
Size: 1464 bytes
Desc: not available
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/668603d2/attachment-0001.bin>

------------------------------

Message: 13
Date: Wed, 13 Jun 2012 19:31:02 +0200
From: "Francois Hugues" <hugues.francois at irstea.fr>
Subject: [postgis-users] How does ST_Slope works ?

To: <postgis-users at postgis.refractions.net>
Message-ID:
       <3CB901080554B04881D30F111F62D93001CD623E at nadia.grenoble.cemagref.fr>

Content-Type: text/plain; charset="us-ascii"

Hello list,

I have two (basics) questions about ST_Slope about somethings I don't
understand.

1. To know which Pixeltype I had to use, I tried to use st_bandpixeltype

which told me my pixels were 32BSI type but my results using this type
are 0 or 1 and if I try another type like 32BF, results seems to be more
useful. Does someone have an explanation about this weird difference ?

What is the unit used by st_slope ?

2. My raster is a tiled one and as you can see on both pictures,
ST_Slope gives no results for pixels located at the border of each tile.
I can understand it is impossible to find the slope for the pixels which

make the border of the raster, but is there not a way to have complete
results for the tile in the middle of the raster and thus use the
neighboring tiles.

Hugues.

-------------- next part --------------

An HTML attachment was scrubbed...
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/6181a3f0/attachment-0001.html>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: slopes32BSI.jpg
Type: image/jpeg
Size: 945220 bytes
Desc: slopes32BSI.jpg
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/6181a3f0/attachment-0002.jpg>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: slopes32BF.jpg
Type: image/jpeg
Size: 992566 bytes
Desc: slopes32BF.jpg
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20120613/6181a3f0/attachment-0003.jpg>

------------------------------

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net

http://postgis.refractions.net/mailman/listinfo/postgis-users

End of postgis-users Digest, Vol 124, Issue 13
**********************************************

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

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120613/63fd95bf/attachment.html>