Name: CIP Projects

Display Field: PROJECTNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 63ee0b4a321a4fe89d2f96d00a99e5d8

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 5650816.089870423
YMin: 3617294.660724446
XMax: 5692136.2998808175
YMax: 3675722.370353386
Spatial Reference: 102675  (3417)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: DEPT
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSFSSolid
Color: [130, 130, 130, 255]
Outline:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 0
Default Label:
UniqueValueInfos:
• Value: Airport
  Label: Airport
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [166, 206, 227, 255]
  Outline:
  Style: esriSLSSolid
  Color: [166, 206, 227, 255]
  Width: 0
• Value: Budget
  Label: Budget
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [31, 120, 180, 255]
  Outline:
  Style: esriSLSSolid
  Color: [31, 120, 180, 255]
  Width: 0
• Value: CMO
  Label: City Manager's Office
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [178, 223, 138, 255]
  Outline:
  Style: esriSLSSolid
  Color: [178, 223, 138, 255]
  Width: 0
• Value: CivicCenter
  Label: Leisure Services - Civic Center Division
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [51, 160, 44, 255]
  Outline:
  Style: esriSLSSolid
  Color: [51, 160, 44, 255]
  Width: 0
• Value: Clerk
  Label: City Clerk
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [251, 154, 153, 255]
  Outline:
  Style: esriSLSSolid
  Color: [251, 154, 153, 255]
  Width: 0
• Value: ConferenceCenter
  Label: Leisure Services - Conference Center
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [227, 26, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [227, 26, 28, 255]
  Width: 0
• Value: Construction
  Label: Inspection & Construction Services
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [253, 191, 111, 255]
  Outline:
  Style: esriSLSSolid
  Color: [253, 191, 111, 255]
  Width: 0
• Value: Council
  Label: City Council
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 127, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 127, 0, 255]
  Width: 0
• Value: Economic
  Label: Economic Development
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [202, 178, 214, 255]
  Outline:
  Style: esriSLSSolid
  Color: [202, 178, 214, 255]
  Width: 0
• Value: EngMisc
  Label: Engineering - Miscellaneous
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [106, 61, 154, 255]
  Outline:
  Style: esriSLSSolid
  Color: [106, 61, 154, 255]
  Width: 0
• Value: Facility
  Label: Engineering - Facility Management
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 255, 153, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 255, 153, 255]
  Width: 0
• Value: Finance
  Label: Finance
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [177, 89, 40, 255]
  Outline:
  Style: esriSLSSolid
  Color: [177, 89, 40, 255]
  Width: 0
• Value: Fire
  Label: Fire
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [166, 206, 227, 255]
  Outline:
  Style: esriSLSSolid
  Color: [166, 206, 227, 255]
  Width: 0
• Value: Housing
  Label: Housing & Community Development
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [31, 120, 180, 255]
  Outline:
  Style: esriSLSSolid
  Color: [31, 120, 180, 255]
  Width: 0
• Value: I
  Label: Information Technology
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [178, 223, 138, 255]
  Outline:
  Style: esriSLSSolid
  Color: [178, 223, 138, 255]
  Width: 0
• Value: Library
  Label: Library
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [51, 160, 44, 255]
  Outline:
  Style: esriSLSSolid
  Color: [51, 160, 44, 255]
  Width: 0
• Value: OSPNS
  Label: Office of Shared Prosperity and Neighborhood Support
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [251, 154, 153, 255]
  Outline:
  Style: esriSLSSolid
  Color: [251, 154, 153, 255]
  Width: 0
• Value: PIO
  Label: Public Information Office
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [227, 26, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [227, 26, 28, 255]
  Width: 0
• Value: Parking
  Label: Transportation Services - Parking Division
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [253, 191, 111, 255]
  Outline:
  Style: esriSLSSolid
  Color: [253, 191, 111, 255]
  Width: 0
• Value: Parks
  Label: Leisure Services - Parks Division
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 127, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 127, 0, 255]
  Width: 0
• Value: Planning
  Label: Planning Services
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [202, 178, 214, 255]
  Outline:
  Style: esriSLSSolid
  Color: [202, 178, 214, 255]
  Width: 0
• Value: PublicWorks
  Label: Public Works
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [106, 61, 154, 255]
  Outline:
  Style: esriSLSSolid
  Color: [106, 61, 154, 255]
  Width: 0
• Value: Recreation
  Label: Leisure Services - Recreation Division
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 255, 153, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 255, 153, 255]
  Width: 0
