New answers tagged

3

You can do this via the python interface. Start the Python Console from the plugin menu. As an example, this code will set all 10 fields of the first layer to "Hidden": # get map canvas object mc = iface.mapCanvas() # get the first layer (layer 0) l = mc.layers()[0] # get the edit form configuration f = l.editFormConfig() # loop over 0 to 9, and set ...


2

This is another way rank_dictionary = {'very low':0, 'low':5, 'moderate':20,'high':50, 'very high':100} shapefile = 'dataset' fields = ['Rank_txt', 'Rank_num'] with arcpy.da.UpdateCursor(shapefile, fields) as Cursor: for row in Cursor: row[1] = rank_dictionary.get(row[0]) Cursor.updateRow(row)


4

Since you've already created your field to store the integer ranks you can use the Field Calculator with the following codeblock (this code assumes your string, or text, ranks are stored in the field rank and your new field for storing the integer ranks is num_rank): For each feature in your dataset, the corresponding rank value (very low, low, moderate, ...


1

This will get you started. My assumption is that RANK is your attribute string field and RANK_NUM is your rank numerical value field. attributes = [['very low',0], ['low',5], ['moderate',20], ['high',50], ['very high',100]] dataset_lyr = "dataset_lyr" arcpy.MakeFeatureLayer_management("dataset.shp", dataset_lyr) for att in attributes: selection = '"' + ...


2

In your DynamicValue table your expression is [COMPLAINT] + "-2016-" + [PROJECTID] but in the text of your qestion you say that it's [COMPLAINT] & "-2016-" & [PROJECTID] with + instead of &. I believe the expressions use VBScript so the expression [COMPLAINT] & "-2016-" & [PROJECTID] looks more correct to me. You are getting a Type ...


0

If you are entering house number points please also try the house numbering qgis plugin: https://github.com/marcobra/HouseNumbering


2

There is an easy way that needs two steps from the db-manager and two tables that can be deleted in the end(there is a way with virtual tables, but i donĀ“t get them to work properly from the db-manager). go to db-manager and then to virtual layers and select your table with the trees; then start the sql-window Enter into the query field: SELECT ...


-1

You could to use the "Field Calculator". Try this expression for update your field "group": CASE WHEN "species"='Ash' THEN 1 WHEN "species"='Beech' THEN 2 ...... ...... END


5

You can assign this field in "Layer Properties >> Display >> Field"


0

GeoPackage is a SQLIte database, So you can edit the table with a program for manage databases. Per example, you could to use "DBeaver", or you could to use "SQLite Expert Personal" (freeware). With SQLite Expert you could to delete and reorder fields.



Top 50 recent answers are included