[QGIS-it-user] Surrogato di rasmover

[Marco Spaziani]

Considerato che il plugin Rasmover non è più disponibile nelle versioni
3.x, e considerato che non ci sono plugin "surrogati" di Rasmover, voi che
procedura usate per spostare "al volo" e "a mano" un raster? e che non
sia ovviamente lo strumento Georeferenziatore di QGIS ...lo strumento
Georeferenziatore è potentissimo per fare "spostamenti" con precisione
centimetrica ...io invece mi riferisco ad uno strumento grezzo, con ampio
margine d'errore, ma che ti consenta di avere uno spostamento "al volo"
(pur se non preciso ...insomma quello che faceva Rasmover). Ho letto che in
R dovrebbe esserci qualcosa, ma non ho padronanza di questo software che
"gira" su Processi di QGIS. Sempre in Processi di QGIS ho visto su SAGA su
GRASS e su GDAL, ma non mi sembra che ci sia niente di utile.
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] Read polygon attribute Table

[Nicolas Cadieux]

Hi,

I could only be of help if your are working outside the QGIS API.  I normally 
work with python directly for this stuff.  I would use a geopandas dataframe 
that can be easily created. Google Geopandas and you with find it in a flash. 

Nicolas Cadieux

> Le 23 sept. 2020 à 13:13, ming han  a écrit :
> 
> 
> Hi Nicolas 
> 
>Many thanks for your reply, would you please give me some specific 
> suggestions. Normally I can read the attribute table by reading the dbf 
> files. but this time I stored the vector object in memory, do not want to 
> save it to files.  
> I can only read the attribute of this vector object feature by feature. I 
> do not know how to read all attribute at once. 
>  Thanks
> Ming
> 
> Nicolas Cadieux  于2020年9月23日周三 下午12:03写道：
>> Hi,
>> 
>> More knowledgeable people than me surely  respond but are you looking for 
>> something like geopandas dataframe?  I image the QGIS API has something like 
>> this.
>> 
>> Nicolas Cadieux
>> 
>> > Le 23 sept. 2020 à 11:41, ming han  a écrit :
>> > 
>> > 
>> > Hi All
>> > 
>> > Is there a way to read the polygon attribute table at one time with 
>> > python. I notice that there are several ways to read it feature by 
>> > feature. 
>> > 
>> > Thanks
>> > Ming
>> > ___
>> > Qgis-user mailing list
>> > Qgis-user@lists.osgeo.org
>> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] PyQGIS: wipe all xyz connections

[1520 gis]

Hi Erich Purpur,

I am a Python coding beginner and made some changes according to your
reply. I have a XYZ connection for OpenStreetMap. But after hitting the
button wipeAllConnectionsXyz in a QGIS Plugin, I did not get any error
message, but the OSM connection was not removed. Find the code below:

def removeAllConnectionsXYZ(self):
s = QSettings()
xyz = 'qgis/connections-xyz'
groupsXYZ = s.childGroups()
for group in groupsXYZ:
s.beginGroup(xyz)
s.remove("")
s.endGroup()

self.dlg.wipeAllConnectionsXyz.clicked.connect(
self.removeAllConnectionsXYZ)

# Kind regards

# Julierme


On Wed, Sep 23, 2020 at 1:54 PM Erich Purpur  wrote:

