Synchronizing POSM Server Data with ArcMap.


1. Launch POSM to begin creating HTML reports for POSM sessions.

A. Click “Export GIS and HTML Data” button to begin.

I. “Check All” sessions.

II. Click “Find GIS Match” button.
a. This will create a ‘NoGISmatch.txt’ in the POSM folder, which recreates each time match is run.

• C:\POSM\NoGISmatch.txt

b. Inappropriate sessions (i.e. lateral videos, etc.) can be removed from database so they don’t keep returning these records in the NoGISmatch.txt.
B. In ‘Database Field’ dropdown list select “Sessions Modified.”

C. Set “Data Value” to “True” and click “Search.”
I. This will show in the window how many sessions have been modified since last export.

D. Make sure all are checked (‘Check All’) and then “Create HTML Reports.”


E. All checked sessions are now being converted to HTML reports. The status of completion is given in the lower left.

F. Close.

2. Launch ArcMap to begin importing HTML pages to the map.
A. Open the MXD setup for use with POSM.
I. Begin edit session on san_version in sandbox.

B. Click on “POSM_Import,” this step will populate report and depth fields in each districts pipe layer.

I. Click “Select Posm Database.”

a. Navigate to \\Fileserver\sewervideo\POSM\DatabaseLocations.mdb and click “Select.”

II. Select POSM Sewer SQL and click “Open Database.”

III. Select the settings from “Saved Settings Name” and click “Load Settings.” Layers that will be effected will appear under layers that will be affected.

IV. Click “Begin Import” (do not check import all sessions).

C. “Close Import Posm GIS Data” when finished.

POSM Server (GIS Edition) // Synchronizing POSM Server Data with ArcMap // Page 2


3. The next step exports all new info brought into GIS from inspection vehicle to database which gets written back to truck.

A. With the POSM export MXD map open click on “Posm_Export.”
I. Select Posm Database: \\POSM\DatabaseLocations.mdb

II. Select “POSM Sewer SQL” and “Open Database.”

III. Click “Clear POSM GIS Database”.

IV. Under the “Export Settings Name” dropdown, select settings name and click “Begin Import.”

B. After the export is complete, go into the POSM folder on the fileserver and copy the “PosmGISData.mdb.”
C. This file should be copied to a media device to be written to the inspection vehicles’ POSM folder.

D. Once the new “PosmGISData.mdb” is overwritten to the inspection vehicles’ POSM folder, data will be available to pre-load existing map data to the POSM header via the “Asset ID” button.

POSM Server (GIS Edition) // Synchronizing POSM Server Data with ArcMap // Page 3