Docstoc

projectReport_Uttam SAIKIA_ID-10040

Document Sample
projectReport_Uttam SAIKIA_ID-10040 Powered By Docstoc
					                                                                                      1

                                            A
                                      PROJECT REPORT
              o                              ON
   INTEGRATION OF CADASTRAL MAPPING
                USING
          ORACLE SPATIAL 10G




                                        SUBMITTED BY
                                         Uttam Saikia
                                         Roll No: 05/13



                                     UNDER THE GUIDENCE OF

   Mr. BICHITRA KALITA                                Mr. GANESH KHADANGA
   Selection Grade Professor                                 (Scientist D)
   Dept. Of Computer Application                            LRIS Division
   Assam Engineering College                         National Informatics Centre
   Guwahati-781013                                        New Delhi-110003



   Work done at:
         Land Record Division, National Informatics Center



Dept. Of Computer Application, AEC                                         NIC,New Delhi
                                                                                  2




                            GOVERNMENT OF INDIA
    MINISTRY OF COMMUNICATIONS & INFORMATION TECHNOLOGY


                  DEPARTMENT OF INFORMATION TECHNOLOGY


                     National Informatics Centre
             This is to certify that Shri Uttam Saikia ID no-10040 a student of

   Master of Computer Application from Gauhati University has done/is

   doing his full-semester project training at LRISD, Department of

   information technology NIC, New Delhi, from 02.06.07 to 15.11.2007.

               The project work entitled “Intregation Of Cadastral mapping

   Using oracle Spatial 10g” embodies the original work done by him during

   his above full semester project training period.




     Head / Project Guide                              Technical Director
                                            Training Division, NIC New Delhi




Dept. Of Computer Application, AEC                                     NIC,New Delhi
                                                                                   3




                                DECLARATION

                 I do, hereby, declare that the dissertation entitled “Integration
   Of Cadastral Mapping Using Oracle spatial 10g” is an authentic work
   developed by me at “National Informatics Center, New Delhi”, under the
   guidance of Mr. Ganesh Khadanga (Scientist-D) and Mrs. Sanjukta Pradhan
   (Scientist B) and Mr. Bichitra Kalita (Selection Grade Professor, AEC) and
   submitted as a 6th semester project work for the degree of Master Of
   Computer Application under Gauhati University.


            I also declare that, any or all contents incorporated in this
   dissertation have not been submitted in any form for the award of any
   degree or diploma of any other institution or university.




                                               Uttam Saikia
                                              6th semester, M.C.A
                                        Assam Engineering College, Jalukbari
                                              Guwahati-13




Dept. Of Computer Application, AEC                                      NIC,New Delhi
                                                                                      4




                    ACKNOWLEDGEMENT

            The successful completion of the project entitled Integration Of Cadastral
   Mapping Using Oracle Spatial 10g ”is attributed to the great help received from
   different people. Nothing concrete can be achieved without an optimal combination
   of inspiration and perspiration.

           I would to like to express my sincere thanks to Dr. D. R. Shukla (H.O.D.,
   LRISD) for providing me with the opportunity to take up Project at National
   Informatics Center in its Land Records Information System Division.
            I am extremely thankful to Mr. Ganesh Khadanga (P.S.A., LRISD), my
   Project in charge, for his invaluable time & direction that enabled me to complete an
   immensely productive & challenging assignment such as this.
            I would like to express my kind gratitude to Mrs Sanjukta Pradhan
   (Scientist-B) for her guidance at the logical level during the various phases of the
   project. Without his assistance it would not have been possible to overcome the
   complexities involved in the project.


                   With due regards and thanks.




                                                       Uttam Saikia
                                                       MCA 6th Semester
                                           Assam Engineering College, Jalukbari
                                                        Guwahati-13




Dept. Of Computer Application, AEC                                         NIC,New Delhi
                                                                                         5

                           Assam Engineering College
                    Department of Computer Application
                        Jalukbari, Guwahati-13, Assam




                         CERTIFICATE


             This is to certify that Mr. Uttam Saikia ,a student of 6th semester, Master of
   Computer Application, ASSAM ENGINEERING COLLEGE, GUWAHATI has carried
   out the project on “Integration Of Cadastral Mapping Using Oracle Spatial 10g” for
   the LRISD,NIC-HQRS, New Delhi.
             This project work has been prepared as a fulfillment of the requirement for
   the degree of Master of Computer Application to be awarded by Gauhati University.
   This work has not been presented earlier for any other academic activity.


               I wish him all success in life.




                                           (Jyoti Prakash Guwashami)
                                      Assistant Professor & Professor In charge
                                     Department Of Computer Application
                                           Assam Engineering College
                                             Guwahati-781013




Dept. Of Computer Application, AEC                                            NIC,New Delhi
                                                                                         6

                                      ABSTRACT

          I am doing my project in LRISD (Land Records Information System
   Department) under ministry of Communication and IT. As we know that our land
   records information are traditionally paper based, they are maintained on paper.
   But LRISD has started to computerize the land records information of the different
   states of INDIA and they have also finished computerization of some of the states.
   This application will be web based. This application will have all the features report
   generation. One of the main repots that they do generate is ROR (Records of
   Right). These reports are in a hierarchy like States-> District->Tehsil->Ri->Halka-
   >Village->ParcelId and for a single village the official may have to generate
   thousands of such ROR.
           My module should be able to generate ROR report in a printable format. I
   should also provide a function to generate a ROR report and print it along with the
   map. This map is in digitized format. My module should also provide the facility to
   mutate (change of ownership, partition of land) a specified plot and also should be
   able to generate ROR report in a printable format for the mutated plots.
           Here I will use three-tier software architecture –as a front end Java server
   pages (JSP) and as back end I will use oracle 10g database.


   Tools and Technology Used:
                                     Java Server Pages
                                Oracle 10 g (includes spatial features)
                          JTS Library and Java Map Viewer API
                              Oracle 10g Jdeveloper IDE
                          Oracle OC4J application Server.




   NIC Division Allotted:        Land Record Computerisation.


   Module / Name Of Student Trainee(s) / Trainee ID:

Dept. Of Computer Application, AEC                                            NIC,New Delhi
                                                                                  7



         “Integration Of Cadastral Mapping Using Oracle spatial 10g” / Uttam Saikia
   /10040.




Dept. Of Computer Application, AEC                                     NIC,New Delhi
                                                8




             STUDY OF ORGANIZATION




Dept. Of Computer Application, AEC   NIC,New Delhi
                                                                                         9




   1.National Informatics Centre
              National Informatics Centre (NIC) is a premier Information Technology
   organization in India committed to providing state-of-the-art solutions for the IT
   needs of the Government of India at all levels. NIC carries the distinction of being
   the largest IT organization in the country and has set up a satellite based nation
   wide computer communication network called NICNET having over 1400 nodes
   connecting the national capital, the state capitals and the district headquarters to
   one another. The IT services of NIC range from Consultancy, Software Conferencing,
   CAD, EDI, Multimedia and Internet Services including Web Site Development and
   Hosting. NIC has a nation wide presence with its offices spread all across the
   country, from Leh to Andaman & Nicobar Islands.


              The organizational set up of NIC encompasses its Headquarters at New
   Delhi, State units in all the 29 State Capitals and 6 Union Territory Headquarters
   and District centers in almost all the districts of India. The organization employs a
   large pool of efficient technical manpower. At the NIC Headquarters, a large number
   of Application Divisions exist which provide total informatics support to the
   ministries and departments of the central government. NIC computer cells are
   located in almost all the Ministries of the central government and apex offices
   including the prime ministers office, the Rashtrapati Bhawan and the Parliament
   House. Apart from this, NIC has various resource divisions at the headquarters,
   which specializes into different areas of IT and facilitate the application divisions as
   well as the NIC centers in providing state-of-the-art services to the government.



Dept. Of Computer Application, AEC                                            NIC,New Delhi
                                                                                       10



            At the state level, NIC state centres provide informatics support to their
   respective state government and at the district leve3l there are the NIC district
   informatics offices that strive hard to provide effective informatics support to the
   development, revenue and judiciary administration of the district.


           In order to promote Information Technology in the country, focusing on
   Internet Technology based value – added services in the area of industry, business
   and commerce, NIC has also established 17 National Information Technology
   Promotional Units (NITUs) at major industrial/commercial cities viz., - Ahmedabad,
   Bangalore, Bhopal, Bhubaneswar, Chandigarh, Chennai, Hyderabad, Jaipur,
   Kanpur,     Kochi,    Kolkata,    Lucknow,   Mumbai,   Nagpur,   Patna,    Pune   and
   Vishakapatnam. These centres provide video – conferencing facilities, EDI services
   and other Internet Technologies based services over NICNET.
   The spectrum of services provided by NIC encompasses various dimensions of the
   Information Technology Arena and can be broadly listed as under:


      Consultancy Software
      Design & Development
      Networking Internet Services
      WWW Services
      Video Conferencing
      Computer Aided Design (CAD)
      Multimedia
      Mathematical Modelling and Simulation
      Geographical Information System
      Electronic Commerce
      Office Automation
      Training
      Rural Informatics


