0

Asset properties question

Forum / Questions & Answers

We have a database monitoring solar PV generation. We have several inverters, each connected to several strings of solar panels. We want to monitor the output of each string of panels and compare against that string's peak output (a constant based on the highest value it achieved last summer).

I'm not sure where to put this Peak Outpu value or how to get it in there. It's an attribute of the PV string asset rather than of any real-time tag.

I was thinking of creating a 'String Properties' tag that just gets a token value each day and attaching the Peak Output value to a property in there (maybe along with some other asset-wide properties). But how do I create this tag? It's not created by the incoming data so I'd have to create it separately. Maybe from a dedicated CSV Collector? Or I store them in SQL?

Or is there a better way?

4 replies

null
    • smason
    • 4 days ago
    • Reported - view

    Hi ,

    CSV or SQL would make the most sense I think, whichever would easier to consume. I would place it in it's own DataSet as it's coming from a different source. If it is a String tag, then I would expect the architecture to be [Inverter].[String].[Panel] based upon your description.

    • alistair_frith
    • 4 days ago
    • Reported - view

    Thanks. I already have a little SQL data so I have created another collector connection to another table with a 'Properties' tag for each solar string. That tag then has all the static properties I need. This seems to work ok though it's a little awkward.

    The hierarchy I have is Site.Inverter.String. We don't collect any data on individual panels.

      • damon_vinciguerra.1
      • 3 days ago
      • Reported - view

       this use case is very intriguing to me. But I lost the thread of the conversation. If you don't mind, could you expand on your solution?

      You have a real-time tag for each string current. And now you have another tag for each string that is sourced from SQL. And the SQL tag has a property called Peak Output. What is the value of the SQL tag? How do you match the real-time tag to the SQL tag?

      • alistair_frith
      • 3 days ago
      • Reported - view

      Hi 

      This is a demo environment. We have MQTT data coming in from the inverters and solar PV strings.
       

      I am trying to also model some static asset data such as inverter make/model/capacity and solar PV string peak power. I come from a PI background where this would be modelled in AF as static element attributes.

      Separate to the MQTT data, and partly to play with other collectors, I had set up a SQL collector and I've just put the peak power of each string into a table with a name column of <Inverter>.<PV String>.Properties, a dummy value and all the PV String properties I want (including PeakPower) as extra columns. These are then matched to the correct solar string by the view.

      It seems to work but I don't know if it's the 'best' way. The views are supposed to be able to directly read properties from a SQL database but I've not been able to get that working. Canary are helping on that.

Login to reply

Content aside

print this pagePrint this page
  • 3 days agoLast active
  • 4Replies
  • 18Views
  • 3 Following