Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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?

Update I am using a Postgres DBMS.

share|improve this question
1  
What DBMS is your database stored in? –  PolyGeo Aug 1 '12 at 1:54
    
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

1 Answer 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)
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.