Name: Infrastructure Projects

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.31607184167E7
YMin: 4053056.4651999995
XMax: -1.3155579632100001E7
YMax: 4058767.744400002
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: projectclass
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: One-Time
  Label: One-Time
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 211, 127, 255]
  Outline:
  Style: esriSLSSolid
  Color: [168, 112, 0, 255]
  Width: 1
• Value: Reoccurring
  Label: Reoccurring
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [102, 205, 171, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 115, 76, 255]
  Width: 1
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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• projname ( type: esriFieldTypeString, alias: Project Name, length: 255 )
• projdesc ( type: esriFieldTypeString, alias: Description, length: 1000 )
• projtype ( type: esriFieldTypeString, alias: Project Type, length: 50 , Coded Values: [Facilities: Facilities] , [Parks: Parks] , [Sewer Collection: Sewer Collection] , ...7 more... )
• safety ( type: esriFieldTypeString, alias: Health and Safety, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• mandate ( type: esriFieldTypeString, alias: Mandate, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• repair ( type: esriFieldTypeString, alias: Repair or Maintenance, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• replace ( type: esriFieldTypeString, alias: Replacement, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• expand ( type: esriFieldTypeString, alias: Expansion, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• efficient ( type: esriFieldTypeString, alias: Efficiency, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• fiscalyr ( type: esriFieldTypeString, alias: Fiscal Year, length: 10 , Coded Values: [2025-26: 2025-26] , [2024-25: 2024-25] , [2023-24: 2023-24] , ...6 more... )
• fundsource ( type: esriFieldTypeString, alias: Funding Source, length: 50 , Coded Values: [General Fund: General Fund] , [Special Fund: Special Fund] , [Special Tax: Special Tax] , ...1 more... )
• planstart ( type: esriFieldTypeDate, alias: Planned Start Date, length: 8 )
• planend ( type: esriFieldTypeDate, alias: Planned End Date, length: 8 )
• estcost ( type: esriFieldTypeDouble, alias: Estimated Cost )
• pocname ( type: esriFieldTypeString, alias: Contact Name, length: 255 )
• pocphone ( type: esriFieldTypeString, alias: Contact Phone, length: 12 )
• pocemail ( type: esriFieldTypeString, alias: Contact Email, length: 255 )
• projstatus ( type: esriFieldTypeString, alias: Project Status, length: 50 , Coded Values: [Project Initiation: Project Initiation] , [Analysis and Review: Analysis and Review] , [Executive Approval: Executive Approval] , ...1 more... )
• funded ( type: esriFieldTypeString, alias: Funded Project, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• projphase ( type: esriFieldTypeString, alias: Project Phase, length: 255 , Coded Values: [PreDesign: PreDesign] , [Design: Design] , [Construction: Construction] , ...2 more... )
• actstart ( type: esriFieldTypeDate, alias: Actual Start Date, length: 8 )
• actend ( type: esriFieldTypeDate, alias: Actual End Date, length: 8 )
• actcost ( type: esriFieldTypeDouble, alias: Actual Cost )
• status ( type: esriFieldTypeString, alias: Status, length: 1000 )
• docpath ( type: esriFieldTypeString, alias: Document Path, length: 1000 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 50 )
• projectclass ( type: esriFieldTypeString, alias: Project Class, length: 50 , Coded Values: [Reoccurring: Reoccurring] , [One-Time: One-Time] )
• ccdesignappdate ( type: esriFieldTypeDate, alias: City Council Design Approval Date, length: 8 )
• ccawarddate ( type: esriFieldTypeDate, alias: City Council Award Date, length: 8 )
• noticecompleteappdate ( type: esriFieldTypeDate, alias: Notice of Completion Approval Date, length: 8 )
• SpecPublicAnnouce ( type: esriFieldTypeString, alias: Special Public Announcements, length: 500 )
• NumofChangeOrders ( type: esriFieldTypeDouble, alias: # of Change Orders )
• TotalAmountChangeOrders ( type: esriFieldTypeDouble, alias: Total Amount of Change Orders )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• 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 )

Relationships:

• GIS.Project_Comments (0) -- Related To: Project Comments (1)

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

  Iteminfo   Thumbnail   Metadata