[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Raster2pgsql - preserving number of decimal places
From: Nick Ward <Nick.Ward () landmark ! co ! uk>
Date: 2016-09-26 12:36:36
Message-ID: HE1PR0502MB30041B7393AA39A59F4C9621DBCD0 () HE1PR0502MB3004 ! eurprd05 ! prod ! outlook ! com
[Download RAW message or body]
[Attachment #2 (text/plain)]
Thank you Mateusz for the suggestion.
I sort of assumed I could do it via the select but was hoping to be able to load the \
exact values as rounding may not give the correct result.
Can anyone let me know what I am doing wrong or if this is just not achievable?
Regards
Nick
From: postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] On Behalf Of \
Mateusz Loskot
Sent: 24 September 2016 22:11
To: PostGIS Users Discussion <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] Raster2pgsql - preserving number of decimal places
On 24 Sep 2016 22:56, "Nick Ward" \
<Nick.Ward@landmark.co.uk<mailto:Nick.Ward@landmark.co.uk>> wrote:
>
> SELECT filename, rid, ST_Value(rast, pt.geom) As val
round(ST_Value(...), 2)
--
Mateusz Łoskot
Registered Office: 7 Abbey Court, Eagle Way, Sowton, Exeter, Devon, EX2 7HY. \
Registered Number 2892803 Registered in England and Wales. The information contained \
in this e-mail is confidential and may be subject to legal privilege. If you are not \
the intended recipient, you must not use, copy, distribute or disclose the e-mail or \
any part of its contents or take any action in reliance on it. If you have received \
this e-mail in error, please e-mail the sender by replying to this message. All \
reasonable precautions have been taken to ensure no viruses are present in this \
e-mail. Landmark Information Group Limited cannot accept responsibility for loss or \
damage arising from the use of this e-mail or attachments and recommend that you \
subject these to your virus checking procedures prior to use.
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Thank \
you Mateusz for the suggestion. <o:p></o:p></span></p>
<p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">I \
sort of assumed I could do it via the select but was hoping to be able to load the \
exact values as rounding may not give the correct result.<o:p></o:p></span></p>
<p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Can \
anyone let me know what I am doing wrong or if this is just not \
achievable?<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Nick<o:p></o:p></span></p>
<p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" \
style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span \
lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> \
postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] <b>On Behalf Of \
</b>Mateusz Loskot<br> <b>Sent:</b> 24 September 2016 22:11<br>
<b>To:</b> PostGIS Users Discussion <postgis-users@lists.osgeo.org><br>
<b>Subject:</b> Re: [postgis-users] Raster2pgsql - preserving number of decimal \
places<o:p></o:p></span></p> <p class="MsoNormal"><o:p> </o:p></p>
<p>On 24 Sep 2016 22:56, "Nick Ward" <<a \
href="mailto:Nick.Ward@landmark.co.uk">Nick.Ward@landmark.co.uk</a>> wrote:<br> \
><br> > SELECT filename, rid, ST_Value(rast, pt.geom) As val<o:p></o:p></p>
<p>round(ST_Value(...), 2)<o:p></o:p></p>
<p>-- <br>
Mateusz Łoskot<o:p></o:p></p>
</div>
Registered Office: 7 Abbey Court, Eagle Way, Sowton, Exeter, Devon, EX2 7HY. \
Registered Number 2892803 Registered in England and Wales. The information contained \
in this e-mail is confidential and may be subject to legal privilege. If you are not \
the intended recipient, you must not use, copy, distribute or disclose the e-mail or \
any part of its contents or take any action in reliance on it. If you have received \
this e-mail in error, please e-mail the sender by replying to this message. All \
reasonable precautions have been taken to ensure no viruses are present in this \
e-mail. Landmark Information Group Limited cannot accept responsibility for loss or \
damage arising from the use of this e-mail or attachments and recommend that you \
subject these to your virus checking procedures prior to use.
</body>
</html>
[Attachment #4 (unknown)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic