<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Those accessors would be useful; the
first or second. I am basically just trying to create a csv of
x,y,z,r,b,g out of all my pcpoints.<br>
<br>
On 11/17/2014 10:40 PM, Paul Ramsey wrote:<br>
</div>
<blockquote cite="mid:etPan.546acdc1.3a95f874.14ddc@Butterfly.local"
type="cite">
<style>body{font-family:Helvetica,Arial;font-size:13px}</style>
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px; color:
rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Not at the
moment, but I’ve had requests for some different kinds of
accessors, like </div>
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px; color:
rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br>
</div>
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px; color:
rgba(0,0,0,1.0); margin: 0px; line-height: auto;">PC_Get(pcpoint,
ARRAY[text]) -> ARRAY[double]</div>
<div id="bloop_sign_1416285543226777088" class="bloop_sign">
<title></title>
<div> <br>
</div>
<div>Or even </div>
<div><br>
</div>
<div>PC_Get(pcpatch, text) -> ARRAY[double]</div>
<div><br>
</div>
<div>Or (and i wonder if this is wise)</div>
<div><br>
</div>
<div>
<div>PC_Get(pcpatch, ARRAY[text]) -> ARRAY[ARRAY[double]]</div>
</div>
<div><br>
</div>
<div>Do you have any interest in that kind of thing?</div>
<div><br>
</div>
-- <br>
Paul Ramsey<br>
<a class="moz-txt-link-freetext" href="http://cleverelephant.ca">http://cleverelephant.ca</a>
<div><a class="moz-txt-link-freetext" href="http://postgis.net">http://postgis.net</a>
</div>
<script type="application/ld+json">
{
"@context": <a class="moz-txt-link-rfc2396E" href="http://schema.org">"http://schema.org"</a>,
"@type": "em",
"name": "John Doe",
"jobTitle": "Graduate research assistant",
"affiliation": "University of Dreams",
"additionalName": "Johnny",
"url": <a class="moz-txt-link-rfc2396E" href="http://www.example.com">"http://www.example.com"</a>,
"address": {
"@type": "PostalAddress",
"streetAddress": "1234 Peach Drive",
"addressLocality": "Wonderland",
"addressRegion": "Georgia"
}
}
</script> </div>
<br>
<p style="color:#000;">On November 17, 2014 at 7:49:48 PM, Ashley
Mort (<a moz-do-not-send="true"
href="mailto:ashley_c_mort@raytheon.com">ashley_c_mort@raytheon.com</a>)
wrote:</p>
<blockquote type="cite" class="clean_bq"><span>
<div bgcolor="#FFFFFF" text="#000000">
<div>
<title></title>
<div class="moz-cite-prefix">Ok thanks! That helps
alot. My higher precision is there if I use PC_Get. Is
there a more efficient way of querying other than:<br>
<br>
select PC_Get(PC_Explode(pa),'X'),
PC_Get(PC_Explode(pa),'Y'),
PC_Get(PC_Explode(pa),'Z'),
PC_Get(PC_Explode(pa),'Red'),
PC_Get(PC_Explode(pa),'Green'),
PC_Get(PC_Explode(pa),'Blue') from
sthelens4326 limit 100000;<br>
<br>
<br>
On 11/17/2014 5:50 PM, Paul Ramsey wrote:<br>
</div>
<blockquote
cite="mid:etPan.546a89d3.71f32454.14ddc@Butterfly.local"
type="cite">
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px;
color: rgba(0,0,0,1.0); margin: 0px; line-height:
auto;">
(a) you’ll want to use pc_get to actually get the
coordinate value
and confirm the precision, you might just be seeing a
text output
artifact as the json is written out</div>
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px;
color: rgba(0,0,0,1.0); margin: 0px; line-height:
auto;">
(b) you’ll want to check the pointcloud_formats entry
for this pcid
and see what the specified precision actually is</div>
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px;
color: rgba(0,0,0,1.0); margin: 0px; line-height:
auto;">
(c) looks like you’re storing far more precision than
you actually
need, if you reduced it appropriately, per what you
see in those
results (lots of 0’s after the 6th digit) you’ll save
lots of space
probably</div>
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px;
color: rgba(0,0,0,1.0); margin: 0px; line-height:
auto;">
<br>
</div>
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px;
color: rgba(0,0,0,1.0); margin: 0px; line-height:
auto;">
P.</div>
<div id="bloop_sign_1416268147267236864"
class="bloop_sign">
<div><br>
</div>
-- <br>
Paul Ramsey<br>
<a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://cleverelephant.ca">http://cleverelephant.ca</a>
<div><a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://postgis.net">http://postgis.net</a></div>
<script type="application/ld+json">
<![CDATA[
{
"@context": <a class="moz-txt-link-rfc2396E" href="http://schema.org"><a class="moz-txt-link-rfc2396E" href="http://schema.org">"http://schema.org"</a></a>,
"@type": "em",
"name": "John Doe",
"jobTitle": "Graduate research assistant",
"affiliation": "University of Dreams",
"additionalName": "Johnny",
"url": <a class="moz-txt-link-rfc2396E" href="http://www.example.com">"http://www.example.com"</a>,
"address": {
"@type": "PostalAddress",
"streetAddress": "1234 Peach Drive",
"addressLocality": "Wonderland",
"addressRegion": "Georgia"
}
}
]]>
</script></div>
<br>
<p style="color:#000;">On November 17, 2014 at 3:46:40
PM, Ashley
Mort (<a moz-do-not-send="true"
href="mailto:ashley_c_mort@raytheon.com">ashley_c_mort@raytheon.com</a>)
wrote:</p>
<blockquote type="cite" class="clean_bq">
<div>
<div><span>Can someone please help me figure out why
I am losing
coordinate<br>
precision when I use pdal's pgpoingcloud.writer
to write into
my<br>
Postgres DB?<br>
<br>
I have a .las file in epsg:4326 and when I put
it though my
pdal<br>
pipeline, I seem to lose precision (-122.1831470
will become
-112.183)<br>
when I query for it.<br>
<br>
Below is a sample point from my .las file, the
output I get
from<br>
querying postgres, and the pipeline file that I
used. Can anyone
point<br>
out what I'm doing wrong? Thanks!<br>
<br>
<br>
postgres@ubuntu:/home/stack/Downloads$ pdal info
st2-helens.las -p
5<br>
{<br>
"X": "-122.18314700000002",<br>
"Y": "46.238651000000004",<br>
"Z": "1161.8700000000001",<br>
"Intensity": "0",<br>
"ReturnNumber": "0",<br>
"NumberOfReturns": "0",<br>
"ScanDirectionFlag": "0",<br>
"EdgeOfFlightLine": "0",<br>
"Classification": "2",<br>
"ScanAngleRank": "0",<br>
"UserData": "0",<br>
"PointSourceId": "20",<br>
"Time": "0",<br>
"Red": "205",<br>
"Green": "205",<br>
"Blue": "185"<br>
}<br>
<br>
lidarimport=# select PC_AsText(PC_Explode(pa))
from sthelens4326
limit 10;<br>
pc_astext<br>
{"pcid":3,"pt":[-122.211,46.1886,1874.3,0,0,0,0,0,1,0,0,12,0,242,242,238,1.1605<br>
3e+007,0]}<br>
{"pcid":3,"pt":[-122.211,46.1886,1874.3,0,0,0,0,0,2,0,0,21,0,242,242,238,7.4041<br>
5e+006,0]}<br>
<br>
<?xml version="1.0" encoding="UTF-8"?><br>
<Pipeline version="1.0"><br>
<Writer
type="drivers.pgpointcloud.writer"><br>
<Option name="connection">dbname='lidar'
user='postgres'<br>
password='password'</Option><br>
<Option
name="table">StHelens4326</Option><br>
<Option name="srid">4326</Option><br>
<Filter type="filters.chipper"><br>
<Option name="capacity">400</Option><br>
<Filter type="filters.cache"><br>
<Reader type="drivers.las.reader"><br>
<Option
name="filename">st2-helens.las</Option><br>
<Option
name="spatialreference">EPSG:4326</Option><br>
</Reader><br>
</Filter><br>
</Filter><br>
</Writer><br>
</Pipeline><br>
<br>
--<br>
Ashley Mort<br>
Sr. Software Engineer<br>
Raytheon - Intelligence and Information Systems<br>
972-205-5165 (office)<br>
814-571-3039 (cell)<br>
<br>
_______________________________________________<br>
pdal mailing list<br>
<a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:pdal@lists.osgeo.org">pdal@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://lists.osgeo.org/mailman/listinfo/pdal">http://lists.osgeo.org/mailman/listinfo/pdal</a><br>
</span></div>
</div>
</blockquote>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Ashley Mort
Sr. Software Engineer
Raytheon - Intelligence and Information Systems
972-205-5165 (office)
814-571-3039 (cell)
</pre>
</div>
</div>
</span></blockquote>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Ashley Mort
Sr. Software Engineer
Raytheon - Intelligence and Information Systems
972-205-5165 (office)
814-571-3039 (cell)</pre>
</body>
</html>