Question
how to import the LIDAR data to postgres
Hi every one, i'm facing a problem while i'm trying to import the .LAZ fiel to Postgres DB. Workbench is showing only 1 feature was written to the database, where as the input file is having more. Log is also not showing any error. The data should be imported to Postgres with the data type "pcpatch". Please help me in this regard. Thanks in advance.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi,
I think we would need more info to help here.
What does the log say? Consider pasting the whole log into http://pastebin.com/ and posting the link here.
David
+21- Safer
Try coercing the LAZ with the PointCloudCoercer. Next to that the pcpatch is not registered in the readers and writers documnetation as a fieldtype, and so is the blob type for PostgresSQL, so I wonder if it will work at all....,let us know.
Just out of curiousity LAZ is one of the most efficient (if not the most efficient) spatial format for pointcloud data, why transform it into a non spatial db format?
Hi,
I look around on the net a bit, and it seems the PcPatch datatype isn't native in PostGIS, it looks like it's part of a 3rd party plugin (https://github.com/pramsey/pointcloud).
There is also no mention of this datatype in FME, so I would say it's a good probability that this isn't supported by FME.
Consider asking Safe support, tough.
David