topic Full US level SSURGO database, bad idea? in Data Management Questions https://community.esri.com/t5/data-management-questions/full-us-level-ssurgo-database-bad-idea/m-p/184575#M10419 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P></P><P>Does anyone have some "best practices" or "lessons learned" they'd like to share on creating a complete US level SSURGO geodatabase in SQLServer?&nbsp; </P><P></P><P>I'm creating an application that will hopefully be useful across the entire US but really hate the idea of coding a big fat 'if STATE='X' then GDB="X" to deal with the smaller data chucks that come from USDA.&nbsp; Handling user AOIs that overlap state boundaries gets even uglier... </P><P><BR />We've made an initial attempt at loading the dataset chucks and are close to 30M MUPOLGYON records and performance is not that great. </P><P></P><P>Is ugly code better than an overtaxed database? </P><P></P><P>Thanks in advance for any advice.</P></BODY></HTML> Fri, 27 May 2016 21:22:42 GMT FredSpataro 2016-05-27T21:22:42Z Full US level SSURGO database, bad idea? https://community.esri.com/t5/data-management-questions/full-us-level-ssurgo-database-bad-idea/m-p/184575#M10419 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P></P><P>Does anyone have some "best practices" or "lessons learned" they'd like to share on creating a complete US level SSURGO geodatabase in SQLServer?&nbsp; </P><P></P><P>I'm creating an application that will hopefully be useful across the entire US but really hate the idea of coding a big fat 'if STATE='X' then GDB="X" to deal with the smaller data chucks that come from USDA.&nbsp; Handling user AOIs that overlap state boundaries gets even uglier... </P><P><BR />We've made an initial attempt at loading the dataset chucks and are close to 30M MUPOLGYON records and performance is not that great. </P><P></P><P>Is ugly code better than an overtaxed database? </P><P></P><P>Thanks in advance for any advice.</P></BODY></HTML> Fri, 27 May 2016 21:22:42 GMT https://community.esri.com/t5/data-management-questions/full-us-level-ssurgo-database-bad-idea/m-p/184575#M10419 FredSpataro 2016-05-27T21:22:42Z