spatialite find if point is in polygon

How to find if a point is in a polygon. The shape file I used is tigerline data from the census site. I created a new database and imported the shapefile. $ spatialite us.sqlite SpatiaLite version ..: 4.1.1 Supported Extensions: - 'VirtualShape' [direct Shapefile access] - 'VirtualDbf' [direct DBF access] - 'VirtualXL' [direct XLS access] - 'VirtualText' [direct CSV/TXT access] - 'VirtualNetwork' [Dijkstra shortest path] - 'RTree' [Spatial Index - R*Tree] - 'MbrCache' [Spatial Index - MBR cache] - 'VirtualSpatialIndex' [R*Tree metahandler] - 'VirtualXPath' [XML Path Language - XPath] - 'VirtualFDO' [FDO-OGR interoperability] - 'SpatiaLite' [Spatial SQL - OGC] PROJ. [Read More]

creating a debian package for python library

This as a quick and dirty (filthy) guide to creating a debian package for a pythin library stored in a git repository. I assume you have no gzip file to download and compile the which is what the standard package building tools expect. I used information here as a basis. Dependencies: python-stdeb devscripts In the root of your git repo run the following command to “debianize”. python setup.py --command-packages=stdeb. [Read More]

Using the puppet provisioner with vagrant

I needed to setup a quick dev environment using debian wheezy with mongodb. Vagrant is my go to for testing things out with mucking up my laptop. The first step was go get a vagrant box with wheezy. Puppetlabs has a nice collection of boxes available. An easy to use puppet module for mongodb is available from the module forge. mkdir vagrant_mongo cd vagrant_mongo # Create Vagrantfile vagrant init debian-73-x64-virtualbox-puppet http://puppet-vagrant-boxes. [Read More]

Setting up FTDI cable for Chirp and Yaesu VX-6

Chirp is free software to configure ham radios. I have an Ubuntu 12.04 install of linux that I wanted to run the software from. What I had to do to get linux to recognize the cable. I installed the daily snapshot (version 20140428~precise~1) of chirp. Directions for installing chirp software can be found here. However, the guide under manual method for getting the cable working did not work for me. [Read More]

Exploring openstreetmap

I want to make a map of the continental united states (CONUS) that contains the US border, state borders and major highways using data from OpenStreetMap. It can’t be that difficult, right? Getting OpenStreetMap Data The first order of business is getting the data. A quick google search led me to the Downloading data page on the OpenStreetMap wiki. A quick look through extracts that others provide did not seem to have what I wanted so I opted to download the entire planet. [Read More]

Using ffmpeg to speed up video

I needed to speed up video and found this post. I also needed to remove the audio track which you can do with the -an option. The command ended up looking like: ffmpeg -i invideo.mp4 -vf "setpts=(1/<multiplier>)" -an outvideo.mp4 I then wanted to trim some time off the video. This post was helpful and I ended up with ffmpeg -i invideo.mp4 -vcodec copy -acodec copy -ss 00:00:03.000 outvideo.mp4 I only needed to trim 3 seconds off the beginning. [Read More]