{ "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "syncEnabled": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "work_completed_equipment_repeat_start", "relatedTableId": 1, "id": "2", "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "equipment_repeat_start", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_equip_class", "type": "codedValue", "codedValues": [ { "code": "12 Pressure Washer", "name": "12 Pressure Washer" }, { "code": "Arrow Board Trailer, Wanco", "name": "Arrow Board Trailer, Wanco" }, { "code": "Message Board Trailer, Wanco", "name": "Message Board Trailer, Wanco" }, { "code": "Concrete and asphalt cutter walk behind Stihl (Charged by the foot)", "name": "Concrete and asphalt cutter walk behind Stihl (Charged by the foot)" }, { "code": "181 Hydro Cleaner Truck", "name": "181 Hydro Cleaner Truck" }, { "code": "47 Hot patch Truck International", "name": "47 Hot patch Truck International" }, { "code": "71 Backhoe", "name": "71 Backhoe" }, { "code": "Kohler Hot Tapping Machine 1 inch", "name": "Kohler Hot Tapping Machine 1 inch" }, { "code": "63 Vac-Con, International", "name": "63 Vac-Con, International" }, { "code": "81 Vac-Con, Peterbilt", "name": "81 Vac-Con, Peterbilt" }, { "code": "70 Peterbilt Utility service Truck", "name": "70 Peterbilt Utility service Truck" }, { "code": "61 Vac-on International", "name": "61 Vac-on International" }, { "code": "Kohler Hot Tapping Machine 2 inch", "name": "Kohler Hot Tapping Machine 2 inch" }, { "code": "Kohler Hot Tapping Machine 6 inch and up", "name": "Kohler Hot Tapping Machine 6 inch and up" }, { "code": "Generator Small 1000Watt Honda", "name": "Generator Small 1000Watt Honda" }, { "code": "Generator Small 1700 Watt Generac", "name": "Generator Small 1700 Watt Generac" }, { "code": "Chainsaws/Stihl", "name": "Chainsaws/Stihl" }, { "code": "Blowers/Stihl", "name": "Blowers/Stihl" }, { "code": "String Trimmers/Stihl", "name": "String Trimmers/Stihl" }, { "code": "Pole Saw/Stihl", "name": "Pole Saw/Stihl" }, { "code": "Hedge Trimmer/Stihl", "name": "Hedge Trimmer/Stihl" }, { "code": "Asphalt Cutter, Walk behind/Stihl", "name": "Asphalt Cutter, Walk behind/Stihl" }, { "code": "4015 Vibraplate, Wacker Meuson", "name": "4015 Vibraplate, Wacker Meuson" }, { "code": "Jumping Jack/Compactor, Mikasa", "name": "Jumping Jack/Compactor, Mikasa" }, { "code": "Viber plate Wacker", "name": "Viber plate Wacker" }, { "code": "Generator Small 4200 Watt Generac", "name": "Generator Small 4200 Watt Generac" }, { "code": "Generator Small 3000 Watt Honda", "name": "Generator Small 3000 Watt Honda" }, { "code": "Generator Small 5000 Watt Honda, In 171 Service Van", "name": "Generator Small 5000 Watt Honda, In 171 Service Van" }, { "code": "Generator Small 7000 Watt Honda, on 118 CCTV Trailer", "name": "Generator Small 7000 Watt Honda, on 118 CCTV Trailer" }, { "code": "5219 Honda 3000 Generator", "name": "5219 Honda 3000 Generator" }, { "code": "5220 Honda 3000 Generator", "name": "5220 Honda 3000 Generator" }, { "code": "118 CCTV Trailer/Cues", "name": "118 CCTV Trailer/Cues" }, { "code": "182 Sewer Rodder, Screco", "name": "182 Sewer Rodder, Screco" }, { "code": "132 Flat Bed Trailer 14ft.", "name": "132 Flat Bed Trailer 14ft." }, { "code": "128 Flat Bed Trailer 12ft.", "name": "128 Flat Bed Trailer 12ft." }, { "code": "178 Flat Bed Trailer 22ft.", "name": "178 Flat Bed Trailer 22ft." }, { "code": "5121 Wacker 2\" Pump", "name": "5121 Wacker 2\" Pump" }, { "code": "5225 Honda 2\" pump", "name": "5225 Honda 2\" pump" }, { "code": "4044 Small Water Pump 425GPM, 3\"/Wacker", "name": "4044 Small Water Pump 425GPM, 3\"/Wacker" }, { "code": "5221 Water Pump 425 GPM, 3\"/Wacker", "name": "5221 Water Pump 425 GPM, 3\"/Wacker" }, { "code": "4044 Wacker 3\" pump", "name": "4044 Wacker 3\" pump" }, { "code": "5133 Wacker 3\" Pump", "name": "5133 Wacker 3\" Pump" }, { "code": "5221 Wacker 3\" Pump", "name": "5221 Wacker 3\" Pump" }, { "code": "5119 Asphalt Cutter, Blue Walk-Behind/Pro-Cut", "name": "5119 Asphalt Cutter, Blue Walk-Behind/Pro-Cut" }, { "code": "169 Asphalt Cutter, Yellow Walk-Behind/Stow", "name": "169 Asphalt Cutter, Yellow Walk-Behind/Stow" }, { "code": "1 Roller/Compactor", "name": "1 Roller/Compactor" }, { "code": "Mikasa Compactor Machine", "name": "Mikasa Compactor Machine" }, { "code": "6106 Generator Large 45Kv/Whisperwatt 36KW", "name": "6106 Generator Large 45Kv/Whisperwatt 36KW" }, { "code": "6107 Generator Large 45Kv/Whisperwatt 36KW", "name": "6107 Generator Large 45Kv/Whisperwatt 36KW" }, { "code": "6110 Generator Large 45Kv/Whisperwatt 36KW", "name": "6110 Generator Large 45Kv/Whisperwatt 36KW" }, { "code": "6115 Generator Large 45Kv/Whisperwatt 36KW", "name": "6115 Generator Large 45Kv/Whisperwatt 36KW" }, { "code": "11 Portable Air Compressor, Sullair", "name": "11 Portable Air Compressor, Sullair" }, { "code": "113 Shoring Trailer/Shoring (Daily Rate)", "name": "113 Shoring Trailer/Shoring (Daily Rate)" }, { "code": "6113 Generator Large 70Kv/Whisperwatt 56KW", "name": "6113 Generator Large 70Kv/Whisperwatt 56KW" }, { "code": "6112 Generator Large 125Kv/Whisperwatt 100KW", "name": "6112 Generator Large 125Kv/Whisperwatt 100KW" }, { "code": "23 Service Truck, Supervisor, Dan Vit", "name": "23 Service Truck, Supervisor, Dan Vit" }, { "code": "206 Service Truck, Supervisor, Will Matcham", "name": "206 Service Truck, Supervisor, Will Matcham" }, { "code": "200 Service Truck", "name": "200 Service Truck" }, { "code": "36 Service Truck", "name": "36 Service Truck" }, { "code": "73 John Deere Gator for gate valve turning", "name": "73 John Deere Gator for gate valve turning" }, { "code": "75 Meter read van", "name": "75 Meter read van" }, { "code": "Trash Pumps Small Electric, Tsurum 53-100GPM", "name": "Trash Pumps Small Electric, Tsurum 53-100GPM" }, { "code": "6111 Trash Pump Large, Gorman-Rupp 4\"", "name": "6111 Trash Pump Large, Gorman-Rupp 4\"" }, { "code": "5227 Trash Pump Large Gorman-Rupp 6\"", "name": "5227 Trash Pump Large Gorman-Rupp 6\"" }, { "code": "6116 Pump Large Gorman-Rupp 6\"", "name": "6116 Pump Large Gorman-Rupp 6\"" }, { "code": "55 Flail Mower, John Deere", "name": "55 Flail Mower, John Deere" }, { "code": "188 Skid Steer/Case", "name": "188 Skid Steer/Case" }, { "code": "86 F-350 Service Truck", "name": "86 F-350 Service Truck" }, { "code": "57 F-350 Service Truck/Sign Truck", "name": "57 F-350 Service Truck/Sign Truck" }, { "code": "171 F-550 Service Truck", "name": "171 F-550 Service Truck" }, { "code": "157 F-350 Service Truck/Boom Truck for Pump Maintenance", "name": "157 F-350 Service Truck/Boom Truck for Pump Maintenance" }, { "code": "184 Chevy Boom Truck", "name": "184 Chevy Boom Truck" }, { "code": "78 Ford F 350 Service Truck", "name": "78 Ford F 350 Service Truck" }, { "code": "76 Ford F 350 Service Truck", "name": "76 Ford F 350 Service Truck" }, { "code": "75 International, Truck Bobtail Flat Bed", "name": "75 International, Truck Bobtail Flat Bed" }, { "code": "196 Backhoe/Caterpillar 420-D", "name": "196 Backhoe/Caterpillar 420-D" }, { "code": "74 Backhoe CAT 420-D", "name": "74 Backhoe CAT 420-D" }, { "code": "Bull Prick", "name": "Bull Prick" }, { "code": "105 F-550 Dump Truck, 3 Yard", "name": "105 F-550 Dump Truck, 3 Yard" }, { "code": "175 F-700 dump Truck, 5 Yard", "name": "175 F-700 dump Truck, 5 Yard" }, { "code": "104 F-650 dump Truck, 5 Yard", "name": "104 F-650 dump Truck, 5 Yard" }, { "code": "103 Ford F 650 Dump Truck 5Y", "name": "103 Ford F 650 Dump Truck 5Y" }, { "code": "116 Loader/John Deere 544G", "name": "116 Loader/John Deere 544G" }, { "code": "116 Loader/ John Deere 544G", "name": "116 Loader/ John Deere 544G" }, { "code": "176 International Dump Truck, 10 Yard", "name": "176 International Dump Truck, 10 Yard" }, { "code": "108 Peterbilt Dump Truck, 12 Yard", "name": "108 Peterbilt Dump Truck, 12 Yard" }, { "code": "51 Ford F 350 Service Truck", "name": "51 Ford F 350 Service Truck" }, { "code": "219 Ford F 350 Service Truck/Sign Truck", "name": "219 Ford F 350 Service Truck/Sign Truck" }, { "code": "218 Ford F 350 Service Truck", "name": "218 Ford F 350 Service Truck" }, { "code": "210 Ford F 150 Supervisor Truck", "name": "210 Ford F 150 Supervisor Truck" }, { "code": "Other", "name": "Other" } ] }, "name": "equip_class", "length": 255, "alias": "Equipment Class", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equip_code", "length": 255, "alias": "Equipment Code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "eqip_other", "length": 255, "alias": "Describe Other Equipment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equip_class_calc", "length": 255, "alias": "equip_class_calc", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equip_time_cat", "length": 255, "alias": "Equipment Time Used", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_cost_regular", "length": 255, "alias": "Equipment Cost Regular", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_cost_ot", "length": 255, "alias": "Equipment Cost OT", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_cost_idle", "length": 255, "alias": "Equipment Cost Idle", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_hours_regular", "alias": "Equipment Hours Regular", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_hours_ot", "alias": "Equipment Hours OT", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_hours_idle", "alias": "Equipment Hours Idle", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calcequipment_hours_regular", "length": 255, "alias": "calcequipment_hours_regular", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calcequipment_hours_ot", "length": 255, "alias": "calcequipment_hours_ot", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calcequipment_hours_idle", "length": 255, "alias": "calcequipment_hours_idle", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calcequipment_cost_regular", "length": 255, "alias": "calcequipment_cost_regular", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calcequipment_cost_ot", "length": 255, "alias": "calcequipment_cost_ot", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calcequipment_cost_idle", "length": 255, "alias": "calcequipment_cost_idle", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_cost_total", "alias": "Total Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_note", "length": 255, "alias": "Equipment Notes", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_crew_e", "length": 255, "alias": "work_crew_e", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_type_e", "length": 255, "alias": "work_type_e", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "r1068_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAcsending": true }, { "name": "uuid_1068", "isUnique": true, "description": "", "fields": "globalid", "isAcsending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads,Query,Update,Delete,Sync", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "serviceItemId": "463f82d7c5134b9e97398b3fb52588d3" }