tjh.dev
nixpkgs mirror (for testing)
github.com/NixOS/nixpkgs
nix
1CREATE EXTENSION pointcloud;
2CREATE EXTENSION pointcloud_postgis CASCADE;
3INSERT INTO pointcloud_formats
4(pcid, srid, schema) VALUES (
5 1,
6 4326,
7 '<?xml version="1.0" encoding="UTF-8"?>
8 <pc:PointCloudSchema xmlns:pc="http://pointcloud.org/schemas/PC/1.1"
9 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
10 <pc:dimension>
11 <pc:position>1</pc:position>
12 <pc:size>4</pc:size>
13 <pc:description>X coordinate as a long integer. You must use the
14 scale and offset information of the header to
15 determine the double value.</pc:description>
16 <pc:name>X</pc:name>
17 <pc:interpretation>int32_t</pc:interpretation>
18 <pc:scale>0.01</pc:scale>
19 </pc:dimension>
20 <pc:dimension>
21 <pc:position>2</pc:position>
22 <pc:size>4</pc:size>
23 <pc:description>Y coordinate as a long integer. You must use the
24 scale and offset information of the header to
25 determine the double value.</pc:description>
26 <pc:name>Y</pc:name>
27 <pc:interpretation>int32_t</pc:interpretation>
28 <pc:scale>0.01</pc:scale>
29 </pc:dimension>
30 <pc:dimension>
31 <pc:position>3</pc:position>
32 <pc:size>4</pc:size>
33 <pc:description>Z coordinate as a long integer. You must use the
34 scale and offset information of the header to
35 determine the double value.</pc:description>
36 <pc:name>Z</pc:name>
37 <pc:interpretation>int32_t</pc:interpretation>
38 <pc:scale>0.01</pc:scale>
39 </pc:dimension>
40 <pc:dimension>
41 <pc:position>4</pc:position>
42 <pc:size>2</pc:size>
43 <pc:description>The intensity value is the integer representation
44 of the pulse return magnitude. This value is optional
45 and system specific. However, it should always be
46 included if available.</pc:description>
47 <pc:name>Intensity</pc:name>
48 <pc:interpretation>uint16_t</pc:interpretation>
49 <pc:scale>1</pc:scale>
50 </pc:dimension>
51 <pc:metadata>
52 <Metadata name="compression">dimensional</Metadata>
53 </pc:metadata>
54 </pc:PointCloudSchema>'
55);