<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16443"></HEAD>
<BODY>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=732280905-07062012>Hi
All,</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=732280905-07062012></SPAN></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=732280905-07062012>I am
working on a data upload function where for a web map a user can upload a shape
file onto the server, the file will then be loaded via a utility into PostGIS
e.g. using ogr2ogr or shp2pgsql.</SPAN></FONT></DIV>
<DIV><SPAN class=732280905-07062012><FONT size=2><FONT face=Arial><FONT
color=#000080>Now we all know that <TR class=msg msg-type="PRIVMSG"
msg-prefix="" msg-dest="#postgis" dest-type="IRCChannel" view-type="IRCChannel"
status-text="[2012-06-06 21:58:20] karstenv!~chatzilla@c-24-17-228-250.hsd1.wa.comcast.net"
timestamp="1339045100545" msg-user="karstenv ME!" mark="even"><TD
class=msg-data><SPAN>usually a shape files has at least 3 files shp, shx and dbf
to be complete... but unusually </SPAN></TD></TR><TR class=msg msg-type="JOIN"
msg-prefix="" msg-dest="#postgis" dest-type="IRCChannel" view-type="IRCChannel"
status-text="[2012-06-06 21:59:38] darkblue_b!~chatzilla@c-24-130-122-95.hsd1.ca.comcast.net"
timestamp="1339045178312" msg-user="darkblue_b" mark="even" msg-user-mode=""><TD
class=msg-timestamp></TD><TD class=msg-type><SPAN>- </SPAN><SPAN>well I was
wondering if it would be possible to only use a shp file alone to load the
geometry to PostGIS (if it is ok to lose index and attributes)
</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=732280905-07062012><FONT size=2><FONT face=Arial><FONT
color=#000080><SPAN></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=732280905-07062012><FONT color=#000080 size=2 face=Arial>The
reason is this would have several advantages for the work I am tying to
do</FONT></SPAN></DIV>
<DIV><SPAN class=732280905-07062012><FONT color=#000080 size=2 face=Arial>1. the
shape file is user provided (if will be always 'simple' polygon shapes, but due
to that will always have non consistent attributes (i.e not the same tabel
schema) which are not needed anyway for the purposes of the
app</FONT></SPAN></DIV>
<DIV><SPAN class=732280905-07062012><FONT color=#000080 size=2 face=Arial>2. the
geometry alone will be used to show areas of Interest for the user on the map
(attributes are not needed, only location and extent
matters)</FONT></SPAN></DIV>
<DIV><SPAN class=732280905-07062012><FONT color=#000080 size=2 face=Arial>3.
inconsistencies of differing attributes will not be a problem if I could
in fact only import the geometry to PostGIS and simply add a unique gid and user
id as only default attributes to the PostGIS table</FONT></SPAN></DIV>
<DIV><SPAN class=732280905-07062012>
<DIV><FONT size=2><FONT face=Arial><FONT color=#000080><SPAN
class=732280905-07062012><SPAN></SPAN></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT size=2><FONT face=Arial><FONT color=#000080><SPAN
class=732280905-07062012><SPAN>A</SPAN><SPAN>ny ideas on that weird idea ,
if that could be accomplished with existing tools without too much trouble
?</SPAN></TD></TR></SPAN><SPAN class=732280905-07062012>
</SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN class=732280905-07062012><FONT color=#000080 size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=732280905-07062012><FONT color=#000080 size=2
face=Arial>Cheers</FONT></SPAN></DIV>
<DIV><SPAN class=732280905-07062012><FONT color=#000080 size=2
face=Arial>Karsten</FONT></SPAN></DIV></SPAN></DIV>
<DIV><SPAN class=732280905-07062012></SPAN> </DIV>
<DIV align=left>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 11pt">Karsten
Vennemann<BR></SPAN><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 9pt">Principal<BR><BR><SPAN
style="COLOR: #003264">Terra GIS LTD<BR>2119 Boyer Ave E
<BR>Seattle, WA 98112<BR>USA <BR><A
title=blocked::http://www.terragis.net/ href="http://www.terragis.net/"><FONT
color=#0000ff>www.terragis.net</FONT></A></SPAN></SPAN><?xml:namespace prefix =
o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: #003264; FONT-SIZE: 9pt">Phone
++1 206 905 1711<BR>Fax ++1 925 905
1711</SPAN><o:p></o:p></P></DIV>
<DIV> </DIV><br/><br/><br><br><FONT face="Tahoma" size="2"><br>=======<br>Email scanned by PC Tools - No viruses or spyware found.<br>(Email Guard: 9.0.0.888, Virus/Spyware Database: 6.19830)<br><a href=http://www.pctools.com/?cclick=EmailFooterClean_51>http://www.pctools.com</a><br>=======</FONT>
</BODY></HTML>