Select to view content in your preferred language

Can I convert Query Tables containing POINT and LINESTRING data directly to Feature class or Shapefile using a tool in Pro?

252
1
a week ago
JulieEdwards
Occasional Contributor

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.

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 ?

0 Kudos
1 Reply
AlfredBaldenweck
MVP Frequent Contributor

I think you'd need to edit that Query definition to either remove the STAsText and return the straight geometry, or to cast it back into geometry using STGeomFromText (geometry Data Type) - SQL Server | Microsoft Learn

0 Kudos