1

I am very new to GIS and am using the ArcMap 10 program.

Currently, I am trying to set up a query layer from a remote database. I am able to connect to the database, but I am having trouble making the query because the table I want to use has a "bigint" column. From what I have read, ArcMap does not support this data type directly, though some sources suggest that there is a workaround by manually writing a query in the "name" and "Query" fields instead of using the "List of tables" and "columns" selection menus. I've tried this "workaround", and have not succeeded.

Is there any way that I can use my database in a query layer without modifying the database at all? Or can I connect the database to ArcMap in another way?

I am using a PostgreSQL DBMS.

Improve this question
1
  • 1
    This may or may not be a reference that you have read to say "ArcMap does not support this data type directly" (forums.arcgis.com/threads/…) but thought I would post in case it helps others assist you Commented Aug 1, 2012 at 23:23

1 Answer 1

Reset to default
1

In the query you used to define the Query Layer, you could cast this bigint column to another type that is supported by ArcGIS.

SELECT CAST(yourbigintcolumn as float)
Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.