<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Ping....<br> <BR><div><hr id="stopSpelling">From: audiofile@outlook.com<br>To: dev@openstreetmap.org<br>Date: Fri, 28 Feb 2014 11:11:17 -0800<br>Subject: [OSM-dev] Joining SRTM Gov. Elevation Data with OSM USA Data Locally<br><br>
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr">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.<br> <br>My server system is: <br>overclocked and water-cooled i7 3930k (4.1GHZ) 6 cores (plus 6 "Hyperthreads")<br>32 GB RAM<br>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)<br>SQL Server Enterprise<br>Windows Server 2012 Enterprise<br> <br>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 :) )<br> </div>
<br>_______________________________________________
dev mailing list
dev@openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev</div> </div></body>
</html>