Questions tagged [duplication]

For questions related to creating, finding, or removing duplicate records or features.

Filter by
Sorted by
Tagged with
5
votes
1answer
105 views

Why highlighting duplicates does not work in QGIS?

I have used the formula from this query Identifying duplicate attributes in field using QGIS: count(1, "FieldWithDuplicates") > 1 but it doesn't work in my case, just highlights each ...
6
votes
1answer
77 views

Selecting duplicate records except the first and last duplicate with Select by expression in QGIS

I'd like to know how to select duplicate records except the first and last one, with the "Select by attribute/expression". On GIS SE I found a solution for selecting duplicates except the ...
3
votes
0answers
58 views

IDs are being duplicated between different instances of QGIS

Is there a way to create a secondary ID that cannot be duplicated? Currently using 1 project between multiple instances of QGIS, this is resulting in this secondary field being duplicated which is ...
2
votes
0answers
20 views

Duplicating layer properties in ArcGIS Online

I'm very new to ArcGIS. I was wondering if there is a way to duplicate layer properties (drawing style/legend and pop-ups) to another layer. I was thinking, maybe duplicating the layer, then changing ...
0
votes
1answer
36 views

Deleting duplicate features with ArcPy based on multiple attributes

I want to write Python code that removes duplicate features from a table based on their attribute value. Within the code, a loop will iterate through multiple attributes to check if the value is Null. ...
1
vote
1answer
39 views

Removing slightly different overlapping geometries in QGIS/SQL

I am working on a large map in QGIS that is using 40' wide street approximations to visualize a small city. The data is also held on an SQL server that I have access to. I am taking over the work from ...
0
votes
0answers
15 views

Attribute form defaults: How to take over the settings directly when duplicating the layer (and not afterwards by copy-paste-styles)

I have a point-shapefile-layer with attribute form defaults for some fields, QGIS 3.16 (see image, red marks). If I now duplicate the layer (by exporting or by duplicating) these attribute form ...
7
votes
3answers
306 views

Redistributing duplicated points inside the polygon

I have a point layer with real estate data, obtained after geocoding by addresses. In case of multi apartment housing all points with data for several apartments in one building has identical ...
2
votes
1answer
108 views

Find and delete duplicate rows in matrix in QGIS 3.6

I used the OD Matrix to produce a list of the distances between all sites to all other sites via a network. This process produces duplicates, since it makes calculations in both directions, i.e., from ...
3
votes
1answer
97 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 ...
2
votes
1answer
50 views

Duplicates Not Highlighted

Actually I am using Geometry Generator and a small script for displaying duplicate values in the data. But some duplications are not highlighted. Don't know why its happening. can any one suggest any ...
1
vote
1answer
51 views

Intersect without duplication (QGIS)

In QGIS 3.16, I have a layer of polygons corresponding to particular ecological habitat zones. I'd like to perform a series of intersections in order to add information to each polygon as to where it ...
4
votes
1answer
57 views

Automate the selection of duplicate geometries with QGIS3

I have a layer of buffers calculated from watercourses. Each watercourse/buffer has a Strahler Order (0 to 7). I need to delete overlaps between buffers order 0 and buffers order 1 to start, but ...
3
votes
1answer
103 views

Adding duplicate labels within polygon in QGIS

Is there a way to include multiple duplicates of the same label within a single polygon in QGIS? So a single polygon(s) with a label from a single field, repeated at a set distance within the polygon -...
2
votes
2answers
78 views

Duplicating data for use in new ArcMap project

I am using ArcMap 10.8.1. I wanted to make a new project based on the same data as an existing project, so I duplicated the project file and started editing one of the layers in Editor Mode. I then ...
1
vote
1answer
67 views

Deleting duplicate polygon using QGIS

I am using QGIS "Delete Duplicate Geometries" tool, I am trying to delete one of the below two polygons , but failed. The below two polygons are identical with vertices , but the start of ...
7
votes
1answer
144 views

Identifying duplicate geometries in different layers with QGIS

I'm using QGIS 3.16 Hannover under MacOS 10.13 environment. I've got two polygon shapefile layers: 'LIC' and 'ZEPA'. Some polygons (name, code & geometry) are present in both layers and I want to ...
1
vote
2answers
31 views

