Questions tagged [attribute-table]

A tabular set of data linked one-to-one to a set of spatial features.

Filter by
Sorted by
Tagged with
0
votes
0answers
21 views

Adding boundary info of polygon to attribute column in QGIS

I have a shapefile with buildings as polygons. Is it possible to add attribute columns referring if the polygon boundary is "other polygon" or "outdoors" for a certain orientation (...
1
vote
1answer
25 views

Matching/Joining Photos to two fields and a fuzzy time

I have a directory with around 100,000 images sorted by the crew that took the photo and the time it was uploaded. I also have a master spreadsheet with the dates the images were taken, the camera's ...
1
vote
0answers
17 views

Shapefile Attribute table: Automatic numbering of points arranged in (non-orthogonal) row/line based blocks, by row order + from left to right

I have a Sentinel time series of several rasters, which contain reflection values for 10 Sentinel-bands. Now I'd like to excerpt these values for given points. The sample points are arranged in pixel ...
2
votes
0answers
25 views

Field values don't show up in the symbology while they are visible in attribute table

I am trying to colour different categories within a shapefile in different styles to differentiate them - these categories are visible when looking in the shapefile's attribute table, but then don't ...
1
vote
1answer
36 views

QGIS attribute table not dissolving records

So I have a filtered shapefile layer with only 2 records: I use dissolve tool, selecting all fields, since I have tried different combinations Yet, final attribute table of dissolved image still ...
-1
votes
0answers
21 views

How to select features by two columns with values not NULL

I want to select only those features where values are present in the same row from two columns i.e. Type Type2 Typ3 playarea black NULL playarea white blue space ...
1
vote
1answer
27 views

Transforming dataframe into feature attribute table in Processing plugin using PyQGIS

I am trying to develop a processing plugin using "Create New Script from Template". In this plugin I have created a pandas dataframe. Assuming the df looks like this: C1 C2 0.25 0.84 0.36 ...
4
votes
1answer
120 views

Viewing several attribute tables at the same time in QGIS

I want to view the attribute tables of several layers at the same time. As far as I know it is only possible to open several attribute tables as tabs, but I want to compare the data of different ...
1
vote
1answer
22 views

Merging attribute features based on matching field

I have parcel data for a city where my goal is to merge rows which have the same parcel number ID. I have 53,000 total parcels, with about 6 thousand rows that have one duplicate. So far I have been ...
1
vote
2answers
33 views

Creating a new column from existing columns in a shapefile with a condition in R

I have a shapefile that has multiple columns, and I am trying to merge columns X5andX1 into a new column class, such that only the NA rows of X5 get filled by the corresponding rows of X1. For example,...
3
votes
3answers
189 views

Summing data in row of certain attributes in QGIS

In my shapefile, I have calculated some indicators for each polygon. Now I want to create a new field having sum of these indicators. I created new field and populated it with desired values using ...
0
votes
1answer
14 views

Assign attribute to polylines denoting what feature makes up the majority of other features within a radius

I have two polyline shapefiles, one being roads with a year-built attribute and the other roads with an unknown year-built. I want to somehow use a 1km radius around each unknown year road segment and ...
0
votes
1answer
23 views

Altering field name using ArcGIS Pro

I am using the Alter Field tool in ArcMap to change the name of an attribute column of a shapefile. But, I am getting this error, How can this be fixed?
1
vote
1answer
30 views

Using .CSV file as an external dictionary, but can't find a way to reference/make a key for Null in order to assign it a value using ArcPy

I am using ArcGIS Desktop: ArcMap 10.8.1 and using Python 2.7.18. I have a script that uses a .CSV file as an external dictionary (opposed to creating a dictionary within the script) but I cannot find ...
2
votes
1answer
30 views

Filter objects in attribute table by minimum value

I have a line layer which contains the attributes "id" and "network_cost". There are lots of objects with the same id. For example, there are 500 objects with the id "ABC"...
2
votes
1answer
33 views

QGIS: Relation reference display expression

I have a child table (depuratori) with a foreign key to a parent table (reti). The parent table has a primary key and two foreign key, no other fields. I have setup the form widget to "Relation ...
1
vote
0answers
8 views

Calculating raster land use zone characteristics for multiple circular buffers derived from lat long coordinates in QGIS 3.12.3

Calculating raster land use zone characteristics for multiple circular buffers derived from lat long coordinates in QGIS 3.12.3 I am running QGIS 3.12.3. I have 150 circular buffers at 1KM, 4KM, ...
4
votes
1answer
53 views

Is it possible to filter the attribute table in several years at the same time?

I have a very extensive attribute table (see screenshot) and would now like to filter the objects according to certain years (1997, 2002, 2009, 2014 and 2018) and, after that, biotope types. I think ...
0
votes
1answer
26 views

i want to create a layer with two different value of a field [closed]

I want to create a layer with two different value of a field. Suppose I have a layer named "Road Network". In that feature class i have a field in attribute table named "addi_rd"......
3
votes
3answers
179 views

Summing multiple fields in QGIS

I have a layer/table with several fields I need to sum together to create a value in another field. I have tried using aggregate() and sum() but I can't get the a correct syntax to be able to do the ...
1
vote
2answers
50 views

Multiple Points attribute information into one Point in QGIS

I have three points from two layers ( Point 2539 and 2538 from one layer lets say X and point AL101974 from layer Y ) ( Refer figure-1 below). Point 2539 and 2538 has multiple attribute information ( ...
2
votes
1answer
65 views

Removing duplicate features in QGIS based on two conditions

I have duplicates (maybe triplicates) in an attribute table and would like to remove the duplicate locations based on comparison to the other duplicate. For example: Scenario 1: I would like to ...
1
vote
2answers
92 views

Attribute Table into pandas DataFrame-PyQGIS

I'm trying to develop a plugin in QGIS. My issue is that I don't know how to transform an attribute table into a dataframe in order to use it further in run(self) function later. I also used a ...
4
votes
2answers
97 views

Combining columns in attribute table

How can I merge columns in attribute table with / as delimeters?
6
votes
2answers
140 views

Extracting numbers from text attribute in QGIS

Is it possible to make a new column and store only the numbers in the column "GNR" i.e. removing (1: ))?
2
votes
1answer
56 views

QGIS - creating a report from attribute table

I create a report from attribute table. At one column I have a name of a street, at second column I have a number. Relation between street and a number is one-to-many. Is there a function to show at ...
1
vote
1answer
25 views

Specify attribute from raster's attribute table for raster calculator

I'm working with the ModelBuilder in ArcMap version 10.5. I have two layers : one is a raster that has only 1 value per pixel. The second layer is a raster that has 4 attributes. I want to use the ...
3
votes
3answers
125 views

Counting points in polygon and printing out each placing

Here is my sample table for further description: I have a original point layer: ID Name X(latitude) Y(longtitude) ID1 Dog A 1 ID2 Cat A 1 ID3 Bird B 1 ID4 Cat A 2 ID5 Cat B 1 ID6 Dog A 1 Those ...
2
votes
1answer
49 views

Area/perimeter calculations in table

In ArcView3.2 I used Xtools a lot, just click and it calculated area/perimeter for every polygon, in QGIS I am choosing column and write $area after the "Epsilon" + update. Is there some ...
2
votes
2answers
40 views

Calculating average of columns of singleparts in QGIS

I have singleparts (pipes) with name and depth. I need to count the average depth based on name. So for e.g. pipe 'cont500str1' has average depth (2,93+2,03+1,99+1,17+2,12)/5 = 2,048. The complication ...
0
votes
0answers
13 views

ArcGIS Hyperlink and cloud storage

I am working on a project for public agency and they would like to validate the location of water valves between GIS data and record drawings (plans&profiles). One of deliverable includes ...
4
votes
1answer
70 views

QGIS 3.18: Listing visible features in print composer

I'm trying to achieve auto-listing of features visible (ie rendered and in Map's extents) in a text field rendered as HTML. My idea is: Adding attribute's table to print composer, setting it to show ...
0
votes
0answers
38 views

