Project database, cad, etc
Up to Coffee Corner
Can someone point me in the direction of how the openwind project data is stored. I am working on a PostGis based project database for wind farm civil design work - pretty similar. Can I piggy back on the openwind project database to share the shp files, turbine locations, etc?
Hi Doug,
At present its just a binary blob which contains all the data and settings for the project. openWind shares by supporting common file formats such as SHP, KML, ESRI and Idrisi grids etc.. I'm not sure what you need but I'm always open to supporting more compatibility between software.
Nick
Here's an example of what I am working on: PostgreSQL/PostGIS stores wind project data, shp file data, etc, plus common data like cost of foundation type A, etc. SQL queries generate cost or tabular reports for a given wind project. I'd like the workflow with Openwind, GIS and CAD to minimize the import/export of data. I'm not using GIS to edit, so pointing to shp files or PostGIS is basic; CAD data (Civil 3D) like roads gets exported to an xml, which I have to read back in to the db; for OpenWind, I'd be interested in getting a connection from my database to the data native to Openwind, for starters the turbine coordinates, once an optimization is run, to share with CAD & GIS, and the energy capture for reports. I'm no coder but am willing to do some script work. First checking to see what's feasible.
Thanks Nick,
Doug K krausepdx@gmail.com
You can output a turbine layout as either XML (KML), Esri Shape, or ASCII text by right clicking on the Sitelayer and choosing "export" so there is already output to GIS in that sense. Are you wanting to use openWind as a backend for your application? What is it you'd like to see? I don't really think that a database connection would be practical as openWind is far too configurable for there to be any common data structure. The whole point of openWind is that the user determines how the software is used and how the data is structured.
Nick