Hi Raymond, Thx for your hints. We tried with copy/pasting, at least with more than one object it is very buggy, and often crashes QGIS. Also, is there any way to do it and after pasting open the form, just like if you digitize/create a new object?
Considering the shape-files, for internal analysis you just choose "create temporary layer", but this always cuts the attribute-names for us, as if the temporary layer saves to shape-file. Maybe we will try to save every intermediate step to SQLite or sth. similar. What do you mean with "memory layer"? Thx for your support, Chris. Christian Schmidt Stv. Geschäftsleiter M.Sc. Photogrammetrie u. Geoinformatik Bahnhofstrasse 40 5401 Baden Telefon: +41 56 210 39 60 Mobile: +41 78 684 70 09 Email: [email protected] -----Ursprüngliche Nachricht----- Von: Qgis-user <[email protected]> Im Auftrag von Raymond Nijssen Gesendet: Freitag, 12. Oktober 2018 09:08 An: [email protected] Betreff: Re: [Qgis-user] "Create Object from geometry" Feature Hi Christian On 12-10-18 08:53, Schmidt Christian wrote: > Hello QGIS-community, > > We are quite new to working with PostGIS in QGIS 3.2.0, so we have > some usability-questions… > > In the Autodesk world (don't hit me 😉) there is a feature called > "create object from geometry". > What it does, is to create a new database-object from an existing > selected geometry. After creating the object you enter the attributes > needed and commit it to the database. > > Is there any similar feature in QGIS? Is there any possibility to > conviniently copy db-objects from table to table? I think you can set that db layer to editable and then copy-paste selected features from other layers to it. Attributes with the same field name and type will be copied, others you can enter by manually afterwards. > We tried db-manager, but it was just good for importing/exporting > data, though it's possible to import data from a temporary Qgis layer. > > But then we have problems with shortened attribute names in our > temporary layers. > So, is there any way to get/preserve long attribute-names in analysis? > For ex. If we use "union" or > "intersect" our input-attributes (from PostGIS) are shortened to > shape-file-limit (10 characters?) thus it's quite time-consuming to > get data back into the database. Don't use shapefiles for this, that is where the fild name length limit is. Try a memory layer instead. Or if you need to save is, try geopackage (gpkg). > > Thx for your worthy hints, best regards from switzerland. Good luck and regards from The Netherlands! :) Raymond > > *Christian Schmidt > *Stv. Geschäftsleiter** > > M.Sc. Photogrammetrie u. Geoinformatik > *neuesReLISLogo* > > Bahnhofstrasse 40 > > 5401 Baden > > Telefon: +41 56 210 39 60 > > Mobile: +41 78 684 70 09 > > Email: [email protected] <mailto:[email protected]> > > > > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > _______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
