Sewer Treatment Plant

+ Resource Description

Citation

Information used to reference the data.

Title: Sewer Treatment Plant

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

treatment plants of variable capacity 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.SewerTreatmentPlant

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: Kentucky, Louisville, Louisville Metro, Jefferson County

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	1164802.035000 (survey feet)
Right	1298835.251250 (survey feet)
Top	311413.403750 (survey feet)
Bottom	207559.053750 (survey feet)

In Unprojected coordinates (geographic)

GCS North American 1983

Boundary	Coordinate
West	-85.908413 (longitude)
East	-85.436452 (longitude)
North	38.349086 (latitude)
South	38.058253 (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.SewerTreatmentPlant

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

Name: MSDDATA.SewerTreatmentPlant

Type of object: Feature Class

Geometry type: Point

Number of records: 128

Description:

Sanitary Sewer Treatment Plant

Source:

Hansen

Attributes

UNITID

Definition:

Unique ID number

Alias: UNITID Type: String Width: 16 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

DISTRICT

Alias: DISTRICT Type: String Width: 4 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 = 98 for Sanitary Treatment Plant)

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

FACNUM

Definition:

MSD facility number

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

STP_NAME

Definition:

Treatment plant name

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

INST_DATE

Definition:

Install Date

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

SERV_STATUS

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

ASBUILT

Definition:

Final record number

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

AGENCY

Definition:

Who owns the facility

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

Attribute domain values

Value	Definition
MSD	MSD owned and operated
P	Private facility going to MSD facility
PMSD	Private but maintained by MSD
PTP	Private facility going to a private treatment plant

KPDESNO

Alias: KPDESNO Type: String Width: 12 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

DATEACQUIRED

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

LOC

Alias: LOCATION Type: String Width: 4 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

DATENOTSRV

Alias: DATENOTSRV Type: Date Width: 36 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

ANCILLARYROLE

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

ESRI Subtypes of MSDDATA.SewerTreatmentPlant

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

98 - Sewer Treatment Plant

Attributes

COMPTYPE

Default value: 98

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

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

ESRI feature type: Simple Junction

Geometry type: Point

Topology: TRUE

Feature count: 128

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

Type: Entity point

Count: 128

+ 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 conversion project,

treatment plants were manually transcribed

from engineering record drawings onto PTD

manuscript maps. These facilities 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

graphic on screen. Treatment plants are

identified as comptype 98 and are extracted

from the arcstorm database and included in

this layer.

Process Step 2

Process description:

Metadata imported.

Data Source used

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

Process Step 3

Process description:

Metadata imported.

Data Source used

H:\MetaData_Transfer\MSDData\stp.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: 08370500

Data Source used

J:\common\MSD\metadata_shapefiles\SewerTreatmentPlant.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: 173418

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

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

2 Process

Date: 20081111 Time: 103026

Tool location: S:\Program Files\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\AddJoin

Command issued: AddJoin PlaceholderText1 COMPKEY PlaceholderText2 COMPKEY KEEP_COMMON PlaceholderText1

3 Process

Date: 20081111 Time: 103026

Tool location: S:\Program Files\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\SelectLayerByAttribute

Command issued: SelectLayerByAttribute PlaceholderText1 NEW_SELECTION "OPSID IS NOT NULL" PlaceholderText1

4 Process

Date: 20081111 Time: 103417

Tool location: S:\Program Files\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\AddJoin

Command issued: AddJoin PlaceholderText1 COMPKEY PlaceholderText2 COMPKEY KEEP_COMMON PlaceholderText1

5 Process

Date: 20081111 Time: 103417

Tool location: S:\Program Files\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\SelectLayerByAttribute

Command issued: SelectLayerByAttribute PlaceholderText1 NEW_SELECTION "OPSID IS NOT NULL" PlaceholderText1

6 Process

Date: 20081111 Time: 103609

Tool location: S:\Program Files\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\AddJoin

Command issued: AddJoin PlaceholderText1 COMPKEY PlaceholderText2 COMPKEY KEEP_COMMON PlaceholderText1

7 Process

Date: 20081111 Time: 103610

Tool location: S:\Program Files\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\SelectLayerByAttribute

Command issued: SelectLayerByAttribute PlaceholderText1 NEW_SELECTION "OPSID IS NOT NULL" PlaceholderText1

8 Process

Date: 20091013 Time: 111341

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.SewerTreatmentPlant" H:\Shapefiles point_stp.shp # "COMPKEY 'COMPKEY' true true false 4 Long 0 10 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,COMPKEY,-1,-1;COMPTYPE 'COMPTYPE' true true false 4 Long 0 10 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,COMPTYPE,-1,-1;UNITID 'UNITID' true true false 16 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,UNITID,-1,-1;LOC 'LOCATION' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,LOC,-1,-1;INST_DATE 'INST_DATE' true true false 36 Date 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,INST_DATE,-1,-1;ASBUILT 'ASBUILT' true true false 10 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,ASBUILT,-1,-1;SERV_STATU 'SERV_STATUS' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,SERV_STATUS,-1,-1;AGENCY 'AGENCY' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,AGENCY,-1,-1;STP_NAME 'STP_NAME' true true false 30 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,STP_NAME,-1,-1;FACNUM 'FACNUM' true true false 5 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,FACNUM,-1,-1;KPDESNO 'KPDESNO' true true false 12 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,KPDESNO,-1,-1;DATEACQUIR 'DATEACQUIR' true true false 36 Date 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,DATEACQUIRED,-1,-1;DATENOTSRV 'DATENOTSRV' true true false 36 Date 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,DATENOTSRV,-1,-1;DISTRICT 'DISTRICT' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,DISTRICT,-1,-1;ADDRESS 'ADDRESS' true true false 35 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,ADDRESS,-1,-1;STNO 'STNO' true true false 6 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,STNO,-1,-1;PREDIR 'PREDIR' true true false 3 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,PREDIR,-1,-1;STNAME 'STNAME' true true false 20 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,STNAME,-1,-1;SUFFIX 'SUFFIX' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,SUFFIX,-1,-1;ENABLED 'Enabled' true true true 2 Short 0 5 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,ENABLED,-1,-1;ANCILLARYR 'AncillaryRole' true true true 2 Short 0 5 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerTreatmentPlant,ANCILLARYROLE,-1,-1" # H:\Shapefiles\point_stp.shp

9 Process

Date: 20100113 Time: 114813