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

[Smith, Michael ERDC-CRREL-NH]

When I loaded into Oracle, I specified dim=2 so that is what got created.

Mike


On 8/13/10 10:23 AM, "Paul Ramsey" <pramsey at cleverelephant.ca> wrote:

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