Name: FY_20_21_Concrete_units_and_costs

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• WorkOrderId (type: esriFieldTypeInteger, alias: WorkOrderId, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Entity_Type (type: esriFieldTypeString, alias: Entity Type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Priority (type: esriFieldTypeInteger, alias: Priority, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Submit_To (type: esriFieldTypeString, alias: Submit To, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Proj_Start_Date (type: esriFieldTypeDate, alias: Proj Start Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Proj_Finish_Date (type: esriFieldTypeDate, alias: Proj Finish Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Actual_Start (type: esriFieldTypeDate, alias: Actual Start, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Actual_Finish (type: esriFieldTypeDate, alias: Actual Finish, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Shop (type: esriFieldTypeString, alias: Shop, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Map_Page (type: esriFieldTypeString, alias: Map Page, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Tile_No (type: esriFieldTypeString, alias: Tile No, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Entity_Group (type: esriFieldTypeString, alias: Entity Group, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Initiated_By (type: esriFieldTypeString, alias: Initiated By, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Date_Initiated (type: esriFieldTypeDate, alias: Date Initiated, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Date_Submit_To (type: esriFieldTypeDate, alias: Date Submit To, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Completed_By (type: esriFieldTypeString, alias: Completed By, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Supervisor (type: esriFieldTypeString, alias: Supervisor, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Update_Map (type: esriFieldTypeString, alias: Update Map, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Legal_Billable (type: esriFieldTypeString, alias: Legal Billable, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Contractor_Billable (type: esriFieldTypeString, alias: Contractor Billable, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Project (type: esriFieldTypeString, alias: Project, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Account (type: esriFieldTypeInteger, alias: Account, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Expense_Type (type: esriFieldTypeString, alias: Expense Type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Stage (type: esriFieldTypeString, alias: Stage, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Submit_To_Opened_By (type: esriFieldTypeString, alias: Submit To Opened By, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Requested_By (type: esriFieldTypeString, alias: Requested By, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Canceled (type: esriFieldTypeString, alias: Canceled, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Canceled_By (type: esriFieldTypeString, alias: Canceled By, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Cancel_Reason (type: esriFieldTypeString, alias: Cancel Reason, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Date_Canceled (type: esriFieldTypeString, alias: Date Canceled, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Closed_By (type: esriFieldTypeString, alias: Closed By, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Closed_Date (type: esriFieldTypeDate, alias: Closed Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Date_Submit_To_Open (type: esriFieldTypeDate, alias: Date Submit To Open, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Cycle_Interval_Number (type: esriFieldTypeInteger, alias: Cycle Interval Number, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Cycle_From (type: esriFieldTypeString, alias: Cycle From, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Cycle_Type (type: esriFieldTypeString, alias: Cycle Type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Cycle_Interval_Unit (type: esriFieldTypeString, alias: Cycle Interval Unit, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Total_Cost (type: esriFieldTypeDouble, alias: Total Cost, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Labor_Cost (type: esriFieldTypeDouble, alias: Labor Cost, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Material_Cost (type: esriFieldTypeDouble, alias: Material Cost, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Equipment_Cost (type: esriFieldTypeDouble, alias: Equipment Cost, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Permit_Cost (type: esriFieldTypeDouble, alias: Permit Cost, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Parent_WOID (type: esriFieldTypeString, alias: Parent WOID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Instructions (type: esriFieldTypeString, alias: Instructions, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Inspection (type: esriFieldTypeString, alias: Inspection, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Unattached (type: esriFieldTypeString, alias: Unattached, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Contract_Work_Order_Id (type: esriFieldTypeString, alias: Contract Work Order Id, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Street_Name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Units_Accomplished (type: esriFieldTypeDouble, alias: Units Accomplished, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Units_Accomp__Description (type: esriFieldTypeString, alias: Units Accomp. Description, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Request_Ids (type: esriFieldTypeString, alias: Request Ids, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Custom_Category_Id (type: esriFieldTypeInteger, alias: Custom Category Id, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Resolution (type: esriFieldTypeString, alias: Resolution, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Domain (type: esriFieldTypeInteger, alias: Domain, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Is_Reactive (type: esriFieldTypeString, alias: Is Reactive, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Printed_On (type: esriFieldTypeString, alias: Printed On, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Contract_Id (type: esriFieldTypeString, alias: Contract Id, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Contractor (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Total_Assets (type: esriFieldTypeString, alias: Total Assets, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Next_Print_Date (type: esriFieldTypeDate, alias: Next Print Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Init__Hour (type: esriFieldTypeInteger, alias: Init. Hour, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Init__Day_of_Week (type: esriFieldTypeString, alias: Init. Day of Week, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Init__Day_of_Month (type: esriFieldTypeInteger, alias: Init. Day of Month, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Init__Month (type: esriFieldTypeInteger, alias: Init. Month, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Init__Year (type: esriFieldTypeInteger, alias: Init. Year, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Init__App (type: esriFieldTypeString, alias: Init. App, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SR_Problem_Code (type: esriFieldTypeString, alias: SR Problem Code, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SR_Description (type: esriFieldTypeString, alias: SR Description, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SR_Initiated_By (type: esriFieldTypeString, alias: SR Initiated By, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SR_Date_Initiated (type: esriFieldTypeString, alias: SR Date Initiated, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SR_Submit_To (type: esriFieldTypeString, alias: SR Submit To, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SR_Date_Submit (type: esriFieldTypeString, alias: SR Date Submit, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SR_Closed_By (type: esriFieldTypeString, alias: SR Closed By, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SR_Date_Closed (type: esriFieldTypeString, alias: SR Date Closed, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SR_Priority (type: esriFieldTypeString, alias: SR Priority, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SR_Status (type: esriFieldTypeString, alias: SR Status, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SR_Address (type: esriFieldTypeString, alias: SR Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Cost_Summary_Total_Hours (type: esriFieldTypeDouble, alias: Cost Summary Total Hours, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Cost_Summary_Labor_Costs (type: esriFieldTypeDouble, alias: Cost Summary Labor Costs, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Cost_Summary_Material_Costs (type: esriFieldTypeDouble, alias: Cost Summary Material Costs, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Cost_Summary_Equipment_Costs (type: esriFieldTypeDouble, alias: Cost Summary Equipment Costs, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• LF_CURB___GUTTER (type: esriFieldTypeInteger, alias: LF CURB & GUTTER, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• LF_SIDEWALK (type: esriFieldTypeInteger, alias: LF SIDEWALK, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• NUMBER_OF_BFR (type: esriFieldTypeInteger, alias: NUMBER OF BFR, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SQFT_STREET (type: esriFieldTypeInteger, alias: SQFT STREET, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SQFT_SIDEWALK (type: esriFieldTypeInteger, alias: SQFT SIDEWALK, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SQFT_MEDIAN_REPAIR (type: esriFieldTypeInteger, alias: SQFT MEDIAN REPAIR, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• CUBIC_YDS_CONCRETE (type: esriFieldTypeString, alias: CUBIC YDS CONCRETE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• SQFT_STAMP (type: esriFieldTypeInteger, alias: SQFT STAMP, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SQFT_DRIVEWAYS (type: esriFieldTypeInteger, alias: SQFT DRIVEWAYS, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• Cost_C_G (type: esriFieldTypeDouble, alias: C&G Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BFR_Cost (type: esriFieldTypeDouble, alias: BFR's Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFT_Street_cost (type: esriFieldTypeDouble, alias: SQFT Street Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Median_cost (type: esriFieldTypeDouble, alias: Median Costs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SqFT_stamp_cost (type: esriFieldTypeDouble, alias: SqFt Stamp Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFT_Driveways_cost (type: esriFieldTypeDouble, alias: Driveway Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CbYd_concrete_cost (type: esriFieldTypeDouble, alias: CbYd Concrete cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sqft_Sidewalk_Cost (type: esriFieldTypeDouble, alias: Sidewalk Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/19/2021 6:54:48 PM

Schema Last Edit Date: 3/19/2021 6:54:48 PM

Data Last Edit Date: 3/19/2021 6:54:48 PM

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