AirVision is easily integrated with ARCGIS to create stunning maps of air pollution or meteorology data, thanks to the open nature of AirVision’s database. With only a few steps, you can easily integrate the two products to review data spatially.

First, a database connection will need to be made from ARCGIS to the AirVision database. Once you have opened your map, you will use a connection to create a layer for a particular pollutant, time range, and data average interval (probably hourly data). Right click “Layers” and select “Add Data”. Under “Look In”, select “Database Connections” and then “Add OLE DB Connection”


Choose “Microsoft OLE DB Provider SQL Server.”


You will be switched to the Connection tab. Enter the name of the SQL Server PC, the user name, and password required to connect with the server (if your SQL is on the same PC as ARCGIS, you can use Integrated Security). Select “AV Data” or whatever your actual database instance name is, and use the “Test Connection” button to verify connection.


You should then be prompted with a list of tables in AVData. You will want to scroll until you find the View called “Reporting.ReadingAverageDataFull.”


Select that, and then click “Add.”

Now that we are connected to the database and the main view, we need to refine what data we want and tell ARCGIS how we want it depicted.
Right-click the Reporting.ReadingAverageData view in ARCGIS and select “Display X-Y Data.” Select Longitude for X data, Latitude for Y data, but leave Z-Data blank. You will receive a warning about not having an Object ID field. Just ignore it.



Now, we can define the data we want. Right click on “Reporting.ReadingAverageDataFull Events” (you can rename this event layer to something else if you wish) and select “Properties.” Under “Definition Query”, we can query the various fields in the ReadingAverageDataView to narrow the scope of the data we want, either using the query builder, or our own knowledge of SQL Server. For example, this query limits the data set to hourly data for a particular day, and just the ozone data.


With the Symbology tab, you can choose a number of ways to depict the data (circles of varying sizes, graduating colors, etc), but the important part is to set Fields->Values to “Final Value.”


And before long… voila, we have a map.

For other details on using ARCGIS, contact ESRI Support.