Open Source Options to Publish GIS Services

2019-11-19T13:43:30-06:00

The What and Why of REST Services:   ESRI Configuration:   Open Source Options: GeoServer + any free WMS OpenLayers   GeoNode   QGIS Cloud LizMap Additoinal Paid Hosting Services: Mapbox CartoDB  

Open Source Options to Publish GIS Services2019-11-19T13:43:30-06:00

Important SQL Tricks for GIS

2019-11-19T13:39:42-06:00

Basic SQL Structure SELECT * FROM Table; This is as simple as it gets. Simple Query SELECT ID, NAME FROM Table WHERE ID = 3;   Finding Unique Values SELECT DISTINCT NAME FROM Table GROUP BY NAME;   Counting Groups of Occurrences SELECT DISTINCT NAME, COUNT(*) FROM Table GROUP BY NAME;   Math sdf Summarize groups [...]

Important SQL Tricks for GIS2019-11-19T13:39:42-06:00