laptop and a wrench

Bug

A query layer published as a referenced map service results in inconsistent pop-up counts in Portal for ArcGIS Map Viewer.

Portal for ArcGIS
Bug ID Number BUG-000160511
SubmittedAugust 9, 2023
Last ModifiedDecember 1, 2025
Applies toPortal for ArcGIS
Version found10.8.1
Operating SystemWindows Server
Operating System VersionN/A
StatusNon-Reproducible

Additional Information

The SQL produces some geometries that are not oriented correctly. Use one of the following two options to resolve the issue. Option 1: Reorient large polygons. SELECT Iif(Shape.STArea() > 510065620000000, Shape.ReorientObject(), Shape) as Shape, OID FROM (SELECT OID ,case when left(workarea,3) = 'Pol' then geography::STPolyFromText(WorkArea,4326).MakeValid() else geography::STGeomFromText(WorkArea,4326).MakeValid().STBuffer(15.24) end as Shape FROM aTable) a Option 2: Use Geometry instead of Geography. SELECT Shape, OID,Shape.STArea() as Area FROM (SELECT OID ,case when left(workarea,3) = 'Pol' then Geometry::STPolyFromText(WorkArea,4326).MakeValid() else Geometry::STGeomFromText(WorkArea,4326).MakeValid().STBuffer(15.24) end as Shape FROM aTable) a

Steps to Reproduce

Bug ID: BUG-000160511

Software:

  • Portal for ArcGIS

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options