Installation instructions
Oracle, mapviewer and geospatial data
- Download Oracle and mapviewerFrom www.oracle.com
- The database software: Oracle10g rel2 Standard Edition 10.2.0.10 for Microsoft Windows'A' ena-7
- The Application Server mapviewer: mapviewer 10.1.2.0.2 kit and Quickstart
- Install the Oracle software and create the database
- Double click onSetup
- Login to DB: Installed in C:/Oracle/product/10.2.0/mapdb
(DB installed on machine with static IP preferably)
- LoginSysAnd conectSysdba
- Name:Mapdb(This is the SID)
- Passwd :???
- Create a DB
- Administration Tab
- Tablespaces Link
- Create button
- Object: maptablespace (name the tablespace)
- Add button
- Mapdata (file on disk. Created !)
- Reuse same file 4G
- Automatic extend 500 mb
- Create a user in dB mapsdb
- Under "users & privileges" select:
- Users [LINK]-> mapuser (<-this is the user name)
- Pass L
- Default tablespace: maptablespace (from above !)
- Temporary tablespace: temp
- Roles Link
- Edit List link
- Move "dba" to the right (this user is dBA)
- Connecting to Oracle:
- Admin user name: SYS
- Connect as sysdba
- To login to admin ORACLE: http: // localhost: 1158/EM Username: SYS, password :???, Connect as: sysdba
- To login to mapsdb (our DB) http: // localhost: 1158/EM Username: mapuser, password: l, connect as: normal
- The following I don't use:
- The iSQL * Plus URL is: http: // localhost: 5560/isqlplus
- The iSQL x plus dba url is: http: // localhost: 5560/isqlplus/DBA
- Mapviewer Installation
- Unzip mapviewer Qs(Read readme file !! And fix the start. BAT)
- It is installed!
- To start mapviewer executeStart. batIn the directory where unziped
- To login to mapviewer:Http: // localhost: 8888
- To create a password in mapviewer, read its readme file
- Configure mapviewer to use the right dB all the time.
- Edit the config file in mapviewer_installation/productname/J2EE/home/applications/mapviewer/web/WEB-INF/Conf
- Near the end of the file (see the tags there) place the following:
Note: Map_data_sourceIs the name that your app and mapviewer use to refer to the DB
Another note:In the passwd field place!So that mapviewer will encrypt the passwd next time mapviewer comes up.
Another note:Below the map_data_source is simply a name such as my_datasource.
<map_data_source name="maptablespace" jdbc_host="localhost" jdbc_sid="mapdb" jdbc_port="1521" jdbc_user="mapuser" jdbc_password="!l" jdbc_mode="thin" number_of_mappers="3" />
|
- Import Data
Some additional notes from Farshad
- Esri.com search for census 200 tuger (Census)
The exacl URL where we downloaded the files is:Http://arcdata.esri.com/data/tiger2000/tiger_download.cfm
- Use second pull down menu to select and download (Georgia ).
- Count 2000
- Line Features-roads
- Water polygons
- See CD for some of the files we have.
- Java User applications ** and ** importer Java program need the following jars:
- From:/productname/J2EE/home/applications/mapviewer/web/WEB-INF/lib
Mvclient. Jar(Size 134 K)
- From: C:/Oracle/product/10.2.0/db_1/MD/lib
Sdoapi. Jar(Size 14 K)
- You need a patched sdoutl. Jar. To get this go:
- Http://www.oracle.com/technology/software/products/spatial/index.html
- Dounload the Java kit for the "Oracle Java shapefile converter"
- In this page there is also a ReadMe file.
- The kit contains the patchedSdoutl. JarThat you need:
- Use to compile/execute your app
- Use to compile/execute the converter.
- It also contains a sample converter file to convert Shape files (from ESRI) into spatial files (Oracle format ).
- From: C:/Oracle/product/10.2.0/db_1/jdbc/lib (where I installed Oracle)
Ojdbc14.jar(Size 1501 K)
- Create indexes in the database that the mapviewer needs:
NoteDo this after you import the data in your DB.
- Log in to mapdb.
- "Tables"
- In "Object Name" Enter ga_counties (see the importer file on how it names this)
- Actions-> Create Index
- Provide a name: county_geom_idx
- Click OK
- Go back and click on the radio "create index on one or more non-spatial columns"
- County ...... value 1