Dept. Of Computer Application, AEC                                           NIC,New Delhi
                                                                                             11

      Patent Information
      Computer Telephony Interface (CTI)
      Computer Aided Paperless Examination Systems


   1.1 LAND RECORDS INFORMATION SYSTEM DIVISION

          Land Records is driving towards e-Governance by making computerization’s
   vast scope for Data Collection, Storage, Processing and Retrieval; effective and
   proper maintenance of Land Records well within its purview. LRIS aims to achieve
   the following objectives:



                     Automatic generation and issues of Records of Rights
                     Data     Integrity,   accuracy     and   timeliness   in   Land   Records
                      Information Processing is ensured.
                     Allows more time to the village functionary to engage in
                      development activities since maintenance of registers is automatic
                      due to LRIS.
                     As Correct and reliable data is always available, it proves useful for
                      planning and decision-making providing speedier social justice.
                     Documents with legal implications can be generated to enable needy
                      landholders, for use as a proof of title, to secure loans and subsides
                      under various development programs.
                     Retrieval of land records information in useful formats for decision
                      making and planning at the Revenue Block/Revenue Circle/Sub
                      Division/ District/ State level.
                     Helps to settle land disputes by providing accurate and effective
                      information.
                     Contributes to Agriculture Census work with up to date Crop
                      information.
                     The crop information maintained is useful for agricultural census
                      work.
Dept. Of Computer Application, AEC                                                 NIC,New Delhi
                                                                                     12

                     The land reforms can be implemented is useful for agricultural
                      census work.
                     The land reforms can be implemented effectively.
                     Data Safety by using storage devices like Cartridges, CD-ROMS,
                      thereby eluding data loss and data corruption.



          The Land Records Information System Software attempts to cover all
   processes involved in Recording of Land use, Crop, Tenant and Ownership details
   including transfer of ownership in its scope of Computerization.

          Land data is maintained by revenue Department and is regularly updated by
   the latter as and when new data is generated at the sub district level. The LRIS
   software deploys only textual data that is neither graphic nor spatial. The
   computerized Land Records Information System purports to include the following
   subsystems or functions. These cater to the various facets of effective LRIS software
   satisfying user’s diverse information needs.



   1.2 COMPANY PROFILE:

   Company Name          : National Informatics Center.

   Address               : NIC A-Block,
                            CGO complex,
                           Lodhi Road,
                           New Dwlhi-110003,

   Phone No              :
   Fax                   :
   Website                : http://indiaimage.nic.in/

   Company Logo          :




Dept. Of Computer Application, AEC                                         NIC,New Delhi
                                               13




                    System Study




Dept. Of Computer Application, AEC   NIC,New Delhi
                                                                                          14

   2. INTRODUCTION ABOUT THE PROJECT:

   2.1 Need of the System
            “Integrated Of Cadastral Mapping using oracle 10g” is software in
   series of domain specific software products, which would be greatly facilitating
   integration of Record of Rights with Cadastral maps. It is the first version of LRIS
   through which digitized maps can be stored, viewed and specific plots can be splitted
   and mutated based on perimeter and digested points. It displays the ROR in Hindi.
   Apart from this, the software can also generate reports of printing, mutation and
   merging without using any separate report tool.


   Highlights

       Posting data - Data for a specified village can be posted into LRIS, which
        requires the three files (.shp, .sbx, .dbf).
       Viewing the list of the available map data after the data has been posted into it.
       Highlighting a specific plot with area, scale, location and its adjacent plots.
       Print of a particular plot and its ROR.
       Mutation – Mutation can be done by two ways –
                     By corner points
                     By perimeter
       Grid can be displayed of various sizes (in meters) according to user’s choice that
        help the user to select the intermediate points inside the plot in order to mutate
        the plot in the desired way.
       Saving the mutated plots in the database.
       Merging - The mutated plots can be merged to get the original plot with that the
        details of the mutated plots will be deleted from the database.
       A report of the mutation & merging details and the printing details of all the
        plots is generated.




Dept. Of Computer Application, AEC                                              NIC,New Delhi
                                                                                           15




   2.2 Project Title:

         The Project Titled as “Integration Of Cadastral Maping Using Oracle
   spatial 10g”.The project is the module for Land record computerization.


   2.3 Problem Definition:

               As we know that our land records information are traditionally paper
   based, they are maintained on paper. But LRISD has started to computerize the
   land records information of the different states of INDIA and they have also finished
   computerization of some of the states. This application will be web based. This
   application will have the features of report generation about plots and do mutation
   or multiple division of a specified plot. One of the main repots that they do generate
   is ROR (Records of Right). These reports are in a hierarchy like States-> District-
   >Tehsil->Ri->Halka->Village->ParcelId and for a single village the official may have
   to generate thousands of such ROR.
              It is software catering to the needs of Tehsildars at all places in India. It is
   software in series of domain specific software products, which would be greatly
   facilitating integration of Record of Rights(ROR) with Cadastral maps. It is the first
   version of LRIS through which digitized maps can be stored, viewed and specific
   plots can be splitted and mutated based on perimeter and digested points. It displays
   the ROR in Hindi.
            Apart from this, the software can also generate reports of printing, mutation
   and merging without using any separate report tool.


   2.4 OBJECTIVE OF THE PROJECT:

   This project consisting of two parts.


          Generation of report consisting of attribute data with map (ROR + Map).
          Mutation module.

Dept. Of Computer Application, AEC                                              NIC,New Delhi
                                                                                               16

   Generation of report consisting of attribute data with map

   Objective:
           ●    Integration of land record alphanumeric attribute data with spatial map.
           ●    Implementing the solution over web.


   Mutation Module

               Mutation is a process by which the ownership of the plot changes.          This
   module stores any kind of change in ownership, cultivation rights, plot details etc.


    Objective:

                Given a khasra no and the specification for mutation, split the parcel into
                 multiple part according to the specification.
           ●     Implementation of the module over web.


   2.5 SCOPE OF THE PROJECT:

               When we develop a system a lot of problems arise. We are developing a
   Integrated System for land record with map details. While making the project, the
   team must consider about all the problems associated with that project. This system
   has mainly two entities.
                 Parcel
                 Person
   These two entities are related. Person has Right over Parcel defines the relationship.




   The basic model can be depicted as follows:
Dept. Of Computer Application, AEC                                               NIC,New Delhi
                                                                                     17



                                Right
                Person                     Parcel




            It is software catering to the needs of Tehsildars for showing plot with
   ownership details. For printing configuration, the printing can be taken up in any A4
   size laser printer. It is preferable to take a print out in Lazar printer than a dot
   matrix printer. General users are only able to see the data attribute along with the
   map. They are not permitted to mutate any plot. Only Tehsilder or authorized
   official person can mutate the plot.




                                ************ ***************




Dept. Of Computer Application, AEC                                         NIC,New Delhi
                                               18




       FEASIBILITY STUDY




Dept. Of Computer Application, AEC   NIC,New Delhi
                                                                                             19

   3 INTRODUCTION TO FEASIBILITY STUDY
             Feasibility is the determination of whether or not a project is worth doing.
   The process followed in making this determination is called feasibility study. This
   type of study determines if a project can and should be taken. Once it has been
   determined that a project is feasible, the analyst can go ahead and prepare the
   project specification which finalizes project requirement.


         Normally feasibility studies culminate in a written or oral feasibility report.
   The contents and recommendations of such a study will be used as a sound basis for
   deciding whether to proceed, postponed or cancel the project. Thus, since the
   feasibility study may lead to the commitment of large resources, it becomes
   necessary that it should be conducted competently and that no fundamental errors of
   judgment are made. In the conduct of feasibility study, the analyst will usually
   consider six distinct but interrelated types of feasibility.
   They are

 3.1 ECONOMIC FEASIBILITY:

       The       financial   and   economic   question   raised    during   preliminary
 investigations are for the purpose of estimating-
                 The Cost to conduct full system investigation.
                 The cost of hardware and software for class of application.
                 The benefits in terms of reduced cost and fewer costly errors.
                 The cost if not changes ,i.e ,if the proposed system is not developed


 Our proposed system is economically feasible because-
              The system works efficiently.
              The system will provide a fast and efficient automated
                  environment instead of slow and taxing manual system,thus
                  reducing both time and manpower spent in running the existing
                  system.


