pixelcooker

How to perform Forward Geocoding (convert Address to Latitude Longitude Coordinates) automatically in Google Sheets Spreadsheet. Example using OSM's Nominatim API service. Other geocoding services such as Google, Bing, MapQuest, Mapbox, or ArcGIS Online also supported as long as you provide the API key and correct query URL in the URL cells.

This video is about how to fix, clean, remove dangling nodes, overshoot, undershoot, or loose ends commonly found in Polyline GIS data, in very fast, automatic and easy way using ArcGIS Desktop (also can be done in ArcGIS Pro). These error will limiting further processing such as polygons generation from polylines data or other needs. The secret is using hidden but super powerful CLEAN command in ArcInfo Coverage format from the golden DOS age of GIS in the 80's.

A few months ago, I created a video tutorial about how to serve raster or imagery tiles using Github  using TMS/XYZ Tile Serving protocol. The tiles can be consumed by a web gis app either as a base  map or operational layer. Although the workflow is proven to be working for general cases, the tiles  displaying and loading speed are quite mediocre compared to API-based serving such as WMS,  WMTS, or ArcGIS Services.  Now, there is one protocol called PMTiles that can also provide similar functionality with additional  features and better loading/displaying performance. PMTiles in many ways is similar to Mapbox  MBTiles format (the tiles are packed into a single file), or ArcGIS's TPK Package. However, PMTiles  can be served directly using a common HTTP query (not like MBtiles or TPK which must be deployed into API Services to be able to be consumed by a webgis client). So, if you want to use Github as your host, you won't find an uploading problem because the file can be upload