MSD Completed Capital Projects
SDE Feature Class - msddata.captcomp
FGDC, ESRI Metadata
DescriptionSpatialData StructureData SourceData DistributionMetadata
+ Resource Description
Citation
Information used to reference the data.
Title: MSD Completed Capital Projects
Originators: MSD
Publication date: 11/2004
Data type: vector digital data
Data location: Server=lojicora1; Service=esri_sde; User=eweidner; Version=SDE.DEFAULT
Description
A characterization of the data, including its intended use and limitations.
Abstract: 
This layer is created in region, a feature class that contains one or more polygons to make up a project area. It shows locations of MSD capital projects that are completed in Jefferson County. The project information is extracted from capproj.projects table in ODBC data source. Countywide projects are not included in this layer.
Purpose: 
Identification of project sites within a MSD capital project.
Language of dataset: en
Point Of Contact
Contact information for the individual or organization that is knowledgeable about the data.
Person: Noriko McKinney
Organization: MSD
Phone: (502) 540-6361
Fax: (502) 540-6180
Email: Mckinney@msdlouky.org
Address type: mailing and physical address
Address: 
700 W. Liberty St.
City: Louisville
State or Province: KY
Postal code: 40203
Data Type
How the data are represented, formatted and maintained by the data producing organization.
File or table name: msddata.captcomp
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: 11/2004
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: boundaries
Keyword thesaurus: ArcIMS Metadata Server Theme Codes
Place:
Keywords: Louisville, Louisville Metro, Kentucky, 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
BoundaryCoordinate
Left 1152766.375000 (survey feet)
Right 1306428.125000 (survey feet)
Top 321027.792500 (survey feet)
Bottom 185400.781250 (survey feet)
In Unprojected coordinates (geographic)
GCS North American 1983
BoundaryCoordinate
West-85.950989 (longitude)
East-85.409113 (longitude)
North38.375751 (latitude)
South37.996815 (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.captcomp
Detailed descriptions of entity type, attributes, and attribute values for the data.
Name: msddata.captcomp
Type of object: Feature Class
Geometry type: Polygon
Number of records: 327
Attributes
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
BUDGET_ID
Definition: 
Numerical project budget id number preceded by alphabet
Alias: BUDGET_ID Type: String Width: 10 Precision: 0 Scale: 0
Attribute domain values
ValueDefinition
A 
Pond Creek Area Team
B 
Beargrass Area Team
C 
Pond Creek Area Team
E 
Floyds Fork/North County/MFWTP Area Team
F 
Floyds Fork/North County/MFWTP Area Team
G 
General/Miscellaneous
H 
Wet Weather/Water Quality Area Team (I & I portion)
I 
Wet Weather/Water Quality Area Team (CSO portion)
J 
Wet Weather/Water Quality Area Team (Water Quality portion)
K 
Equipment
PROJ_NAME
Definition: 
Name of the project
Alias: PROJ_NAME Type: String Width: 100 Precision: 0 Scale: 0
NO_PROP
Definition: 
Number of properties to be connected to the sewer by the project.
Alias: NO_PROP Type: Integer Width: 4 Precision: 6 Scale: 0
SERV_AREA
Definition: 
The Treatment Plant that provides the sewer service for the project.
Alias: SERV_AREA Type: String Width: 25 Precision: 0 Scale: 0
Attribute domain values
ValueDefinition
Cedar Creek WTP (definition not provided)
Floyds Fork WTP (definition not provided)
Hite Creek WTP (definition not provided)
Jeffersontown WTP (definition not provided)
Morris Forman WTP (definition not provided)
Not Applicable (definition not provided)
Prospect (definition not provided)
West County WTP (definition not provided)
PROJ_TYPE
Definition: 
Type of Project
Alias: PROJ_TYPE Type: String Width: 25 Precision: 0 Scale: 0
PROJ_CAT
Definition: 
Project Category
Alias: PROJ_CAT Type: String Width: 20 Precision: 0 Scale: 0
CONTACT
Definition: 
MSD Contact Person
Alias: CONTACT Type: String Width: 40 Precision: 0 Scale: 0
PRJSTAT
Definition: 
Current project status
Alias: PRJSTAT Type: String Width: 40 Precision: 0 Scale: 0
PLAN
Definition: 
Indicates if the project is in or out of the 5  year plan. 0 indicates project out of area, 5 indicates within the 5 year plan.
Alias: PLAN Type: SmallInteger Width: 2 Precision: 1 Scale: 0
TYPE
Definition: 
Project Type
Alias: TYPE Type: SmallInteger Width: 2 Precision: 1 Scale: 0
PROJ_DEP
Definition: 
Project dependency.  Conditions that must be fulfilled before the sanitary sewer project can be activated.
Alias: PROJ_DEP Type: String Width: 40 Precision: 0 Scale: 0
ESTCOST
Definition: 
Estimated Capital Project Cost
Alias: ESTCOST Type: Double Width: 8 Precision: 38 Scale: 8
PROJST_DATE
Definition: 
Project Status Date
Alias: PROJST_DATE Type: String Width: 10 Precision: 0 Scale: 0
PRJSTQTR
Definition: 
The quarter of a year the construction is scheduled to complete
Alias: PRJSTQTR Type: String Width: 15 Precision: 0 Scale: 0
PRJSTYR
Definition: 
The year the construction is schduled to complete
Alias: PRJSTYR Type: String Width: 4 Precision: 0 Scale: 0
PROJEND_DATE
Definition: 
Project End Date
Alias: PROJEND_DATE Type: String Width: 10 Precision: 0 Scale: 0
PLANENDQTR
Definition: 
The quarter of a year the design and planning are scheduled
Alias: PLANENDQTR Type: String Width: 15 Precision: 0 Scale: 0
PLANENDYR
Definition: 
The year the design and planning are scheduled to complete
Alias: PLANENDYR Type: String Width: 4 Precision: 0 Scale: 0
ESMTENDQTR
Definition: 
The quarter of a year the easement acuisition is schduled to complete
Alias: ESMTENDQTR Type: String Width: 15 Precision: 0 Scale: 0
ESMTENDYR
Definition: 
The year the easement acquistion is scheduled to complete
Alias: ESMTENDYR Type: String Width: 4 Precision: 0 Scale: 0
BID_QTR
Definition: 
The quarter of a year the bid is scheduled
Alias: BID_QTR Type: String Width: 15 Precision: 0 Scale: 0
BID_YR
Definition: 
The year the bid is scheduled
Alias: BID_YR Type: String Width: 4 Precision: 0 Scale: 0
CONST_QTR
Definition: 
The quarter of a year the construction is scheduled to complete
Alias: CONST_QTR Type: String Width: 15 Precision: 0 Scale: 0
CONST_YR
Definition: 
The year the construction is scheduled to complete
Alias: CONST_YR Type: String Width: 4 Precision: 0 Scale: 0
AREATEAM
Definition: 
Name of the Areateam
Alias: AREATEAM Type: String Width: 30 Precision: 0 Scale: 0
DATE_CLOSED
Alias: DATE_CLOSED Type: Date Width: 36 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
SHAPE.AREA
Alias: SHAPE.AREA Type: Double Width: 0 Precision: 0 Scale: 0
SHAPE.LEN
Alias: SHAPE.LEN Type: Double Width: 0 Precision: 0 Scale: 0
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.captcomp
ESRI feature type: Simple
Geometry type: Polygon
Topology: FALSE
Feature count: 327
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.captcomp
Type: G-polygon
Count: 327
+ 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: 
Each project site in this layer is transferred from the capital project layer  captsan  which contains common item field Budget ID number
Process Step 2
Process description: 
Metadata imported.
Data Source used
H:\data\lojic\metadata\jeff\MSDDATA_captcomp.xml
Process Step 3
Process description: 
Dataset copied.
Data Source used
Server=lojicora1; Service=esri_sde; User=msddata; Version=SDE.DEFAULT
ESRI geoprocessing history
Description of ESRI geoprocessing commands, settings, and tolerances applied to the data.
ESRI geoprocessing command information
1 Create Feature Class
Date: 20050203 Time: 090941
Tool location: C:\Program Files\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\CreateFeatureclass
Command issued: CreateFeatureclass "Database Connections\lojicora1.msddata.sde" captcomp # region_Layer SAME_AS_TEMPLATE SAME_AS_TEMPLATE "PROJCS['NAD_1983_StatePlane_Kentucky_North_FIPS_1601_Feet',GEOGCS['GCS_North_American_1983',DATUM['D_North_American_1983',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Lambert_Conformal_Conic'],PARAMETER['False_Easting',1640416.666666667],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-84.25],PARAMETER['Standard_Parallel_1',37.96666666666667],PARAMETER['Standard_Parallel_2',38.96666666666667],PARAMETER['Latitude_Of_Origin',37.5],UNIT['Foot_US',0.3048006096012192]];-179204.923381 -1155587.886514 762.166501;0.000000 100000.000000;0.000000 100000.000000" # 0 0 0 "Database Connections\lojicora1.msddata.sde\MSDDATA.captcomp"
2 Append
Date: 20050203 Time: 090952
Tool location: C:\Program Files\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\Append
Command issued: Append region_Layer "Database Connections\lojicora1.msddata.sde\MSDDATA.captcomp" TEST "Database Connections\lojicora1.msddata.sde\MSDDATA.captcomp"
3 FeatureClassToFeatureClass_1
Date: 20050203 Time: 090958
Tool location: C:\Program Files\ArcGIS\ArcToolbox\Toolboxes\Conversion Tools.tbx\FeatureClassToFeatureClass
Command issued: FeatureClassToFeatureClass R:\msddata\captcomp\region.complete "Database Connections\lojicora1.msddata.sde" captcomp # "AREA AREA HIDDEN;PERIMETER PERIMETER HIDDEN;COMPLETE# COMPLETE_ HIDDEN;COMPLETE-ID COMPLETE_ID HIDDEN;BUDGET_ID BUDGET_ID VISIBLE;PROJ_NAME PROJ_NAME VISIBLE;NO_PROP NO_PROP VISIBLE;SERV_AREA SERV_AREA VISIBLE;PROJ_TYPE PROJ_TYPE VISIBLE;PROJ_CAT PROJ_CAT VISIBLE;CONTACT CONTACT VISIBLE;PRJSTAT PRJSTAT VISIBLE;PLAN PLAN VISIBLE;TYPE TYPE VISIBLE;PROJ_DEP PROJ_DEP VISIBLE;ESTCOST ESTCOST VISIBLE;PROJST_DATE PROJST_DATE VISIBLE;PRJSTQTR PRJSTQTR VISIBLE;PRJSTYR PRJSTYR VISIBLE;PROJEND_DATE PROJEND_DATE VISIBLE;PLANENDQTR PLANENDQTR VISIBLE;PLANENDYR PLANENDYR VISIBLE;ESMTENDQTR ESMTENDQTR VISIBLE;ESMTENDYR ESMTENDYR VISIBLE;BID_QTR BID_QTR VISIBLE;BID_YR BID_YR VISIBLE;CONST_QTR CONST_QTR VISIBLE;CONST_YR CONST_YR VISIBLE;AREATEAM AREATEAM VISIBLE;DATE_CLOSED DATE_CLOSED VISIBLE" SAME_AS_TEMPLATE SAME_AS_TEMPLATE # 0 "Database Connections\lojicora1.msddata.sde\MSDDATA.captcomp"
4 ChangePrivileges_6
Date: 20061213 Time: 074400
Tool location: C:\Program Files\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\ChangePrivileges
Command issued: ChangePrivileges "Database Connections\p_msddata.sde\MSDDATA.captcomp" LOJIC_ROLE GRANT # "Database Connections\p_msddata.sde\MSDDATA.captcomp"
5 Process
Date: 20080531 Time: 172429
Tool location: C:\Program Files (x86)\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpgradeSpatialReference
Command issued: UpgradeSpatialReference "Database Connections/pl_MSDDATA.sde/msddata.captcomp" 0.00125 0.025 0.025 "Database Connections/pl_MSDDATA.sde/msddata.captcomp"
6 Process
Date: 20080811 Time: 113432
Tool location: C:\Program Files (x86)\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\Analyze
Command issued: Analyze "Database Connections/pl_msddata.sde\msddata.captcomp_1" BUSINESS;FEATURE "Database Connections/pl_msddata.sde\msddata.captcomp_1"
7 Process
Date: 20080811 Time: 124746
Tool location: C:\Program Files (x86)\ArcGIS\ArcToolbox\Toolboxes\Data Management Tools.tbx\ChangePrivileges
Command issued: ChangePrivileges "Database Connections/pl_msddata.sde\msddata.captcomp" LOJIC_ROLE GRANT # "Database Connections/pl_msddata.sde\msddata.captcomp"
+ Data Distribution Information
General
Description of the data known by the party from whom the data may be obtained, liability of party distributing data, and technical capabilities required to use the data.
Resource description: 
Downloadable Data
+ Metadata Reference
Metadata Date
Dates associated with creating, updating and reviewing the metadata.
Last updated: 20100405
Language of metadata: en
Metadata Point of Contact
Contact information for the individual or organization responsible for the metadata information.
Organization: LOJIC
Person: Jeff Ackerman
Phone: (502) 540-6372
Fax: (502) 540-6499
Email: ackerman@lojic.org
Address type: mailing and physical address
Address: 
700 West Liberty St.
City: Louisville
State or Province: Kentucky
Postal code: 40203
Metadata Standards
Description of the metadata standard used to document the data and reference to any additional extended profiles to the standard used by the metadata producer.
Standard name: FGDC Content Standards for Digital Geospatial Metadata
Standard version: FGDC-STD-001-1998
Time convention: local time
Metadata profiles defining additonal information:
Profile: ESRI Metadata Profile
Online linkage: http://www.esri.com/metadata/esriprof80.html
FGDC Plus Metadata Stylesheet
Stylesheet: FGDC Plus Stylesheet
File name: FGDC Plus.xsl
Version: 2.2
Description: This metadata is displayed using the FGDC Plus Stylesheet, which is an XSL template that can be used with ArcGIS software to display metadata. It displays metadata elements defined in the Content Standard for Digital Geospatial Metadata (CSDGM) - aka FGDC Standard, the ESRI Profile of CSDGM, the Biological Data Profile of CSDGM, and the Shoreline Data Profile of CSDGM. CSDGM is the US Federal Metadata standard. The Federal Geographic Data Committee originally adopted the CSDGM in 1994 and revised it in 1998. According to Executive Order 12096 all Federal agencies are ordered to use this standard to document geospatial data created as of January, 1995. The standard is often referred to as the FGDC Metadata Standard and has been implemented beyond the federal level with State and local governments adopting the metadata standard as well. The Biological Data Profile broadens the application of the CSDGM so that it is more easily applied to biological data that are not explicitly geographic (laboratory results, field notes, specimen collections, research reports) but can be associated with a geographic location. Includes taxonomical vocabulary. The Shoreline Data Profile addresses variability in the definition and mapping of shorelines by providing a standardized set of terms and data elements required to support metadata for shoreline and coastal data sets. The FGDC Plus Stylesheet includes the Dublin Core Metadata Element Set. It supports W3C DOM compatible browsers such as IE7, IE6, Netscape 7, and Mozilla Firefox. It is in the public domain and may be freely used, modified, and redistributed. It is provided "AS-IS" without warranty or technical support.
Instructions: On the top of the page, click on the title of the dataset to toggle opening and closing of all metadata content sections or click section links listed horizontally below the title to open individual sections. Click on a section name (e.g. Description) to open and close section content. Within a section, click on a item name (Status, Key Words, etc.) to open and close individual content items. By default, the Citation information within the Description section is always open for display.
Download: FGDC Plus Stylesheet is available from the ArcScripts downloads at www.esri.com.
Federal Geographic Data Committee