-
Recent Posts
Archives
- July 2016
- April 2015
- January 2015
- October 2014
- September 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- January 2014
- August 2013
- March 2013
- February 2013
- January 2013
- December 2012
- June 2012
- April 2012
- March 2012
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
Categories
Blogroll
Meta
Monthly Archives: March 2011
Importing a Shapefile into PostgreSQL
I tried to import a shapefile to a PostgreSQL database using SPIT in QGIS, but kept getting an error because the gid column already existed in the .dbf. So I used the command line instead: shp2pgsql Downloads/Archive/data_dev.shp > data.sql then … Continue reading
Posted in PostgreSQL
1 Comment
Taking the top 5 of grouped ranked data in PostgreSQL
Working from a list of my ancestors’ occupations I wanted to list the top 5 occupations in each occupational category per decade, so that given year category description total … 1851 Agriculture Ag Lab 4 1851 Agriculture Farm Bailiff 1 … Continue reading
Posted in PostgreSQL, SQL
Leave a comment