[fdo-users] Re: Tool for editing f_ tables in SQL 2008?

[Dan Stoica]

Ø  Are they populated from some ENUMs, CONSTANTs or are they calculated somehow?

Yes, they are bitmapped values as follows:


a)      attributetype column stores the geometric type:

FdoGeometricType
enum FdoGeometricType
{
    /// Represents 0-dimensional geometric primitives, such as Points.
    FdoGeometricType_Point = 0x01,

    /// Represents 1 dimensional geometric primitives, such as Curves and Lines.
    FdoGeometricType_Curve = 0x02,

    /// Represents 2 dimensional geometric primitives, such as Polygons.
    FdoGeometricType_Surface = 0x04,

    /// Represents 3 dimensional geometric primitives, such as Cubes.
    FdoGeometricType_Solid = 0x08



b)  geometrytype column stores the geometry type:


enum FdoGeometryTypeHexCode
{
    FdoGeometryTypeHexCode_None              = 0x00020,
    FdoGeometryTypeHexCode_Point             = 0x00040,
    FdoGeometryTypeHexCode_LineString        = 0x00080,
    FdoGeometryTypeHexCode_Polygon           = 0x00100,
    FdoGeometryTypeHexCode_MultiPoint        = 0x00200,
    FdoGeometryTypeHexCode_MultiLineString   = 0x00400,
    FdoGeometryTypeHexCode_MultiPolygon      = 0x00800,
    FdoGeometryTypeHexCode_MultiGeometry     = 0x01000,
    FdoGeometryTypeHexCode_CurveString       = 0x02000,
    FdoGeometryTypeHexCode_CurvePolygon      = 0x04000,
    FdoGeometryTypeHexCode_MultiCurveString  = 0x08000,
    FdoGeometryTypeHexCode_MultiCurvePolygon = 0x10000,
};

Check for example how the geometrytype is computed from user's input:

FdoGeometricPropertyDefinition::SetSpecificGeometryTypes(FdoGeometryType *types, FdoInt32 length)


Regerds,
Dan.

From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Srecko Lipovsek
Sent: Tuesday, October 26, 2010 5:50 PM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] Re: Tool for editing f_ tables in SQL 2008?

Wow, thanks for quick answer ... and special for attached document ...

This document is very helpful and explain a lot.
I can't still figure out meaning of columns attributetype and geometrytype in table f_attributedefinition

Are they populated from some ENUMs, CONSTANTs or are they calculated somehow?

>From your document:
attributetype = FDO property type.
geometrytype = Detailed geometry types allowed for this column.

Here are some of the values from table f_atributedefinition from different databases
Works with

columntype

attributetype

geometrytype

Point

geometry

1

576

Point

geometry

1

64


Line or..

geometry

2

42112

Line or..

geometry

7

126912

Line or..

geometry

2

1152


Polygon or..

geometry

4

256

Polygon or..

geometry

4

84224


________________________________
Srecko Lipovsek
Kaliopa d.o.o., Ljubljana, Slovenija

________________________________
View this message in context: Re: Tool for editing f_ tables in SQL 2008?<http://osgeo-org.1803224.n2.nabble.com/Tool-for-editing-f-tables-in-SQL-2008-tp5673979p5676696.html>
Sent from the FDO Users mailing list archive<http://osgeo-org.1803224.n2.nabble.com/FDO-Users-f2048584.html> at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20101026/2918ce06/attachment-0001.html