Deleting data by location using another shapefile

I have two shapefiles: one is main file and another is a part divided (manually by selecting) from the main file. Now i want to delete the divided part from the main file with the help of divided part....
2
votes
0answers
46 views

Tippecanoe vector tiles duplicating over certain graticules (equator, -90)

I have large geojsons at different scales that I have converted to tiles with tippecanoe. My ultimate goal is for a user to be able to draw a box around the tiles and calculate mean attribute values ...
1
vote
1answer
89 views

Highlight duplicates at nearest distance

I have a point shapefile with several names and there are a lot of duplicate names in the data. I want to highlight the nearest duplicates in the data. How can I solve that in QGIS?
1
vote
0answers
53 views

Nearest unique duplicate points

How can I highlight nearest(certain distance) unique duplicates? Actually I tried a process in ArcGIS but only duplicates are pulled out from the entire file without considering distance. How can I do ...
4
votes
3answers
334 views

Eliminating duplicates only if data is the same according to attributes

Having duplications in the data is quite natural and removing them is quite hard if we didn't have the same attributes. In QGIS there are tools to eliminate the duplications but only if the data is ...
0
votes
1answer
31 views

How to specify from which file duplicates should be deleted after appending two datasets

I am using python script and ArcGIS Desktop 10.8.1 to synchronize two datasets. There are many (thousands) of duplicate features that I would like to drop in an output. How can I specify that, in the ...
2
votes
1answer
263 views

Leaflet: mutually exclusive overlay layers: "overlayadd" event firing twice

