Re: [OSM-dev] Joining SRTM Gov. Elevation Data with OSM USA Data Locally

2014-03-02 Thread Joel Znamenacek
Ping From: audiof...@outlook.com To: dev@openstreetmap.org Date: Fri, 28 Feb 2014 11:11:17 -0800 Subject: [OSM-dev] Joining SRTM Gov. Elevation Data with OSM USA Data Locally Trying to build one database with SRTM 1 sec (30m) data and OSM data of the USA is kicking my ass. I'm reaching

Re: [OSM-dev] Joining SRTM Gov. Elevation Data with OSM USA Data Locally

2014-03-02 Thread Yves
@openstreetmap.org Date: Fri, 28 Feb 2014 11:11:17 -0800 Subject: [OSM-dev] Joining SRTM Gov. Elevation Data with OSM USA Data Locally Trying to build one database with SRTM 1 sec (30m) data and OSM data of the USA is kicking my ass. I'm reaching out for help. I have both datasets in SQL Server and trying

Re: [OSM-dev] Joining SRTM Gov. Elevation Data with OSM USA Data Locally

2014-03-02 Thread Frederik Ramm
Hi, On 02/28/2014 08:11 PM, Joel Znamenacek wrote: Trying to build one database with SRTM 1 sec (30m) data and OSM data of the USA is kicking my ass. I'm reaching out for help. I have both datasets in SQL Server and trying to join them together is the pain point. The pain is either in long

[OSM-dev] Joining SRTM Gov. Elevation Data with OSM USA Data Locally

2014-02-28 Thread Joel Znamenacek
Trying to build one database with SRTM 1 sec (30m) data and OSM data of the USA is kicking my ass. I'm reaching out for help. I have both datasets in SQL Server and trying to join them together is the pain point. The pain is either in long query times and/or not accurate enough lookups. I'm