Dept. Of Computer Application, AEC                                                 NIC,New Delhi
                                                                                     20


                      The system will be a user friendly one with a easy GUI.
                      The system will provide more efficient and unbreakable
                         security than the already existed manual system.
                      The cost of the system is nothing in comparison to the
                         amount of money it will save because of the higher security it
                         provides.

     3.2 TECHNICAL FEASIBILITY:


              Technical feasibility canters around the existing computer system(H/W
   and S/W) whether it can support the addition of proposed system, if not, to what
   extent it can support and organization’s capacity to acquire additional
   components.
   Our Proposed system is technically feasible because-
                      The H/W and S/W required are easy to install and handle.
                      The necessary H/W configuration and software platform is
                         already there.
                      The system supports interactivity will the user through GUI.


   3.3 BEHAVIORAL FEASIBILITY:

             Behavioural feasibility determines how much effort will go into selling
   the proposed system, in educating and training the user staff on the new
   system.Behavioral study strives on ensuring that equilibrium of the organization
   is not disturbed. The changes should be ready accepted by the staff and
   sanctioned by authority to achieve organizational objective.


   Our proposed system is behaviourally feasible because:


        The state authority accepts it since it provides greater security, which is a
           must requirement.


Dept. OF Computer Application, AEC                                           NIC ,New Delhi
                                                                                        21


        The staff, which uses the application ,accepts it, as it is not hard to use.
        The owner accepts it as it provides greater value to the document he
             posses(i.e the ROR or khasra report).



   4 SYSTEM REQUIREMENT SPECIFICATIONS:
   First module:
   Generation of report consisting of attribute data with map
     Objective:
         ●    Integration of land record alphanumeric attribute data with spatial map.
         ●    Implementing the solution over web.
   Input Specification:


          The Khasra no is provided as the primary input.
         ●    The attribute data, which consists of owner of the plot, Location, Area,
                   crop, area under crop, Remarked are stored in different tables in
                   Oracle database.
         ●    The spatial data for Parcel map are stored in Oracle as SDO_Geometry
                   data type.
   Output Specification:


         ●       The integrated report showing Record Of Rights (ROR) with the map
              for a particular plot.
         ●       The integrated report showing village map with highlighted plot



     Process
         ●       Based 0n the Khasra no the attribute data is to be fetched from
              different table to generate the ROR.
         ●       Using the ISCII2UTF tool the attribute data are converted into local
              language for display purpose.

Dept. OF Computer Application, AEC                                            NIC ,New Delhi
                                                                                        22


         ●        The spatial data corresponding to the khasra no are retrieved from
             the database using spatial query is rendered using map viewer.
   Mutation Module
                    Mutation is a process by which the ownership of the plot changes.
   This module stores any kind of change in ownership, cultivation rights, plot
   details etc.
      Objective:
         ●      Given a khasra no and the specification for mutation, split the parcel
                into multiple part according to the specification.
         ●      Implementation of the module over web.
   Input specification:
         ● The    input specification depends on the user level.
         ● If   the user is an administrator then he/she should be provided with the
             pending mutation cases waiting for his approval.
         ● The    pending mutation cases are shown with details such as mutation case
             no, plots no, mutation type, mutation specification etc.
         ● After    the approval from the admin the mutation details are stored with
             status as approved.
         ● The    DEO user then get the approved mutation case no, plot no, mutation
             specification details from the database.
         ● The    plot is spitted based on the specification stored in the database.
      Output Specification:


         ●      The visualization of map with mutated results
         ●      The new plots are stored in the database and the old plot details are
                moved into the history table
       Process:
         ● The     original data for the parcel map are stored in the oracle spatial
             database table.


Dept. OF Computer Application, AEC                                               NIC ,New Delhi
                                                                                        23


            ● The   DEO user will be shown with the original map with the coordinates
              and the points to be joined are taken as the input from the user
            ● The   input coordinates are converted into line and stored in a temporary
              table inside the database for later retrieval.


   For splitting the plot for mutation –
            The original plot spatial data are fetched and converted into line string
            and the mutation lines stored in the temporary table are also retrieved to
            create a line string out of multiple lines
                    ●   These two line strings are then merged
                    ●   The merged line strings are later polygon zed to get sub polygons
                        from the original polygon


       ●   The new sub polygon spatial data are then stored into the database in the
       original table as new entry and the original polygon data is moved to a history
       table.


   .
                                   **************   *************




Dept. OF Computer Application, AEC                                               NIC ,New Delhi
                                                               24




                            SYSTEM ANALYSIS




Dept. OF Computer Application, AEC            NIC ,New Delhi
                                                                                                25
   5. INTRODUCTION OF SYSTEM ANALYSIS:

         System Analysis is through study of various study operations preformed by a
   system and their relationship within and outside the system. One aspect of analysis is
   defining the boundaries of the system and determining whether or not a candidate
   system should consider other related system. During analysis, data are colleted on the
   available files, decision point and transaction handled by the present system. One of
   the best approaches to system analysis is the structures analysis. Structures analysis
   is a set of techniques and graphical tools that allows us to develop a new kind of
   system specification that is easily understandable to the developer.


   The various tools of structures analysis are:
             1. Data flow Diagram (DFD).
             2. Data Dictionary
             3. Decision Tree.
             4. Structured Table.
   5.1 Data Flow Diagram:
             The various symbols used to represents a data flow diagram are:




                The square defines a Source or destination of the system




              The Circle represents process that transforms dataflow(s) into outgoing data
   flow(s)




Dept. OF Computer Application, AEC                                             NIC ,New Delhi
                                                                                             26




             The open rectangle or the two lines is a data store




               An arrow represents the flow of data. It is a pipeline which the information
   flow




Dept. OF Computer Application, AEC                                          NIC ,New Delhi
                                                                                        27




                              Request to registration

                                     Responds             Cadastral
        TEHSILDER/
                                                        Mapping with
                              Request Map/ROR            ROR S/W
        OPERATOR /

        SURVEYER              Return                         0
                              parameters/Map




                           Fig-Context Diagram (0 Level DFD)




Dept. OF Computer Application, AEC                                     NIC ,New Delhi
                                                                                                   28




                               Request to authenticate


                                                            Login
                                                                           used
            OPERATOR /                                     Process
                                     Registration                                     DATABASE
           TEHSILDER /                                                     database
           SURVEYER                                           0.1


                                                  Request with perimeter


                                                                            used database

                                                          Cadastral
                                                          Mapping
                                                         With ROR S/W

                                                             0.2



                                                                     Responds
                         Request with perimeter



                                                     AUTHENTICATED
                                                      USER




                                     Fig: 1st Level DFD




Dept. OF Computer Application, AEC                                                NIC ,New Delhi
                                                                                                  29




                                                            Map View
      OPERATOR                                               Process
                                                              0.2.1


                                                Map Data                        Map Data
                                                                                From Database

                  Request Map View
                  And ROR                                                 MASTER STORE
                                         Combine
                                          Process
               Response                    0.2.3                                Parameter From
                                                                                Database

                                               ROR Parametter

                                                                 ROR
                                                                Process
                                                                 0.2.2




         NOTE:
         MASTER STORE- includes geometry data, personal data.
         Responds: specified map with ROR.


                              nd
                    Fig -:2        Level DFD for OPERATOR




Dept. OF Computer Application, AEC                                               NIC ,New Delhi
                                                                                               30



                                                            Map View
                                                             Process
                                                             0.2.1
                                                                          Map Data
      TEHSILDER
                                                                          From Database
                                           Map Data



                                          Combine                     MASTER STORE
                               c
     a        b                           Process
                                            0.2.3
                           d
                                                                           Parameter From
                                                                           Database

                                           ROR Parameters
         Mutation                                            ROR
                                                            Process
          Process              Responds                      0.2.2
           0.2.4


                  Mutation Result
                                          MUTATION STORE




     NOTE:
                                                            MASTER STORE and
     a – Flows of Tehsilder requested parameter.
                                                            MUTATION STORE includes:
     b – Responds mutated data.
                                                            geometry data, personal data
     c – Request for ROR and map view
     d - View map with ROR .




                         Fig -:2nd Level DFD For TEHSILDER




Dept. OF Computer Application, AEC                                            NIC ,New Delhi
                                                                                                      31



                                                                          Map Data
                                                                          From Database



                                                                                         MASTER STORE


           SURVEYOR

                                                    Map Data


                                a         Combine
                                          Process                                      ROR
                                                                ROR Parameters        Process
                            b              0.2.3
                                                                                       0.2.2



                                         Required Information

                          Send Required information
                                                                                       FAKE REPORT STORE
                                                                                 c


                        View the specified Report




   NOTE:

     a -Surveyor’s request for map+ROR view              MASTER STORE-includes: geometry
     b -View specified map+ROR                           data, personal data.
     c- Fake reports are stored                          FAKE REPORT STORE -includes  the
                                                         tabular information for mutation


                        Fig-2nd Level DFD for SURVEYOR




