Name: CIRB Project Status

Display Field: T_VENDOR_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 4000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 171515.7456
YMin: 48033.2459999993
XMax: 925641.406499997
YMax: 408210.608899999
Spatial Reference: PROJCS["Lambert_Conformal_Conic_2SP",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["false_easting",600000.0],PARAMETER["false_northing",0.0],PARAMETER["central_meridian",-98.0],PARAMETER["standard_parallel_1",34.125],PARAMETER["standard_parallel_2",36.5],PARAMETER["scale_factor",1.0],PARAMETER["latitude_of_origin",33.3333333333333],UNIT["Meter",1.0]]

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"CALC_STATUS","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[197,0,255,255],"width":4},"value":"1","label":"90 Day Bid List","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,170,0,255],"width":4},"value":"2","label":"Awarded - NTP Not Processed","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,169,230,255],"width":4},"value":"3","label":"Project Under Construction","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[112,168,0,255],"width":4},"value":"4","label":"Project Completed - Final Est. Not Processed","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":4},"value":"5","label":"To Comptroller for Closeout","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,0,255],"width":4},"value":"0","label":"Comptroller Tied Info","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: CALC_STATUS

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• T_JOB_PIECE (type: esriFieldTypeString, alias: JP No., SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• D_DATE_LAST_UPDATED (type: esriFieldTypeDate, alias: Date Last Updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• T_PROJECT (type: esriFieldTypeString, alias: Project No., SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• JP_DESCRIPTION (type: esriFieldTypeString, alias: JP Desc., SQL Type: sqlTypeOther, length: 151, nullable: true, editable: true)
• A_CONTRACT_AMOUNT (type: esriFieldTypeDouble, alias: Contract Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_AMOUNT_EARNED (type: esriFieldTypeDouble, alias: Amount Earned, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_AMOUNT_PAID (type: esriFieldTypeDouble, alias: Amount Paid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• N_DAYS_CHARGED (type: esriFieldTypeInteger, alias: Days Charged, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D_LET_DATE (type: esriFieldTypeDate, alias: Let Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• D_CONTRACT_DATE (type: esriFieldTypeDate, alias: Contract Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• D_CONTRACT_AWARD_DATE (type: esriFieldTypeDate, alias: Contract Award Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• D_WORK_ORDER_DATE (type: esriFieldTypeDate, alias: Work Order Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• D_WORK_ORDER_EFF_DATE (type: esriFieldTypeDate, alias: Work Order Eff. Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• D_WORK_START_DATE (type: esriFieldTypeDate, alias: Work Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• D_ESTIMATED_COMP_DATE (type: esriFieldTypeDate, alias: Est. Comp. Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• F_FINAL_PAYMENT_CODE (type: esriFieldTypeString, alias: Final Payment Code, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• T_HIGHWAY (type: esriFieldTypeString, alias: Highway, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• T_CONTRACT (type: esriFieldTypeString, alias: Contract, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• D_FINAL_EST_DATE (type: esriFieldTypeDate, alias: Final Est. Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• D_ACCEPTANCE_DATE (type: esriFieldTypeString, alias: Acceptance Date, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• N_CAL_DAYS_ALLOWED (type: esriFieldTypeInteger, alias: Cal. Days Allowed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• N_REVISED_DAYS (type: esriFieldTypeInteger, alias: Revised Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• T_CONTRACTOR (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• D_FINAL_TO_COMPTR (type: esriFieldTypeDate, alias: Final to Comptroller, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• T_CONSULTANT_1 (type: esriFieldTypeString, alias: Consultant, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• T_VENDOR_NAME (type: esriFieldTypeString, alias: Vendor Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• RESIDENCY_NAME (type: esriFieldTypeString, alias: Residency Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• A_CURRENT_CONTRACT_AMOUNT (type: esriFieldTypeDouble, alias: Current Contract Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY_NO (type: esriFieldTypeString, alias: County No., SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• LEAD_TIED (type: esriFieldTypeString, alias: Lead Tied, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LEAD_JP (type: esriFieldTypeString, alias: Lead JP, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• CALC_STATUS (type: esriFieldTypeString, alias: Status Code, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• USER_LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D_ACTUAL_COMP_DATE (type: esriFieldTypeDate, alias: Actual Comp. Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONSULT_NAME (type: esriFieldTypeString, alias: Constultant Name, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• COMM_DIST (type: esriFieldTypeString, alias: Comm. Dist., SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• T_FISCAL_YEAR (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• T_WORK (type: esriFieldTypeString, alias: Work, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• C_WORK_CODE (type: esriFieldTypeString, alias: Work Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• GB_DESCRIPTION (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• JP_PROJECT_TOTAL (type: esriFieldTypeDouble, alias: JP Project Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AMOUNT (type: esriFieldTypeDouble, alias: Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 1
Name: 1
Domains:

Templates:

Name: 1
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• CALC_STATUS: 1

---

ID: 2
Name: 2
Domains:

Templates:

Name: 2
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• CALC_STATUS: 2

---

ID: 3
Name: 3
Domains:

Templates:

Name: 3
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• CALC_STATUS: 3

---

ID: 4
Name: 4
Domains:

Templates:

Name: 4
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• CALC_STATUS: 4

---

ID: 5
Name: 5
Domains:

Templates:

Name: 5
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• CALC_STATUS: 5

---

ID: 0
Name: 0
Domains:

Templates:

Name: 0
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• CALC_STATUS: 0

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/6/2021 6:54:33 PM

Schema Last Edit Date: 4/6/2021 6:54:33 PM

Data Last Edit Date: 4/6/2021 6:54:33 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat