04-19-2019 01:22 AM
I have to build an application, using FA.
I have some polygons, for each polygon one value per month (from the 2013 to the 2019).
What is the best way to store this information in the database (Postgis) ?
I remember on the BI application (on Amazon) I had one geojson for the geometries and one csv with time info. Do I have to use a similar way?
One table with the geometries and one table with the attributes?
a month ago
I wasn't clear on this question and at first read I actually thought 'FA' meant functiontal attributes, which is entirely possible in Analyzer Views.
In this case the 'best' way to store time attributes is going to be dependent on your specific case/desire. I think it is a subjective question that is tough for another to answer.
In any case at least I can tell you that you need not separate geometry and attributes when using Analzyer Views. Many of the charts in Analyzer Views are designed to work with Time/Date attribute values within the Feature Data table.