Name: Proposed Public Improvement Projects

Display Field: PROJNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: A polygon that represents an overview of the CIP project.

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 520319.201447055
YMin: -5966606.93789993
XMax: 2.57932621922054E7
YMax: 253268.115763396
Spatial Reference: PROJCS["Dakota - county coordinates - english",GEOGCS["Dakota - county coordinates - english",DATUM["",SPHEROID["",6378421.989,298.2572133677354]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",499999.999998],PARAMETER["False_Northing",99999.9999996],PARAMETER["Central_Meridian",-93.31666666666666],PARAMETER["Standard_Parallel_1",44.51666666666667],PARAMETER["Standard_Parallel_2",44.91666666666666],PARAMETER["Latitude_Of_Origin",44.47194444444445],UNIT["Foot_US",0.3048006096012192]]

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [245, 202, 122, 255]
Outline:
Style: esriSLSSolid
Color: [240, 135, 14, 255]
Width: 2
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LOCATION ( type: esriFieldTypeString, alias: Location, length: 255 )
• PublicNotice ( type: esriFieldTypeString, alias: Public Notice, length: 255 )
• Link ( type: esriFieldTypeString, alias: Important Public Link, length: 255 )
• HyperlinkToProject ( type: esriFieldTypeString, alias: Hyperlink To Project, length: 256 )
• HyperlinkToContract ( type: esriFieldTypeString, alias: Hyperlink To Contract, length: 256 )
• WORKSTATUS ( type: esriFieldTypeString, alias: Project Status, length: 50 , Coded Values: [Pending: Pending] , [UnderConstruction: Under Construction] , [SubstantiallyComplete: Substantially Complete] , ...3 more... )
• CHARGECODE ( type: esriFieldTypeString, alias: Charge Code, length: 10 )
• ASSIGNEDTO ( type: esriFieldTypeString, alias: Assigned To, length: 50 )
• SUPERVISOR ( type: esriFieldTypeString, alias: Supervisor, length: 50 )
• PLANSTART ( type: esriFieldTypeDate, alias: Planned Start, length: 8 )
• PLANEND ( type: esriFieldTypeDate, alias: Planned End, length: 8 )
• ACTSTART ( type: esriFieldTypeDate, alias: Actual Start, length: 8 )
• ACTEND ( type: esriFieldTypeDate, alias: Actual End, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, length: 50 )
• ContractNumber ( type: esriFieldTypeString, alias: ContractNumber, length: 50 )
• CIP_Year ( type: esriFieldTypeString, alias: CIP/Funding Year, length: 50 )
• CIP_Maint ( type: esriFieldTypeString, alias: Project Type, length: 50 , Coded Values: [General Maintenance: General Maintenance] , [Sealcoat: Sealcoat] , [New: New] , ...15 more... )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 1000 )
• CIPSTAT ( type: esriFieldTypeString, alias: CIP/Project Status, length: 50 , Coded Values: [Proposed: Proposed] , [Completed: Completed] , [Approved: Approved] , ...7 more... )
• X_BSMT ( type: esriFieldTypeString, alias: Basement Status, length: 254 , Coded Values: [In Basement: In Basement] , [Scanned: Scanned] , [Scanned & Purged: Scanned & Purged] , ...7 more... )
• ImprovementType ( type: esriFieldTypeString, alias: Improvement Type, length: 50 , Coded Values: [Street: Street] , [Trail: Trail] , [Sanitary FO: Sanitary FO] , ...15 more... )
• PlanType ( type: esriFieldTypeString, alias: Plan Type, length: 50 , Coded Values: [Record Plans: Record Plans] , [Construction Plans: Construction Plans] )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• RecordPlan ( type: esriFieldTypeString, alias: Record Plan, length: 50 )
• PublicHearingDate ( type: esriFieldTypeDate, alias: Public Hearing Date, length: 8 )
• FinalAcceptance ( type: esriFieldTypeDate, alias: Final Acceptance Date, length: 8 )
• AssessmentHearing ( type: esriFieldTypeDate, alias: Assessment Hearing Date, length: 8 )
• PublicEntity ( type: esriFieldTypeString, alias: Public Entity, length: 50 , Coded Values: [City of Eagan: City of Eagan] , [Dakota County: Dakota County] , [State of Minnesota: State of Minnesota] , ...14 more... )
• EngineeringFirm ( type: esriFieldTypeString, alias: Engineering Firm(s), length: 200 )
• Tech_BidDate ( type: esriFieldTypeDate, alias: Tech/BidDate, length: 8 )
• ContractNumber2 ( type: esriFieldTypeString, alias: Contract Number 2, length: 50 )
• ContractNumber3 ( type: esriFieldTypeString, alias: Contract Number 3, length: 50 )
• JPA ( type: esriFieldTypeSmallInteger, alias: JPA Y or N , Coded Values: [1: Yes] , [0: No] )
• JPADocumentation ( type: esriFieldTypeString, alias: JPA Documentation, length: 200 )
• NeighborhoodMeeting ( type: esriFieldTypeDate, alias: NeighborhoodMeeting, length: 8 )
• OtherEntityProjectNumber ( type: esriFieldTypeString, alias: OtherEntityProjectNumber, length: 50 )
• SHAPE.STArea() ( type: esriFieldTypeDouble, alias: SHAPE.STArea() )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• Rotation ( type: esriFieldTypeInteger, alias: Rotation )
• ProjName ( type: esriFieldTypeString, alias: Project Name, length: 255 )
• PublicHearingComments ( type: esriFieldTypeString, alias: Public Hearing Comments, length: 150 , Coded Values: [N/A: N/A] , [TBD: TBD] )
• FinalAcceptanceComments ( type: esriFieldTypeString, alias: Final Acceptance Comments, length: 150 , Coded Values: [N/A: N/A] , [TBD: TBD] )
• AssessmentHearingComments ( type: esriFieldTypeString, alias: Assessment Hearing Comments, length: 150 , Coded Values: [N/A: N/A] , [TBD: TBD] )
• NeighborhoodMeetingComments ( type: esriFieldTypeString, alias: Neighborhood Meeting Comments, length: 150 , Coded Values: [N/A: N/A] , [TBD: TBD] )
• VideoLink ( type: esriFieldTypeString, alias: VideoLink, length: 200 )
• WebsiteProjectSpecificLink ( type: esriFieldTypeString, alias: WebsiteProjectSpecificLink, length: 200 )
• WebsiteProjectGenericLink ( type: esriFieldTypeString, alias: WebsiteProjectGenericLink, length: 200 )
• ProjectContact ( type: esriFieldTypeString, alias: ProjectContact, length: 50 )
• ProjectDetails ( type: esriFieldTypeString, alias: ProjectDetails, length: 3000 )
• PublicViewing ( type: esriFieldTypeString, alias: PublicViewing, length: 50 , Coded Values: [N: No] , [Y: Yes] , [NA: N/A] )
• CurrentConstructionURL ( type: esriFieldTypeString, alias: CurrentConstructionURL, length: 255 )
• PlanITID ( type: esriFieldTypeString, alias: PlanITID, length: 50 )
• GISStatus ( type: esriFieldTypeString, alias: GISStatus, length: 50 )
• PlanStatus ( type: esriFieldTypeString, alias: PlanStatus, length: 50 )
• FeasibilityReportApprovalDate ( type: esriFieldTypeDate, alias: FeasibilityReportApprovalDate, length: 8 )
• ChangeOrder ( type: esriFieldTypeDate, alias: ChangeOrder, length: 8 )
• FinalPaymentDate ( type: esriFieldTypeDate, alias: FinalPaymentDate, length: 8 )
• FinalAssessmentReportDate ( type: esriFieldTypeDate, alias: FinalAssessmentReportDate, length: 8 )
• FinalAssessmentPublicHearingDat ( type: esriFieldTypeDate, alias: FinalAssessmentPublicHearingDate, length: 8 )
• JPADate ( type: esriFieldTypeDate, alias: JPADate, length: 8 )
• ContractAwardDate ( type: esriFieldTypeDate, alias: ContractAwardDate, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 150 )
• MS4Inspection ( type: esriFieldTypeString, alias: MS4Inspection, length: 50 , Coded Values: [Y: Yes] , [N: No] , [UNK: Unknown] )
• EngineeringInspection ( type: esriFieldTypeString, alias: EngineeringInspection, length: 50 , Coded Values: [Y: Yes] , [N: No] , [UNK: Unknown] )
• PrvBuildingPermit ( type: esriFieldTypeString, alias: PrvBuildingPermit, length: 250 )
• PrvSWPermit ( type: esriFieldTypeString, alias: PrvSWPermit, length: 250 )
• PrvDevelopementNumber ( type: esriFieldTypeString, alias: PRVDevelopementNumber, length: 250 )
• PrvErosionControlPermitNumber ( type: esriFieldTypeString, alias: PrvErosionControlPermitNumber, length: 250 )
• PrvJNumber ( type: esriFieldTypeString, alias: PrvJNumber, length: 50 )
• PrvProjectType ( type: esriFieldTypeString, alias: PrvProjectType, length: 50 )
• GeometryUpdateNeeded ( type: esriFieldTypeString, alias: GeometryUpdateNeeded, length: 50 )
• GeometryUpdateComments ( type: esriFieldTypeString, alias: GeometryUpdateComments, length: 1000 )
• DelayedOnHoldComment ( type: esriFieldTypeString, alias: DelayedOnHoldComment, length: 300 )
• AssignedOther ( type: esriFieldTypeString, alias: AssignedOther, length: 50 )
• MS4Inspector ( type: esriFieldTypeString, alias: MS4Inspector, length: 50 )
• UtilConnectInspection ( type: esriFieldTypeString, alias: UtilConnectInspection, length: 50 )
• UtilityInspector ( type: esriFieldTypeString, alias: UtilityInspector, length: 50 )
• REFCalc ( type: esriFieldTypeString, alias: REFCalc, length: 50 )
• REFCalculator ( type: esriFieldTypeString, alias: REFCalculator, length: 50 )
• FeasibilityReportAttachment ( type: esriFieldTypeString, alias: FeasibilityReportAttachment, length: 200 )
• FinalAssessmentReportAttachment ( type: esriFieldTypeString, alias: FinalAssessmentReportAttachment, length: 200 )
• PlansAndSpecificationsDate ( type: esriFieldTypeDate, alias: PlansAndSpecificationsDate, length: 8 )
• PandSAttachments ( type: esriFieldTypeString, alias: PandSAttachments, length: 200 )
• BidAttachments ( type: esriFieldTypeString, alias: BidAttachments, length: 200 )
• ContractAwardAttachment ( type: esriFieldTypeString, alias: ContractAwardAttachment, length: 200 )
• HasDrainageEasement ( type: esriFieldTypeString, alias: HasDrainageEasement, length: 50 )
• DrainageEasement ( type: esriFieldTypeString, alias: DrainageEasement, length: 200 )
• HasConservationEasement ( type: esriFieldTypeString, alias: HasConservationEasement, length: 50 )
• ConservationEasement ( type: esriFieldTypeString, alias: ConservationEasement, length: 200 )
• HasMaintAgreement ( type: esriFieldTypeString, alias: HasMaintAgreement, length: 50 )
• MaintenanceAgreement ( type: esriFieldTypeString, alias: MaintenanceAgreement, length: 200 )
• HasOtherLegalDoc ( type: esriFieldTypeString, alias: HasOtherLegalDoc, length: 50 )
• OtherLegalDoc ( type: esriFieldTypeString, alias: OtherLegalDoc, length: 200 )
• ChangeOrder1Date ( type: esriFieldTypeDate, alias: ChangeOrder1Date, length: 8 )
• CO1Attachment ( type: esriFieldTypeString, alias: COAttachment, length: 200 )
• ChangeOrder2Date ( type: esriFieldTypeDate, alias: ChangeOrder2Date, length: 8 )
• CO2Attachment ( type: esriFieldTypeString, alias: CO2Attachment, length: 200 )
• ChangeOrder3Date ( type: esriFieldTypeDate, alias: ChangeOrder3Date, length: 8 )
• CO3Attachment ( type: esriFieldTypeString, alias: CO3Attachment, length: 200 )
• ChangeOrder4Date ( type: esriFieldTypeDate, alias: ChangeOrder4Date, length: 8 )
• CO4Attachment ( type: esriFieldTypeString, alias: CO4Attachment, length: 200 )
• ChangeOrder5Date ( type: esriFieldTypeDate, alias: ChangeOrder4Date, length: 8 )
• CO5Attachment ( type: esriFieldTypeString, alias: CO5Attachment, length: 200 )
• MatrixViewing ( type: esriFieldTypeString, alias: MatrixViewing, length: 25 , Coded Values: [Public: Public] , [Private: Private] , [No: No] )
• UniqueProjectID ( type: esriFieldTypeString, alias: UniqueProjectID, length: 50 )
• EngFirmOther ( type: esriFieldTypeString, alias: EngineeringFirmOther, length: 50 )
• Technical_Date ( type: esriFieldTypeDate, alias: TechnicalDate, length: 8 )
• TechnicalProposalAttachment ( type: esriFieldTypeString, alias: TechnicalProposalAttachment, length: 300 )
• PreBidMtg ( type: esriFieldTypeDate, alias: PreBidMtg, length: 8 )
• PreCon ( type: esriFieldTypeDate, alias: PreCon, length: 8 )
• FinalAssessmentNeighHearingDat ( type: esriFieldTypeDate, alias: FinalAssessmentNeighHearingDat, length: 8 )
• PlattedEasements ( type: esriFieldTypeString, alias: PlattedEasements, length: 50 )
• RecordedDocs ( type: esriFieldTypeString, alias: RecordedDocs, length: 50 )
• OtherRecordedDocs ( type: esriFieldTypeString, alias: OtherRecordedDocs, length: 50 )
• JPAInfo ( type: esriFieldTypeString, alias: JPA Info, length: 300 )
• WarrantyBond ( type: esriFieldTypeString, alias: WarantyBond, length: 50 )
• BondStart ( type: esriFieldTypeDate, alias: BondStart, length: 8 )
• BondEnd ( type: esriFieldTypeDate, alias: BondEnd, length: 8 )
• ExternalContactName ( type: esriFieldTypeString, alias: ExternalContactName, length: 50 )
• ExternalContactPhNumber ( type: esriFieldTypeString, alias: ExternalContactPhNumber, length: 50 )
• ExternalContactNotes ( type: esriFieldTypeString, alias: ExternalContactNotes, length: 300 )
• PrvProjectTypeOther ( type: esriFieldTypeString, alias: PrvProjectTypeOther, length: 50 )
• CertofOccupancy ( type: esriFieldTypeDate, alias: CertofOccupancy, length: 8 )
• LetterofOccupancy ( type: esriFieldTypeString, alias: LetterofOccupancy, length: 50 )
• LOCStart ( type: esriFieldTypeDate, alias: LOCStart, length: 8 )
• LOCEnd ( type: esriFieldTypeDate, alias: LOCEnd, length: 8 )
• PrvGradingPermit ( type: esriFieldTypeString, alias: PrvGradingPermit, length: 250 )
• InitialSMPInspection ( type: esriFieldTypeString, alias: InitialSMPInspection, length: 50 , Coded Values: [No: No] , [NoGo: No Go] , [Good: Good] , ...1 more... )
• FinalSMPInspection ( type: esriFieldTypeString, alias: FinalSMPInspection, length: 50 , Coded Values: [No: No] , [NoGo: No Go] , [Good: Good] , ...1 more... )
• BidDateTimeText ( type: esriFieldTypeString, alias: BidDateTimeText, length: 100 )
• GeometryOwner ( type: esriFieldTypeString, alias: GeometryOwner, length: 1000 )
• Assessable ( type: esriFieldTypeString, alias: Assessable, length: 50 , Coded Values: [N: No] , [Y: Yes] , [NA: N/A] )
• TOTCOST ( type: esriFieldTypeDouble, alias: TOTCOST )
• ProjectStatus ( type: esriFieldTypeString, alias: ProjectStatus, length: 1000 , Coded Values: [ApprovedInCIP: Approved In CIP] , [Active: Active] , [CompleteOpen: Complete-Open] , ...4 more... )
• PRJMAN ( type: esriFieldTypeString, alias: PRJMAN, length: 1000 )
• ProjectOwnerAgencyLiason ( type: esriFieldTypeString, alias: ProjectOwnerAgencyLiason, length: 1000 )
• Lifecycle ( type: esriFieldTypeString, alias: Lifecycle, length: 1000 )
• DataProcessingNotes ( type: esriFieldTypeString, alias: DataProcessingNotes, length: 1000 )
• Capitalized ( type: esriFieldTypeString, alias: Capitalized, length: 25 , Coded Values: [N: No] , [Y: Yes] , [NA: N/A] )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata