Search

Viewing PostGIS data with an FME Connection in ArcGIS

Liz Sanderson
Liz Sanderson
  • Updated

Symptom

When previewing a PostGIS table after creating an FME Connection to it in ArcGIS the following symptoms may occur:

- a message "The current selection be displayed as a table" appears
- an empty table appears
- an error about a numeric index appears

Cause

To see the table in ArcGIS you must have a unique integer field in your table when writing to PostGIS.
 

Resolution

Using SQL Command: Using SQL Statement create a spatial index on the table. See troubleshooting documentation for the commands.
In FME Desktop: Use the "int4" type on the destination schema with "PRIKEY" set for the Index to achieve this. A Counter can be used to create unique values if they do not already exist on your features.

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.