Web Application Developer.

August 27th, 2008

PostGIS Basics - Part 2 - Hello World
August 27th 9:06 PM

A quick hello world

There are a couple of things you must know about PostGIS and GIS in general before you can work with them.

First, PostGIS keeps a table of spatially enabled columns with metadata that you must update via built in functions (called geometry_columns). Consult the command reference for details, but I used the following to set up a POINT enabled column:




Read More »


Posted by Jeremy Tunnell| Comments (0)
 


Other Tags



August 26th, 2008

Transforming an address into Latitude and Longitude using PHP and curl
August 26th 8:03 PM

Step 1 - Get a key

Yahoo offers a service that will translate any address (US only) into a latitude/longitude pair for free, for up to 5000 queries/day. The first thing you need to do is visit Yahoo and sign up for an api key: Yahoo API.




Read More »


Posted by Jeremy Tunnell| Comments (1)
 


Other Tags