6
You can adjust the text size (for the whole of QGIS) in the Settings->Options menu.
giving (at 20pt):
6
This answer will number parcels from West to East.
You can create a new layer with the ordered ID
Go the the menu layer / add layer / add-edit virtual layer and enter the following query.
select *, ROW_NUMBER() OVER(ORDER BY ST_MinX(geometry) asc, ST_MinY(geometry) asc) as newID
FROM myLayer
you can replace the layer name (myLayer) with the true name.
...
3
Another method is to add a new column, "Year Constructed," using a conditional expression like this:
Case
when "P1939" = max("P1939", "P1940", "P1950", "P1960", "P1970", "P1980", "P1990", "P2000", "P2010") then 1939
when "P1940" = max("P1939", "P1940", "P1950", "P1960", "P1970", "P1980", "P1990", "P2000", "P2010") then 1940
when "P1950" = max("P1939", "...
3
From Understanding how to use Microsoft Excel files in ArcGIS:
Excel tables are read-only in ArcGIS as well as in Excel when you have a workbook open in ArcGIS.
Consequently, you will not be able to add a field to one, delete a field from one or calculate geometry in one, unless you export that Excel worksheet as a geodatabase (or DBF) table.
3
As far as I know, there is no an option in QGIS to change only the text size of the attribute table. Therefore, I suggest you to add a new theme to change font size of attribute table. To do that:
open QGIS profile folder (Settings -> User Profiles -> Open Active Profile Folder).
navigate themes folder and create a folder and name it (i.e. My Theme).
...
2
If you open the attribute table of the layer with the selected features you're interested in, click on Show All Features in the lower left corner, then Show Selected Features.
2
You can also use pandas module which is included in 10.5:
pandas is an open source, BSD-licensed library providing
high-performance, easy-to-use data structures and data analysis tools
for the Python programming language.
import pandas as pd
import arcpy
fc = r'C:\data.gdb\table' #Change
fields = ['ID', 'Road_Type', 'veg_type', 'DENSITY']
df = pd....
2
By converting it to string I was able to get it to recognize the ID.
Theres probably a much better way but this is what I got.
for fc in arcpy.ListFeatureClasses('*M'):
table1 = fc + 'table'
flds = ['ID', 'Road_Type', 'veg_type', 'DENSITY']
searchDict = {str(f[0])+','+str(f[1])+','+str(f[2]):(f[3:]) for f in
arcpy.da.SearchCursor(table1, flds)}
uc_flds ...
2
You could use the query builder found under 'provide feature filter' when you right-click on your layer > properties > source.
Depending on what planet species you'd like to show on the map each time you could use the query builder to define this so that only that species shows. Without seeing your data I've done a quick example below.
By then selecting '...
2
I often have to visually audit points numbering in the thousands and I find this plugin to be a lifesaver:
https://plugins.qgis.org/plugins/Go2NextFeature3/
It can automatically zoom or pan to the next item in the attribute table and even select it.
2
Here's an alternative method using rule-based styling.
Set up a graduated style with 9 classes with your desired color ramp. Choose the color ramp carefully, because if you want won't be able to change this later. It doesn't matter what field or expression you use for "column", because you're going to change that in step 3. The entire point of this step is ...
1
Hi using a tool like Miller https://github.com/johnkerl/miller starting from this example input file
p1940,p1950,p1960,p1970
436,490,446,195
526,320,963,780
220,888,705,831
and running
mlr --csv merge-fields -a max -r "^[a-z]" -o value -k then put '
for (key, value in $*) {
if (value == $value_max && key != "value_max") {
$fieldName=...
1
This is possible, but the expression needed to compute it is a bit convoluted. I will explain below.
Your task is to find the column name which has the highest value for every feature. If the highest value is in P1940 column, your answer is 1940, if the highest value is in P1980, your answer is 1980 and so on.
You can do this using array functions in QGIS. ...
1
Refactor fields is no longer a plugin. Now it's a core feature. Access it through the Processing Toolbox (Processing menu > Toolbox).
Only top voted, non community-wiki answers of a minimum length are eligible