> Is this regarding the following stackoverflow thread?
> https://gis.stackexchange.com/questions/374808/pyqt5-wipe-xyz-connections
>
> If so, your error message as you posted it in StackOverflow is:
> for group in getGroupXYZ(self): NameError: name 'getGroupXYZ' is not
> defined
>
> From what I gather in the code posted in SO, you are trying to iterate
> over getGroupXYZ(), which is a function. This is not an object which holds
> multiple items, which is the purpose of a loop. However, in your
> getGroupXYZ() function, you return an object called groupsXYZ. You should
> loop of the groupsXYZ object, not the function.
>
> -Erich
>
>
>
>
> On Wed, Sep 23, 2020 at 11:38 AM 1520 gis <
> juliermeopensourcedevelo...@gmail.com> wrote:
>
>> Dear all,
>>
>> I am writing a PyQT5 QGIS Plugin to wipe out all xyz connections
>> available in QGS projects.
>>
>> I wrote the code below, but I am not achieving my goal and I did not
>> understand the structure of xyz connections.
>>
>> def removeAllConnectionsXYZ(self):
>> s = QSettings()
>> xyz = 'qgis/connections-xyz'
>> groupsXYZ = s.childGroups()
>>
>> for group in groupsXYZ:
>> s.beginGroup(xyz)
>> s.remove("")
>> s.endGroup()
>> self.dlg.wipeAllConnectionsXyz.clicked.connect(
>> self.removeAllConnectionsXYZ)
>>
>>
>>
>>
>> # Any comment will be very appreciated.
>>
>> #Thank you for your time in advance
>>
>> #Julierme
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Read polygon attribute Table

[ming han]

Hi Nicolas

   Many thanks for your reply, would you please give me some specific
suggestions. Normally I can read the attribute table by reading the dbf
files. but this time I stored the vector object in memory, do not want to
save it to files.
I can only read the attribute of this vector object feature by feature.
I do not know how to read all attribute at once.
 Thanks
Ming

Nicolas Cadieux  于2020年9月23日周三 下午12:03写道：

> Hi,
>
> More knowledgeable people than me surely  respond but are you looking for
> something like geopandas dataframe?  I image the QGIS API has something
> like this.
>
> Nicolas Cadieux
>
> > Le 23 sept. 2020 à 11:41, ming han  a écrit :
> >
> > 
> > Hi All
> >
> > Is there a way to read the polygon attribute table at one time with
> python. I notice that there are several ways to read it feature by feature.
> >
> > Thanks
> > Ming
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] PyQGIS: wipe all xyz connections

[Erich Purpur]

Is this regarding the following stackoverflow thread?
https://gis.stackexchange.com/questions/374808/pyqt5-wipe-xyz-connections

If so, your error message as you posted it in StackOverflow is:
for group in getGroupXYZ(self): NameError: name 'getGroupXYZ' is not defined

>From what I gather in the code posted in SO, you are trying to iterate over
getGroupXYZ(), which is a function. This is not an object which holds
multiple items, which is the purpose of a loop. However, in your
getGroupXYZ() function, you return an object called groupsXYZ. You should
loop of the groupsXYZ object, not the function.

-Erich




On Wed, Sep 23, 2020 at 11:38 AM 1520 gis <
juliermeopensourcedevelo...@gmail.com> wrote:

> Dear all,
>
> I am writing a PyQT5 QGIS Plugin to wipe out all xyz connections available
> in QGS projects.
>
> I wrote the code below, but I am not achieving my goal and I did not
> understand the structure of xyz connections.
>
> def removeAllConnectionsXYZ(self):
> s = QSettings()
> xyz = 'qgis/connections-xyz'
> groupsXYZ = s.childGroups()
>
> for group in groupsXYZ:
> s.beginGroup(xyz)
> s.remove("")
> s.endGroup()
> self.dlg.wipeAllConnectionsXyz.clicked.connect(
> self.removeAllConnectionsXYZ)
>
>
>
>
> # Any comment will be very appreciated.
>
> #Thank you for your time in advance
>
> #Julierme
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] PyQGIS: wipe all xyz connections

[Etienne Trimaille]

You need to clarify if you want to remove all layers based on XYZ which are
loaded in the current project
Or if you want to remove all XYZ connections which are in the Browser Panel?

It's two different things.

Le mer. 23 sept. 2020 à 17:39, 1520 gis <
juliermeopensourcedevelo...@gmail.com> a écrit :

