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

[Paul Ramsey]

It's what was provided... Not the best thing for performance, but everyone is on the same level, unless Oracle dropped those dimensions, heaven forfend. 

P.

On 2010-08-13, at 2:43 AM, Andrea Aime <aaime at opengeo.org> wrote:

> 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.
> 
> _______________________________________________
> Benchmarking mailing list
> Benchmarking at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/benchmarking