Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
    
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 – PolyGeo Aug 1 '12 at 23:23

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)
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.