MSD Customer Calls

+ Resource Description

Citation

Information used to reference the data.

Title: MSD Customer Calls

Originators: MSD

Publication date: 8/21/2000

Data type: vector digital data

Data location: Server=lojicora1; Service=esri_sde; User=msddata; Version=SDE.DEFAULT

Description

A characterization of the data, including its intended use and limitations.

Abstract:

Points indicating the MSD customer calls which are also entered into the MSD Hansen Database

Purpose:

General query, display & analysis

Language of dataset: en

Point Of Contact

Contact information for the individual or organization that is knowledgeable about the data.

Person: Julie Buckler

Organization: MSD

Phone: (502) 540-6443

Fax: (502) 540-6180

Email: buckler@msdlouky.org

Data Type

How the data are represented, formatted and maintained by the data producing organization.

File or table name: MSDDATA.custserv_t

Data type: vector digital data

Data format: SDE Feature Class

Native dataset environment: Microsoft Windows 2000 Version 5.2 (Build 3790) Service Pack 2; ESRI ArcCatalog 9.3.1.3000

Time Period of Data

Time period(s) for which the data corresponds to the currentness reference.

Date: REQUIRED: The year (and optionally month, or month and day) for which the data set corresponds to the ground.

Currentness reference:

ground condition

Status

The state of and maintenance information for the data.

Data status: Complete

Update frequency: As needed

Key Words

Words or phrases that summarize certain aspects of the data.

Theme:

Keywords: location

Keyword thesaurus: ArcIMS Metadata Server Theme Codes

Place:

Keywords: Louisville, Louisville Metro, Jefferson County, Kentucky

Keyword thesaurus: None

Data Access Constraints

Restrictions and legal prerequisites for accessing or using the data after access is granted.

Access constraints:

Data access is restricted to LOJIC Participants, their contractors and Licensees only

Use constraints:

LIMITATION OF LIABILITY: MSD and the participants of the Louisville/Jefferson County Information Consortium (LOJIC) have no indication or reason to believe that there are any inaccuracies or defects of information incorporated in this work and make NO REPRESENTATIONS OF ANY KIND, INCLUDING, BUT NOT LIMITED TO, THE WARRANTIES OF MERCHANTBILITY OR FITNESS FOR A PARTICULAR USE, NOR ARE ANY SUCH WARRANTIES TO BE IMPLIED, WITH RESPECT TO THE INFORMATION OR DATA, FURNISHED HEREIN.



The attached data is owned by the LOJIC participants and is protected by United States Copyright laws and applicable international copyright treaties and/or conventions.

+ Spatial Reference Information

Horizontal Coordinate System

Reference system from which linear or angular quantities are measured and assigned to the position that a point occupies.

Projected coordinate system:

Name: NAD 1983 StatePlane Kentucky North FIPS 1601 Feet

Map units: survey feet

Geographic coordinate system:

Name: GCS North American 1983

Coordinate System Details

Map projection

Map projection name: Lambert Conformal Conic

Standard parallel: 37.966667

Standard parallel: 38.966667

Longitude of central meridian: -84.250000

Latitude of projection origin: 37.500000

False easting: 1640416.666667

False northing: 0.000000

Planar Coordinate Information

Planar coordinate encoding method: coordinate pair

Coordinate representation:

Abscissa resolution: 0.001250

Ordinate resolution: 0.001250

Planar distance units: survey feet

Geodetic model

Horizontal datum name: North American Datum of 1983

Ellipsoid name: Geodetic Reference System 80

Semi-major axis: 6378137.000000

Denominator of flattening ratio: 298.257222

Vertical Coordinate System

Reference system from which vertical distances (altitudes or depths) are measured.

Altitude system definition:

Altitude resolution: 1.000000

Altitude encoding method: Explicit elevation coordinate included with horizontal coordinates

Spatial Domain

The geographic areal domain of the data that describes the western, eastern, northern, and southern geographic limits of data coverage.

Bounding Coordinates

In Projected or local coordinates

NAD 1983 StatePlane Kentucky North FIPS 1601 Feet

