colemanm

#!/usr/bin/env ruby

# Requires the rar utility
# apt-get install rar

# List of filenames to be extracted
l = File.read(ARGV[0])
# Password
p = ARGV[1]

colemanm

<OGRVRTDataSource>
    <OGRVRTLayer name="test">
        <SrcDataSource>test.csv</SrcDataSource>
        <GeometryType>wkbPoint</GeometryType>
        <LayerSRS>WGS84</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="Longitude" y="Latitude"/>
    </OGRVRTLayer>
</OGRVRTDataSource>

colemanm

colemanm

colemanm

select created_by,count(*) from changes where created_by is not null group by created_by order by count desc

colemanm

Register for LizardTech Developer Account

https://www.lizardtech.com/developer/

Download the SDK

• Mac: https://www.lizardtech.com/download/developer/MrSID_DSDK-8.5.0.3422-darwin11.universal.gccA42.tar.gz
• Linux: https://www.lizardtech.com/download/developer/MrSID_DSDK-8.5.0.3422-linux.x86-64.gcc44.tar.gz

colemanm

QGIS Open Image Custom Action

Use this guide to link a path name to a feature's photo in the attribute table.

This assumes you have a column in your data containing the full path to the image you'd like to open (in this example, a field called photo_path).

Create Action

1. Right click feature class → Properties
2. On Actions tab:

colemanm

#!/usr/bin/env ruby

require 'json'
require 'pg'
require 'sequel'

def database
  @db ||= Sequel.connect(adapter: 'postgres',
                         host: 'db.snichaos.com',
                         user: 'postgres',

colemanm

img {
    max-width: 100%;
	 height: auto;
} 

.right {float:right;}
.left {float:left;}

/* bannerSliders
-------------------------------------------------- */

colemanm

#!/usr/bin/env ruby

require 'json'
require 'fileutils'

data = JSON.parse(File.read(ARGV[0]))

sorted = JSON.parse(Hash[*data.sort.flatten].to_json)

json = []