170 likes | 193 Views
Explore Query Layers in ArcGIS for efficient database access & advanced functions. Discover spatial data types, setup files, & database connections. Enhance user experience through user-friendly tools and entity discovery.
E N D
Accessing Spatial Databases in ArcGIS using Query Layers Annie Sasidar and Said Parirokh
Road Map Accessing Spatial Databases in ArcGIS using Query Layers
Motivation Device Desktop Web Apps Portal Access / Identity Services Server Online Content and Services Accessing Spatial Databases in ArcGIS using Query Layers
Query Layer at 10.0 Accessing Spatial Databases in ArcGIS using Query Layers
Query Layer 10.1 onwards Accessing Spatial Databases in ArcGIS using Query Layers
Database or Geodatabase? Accessing Spatial Databases in ArcGIS using Query Layers
Tables + spatial types Accessing Spatial Databases in ArcGIS using Query Layers
Tables+ Spatial types + Advanced functionality Accessing Spatial Databases in ArcGIS using Query Layers
Alitbase Dameng SAP Hana Teradata SQLite SQL Server Oracle PostgreSQL IBM DB2 Netezza
How does connection work? Accessing Spatial Databases in ArcGIS using Query Layers
Client setup files Accessing Spatial Databases in ArcGIS using Query Layers
Database Access • View Content • Spatial Data types supported in ArcGIS ->( resources.arcgis.com) • Non-Spatial search for DBMS data types supported in ArcGIS • Unregistered tables within a GDB • Dynamic information • Database Administration • Add user • Add content • Work with layers • Set properties • Analyze • Edit tables • Feature Service at 10.2 Accessing Spatial Databases in ArcGIS using Query Layers
Summary • Improved connection user experience • Discover entity type on opening the spatial class • Works as a Feature layer in ArcMap • Use GP tools for analysis • Publish as map service • Layer package • Edit as a feature service from 10.2 Accessing Spatial Databases in ArcGIS using Query Layers
Resources Query Layer http://resources.arcgis.com/en/help/main/10.2/index.html#/What_is_a_query_layer/00s50000000n000000/ Changes in Query Layer http://support.esri.com/en/knowledgebase/techarticles/detail/41246 The Evolution of Query Layers(Blog) http://blogs.esri.com/esri/supportcenter/2014/04/08/the-evolution-of-query-layers/ Accessing Spatial Databases in ArcGIS using Query Layers
Related Sessions Web Enabling Databases with ArcGIS for Server : http://geochannel.esri.com/index.cfm?event=video.view&channelId=1&videoId=4773 Accessing Spatial Databases in ArcGIS using Query Layers
Please take our Survey Your feedback allows us to help maintain high standards and to help presenters Find your event in the Esri Events App Find the session you want to review Scroll down to the bottom of the session Answer survey questions and submit
Thank you… Accessing Spatial Databases in ArcGIS using Query Layers Please fill out the session survey: First Offering ID : 1168 Second Offering ID: 1169 Accessing Spatial Databases in ArcGIS using Query Layers