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

Srecko Lipovsek srecko.lipovsek at kaliopa.si
Tue Oct 26 17:50:09 EDT 2010


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: 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 at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20101026/73528eab/attachment.html


More information about the fdo-users mailing list