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:
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
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata