<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h2
{margin-top:6.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:0in;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:11.0pt;
font-family:"Trebuchet MS";
color:navy;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 77.95pt 1.0in 77.95pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'>Thank you to all that have replied thus for
to my question about loading multiple shapefiles with different schemas.
All answers have been very useful. <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'>I will look into GeoKettle. A cursory looks
seems as if it is very promising and similar to another ETL tool I have used.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'>Also, the suggestion to bring everything in
with shp2pgsql and then use a bunch of</span></font> <font face="Trebuchet MS"><span
style='font-family:"Trebuchet MS"'>insert into...select...from... is actually
very similar to what I originally had in mind, but is actually more elegant. Once
each layer is loaded, each could actually inserted into the target layer with a
single insert into...select...from... for each layer using the between function
on gid. <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'>Great suggestions everyone. Thank you.</span></font><o:p></o:p></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'>Todd Fagin<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'>Coordinate Solutions, Inc.<o:p></o:p></span></font></p>
<p class=MsoPlainText><st1:Street w:st="on"><st1:address w:st="on"><font
size=2 face="Trebuchet MS"><span style='font-size:10.0pt;font-family:"Trebuchet MS"'>2804
NW 18th St</span></font></st1:address></st1:Street><font face="Trebuchet MS"><span
style='font-family:"Trebuchet MS"'>.<o:p></o:p></span></font></p>
<p class=MsoPlainText><st1:place w:st="on"><st1:City w:st="on"><font size=2
face="Trebuchet MS"><span style='font-size:10.0pt;font-family:"Trebuchet MS"'>Oklahoma
City</span></font></st1:City><font face="Trebuchet MS"><span
style='font-family:"Trebuchet MS"'>, <st1:State w:st="on">OK</st1:State> <st1:PostalCode
w:st="on">73107</st1:PostalCode></span></font></st1:place><font
face="Trebuchet MS"><span style='font-family:"Trebuchet MS"'><o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'>405.740.4324 (voice)<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'>904.471.5548 (fax)<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'>www.coordinatesolutions.com<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Trebuchet MS"><span style='font-size:
10.0pt;font-family:"Trebuchet MS"'> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>