<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY
style="WORD-WRAP: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space">
<DIV dir=ltr align=left>
<P><FONT size=2>Hi Kirk,</FONT></P>
<P><FONT size=2>I meant substitute all references to ref_solar_station_id with
ref_weather_station_id. </FONT></P>
<P><FONT size=2><SPAN class=157253912-20022007>The idea
is </SPAN> <SPAN class=157253912-20022007>to update </SPAN><SPAN
class=157253912-20022007>the</SPAN> ref_weather_station_id of those that don't
have a<SPAN class=157253912-20022007>ny</SPAN> weather <SPAN
class=157253912-20022007>for that year </SPAN>with those that do.<SPAN
class=157253912-20022007> Basically the first
step sets the ref_weather_station_id to the station_id if the
station has weather data for that year and null if it does not and similarly
ref_sol with station_id if the station has solar data for that year. So by
the time you get to step 5 those that have nulls in ref_weather_station_id have
no weather for that year. Those that have weather for that year (assuming I
wrote the query right - the ref_weather_station_id should be the same as the
station_id) . Hope my explanation isn't even more
confusing.</SPAN></FONT></P>
<P><FONT size=2><SPAN class=157253912-20022007>Thanks,</SPAN></FONT></P>
<P><FONT size=2><SPAN
class=157253912-20022007>Regina</SPAN></FONT></P></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Kirk
Wythers<BR><B>Sent:</B> Friday, February 16, 2007 4:53 PM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> Re: [postgis-users] joining "nearest"
data<BR></FONT><BR></DIV>
<DIV></DIV><BR>
<DIV>
<DIV>On Feb 15, 2007, at 7:35 AM, Obe, Regina wrote:</DIV><BR
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<P style="MARGIN: 0px"><FONT style="FONT: 12px Helvetica" face=Helvetica
size=3>Step 5 - Do the same as Step 4 except for
ref_weather_station_id</FONT></P></BLOCKQUOTE></DIV><BR>
<DIV>Do you mean substitute ref_weather_station_id for
ref_solar_station_id in line one only. Bottom line, are you saying that you want
to fill in in ref_weather_station_id with those that have no solar data for that
year, or with those that have no weather data for that
year? </DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P><br>
<P><STRONG><br>
The substance of this message, including any attachments, may be<br>
confidential, legally privileged and/or exempt from disclosure<br>
pursuant to Massachusetts law. It is intended solely for the<br>
addressee. If you received this in error, please contact the sender<br>
and delete the material from any computer.<br>
</STRONG></P></BODY></HTML>