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.

In Denmark many municipalities have the same provider of public data. These data are pushed to a local database – often a SQL Server. The DBMS layout is the same for all municipalities.

When I create a linked table from the SQL Server, I can save (or load) a .sql file in the MapInfo dialog.

This .sql-file is portable and I can share it with municipalities with the same setup – but only with MapInfo-municipalities.

Recently I had a post at a conference on this item and I urged my colleagues to use my .sql-files and/or my source code. I was however unable to guide my colleagues from the ArcGis-municipalities.

Can anyone give me some heads up on this matter? Is it possible to do In ArcGis? The .sql file from MapInfo contains the plain SQL query which is sent to the SQL Server:

I.e. :

Select 
"JY72000V"."VEJ_NAVN"+ ' '+ "JY72000V"."HUS_NR" As Adresse, 
"JY70100V"."KOMMUNENUMMER" AS Kommunenummer, 
"JY70100V"."EJENDOMSNR" AS Ejendomsnummer, 
Cast("JY72000V"."KOMMUNENUMMER" As varchar(3)) + Cast("JY72000V"."VEJKODE" as varchar(4)) + "JY72000V"."HUS_NR" As ADRESSE_ID
From "ql5020pd"."dbo"."JY70100V", "ql5020pd"."dbo"."JY72000V"
Where "JY70100V"."ADG_ID"="JY72000V"."ADG_ID"

Thanks for any help

Søren Breddam,

Stevns Kommune

share|improve this question

1 Answer 1

You should be able to do this using the Query Layer functionality in ArcMap. From File->Add Data->Add Query Layer. This should allow you to add as a layer (or table) a standard SQL query. See example below:

enter image description here

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.