Relationship Classes

Domains

CapitalImprovementPlan - Layer

Name	CapitalImprovementPlan
ShapeType	Point
FeatureType	Simple
AliasName	Capital Improvement Plan
HasM	false
HasZ	false
HasAttachments	false

Description

The short range plan that identifies capital projects and equipment purchases, provides a planning schedule and identifies options for financing the plan.

Field	DataType	Length	AliasName	Description	Domain	DefaultValue	IsNullable	Precision	Scale
PROJID	String	50	Project Identifier	Unique project identifier			true
PROJNAME	String	255	Project Name	The name of the project			true
PROJDESC	String	1000	Description	A detailed description of the project			true
PROJTYPE	String	50	Project Type	The type of project			true
FISCALYR	String	10	Fiscal Year	The fiscal year the project is planned for			true
FUNDSOURCE	String	50	Funding Source	The funding source for the project			true
ESTCOST	Double	8	Estimated Cost	The total estimated cost for the project			true
POCNAME	String	255	Contact Name	The name of the individual responsible for the project			true
POCPHONE	String	12	Contact Phone	The phone number for the individual responsible for the project			true
POCEMAIL	String	255	Contact Email	The email address for the individual responsible for the project			true
NUMVOTES	Integer	4	Number of Votes	The total number of votes accumulated			true
GlobalID	GlobalID	38	GlobalID	GlobalID			false

ExternalAgencyProject - Layer

Name	ExternalAgencyProject
ShapeType	Polygon
FeatureType	Simple
AliasName	External Agency Projects
HasM	false
HasZ	false
HasAttachments	false

Description

Capital projects planned by external agencies or private utilities.

Field	DataType	Length	AliasName	Description	Domain	DefaultValue	IsNullable	Precision	Scale
AGENCY	String	255	Company or Agency	The agency responsible for the project			true
PROJNAME	String	255	Project Name	The name of the project			true
PROJDESC	String	1000	Description	A detailed description of the project			true
PLANSTART	Date	8	Planned Start Date	Planned start date/time			true
PLANEND	Date	8	Planned End Date	Planned end date/time			true
POCNAME	String	255	Contact Name	The name of the individual responsible for the project			true
POCPHONE	String	12	Contact Phone	The phone number for the individual responsible for the project			true
POCEMAIL	String	255	Contact Email	The email address for the individual responsible for the project			true

InfrastructureProject - Layer

Name	InfrastructureProject
ShapeType	Polygon
FeatureType	Simple
AliasName	Infrastructure Projects
HasM	false
HasZ	false
HasAttachments	false

Description

Infrastructure projects identified by respective managers and engineers responsible for the maintenance and improvement of public infrastructure.

Field	DataType	Length	AliasName	Description	Domain	DefaultValue	IsNullable	Precision	Scale
PROJID	String	50	Project Identifier	Unique project identifier			true
PROJNAME	String	255	Project Name	The name of the project			false
PROJDESC	String	1000	Description	A detailed description of the project			false
RATIONALE	String	1000	Rationale	A description of the project rationale			true
PROJTYPE	String	50	Project Type	The type of project	piProjectType		false
SAFETY	String	5	Health and Safety	A flag used to indicate whether the project will address health and safety concerns	YesNo	No	true
MANDATE	String	5	Mandate	A flag used to indicate whether the project will address a mandate	YesNo	No	true
REPAIR	String	5	Repair or Maintenance	A flag used to indicate whether the project will prevent infrastructure deterioation	YesNo	No	true
REPLACE	String	5	Replacement	A flag used to indicate whether the project will correct a problem with existing infrastructure	YesNo	No	true
EXPAND	String	5	Expansion	A flag used to indicate whether the project will increase service capacity or meet service demands	YesNo	No	true
EFFICIENT	String	5	Efficiency	A flag used to indicate whether the project will increase the efficiency of existing infrastructure	YesNo	No	true
FISCALYR	String	10	Fiscal Year	The fiscal year the project is planned for			false
FUNDSOURCE	String	50	Funding Source	The funding source for the project	piProjectFundSource		false
PLANSTART	Date	8	Planned Start Date	Planned start date/time			true
PLANEND	Date	8	Planned End Date	Planned end date/time			true
ESTCOST	Double	8	Estimated Cost	The total estimated cost for the project			true
POCNAME	String	255	Contact Name	The name of the individual responsible for the project			false
POCPHONE	String	12	Contact Phone	The phone number for the individual responsible for the project			true
POCEMAIL	String	255	Contact Email	The email address for the individual responsible for the project			true
PROJSTATUS	String	50	Project Status	The current status of the project during the planning phase	piProjectPlanStatus		true
FUNDED	String	5	Funded Project	A flag used to indicate whether the project has been funded by governing body	YesNo	No	true
PROJPHASE	String	255	Project Phase	The construction phase the infrastructure project is in	piProjectPhase		true
ACTSTART	Date	8	Actual Start Date	Actual start date/time			true
ACTEND	Date	8	Actual End Date	Actual end date/time			true
ACTCOST	Double	8	Actual Cost	The actual cost of the project			true
STATUS	String	1000	Status	A general description of the project status			true
DOCPATH	String	255	Document Path	A URL or path to the document			true
GlobalID	GlobalID	38	GlobalID	GlobalID			false

PavementMoratorium - Layer

Name	PavementMoratorium
ShapeType	Polyline
FeatureType	Simple
AliasName	PavementMoratorium
HasM	false
HasZ	false
HasAttachments	false

Description

Moratoriums issued on newly paved streets that preclude, or greatly restrict, trench cuts or other right-of-way activity.

Field	DataType	Length	AliasName	Description	Domain	DefaultValue	IsNullable	Precision	Scale
AGENCY	String	255	Issued By	The agency that issued the pavement moratorium			true
ACTSTART	Date	8	Start Date	Actual start date/time			true
ACTEND	Date	8	End Date	Actual end date/time			true

PlanComment - Table

ProjectComment - Table

PlanHasComments - RelationshipClass

ProjectHasComments - RelationshipClass

piProjectFundSource - Domain

DomainName	piProjectFundSource
Description	The funding source for the capital improvement project
FieldType	String
Domain Type	CodedValue

Code	Name
Capital Fund	Capital Fund
Connection Fee	Connection Fee
General Fund	General Fund
Grant	Grant
Impact Fee	Impact Fee
Revenue Bond	Revenue Bond
Special Fund	Special Fund
Special Tax	Special Tax
System Revenue	System Revenue
Other	Other

piProjectPhase - Domain

DomainName	piProjectPhase
Description	The construction phase the infrastructure project is in
FieldType	String
Domain Type	CodedValue

Code	Name
PreDesign	PreDesign
Design	Design
Construction	Construction
Closeout	Closeout

piProjectPlanStatus - Domain

DomainName	piProjectPlanStatus
Description	The current status of the project during the planning phase
FieldType	String
Domain Type	CodedValue

Code	Name
Project Initiation	Project Initiation
Analysis and Review	Analysis and Review
Executive Approval	Executive Approval
Board Authorized	Board Authorized

piProjectType - Domain

DomainName	piProjectType
Description	The type of capital improvement project
FieldType	String
Domain Type	CodedValue

Code	Name
Facilities	Facilities
Parks	Parks
Sewer Collection	Sewer Collection
Stormwater Drainage	Stormwater Drainage
Transportation	Transportation
Water Distribution	Water Distribution
Other	Other

YesNo - Domain

DomainName	YesNo
Description	A yes/no indicator
FieldType	String
Domain Type	CodedValue

Code	Name
Yes	Yes
No	No