Layers:

Layer: All CIP Projects (0)

Name: All CIP Projects

Display Field: PROJECTNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: d334952b2f744694adbd7cb62a92bb85

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 7586052.149278209
YMin: 601073.630905509
XMax: 7626691.213254586
YMax: 696891.0889107585
Spatial Reference: 2913  (2913)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [0, 0, 0, 0]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
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:
• SHAPE.STArea() ( type: esriFieldTypeDouble, alias: SHAPE.STArea() )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PROJECTNUM ( type: esriFieldTypeString, alias: PROJECTNUM, length: 10 )
• PROJECTNAME ( type: esriFieldTypeString, alias: PROJECTNAME, length: 100 )
• PROJCAT ( type: esriFieldTypeString, alias: PROJCAT, length: 20 , Coded Values: [CIV: Civic] , [SAN: Sanitary] , [STM: Storm] , ...2 more... )
• ACTIVE ( type: esriFieldTypeSmallInteger, alias: ACTIVE , Coded Values: [1: Yes] , [0: No] )
• LASTUPDATE ( type: esriFieldTypeDate, alias: LASTUPDATE, length: 8 )
• LASTEDITOR ( type: esriFieldTypeString, alias: LASTEDITOR, length: 50 )
• DATE_CREATED ( type: esriFieldTypeDate, alias: DATE_CREATED, length: 8 )
• CREATED_BY ( type: esriFieldTypeString, alias: CREATED_BY, length: 50 )
• Globalid ( type: esriFieldTypeGlobalID, alias: Globalid, length: 38 )
• NAC ( type: esriFieldTypeString, alias: NAC, length: 150 )
• ProjectStatusCode ( type: esriFieldTypeString, alias: ProjectStatusCode, length: 20 , Coded Values: [COMP: Completed] , [FUTR: Future] , [HOLD: On Hold] , ...5 more... )
• ProjectCIPYear ( type: esriFieldTypeString, alias: ProjectCIPYear, length: 20 )
• ProjectCIPYearNum ( type: esriFieldTypeSmallInteger, alias: ProjectCIPYearNum )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Tables:

Table: CapitalProjects.dbo.Projects (7)

Name: CapitalProjects.dbo.Projects

Display Field: ProjectName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: d334952b2f744694adbd7cb62a92bb85

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• ProjectID ( type: esriFieldTypeOID, alias: ProjectID )
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, length: 8 )
• ProjectName ( type: esriFieldTypeString, alias: ProjectName, length: 150 )
• ProjectConsultant ( type: esriFieldTypeString, alias: ProjectConsultant, length: 50 )
• ProjectContractor ( type: esriFieldTypeString, alias: ProjectContractor, length: 50 )
• ProjectStatusCode ( type: esriFieldTypeString, alias: ProjectStatusCode, length: 4 )
• ProjectTypes ( type: esriFieldTypeSmallInteger, alias: ProjectTypes )
• ProjectStatus ( type: esriFieldTypeString, alias: ProjectStatus, length: 1073741822 )
• ProjectDescription ( type: esriFieldTypeString, alias: ProjectDescription, length: 1073741822 )
• ProjectProblem ( type: esriFieldTypeString, alias: ProjectProblem, length: 1073741822 )
• ProjectJustification ( type: esriFieldTypeString, alias: ProjectJustification, length: 1073741822 )
• ProjectScope ( type: esriFieldTypeString, alias: ProjectScope, length: 1073741822 )
• ProjectRemarks ( type: esriFieldTypeString, alias: ProjectRemarks, length: 1073741822 )
• ProjectMap ( type: esriFieldTypeString, alias: ProjectMap, length: 1073741822 )
• ProjectCIPYear ( type: esriFieldTypeString, alias: ProjectCIPYear, length: 12 )
• ProjectFund ( type: esriFieldTypeString, alias: ProjectFund, length: 8 )
• ProjectNew ( type: esriFieldTypeSmallInteger, alias: ProjectNew )
• ProjectAsOfDate ( type: esriFieldTypeDate, alias: ProjectAsOfDate, length: 8 )
• ProjectStartDate ( type: esriFieldTypeDate, alias: ProjectStartDate, length: 8 )
• PWApproved ( type: esriFieldTypeSmallInteger, alias: PWApproved )
• PWApprovedBy ( type: esriFieldTypeString, alias: PWApprovedBy, length: 50 )
• PWApprovedTs ( type: esriFieldTypeDate, alias: PWApprovedTs, length: 8 )
• FinApproved ( type: esriFieldTypeSmallInteger, alias: FinApproved )
• FinApprovedBy ( type: esriFieldTypeString, alias: FinApprovedBy, length: 50 )
• FinApprovedTs ( type: esriFieldTypeDate, alias: FinApprovedTs, length: 8 )
• ProjectSubstantialDate ( type: esriFieldTypeDate, alias: ProjectSubstantialDate, length: 8 )
• ProjectCompletionDate ( type: esriFieldTypeDate, alias: ProjectCompletionDate, length: 8 )
• ProjectCompletionTBD ( type: esriFieldTypeSmallInteger, alias: ProjectCompletionTBD )
• ProjectDurationDays ( type: esriFieldTypeSmallInteger, alias: ProjectDurationDays )
• ProjectAuthorizedCost ( type: esriFieldTypeDouble, alias: ProjectAuthorizedCost )
• ProjectEstimatedCost ( type: esriFieldTypeDouble, alias: ProjectEstimatedCost )
• ProjectActualCost ( type: esriFieldTypeDouble, alias: ProjectActualCost )
• ProjectCategory ( type: esriFieldTypeString, alias: ProjectCategory, length: 20 )
• ProjectWebFlag ( type: esriFieldTypeSmallInteger, alias: ProjectWebFlag )
• ProjectAllowFundingUpdates ( type: esriFieldTypeSmallInteger, alias: ProjectAllowFundingUpdates )
• ProjectFundingArtOrdinance ( type: esriFieldTypeSmallInteger, alias: ProjectFundingArtOrdinance )
• ProjectFundingMSTIP ( type: esriFieldTypeSmallInteger, alias: ProjectFundingMSTIP )
• ProjectStatusDashboard ( type: esriFieldTypeString, alias: ProjectStatusDashboard, length: 10 )
• ProjectStatusCADD ( type: esriFieldTypeString, alias: ProjectStatusCADD, length: 50 )
• ProjectStatusSurvey ( type: esriFieldTypeString, alias: ProjectStatusSurvey, length: 50 )
• ProjectStatusConstruction ( type: esriFieldTypeString, alias: ProjectStatusConstruction, length: 50 )
• ProjectComments ( type: esriFieldTypeString, alias: ProjectComments, length: 2147483647 )