• Value: Sanitary
  Label: Engineering - Sanitary Sewer
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [177, 89, 40, 255]
  Outline:
  Style: esriSLSSolid
  Color: [177, 89, 40, 255]
  Width: 0
• Value: Stormwater
  Label: Engineering - Stormwater
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [166, 206, 227, 255]
  Outline:
  Style: esriSLSSolid
  Color: [166, 206, 227, 255]
  Width: 0
• Value: Street
  Label: Engineering - Street
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [31, 120, 180, 255]
  Outline:
  Style: esriSLSSolid
  Color: [31, 120, 180, 255]
  Width: 0
• Value: Sustainability
  Label: Sustainability
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [178, 223, 138, 255]
  Outline:
  Style: esriSLSSolid
  Color: [178, 223, 138, 255]
  Width: 0
• Value: Traffic
  Label: Engineering - Traffic
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [51, 160, 44, 255]
  Outline:
  Style: esriSLSSolid
  Color: [51, 160, 44, 255]
  Width: 0
• Value: Transportation
  Label: Transportation Services
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [251, 154, 153, 255]
  Outline:
  Style: esriSLSSolid
  Color: [251, 154, 153, 255]
  Width: 0
• Value: WRRC
  Label: Water & Resource Recovery Center
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [227, 26, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [227, 26, 28, 255]
  Width: 0
• Value: Water
  Label: Water Department
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [253, 191, 111, 255]
  Outline:
  Style: esriSLSSolid
  Color: [253, 191, 111, 255]
  Width: 0
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 )
• PROJECTNO ( type: esriFieldTypeString, alias: Project Number, length: 30 )
• PROJECTNAME ( type: esriFieldTypeString, alias: Project Name, length: 255 )
• TOTALCOST ( type: esriFieldTypeInteger, alias: Total Cost )
• STATUS ( type: esriFieldTypeString, alias: CIP Status, length: 25 )
• DEPT ( type: esriFieldTypeString, alias: Department, length: 255 , Coded Values: [Fire: Fire] , [Parks: Leisure Services - Parks Division] , [CivicCenter: Leisure Services - Civic Center Division] , ...31 more... )
• DESCRIPTION ( type: esriFieldTypeString, alias: Project Description, length: 500 )
• FUNDSOURCE ( type: esriFieldTypeString, alias: Funding Sources, length: 500 )
• FSOURCE1 ( type: esriFieldTypeString, alias: Funding Source 1, length: 255 , Coded Values: [Unknown: Unknown] , [SalesTax20: Sales Tax Fund (20%)] , [DRA: DRA Distribution/Gaming] , ...52 more... )
• FSOURCE2 ( type: esriFieldTypeString, alias: Funding Source 2, length: 255 , Coded Values: [Unknown: Unknown] , [SalesTax20: Sales Tax Fund (20%)] , [DRA: DRA Distribution/Gaming] , ...52 more... )
• FSOURCE3 ( type: esriFieldTypeString, alias: Funding Source 3, length: 255 , Coded Values: [Unknown: Unknown] , [SalesTax20: Sales Tax Fund (20%)] , [DRA: DRA Distribution/Gaming] , ...52 more... )
• FSOURCE4 ( type: esriFieldTypeString, alias: Funding Source 4, length: 255 , Coded Values: [Unknown: Unknown] , [SalesTax20: Sales Tax Fund (20%)] , [DRA: DRA Distribution/Gaming] , ...52 more... )
• FSOURCE5 ( type: esriFieldTypeString, alias: Funding Source 5, length: 255 , Coded Values: [Unknown: Unknown] , [SalesTax20: Sales Tax Fund (20%)] , [DRA: DRA Distribution/Gaming] , ...52 more... )
• FIRSTYEAR ( type: esriFieldTypeString, alias: Year Added to CIP, length: 4 )
• OLDCIP ( type: esriFieldTypeString, alias: Old CIP Number, length: 20 )
• OLDCIP2 ( type: esriFieldTypeString, alias: Old CIP Number, length: 20 )
• OLDCIP3 ( type: esriFieldTypeString, alias: Old CIP Number, length: 20 )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Relationships:

• DUBUQUE.CIP_Budget (3) -- Related To: Budget (8)
• DUBUQUE.CIP_Expenditure (2) -- Related To: Expenditures (9)

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

  Iteminfo   Thumbnail   Metadata