Database Reference
In-Depth Information
echo $x of $total started. $f processing.
las2txt --parse xyzinrcpM -sep komma $f $f.csv
done
For Windows, we can accomplish this with PowerShell (a special thanks to Leland
Barnes for providing this approach), as follows:
$las = dir *.las
$x = 0
$las |foreach {
write-host ($x++) "of $($las.count) is
started. $($_.Name) is processing"
write-host "las2txt --parse xyzinrcpM -sep
komma $($_.name) $($_.basename).csv"
}
Note
Additional options for las2txt can be accessed by simply running the previous
command without any options.
Now that the data are in text format, available as
Comma Separated Values
(
CSVs
), loading them into PostgreSQL is easy. From within psql, we can use the
\copy
command to accomplish this, as follows:
\copy chp07.lidar from 'N2210595.las.csv' with
csv
\copy chp07.lidar from 'N2215595.las.csv' with
csv
\copy chp07.lidar from 'N2220595.las.csv' with
csv
Now,thedataareinourdatabase,buttheyareonlyimplicitlyspatialdata.Let'smake
this explicit by executing the following commands:
