duplicate entries in the Samples table

[cmrRose]

I'm getting pairs of duplicate CatalogNumber and SampleID values (paired with unique QbjectID values)

It shows up in a query of the table through this interface too: http://geodata.wgnhs.uwex.edu/arcgis/rest/services/lslc/MapServer/6/query?where=SampleId+%3D+210&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&outFields=*&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&outSR=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&returnDistinctValues=false&f=html

[cmrRose]

Possible culprit is Section#204140 , which seems to be a tiny island.

Might have duplicates of the samples in Section #204136, the large section on the mainland.

[cmrRose]

[schoep]

I'll check the sections geometry, but will likely need to merge features to multipart.

[schoep]

@cmrRose an update of both the PLSS Sections polygons and Sample table is ready to deploy. The PLSS sections were dissolved to multipart features so no more many-to-many joins. One major change is the new field "PlssId" to replace the ambiguous "SectionId". This new field appears in the both the PLSS Sections layer and the Sample table. Other fields in the PLSS Section have been renamed and cleaned-up for clarity. I'm waiting to deploy until you are ready to update the code to handle the new field.

[schoep]

@cmrRose the new services have been deployed. Let me know if you need any changes and I'll let you close the issue when ready.

[cmrRose]

The duplicate entries in the samples table are gone, thanks to you cleaning up the polygons.

The field designating section ID is now named PlssId in both the samples table and the sections layer.

In the samples table, the SampleId field has now become the esriFieldTypeOID field or OBJECTID field. This is the field that is returned in response to a query for ids.