PHP User Group Malta // View topic - [PG] Rain effect on roads

PHP User Group Malta Forum Index :: FAQ :: Search :: Memberlist :: Usergroups

Forum Subscriptions

[PG] Rain effect on roads

PHP User Group Malta Forum Index // The Database Section

View previous topic :: View next topic

yancho
Site Admin

Joined: 13 Nov 2007
Posts: 56
Location: Iklin

Posted: Thu Feb 14, 2008 12:46 pm Post subject: [PG] Rain effect on roads

Hi,

I am working on a PG SQL function to enable / disable a street from a network if there is too much rain water in the road and it also depends on what type of vehicle the driver has.

At the moment I am giving limits to the type of vehicle :

Private Car : 35cm
Light Good Vehicle : 40cm
Heavy Good vehicle : 50cm
Public Transport : 45cm

So first thing is that I am coparing the rain level with the hard coded limits, and if the rain level goes above I do not include the road in the routing

However, we all know that if 10mm of rain dropped on an area, there will be more collected rain water in a valley (point with low Z location (altitude)) rather than a higher point.

What do you suggest I do so I know if the point is in a valley? Remember it can be that the road is in a low altitude but its a plane - thus rain water will not be such a problem.

Suggestions are welcome

Thanks
_________________

	PHP User Group Malta Forum Index // The Database Section	All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

alexisRed v1.2 // Theme Created By: Andrew Charron and Web Hosting Bluebook // Icons in Part By: Travis Carden
Boards optimised using the phpBB-SEO mod found at phpbb-seo.com
Boards hosted courtesy of solutions-lab.net
Link Backs : PHPClasses.org - MT Page :: PHPUsergroups.org - MT Page