sjg

Mapping, Counting, Recovering: Humanities through the Digital Lens' Workshop - UCL DH / QMU - March 2024

Introduction

This workshop session will show you how to turn a raw data spreadsheet in excel into ann interactive digital map using some free online tools and some code on this page. Learn how to Geocode some data in a Google Sheet and then export the data onto geojson.io.

Tutorial Video Link

• https://youtu.be/xfdHzVriFe8 - 44 mins

Tools used for this Example

sjg

Execute Install Script from Powershell

1. Open PowerShell (Windows key + R, type powershell and press Enter).
2. Copy and Paste the following commands

Set-ExecutionPolicy RemoteSigned -Scope CurrentUser 
irm get.scoop.sh | iex
Start-Process powershell.exe -Verb RunAs

sjg

Execute Install Script from Powershell

1. Open PowerShell (Windows key + R, type powershell and press Enter).
2. Copy and Paste the following commands

Set-ExecutionPolicy RemoteSigned -Scope CurrentUser 
irm get.scoop.sh | iex
Start-Process powershell.exe -Verb RunAs

sjg

var mqtt = require('mqtt');
var request = require('request');

var client  = mqtt.connect('mqtt://test.mosquitto.org')

client.on('connect', function () {
  console.log("");
  console.log("Connected to MQTT Server");
  client.subscribe('#')
})

sjg

$search = [                     // www.fileformat.info/info/unicode/<NUM>/ <NUM> = 2018
                "\xC2\xAB",     // « (U+00AB) in UTF-8
                "\xC2\xBB",     // » (U+00BB) in UTF-8
                "\xE2\x80\x98", // ‘ (U+2018) in UTF-8
                "\xE2\x80\x99", // ’ (U+2019) in UTF-8
                "\xE2\x80\x9A", // ‚ (U+201A) in UTF-8
                "\xE2\x80\x9B", // ‛ (U+201B) in UTF-8
                "\xE2\x80\x9C", // “ (U+201C) in UTF-8
                "\xE2\x80\x9D", // ” (U+201D) in UTF-8
                "\xE2\x80\x9E", // „ (U+201E) in UTF-8

sjg

echo -e "\033[91m\xE2\x9c\x98 - Can't find text"
echo -e "\033[92m\xE2\x9c\x94 - Found Text"

sjg

ALTER TABLE photo_locations ADD `points` point DEFAULT NULL;

UPDATE photo_locations SET points = coords;

/* OR If your points coloum in a VARCHAR */
UPDATE photo_locations SET points = POINT(lon,lat);


# MYSQL 5.7.8
# CREATE FUNCTION `distance_old_user`(a POINT, b POINT) RETURNS double DETERMINISTIC

sjg

- (void)viewDidLoad {
    [super viewDidLoad];
    // Do any additional setup after loading the view, typically from a nib.
   
    CGRect screenRect = [[UIScreen mainScreen] bounds];
    CGFloat screenWidth = screenRect.size.width;
    CGFloat screenHeight = screenRect.size.height;
    
    UIWebView *webview=[[UIWebView alloc]initWithFrame:CGRectMake(0, 0, screenWidth, screenHeight )];
    NSString *url=@"https://google.com/";

sjg

# TripSensor Install Info
 
# Getting BU353-S4 GPS Device Working on Raspberry Pi
# ************************************************************
sudo apt-get -y install gpsd gpsd-clients python-gps

# Change file with settings
nano /etc/default/gpsd

# Default settings for gpsd.

sjg

# Setup Script for BENVGSC4 Database Virtual Machine 
# -- CENTOS VM Setup
# -- Machine Specs 
# -- Author:  Steven Gray, Jan 2015
# -- Version: 1.0

# Do not run this file -- this will not install all features, manually install these

# Setup System
yum -y install htop