Jump to content



Photo

SQL Database to GIS Mapping

sql esri arcmap gis mapping tables

  • Please log in to reply
3 replies to this topic

#1 Roger H.

Roger H.

    Neowinian Senior

  • Tech Issues Solved: 20
  • Joined: 18-August 01
  • Location: Germany
  • OS: Windows 8.1
  • Phone: Nexus 5

Posted 18 March 2014 - 13:44

Just wondering if any SQL Admins out there can help me pull up some addresses and Map it into ESRI ArcMap.

 

I got the Database Connection but with many tables, can't really figure out how to properly geocode the addresses and then layer them on the map.

 

Thanks :)




#2 riahc3

riahc3

    Neowin's most indecisive member

  • Tech Issues Solved: 11
  • Joined: 09-April 03
  • Location: Spain
  • OS: Windows 7
  • Phone: HTC Desire Z

Posted 18 March 2014 - 13:52

Just wondering if any SQL Admins out there can help me pull up some addresses and Map it into ESRI ArcMap.
 
I got the Database Connection but with many tables, can't really figure out how to properly geocode the addresses and then layer them on the map.
 
Thanks :)

Im sure that Ive misunderstood you...

You want to get a address "123 Bob Street" from a SQL server and then map it onto something (in this case ESRI ArcMap)?



#3 sc302

sc302

    Neowinian Senior

  • Tech Issues Solved: 28
  • Joined: 12-July 05
  • Location: NJ, USA

Posted 18 March 2014 - 13:58

I know what he is trying to do.  he wants to get the data out of the sql db and then basically merge it into the arcmap sql db address list and then have arcmap do its job to put in points of interest or addresses onto itself. 

 

I am not versed enough in sql to be able to do it.  I haven't played with ESRI in some time...Maybe 2010...

 

If you have ESRI support, they should be able to help you out with that request. 



#4 OP Roger H.

Roger H.

    Neowinian Senior

  • Tech Issues Solved: 20
  • Joined: 18-August 01
  • Location: Germany
  • OS: Windows 8.1
  • Phone: Nexus 5

Posted 18 March 2014 - 14:28

sc302 got that correct.

 

I have a SQL DB with address (14879) along with all the other details of the property.

 

I've linked SQL to ArcMAP via an OLE DB Connection (read only which is fine).

 

Now as mentioned, basically all I want to do is visually display address points on the GIS Map of the town and later on being able to display other details too say only properties that sold or pull data points from the DB such as "Neighborhoods" and overlay that information on the map using different colors for differ neighborhoods :).

 

I'm the resident "tech guy so I should know this stuff" but that's like asking a brain surgeon to do heart surgery because "(s)he's also a surgeon" :p

 

Thanks sc302, I've been going back and forth with a  ESRI tech person and waiting for a call but just figured i'd ask here as well.