Name: CIP Tracker
Display Field: ProjectName
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.0823118384790061E7
YMin: 3840822.319411479
XMax: -1.0791883693230962E7
YMax: 3870835.2442251323
Spatial Reference: 102100
(3857)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: ProjectPhase
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol: Style: esriSFSDiagonalCross
Color: [0, 0, 0, 255]
Outline:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 0
Default Label: Project Phase Unknown
UniqueValueInfos:
-
Value: Bidding
Label: Bidding; Construction
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [202, 122, 245, 255]
Outline:
Style: esriSLSSolid
Color: [202, 122, 245, 255]
Width: 1
-
Value: Construction
Label: Bidding; Construction
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [202, 122, 245, 255]
Outline:
Style: esriSLSSolid
Color: [202, 122, 245, 255]
Width: 1
-
Value: Complete
Label: Complete; Warranty / Maintenance
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [78, 78, 78, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 0]
Width: 2
-
Value: Warranty / Maintenance
Label: Complete; Warranty / Maintenance
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [78, 78, 78, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 0]
Width: 2
-
Value: Design
Label: Design
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [230, 152, 0, 255]
Outline:
Style: esriSLSSolid
Color: [230, 152, 0, 255]
Width: 0
-
Value: Equipment / Services
Label: Equipment / Services
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [181, 53, 53, 255]
Outline:
Style: esriSLSSolid
Color: [168, 0, 0, 255]
Width: 0
-
Value: Planning
Label: Planning
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [115, 178, 255, 255]
Outline:
Style: esriSLSSolid
Color: [115, 178, 255, 255]
Width: 0
-
Value: Study / Evaluation
Label: Study / Evaluation
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [230, 230, 0, 255]
Outline:
Style: esriSLSSolid
Color: [230, 230, 0, 255]
Width: 0
Transparency: 30
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
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
ProjectName
(
type: esriFieldTypeString, alias: Project Name, length: 250
)
-
StreetName
(
type: esriFieldTypeString, alias: Street Name, length: 50
)
-
FromStreet
(
type: esriFieldTypeString, alias: From Street, length: 50
)
-
ToStreet
(
type: esriFieldTypeString, alias: To Street, length: 50
)
-
ProjectLocation
(
type: esriFieldTypeString, alias: Project Location (eBuilder), length: 1500
)
-
ProjectScope
(
type: esriFieldTypeString, alias: Project Scope, length: 1500
)
-
WaterProject
(
type: esriFieldTypeString, alias: Water Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
SewerProject
(
type: esriFieldTypeString, alias: Sewer Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
StreetProject
(
type: esriFieldTypeString, alias: Street Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
DrainageProject
(
type: esriFieldTypeString, alias: Drainage Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
SidewalkProject
(
type: esriFieldTypeString, alias: Sidewalk Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
TrafficProject
(
type: esriFieldTypeString, alias: Traffic Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
ParksProject
(
type: esriFieldTypeString, alias: Parks Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
BuildingProject
(
type: esriFieldTypeString, alias: Building Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
MillOverlayProject
(
type: esriFieldTypeString, alias: Mill Overlay Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
ReclamationProject
(
type: esriFieldTypeString, alias: Reclamation Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
MicrosealProject
(
type: esriFieldTypeString, alias: Microseal Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
HeaterRepaverProject
(
type: esriFieldTypeString, alias: Heater Repaver Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
PanelReplacementProject
(
type: esriFieldTypeString, alias: Panel Replacement Project, length: 1
, Coded Values:
[P: Primary Project]
, [I: Included Project]
)
-
ManagingDivision
(
type: esriFieldTypeString, alias: Managing Division, length: 4
, Coded Values:
[CMAM: Construction Management Asset Management]
, [PKPL: Parks and Recreation Planning]
, [PWDR: Public Works Drainage]
, ...8 more...
)
-
CityDepartment
(
type: esriFieldTypeString, alias: City Department, length: 2
, Coded Values:
[PW: Public Works]
, [WU: Water Utilities]
, [CM: Construction Management]
, ...1 more...
)
-
PrimaryProjectNumber
(
type: esriFieldTypeString, alias: Primary Project Number, length: 50
)
-
SecondaryProjectNumber
(
type: esriFieldTypeString, alias: Secondary Project Number, length: 25
)
-
PrimaryProjectManager
(
type: esriFieldTypeString, alias: PrimaryProjectManager, length: 100
)
-
PrimaryPMPhone
(
type: esriFieldTypeString, alias: Primary Project Manager's Phone Number, length: 15
)
-
PrimaryPMEmail
(
type: esriFieldTypeString, alias: Primary Project Manager's E-mail, length: 50
)
-
SecondaryProjectManager
(
type: esriFieldTypeString, alias: Secondary Project Manager, length: 100
)
-
CouncilDistrict
(
type: esriFieldTypeString, alias: Council District, length: 15
)
-
SubsCompleteMonth
(
type: esriFieldTypeString, alias: Substantially Complete Month, length: 3
, Coded Values:
[JAN: January]
, [FEB: February]
, [MAR: March]
, ...9 more...
)
-
SubsCompleteCalendarYear
(
type: esriFieldTypeSmallInteger, alias: Substantially Complete Calendar Year
, Coded Values:
[2008: 2008]
, [2009: 2009]
, [2010: 2010]
, ...40 more...
)
-
SubsCompleteFiscalQuarter
(
type: esriFieldTypeSmallInteger, alias: Substantially Complete Fiscal Quarter
, Coded Values:
[1: 1]
, [2: 2]
, [3: 3]
, ...1 more...
)
-
SubsCompleteFiscalYear
(
type: esriFieldTypeSmallInteger, alias: Substantially Complete Fiscal Year
, Coded Values:
[2008: 2008]
, [2009: 2009]
, [2010: 2010]
, ...40 more...
)
-
Inspector
(
type: esriFieldTypeString, alias: Inspector, length: 30
)
-
HikeBikePlan
(
type: esriFieldTypeString, alias: Hike/Bike Plan, length: 1
, Coded Values:
[Y: Yes]
, [N: No]
)
-
SquareYard
(
type: esriFieldTypeDouble, alias: Square Yard
)
-
LaneMile
(
type: esriFieldTypeDouble, alias: Lane Mile
)
-
Remarks
(
type: esriFieldTypeString, alias: Remarks, length: 255
)
-
CurrentActivity
(
type: esriFieldTypeString, alias: Current Activity, length: 3500
)
-
Contractor
(
type: esriFieldTypeString, alias: Contractor, length: 50
)
-
AnticipatedCompletionDate
(
type: esriFieldTypeDate, alias: Anticipated Completion Date, length: 8
)
-
LastUpdatedDate
(
type: esriFieldTypeDate, alias: Last Updated Date, length: 8
)
-
LastUpdatedByEBuilder
(
type: esriFieldTypeDate, alias: Last Updated by e-Builder, length: 8
)
-
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
)
-
SubsCompleteQtr
(
type: esriFieldTypeString, alias: Substantially Complete Quarter, length: 10
, Coded Values:
[FY13-4Q: FY13-4Q]
, [FY14-1Q: FY14-1Q]
, [FY14-2Q: FY14-2Q]
, ...66 more...
)
-
CIP_ID
(
type: esriFieldTypeString, alias: CIP ID, length: 8
)
-
Shape
(
type: esriFieldTypeGeometry, alias: SHAPE
)
-
EditedLastBy
(
type: esriFieldTypeString, alias: EditedLastBy, length: 50
)
-
LastEditedDate
(
type: esriFieldTypeDate, alias: LastEditedDate, length: 8
)
-
BondProgramYear
(
type: esriFieldTypeSmallInteger, alias: Bond Program Year
, Coded Values:
[2008: 2008]
, [2009: 2009]
, [2010: 2010]
, ...40 more...
)
-
BondProjectCategory
(
type: esriFieldTypeString, alias: Bond Project Category, length: 30
, Coded Values:
[Public Safety: Public Safety]
, [Parks & Recreation: Parks & Recreation]
, [Public Works/Streets: Public Works/Streets]
, ...2 more...
)
-
ProjectStatus
(
type: esriFieldTypeString, alias: Project Status, length: 50
)
-
ProjectPhase
(
type: esriFieldTypeString, alias: Project Phase, length: 50
)
-
Shape.STArea()
(
type: esriFieldTypeDouble, alias: Shape.STArea()
)
-
Shape.STLength()
(
type: esriFieldTypeDouble, alias: Shape.STLength()
)
-
ConstructionStartYear
(
type: esriFieldTypeSmallInteger, alias: Construction Start Year
, Coded Values:
[2008: 2008]
, [2009: 2009]
, [2010: 2010]
, ...40 more...
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata