Create a couple of SQL (postgreSQL) statments to identify creeks in crossing in a DB

已完成 已发布的 Dec 5, 2011 货到付款
已完成 货到付款

Hi

I am building a map using two separate creek data sets (OSM creeks and DEM derived creeks). The OSM data is generally more reliable, but there are only a small number of creeks.

I am wanting to find all the creeks in the DEM dataset that are NOT already in the OSM dataset. (so they can be shown on a map).

I am happy to ignore a DEM creek if it is crosses an OSM creek twice or more times (if it crosses just once then it is more likely a side creek)

Your job is to develop a SQL statement that will

1) Display all DEM_creeks that do not cross any single OSM creek more than once.

2) Delete all DEM_creeks that cross a single OSM creek more than once

I will provide full details of the tables and ca provide SSH access to the server so you can play with the SQL.

Matt :)

## Deliverables

The image attached gives a sense for the overlapping creek issue.

数据库管理 工程 地理位置 Linux MySQL 脚本安装 shell脚本 SQL

项目ID: #3736704

关于项目

5个方案 远程项目 活跃的Dec 7, 2011

授予:

mangoon

See private message.

$5 USD 在14天内
(13条评论)
4.5

有5名威客正在参与此工作的竞标,均价$30/小时

customizedata

See private message.

$42.5 USD 在14天内
(92条评论)
5.5
Shurgenz

See private message.

$42.5 USD 在14天内
(16条评论)
4.3
gisoftek

See private message.

$35.7 USD 在14天内
(2条评论)
1.9
vw8069563vw

See private message.

$25.5 USD 在14天内
(0条评论)
0.0