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