[postgis-users] joining "nearest" data

[Obe, Regina]

Hi Kirk,

I meant substitute all references to ref_solar_station_id with
ref_weather_station_id. 

The idea is  to update the ref_weather_station_id of those that don't
have any weather for that year with those that do.  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.

Thanks,

Regina


________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Kirk
Wythers
Sent: Friday, February 16, 2007 4:53 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] joining "nearest" data



On Feb 15, 2007, at 7:35 AM, Obe, Regina wrote:


	Step 5 - Do the same as Step 4 except for ref_weather_station_id


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? 



-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070220/eb5e0017/attachment.html>