[Benchmarking] 4-dimensional data in the postgis database?

[Andrea Aime]

Look here:

benchmarking=# select * from geometry_columns;
  f_table_catalog | f_table_schema |       f_table_name        | 
f_geometry_column | coord_dimension | srid |      type
-----------------+----------------+---------------------------+-------------------+-----------------+------+-----------------
                  | public         | ramp                      | 
the_geom          |               4 | 4326 | MULTILINESTRING
                  | public         | contour                   | 
the_geom          |               4 | 4326 | MULTILINESTRING
                  | public         | point_labels_for_geometry | 
the_geom          |               4 | 4326 | POINT
                  | public         | building                  | 
the_geom          |               4 | 4326 | MULTIPOLYGON
                  | public         | contour_0                 | 
the_geom          |               4 | 4326 | MULTILINESTRING
                  | public         | contour_1                 | 
the_geom          |               4 | 4326 | MULTILINESTRING
                  | public         | contour_2                 | 
the_geom          |               4 | 4326 | MULTILINESTRING
                  | public         | contour_3                 | 
the_geom          |               4 | 4326 | MULTILINESTRING
                  | public         | contour_4                 | 
the_geom          |               4 | 4326 | MULTILINESTRING
                  | public         | contour_5                 | 
the_geom          |               4 | 4326 | MULTILINESTRING
                  | public         | contour_6                 | 
the_geom          |               4 | 4326 | MULTILINESTRING
                  | public         | contour_7                 | 
the_geom          |               4 | 4326 | MULTILINESTRING
                  | public         | industry                  | 
the_geom          |               4 | 4326 | MULTIPOLYGON
                  | public         | motorway                  | 
the_geom          |               4 | 4326 | MULTILINESTRING
                  | public         | point_labels_no_geometry  | 
the_geom          |               4 | 4326 | POINT
                  | public         | road                      | 
the_geom          |               4 | 4326 | MULTILINESTRING
                  | public         | settlement                | 
the_geom          |               4 | 4326 | MULTIPOLYGON
                  | public         | track                     | 
the_geom          |               4 | 4326 | MULTILINESTRING
(18 rows)

benchmarking=# select ST_AsEWKT(the_geom) from contour_0 limit 1;
 
   st_asewkt

--------------------------------------------------------------------------------------------------------------------------------------------
----------------
  SRID=4326;MULTILINESTRING((2.47923685856342 42.3170588118108 -9999 
0,2.47924854799622 42.3171129031747 -9999 0,2.47923559621537 42.31721190
53844 -9999 0))
(1 row)

Ah hem... is this intended?

Cheers
Andrea

-- 
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.