Re: [postgis-users] create table from existing raster table

2015-05-08 Thread Pierre Racine
What do you mean by "proper"? How is it? Your query should results in a raster 
column.

Pierre

From: postgis-users-boun...@lists.osgeo.org 
[postgis-users-boun...@lists.osgeo.org] On Behalf Of Ahmet Temiz 
[ahmettemi...@gmail.com]
Sent: Friday, May 08, 2015 8:33 AM
To: PostGIS Users Discussion; PostGIS Users Discussion
Subject: [postgis-users] create table from existing raster table

hello

I was wondering how we could create table from existing raster table ?

I tried:
create table newrastertable as select ST_Slope(rast) from existingDEMrastertable

​but I couldn't get proper raster table

how can we do that ?

regards​

--
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu




Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] Using ST_Slope in EPSG:4326

2015-05-08 Thread Pierre Racine
You have to project your raster wit ST_Transform() before calling ST_Slope().

You also have to ST_Union() your raster tiles before projecting it.

Pierre

From: postgis-users-boun...@lists.osgeo.org 
[postgis-users-boun...@lists.osgeo.org] On Behalf Of Ahmet Temiz 
[ahmettemi...@gmail.com]
Sent: Friday, May 08, 2015 5:00 AM
To: PostGIS Users Discussion; PostGIS Users Discussion
Subject: [postgis-users] Using ST_Slope in EPSG:4326

hello,

( sorry for previous untitled message)

How can we get correct values from ST_Slope, if raster table  is in EPSG:4326 ?
or
we have to transform dem table to metric projection.

please let me know

kind regards

--
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu




Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users


[postgis-users] create table from existing raster table

2015-05-08 Thread Ahmet Temiz
hello

I was wondering how we could create table from existing raster table ?

I tried:
create table newrastertable as select ST_Slope(rast) from
existingDEMrastertable

​but I couldn't get proper raster table

how can we do that ?

regards​

-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu




Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] Quick/unobstrusive way to determine if a geometry has curve elements?

2015-05-08 Thread Andrea Aime
Hi,
just to be on the safe side, I've opened both:
http://trac.osgeo.org/postgis/ticket/3112
http://trac.osgeo.org/postgis/ticket/3113

Cheers
Andrea


On Thu, May 7, 2015 at 3:34 PM, Andrea Aime 
wrote:

> On Thu, May 7, 2015 at 3:26 PM, Sandro Santilli  wrote:
>
>> I meant it is a feature request to have ST_Simplify support curve types.
>>
>
> Ah, but I'm not really interested in this one.
>
>
>> The list of functions supposedly supporting cuve types are here:
>>
>> http://postgis.net/docs/PostGIS_Special_Functions_Index.html#PostGIS_Curved_GeometryFunctions
>>
>> I don't think any of them supports linear but curve-accepting types.
>>
>
> Right, this is the case that I'm after, I want to isolate geometries that
> will not
> be accepted by these functions. ST_HasArc almost does it, I want a function
> that does it fully
>
> Cheers
> Andrea
>
> --
> ==
> GeoServer Professional Services from the experts! Visit
> http://goo.gl/NWWaa2 for more information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39  339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
>
> Le informazioni contenute in questo messaggio di posta elettronica e/o
> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
> darcene notizia via e-mail e di procedere alla distruzione del messaggio
> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
> principi dettati dal D.Lgs. 196/2003.
>
>
>
> The information in this message and/or attachments, is intended solely for
> the attention and use of the named addressee(s) and may be confidential or
> proprietary in nature or covered by the provisions of privacy act
> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
> Code).Any use not in accord with its purpose, any disclosure, reproduction,
> copying, distribution, or either dissemination, either whole or partial, is
> strictly forbidden except previous formal approval of the named
> addressee(s). If you are not the intended recipient, please contact
> immediately the sender by telephone, fax or e-mail and delete the
> information in this message that has been received in error. The sender
> does not give any warranty or accept liability as the content, accuracy or
> completeness of sent messages and accepts no responsibility  for changes
> made after they were sent or for other risks which arise as a result of
> e-mail transmission, viruses, etc.
>
> ---
>



-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsib

[postgis-users] Using ST_Slope in EPSG:4326

2015-05-08 Thread Ahmet Temiz
hello,

( sorry for previous untitled message)

How can we get correct values from ST_Slope, if raster table  is in
EPSG:4326 ?
or
we have to transform dem table to metric projection.

please let me know

kind regards

-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu




Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[postgis-users] (no subject)

2015-05-08 Thread Ahmet Temiz
hello,

How can we get correct values from ST_Slope, if raster table  is in
EPSG:4326 ?
or
we have to transform dem table to metric projection.

please let me know

kind regards


-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu




Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users