geodatabases

Analyzing Fire Department Response with PostGIS

Analyzing Fire Department Response with PostGIS

Local government fire departments always face scrutiny of their performance and efficiency. They are continuously asked to do a better job with fewer resources. In this highly technical session we will show how PostGIS is being used to analyze and measure performance throughout the city and plan for future resource requirements. Every city we work with is unique in some ...

Read More »

Setup, create and manage a PostgreSQL Enterprise Geodatabase in ArcGIS

Setup, create and manage a PostgreSQL Enterprise Geodatabase in ArcGIS

When you need a large, multiuser geodatabase that can be edited and used simultaneously by many users, the Enterprise geodatabase provides a good solution. It adds the ability to manage a shared, multiuser geodatabase as well as support for a number of critical version-based GIS workflows. The ability to leverage your organization’s enterprise relational databases is a key advantage of ...

Read More »

LIDAR In PostgreSQL With Pointcloud

LIDAR In PostgreSQL With Pointcloud

How do you store massive point cloud data sets in a database for easy access, filtering and analysis? The new PointCloud extension for PostgreSQL allows LIDAR data to be loaded, filtered by spatial and attribute values, and analyzed via integration with PostGIS. We’ll discuss the extension implementation, basics of loading data with PDAL, and how to use PointCloud with PostGIS ...

Read More »

Mending Spatial Data with PostGIS

Mending Spatial Data with PostGIS

This presentation demonstrates common techniques to clean-up spatial data from a real-world data source. I will start with raw OSM data. Topics I’ll cover: 1) Getting OSM data 2) How to merge multilinestrings into single linestrings. 3) Fill in gaps, snapping, reducing resolution 4) Consolidating geometries with aggregate functions ST_Union, ST_MakeLine, ST_Collect based on both spatial and non-spatial attributes

Read More »

Geospatial Queries

Geospatial Queries

Geotools is an open source Java library that provides tools for geospatial data. It provides an implementation of Open Geospatial Consortium (OGC) specifications as they are developed. In this talk, Pablo explains us what Geotools is and what we can use it for. He also tells us about Geospatial databases and CQl queries.

Read More »