LeafletJS. I am trying to have two overlay layers be mutually exclusive. Full example here on jsfiddle I guess it comes down to this bit of code: map.on('overlayadd', function(event) { ...
0
votes
1answer
38 views

Snapshot live feed featurelayer by creating a copy of the data in ArcGIS

Let's say we have a feature layer on ArcGIS online that is constantly updated. Examples would be the Recent Conditions in Air Quality (PM2.5), Satellite (VIIRS) Thermal Hotspots and Fire Activity, or ...
4
votes
1answer
173 views

Removing intersect or overlap of points in the same vector layer

Is there anyway to remove the intercept part of the vector points? P.S. Please ignore the red circle, it's not a polygon, it is a hand drawn by me to show the error part So far I've done: "...
3
votes
1answer
93 views

Selecting duplicates records except one in QGIS

I'd like to know how to select duplicates records except one, with the "Select by attribute". I've attached a picture to explain better the output needed.
2
votes
1answer
1k views

Removing duplicate points in GeoPandas using distance and time

I have a list of of coordinates that have areas mapped out on a map user_id id latitude longitude requested_at 84 106 13.0472367 77.5022635 12-10-2020 14:59 84 107 13.0472789 77.5024498 ...
3
votes
2answers
388 views

PostGIS - identify duplicate points from polygons/linestrings?

I'm trying to identify polygons/linestrings with duplicate points, using PostGIS. I just want to tell whether the geometry has duplicate points, not remove the extra point. I know there is ...
2
votes
1answer
36 views

Find same names (duplicates) in one field using another feature class field

I have 2 tables (UML, PalmOil) and I would like to check record by record within PalmOil, if there are duplicates intersecting NameUMLwith NamePalmOil UML ID | NameUML | 1 NAME1 2 NAME2 3 ...
6
votes
1answer
346 views

Delete duplicate points in QGIS

How to delete duplicate points in QGIS (3.14)? I insert a layer into the project. The layer contains several objects (61 points), some of which are duplicates. In the menu I select "Vector" &...
2
votes
0answers
280 views

Select duplicates by attributes in QGIS

I selected my duplicates in my attribute table by Count(1,"ID")>1. Now I just only want to keep the duplicates with the highest areas. Is there a way to directly select them or a work ...
1
vote
0answers
31 views

Duplicating Layers to new, independent layers in QGIS 3

I am currently working on a rough freight railway station planning project in QGIS 3 and it's output should be different "alternatives" (as layer groups) with different layers to each. For ...
3
votes
1answer
182 views

Merge nearby points from two shapefiles in QGIS

I am working with 2 shapefiles: points from one datasource and another. Some of the features are duplicates. However, since data quality in the second datasource is not as good as in the first one, ...
0
votes
1answer
49 views

How to create multiple graduated layers using different attributes/columns? [duplicate]

I have a shapefile for which I'd like to create multiple graduated layers for each attribute/column. At present, I manually duplicate the layer and then change the column from the drop down list, ...
2
votes
1answer
130 views

PostGIS: Finding duplicate label within a radius

I have data in PostGIS that have value and geometry. If there is a same value within let's say <10 m, I want to detect or remove that value from my table. Here is the small example: create table ...
1
vote
2answers
212 views

Deleting duplicate points from two different layers

I have two layers with the same feature ("Object ID") and same location All lightning strikes Cloud strikes I want to delete the 'Cloud strikes' that are still to be found in the 'All lightning ...
2
votes
0answers
32 views

How do you link QGIS legends in different print composers?

I have a long linear QGIS project with about 20 separate print composer layouts. I'd like to link each legend to the original one, so I don't have to copy and paste 20 times every time I need to ...
3
votes
2answers
208 views

Remove duplicate labels for parallel line features in QGIS 3

I've been really struggling to get my highways to label neatly. The idea is to have one route number label every 1 km on the route. The only issue is that there are duplicate separated carriageways ...
1
vote
0answers
58 views

Separating 50 duplicate points by limit in buffer zone using QGIS

I am building a customer database in QGIS. I get GPS coordinates for customers from my staff. Then I convert those GPS coordinates into shapefile points in QGIS. I get a lot of duplicate points. I am ...
1
vote
1answer
55 views

Combine duplicate rows but keep class information?

I'm stuck trying to figure out how to avoid combining and deleting duplicate values manually. I'm working with parcel data, and based on some property information, each parcel is either in group a, b, ...
0
votes
0answers
98 views

Remove duplicate polygons in a single layer using ogr2ogr? [duplicate]

I have a spatialite database file containing buildings within a country as multipolygons. While trying to use QGIS to delete these duplicate features, QGIS keeps on crashing due to the millions of ...
1
vote
0answers
124 views

Proper identification of duplicates using spatial and temporal criteria in PostGIS

I have a table with metadata about sampling locations in the ocean. It includes geographic coordinates, date-time in which sampling was done the number of vertical measurements in each location (...
1
vote
0answers
305 views

QGIS Duplicate Labels still appearing despite suggested changes. Do i need to do an expression?

I have one field called Streets. In Streets there are road beds with suffix as Pkwy, Street, Avenue, Expressway and so on. I also want to label some of these road beds. In Layer styling under ...
3
votes
2answers
303 views

Duplicate points and bounding box in PyQGIS?

I am trying to find all points in a vector layer that do not have a duplicate point. To do this, for each point I create a list of features that intersect its bounding box ('candidates') then check ...
1
vote
1answer
75 views

Has anyone experienced duplication issues when exporting large datasets to .CSV on ArcGIS Pro?

I am working with a shapefile in ArcGIS Pro that has 3.2 million observations and about 20 columns. The .shp file is 87MB and the .dbf is just over 2GB. I am attempting to accomplish an export. ...
0
votes
1answer
94 views

Over calculation of area- How do I calculate correct acreage when there are stacked parcels?

I am currently interning for a county in the United States. I am working on the data and mapping needed to fulfill the Open Space Activity of CRS. Stacked parcels are causing me a massive headache. ...
3
votes
4answers
616 views

Identifying features with duplicate geometry in QGIS

I am working on a public transport network in one shapefile (polyline type) in QGIS 2.18. Certain bus routes share the same paths, means that one line-part can repeat more than once. It always has the ...
1
vote
1answer
29 views

How to create a new layer with specific data from a large data base of irrelevant data?

I am a complete beginner to QGIS. I am trying to isolate an individual set of data from a very large data base to plot in another layer. I have isolated the piece of data by using the Selection by ...
6
votes
1answer
1k views

Labeling only one duplicate attribute without editing original data in QGIS

I have several points (e.g. 4 bus stop positions) in one area. They all belong to the same station, so they all have the same "name" attribute. To avoid a mess of labels showing all the same ...