Posts

Showing posts from March, 2023

SVG to GIS Vector Data Conversion and Vice Versa

Image
How to convert SVG (Scalable Vector Graphics) to GIS Vector Data (SHP or Mapinfo or any other format) using QGIS and Inkscape. GIS and Inkscape is a free and open source software that you can download from their respective site.

How to Build HTML Form with Ability to Extract Geolocation Data From the Browser/Mobile Devices and Populate the Form Data in Google Sheets

Image
Just as the post title suggest, this post is about how to do it. Here are the steps.  1. Create a New Google Sheets Spreadsheet. Give a meaningful and consistent header such as the image below:  2. Share it as public (anyone with the link) and set the anyone as Editor.  3. From the GSheets Menu, go to Extension > App Scripts.  4. Delete the initial function, and copy/paste code snippets below.  // Original code from https://github.com/jamiewilson/form-to-google-sheets // Updated for 2021 and ES6 standards const   sheetName  =  'Geolocation' const   scriptProp  =  PropertiesService . getScriptProperties () function   initialSetup  () {    const   activeSpreadsheet  =  SpreadsheetApp . getActiveSpreadsheet ()    scriptProp . setProperty ( 'key' ,  activeSpreadsheet . getId ()) } function   doPost  ( e ) {  ...