rbanick

Private Function CheckStringCHAR(InString) As String

' CheckStringCHAR(InString)
' Returns its passed agrument, but with exchanged European? characters
' Function created 7/08/2003 by Stanley D. Grom, Jr.
'
CheckStringCHAR = ""
StringLength = Len(InString)

For i = 1 To StringLength

rbanick

#!/bin/bash

# This will convert PDF atlases to .pngs and then convert them back to .PDF, now rasterized.
# Use this script to flatten PDF exports from QGIS so you can generate thumbnails for the Mapfolio

### DEPENDENCIES
# This script uses parallel, imagemagick and ghostscript. 
# To install: brew install imagemagick && brew install parallel && brew install gs
# Please note: Ghostscript does not automatically come installed with imagemagick.

rbanick

#!/bin/bash

# This will convert PDF atlases to .pngs and then convert them back to .PDF, now rasterized.
# Use this script to flatten PDF exports from QGIS so you can generate thumbnails for the Mapfolio

# This script uses imagemagick and ghostscript.
# Please note: Ghostscript does not automatically come installed with imagemagick. Run 'brew install gs' to install it.

## Atlas Conversion

rbanick

Creating custom OBF files for OsmAnd

Setup

1. Make sure the latest version of java is installed.
2. Download OsmAndMapCreator from here: http://download.osmand.net/latest-night-build/OsmAndMapCreator-main.zip
3. Download a PBF file for your area of interest from Geofabrik (http://download.geofabrik.de/) or other source (e.g. activation wiki)
4. Create an OBF folder on your desktop
5. Unzip your OsmAndMapCreator folder to whatever location you want.

rbanick

Building swipers from the Guinea-swipe code

Making the maps

To be filled in!

Cleaning up the code

Github

rbanick

Rolling back Homebrew formula on a UNIX platform

The problem

Sometimes brew updates break your computer or a piece of software. This is usually really unpleasant as it can take some time to diagnose which formula at which version did so. Even if you can diagnose, it's not very clear how to roll back homebrew softwares to previous versions.

How to fix it

rbanick

#### getting intersects of roads from a district. To eliminate bordering things using ST_Contains

DROP TABLE chitawan_roads_intersect;

CREATE TABLE chitawan_roads_intersect
WITH (OIDS)
AS
	SELECT osm_roads_4326.*
	FROM osm_roads_4326, districts
		WHERE

rbanick

## create summary table

CREATE TABLE temp_table AS 
(select 
	 	count(id) AS features_per_ADMIN, 
		avg(master_table.thing_to_average) AS avg_thing_to_average, 
		sum(master_table.thing_to_sum) AS sum_thing_to_sum, 
		count(master_table.thing_to_count) AS count_thing_to_count, 
		COUNT(DISTINCT master_table.thing_to_count_distinct) AS cntd_thing_to_count_distinct, 	
		## ...add as many summary fields as you want here

rbanick

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

rbanick

QGIS Atlas Techniques

Basics

Creating an Atlas Layer

1. Create a shapefile that includes ONLY the features you want to create an atlas of (e.g. only the districts you want maps of)
2. Open a new print composer. Give it a name you can remember, like 'Atlas'
3. Go to the 'Atlas Generation' tab and check the box next to "Generate Atlas".