Dept. OF Computer Application, AEC                                                   NIC ,New Delhi
                                                                                                      32




                                  FAKE REPORT STORE



                             Parcel ID                Parameter

                                                                          Split Plots
                                           Approve                         Process
                        Request            Process
                                                            Mutation
    TEHSILDER                                               Approve        0.2.4.2
                                            0.2.4.1
                        Responds




                                                                         Splited Map Data
                                                                                 flow



                                           Splited
                                                                         MUTATION
                                           Map View           Mutated    STORE
                   Splited Map                                Map data
                   Request                  0.2.4.3

               Required result




          NOTE:

          FAKE REPORT STORE - includes    the tabular information for mutation.
          MUTATION STORE     – includes the geometry data, personal data.



                                    rd
                           Fig- 3        Level DFD for TEHSILDER



5.2 DATA DICTIONARY


 Dept. OF Computer Application, AEC                                                  NIC ,New Delhi
                                                                                              33

 Field Name                    Full Form         Description
 Distno                        Dietrict number   Unique code for identifying a particular
                                                 district
 Tehsilno                      Tehsil number     Unique code for identifying a particular
                                                 Tehsil
 Rino                          RI number         Unique code for identifying a particular RI.
 Halkano                       Halka number      Unique code for identifying a particular
                                                 Halka
 Villageno                     Village number    Unique code for identifying a particular
                                                 village
 khasrano                      Khasra number     Unique code for identifying a particular
                                                 Khasra
 Subkhasra1,Subkhasra2         Subkhasra         Part Of Khsra number
 ,Subkhasra3                   number
 Referenceno                   Reference number Unique code for identifying a particular ROR

 Distname                                        Name of district
 SubReference1,SubRefer                          Part of reference number.
 ence2,SubReference 3
 Pattedar                                        The person who have the patta.
 Encroachers                                     The Person who is occupying
 Owner                                           Owner name of The particular land
 KhasraArea                                      Total Area of the land
 Shamilkhasras
 Land Type                                       Code for identifying the type of the land
 Holding Type                                    Code for identifying the Holding type of the
                                                 land
 YearStartDate                                   Starting Date of the year
 YearEndDate                                     Ending date of The year
 Khasaramaster
 CareatedBy                                      Loding ID of the person who have created
                                                 the khasra.
 CreatedOn                                       Date and Time on which the khasra is
                                                 Created
 ModidifeOn                                      Date and time on which khasra is modified
 PostedOn                                        Posting date of the new data entry year
 Districtname                                    Name of the district
 Tehsilname                                      Name of the tehsil
 RIname                                          Name of the RI
 Halkaname                                       Name of Halka
 Villagename                                     Name of Village
 Sex                                             Informaion about sex of the land owner
 Father_Name                                     Father Name of the land owner
 Caste_Code                                      Unique code to identify caste of the land

Dept. OF Computer Application, AEC                                           NIC ,New Delhi
                                                                                 34
                                     owner
 Address                             Address of the land owner
 Caste_Name                          Name of the land owners caste
 Remarks                             Remarks of the owners caste
 Ownership_code                      Unique code for the own
 TaxPaidToOwner                      Amount of tax paid to owner
 Lessor_code                         Code of ledger,it is like a register
 Area_LeasedEncroached               Amount of leased area cncoached
 Lease_Amount                        Amount of which lease is given
 Lease_duration                      Duration of time for which lease is given
 Crop_Amount                         Amount of Crop
 Kua_kabza                           No of Kua
 Share                               Share of eachowner
 Sinchit                             Irrigation land
 Asinchit                            Unirrigated land
 Doublecrop
 Vrakshkunj                          No of trees in a particular land
 Van                                 No of forest
 Kawilkasht                          Land which can be cultivated
 Vivran                              Description
 ChaluPadti                          Land which are left unused
 Padti2to5                           Land which are left unused for 2-5 years
 PadtiGreaterThan5                   Land which are left unused for more than
                                     5 years
 ShudhBoya                           Irregated land
 Falodyan                            Garden of fruits
 Remarks                             Comments given by the tehsildar or ri
 Approval_status                     Approval or disapproval of the mutation
                                     notice.
 Owner                               Owner name of the particular land
 KhasraArea                          Total area of the land
 ShamilKhasras                       Description
 LandType                            Code for identifying the type of the land
 Holding Type                        Code for identifying the holding type of the
                                     land
 Khasraremarks                       Comment of khasra.
 Shamilkhasra                        Small plot integrated with a big plot or
                                     khasra
 Tenants                             Person using someone else’s land on rent
 Encroachers                         Person who have forced fully occupied
                                     someone else land
 Crop                                Name of the Crop cultivated in that area
 User_name                           Unique number given to a mutation
                                     application to identify it uniquely


Dept. OF Computer Application, AEC                              NIC ,New Delhi
                                                                                           35
 Subject_name                                  A unique field in the user certificate which
                                               contains user details.
 Last_login                                    Date and time of the last login by a user
                                               typing to login
 Login_time                                    Date and time of the login by a user typing
                                               to login
 Logout_time                                   Date and time of the logout by a user
                                               typing to login
 Mutationno                                    Unique number given to a mutation
                                               application
 Applicant                                     No of person who applied for the mutation
 Mut_type                      Mutation type   Type of mutation requested such as sell,
                                               partition etc.
 Reg_no                        Registration    Registration number of mutation
                               number
 Reg_amount                    Registration    Amount of money for mutation registration
                               amount
 Issuing authority
 Area                                          Area of a plot
 Perimeter                                     Perimeter of the plot
 Bhagora_Id                                    Unique Khasra number of a plot
 Code
 Geometry                                      Stores sdo_geometry data type objects
 Mutation status                               Describes a specified plot is mutated
 LagantoPay                                    Land for paying
 CesstoPay                                     Paying for cess
 Otherstopay                                   Paying for others
 Divtopay                                      Paying for division
 Comtopay                                      Paying for comment
 Nilambit                                      Not for paying
 ID                                            Unique number
 Surveyno                                      Unique suvey number against a plot
 GIS area                                      Area of mutated plot
 Stauts                                        Describes a specified plot is mutated or not
 Parentsurveyno                                Survey no after mutation
 loaddate                                      Date and time of mutation




Dept. OF Computer Application, AEC                                        NIC ,New Delhi
                                                                                36

          Start




        Read User
        Type




         If User
         Operator
                       Y        View Map with         Print
                                   ROR                Report



         N
                               Show Map With
                                  ROR
         If User
         Tehsilder     Y                            Print
                                                    Report
                               Mutation of Plots


             N
                                View Map with
                       Y
                                   ROR
         If User       Y
         Surveyor                                  Print
                                Generate Fake      Report
                                  Report
             N



        Stop



   5.3 Fig-Flow Chart



Dept. OF Computer Application, AEC                             NIC ,New Delhi
                                                                                             37


   6. WORKING ENVIRONMENT:

   Resources:

   6.1 Hardware Requirements:

   Processor : PC with a Pentium IV class Processor, 600 MHz
   Hard disk : 40 GB on the drive
   RAM         : 512 MB Minimum
   Operating System: LINUX (REDHAT)
   Video      : 800X 600 , 256 colors
   Recommended : High colors 16 bits

    6.2 Software Requirements:

   The Open Source System Software tools, as proposed by NIC Experts, will be used for
   development & implementation of the Application e.g.
   Platform: J2sdk 1.5
   Operating System: LINUX (REDHAT)
   IDE :ORACLE Jdeveloper 10g
   DBMS: ORACLE 10g
   Mail Client/Browser: Mozilla
   API- Map Viewer
   Tools-Map builder



   6.3 TECHONOLOGY USED:

   6.3.1 INTRODUCTION TO JSP

           JSP is a server-side technology for developing Web applications based on the
   Sun Framework. It is known as server side technology because the Server is entirely
   responsible for processing the dynamic portions of the page whereas the Client only
   sees the HTML, Java script, and CSS within the browser.


Dept. OF Computer Application, AEC                                          NIC ,New Delhi
                                                                                             38
   Features of JSP

      Better language support

      Programmable controls

      Event-driven programming

      XML-based components

      User authentication, with accounts and roles

      Higher scalability

      Increased performance - Compiled code

      Easier configuration and deployment


   6.3.2 WHY THIS TECHNOLOGY (Java Server Pages)

              A JSP page is a text document that contains two types of text: static data,
   which can be expressed in any text-based format (such as HTML, SVG, WML, and
   XML) and JSP elements, which construct dynamic content. The recommended file
   extension for the source file of a JSP page is .jsp. The page can be composed of a top
   file that includes other files that contain either a complete JSP page or a fragment of a
   JSP page.

   6.4 INTRODUCTION TO ORACLE SPATIAL 10g

   6.4.1 Oracle Spatial:

           Oracle Spatial, often referred to as spatial, provides a SQL schema and
   functions that facilitate the storage, retrieval, update, and query of collections of
   spatial features in an Oracle database. Spatial consists of the following components:
         A schema (MDSYS) that prescribes the storage, syntax, and semantics of
               supported geometric data types

         A spatial indexing mechanism

         A set of operators and functions for performing area-of-interest queries, spatial
               join queries, and other spatial analysis operations

