Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Oct 23 21:48
    m-kuhn synchronize #112
  • Oct 23 21:38
    m-kuhn synchronize #112
  • Oct 23 21:30
    m-kuhn synchronize #112
  • Oct 23 21:08
    m-kuhn synchronize #112
  • Oct 23 21:06
    m-kuhn synchronize #112
  • Oct 23 20:59
    m-kuhn commented #526
  • Oct 23 20:55

    m-kuhn on main_wastewater_node

    (compare)

  • Oct 23 20:54

    m-kuhn on master

    Add main wastewater node to was… Set a default main_wastewater_n… Fix relation in delta and 4 more (compare)

  • Oct 23 20:54
    m-kuhn closed #111
  • Oct 23 20:48
    m-kuhn synchronize #111
  • Oct 23 20:48

    m-kuhn on main_wastewater_node

    Fix main wastewater node migrat… (compare)

  • Oct 23 18:53

    qgep-ninja on gh-pages

    Automatic update from https://g… (compare)

  • Oct 22 19:56
    urskaufmann commented #104
  • Oct 22 08:42
  • Oct 22 08:40
    m-kuhn synchronize #44
  • Oct 22 08:33
    m-kuhn opened #44
  • Oct 22 08:22
  • Oct 22 08:08
    urskaufmann commented #104
  • Oct 22 07:32
    m-kuhn commented #104
  • Oct 22 06:15
    urskaufmann commented #104
Tudor Bărăscu
@tudorbarascu
This message was deleted
@m-kuhn Documents linked with relations update.
Matthias Kuhn
@m-kuhn
@tudorbarascu hi
is there a password set for the virtual machine?
Tudor Bărăscu
@tudorbarascu
@m-kuhn qgis is the pass, I think it's written in the docs
hi
Matthias Kuhn
@m-kuhn
thanks
is there a username as well?
(guiding somebody else remote :) )
oh, seems its documented
Tudor Bărăscu
@tudorbarascu
Tudor Bărăscu
@tudorbarascu
ping @m-kuhn
Tudor Bărăscu
@tudorbarascu
@m-kuhn are you around?
I'm trying to restore the latest qgep data model and I get pg_restore: [archiver (db)] Error from TOC entry 846; 1259 23699 MATERIALIZED VIEW vw_network_segment postgres pg_restore: [archiver (db)] could not execute query: ERROR: function st_curvetoline(public.geometry, integer) does not exist LINE 1: SELECT ST_CurveToLine($1, 32) ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. QUERY: SELECT ST_CurveToLine($1, 32) CONTEXT: SQL function "st_curvetoline" during inlining Command was: CREATE MATERIALIZED VIEW vw_network_segment AS WITH reach_parts AS ( SELECT row_number() OVER (ORDER BY od_reach_p... pg_restore: [archiver (db)] could not execute query: ERROR: relation "vw_network_segment" does not exist Command was: ALTER TABLE vw_network_segment OWNER TO postgres;
Matthias Kuhn
@m-kuhn
@tudorbarascu You need to update postgis, ST_CurveToLine is only available in newer postgis versions (2.3?)
Tudor Bărăscu
@tudorbarascu
Thanks for the info!
Tudor Bărăscu
@tudorbarascu
Interesting, I have Postgis 2.2.2 and the function is there. Maybe it has changed.
Tudor Bărăscu
@tudorbarascu
@m-kuhn I am recreating the VM. Should I also update the requirements in the docs to postgis 2.3?
Matthias Kuhn
@m-kuhn
Ah yes that would be nice
Tudor Bărăscu
@tudorbarascu
Ok, restoring went well. I'm trying to digitize a reach with QGIS 2.16 as soon as I press ok after completing the form I get Layer vw_qgep_reach: PostGIS error while adding features: ERROR: Geometry type (LineString) does not match column type (CompoundCurve)
@m-kuhn any ideas?
Matthias Kuhn
@m-kuhn
@tudorbarascu can you try to replace something in the .qgs file
<datasource>service='pg_qgep' key='"obj_id"' srid=21781 type=LineString table="qgep"."vw_qgep_reach" (progression_geometry) sql=</datasource>
<datasource>service='pg_qgep' key='"obj_id"' srid=21781 type=CompoundCurve table="qgep"."vw_qgep_reach" (progression_geometry) sql=</datasource>
Tudor Bărăscu
@tudorbarascu
It worked, will make a pull request if you haven't made a commit already.
Matthias Kuhn
@m-kuhn
Thanks for the feedback
Can you include some changes in the PR
Tudor Bărăscu
@tudorbarascu
Yes, what changes?
Matthias Kuhn
@m-kuhn
sed -i.bak 's/type=LineString/type=CompoundCurve/g'
sed -i.bak 's/type=Polygon/type=CurvePolygon/g'
In QGIS turn off provider side simplification for all line and polygon layers
Tudor Bărăscu
@tudorbarascu
I guess I should also add to the docs that QGIS provider side simplification for all line and polygon layers should be turned off?
Matthias Kuhn
@m-kuhn
That cannot hurt.
I think it should be fixed in QGIS (it shouldn't try to simplify curve postgis layers)
That's what triggered qgis/QGIS#3325 but that cannot be merged into 2.18
Tudor Bărăscu
@tudorbarascu
@m-kuhn Thanks for all the help.
Can you please tell me what qgep_en.qgs.cfg and qgep_en_webmap.qgs are for?
qgep_en.qgs.cfg has:
Matthias Kuhn
@m-kuhn
Oh, are they in the repo
they are used for a webmap
Tudor Bărăscu
@tudorbarascu
        "vw_qgep_reach": {
            "abstract": "", 
            "displayInLegend": "True", 
            "baseLayer": "False", 
            "noLegendImage": "False", 
            "id": "vw_qgep_reach", 
            "title": "vw_qgep_reach", 
            "singleTile": "True", 
            "geometryType": "line",
Should the geometry type also change?
Matthias Kuhn
@m-kuhn
Nothing to change there
Tudor Bărăscu
@tudorbarascu
ok, for the webmap thought? I suppose the same changes should go there, right?
I mean, should I simply ignore them or do that same?
Matthias Kuhn
@m-kuhn
I wouldn't change them
As long as they don't make trouble
Tudor Bărăscu
@tudorbarascu
ok, cool!
Tudor Bărăscu
@tudorbarascu
@m-kuhn Do you use any specific version of QGIS for QGEP? I'm trying to use a digitize a drainage channel action for the first time but I get ```
An error occurred during execution of following code:
import qgepplugin

feature = QgsMapLayerRegistry.instance().mapLayer('od_wastewater_structure').getFeatures( QgsFeatureRequest().setFilterExpression( 'obj_id = \'{}\''.format( '' ) ) ).next()
qgepplugin.ui.forms.digitizeDrainageChannel(feature.id(), 'od_wastewater_structure')


traceback.print_exception() failed
On QGIS 2.16
Matthias Kuhn
@m-kuhn
2.16 looks ok
In the python console
QgsMapLayerRegistry.instance().mapLayer('od_wastewater_structure')
Does that work?