[postgis-users] help setting up postgis

[Jan Saalbach]

Nicolas, thank you for your help. I have imported a set of points  
using a python to psql script which filled a GeometryColumn using the  
ST_MakePoint() function.

Now I would like to visualize the points using uDig. Since the set  
imported is comprised of around 10 million points, drawing each point  
is not possible. What I would like to do is create and just draw a  
bounding box of the set of points. This way I could compare it to  
another set of points in respect of the position to each other.

The thing I do not know yet is how to do it using postgis , i.e. which  
commands I need. Any tips on how I could go about visualizing two  
datasets of scattered points?

Regards,
Jan


> Hi,
>
> A 3D point seems to be the candidate.
> You could also keep x, y, z as numeric columns to perform some
> computation on the altitude, as postgis does not support 3d geometries
> in all its functions.
>
> You will be able to build the points using the st_makePoint(...) function.
>
> Nicolas