/data/GNIS-2009
===============

- downloaded TX file from http://geonames.usgs.gov/domestic/download_data.htm
   - converted "|" to tabs
   - created ODBC connection, used ogr2ogr to convert vrt to shp:
   
	<OGRVRTDataSource>
		<OGRVRTLayer name="geonames-layer">
		<SrcDataSource>ODBC:@geonames</SrcDataSource>
		<SrcLayer>TX_Features_20090803.csv</SrcLayer>
		<GeometryType>wkbPoint</GeometryType>
		<LayerSRS>+proj=longlat +ellps=GRS80 +datum=NAD83</LayerSRS>
		<GeometryField encoding="PointFromColumns" x="PRIM_LONG_DEC" y="PRIM_LAT_DEC"/>
		</OGRVRTLayer>
	</OGRVRTDataSource>
   
   - imported into postgis (with "-W latin1" shp2pgsql switch) to reduce column sizes
        select max(length(feature_id)) from gnis_names09;
        alter table gnis_names09 alter column feature_id type varchar(7);
   - removed major out-of-state outlying points using QGIS
   - removed all fields except: FID,NAME,CLASS,STATE,COUNTY,ELEVATION,MAP

/data/TIGER-2008
================

- downloaded TX from http://www.census.gov/geo/www/tiger/tgrshp2008/tgrshp2008.html
   - merged files for entire state using ogr2ogr with the "-update -append" switch