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

Completado Publicado Dec 5, 2011 Pagado a la entrega
Completado Pagado a la entrega

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.

Administración de bases de datos Ingeniería Geolocalización Linux MySQL Instalación de scripts Shell Script SQL

Nº del proyecto: #3736704

Sobre el proyecto

5 propuestas Proyecto remoto Activo Dec 7, 2011

Adjudicado a:

mangoon

See private message.

$5 USD en 14 días
(13 comentarios)
4.5

5 freelancers están ofertando un promedio de $30 por este trabajo

customizedata

See private message.

$42.5 USD en 14 días
(92 comentarios)
5.5
Shurgenz

See private message.

$42.5 USD en 14 días
(16 comentarios)
4.3
gisoftek

See private message.

$35.7 USD en 14 días
(2 comentarios)
1.9
vw8069563vw

See private message.

$25.5 USD en 14 días
(0 comentarios)
0.0