Bridging the Gap: SQL and ArcGIS Querying скачать в хорошем качестве

Bridging the Gap: SQL and ArcGIS Querying

GIS shapefiles and standalone tables are fundamentally built on the premise of relational databases. As such, the query mechanisms in GIS are built around the language of relational databases, namely SQL. This Lunch and Learn will cover the crosswalk between these two approaches to querying and the underlying mathematical operations at play (don't worry; it won't be mathy). This topic is designed for someone from either perspective to gain knowledge of the other and to encourage geospatial professionals to think through their queries as an exercise in tabular thinking, enhancing their problem-solving skills in selection tasks. It is likely that if you did not learn GIS from a computing-oriented professor, you will learn a lot about what's going on with your query system by watching this video. If you are a computing professional that has never seen a GIS, this will serve as an introduction about how to leverage your knowledge of SQL to query features within a GIS environment.