AnsweredAssumed Answered

postgresql error st_point

Question asked by sanhita_tgt on Sep 12, 2019
Latest reply on Sep 12, 2019 by sanhita_tgt

I am doing a union of multiple tables to create a view. All table include shape and have the same geometry type. I am getting the following errors while creating the spatial view: ERROR: could not identify an equality operator for type st_point LINE 8: td.shape . What am I not defining in shape in either tables that is causing the error?

A sample of my query for the view is as follows:

 

SELECT
td.storenum,
td.address,
td.city,
td.state,
td.zip,
td.shape
FROM
competitor_td td

where td.catcode= '05'

 

union

select
vw.store_num as storenum,
vw.address,
vw.city,
vw.st_abbrv as state,
vw.zip_code as zip,
vw.shape
FROM
store_vw vw
WHERE  vw.status <> 'Closed'

Outcomes