<html>
<head>
</head>
<body class='hmmessage'><div dir='ltr'>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style>
<div dir="ltr"><br>
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style><div><div dir="ltr">Is all the 1 sec (30m) SRTM data already imported into OSM? I saw some elevation data, but it looks incomplete so I started trying to blend both data sets. <br> <br>This project is kicking my ass and I need help melding a lat/lon from OSM to SRTM lat/lon. 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 do this are appreciated (granular views are just as good :) ).<br> <br>Joel<br> </div></div></div>
</div></body>
</html>