Posts Tagged “PostGIS”

Ubuntu GIS from Scratch: Step 4 – Loading Data.

(Note – this post was updated on October 28 to include new information!) Welcome to Step Four in our exploration of open source GIS using Ubuntu. In the previous installment, we spatially extended our PostgreSQL database server with PostGIS. Now we’re ready to load some geographical data into our database. PostGIS includes a tool called [...]

Read more »

Ubuntu GIS from Scratch: Step 3 – PostGIS

Welcome to Step Three in our exploration of open source GIS using Ubuntu. In order to grasp the full power of GIS, we need to spatially extend our database (PostgreSQL, which was installed in the first step). The spatial extension for PostgreSQL is PostGIS. In the second step, we installed GEOS and GDAL, two major [...]

Read more »

Ubuntu GIS from Scratch: Step 2 – GEOS and GDAL

Welcome to Step Two in our exploration of open source GIS using Ubuntu. In order to grasp the full power of GIS, we need to spatially extend our database (PostgreSQL, which was installed in the previous step). The spatial extension for PostgreSQL is PostGIS, which we will eventually be installing. But before we can get [...]

Read more »

Catching Bad Characters

When loading data into a PostGIS database using shp2pgsql, have you ever gotten this cryptic error? Unable to convert data value to UTF-8 (iconv reports “Invalid or incomplete multibyte or wide character”). Current encoding is “UTF-8″. Try “LATIN1″ (Western European), or one of the values described at http://www.postgresql.org/docs/current/static/multibyte.html. This means that there is an invalid [...]

Read more »

A Difference of Projections

If you divide your time between ArcGIS and QGIS, you may have noticed that they don’t use the exact same projections.  For Northern Colorado, for example, ArcGIS offers “NAD 1983 HARN StatePlane Colorado North FIPS 0501″, while the best QGIS can do is “NAD83(HARN) / Colorado North”.  When projection information doesn’t agree exactly, I get [...]

Read more »

Trendspotting

British GIS site web-gis.co.uk is currently hosting a poll about GIS data formats.  Not too many people have voted yet, but a clear trend is already emerging.  The data suggests that PostGIS has been gaining a lot of ground, eclipsing other popular proprietary data formats.  Here’s the current breakdown: PostgreSQL/PostGIS – 17 votes, 65.4% Proprietary [...]

Read more »