Dept. OF Computer Application, AEC                                          NIC ,New Delhi
                                                                                              39
         Administrative utilities

            The spatial component of a spatial feature is the geometric representation of its
   shape in some coordinate space. This is referred to as its geometry

   6.4.2 Geometry Types

               A geometry is an ordered sequence of vertices that are connected by straight
   line segments or circular arcs. The semantics of the geometry are determined by its
   type. Spatial supports several primitive types, and geometries composed of collections
   of these types, including two-dimensional:

        ●   Points and point clusters

        ●   Line strings

        ●   n-point polygons

        ●   Arc line strings (All arcs are generated as circular arcs.)

        ●   Arc polygons

        ●   Compound polygons

        ●   Compound line strings

        ●   Circles

        ●   Optimized rectangles



   6.4.4 Spatial Operators

            Here I describes the operators that we can use when working with the spatial
   object data type. For an overview of spatial operators, including how they differ from
   spatial procedures and functions.




 Table: Main Spatial Operators




Dept. OF Computer Application, AEC                                           NIC ,New Delhi
                                                                                                           40
  Operator             Description

  SDO_FILTER           Specifies which geometries may interact with a given geometry.

  SDO_JOIN             Performs a spatial join based on one or more topological
                       relationships.

  SDO_NN               Determines the nearest neighbor geometries to a geometry.

  SDO_NN_DIST Returns the distance of an object returned by the SDO_NN
  ANCE                 operator.

  SDO_RELATE           Determines whether or not two geometries interact in a specified
                       way.

  SDO_WITHIN_ Determines if two geometries are within a specified distance from
  DISTANCE             one another.



   6.4.6 SDO_GTYPE

            The SDO_GTYPE attribute indicates the type of the geometry. Valid geometry
   types correspond to those specified in the Geometry Object Model for the OGIS Simple Features for SQL
   specification (with the exception of Surfaces). The numeric values differ from those
   given in the OGIS specification, but there is a direct correspondence between the
   names and semantics where applicable.

   The SDO_GTYPE value is 4 digits in the format dltt, where:

        ●   d identifies the number of dimensions (2, 3, or 4)

        ●   l identifies the linear referencing measure dimension for a three-dimensional
                linear referencing system (LRS) geometry, that is, which dimension (3 or 4)
                contains the measure value. For a non-LRS geometry, or to accept the
                Spatial default of the last dimension as the measure for an LRS geometry,
                specify 0. For information about the linear referencing system (LRS), tt
                identifies the geometry type (00 through 07, with 08 through 99 reserved for


Dept. OF Computer Application, AEC                                                       NIC ,New Delhi
                                                                                                        41
               future use).

           The bellow given table shows the valid SDO_GTYPE values. The Geometry
   Type and Description values reflect the OGIS specification.

   Table :Valid SDO_GTYPE Values
    Value Geometry Type              Description

    dl00    UNKNOWN_GEOM Spatial ignores this geometry.
            ETRY

    dl01    POINT                    Geometry contains one point.

    dl02    LINE or CURVE            Geometry contains one line string that can contain straight or
                                     circular arc segments, or both. (LINE and CURVE are
                                     synonymous in this context.)

    dl03    POLYGON                  Geometry contains one polygon with or without holes.

    dl04    COLLECTION               Geometry is a heterogeneous collection of elements.
                                     COLLECTION is a superset that includes all other types.

    dl05    MULTIPOINT               Geometry has one or more points. (MULTIPOINT is a superset of
                                     POINT.)

    dl06    MULTILINE or             Geometry has one or more line strings. (MULTILINE and
            MULTICURVE               MULTICURVE are synonymous in this context, and each is a
                                     superset of both LINE and CURVE.)

    dl07    MULTIPOLYGON             Geometry can have multiple, disjoint polygons (more than one
                                     exterior boundary). (MULTIPOLYGON is a superset of
                                     POLYGON.)




           The d in the Value column of this table the number of dimensions: 2, 3, or 4. For
   example, an SDO_GTYPE value of 2003 indicates a two-dimensional polygon.

   6.5 ORACLE MAPVIEWER:

Dept. OF Computer Application, AEC                                                     NIC ,New Delhi
                                                                                                 42
            When an application uses OracleAS MapViewer, it applies specific styles (such as
   colors and patterns) to specific themes (that is, collections of spatial features, such as
   cities, rivers, and highways) to render a map (such as a GIF image for display on a
   Web page). For example, the application might display a map in which state parks
   appear in green and restaurants are marked by red stars. A map typically has several
   themes representing political or physical entities, or both. For example, a map might
   show national and state boundaries, cities, mountain ranges, rivers, and historic sites.
   When the map is rendered, each theme represents a layer in the complete image.

             OracleAS MapViewer lets you define styles, themes, and base maps, including
   the rules for applying one or more styles to each theme. These styles, themes, base
   maps, and associated rules are stored in the database in map definition tables under
   the MDSYS schema, and they are visible to you through metadata views. All styles in
   a database instance are shared by all users.

   Some fundamental concepts include style, theme, base map, mapping metadata, and
   map.

        ●    Styles define rendering properties for features that are associated with styles.
                 For example, a text style determines how such a feature is labeled on a map,
                 while a line style determines the rendition of a linear feature such as a road.

        ●    A theme is a collection of features (entities with spatial and nonspatial
                 attributes) that are associated with styles through the use of styling rules.

        ●    A base map consists of one or more themes.

        ●    Mapping metadata consists of a repository of styles, themes, and base maps
                 stored in a database.

        ●    A map is one of the components that OracleAS MapViewer creates in response
                 to a map request. The map can be an image file, the object representation of
                 an image file, or a URL referring to an image file.

   6.6 JTS library




Dept. OF Computer Application, AEC                                              NIC ,New Delhi
                                                                                           43
           JTS (Java Topology Suite) provides an implementation of the spatial data model
   defined in the OGC Simple Features Specification for SQL (SFS); a complete,
   consistent, implementation of fundamental 2D spatial algorithms including binary
   predicates (such as touch and overlap) and spatial analysis methods (such as
   intersection and buffer); an explicit precision model, with algorithms that gracefully
   handle situations that result in dimensional collapse; robust implementations of key
   computational geometric operations; and, I/O in Well-Known Text format


       The JTS Topology Suite is an API of 2D spatial predicates and functions. It has
   the following design goals:

          JTS conforms to the Simple Features Specification for SQL published by the
           Open GIS Consortium
          JTS provides a complete, consistent, robust implementation of fundamental 2D
           spatial algorithms
          JTS is fast enough for production use
          JTS is written in 100% pure Java
          JTS is open source




                              ********* *********




Dept. OF Computer Application, AEC                                        NIC ,New Delhi
                                                      44




              SYSTEM DESIGN




Dept. OF Computer Application, AEC   NIC ,New Delhi
                                                                                              45
   7. INTRODUCTION

          Design is critical component of software development life cycle. It is a meaningful
   representation of the system to be built and can be traced to the customer
   requirements. Absence of proper design is bound to lead to confusion and errors. A
   complete design must accommodate all of the implicit requirements desired by the
   customer. It must be a readable, understandable guide for programmers. It should
   provide a complete picture of the software addressing the data, functional, and
   behavioral domains from an implementation perspective.
              System design goes through two phases of development-
                            Logical Design and
                            Physical Design


                 Logical design review the present physical system; prepare input and
   output specification; make edit security ,and control specification; detail the
   implementation plan ,and prepare a logical design walkthrough. The physical design
   maps out details of physical system plan, the system implementation, device a test and
   implementation plan, and specify any new hardware and software.


    7.1   LOGICAL DESIGN:


              A Data flow diagram shows the logical flow of system and defines the
       boundaries of the system. Logical design specify the user specify the user needs a
       level of detail that virtually determines the information flow into and out of the
       system and required data resources. Logical design describes the,outputs,databases
       and procedures. All in a format that meets user requirements.




