Everything happens somewhere, and organizations are realizing how important a role location, surroundings and time play in decision-making, including:
- Which driving route is least congested?
- Where's the closest top-rated French restaurant?
- Are field equipment malfunctions related to altitude or time of day?
- What people will be in a particular location given their current activity?
The challenge is how to store, index and query the massive quantities of spatial and temporal data generated via mobile phones, cameras, computers, sensors and Internet-enabled appliances.
This class will present the best practices emerging from the field of geospatial data and the specialized database systems developed to manage it. We will cover:
- Apps that inspire: novel ways geospatial data is being applied in government and industry
- Geospatial data management standards such as GeoJSON and GML; which should you follow?
- Geospatial basics: bounding box and proximity searches
- Advanced geospatial operations, including storing complex geometries, temporal, and geo-metadata; performing bounding polygon and radius, intersections, and buffering; and best practices for scaling and partitioning geospatial data
- Comparison of specific SQL and NoSQL geo-indexing libraries
Attend this class to learn how to best store, index, and query the spatial and temporal data generated by mobile devices, sensor networks, and Internet-enabled appliances. Fundamentals on geospatial data-management standards (GeoJSON, GML), bounding box and proximity searches, and the storage of geometries and geo-metadata will also be covered. Databases will include PostGIS and CouchDB (running on Cloudant).