How to resize attribute table on QGIS print layout

I have a attribute table which I want to print using the layout composer. From here I have three questions: How to resize the columns in the print layout? How do I set the horizontal alignment to ...
1
vote
1answer
27 views

Merging point features into one feature and create ID table containing name of each point

I have 510 point features in separate shapefiles each representing bus stops and I want to merge them into one feature shp containing an ID column for the bus line number each bus stop belongs to. How ...
5
votes
3answers
123 views

Generating unique code for features via grouping by several attributes

I have features with 3 columns of information ("material", "name", "dimension") in the Attribute table. I need these features to group - to create 4th column where ...
3
votes
1answer
53 views

Selecting and displaying all of items with same value in attribute table using ArcMap

One of the columns in my attribute table is entitled NAICS_1 and I'm supposed to display only the objects with an NAICS_1 of a specific value. How do I filter the attribute table using ArcMap to only ...
0
votes
0answers
19 views

Join two polyline shapefiles without a common field to copy over attributes?

I am trying to sort out how to utilize two polyline shapefiles where their data doesn't have any common "data" attributes but they generally represent the same features. Spatially, there are ...
0
votes
0answers
35 views

Network analysis using QGIS

I have a water pipe network consisting of segments with attributes of pipe dimension, material of pipe and street location. I need to create another network with different segments grouped by these ...
6
votes
2answers
125 views