Dept. OF Computer Application, AEC                                           NIC ,New Delhi
                                                                                            46
    7.2    PHYSICAL DESIGN:
             The physical design produces the working system by defining the system
       specification that tells the programmers exactly what the candidate system must
       do. The physical design consist of the following steps:


          1. Design of the physical system and Logical system.
               * Design of the physical system
               * Specify input/output media
               * Design physical information flow through the system and physical design
                    walkthrough.
          2. plan system implementation
               * Prepare a conversion schedule and target date.
              * Determine the training procedure,courses and timetable.
           3.Devise a test and implementation plan and specify any new hardware and
       software.
    7.3     STRUCTURED DESIGN:


              Structured design is flow methodolgy.It is an attempt to minimized the
       complexity and makes a problem manageable by subdividing it into smaller
       segments or module. Structured design with system specification that identify
       input and outputs describe the functional aspects the system.
       Design of project consists of number of steps. The design of the modules consists of
       the following steps:


              * DATABASE DESIGN
              * INPUT DESIGN
              * OUTPUT DESIGN




Dept. OF Computer Application, AEC                                         NIC ,New Delhi
                                                                                                  47
    7.4    DATABASE DESIGN:
                The design of database describes how data should be organized around the
       user requirements. I should be organized around the user requirements. It should
       be designed in the line with the activity and volatility of the information and the
       nature of the stored media and devices.
       One of the important steps in designing the database is normalization. This
       technique logically groups the data over the number of tables, which are
       independent and contain no unnecessary or redundant data.


   7.4.1 E-R DIAGRAM:
               All the attributes used in the entity sets are describe bellow:


    Attributes of Authorized official:


    Name, address, organization, department, designation, certificate, user_code


   Attribute of ROR:


   Distno,tehsilno,RIno,Halkano,villageno,distname,tehsilname,Riname,villagename,refe
   rence,subreferance,khasraarea,owner,shimalkhasra,tenant,irriarea,doublecrop,chalup
   adti,padti2to5,luhpadthigraterthan5,crop,falodyan,vrakharopan,Bagisa,liremarks1,lue
   ramarks2,sinchit,Ashinsit,charagan,vrakskunja,van,YarstartDate,yearEnDate,patttad
   ar,Encroacher,landtype,holdingtype,kua_kabja,name,fathersname,share,createdby,cra
   tedon,modifiedby,modifiedon.


   Attribute of Mutation:
          Surveyno, Mutationno, Geom, status, load_date, Area, Perimeter, Bhagora, code,
   Geometry, mutationstatus, ID, Gisarea, parentsurveyno.




Dept. OF Computer Application, AEC                                               NIC ,New Delhi
   7.4.1 ER Diagram:                                                                                  48


                                                              khasrano              Samilkhasra

                    Authorized                   Generates
                     Official                                            ROR



                                                 Mutation
                                                                           Uses
                      Is A
                                                       Mutation No                      khasrsno

                                                                         Parcel
          Operator            Surveyer


                 Tehsilder
                                                                           Has


                                                                                       Villageno

                                                                         Village

                                                                                        VillageName



       Districtno                 DistrictName                             Has

                                                                                         Haskano
                      District
                                                                          Halka

                                                                                        HalkaName

                       Has
                                                                           Has


                                                                                       RIno
     Tehsilno

                                                    Has                        RI
                     Tehsil
                                                                                        RIName
   TehsilName



Dept. OF Computer Application, AEC                                                  NIC ,New Delhi
                                                                                         49
   Attribute Of parcel:
   Distno,Tehsilno,Rino,Halkano,Villageno,RptKay,Mkhasra,ahamilkhasra,Khasraarea,o
   wner,tenent,Encroachers,Tax1,tax,Crop,Crop_en,Irriarea,irrarea_en,unirriarea,double
   crop,chalupadti,padti2to5,padti2,soil,Luh,lugh,Ownertype,season,userId,landtype,vilm
   ukta,irrSource,RabiYear,kharifyear,Startyear,Enddate,RptKeyrefno.


   Attribute Of village:
   Distno,tehsilno,RIno,Halkano,Villageno,villagename,patelname,Createdby,Createdon,
   modifiedBy,modifiedOn.


   Attribute of Halka:
   Distno,tehsilno,RIno,Halksno,Halkaname,Createdby,CreatedOn,ModifiedBy,Modified
   On.


   Attribute of RI:
       Distno,tehsilno,RIno,Riname,CreatedBy,CreatedOn,ModifiedBy,ModifiedOn


   Attribute of Tehsil:
         Distno,Tehsilno,Tehsilname,CreatedOn,CreatedBy,ModifiedBy,ModifiedOn.


   Attribute of District:
          Distno ,Distname ,CreatedOn, CreatedBy ,ModifiedBy ,ModifiedOn.




Dept. OF Computer Application, AEC                                      NIC ,New Delhi
                                                                                              50
   7.5. Normalization:
             Normalization is an important steps in database designing –a process of
   breaking down a complex designing in to a group of simple relations.Normalisation is
   importance for adapting a real life situation, something that will fit effectively into a
   relational database.


   7.5.1 The Advantage of normalization are:
   ->Database is easier to maintain
   ->Database can be expanded with minimum effort
   ->Dose not include more duplicated data than necessary
   ->Minimizes inconsistency in the database
   ->minimizes the effect of duplicate and delete anomalies


   7.5.2 The various normal forms are as follows:
   1NF: A relation R is in 1NF iff it contains atomic values
    2NF: A relation R is in 2NF iff it is in the 1NF and every non key attribute is fully
           dependent on the primary key.
    3NF: A relation R is in 3NF iff it is in 2NF and every non-key attribute is
   no transitively dependent on the primary key.


   BCNF: A relation R is in BCNF iff every determinant is a candidate key.


   4NF: A relation r in 4NF iff,whenever there exists a multivalued dependency(MVD) in
   the R,say A->->B,and then all other attribute of R are also functionally dependent on
   A.


   5NF: A relation R is in 5NF iff every join dependency in R is implied by the candidate
   keys of R.


   Here the tables that I have used are in 3NF


Dept. OF Computer Application, AEC                                           NIC ,New Delhi
                                                                                 51
   7.6 Table Design:
              The Tables Used Are Shown Below

    1. DISTMASTER:


      FIELD NAME                     DATA TYPE          WIDTH
    DISTNO                           VARCHAR2           2
    DISTNAME                         VARCHAR2           50
    CREATEDBY                        VARCHAR2           15
    CREATEDON                        DATETIME           8
    MODIFYBY                         VARCHAR2           15
    MODIFYON                         DATETIME           8


                  :
  PRIMARY KEY DISTNO


   2. TEHSILMASTER:


      FIELD NAME                      DATA TYPES        WIDTH
    DISTNO                           VARCHAR2           2
    TEHSILNO                         VARCHAR2           2
    TEHSILNAME                       VARCHAR2           50
    CREATEDBY                        VARCHAR2           15
    CREATEDON                        DATETIME           8
    MODIFYBY                         VARCHAR2           15
    MODIFIEDON                       DATETIME           8

   PRIMARY KEY: DISTNO, TEHSILNO
   3. RIMASTER:

    FIELD NAME                       DATA TYPES    WIDTH
    DISTNO                           VARCHAR2      2
    TEHSILNO                         VARCHAR2      2
    RINO                             VARCHAR2      2
    RINAME                           VARCHAR2      50
    CREATEDBY                        VARCHAR2      15
    CREATEDON                        DATETIME      8
    MODIFIEDBY                       VARCHAR2      15
    MODIFIEDON                       DATETIME      8


                      :
    PRIMARY KEY DISTNO, TEHSILNO, RINO.


   4. HALKAMASTER:



Dept. OF Computer Application, AEC                              NIC ,New Delhi
                                                                              52
    FIELD NAME                       DATA TYPE       WIDTH
    DISTNO                           VARCHAR2        2
    TEHSILNO                         VARCHAR2        2
    RINO                             VARCHAR2        2
    HALKANO                          VARCHAR2        2
    HALKANAME                        VARCHAR2        50
    CREATEDBY                        VARCHAR2        15
    CREATEDON                        DATETIME        8
    MODIFIEDBY                       VARCHAR2        15
    MODIFIEDON                       DATETIME        8



                  :
  PRIMARY KEY DISTNO, TEHSILNO, RINO,HALKANO
 5. VILLAGEMASTER:

    FIELD NAME                       DATATYPE        WIDTH
    DISTNO                           VARCHAR2        2
    TEHSILNO                         VARCHAR2        2
    RINO                             VARCHAR2        2
    HALKANO                          VARCHAR2        2
    VILLAGENO                        VARCHAR2        20
    VILLAGENAME                      VARCHAR2        50
    PATEL NAME                       VARCHAR2        50
    CREATEDBY                        VARCHAR2        15
    CREATEDON                        DATETIME        8
    MODIFIEDBY                       VARCHAR2        15
    MODIFIEDON                       DATETIME        8
                  :
  PRIMARY KEY DISTNO, TEHSILNO, RINO, HALKANO VILLAGENO

 6 GEOM_TABLE:

  FIELD NAME                          DATATYPE       WIDTH
  AREA                               NUMBER          38
  PERIMETER                          NUMBER          38
  BHAGORA                            NUMBER          38
  BHAGORA_ID                         VARCHAR2        20
  CODE                               VARCHAR2        40
  GEOMETRY                           SDO_GEOMETRY
  MUTATIONSTATUS                                     2

                  :
  PRIMARY KEY BHAGORA_ID


 7. MUTATION_LINE:




Dept. OF Computer Application, AEC                           NIC ,New Delhi
                                                                                      53
  FIELD NAME                          DATA TYPE         WIDTH

  SURVEYNO                           VARCHAR2           20
  MUTATIONNO                         VARCHAR2           20
  GEOM                               SDO_GEOMETRY
  STATUS                             NUMBER             10
  LOAD_DATE                          DATE               20

 PRIMARY KEY: SURVEYNO,MUTATIONNO




8. GEOM_TRANSACTION_TABLE:


  FIELD NAME                           DATA TYPE    CON WIDTH
  ID                                 NUMBER            2
  SURVERNO                           VARCHAR2          20
  GEOMETRY                           SDO_GEOMETRY
  GISAREA                            NUMBER            20
  STATUS                             NUMBER            20
  PARENT SURVEYNO                    VARCHAR2          20
  MUTATIONSTATUS                     VARCHAR2          2

                   :
 PRIAMARY KEY ID , SURVEYNO


   9. TABLE NAME: KHASRA-MASTER


    FIELD NAME                        DATA TYPE              WIDTH
   Distno                            Varchar2                2
   Tehsilno                          Varchar2                2
   Rino                              Varchar2                2
   Halkano                           Varchar2                5
   Villageno                         Varchar2                3
   Khasrano                          Varchar2                5
   Subkhasra1                        Varchar2                4
   Subkhasra2                        Varchar2                4
   Subkhasra3                        Varchar2                50



Dept. OF Computer Application, AEC                                   NIC ,New Delhi
                                                                                         54
   Referenceno                       Varchar2              5
   SubReference1                     Varchar2              4
   SubReference2                     Varchar2              4
   SubReference3                     Varchar2              50
   Pattadar                          Char                  1
   Encroachers                       Char                  1
   Owner                             Char                  1
   KhasraArea                        Numeric               9
   ShamilKhasra                      Varchar2              700
   LandType                          Numeric               9
   HoldingType                       Numric                9
   YearStartDate                     Datetime              8
   YearEndDate                       Datetime              8
   Khasraremarks                     Varchar               4000
   CreatedBy                         Varchar               15
   CreatedOn                         DateTime              8
   ModifiedBy                        Varchar               15
   ModifiedOn                        DateTime              8
   PostedBy                          Varchar               15
   PostedOn                          Datetime              8
   Remflag                           Char                  1


   PRIMARYKEY: Distno, Tehsilno, Rino, Halkano, Villageno, Khasrano, Subkhasra1,
   Subkhasra2, Subkhasra3, Referenceno, SubReference1, SubReference2,
   SubReference3.


   10. TABLE NAME: PERSON_DETALIS


   FIELD NAME                        DATA TYPE             WIDTH
   RowID                             Numeric               9


Dept. OF Computer Application, AEC                                      NIC ,New Delhi
                                                                       55
   Distno                            Varchar2   2
   Tehsilno                          Varchar2   2
   Rino                              Varchar2   2
   Halkano                           Varchar2   5
   Villageno                         Varchar2   3
   Khasrano                          Varchar2   5
   Subkhasra1                        Varchar2   4
   Subkhasra2                        Varchar2   4
   Subkhasra3                        Varchar2   50
   Type                              Char       1
   Sex                               Varchar    50
   Name                              Numeric    9
   Name1                             Varchar    150
   FatherName                        Varchar    50
   FatherName1                       Varchar    150
   Address                           Varchar    50
   CasteCode                         Numeric    150
   CasteName                         Varchar    50
   Remarks                           Varchar    50

   OwnershipCode                     Numeric    9
   TaxpaidToOwner                    Numeric    25
   Lessorcode                        Numeric    100
   Area Leasedencroached             Numeric    9
   LeaseAmount                       Numeric    9
   LeaseDuration                     Numeric    9
   CropAmount                        Numeric    9
   Kuakabza                          Numeric    9
   CreatedBy                         Varchar    9
   CreatedOn                         Datetime   9



Dept. OF Computer Application, AEC                    NIC ,New Delhi
                                                                                     56
   ModifiedBy                        Varcar               9
   ModifiedOn                        Datetime             15
   YearStartDate                     Datetime             8
   YearEndDate                       Datetime             8
   Share                             Varchar              15


   PRIMARY KEY:, RowID
   Distno,Tehsilno,Rino,Halkano,Villageno,Khasrsno,SubKhasra1,SubKhasra2,
   subkhasrs3.


   11. TABLE NAME: LAND_UTILIZATION_HEADER


   FIELD                             DATA TYPE           WIDTH
   Distno                            Varchar
   Tehsilno                          Varchar
   Rino                              Varchar
   Halkano                           Varchar
   Villageno                         Varchar
   Khasrano                          Varchar
   Subkhasra1                        Varchar
   Subkhasra2                        Varchar
   Subkhasra3                        Varchar
   YearStartDate                     Datetime
   Sinchit                           Datetime
   Asinchit                          Numeric
   DoubleCrop                        Numeric
   Charagh                           Numeric
   Vrakshkuni                        Numeric
   Van                               Numeric
   Kawilkasht                        Numeric


Dept. OF Computer Application, AEC                                  NIC ,New Delhi
                                                                                    57
   Vivran                            Varchar
   ChaluPadti                        Numeric
   Padti2to5                         Numeric
   Padti2to5YRNo                     Smallint
   PadtiGreaterThan5                 Numeric
   Others                            Numeric
   ShudhBoya                         Numeric
   Falodyan                          Numeric
   Vrakshoropan                      Numeric
   Bagicha                           Numeric
   LuRemarks1                        Varchar
   LuRemarks2                        Varchar
   CreatedBy                         Varchar
   CreatedOn                         Datetime
   ModifiedBy                        Varchar
   ModifiedOn                        Datetime


   PRIMARY KEY:
   Distno,Tehsilno,Rino,Halkano,Villageno,Khasrano,SubKhasra1,SubKhasra2,Subkhasr
   a3,YearStartdate,YearEndDate.
   12. TABLE NAME: SEASONAL_UTILISATION_MASTER


   FIELD NAME                        DATA TYPE          WIDTH
   Distno
   Tehsilno
   Rino
   Halkano
   Villageno
   Khasrano
   Subkhasra1


Dept. OF Computer Application, AEC                                 NIC ,New Delhi
                                                                                    58
   Subkhasra2
   Subkhasra3
   YearStartDate
   YearEndDate
   Season
   GroupId
   SinchitArea
   AsinchitArea
   DoubleCrop
   sourceOflrrigation
   SownBy
   CreatedBy
   CreatedOn
   ModifiedBy
   ModifiedOn


   PRIMARY KEY:
   Distno,Tehsilno,Rino,Halkano,Villageno,khasrano,SubKhasra1,Subkhasra2,Subkhasr
   a3,YearSatartDate,YearEndDate,Season,roupId.




   13. TABLE NAME: MIN_NO


   FIELD NAME                        DATA TYPE          WIDTH
   Code                              Char               4
   Cdname                            Char               30


   PRIMARY KEY: Code




Dept. OF Computer Application, AEC                                 NIC ,New Delhi
                                                                          59
   14. TABLE NAME: TAX


   FIELD NAME                        DATA TYPE   WIDTH
   Distno
   Tehsilno
   Rino
   Halkano
   Villageno
   Khasrano
   Subkhasra1
   Subkhasra2
   Subkhasra3
   yearStartDate
   YearEndDate
   LaganToPay
   CessToPay
   OthersTopay
   DivTopay
   ComToPay
   LaganPaidInst1
   CesspaidInst1
   OtherspaidInt1
   DivPaidint1
   ComPaidInst2
   OthersPaidInst2
   Nilambit
   Vilmukta
   Remarks
   CreatedBy
   CreatedOn


Dept. OF Computer Application, AEC                       NIC ,New Delhi
                                                                                    60
   ModifiedBy
   ModifiedOn


   PRIMARY KEY:
   Distno,Tehsilno,Rino,Halkano,Villageno,Khasrano,Subkhasra1,Subkhasra2,Subkhasr
   a3,YearStartDate,YearEndDate.


   15. TABLE NAME: SOIL


   FIELD NAME                        DATA TYPE          WIDTH
   Distno
   Tehsilno
   Rino
   Halkano
   Villageno
   Khasrano
   Subkhasra1
   Subkhasra2
   Subkhasra3
   SoilCode
   YearStartdate
   YearEndDate




   PRIMARY KEY:
   Distno,Tehsilno,Rino,Halkano,Villageno,Khasrano,Subkhasra1,Subkhasra2,Subkhasr
   a3,SoilCode,YearStartDate,YearEndDate


   16. TABLE NAME:TREES




