Completed in February of 2004 for Alabama Department of Transportation, Soil Test Data Control (STDC) manages Materials and Test laboratory data with interactive tools for data input, and by employing estimation theory for quality control analysis. Developed as an ASP.NET application with C# code behind, STDC supports multiple users in multiple locations, has zero deployment issues, and replaces dated technology from the test workflow. Further, ownership of the data and reporting process has been transferred from computer services to the test engineers. Where analysis was once performed yearly it is now reported as-needed and is evaluated in real-time.



Technologies: ASP.NET, ADO.NET, C#, SQL, MS Access, HTML

The translator uses C# to modify Terramodel Xml files so that DTM features are formatted for InRoads. The program implements a mapping table so that the users can associate Terramodel codes to InRoads features. A special thanks to Seth Cohen of Prosoft who did the hard work of documenting the main differences between the two files. I am currently working on a tool to reverse this process.



Technologies: C#, Xml

RTM is a MicroStation MDL application developed to aid in the production of Right of Way maps. The application is divided into three distinct command groups – Placement, Editing, and Data Analytics.

Placement commands are dynamic symbol creation tools for components such as tract numbers, parcel, and remainder symbols, as well as markers for structures, point of commencement, and beginning. All control standard graphic symbology through the use of preference and symbol definition controls.

Editing tools for changing data in tract bubbles, parcel and remainder symbols are included, and so are manipulation tools for managing symbols placed with leaders. The leader edit tools allow symbols to be moved while leaving terminator point anchored. The smart delete command can tell when a tract bubble is selected versus any other symbol and acts accordingly.

Data Analytics involves linking tract and parcel shapes to their respective symbols and using this link to label parcel legs, extract area reports, and automate bearing and distance tables. These tools have the unique ability to traverse parcel boundaries from point of commencement to point of beginning and determine a clockwise direction path for reporting purposes.

New work involves migrating the application to V8.5. Xml strategies with VBA are being employed to manage preferences, manage user options, and provide a data extraction path to and from Microsoft Excel based right of way reports.

Here's an avi file for the MicroStation/J version of RTM. The file requires Windows media player and is 1.7 meg. rtm.avi



Technologies: MicroStation V7, MDL, ANSI C, MicroStation V8, VBA, Xml

In early 2004 Khoi Dinh-Vu, Editor C-A-D sent me an email from a reader looking for sample code from an article I wrote for the magazine in 2003, a download that was on cadgurus.com and available until fall if 2003. Oops.

I quickly set up a free web address on Brinkster. The address was odd but manageable. I had been working on the soil lab program and decided to create a simple ASP.NET page with a database to serve up the content. With some effort, free usually means something is missing, I managed to get the page working tweaking the web.config file and writing the c# code in-line.

Not a week later I started thinking more about the cadgurus downloads. The task was easy enough since it was the same process I used for the ControlAltDelete articles. Well one thing lead to another, I began thinking about adding a portfolio, and then I reasoned if I have a portfolio I'd need a resume, and . . .

Well here it is markstefanchuk.com.The site was created using VS.Net and uses ASP.Net, ADO.Net, C# for code behind, and some HTML

If you are a Client or potential Employer I hope you find something here that says I can help you. If so, contact me .

I retired my home made blog tools last year and replaced them with blogger.com. And I set the page design of markstefanchuk.com to match a blogger.com template. The original template design is by Douglas Bowman www.stopdesign.com.

Despite a narrow focus on MicroStation CAD technology, cadgurus.com hosted thousands of visitors every day. Roughly 30% of the content was contributed by her visitors, but what most didn't realize was that the remaining 70% of the content was created by just two people - its founders, Mary Ramsey and Mark Stefanchuk.

In 1998, the site began as a small collection of html pages. An index page, a tip of the week page, and a downloads page were the most visited pages at that time. However, as the content increased, maintenance of the site became more demanding and we needed to build a better solution.

The site was redisigned using ASP. The new site served daily content, introduced applications for uploading new content, and auto-generated a weekly newsletter. In the end there were more than a dozen administrative applications in addition to the tools for extracting daily content from the archive databases.

By summer of 2003 our interests were being pulled in new directions. And since there are many other excellent web resources for MicroStation we decided to shut down cadgurus.com. The downloads can still be found on this site, cadgurus downloads.



Technologies: ASP, ADO, VB Script, SQL, MS Access, HTML