GIS在房產(chǎn)和土地信息管理中的應(yīng)用

GIS在房產(chǎn)和土地信息管理中的應(yīng)用GIS在房產(chǎn)和土地信息管理中的應(yīng)用摘要：利用GIS技術(shù)對(duì)校園房產(chǎn)與土地信息進(jìn)行可視化管理，可高效、準(zhǔn)確地掌握房產(chǎn)和土地資源及其空間分布情況，為學(xué)校資產(chǎn)管理部門(mén)提供快速有效的決策和管理的現(xiàn)代化工具。在對(duì)系統(tǒng)總體結(jié)構(gòu)、功能、數(shù)據(jù)庫(kù)進(jìn)行設(shè)計(jì)的基礎(chǔ)上，采用GIS組件技術(shù)，將MapX組件嵌入到VisualBasic6.0可視化開(kāi)發(fā)環(huán)境中，以Access為后臺(tái)數(shù)據(jù)庫(kù)，開(kāi)發(fā)了集數(shù)據(jù)錄入、查詢、修改、統(tǒng)計(jì)及報(bào)表等功能為一體的高校房產(chǎn)管理信息系統(tǒng)，該系統(tǒng)在實(shí)際應(yīng)用中收到良好的效果。關(guān)鍵詞：計(jì)算機(jī)應(yīng)用房產(chǎn)和土地信息管理GISMapX隨著GIS技術(shù)的迅速發(fā)展，我國(guó)各行各業(yè)的“數(shù)字化”建設(shè)取得巨大進(jìn)步，“數(shù)字中國(guó)”、“數(shù)字城市”網(wǎng)絡(luò)化管理的愿望正在變?yōu)楝F(xiàn)實(shí)。由于高等教育的迅速發(fā)展和辦學(xué)規(guī)模的不斷擴(kuò)大，學(xué)校土地、房產(chǎn)迅速增加和變更。圖形和屬性信息不一致，高校資產(chǎn)管理部門(mén)過(guò)去的管理方式、管理手段及管理軟件已不能滿足新形勢(shì)管理需要[1]。為了適應(yīng)信息時(shí)代發(fā)展的需要，建立高校房產(chǎn)和宗地管理信息系統(tǒng)勢(shì)在必行。以“蘭州交通大學(xué)房產(chǎn)和宗地管理信息系統(tǒng)”軟件開(kāi)發(fā)為例，探討了采用VisualBasic6.0語(yǔ)言，基于MapX組件和數(shù)據(jù)庫(kù)軟件Access，實(shí)現(xiàn)校園房產(chǎn)和土地信息數(shù)據(jù)入庫(kù)、更新、修改、查詢、統(tǒng)計(jì)和報(bào)表等功能，為提高學(xué)校相關(guān)部門(mén)的管理效率和信息化管理水平發(fā)揮巨大作用、產(chǎn)生深遠(yuǎn)影響。該系統(tǒng)已在學(xué)校智能部門(mén)中應(yīng)用，為校園信息化管理提供可視化的平臺(tái)。1基于VB的MapX組件實(shí)現(xiàn)公房管理1.1組件式GIS開(kāi)發(fā)平臺(tái)通?？稍O(shè)計(jì)為三級(jí)結(jié)構(gòu)：基礎(chǔ)組件面向空間數(shù)據(jù)管理，提供基礎(chǔ)的交互過(guò)程，并能以靈活的方式與數(shù)據(jù)庫(kù)系統(tǒng)連接。高級(jí)通用組件由基礎(chǔ)組件結(jié)構(gòu)而成，面向通用功能，簡(jiǎn)化用戶開(kāi)發(fā)過(guò)程，如顯示工具組件、選擇工具組件、編輯工具組件、屬性瀏覽器組件等，它們之間的協(xié)同控制消息都被封裝起來(lái)。這級(jí)組件經(jīng)過(guò)封裝后，面向通用功能，使二次開(kāi)發(fā)更為簡(jiǎn)單[2]。行業(yè)性組件抽象出行業(yè)應(yīng)用的特定算法，固化到組件中，進(jìn)一步加速開(kāi)發(fā)過(guò)程。以GPS監(jiān)控為例，對(duì)于GPS應(yīng)用，除了需要地圖顯示、信息查詢等一般的GPS功能外，還需要特定的應(yīng)用功能，如動(dòng)態(tài)目標(biāo)顯示、目標(biāo)鎖定、軌跡顯示燈。這些GPS行業(yè)性應(yīng)用功能組件被封裝起來(lái)后，開(kāi)發(fā)工作就可簡(jiǎn)化為設(shè)置顯示目標(biāo)的圖例、軌跡顯示的顏色、鎖定的目標(biāo)以及調(diào)用、接受數(shù)據(jù)的方法等。1.2MapX開(kāi)發(fā)方式圖層化MapX是按圖層組織地圖，將一副計(jì)算機(jī)地圖劃分成多個(gè)透明層疊的圖層，每個(gè)圖層包括了整個(gè)地圖的一種信息。為了便于對(duì)圖層進(jìn)行編輯和管理，可以通過(guò)控制圖層集合對(duì)象來(lái)協(xié)調(diào)處理各圖層的關(guān)系。地圖中的所有圖層組成圖層集合，要在MapX中進(jìn)行增加、刪除或改變圖層等操作，必須通過(guò)圖層集合。每個(gè)地圖對(duì)象都包括了一個(gè)圖層集合，圖層集合又是由圖層對(duì)象組成，因此通過(guò)圖層集合訪問(wèn)地圖中各個(gè)圖層。MapX是通過(guò)圖層集合來(lái)控制地圖。校園電子地圖中設(shè)置的圖層包括：行政樓、教學(xué)樓、實(shí)驗(yàn)樓、圖書(shū)館、公寓和家屬樓、綠地、校園景點(diǎn)、運(yùn)動(dòng)場(chǎng)、道路節(jié)點(diǎn)、道路線及界線等圖層。數(shù)據(jù)綁定每個(gè)地圖都有一個(gè)數(shù)據(jù)集合，通過(guò)數(shù)據(jù)集合可以將屬性數(shù)據(jù)與地圖空間數(shù)據(jù)連接起來(lái)。數(shù)據(jù)綁定是將外部數(shù)據(jù)引入MapX的過(guò)程，外部數(shù)據(jù)可以是多種類型的數(shù)據(jù)庫(kù)，數(shù)據(jù)綁定后可以在地圖上以圖元瀏覽數(shù)據(jù)或基于這些數(shù)據(jù)創(chuàng)建專題渲染地圖。特征集合和特征查找在MapX中,地圖由圖層組成,圖層又是由地圖特征組成。通常每個(gè)圖層中只包含一種類型的特征。在MapX中,一個(gè)圖層中的所有特征構(gòu)成了一個(gè)特征集合。其中每個(gè)圖元就是一個(gè)特征對(duì)象,可以通過(guò)圖層的屬性查找定位地理特征，如線、符號(hào)或區(qū)域特征。為了能夠使用該方法,必須使查找圖層的Mapinfo表中存在一個(gè)索引字段。在各圖層中實(shí)現(xiàn)找尋地物的方法：ForEachlyRInMap1.LayersIflyR.Name="行政教學(xué)樓"ThenSetds=Formmain.Map1.DataSets.Add(miDataSetLayer,lyR)Setftrs=lyR.Search("NAMElike""%"&buildname&"%""")MapX的模型結(jié)構(gòu)MapX組件的基本組成單元是單個(gè)對(duì)象(Object)和集合(Collection)，其中集合包括對(duì)象,是多個(gè)對(duì)象的組合，每種對(duì)象和集合負(fù)責(zé)處理地圖某一方面功能[3]。MapX定義了一個(gè)類體系，可以有效地組織圖形元素、圖層及屬性數(shù)據(jù)等對(duì)象，主要有以下功能：①顯示MapInfo格式的地圖。MapX支持與MapInfo一致的數(shù)據(jù)格式，可直接打開(kāi).tab、.gst等文件。②生成和編輯地圖對(duì)象。MapX中封裝了大量的繪圖工具，可生成點(diǎn)、線、面和注記等要素，它內(nèi)部的FeatureFactory對(duì)象為要素符號(hào)化提供了方法，并允許用戶自定義符號(hào)。③供對(duì)地圖進(jìn)行放大、縮小、漫游和要素選取等操作。在MapX中，應(yīng)用ToolUsed事件并設(shè)定相關(guān)參數(shù)，便可實(shí)現(xiàn)對(duì)地圖的上述操作。④圖層控制。MapX允許用戶將要素分層管理，真正創(chuàng)建要素的物理層。圖層控制、加載圖層、加載圖層集的方法如下：.Map1.Layers.LayersDlgMap1.RefreshDialogTitle="加載圖層".Filter="MapInfoTables(*.tab)|*.tab".DialogTitle="加載圖層集".Filter="MapXGeoSet(*.gst)|*.gst"⑤建立屬性表。MapX提供了實(shí)現(xiàn)數(shù)據(jù)庫(kù)中的數(shù)據(jù)與MapInfo地圖關(guān)聯(lián)的方法，對(duì)幾何數(shù)據(jù)賦予相應(yīng)的屬性，以滿足信息查詢的需要。用戶可通過(guò)圖上選取或SQL語(yǔ)句對(duì)要素的屬性進(jìn)行訪問(wèn)。2系統(tǒng)模型與功能設(shè)計(jì)2.1系統(tǒng)模型設(shè)計(jì)在用戶需求分析的基礎(chǔ)上，系統(tǒng)的總體結(jié)構(gòu)設(shè)計(jì)包括：地圖數(shù)據(jù)管理、系統(tǒng)組成、系統(tǒng)界面、系統(tǒng)功能、數(shù)據(jù)存儲(chǔ)管理、數(shù)據(jù)顯示以及數(shù)據(jù)輸入輸出，該系統(tǒng)結(jié)構(gòu)如圖1所示。圖1系統(tǒng)總體結(jié)構(gòu)2.2系統(tǒng)功能設(shè)計(jì)該系統(tǒng)為學(xué)校只能部門(mén)對(duì)校園房產(chǎn)和宗地進(jìn)行管理的工具，擁有管理員和擁護(hù)兩級(jí)使用權(quán)限，用戶可以對(duì)數(shù)據(jù)進(jìn)行查詢、統(tǒng)計(jì)和報(bào)表輸出等基本操作，管理員能夠進(jìn)行所有操作。圖2系統(tǒng)功能結(jié)構(gòu)圖2.3數(shù)據(jù)庫(kù)結(jié)構(gòu)和數(shù)據(jù)詞典用戶管理信息表用戶管理表用于存儲(chǔ)用戶名稱，密碼和權(quán)限土地管理信息表土地管理表用于存儲(chǔ)管理員錄入的校園宗地信息，以便用戶由圖查詢宗地屬性時(shí)，顯示相關(guān)信息。土地信息一般包括如表2的字段。除上字段外還有發(fā)證日期、證書(shū)號(hào)、載明面積、權(quán)屬性質(zhì)、取得日期、坐落位置、土地面積（平方米）、土地面積（畝）、金額、使用單位、土地來(lái)源、使用狀況及備注等。人事住房信息表人事住房信息表用于存儲(chǔ)管理員由excel表導(dǎo)入或由對(duì)話框錄入的職工住房信息，以便資產(chǎn)部門(mén)快速查詢，了解職工個(gè)人住房和相關(guān)信息，避免過(guò)去那種低效的翻閱紙質(zhì)卡片檔案的繁瑣勞動(dòng)。人事住房信息內(nèi)容較多，包括姓名、性別、單位名稱、出生年日、最高學(xué)歷、上大學(xué)時(shí)間、參加工作時(shí)間、離退休時(shí)間、職務(wù)、職稱、配偶姓名、配偶單位、門(mén)牌號(hào)碼、房屋類型、建筑面積、使用面積、售房面積及竣工時(shí)間等40多項(xiàng)。建筑物信息建筑物信息表用于存儲(chǔ)管理員由對(duì)話框錄入的公房信息，資產(chǎn)管理員利用查詢功能可快速查詢各類公房的相關(guān)信息和圖片，還有建筑物結(jié)構(gòu)、卡片號(hào)、資產(chǎn)分類代碼、證書(shū)號(hào)、產(chǎn)權(quán)使用人、發(fā)證日期、坐落位置、使用狀況、竣工日期、建筑面積（平方米）、金額、備注及圖片等。樓層信息表樓層信息表包括建筑物名稱、樓層、樓層總面積、衛(wèi)生間、過(guò)廊、樓梯、水房、配電室、值班室、水箱、備注及CAD圖等。供資產(chǎn)管理人員快速查詢每棟樓房的各層信息和圖片。房間信息房間信息表包括建筑物名稱、樓層、使用單位、房間號(hào)、房間名稱、使用方向、建筑面積、使用面積、配電室、值班室等信息和圖片。供資產(chǎn)管理人員快速查詢樓房的各層房間的相關(guān)信息。3系統(tǒng)主要功能實(shí)現(xiàn)3.1屬性數(shù)據(jù)的輸入和輸出公房管理信息系統(tǒng)主要用于人事住房信息、公房信息、宗地信息等的查詢、統(tǒng)計(jì)、報(bào)表等工作，提高職能部門(mén)的工作效率和管理水平，而這些信息數(shù)據(jù)種類繁多、錄入信息量較大，本系統(tǒng)采用了兩種錄入方法：一種方法是對(duì)已有excel表格數(shù)據(jù)由程序按字段自動(dòng)導(dǎo)入ACCESS數(shù)據(jù)庫(kù)，這樣避免了大量的數(shù)據(jù)錄入工作，并消除了錄入過(guò)程的錯(cuò)誤；另一種方法是采用對(duì)話框的方式，將各種數(shù)據(jù)表中的字段顯示在對(duì)話框中，以編輯框的方式，直觀友好的進(jìn)行數(shù)據(jù)的錄入、添加、修改和刪除等操作。在對(duì)屬性數(shù)據(jù)進(jìn)行統(tǒng)計(jì)后，不僅可在對(duì)話框中顯示數(shù)據(jù)，而且可形成excel報(bào)表，將統(tǒng)計(jì)結(jié)果輸出，呈報(bào)有關(guān)部門(mén)，提高辦事效率，快速為職能部門(mén)的決策提供依據(jù)。3.2查詢功能實(shí)現(xiàn)圖文互訪是系統(tǒng)最大的特點(diǎn)，系統(tǒng)提供了兩種方式的查詢，一種是從地圖到屬性的查詢、瀏覽，即從平面圖查詢指定地物的屬性。另一種是從屬性到地圖的定位查詢定位，由地物的屬性值如建筑物的名稱查詢?cè)摻ㄖ镌诘貓D中的位置，亮顯并放大。3.3統(tǒng)計(jì)報(bào)表功能統(tǒng)計(jì)匯總功能分為攻防統(tǒng)計(jì)和居住房統(tǒng)計(jì)兩大功能板塊，其中居住房統(tǒng)計(jì)又分為：人事住房統(tǒng)計(jì)、租房統(tǒng)計(jì)、售房統(tǒng)計(jì)。3.3其他功能本系統(tǒng)還包括宗地信息查詢、地圖顯示、面積和距離測(cè)量、地圖信息查詢、輸出、保存以及打印等功能。4結(jié)束語(yǔ)采用VisualBasic語(yǔ)言結(jié)合MapX的開(kāi)發(fā)環(huán)境，從分利用了組件式開(kāi)發(fā)的優(yōu)點(diǎn)，縮短了系統(tǒng)開(kāi)發(fā)的時(shí)間，降低了開(kāi)發(fā)的難度，同時(shí)也大大提高了系統(tǒng)的信息管理的能力和效率。系統(tǒng)優(yōu)點(diǎn)如下：（1）實(shí)現(xiàn)了對(duì)已有數(shù)據(jù)導(dǎo)入系統(tǒng)的功能以及地圖和屬性數(shù)據(jù)的關(guān)聯(lián)關(guān)系。（2）實(shí)現(xiàn)了對(duì)圖道屬性和由屬性到圖的雙向查詢，彌補(bǔ)了MIS系統(tǒng)缺乏空間數(shù)據(jù)的缺點(diǎn)。（3）實(shí)現(xiàn)了對(duì)公房信息、土地信息和人事住房等信息的實(shí)時(shí)更新、統(tǒng)計(jì)和報(bào)表功能。這種軟件開(kāi)發(fā)技術(shù)也可用于地下管網(wǎng)與交通信息系統(tǒng)等方面，對(duì)類似的軟件開(kāi)發(fā)具有一定的參考價(jià)值。后續(xù)工作也可從三維可視化技術(shù)入手，進(jìn)行空間信息查詢。參考文獻(xiàn)[1]Linxiaosong.thedesignanddevelopmentofCampusRealEstatebasedonGIS[J].ChongqingJiaotongUniversity,2004[2]Zhengwenwu,Liuyong.hedesignanddevelopmentofCampusRealEstatebasedonMapObjects.HengyangshifangUniversity,2005[3]Wanjianhua,Menghui.TheApplicationofGISinCampusRealEstateManagement.People'sTrafficPress,2007TheApplicationofGISinCampusRealEstateManagementChengYaodongMengBinZhaoTingtingHanJinWangAin(SchoolofMathematics,Physics&SoftwareEngineering,LanzhouJiaotongUniversity,LanzhouGans730070,China;)Abstract:Houseproperties,landresourcesandtheirspatialdistributioncanbemanagedeffectivelyandaccuratelywiththehelpofGIStechnologyusedinvisualmanagementofcampusestateandlandinformation,whichprovidesatoolforassetsmanagementdepartmentstoperformfastandeffectivedecisionmakingandmanaging.Withthedesignofgeneralstructure,functions,anddatabaseasthebasis,theuseofGIScomponentstechnologytoembedManxintoVisualBasic6.0,andAccessasdatabasedeveloptool,acampusestatemanagementinformationsystemisdeveloped,whichincludesfunctionslikeentering,inquiry,modifying,statisticsandreportingofdata.Thesystemhasworkedwellpractically.Keyword:computerapplication;houseandlandinformationmanagement;GIS;MapXWiththerapiddevelopmentofGIStechnology，"Digitization"ofallwalksoflifeinChinahasmadegreatprogress,theNetworkmanagement'sdesireof"DigitalCity"and"DigitalChina"istobecomeareality.Duetotherapiddevelopmentofhighereducationandtheconstantexpansionoftheschool,Andtheschoolland,realestaterapidlyincreaseandchange.TheinconsistencyofGraphicinformationandattributeinformationandThemanagementoftheuniversityassetsmanagementdepartmentaboutmanagementtoolsandmanagementsoftwareandmanagementstylecannotadaptthemanagementneedsofthenewsituation.Inordertoadapttheneedsofthedevelopmentoftheinformationage,theestablishmentoftheUniversityPropertyandparcelmanagementinformationsystemisimperative.WithsoftwaredevelopmentabouttherealestateandparcelmanagementinformationsystemsofLanzhouJiaotongUniversity,weresearchfortheFunction,ForexamplethestorageofInformationdata,update,modify,query,statisticsandreportsaboutThecampusestateandland,BasedonvbandMapXcomponentanddatabasesoftwareAccess,whichplayasignificantroleandhaveaprofoundimpactfortheefficiencyofschoolsectormanagementandthelevelofinformationmanagement.Thesystemhasbeenusedinschoolsintelligencedepartmentandprovidedavisualizationplatformforcampusinformationmanagement.1ThepublicestatemanagementbesedonMapXandVb1.1athree-tierstructurecouldbeingdesignedusuallyinthedevelopmentplatformofComponentGIS.(1)BasiccomponentsForspatialdatamanagement,toprovideabasisforinteractionandconnectwiththedatabasesystembyaflexibleway.(2)SeniorcommoncomponentsMadebytheunderlyingcomponentstructure,thedevelopmentprocessbecomesimpleforuserAboutcommonfunctions,ForexamplethecomponentsofdisplaytoolandselectToolsandeditingtoolsandattributebrowser.Cooperativecontrolmessagesareencapsulatedbetweenthem.theCommonfunctionsmakesecondarydevelopmenteasierafterComponentshavebeenpackaged[2].(3)IndustrycomponentsAbstractedindustryapplicationspecificalgorithms,fixedtothecomponent,acceleratethedevelopmentprocessbymoveforwardasinglestep.ForGPSapplications,NotonlytheneedofthemapdisplayandInformationinquiryandothertheGPSfunctions,butalsorequiresaspecificapplicationfunctionswhichbasedonGPSmonitoring,Suchasdynamictargetdisplay,targetlock,trackindicatorlights.AftertheGPSindustryapplicationfunctionalcomponentswhichareencapsulated,Legendofthedevelopmentworkcanbereducedtothetargetsetdisplay,thetrajectorydisplayofcolor,targetlockandthewayoftheaccepteddata.1.2DevelopmentapproachbasedonMapXLayersMapXislayer-organizationmapwhichdividedacomputermapintomultipletransparentlaminatedlayersandeachlayerincludinganinformationoftheentiremap.wecancoordinatethehandlingoftherelationshipofthevariouslayersbycontrolingtheLayerscollectionthatmadeeditandmanageeasyer.collectionofmaplayerswascomposedbylayers,theoperationssuchasadding,deleting,changingmustpassacollectionoflayersinMapX.Theobjectineachmap,includingacollectionoflayersandlayerscollectionbasedonlayerobjects.throughtheLayerscollectionaccessmaplayers,throughtheLayerscollectionaccessmaplayers.MapXcontrolthemapbycontrolingcollectionoflayers.Tosetinthecampuselectronicmaplayers,suchastheadministrationbuilding,classroombuilding,laboratorybuilding,alibrary,apartmentsandfamilywings,greenspaces,campusattractions,playgrounds,roadsnodesroadlinesandboundariesoflayers.DataBindingEachmaphasadatacollection,datacollectioncanattributedataandmapspatialdatalink.DataBindingtointroducetheMapXTheprocessofexternaldata,externaldatacanbeavarietyoftypesofdatabase,databindingelementsonthemapbrowsingdataorbasedonthesedatatocreateathematicmapisrendered.CharacteristiccollectionsandthewaytofindInMapX,themapismadeupoflayersandlayersmadeupofmapfeatures.Usuallyeachlayerhasonetypeofcharacteristics.InMapX,allthecharacteristicsofalayerconstitutingafeatureset.Eachdiagramelementisafeatureoftheobject,bythepropertiesofthelayertolocategeographicfeatures,suchaslines,symbolsorregionalcharacteristics.Mapinfotableinordertobeabletousethismethod,youmustfindlayersthereisanindexfield.themethodofFindingthesurfacefeaturesineachlayer:ForEachlyRInMap1.LayersIflyR.Name="Chiefclassroombuilding"ThenSetds=Formmain.Map1.DataSets.Add(miDataSetLayer,lyR)Setftrs=lyR.Search("NAMElike""%"&buildname&"%""")(4)ThemodelstructureofMapXThebasicunitinMapXcomponentisasingleobjectandcollectioncollectionincludesobjects,isacombinationofmultipleobjects,eachobjectandcollectionhandlesmapafunction[3].MapXdefinesaclasssystem,whichcaneffectivelyorganizethegraphicelements,layersandattributedataobjects,mainlythefollowingfunctions:TodisplaythemapofMapInfoformat.MapXandMapInfoconsistenthavethesamedataformat.AndTab,.Gstandotherdocumentscanbeopeneddirectly.Togenerateandeditmapobjects.AlargenumberofdrawingtoolsencapsulatedinMapXwhichcangeneratepoints,lines,surfaces,andannotationelementsonitwithinFeatureFactoryobjectelementssymbolizedprovidesmethodsandallowstheusertocustomsymbols.Forthemap,zoomin,zoomout,roamingandfeatureselectionoperation.InMapX,ToolUsedeventandsettherelevantparameters,theaboveoperationcanberealizedonthemap.Layercontrol.MapXallowstheusertomanagetheelementsofhierarchicalandcreatetheelementsofthephysicallayerreally.thefollowingmethodofLayercontroling,loadinglayers:Map1.Layers.LayersDlgMap1.RefreshDialogTitle="loadinglayers".Filter="MapInfoTables(*.tab)|*.tab".DialogTitle="Loadacollectionoflayers".Filter="MapXGeoSet(*.gst)|*.gst"Createapropertysheet.MapXprovidesthedatainthedatabaseandMapInfomapassociatedmethod,giventhecorrespondingpropertyofthegeometricdata,inordertomeettheinformationneedsofthequery.UserscanselectFigureorSQLstatementstoaccessthepropertiesoftheelements.2Thesystemmodelandfunctiondesigned2.1ThedesigneofSystemModelTheoverallstructureofthesystemdesignbasedonuserneedsanalysis,includingmapdatamanagementsystem,systeminterface,systemfunctionality,datastoragemanagement,datadisplayanddatainputandoutput,thesystemarchitectureisshowninFigure1.Figure1SystemArchitecture

