topic Re: query layer ST_Z(Shape) Postgresql - attribute column not found in Geodatabase Questions

query layer ST_Z(Shape) Postgresql - attribute column not found

RichardWebb2 — Fri, 03 Feb 2017 03:28:50 GMT

Hi,

This query works in PGAdmin and validates via the Edit query dialog in ArcGIS 10.5 however raises:

select *,ST_Z(Shape) AS "Height" from awsprod.lccgis.FLO_BUILDING_FLOOR_HEIGHTS

If I remove the all important ST_Z(Shape) AS "Height" the query works fine in the attributes.

Regards,

Richard

Re: query layer ST_Z(Shape) Postgresql - attribute column not found

KevinDunlop — Fri, 03 Feb 2017 14:40:41 GMT

I had a similar problem in Oracle the other day. It was related to using a function that returned value with an input value that was too long (too many string characters) for the function. So with that, I wonder if your ST_GEOMETRY might be not have z values. If you view the query's results in pgAdmin what values are being returned from ST_Z(Shape)?

Re: query layer ST_Z(Shape) Postgresql - attribute column not found

VinceAngelo — Fri, 03 Feb 2017 16:50:43 GMT

Placing the double-quotes around "Height" may have forced the SELECT result set to have a column named "Height", which ArcGIS cannot "see" because it requires ANSI-conformant SQL naming. Try eliminating the double-quotes from the SELECT statement.

- V

Re: query layer ST_Z(Shape) Postgresql - attribute column not found

RichardWebb2 — Sun, 05 Feb 2017 21:27:45 GMT

Without quotes of any kind this is working. Thanks Vince.

select *,ST_Z(Shape) as Height from awsprod.lccgis.FLO_BUILDING_FLOOR_HEIGHTS