Name: Civic Projects

Display Field: sdeProd.GIS.cob_CIP.PROJECTNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 7219b3fffe1e4dda8704380513bc2a26

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: false

Supports Statistics: false

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 7584528.391404197
YMin: 601073.630905509
XMax: 7626691.213254586
YMax: 697060.5626640469
Spatial Reference: 2913  (2913)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [76, 230, 0, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label:
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: false
Supports OrderBy: false
Supports Distinct: false
Supports Pagination: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• sdeProd.GIS.cob_CIP.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• sdeProd.GIS.cob_CIP.PROJECTNUM ( type: esriFieldTypeString, alias: PROJECTNUM, length: 10 )
• sdeProd.GIS.cob_CIP.PROJECTNAME ( type: esriFieldTypeString, alias: PROJECTNAME, length: 100 )
• sdeProd.GIS.cob_CIP.PROJCAT ( type: esriFieldTypeString, alias: PROJCAT, length: 20 , Coded Values: [CIV: Civic] , [SAN: Sanitary] , [STM: Storm] , ...2 more... )
• sdeProd.GIS.cob_CIP.ACTIVE ( type: esriFieldTypeSmallInteger, alias: ACTIVE , Coded Values: [1: Yes] , [0: No] )
• sdeProd.GIS.cob_CIP.LASTUPDATE ( type: esriFieldTypeDate, alias: LASTUPDATE, length: 8 )
• sdeProd.GIS.cob_CIP.LASTEDITOR ( type: esriFieldTypeString, alias: LASTEDITOR, length: 50 )
• sdeProd.GIS.cob_CIP.DATE_CREATED ( type: esriFieldTypeDate, alias: DATE_CREATED, length: 8 )
• sdeProd.GIS.cob_CIP.CREATED_BY ( type: esriFieldTypeString, alias: CREATED_BY, length: 50 )
• sdeProd.GIS.cob_CIP.Globalid ( type: esriFieldTypeGlobalID, alias: Globalid, length: 38 )
• sdeProd.GIS.cob_CIP.NAC ( type: esriFieldTypeString, alias: NAC, length: 150 )
• sdeProd.GIS.cob_CIP.ProjectStatusCode ( type: esriFieldTypeString, alias: ProjectStatusCode, length: 20 , Coded Values: [COMP: Completed] , [FUTR: Future] , [HOLD: On Hold] , ...5 more... )
• sdeProd.GIS.cob_CIP.ProjectCIPYear ( type: esriFieldTypeString, alias: ProjectCIPYear, length: 20 )
• sdeProd.GIS.cob_CIP.ProjectCIPYearNum ( type: esriFieldTypeSmallInteger, alias: ProjectCIPYearNum )
• sdeProd.GIS.cob_CIP.SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHAPE.STArea() ( type: esriFieldTypeDouble, alias: SHAPE.STArea() )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• CapitalProjects.dbo.Projects.ProjectID ( type: esriFieldTypeInteger, alias: ProjectID )
• CapitalProjects.dbo.Projects.ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, length: 8 )
• CapitalProjects.dbo.Projects.ProjectName ( type: esriFieldTypeString, alias: ProjectName, length: 150 )
• CapitalProjects.dbo.Projects.ProjectConsultant ( type: esriFieldTypeString, alias: ProjectConsultant, length: 50 )
• CapitalProjects.dbo.Projects.ProjectContractor ( type: esriFieldTypeString, alias: ProjectContractor, length: 50 )
• CapitalProjects.dbo.Projects.ProjectStatusCode ( type: esriFieldTypeString, alias: ProjectStatusCode, length: 4 )
• CapitalProjects.dbo.Projects.ProjectTypes ( type: esriFieldTypeSmallInteger, alias: ProjectTypes )
• CapitalProjects.dbo.Projects.ProjectStatus ( type: esriFieldTypeString, alias: ProjectStatus, length: 2147483647 )
• CapitalProjects.dbo.Projects.ProjectDescription ( type: esriFieldTypeString, alias: ProjectDescription, length: 2147483647 )
• CapitalProjects.dbo.Projects.ProjectProblem ( type: esriFieldTypeString, alias: ProjectProblem, length: 2147483647 )
• CapitalProjects.dbo.Projects.ProjectJustification ( type: esriFieldTypeString, alias: ProjectJustification, length: 2147483647 )
• CapitalProjects.dbo.Projects.ProjectScope ( type: esriFieldTypeString, alias: ProjectScope, length: 2147483647 )
• CapitalProjects.dbo.Projects.ProjectRemarks ( type: esriFieldTypeString, alias: ProjectRemarks, length: 2147483647 )
• CapitalProjects.dbo.Projects.ProjectMap ( type: esriFieldTypeString, alias: ProjectMap, length: 2147483647 )
• CapitalProjects.dbo.Projects.ProjectCIPYear ( type: esriFieldTypeString, alias: ProjectCIPYear, length: 12 )
• CapitalProjects.dbo.Projects.ProjectFund ( type: esriFieldTypeString, alias: ProjectFund, length: 8 )
• CapitalProjects.dbo.Projects.ProjectNew ( type: esriFieldTypeSmallInteger, alias: ProjectNew )
• CapitalProjects.dbo.Projects.ProjectAsOfDate ( type: esriFieldTypeDate, alias: ProjectAsOfDate, length: 8 )
• CapitalProjects.dbo.Projects.ProjectStartDate ( type: esriFieldTypeDate, alias: ProjectStartDate, length: 8 )
• CapitalProjects.dbo.Projects.PWApproved ( type: esriFieldTypeSmallInteger, alias: PWApproved )
• CapitalProjects.dbo.Projects.PWApprovedBy ( type: esriFieldTypeString, alias: PWApprovedBy, length: 50 )
• CapitalProjects.dbo.Projects.PWApprovedTs ( type: esriFieldTypeDate, alias: PWApprovedTs, length: 8 )
• CapitalProjects.dbo.Projects.FinApproved ( type: esriFieldTypeSmallInteger, alias: FinApproved )
• CapitalProjects.dbo.Projects.FinApprovedBy ( type: esriFieldTypeString, alias: FinApprovedBy, length: 50 )
• CapitalProjects.dbo.Projects.FinApprovedTs ( type: esriFieldTypeDate, alias: FinApprovedTs, length: 8 )
• CapitalProjects.dbo.Projects.ProjectSubstantialDate ( type: esriFieldTypeDate, alias: ProjectSubstantialDate, length: 8 )
• CapitalProjects.dbo.Projects.ProjectCompletionDate ( type: esriFieldTypeDate, alias: ProjectCompletionDate, length: 8 )
• CapitalProjects.dbo.Projects.ProjectCompletionTBD ( type: esriFieldTypeSmallInteger, alias: ProjectCompletionTBD )
• CapitalProjects.dbo.Projects.ProjectDurationDays ( type: esriFieldTypeSmallInteger, alias: ProjectDurationDays )
• CapitalProjects.dbo.Projects.ProjectAuthorizedCost ( type: esriFieldTypeDouble, alias: ProjectAuthorizedCost )
• CapitalProjects.dbo.Projects.ProjectEstimatedCost ( type: esriFieldTypeDouble, alias: ProjectEstimatedCost )
• CapitalProjects.dbo.Projects.ProjectActualCost ( type: esriFieldTypeDouble, alias: ProjectActualCost )
• CapitalProjects.dbo.Projects.ProjectCategory ( type: esriFieldTypeString, alias: ProjectCategory, length: 20 )
• CapitalProjects.dbo.Projects.ProjectWebFlag ( type: esriFieldTypeSmallInteger, alias: ProjectWebFlag )
• CapitalProjects.dbo.Projects.ProjectAllowFundingUpdates ( type: esriFieldTypeSmallInteger, alias: ProjectAllowFundingUpdates )
• CapitalProjects.dbo.Projects.ProjectFundingArtOrdinance ( type: esriFieldTypeSmallInteger, alias: ProjectFundingArtOrdinance )
• CapitalProjects.dbo.Projects.ProjectFundingMSTIP ( type: esriFieldTypeSmallInteger, alias: ProjectFundingMSTIP )
• CapitalProjects.dbo.Projects.ProjectStatusDashboard ( type: esriFieldTypeString, alias: ProjectStatusDashboard, length: 10 )
• CapitalProjects.dbo.Projects.ProjectStatusCADD ( type: esriFieldTypeString, alias: ProjectStatusCADD, length: 50 )
• CapitalProjects.dbo.Projects.ProjectStatusSurvey ( type: esriFieldTypeString, alias: ProjectStatusSurvey, length: 50 )
• CapitalProjects.dbo.Projects.ProjectStatusConstruction ( type: esriFieldTypeString, alias: ProjectStatusConstruction, length: 50 )
• CapitalProjects.dbo.Projects.ProjectComments ( type: esriFieldTypeString, alias: ProjectComments, length: 2147483647 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata