Questions tagged [duplication]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
40 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
23 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 ...
0
votes
0answers
21 views

Duplicated label problem in ArcGIS Server 10.7.1 cached map services

I have an interesting problem related to cached maps service. So, When I publish dynamic map service to ArcGIS Server 10.7.1, it works well not exist any duplicated label. But When I publish cached ...
1
vote
1answer
54 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
32 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
53 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 ...
0
votes
2answers
52 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
18 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
106 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
44 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
44 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
24 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
120 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
150 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 ...
2
votes
2answers
190 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
54 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
72 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. ...
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 ...
5
votes
1answer
633 views

Labeling only one duplicate attribute in QGIS without editing original data

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 lables showing all the same name I only ...
1
vote
0answers
56 views

Duplicate Records on AGOL

I recently uploaded to AGOL a feature service layer with a relationship table (many to many). While configuring the layer, I found out that for some reason the table counts more records than what ...
4
votes
1answer
89 views

increment column value with an integer when it is a duplicate

I have a layer with around 1000 lines. Some Name are repeated several times and I wish to have every name unique. Thus I try in the field calculator to add an integer at the end of the name only when ...
0
votes
1answer
427 views

Removing duplicate rows created by ST_Intersects in PostGIS?

I want to basically take one spatial table of polygons and determine if any of the polygons interest with another table of polygons and save the results in a new table with a new column saving the ...
3
votes
1answer
68 views

Offsetting Atlas Generated Maps

My aim is to generate maps of polling stations to helps electors find their local polling stations for elections in 2019 and onwards. I've plotted and labelled 80 polling stations on a 'Polling ...
1
vote
0answers
84 views

Distinguishing two streets with the same name?

I am trying to get road data using the Overpass API. I want a user to be able to find a street using its name then retrieve the data for the nodes to draw a line on the map. This is all fine using: [...
1
vote
0answers
242 views

Removing duplicate highway shield symbol labels from ArcMap document

I have highway shield symbols in my map document that are showing duplicate labels in the current map view. When I go to the Properties of the roads layer, then Labels, then Placement Properties and ...
4
votes
0answers
376 views

Dealing with duplicate locations kriging - a method for replacing with a single location taking the mean of the duplicates? (R)

I understand that the existence of duplicate points (locations) when Kriging will result in a singular covariance matrix. The only way I've encountered people dealing with this is to keep the first of ...
3
votes
2answers
86 views

Duplicated Features in point layer

I have duplicated features in point layer (Land Marks) but these duplicate has 2 cases : they might be not all have their center above each other (some have it at center , some is a bit far but its ...
2
votes
1answer
252 views

Delete duplicate features with identic geometry based on attribute with QGIS

I have a vector layer containing landmark buildings in Stockholm. Each landmark building consists out of several features with the same KOM_ID but with different Z-values. When rasterizing this shape ...
5
votes
2answers
2k views

Deleting duplicate points except those with different attributes in QGIS?

I have a question regarding removal of duplicate points, which I did not find answered here yet. In my point shapefile there are some points at the same coordinates. Some of them have the exact same ...
1
vote
1answer
29 views

Creating duplicate records based on overlapping polygons

I have a shapefile of all the counties in one state, I also have a shapefile of a grid map dividing the entire state into 1-mile grids. I need to come up with a list of which grids are in which county,...
2
votes
3answers
141 views

Deselecting original feature from selection of both original and duplicate features?

I have a field which is supposed to hold a unique identifier, however due to issues with Attribute Assistant I have multiple features which have the same unique ID. I want to write a script which will ...
5
votes
1answer
408 views

Deleting duplicate records in the attribute table and keep the minimum value in PyQGIS?

I have two fields: ID_PARCEL and NL. The ID_PARCEL is the field that contains duplicate records. I would like to remove the duplicate record by keeping the minimum NL field value. For example: the ...
2
votes
1answer
183 views

Select all fields from table and use with arcpy.DeleteIdentical_management()?

I would like to use arcpy.DeleteIdentical_management() function without having to specify all fields in the table. Is there a keyword used to select all field in a table? I tried "*" or "ALL" but ...
3
votes
1answer
150 views

PyQGIS Finding duplicates across multiple columns

I have a table with three columns that I'm interested in: X, Y and rotate. These specify the position and angle of a symbol. I want to find duplicates across these columns, so anything with the same X,...
3
votes
1answer
1k views

Identify duplicate attributes (followup)

I am processing a large map with several hundred thousand building polygons in QGIS 2.18. Unfortunately I had to puzzle this map together from several smaller and overlapping pieces and so quite a few ...
1
vote
1answer
465 views

How to duplicate features based on attribute value pyshp?

I have a shapefile in which there are a series of polygons that I have to attribute to the name of a project which are recorded in 6 attribute fields. For each polygon there might be one to 6 ...
5
votes
1answer
199 views

manage qgis rule based styling duplicates

I am new to qgis. When I am using rule based styling, duplicates for some reason show all the matching symbols and not only the first match rule's symbol. How do I make show only one symbol even if it ...
4
votes
2answers
932 views

How to select duplicate records based on multiple fields?

I have a feature class with two fields of interest: "name" and "identifier" (Original Data; Figure 1). Note that there are several duplicate rows in the table and the table may or may not be sorted, ...
2
votes
1answer
259 views

WFS consumed in QGIS generates duplicate features

Problem: When some of my layers are published by Geoserver 2.8.0 and added as WFS layer in QGIS 2.16.0 some of the data are duplicated. The duplicated data do not have geometry. I have observed this ...
5
votes
2answers
306 views

substitue raster values duplicate error

I have a raster (seg) whose values I want to substitute, and am getting an error from function subs from the raster package that I don't understand at all. I get the following error Error in .local(...
1
vote
1answer
98 views

Restricting duplicate attribute values in file geodatabase feature class? [duplicate]

I have created a File Geodatabase with around 9 feature datasets, and each of those have their own feature classes. So for one of the point feature classes in my GDB, I want to restrict the entering ...
0
votes
1answer
160 views

Customized Kml with ArcGIS

I'm using ArcGIS 10 desktop version. I need to customize my kml files as to what they pop up in Google Earth. One of the attributes appears twice even when the field is not enabled. The picture ...
11
votes
2answers
3k views

Duplicating layer in memory using pyqgis?

I have a layer in QGIS, and I want to duplicate it through a plugin so I can use the copy of it as I want, without modifying the original. Of course layer2 = layer1 will not work, because everything ...
1
vote
1answer
110 views

Removing duplicate legend items in QGIS?

I work with several layers that share similar symbology partly. I'm trying to remove duplicate Symbology from the legend: All the layer and their classification are in the map extent. I try to use ...
2
votes
1answer
638 views

OpenLayers 3: Attributions

I have a number of layers which share the same attribution. When more then one of them are visible at the same time I get something like this in my attribution control: Company1 hyperlink1 Company2 ...
3
votes
2answers
535 views

Count duplicates in ArcGIS, ArcMap 10.4

How can I find how many duplicates I have in my dataset (areas, lines, points) using ArcMap? With topology I can find overlapping objects, but I want to find duplicates. Are there any tools from ...
2
votes
1answer
73 views

Identify groups of stacked geometries in PostGIS

I need to create a column in my PostGIS table with values identifying different groups of stacked/duplicate geometries, such that one group of stacked geometries might get a value of 1, another group ...
7
votes
5answers
20k views

Identifying duplicate attributes using ArcGIS Desktop?

I am trying to identify and flag exact duplicate attribute labels (text) in a field. I can't access "Delete Identical" with my Standard ArcGIS license. I have ET Geowizards installed, they have a ...
3
votes
1answer
382 views

Creating duplicate features - many to one - in qgis

Essentially I have a shapefile of polylines and wish to create duplicates and based on attribute data. I have route data for individuals as polylines. Then I have attribute data which tells me the ...
2
votes
1answer
161 views

Virtual fields are lost when duplicate layers

I've just upgraded to QGIS 2.12.3 - and hoped that the issue which was really time-consuming in 2.12. <3 could have been solved ... On duplicating layer - with tons of joined tables and virtual ...