2.2ThedesigneofSystemfunctionThesystemisthetooloffunctionaldepartmentstocarryoutmanagementforthecampuspropertyandland.Ithastwopermissionsofadministratoranduser.Userscanquery,statisticsandreportoutputandotherbasicoperationsondata.managercandoallofoperations.Figure2Thesystemfunctionstructurechart2.3Thedatabasestructureanddatadictionary（1）ManagementofuserinformationtableUsermanagementtableisusedtostoretheusername,passwordandpermissions.（2）LandmanagementinformationtableLandmanagementtableisusedtostoretheadministratorwillinputthecampusparcelinformation,sothattheuserbygraphqueryparcelattributes,displayrelatedinformation.Landinformationgenerallyincludes2fields.Inadditiontofield，thereisthedateofissuance,thecertificatenumber,specifythenatureofthearea,location,dateofacquisition,,landarea(squaremeters),landarea(MU),amount,useunits,landsources,theuseandremark.PersonalhousinginformationtablePersonalhousinginformationtableisusedtostoretheadministratorbyimportexceltableorbytheemployeehousinginformationentry,querytoassetmanagement,andknowledgeworkersindividualhousingandrelatedinformation,toavoidthetediouslaborinthepastthekindofinefficientreadingpapercardfile.Personalhousinginformationislarge,includingname,gender,unitname,birthyear,thehighestdegree,theUniversityoftime,time,timetoparticipateintheworkofretired,post,title,nameofspouse,thespouseunit,number,typeofhousing,constructionarea,usethearea,whiletheareaandthecompletiontimeofmorethan40kinds.BuildinginformationBuildinginformationtableisusedtostorethepublichousesbytheinformationinputbythedialogmanager.Assetadministratorsuserelevantinformationandimagequeryfunctioncanquicklyqueryallkindsofpublichouses.therearethestructureofbuildings,thecardnumber,assetclassificationcode,thecertificatenumber,propertyuse,date,location,use,constructionarea,thecompletiondate(squaremeters),theamountofnotesandpictures,etc..FloorinformationtableFloorinformationtableincludesbuildingname,floors,totalfloorarea,bathrooms,corridors,staircases,waterroom,powerdistributionroom,dutyroom,watertank,notesandCADmap，forassetmanagementfastqueryinformationandpicturesofeachlayerofeachbuilding.RoominformationtableTheroominformationtableincludesbuildingname,floor,useunit,roomnumber,nameofroom,use,constructionarea,usethearea,powerdistributionroom,dutyroominformationandpictures，forassetmanagementfastqueryinformationandpicturesofeachroomofeachlayer.3Themainfunctionsofthesystemimplementation3.1InputandoutputofattributedataPublichousesbythemanagementinformationsystemismainlyusedfortheworkingpersonnelhousinginformation,publicinformation,informationquery,landstatistics,report。Itimprovesthefunctionaldepartmentsoftheworkefficiencyandmanagementlevel。Theinformationdatahasmanykinds，andinformationofInputislarge。Thesystemusestwoinputmethod：OnemethodistheEXCELformdatabyprogramsinthefieldofautomaticimportofACCESSdatabase。Thismethodavoidsalotofdataentryworks,andremovestheentryprocesserrors。Anothermethodistousethedialogbox,thefielddatainthetableshowninthedialogbox,intheeditbox,intuitiveandfriendlydataentry,add,modifyanddeleteoperations.Inthestatisticsoftheattributedata,notonlycandisplaydatainadialogbox,butalsocanformaexcelstatement,theoutputresults,reportedtotherelevantdepartments,improveworkefficiency,andprovidethebasisforthedecision-makingdepartmentsquickly.3.2InquiryfunctionRealizationofgraphicexchangeisthebiggestfeature。Thesystemprovidestwowaystoquery。Oneisqueryandbowsefromamaptoattribute,querythespecifiedobjectfromaplanargraphproperties。Anotheristhequerylocationfromapropertytomaplocation。Thenamesuchasbuildingquerythebuildingpositioninthemapbyobjectattrib