Boundary	Coordinate
Left	1155353.000000 (survey feet)
Right	1327234.625000 (survey feet)
Top	347993.812500 (survey feet)
Bottom	187547.297500 (survey feet)

In Unprojected coordinates (geographic)

GCS North American 1983

Boundary	Coordinate
West	-85.943698 (longitude)
East	-85.336999 (longitude)
North	38.450493 (latitude)
South	38.002839 (latitude)

+ Data Structure and Attribute Information

Overview

Summary of the information content of the data, including other references to complete descriptions of entity types, attributes, and attribute values for the data.

Direct spatial reference method: Vector

Attributes of MSDDATA.custserv_t

Detailed descriptions of entity type, attributes, and attribute values for the data.

Name: MSDDATA.custserv_t

Type of object: Feature Class

Geometry type: Point

Number of records: 0

Attributes

ADDRKEY

Definition:

Unique identifier used to link to the Hansen Address Table

Alias: ADDRKEY Type: Integer Width: 4 Precision: 10 Scale: 0

SERVNO

Definition:

Unique identifier for each call point

Alias: SERVNO Type: Integer Width: 4 Precision: 10 Scale: 0

REQADDR

Definition:

Address of the service request

Alias: REQADDR Type: String Width: 61 Precision: 0 Scale: 0

CUSTFIRST

Definition:

Callers first name

Alias: CUSTFIRST Type: String Width: 30 Precision: 0 Scale: 0

CUSTLAST

Definition:

Callers last name

Alias: CUSTLAST Type: String Width: 50 Precision: 0 Scale: 0

CUSTADDR1

Definition:

Primary caller address

Alias: CUSTADDR1 Type: String Width: 40 Precision: 0 Scale: 0

CUSTADDR2

Definition:

Secondary caller address

Alias: CUSTADDR2 Type: String Width: 40 Precision: 0 Scale: 0

CITY

Definition:

City in which the REQADDR is located

Alias: CITY Type: String Width: 30 Precision: 0 Scale: 0

STATE

Definition:

State in which the REQADDR is located

Alias: STATE Type: String Width: 30 Precision: 0 Scale: 0

ZIP

Definition:

Zipcode in which the REQADDR is located

Alias: ZIP Type: String Width: 20 Precision: 0 Scale: 0

PROBDEF

Definition:

Type of problem of the service request

Alias: PROBDEF Type: String Width: 5 Precision: 0 Scale: 0

Attribute domain values

Value	Definition
ALARM	Facility Alarm
BCKUP	Sewer backup, PSC stopped up
BILL	Billing Information
CAVE	Cave In
CBASIN	Catch Basin
CONST	New Construction
DISCH	Discharge, dumped substance, emergency pump malfunction
DRAIN	Cleaning, erosion, facility damage, flooding, standing water, steep ditch
ECSR	External affairs conversion data
INFO	Information request
MNHLE	manhole
MOW	Grass/Weeds overgrown ditch, creek, floodwall, TP, PS, MSD owned
OBSTR	Drainage obstruction
ODOR	puwee odor
PDAMG	Property damage due to construction repair
RESTR	Restoration/Landscaping
SEWIN	Sewer Investigation
TREES	Tree Issues

MODDATE

Alias: MODDATE Type: Date Width: 36 Precision: 0 Scale: 0

PROBDATE

Definition:

Date in which the problem occurred

Alias: PROBDATE Type: Date Width: 36 Precision: 0 Scale: 0

SUBPROB

Definition:

Subproblem definition

Alias: SUBPROB Type: String Width: 10 Precision: 0 Scale: 0

Attribute domain values

Value	Definition
CAVEIN	Cave in
NOFUNDITCH	No fund ditch
NOFUNFACIL	No fund facility
NOTMSD	Not MSD
PRIVPROP	Private Property
RAINEVENT	Rain event

SOURCE

Definition:

Indicates how the problem was reported

Alias: SOURCE Type: String Width: 10 Precision: 0 Scale: 0

Attribute domain values

