Abstract:According to data loading of real estate by Ji'nan Real Estate Institute of Surveying and Mapping, based on CASS9.1, ETL tools and geographic information workstation EPS software, the method for transforming CAD data to ArcGIS data by using three different means has been illustrated in detail, and the process and results of 3 methods have been analyzed. Through lateral contrast of three loading means, advantages and disadvantages of each means have been summarized respectively. It will provide targeted suggestions for improvement of loading work with high efficiency and low error, and laid the foundation and pave the way for a solid storage of historical data.