Re: [OSM-dev] Joining SRTM Gov. Elevation Data with OSM USA Data Locally
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 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 finding SQL Server 2012 spatial is slow (it uses .NET). The scope of the project is just the USA data. My server system is: overclocked and water-cooled i7 3930k (4.1GHZ) 6 cores (plus 6 Hyperthreads) 32 GB RAM 1.6GB/s disk IO subsystem and 1/2 TB of space. Speed is as indicated by SQL Server performance monitor. (This can go higher w/more HW RAID controllers that I already have) SQL Server Enterprise Windows Server 2012 Enterprise Ideas from a 30,000' view on how to associate SRTM elevation for any OSM lat/lon point via SQL query on my server is appreciated (granular views are just as good :) ) ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Joining SRTM Gov. Elevation Data with OSM USA Data Locally
Hi, OSM devs usually use Postgis + Postgresql. However, maybe if you're explain why and how you mix a DEM with osm data ? You put elevation on every node ? On 2 mars 2014 22:16:36 UTC+01:00, Joel Znamenacek audiof...@outlook.com wrote: 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 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 finding SQL Server 2012 spatial is slow (it uses .NET). The scope of the project is just the USA data. My server system is: overclocked and water-cooled i7 3930k (4.1GHZ) 6 cores (plus 6 Hyperthreads) 32 GB RAM 1.6GB/s disk IO subsystem and 1/2 TB of space. Speed is as indicated by SQL Server performance monitor. (This can go higher w/more HW RAID controllers that I already have) SQL Server Enterprise Windows Server 2012 Enterprise Ideas from a 30,000' view on how to associate SRTM elevation for any OSM lat/lon point via SQL query on my server is appreciated (granular views are just as good :) ) ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev -- Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Joining SRTM Gov. Elevation Data with OSM USA Data Locally
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 query times and/or not accurate enough lookups. This is really a question you should discuss with SQL server experts, not with OSM experts. A watercooled and over-clocked CPU is good but a well designed query is even better, and well designed depends very much on how the database system works that's why I said SQL server experts. http://wiki.openstreetmap.org/wiki/Route_altitude_profiles_SRTM is an example of loading SRTM data into a PostGIS. I don't know what you want to do but if you're thinking about route altitude profiles, then you'd most certainly first want to compute a route and then add the altitude information to that, rather than adding altitude to every point in OSM first. But at this point we can just guess really. Tell us exactly what you want to achieve and we might be able to suggest something. Building a database with SRTM data and OSM data is not nearly precise enough. Bye Frederik -- Frederik Ramm ## eMail frede...@remote.org ## N49°00'09 E008°23'33 ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
