…and data analysis
Sound data management and handling plays a significant role for subsequent processing, the use in applications, models or visualisations. Data often has to be formatted and transformed into a uniform type or meet defined standards. In addition, data needs to be structured, accessible and organised in a way allowing it to easily be linked to other related information, which maybe be of different type, such as spatial or aspatial (textual). The data organisation and linkages are performed through establishing and managing databases, ideally capable of also storing spatial data.
Spatial Ventures has experience in working with a variety of relational database systems, conceptual tasks (EER), including the creation of spatial sql based queries and establishing data linkages, or relationships. Common systems we are familiar with are:
MS SqlServer, Postgres/Postgis, Esri Geodatabase, MS Access and MySql.Our proficiency of analysing and processing spatial and aspatial data is mostly performed with established GIS applications, and – often offering greater flexibility – opensource based solutions such as R, Gdal, or other python based libraries.