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.
Userlevel 4
- 8178 replies
-
20 March 2014
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
Userlevel 4
+13
- Contributor
- 3726 replies
-
20 March 2014
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?
I'm sorry it's Post GIS not Postgres. I want the data in a spatial format only.
Userlevel 4
- 8178 replies
-
20 March 2014
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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.