Skip to content
No results
  • Archives
  • Best of GitHub
    • Quine Relay
    • Stacksort
  • Best of YouTube
  • Causal stuff
  • My Stuff
    • My Javascript demos
    • Download geodata
  • Tricks
    • AWS Tricks
    • Beat tricks
    • Datasets
    • Encoding Tricks
    • Geo Tricks
    • Git tricks
    • Linux Tricks
    • Neo4j tricks
    • NumPy & Pandas Tricks
    • PHP tricks
    • Python Tricks
    • Skipper Tips
    • SQL Snippets
SKIPPERKONGEN
  • Archives
  • Best of GitHub
    • Quine Relay
    • Stacksort
  • Best of YouTube
  • Causal stuff
  • My Stuff
    • My Javascript demos
    • Download geodata
  • Tricks
    • AWS Tricks
    • Beat tricks
    • Datasets
    • Encoding Tricks
    • Geo Tricks
    • Git tricks
    • Linux Tricks
    • Neo4j tricks
    • NumPy & Pandas Tricks
    • PHP tricks
    • Python Tricks
    • Skipper Tips
    • SQL Snippets
SKIPPERKONGEN
  • Spatial stuff

OpenStreetMap tiles with custom projection and grid using Mapnik

Previous effort In a previous post I tried generating OpenStreetMap tiles using GeoServer. It ended when I couldn’t find a good style (SLD) to apply the OSM layer. The (new) idea, that also failed miserably In this post I tried…

  • kostas
  • October 11, 2011
  • Command line Fu, Systems

how to delete/empty S3 bucket with many objects

There is a good little tool called s3funnel on GitHub for this. I used easy_install to install on my Mac. easy_install s3funnel

  • kostas
  • October 10, 2011
  • Systems

Select rows based on date in Oracle database

E.g. to select rows with a timestamp on minutes 0, 5, 10, …, 55 select * from t where mod(to_number(to_char(date_time_col, ‘mi’)),5)=0

  • kostas
  • October 8, 2011
  • Systems

How to alternately select m rows every n rows in oracle sql

For m=10 and n=100 add the following where clause WHERE mod(rownum, 100)

  • kostas
  • October 7, 2011
  • Command line Fu

Check if shared library is installed on Mac OS X

One way to check whether a library is installed is to use ld, e.g. check that zlib is installed: ld -lzlib If library is installed you’ll get something like this: ld: warning: -arch not specified ld: could not find entry…

  • kostas
  • October 5, 2011
  • Command line Fu

Checking for disc overload on linux

The trick is to use vmstat and look at the number for “wait on acknowledge”. vmstat -S m 1 100 Look under “cpu” and the “wa” column. If this number is high, it is bad. It should be zero. Some…

  • kostas
  • October 5, 2011
  • Command line Fu, Spatial stuff

OpenStreetMap tiles in EPSG:25832 projection using GeoServer

Warning: This is a description of how to create a OpenStreetMap WMS with GeoServer. It works fine up to the point where the layers published as an unstyled WMS. This is where I’ve not been able to produce a good…

  • kostas
  • September 16, 2011
  • 4 Comments
  • Programming

Fetching static JSON files cross site with jQuery.

Say you have a static JSON file sitting on a web server, e.g. mystaticfiles.com on Amazon S3 or a CDN. For the sake of argument, let’s imagine that it’s a configuration file. The contents of the file looks like this:…

  • kostas
  • September 16, 2011
  • 3 Comments
  • Command line Fu, Spatial stuff

Reprojecting shapefiles with ogr2ogr

If you have an ESRI Shapefile (.shp) that you want to reproject, you can use ogr2ogr ogr2ogr -t_srs newfile.shp oldfile.shp The EPSG code could be for instance epsg:28532.

  • kostas
  • September 13, 2011
  • Command line Fu

Creating a word cloud from PDF documents

Warning: This is not the hardest way to create a word cloud from pdf-documents, but it’s up there. Say you have directory containing pdf documents: $ ls a.pdf b.pdf c.pdf …

  • kostas
  • September 7, 2011
  • 5 Comments
Prev
1 … 21 22 23 24 25 26 27
Next
Copyright © 2026 - WordPress Theme by CreativeThemes