Value	Definition
INTERNET	Report from Internet
Letter	Report from letter
Other	Report from other action
Phone	Report from phone call
Walkin	Report from personal visit to MSD

CALLNUM

Definition:

Total number of calls for the service request

Alias: CALLNUM Type: Integer Width: 4 Precision: 10 Scale: 0

PRIORITY

Definition:

Priority of the problem

Alias: PRIORITY Type: String Width: 4 Precision: 0 Scale: 0

Attribute domain values

Value	Definition
HIGH	High/critical/immediate
HOLD	On hold (see comments for more information)
LOW	Low/when time permits
MED	Medium/Normal
SPEC	Special handling
XHGH	External affairs high
XLOW	External affairs low

ADDBY

Definition:

Employee id of the person who added the service request

Alias: ADDBY Type: String Width: 30 Precision: 0 Scale: 0

ADDDATE

Definition:

Date in which the call was entered into Hansen Database

Alias: ADDDATE Type: Date Width: 36 Precision: 0 Scale: 0

TAKENBY

Definition:

The employee id of the person who added the service request

Alias: TAKENBY Type: String Width: 12 Precision: 0 Scale: 0

CALLDATE

Definition:

Date in which the caller called regarding the service request

Alias: CALLDATE Type: Date Width: 36 Precision: 0 Scale: 0

RESPONS

Definition:

Code to indicate who is responsible for the service request

Alias: RESPONS Type: String Width: 4 Precision: 0 Scale: 0

Attribute domain values

Value	Definition
MAT	MSD Area Team
MCA	MSD construction area team
MCC	MSD customer call center
MDP	MSD development plan review
MDR	MSD drainage department
MFI	MSD finance department
MIC	MSD industrial compliance
MLE	MSD legal department
MOP	MSD operations
MPA	MSD physical assets
MSC	MSD customer service center
MSM	MSD sanitary maintenance
MWW	MSD wet weather/water quality

RESOLCODE

Definition:

Code indicating the resolution of the service request

Alias: RESOLCODE Type: String Width: 5 Precision: 0 Scale: 0

Attribute domain values

Value	Definition
CUST	Customer responsibility
INFO	Information Provided
NOMSD	No MSD action needed
NOPRB	No problem found
REFER	Refferred to other agency
WOCOM	Work completed

RESOLDATE

Definition:

Date and time indicating when the service request was resolved

Alias: RESOLDATE Type: Date Width: 36 Precision: 0 Scale: 0

RESOLVED

Definition:

Flag indicating if the request has been resolved

Alias: RESOLVED Type: String Width: 1 Precision: 0 Scale: 0

Attribute domain values

Value	Definition
Y	indicates the request has been resolved
N	indicates the request has not been resolved

SOLUT_ID

Definition:

Unit ID of the solution, if applicable, that will  resolve the service

Alias: SOLUT_ID Type: String Width: 16 Precision: 0 Scale: 0

ST_DIR

Definition:

Street direction in  REQADDR  field

Alias: ST_DIR Type: String Width: 3 Precision: 0 Scale: 0

ST_NAME

Definition:

Street name in "REQADDR" field

Alias: ST_NAME Type: String Width: 20 Precision: 0 Scale: 0

ST_TYPE

Definition:

Street type in  REQADDR  field

Alias: ST_TYPE Type: String Width: 4 Precision: 0 Scale: 0

HOUSENO

Definition:

House Number

Alias: HOUSENO Type: String Width: 6 Precision: 0 Scale: 0

REQZIP

Definition:

Zipcode of Request

Alias: REQZIP Type: String Width: 10 Precision: 0 Scale: 0

PROBYEAR

Definition:

Year service request made

Alias: PROBYEAR Type: Double Width: 8 Precision: 38 Scale: 8

ST2_DIR

Definition:

Street direction in  REQADDR  field

Alias: ST2_DIR Type: String Width: 3 Precision: 0 Scale: 0

ST2_NAME

Definition:

Street name in  REQADDR  field

Alias: ST2_NAME Type: String Width: 20 Precision: 0 Scale: 0

