Urban Planning and Information System is a Web-GIS based application system that amalgamates MapInfo’s MapXtreme server, Oracle8i database server and Microsoft Internet technologies like Active Server Pages (ASP) and Component Object Model (COM). This system shows the spatial and attribute data of map layers. The map features are stored in the MapXtreme server as layers or geosets. These layers are used with the database attributes for visual display of information that is required for urban planning and information system. The system requires Microsoft Internet Information Server (IIS 4.0) Web server to host the system and available to the users via web browser (Fig.1). The core constituents of this design are as follows.
ASP Files: These are the Active Server Page files, which contain the presentation logic. VBScript was used for server-side scripting because it is simple, easily maintainable and integrates well with the other Microsoft technologies. Client-side scripting was done using JavaScript because it is a browser-independent scripting language & hence is best suited for client-side scripting.
COM Component: The COM is a DLL written in VB programming language that contains routines to insert, retrieve, delete and modify data into Oraccle8i database. The ASP files use these routines to insert, retrieve, delete and modify the database. The DLL handles multiple transactions to optimize data retrieval.
HTML & CSS File: The HTML file was the basic skeleton of the entire web site. This language was used as this is a static language and it has all the components for the presentation of the Web site. The CSS (Cascading Style Sheets) are files those were used to improve and optimize the presentation logic and coding. The various attributes of any object in the HTML is grouped and defined in the style sheet.
GIF File: The GIF files contain the raster images of the maps after converting from vectors. Since GIF files are lighter they are the part of presentation to display the map features. The maps are actually in a vector format (tab files) and are converted to the GIF format by the interfacing layer of MapX (mapping OCX).
The web-GIS based urban planning and information system consists of 2 subsystems PUPIS and DPIS. These subsystems have very much similar architecture and process flow. However, their functionalities are different. PUPIS is useful for utility functionalities like water supply, sewerage operation and electricity networks whereas DPIS is useful for town planning and related departmental activities. Both the subsystems, however, look like a single system from user perspective. The process flow of PUPIS and DPIS are described in Fig.2 and Fig. 3 respectively.
PUPIS (Public Utility Planning and Information System)
DPIS (Development Planning and Information System)
System Configuration
Urban Planning and Information system requires the following minimum configurations.
Hardware and Software Requirements
- NT Server, 512 MB RAM, 40 GB HDD
- Pentium II workstation (Client Side Browser)
- IIS Web Server
- Database Server
- Application Server
- Mapping Server
- Network (Intranet/ Internet)
System Specific Software Requirements
- HTTP Web Server - Microsoft Internet Information Server (IIS) 4.0
- Application Server - Microsoft Transaction Server (MTS) 2.0
- ADO/OLEDB - Microsoft Data Access Component (MDAC) 2.0 SP1
- Map Database – MapInfo 5.0 or above
- Mapping Server – MapXtreme (NT) 2.0 or above
- Database Server – Oracle8i
- Web Browser - Microsoft Internet Explorer
4.0+
System Benefits
Through this system, users will be able to query and locate plots, roads, subdivisions, layout, encroached land, mosquito breeding place, water and sewerage pipelines, electric poles and other geographic features of interest, as well as view information about them, and create maps on-screen or to print. You can turn map layers “on” or “off,” depending upon your needs. Also, some of these layers are scale-dependent and can only be viewed when you are zoomed in far enough. The functional and technical benefits are as follows.
Functional
- Improve management of resources
- Interdepartmental information sharing and communication
- Better planning of public utilities services and Town Planning
- View and presentation of information (visualization of municipal assets geographically)
- Geographic database (GDB) creation and maintenance (digital, continuous and scale free cartographic GIS database)
- Perform spatial queries, spatial modeling and analysis like where are all suitable sites to build new schools, buildings, shopping malls etc.
- Tools to query, analyze, and map data in support of the decision making process
- Planning & Management of Utility and Town Planning Database
- Ease in Maintenance and better monitoring of municipal resources
- On-line Decision-Making
- Knowing where-is-what Information (Click before you dig)
- Use of color- coded thematic maps for better understanding
- Generation of maintenance and query based
analytical reports