SciGRID Change Log ------------------ SciGRID version 0.2 (20.11.2015): What has changed since the release of SciGRID version 0.1? **removed** SciGRID/code/scigrid.sh: removed and only a makefile is now available, to avoid redundancy SciGRID/code/create_network_csv.py: psql tool is used for this task see makefile - fix osmosis filter: an improved osmosis filtering command is used, inspired by Jonas Hörsch (FIAS) - fix geometries: power lines that were splitted by osm2pgsql, are now connected by using the PostGIS function ST_Union() **improvements in SciGRID** exclude substation=transition in counting stations, these are substations that indicate transition between power line and power cable added SciGRID/data/03_network/vertices_ref_id.csvdata: used to update topology while the v_ids remain the same, but l_ids may change SciGRID/code/create_plots.py: • sorted legend entries, transmission line with dynamical coloring depending on the line's voltage level • corrected ratio height/width of the topology and landmass plot, • simplified border shape, done by exchanging the old gpx file (containing more than 250000 points) with a simplified one (containing 8000 points). For more details see UserGuide documentation page 42 in section: How to obtain gpx files? • make use of standard python package logging **improvements in the makefile** added options PGCLUSTER,PGPASS,RAM,CORES,TEMP folder instead of reading config.txt to define makefile variables, the default_config.mk contains now the variable definitions. It is included in the makefile (reason: remove redundancy) dependency tree build by milestones (database_import.done, abstraction.done) store the stdout in log files (osmosis.log, osm2pgsql.log, database.log, and abstraction.log) cleaned structure and messages **improvement in the topology** links: • added columns operator, name, ref, from relation • replaced geometry column with WKT_SRID_4326 text column which is the standard text format for EPSG:4326 projections • changed electrical assumption columns to a per unit format as suggested by Tom Brown (FIAS) • mapping: wires names format changed from text to integer values vertices: • added columns operator, name, ref • replaced geometry column with WKT_SRID_4326 text column which is the standard text format for EPSG:4326 projections • mapping: ‘sub_station’ and ‘station’ to substation links,vertices,vertices_ref_id: • output files renamed to .csvdata, ordering by l_id and v_id, encoding set to UTF8, delimiter is comma ‘,’ and quote char is single quote ‘ **added** • GUI_SciGRID.py: Excecution of SciGRID using a Graphical User Interface, asks the user if decisions are necessary via message boxes **documentation** • pyGUI documentation • How to get the gpx file for the landmass borders and simplify it for the plot • How to find postgis.sql and spatial_ref_sys.sql in section trouble shooting (relevant for PostGIS 1.5) SciGRID version 0.1 (15.06.2015) -Abstracts the OpenStreetMap power relations and produces a topological transmission network for Germany. -The relations considered are either constitutes of 2 substations or of 3 substations and a T-junction.