ArcGIS Customizations
Users of ArcGIS 9.3 can download this ArcObjects dll to geocode Orem
addresses using the Orem Geocoding Web Service. This DLL can geocode one typed address
at a time, panning the user around the data view, optionally placing a graphic at the
location. The DLL can also geocode an entire table of addresses, resulting in a
shapefile.
To install the DLL:
- Open ArcMap
- Customize the Toolbar (Tools > Customize…)
- Click the Commands tab
- Click the Add from file… button
- Browse to the location where you saved this DLL, select the DLL, and click OK
- Click OK on the resulting dialog box
- A command called Geocode Orem Addresses… will be placed in the Geocoding category
- Drag and drop the command to any toolbar you want
- You can click the Close button and skip the rest of these instructions, or continue
following along to enable geocoding entire tables
- Click the Toolbars tab
- Check on the Context Menus checkbox
- Drop down the Context Menus button and expand the Table submenu
- Click the Commands button in the Customize dialog box
- Drag and drop the command to a logical place in the Table submenu
- Close the Customize dialog box
To use the DLL:
Geocoding a single address (it helps to have other layers in your map
that cover Orem city)
- Click the Orem City Geocoder button. Its icon is an outline of Orem city with a
grey post sign in the middle of it.
- Enter an address any logical way, but leave out the city, state, and zip. Some examples
of geocodable addresses are:
- 414 N 800 E
- 414 north 800 E.
- 800 EAST 414 North
- 359 w univ
- 1300 S 359 WEst
- 869 w 398 S
- Optionally enter an offset for the point (default is 0 feet)
- As the dialog box indicates, you can keep the current extent and place the graphic,
or have the map moved for you. When you have the map moved for you, you have the
option of placing a graphic on the map. The graphic is a solid red square. (It would
be pointless for the map not to move and not to place a graphic).
Geocoding a table of addresses
- If it's not already, add a table to your map with the Add Data command. The table
will not show up in the Display tab of the Table of Contents, but the Source tab
instead.
- Right-click the table and choose Geocode Orem Addresses...
- A Dialog box appears. You can cancel it if you don't really want to geocode
addresses.
- Drop down the list of fields to choose a field to geocode. Obviously, addresses
can't be spread across multiple fields.
- Optionally, click the checkbox to include the X and Y values of the resulting point
in the new shapefile. The new shapefile will automatically have a Match field and a
Side field. The Side field can be misleading, since it assumes the first number in the
address is the house and the second word is the prefix direction.
- Optionally enter an offset for the point (default is 0 feet)
- Click the folder button to specify an output folder and name for the shapefile.
Only then will the OK button be enabled.
- Geocoding progress will be updated every 25 rows.
Users of ArcGIS 9.2 have probably been frustrated by ArcCatalog's
inability to preview text files. This DLL is the solution. It not only previews text
files, but uses the font settings set in Windows Notepad.
To install the DLL:
- Unzip the files to a location on your hard drive, preferably a new folder
specifically for this utility
- Close any ArcGIS programs that are running
- Run the Install.bat program
- Open ArcCatalog
- Verify that ArcCatalog can list text files
- Click Tools > Options
- In the bottom window, verify that Text Files is checked
- Optionally, you can select Text Files and click the Properties... button.
This allows you select which file extensions are text files, but you only have four
hard-coded extensions to choose from.
To use the DLL:
- Browse to a text file in ArcCatalog and select it in the tree
- Click the Preview tab
- To change the Font used in the Preview tab:
- Close ArcCatalog
- Open Notepad
- Click Format > Font and change the Font there
- Optionally, click Format > Word Wrap. The text preview tab will only wrap
text if notepad is set to do the same thing.
This DLL is not downloadable as it accesses a particular set of tables
in a certain database internal to Orem. All in-house database applications built by
Orem access an IBM i-Series with an AS/400 operating system. This database is not
natively accessed by ArcGIS or MapObjects. Some of these database programs regularly
verify addresses by looking at a central repository of valid addresses. Over time,
however, this database has become outdated as administrative boundaries have changed.
Before the release of the Address Hive, our GIS Planner, Clint
Spencer had to enter address information twice: once in our parcel geodatabase and
once in the address database. Using ArcHiveCommands, he can quickly add selected
parcel address information into the Address Hive database. Other tools generate
unique parcel IDs and help him reconcile mislinks between the geodatabase and the
i-Series database.