Sewer Manhole

+ Resource Description

Citation

Information used to reference the data.

Title: Sewer Manhole

Originators: MSD

Publication date: 3/1999

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 of manholes within 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) 502 - 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.SewerManhole

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: 3/1999

Currentness reference:

ground condition

Status

The state of and maintenance information for the data.

Data status: Complete

Update frequency: Weekly

Key Words

Words or phrases that summarize certain aspects of the data.

Theme:

Keywords: utilitiesCommunications, 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	1164019.536250 (survey feet)
Right	1307309.591250 (survey feet)
Top	316426.502500 (survey feet)
Bottom	201211.750000 (survey feet)

In Unprojected coordinates (geographic)

GCS North American 1983

Boundary	Coordinate
West	-85.911456 (longitude)
East	-85.406744 (longitude)
North	38.363147 (latitude)
South	38.040787 (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.SewerManhole

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

Name: MSDDATA.SewerManhole

Type of object: Feature Class

Geometry type: Point

Number of records: 77421

Description:

Sanitary Sewer Manhole

Source:

Hansen

Attributes

COMPTYPE

Definition:

Type of feature; in this case always 22 (sewer

Alias: COMPTYPE Type: Integer Width: 4 Precision: 10 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

ASBUILT

Definition:

Record number from the MSD project drawing

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

AGENCY

Definition:

Owner of facility

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

Attribute domain values

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

UNITID

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

COMPKEY

Definition:

Unique identifier assigned by V7IMS application

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

LOC

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

INST_DATE

Definition:

Date the project was constructed, mm/dd/yyyy

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

UNITTYPE

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

SERV_STATUS

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

SEAL

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

REC_TPNUM

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

REC_TPNAME

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

DEPTH

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

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

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

22 - Sewer Manhole

Attributes

COMPTYPE

Default value: 22

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_SmhUnitType

Domain description: Sewer manhole 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

SEAL

Attribute defined domain:

Domain name: MSD_Seal

Domain description: Type of seal

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

ESRI feature type: Simple Junction

Geometry type: Point

Topology: TRUE

Feature count: 77421

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

Type: Entity point

Count: 77421

+ 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, sewer

facilities were manually transcribed from

engineering record drawings onto PTD Library

plan/topo manuscript maps. These facilities

were then digitzed, on screen, using the

Hansen IMSARC, 6.0 application. Ever since

the completion of the sewer conversion

project, the built sanitary construction plans

are used to digitize the graphics on screen.

Process Step 2

Process description:

Metadata imported.

Data Source used

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

Process Step 3

Process description:

Metadata imported.

Data Source used

H:\MetaData_Transfer\MSDData\manhole.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: 08351200

Data Source used

J:\common\MSD\metadata_shapefiles\SewerManhole.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: 102811

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.SewerManhole" H:\Shapefiles point_smh.shp # "COMPKEY 'COMPKEY' true true false 4 Long 0 10 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,COMPKEY,-1,-1;COMPTYPE 'COMPTYPE' true true false 4 Long 0 10 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,COMPTYPE,-1,-1;UNITID 'UNITID' true true false 16 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,UNITID,-1,-1;LOC 'LOCATION' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,LOC,-1,-1;UNITTYPE 'UNITTYPE' true true false 6 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,UNITTYPE,-1,-1;INST_DATE 'INST_DATE' true true false 36 Date 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,INST_DATE,-1,-1;ASBUILT 'ASBUILT' true true false 10 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,ASBUILT,-1,-1;SERV_STATU 'SERV_STATUS' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,SERV_STATUS,-1,-1;AGENCY 'AGENCY' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,AGENCY,-1,-1;SEAL 'SEAL' true true false 4 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,SEAL,-1,-1;REC_TPNUM 'REC_TPNUM' true true false 16 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,REC_TPNUM,-1,-1;REC_TPNAME 'REC_TPNAME' true true false 30 Text 0 0 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,REC_TPNAME,-1,-1;DEPTH 'DEPTH' true true false 8 Double 8 38 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,DEPTH,-1,-1;ENABLED 'Enabled' true true true 2 Short 0 5 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,ENABLED,-1,-1;ANCILLARYR 'AncillaryRole' true true true 2 Short 0 5 ,First,#,Database Connections\Connection to lojicora1.sde\MSDDATA.Sewer\MSDDATA.SewerManhole,ANCILLARYROLE,-1,-1" # H:\Shapefiles\point_smh.shp

2 Process

Date: 20100113 Time: 114635