search

smnorris / bcfishobs

Reference BC Known Fish Observations to the Freshwater Atlas stream network
Apache License 2.0
6 stars 2 forks source link

cannot add postgres view to arcgis desktop #8

Closed smnorris closed 4 years ago

smnorris commented 5 years ago

On ArcGIS 10.1 - perhaps this isn't an issue for current versions but it could be valuable to write whse_fish.fiss_fish_obsrvtn_events_vw as a table or maybe materialized view

smnorris commented 4 years ago

For QGIS it seems the issue was that the Geometry types have to be exactly defined. A view is displayed in the browser window if the point geom is coerced: ::geometry(Point, 3005) in the query that defines the view/materialized view.

smnorris commented 4 years ago

Looks like it was the same issue with Arc.