> Dear all,
>
> I am writing a PyQT5 QGIS Plugin to wipe out all xyz connections available
> in QGS projects.
>
> I wrote the code below, but I am not achieving my goal and I did not
> understand the structure of xyz connections.
>
> def removeAllConnectionsXYZ(self):
> s = QSettings()
> xyz = 'qgis/connections-xyz'
> groupsXYZ = s.childGroups()
>
> for group in groupsXYZ:
> s.beginGroup(xyz)
> s.remove("")
> s.endGroup()
> self.dlg.wipeAllConnectionsXyz.clicked.connect(
> self.removeAllConnectionsXYZ)
>
>
>
>
> # Any comment will be very appreciated.
>
> #Thank you for your time in advance
>
> #Julierme
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Read polygon attribute Table

[Nicolas Cadieux]

Hi,

More knowledgeable people than me surely  respond but are you looking for 
something like geopandas dataframe?  I image the QGIS API has something like 
this.

Nicolas Cadieux

> Le 23 sept. 2020 à 11:41, ming han  a écrit :
> 
> 
> Hi All
> 
> Is there a way to read the polygon attribute table at one time with 
> python. I notice that there are several ways to read it feature by feature. 
> 
> Thanks
> Ming
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Read polygon attribute Table

[ming han]

Hi All

Is there a way to read the polygon attribute table at one time with
python. I notice that there are several ways to read it feature by feature.

Thanks
Ming
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] PyQGIS: wipe all xyz connections

[1520 gis]

Dear all,

I am writing a PyQT5 QGIS Plugin to wipe out all xyz connections available
in QGS projects.

I wrote the code below, but I am not achieving my goal and I did not
understand the structure of xyz connections.

def removeAllConnectionsXYZ(self):
s = QSettings()
xyz = 'qgis/connections-xyz'
groupsXYZ = s.childGroups()

for group in groupsXYZ:
s.beginGroup(xyz)
s.remove("")
s.endGroup()
self.dlg.wipeAllConnectionsXyz.clicked.connect(
self.removeAllConnectionsXYZ)




# Any comment will be very appreciated.

#Thank you for your time in advance

#Julierme
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Reliable geocoding alternative?

[Nicolas Cadieux]

Hi,
Do you have coordinates (x,y) in that csv?  You can generate the geometries 
from that.  If not, you will need to find a database for that. What were you 
planing on using for the geospatial info?

Nicolas Cadieux

> Le 23 sept. 2020 à 10:17, Erich Purpur  a écrit :
> 
> 
> Thank you again for your response. I understand what you suggest but it won't 
> work in this case unfortunately. 
> 
> I only have a .csv file, which has an address and all the other information 
> too. There is no other layer.
> 
> -Erich
> 
>> On Wed, Sep 23, 2020 at 10:12 AM Nicolas Cadieux 
>>  wrote:
>> 
>> Hi,
>> 
>> To do this, you need two files. If they are csv, you can use that.  If you 
>> are limited in what you can do, just save a geopackage.  You will need one 
>> file with the addresses (that you have) and one file, or a data base with 
>> the georeferenced information.  Do you have that? If not what where you 
>> planing to use to find the geographic positions of the objects?
>> 
>> A csv is a vector layer if it’s georeferenced or a database if it’s not.  
>> You may be limited in what you can do but export it to a for at that QGIS 
>> can write to like geopackage or SpatiaLite which is the same thing but with 
>> not spatial info.
>> 
>> Nicolas Cadieux
>> 
>>> Le 23 sept. 2020 à 08:52, Erich Purpur  a écrit :
>>> 
>>> 
>>> Hi Nicolas-
>>> 
>>> The issue is that I have data in a .csv file. Each row has an address. Both 
>>> the 'join attributes by location' and 'join attributes by field value' tool 
>>> specify that it joins vector layers. But I don't have a vector layer. 
>>> 
>>> -Erich
>>> 
 On Tue, Sep 22, 2020 at 7:41 PM Nicolas Cadieux 
  wrote:
 Hi,
 
 Why not just use "Join Attributes by Location" or "Join Attributes by 
 Field Value" in Processing?  If you have inconsistent results, I would 
 look at your data base.  Are you using unique fields?  Do you have 
 duplicate shapes or shape collections (MultiPoints, Mulit...)?  What 
 method are you using? intersects, within...  ?
 
 Nicolas
 
 On 2020-09-22 7:19 p.m., Erich Purpur wrote:
