5

In QGIS I can suggest using a Virtual Layer through Layer > Add Layer > Add/Edit Virtual Layer... Let's assume we have two layers "points_layer" (red) and "lines_layer" (grey) respectively, see image below. With the following query, it is possible to achieve the result, i.e. to add only the names of my vertices (from line intersection, duplicates ...


4

Found the answer. One had to add the "%" sign with a concat operator: "id" LIKE concat(attribute ( @atlas_feature, 'ref'),'%')


4

Open user profile folder ("Settings > User profiles > default"). Goto /python/plugins/refFunctions. Open refFunctions.py. Go to geomintersects function definition. Change 100000 in if count < 100000: to a value that you desire. You need to do same process for the other functions, if you want to use them.


4

Yes, there is. It's the 'Merge Attributes of Selected Features' button. First you need to enable the Advanced Digitising toolbar (View > Toolbars > Advanced Digitising). Then enable editing on your desired layer and select both the feature you want to copy attributes from, and any of the feature(s) you want to copy attributes to. In the main window the ...


4

One of your GEOID columns has a leading zero, so that's why they are not joining, you are joining on text fields so the text don't match up. You have two options: convert the GEOID fields to numeric format or add a leading zero to the GEOID field that is missing it. You probably want to do the latter as leading zero's usually hold some importance in census ...


4

Use python with a Dictionary (backup your data before you try it and check output to make sure it works as expected): d = {"BA1404":'Acer negundo',"BA3501":'Aescolus sp.',"BA2007":'Ailanthus altissima', "BA2009":'Celtis sp.',"BA1304":'Fraxinus pennsylvanica',"BA2010":'Gleditsia triacanthos', "BA2002":'Juglans nigra',"BA0404":'Pinus strobus',"BA2008":...


2

As of QGIS 3.12, you can conditionally format row background and text colour in the attribute table in Layouts by setting the formatting in the Attribute Table for the layer in the main window. So if you set up conditional formatting in the Attribute Table to "field" = 'value' this will be reflected in the attribute table in the map layout if you check '...


2

I think if you don't use dataProvider it's ok. Found in Deleting selected features using PyQGIS?: with edit(layer): # build a request to filter the features based on an attribute request = QgsFeatureRequest().setFilterExpression('"DN" != 3') # we don't need attributes or geometry, skip them to minimize overhead. # these lines are not ...


2

I am not sure if I understand what your GeoTIFF file represents. If your GeoTIFF file contains elevation values, you can use the Drape (set Z value from raster) QGIS algorithm to set Z values of the points to the elevation value of the raster at that position. Input Layer: Your point layer; Raster layer: the DEM.


2

Note: this should work, as the correct values show up in the expression preview. However, it currently doesn't update the field with anything, probably due to a bug with attributes(). This is a potentially very powerful tool and a shame it doesn't work so I have lodged an issue on GitHub. Edit: this has been addressed in a commit and should work in the ...


2

CONTAINS KEYWORD You can make a field that writes the "category" of 'DESCRIPT' features if it has a certain keyword using this code in the field calculator in the attribute table. CASE WHEN "DESCRIPT" ILIKE '%Undifferentiated%' THEN 'dog' ELSE 'cat' END EQUALS EXACT KEYWORD If you want to categorize by exact word, the use this code: CASE ...


2

sf::st_write in R uses the abbreviate function in its base package to create unique names of the right length for a shapefile. If I have a spatial object with these two long names (plus "geometry"): > names(p) [1] "longnamehereplease" "longnamehereaswell" "geometry" then writing them gives: > st_write(p,"p.shp") Writing layer `p' to data ...


1

Assuming you have a common ID in your Shapefile and your CSV file, you should perform a join in QGIS between the census tract layer and your csv [1]. Entities in your shapefile that don't have any correspondence in your CSV will have NULL values on the joined columns. This NULL value would help you to select only the entities that have a match, with a ...


1

If you have the ArcGIS Desktop Advanced license: You can apply the Near tool (https://desktop.arcgis.com/en/arcmap/10.3/tools/analysis-toolbox/near.htm) with the Canopy as input and the Path as near feature. This will calculate you the distance between your two features and add an attribute field (NEAR_DIST) to your Canopy layer with the distance for each ...


1

Not the best solution according to the data amount, i.e. 19 thousands features. But perhaps you are working with a database. In terms of QGIS I can suggest using a Virtual Layer through Layer > Add Layer > Add/Edit Virtual Layer... With the following query, it is possible to achieve the result, i.e. to find the users which most often meet in this ...


1

If all your data is in one file you could duplicate the layer in QGIS (not the file itself, but the layer reference) for as many different categories as you need (right click on layer > Duplicate Layer). Then filter each reference to the respective category (right click on layer > Filter...) so in essence it's like you have a layer for each category but ...


1

Is there a possibility in QGIS to only show/export the relevant attribute without me having to do so manually every time I want to look at my data? When you right-click on the layer and choose Export-> Save Features as..., you can choose which attributes to save / export. Fields can be hidden in the attribute table of a layer by right-clicking-> Hide ...


1

ahmadhanb's answer works, but it seems to me that the part you want to remove always is in paranthesis, so if you split on '(', you can simplify as the first part split is returning is always what you are looking for: from qgis.gui import * @qgsfunction(args='auto', group='Custom') def splitText(labeltext, feature, parent): split_text = labeltext....


1

If only you need to extract Oligocene-miocene and put it in the category column, you can use the substr() function from Field Calculator to update the descript_category column as follows: substr("descript_title",0,17) Which will extract only Oligocene-miocene from the descript_title and add it to the descript_category. Another way is to create a custom ...


1

Sounds like you want to use the Extract values to points tool? This would transfer a pixel value from your classified raster to the point dataset.


1

You can do by it writing a custom expression and put in a html- field. It is quite hard to make a general solution, but for a customized case, someting like this will work from qgis.core import * from qgis.gui import * @qgsfunction(args='auto', group='Testing') def dataset(table, feature, parent): output="" layer=QgsProject.instance()....


1

If you are trying to modify these rows you see as blue in the screenshot(?), I don't think it's currently change those based on a value: I don't think it would be a really big development to make it possible to read an expression to the value like you can do with most of the inputs in the print layout. So I suggest you to open a feature request on GitHub.


Only top voted, non community-wiki answers of a minimum length are eligible