<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial><SPAN class=790233119-09092003>I am trying to familiarize
myself with POSTGIS syntax and am hitting some barriers. <SPAN
class=790233119-09092003>I'm sure there is something basic I am missing.
Any help would be greatly appreciated</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003>1) Is Geometry still a
valid data type? I am working on a POSTGIS tutorial and if I use the
SELECT command below </SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003><SPAN
class=790233119-09092003>SELECT AddGeometryColumn ( 'db', 'table', 'field', -1,
'GEOMETRY', 2 ) ;</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003><SPAN
class=790233119-09092003></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003><SPAN
class=790233119-09092003>I get:</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003><SPAN
class=790233119-09092003></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003>Invalid Type name - valid
ones are: GEOMETRY, GEOMETRYCOLLECTION, POINT, MULTIPOINT, POLYGON,
MULTIPOLYGON, LINESTRING, MULTILINESTRIN</SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003>2) I hit another roadblock
when trying to use the shp2pgsql command.</SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003>When I try to dump a
shapefile into a new tabel using:</SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003>./shape2pgsql -D db
/var/www/cgi-bin/atlas/data/states_nlam.shp states db</SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003>I get a series of
coordinates printing to the screen but the table is not created.
What am I doing wrong?</SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003>Thanks,</SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=790233119-09092003>Kurt</SPAN></FONT></DIV>
<P>~~~~~~~~~~~~~~~~~~~~~~~~~~~</P>
<P><FONT face="Times New Roman">Kurt A. Menke</FONT> <BR><FONT
face="Times New Roman">GIS Analyst</FONT> <BR><FONT face="Times New Roman">Earth
Data Analysis Center</FONT> <BR><FONT face="Times New Roman">The University of
New Mexico</FONT> <BR><FONT face="Times New Roman">Bandelier West, Room
111</FONT> <BR><FONT face="Times New Roman">Albuquerque, NM 87131-6031</FONT>
<BR><FONT face="Times New Roman">(505)277-3622 ext. 239</FONT> <BR><FONT
face="Times New Roman">Fax (505)277-3614</FONT> </P>
<DIV> </DIV></BODY></HTML>