> Hi all-
> 
> Geocoding is the one process I am still doing in ArcPro. Most of the QGIS 
> geocoding tutorials I have found recommend using the Geocoding tool in 
> MMQGIS but I have really struggled to get consistent results.
> 
> Does anyone have an alternative Geocoding plugin or other tool they use?  
> It doesn't have to be within QGIS, an external tool would be fine.
> 
> Thank you,
> 
> Erich Purpur
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Afther update QGis 3.14.15-1 to QGis 3.14.16-1 python error..!!

[magerlin]

Now there is a version 2.14.16-2

Do not know whether it is the same issue but it cannot be started up:

Stack Trace


PyTuple_Size :
PyInit_QtCore :
QObject::inherits :
qt_plugin_query_metadata :
QWidget::event :
QApplicationPrivate::notify_helper :
QApplication::notify :
QgsApplication::notify qgsapplication.cpp:439
QCoreApplication::notifyInternal2 :
QWidget::ensurePolished :
QWidget::event :
QApplicationPrivate::notify_helper :
QApplication::notify :
QgsApplication::notify qgsapplication.cpp:439
QCoreApplication::notifyInternal2 :
QCoreApplicationPrivate::sendPostedEvents :
qt_plugin_query_metadata :
QEventDispatcherWin32::processEvents :
UserCallWinProcCheckWow :
DispatchMessageWorker :
QEventDispatcherWin32::processEvents :
qt_plugin_query_metadata :
QEventLoop::exec :
QDialog::exec :
QgsMessageViewer::showMessage qgsmessageviewer.cpp:70
QgsPythonUtilsImpl::runString qgspythonutilsimpl.cpp:352
QgsPythonRunnerImpl::runCommand qgisapp.cpp:11784
QgsPythonRunner::run qgspythonrunner.cpp:33
QgisApp::QgisApp qgisapp.cpp:1412
main main.cpp:1364
BaseThreadInitThunk :
RtlUserThreadStart :




QGIS Info
QGIS Version: 3.14.16-Pi
QGIS code revision: df27394552
Compiled against Qt: 5.11.2
Running against Qt: 5.11.2
Compiled against GDAL: 3.0.4
Running against GDAL: 3.0.4



System Info
CPU Type: x86_64
Kernel Type: winnt
Kernel Version: 10.0.17763



-
Regards Morten

Currently using Qgis 3.14.15
Windows 10, 64bit
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] How to create one new string-value from many other string-values?

[Aron Gergely]

I don't know what is wrong with me today. Here is the response I sent in 
private by accident. Apologies:


On 23/09/2020 13:33, Aron Gergely wrote:

Hi Bernd,

Try blogs? A web search on 'QGIS aggregate functions' used to yield me 
some nice blog resources.



For example from Ujaval Gandhi:
https://spatialthoughts.com/2019/04/12/summary-aggregation-qgis/
https://spatialthoughts.com/2019/04/19/advanced-aggregate-expressions/

Not meaning to single him out of course, some other qgis contributors 
also share great resources! ;)


Best regards,
Aron

On 23/09/2020 13:08, Bernd Vogelgesang wrote:


On 23.09.20 10:21, Bernd Vogelgesang wrote:


On 23.09.20 09:04, jan.ru...@stadt-koeln.de wrote:

hi there,
I got a table with a content for streetnames. For example the street
"Mainstreet" ist separated in
10 different rows of data (one dataset for each letter in the word
"Mainstreet").