Calculating distance from point to previous point in attribute table

I have a list of points with field data in the attribute table. I want to have the distance between point id₁ and point id₁-1 (previous point in table). Can I write this as a formula in the attribute ...
0
votes
1answer
24 views

How to make a photo as a label on a point feature using ArcGIS/Arcmap

How to make a photo as a label on a point feature using ArcGIS/Arcmap. In this case each point feature will display a different photo. Someone has discussed this before, it can be seen at the ...
1
vote
1answer
58 views

Automatically updating the attribute table

How can I write an expression to update the area of polygons and lengths of features automatically as well as the sum of the areas and lengths. I am using QGIS 3.16.7 and the data format is OGR ...
0
votes
0answers
29 views

How to recover the attribute table data

I downloaded a new shapefile and is displayed without any value in the attribute table, do you know what could be the reason?
7
votes
2answers
104 views

Creating field based on the sequential indicator in QGIS

I have a points layer in QGIS that is organised by time, with a column called "Diff" that has either 1 or 0. The 1 marks a point where there is a jump in time, the 0 marks where nothing has ...
3
votes
1answer
45 views

Creating new field based on the sum of occurrences of feature attribute

I have an "Owner_Name" field. I want to add a virtual field "Num_Properties" containing the number of properties each owner owns. (). To figure this I believe I need the expression ...
2
votes
1answer
27 views

QGIS displays NULL values as zero in the layout tables

I use QGIS 3.18.2-Zürich to display the table in layout mode. My table contains two fields of type Double. If I set the values to Null (None), a zero is displayed instead of an empty cell. What should ...
0
votes
0answers
19 views

How to access the rows in an ArcGIS Server JavaScript FeatureTable?

Using the ArcGIS Server JavaScript API v4.x how can I access the rows in a FeatureTable? As an example, I modified the ArcGIS FeatureTable sample to log the table object to the console: Note that the ...
0
votes
2answers
33 views

Indexing from first row of attribute table with Python

I'm just trying to extract the variable value of the 7th column of the first row in a vector layer. I'm not sure how to index the table exactly though. I included the lines I wrote, which I imagine ...
1
vote
1answer
21 views

Replace a field with maximum of it's attribute values based on values repeated on another field's attribute values using ArcPy

So I have performed Spatial Join between a point and line feature class. Now for each point there are several lines. What I want is the maximum count of line features as an attribute value in the &...
3
votes
1answer
86 views

“Packing” MapInfo TAB file in QGIS

I am used to working with MapInfo when using TAB files, however am in the process of learning how to use QGIS instead. One snag I have hit is that when rows in a table are deleted, the empty rows ...
8
votes
3answers
269 views

Finding nearest neighbor with smaller attribute value in QGIS for a huge dataset: make expression more efficient

The setting I have a Geopackage point layer in QGIS 3.18 with over 350.000 features for an area of about 1700 km² (extent ca. 50*60 km), representing centroids of buildings. The points contain an ...

1
2 3 4 5
35