Dept. OF Computer Application, AEC                                 NIC ,New Delhi
                                                                                    61
   FIELD NAME                        DATA TYPE          WIDTH
   Distno
   Tehsilno
   Rino
   Halkano
   Villageno
   Khasrano
   Subkhasra1
   Subkhasra2
   Subkhasra3
   TreeCode
   TreeCount
   YearStartdate
   YearEndDate
   CreatedBy
   CreatedOn
   ModifiedBy
   ModifiedOn


   PRIMARY KEY:
   Distno,Tehsilno,Rino,Halkano,Villageno,Khasrano,Subkhasra1,Subkhasra2,Subkhasr
   a3,TreeCode,YearStartDate,YearEndDate.


   17. TABLE NAME:LR_CODE_MASTER:


   FIELD NAME                        DATA TYPE          WIDTH
   ID                                Numeric            9
   Type                              Varchar            60
   Code                              Varchar            4
   Description                       Varchar            60


Dept. OF Computer Application, AEC                                 NIC ,New Delhi
                                                                                     62
   Mapcode                           Varchar            50
   Active                            Char               1
   CreatedBy                         Varchar            15
   CreatedOn                         Datetime           8
   ModifiedBy                        Varchar            15
   ModifiedOn                        Datetime           8


   PRIMARY KEY: ID
   18. TABLE NAME: SEASONAL-CROP_DETAIL


   FIELD NAME                        DATA TYPE          WIDTH
   Distno                            Varchar            2
   Tehsilno                          Varchar            2
   Rino                              Varchar            2
   Halkano                           Varchar            5
   Villageno                         Varchar            3
   Khasrano                          Varchar            5
   Subkhasra1                        Varchar            4
   Subkhasra2                        Varchar            4
   Subkhasra3                        Varchar            50
   YearStartDate                     DateTime           8
   YearEndDate                       Datetime           8
   Season                            Int                4
   GroupID                           Numeric            9
   CropCode                          Numeric            9
   SeqNo                             Numeric            4


   PRIMARY KEY:
   Distno,Tehsilno,Rino,Halkano,Villageno,Khasrano,Subkhasra1,Subkhasra2,Subkhasr
   a3,TreeCode,YearStartDate,YearEndDate,Season,GroupId,CropCode.


Dept. OF Computer Application, AEC                                  NIC ,New Delhi
                                                                          63




   19. TABLE NAME: RPT_KHASRA


   FIELD NAME                        DATA TYPE   WIDTH
   Distno                            Varchar     2
   Tehsilno                          Varchar     2
   Rino                              Varchar     2
   Halkano                           Varchar     5
   Villageno                         Varchar     3
   RptKey                            Varchar     150
   Mkhasra                           Varchar     125
   Mrefno                            Varchar     125
   Khasrsno                          Varchar     125
   Shamilkhasra                      Varchar     800
   Khasrsarea                        Numeric     9
   Owners                            Text        16
   Tenants                           Text        16
   Encroachers                       Varchar     16
   Tax1                              Varchar     150
   Tax                               Varchar     150
   Crop                              Varchar     1000
   Crop en                           Varchar     1000
   IrriArea                          Varchar     1000
   Irriarea en                       Varchar     1000
   UnirriArea                        Varchar     25
   DoubleCrop                        Varchar     25
   ChaluPadti                        Numeric     9
   Padti2to5                         Numeric     9
   Padti2to5No                       Int         4


Dept. OF Computer Application, AEC                       NIC ,New Delhi
                                                                                     64
   Padti5                            Numeric            9
   Soil                              Varchar            500
   LUH                               Varchar            500
   LUHG                              Varchar            500
   OwnerType                         Char               1
   Season                            Tinyint            1
   UserID                            Varchar            15
   LandType                          Numeric            9
   Remarks                           Varchar            550
   Vilmukta                          Varchar            50
   IrrSource                         Varchar            500
   RabiYear                          Varchar            4
   KharifYear                        Varchar            4
   Startyear                         Varchar            4
   Enddate                           Varchar            4
   RptKeyrefno                       Varchar            150
   Varchar                           Image              16
   Varchar                           Varchar            50




   PRIMARY KEY:
   Distno,Tehsilno,Rino,Halkano,Villageno,mKhasra,mKhasra,YearStartDate,
   YearEndDate.




Dept. OF Computer Application, AEC                                  NIC ,New Delhi
                                                                                           65
   20. TABLE NAME: USER_DETAIL


   FIELD NAME                        DATA TYPE                 WIDTH
   User_name                         Varchar                   20
   Address                           Varchar                   50
   Department                        Varchar                   50
   Designation                       Varchar                   25
   Register date                     Datetime                  8
   Certificate                       Varchar                   50
   Usercode                          Varchar                   20


   PRIMARY KEY : user_name, usercode




   8 .INPUT AND OUTPUT DESIGN:
             The input and output design is crucial part of any system design. often
   inaccurate input data are result of error caused by bad input design. Data entry errors
   can be controlled by a good input design. Input design is the process of converting
   user-oriented input to a computer based format. The goal of design input data is to
   make data entry as an easy, logical and free from error as possible.
          The input and output design of my project modules consist of designing the
   various input and output forms using JSP tags,HTML tages.Keeping in view to the




Dept. OF Computer Application, AEC                                        NIC ,New Delhi
                                                                                           66
   user requirement the input the input forms are designed and developed for easy and
   error free data entry.
            The Different input and output forms for “Intregation of Cadastral Maping
   Using Oracle 10g “ are as follow.




          Login form for all the types of user. Here User can Gives his/her user name and
   password. The login name are unique. after successful login user go to next page
   otherwise he gets message..




Dept. OF Computer Application, AEC                                        NIC ,New Delhi
                                                                                           67




          This Input form used by the user to see the ROR attribute with Map. After
   submition of this form user can see the ROR attribute along with the specified map.




Dept. OF Computer Application, AEC                                        NIC ,New Delhi
                                                                                   68




             This Output form display the Record of Right(ROR) with the map.




Dept. OF Computer Application, AEC                                NIC ,New Delhi
                                                                                               69
              This is the form used by the tehsilder to mutate the plot. All this input
   information is collected form the owner.




Dept. OF Computer Application, AEC                                            NIC ,New Delhi
                                                                                            70




            After Submited the previous form .User can give the input co-ordinate for
     splitting the plot using this Input Form.




            The out puts of the mutated plots are shown in this form.




Dept. OF Computer Application, AEC                                         NIC ,New Delhi
                                                                                              71


    11 CONCLUSION:


                  “Integration Of Cadastral Mapping using oracle spatial 10g” is a
   nice approach through which we can achieve the target of excellence. Though there are
   some limitations due to which proposed system could not attain all the objectives we
   had set. But overall system will be very helpful in order to provide a quality service
   efficiently and effectively. I have tried to fulfill almost all the requirements. There
   might be some limitations and those are due to time and cost constraint. Future
   enhancement of the project will be happen on and off.




   11.1 SCOPE FOR FUTURE WORK


             We have coded the system using object-oriented approach. Through this
   project, the Administrator (NIC) will manage growth of this Project. He can know the
   details of request, which has been done by people for getting ROR. It will also show
   the details of every plot and where it is occurred. Through this software when we enter
   the data it will be stored. Mutation is presently carried out by joining of any well
   defined corner points. Where as the field requirement may demand for putting a line
   at a specified distance from a known well demark able and visible point. For that
   purpose the JTS libraries function like get Length(), get Distance () etc. are use.




                            ************     *************




Dept. OF Computer Application, AEC                                           NIC ,New Delhi
                                                                                             72




                                     BIBLIOGRAPHY



       1. “System Analysis And Design”
                               -Awad M Elias.

       2. “Software Engineering”
                              -Rajib Mall

       3. “Software Engineering - A Practitioner’s Approach”
                             -Roger S.Pressman.

       4. “The Complete Reference –JAVA”
                             -Herbert Schiledt.

       5. “Teach yourself JSP in 21 days” – SAMS

       6. “Beginning Database Design”
                              - Gavin Powell



       Web Site:
       1.   http ://www.oracle.com/technology/products/mapviewer/pdf/mapviewer_904_ug.pdf.

       2.   http://www.vividsolutions.com/jts/jtshome.htm.

       3.   http://www.oracle.com-for all types of help is oracle




                              ***********END**************


Dept. OF Computer Application, AEC                                          NIC ,New Delhi
                                                      73




Dept. OF Computer Application, AEC   NIC ,New Delhi

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:29
posted:4/13/2011
language:English
pages:73