I would like to merge these 10 datasets to one dataset. All those
datasets have one ID - so they qgis should
be able to search for the same Id and create a new textstring with
all the leters.

I don't know how to practicly implement my idea in QGIS. Does anyone
have an idea for me?

Thanks a lot and I wish you all a good day!

Jan R.



I think you could try to use an aggregate expression in the field
calculator for a new field.

sth like:

aggregate(
 layer:= 'streets',
 aggregate:='concatenate',
 expression:=name,
 concatenator:='',  <- 2 single quotes, not 1 double, for an empty
concatenator!
 filter:= ID
 )

I don't know if the filter for ID works in this way. Can't check that
cause I do not own such "interesting" data ;)

Cheers,

Bernd




found no way to make my initial aproach work, but this:

 array_to_string(array_agg("street",group_by:="ID"),'','')

in the field calculator for a new text field glues together the complete
street name


If someone knows a resource with more examples how to work with all
these great functions available, please post it.






Monatlich aktuelle Informationen Ihrer Stadtverwaltung in unserem
Newsletter! Newsletter
Anmeldung 





[https://styleguide.bundesregierung.de/resource/blob/72496/1760346/6d7f611945ca42908c50804510c5335b/breg-vorschaubild-01-unterstuetzt-842x595px-jpg-srgb-v01-data.png] 




[https://www.stadt-koeln.de/images/footer_wahlhelferaufruf2020.jpg] 






___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


--
Email Signature Kind Regards,

Aron Gergely
+31 (0) 6 38 70 97 66

*Rasterra* | www.rasterra.nl 


--
Email Signature Kind Regards,

Aron Gergely
+31 (0) 6 38 70 97 66

*Rasterra* | www.rasterra.nl 
<>___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] How to create one new string-value from many other string-values?

[Bernd Vogelgesang]

On 23.09.20 10:21, Bernd Vogelgesang wrote:


On 23.09.20 09:04, jan.ru...@stadt-koeln.de wrote:

hi there,
I got a table with a content for streetnames. For example the street
"Mainstreet" ist separated in
10 different rows of data (one dataset for each letter in the word
"Mainstreet").

I would like to merge these 10 datasets to one dataset. All those
datasets have one ID - so they qgis should
be able to search for the same Id and create a new textstring with
all the leters.

I don't know how to practicly implement my idea in QGIS. Does anyone
have an idea for me?

Thanks a lot and I wish you all a good day!

Jan R.



I think you could try to use an aggregate expression in the field
calculator for a new field.

sth like:

aggregate(
 layer:= 'streets',
 aggregate:='concatenate',
 expression:=name,
 concatenator:='',  <- 2 single quotes, not 1 double, for an empty
concatenator!
 filter:= ID
 )

I don't know if the filter for ID works in this way. Can't check that
cause I do not own such "interesting" data ;)

Cheers,

Bernd




found no way to make my initial aproach work, but this:

 array_to_string(array_agg("street",group_by:="ID"),'','')

in the field calculator for a new text field glues together the complete
street name


If someone knows a resource with more examples how to work with all
these great functions available, please post it.






Monatlich aktuelle Informationen Ihrer Stadtverwaltung in unserem
Newsletter! Newsletter
Anmeldung



