A
Sample Programs

Oracle8i interMedia Locator includes a number of scripts that you can modify and run.

A.1 Sample Scripts

Sample Oracle8i interMedia Locator scripts are available in the following directory after you install this product:

$ORACLE_HOME/md/demo/geocoder

These scripts consist of the following files:

• geohttp.sql

  This file contains two parts. One part is for running a geocode function in interactive mode and the other is for running the geocode function in batch mode.

  • Interactive mode.

    See Example 1 in "GEOCODE1 Function (with lastline field)" for a listing of this part of the file.

  • Batch mode.

    You must update the setup tables in the nh_cs.sql file before you run the geohttp.sql in batch mode. See Example 2 in "GEOCODE1 Function (with lastline field)" or Example 3 in "GEOCODE1 Function (with lastline field)" for a listing of this part of the file.

• geoindex.sql

  This file contains:

  • A function named ESTIMATE_LEVEL to better estimate the index level for use with the spatial locator index for within-distance queries that use a radius distance greater than 100 miles. See the example in "ESTIMATE_LEVEL" for a listing of this file.

  • A procedure statement named SETUP_LOCATOR_INDEX that builds a setup spatial locator index on the location column that contains the spatial information within the cust_table table where the spatial information is stored. See the example in "SETUP_LOCATOR_INDEX" for a listing of this file.

• geolocate.sql

  This file contains a routine that dynamically creates a geometry of interest and then queries against the NH_COMPUTER_STORES table to find out how many stores are within a 10-mile radius of the office. See Example 2 in "LOCATOR_WITHIN_DISTANCE" for a listing of this file.

---