Here I’m going to show you how you can accomplish this.
![esri query table tool esri query table tool](https://community.esri.com/legacyfs/online/421803_TableTest_tool.png)
Now, the key thing here is you know you have a common ID between the spatial feature that you want to select, and the non-spatial table that you want to join to. It’s a non-spatial data table living in SQL server and I happen to want to join that to my fire hydrants.
![esri query table tool esri query table tool](https://static.filehorse.com/screenshots-mac/developer-tools/mysql-workbench-screenshot-03.jpg)
One particular one being the facility ID, this is essentially the fire hydrant ID and I happen to have an SQL database table which highlights the inspections performed on these fire hydrants. This fire hydrants layer has a variety of attributes on it. I’ve just got a single layer that I’ve added, I’ve got two layers, one is my Open Street Map base map and my Fire Hydrants layer. Here you can see that I’m in Geocortex Essentials Manager and currently I am on the map tab. This is done through the data linking technology that ships with Geocortex Essentials. In this Tech Tip video, I’m going to show you how you can display data from SQL databases inside of your Geocortex Viewers when selecting features on the map. I work on our technical marketing team, and in this tech tip video I’m going to show you how you can display data from SQL databases when selecting a feature on the map using our data linking technology. “Hi everyone, my name is Patrick Fingler.
#Esri query table tool how to#
In this week’s Geocortex Tech Tip, we focus on SQL databases specifically, and how to quickly access and display data within your Geocortex Viewers via the data linking technology in Geocortex Essentials. No duplication or synchronization of data is required either all you need is a relational database with data that contains a shared key or attribute. Our technology quietly queries outside databases and displays relational data seamlessly alongside spatial data. With Geocortex Essentials, you can pull this non-spatial data into your application and work with it on the map. When it comes to data, not everything you need to interact with lives in a spatial database. Displaying data from SQL Database when you select features