<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.8.0">
</HEAD>
<BODY>
<TT>Who are you?</TT><BR>
<BR>
Mark Thomas - independent GIS developer/contractor<BR>
<BR>
<TT>What are you using PostGIS for?</TT><BR>
<BR>
1) geocoding, zip code lookups, radius lookups (i.e. is gimme everything within XXX miles of 123 main st, somewhere, AL 12345), and customer-created polygon lookups (cartoweb/MapServer for visual polygon drawing) in a custom application providing free demographic data and statistics on the public Internet. PostgreSQL/PostGIS stores all the demographic data retrieved by the various lookups and is then rendered in either HTML or PDF.<BR>
<BR>
check it out at <A HREF="http://www.demographicsdata.com">http://www.demographicsdata.com</A> - note that its running on my home workstation right now so it might be slow/down at times, but that will change soon...<BR>
<BR>
2) I use PostGIS for easy creation of shapefiles. For example, I used it to create a shapefile out of a Google Earth KML file. PostGIS is an invaluable tool for spatial data analysis and manipulation. I also use PostGIS to create shapefiles out of TIGER/line files.<BR>
<BR>
<TT>Why did you choose PostGIS?</TT><BR>
<BR>
Because its more OGC standards-based than Oracle Spatial/Locator, its more robust/mature than MyGIS, the large user community, and its free!<BR>
<BR>
<TT>What makes you happy about your PostGIS installation?</TT><BR>
<BR>
It's so easy to install and use. A simple shell script gives me a fully working environment. The SDO libraries for Oracle Spatial work great, but there's a steep learning curve involved and the functions are somewhat convoluted. On the other hand, PostGIS is so easy to use. The community is also an order of magnitude better and more helpful IMHO.<BR>
<BR>
<TT>What makes you unhappy about your PostGIS installation?</TT><BR>
<BR>
Nothing.<BR>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
Mark Thomas<BR>
http://www.spatialguru.net<BR>
<BR>
<I>"Commit to the Lord whatever you do, </I><BR>
<I> and your plans will succeed." - Proverbs 16:3</I><BR>
<BR>
<BR>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>