[https://styleguide.bundesregierung.de/resource/blob/72496/1760346/6d7f611945ca42908c50804510c5335b/breg-vorschaubild-01-unterstuetzt-842x595px-jpg-srgb-v01-data.png]


[https://www.stadt-koeln.de/images/footer_wahlhelferaufruf2020.jpg]




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] How to create one new string-value from many other string-values?

[Aron Gergely]

By accident I did not reply via the list :( see my suggested solution below

On 23/09/2020 10:10, Aron Gergely wrote:

Hi Jan,

You would be able to solve this with the 'Aggregate' tool:
https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/vectorgeometry.html#qgisaggregate

It groups rows of data according to an expression (just per ID value 
in your case)

and can  aggregate the attribute field values via aggregate functions.
For your field containing all those street name letters, you could 
then select the 'concatenate' function.


You may have to look into sorting your rows if the letters are not 
concatenated in the right order.

The tool also supports expressions on the input fields.

Good luck!

Aron

On 23/09/2020 09:04, jan.ru...@stadt-koeln.de wrote:


hi there,

I got a table with a content for streetnames. For example the street 
“Mainstreet” ist separated in


10 different rows of data (one dataset for each letter in the word 
“Mainstreet”).


I would like to merge these 10 datasets to one dataset. All those 
datasets have one ID – so they qgis should


be able to search for the same Id and create a new textstring with 
all the leters.


I don’t know how to practicly implement my idea in QGIS. Does anyone 
have an idea for me?


Thanks a lot and I wish you all a good day!

Jan R.


Monatlich aktuelle Informationen Ihrer Stadtverwaltung in unserem 
Newsletter! Newsletter Anmeldung 





https://www.stadt-koeln.de/images/footer_wahlhelferaufruf2020.jpg 




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user


--
Email Signature Kind Regards,

Aron Gergely
+31 (0) 6 38 70 97 66

*Rasterra* | www.rasterra.nl 


--
Email Signature Kind Regards,

Aron Gergely
+31 (0) 6 38 70 97 66

*Rasterra* | www.rasterra.nl 
<>___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] How to create one new string-value from many other string-values?

[Bernd Vogelgesang]

On 23.09.20 09:04, jan.ru...@stadt-koeln.de wrote:

hi there,
I got a table with a content for streetnames. For example the street 
"Mainstreet" ist separated in
10 different rows of data (one dataset for each letter in the word 
"Mainstreet").

I would like to merge these 10 datasets to one dataset. All those datasets have 
one ID - so they qgis should
be able to search for the same Id and create a new textstring with all the 
leters.

I don't know how to practicly implement my idea in QGIS. Does anyone have an 
idea for me?

Thanks a lot and I wish you all a good day!

Jan R.



I think you could try to use an aggregate expression in the field
calculator for a new field.

sth like:

aggregate(
 layer:= 'streets',
 aggregate:='concatenate',
 expression:=name,
 concatenator:='',  <- 2 single quotes, not 1 double, for an empty
concatenator!
 filter:= ID
 )

I don't know if the filter for ID works in this way. Can't check that
cause I do not own such "interesting" data ;)

Cheers,

Bernd






Monatlich aktuelle Informationen Ihrer Stadtverwaltung in unserem Newsletter! 
Newsletter 
Anmeldung



[https://styleguide.bundesregierung.de/resource/blob/72496/1760346/6d7f611945ca42908c50804510c5335b/breg-vorschaubild-01-unterstuetzt-842x595px-jpg-srgb-v01-data.png]

[https://www.stadt-koeln.de/images/footer_wahlhelferaufruf2020.jpg]



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] How to create one new string-value from many other string-values?

[Jan.Rutha]

hi there,
I got a table with a content for streetnames. For example the street 
"Mainstreet" ist separated in
10 different rows of data (one dataset for each letter in the word 
"Mainstreet").

I would like to merge these 10 datasets to one dataset. All those datasets have 
one ID - so they qgis should
be able to search for the same Id and create a new textstring with all the 
leters.

I don't know how to practicly implement my idea in QGIS. Does anyone have an 
idea for me?

Thanks a lot and I wish you all a good day!

Jan R.







Monatlich aktuelle Informationen Ihrer Stadtverwaltung in unserem Newsletter! 
Newsletter 
Anmeldung



[https://styleguide.bundesregierung.de/resource/blob/72496/1760346/6d7f611945ca42908c50804510c5335b/breg-vorschaubild-01-unterstuetzt-842x595px-jpg-srgb-v01-data.png]

[https://www.stadt-koeln.de/images/footer_wahlhelferaufruf2020.jpg]

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user