Can I export MapInfo "styleitem" info to PostGIS?

[Tamas Szekeres]

Jacob,

Does it mean you have different styles per feature in most of your
mapinfo files? If you have only layer level styles then it would be
reasonable to extract the auto style information to the mapfile
configuration. Currently I'm not aware of any stardard that would
address storing the style info along with the data in the database
that could be officially supported by mapserver and OGR. For example
we could add support for parsing the OGR stylestring representation
from a feature attribute but it would be quite unefficient and slow.


Best regards,

Tamas



2007/10/11, Delfos, Jacob <Jacob.Delfos at maunsell.com>:
> Daniel,Flavio,
>
> Thanks for your replies. At least I know I won't have to bother pursuing
> that if it doesn't work.
> I may look into carrying color across. I tried using FME to get style
> across, but I probably did it wrong, because it came out empty.
>
> I'll look into whether I can write a script to assign colors
> automatically based on an attribute.
>
> Thanks,
>
> Jacob
>
>
>
> > -----Original Message-----
> > From: UMN MapServer Users List
> > [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of Daniel Morissette
> > Sent: 10 October 2007 21:08
> > To: MAPSERVER-USERS at LISTS.UMN.EDU
> > Subject: Re: [UMN_MAPSERVER-USERS] Can I export MapInfo
> > "styleitem" info to PostGIS?
> >
> > Flavio Hendry wrote:
> > > Hi Jacob
> > >
> > > I do not think that you could do that as the moment. FME
> > (www.safe.com)
> > > would bring the styles along to PostGIS. However there is no way to
> > > define any other STYLEITEM as "auto" at the moment.
> >
> > That's correct. The original plan was to eventually support binding
> > STYLEITEM to any attribute which would contain a style string in the
> > format that OGR produces/understands, but we never got to
> > that and only
> > STYLEITEM AUTO has been implemented.
> >
> > > "auto" is more or
> > > less limited to colors as far as I know.
> >
> > AUTO also supports mapping symbols, fonts and about anything
> > you find in
> > MapInfo symbology. You need to have the right entries in your fontset
> > and symbolset for the mapping to work. This should be covered
> > by the OGR
> > HowTo.
> >
> >
> > > Ideal would be something like
> > > COLORITEM pointing to a column containing RGB color info ...
> > >
> >
> > This is possible with v5.0, you'd use:
> >
> >     COLOR [mycolor]
> >
> > Where "mycolor" is the attribute name from the data source.
> > Color can be
> > given as a hex value (e.g. #FFFFFF) or an RGB triplet (e.g.
> > 255 255 255).
> >
> > The following properties can accept bindings in 5.0:
> >
> > * Style: angle, color, outlinecolor, size, symbol
> > * Label: angle, color, outlinecolor, size, font, priority
> >
> > That is the reason why LABELITEM, ANGLEITEM, etc were dropped in 5.0.
> > e.g. LABELITEM was replaced by "LABEL [mylabelitem]", etc.
> >
> > Daniel
> > --
> > Daniel Morissette
> > http://www.mapgears.com/
> >
>
> This email and any attachments are intended solely for the named recipient and are confidential. The copying or distribution of them or any information they contain by anyone other than the named recipient is prohibited. If you have received this document in error, please notify the sender and delete all copies from your computer system and destroy all hard copies. It is the recipient's responsibility to check this email and any attachments to this email for viruses before use.
>