ST2_TYPE

Definition:

field

Alias: ST2_TYPE Type: String Width: 4 Precision: 0 Scale: 0

OBJECTID

Definition:

Internal feature number.

Alias: OBJECTID Type: OID Width: 4 Precision: 10 Scale: 0

Attribute values: Sequential unique whole numbers that are automatically generated.

Attribute definition source:

ESRI

COMPKEY

Alias: COMPKEY Type: Integer Width: 4 Precision: 10 Scale: 0

CAT_CODE

Definition:

Historical category code pulled over from the Customer Response System) CRS. This item will be eventually dropped.

Alias: CAT_CODE Type: String Width: 2 Precision: 0 Scale: 0

SHAPE

Definition:

Feature geometry.

Alias: Shape Type: Geometry Width: 4 Precision: 0 Scale: 0

Attribute values: Coordinates defining the features.

Attribute definition source:

ESRI

ESRI Feature Description

Description of spatial objects in the data using the Environmental Systems Research Institute (ESRI) terminology.

Environmental Systems Research Institute (ESRI) terms

MSDDATA.custserv_t

ESRI feature type: Simple

Geometry type: Point

Topology: FALSE

Feature count: 0

Spatial index: TRUE

Linear referencing: FALSE

SDTS Feature Description

Description of point and vector spatial objects in the data using the Spatial Data Transfer Standards (SDTS) terminology.

Spatial data transfer standard (SDTS) terms

MSDDATA.custserv_t

Type: Entity point

Count: 0

+ Data Source and Process Information

Process Steps

Information about events, parameters, tolerances and techniques applied to construct or derive the data.

Process step information

Process Step 1

Process description:

Calls are address matched in Oracle database against $LOJICDATA/siteadd layer to locate calls as points in CUSTSERV. The agency field is used to pull those requests that are MSD s responsibility. The metroser layer in $LOJICDATA stores all other service requests in Hansen.

Process Step 2

Process description:

Metadata imported.

Data Source used

H:\data\lojic\metadata\MSDDATA#CUSTSERV.xml

Process Step 3

Process description:

Dataset copied.

Data Source used

Server=lojicora1; Service=esri_sde; User=msddata; Version=SDE.DEFAULT

Process Step 4

Process description:

Metadata imported.

Process date: 20100223 Process time: 11083000

Data Source used

J:\lojic\MetaData_Transfer\MSDData\custserv.xml

ESRI geoprocessing history

Description of ESRI geoprocessing commands, settings, and tolerances applied to the data.

ESRI geoprocessing command information

1 Process

Date: 20080531 Time: 172527

Tool location: C:\Program Files (x86)\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpgradeSpatialReference

Command issued: UpgradeSpatialReference "Database Connections/pl_MSDDATA.sde/msddata.custserv" 0.00125 0.025 0.025 "Database Connections/pl_MSDDATA.sde/msddata.custserv"

2 Process

Date: 20080811 Time: 120506

Tool location: C:\Program Files (x86)\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\Analyze

Command issued: Analyze "Database Connections/pl_msddata.sde\msddata.custserv_1" BUSINESS;FEATURE "Database Connections/pl_msddata.sde\msddata.custserv_1"

3 Process

Date: 20080811 Time: 124924

Tool location: C:\Program Files (x86)\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\ChangePrivileges

Command issued: ChangePrivileges "Database Connections/pl_msddata.sde\msddata.custserv" LOJIC_ROLE GRANT # "Database Connections/pl_msddata.sde\msddata.custserv"

4 Process

Date: 20100224 Time: 021144

Tool location: C:\Program Files (x86)\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\ChangePrivileges

Command issued: ChangePrivileges "Database Connections/pu_msddata.sde\msddata.custserv" LOJIC_ROLE GRANT # "Database Connections/pu_msddata.sde\msddata.custserv"

5 Process

Date: 20100227 Time: 001634

Tool location: C:\Program Files (x86)\ArcGIS\ArcToolbox\Toolboxes\Conversion Tools.tbx\FeatureClassToFeatureClass