Sewer Pump Station

+ Resource Description

Citation

Information used to reference the data.

Title: Sewer Pump Station

Originators: MSD

Publication date: 8/01

Data type: vector digital data

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

Description

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

Abstract:

Point layer showing locations of MSD sanitary

pumping stations that operate in Jefferson

County.

Purpose:

General query and display.

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

Address type: mailing and physical address

Address:

700 W. Liberty St.

City: Louisville

State or Province: Kentucky

Postal code: 40203

Data Type

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

File or table name: MSDDATA.SewerPumpStation

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: 8/01

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: structure

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	1166444.277500 (survey feet)
Right	1305456.213750 (survey feet)
Top	316096.322500 (survey feet)
Bottom	203506.110000 (survey feet)

In Unprojected coordinates (geographic)

GCS North American 1983

Boundary	Coordinate
West	-85.902981 (longitude)
East	-85.413279 (longitude)
North	38.362177 (latitude)
South	38.047206 (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.SewerPumpStation

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

Name: MSDDATA.SewerPumpStation

Type of object: Feature Class

Geometry type: Point

Number of records: 509

Description:

Sanitary Sewer Pump Station

Source:

Hansen

Attributes

AGENCY

Alias: AGENCY 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

UNITID

Definition:

Unique ID number

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

COMPKEY

Definition:

Unique identifier assigned by Hansen application

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

COMPTYPE

Definition:

Type of feature (Comptype = 15 for Pump Station)

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

FACNUM

Definition:

MSD pump station number

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

INST_DATE

Definition:

The date pump station was built

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

REC_TPNAME

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

ASBUILT

Definition:

Final record number

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

SERV_STATUS

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

REC_TPNUM

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

DISTRICT

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

LOC

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

UNITTYPE

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

PS_NAME

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

ADDRESS

Alias: ADDRESS Type: String Width: 35 Precision: 0 Scale: 0

STNO

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

PREDIR

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

STNAME

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

SUFFIX

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

ENABLED

Alias: Enabled Type: SmallInteger Width: 2 Precision: 5 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

ANCILLARYROLE

Alias: AncillaryRole Type: SmallInteger Width: 2 Precision: 5 Scale: 0

ESRI Subtypes of MSDDATA.SewerPumpStation

Describes the subtypes that have been defined for a feature class in a geodatabase

In the following list the subtype code is followed by the subtype name. Attributes (subtype fields) for each subtype are described in terms of their default value, valid domain values, value after merging or splitting features, etc.

Subtypes

15 - Sewer Pump Station

Attributes

COMPTYPE

Default value: 15

LOC

Attribute defined domain:

Domain name: MSD_Loc

Domain description: MSD asset locations.

Domain owner: msddata

Field type: String

Domain type: Coded Value

Merge rule: Default value

Split rule: Duplicate

UNITTYPE

Attribute defined domain:

Domain name: MSD_PsUnitType

Domain description: Drainage and Sewer Pump Station Unit Type

Domain owner: msddata

Field type: String

Domain type: Coded Value

Merge rule: Default value

Split rule: Duplicate

SERV_STATUS

Default value: I

Attribute defined domain:

Domain name: MSD_ServStat

Domain description: Service status

Domain owner: msddata

Field type: String

Domain type: Coded Value

Merge rule: Default value

Split rule: Duplicate

AGENCY

Default value: MSD

Attribute defined domain:

Domain name: MSD_Owner

Domain description: Asset ownership

Domain owner: msddata

Field type: String

Domain type: Coded Value

Merge rule: Default value

Split rule: Duplicate

ENABLED

Default value: 1

Attribute defined domain:

Domain name: EnabledDomain

Domain description: ESRI Geometric Network Domain. DEFAULT for all geometric networks.

Domain owner: msddata

Field type: SmallInteger

Domain type: Coded Value

Merge rule: Default value

Split rule: Default value

ANCILLARYROLE

Default value: 0

Attribute defined domain:

Domain name: AncillaryRoleDomain

Domain description: ESRI geometric network domain. Default for all geometric networks.

Domain owner: msddata

Field type: SmallInteger

Domain type: Coded Value

Merge rule: Default value

Split rule: Default value

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.SewerPumpStation

ESRI feature type: Simple Junction

Geometry type: Point

Topology: TRUE

Feature count: 509

Spatial index: TRUE

Linear referencing: FALSE

Network role: Source Sink

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.SewerPumpStation

Type: Entity point

Count: 509

+ 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:

During the sewer converson project, sanitary

pumping stations were manually transcribe

from engineering record drawings onto PTD

manuscript maps. These sanitary pumping

stations were then digitized on screen using

the IMSARC application. Now that the sewer

conversion project is complete, the built

sanitary construction plans are used to digitize

the graphics on screen. Pump stations are

identified as comptype 15 and extracted from

the arcstorm database and included in this

layer.

Process Step 2

Process description:

Metadata imported.

Data Source used

H:\data\lojic\metadata\jeff\MSDDATA_SPS.xml

Process Step 3

Process description:

Metadata imported.

Data Source used

H:\MetaData_Transfer\MSDData\sps.xml

Process Step 4

Process description:

Dataset copied.

Data Source used

Server=lojicora1; Service=esri_sde; User=bcarroll; Version=MSDDATA.SEWER_E

Process Step 5

Process description:

Dataset copied.

Data Source used

\\gishome1.pc.lojic.local\home\bcarroll\Data Backups\MSDDATA.gdb

Process Step 6

Process description:

Metadata imported.

Process date: 20091022 Process time: 08362800

Data Source used

J:\common\MSD\metadata_shapefiles\SewerPumpStation.xml

ESRI geoprocessing history

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

ESRI geoprocessing command information

1 Process

Date: 20091013 Time: 104515

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

Command issued: FeatureClassToFeatureClass "Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation" H:\Shapefiles point_sps.shp # "COMPKEY 'COMPKEY' true true false 4 Long 0 10 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,COMPKEY,-1,-1;COMPTYPE 'COMPTYPE' true true false 4 Long 0 10 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,COMPTYPE,-1,-1;UNITID 'UNITID' true true false 16 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,UNITID,-1,-1;LOC 'LOCATION' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,LOC,-1,-1;UNITTYPE 'UNITTYPE' true true false 6 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,UNITTYPE,-1,-1;INST_DATE 'INST_DATE' true true false 36 Date 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,INST_DATE,-1,-1;ASBUILT 'ASBUILT' true true false 10 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,ASBUILT,-1,-1;SERV_STATU 'SERV_STATUS' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,SERV_STATUS,-1,-1;AGENCY 'AGENCY' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,AGENCY,-1,-1;REC_TPNAME 'REC_TPNAME' true true false 30 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,REC_TPNAME,-1,-1;REC_TPNUM 'REC_TPNUM' true true false 16 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,REC_TPNUM,-1,-1;PS_NAME 'SPS_NAME' true true false 30 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,PS_NAME,-1,-1;DISTRICT 'DISTRICT' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,DISTRICT,-1,-1;FACNUM 'FACNUM' true true false 5 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,FACNUM,-1,-1;ADDRESS 'ADDRESS' true true false 35 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,ADDRESS,-1,-1;STNO 'STNO' true true false 6 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,STNO,-1,-1;PREDIR 'PREDIR' true true false 3 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,PREDIR,-1,-1;STNAME 'STNAME' true true false 20 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,STNAME,-1,-1;SUFFIX 'SUFFIX' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,SUFFIX,-1,-1;ENABLED 'Enabled' true true true 2 Short 0 5 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,ENABLED,-1,-1;ANCILLARYR 'AncillaryRole' true true true 2 Short 0 5 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerPumpStation,ANCILLARYROLE,-1,-1" # H:\Shapefiles\point_sps.shp

2 Process

Date: 20100113 Time: 114746