https://community.esri.com/t5/arcgis-pro-questions/can-i-convert-query-tables-containing-point-and/m-p/1704863#M103368 <P>We receive a weekly download from a third party containing 5 Highways pipe and node data features. The party had been providing this as Query Feature Class items packaged in a geopackage (.GPKG) file, and these were readily convertable using the Feature Class to Shapefile tool in Pro. However, they've now changed the packaged data to Query Table (-see screenprint of source when added to a Pro project) which, without any easily-rendered geodata or XY columns or the like, aren't readily convertable to the shapes that we use.</P><P>The 2 point features DO contain columns holding POINT data and what appear to be XY values, ditto the 3 line features contain columns with LINESTRING data (-see egs attached), but I cannot see any way that we can use a tool for a simple conversion: there seem to be no tools that interrogate that POINT and LINESTRING data for a start. Or am I missing something obvious ?</P> Thu, 28 May 2026 12:31:23 GMT JulieEdwards 2026-05-28T12:31:23Z https://community.esri.com/t5/arcgis-pro-questions/can-i-convert-query-tables-containing-point-and/m-p/1704863#M103368 <P>We receive a weekly download from a third party containing 5 Highways pipe and node data features. The party had been providing this as Query Feature Class items packaged in a geopackage (.GPKG) file, and these were readily convertable using the Feature Class to Shapefile tool in Pro. However, they've now changed the packaged data to Query Table (-see screenprint of source when added to a Pro project) which, without any easily-rendered geodata or XY columns or the like, aren't readily convertable to the shapes that we use.</P><P>The 2 point features DO contain columns holding POINT data and what appear to be XY values, ditto the 3 line features contain columns with LINESTRING data (-see egs attached), but I cannot see any way that we can use a tool for a simple conversion: there seem to be no tools that interrogate that POINT and LINESTRING data for a start. Or am I missing something obvious ?</P> Thu, 28 May 2026 12:31:23 GMT https://community.esri.com/t5/arcgis-pro-questions/can-i-convert-query-tables-containing-point-and/m-p/1704863#M103368 JulieEdwards 2026-05-28T12:31:23Z https://community.esri.com/t5/arcgis-pro-questions/can-i-convert-query-tables-containing-point-and/m-p/1705279#M103401 <P>I think you'd need to edit that Query definition to either remove the<A href="https://learn.microsoft.com/en-us/sql/t-sql/spatial-geometry/stastext-geometry-data-type?view=sql-server-ver17" target="_self"> STAsText</A> and return the straight geometry, or to cast it back into geometry using&nbsp;<A href="https://learn.microsoft.com/en-us/sql/t-sql/spatial-geometry/stgeomfromtext-geometry-data-type?view=sql-server-ver17" target="_blank">STGeomFromText (geometry Data Type) - SQL Server | Microsoft Learn</A></P> Fri, 29 May 2026 18:43:11 GMT https://community.esri.com/t5/arcgis-pro-questions/can-i-convert-query-tables-containing-point-and/m-p/1705279#M103401 AlfredBaldenweck 2026-05-29T18:43:11Z