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

[Smith, Michael ERDC-CRREL-NH]

Or I can reload the shapefiles to oracle.


On 8/13/10 2:11 PM, "Paul Ramsey" <pramsey at opengeo.org> wrote:

> Some of the features have legitimate 3d values...
> 
> select asewkt(the_geom) from building limit 1;
> 
>  SRID=4326;MULTIPOLYGON(((-8.40222993700407 42.8050499679355 206.8
> 0,-8.40236966889325 42.8050182858188 207.1 0,-8.40239837068399
> 42.8050859669865 207.1 0,-8.40226476888771 42.8051167890218 206.3
> 0,-8.40222993700407 42.8050499679355 206.8 0)))
> 
> Should I force mine down to 2D for consistency?
> P
> 
> On Fri, Aug 13, 2010 at 10:56 AM, Smith, Michael ERDC-CRREL-NH
> <michael.smith at usace.army.mil> wrote:
>> 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
>> 
>> _______________________________________________
>> 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